| 00:17.29 | *** join/#uphpu _psychic_ (n=_psychic@c-24-2-78-210.hsd1.ut.comcast.net) |
| 01:26.31 | *** join/#uphpu wps (n=wps@65.73.113.162) |
| 01:26.32 | *** mode/#uphpu [+o wps] by ChanServ |
| 01:41.58 | *** join/#uphpu diskotec|w (n=UN@12.125.156.114) |
| 01:51.24 | *** join/#uphpu Utah_Dave (n=boucha@c-67-166-71-219.hsd1.ut.comcast.net) |
| 02:08.22 | *** join/#uphpu bigdog_ut (n=bigdog@207.135.132.13) |
| 02:08.22 | *** mode/#uphpu [+o bigdog_ut] by ChanServ |
| 02:29.03 | *** part/#uphpu Utah_Dave (n=boucha@c-67-166-71-219.hsd1.ut.comcast.net) |
| 02:33.22 | *** join/#uphpu cycokilr (n=cycokilr@71-35-219-179.slkc.qwest.net) |
| 12:43.49 | *** join/#uphpu Utah_Dave (n=boucha@0-2pool130-195.nas28.salt-lake-city1.ut.us.da.qwest.net) |
| 12:59.34 | *** join/#uphpu Utah_Dav1 (n=boucha@0-1pool139-165.nas28.salt-lake-city1.ut.us.da.qwest.net) |
| 14:02.30 | *** join/#uphpu wps (n=wps@64.72.210.10) |
| 14:02.30 | *** mode/#uphpu [+o wps] by ChanServ |
| 14:43.54 | *** part/#uphpu Utah_Dav1 (n=boucha@0-1pool139-165.nas28.salt-lake-city1.ut.us.da.qwest.net) |
| 14:44.46 | *** join/#uphpu Utah_Dave (n=boucha@0-1pool139-165.nas28.salt-lake-city1.ut.us.da.qwest.net) |
| 14:53.26 | *** join/#uphpu _psychic_ (n=_psychic@71.32.228.156) |
| 15:18.21 | *** join/#uphpu jakea (n=jakea@128.187.164.63) |
| 16:08.12 | *** join/#uphpu _psychic_ (n=_psychic@71.32.228.156) |
| 16:23.47 | *** join/#uphpu mindjuju (n=Administ@216.20.238.225) |
| 16:24.48 | mindjuju | ugh! can't think straight, have to finish this app! anybody remember how to do a query, and bring in the first result it encounters. at this point, doesn't matter a hoot which record it brings first, as long as it is just 1 record |
| 16:25.26 | Utah_Dave | LIMIT 1 ? |
| 16:29.06 | _psychic_ | alas |
| 16:29.30 | mindjuju | though i do use mysql on occassion, limit is not part of ms sql and i was trying to think of the stupidest t-sql tag i could think of to limit it to 1 |
| 16:29.39 | mindjuju | turns out it was top 1 |
| 16:29.49 | Utah_Dave | mysql_fetch_row |
| 16:30.03 | Utah_Dave | gets one item from a resultset |
| 16:30.04 | mindjuju | thnx gents! |
| 16:30.12 | Utah_Dave | mysql_fetch_object |
| 16:30.15 | Utah_Dave | mysql_fetch_array |
| 16:31.06 | Utah_Dave | I think that whole series pull one object from the result set. You can do a WHILE loop over that resultset and do mysql_fetch_row for each item |
| 16:32.24 | Utah_Dave | Oh, sorry mindjuju. I didn't read your last post before responding! |
| 16:32.36 | _psychic_ | hehe |
| 16:33.05 | Utah_Dave | I'm sorry about the MS SQL as well. I had to use it for part of a recent project and it hurt |
| 16:33.09 | Utah_Dave | :) |
| 16:35.13 | *** join/#uphpu herlo (n=herlo@64-205-130-223.client.dsl.net) |
| 17:14.05 | *** join/#uphpu fungus (n=fungus@2001:470:1f00:645:20a:95ff:fec5:636a) |
| 20:41.27 | *** join/#uphpu RyanE_ (n=ryan@rberick.dsl.xmission.com) |
| 21:05.52 | *** join/#uphpu lampous__ (n=lampous@63-226-108-67.slkc.qwest.net) |
| 21:05.56 | *** part/#uphpu lampous__ (n=lampous@63-226-108-67.slkc.qwest.net) |
| 21:40.03 | *** part/#uphpu Utah_Dave (n=boucha@0-1pool139-165.nas28.salt-lake-city1.ut.us.da.qwest.net) |
| 21:48.52 | *** join/#uphpu Utah_Dave (n=boucha@0-1pool139-165.nas28.salt-lake-city1.ut.us.da.qwest.net) |
| 22:22.00 | *** join/#uphpu RyanE (n=ryan@rberick.dsl.xmission.com) |
| 22:31.04 | *** part/#uphpu Utah_Dave (n=boucha@0-1pool139-165.nas28.salt-lake-city1.ut.us.da.qwest.net) |
| 23:06.46 | *** join/#uphpu fungus (n=fungus@2001:470:1f00:645:20a:95ff:fec5:636a) |