/cffunction>
<cffunction name="unlock_items" access="public" returntype="void">
<cfargument name="app_user_id" type="numeric" required="no" default="0">
<cfargument name="cfuserid" type="string" required="no" default="">
<cfobject component="#request.cfcpath#qrystodatabase" name="qry" />
<cfset qry_unlock_items_for_paypal = qry.qry_unlock_items_for_paypal(
app_user_id="#arguments.app_user_id#", cfuserid="#arguments.cfuserid#" ) />
</cffunction>
<cffunction name="f_unlock_items_15_minutes" access="public"
returntype="void">
<cfobject component="#request.cfcpath#qrystodatabase" name="qry" />
<cfset qry_unlock_items_for_paypal_15_minutes =
qry.qry_unlock_items_for_paypal_15_minutes() />
</cffunction>
<cffunction name="refresh_lock_time" access="public" returntype="void"
output="no">
<cfargument name="app_user_id" required="yes" type="numeric">
<cfobject component="#request.cfcpath#qrystodatabase" name="qry" />
<cfset variables.temp = qry.qry_paypal_refresh_lock_time (
app_user_id = "#arguments.app_user_id#"
) />
</cffunction>
<cffunction access="public" name="save_express_checkout" output="no"
returntype="struct">
<cfargument name="api_response" type="string" required="yes">
<cfset variables.response_struct = structnew()>
<cfset variables.response_struct.raw_response = arguments.api_response>
<cfset variables.response_struct.decoded_response =
urldecode(arguments.api_response)>
<cfloop list="#arguments.api_response#" index="i" delimiters="&">
<cfset variables.key = urldecode(listgetat( i, 1, "=" ))>
<cfset variables.value = urldecode(listgetat( i, 2, "=" ))>
<cfset structinsert(variables.response_struct, variables.key,
variables.value)>
</cfloop>
<cfif not StructKeyExists(variables.response_struct, "token")>
<cfset structinsert(variables.response_struct, "token","")>
</cfif>
<cfobject component="#request.cfcpath#qrystodatabase" name="qry" />
On Fri, Jun 13, 2014 at 8:03 PM, Phillip Vector <vec...@mostdeadlygame.com>
wrote:
>
> *sigh*
>
> This is the code for the function.
>
> Please show the full code including the following lines..
>
> 240 : </cffunction>
> 241 : <cffunction name="f_unlock_items_15_
> minutes" access="public" returntype="void">
> 242 : <cfobject component=" /cfcs/qry-todatabase" name="qry" />
> 243 : <cfset qry_unlock_items_for_paypal_15_minutes =
> qry.qry_unlock_items_for_paypal_15_minutes() />
> 244 : </cffunction>
>
> I want to see if cfcomponent is there. Since these tend to be at the start
> and end of a file, I would like the full file please.
>
> Also, I only have 14 years of experience, so I'm not up there with you at
> 15, but you shouldn't use cfcatch to display the SQL that was put in. It
> gives a bad vector for a hacker to put in sql and see what kind of stuff
> got generated that produced the error.
>
>
>
> On Fri, Jun 13, 2014 at 4:57 PM, Matthew Smith <chedders...@gmail.com>
> wrote:
>
> >
> > <cffunction access="public" name="f_qry_ordersGet" output="no"
> > returntype="query">
> > <cfargument name="orderKeyList" type="string" required="no" default="">
> > <cfargument name="personKeyList" type="string" required="no"
> default="">
> > <cftry>
> > <cfquery
> > name="f_qry_ordersGet"
> > datasource="#variables.datasource#">
> > SELECT o.tablePK
> > ,o.tblPeopleFK
> > ,o.createdOn
> > ,o.shippingMethod
> > ,o.itemSubTotal
> > ,o.totalBeforeTax
> > ,o.tax
> > ,o.shippingCost
> > ,o.total
> > ,p.firstName + ' ' + p.lastName AS name
> > FROM #request.sqlObjectPrefix#tblOrders o
> > INNER JOIN #request.sqlObjectPrefix#tblPeople p
> > ON o.tblPeopleFK = p.tablePK
> > WHERE 1 = 1
> > <cfif len(arguments.orderKeyList)>
> > AND o.tablePK = <cfqueryparam value="#arguments.orderKeyList#"
> > cfsqltype="CF_SQL_INTEGER" list="Yes">
> > </cfif>
> > <cfif len(arguments.personKeyList)>
> > AND o.tblPeopleFK = <cfqueryparam value="#arguments.personKeyList#"
> > cfsqltype="CF_SQL_INTEGER" list="Yes">
> > </cfif>
> > </cfquery>
> > <cfcatch>
> > <cfdump var="#arguments#" />
> > <cfdump var="#cfcatch.sql#" abort="true" />
> > </cfcatch>
> > </cftry>
> > <cfreturn f_qry_ordersGet />
> > </cffunction>
> >
> >
> > On Fri, Jun 13, 2014 at 7:51 PM, Phillip Vector <
> vec...@mostdeadlygame.com
> > >
> > wrote:
> >
> > >
> > > I highly doubt that. But you should know then that we need to see the
> > whole
> > > code in order to see if what you are saying is correct.
> > >
> > > So copy the full file code here and let's take a look.
> > >
> > > On Fri, Jun 13, 2014 at 4:48 PM, Matthew Smith <chedders...@gmail.com>
> > > wrote:
> > >
> > > >
> > > > It has it. Been doing this 15 years.
> > > >
> > > >
> > >
> > >
> > >
> >
> >
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358725
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
