It could be an Access issue, but double quotes are allowed in queries. It
is single quotes that will give you problems. You may want to run a
function to replace singles quotes with two single quotes, as that will
allow them to be inserted in the database.
What other sorts of issues are you having? I have a script that has been
running every five minutes for over three months to insert messages from
seven newsgroups into a database, and have not had any problems.
Chris Evans
[EMAIL PROTECTED]
http://www.fuseware.com
-----Original Message-----
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 10, 2000 10:13 AM
To: CF-Talk
Subject: Re: CFX_NNTP
> I've used it quite successfully. What sort of problems are you having?
Well, for instance, due to the fact that it pulls message-senders' names
including quotation marks (i.e. "W Luke"), that in turn disrupts a standard
Query to insert those messages into a Database (whether this is an Access
problem, ODBC problem, or any DB I don't know - but AFAIK you can't insert a
field with quotes into a table). I've used the Replace function to strip
the quotation marks, but it doesn't work properly and only strips some of
the names.
What I really need is to create - or bind with - a message board. Any
ideas?
Cheers,
Will
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]