How about the missing comma in the Values part of your query... looks like a temp stored procedure is being created and choking between parameters 10 and 11.
Justin > -----Original Message----- > From: Jen Perkins [mailto:[EMAIL PROTECTED]] > Sent: Thursday, March 14, 2002 2:38 PM > To: CF-Talk > Subject: weird sql error > > I keep getting a really strange sql error and I don't know > what the heck > it's coming from. > > ======================================= > DETAIL: [Microsoft][ODBC SQL Server Driver][SQL Server]Line > 33: Incorrect > syntax near '@P11'. > > SQL = "SET NOCOUNT ON INSERT INTO images ( archiveFlag, > approvalTypeID, > deletedFlag, imageExtensionID, contentTypeID, addedBy, modifiedBy, > dateAdded, dateModified, mediaFilesize, mediaHeight, > mediaWidth, filename, > title, alt, caption) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ?, > ?, ?, ?, ?, ?) > SET NOCOUNT OFF SELECT @@IDENTITY AS newID" > > Query Parameter Value(s) - > Parameter #1 = 0 > Parameter #2 = 10 > Parameter #3 = 0 > Parameter #4 = 0 > Parameter #5 = 112 > Parameter #6 = 100 > Parameter #7 = 100 > Parameter #8 = {ts '2002-03-14 10:51:32'} > Parameter #9 = {ts '2002-03-14 10:51:32'} > Parameter #10 = 153654 > Parameter #11 = 0 > Parameter #12 = 0 > Parameter #13 = 9906-feeding_031402_105132.bmp > Parameter #14 = test > Parameter #15 = > Parameter #16 = > ======================================= > > I've done a cf_dump of all the variable scopes and I can't > figure out where > this @P11 is coming from. Anyone run across something like > this before? > > > > Jen Perkins > Macromedia Certified ColdFusion Developer > Carol/Trevelyan Strategy Group > http://www.ctsg.com/ > > Kumbaya, Dammit! > http://www.kumbayadammit.com/ > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.336 / Virus Database: 188 - Release Date: 3/11/2002 > > ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
