Thanks! - I think I just fixed it.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Knipp, Eric
Sent: Wednesday, November 17, 2004 3:56 PM
To: '[EMAIL PROTECTED]'
Subject: RE: Report help
Tim,
Can you join the tables?
Eric
-----Original Message-----
From: Tim Starling [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 17, 2004 3:53 PM
To: [EMAIL PROTECTED]
Subject: Report help
Could someone give me a suggestion on how to best address the following
problem?
I have a page that will allow my users to register for an event. On that
page you have the ability to choose up to three upgrades and enter other
options for each trip. The options for each of the three upgrade choices is
pulled from the same table and I simply store the ID for the option that
they choose in their respective field. I have upgrade.Id being stored in
registration.upgrade1, registration.upgrade2, and registration.upgrade3. I
now need to create a report that will show all of the registrations at once
and list out the upgrade options that each person has chosen. Listing out
the Ids is no problem but I need to show the descriptions from the upgrades
table instead of the id.
Currently, I have two queries - one that pulls in their registration
information and all of the other associated information (such as their name,
address, etc. from the profile table) and one that lists out the upgrade
options from the upgrades table. At first I thought I could use a CFCase
tag but it will not allow the cfoutput tag within it to auto generate the
cfcase options. I've tried some other options but now I'm realizing that I
can't use a cfoutput tag with the query attribute inside another cfoutput
tag that also uses the query attribute.
I'm sure there is an easy solution - I just can't seem to think of one at
the moment. Any help would be appreciated.
Thanks,
Tim
----------------------------------------------------------
To post, send email to [EMAIL PROTECTED]
To unsubscribe:
http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe:
http://www.dfwcfug.org/form_MemberRegistration.cfm
-----------------------------------------
CONFIDENTIALITY NOTICE: The information contained in this e-mail and
attached document(s) may contain confidential information that is intended
only for the addressee(s). If you are not the intended recipient, you are
hereby advised that any disclosure, copying, distribution or the taking of
any action in reliance upon the information is prohibited. If you have
received this e-mail in error, please immediately notify the sender and
delete it from your system.
----------------------------------------------------------
To post, send email to [EMAIL PROTECTED]
To unsubscribe:
http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe:
http://www.dfwcfug.org/form_MemberRegistration.cfm
----------------------------------------------------------
To post, send email to [EMAIL PROTECTED]
To unsubscribe:
http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe:
http://www.dfwcfug.org/form_MemberRegistration.cfm
