FreeTDS Development Group

[Steve Hanselman <SteveH AT brendata.co.uk>]

We're guessing that the working version could have been 53rc1 from a backup
listing.

Mssql_query is returning true so it likes the query (we tried breaking the
query and it returns false.

We tried changing the string to "set rowcount 5\n select * from sometable"
but this makes no difference.

(This is a generic piece of code and the ability to run queries with the set
rowcount in the query is important).

Steve


-----Original Message-----
From: Steve Hanselman [mailto:SteveH AT brendata.co.uk] 
Sent: 04 September 2003 18:17
To: 'freetds AT lists.ibiblio.org'
Subject: [freetds] Issue with freetds 0.61.2 ok on prior version which was
<0.60

Using php4 (4.3.3) to a Microsoft 6.5 SQL Server we could previously run two
commands in a string and the results were returned correctly

 

E.g. "set rowcount 5 select * from sometable"

 

Mssql_fetch_array now returns false the first time it is called (presumably
wrongly handling the result set).

Tried using mssql_fetch_object but that returns nothing either.

 

We are using Sybase-ct as the method.

 

This previously worked ok on a version that was lower than 0.60 (I'm sorry I
don't know the version, we were running this for a week then deleted the old
version before noticing this issue).

 

Nothing has changed in the freetds.conf (ver=4.2)

 

Any ideas on what else to look for?

 

Regards

 

Steve

 

Steve Hanselman

Brendata (UK) Ltd

 

Tel: +44 (0)1268 466111

Fax: +44 (0)870 1387283

Mob: +44 (0)7973 750993

 

 

 



The information contained in this email is intended for the personal and
confidential use
of the addressee only. It may also be privileged information. If you are not
the intended
recipient then you are hereby notified that you have received this document
in error and
that any review, distribution or copying of this document is strictly
prohibited. If you have 
received  this communication in error, please notify Brendata immediately
on: 

+44 (0)1268 466100, or email 'technical AT brendata.co.uk' 

Brendata (UK) Ltd
Nevendon Hall, Nevendon Road, Basildon, Essex. SS13 1BX  UK
Registered Office as above. Registered in England No. 2764339

See our current vacancies at www.brendata.co.uk
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds

The information contained in this email is intended for the personal and 
confidential use
of the addressee only. It may also be privileged information. If you are not 
the intended
recipient then you are hereby notified that you have received this document 
in error and
that any review, distribution or copying of this document is strictly 
prohibited. If you have 
received  this communication in error, please notify Brendata immediately on: 

+44 (0)1268 466100, or email 'technical AT brendata.co.uk' 

Brendata (UK) Ltd
Nevendon Hall, Nevendon Road, Basildon, Essex. SS13 1BX  UK
Registered Office as above. Registered in England No. 2764339

See our current vacancies at www.brendata.co.uk