Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"

Re: DBI and stored procedures

by dsheroh (Prior)
on Nov 05, 2012 at 12:01 UTC ( #1002313=note: print w/replies, xml ) Need Help??

in reply to DBI and stored procedures

Regardless of SQL injection concerns, you should be validating pretty much all entered data anyhow, except for perhaps freeform "comments" fields and the like.

Is it a date field? You need to validate that it's a good date, and not 2009-02-29. Is it a credit card number? Validate that it's sixteen digits and the check digit is correct. Etc. Unless these things are being verified in the stored proc, you need to check them in code before sending it to the database.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1002313]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (9)
As of 2018-03-18 14:10 GMT
Find Nodes?
    Voting Booth?
    When I think of a mole I think of:

    Results (230 votes). Check out past polls.