EasyCFM.COM ColdFusion Forums / Coding Help! / PreserveSignleQuotes

   Reply to Discussion | New Discussion << previous || next >> 
Posted By Discussion Topic: PreserveSignleQuotes

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

melrish
03-09-2013 @ 3:31 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Member
Posts:
Joined: Nov 2012

Need help... Please see the code below: Why I am getting this error, i know that my systax is correct.

ERROR:
Variable PRESERVESIGNLEQUOTES is undefined.

    <cfif #Nationality# EQ "0">
         <cfset qNationality = "">
    <cfelse>
         <cfset qNationality = " AND TBLmaster.Nationality = '#Nationality#'">
    </cfif>
    
    <cfif #Age# EQ "">
         <cfset qAge = "">
    <cfelse>
         <cfset qAge = " AND TBLmaster.Age >= '#Age#'">
    </cfif>
    
    <cfif #numYears# EQ "">
         <cfset qNumYears = "">
    <cfelse>
         <cfset qNumYears = " AND TBLmaster.numYears >= '#numYears#'">
    </cfif>

     <cfif #Experiences# EQ "">
         <cfset qExperiences = "">
    <cfelse>
         <cfset qExperiences = " AND TBLemployment.industry LIKE '%#Experiences#%'">
    </cfif>
    
    <cfif #Degree# EQ "">
         <cfset qDegree = "">
    <cfelse>
         <cfset qDegree = " AND TBLacademics.Major LIKE '%#degree#%'">
    </cfif>
    
    <cfif #University# EQ "">
         <cfset qUniversity = "">
    <cfelse>
         <cfset qUniversity = " AND TBLacademics.University LIKE '%#University#%'">
    </cfif>
     
  
     <cfquery name="qListing">
    SELECT *, TBLmaster.*, TBLacademics.*, TBLemployment.*
    FROM     TBLemployment INNER JOIN
              TBLmaster ON TBLemployment.IDNO = TBLmaster.IDNO INNER JOIN
            TBLacademics ON TBLmaster.IDNO = TBLacademics.IDNO
     WHERE      TBLmaster.Tag='1' AND TBLacademics.Tag='1' AND TBLemployment.Tag='1'
              #PreserveSignleQuotes(qNationality)#
              #PreserveSignleQuotes(qAge)#
            #PreserveSignleQuotes(qNumYears)#
            #PreserveSignleQuotes(qExperiences)#
            #PreserveSignleQuotes(qDegree)#
            #PreserveSignleQuotes(qUniversity)#     
    </cfquery>


Cheers,
Arish Perez

Webmaster
03-09-2013 @ 8:46 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Administrator
Posts: 4542
Joined: Jan 2002

It's misspelled.

PRESERVESIGNLEQUOTES

Should be

PRESERVESINGLEQUOTES

Pablo Varando
Senior Application Architect
EasyCFM.COM, LLC.

904.483.1457 \\ mobile
webmaster@easycfm.com \\email

\m/ (>.<) \m/
--- rock on ---


Website Designed and Developed by Pablo Varando.