Bug #4748 [NEW]: MySQL Only db function
| From: | jruiz at tecsisa dot com | Date: | Tue, 05 Jul 2005 12:34:34 +0000 |
| Subject: | Bug #4748 [NEW]: MySQL Only db function | ||
| Groups: | php.pear.doc | ||
| Request: | Send a blank email to pear-doc+get-6450@lists.php.net to get a copy of this message | ||
From: jruiz at tecsisa dot com
Operating system: SQL Server
PHP version: 4.3.7
Package: Documentation
Bug Type: Bug
Bug description: MySQL Only db function
Description:
------------
* Mail_Queue_Container::put() in PEAR :: Mail :: Queue :: DB Container
uses the mySQL function "now()" in two SQL Queries.
Should use database independant code.
Reproduce code:
---------------
sprintf("INSERT INTO %s (id, create_time, time_to_send, id_user, ip,
sender, recipient, headers, body, delete_after_send)
VALUES(%d, now(), '%s', %d, '%s', '%s',
'%s',
'%s', '%s', %d)",
Expected result:
----------------
An insert in the MS SQL Data Base
Actual result:
--------------
An error, now() is not a MS DB SQL function
--
Edit bug report at http://pear.php.net/bugs/bug.php?id=4748&edit=1
--