Check your query again. The number of columns your inserting into is not the same number of values your passing. a query like so would cause this error. Notice I'm trying to insert into d, but not passing a value to insert.
insert into a, b, c, d values #a#, #b#, #c# emmet On Fri, Nov 14, 2008 at 5:43 PM, Connie Works <[EMAIL PROTECTED]> wrote: > Jim, > > Thanks for the suggestion. The error message I am now getting is "Error > Executing Database Query. > [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft > Access Driver] Number of query values and destination fields are not the > same." > > I've checked my fields and their names and everything seems corrected. > > > Connie Works > Business Systems Specialist > Center for University Teaching, Learning, and Assessment > Building 53/Room 207 > University of West Florida > Pensacola, Florida 32514 > Telephone: 1-850-474-3080; FAX: 1-850-857-6331 > http://uwf.edu/cutla > > > -----Original Message----- > From: Jim Schell [mailto:[EMAIL PROTECTED] > Sent: Friday, November 14, 2008 3:43 PM > To: cf-newbie > Subject: RE: cfquery error > > Connie, > > When I ran into this it was because the script doing the file upload was > taking to long. > > > Here is a link to show you how to turn off IE friendly error messages so > you > can see the real root error. > > http://www.communitymx.com/content/article.cfm?cid=A66B8 > > I would ask your ISP about the time out property when you are inserting > data. > > Jim > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4162 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
