On Tuesday 01 August 2006 17:04, Greg Sabino Mullane wrote: > > use strict; > > use DBI; > > $sth->bind_param( 1, \$insertid, SQL_INT); #insertid from other > > insertion $sth->bind_param( 2, \$ap, SQL_DOUBLE); > > You need to tell DBI to import the SQL type constants. This is done by > replacing 'use DBI;' above with: > > use DBI qw(:sql_types); > > Note that SQL_INT is not a valid type: you want to use SQL_INTEGER > instead. You can view all the available types with this bit of code, > taken from the documentation for DBI:
Thanks, that helped. -- Bjørge Solli - Office:+47 55205847 Mohn-Sverdrupsenteret, Nansensenteret, Høyteknologisenteret T47 Thormöhlensgate 47, 5006 Bergen, Norway - www.nersc.no Google Earth: www.nersc.no/GE - TOPAZ: topaz.nersc.no -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
