comment on

This code looks like it should work. here are a few things i would check.:

go into the sql tool for whatever DB you are using and try entering the command you think you are sending. The DB could have a trigger that does something to the data.
look at your schema, you are treating prices as a string in the sql statement, but it may be types are something else in the db and you are getting somekind of conversion bug.

try using placeholders instead of interpolation:

my $query = "UPDATE items SET price=? WHERE itemref=?;";

   print $query;

   $sth = $dbh->prepare ( $query );
   $sth->execute ($price,$itemref);
[download]

This may solve the datatyping issues above.

You are not checking the prepare or execute for errors, there is a good chance your code isn't updating anything in the db and you don't know it.
If all the fails, try moving the comma in the string and see if that changes the results. ie '233,56.00'. if it does that's more information.

-pete
"Worry is like a rocking chair. It gives you something to do, but it doesn't get you anywhere."

In reply to Re: Bizzare comma bug by dreadpiratepeter
in thread Bizzare comma bug by simonodell

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		`&`
	<		`<`
	>		`>`
	[		`[`
	]		`]`

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.