Mark
|
| Posted: 09/13/2002, 4:30 AM |
|
I have read Alex's post but still can't get it work.
I have a query that is date dependent
On the grid page is a control that diplays todays date {s_today}
The query works if I hard code the date can anyone enlighten me as to what I
may be missing
SELECT B.NAME FROM JOES.STAFF B
WHERE B.NAME NOT IN
(SELECT A.NAME
FROM JOES.STAFF_ACTIVITIES A
WHERE TO_CHAR(TO_DATE(A.DT,'MM/DD/YYYY'),'MM/DD/YYYY') =
'{s_today}')
CCS 1.0.7.0
Win2k Server
Oracle
PHP
Thanks
Mark
|
|
|
 |
Nicole
|
| Posted: 09/16/2002, 2:40 AM |
|
Mark,
print whole sql statement and test it against db, I suppose that the problem is in date formatting.
To print sql use following code in the form Before Show event:
global $form_name;
$form_name->ds->SQL;
|
|
|
|
Mark
|
| Posted: 09/16/2002, 4:56 AM |
|
Nicole
This code did not work
Mark
|
|
|
|
Nicole
|
| Posted: 09/17/2002, 4:41 AM |
|
Mark,
sorry the code is:
global $form_name;
echo "sql: ". $form_name->ds->SQL;
|
|
|
|
|
