Log message #1110470

# At Username Text
# Oct 22nd 2009, 14:28 dogmatic69 t0nic: put it in the message part
# Oct 22nd 2009, 14:27 FMC dogmatic69: I will thanks
# Oct 22nd 2009, 14:27 t0nic the $validate array defines rules, but I don't think it will do this so I'm checking manually, but I want to make a message show up next to the box, which I don't know how to do without using the validate array
# Oct 22nd 2009, 14:27 dogmatic69 of force join
# Oct 22nd 2009, 14:27 dogmatic69 FMC: seach google for cakephp adhoc join, i think there was something about it
# Oct 22nd 2009, 14:26 t0nic I'd like to put a message next to the tag list/multiselect box
# Oct 22nd 2009, 14:26 FMC Is there a way to force cakePHP to "join" without a hasOne, or without a foreignKey ?
# Oct 22nd 2009, 14:26 t0nic I am going to check that Video has at least one Tag in beforeValidate
# Oct 22nd 2009, 14:25 ADmad $validate is an array like any other.. manipulate it the way you want
# Oct 22nd 2009, 14:25 dogmatic69 t0nic: not following you
# Oct 22nd 2009, 14:25 cpierce dogmatic69: yes ... you are in the cake channel where we help people and you thought you were in the #cakenazi channel
# Oct 22nd 2009, 14:25 t0nic is there a way to set a validation message for a field (before returning false) from beforeValidate?
# Oct 22nd 2009, 14:25 dogmatic69 what happend to $this->paginate();
# Oct 22nd 2009, 14:24 dogmatic69 am i in the wrong chan? whats with all this limist and offsets
# Oct 22nd 2009, 14:23 joeb I always used am($this->params['named'], array('limit' => 10, 'page' => 1)) for my controllers.
# Oct 22nd 2009, 14:21 cpierce limit 20, $currentoffset+20;
# Oct 22nd 2009, 14:21 nicoleG thanks
# Oct 22nd 2009, 14:21 nicoleG great
# Oct 22nd 2009, 14:21 nicoleG mysql 5
# Oct 22nd 2009, 14:21 cpierce yeah just send the variable + 30 or whatever as your offset
# Oct 22nd 2009, 14:21 nicoleG nope,
# Oct 22nd 2009, 14:21 nicoleG between*
# Oct 22nd 2009, 14:21 markstory I hope you're not using old mssql, there is no limit/offset.
# Oct 22nd 2009, 14:21 nicoleG er
# Oct 22nd 2009, 14:21 nicoleG ?
# Oct 22nd 2009, 14:21 nicoleG then i will just need to create the links to paginate below my data chunks/
# Oct 22nd 2009, 14:20 cpierce will do the offset for you
# Oct 22nd 2009, 14:20 cpierce LIMIT 3, 30
# Oct 22nd 2009, 14:20 nicoleG thank you
# Oct 22nd 2009, 14:20 nicoleG i will look in to it :)
# Oct 22nd 2009, 14:20 markstory its good stuff.
# Oct 22nd 2009, 14:20 nicoleG never used OFFSET
# Oct 22nd 2009, 14:20 joeb nicoleG: LIMIT and OFFSET
# Oct 22nd 2009, 14:20 nicoleG yes joeb
# Oct 22nd 2009, 14:19 nicoleG yeah markstory, that makes sense
# Oct 22nd 2009, 14:19 joeb nicoleG: But, it's coming from ->query() ?
# Oct 22nd 2009, 14:19 nicoleG basically yes joeb, that's what i have
# Oct 22nd 2009, 14:19 markstory you are loading 10 million rows into memory and then showing 20.
# Oct 22nd 2009, 14:19 joeb nicoleG: I thought you meant that you had some big static array that you wanted to essentially paginate through.
# Oct 22nd 2009, 14:19 markstory nicoleG: just think if you have 10million rows.
# Oct 22nd 2009, 14:19 nicoleG damn