Solved

ouput query question

Posted on 2009-05-06
2
210 Views
Last Modified: 2013-12-24
I have a shopping cart that is using an output query to display each line item.
I need to add some text to each line item if a varilable isdefined,
<cfif IsDefined("session.ccode")>
    <cfoutput><span class="text12red smallText">#GetCCode.Description#</span></cfoutput>
</cfif>
The problem is that it will repeat the output several times across the line. If I have one line item it will show once for that item.
If I have two line items it will show twice for the first one and once for the next.
If I have three lines items it will show three times for the first item, two times for the next and so on.
How do I get it to show only once for each line item?
0
Comment
Question by:usky1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 52

Accepted Solution

by:
_agx_ earned 350 total points
ID: 24316288
It is difficult to say without seeing more code. My guess would be the <cfoutput> tags.  If you already using "using an output query" that means you already have cfoutput tags around the variable.  So you do not need a second set of <cfoutput> tags around the code above.   Try removing it ...

Example:
<cfoutput query="yourQuery">
    ...
     <cfif IsDefined("session.ccode")>
         <span class="text12red smallText">#GetCCode.Description#</span>
     </cfif>
    ...
</cfoutput>
0
 

Author Closing Comment

by:usky1
ID: 31578508
Some times the obvious is missed. thanks for catching that.
0

Featured Post

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In our day to day coding, how many times have we come across a necessity to check whether a URL is a broken link or not? For those of you that answered countless and are using ColdFusion like myself, then this article is for you.  It will show yo…
Have you ever sent email via ColdFusion and thought of tracking this mail to capture the exact date and time when the message was opened ?  If yes, then this article is for you ! First we need a table user_email with columns user_id , email , sub…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question