subject:"RE\: Query of Queries"

Acctuly none of the tables have changed at all. Also every query that was using 
query of queries stoped working. Below is the error.

java.sql.SQLException: String index out of range: 17
at coldfusion.sql.JdbcImpl.getConnection(JdbcImpl.java:73)
at coldfusion.sql.JdbcImpl.getConnection(JdbcImpl.java:56)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:214)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:447)
at 
cfdsp_lesson_interface2ecfm1632308106.runPage(/nterface/dsp_lesson_interface.cfm:31)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62)
at 
coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:80)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47)
at 
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:105)
at 
coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at 
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252)
at 
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at 
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192)
at 
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348)
at 
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
at 
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)


 

Have any of the tables changed? Could be that if you're using cfqueryparam
on the original queries and the tables have changed, there might be a column
mis-match.

Adrian

Today our development server got hung up. We had to restart coldfusion and
after the restart all queries using query of queries stopped working. The
error message says (string out of index 7). Our development server is a
linux box with cf 6 installed. If any one has come across this issue please
let me know. 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310204
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Query of Queries

2008-08-05 Thread Dave Phillips

Heath,

Can you run the following in a test.cfm file on your server (OUTSIDE OF YOUR
EXISTING APP):

cfquery datasource=yourdatasource name=qTest
SELECT ID FROM WHATEVER   (just use a simple query here)
/cfquery
cfquery dbtype=query name=qTestQOQ
SELECT ID
FROM qTest
/cfquery
cfdump var=#qTest#
cfdump var=#qTestQOQ#

Just trying to narrow down the issue.

Sincerely,

Dave Phillips

-Original Message-
From: heath stein [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 05, 2008 8:27 AM
To: CF-Talk
Subject: Re: Query of Queries

Acctuly none of the tables have changed at all. Also every query that was
using query of queries stoped working. Below is the error.

java.sql.SQLException: String index out of range: 17
at coldfusion.sql.JdbcImpl.getConnection(JdbcImpl.java:73)
at coldfusion.sql.JdbcImpl.getConnection(JdbcImpl.java:56)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:214)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:447)
at
cfdsp_lesson_interface2ecfm1632308106.runPage(/nterface/dsp_lesson_interface
..cfm:31)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62)
at
coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:80)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47)
at
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistence
Filter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43)
at
coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:105)
at
coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at
jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252)
at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192)
at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:
348)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451
)
at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:29
4)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)


 

Have any of the tables changed? Could be that if you're using cfqueryparam
on the original queries and the tables have changed, there might be a
column
mis-match.

Adrian

Today our development server got hung up. We had to restart coldfusion and
after the restart all queries using query of queries stopped working. The
error message says (string out of index 7). Our development server is a
linux box with cf 6 installed. If any one has come across this issue please
let me know. 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310207
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Query of Queries

Thanks Dave,

I actually did this out side of the current app, on a new table and got the 
same error.

Heath Stein


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310208
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Query of Queries

2008-08-05 Thread Dave Phillips

Yikes!  Have you tried it with a different datasource?  I can't imagine it
is something with the way the database is returning the records, or even the
driver for that matter, however, just to eliminate other possibilities.  I'd
try it with a different datasource (of the same type) and then if you still
get it, a different datasource (of a different type), to rule that out too.
If that still fails, then, since it is a development server, I would go
ahead and reinstall CF and see if that solves the problem.  If that doesn't
work either, then I'm not sure what else to do short of deleting your entire
installation and starting with a fresh new install.

