Amit, I double checked the mail server settings and it looks like it should send your mail. I then looked at your code (very briefly). One thing I noticed immediately was that you seem to have something like this:
<cfoutput query="queryName"> <cfmail from="" to="" etc...> #form.Body# </cfmail> </cfoutput> This *might* be your problem. Take a look at the CFMAIL tag in more detail and you'll discover that you don't need to put <CFMAIL> inside of a <CFOUTPUT> in order to loop it. The CFMAIL tag has it's own "query" attribute. You should be able to do this instead: <cfmail query="queryName" server="mail.acpatel.com" etc...> #form.Body# </cfmail> Check out the following link for more information on the CFMAIL tag: http://livedocs.macromedia.com/cfmxdocs/CFML_Reference/Tags-pt2.jsp#2355015 -Novak ----- Original Message ----- From: "Matthew Walker" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, May 29, 2003 10:20 PM Subject: RE: extra eyes on this insert > 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
