[ic] Reports menu problem
peter at pajamian.dhs.org
Tue Jul 17 20:28:17 EDT 2007
On 07/17/2007 05:17 PM, Jon Jensen wrote:
> On Wed, 18 Jul 2007, Gert van der Spoel wrote:
>> I suppose this could be considered a bug and '!=' => 'ne' should be
>> added to SQL_Parser.pm
> Actually, != is not part of standard SQL. The inequality operator is <>
> only. PostgreSQL and MySQL both have != as an alias, but it's nonstandard.
> I don't know if anyone would mind having it as an alias, though.
I think we should accept it in Vend::SQL_Parser.pm but not encourage its
>> So for example get:
>> Change the query:
>> select affiliate, campaign, total_cost, order_date
>> from transactions
>> WHERE deleted != '1' [scratch date_limit] [scratch
>> order by affiliate, campaign, order_date
>> Change != into <>
> Good idea. It's nice if our SQL works with our SQL parser. :)
> I changed several instances of != to <> in SQL, all that I could find,
> in the development trunk of CVS. I notice that we fixed a few of these
> back in the 4.9 era too, when Vend::SQL_Parser was first added.
Good, I was thinking about doing this, you beat me to it. ;-)
More information about the interchange-users