Miro
|
| Posted: 06/01/2003, 9:07 AM |
|
hi people..
this might be a stupid question, but how do I pass a parameter to WHERE clause of my SQL statement? I already have some expressions in WHERE part, I just need to add some more based on the incoming parameters...
Thanks in advance..
PS : PHP, PostgreSQL
miro.
|
|
|
 |
RonB
|
| Posted: 06/01/2003, 3:13 PM |
|
CC?CCS? php?ASP?....
In CCS you can use the query builder to set parameter or switch to sql view, add the parameter like:
where some_id={some_variable_name}
now make sure you add the parameter using the interface setting name and source and setting the retrieval method(url,session etc)
Ron
|
|
|
|
miro
|
| Posted: 06/01/2003, 4:40 PM |
|
thanks Ron, it is CC actually..
|
|
|
|
|
