I am having trouble getting it to work with my query. With my query second select
never populates. I fail to see why!
Thanks!
Here is a portion of the given sample query output:
MASTER_CAT MCODE CODE CAT FEATURED_POSTING
General Merchandise GEN GENALL All General Mdse. P406974
General Merchandise GEN GENARS Arts & Crafts P406974
General Merchandise GEN GENBOO Books & Publications P406974
General Merchandise GEN GENDOL For Dollar Stores P406974
General Merchandise GEN GENGIF Giftware P406974
General Merchandise GEN GEN-CL GM Closeouts/Surplus P406974
General Merchandise GEN GENHAR Hardware P406974
General Merchandise GEN GENHBA Health & Beauty Aids P406974
General Merchandise GEN GENHOM Home Fashion P406974
General Merchandise GEN GENKIT Housewares P406974
General Merchandise GEN GENNOV Novelties P406974
General Merchandise GEN GENHOL Seasonal/Holiday P406974
General Merchandise GEN GENSPO Sporting Goods P406974
General Merchandise GEN GENTOY Toys/Games P406974
General Merchandise GEN GENALT Adult Merchandise P406974
General Merchandise GEN GENOTH Other P406974
Apparel/Accessories APP APPALL All Apparel/Access. P406368
Apparel/Accessories APP APP-CL Apparel Closeouts P406368
Apparel/Accessories APP APPBAC Boys Accessories P406368
Apparel/Accessories APP APPBOY Boys Apparel P406368
Apparel/Accessories APP APPFAB Fabric/Textiles P406368
Here is what I am using:
getcats Master_cat MCODE Code Cat
Freshwater 1 10 General
Freshwater 1 9 Miscellaneous
Freshwater 1 8 Rainbowfish
Freshwater 1 7 Livebearers
Freshwater 1 6 Killifish
Freshwater 1 5 Cyprinid
Freshwater 1 4 Characins
Freshwater 1 3 CatFish
Freshwater 1 2 Anabantids
Freshwater 1 1 Cichlids
Brackish 4 11 Livebearers
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
