ASP Classic - URL QueryString with Comma, how to pass through to page?

I am using a URL Rewrite, and have opted to use the title of the articles, as the URL.
Since the design of the site, of which was done back in 2014, I prepared the title to be used in this way.

NOW, the issue is this.
some of the articles have commas in the title.
So, the URL looks something like this.

/KISS_Concert_(Jan_10,_1985)

With a comma after the 10.

How can I pass this to my Query?
As of right now, it breaks at the comma.
So, it only sends to the page.

/KISS_Concert_(Jan_10

I have searched and have come up with nothing.
The only thing I can find is using:

%2C
/KISS_Concert_(Jan_10%2C_1985)

However, it still cuts off after the 10 in the name.

The only other option is to create a new column in the table, for the URL, and have it without a comma.
And leave the title as is, with the comma.
However, if there is a way, of which, there should be.
Heck, Microsoft has commas in their URLs, so we should be able to accomplish the same thing as well.
LVL 31
Wayne BarronAuthor, Web DeveloperAsked:
Who is Participating?
 
Scott Fell, EE MVEConnect With a Mentor Developer & EE ModeratorCommented:
Hi Wayne,

What are you using for your URL Rewrite?  IIS or something in your ASP code? I think that part is missing or at least I am not understanding that part.
0
 
Wayne BarronAuthor, Web DeveloperAuthor Commented:
Sorry, IIS 10 - URL Rewrite .
0
 
Wayne BarronAuthor, Web DeveloperAuthor Commented:
Pattern
([_0-9a-z-(-)-]+)

Open in new window


Rewrite URL
Main.asp?Article={R:1}

Open in new window

0
 
Wayne BarronConnect With a Mentor Author, Web DeveloperAuthor Commented:
Got it, thanks to Scott.

([_0-9a-z-(-)-,-]+)

Open in new window


Had to add the comma to the Pattern.
1
 
Wayne BarronAuthor, Web DeveloperAuthor Commented:
Figured it out, once Scott asked what I was using.
1
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.