Hello cf-talk,
On Tue, 5 Mar 2002, at 17:51:16 you carefully wrote:
WS> I assume all of the fields from mensapparel down, and also saleinfo, are
WS> number fields?
all of the fields from mensapparel down are yes/no boolean
fields in Access.
saletitle is text, salestart/end are dates.
I don't get it, it still looks right.
WS> -----Original Message-----
WS> From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
WS> Sent: 05 March 2002 17:47
WS> To: CF-Talk
WS> Subject: can someone see a problem with this!!!
WS> Hello everyone,
WS> I must be missing something. I keep getting an error "data mismatch in
WS> criteria".
WS> But it looks right to me? What am I missing? I may be looking too
WS> hard.
WS> <cfquery name="UpdateRecord" datasource="os" dbtype="ODBC">
WS> UPDATE stores
WS> SET storename='#Form.storename#',
WS> map='#Form.map#',
WS> description='#Form.description#',
WS> salestart='#Form.salestart#',
WS> saleend='#Form.saleend#',
WS> saleinfo='#Form.saleinfo#',
WS> wwwlink='#Form.wwwlink#',
WS> mensapparel=#Form.mensapparel#,
WS> womensapparel=#Form.womensapparel#,
WS> maternity=#Form.maternity#,
WS> AccessoriesJewelry=#Form.AccessoriesJewelry#,
WS> ChildrenApparel=#Form.ChildrenApparel#,
WS> FoodDrink=#Form.FoodDrink#,
WS> toysgames=#Form.toysgames#,
WS> HomeFurnishings=#Form.HomeFurnishings#,
WS> music=#Form.music#,
WS> Shoes=#Form.Shoes#,
WS> saletitle='#Form.saletitle#'
WS> WHERE storeID=#Variables.RecordID#
WS> </cfquery>
Best regards,
Jeff Fongemie mailto:[EMAIL PROTECTED]
______________________________________________________________________
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=coldfusiona
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
