this is what i get
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.
The Error Occurred in
C:\Websites\mysites\mysite\rmfly3\reports\add.fishing.report.process.cfm:
line 26
24 : </cfquery>
25 :
26 : <!--- finalize insert --->
27 : <cfquery name="qifr" datasource="#dsn#">
28 : INSERT INTO fr (FRarea,
--------------------------------------------------------------------------
SQL SELECT max(FRID) AS FRID FROM fr
DATASOURCE rmfly2
VENDORERRORCODE -3005
SQLSTATE HY000
----- Original Message -----
From: "Dave Watts" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 30, 2003 12:07 AM
Subject: RE: extra eyes on this insert
> > this sems like it should work but i just cant find the error,
> > i keep getting is this
> > [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC
> > Microsoft Access Driver] Too few parameters. Expected 1.
> >
> > I checked the reserved db names but I just cant find it. I
> > even did a standard db insert just to see and still got the
> > same error.
>
> You might find it useful to enable debugging and look at the actual SQL
> statement sent to the database. This'll typically show you the error. For
> example, you may have a comma within one of the unquoted values sent from
> your form.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
