Re: [PHP] Problem with mssql_query()

2007-05-10 Thread Chris
Richard Lynch wrote: PostgreSQL will simply throw an error, because '8' is not no way no how an INT. It's a string. Since when? test=# create table b(b int); CREATE TABLE test=# insert into b(b) values ('1'); INSERT 0 1 test=# SELECT * from b; b --- 1 (1 row) test=# select * from b where b

Re: [PHP] Problem with mssql_query()

2007-05-09 Thread Richard Lynch
I dunno 100% for sure about MSsql, but I know for sure that MySQL lets you do wording_id = '8' when wording_id is an INT and PostgreSQL will simply throw an error, because '8' is not no way no how an INT. It's a string. I suspect MS SQL may be doing the same, in its own unique bland non-desript w

RE: [PHP] Problem with mssql_query()

2007-05-09 Thread Chris Boget
x27;]; } $this->connection = $conn; return DB_OK; } We use the DSN: mssql://UID:[EMAIL PROTECTED]/db_name. We are not using persistent connections. thnx, Chris From: Dan Shirah [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 09, 200

Re: [PHP] Problem with mssql_query()

2007-05-09 Thread Dan Shirah
Post your block of code from your connection string (Leave out your username/password info please) to the end of the result set for your query so I can take a look at it. On 5/9/07, Chris Boget <[EMAIL PROTECTED]> wrote: I noticed the following in my logs: 22:04:42 [warning] [D:\PHP\pear\DB\m

Re: [PHP] problem with mssql_query

2003-11-12 Thread bob pilly
Thanks! Cheers Bob --- Jason Wong <[EMAIL PROTECTED]> wrote: > On Tuesday 11 November 2003 23:07, bob pillford > wrote: > > Hi all i have the following code which isnt > working correctly and i cant > > work out why. Any help would be greatly > appreciated as its sending me > > crazy! > > > > $

Re: [PHP] problem with mssql_query

2003-11-12 Thread Jason Wong
On Tuesday 11 November 2003 23:07, bob pillford wrote: > Hi all i have the following code which isnt working correctly and i cant > work out why. Any help would be greatly appreciated as its sending me > crazy! > > $query = "select refno from campaign where appdate between 'nov 07 2003' > and 'nov