On Sep 9, Eduardo Vazquez Rodriguez said: >@duration = $string =~ /\sduration=(.*?)\s/; > >The first element in duration contains "1.23", in a string format > >When I try to insert $duration[0], into a field of integer type in a database, >I get the Following error: > >Error Column "duration" is of type integer but expression is of type character >varying
You neglected to show us the code that actually inserts the data into the table. Perhaps you've accidentally quoted the data? -- Jeff "japhy" Pinyan % How can we ever be the sold short or RPI Acacia Brother #734 % the cheated, we who for every service http://japhy.perlmonk.org/ % have long ago been overpaid? http://www.perlmonks.org/ % -- Meister Eckhart -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
