Skip to main content
A
Anonymous
September 23, 2013
Question

Is using an if statment from within a query my best option?

  • September 23, 2013
  • 1 reply
  • 558 views

I have a mailer that sends out a word of encouragement every morning to several of my clients’ employees. The messages are pre-written. Any client can actually change the message before for that day without affecting the message being sent out to my other clients. I do this by sending the clients the message for the day in advance.

Once a client edits the message it is saved to another table called edits. When the message for the day goes out, I need to loop through the edits table first, if the table is not null for that day, it sends the message from the edits table. If the edits table is null, the message is pulled from the daily table.

Can I do an if statement from within the query, if the table is null for that day then query the second table called daily for the message for that day? 

    This topic has been closed for replies.

    1 reply

    p_sim
    p_sim
    Participating Frequently
    September 24, 2013

    Might be like this:

    <!--- Get message from edits table --->

    <cfquery name="getMessage">

              SELECT message

              FROM edits

              WHERE clientID = <cfqueryparam value="#attributes.clientID#" cfsqltype="cf_sql_integer">

                        AND scheduledDate = <cfqueryparam value="#dateFormat(now(), 'mm/dd/yy')#" cfsqltype="cf_sql_date">

    </cfquery>

    <!--- If there is no record in edits table, then get message from daily table --->

    <cfif NOT getMessage.recordCount>

              <cfquery name="getMessage">

                        SELECT message

                        FROM daily

                        WHERE clientID = <cfqueryparam value="#attributes.clientID#" cfsqltype="cf_sql_integer">

              </cfquery>

    </cfif>

    <cfoutput>#getMessage.message#</cfoutput>

    A
    Anonymous
    September 24, 2013

    Thanks, your advicse was very helpful. I didn't think of using the recordcount.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices