Robbie Vettenburg
|
| Posted: 03/07/2002, 7:40 AM |
|
Hi,
This is my configuration:
One searchpage with 4 listboxes and one results page
The user can select components from the four listboxen to make a computer
configuration.
Field 1: ARTCD Caption Case
Field 2: ARTCD Caption Processor
Field 3: ARTCD Caption Motherboard
On the result page i have on the input tab on the form properties:
Parameters
Cases Field ARTCD Variable name Case
Processor Field ARTCD Variable name Processor
Motherboard Field ARTCD Variable name Motherboard
If I select an item from one listbox, everything goes ok, but when ik select
two or more listboxes, no record is displayed.
Has anyone a solution?
Kind Regards
Vettenburg Robbie
Belgium
|
|
|
 |
Brent
|
| Posted: 03/07/2002, 7:42 AM |
|
Multiple list boxes should work. You need to debug your application to determine
if the SQL statement that was generated is correct.
In the grid form Open event you need to print the $sSQL statement.
//PHP
die("[myGrid OPEN EVENT] \$sSQL=$sSQL);
Now copy and paste the same SQL statement to an Access or MySQL query window
to see if it returns any records. Chances are you don't have records that
match both listbox values.
|
|
|
|
Robbie Vettenburg
|
| Posted: 03/07/2002, 7:44 AM |
|
you can vieuw it on following site=
http://www25.brinkster.com/updateshop/pc/pcconfig.asp
|
|
|
|
|
