Patrick
09/28/2022, 4:24 PMAdam Cameron
gsr
09/28/2022, 11:01 PMNikola Mikasinovic
09/30/2022, 7:54 AMgsr
10/04/2022, 12:29 PMOokma-Kyi
10/04/2022, 9:16 PMgsr
10/04/2022, 11:00 PMexec sp_proclist
so trying to make it work in the function so i can pass thatquery to the function and it fetches that many records, not sure it will work that or i need to modify my reports because the reports are quite quite big and too many to count
Here is my trying on github
https://trycf.com/gist/2dde579d38157ccf83019557ea62a742/lucee5?theme=monokaiUmair Khan
10/05/2022, 4:49 PMgsr
10/09/2022, 2:41 PMAngad Yadav
10/10/2022, 5:11 AMepipko
10/12/2022, 7:30 PMNikola Mikasinovic
10/13/2022, 8:05 AMgsr
10/14/2022, 4:45 PMgsr
10/17/2022, 3:19 PMcflock timeout="10" scope="Session" type="Exclusive">
<CFPARAM NAME="Session.loginid" DEFAULT=0>
</cflock>
i check some tutorials and getting a very vague answer, some say do not use it, some say names should be used instead of scope, so not sure ho can i fix itRyan Theiss-Aird
10/17/2022, 7:25 PMNate Smith
10/18/2022, 6:12 PMepipko
10/18/2022, 6:21 PMRob W
10/23/2022, 7:47 AMNikola Mikasinovic
11/03/2022, 4:48 PMAnders Lars
11/04/2022, 6:35 PMhpeter16
11/07/2022, 10:47 PM<cfexecute>
tag against the command shell injection attack?Simone
11/08/2022, 6:22 PMSimone
11/08/2022, 6:22 PMepipko
11/09/2022, 9:07 PMepipko
11/10/2022, 11:28 PMsiteadvice
11/15/2022, 9:01 PM<cfset maxpriceQuery = QueryNew("id,maxprice","integer,integer")>
<cfset QueryAddRow(maxpriceQuery, #get.recordcount#)>
<cfset intMaxPriceLoop = 1>
<cfloop query="get">
<cfset QuerySetCell(maxpriceQuery, "id", #id#, intMaxPriceLoop)>
<cfset QuerySetCell(maxpriceQuery, "maxprice", #maxprice#, intMaxPriceLoop)>
<cfset intMaxPriceLoop = intMaxPriceLoop + 1>
</cfloop>
Then I want to be able to select from that query, something like this...
select top 2 id from maxpriceQuery where maxprice <= #getprice.price#
But I don't know how.
Can someone help?
I thought maybe I could use this...
<cfquery name="getmydata" datasource="maxpriceQuery">
...but that's evidently wrong because maxpriceQuery is not a valid datasource.
I'm sure I did this once years ago but I'll be darned if I can figure out how. :-)Risen Joe
11/17/2022, 5:03 PMjohnbarrett
11/23/2022, 7:38 AM<cfif #form.conversionType# is "CtoF"> <cfinvoke component="convertTemp" method="ctof" returnvariable="newtemp" temp=#form.temperature#>
<cfoutput>#form.temperature# degrees Celsius is #newtemp# degrees Farenheit.</cfoutput>
<cfelseif #form.conversionType# is "FtoC">
<cfinvoke component="convertTemp" method="ftoc" returnvariable="newtemp" temp=#form.temperature#>
<cfoutput>#form.temperature# degrees Fahrenheit is #newtemp# degrees Celsius.</cfoutput>
</cfif>
gsr
11/28/2022, 4:51 PMgsr
11/29/2022, 1:13 AM