- see footer for list info -<
er.... Ok so im confused...
What convert function..?
From: "Tom Smith" <[EMAIL PROTECTED]> Reply-To: Coldfusion Development <[email protected]> To: "Coldfusion Development" <[email protected]> Subject: Re: [CF-Dev] Money! Date: Wed, 12 Jan 2005 16:13:51 -0000
>- 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 -<
_______________________________________________
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 -<