I'm sure you've thought of all that already, but I tried googling (as you
have as well, I'm sure) and don't find any solutions out there on this, and
I'm sure you don't want to be down longer than you need to be.

Sorry I can't be of more help!

Sincerely,

Dave Phillips

-Original Message-
From: heath stein [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 05, 2008 8:55 AM
To: CF-Talk
Subject: Re: Query of Queries

Thanks Dave,

I actually did this out side of the current app, on a new table and got the
same error.

Heath Stein




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310209
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Query of Queries

2008-08-05 Thread Yuliang Ruan

good thing it's the development server :)  

what if you just try:
cfquery type=query
select 1 as id
/cfquery  

no datasources involved.

cfset qfoo=querynew(id)
cfset res=queryaddrow(qfoo,1)
cfset res=querysetcell(qfoo,id,1)

no sql involved. 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310211
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Query of Queries

Thanks Dave,

I am afraid your right we might have to do a re-install. 

Thanks Heath 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310210
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Query of Queries

Query of Queries working again

I did one more restart before I was going to do a re-install and Query of 
Queries magically started working again. Jrun must have not been starting a 
process or something.

Heath



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310212
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Query of Queries

2008-08-05 Thread Yuliang Ruan

cross fingers and start preparing reinstall plan heh 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310214
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Query of Queries

2008-08-05 Thread Claude Schneegans

 I am afraid your right we might have to do a re-install.

If restarting CF fails, and BEFORE reinstalling CF, one could try to 
restart the server.

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310215
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Query of Queries

2008-08-05 Thread Brad Wood

Did you check the logs to see if there were any errors starting ColdFusion 
when QofQ's stopped working?  (Not the run-time error, but an actual startup 
one)

~Brad

- Original Message - 
From: heath stein [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Tuesday, August 05, 2008 9:21 AM
Subject: Re: Query of Queries

 Query of Queries working again

 I did one more restart before I was going to do a re-install and Query of 
 Queries magically started working again. Jrun must have not been starting 
 a process or something.

 Heath

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310222
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Query of Queries Issue

2007-12-28 Thread Raymond Camden

Maybe doing a CAST on the column will help? CF may be seeing the nulls
and assuming the column is a varchar instead of an int.

On Dec 28, 2007 11:28 AM, Flesher, Rob [USA] [EMAIL PROTECTED] wrote:
 All,

 Please forgive me if you get this twice, as it did not appear to post
 the first time.

 I am having an issue with cold fusion query of queries when upgrading to
 MX7.  Previously, when doing a SUM(querycol) in a query of queries when
 all the values of the column were null, the sum would return a 0.  In
 MX7, it is returning a blank string, causing all calculations to error
 out.

 Can someone tell me if CF query of queries has a function similar to
 oracle's NVL?  Basically, what I need to do is NVL(SUM(querycol), 0) to
 insure any null values return as a 0.

 If a function like this doesn't exist, how would you recommend I deal
 with this issue?

 Thanks,
 Rob Flesher


 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295491
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Query of Queries Issue

2007-12-28 Thread Jim Davis

 -Original Message-
 From: Flesher, Rob [USA] [mailto:[EMAIL PROTECTED]
 Sent: Friday, December 28, 2007 12:29 PM
 To: CF-Talk
 Subject: Query of Queries Issue

 All,

 Please forgive me if you get this twice, as it did not appear to post
 the first time.

 I am having an issue with cold fusion query of queries when upgrading
 to
 MX7.  Previously, when doing a SUM(querycol) in a query of queries when
 all the values of the column were null, the sum would return a 0.  In
 MX7, it is returning a blank string, causing all calculations to error
 out.

 Can someone tell me if CF query of queries has a function similar to
 oracle's NVL?  Basically, what I need to do is NVL(SUM(querycol), 0) to
 insure any null values return as a 0.

 If a function like this doesn't exist, how would you recommend I deal
 with this issue?

Well - I'm sure you could do an if outside the query (you can modify
queries manually like any other data structure) but I assume you'd prefer
something in the query itself.

I'm not sure but can you do math in the query?  Something like 
SUM(querycol) + 0 - that should (if it's allowed trigger CFs automatic type
conversion to create a number for you).  For that matter having a zero in
any of the rows should also do it... perhaps adding a dummy row with a zero
value into the original query might be possible?

Something to try at least.

Jim Davis

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295490
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Query of Queries causing server to hang

2007-10-29 Thread Jon Clausen

Graham,

I haven't seen this exact error before, but do you perchance have a  
cflock around the QoQ code?

Query of queries are very expensive on the server and grow more so as  
the record set being manipulated increases.  Many times, the same  
functions performed in QoQ can be performed by rewriting the SQL used  
in the original query to return a more efficient query from the start.

If you must use QoQ with a large record set, you might try adding  
caching to the query to lower the overhead or scoping the manipulated  
record set as appropriate for later re-use.

The lock may be increasing the problem as the thread count stacks up  
while waiting for the ability to lock.  Once that happens, and CF  
reaches the maximum number of requests (as configured in the CF  
Admin) the initial request may not finish and the memory used to  
manipulate and handle the query record set may not be cleared for  
other requests.  I had to do some SQL optimizing last year on a  
client site which was having similar issues.

HTH,

Jon

On Oct 29, 2007, at 8:50 AM, graham bates wrote:

 Over the last few weeks we have noticed our servers starting to  
 queue up and often not recover; upon inspecting the stack trace, we  
 invariably see lines like the following;

 Thread jrpp-485:
  - waiting to lock 0x60597d10 (a java.lang.Class)
 Runing a CFQUERY
 at D:\Live\wwwroot\admin\blah.cfm:109
 Thread jrpp-484:
  - waiting to lock 0x60597d10 (a java.lang.Class)
 Runing a CFQUERY
 at D:\Live\wwwroot\admin\data\blah2.cfm:104
 Thread jrpp-483:
  - waiting to lock 0x60597d10 (a java.lang.Class)
 Runing a CFQUERY
 at D:\Live\cfc\outsource\blah3.cfc:53


 What is interesting, is that when these line numbers are followed,  
 they are always pointing to **Query of Queries**. Has anyone come  
 across this kind of thing before, my searches on these and other  
 forums reveal nothing.

 Many Thanks



 

~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292276
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: query of queries and column aliasing

2007-08-08 Thread Gaulin, Mark

Try col_alias = expression
Mark

-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 08, 2007 6:17 PM
To: CF-Talk
Subject: query of queries and column aliasing

So, it looks like column aliasing isn't valid in query of queries.

For example, the following works:

select foo + ' - ' + foo2 from qry

But this does not:

select foo + ' - ' + foo2 as newfoo from qry

Coldfusion seems to automatically alias the dynamic columns .. as
Column_1 in the case above.

But.. is there any way to do column aliasing in QoQ that I'm missing, or
is it just not supported?

(BTW I'm using CFMX 7.0.2)

--
Rick Root
Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at
www.opensourcecf.com

~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285770
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: query of queries and column aliasing

2007-08-08 Thread Rick Root

Idiot alert, idiot alert!

My alias name was DESC... short for description

Also a reserved word =)

Funny how things work fine when you don't use reserved words.

Rick

~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285773
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Query of Queries date comparison

2007-07-31 Thread Claude Schneegans

 I think he is working with dates

You're right, I didn't notice the CFMX form of the function.

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284933
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Query of Queries date comparison

2007-07-30 Thread Gualtiero Sappa

You can try using data object instead of a string formatted as a date. I 
think the column in your query is of type string.

Bye
Gualtiero

- Original Message - 
From: Mark Lewis [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Monday, July 30, 2007 1:43 PM
Subject: Query of Queries date comparison

 Hi,

 Wondered if someone could advise on this problem I am having.

 I have created a query as shown below...

 cfset event = QueryNew(date, name, destination, date, varchar, 
 varchar)

 cfset newRow = QueryAddRow(event, 2)

 cfset temp = QuerySetCell(event, date, 07/28/2007, 1)
 cfset temp = QuerySetCell(event, name, trip to zoo, 1)
 cfset temp = QuerySetCell(event, destination, london, 1)

 cfset temp = QuerySetCell(event, date, 07/31/2007, 2)
 cfset temp = QuerySetCell(event, name, trip to zoo, 2)
 cfset temp = QuerySetCell(event, destination, london, 2)

 I would like to run a query on this query where it finds only the records 
 where the date is greater than today.

 I have written the following...

  cfquery name=search dbtype=query
   SELECT *
   FROM event
   WHERE date  #DateFormat(Now(),mm/dd/)#
  /cfquery

 However I get an error returned

 Query Of Queries syntax error.
 Encountered date. Incorrect conditional expression, Expected one of 
 [like|null|between|in|comparison] condition, 

 Does this mean I cannot use this greater than (  ) clause on a query of 
 queries, I have searched for some documentation but couldnt find any. I f 
 anyone knows where any could be posted on the web, or a solution to this 
 problem that would be great.

 Thank you in advance

 Mark

~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284786
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Query of Queries date comparison

2007-07-30 Thread Dave Francis

Date is possibly(probably) a reserved word? Even if it isn't, your test
will fail when the year rolls over - you should test /mm/dd.  And I
think you might need apostrophes around today's formatted date?

None of this is guaranteed, I am famous for being wrong.


-Original Message-
From: Mark Lewis [mailto:[EMAIL PROTECTED] 
Sent: Monday, July 30, 2007 7:43 AM
To: CF-Talk
Subject: Query of Queries date comparison

Hi,

Wondered if someone could advise on this problem I am having.

I have created a query as shown below...


cfset event = QueryNew(date, name, destination, date, varchar,
varchar)

cfset newRow = QueryAddRow(event, 2)

cfset temp = QuerySetCell(event, date, 07/28/2007, 1)
cfset temp = QuerySetCell(event, name, trip to zoo, 1)
cfset temp = QuerySetCell(event, destination, london, 1)

cfset temp = QuerySetCell(event, date, 07/31/2007, 2)
cfset temp = QuerySetCell(event, name, trip to zoo, 2)
cfset temp = QuerySetCell(event, destination, london, 2)


I would like to run a query on this query where it finds only the records
where the date is greater than today.

I have written the following...

  cfquery name=search dbtype=query
   SELECT *
   FROM event
   WHERE date  #DateFormat(Now(),mm/dd/)#
  /cfquery

However I get an error returned 

Query Of Queries syntax error.
Encountered date. Incorrect conditional expression, Expected one of
[like|null|between|in|comparison] condition, 

Does this mean I cannot use this greater than (  ) clause on a query of
queries, I have searched for some documentation but couldnt find any. I f
anyone knows where any could be posted on the web, or a solution to this
problem that would be great.

Thank you in advance

Mark



~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284787
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Query of Queries date comparison

2007-07-30 Thread AJ Mercer

Not too sure about this, but have you tried it with GT

maybe also try changing the filed name from date to tripDate - in case it is
a reserved word

On 7/30/07, Mark Lewis [EMAIL PROTECTED] wrote:

 Hi,

 Wondered if someone could advise on this problem I am having.

 I have created a query as shown below...


 cfset event = QueryNew(date, name, destination, date, varchar,
 varchar)

 cfset newRow = QueryAddRow(event, 2)

 cfset temp = QuerySetCell(event, date, 07/28/2007, 1)
 cfset temp = QuerySetCell(event, name, trip to zoo, 1)
 cfset temp = QuerySetCell(event, destination, london, 1)

 cfset temp = QuerySetCell(event, date, 07/31/2007, 2)
 cfset temp = QuerySetCell(event, name, trip to zoo, 2)
 cfset temp = QuerySetCell(event, destination, london, 2)


 I would like to run a query on this query where it finds only the records
 where the date is greater than today.

 I have written the following...

   cfquery name=search dbtype=query
SELECT *
FROM event
WHERE date  #DateFormat(Now(),mm/dd/)#
   /cfquery

 However I get an error returned

 Query Of Queries syntax error.
 Encountered date. Incorrect conditional expression, Expected one of
 [like|null|between|in|comparison] condition, 

 Does this mean I cannot use this greater than (  ) clause on a query of
 queries, I have searched for some documentation but couldnt find any. I f
 anyone knows where any could be posted on the web, or a solution to this
 problem that would be great.

 Thank you in advance

 Mark

 

~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284791
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Query of Queries date comparison

2007-07-30 Thread Ben Nadel

Mark,

I think the problem is the date column. Date is a reserved word, I
think, and must be wrapped in []. Also, I would use a query param as it
takes care of the data type conversion.

cfquery name=search dbtype=query
   SELECT *
   FROM event
   WHERE [date]  cfqueryparam value=#DateFormat(Now(),mm/dd/)#
cfsqltype=CF_SQL_TIMESTAMP /
/cfquery


..
Ben Nadel
Certified Advanced ColdFusion MX7 Developer
www.bennadel.com
 
Need ColdFusion Help?
www.bennadel.com/ask-ben/

-Original Message-
From: Mark Lewis [mailto:[EMAIL PROTECTED] 
Sent: Monday, July 30, 2007 7:43 AM
To: CF-Talk
Subject: Query of Queries date comparison

Hi,

Wondered if someone could advise on this problem I am having.

I have created a query as shown below...


cfset event = QueryNew(date, name, destination, date, varchar,
varchar)

cfset newRow = QueryAddRow(event, 2)

cfset temp = QuerySetCell(event, date, 07/28/2007, 1) cfset temp =
QuerySetCell(event, name, trip to zoo, 1) cfset temp =
QuerySetCell(event, destination, london, 1)

cfset temp = QuerySetCell(event, date, 07/31/2007, 2) cfset temp =
QuerySetCell(event, name, trip to zoo, 2) cfset temp =
QuerySetCell(event, destination, london, 2)


I would like to run a query on this query where it finds only the
records where the date is greater than today.

I have written the following...

  cfquery name=search dbtype=query
   SELECT *
   FROM event
   WHERE date  #DateFormat(Now(),mm/dd/)#
  /cfquery

However I get an error returned 

Query Of Queries syntax error.
Encountered date. Incorrect conditional expression, Expected one of
[like|null|between|in|comparison] condition, 

Does this mean I cannot use this greater than (  ) clause on a query of
queries, I have searched for some documentation but couldnt find any. I
f anyone knows where any could be posted on the web, or a solution to
this problem that would be great.

Thank you in advance

Mark

~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284790
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Query of Queries date comparison

2007-07-30 Thread Mark Lewis

Gualtiero and Dave thanks for your help I have resolved the issue with both 
your tips.

Thank you for your time again

Mark



 Date is possibly(probably) a reserved word? Even if it isn't, your test
 will fail when the year rolls over - you should test /mm/dd.  And I
 think you might need apostrophes around today's formatted date?

 None of this is guaranteed, I am famous for being wrong.



~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284795
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Query of Queries date comparison

2007-07-30 Thread Mark Lewis

Oh sorry, I only just got everyone else's responses through, thank you to 
you guys for your time too.

Much appreciated,

Mark 


~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284796
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Query of Queries date comparison

2007-07-30 Thread Ben Doom

I think you need quotes around your date in the comparison in the SQL. 
But I always have trouble with QoQ syntax for some reason.

--Ben Doom

Mark Lewis wrote:
 Hi,
 
 Wondered if someone could advise on this problem I am having.
 
 I have created a query as shown below...
 
 
 cfset event = QueryNew(date, name, destination, date, varchar, varchar)
 
 cfset newRow = QueryAddRow(event, 2)
 
 cfset temp = QuerySetCell(event, date, 07/28/2007, 1)
 cfset temp = QuerySetCell(event, name, trip to zoo, 1)
 cfset temp = QuerySetCell(event, destination, london, 1)
 
 cfset temp = QuerySetCell(event, date, 07/31/2007, 2)
 cfset temp = QuerySetCell(event, name, trip to zoo, 2)
 cfset temp = QuerySetCell(event, destination, london, 2)
 
 
 I would like to run a query on this query where it finds only the records 
 where the date is greater than today.
 
 I have written the following...
 
   cfquery name=search dbtype=query
SELECT *
FROM event
WHERE date  #DateFormat(Now(),mm/dd/)#
   /cfquery
 
 However I get an error returned 
 
 Query Of Queries syntax error.
 Encountered date. Incorrect conditional expression, Expected one of 
 [like|null|between|in|comparison] condition, 
 
 Does this mean I cannot use this greater than (  ) clause on a query of 
 queries, I have searched for some documentation but couldnt find any. I f 
 anyone knows where any could be posted on the web, or a solution to this 
 problem that would be great.
 
 Thank you in advance
 
 Mark
 
 

~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284794
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Query of Queries date comparison

2007-07-30 Thread Claude Schneegans

 I would like to run a query on this query where it finds only the 
records where the date is greater than today.

You cannot compare dates if they are stored in American format.

Use QuerySetCell(event, date, 2007/07/28, 1) Instead: always with mask 
/mm/dd
Then
WHERE date  #DateFormat(Now(),/mm/dd)#
(you can even forget about slashes)

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284802
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Query of Queries date comparison

2007-07-30 Thread Claude Schneegans

 and yes, since you are actually working with strings, not dates, you 
do need quotes in
WHERE date  '#DateFormat(Now(),/mm/dd)#'

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284803
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Query of Queries date comparison

2007-07-30 Thread Ben Nadel

Claude,

I think he is working with dates; I think the data-type for that column
in Querynew() was date.


..
Ben Nadel
Certified Advanced ColdFusion MX7 Developer
www.bennadel.com
 
Need ColdFusion Help?
www.bennadel.com/ask-ben/

-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED] 
Sent: Monday, July 30, 2007 10:48 AM
To: CF-Talk
Subject: Re: Query of Queries date comparison

. and yes, since you are actually working with strings, not dates,
you do need quotes in WHERE date  '#DateFormat(Now(),/mm/dd)#'

~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284826
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: query of queries question

2007-06-29 Thread Peterson, Chris

I would cache your initial result, and build a set of filters that are
applied to it each time the user updates their filter.  So, you would
have cachedQuery as your initial base search, then filteredQuery that
you would not cache but would always be the result of a QoQ of your
cached query with updated filters applied against it. 



Chris Peterson
Gainey IT
Adobe Certified Advanced Coldfusion Developer

~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ 

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282539
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Query of Queries Question

2007-02-26 Thread Ben Nadel

This is just a guess, but you can try putting either a \ or a '
before the characters that needs to be escaped??

LIKE 'foo\%bar'

Or maybe

LIKE 'foo'%bar'

The single quote is only a guess because single quote escaped another
single quote. 


..
Ben Nadel
Certified Advanced ColdFusion MX7 Developer
www.bennadel.com
 
Need ColdFusion Help?
www.bennadel.com/ask-ben/

-Original Message-
From: Dave Phillips [mailto:[EMAIL PROTECTED] 
Sent: Monday, February 26, 2007 11:32 AM
To: CF-Talk
Subject: Query of Queries Question

Hi,
 
Anyone know how to force a LIKE comparison in a QofQ query to look for
literals of the following special characters:
 
%
_
[
]
^
 
All of the above are characters used in a LIKE comparison, but my string
has several of them in it, so I need to 'escape' them somehow.
 
I'm on MX 6.1.  Thanks!
 
Sincerely,
 
Dave Phillips
President
WebTech Staffing, LLC
[EMAIL PROTECTED]
(817) 473-2119
 





~|
Macromedia ColdFusion MX7
Upgrade to MX7  experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270676
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Query of Queries Question

2007-02-26 Thread Dave Phillips

Tried thatI did finally find it in the docs.  You can actually specify
your own escape character.  So it's like this:

SELECT * FROM whatever WHERE what LIKE '%95\%%' ESCAPE '\'

This will find anything that has 95% in the resultset 'whatever', column
'what'.

It doesn't matter what character you use.  Of course, you want to make sure
that character is not in your text you are queryingso I ended up doing
this:

SELECT * FROM whatever WHERE what LIKE '%95#chr(9)#%%' ESCAPE '#chr(9)#'

Ascii Character 9 is the TAB character and in my circumstance it works well
because I'm comparing URLs and they don't contain tab characters.

Hope this helps someone else who runs into the same thing!

Dave

-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED] 
Sent: Monday, February 26, 2007 10:36 AM
To: CF-Talk
Subject: RE: Query of Queries Question


This is just a guess, but you can try putting either a \ or a ' before
the characters that needs to be escaped??

LIKE 'foo\%bar'

Or maybe

LIKE 'foo'%bar'

The single quote is only a guess because single quote escaped another single
quote. 





~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade  see new features.
http://www.adobe.com/products/coldfusion

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270716
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Query of Queries Problem with JDBC

2007-01-24 Thread Jochem van Dieten

Jerky San Pedro wrote:
I am getting a Query of Query error in CFMX 6.1 when I used a JDBC
driver for PostgreSQL 8.1.

Which error exactly?

I tested CFMX 6.1 in two setups:

One is an FC4 server
The other is a RHEL4 server

In FC4, I installed PostgreSQL 8.1 and connected CFMX using the
recommended JDBC3 and JDBC2, each in alternate trials. Both trials
issued a query of queries (QofQ) error, which I heard of is inherent
in FC4. With that, I removed PostgreSQL 8.1 and downgraded to 7.4 and
used the recommended JDBC for 7.4. It worked fine. I don't get any
QofQ errors.

Have you tried the combination of CF 6.1, PostgreSQL 8.2.1 and the
postgresql-8.2-504.jdbc3.jar driver?

In RHEL4, I installed PostgreSQL 7.4 first. It worked fine. No QofQ
errors. I wasn't able to fully install PostgreSQL version 8.1 for
RHEL4. Thus I tried something else: I removed the JDBC JVM mapping for
7.4 in CFMX administrator and installed an 8.1 JDBC2 JVM mapping. I
connected to a remote PostgreSQL 8.1 database. It worked. No errors.
QofQ OK. Problem is my database is remote, which is a different
scenario from my FC4's setup. My problem at this point is semi-solved.

What happens if you don't register the PostgreSQL JDBC driver in your
classpath, but just drop it in the /WEB-INF/cfusion/lib/ directory and restart
the instance?

But since the best scenario is sticking to PostgreSQL 7.4, I might
just stick to it.

1. If I am using simple queries available, would my using a 7.4 JDBC
driver to connect to an 8.1 database cause any problems?

PostgreSQL servers and JDBC drivers each support multiple versions of the
protocol. Any JDBC driver for 7.4 or later will connect to any server version
7.4 or later. I would not downgrade the server just because I needed an older
driver.

2. Has anyone encountered this?

3. How will you know what JDBC driver is suitable for you? I thought
CFMX comes with its own JDK, which is version 1.4, thus JDBC3. How
come JDBC2 works well, or does it really?

Because CF MX / 7 only uses JDBC2.

Jochem

PS Have you applied for the Scorpio beta yet?
https://prerelease.adobe.com/callout/apply.html?callid={E9F64ADB-DADA-485E-BFFE-60E0D783EBEF}

~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 MX7 integration create powerful cross-platform RIAs
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267444
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Query of Queries Problem with JDBC

2007-01-24 Thread Jerky San Pedro

Hello Jochem,

The error I am getting is that ColdFusion MX gets an error executing Query of 
Queries.

Well, here's my testing code:
---
cfquery name=qryName datasource=#REQUEST.DNS#
SELECT  a.*
FROMstatscountries a
JOIN(
SELECT  isocode
FROMstatscountries
WHERE   isocode LIKE '%A%'
) b
ON  a.isocode = b.isocode
WHERE   a.isocode LIKE '%U%'
/cfquery

cfquery name=qofq dbtype=query
SELECT  *
FROMqryName
WHERE   isocode LIKE '%U%'
/cfquery

cfoutput
#qofq.RecordCount#
/cfoutput
-

Then, the error I get when I execute it is:

=
Error Occurred While Processing Request
Error Executing Database Query.
 
The error occurred in /var/www/html/circus/index.cfm: line 14

12 : /cfquery
13 : 
14 : cfquery name=qofq dbtype=query
15 : SELECT * 
16 : FROM   qryName

SQLSELECT * FROM qryName WHERE isocode LIKE '%U%'

java.sql.SQLException
at coldfusion.sql.JdbcImpl.getConnection(JdbcImpl.java:73)
at coldfusion.sql.JdbcImpl.getConnection(JdbcImpl.java:56)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:207)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:447)
at cfindex2ecfm1734096888.runPage(/var/www/html/circus/index.cfm:14)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62)
at 
coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:80)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47)
at 
coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
at 
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:105)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at 
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252)
at 
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at 
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192)
at 
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348)
at 
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
at 
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
==

