Need to catch a URL variable 1

[Bammy217]

Heya,

Ok I'm making the conversion from Cold Fusion to ASP (Started today ) and would like to ask you guys a question. I'm running a SQL Stored procedure, and need to feed it some variables (IDs of 2 ITEMS) so am using "testpage.asp?Pid=12&Sid=88" now all I want to do is get my IIS to feed this to SQLServer " exec ssp_GetPage '12', '88' "

And then display the results, Now I've figured out how to get ASP to Execute a Stored Procedure, but am still unable to feed it a variable specified by the URL...

Please Help
D. We never fail, we just find that the path to succes is never quite what we thought...

 

[onpnt]

testpage.asp?Pid=12&Sid=88

to call

request.querystring("Pid&quot
request.querystring("Sid&quot

is that what your looking for _________________________________________________________
for the best results to your questions: FAQ333-2924
Is your question a most FAQ?? Find out here FAQ333-3048

http://www.onpntwebdesigns.com/aspTut4.asp

 

[jemminger]

[tt]
oConnection.Execute("EXEC ssp_GetPage '" &_
request.querystring("Pid&quot & "','" &_
request.querystring("Sid&quot & "'&quot[/tt] =========================================================
if (!succeed) try();
-jeff