|
 |
asp_web_howto thread: Help! Stored Procedures
Message #1 by info@e... on Fri, 15 Jun 2001 07:02:34
|
|
Hello everyone,
I am having problem putting a Request.Querystring on a stored procedure. I
have a stored procedure that displays database information trough a
recordset. I want the record to change depending on the ID that it is
given. Example URL: www.mysite.com/detail.asp?sku=12345
My database field is called sku, fyi & that is what I want on the URL. So
if I were to change the "12345" to a "99999", the record would change
according to the matching sku number. Can anyone help me on how to call
it?? I would really appreciate any examples. Thanks!
Regards,
Elmer M.
elmer@e...
Message #2 by Kyle Burns <kburns@c...> on Fri, 15 Jun 2001 09:02:54 -0500
|
|
How is your SP declared? Does it return a recordset?
Kyle M. Burns, MCP
Database Administrator/Webmaster
Centra Credit Union
kburns@c...
-----Original Message-----
From: info@e... [mailto:info@e...]
Sent: Friday, June 15, 2001 2:03 AM
To: ASP Web HowTo
Subject: [asp_web_howto] Help! Stored Procedures
Hello everyone,
I am having problem putting a Request.Querystring on a stored
procedure. I
have a stored procedure that displays database information trough a
recordset. I want the record to change depending on the ID that it is
given. Example URL: www.mysite.com/detail.asp?sku=3D12345
My database field is called sku, fyi & that is what I want on the URL.
So
if I were to change the "12345" to a "99999", the record would change
according to the matching sku number. Can anyone help me on how to call
it?? I would really appreciate any examples. Thanks!
Regards,
Elmer M.
elmer@e...
Message #3 by info@e... on Fri, 15 Jun 2001 19:03:19
|
|
Yes, my SP returns a recordset. Thanks!
P.S - Let me know if you need a sample of my code.
Regards,
Elmer M.
> How is your SP declared? Does it return a recordset?
>
> Kyle M. Burns, MCP
> Database Administrator/Webmaster
> Centra Credit Union
> kburns@c...
>
>
>
> -----Original Message-----
> From: info@e... [mailto:info@e...]
> Sent: Friday, June 15, 2001 2:03 AM
> To: ASP Web HowTo
> Subject: [asp_web_howto] Help! Stored Procedures
>
>
> Hello everyone,
>
> I am having problem putting a Request.Querystring on a stored
> procedure. I
> have a stored procedure that displays database information trough
a
> recordset. I want the record to change depending on the ID that it
is
> given. Example URL: www.mysite.com/detail.asp?sku=3D12345
>
> My database field is called sku, fyi & that is what I want on the URL.
> So
> if I were to change the "12345" to a "99999", the record would
change
> according to the matching sku number. Can anyone help me on
how to call
>
> it?? I would really appreciate any examples. Thanks!
>
> Regards,
> Elmer M.
> elmer@e...
>
|
|
|
View Cart
