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
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]
, May 09, 2007 11:07 AM
To: Chris Boget
Cc: PHP General
Subject: Re: [PHP] Problem with mssql_query()
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
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
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 08
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!
$query = select
6 matches
Mail list logo