> daniel kessler wrote: > > Here are the results from the dump (not sure how this'll come > through) ommitting unnecessary info. > > Can you re-paste this dump without ommitting anything...I'm guessing > there is some necessary info in there. My guess is that the s.id is > being returned in your result set, and since that isn't always 3, > those > are distinct records. Another way of doing this query might be > something like...
Your right, it is more than that. I'm making a variable for rowcount so that I only get so many at a time. This query is inside another query that only gets the rows from something to something. We've been working with the inner query though - the ones that does all the searching. Here's a produced dump: http://hhp.umd.edu/home/notes_search_dump.cfm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267773 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
