Bug #4748

MySQL Only db function

Details

Submitted	2005-07-05 12:34 UTC
From	jruiz at tecsisa dot com
Assigned	quipo
Status	Closed
Package	Mail_Queue
PHP Version	4.3.7
OS	SQL Server
Roadmaps	(Not assigned)

Comments

[2005-07-05 12:34 UTC] jruiz at tecsisa dot com

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