added one to the result.
If you haven't already, make sure that you have an unique index (key) on the
intNewsID column. If it's your primary key, then why aren't you using
MySQL's AUTO_INCREMENT column type? It will automatically handle making
unique primary keys for you.
Create table tblNews (
intNewsID int unsigned not null auto_increment,
...,
primary key (intNewsID)
);
Cheers,
barneyb
> -----Original Message-----
> From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 06, 2004 8:21 AM
> To: CF-Talk
> Subject: Re: CF_MAX_ID - MySQL slowww
>
> Spectrum WebDesign said:
> >
> > <!---get MaxID form DB--->
> > <cfloop condition="true">
> > <cftry>
> > <cftransaction>
> > <cf_max_ID
> > datasource="#dsn#"
> > tablename="tblNews"
> > primarykey="intNewsID">
>
> It would help if we had the code for cf_max_id and if you placed some
> timers for the different sections.
>
> Jochem
>
>
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
