Hello everyone,
I must be missing something. I keep getting an error "data mismatch in
criteria".
But it looks right to me? What am I missing? I may be looking too
hard.
<cfquery name="UpdateRecord" datasource="os" dbtype="ODBC">
UPDATE stores
SET storename='#Form.storename#',
map='#Form.map#',
description='#Form.description#',
salestart='#Form.salestart#',
saleend='#Form.saleend#',
saleinfo='#Form.saleinfo#',
wwwlink='#Form.wwwlink#',
mensapparel=#Form.mensapparel#,
womensapparel=#Form.womensapparel#,
maternity=#Form.maternity#,
AccessoriesJewelry=#Form.AccessoriesJewelry#,
ChildrenApparel=#Form.ChildrenApparel#,
FoodDrink=#Form.FoodDrink#,
toysgames=#Form.toysgames#,
HomeFurnishings=#Form.HomeFurnishings#,
music=#Form.music#,
Shoes=#Form.Shoes#,
saletitle='#Form.saletitle#'
WHERE storeID=#Variables.RecordID#
</cfquery>
Best regards,
Jeff Fongemie mailto:[EMAIL PROTECTED]
_____________________________________________________
Composed on Tuesday, March 05, 2002, at 12:45:05 PM
______________________________________________________________________
Get Your Own 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=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
