Re: Newbie question--isqlperl text blob insert
In article <3qvqg7$2mq@bennett.eng.umd.edu>
mkerry@Glue.umd.edu "Michael Kerry" writes:
<snip>
> $table = 'mydata';
> $insert = &isql_open(<<EOI) || die $isql_code;
> insert into $table(inv_data) values(?)
> EOI
>
> # insert it
> #
>
> &isql_execute($insert, (@ary)) || die $isql_code;
>
>
> That last line is bad, giving the error
> "-1213 Character to numeric conversion error"
I suspect the problem is that the correct syntax is as follows:
table sally
(
charfield char( 1 ),
numfield integer
);
insert into sally values( 'X', 1 );
e.g. you need quotes around values to be inserted into
CHAR, and possible DATE and DATETIME type columns.
Easiest to put them round all values as it doesn't stop an insert
into a numeric type column.
--
============================================================================
Sally Woolrich | This mail contains my personal
sally@excelsis.demon.co.uk | views not those of my employer!
============================================================================