RE: Bad int8 external representation "" (SQL-HY000)(DBD: st_execute/SQLExecute err=-1)

On Thu, 20 Apr 2006 16:21:29 -0700, Loo, Peter # PHX wrote:

Hi Peter

Yes, thanks. I have it working now. Now I am working on the
UPDATE from a SELECT. I am having problem with char columns. I am
working on a routine that will identify the columns that require
quotes and dynamically plug them in before doing the update.

You're wasting you time, and unless you're infallible, will probably write code
which fails one day.

Use placeholders, as I said in my other post a moment ago.

--
Cheers
Ron Savage, ron@xxxxxxxxxxxxx on 21/04/2006
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian company


.