[Solar-talk] Patch for Solar_Content_Abstract

Travis Swicegood development at domain51.com
Mon Oct 2 15:42:39 PDT 2006


Paul M Jones wrote:
> My only concern there goes something like this:  You have a varchar  
> column, and you want to populate it with a numeric value (which will  
> of course be stored as a string).  If the numeric value is not  
> quoted, will the DB choke on that at insert/update time?
>
> That is, do all the supported DBMSes see these as equally valid?
>
>      UPDATE table SET char_col = 123;
>      UPDATE table SET char_col = '123';
>
> Any ideas here?
>   

Hmm...

Maybe the solution here is to do just what's needed to make this work.  
Since we already know that in this case count($tags) is going to be an 
integer that doesn't really need escaping, just updating that ->having() 
call is the simplest solution with the least ripple effect.  Attached is 
the patch I have in place on my machine which includes the update to 
take into account the lack of a requirement for a column specification 
in the top level count().

-Travis


-------------- next part --------------
A non-text attachment was scrubbed...
Name: Solar_Content_Abstract.patch
Type: text/x-patch
Size: 897 bytes
Desc: not available
Url : http://mail.killersoft.com/pipermail/solar-talk/attachments/20061002/041a9344/attachment.bin 


More information about the solar-talk mailing list