On Tue, 2006-08-01 at 10:13 -0500, Charles K. Clarkson wrote: > Bjørge Solli wrote: > > : I get an error message I don't understand. I've been following > : what I thought was good practice when talking to a DB. > > Did you import those constants? > > use DBI qw(:sql_types);
I have a similar problem myself now. I am getting a type mismatch because they are strings. I am doing a split on a csv input file. I ran bind with SQL_NUMERIC or SQL_INTEGER or SQL_DECIMAL it still fails. I did a $var +=0 and it worked. This is an OK solution, not a great one. Problem is that there is a dollar value 1234.59 and I am worried that this will convert to float and corrupt the value. Is there a better way to do this? -- Ken Foskey FOSS developer -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
