LiveDocs Comments - coldfusion - 7 - htmldocs - 00000316.htm

coldfusion/7/htmldocs/00000316.htm

Joe1982 — 2007-10-18T11:08:26

It may also be useful to note that when setting up a query dynamically, using the code "ArrayToList(userQuery.getColumnList())" can be a little tricky.

I have the following code that I am using to build a dynamic query. If I use 2 tables that have a field with the same name I will only have the data in the field from the first table repeated 2 times. Here is the code:

Here I declare the columns:

Here I loop through the columns to print the data:

If I write the sql "select a.name, b.name from schema1.table1 a, schema1.table2 b" I will only get the data for a.name twice.

Has anyone found a solution for this?

coldfusion/7/htmldocs/00000316.htm

2007-07-01T14:38:08

The comment in Dec 2005 about cfquery only creates a query object for select statements is not completely true.

If the statment you run returns a recordset, it will create a query object. The database does not return a recordset for most insert/updates, but you could for example: add an on insert trigger that runs "select @@identity as ID" which returns the primary key value in an identity column. You could now name your cfquery that runs the insert statement, it will have one row, one field, ID with the new record ID just inserted.

coldfusion/7/htmldocs/00000316.htm

carehart — 2007-03-13T22:57:17

Docs above say "Setting this value to 0 disables query caching", but isn't it true instead that setting to 0 means "unlimited query caching"? That's what's been documented here (http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_19406) for CF 6, 6.1. My testing shows it still so in 7.02. If so, besides changing the above, It would seem helpful for that document to be udpated to reflect that it's still true.

It also seems that this should be corrected, really, to offer "disable" and "unlimited" buttons instead, to make intended behavor clear. Then 0 should be interpreted instead as disabled.

The potential negative impact of this current behavior is substantial, for those who think that setting to 0 is preventing any caching, where in fact code on the server uses the caching attributes, and therefore could be using large amounts of memory (with no easy means to detect that).

coldfusion/7/htmldocs/00000316.htm

Sankalan — 2006-10-11T12:38:52

How to get ColumnList from a query resultset ?

select * from tableName

#myQuery.ColumnList#

#myResult.ColumnList#

This will give the column names in alphabetical order.

But to get the column names in the same order as in database tables, use this:

#ArrayToList(myQuery.getColumnList())#

coldfusion/7/htmldocs/00000316.htm

MikerRoo — 2006-07-11T13:55:14

It should be noted here that cachedWithin behavior has changed.
Using cachedWithin on a non-select query makes no sense but it did not throw an exception until version 7.02. (This has come up on the forums a few times now.)

coldfusion/7/htmldocs/00000316.htm

105 — 2005-12-27T22:47:25

It should be stated that cfquery only creates a query object for select statements. For insert, update and delete statements, no query object is created and a variable named with the query name is undefined.

coldfusion/7/htmldocs/00000316.htm

funkdancer — 2005-11-02T04:47:31

When performing date comparisons in QoQs, CFMX7 lets you do e.g.
where myDate <= #createodbcdatetime(now())#

In CFMX6 you will need to use bound params, e.g.
where myDate <=

coldfusion/7/htmldocs/00000316.htm

ASandstrom — 2005-08-24T09:47:23

In response to wyntermoonwolf:
Actually, it should read:
result_name.recordcount - Number of records (rows) returned from the query.

coldfusion/7/htmldocs/00000316.htm

wyntermoonwolf — 2005-08-23T13:38:06

result_name.recordcount - Current row of query that cfoutput is processing.

It should read: result_name.CurrentRow

coldfusion/7/htmldocs/00000316.htm

Gregd66 — 2005-03-17T10:58:55

truncate table temp_table

insert into temp_table
(testdata)
values
('#mydata#')

select testdata
from temp_table

ERROR: DB data #selectdata.testdata# does not match original #mydata#

Data OK.

coldfusion/7/htmldocs/00000316.htm

cf.Objective — 2005-02-12T09:06:28

In the chart outlining resultset extended variables, the text claims that result_name.recordcount is the current row of the query that's being processed by cfoutput. And, nobody is claiming to represent the total number of rows returned in the query object.

Just thought you'd like to know...

J

coldfusion/7/htmldocs/00000316.htm

rvoosten — 2005-02-09T00:17:15

docbug: the result = "result_name" should be before the greater than (>) symbol