PHP-FreeTDS.5 and SQL7.0: PHP dies...
Francis Smit
francis at kbd.com.au
Tue Apr 18 06:13:06 EDT 2000
Franck Martin wrote:
> In PHP 3.0, when I access a table in SQL7.0, I have trouble with certain
> columns being present in the SELECT, I also have problems if my result is
> very big above 100 rows returned. This is really strange...
>
> The result is that the PHP page dies and does not return any data to the
> web browser.
>
> Any ideas?
>
> franck at sopac.org.fj
>
1). If you don't need those fields then get rid of them
i.e. don't use SELECT * FROM use SELECT f1, f2, ....
where f1, f2, are the fields you want.
2). limit what you get back using WHERE clauses
(though 100 rows or even 200 should be ok if you
don't have too many fields, and more important don't
return weird types (i.e. rowguid's) that freeTDS cannot
understand).
--
Francis Smit
Knowledge By Design/OzTel
Suite 201, 683 George st
Sydney 2000 NSW
http://www.kbd.com.au
mailto:francis at kbd.com.au
Tel: +61 2 9212 1399
Fax: +61 2 9212 5727
___________________________________
m$: How can we stuff you up today?
-------------- next part --------------
A non-text attachment was scrubbed...
Name: francis.vcf
Type: text/x-vcard
Size: 337 bytes
Desc: Card for Francis Smit
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20000418/8d036621/attachment.vcf
More information about the FreeTDS
mailing list