FreeTDS Development Group

[Francis Smit <francis AT kbd.com.au>]

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?

begin:vcard 
n:Smit;Francis
x-mozilla-html:TRUE
org:Knowledge By Design
version:2.1
email;internet:francis AT kbd.com.au
title:Software Development Manager
tel;fax:+61 2 9212 6962
tel;work:+61 2 9212 1399
adr;quoted-printable:;;Level 2, Suite 202,=0D=0A683 George Street;Sydney;NSW;2203;Australia
x-mozilla-cpt:;0
fn:Francis Smit
end:vcard