Try using QUOTE function.
Asif Iqbal wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi All
I have been using mysql database to collect my syslog data. It was
working fine. However recently I had few logs that had apotrophe and I
failed to insert those lines into my database. It said syntax
Man I have been banging away at this for a week and I am only just
getting to a point where I am finding a resolution. There seems to be a
lot of info out there for this kind of thing, but very little on how to
implement it.
I use ASP and VBScript with Macromedia Dreamweaver so with asp I can
I don't use ASP and VBScript with Macromedia Dreamweaver, but I think
the problem here is that you've misunderstood what is needed, rather
than that Dreamweaver's escaping mechanism doesn't work. Let me try to
explain. Mysql has no trouble with apostrophes in the data. The
problem comes
msg.pgp
Description: PGP message
At 20:39 -0500 1/7/04, Asif Iqbal wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi All
I have been using mysql database to collect my syslog data. It was
working fine. However recently I had few logs that had apotrophe and I
failed to insert those lines into my database. It said syntax
msg.pgp
Description: PGP message
At 21:35 -0500 1/7/04, Asif Iqbal wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Paul DuBois wrote:
At 20:39 -0500 1/7/04, Asif Iqbal wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi All
I have been using mysql database to collect my syslog data. It was
working fine. However
msg.pgp
Description: PGP message
At 22:30 -0500 1/7/04, Asif Iqbal wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Paul DuBois wrote:
At 21:35 -0500 1/7/04, Asif Iqbal wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Paul DuBois wrote:
At 20:39 -0500 1/7/04, Asif Iqbal wrote:
-BEGIN PGP SIGNED MESSAGE-