RE: Escaping Characters in a SQL Statement

2001-05-16 Thread spectra
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: S

RE: Escaping Characters in a SQL Statement

2001-05-16 Thread Teng-Yan Loke
-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.

Re: Escaping Characters in a SQL Statement

2001-05-14 Thread Dick Applebaum
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 f