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

DATABASE CONNECTION ERROR: 'ifacorpus' has no readable tables

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:
Submission Method POST GET
(switch if there are problems with broken connections)

Select a single record

Information on table field names

Get values from

WHERE (required)
Select: (
 Attributes
 Relation
 Value
 )
 Logical rel.