Oli wrote:
Hi
URL in address bar:
http://localhost/edituser.asp?pID=1
SQLQuery = "SELECT * from Applicant WHERE pID="' &
Request.Querysting('pID') & '"
But it only gets: SELECT * from Applicant WHERE pID=
This is only simple but is causing me a headache!
Any ideas??
TIA - Oli
Nope. Show us some more of the script. Actually, you should create a test
page with just the following code in it:
<%
dim parm
parm = Request.Querystring("pID")
Response.Write "parm contains " & parm
Response.End
%>
Run the page, adding the querystring to the url, and let us know if you
don't get the intended result. If you do get the intended result, start
adding code from your current page until it stops working. If that does not
clue you into the problem, show us the code that breaks the page.
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"