RE: [PHP-DB] Error in SQL syntax
| From: | Rick Emery | Date: | Tue, 28 Aug 2001 13:30:34 +0000 |
| Subject: | RE: [PHP-DB] Error in SQL syntax | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-11895@lists.php.net to get a copy of this message | ||
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:alexv@vse.karelia.ru]
Sent: Tuesday, August 28, 2001 1:03 AM
To: php-db@lists.php.net
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: php-db-unsubscribe@lists.php.net
For additional commands, e-mail: php-db-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net