provide testing Access DB and expected XML output
provide Gabe with VegBranch export db and the expected XML that should result
from its being loading and downloaded.
email, 16 Jan 2003 11:14:24 -0800
#4 Updated by Michael Lee over 19 years ago
Gabe, I've come across this with SQL statements in Access and I solve the
problem by searching for single quotes (') and replacing with 2 single quotes
(''). The Access SQL interpreter then replaces the '' with ' when inserting the
data. For example:
INSERT INTO temptbl (tempfld) SELECT 'This is the ''way'' it is';
inserts the string:
This is the 'way' it is
Not sure if this is helpful, but I thought I'd give it a shot.