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
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
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
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
I noticed the following in my logs:
22:04:42 [warning] [D:\PHP\pear\DB\mssql.php][439]: mssql_query(): Unable
to set query
22:04:42 [info] Backtrace: [D:\PHP\pear\DB\mssql.php][439]; function(
mssql_query ); args( 1[value:select @@ERROR as ErrorCode] 2[value:Resource
id #21] )
22:04:42 [i
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!
> >
> > $
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
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
2003' ";
$result=mssql_query($query,$numero);
$numrows=mssql
8 matches
Mail list logo
