Project

General

Profile

Bug #956

provide testing Access DB and expected XML output

Added by Michael Lee over 19 years ago. Updated over 17 years ago.

Status:
Resolved
Priority:
Immediate
Category:
misc
Target version:
Start date:
01/16/2003
Due date:
% Done:

0%

Estimated time:
Bugzilla-Id:
956

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

exampleVegBranch.zip (282 KB) exampleVegBranch.zip Michael Lee, 01/28/2003 04:48 PM
dnld__expectedVBr.xml (10.1 KB) dnld__expectedVBr.xml Michael Lee, 01/28/2003 04:49 PM

History

#3 Updated by Gabriel Farrell over 19 years ago

This plot fails to load at all because of single quotes in some data fields.

#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.

#5 Updated by Gabriel Farrell over 19 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.

#6 Updated by Michael Lee over 17 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.

#7 Updated by Redmine Admin over 9 years ago

Original Bugzilla ID was 956

Also available in: Atom PDF