I am beating my head. I am inserting a new category and I am getting an error
saying There are more columns in the INSERT statement than values specified in
the VALUES clause. If I remove the pricePerAd from both the invoke and the
query, it works just fine. Am I missing something here?
<CFINVOKE COMPONENT="components/manageCategories"
METHOD="CommitMainCategory"
CategoryID = "0"
CategoryName = "#Left(form.CategoryName,100)#"
CategoryDescription = "#Left(form.CategoryDescription,59999)#"
CategoryImage = "0"
CatStatus = "1"
CatPos = "#Val(form.NCatPos)#"
PricePerAd = "#Val(PricePerAd)#"
RETURNVARIABLE="thisNewCategoryID">
</CFINVOKE>
<!---:::Function: Commit Main Category --->
<cffunction name="CommitMainCategory" access="public" returntype="numeric"
output="no" hint="Commit Main Category">
<cfargument name="CategoryID" type="numeric" required="yes">
<cfargument name="CategoryName" type="string" required="yes">
<cfargument name="CategoryDescription" type="string" required="yes">
<cfargument name="CategoryImage" type="string" required="yes">
<cfargument name="CatStatus" type="numeric" required="yes">
<cfargument name="CatPos" type="numeric" required="no">
<cfargument name="pricePerAd" type="string" required="No">
<cfset var NewCategoryID = "">
<cfif ARGUMENTS.CategoryID GT 0>
<!--- UPDATE EXISTING CATEGORIES --->
<CFQUERY NAME="NewCategoryID" DATASOURCE="#APPLICATION.DB#"
USERNAME="#APPLICATION.UN#" PASSWORD="#APPLICATION.PW#">
UPDATE #APPLICATION.DBPRE#Categories
SET CategoryName = '#Trim(ARGUMENTS.CategoryName)#',
CategoryDescription = '#Trim(ARGUMENTS.CategoryDescription)#',
CategoryImage = '#Trim(ARGUMENTS.CategoryImage)#',
CatStatus = #Val(ARGUMENTS.CatStatus)#,
pricePerAd = #Val(ARGUMENTS.pricePerAd)#
WHERE CategoryID = #Val(ARGUMENTS.CategoryID)#
</CFQUERY>
<cfset thisNewCategoryID = #Val(ARGUMENTS.CategoryID)#>
<cfelse>
<!--- INSERT NEW --->
<CFQUERY NAME="NewCategoryID" DATASOURCE="#APPLICATION.DB#"
USERNAME="#APPLICATION.UN#" PASSWORD="#APPLICATION.PW#">
SET NOCOUNT ON
INSERT INTO #APPLICATION.DBPRE#Categories
(CategoryName,
CategoryDescription,
CategoryImage,
CatStatus,
CatPos,
PricePerAd)
VALUES
('#Trim(ARGUMENTS.CategoryName)#',
'#Trim(ARGUMENTS.CategoryDescription)#',
'#Trim(ARGUMENTS.CategoryImage)#',
#Val(ARGUMENTS.CatStatus)#,
#Val(ARGUMENTS.CatPos)#),
#Val(ARGUMENTS.pricePerAd)#
Select @@identity as CategoryID
SET NOCOUNT OFF
</CFQUERY>
<cfset thisNewCategoryID = #Val(NewCategoryID.CategoryID)#>
</cfif>
<cfreturn thisNewCategoryID>
</cffunction>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261846
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
