RE: MAX function problem

Thanks this solved the problem. Sal >From: [EMAIL PROTECTED] (Scott Brader) >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: RE: MAX function problem >Date: Wed, 29 May 2002 12:34:21 -0500 > >I believe you should word your query as > >SELE

Re: MAX function problem

Try: SELECT MAX(ID) AS TheID FROM UserInfo Please tell me that this query is within a transaction, and that you're only doing this because you're using Access. - Original Message - From: S R <[EMAIL PROTECTED]> Date: Wednesday, May 29, 2002 11:28 am Subject: MAX function problem >

RE: MAX function problem

I believe you should word your query as SELECT MAX(ID) AS TheID FROM UserInfo Scott Brader Prairie Software Development LLC 101 East Sadd Street PO Box 235 North Prairie, WI 53153-0235 Phone: 262.392.9173 Fax: 262.392.9174 Toll Free: 888.821.3427 Mobile: 262.490.1376

RE: MAX function problem

SELECT MAX(ID) AS TheID FROM UserInfo Use the above SQL instead. -Matt > -Original Message- > From: S R [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 29, 2002 10:28 AM > To: CF-Talk > Subject: MAX function problem > > Hello, > > Everytime I use this function I have problems. My co

Re: MAX function problem

Try: SELECT MAX(ID) AS TheID FROM UserInfo HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server >>> Find out how iMS Stacks up to the competition: >http://w

RE: MAX function problem

The problem is that your As TheID needs to appear immediately after Max(ID) like so: SELECT MAX(ID) AS TheID FROM UserInfo The way you have it actually is renaming the table not the result. -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 10:28 AM To

Re: MAX function problem

Thanks, it worked. I've been staring at the screen too long and I had the sql statement backwards. Thanks again. Sal >From: <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: Re: MAX function problem >Date: Wed, 1

Re: MAX function problem

Try: SELECT MAX(ID) as MAXID FROM ContactInfo Regards, Pardeep. - Original Message - From: "S R" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, March 13, 2002 2:08 PM Subject: MAX function problem > I keep getting an error resolving parameter MAXID when I

RE: MAX function problem

Try: SELECT MAX(ID) AS MAXID FROM ContactInfo Thanks, Jason Larson "You think the Cubs have sore arms? What about the fans in left field?" -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 3:08 PM To: CF-Talk Subject: MAX function problem