RE: Escaping Characters in a SQL Statement
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dear all I'm running NT 4 SP5 with CF 4.5.1 SP2, Spectra 1.0.1 and PWS. If I upgrade to Windows 2000 Professional with IIS 5, are there any precautions I should be aware of? I tried searching thru this list and Allaire KB, but found nothing. Thanx. - Loke, Teng-Yan | [EMAIL PROTECTED] | +65-8313547 E-Developer | novaSPRINT.com (S) Pte Ltd -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.8 for non-commercial use http://www.pgp.com iQA/AwUBOwHLrRQsl2B8K+e4EQI2JQCcDqQYrK7VnZbiOSP+jGQFnMty5n8An2Ey q8RekWXQPwv+GYRRg9M4nehQ =UBvw -END PGP SIGNATURE- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Escaping Characters in a SQL Statement
We found that the CF Adv Security services would fail unless upsized from the default Access DBs on Win2k/IIS5.0. Apart from that, things seem to be running smoothly. But, of course, you wouldn't run Adv Security through Access DBs anyway :) Morten O. -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dear all I'm running NT 4 SP5 with CF 4.5.1 SP2, Spectra 1.0.1 and PWS. If I upgrade to Windows 2000 Professional with IIS 5, are there any precautions I should be aware of? I tried searching thru this list and Allaire KB, but found nothing. Thanx. - Loke, Teng-Yan | [EMAIL PROTECTED] | +65-8313547 E-Developer | novaSPRINT.com (S) Pte Ltd -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.8 for non-commercial use http://www.pgp.com iQA/AwUBOwHLrRQsl2B8K+e4EQI2JQCcDqQYrK7VnZbiOSP+jGQFnMty5n8An2Ey q8RekWXQPwv+GYRRg9M4nehQ =UBvw -END PGP SIGNATURE- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Escaping Characters in a SQL Statement
If you want to store store html in a text field in the db, you don't need to do anything if you use the cfquery tag. HTH Dick At 5:28 PM +0800 5/14/01, Teng-Yan Loke wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dear all I have a column in a table which is of type long. After filtering for a set of records from this table, I want to write back this column into the table. This column is known to store HTML code (i.e. web pages). I only know the following characters have to be escaped: '/\. How do I write my SQL update statement such that all the possible nasty characters are escaped? Thanx. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists