>
> 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?
> @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";
Katie,
sorry to say, but this is not a SQL list rather a Perl
list. However, the correct statement needs to be...
WHERE c.miles IS NULL;
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/
