> > However... the qoq started complaining about comparing integers to > strings... I guess Verity search returns all data as strings... > I had to CAST image_id column in db query as CHAR, and it started > working... But... it that right? Should it be like that? > I am worried that casting a column as char, and then comparing string > values in the qoq might actually bring in a big overhead and make it > slower than doing an IN () comparisson... Any thoughts?
That's odd, I've not had that problem, damn QoQ! Also, if you are wanting to maintain the order of the verity results the QoQ may still be neccessary / useful. Doing a DB select with the IN() clause will ignore the verity order. Sorry I can't help with the casting. Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302836 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
