Project

General

Profile

Actions
Copy link

Bug #1688

closed

Plot Query criteria need to be SQL-safe

Added by Michael Lee over 20 years ago. Updated almost 20 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
P. Anderson
Category:
misc
Target version:
UnMilestoned
Start date:
09/14/2004
Due date:
% Done:

0%

Estimated time:
Bugzilla-Id:
1688
Actions
Copy link
 #1

Updated by Michael Lee over 20 years ago

goto http://vegtest.vegbank.org/vegbank/LoadPlotQuery.do and select
"Ed's test" from the project picklist.

Error results, b/c criteria are not made SQL safe (secrutiy!)

error message:
Please correct the following error(s) before proceeding:

  • The database threw the following error "ERROR: syntax error at or near "s"
    " on query "{1}".
Actions
Copy link
 #2

Updated by P. Anderson about 20 years ago

The plot query field values are now made SQL safe by doubling the 'single
quotes' and removing all ; semicolons. This treatment shoud be given to all
vegbank forms.

Actions
Copy link
 #3

Updated by Michael Lee almost 20 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
Copy link
 #4

Updated by Michael Lee almost 20 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
Copy link
 #5

Updated by Redmine Admin almost 12 years ago

Original Bugzilla ID was 1688

Actions
Copy link

Also available in: Atom PDF