• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 357
  • Last Modified:

CFPROCPARAM for a SQL query help

I have the following parameter
      <CFPROCPARAM
                  dbvarname="EndDate"
                  type="in"
                  value="#Session.BeginDate#"
                  cfsqltype="CF_SQL_INTEGER">

it's working, but I need it to subtract 1 from Session.BeginDate (which is a number not a date).  So if session.begindate is 30, I want the value passed it to be 29.  I tried doing the following, but it doesn't work:

      <CFPROCPARAM
                  dbvarname="EndDate"
                  type="in"
                  value="#Session.BeginDate#+1"
                  cfsqltype="CF_SQL_INTEGER">

Please advise.

Thanks
0
YLaw
Asked:
YLaw
  • 3
2 Solutions
 
73SpyderCommented:
<cfif session.begindate EQ 30>
   <cfset variables.temp_date_value = 29>
<cfelse>
   <cfset variables.temp_date_value = session.begindate>
</cfif>


    <CFPROCPARAM
               dbvarname="EndDate"
               type="in"
               value="#temp_date_value #"
               cfsqltype="CF_SQL_INTEGER">
0
 
73SpyderCommented:
<cfif session.begindate EQ 30>
   <cfset variables.temp_date_value = 29>
<cfelse>
   <cfset variables.temp_date_value = session.begindate>
</cfif>


    <CFPROCPARAM
               dbvarname="EndDate"
               type="in"
               value="#temp_date_value#"
               cfsqltype="CF_SQL_INTEGER">

//-- Removed an extra space I left in the code above.
0
 
YLawAuthor Commented:
Sorry, I'll never know what session.begindate is.  That's why I need to calculate it in the value or set it somewhere else to the value minus 1
0
 
73SpyderCommented:
ah  I get it

   <cfset variables.temp_date_value = session.begindate - 1 >



    <CFPROCPARAM
               dbvarname="EndDate"
               type="in"
               value="#variables.temp_date_value#"
               cfsqltype="CF_SQL_INTEGER">
0
 
CodeParadiseCommented:
YLaw, you need to do the calculations between the # signs.

    <CFPROCPARAM
               dbvarname="EndDate"
               type="in"
               value="#Session.BeginDate -  1#"
               cfsqltype="CF_SQL_INTEGER">
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now