RE: Order by a field with multiple keywords
sorry, fred. :) Chris Olive DOHRS Website Administrator -Original Message- From: Fred T. Sanders [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 09, 2000 8:26 PM To: [EMAIL PROTECTED] Subject: Re: Order by a field with multiple keywords I resemble that search! LOL Fred - Original Message - From: "Olive, Christopher M Mr USACHPPM" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 09, 2000 3:14 PM Subject: RE: Order by a field with multiple keywords > you're subject line is close to the actual solution. :) > > try. > > SELECT > fred, > fred2, > fred3, > region > FROM > sometable > GROUP BY > region > ORDER BY > region > > Chris Olive > DOHRS Website Administrator > > > -Original Message- > From: Cyrill Vatomsky [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, May 09, 2000 1:22 PM > To: Cf-Talk@Houseoffusion. Com > Subject: Order by a field with multiple keywords > > > Hi, All > > I have a table with a "region" field that would contain several entries > (Central Coast, California, West Coast, USA). How can I display the list by > each individual region? Most records, of course will be displayed several > times in each subgroup. > > All I can think of is make a list of all regions and then run a query for > each of them. Is there a better way? With just one query? > > TIA > > Cyrill > > > -- -- > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=li sts/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=li sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Order by a field with multiple keywords
I resemble that search! LOL Fred - Original Message - From: "Olive, Christopher M Mr USACHPPM" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 09, 2000 3:14 PM Subject: RE: Order by a field with multiple keywords > you're subject line is close to the actual solution. :) > > try. > > SELECT > fred, > fred2, > fred3, > region > FROM > sometable > GROUP BY > region > ORDER BY > region > > Chris Olive > DOHRS Website Administrator > > > -Original Message- > From: Cyrill Vatomsky [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, May 09, 2000 1:22 PM > To: Cf-Talk@Houseoffusion. Com > Subject: Order by a field with multiple keywords > > > Hi, All > > I have a table with a "region" field that would contain several entries > (Central Coast, California, West Coast, USA). How can I display the list by > each individual region? Most records, of course will be displayed several > times in each subgroup. > > All I can think of is make a list of all regions and then run a query for > each of them. Is there a better way? With just one query? > > TIA > > Cyrill > > > -- -- > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=li sts/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=li sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Order by a field with multiple keywords
you're subject line is close to the actual solution. :) try. SELECT fred, fred2, fred3, region FROM sometable GROUP BY region ORDER BY region Chris Olive DOHRS Website Administrator -Original Message- From: Cyrill Vatomsky [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 09, 2000 1:22 PM To: Cf-Talk@Houseoffusion. Com Subject: Order by a field with multiple keywords Hi, All I have a table with a "region" field that would contain several entries (Central Coast, California, West Coast, USA). How can I display the list by each individual region? Most records, of course will be displayed several times in each subgroup. All I can think of is make a list of all regions and then run a query for each of them. Is there a better way? With just one query? TIA Cyrill -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Order by a field with multiple keywords
Hi, All I have a table with a "region" field that would contain several entries (Central Coast, California, West Coast, USA). How can I display the list by each individual region? Most records, of course will be displayed several times in each subgroup. All I can think of is make a list of all regions and then run a query for each of them. Is there a better way? With just one query? TIA Cyrill -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
