Can you share the table create scripts? You need to send us the output of
show create table OWNER.CONFERENCE;
Also send across some sample data.
ANoop
On 4/18/07, Katie L. Barbee <[EMAIL PROTECTED]> wrote:
I believe this is a very simple question or at least I'm hoping ...
I am trying to select items from a table where the miles field is not
null or blank and the below statement does not work. Does anyone have
any suggestions?
Thanks!
@resultkeys = ("Date","People","Miles","Savings");
$sql = "SELECT c.objectid,c.dateadded as
\"Date\",c.totalpeople as \"People\", ";
$sql .= "c.miles as Miles, c.totalsaved as \"Savings\" ";
$sql .= "FROM OWNER.CONFERENCE c";
$sql .= " WHERE c.miles <> "";
$sql .= " ORDER BY c.datestart";
