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
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics.
http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
