cfquery Questions
2
Solved
I am converting a ColdFusion application to C# (I'm a CF n00b).
I have a script that performs a cfquery and then cfloop's through the results, and it appears to be trying to compare the current ro...
Hyperplasia asked 8/1, 2013 at 23:10
8
Solved
I want to get a specific row in a ColdFusion Query object without looping over it.
I'd like to do something like this:
<cfquery name="QueryName" datasource="ds">
SELECT *
FROM tablename
<...
Seemly asked 31/7, 2009 at 13:31
3
Solved
Can I split an array into two separated ones with each element in the original array separated by a ":"? The text before the ":" goes to array1, the text after ":" goes to array2
<cfset tempArr...
Smoothspoken asked 5/6, 2013 at 19:47
1
Solved
This does not crash in ColdFusion 11, but does crash in ColdFusion 2016
SELECT *
FROM dbo.Roles WITH (NOLOCK)
WHERE Code IS NOT NULL
AND Active = 1
AND RoleID IN (SELECT RoleID FROM dbo.Emp WITH (...
Chubb asked 17/2, 2016 at 1:13
1
Today while fixing bugs in some existing code I found a strange error.
Branch target offset too large for short
After searching I found that it is something to do with Java byte code conversi...
Guildsman asked 24/6, 2015 at 11:8
2
Solved
When I use CFINSERT the form data is inserted into my database because the field names match the column names.
MY QUESTION: How can I get the primary key of the row I just added using the CFINSER...
Shiv asked 21/4, 2015 at 9:13
2
Solved
Take the following query example:
<cfquery name="Test" Datasource = "TestDB">
Select * from Table_Test
</cfquery>
Assume that the "Test" query returns 10 rows. I want to show single...
Counterblow asked 27/10, 2014 at 11:49
2
I primarily use CFQUERYPARAM to prevent SQL injection. Since Query-of-Queries (QoQ) does not touch the database, is there any logical reason to use CFQUERYPARAM in them? I know that values that do ...
Varro asked 27/2, 2014 at 16:21
4
I have a query result set from cfquery. I just want to add a new after a particular row number. But When tried each time it inserts the row at the end.
Is there any way I can insert row at the mid...
Spiritoso asked 5/2, 2014 at 13:8
3
Solved
I have the following cfquery:
<cfquery name="CQuery" datasource="XX.X.X.XXX">
INSERT INTO DatabaseName
(PhoneNumber_vch,
Company_vch,
date_dt)
VALUES(#PhoneNumber#,
#Company#,
#Date...
Arpent asked 30/10, 2013 at 19:51
2
Solved
I am trying to take a look at AngularJS, with a cf backend
I have the following code that pulls a regular cfquery called getIndex which pulls five rows of columns each (firstName, lastName)
var t...
Wolfgram asked 4/1, 2013 at 0:19
3
Solved
I'm trying to convert ColdFusion query column to a list, what is the best way to do so?
I thought that there is a built in function that allows one to easily convert a query's column in to a list,...
Sergiosergipe asked 30/3, 2011 at 17:18
2
Solved
I am writing a query in ColdFusion 9.01 script and having trouble understanding why it is not caching the results. The same exact query will cache when executed using the CFML tag syntax.
The SQL,...
Anet asked 26/10, 2011 at 1:49
2
Solved
When I select data from a MySQL table using the cfquery tag in ColdFusion 8, the column names are all converted to uppercase even though I've stored them in camelCase in the database table. Is ther...
Tyrosine asked 29/9, 2011 at 12:58
2
Solved
I am using CFQuery to retrieve the CLOB field from Oracle DB. If the CLOB filed contains the Data less than ~ 8000, then I can see <CFQuery > retrieved the value (<cfdump> the o/p), how...
Ribonuclease asked 22/2, 2011 at 7:20
1
Solved
I would like to add some code to my Application.cfc onRequestEnd function that, if a certain application variable flag is on, will log query sql and execution time to a database table. That part is...
Declare asked 17/12, 2010 at 19:52
3
Solved
I am using a HQL query to get a bunch of state objects like so:
<cfquery name="LOCAL.qStates" dbtype="hql">
from States where countryID = #ARGUMENTS.countryID#
order by name asc
</cfque...
Kiehl asked 11/11, 2010 at 11:30
6
Solved
Is it possible to Execute 2 insert or Update Statements using cfquery?
If yes how?
if no, what is the best way to execute multiple queries in Coldfusion, by opening only one Connection to DB.
I ...
Copybook asked 10/12, 2009 at 18:19
2
Solved
When you use the cachedwithin attribute in a cfquery how does it store the query in memory. Does it store it by only the name you assign to the query? For example, if on my index page I cache a que...
Arlo asked 14/6, 2010 at 18:50
3
Solved
I have the unfortunate task of cleaning up a bunch of old ColdFusion code. Queries are all over the place, I am working on moving them all to common CFCs for easier maintenance.
I am running into ...
Disassembly asked 2/6, 2009 at 15:43
5
Solved
I'm trying to be a good CF web developer and use <cfqueryparam> around all FORM or URL elements that make it to my SQL queries.
In this case, I'm trying to allow a user to control the ORDER...
Hispanicism asked 20/5, 2009 at 17:41
1
© 2022 - 2024 — McMap. All rights reserved.