[PHP-DB] DBD

2007-06-28 Thread Mad Unix
on my linux system i keep the following message under my apache server Apache2.x PHP5.2 OCI8 any help [Thu Jun 28 15:40:51 2007] [crit] (70023)This function has not been implemented on this platform: DBD: failed to initialise [Thu Jun 28 15:40:51 2007] [crit] (70023)This function has not been

[PHP-DB] Problem with passing variable to mssql

2007-06-28 Thread William Curry
I have issues I cant understand passing a sql statement to mssql, most of which work fine, however in some cases, a statement like SELECT * FROM tblX where value like 'variable%' will return 0 records when I know they are there. No errors, just 0 records. When I echo the sql string to the

Re: [PHP-DB] Problem with passing variable to mssql

2007-06-28 Thread Stut
William Curry wrote: I have issues I cant understand passing a sql statement to mssql, most of which work fine, however in some cases, a statement like SELECT * FROM tblX where value like 'variable%' will return 0 records when I know they are there. No errors, just 0 records. When I echo the

Re: [PHP-DB] Problem with passing variable to mssql

2007-06-28 Thread Stut
Please include the list when replying. William Curry wrote: Thanx for the quick reply, I left out the concats in my sample here is the exact statement: $qry1 = SELECT *,CONVERT(Char(24),CALL_ENTRY_DATE,101) as MYDATE from PcarsCallComplete where Location_address = .$Location2. order by

Re: [PHP-DB] Problem with passing variable to mssql

2007-06-28 Thread James Gadrow
William Curry wrote: $qry1 = SELECT *,CONVERT(Char(24),CALL_ENTRY_DATE,101) as MYDATE from PcarsCallComplete where Location_address = .$Location2. order by CALL_NO; This method usually works well for me for debugging purposes: immediately prior to query, echo it to see exactly what you're