Thanks all!
----- Original Message ----- From: "Mike Randolph" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, May 30, 2003 12:16 AM Subject: Re: extra eyes on this insert > 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
