php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #9295 Error passing DATE to OpenLink
Submitted: 2001-02-16 05:47 UTC Modified: 2001-04-27 21:55 UTC
From: k dot watkins at ru dot ac dot za Assigned:
Status: Closed Package: ODBC related
PHP Version: 4.0.4pl1 OS: FreeBSD 4.2-STABLE
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: k dot watkins at ru dot ac dot za
New email:
PHP Version: OS:

 

 [2001-02-16 05:47 UTC] k dot watkins at ru dot ac dot za 
Reproducing the problem:
------------------------
odbc_do($cid, 'Select * from table where datefield=DATE("16/02/2001")');

produces:
Warning: SQL error: [unixODBC][OpenLink][ODBC][Driver]Option Value Changed, SQL state [???? in SQLExecDirect in
/www/data/datetest.php on line 12

Entering the query from the OpenLink odbctest program gives
the desired result.

Using DATE(02,16,2001) gives the same result. 

I've tried with php configured to use both iodbc and
unixODBC. Both produce the same result.

Queries not involving DATE() are working on the same setup. 

My configuration:
-----------------
'./configure' 
'--with-apxs=/usr/local/sbin/apxs' 
'--enable-versioning'
'--with-system-regex' 
'--with-config-file-path=/usr/local/etc'
'--disable-debug'
'--enable-track-vars'
'--without-gd'
'--disable-pear' 
'--without-mysql'
'--with-zlib'
'--with-mysql=/usr/local' 
'--with-unixODBC'
'--with-openlink'
'--with-magic-quotes'
'--enable-trans-sid' 
'--prefix=/usr/local'
'i386--freebsd4.2'

I'm running apache 1.3.14

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-04-01 20:02 UTC] kalowsky@php.net 
which version of OpenLink are you using?  Supposedly the 
latest OpenLink has been better optimized for use with PHP.  
Please try updating to that (if you haven't already) and 
see if this problem still persists for you...
 [2001-04-27 21:55 UTC] kalowsky@php.net 
no user feedback, considered fixed.  if the problem still 
persists, please reopen the bug.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Thu Apr 25 10:01:29 2024 UTC