The problem shoots randomly after the CFMX server starts. Sometimes it occurs 
in a fluid succession, sometimes it seems fixed but would get crappy after one 
restart.

I've also tried dropping in the JDBC drivers at those directories, then restart 
the server, but I still get the error. As for using a 7.4 JDBC to access an 8.1 
database, it gets an error on some encoding, particularly on trailing spaces, 
which I don't get when I use an 8.1 JDBC.

On using PostgreSQL 8.2 with CFMX, I haven't tried it, and I am not sure if the 
RPMs would install properly on my FC4. If I remember it right, I think I have 
tried installing 8.2 and the RPMs went searching for some .so# that I don't 
have.

Does CFMX really use JDBC2? I thought JVM 1.4 uses JDBC3. Isn't the JVM that 
comes with ColdFusion version 1.4? So shouldn't I use JDBC3 (although JDBC2 
works, anyway).

Anyways, thanks for the advices, and I'll see 8.2.

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267569
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Query of Queries Problem with JDBC

2007-01-23 Thread Dave Watts

2. Has anyone encountered this? What did you do?

I haven't encountered this. But there are a couple of things I would
suggest.

First, have you considered upgrading to CFMX 7.0.2?

Second, have you considered upgrading the JVM? You should be able to upgrade
to a later 1.4.2 JVM.

