P is for Practical | |
PerlMonks |
SQL Insert with blank in the middleby dredwerker (Initiate) |
on Jul 08, 2010 at 07:47 UTC ( [id://848634]=perlquestion: print w/replies, xml ) | Need Help?? |
dredwerker has asked for the wisdom of the Perl Monks concerning the following question:
Hi all,
I am trying to insert street into a database but I get an incorrect syntax error due to the space in say 'High Street' or in the case below 'something place'.
I am not sure what to do in my insert to make it work - ideas welcome :) $dbh2->do("INSERT INTO PerlTest (Postcode,$_,streetCount) VALUES ('',$_,0)");
Back to
Seekers of Perl Wisdom
|
|