doing this all from sql only?
On 10/5/07, Erika L. Walker <[EMAIL PROTECTED]> wrote: > awesome awesome, thank you ... you guys are the bestest. > > next question. Members show up multiple times in the membercat table because > they can belong to multiple categories.... > > SELECT mcompany, bizcategory > FROM members > INNER JOIN memberscat on members.memberid = memberscat.memberid > INNER JOIN bizcat on memberscat.bizid = bizcat.bizid > > Worked first time out of the box .... but, what happens with multiple > categories ... > > What I am trying to do is get the data from one datasource, dump it into > another, but all in one table, which means a pipe delimited list of the > categories all in one field. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:243647 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
