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.

Reply via email to