Hello Dave, Try renaming ...the second frid....to FFrid they cant be the same name.
Cheers, Mike RAndolph At 12:11 AM 5/30/2003 -0400, you wrote: >i agree I dont think its getting to the insert >I hear what you were saying about the first sql, actually i have tried >adding the other field. I even added * and still the error. So then I tried >this sql ><!--- get last posted subjectID ---> ><cfquery name="qfr" datasource="#dsn#"> >SELECT max(FRID) AS FRID >FROM fr ></cfquery> > >that code "max(fieldID) AS fieldID" >never works for me, lol and it gives me this error >could that be cause its an an autoNumber field? > > Error Executing Database Query. > [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft >Access Driver] Circular reference caused by alias 'FRID' in query >definition's SELECT list. > > >----- Original Message ----- >From: "Mike Randolph" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Thursday, May 29, 2003 11:58 PM >Subject: Re: extra eyes on this insert > > > > Hello Dave, > > > > Are your sure your getting to the insert query? Can you orderby a column > > that is not in your select query? I don't see any glaring issues with the > > insert. 11 fields, 11 updates no missing quotes?? > > > > Kind Regards, > > Mike Randolph > > > > At 11:51 PM 5/29/2003 -0400, you wrote: > > ><cfquery name="qfr" datasource="#dsn#"> > > >SELECT FRID > > >FROM fr > > >ORDER BY subjectID DESC > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4