Tony Tomov
|
Posted: 01/07/2002, 6:16 AM |
|
When using a custom SQL (grid ) like:
SELECT table.*, table1.* FROM table,table1
WHERE ..... table.field1 = ".get_session("MySesID").";
I recieve the following Error from CC:
ERROR: parse error near "MySesID",
but when the page is generated
(I have first write the select statment from tables - to obtain the fields, and the where clause is written after that)
all goes OK
I use PHP with templates and PostgreSQL.
Tony
|
|
|
Tony Tomov
|
Posted: 01/07/2002, 6:34 AM |
|
The solution is to write in Open event the following code:
$sWhere = $sWhere ." AND table.field1 = ".get_session("MySesID");
Regards
Tony
|
|
|
|