RE: Informix + SLOB
| From: | Dan Fitzpatrick | Date: | Thu, 03 Aug 2000 05:40:43 +0000 |
| Subject: | RE: Informix + SLOB | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-1748@lists.php.net to get a copy of this message | ||
Francois,
SLOB support is not yet implemented. (From
http://www.php.net/manual/ref.ifx.php)
-snip-
IUS 9.x support is partly finished: the new data types are there, but
SLOB and CLOB support is still under construction.
-snip-
We use BLOB's and they work like this for selects.
ifx_textasvarchar(1);
$conn_id = ifx_connect("db@host","user",password);
$sql = "SELECT * FROM table WHERE field = 1";
$q = ifx_query($sql,$conn_id);
Then treat the text field as a regular field variable.
--
Dan Fitzpatrick
Rapid Ascent - The e-Business Builders
http://rapidascent.com
Got $$$$$$/Stock/Sandals/Shorts/FlexibleHours/Telecommute/Sushi/Gadgets?
I'm looking for Java/XML/EJB/JSP/Enhydra/PHP or,
Linux/Solaris/Apache/F5/Cisco/Firewall-1/Informix.
If this better describes a friend of yours, I'll pay $3,000 for a
referral.
________________________________
Subject: Informix + SLOB
Date: Wed, 02 Aug 2000 18:21:26 +0200
From: Francois Baligant <francois@be.euro.net>
To: php-db@lists.php.net
Hi,
We are running Informix Foundation.2000. We are using
Smart-Large Object mainly to store big text documents.
As anyone ever succeeded at selecting a slob with PHP4?
(4.0.1pl2) So far, it returns nothing or the webserver
core dumps.
As anyone some examples on how to use the SLOB Informix
functions ? I think we are doing it wrong due to the
lack of documentation.
Thanks,
Francois
ps: please Cc: my email so your response don't get lost in the
newsgroup :-)
--
Francois Baligant * * Wanadoo Belgium NV/SA
Network Operation Center * * a subsidiary of France Telecom
* Lozenberg 22 - B-1932 Zaventem
FB1-6BONE * tel: +32 2 717 17 17
francois@be.wanadoo.com fax: +32 2 717 17 77