>- see footer for list info -< would cfqueryparam do what you want?
----- Original Message ----- From: Paul Swingewood To: [email protected] Sent: Wednesday, January 12, 2005 4:01 PM Subject: [CF-Dev] Money! >- see footer for list info -< I have a field in an SQL database of type MONEY I have a form that asks for a selling price. <cfinput type = "text" name = "SellingPrice" required = "Yes"> I then have a query to update the database INSERT INTO tblPropertyDetails (NoBedroomsIDFK, PropertyTypeIDFK, PropertyLocationIDFK, RoadName, Picture, Description1, Description2, Description3, Description4, Description5, Description6, SellingPrice, PostCode, PDFDetails) VALUES ('#form.Select_Bedrooms#', '#form.Select_Type#', '#form.Select_Location#', '#trim(form.RoadName)#', '#smallpic#', '#trim(form.Description1)#', '#trim(form.Description2)#', '#trim(form.Description3)#', '#trim(form.Description4)#', '#trim(form.Description5)#', '#trim(form.Description6)#', '#form.SellingPrice#', '#trim(PostCode)#', '#Details#') I get the following error message. Disallowed implicit conversion from data type varchar to data type money, table 'Taylor Rose.dbo.tblPropertyDetails', column 'SellingPrice'. Use the CONVERT function to run this query. What do I need to do to make the SellingPrice from the form into the correct datatype ..? Regards - Paul _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
