| 00:38.05 | *** join/#uphpu timothy_ (n=timothy@c-67-171-118-199.hsd1.ut.comcast.net) |
| 02:14.12 | *** join/#uphpu Utah_Dave (n=boucha@c-67-177-32-125.hsd1.ut.comcast.net) |
| 02:25.19 | *** join/#uphpu Utah_Dav1 (n=boucha@c-67-172-244-155.hsd1.co.comcast.net) |
| 02:31.51 | timothy_ | ~goodnight all |
| 02:31.59 | timothy_ | ~bye all |
| 02:32.01 | jbot | no |
| 02:32.06 | timothy_ | ~later all |
| 02:32.21 | timothy_ | ~seeya all |
| 02:32.27 | timothy_ | ~by all |
| 02:32.34 | timothy_ | anyway.... later guys |
| 02:50.03 | *** join/#uphpu Utah_Dave (n=boucha@c-67-177-32-125.hsd1.ut.comcast.net) |
| 02:53.17 | *** join/#uphpu Utah_Dav2 (n=boucha@c-67-177-32-125.hsd1.ut.comcast.net) |
| 02:53.25 | *** part/#uphpu Utah_Dav2 (n=boucha@c-67-177-32-125.hsd1.ut.comcast.net) |
| 03:21.41 | *** join/#uphpu Utah_Dave (n=boucha@c-67-177-32-125.hsd1.ut.comcast.net) |
| 03:37.57 | *** join/#uphpu beandog (n=sdibb@gentoo/developer/beandog) |
| 03:40.39 | *** join/#uphpu herlo (n=herlo@adsl-75-37-101-105.dsl.chcgil.sbcglobal.net) |
| 03:59.18 | *** join/#uphpu Utah_Dav1 (n=boucha@c-67-177-32-125.hsd1.ut.comcast.net) |
| 07:49.05 | *** join/#uphpu atoponce (i=aaron@tor/regular/atoponce) |
| 10:58.15 | *** join/#uphpu atoponce (i=aaron@tor/regular/atoponce) |
| 13:06.42 | *** join/#uphpu RyanE_ (i=Piadas@rberick.dsl.xmission.com) |
| 13:17.48 | *** part/#uphpu herlo (n=herlo@adsl-75-37-101-105.dsl.chcgil.sbcglobal.net) |
| 13:37.30 | *** join/#uphpu RyanE (i=Piadas@rberick.dsl.xmission.com) |
| 13:38.13 | *** join/#uphpu jsmith (n=jsmith@000-173-309.area3.spcsdns.net) |
| 14:13.16 | *** join/#uphpu atoponce (i=aaron@gateway/gpg-tor/key-0xFC04088F) |
| 14:20.35 | *** join/#uphpu herlo (n=herlo@65.195.245.6) |
| 14:27.12 | *** join/#uphpu Utah_Dave (n=boucha@72-166-51-162.dia.static.qwest.net) |
| 14:29.08 | *** join/#uphpu wps (n=wps@64.72.210.10) |
| 14:29.08 | *** mode/#UPHPU [+o wps] by ChanServ |
| 14:31.10 | *** join/#uphpu _psychic_ (n=_psychic@71.32.228.156) |
| 14:33.04 | *** join/#uphpu bigdog_ut (n=bigdog@208.177.146.102.ptr.us.xo.net) |
| 14:33.04 | *** mode/#UPHPU [+o bigdog_ut] by ChanServ |
| 14:51.27 | *** join/#uphpu mindjuju (n=Administ@65-121-75-195.dia.static.qwest.net) |
| 14:51.41 | mindjuju | join #coldfusion |
| 14:52.20 | bigdog_ut | ~slap mindjuju |
| 14:52.33 | jbot | ACTION slaps mindjuju, keep your grubby fingers to yourself! |
| 14:52.43 | mindjuju | sup yo |
| 14:52.48 | bigdog_ut | nada mucho |
| 14:53.06 | bigdog_ut | about ready to shot active dir |
| 14:53.34 | mindjuju | yeah, active directory blows |
| 14:53.50 | mindjuju | try to stay away from it |
| 14:54.01 | bigdog_ut | it sucks with its crap dns implementation |
| 14:54.49 | mindjuju | was that what you were IMing me about yesterday? |
| 15:02.02 | bigdog_ut | no it was about sql server |
| 15:03.23 | *** join/#uphpu timothy_ (n=timothy@c-67-171-118-199.hsd1.ut.comcast.net) |
| 15:04.45 | mindjuju | sup timothy_ |
| 15:05.01 | timothy_ | sup dude |
| 15:05.13 | timothy_ | dudes and ladies |
| 15:05.21 | timothy_ | :) |
| 15:07.13 | Utah_Dave | sql server bites. Maybe I'm just not used to it, but we're exporting data from it into MySQL so we don't have to try to work too much with sql server |
| 15:09.41 | jsmith | Actually, sql server isn't *that* bad. |
| 15:09.46 | _psychic_ | its worse |
| 15:09.50 | _psychic_ | :P |
| 15:09.52 | jsmith | Sure beats MySQL for a lot of things. |
| 15:10.06 | mindjuju | i'm actually upgrading from SQL 2k to 2k5 |
| 15:13.30 | mindjuju | jsmith, did you see that we are having a lunch of friday? do you think you can go? |
| 15:13.51 | jsmith | mindjuju: I'm in Virginia now... |
| 15:14.04 | mindjuju | like living or consulting? |
| 15:14.09 | jsmith | Living |
| 15:14.30 | mindjuju | what part you in? |
| 15:14.38 | jsmith | Stafford County... |
| 15:14.47 | jsmith | 'bout halfway between DC and Richmond |
| 15:15.05 | mindjuju | nice! loved the drive to DC |
| 15:15.14 | mindjuju | i used to live in Buena Vista, then in Lexington |
| 15:22.38 | *** join/#uphpu bigdog_ut (n=bigdog@208.177.146.102.ptr.us.xo.net) |
| 15:22.38 | *** mode/#UPHPU [+o bigdog_ut] by ChanServ |
| 15:33.18 | *** join/#uphpu atoponce (i=aaron@gateway/gpg-tor/key-0xFC04088F) |
| 15:58.42 | *** join/#uphpu jsmith (n=jsmith@000-173-309.area3.spcsdns.net) |
| 16:24.04 | tierra | just as some advance warning, anyone looking at merchant accounts should avoid Global Payments |
| 16:24.30 | mindjuju | try to go through authorize.net myself if at all possible |
| 16:24.33 | timothy_ | thanks for the heads up |
| 16:24.53 | mindjuju | oh wait, like merchant id or online credit card processing? |
| 16:24.58 | timothy_ | and, might I add, you look very nice today, tierra |
| 16:25.27 | tierra | oh, we do go through authorize.net for our gateway, but authorize.net set us up with Global Payments for our merchant account provider, and I just spent the entire last 2 days fixing their problem |
| 16:25.38 | tierra | timothy_: thanks timothy_ ;) |
| 16:25.47 | mindjuju | oh, that sux |
| 16:26.27 | synic | tierra: seriously, I've worked with cardservices intl., echoecho, intellipay, authorize.net, and a few others and they're all a hassle. |
| 16:26.39 | synic | er... echoinc, not echo echo |
| 16:27.39 | tierra | one of my last calls to GP yesterday about 10 minutes before I had to leave work went something like this: "Hi GP, I'm having problems... I've called 20 times now... I've conferenced in Authorize.net twice now... blah, blah... here's the error code Authorize.net told me they are getting from you..." |
| 16:28.15 | timothy_ | any thoughts on http://itransact.com/ |
| 16:28.23 | bigdog_ut | sucks ass |
| 16:28.27 | tierra | and he puts me on hold for about 15 minutes, then comes back on goes: "Ok, give it another shot... ... ... ok, I see a $5 charge just went through fine... ok, fixed" |
| 16:28.30 | bigdog_ut | sorry for lang but it really does |
| 16:28.43 | timothy_ | itransact does? |
| 16:28.47 | bigdog_ut | yes |
| 16:28.49 | bigdog_ut | very much |
| 16:29.06 | bigdog_ut | it might be okay if integrated in some shopping cart |
| 16:29.09 | timothy_ | who do you guys reccommend? |
| 16:29.10 | bigdog_ut | other than that it sucks |
| 16:29.16 | tierra | turned out to be some stupid mistake on their end that took them 20 calls and 2 days to figure out |
| 16:29.24 | bigdog_ut | ping macnewbold |
| 16:29.32 | timothy_ | sorry tierra |
| 16:29.34 | bigdog_ut | macnewbold, you around? |
| 16:29.35 | macnewbold | pong bigdog_ut |
| 16:29.39 | macnewbold | sup |
| 16:29.42 | mindjuju | yeah, kin of macnewbold is at authorize.net |
| 16:29.43 | macnewbold | how's the dawg today |
| 16:29.46 | macnewbold | ah, yes |
| 16:29.54 | bigdog_ut | what is the command for viewing all records in dns for domain with dig/host |
| 16:30.43 | macnewbold | so tierra, what did they do that screwed it up so bad? |
| 16:31.25 | macnewbold | bigdog_ut: if the DNS server will allow it (often not) it's called a zone transfer |
| 16:31.27 | tierra | all I got was that it was some typo on our account settings that they screwed up... they wouldn't go into detail (meaning it was probably something really stupid) |
| 16:31.33 | macnewbold | in nslookup, it was the ls command |
| 16:31.42 | macnewbold | don't know if dig/host can do it |
| 16:31.51 | macnewbold | but their man pages would probably say |
| 16:31.58 | bigdog_ut | i just want to see all the hosts on that domain is all |
| 16:31.59 | macnewbold | oh, joy, that's great |
| 16:32.13 | bigdog_ut | you told me once...cant remember though |
| 16:32.23 | macnewbold | yeah, that's a zone transfer (i.e. "send me all records" rather than "send me this record") |
| 16:32.55 | macnewbold | aha |
| 16:33.05 | macnewbold | dig -t AXFR domain.com |
| 16:33.12 | macnewbold | that's what you want, bigdog_ut |
| 16:33.38 | macnewbold | many DNS servers will deny it though, unless you're doing it from a host listed as a secondary dns server for the domain |
| 16:33.51 | bigdog_ut | oh it is just one of mine internal |
| 16:34.12 | macnewbold | tierra: was it just out of the blue that it broke, or were you still trying to get it working in the first place? |
| 16:34.30 | bigdog_ut | ty macnewbold that worked |
| 16:34.34 | tierra | na, we had it working fine before |
| 16:34.35 | macnewbold | no problem |
| 16:34.39 | macnewbold | weirdos |
| 16:34.44 | macnewbold | I hate it when stuff like that happens |
| 16:38.20 | tierra | also, have I ever mentioned how much SF.net sucks |
| 16:38.48 | tierra | while I'm on the topic of companies that don't know how to run services... |
| 16:39.12 | mindjuju | SF like salesforce? |
| 16:39.24 | tierra | na, SourceForge |
| 16:39.28 | mindjuju | oh |
| 16:39.32 | tierra | http://sf.net |
| 16:39.45 | mindjuju | yup, get tons of OSS from there |
| 16:39.57 | tierra | (if you didn't know that they have the 2 letter domain name as well) |
| 16:41.20 | tierra | yeah, see, I work on a major piece of OSS hosted there, and have to deal with their crap quite often... |
| 16:41.56 | mindjuju | it's funny you say that, i just saw a comment on SF under a project saying how stupid SF was and to go to the home page |
| 16:42.45 | synic | ok... someone asked this in a linux help channel I'm in: |
| 16:42.46 | synic | 09:25 < ngine> hi all, how do I know that my system is affected with warez? I need to run fsck weekly but I have enough space. |
| 16:42.51 | tierra | http://www.wxwidgets.org/ <- maybe you're more lucky then me, but it's not working for me right now very well (it did pop up once)... |
| 16:42.56 | synic | I'm not really sure what to say. |
| 16:43.43 | mindjuju | i'd prolly say something like that you need to see the "warex" |
| 16:44.20 | synic | cyclone suggested downloading "Norton anti-warez" |
| 16:44.28 | tierra | hehe |
| 16:47.38 | Utah_Dave | tierra: are you part of the wxwidgets project? |
| 16:47.48 | tierra | yeah |
| 16:48.01 | Utah_Dave | cool. |
| 16:48.30 | Utah_Dave | I've used wxPython some. I'm not very good with C++ though |
| 16:48.37 | tierra | been working with wxWidgets for 3 years fulltime now, just kinda worked my way into development |
| 16:49.00 | Utah_Dave | that's cool |
| 16:50.11 | tierra | I'm mostly over the administration of the wxWiki, but do make a number of patches against wxWidgets source on occasion |
| 16:52.19 | timothy_ | me either |
| 16:52.20 | tierra | yeah, that's SF.net for ya... |
| 16:52.30 | tierra | trust me, I'm much more annoyed |
| 16:52.38 | _psychic_ | :/ |
| 16:52.52 | tierra | it happens typically 2-3 times a month |
| 16:52.55 | _psychic_ | geez |
| 16:53.08 | tierra | sometimes more |
| 16:53.13 | bigdog_ut | ~lart ads |
| 16:53.23 | tierra | who knows, I'm not constantly watching it |
| 16:53.55 | _psychic_ | ~lart sf.net |
| 16:54.14 | tierra | that does make me curious to put some uptime script in action to watch when it goes down (or just gives really bad performance, which is almost 50% of the time) |
| 16:55.21 | timothy_ | is ~lart some sort of array of responses and it picks one at random? |
| 16:55.28 | tierra | http://cia.navi.cx/stats/project/wxWidgets <- new logo is here as well as here: http://wxforum.shadonet.com/index.php |
| 16:56.03 | _psychic_ | nice |
| 16:57.10 | macnewbold | timothy_: yep |
| 16:57.11 | macnewbold | :) |
| 16:57.17 | timothy_ | cool |
| 17:31.13 | *** join/#uphpu cyco|w (n=bob@66.114.118.144) |
| 17:36.59 | *** part/#uphpu Utah_Dave (n=boucha@72-166-51-162.dia.static.qwest.net) |
| 17:51.55 | *** join/#uphpu RyanE_ (i=Piadas@rberick.dsl.xmission.com) |
| 17:57.03 | *** join/#uphpu _psychic__ (n=_psychic@71.32.228.156) |
| 18:06.10 | *** join/#uphpu Utah_Dave (n=boucha@72-166-51-162.dia.static.qwest.net) |
| 18:40.40 | *** join/#uphpu atoponce (i=aaron@gateway/gpg-tor/key-0xFC04088F) |
| 19:20.37 | *** join/#uphpu Epilog (n=duckman@217.129.133.207) |
| 19:20.40 | Epilog | hi there |
| 19:20.47 | timothy_ | hello |
| 19:21.09 | Epilog | having some implementation problem |
| 19:21.11 | Epilog | if I have a string like "He&llo World", how do I get the next char after the '&' and replace that '&' with foo ? |
| 19:22.24 | jsmith | Epilog: php.net/strpos and php.net/preg_replace are your friends. |
| 19:23.51 | Epilog | jsmith: yep. I think my main problem will be the regex |
| 19:24.37 | timothy_ | ya, I agree w/ jsmith on that one |
| 19:25.01 | jsmith | $location = strpos("He&llo World","&"); |
| 19:25.30 | jsmith | $new_string = preg_replace('/\&/','foo',"He&llo World"); |
| 19:25.36 | jsmith | That should do it. |
| 19:25.44 | jsmith | If not, take the backslash out of my regex |
| 19:50.57 | wps | jsmith: you get my email about asterisk? |
| 19:51.14 | jsmith | wps: Nope... |
| 19:51.58 | wps | sent to hacking@jaredsmith.net |
| 19:52.04 | wps | not using that address anymore? |
| 19:52.14 | wps | (sorry… shouldn't have posted it in here) |
| 19:53.14 | jsmith | No, that's cool... |
| 19:53.19 | jsmith | Just gotta remember to check that account |
| 19:54.08 | Epilog | jsmith: did a similar approach, since I needed to extrach the accesskey |
| 19:54.39 | Epilog | str_pos, $accesskey{str_pos+1}, str_replace(&+accesskey, foo) |
| 19:55.16 | Epilog | is there any good web pratice for the accesskey keys? |
| 19:58.26 | *** join/#uphpu atoponce (i=aaron@gateway/gpg-tor/key-0xFC04088F) |
| 20:04.01 | *** part/#uphpu Utah_Dave (n=boucha@72-166-51-162.dia.static.qwest.net) |
| 20:06.14 | Epilog | time for dinner |
| 20:06.23 | Epilog | cya and thks for the help |
| 20:07.02 | *** join/#uphpu bigdog_ut (n=bigdog@208.177.146.102.ptr.us.xo.net) |
| 20:07.02 | *** mode/#UPHPU [+o bigdog_ut] by ChanServ |
| 20:10.19 | *** join/#uphpu atoponce (i=aaron@gateway/gpg-tor/key-0xFC04088F) |
| 20:15.46 | bigdog_ut | man everyone is so quiet |
| 20:15.58 | jsmith | Yup |
| 20:18.07 | bigdog_ut | whatz up jsmith ? |
| 20:21.20 | jsmith | Trying to brick^H^H^Hupdate the firmware on my new phone. |
| 20:21.32 | jsmith | Then I've gotta put some shoes and socks on and go unload my new grill |
| 20:21.42 | jsmith | What an awful life... |
| 20:22.00 | *** join/#uphpu Utah_Dave (n=boucha@72-166-51-162.dia.static.qwest.net) |
| 20:22.22 | bigdog_ut | yeah very awful |
| 20:22.41 | jsmith | Yay! It worked! |
| 20:22.48 | jsmith | My phone didn't brick! |
| 20:25.43 | *** join/#uphpu jnbek (n=jnbek@c-24-10-178-17.hsd1.ut.comcast.net) |
| 20:30.31 | bigdog_ut | lol |
| 20:33.06 | *** join/#uphpu herlo (n=herlo@65.195.245.6) |
| 20:33.17 | jsmith | -lart herlo |
| 20:33.26 | jsmith | ~lart herlo |
| 20:34.14 | herlo | ~lart jsmith |
| 20:34.19 | herlo | ~monkey jsmith |
| 20:34.29 | jbot | ACTION flings poo at jsmith |
| 20:35.42 | jsmith | herlo: Fine! See if I ever send you your swag! |
| 20:50.24 | mindjuju | ~monkey everybody |
| 20:50.28 | jbot | ACTION flings poo at everybody |
| 20:50.53 | *** part/#uphpu Utah_Dave (n=boucha@72-166-51-162.dia.static.qwest.net) |
| 20:53.12 | *** join/#uphpu Utah_Dave (n=boucha@72-166-51-162.dia.static.qwest.net) |
| 20:57.04 | herlo | jsmith: I am hurt |
| 20:57.13 | herlo | :-$ |
| 20:57.53 | herlo | jsmith: come on man, I am an angel and you know it... O:-) |
| 20:59.21 | Utah_Dave | jsmith: I'll take herlo's swag now that you don't like him! :) |
| 21:05.06 | jsmith | herlo: To be honest, I've just gotta find it... It's in my box of stuff that got lost in the move. |
| 21:06.51 | Utah_Dave | Dell sent someone to my office today to replace the motherboard on my laptop because sometimes it wouldn't start up and the wireless card would mysteriously disappear. |
| 21:06.59 | Utah_Dave | That all works great now. |
| 21:07.18 | Utah_Dave | Except now the headphone jack doesn't work. I can't listen to music while I work!!!!!! |
| 21:07.38 | macnewbold | call them back :) |
| 21:07.40 | Utah_Dave | now they have send somebody out again tomorrow |
| 21:08.07 | Utah_Dave | I'm in a chat session right now with them. |
| 21:08.17 | mindjuju | is there a SQL command that will tell you what ver your using |
| 21:08.26 | macnewbold | "quit;" |
| 21:08.27 | Utah_Dave | the stupid thing is that the computer speakers work |
| 21:08.36 | macnewbold | in mysql, you can use \v or \s or something |
| 21:08.40 | Utah_Dave | for MySQL? |
| 21:08.49 | macnewbold | but mindjuju uses MSSQL |
| 21:08.52 | mindjuju | yup mysql |
| 21:08.54 | macnewbold | ~boo MSSQL |
| 21:08.56 | jbot | Boo! Hiss! MSSQL is pure filth! Boo! |
| 21:09.07 | mindjuju | nope, doing pro bono work so i'm on godaddy hosting |
| 21:09.27 | macnewbold | nice |
| 21:09.42 | mindjuju | all i have is a majorly stripped down version of phpmyadmin and from the looks of it, it's prolly the first release of myadmin |
| 21:10.02 | macnewbold | then you could take advantage of the security holes in it to add a real version :) |
| 21:10.05 | Utah_Dave | SELECT Version(); |
| 21:10.09 | jsmith | mindjuju: I think MSSQL has a stored procedure you can call to get it. |
| 21:10.36 | Utah_Dave | you're using MySQL, right mindjuju? |
| 21:10.45 | mindjuju | k, that was it. ver 4.0.27 |
| 21:11.08 | mindjuju | jsmith, yup, i think that sproc is sysinfo or something near that |
| 21:11.32 | jsmith | I don't remember -- it's been too long |
| 21:12.19 | mindjuju | k, i should be able to say this, right? |
| 21:13.20 | mindjuju | INSERT INTO tbl_example |
| 21:13.20 | mindjuju | (fld_one, fld_two) |
| 21:13.20 | mindjuju | VALUES |
| 21:13.20 | mindjuju | (1,2) Select @@Identity as somevarname |
| 21:16.51 | macnewbold | what's that last part after the two values? |
| 21:16.51 | Utah_Dave | are you trying to do an INSERT... SELECT... ? |
| 21:16.51 | mindjuju | if the tbl_example is set to autoincrement and I need the number that mysql generated i use the select @@identity |
| 21:16.51 | mindjuju | don't i? |
| 21:16.51 | Utah_Dave | no |
| 21:16.52 | Utah_Dave | just a sec |
| 21:17.34 | Utah_Dave | mysql_insert_id() |
| 21:18.04 | macnewbold | yes, insert id is the way |
| 21:18.16 | macnewbold | you've been using that mssql crap way too long, mindjuju :) |
| 21:18.28 | Utah_Dave | amen macnewbold |
| 21:19.09 | herlo | jsmith: I am sure you lost it in the move....It's okay, since I never had it anyway, I am not in a big rush. |
| 21:19.14 | mindjuju | weird, cause this page says it exists |
| 21:19.14 | mindjuju | http://dev.mysql.com/doc/refman/4.1/en/set-option.html |
| 21:19.19 | mindjuju | but i'll do it ya'lls wway |
| 21:19.23 | herlo | jsmith: but thanks for thinking of me |
| 21:20.00 | macnewbold | wow, weird |
| 21:20.22 | macnewbold | you'd probably have to do a select though to get the mysql variable back as a query result to put it into a php variable |
| 21:33.11 | *** join/#uphpu atoponce (i=aaron@gateway/gpg-tor/key-0xFC04088F) |
| 21:45.57 | mindjuju | the mysql_insert_id() seems to be the PHP function. it looks like if I want to call the identity within mysql, i have to use LAST_INSERT_ID(), right? |
| 21:58.56 | macnewbold | mindjuju: yes |
| 22:26.24 | mindjuju | ugh, this is getting crazy weird |
| 22:27.34 | mindjuju | so it seems that i can't pull the last id generated within the same connection, i have to close and open a new connection to use SELECT Last_Insert_ID(). at that point, is there any guarantee that the last record you inserted is the id your getting now in the case of 2 people signing up at the same time? |
| 22:28.16 | timothy_ | dude, I do this all the time. |
| 22:28.26 | timothy_ | after the mysql_query($sql); |
| 22:28.43 | timothy_ | do $id = mysql_insert_id(); |
| 22:29.22 | timothy_ | have you tried that? does it work? |
| 22:29.32 | mindjuju | yeah, those are php commands, i'm not using php in this case |
| 22:29.37 | mindjuju | so need to stick with mysql commands |
| 22:29.53 | timothy_ | oh, sorry dude |
| 22:30.01 | mindjuju | nah, no worries, it is a PHP channel |
| 22:30.04 | timothy_ | that's what I get for not paying attention |
| 22:30.19 | mindjuju | nah, like i said, it's a php channel, it should be fairly safe to assume in here |
| 22:30.25 | timothy_ | ya |
| 22:30.29 | mindjuju | thx anyways |
| 22:30.33 | timothy_ | what are you using? |
| 22:30.34 | timothy_ | np |
| 22:30.58 | mindjuju | remember this is a pro bono project for somebody -- CF and MySQL |
| 22:31.08 | timothy_ | ah |
| 22:36.05 | mindjuju | k, this is starting to go twilight zone time. i take the query i've been using, feed it into phpmyadmin, and it works. issue must be with CF |
| 22:36.26 | mindjuju | well, not the select @@identity, the last_insert_ID |
| 22:37.40 | *** part/#uphpu Utah_Dave (n=boucha@72-166-51-162.dia.static.qwest.net) |
| 23:13.41 | *** join/#uphpu herlo (n=herlo@adsl-75-37-101-105.dsl.chcgil.sbcglobal.net) |
| 23:16.09 | timothy_ | later dudes |
| 23:16.28 | xilch|w | later ted |
| 23:18.17 | xilch|w | mindjuju: mysql has a function called LAST_INSERT_ID() |
| 23:18.22 | xilch|w | have you tried that? |
| 23:19.16 | mindjuju | yeah, i got it to work |
| 23:19.22 | mindjuju | that's what i used |
| 23:19.24 | xilch|w | I don't know how much transparency coldfusion gives to to the db interface, but if it allows plain mysql commands, that should work |
| 23:19.28 | xilch|w | woot |
| 23:20.00 | mindjuju | yeah, i was worried though that if it didn't occur in the same sql session, it might just spit back the last ID not necessarily the one that the session created |
| 23:20.32 | mindjuju | it seems like they have allowance for this instance, so i *think* i'm ok |
| 23:20.55 | xilch|w | It should work within the same session |
| 23:21.09 | mindjuju | tried it |
| 23:21.27 | xilch|w | even if another session adds a row befor you call it, it should return the last id for that session |
| 23:22.25 | xilch|w | sounds like you know what you are doing |
| 23:22.47 | mindjuju | here's to hoping... i got too used to MS SQL's identity |
| 23:22.56 | mindjuju | but seems like oracle has it too |
| 23:23.41 | mindjuju | xilch|w, do you do CF also? |
| 23:23.42 | xilch|w | it will keep the the ids separate for each session for sure |
| 23:24.08 | xilch|w | mindjuju: I messed with CF back in like, '01 or '02 |
| 23:24.16 | xilch|w | I don't remember a thing about it |
| 23:24.34 | xilch|w | way back when it was brand new |
| 23:25.21 | mindjuju | it's not a bad language, but it VERY clearly illustrates one of Bigdog_ut's arguements on PHP. because the language is sooo easy, you get a lot of people slopping code around |
| 23:25.39 | mindjuju | it can be dangerous in that regard |
| 23:25.56 | xilch|w | heh, in my experience, nothing can save you from sloppy code |
| 23:26.27 | xilch|w | I even infect myself with it - I don't even need help from say, synic |
| 23:26.49 | mindjuju | lol |