#mysql
28 October 2007
Total 17 pages. You are browsing page 17/17.
First :: Prev :: [...] [13] [14] [15] [16] [17] :: Next :: Last
23:26 <****> prakriti, don't go yet
23:26 <****> gnari wants to help you badly
23:27 <****> are you saying that join returns rows if you skip the 2 joins on max_ids?
23:29 <****> prakriti, your problem is the NULLs in street_suffix and street_num_unit
23:30 <****> he is gone, probably
23:30 * chadmaynard thinks so
23:30 <****> someone else will have to explain it to him, i am leaving
23:30 * chadmaynard takes a note
23:30 <****> did he want outer join?
23:30 <****> or was he totally wrong?
23:30 <****> not sure
23:31 <****> I'll look later
23:31 <****> chadmaynard: sorry it took me so long, I wanted to make things very clear: http://pastebin.ca/753060
23:32 <****> the problem is that the rows whose id exist in the max_ids table are not included in the self join because he is joining on NULL values
23:32 <****> probablu he just wants coalesce() in the right places
23:33 <****> Gm4n: which part are you stuck on? SELECT title FROM `updates` WHERE number=(select max(number) from updates or the checkForSearch procedure?
23:33 <****> both, actually :P
23:33 <****> but right now, I can't get the in-trigger CALL work
23:34 <****> am I doing this in the best way?
23:34 <****> chadmaynard: fyi you were right on with --without-server flag. It's comiling now :)
23:34 <****> gogogo :D
23:34 <****> or configuring I should say, not compiling yet :)
23:35 <****> Gm4n: it doesn't call it? do you get an error?
23:36 <****> de1: building mysql is pretty easy. I bet it'll go fine
23:36 <****> I get an error, yes: http://pastebin.ca/753062
23:37 <****> Gm4n: i don't think CALL is right
23:37 <****> where'd you get that syntax?
23:38 <****> let me look (I have 4 windows open, each full of mysql tabs)
23:38 <****> you're correct
23:38 <****> http://dev.mysql.com/doc/refman/5.0/en/call.html
23:38 <****> well that's in a routine though...
23:38 <****> try it without the word call
23:39 <****> error without, also
23:39 <****> http://pastebin.ca/753069
23:40 <****> ok put CALL back.
23:41 <****> chadmaynard: Ya never built it before. I may snoop around the source later, too :). It's compiling now. I just hope it sets up the environment and everything fine so I can compime mysql++ without having to further muck around
23:42 <****> Gm4n: hmmmh.
23:42 <****> hmmh? :P
23:42 <****> that'sm y thoughts
23:42 <****> I've been trying to write this trigger all day :(
23:43 <****> can i have your table schemas? So i can try myself instead of asking you to try everything?
23:43 <****> because I don't know how to do it, but maybe I can figure it out
23:45 <****> sure :)
23:46 <****> may I pm you the schemas?
23:46 <****> Gm4n: sure
23:52 <****> so, i can't find any documentation on using MOD() or %, when I do MOD(2,9), i get a number, but MOD(col,9) gives 0 all the time
23:52 <****> can you use MOD() or % on column values?
23:54 <****> hardcorelamer: you should be able to... as long as that column is an integer type I would think
23:55 <****> doesn't seem to work, int(11) unsigned
23:55 <****> i checked the data
23:57 <****> hardcorelamer: http://pastebin.com/m6085845c
23:58 <****> worksforme(tm)
23:58 <****> which version?
23:59 <****> this is 4.1
--- Log closed Mon Oct 29 00:00:40 2007
Total 17 pages. You are browsing page 17/17.
First :: Prev :: [...] [13] [14] [15] [16] [17] :: Next :: Last