65 questions
1
vote
2
answers
157
views
passing multiple values with comma seperation in cfqueryparam causing issue. it is paasing as index scan instead of index seek
I have a query where it passes the list value with comma separation using cfquery param. instead of index seek it is using index scan. I observed this is because of nvarchar 4000.
But the same query ...
0
votes
1
answer
532
views
React- adding query param with pushState adds trailing slash before params (without react router)
I'm trying to manipulate my query params directly without any library (like react-router- because i don't need them now).
The problem is when i try to add query params using this codes:
let url = new ...
- 723
2
votes
1
answer
693
views
how to print/display cfquery with cfqueryparam values replaced?
As you may be aware that when we dump cfquery, it dumps the cfqueryparam values into SQLPARAMETERS of the dump. It's been alright to replace a couple of parameters manually. However, lately I've ...
- 111
1
vote
1
answer
614
views
cfqueryparam pass in list from input checkbox
I have a input checkbox field where user can select multiple checkboxes in a form, and depending on what they select, it will create a string of id's like 10,14,35,47, and that will be submitted to ...
- 41
2
votes
1
answer
91
views
CFQUERYPARAM throws 'incompatible type' error with HQL
My simple query:
<CFQUERY name="thisRecipePreps" dbtype="hql">
FROM recipeItems r
WHERE r.recipe = <cfqueryparam value="#thisrecipeid#">
AND r....
- 107
0
votes
1
answer
420
views
Update query not updating integer fields using CFQUERYPARAM
I have a simple update query, only one table involved. I first wrote this without using CFQUERYPARAM and kept getting errors when the integer fields (zip,plus 4, etc) were null. So, I rewrote using ...
- 3
0
votes
1
answer
137
views
ColdFusion Sanatize SQL
I'm trying to loop over tableList and run a query for each table getting the count from each. Not all of the code is included but the problem is the cfqueryparam. When I run this code right now the ...
- 348
0
votes
2
answers
210
views
querying with nulls and lists
I have
QueryExecute(
SELECT *
FROM dbo.pages
WHERE ID IN ( :id )
...
,
{
id : { value = rc.id, cfsqltype : "cf_sql_integer, list : true }
}
Almost all the time this ...
- 11.1k
0
votes
0
answers
901
views
How to check if query and function are executed successfully?
I have function that takes few arguments then query delete will be executed. Right after that I call another function that will update table with time stamp and user id. The code that I use looks like ...
- 6,140
2
votes
1
answer
2k
views
ColdFusion queryExecute parameters object?
I started using cfscript in my projects recently. While working with cfscript I used queryExecute() function to run queries. In few situations there was more than one query in the same function. These ...
- 6,140
0
votes
1
answer
339
views
ColdFusion to PHP: Can I make queries as easily?
I'm working for a large company that has a ton of ColdFusion web applications. They're requiring all these apps to transition to new platforms/languages.
One of these applications is quite large ...
- 254
3
votes
2
answers
723
views
Strange ColdFusion 10 Error using cfquery cfqueryparam
I am using ColdFusion 10 Update 23 with MySQL database.
When I make a change to a script where I am using cfqueryparm the script causes this error message: "The type for attribute value of tag ...
- 33
3
votes
3
answers
1k
views
Coldfusion: executing dynamic query containing cfqueryparam
First, the code. I'm making a struct of queries:
<cfset myQueryStruct = {
qone = "select * from t1 where column = <cfqueryparam cfsqltype='cf_sql_varchar' value='#arguments.a1#'>",
qtwo = "...
- 1,979
0
votes
3
answers
737
views
Check if argument exist in the structure, if not set to NULL?
I have a set of radio buttons that I would like to validate on the server side. First I created structure that has the argument names for the key. Then each name is set to different values that the ...
- 6,140
2
votes
1
answer
355
views
ColdFusion 9 set decimal type for cfqueryparam?
I have few form fields where user can enter whole numbers, decimal numbers and both types can be positive or negative. In other words they can enter something like this:
1 or 0.9 or 5.6745 or -10 or -...
- 6,140