Man, that looks cold. There's ice floating on the water. BTW I wasn't making fun of your banner earlier with the "I think there should be a CF-programmers-struggling..." comment. I was just reflecting on myself.
> -----Original Message----- > From: Dave Lyons [mailto:[EMAIL PROTECTED] > Sent: Friday, 30 May 2003 5:12 p.m. > To: CF-Talk > Subject: Re: extra eyes on this insert > > yeah I didn't know that they had to be different names. In the example > that > I have it had them listed as the same names, grrr > > but I got it to work. > this was actually for a site that I "accidentally" erased last night & had > to rebuild it in a day. Which is hard for a cf newbie. > but I have gotten a lot of it up, a few more red bulls & whoo hoo!! > > just in case ur interested the ? in this post was in regards to the > fishing > reports at www.rmflyfisher.com. > don't make fun of the banner it was 5am ok > > good thing it is one of my site or i'da been dead meat! > > dave > > > ----- Original Message ----- > From: "Matthew Walker" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, May 30, 2003 12:17 AM > Subject: RE: extra eyes on this insert > > > > How about... > > SELECT max(FRID) AS maxFRID FROM fr > > > > > -----Original Message----- > > > From: Dave Lyons [mailto:[EMAIL PROTECTED] > > > Sent: Friday, 30 May 2003 4:15 p.m. > > > To: CF-Talk > > > Subject: Re: extra eyes on this insert > > > > > > 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