3. How will you know what JDBC driver is suitable for you? I
thought CFMX comes with its own JDK, which is version 1.4,
thus JDBC3. How come JDBC2 works well, or does it really?

CFMX does come with its own JVM, which for CFMX 6.1 is 1.4.2 base or
1.4.2_05, I forget which. The CF Administrator will tell you what JVM
version you're using.

Newer JVMs should still be able to run JDBC2 applications, I think.

And, as for which JDBC driver is suitable, that's really up in the air. If
you can use the JDBC drivers that come with CF, well, most people just do
that. That obviously won't work with PostgreSQL, so you use whatever works
for you. I've seen all sorts of different JDBC drivers used with CF, and
there's typically no one best answer to this question. I've seen some odd
cases where the ODBC bridge provides better performance than the type 4 JDBC
drivers, and frankly that's just crazy to me.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267418
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Query of Queries Problem with JDBC

2007-01-23 Thread Jerky San Pedro

Thanks, then. I guess I'd better stick to 7.4 and MX for the mean time.

2. Has anyone encountered this? What did you do?

I haven't encountered this. But there are a couple of things I would
suggest.

First, have you considered upgrading to CFMX 7.0.2?

Second, have you considered upgrading the JVM? You should be able to upgrade
to a later 1.4.2 JVM.

3. How will you know what JDBC driver is suitable for you? I
thought CFMX comes with its own JDK, which is version 1.4,
thus JDBC3. How come JDBC2 works well, or does it really?

CFMX does come with its own JVM, which for CFMX 6.1 is 1.4.2 base or
1.4.2_05, I forget which. The CF Administrator will tell you what JVM
version you're using.

Newer JVMs should still be able to run JDBC2 applications, I think.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267430
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Query of Queries question

2007-01-05 Thread Jacob Munson

Does the result /have/ to be a query? Could you make a structure
instead, using your cfoutput method? That should be pretty quick.

On 1/5/07, Dave Phillips [EMAIL PROTECTED] wrote:
Does anyone know if it's possible to extract a 'subset' of records in a query
utilizing Query of Queries? Basically I want to do something like this:

cfquery name=qMyQuery dbtype=query
SELECT *
FROM qSomeQuery
WHERE currentRow = 21 AND currentRow 41
ORDERY BY LastName
/cfquery

Of course, this doesn't work because currentrow does not specify the row
number inside of a Query, only when you are working with the query results
directly (like qSomeQuery.currentRow).

Anyone know how this is possible? The only thing I can think of doing is
something like this:

cfoutput name=qSomeQuery startRow=21 maxrows=40
*** In here I would build a new query with only the rows available as I
loop through with functions like queryAddRow() and querySetCell().
/cfoutput

This idea would not be very efficient, so I'm looking for an alternative
method.

Thanks for your help in advance!

Dave

