I've got an existing database table that contains contact (address, city,
email, etc) information and OnOff states for approximately 30 products.
Table Structure:
company_ID
company_Name
company_Address
company_City
company_Email
company_RedBalloons
company_GreenBalloons
company_RedBall
company_GreenBall
etc...
To top it off, there's another db table that contains the fieldname and a
longer description:
product_ID
product_longdesc = this contains description information (eg. A bag of Red
Balloons)
product_fieldname = this actually contains field names from the company db
(eg. like company_RedBalloons)
I need to query a row of the company table and based on Yes/No states of the
database list the product_longdesc in my CF page for a particular company.
Basically, I need to display a page of everything the company sells. I'm
not having much luck.
Thanks in advance,
Aaron
------------------------------------------------------------------------------
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.