>- see footer for list info -< in sql server (t-sql to be precise) you have the convert and cast functions for changing types of data.
You can use cfqueryparam to make sure the data is of the right type before entering it into the database. Does this help? ----- Original Message ----- From: Paul Swingewood To: [email protected] Sent: Wednesday, January 12, 2005 4:19 PM Subject: Re: [CF-Dev] Money! >- 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 -< _______________________________________________ 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 -<
