Re: [PHP-DB] Code bombs connecting to MSSQL 7

2001-04-06 Thread Andrew Hill
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

[PHP-DB] Code bombs connecting to MSSQL 7

2001-04-06 Thread John A DAVIS
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