Jomary
|
| Posted: 04/19/2002, 2:46 PM |
|
Hi:
I'm trying to make a search page that when I put the parameters on the fields I can go to another page which will be the page that contains the information I like to display. The problem is that when I'm going to present the data in the other page it only display one value of two I need it. The page use a custom SQL to make a join of two tables. I'm passing the value needed, as input to that page, to use it in the SQL. What could be the problem? Why I can't get the two values?
Jomary
|
|
|
 |
Nicole
|
| Posted: 04/20/2002, 3:00 AM |
|
Jomary,
print whole sql (with search parameter added) and test it against db. Do you get one record anyway? Try to use left join for tables.
|
|
|
|
Jomary
|
| Posted: 04/20/2002, 2:00 PM |
|
Nicole:
It works if the search - grid form is in the same page but not when I change it to aother page which is what i need to do ...
|
|
|
|
|
