hi, i am having the devil of a time with this. have been researching it
for 3 weeks. have posted to php.faqts.com (no answer), looked a million
times on php.net, and www.borland.com/interbase, written people email
(no response!) and even tried to get the people at easysoft to answer
(they are working on it)..
but it's been 3 weeks now and i cannot seem to get this question
answered, and our project is waiting..
the question simply is: how to write a BLOB (sub-typwith ODBC in PHP?
fyi, it shouldn't make a difference, but i am using interbase 6.0 as the
back end, and the blob is SUB-TYPE 1 (text).
*reading* the blob is trivial with php Unified ODBC. I just use a normal
SQL select statement:
======================================================================
$sql = "select note from note_tbl where pkey = '45'";
# get result
$result = @odbc_exec($conn, $sql);
# assign values
if ( @odbc_fetch_into($result, $row)) {
$note = $row[0];
}
======================================================================
(where notes is the BLOB field). pretty simple.
however, when i try to *write* it back:
======================================================================
$sql = "insert into note_tbl
(note) values ('${note}')
where pkey = '45'";
$result = odbc_exec($conn, $sql);
======================================================================
i get an error message:
======================================================================
Invalid modify request. Conversion error from string "BLOB"
======================================================================
.. so apparently i cannot simply write the string back out to the BLOB.
(tho' IMHO if i can read in a SUB-TYPE 1 (text) BLOB that easily, then i
should be able to write it back out that easily).
apparently this is not just at the PHP Unified ODBC level.. if i run
easysoft's isql program at the command prompt and try to run the same
commands, while i don't get as specific an error message, it does return
an error:
======================================================================
SQL> update notes_tbl set note = 'hello there' where pkey = '16784'
[ISQL]ERROR: Could not SQLExecute
SQL> _
======================================================================
does anyone have some example code for how to do this (in PHP)?
i'd be most grateful..
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
