i'm using php and it's odbc support for inserting values in a database. When i try to insert text larger than 8k in a long (ASCII conding) column i get an error : Not yet implemented....
Use the functions odbc_prepare and odbc_execute: $insert = odbc_prepare ($connection, "insert into testtable (col1, col2, cl3) values (?, ?, ?)"); odbc_execute ($insert, [$col1value, $col2value, $col3value]);
1. not being a PHP prgrammer myself, I'm not sure that [] is really the way to create an array
2. using prepare/execute is also practical as you can more easily insert values with special characters
3. if you have multiple inserts, it is also way more efficient to prepare only once and execute many times with different parameters than to execute multiple odbc_do
Daniel Dittmar
-- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED]
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
