[freeside-devel] Bug In Record.pm

[Ryan Gunn]

Sorry this was not a bug in Record.pm  .. Please ignore previous post . my
problem has something to do with $extra_sql being defined somewhere..

 

  _____  

From: freeside-devel-bounces at sisd.com
[mailto:freeside-devel-bounces at sisd.com] On Behalf Of Ryan Gunn
Sent: Sunday, July 02, 2006 10:47 PM
To: freeside-devel at sisd.com
Subject: [freeside-devel] Bug In Record.pm

 

Hi, just wanted to let everyone know that there appears to be a bug in
Record.pm

 

On line 265 there is an if statement .

            

            if ( @real_fields or @virtual_fields ) {

 

Then on line below that (266) there is a join statement which appears to
join SQL generated for @real_fields and @virtual_fields

 

When there is no @virtual_fields it creates an   AND ( )  at the end of the
query and causes a runtime error about the SQL syntax being incorrect

 

Also I think that it should probably be joined by  OR  instead of  AND

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://420.am/pipermail/freeside-devel/attachments/20060702/527d304d/attachment.html