my point exactly..... -----Original Message----- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 14 July 2003 15:47 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] UUID (was SQL INSERT INTO)
you need to be careful - MS SQL and CF use different UUID formats. I prefer to create the UUID in SQL - this way my db app is middleware independent and doesn't rely on CF to run, but this is a small point. > -----Original Message----- > From: Jolly Green Giant [mailto:[EMAIL PROTECTED] > Sent: 14 July 2003 15:39 > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] UUID (was SQL INSERT INTO) > > > What do you guys use as your UUID's? the result of the createUUID > function? > > __________/ [EMAIL PROTECTED] \__________ > >I am using an Access DB and am using the INSERT INTO > statemeant to add an > >entry to a table, how do i get the ID for the entry that I have just > >inserted (the Autonumber). I am currently using a second > SELECT query to > >retrieve the field using the values that were inserted, but > this doesn't > >look tidy and has possible problems (integrity and performance), > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
