2. ASPRunnerPro General questions
  3. [SOLVED]  Building a pick list
This topic is locked
[SOLVED]

 Building a pick list

 		2/18/2010 2:13:01 PM
ASPRunnerPro General questions
B
 BrettD author

I am working on a Cross Reference database application using ASP Runner Pro 5.2

I would like to be able to search for a result, and then click a button or check a box to select a record to add to a pick list. After completing a dozen or so searches (and picking something from each search), I would then want to go to the final pick list to print out the entire list. Would it be best to do this with the Shopping Cart template (and not care about "checking out")? Or is there another way to do it with the core ASPRunner package?
Sergey Kornilov admin 2/18/2010

I guess it will be very similar to the Shopping Cart template.
What you need is an extra button on the list page that allows to add selected records to the list.

Here is the sample that can help you get started: http://xlinesoft.com/asprunnerpro/docs/email_selected_records.htm
The list itself can be stored either in the database (new table) or in the session variable (easier way).
The latest piece is to print selected records. You can use BeforeSQLQuery event of print page to build WHERE clause based on picked records.