Get values from a SINGLE record

A test page for single record access to our database. Allows to extract the values from a single record in any of the tables. Its primary use is in automatic extraction of data (e.g., a the id of a specific chunk of sound).

The form below allows you to construct an SQL Query in the format:

SELECT <attr1>, <attr2>, ... FROM <table> WHERE <cond1> AND/OR <cond2> AND/OR .... ;
For security reasons, these queries are constructed from prescribed choices.

The results of the query is available as a single line of tab delimited text.

Queries

TABLE:
Number of WHERE conditions: 0 ? $NUMBEROFCONDITIONS : 8'>
Submission Method push(@RemoveNames, 'METHOD'); CHECKED if $METHOD eq "POST">POST CHECKED if $METHOD ne "POST">GET
(switch if there are problems with broken connections)

Select a single record

Information on table field names

"$METHOD"" ACTION="getSQLrecord.txt" TARGET="results">

Get values from

WHERE (required)