FreeTDS Development Group

["Gonzalez, Zara E" <gonzalze AT mail.slh.wisc.edu>]

I've solved my problem, unfortunately it leads me to another problem...
One of the fields in my table was an "image" field. Apparently Freetds and/or
PHP don't support image fields...is this true? 

When I deleted my image field, my query executed perfectly...

So my question is, is there any way I can store an image in my MSSQL server 
and
still be able to pull stuff out of it using PHP?

Thanks,

Zara

-----Original Message-----
From: Richard Rowell [mailto:richard AT bowmansystems.com] 
Sent: Wednesday, January 09, 2002 1:57 PM
To: TDS Development Group
Subject: [freetds] Re: MSSQL Queries not working?


On Wednesday 09 January 2002 13:02, you wrote:
> Hi,
>
> I have Freetds 0.53 connecting to a MSSQL 2000 box...
> I can't seem to pull information out of the database. I can insert, 
> but not pull data out.
>
> Am I using the wrong code? Here is the code that is not working. It 
> seems to be failing on the $result line since when I comment that line 
> out, I at least get an error. If that line isn't commented then all I 
> get is "Page cannot be displayed".
>
> Any Ideas or suggestions?
>
> mssql_connect(DB_HOST, DB_USER, DB_PW) or DIE("Error: Server failed to 
> respond.");
> mssql_select_db(DB_NAME) or DIE("Error: Could not connect to table."); 
> $query = "SELECT * FROM test where id = '$id'"; $result = 
> MSSQL_QUERY($query) or DIE("Error: Could not handle Query."); $r = 
> MSSQL_FETCH_ARRAY($result) or DIE("Error: Could not process result.");
>       $data = $r["data"];

We had similar problems before with an older version of freetds 
(specifically, we could do selects fine till we did and update/insert then 
selects returned empty sets from that point forward) We got it to work fine 
with PHP4.1/Freetds .52/Linux 2.4.16 connecting to both SQL Server 7 & 2000 
databases however.

---
You are currently subscribed to freetds as: [gonzalze AT mail.slh.wisc.edu] To
unsubscribe, forward this message to $subst('Email.Unsub')