About Jeff Allen Expertise I can answer basic to intermediate questions related to Classic ASP.I can answer Intermediate to Advanced questions CSS& HTML, and basic questions about JavaScript and Ajax. I can also answer questions related to web page accessibility under US Section 508.
Experience I have 8 years experience with HTML. I have been developing in ASP, VBScript and CSS for two years each. I also currently work as web developer.
Organizations IWA-HWG
Education/Credentials I have a BA in English with minors in Web Design and Scientific and Technical Writing
Expert: Jeff Allen Date: 7/8/2006 Subject: ASP with AutoNumber
Question Hi,
I have the format of the AN in Access set as: "Br"0000, and in another table the AN set as: "Sr"0000.
When using Querystring only the Numbers are picked up which is causing me a problem.
How do I get around this please?
Thank you.
Answer How are you passing the query strings? Usually, with querystrings you would see something like this in your HTML:
<a href="http://www.mysite.com?br=<%=objRS("IDFieldName")%>">Click me</a>
If you do not assign the correect querystring variable and value to the sending string then there is no way to ensure the recieving page will pick up the correct value when you use something like:
<%
Dim myID : myID = Request.Querystring("br")
%>
But, send me your ASP code so I can review it and we'll see if we can't track the error down. Also, remember that when appending more than one querystring variable that each succeeding querystring is appended using the '&' sign:
?br=1&sr=2&tr=3 (amd so on, I however use the ASCII equivalent (&)so I get less errors which would look like:
?br=1&sr=2&tr=3 (and so on)
Let em know if this isn't quite clear and I'll see if I cna't explain it differently after I have seen your code.
