Project

General

Profile

Actions

Bug #956

closed

provide testing Access DB and expected XML output

Added by Michael Lee about 21 years ago. Updated about 19 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


Files

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
Actions #3

Updated by Gabriel Farrell about 21 years ago

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

Actions #4

Updated by Michael Lee about 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.

Actions #5

Updated by Gabriel Farrell about 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.

Actions #6

Updated by Michael Lee about 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.

Actions #7

Updated by Redmine Admin about 11 years ago

Original Bugzilla ID was 956

Actions

Also available in: Atom PDF