Re: $hour_insert_sth->execute showing error

$hour_master_db->prepare("
   INSERT into esme_hourly_master
   VALUES (?,?,?,?,?,?,?,?,?,now(),'MIS')
                                        ^ add missing )
   ");
[download]

poj

Comment on Re: $hour_insert_sth->execute showing error Download Code

Replies are listed 'Best First'.
Re^2: $hour_insert_sth->execute showing error by 1nickt (Canon) on Nov 04, 2015 at 08:17 UTC
Dammit I looked at that until my eyes were crooked and I couldn't see it! Nice one, poj. The way forward always starts with a minimal test.	[reply]
Re^2: $hour_insert_sth->execute showing error by ravi45722 (Pilgrim) on Nov 04, 2015 at 09:53 UTC
I scrolled twice trice up to my mouse wheel cracks. Still I don't get that one. Thank you	[reply]
Re^3: $hour_insert_sth->execute showing error by poj (Abbot) on Nov 04, 2015 at 10:27 UTC
I expect you would have seen it written like this `my $sql = "insert into esme_hourly_master values (?,?,?,?,?,?,?,?,?,now(),?"; my $hour_insert_sth = $hour_master_db->prepare($sql);` [download] poj	[reply] [d/l]
Re^4: $hour_insert_sth->execute showing error by ravi45722 (Pilgrim) on Nov 04, 2015 at 11:06 UTC
`my $sql = "insert into esme_hourly_master values (?,?,?,?,?,?,?,?,?,now(),?";` [download] U misses the ')' to close the values. Or it's like that only	[reply] [d/l]