LiveDocs Comments - coldfusion - 6 - CFML_Reference - Tags-pt218.htm

coldfusion/6/CFML_Reference/Tags-pt218.htm

jrunrandy — 2005-03-22T11:09:00

Sure. Query of queries:
CFMX: http://livedocs.macromedia.com/coldfusion/6/Developing_ColdFusion_MX_Applications_with_CFML/using_recordsets.htm

CFMX 6.1: http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/using_re.htm#wp1181595

CFMX 7: http://livedocs.macromedia.com/coldfusion/7/htmldocs/00001263.htm

coldfusion/6/CFML_Reference/Tags-pt218.htm

tahseen — 2005-03-17T09:06:34

Hi,
Is there any way to add a query to another query?
I have a situation where i need to do this (q1+q2), both q1 and q1 will have the same number/type of attributes..its the exact same thing in terms of structure, except the data.
Any alternative way to do this?
any help is appreciated.
thanks

coldfusion/6/CFML_Reference/Tags-pt218.htm

Huggie_ON — 2005-01-26T06:20:37

Question for the Variable name "query_name.columnList "
Is there a way that I can get the items in queryname.Columnlist without being sorted by columns name?
In other word I whish the items in columnlist could be the same order in my select sentence. please help me, thanks

coldfusion/6/CFML_Reference/Tags-pt218.htm

2005-01-17T14:30:58

You can get the column names by using brackets:

SELECT [First Name] FROM table

You should then be able to access them using structure syntax:

queryname["First Name"].RowNumber

coldfusion/6/CFML_Reference/Tags-pt218.htm

chilbe — 2004-10-11T06:35:24

Is there a way to get the access column names that have spaces without aliasing them first? Example: "select `First Name` from ...". Only way I have seen to get it out is to do "select `First Name` as FirstName from ...". I would prefer to maintain the original column name when extracting the data.

coldfusion/6/CFML_Reference/Tags-pt218.htm

GrandNagel — 2004-10-08T16:04:49

Is there a maximum length for the Name parameter of the CFQuery or CFLDap tags?

coldfusion/6/CFML_Reference/Tags-pt218.htm

nectaar — 2003-11-18T04:04:04

The example says:
"Query database for information if cached database information has not been updated in the last six hours; otherwise, use cached data."

This is referring to the following line of code: cachedwithin="#CreateTimeSpan(0, 0, 6, 0)#">

The CreateTimeSpan doc says that is of the format CreateTimeSpan(days, hours, minutes, seconds).

Therefore the example should say "...last six minutes..." or change the code to:
cachedwithin = "#CreateTimeSpan(0, 6, 0, 0)#"

coldfusion/6/CFML_Reference/Tags-pt218.htm

jrunrandy — 2003-11-06T08:47:34

Good one. I have entered this as enhancement request 53695.

coldfusion/6/CFML_Reference/Tags-pt218.htm

smb1@cornell.edu — 2003-11-05T11:21:35

There should be a way to determine the number of rows updated or deleted for UPDATE and DELETE commands. Without this, time based rows but first be selected in order to determine if that can/should be updated or inserted. This is terribl inefficient.

coldfusion/6/CFML_Reference/Tags-pt218.htm

jrunrandy — 2003-10-31T10:40:01

Unfortunately, there is no way, in CFMX or CFMX 6.1 to do this.

coldfusion/6/CFML_Reference/Tags-pt218.htm

bzhou@previsionmarketing. — 2003-10-27T05:59:38

we have extensively used 'connectstring' attribute with the combination of 'dbtype' set to DYNAMIC to query dynamicaly created fixed length files. To do that, we have also dynamicaly created a QUTXT.INI file at the same time. On your document, please provide alternative ways to do the same job without 'connectstring' attribute.

coldfusion/6/CFML_Reference/Tags-pt218.htm

sd1985 — 2003-04-17T11:15:00

above it lists that the blockfactor attribute works with oracle native databases, but Tech note 17462 states that it works with both Oracle Native and ODBC databases. Which is it?

coldfusion/6/CFML_Reference/Tags-pt218.htm

mcumar — 2003-02-22T05:49:00

What about the connection string option? Why was it abandoned so quickly?

coldfusion/6/CFML_Reference/Tags-pt218.htm

carehart@systemanage — 2002-12-30T08:26:00

Regarding the statement above:

New in ColdFusion MX: ColdFusion can index query results and delete index keys

This should be clarified in two ways. First, it's not obvious what's meant by the verb "index", so it should be amended to refer to CFINDEX since it's about creating verity indexes. Second, what's new is the ability to index the results from a CFSEARCH (a search of a verity index, whose results appear as a query). That failed in CF5 but seems to work in CFMX.

You've always been able to index other query results. It seems the sentence should read:

New in ColdFusion MX: ColdFusion can index (using CFINDEX) query results from a CFSEARCH and delete index keys