~|
Create robust enterprise, web RIAs.
Upgrade integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265815
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Query of Queries question

2007-01-05 Thread Greg Morphis

not sure what DB you're using.. but with Oracle you can do this in a subquery
select * from
(
select rownum as rn, n.*
From navmenu n
)
where rn = 5 and rn = 7



On 1/5/07, Dave Phillips [EMAIL PROTECTED] wrote:
 Does anyone know if it's possible to extract a 'subset' of records in a query 
 utilizing Query of Queries?  Basically I want to do something like this:

 cfquery name=qMyQuery dbtype=query
 SELECT *
 FROM qSomeQuery
 WHERE currentRow = 21 AND currentRow  41
 ORDERY BY LastName
 /cfquery

 Of course, this doesn't work because currentrow does not specify the row 
 number inside of a Query, only when you are working with the query results 
 directly (like qSomeQuery.currentRow).

 Anyone know how this is possible?  The only thing I can think of doing is 
 something like this:

 cfoutput name=qSomeQuery startRow=21 maxrows=40
*** In here I would build a new query with only the rows available as I 
 loop through with functions like queryAddRow() and querySetCell().
 /cfoutput

 This idea would not be very efficient, so I'm looking for an alternative 
 method.

 Thanks for your help in advance!

 Dave

 

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265817
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Query of Queries question

2007-01-05 Thread Dave Phillips

The query is not coming from a DB.  It is actually coming from a CFSEARCH tag, 
so unfortunately, I can't use this method.

not sure what DB you're using.. but with Oracle you can do this in a subquery
select * from
(
select rownum as rn, n.*
From navmenu n
)
where rn = 5 and rn = 7



On 1/5/07, Dave Phillips [EMAIL PROTECTED] wrote:


~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265870
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Query of Queries question

2007-01-05 Thread Terry Sta . Maria

You don't necessarily have to create a query from scratch.  Instead, if there 
is a column (with a simple datatype) that uniquely identifies each row, this 
can be done with a list and a query of queries.

If qMyQuery.id is such a column, then you can get those all into a list:

cfset list_id = ''
cfloop query=qMyQuery
 cfif qMyQuery.currentRow gte int_rowStart and qMyQuery.currentRow lte 
int_rowEnd
  cfset list_id = listAppend(list_id, qMyQuery.id)
 cfelseif qMyQuery.currentRow gt int_rowEnd
  cfbreak
 /cfif
/cfloop

