Item 3.
It looks like <@BIND> is indeed limited to variables no larger than
32k. Attempting to insert a 40683 byte long jpeg via directDBMS into
a mysql mediumblob column crashes witangod 5.0.1.065. But the file
inserts just fine with an INSERT action. Looks like the data binding
is more extensive with the INSERT/UPDATE actions.
bill
On Jan 7, 2006, at 4:53 PM, William M Conlon wrote:
I've been replacing all my Search, Update, Insert, and Delete
actions with DirectDBMS. Everything has been going along fine
until I got to some data that didn't get properly escaped, so I've
investigated and started using <@BIND>. A few observations and
then questions.
1. Although we are advised to always quote attributes, it appears
that Witango 5.0.1.065 does not properly decode quoted paramters.
So <@BIND SCOPE="request" NAME="myvar"> does not work but <@BIND
SCOPE=request NAME=myvar> does. (This has been filed as a bug).
2. It looks like Witango database actions use binding for any
parameters where Quote Value = True, so I should probably do the
same and use:
UPDATE table SET text = <@BIND SCOPE=request NAME=input_text> WHERE
id = @@request$id
instead of
UPDATE table SET text = '@@request$input_text' WHERE id = @@request$id
3. The Programmers Guide refers to a 32k size limit for VARBIN
columns, but I've successfully inserted 8Megabyte files into BLOBs
using INSERT actions, so I assume <@BIND> will work with
arbritarily sized BLOBs. I guess I'll test and find out.
4. The Programmers Guide refers to OCI and ODBC (which I use).
Does anyone know if this works with JDBC?
5. Are there any other tips for using <@BIND>
thx.
Bill
______________________________________________________________________
__
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Bill
William M. Conlon, P.E., Ph.D.
To the Point
345 California Avenue Suite 2
Palo Alto, CA 94306
vox: 650.327.2175 (direct)
fax: 650.329.8335
mobile: 650.906.9929
e-mail: mailto:[EMAIL PROTECTED]
web: http://www.tothept.com
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
