Just as a guess, the value is being passed from a form that has TWO of
the variables listed on the form.
Therefore, the value is getting to this page with both copies,
something like 10,2
which, when inserted in a query, appears to be more than one value.
Either make sure that there is only one, or take the first item off
the list before inserting.
On 11/28/06, Doug Brown <[EMAIL PROTECTED]> wrote:
> 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:261848
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
