go and have a look at the tag gallery. There's a new custom tag to help
connect mysql database to CF.
Search on mysql.
Paul
> -----Original Message-----
> From: Adam Reynolds [mailto:[EMAIL PROTECTED]]
> Sent: 06 December 2000 11:42
> To: CF-Talk
> Subject: RE: OT: MYSQL
>
>
>
>
> Anybody have experience with this DB?
>
> In particular I'm attempting to insert a new item into a table and
> retrieve the item_id which is defined as an autonumber.
>
> Is there a way of getting this information in MySQL. The other option is
> to create a id table and create a next_id function, but as MySQL does not
> support database transactions and I'm unfamiliar with the intracacies of
> MySQL, I'm curious what people do. I had considered using the LOCK
> command, but I'd prefer an atomic action, rather than locking of the table
> in such a fashion.
>
> Best Regards,
>
> Adam Reynolds
> ColdFusion Web Developer
> ISMG Development, Unilever
> London
>
> ( +44 20 7822 x5450
> m: +44 7973 386620
> * [EMAIL PROTECTED]
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
