sybperl-l Archive

From: Khanh-Linh Huynh <linh dot huynh at mci dot com>
Subject: convert from char to int
Date: Nov 16 1998 12:05AM

I'm writing a cgi app to do updating to the database using sybperl.  Since perl 
regards everything as string, my int field does not get updated.

The below code gave me an "Implict conversion from datatype 'varchar' to 
'numeric'" error.

$col1 = contents{'col1'} ;
....
	update table1
	set
		a = convert(int, $col1)
	where a = $aa

Is there another way to do this?

Thanks...