Using array(s) for data retrieval

Using array(s) for data retrieval

Post by gammbr » Thu, 08 Sep 2005 23:21:54


I would like to create a page or 2 on my site that allows a user to enter
values into an array or arrays, and then using the values in the array(s) query
a database, retrieve records based on those values, and give the user the
results.

There would be 3 values, 2 of which are used for query parameters and the
third is just used to show up on the results page.

Anyone have any recommendations as to go about doing this?
 
 
 

Using array(s) for data retrieval

Post by Christophe » Thu, 08 Sep 2005 23:50:54

Why do you want to store the values in an array, why not just a variable for
each?

And....which server-side language are you using?

- Chris

 
 
 

Using array(s) for data retrieval

Post by Christophe » Thu, 08 Sep 2005 23:52:46

Actually, if they are physically entering the data into a text field, then
DW can just get at the form element values.
 
 
 

Using array(s) for data retrieval

Post by gammbr » Fri, 09 Sep 2005 00:22:06

I already have a page that allows them to enter values and get the data they
are looking for using form element values, but only one set at a time. If they
want to enter say 5 different sets of values, currently they have to enter the
first set, print the results page, enter the second set, print the results
page, etc. Want I want to provide is the ability for them to enter all of the
values, then when they click the Submit button the results page displays the
data for ALL of the values that they entered. Basically it's storing the
values somewhere, then using the values to display recordset results.

I am using ASP.