Give this a shot <cfquery name="loadExtraImgs" datasource="#request.datasource#"> INSERT INTO Consumer_ProductExtraImgs ( Cnsmr_ProductID, expandedImgID, ExpandedImg1, ExpandedImg2, ExpandedImg3, ExpandedImg4, ExpandedImg5, ExpandedImg6, ExpandedImg7, ExpandedImg8, DescriptionforExpandedImg1, DescriptionforExpandedImg2, DescriptionforExpandedImg3, DescriptionforExpandedImg4, DescriptionforExpandedImg5, DescriptionforExpandedImg6, DescriptionforExpandedImg7, DescriptionforExpandedImg8 ) VALUES ( <cfqueryparam value="#Session.ExtraProductImgName#" cfsqltype="CF_SQL_VARCHAR">, <cfqueryparam value="#expandedImgID#" cfsqltype="CF_SQL_VARCHAR">, <cfqueryparam value="#filename1#" cfsqltype="CF_SQL_VARCHAR">, <cfqueryparam value="#filename2#" cfsqltype="CF_SQL_VARCHAR">, <cfqueryparam value="#filename3#" cfsqltype="CF_SQL_VARCHAR">, <cfqueryparam value="#filename4#" cfsqltype="CF_SQL_VARCHAR">, <cfqueryparam value="#filename5#" cfsqltype="CF_SQL_VARCHAR">, <cfqueryparam value="#filename6#" cfsqltype="CF_SQL_VARCHAR">, <cfqueryparam value="#filename7#" cfsqltype="CF_SQL_VARCHAR">, <cfqueryparam value="#filename8#" cfsqltype="CF_SQL_VARCHAR">, <cfqueryparam value="" cfsqltype="CF_SQL_VARCHAR">, <cfqueryparam value="" cfsqltype="CF_SQL_VARCHAR">, <cfqueryparam value="" cfsqltype="CF_SQL_VARCHAR">, <cfqueryparam value="" cfsqltype="CF_SQL_VARCHAR">, <cfqueryparam value="" cfsqltype="CF_SQL_VARCHAR">, <cfqueryparam value="" cfsqltype="CF_SQL_VARCHAR">, <cfqueryparam value="" cfsqltype="CF_SQL_VARCHAR">, <cfqueryparam value="" cfsqltype="CF_SQL_VARCHAR"> ) </cfquery>
On Thu, Apr 23, 2009 at 3:27 PM, Chuck <[email protected]> wrote: > > Start by removing the () from around your variables. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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-talk/message.cfm/messageid:321914 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
