Daniel Gaudreault
|
Posted: 03/28/2001, 6:35 AM |
|
Code charge is a great product, however, I've noticed a possible bug. This
is using PHP 4.0 (no templates) & PostgreSQL.
This used to work in versions prior to 112.
I've tried using the Form Properties/SQL/Use SQL String
I've put in the following query:
select ticketid,categoryid,productid,signmakerid,timestamp(opened) as
opened,timestamp(closed) as closed,opendby,closedby, description from
adminticket
The form displays the fields properly, however, when generating the page,
the query is completely ignored.
I've tried overiding the $sSQL in the OPEN Event. If this is set up as a
grid, the the variable is overwritten, but
when it is setup as a record page (which is what I need) it puts in my code
in the following manner.
/* Added by Dan G. */
$sSQL="select ticketid,categoryid,productid,signmakerid,timestamp(opened) as
\"opened\",timestamp(closed) as \"closed\",opendby,closedby, description
from adminticket";
/* Added by Dan G. */
$sSQL = "select * from adminticket where " . $sWhere;
Is there another work around for this?
Dan Gaudreault
|
|
|
|