Have you tried typing this SELECT statement directly into MySQL? If not,
try it; MySQL may indicate a more precise error.
rick
-----Original Message-----
From: Alex V.Varavva [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 28, 2001 1:03 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Error in SQL syntax
Hi!
On execute script
<?php
...
$db = ibase_connect ($DB_WWW, $USER, $PASS,'WIN1251');
$stmt='SELECT YPID FROM TOP_TODAY WHERE DT>("TODAY"-24)';
$sth = ibase_query ($db, $stmt);
...
?>
I have error
InterBase: Dynamic SQL Error expression evaluation not supported in
./test.php
Why ? This is correctly SQL syntax
Regards
Alex
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]