Bug #956
closed
provide testing Access DB and expected XML output
Added by Michael Lee almost 22 years ago.
Updated almost 20 years ago.
Description
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
Files
This plot fails to load at all because of single quotes in some data fields.
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.
The file Mike provided loads into the database and can then be read out and
compared to the the expected output he provided.
changed from components that are to be deleted to "misc" so that bugs don't get
deleted with component. Sorry for all the email.
Original Bugzilla ID was 956
Also available in: Atom
PDF