Re^6: DBI, place holders and CGI forms

So the advice works great for selects, I'm now thinking about how can I do this with insert statements, the same idea, I don't know what columns have been submitted. Will the same idea work here?

Comment on Re^6: DBI, place holders and CGI forms

Replies are listed 'Best First'.
Re^7: DBI, place holders and CGI forms by mje (Curate) on Jun 17, 2011 at 14:58 UTC
Which idea are you referring to?	[reply]
Re^8: DBI, place holders and CGI forms by Anonymous Monk on Jun 17, 2011 at 15:39 UTC
Your select advice - `select col1, col2, col3 from tab_name where (? is null or foo = ?) a +nd (? is null or bar = ?) and (? is null or baz = ?)` [download] .	[reply] [d/l]
Re^9: DBI, place holders and CGI forms by mje (Curate) on Jun 17, 2011 at 15:51 UTC
I don't see how this applies to inserts. Provide an example of what you are trying to do.	[reply]
Re^10: DBI, place holders and CGI forms by Anonymous Monk on Jun 20, 2011 at 08:35 UTC
Re^11: DBI, place holders and CGI forms by Corion (Patriarch) on Jun 20, 2011 at 08:51 UTC
Some notes below your chosen depth have not been shown here