%
java.io.FileInputStream propFile = new java.io.FileInputStream("C:\\coinprops");
java.util.Properties p = new java.util.Properties(System.getProperties());
p.load(propFile);
System.setProperties(p);
propFile.close();
%>
| Query | |
| Registry Directory | |
| Spec File Type | xml text |
| Log | on off |
Sample Queries to test:
(Click on copy button to copy
the query above and edit it if you wish.
You can click on Quick Run
without copying anything to run the example query as it is.
|
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Select country, capital, coordinates, totalarea, population, telephone, GDP from cia2 where country="Papua New Guinea"
|
cia2.xml | CIA | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Select country, capital, coordinates, totalarea, population, telephone, GDP from cia2 where
country="Papua New Guinea" union Select country, capital, coordinates, totalarea, population, telephone, GDP from cia2 where country="Afghanistan" |
cia2.xml | CIA | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Select cia2.country, cia2.capital, cia2.coordinates, cia2.totalarea, cia2.population, cia2.telephone, cia2.GDP, cia2.currency, hzoanda.rate from cia2, hzoanda where cia2.country="Papua New Guinea" and hzoanda.exchanged=cia2.currency and hzoanda.expressed="USD" and hzoanda.date="07/29/2003" |
cia2.xml, hzoanda.xml | CIA, OandA | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Select cia2.country, cia2.capital, cia2.coordinates, cia2.totalarea, cia2.population, cia2.telephone, cia2.GDP, cia2.currency, hzoanda.rate from cia2, hzoanda where cia2.country="Papua New Guinea" and hzoanda.exchanged=cia2.currency and hzoanda.expressed="USD" and hzoanda.date="07/29/2003" union Select cia2.country, cia2.capital, cia2.coordinates, cia2.totalarea, cia2.population, cia2.telephone, cia2.GDP, cia2.currency, hzoanda.rate from cia2, hzoanda where cia2.country="Afghanistan" and hzoanda.exchanged=cia2.currency and hzoanda.expressed="USD" and hzoanda.date="07/29/2003" |
cia2.xml, hzoanda.xml | CIA, OandA | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Select Ticker, Headlines From quicken where Ticker="IBM"
|
quicken.xml | Quicken | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Select exchanged, expressed, date, rate From hzoanda where
date="01/04/2002" and exchanged="USD" and expressed="EUR"
|
hzoanda.xml | OandA | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Select Date1, Date2, Airline, Price from expedia2 where Destination="SFO" and Departure="BOS" and Date1="9/12/03" and Date2="10/12/03"
|
expedia2.xml | Expedia | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||