Then you can do your query of queries with this list:
cfquery dbtype=query
 SELECT * 
 FROM qMyQuery 
 WHERE id IN (#list_id#) 
/cfquery

If your id column isn't numeric, you can loop through the list creating LIKE 
clauses for string, or similar comparisons for other simple data types.


Hope this helps.

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265872
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Query of Queries question

2007-01-05 Thread Snake

Or even easier, without the loop.

cfset list_id = ValueList(qMyQuery.id)
cfquery dbtype=query
 SELECT * 
 FROM qMyQuery 
 WHERE id IN (#list_id#)
/cfquery

--
Russ
 

-Original Message-
From: Terry Sta. Maria [mailto:[EMAIL PROTECTED] 
Sent: 05 January 2007 20:52
To: CF-Talk
Subject: Re: Query of Queries question

You don't necessarily have to create a query from scratch.  Instead, if
there is a column (with a simple datatype) that uniquely identifies each
row, this can be done with a list and a query of queries.

If qMyQuery.id is such a column, then you can get those all into a list:

cfset list_id = ''
cfloop query=qMyQuery
 cfif qMyQuery.currentRow gte int_rowStart and qMyQuery.currentRow lte
int_rowEnd
  cfset list_id = listAppend(list_id, qMyQuery.id)
 cfelseif qMyQuery.currentRow gt int_rowEnd
  cfbreak
 /cfif
/cfloop

Then you can do your query of queries with this list:
cfquery dbtype=query
 SELECT * 
 FROM qMyQuery 
 WHERE id IN (#list_id#)
/cfquery

If your id column isn't numeric, you can loop through the list creating
LIKE clauses for string, or similar comparisons for other simple data
types.


Hope this helps.



~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265875
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Query of Queries question

2007-01-05 Thread Jon Gunnip

You could also add a RowNumber column to your query:

cfset QueryAddColumn(qSomeQuery, RowNumber) 
cfloop from=1 to=qSomeQuery.RecordCount index=RowNumber 
  cfset QuerySetCell(qSomeQuery, RowNumber, RowNumber, RowNumber) 
/cfloop

Then, do:
cfquery name=qMyQuery dbtype=query
SELECT *
FROM qSomeQuery
WHERE RowNumber = 21 AND RowNumber  41
ORDERY BY LastName
/cfquery

Not sure what the performance hit on doing this would be.

Jon


On 1/5/07, Dave Phillips [EMAIL PROTECTED] wrote:
 Does anyone know if it's possible to extract a 'subset' of records in a query 
 utilizing Query of Queries?  Basically I want to do something like this:

 cfquery name=qMyQuery dbtype=query
 SELECT *
 FROM qSomeQuery
 WHERE currentRow = 21 AND currentRow  41
 ORDERY BY LastName
 /cfquery

 Of course, this doesn't work because currentrow does not specify the row 
 number inside of a Query, only when you are working with the query results 
 directly (like qSomeQuery.currentRow).

 Anyone know how this is possible?  The only thing I can think of doing is 
 something like this:

 cfoutput name=qSomeQuery startRow=21 maxrows=40
*** In here I would build a new query with only the rows available as I 
 loop through with functions like queryAddRow() and querySetCell().
 /cfoutput

 This idea would not be very efficient, so I'm looking for an alternative 
 method.

 Thanks for your help in advance!

 Dave

 

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265888
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Query of Queries - showing all entries from DB1

2006-08-19 Thread Roberto Perez

At 09:29 AM 8/18/2006, Kevin Roche wrote:

I think its just a matter of:

1/ Do an Inner Join with QonQ

2/ Do a QonQ query on the left hand table that creates an exact similar
result set with null entries for any right table fields and omits any rows
from the first query.

3/ Do a QonQ which does a UNION of the the first two.

You may have problems with this if the results of 1 are large and can't be
converted quickly into a list.


Well, I was hoping there would be an easier way. I guess I can import 
the table in DB2 into DB1 and just do a usual left join with the two 
tables now inside the same DB. I was hoping the QoQ syntax would 
allow for a left outer join, but it looks like it doesn't.  :-(

Thanks,

Roberto 


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250375
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Query of Queries - showing all entries from DB1

2006-08-18 Thread Roberto Perez

At 07:30 AM 8/18/2006, you wrote:
I think with a query of queries, you can do a left outer join using *=
syntax:

SELECT
 *
FROM
 table1,
 table2
WHERE
 table1.id *= table2.fkey

I AM NOT SURE OF THIS. But I think I read it somewhere.


Thanks for the input. I tried it, but CFMX did not like the syntax 
(I'm using Access, if that makes a difference).

I found a link to a fake left outer join script at
http://instantbadger.blogspot.com/2006/07/faking-left-outer-join-in-query-of.html

A left outer join sound just like what I need to do. Is there an 
easier way to do it (easier than what is described in the link above)?

Thanks in advance,

Roberto Perez
[EMAIL PROTECTED]


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250273
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Query of Queries - showing all entries from DB1

2006-08-18 Thread James Holmes

I was going to suggest a union, so that link you found is the way to go IMO.

On 8/18/06, Roberto Perez [EMAIL PROTECTED] wrote:

 I found a link to a fake left outer join script at
 http://instantbadger.blogspot.com/2006/07/faking-left-outer-join-in-query-of.html

 A left outer join sound just like what I need to do. Is there an
 easier way to do it (easier than what is described in the link above)?
--
CFAJAX docs and other useful articles:
http://www.bifrost.com.au/blog/

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250279
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Query of Queries - showing all entries from DB1

2006-08-18 Thread Kevin Roche

Roberto,

I would suggest a similar series of steps but the link gives a rather
complex example since they are trying to write a generic version that works
out foir itself waht the queries are. If you do it yourself it may be easier
to understand, and it may be possible to make it perform better.

I think its just a matter of:

1/ Do an Inner Join with QonQ

2/ Do a QonQ query on the left hand table that creates an exact similar
result set with null entries for any right table fields and omits any rows
from the first query.

3/ Do a QonQ which does a UNION of the the first two.

You may have problems with this if the results of 1 are large and can't be
converted quickly into a list.

Kevin



-Original Message-
From: Roberto Perez [mailto:[EMAIL PROTECTED]
Sent: 18 August 2006 12:58
To: CF-Talk
Subject: RE: Query of Queries - showing all entries from DB1


At 07:30 AM 8/18/2006, you wrote:
I think with a query of queries, you can do a left outer join using *=
syntax:

SELECT
 *
FROM
 table1,
 table2
WHERE
 table1.id *= table2.fkey

I AM NOT SURE OF THIS. But I think I read it somewhere.


Thanks for the input. I tried it, but CFMX did not like the syntax
(I'm using Access, if that makes a difference).

I found a link to a fake left outer join script at
http://instantbadger.blogspot.com/2006/07/faking-left-outer-join-in-query-of
..html

A left outer join sound just like what I need to do. Is there an
easier way to do it (easier than what is described in the link above)?

Thanks in advance,

Roberto Perez
[EMAIL PROTECTED]




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250287
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Query of Queries

I have never seen this specifically, but I have gotten similar errors when I
try to define a query with QueryNew() sending in data types... Are you using
QueryNew() to define any query that you are queryying?

...
Ben Nadel 
Web Developer
Nylon Technology
350 7th Avenue
Floor 10
New York, NY 10001
212.691.1134
212.691.3477 fax
www.nylontechnology.com
 
You know, like nunchuck skills, bowhunting skills, computer hacking
skills... Girls only want boyfriends who have great skills.
- Napoleon Dynamite
-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED] 
Sent: Friday, May 12, 2006 9:31 AM
To: CF-Talk
Subject: Query of Queries

I'm getting the following error:

Query Of Queries runtime error./bbr Cannot apply the binary numeric
operator [*|/] on a non numeric type

When running the following query of queries:

select
sum(QUANTITY) AS QUANTITY,
SUM(QUANTITY*OPTION_PRICE) AS MERCH_CHARGE
FROM contents

I dumped the contents of the contents query and both QUANTITY and
OPTION_PRICE contain numeric values.

I've never seen this error before and this code hasn't changed from a
previous installation of the same code on a different server.

This server is at smarterlinux, it's coldfusion mx 7 7,0,1,116466

Rick



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240317
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Query of Queries

2006-05-12 Thread Michael Dinowitz

When creating a query using QueryNew() you  can add an optional second 
attribute to it which will define each column as a specific data type. This 
will avoid the error:

QueryNew(columnlist, [columntypelist])

Michael Dinowitz
Host: House of Fusion
http://www.houseoffusion.com
Publisher: Fusion Authority
http://www.fusionauthority.com




I have never seen this specifically, but I have gotten similar errors when 
I
 try to define a query with QueryNew() sending in data types... Are you 
 using
 QueryNew() to define any query that you are queryying?

 ...
 Ben Nadel
 Web Developer
 Nylon Technology
 350 7th Avenue
 Floor 10
 New York, NY 10001
 212.691.1134
 212.691.3477 fax
 www.nylontechnology.com

 You know, like nunchuck skills, bowhunting skills, computer hacking
 skills... Girls only want boyfriends who have great skills.
 - Napoleon Dynamite
 -Original Message-
 From: Rick Root [mailto:[EMAIL PROTECTED]
 Sent: Friday, May 12, 2006 9:31 AM
 To: CF-Talk
 Subject: Query of Queries

 I'm getting the following error:

 Query Of Queries runtime error./bbr Cannot apply the binary numeric
 operator [*|/] on a non numeric type

 When running the following query of queries:

 select
 sum(QUANTITY) AS QUANTITY,
 SUM(QUANTITY*OPTION_PRICE) AS MERCH_CHARGE
 FROM contents

 I dumped the contents of the contents query and both QUANTITY and
 OPTION_PRICE contain numeric values.

 I've never seen this error before and this code hasn't changed from a
 previous installation of the same code on a different server.

 This server is at smarterlinux, it's coldfusion mx 7 7,0,1,116466

 Rick



 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240318
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Query of Queries

Michael,

I have actually had problems where the data type caused a problem. I was
building a query based on score, all of which were of type Integer...
When dumping the query, all values were numeric... However when sorting on
the column, it would throw errors about trying to sort on non-numeric types.
If I stopped sending in the Data types to QueryNew(), worked perfect.

This is the line that was causing the error. If this line didn't get called,
the sort worked fine:

cfset REQUEST.SearchQuery[ score ][ REQUEST.SearchQuery.CurrentRow ] = 
  Min(
(
   REQUEST.SearchQuery[ score ][ REQUEST.SearchQuery.CurrentRow ] + 
   Ceiling(100 / ArrayLen(arrCriteria))
 ), 
 80
   ) /

This line only gets called if there is an ArrayLen()... Score always
defaults to zero... I can't see anyway for this to return anything but a
numeric value. Yet, if I comment it out, the sort would work fine. There was
not code afterwards that would be affected by it (no conditional logic
affected by my commenting out the line). 

And like I said, if I look out the data type passing, works great.

Seems like a bug to me.

...
Ben Nadel 
Web Developer
Nylon Technology
350 7th Avenue
Floor 10
New York, NY 10001
212.691.1134
212.691.3477 fax
www.nylontechnology.com
 
You know, like nunchuck skills, bowhunting skills, computer hacking
skills... Girls only want boyfriends who have great skills.
- Napoleon Dynamite
-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED] 
Sent: Friday, May 12, 2006 9:42 AM
To: CF-Talk
Subject: Re: Query of Queries

When creating a query using QueryNew() you  can add an optional second
attribute to it which will define each column as a specific data type. This
will avoid the error:

QueryNew(columnlist, [columntypelist])

Michael Dinowitz
Host: House of Fusion
http://www.houseoffusion.com
Publisher: Fusion Authority
http://www.fusionauthority.com




I have never seen this specifically, but I have gotten similar errors 
when I  try to define a query with QueryNew() sending in data types... 
Are you  using
 QueryNew() to define any query that you are queryying?

 ...
 Ben Nadel
 Web Developer
 Nylon Technology
 350 7th Avenue
 Floor 10
 New York, NY 10001
 212.691.1134
 212.691.3477 fax
 www.nylontechnology.com

 You know, like nunchuck skills, bowhunting skills, computer hacking 
 skills... Girls only want boyfriends who have great skills.
 - Napoleon Dynamite
 -Original Message-
 From: Rick Root [mailto:[EMAIL PROTECTED]
 Sent: Friday, May 12, 2006 9:31 AM
 To: CF-Talk
 Subject: Query of Queries

 I'm getting the following error:

 Query Of Queries runtime error./bbr Cannot apply the binary 
 numeric operator [*|/] on a non numeric type

 When running the following query of queries:

 select
 sum(QUANTITY) AS QUANTITY,
 SUM(QUANTITY*OPTION_PRICE) AS MERCH_CHARGE FROM contents

 I dumped the contents of the contents query and both QUANTITY and 
 OPTION_PRICE contain numeric values.

 I've never seen this error before and this code hasn't changed from a 
 previous installation of the same code on a different server.

 This server is at smarterlinux, it's coldfusion mx 7 7,0,1,116466

 Rick



 



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240320
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Query of Queries

Ben Nadel wrote:
 I have never seen this specifically, but I have gotten similar errors when I
 try to define a query with QueryNew() sending in data types... Are you using
 QueryNew() to define any query that you are queryying?

Nope.

contents is a query returned from a CFC, and both fields are numeric fields.

Rick

 -Original Message-
 From: Rick Root [mailto:[EMAIL PROTECTED] 
 Sent: Friday, May 12, 2006 9:31 AM
 To: CF-Talk
 Subject: Query of Queries
 
 I'm getting the following error:
 
 Query Of Queries runtime error./bbr Cannot apply the binary numeric
 operator [*|/] on a non numeric type
 
 When running the following query of queries:
 
   select
   sum(QUANTITY) AS QUANTITY,
   SUM(QUANTITY*OPTION_PRICE) AS MERCH_CHARGE
   FROM contents
 
 I dumped the contents of the contents query and both QUANTITY and
 OPTION_PRICE contain numeric values.
 
 I've never seen this error before and this code hasn't changed from a
 previous installation of the same code on a different server.
 
 This server is at smarterlinux, it's coldfusion mx 7 7,0,1,116466
 
 Rick
 
 
 
 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240321
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Query of Queries

2006-05-12 Thread Michael Dinowitz

Can you send me a full code sample to look at? I'd like to play with it a 
bit to see what's up. I've been finding a number of (rare) issues with CF 
tags, functions and combinations of syntax. I'm logging them all to 
www.blogoffusion.com and this looks like another one to go up there.
Thanks


 Michael,

 I have actually had problems where the data type caused a problem. I was
 building a query based on score, all of which were of type Integer...
 When dumping the query, all values were numeric... However when sorting on
 the column, it would throw errors about trying to sort on non-numeric 
 types.
 If I stopped sending in the Data types to QueryNew(), worked perfect.

 This is the line that was causing the error. If this line didn't get 
 called,
 the sort worked fine:

 cfset REQUEST.SearchQuery[ score ][ REQUEST.SearchQuery.CurrentRow ] =
  Min(
(
   REQUEST.SearchQuery[ score ][ REQUEST.SearchQuery.CurrentRow ] +
   Ceiling(100 / ArrayLen(arrCriteria))
 ),
 80
   ) /

 This line only gets called if there is an ArrayLen()... Score always
 defaults to zero... I can't see anyway for this to return anything but a
 numeric value. Yet, if I comment it out, the sort would work fine. There 
 was
 not code afterwards that would be affected by it (no conditional logic
 affected by my commenting out the line).

 And like I said, if I look out the data type passing, works great.

 Seems like a bug to me.

 ...
 Ben Nadel
 Web Developer
 Nylon Technology
 350 7th Avenue
 Floor 10
 New York, NY 10001
 212.691.1134
 212.691.3477 fax
 www.nylontechnology.com

 You know, like nunchuck skills, bowhunting skills, computer hacking
 skills... Girls only want boyfriends who have great skills.
 - Napoleon Dynamite
 -Original Message-
 From: Michael Dinowitz [mailto:[EMAIL PROTECTED]
 Sent: Friday, May 12, 2006 9:42 AM
 To: CF-Talk
 Subject: Re: Query of Queries

 When creating a query using QueryNew() you  can add an optional second
 attribute to it which will define each column as a specific data type. 
 This
 will avoid the error:

 QueryNew(columnlist, [columntypelist])

 Michael Dinowitz
 Host: House of Fusion
http://www.houseoffusion.com
 Publisher: Fusion Authority
http://www.fusionauthority.com




I have never seen this specifically, but I have gotten similar errors
when I  try to define a query with QueryNew() sending in data types...
Are you  using
 QueryNew() to define any query that you are queryying?

 ...
 Ben Nadel
 Web Developer
 Nylon Technology
 350 7th Avenue
 Floor 10
 New York, NY 10001
 212.691.1134
 212.691.3477 fax
 www.nylontechnology.com

 You know, like nunchuck skills, bowhunting skills, computer hacking
 skills... Girls only want boyfriends who have great skills.
 - Napoleon Dynamite
 -Original Message-
 From: Rick Root [mailto:[EMAIL PROTECTED]
 Sent: Friday, May 12, 2006 9:31 AM
 To: CF-Talk
 Subject: Query of Queries

 I'm getting the following error:

 Query Of Queries runtime error./bbr Cannot apply the binary
 numeric operator [*|/] on a non numeric type

 When running the following query of queries:

 select
 sum(QUANTITY) AS QUANTITY,
 SUM(QUANTITY*OPTION_PRICE) AS MERCH_CHARGE FROM contents

 I dumped the contents of the contents query and both QUANTITY and
 OPTION_PRICE contain numeric values.

 I've never seen this error before and this code hasn't changed from a
 previous installation of the same code on a different server.

 This server is at smarterlinux, it's coldfusion mx 7 7,0,1,116466

 Rick







 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240322
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Query of Queries

Anyone else got any ideas on this?  contents is a regular query result 
set, not anything made by QueryNew()... and the columns in question are 
both numeric columns (quantity is an integer and option_price is a 
decimal(10,2)... mysql database)

Rick

Rick Root wrote:
 I'm getting the following error:
 
 Query Of Queries runtime error./bbr Cannot apply the binary numeric 
 operator [*|/] on a non numeric type
 
 When running the following query of queries:
 
   select
   sum(QUANTITY) AS QUANTITY,
   SUM(QUANTITY*OPTION_PRICE) AS MERCH_CHARGE
   FROM contents
 
 I dumped the contents of the contents query and both QUANTITY and 
 OPTION_PRICE contain numeric values.
 
 I've never seen this error before and this code hasn't changed from a 
 previous installation of the same code on a different server.
 
 This server is at smarterlinux, it's coldfusion mx 7 7,0,1,116466


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240342
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Query of Queries

Do any parts of the query work? Meaning, If you run with just the first SUM
directive does it work? Does it work if you do not do the * in the second
SUM? Let's see if we can narrow it down to exactly what is breaking?

...
Ben Nadel 
Web Developer
Nylon Technology
350 7th Avenue
Floor 10
New York, NY 10001
212.691.1134
212.691.3477 fax
www.nylontechnology.com
 
You know, like nunchuck skills, bowhunting skills, computer hacking
skills... Girls only want boyfriends who have great skills.
- Napoleon Dynamite
-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED] 
Sent: Friday, May 12, 2006 11:47 AM
To: CF-Talk
Subject: Re: Query of Queries

Anyone else got any ideas on this?  contents is a regular query result
set, not anything made by QueryNew()... and the columns in question are both
numeric columns (quantity is an integer and option_price is a
decimal(10,2)... mysql database)

Rick

Rick Root wrote:
 I'm getting the following error:
 
 Query Of Queries runtime error./bbr Cannot apply the binary 
 numeric operator [*|/] on a non numeric type
 
 When running the following query of queries:
 
   select
   sum(QUANTITY) AS QUANTITY,
   SUM(QUANTITY*OPTION_PRICE) AS MERCH_CHARGE
   FROM contents
 
 I dumped the contents of the contents query and both QUANTITY and 
 OPTION_PRICE contain numeric values.
 
 I've never seen this error before and this code hasn't changed from a 
 previous installation of the same code on a different server.
 
 This server is at smarterlinux, it's coldfusion mx 7 7,0,1,116466




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240347
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Query of Queries

2006-05-12 Thread Munson, Jacob

Did you try putting Val() around quantity and option_price, just to make
sure CF isn't doing something funny? 

 -Original Message-
 From: Rick Root [mailto:[EMAIL PROTECTED] 
 Sent: Friday, May 12, 2006 9:47 AM
 
 Anyone else got any ideas on this?  contents is a regular 
 query result 
 set, not anything made by QueryNew()... and the columns in 
 question are 
 both numeric columns (quantity is an integer and option_price is a 
 decimal(10,2)... mysql database)
 
 Rick
 
 Rick Root wrote:
  I'm getting the following error:
  
  Query Of Queries runtime error./bbr Cannot apply the 
 binary numeric 
  operator [*|/] on a non numeric type
  
  When running the following query of queries:
  
  select
  sum(QUANTITY) AS QUANTITY,
  SUM(QUANTITY*OPTION_PRICE) AS MERCH_CHARGE
  FROM contents
  
  I dumped the contents of the contents query and both 
 QUANTITY and 
  OPTION_PRICE contain numeric values.
  
  I've never seen this error before and this code hasn't 
 changed from a 
  previous installation of the same code on a different server.
  
  This server is at smarterlinux, it's coldfusion mx 7 7,0,1,116466

This transmission may contain information that is privileged, confidential 
and/or exempt from disclosure under applicable law. If you are not the intended 
recipient, you are hereby notified that any disclosure, copying, distribution, 
or use of the information contained herein (including any reliance thereon) is 
STRICTLY PROHIBITED. If you received this transmission in error, please 
immediately contact the sender and destroy the material in its entirety, 
whether in electronic or hard copy format. Thank you. A1.



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240350
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Query of Queries

2006-05-12 Thread Josh Nathanson

Total stab in the dark but maybe you could try changing the alias for 
QUANTITY so it's not the same name as the column name itself?  Maybe that's 
messing things up somehow.

-- Josh

- Original Message - 
From: Rick Root [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Friday, May 12, 2006 8:47 AM
Subject: Re: Query of Queries

 Anyone else got any ideas on this?  contents is a regular query result
 set, not anything made by QueryNew()... and the columns in question are
 both numeric columns (quantity is an integer and option_price is a
 decimal(10,2)... mysql database)

 Rick

 Rick Root wrote:
 I'm getting the following error:

 Query Of Queries runtime error./bbr Cannot apply the binary numeric
 operator [*|/] on a non numeric type

 When running the following query of queries:

 select
 sum(QUANTITY) AS QUANTITY,
 SUM(QUANTITY*OPTION_PRICE) AS MERCH_CHARGE
 FROM contents

 I dumped the contents of the contents query and both QUANTITY and
 OPTION_PRICE contain numeric values.

 I've never seen this error before and this code hasn't changed from a
 previous installation of the same code on a different server.

 This server is at smarterlinux, it's coldfusion mx 7 7,0,1,116466

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240352
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Query of Queries

Ben Nadel wrote:
 Do any parts of the query work? Meaning, If you run with just the first SUM
 directive does it work? Does it work if you do not do the * in the second
 SUM? Let's see if we can narrow it down to exactly what is breaking?

It is definately this one causing the problem:

select
SUM(QUANTITY*OPTION_PRICE) AS MERCH_CHARGE
FROM contents

Both values are numeric (I output #isNumeric(contents.QUANTITY)# and 
#isNumeric(contents.OPTION_PRICE)#

The values are 1 and 16.99



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240357
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Query of Queries

I ran this query and got a different error:

select
SUM((OPTION_PRICE+0)) AS MERCH_CHARGE
FROM contents

Cannot mix types VARCHAR and BIGINT in a + binary operation

so it looks like for some reason, coldfusion things OPTION_PRICE is a 
varchar, even though the column type in the database is DECIMAL(10,2)

Rick

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240358
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Query of Queries

2006-05-12 Thread Mark A Kruger

Rick,

What happens when you just do quantity + option_price

-Mark
 

-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED] 
Sent: Friday, May 12, 2006 11:48 AM
To: CF-Talk
Subject: Re: Query of Queries

Ben Nadel wrote:
 Do any parts of the query work? Meaning, If you run with just the 
 first SUM directive does it work? Does it work if you do not do the 
 * in the second SUM? Let's see if we can narrow it down to exactly what
is breaking?

It is definately this one causing the problem:

select
SUM(QUANTITY*OPTION_PRICE) AS MERCH_CHARGE FROM contents

Both values are numeric (I output #isNumeric(contents.QUANTITY)# and
#isNumeric(contents.OPTION_PRICE)#

The values are 1 and 16.99





~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240359
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Query of Queries

2006-05-12 Thread Munson, Jacob

Try using the val() function. 

 -Original Message-
 From: Rick Root [mailto:[EMAIL PROTECTED] 
 Sent: Friday, May 12, 2006 10:53 AM
 
 I ran this query and got a different error:
 
   select
   SUM((OPTION_PRICE+0)) AS MERCH_CHARGE
   FROM contents
 
 Cannot mix types VARCHAR and BIGINT in a + binary operation
 
 so it looks like for some reason, coldfusion things 
 OPTION_PRICE is a 
 varchar, even though the column type in the database is 
 DECIMAL(10,2)

This transmission may contain information that is privileged, confidential 
and/or exempt from disclosure under applicable law. If you are not the intended 
recipient, you are hereby notified that any disclosure, copying, distribution, 
or use of the information contained herein (including any reliance thereon) is 
STRICTLY PROHIBITED. If you received this transmission in error, please 
immediately contact the sender and destroy the material in its entirety, 
whether in electronic or hard copy format. Thank you. A1.



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240360
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Query of Queries

This wouldn't make much sense, but maybe it's that one is int and one is
float... Try putting in  

SUM(1.0  *  OPTION_PRICE) AS MERCH_CHARGE

 - and - 

SUM( 1  *  OPTION_PRICE ) AS MERCH_CHARGE

This way we will see if that breaks. If the 1 still breaks but the 1.0 does
not break, then it's a casting issue?? 

...
Ben Nadel 
Web Developer
Nylon Technology
350 7th Avenue
Floor 10
New York, NY 10001
212.691.1134
212.691.3477 fax
www.nylontechnology.com
 
You know, like nunchuck skills, bowhunting skills, computer hacking
skills... Girls only want boyfriends who have great skills.
- Napoleon Dynamite
-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED] 
Sent: Friday, May 12, 2006 12:48 PM
To: CF-Talk
Subject: Re: Query of Queries

Ben Nadel wrote:
 Do any parts of the query work? Meaning, If you run with just the 
 first SUM directive does it work? Does it work if you do not do the 
 * in the second SUM? Let's see if we can narrow it down to exactly what
is breaking?

It is definately this one causing the problem:

select
SUM(QUANTITY*OPTION_PRICE) AS MERCH_CHARGE FROM contents

Both values are numeric (I output #isNumeric(contents.QUANTITY)# and
#isNumeric(contents.OPTION_PRICE)#

The values are 1 and 16.99





~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240361
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Query of Queries

2006-05-12 Thread Mark A Kruger

Why not CAST?

Select SUM(CAST(option_price AS DECIMAL) * QUANTITY) as merch_charge



-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED] 
Sent: Friday, May 12, 2006 11:53 AM
To: CF-Talk
Subject: Re: Query of Queries

I ran this query and got a different error:

select
SUM((OPTION_PRICE+0)) AS MERCH_CHARGE
FROM contents

Cannot mix types VARCHAR and BIGINT in a + binary operation

so it looks like for some reason, coldfusion things OPTION_PRICE is a
varchar, even though the column type in the database is DECIMAL(10,2)

Rick



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240362
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Query of Queries

Munson, Jacob wrote:
 Try using the val() function. 

val is a coldfusion function, not a SQL function.  you can't use val() 
anymore than you can use lcase() or chr() in a query of queries.

Rick

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240365
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Query of Queries

2006-05-12 Thread Munson, Jacob

Oops, I was thinking of when I use cf functions on the right side of a
where clause.  :\

 -Original Message-
 From: Rick Root [mailto:[EMAIL PROTECTED] 
 Sent: Friday, May 12, 2006 11:18 AM
 To: CF-Talk
 Subject: Re: Query of Queries

 Munson, Jacob wrote:
  Try using the val() function. 

 val is a coldfusion function, not a SQL function.  you can't 
 use val() 
 anymore than you can use lcase() or chr() in a query of queries.

 Rick

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240369
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Query of Queries

2006-05-12 Thread Brian Rinaldi

Have you tried getting the query metadata to verify the column data types?
You can do getMetaData(query) in CF 7.

- Brian Rinaldi
blog - www.remotesynthesis.com/blog
cf open source list - www.remotesynthesis.com/cfopensourcelist
Boston CFUG - www.bostoncfug.org

On 5/12/06, Munson, Jacob [EMAIL PROTECTED] wrote:

 Oops, I was thinking of when I use cf functions on the right side of a
 where clause.  :\

  -Original Message-
  From: Rick Root [mailto:[EMAIL PROTECTED]
  Sent: Friday, May 12, 2006 11:18 AM
  To: CF-Talk
  Subject: Re: Query of Queries
 
  Munson, Jacob wrote:
   Try using the val() function.
 
  val is a coldfusion function, not a SQL function.  you can't
  use val()
  anymore than you can use lcase() or chr() in a query of queries.
 
  Rick
 
 

 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240445
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Query of Queries