Usining Params in SQL View

CodeCharge Studio

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeChargeStudio.Discussion

Usining Params in SQL View

Author

Message

Mark

Posted: 09/13/2002, 3:49 AM

I have read Alex's post on gotocode but 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

CCS 1.0.7.0
Win2k Server
Oracle
PHP

Thanks
Mark

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}')

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home | Search | Members | Register | Login