Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

Re: Issuing a DELETE statement with DBI

by b10m (Vicar)
on Sep 01, 2006 at 08:57 UTC ( #570742=note: print w/replies, xml ) Need Help??


in reply to Issuing a DELETE statement with DBI

First of all, you really really really want to use place holders for starters, to prevent SQL injection (also see a column on this by merlyn).

And to be honest, I think that'd solve your quoting problem too (for I assume the lack of quotes around the $testTitle is giving your DB problems)

(besides the commit answer, given by aquarium, of course).

--
b10m

All code is usually tested, but rarely trusted.
  • Comment on Re: Issuing a DELETE statement with DBI

Replies are listed 'Best First'.
Re^2: Issuing a DELETE statement with DBI
by mattdope (Acolyte) on Sep 01, 2006 at 09:35 UTC
    cheers mate will give that a try

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://570742]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (4)
As of 2022-12-06 00:33 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?