Welcome Guest, Not a member yet? Register   Sign In
DB Active Record Class WHERE question
#9

[eluser]rustyvz[/eluser]
I'll give those a shot and see how they work! THANKS!

One thing about escaping data for security reasons: One of the reasons I specifically used the ARC was because of the following note in the user manual for $this->db->where():

Note: All values passed to this function are escaped automatically, producing safer queries.

Nice! Same note for LIKE, SET, UPDATE, DELETE and method chaining!

EDIT: Ok, that worked great! Thanks all!
I wish there WAS a way to use LIKE & ORLIKE as theu are intended to be used though, but with some sort of 'grouping' (not GROUP BY).

I also wonder if I could have used 'having', and just included the whole paren and statement segment in it. Gee, maybe I should test that... :-)


Messages In This Thread
DB Active Record Class WHERE question - by El Forum - 12-05-2007, 05:50 PM
DB Active Record Class WHERE question - by El Forum - 12-05-2007, 07:19 PM
DB Active Record Class WHERE question - by El Forum - 12-05-2007, 07:27 PM
DB Active Record Class WHERE question - by El Forum - 12-05-2007, 07:33 PM
DB Active Record Class WHERE question - by El Forum - 12-05-2007, 07:38 PM
DB Active Record Class WHERE question - by El Forum - 12-05-2007, 07:43 PM
DB Active Record Class WHERE question - by El Forum - 12-05-2007, 07:45 PM
DB Active Record Class WHERE question - by El Forum - 12-05-2007, 08:06 PM
DB Active Record Class WHERE question - by El Forum - 12-06-2007, 09:43 AM



Theme © iAndrew 2016 - Forum software by © MyBB