Bug #4748 [NEW]: MySQL Only db function

From: 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 --

« previous php.pear.doc (#6450) next »