John,
The quotes are throwing it. Try single or no quotes.
Best regards,
Andrew
---
Andrew Hill - Director Technology Evangelism
OpenLink Software - http://www.openlinksw.com
Internet Data Integration Technology
On 4/6/01 4:30 PM, "John A DAVIS" <[EMAIL PR
THE SQL STATEMENT:
$data = odbc_do($connection, "Select Distinct [ActivityStatus],
[WaterSystemStateCode], [WaterSystemName], [PopulationServed], [SeasonBegins],
[SeasonEnds], [SystemType], Contact, Phone, County, Connections, Address, CityStateZip
From viewInventory Where [WaterSystemStateCod