RE: Informix + SLOB

I know that BLOB support is working. However I really need SLOB because I index data with the Excalibur Text Search Datablade and Smart-large object are needed for that. So I should use WebDatablade instead ? Francois 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 On Wed, 2 Aug 2000, Dan Fitzpatrick wrote: > 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 >