Re: [PHP] ODBC Functions & MS SQL Server 2005

2008-09-18 Thread Thodoris
On Thu, Sep 18, 2008 at 4:35 PM, Micah Gersten <[EMAIL PROTECTED]> wrote: If you need abstraction, check this out: http://us.php.net/pdo Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, vi

Re: [PHP] ODBC Functions & MS SQL Server 2005

2008-09-18 Thread Dan Joseph
On Thu, Sep 18, 2008 at 5:35 PM, Micah Gersten <[EMAIL PROTECTED]> wrote: > You can't upgrade PHP? > > Thank you, > Micah Gersten > onShore Networks > Internal Developer > http://www.onshore.com > > > > Dan Joseph wrote: > > On Thu, Sep 18, 2008 at 4:35 PM, Micah Gersten <[EMAIL PROTECTED]> > wrot

Re: [PHP] ODBC Functions & MS SQL Server 2005

2008-09-18 Thread Micah Gersten
You can't upgrade PHP? Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Dan Joseph wrote: > On Thu, Sep 18, 2008 at 4:35 PM, Micah Gersten <[EMAIL PROTECTED]> wrote: > > >> If you need abstraction, check this out: >> http://us.php.net/pdo >> >> Thank you, >

Re: [PHP] ODBC Functions & MS SQL Server 2005

2008-09-18 Thread Dan Joseph
On Thu, Sep 18, 2008 at 4:35 PM, Micah Gersten <[EMAIL PROTECTED]> wrote: > If you need abstraction, check this out: > http://us.php.net/pdo > > Thank you, > Micah Gersten > onShore Networks > Internal Developer > http://www.onshore.com > > -- > PHP General Mailing List (http://www.php.net/) > To

Re: [PHP] ODBC Functions & MS SQL Server 2005

2008-09-18 Thread Micah Gersten
If you need abstraction, check this out: http://us.php.net/pdo Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Dan Joseph wrote: > On Thu, Sep 18, 2008 at 3:36 PM, Dan Shirah <[EMAIL PROTECTED]> wrote: > > >> If you already have your results in an array, t

Re: [PHP] ODBC Functions & MS SQL Server 2005

2008-09-18 Thread Dan Joseph
On Thu, Sep 18, 2008 at 3:36 PM, Dan Shirah <[EMAIL PROTECTED]> wrote: > > If you already have your results in an array, try using count($result); > That should count the number of results returned to your result array. > > Or you could try uncommenting the mssql extension in your php.ini file and

Re: [PHP] ODBC Functions & MS SQL Server 2005

2008-09-18 Thread Dan Shirah
On 9/18/08, Dan Joseph <[EMAIL PROTECTED]> wrote: > Hi, > > Anyone else using the odbc_* functions to interact with MS SQL Server 2005? > > I'm having a problem getting odbc_num_rows() to return anything other than > -1 when querying a stored procedure. I can get it to work using Top in a > norma

[PHP] ODBC Functions & MS SQL Server 2005

2008-09-18 Thread Dan Joseph
Hi, Anyone else using the odbc_* functions to interact with MS SQL Server 2005? I'm having a problem getting odbc_num_rows() to return anything other than -1 when querying a stored procedure. I can get it to work using Top in a normal query (non-stored procedure). SELECT Top 100 * FROM Tabl

Re: [PHP] odbc functions - not binary safe?

2004-01-26 Thread memoimyself
Check out the message below, which a user added to the online version of the PHP manual. Could this have anything to do with your problem? ** FROM http://br2.php.net/manual/en/function.mysql-escape-string.php ** sp4m_only at hotmail dot com 02-Apr-2003 10:07 I found out another very curiou

Re: [PHP] odbc functions - not binary safe?

2004-01-26 Thread John Nichel
[EMAIL PROTECTED] wrote: Hello CC, On 26 Jan 2004 at 12:47, C C wrote: Hi, I'm trying to insert binary data into a MS SQL Server database. Text files are added fine, but binary files with null bytes are not. The field I'm adding the binary data to is image type. I get an error about unclosed qu

Re: [PHP] odbc functions - not binary safe?

2004-01-26 Thread memoimyself
Hello CC, On 26 Jan 2004 at 12:47, C C wrote: > Hi, > > I'm trying to insert binary data into a MS SQL Server database. Text > files are added fine, but binary files with null bytes are not. The > field I'm adding the binary data to is image type. I get an error about > unclosed quotation marks

[PHP] odbc functions - not binary safe?

2004-01-26 Thread C C
Hi, I'm trying to insert binary data into a MS SQL Server database. Text files are added fine, but binary files with null bytes are not. The field I'm adding the binary data to is image type. I get an error about unclosed quotation marks at the null byte, but I've replaced ' with ''. I tried esca

[PHP] odbc functions

2002-02-04 Thread Richard Black
Does anyone have experience of using odbc_primarykeys??? I'm writing a script to let me port a database from Access to MySQL without having to write all the table definitions by hand. But I can't get odbc_primarykeys to work - it comes back with: Warning: SQL error: , SQL state 0 in SQLPri