Issue concerning command procedures and resultant selection set

[sheilat]

I have created acommand procedure which returns a set of records (correctly). I would like to use the ID from the set as a link to a detail page. The ID is corectly returned to me.  However, when I try to create the detail page it appears to only be possible if the set of records is from a recordset query.  So - how can I add the link to my results page ID so I can pull up a detail page on the item?

Thank you.

[Lawrence_Cramer]

On you results page you'll need a query to pull the record from the database and in your SQL statement the WHERE statement will be dynamically populated by a URL variable. You'll pass the ID in your URL to the Results page to provide this variable.

Just how you do this varies a little depending on which language you are using - PHP, ColdFusion, ASP - but the principle is the same for all.

Lawrence   *Adobe Community Expert*
www.Cartweaver.com
Complete Shopping Cart Application for
Dreamweaver, available in ASP, PHP and CF

[sheilat]

I know how to do this if my records come from a recordset query.  BUT - My records are the result of a command procedure and I can't seem to set up a link using any of the returned columns in the results set.

[Guest]

What is the server-side language did u use? PHP, ASP, etc.. ?

[sheilat]

I am using asp