Bug #956
closedprovide testing Access DB and expected XML output
0%
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
Updated by Gabriel Farrell almost 22 years ago
This plot fails to load at all because of single quotes in some data fields.
Updated by Michael Lee over 21 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.
Updated by Gabriel Farrell over 21 years ago
The file Mike provided loads into the database and can then be read out and
compared to the the expected output he provided.
Updated by Michael Lee over 19 years ago
changed from components that are to be deleted to "misc" so that bugs don't get
deleted with component. Sorry for all the email.