TIA....Precia
Syntax error in UPDATE statement.
SQL = "UPDATE Vins SET Vin = ?, bottlePrice = ?, boxPrice = ?, Desc = ? WHERE VinID = ?"
Query Parameter Value(s) -
Parameter #1 = Sylvaner
Parameter #2 = 0.00
Parameter #3 = 0.00
Parameter #4 = Vin sec, d�salt�rant, au fruit� discret. C'est le compagnon des mets les plus vari�s tels que les salades, la charcuterie, les tourtes ou les escargots.
Parameter #5 = 1
-------------------------------------------------------
<cfquery datasource="datagoeshere">
UPDATE Vins
SET
Vin = <cfqueryparam value="#form.Vin#" cfsqltype="cf_sql_char">,
bottlePrice = <cfqueryparam value="#trim(form.bottlePrice)#" cfsqltype="CF_SQL_INTEGER">,
boxPrice = <cfqueryparam value="#trim(form.boxPrice)#" cfsqltype="CF_SQL_INTEGER">,
Desc = <cfqueryparam value="#form.desc#" cfsqltype="cf_sql_char">
WHERE
VinID = <cfqueryparam value="#form.VinID#" cfsqltype="CF_SQL_INTEGER">
</cfquery>
---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
