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 use. >> So for example get: >> http://www.icdevgroup.org/cgi-bin/cvsweb/interchange/dist/lib/UI/pages/admin >> >> /reports/order/ByAffiliate.html?rev=2.5;content-type=text%2Fplain >> >> Change the query: >> sql=" >> select affiliate, campaign, total_cost, order_date >> from transactions >> WHERE deleted != '1' [scratch date_limit] [scratch >> synd_limit] >> 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. ;-) Peter _______________________________________________ interchange-users mailing list suppressed http://www.icdevgroup.org/mailman/listinfo/interchange-users
Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.