LiveDocs Comments - coldfusion - 6.1 - htmldocs - functa57.htm

coldfusion/6.1/htmldocs/functa57.htm

Chris Peters — 2005-12-20T07:06:27

I agree with mossy_77's comment.

The workarounds everyone suggested do work in most cases. But if you need to do a UNION operation in a Query of Queries (), you cannot use a query created by QueryNew() in unison with a query from another data source.

If you try UNIONing a query from a database with one created from QueryNew(), you get an error similar to this:

Query Of Queries runtime error.
All resulting columns of queries in a SELECT statement containing a UNION operator must have corresponding types.
Columns with index number equal "2" have diffent types (VARCHAR, OTHER).

coldfusion/6.1/htmldocs/functa57.htm

Cal22 — 2005-05-24T21:11:49

For clearing the variable, adding seemed to work better and made a big difference in processing time for me. (CF 5.0)

coldfusion/6.1/htmldocs/functa57.htm

jrunrandy — 2005-05-24T17:55:45

I just added a second to the example and it seemed to work for me. Maybe just try it and see how it works for you.

coldfusion/6.1/htmldocs/functa57.htm

Cal22 — 2005-05-17T18:19:08

Can this be used to clear a query's contents before repopulating it?

coldfusion/6.1/htmldocs/functa57.htm

2005-02-03T12:35:57

Hi mossy_77,

You can use CreateODBCDate function and assign a date datatype to a query column and perform your actions basing on that column.

I hope for number you can use Val function for adding a numeric values.

Goodluck,

-- Ravi.

coldfusion/6.1/htmldocs/functa57.htm

mossy_77 — 2004-07-22T02:14:34

query Functions, there is no faciltity to add arguments to qualify datatypes in custom built queries. this is needed for integers and dates.