Skip to main content
A
Anonymous
May 19, 2009
Question

Issue concerning command procedures and resultant selection set

  • May 19, 2009
  • 2 replies
  • 590 views

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.

This topic has been closed for replies.

2 replies

A
Anonymous
May 22, 2009

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

A
Anonymous
May 22, 2009

I am using asp

Lawrence_Cramer
Lawrence_Cramer
Inspiring
May 20, 2009

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

A
Anonymous
May 22, 2009

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.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices