What's wrong with this Query? 1

[ecobb]

Hi, this is my first .asp project and I'm having problems passing a URL Variable (I guess you call it QueryString) to a query. I thought it would be simple enough, but I keep getting an error.

Here's the query:

SELECT * FROM tblname WHERE schoolid = Request.QueryString('schoolid') ;

And here's the error:

Microsoft JET Database Engine error '80040e14' 

Undefined function 'Request.QueryString' in expression.

What am I doing wrong? The url string is a numeric value, like this: whatever.asp?schoolid=17817

Hope This Helps!

ECAR
ECAR Technologies

http://www.ecartech.com

"My work is a game, a very serious game." - M.C. Escher

 

[Chopstik]

The querystring is part of ASP, not SQL (which is what the rest of your string is. Try this:

strSQL = "SELECT * FROM tblname WHERE schoolid = " & Request.QueryString('schoolid')

Also bear in mind that if your querystring value is null, this will fail. Does this make sense to you? Post back if you have further questions.

------------------------------------------------------------------------------------------------------------------------
"Men occasionally stumble over the truth, but most of them pick themselves up and hurry off as if nothing ever happened."
- Winston Churchill

 

[ecobb]

Ok, I see now. Thanks, that got it!

Hope This Helps!

ECAR
ECAR Technologies

http://www.ecartech.com

"My work is a game, a very serious game." - M.C. Escher

 

[tsdragon]

That should be Request.QueryString([red]"[/red]schoolid[red]"[/red])


Tracy Dryden

Meddle not in the affairs of dragons,
For you are crunchy, and good with mustard.