Hi, what exactly does cfqueryparam do ??? If I'm not wrong, it can convert data input from form fields, into data type on sql. For example data input from form fields is always in string, we can convert it to data type of money for example ??? Examples would be helpful.
Thanks... ----- Original Message ----- From: "JAIME HOI" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, November 20, 2001 3:08 PM Subject: RE: How to save single quotes into DB > hey u r rite!!! i was using Evaluate on my form variable, No wonder it > didn't work. Now i understand. Thanks Pascal! > > > -----Original Message----- > > From: Pascal Peters [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, November 20, 2001 4:07 PM > > To: CF-Talk > > Subject: RE: How to save single quotes into DB > > > > > > It always work automatically, even with form variables. The > > only problem > > might be when you use Evaluate() for dynamic variable names. Then the > > single quotes don't get escaped. > > Anyway, you should really use <cfqueryparam> to avoid all these > > problems. > > > > INSERT INTO TBL (NAME) > > VALUES (<cfqueryparam cfsqltype="CF_SQL_VARCHAR" > > value="#form.myfield#">) > > > > Pascal Peters > > Macromedia Certified Instructor > > Certified ColdFusion (5.0) Advanced Developer > > Certified Web Developer > > LR Technologies, Belgium > > Tel +32 2 639 68 70 > > Fax +32 2 639 68 99 > > Email [EMAIL PROTECTED] > > Web www.lrt.be > > > > > > -----Original Message----- > > From: JAIME HOI [mailto:[EMAIL PROTECTED]] > > Sent: dinsdag 20 november 2001 4:50 > > To: CF-Talk > > Subject: RE: How to save single quotes into DB > > > > > > thanks! but then i juz realise that Coldfusion will > > automatically > > handle this part ONLY IF i do not use the form variable > > directly. I need > > to > > assign that form variable to another variable before setting > > it into DB. > > Then it works automatically. ! > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com 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
