Re: left outer join on query of query function

2008-07-01 Thread Richard White
Not necessarily. How many records are in joinQuery? It should just have one,
empty record. The point of the first query is to get the columns, but not to
select any records; the empty record is created directly below it.

oh yes your right joinquery shouldnt have any records

basically i am trying to run this to outer join 2 queries using 3 primary key 
fields - subjectID, projectID, and testOccasionID so i have adapted it as 
follows:


cfquery name=joinQuery dbtype=query
SELECT *
FROM QueryB

WHERE QueryB.subjectID = -1

  /cfquery

  cfset QueryAddRow(joinQuery) /

  cfquery name=result dbtype=query
SELECT *
FROM QueryA, QueryB

WHERE QueryA.subjectID = QueryB.subjectID
  and QueryA.projectID = QueryB.projectID
  and QueryA.testOccasionID = QueryB.testOccasionID

UNION

SELECT QueryA.*, joinQuery.*
FROM QueryA, joinQuery

WHERE QueryA.subjectID NOT IN (#ValueList(QueryB.subjectID)#) 
and QueryA.projectID NOT IN (#ValueList(QueryB.projectID)#) 
and QueryA.testOccasionID NOT IN (#ValueList(QueryB.testOccasionID)#)
  /cfquery


this doesnt create more rows in fact it actually takes rows off and produces 
duplicate columns, and doesnt work as a normal sql outer join would

instead of using the joinquery.* i will get the column list, take out the 
primary keys fields so it doesnt duplicate them and then see whats happening

thanks dave 

~|
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:308355
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Application.names and sessions

2008-07-01 Thread Cameron Childress
On Mon, Jun 30, 2008 at 5:38 PM, marc -- [EMAIL PROTECTED] wrote:
 I had a setup like this but found out to my surprise that when I switch from 
 the
 1st to the 2nd scenario (using the application.cfc with THIS.name=B), the
 value for session.sessionId did not change. And all my sessionvariables were 
 still there.

 Why is this?

The session cookies's already been set, CF detects that, and just uses
it.  There is no need for a new tracking cookie to be set by CF so it
doesn't set one.  Internally CF will still keep App A and App B's
session data separate, but it will use the same tracking cookie.
Internally CF will use a combination of the sessionID and application
name to make that session data unique.

-Cameron

-- 
Cameron Childress
Sumo Consulting Inc
http://www.sumoc.com
---
cell: 678.637.5072
aim: cameroncf
email: [EMAIL PROTECTED]

~|
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:308356
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Killing registry keys

2008-07-01 Thread Smith, Daron [PA]
Somewhere along the line my client variable storage got switched from DB
to registry.  I've switched it back to database but I have a registry
key that's so large that regedit does not appear to be able to open it.
Is there a way to clean out the registry key for client variables (other
than regedit)?  If I delete the key will it be recreated?  I've seen
reference to a killclient custom tag but cannot seem to locate it.

Thanks for any help

PSEA E-mail Firewall annotation on Tue Jul 01 2008 09:06:49

-


NOTICE: Only the individual sender is responsible for the content of the 
message, and the message does not necessarily reflect the position or policy of 
the Pennsylvania State Education Association.
-



~|
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:308357
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Killing registry keys

2008-07-01 Thread Dave Watts
 Somewhere along the line my client variable storage got 
 switched from DB to registry.  I've switched it back to 
 database but I have a registry key that's so large that 
 regedit does not appear to be able to open it.
 Is there a way to clean out the registry key for client 
 variables (other than regedit)?  If I delete the key will it 
 be recreated?  I've seen reference to a killclient custom tag 
 but cannot seem to locate it.

You can probably use the command-line tools successfully for this:
http://www.petri.co.il/reg_command_in_windows_xp.htm

I'm pretty sure reg.exe is available in Windows Server 2003 also.

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!

~|
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:308358
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


(ot) Image Rollovers

2008-07-01 Thread Steve LaBadie
I don't recall this being a problem in the past, but my image rollovers
do not appear in IE 6  7, on or off. They work perfect in Firefox. I am
using the standard code and Javascript. Any thoughts from the group.

 

 

a href=# onMouseOut=MM_swapImgRestore()
onMouseOver=MM_swapImage('Image28','','images/weather_on.jpg',1)img
src=images/weather.jpg name=Image28 width=80 height=20
border=0/a

 

Steve LaBadie, Web Manager
East Stroudsburg University
200 Prospect St.
East Stroudsburg, Pa 18301
570-422-3999
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 
http://www.esu.edu http://www.esu.edu 

 



~|
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:308359
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: (ot) Image Rollovers

2008-07-01 Thread Adrian Lynch
Got a link for us to see?

-Original Message-
From: Steve LaBadie [mailto:[EMAIL PROTECTED]
Sent: 01 July 2008 14:20
To: CF-Talk
Subject: (ot) Image Rollovers


I don't recall this being a problem in the past, but my image rollovers
do not appear in IE 6  7, on or off. They work perfect in Firefox. I am
using the standard code and Javascript. Any thoughts from the group.

 

 

a href=# onMouseOut=MM_swapImgRestore()
onMouseOver=MM_swapImage('Image28','','images/weather_on.jpg',1)img
src=images/weather.jpg name=Image28 width=80 height=20
border=0/a

 

Steve LaBadie, Web Manager
East Stroudsburg University
200 Prospect St.
East Stroudsburg, Pa 18301
570-422-3999
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 
http://www.esu.edu http://www.esu.edu 

~|
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:308360
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: (ot) Image Rollovers

2008-07-01 Thread Andy Matthews
Are these buttons inside a cfoutput? The # inside the href attribute
probably needs to be escaped.

-Original Message-
From: Steve LaBadie [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 01, 2008 8:20 AM
To: CF-Talk
Subject: (ot) Image Rollovers

I don't recall this being a problem in the past, but my image rollovers do
not appear in IE 6  7, on or off. They work perfect in Firefox. I am using
the standard code and Javascript. Any thoughts from the group.

 

 

a href=# onMouseOut=MM_swapImgRestore()
onMouseOver=MM_swapImage('Image28','','images/weather_on.jpg',1)img
src=images/weather.jpg name=Image28 width=80 height=20
border=0/a

 

Steve LaBadie, Web Manager
East Stroudsburg University
200 Prospect St.
East Stroudsburg, Pa 18301
570-422-3999
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.esu.edu
http://www.esu.edu 

 





~|
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:308362
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


query of query timing out

2008-07-01 Thread Richard White
hi

is there any reason why a basic query of query with only if statements and no 
loops would make the jrun processor shoot up and for it to eventually time out

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:308361
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 query timing out

2008-07-01 Thread Richard White
 hi
 
 is there any reason why a basic query of query with only if statements 
 and no loops would make the jrun processor shoot up and for it to 
 eventually time out
 
 thanks 


this is the code:

cfquery name=newQuery dbtype=query
select query.subjectID
cfif queryType neq subject
  ,query.projectID
/cfif

cfif queryType eq testOccasion or queryType eq test
  ,query.testOccasionID
/cfif

cfif arraylen(newColumnArray) gt 0
  ,#arraytolist(newColumnArray)#
/cfif

,mergedColumnsQuery.#currentColumn#

from query, mergedColumnsQuery
/cfabort

there are 2 queries named as above, they both have data in them, the 
currentcolumn does exist in the mergedcolumnquery, and the newColumnArray has 2 
elements and both exist in the query

if i place an abort before the query of query then it aborts in a couple of 
seconds, but if i place it after the query then it clogs up the jrun and just 
times out

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:308363
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: (ot) Image Rollovers

2008-07-01 Thread Steve LaBadie
http://www4.esu.edu/inside/index.cfm

The images are in the white header section.

Steve LaBadie, Web Manager
East Stroudsburg University
200 Prospect St.
East Stroudsburg, Pa 18301
570-422-3999
[EMAIL PROTECTED]
http://www.esu.edu

-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 01, 2008 9:33 AM
To: CF-Talk
Subject: RE: (ot) Image Rollovers

Got a link for us to see?

-Original Message-
From: Steve LaBadie [mailto:[EMAIL PROTECTED]
Sent: 01 July 2008 14:20
To: CF-Talk
Subject: (ot) Image Rollovers


I don't recall this being a problem in the past, but my image rollovers
do not appear in IE 6  7, on or off. They work perfect in Firefox. I am
using the standard code and Javascript. Any thoughts from the group.

 

 

a href=# onMouseOut=MM_swapImgRestore()
onMouseOver=MM_swapImage('Image28','','images/weather_on.jpg',1)img
src=images/weather.jpg name=Image28 width=80 height=20
border=0/a

 

Steve LaBadie, Web Manager
East Stroudsburg University
200 Prospect St.
East Stroudsburg, Pa 18301
570-422-3999
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 
http://www.esu.edu http://www.esu.edu 



~|
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:308364
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: (ot) Image Rollovers

2008-07-01 Thread Steve LaBadie
No, they are outside.

Steve LaBadie, Web Manager
East Stroudsburg University
200 Prospect St.
East Stroudsburg, Pa 18301
570-422-3999
[EMAIL PROTECTED]
http://www.esu.edu

-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 01, 2008 9:45 AM
To: CF-Talk
Subject: RE: (ot) Image Rollovers

Are these buttons inside a cfoutput? The # inside the href attribute
probably needs to be escaped.

-Original Message-
From: Steve LaBadie [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 01, 2008 8:20 AM
To: CF-Talk
Subject: (ot) Image Rollovers

I don't recall this being a problem in the past, but my image rollovers
do
not appear in IE 6  7, on or off. They work perfect in Firefox. I am
using
the standard code and Javascript. Any thoughts from the group.

 

 

a href=# onMouseOut=MM_swapImgRestore()
onMouseOver=MM_swapImage('Image28','','images/weather_on.jpg',1)img
src=images/weather.jpg name=Image28 width=80 height=20
border=0/a

 

Steve LaBadie, Web Manager
East Stroudsburg University
200 Prospect St.
East Stroudsburg, Pa 18301
570-422-3999
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
http://www.esu.edu
http://www.esu.edu 

 







~|
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:308365
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: (ot) Image Rollovers

2008-07-01 Thread Andy Matthews
Might be because you're missing semicolons after your method calls?

Is there anything in your .headercell class which could be causing them to
disappear?

What happens when you remove all of the onmouseover/mouseout attributes so
that you have a simple, normal link?


andy 

-Original Message-
From: Steve LaBadie [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 01, 2008 8:49 AM
To: CF-Talk
Subject: RE: (ot) Image Rollovers

http://www4.esu.edu/inside/index.cfm

The images are in the white header section.

Steve LaBadie, Web Manager
East Stroudsburg University
200 Prospect St.
East Stroudsburg, Pa 18301
570-422-3999
[EMAIL PROTECTED]
http://www.esu.edu

-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 01, 2008 9:33 AM
To: CF-Talk
Subject: RE: (ot) Image Rollovers

Got a link for us to see?

-Original Message-
From: Steve LaBadie [mailto:[EMAIL PROTECTED]
Sent: 01 July 2008 14:20
To: CF-Talk
Subject: (ot) Image Rollovers


I don't recall this being a problem in the past, but my image rollovers do
not appear in IE 6  7, on or off. They work perfect in Firefox. I am using
the standard code and Javascript. Any thoughts from the group.

 

 

a href=# onMouseOut=MM_swapImgRestore()
onMouseOver=MM_swapImage('Image28','','images/weather_on.jpg',1)img
src=images/weather.jpg name=Image28 width=80 height=20
border=0/a

 

Steve LaBadie, Web Manager
East Stroudsburg University
200 Prospect St.
East Stroudsburg, Pa 18301
570-422-3999
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.esu.edu
http://www.esu.edu 





~|
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:308366
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: (ot) Image Rollovers

2008-07-01 Thread Sonny Savage
I think you've run into an infamous layout bug in IE.  Try setting the width
of the absolutely positioned div (class=weather).

Edward A Savage Jr - Sonny
Senior Software Engineer
Creditdiscovery, LLC
An appeaser is one who feeds a crocodile, hoping it will eat him last. ~
Sir Winston Churchill

On Tue, Jul 1, 2008 at 9:19 AM, Steve LaBadie [EMAIL PROTECTED]
wrote:

 I don't recall this being a problem in the past, but my image rollovers
 do not appear in IE 6  7, on or off. They work perfect in Firefox. I am
 using the standard code and Javascript. Any thoughts from the group.





 a href=# onMouseOut=MM_swapImgRestore()
 onMouseOver=MM_swapImage('Image28','','images/weather_on.jpg',1)img
 src=images/weather.jpg name=Image28 width=80 height=20
 border=0/a



 Steve LaBadie, Web Manager
 East Stroudsburg University
 200 Prospect St.
 East Stroudsburg, Pa 18301
 570-422-3999
 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
 http://www.esu.edu http://www.esu.edu





 

~|
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:308367
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


post limit and site wide error handler

2008-07-01 Thread Rick Root
Can anyone verify for me that CF *does* or *does not* handle POST size
errors with a site wide error handler?

Mine does not.  instead of a normal CF error I get one of them ugly
jrun 500 errors that looks like this:

500
coldfusion.filter.RequestThrottleFilter$PostSizeLimitExceededException:
Post Size exceeds the maximum limit.
at 
coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:112)
at coldfusion.CfmServlet.service(CfmServlet.java:175)
at 
coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
at com.intergral.fusionreactor.filter.FusionReactorFilter.G(Unknown 
Source)
at com.intergral.fusionreactor.filter.FusionReactorFilter.B(Unknown 
Source)
at 
com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(Unknown
Source)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
at 
coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at 
coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
at jrun.servlet.FilterChain.service(FilterChain.java:101)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at 
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
at 
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
at 
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
at 
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)
at 
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
at 
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)


-- 
Rick Root
New Brian Vander Ark Album, songs in the music player and cool behind
the scenes video at www.myspace.com/brianvanderark

~|
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:308368
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: (ot) Image Rollovers

2008-07-01 Thread Steve LaBadie
If I remove everything, they still don't appear. The only thing in the
headercell is color and paading.

If I clear the cache and cookies the images appear. Once I refresh the
screen the disappear.

Steve LaBadie, Web Manager
East Stroudsburg University
200 Prospect St.
East Stroudsburg, Pa 18301
570-422-3999
[EMAIL PROTECTED]
http://www.esu.edu

-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 01, 2008 10:01 AM
To: CF-Talk
Subject: RE: (ot) Image Rollovers

Might be because you're missing semicolons after your method calls?

Is there anything in your .headercell class which could be causing them
to
disappear?

What happens when you remove all of the onmouseover/mouseout attributes
so
that you have a simple, normal link?


andy 

-Original Message-
From: Steve LaBadie [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 01, 2008 8:49 AM
To: CF-Talk
Subject: RE: (ot) Image Rollovers

http://www4.esu.edu/inside/index.cfm

The images are in the white header section.

Steve LaBadie, Web Manager
East Stroudsburg University
200 Prospect St.
East Stroudsburg, Pa 18301
570-422-3999
[EMAIL PROTECTED]
http://www.esu.edu

-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 01, 2008 9:33 AM
To: CF-Talk
Subject: RE: (ot) Image Rollovers

Got a link for us to see?

-Original Message-
From: Steve LaBadie [mailto:[EMAIL PROTECTED]
Sent: 01 July 2008 14:20
To: CF-Talk
Subject: (ot) Image Rollovers


I don't recall this being a problem in the past, but my image rollovers
do
not appear in IE 6  7, on or off. They work perfect in Firefox. I am
using
the standard code and Javascript. Any thoughts from the group.

 

 

a href=# onMouseOut=MM_swapImgRestore()
onMouseOver=MM_swapImage('Image28','','images/weather_on.jpg',1)img
src=images/weather.jpg name=Image28 width=80 height=20
border=0/a

 

Steve LaBadie, Web Manager
East Stroudsburg University
200 Prospect St.
East Stroudsburg, Pa 18301
570-422-3999
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
http://www.esu.edu
http://www.esu.edu 







~|
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:308369
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: post limit and site wide error handler

2008-07-01 Thread Rick Root
(oh ... 8.0.1 with the latest cumulative hot fix, on windows.. cf standard)

On Tue, Jul 1, 2008 at 10:17 AM, Rick Root [EMAIL PROTECTED] wrote:
 Can anyone verify for me that CF *does* or *does not* handle POST size
 errors with a site wide error handler?

 Mine does not.  instead of a normal CF error I get one of them ugly
 jrun 500 errors that looks like this:

 500
 coldfusion.filter.RequestThrottleFilter$PostSizeLimitExceededException:
 Post Size exceeds the maximum limit.
at 
 coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:112)
at coldfusion.CfmServlet.service(CfmServlet.java:175)
at 
 coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
at com.intergral.fusionreactor.filter.FusionReactorFilter.G(Unknown 
 Source)
at com.intergral.fusionreactor.filter.FusionReactorFilter.B(Unknown 
 Source)
at 
 com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(Unknown
 Source)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
at 
 coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at 
 coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
at jrun.servlet.FilterChain.service(FilterChain.java:101)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at 
 jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
at 
 jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
at 
 jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
at 
 jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)
at 
 jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
at 
 jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)


 --
 Rick Root
 New Brian Vander Ark Album, songs in the music player and cool behind
 the scenes video at www.myspace.com/brianvanderark




-- 
Rick Root
New Brian Vander Ark Album, songs in the music player and cool behind
the scenes video at www.myspace.com/brianvanderark

~|
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:308370
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


SQL Server, CF DSNs and large text fields.

2008-07-01 Thread Ian Skinner
I have a requirement to work with 8K+ character blocks of text in a 
ColdFusion Content system using a MS SQL Server database.  This is going 
to be a 'text' field in MS SQL Server, correct?  I am going to need to 
enable 'CLOB' fields in the Oracle DSN am I not?  Any other DSN settings 
that need modification, Long Text Buffer or Blob Buffer?

This is run on a hosted server, and I just need to make sure what I need 
to request the Hosting Provider on how to configure the DSN.

TIA
Ian


~|
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:308371
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: (ot) Image Rollovers

2008-07-01 Thread Andy Matthews
You have any javascript acting upon that table cell? Maybe some sort of
show/hide code? 

-Original Message-
From: Steve LaBadie [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 01, 2008 9:15 AM
To: CF-Talk
Subject: RE: (ot) Image Rollovers

If I remove everything, they still don't appear. The only thing in the
headercell is color and paading.

If I clear the cache and cookies the images appear. Once I refresh the
screen the disappear.

Steve LaBadie, Web Manager
East Stroudsburg University
200 Prospect St.
East Stroudsburg, Pa 18301
570-422-3999
[EMAIL PROTECTED]
http://www.esu.edu

-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 01, 2008 10:01 AM
To: CF-Talk
Subject: RE: (ot) Image Rollovers

Might be because you're missing semicolons after your method calls?

Is there anything in your .headercell class which could be causing them to
disappear?

What happens when you remove all of the onmouseover/mouseout attributes so
that you have a simple, normal link?


andy 

-Original Message-
From: Steve LaBadie [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 01, 2008 8:49 AM
To: CF-Talk
Subject: RE: (ot) Image Rollovers

http://www4.esu.edu/inside/index.cfm

The images are in the white header section.

Steve LaBadie, Web Manager
East Stroudsburg University
200 Prospect St.
East Stroudsburg, Pa 18301
570-422-3999
[EMAIL PROTECTED]
http://www.esu.edu

-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 01, 2008 9:33 AM
To: CF-Talk
Subject: RE: (ot) Image Rollovers

Got a link for us to see?

-Original Message-
From: Steve LaBadie [mailto:[EMAIL PROTECTED]
Sent: 01 July 2008 14:20
To: CF-Talk
Subject: (ot) Image Rollovers


I don't recall this being a problem in the past, but my image rollovers do
not appear in IE 6  7, on or off. They work perfect in Firefox. I am using
the standard code and Javascript. Any thoughts from the group.

 

 

a href=# onMouseOut=MM_swapImgRestore()
onMouseOver=MM_swapImage('Image28','','images/weather_on.jpg',1)img
src=images/weather.jpg name=Image28 width=80 height=20
border=0/a

 

Steve LaBadie, Web Manager
East Stroudsburg University
200 Prospect St.
East Stroudsburg, Pa 18301
570-422-3999
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.esu.edu
http://www.esu.edu 









~|
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:308372
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: (ot) Image Rollovers

2008-07-01 Thread Steve LaBadie
Just using the standard MM code that appears when you creat the
rollerover in Dreamweaver. This has never been an issue before.

Steve LaBadie, Web Manager
East Stroudsburg University
200 Prospect St.
East Stroudsburg, Pa 18301
570-422-3999
[EMAIL PROTECTED]
http://www.esu.edu

-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 01, 2008 10:27 AM
To: CF-Talk
Subject: RE: (ot) Image Rollovers

You have any javascript acting upon that table cell? Maybe some sort of
show/hide code? 

-Original Message-
From: Steve LaBadie [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 01, 2008 9:15 AM
To: CF-Talk
Subject: RE: (ot) Image Rollovers

If I remove everything, they still don't appear. The only thing in the
headercell is color and paading.

If I clear the cache and cookies the images appear. Once I refresh the
screen the disappear.

Steve LaBadie, Web Manager
East Stroudsburg University
200 Prospect St.
East Stroudsburg, Pa 18301
570-422-3999
[EMAIL PROTECTED]
http://www.esu.edu

-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 01, 2008 10:01 AM
To: CF-Talk
Subject: RE: (ot) Image Rollovers

Might be because you're missing semicolons after your method calls?

Is there anything in your .headercell class which could be causing them
to
disappear?

What happens when you remove all of the onmouseover/mouseout attributes
so
that you have a simple, normal link?


andy 

-Original Message-
From: Steve LaBadie [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 01, 2008 8:49 AM
To: CF-Talk
Subject: RE: (ot) Image Rollovers

http://www4.esu.edu/inside/index.cfm

The images are in the white header section.

Steve LaBadie, Web Manager
East Stroudsburg University
200 Prospect St.
East Stroudsburg, Pa 18301
570-422-3999
[EMAIL PROTECTED]
http://www.esu.edu

-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 01, 2008 9:33 AM
To: CF-Talk
Subject: RE: (ot) Image Rollovers

Got a link for us to see?

-Original Message-
From: Steve LaBadie [mailto:[EMAIL PROTECTED]
Sent: 01 July 2008 14:20
To: CF-Talk
Subject: (ot) Image Rollovers


I don't recall this being a problem in the past, but my image rollovers
do
not appear in IE 6  7, on or off. They work perfect in Firefox. I am
using
the standard code and Javascript. Any thoughts from the group.

 

 

a href=# onMouseOut=MM_swapImgRestore()
onMouseOver=MM_swapImage('Image28','','images/weather_on.jpg',1)img
src=images/weather.jpg name=Image28 width=80 height=20
border=0/a

 

Steve LaBadie, Web Manager
East Stroudsburg University
200 Prospect St.
East Stroudsburg, Pa 18301
570-422-3999
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
http://www.esu.edu
http://www.esu.edu 











~|
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:308373
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: (ot) Image Rollovers

2008-07-01 Thread Robert Harrison
Post the page and send out a URL.


Robert B. Harrison
Director of Interactive services
Austin  Williams
125 Kennedy Drive, Suite 100 Hauppauge NY 11788
T : 631.231.6600 Ext. 119 
F : 631.434.7022
www.austin-williams.com

Great advertising can't be either/or... It must be .
-Original Message-
From: Steve LaBadie [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 01, 2008 10:15 AM
To: CF-Talk
Subject: RE: (ot) Image Rollovers

If I remove everything, they still don't appear. The only thing in the
headercell is color and paading.

If I clear the cache and cookies the images appear. Once I refresh the
screen the disappear.

Steve LaBadie, Web Manager
East Stroudsburg University
200 Prospect St.
East Stroudsburg, Pa 18301
570-422-3999
[EMAIL PROTECTED]
http://www.esu.edu

-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 01, 2008 10:01 AM
To: CF-Talk
Subject: RE: (ot) Image Rollovers

Might be because you're missing semicolons after your method calls?

Is there anything in your .headercell class which could be causing them
to
disappear?

What happens when you remove all of the onmouseover/mouseout attributes
so
that you have a simple, normal link?


andy 

-Original Message-
From: Steve LaBadie [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 01, 2008 8:49 AM
To: CF-Talk
Subject: RE: (ot) Image Rollovers

http://www4.esu.edu/inside/index.cfm

The images are in the white header section.

Steve LaBadie, Web Manager
East Stroudsburg University
200 Prospect St.
East Stroudsburg, Pa 18301
570-422-3999
[EMAIL PROTECTED]
http://www.esu.edu

-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 01, 2008 9:33 AM
To: CF-Talk
Subject: RE: (ot) Image Rollovers

Got a link for us to see?

-Original Message-
From: Steve LaBadie [mailto:[EMAIL PROTECTED]
Sent: 01 July 2008 14:20
To: CF-Talk
Subject: (ot) Image Rollovers


I don't recall this being a problem in the past, but my image rollovers
do
not appear in IE 6  7, on or off. They work perfect in Firefox. I am
using
the standard code and Javascript. Any thoughts from the group.

 

 

a href=# onMouseOut=MM_swapImgRestore()
onMouseOver=MM_swapImage('Image28','','images/weather_on.jpg',1)img
src=images/weather.jpg name=Image28 width=80 height=20
border=0/a

 

Steve LaBadie, Web Manager
East Stroudsburg University
200 Prospect St.
East Stroudsburg, Pa 18301
570-422-3999
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
http://www.esu.edu
http://www.esu.edu 









~|
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:308374
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


CF8 on SLES 10.2 - where is an updated glibc ?

2008-07-01 Thread Tom Chiverton
I'm doing some tests before upgrading some of our servers, and I can't get 
64bit CF8 to run on SLES 10.2 (which is listed as supported on the support 
matrix).
I installed from the 64bit download (coldfusion-801-lin64.bin, md5sum checked) 
on adobe.com, and all I get from running 'cd /opt/coldfusion8;./coldfusion 
start' as root is 
---
Starting ColdFusion 8...
The ColdFusion 8 server is starting up and will be available shortly.
There has been an error starting ColdFusion 8, please check the logs.
---

The logs are empty.
I su'ed to the run time user (nobody) and then run the start up commands 
lifted from the start up script by hand:
export PATH=$PATH:$CF_DIR/runtime/bin; export 
LD_LIBRARY_PATH=$LD_LIBRARY_PATH; cd $CF_DIR/runtime/bin;
$CF_DIR/runtime/bin/coldfusion8 -jar jrun.jar -autorestart -start coldfusion 
and this gives the slightly more helpful 'Floating point exception'.

So I use 'strace' to run '$CF_DIR/runtime/bin/coldfusion8 ...' and it's 
falling over real early, just after glibc is loaded.
You'll note on the support matrix that SLES 10.1 requires glibc-2.5 but 
nothing is mentioned about 10.2 - and 10.2 only seems to come with glibc-2.4 
here.

Can anyone say they've got this working ? Or knows if there is an update we 
need to apply to SLES 10.2 (though the IT guys tell me it's up to date) ?

.
open(/lib64/libc.so.6, O_RDONLY)  = 3
read(3, \177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0\0\1\0\0\0\200\322..., 832) = 
832
fstat(3, {st_mode=S_IFREG|0755, st_size=1570331, ...}) = 0
mmap(NULL, 2355560, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 
0x2aee1933f000
madvise(0x2aee1933f000, 2355560, MADV_SEQUENTIAL|0x1) = 0
mprotect(0x2aee19475000, 1048576, PROT_NONE) = 0
mmap(0x2aee19575000, 20480, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|
MAP_DENYWRITE, 3, 0x136000) = 0x2aee19575000
mmap(0x2aee1957a000, 16744, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|
MAP_ANONYMOUS, -1, 0) = 0x2aee1957a000
close(3)= 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 
0x2aee1957f000
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 
0x2aee1958
arch_prctl(ARCH_SET_FS, 0x2aee1957fed0) = 0
--- SIGFPE (Floating point exception) @ 0 (0) ---
+++ killed by SIGFPE +++

-- 
Tom Chiverton



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at 
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  A list 
of members is available for inspection at the registered office. Any reference 
to a partner in relation to Halliwells LLP means a member of Halliwells LLP.  
Regulated by The Solicitors Regulation Authority.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 2500.

For more information about Halliwells LLP visit www.halliwells.com.

~|
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:308375
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: (ot) Image Rollovers

2008-07-01 Thread Andy Matthews
He did already. 

http://www4.esu.edu/inside/index.cfm

-Original Message-
From: Robert Harrison [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 01, 2008 9:53 AM
To: CF-Talk
Subject: RE: (ot) Image Rollovers

Post the page and send out a URL.


Robert B. Harrison
Director of Interactive services
Austin  Williams
125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F
: 631.434.7022 www.austin-williams.com

Great advertising can't be either/or... It must be .



~|
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:308376
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: (ot) Image Rollovers

2008-07-01 Thread Sonny Savage
My reply is in reference to what is called the IE hasLayout() rendering
bug... have you tried it?

On Tue, Jul 1, 2008 at 10:04 AM, Sonny Savage [EMAIL PROTECTED] wrote:

 I think you've run into an infamous layout bug in IE.  Try setting the
 width of the absolutely positioned div (class=weather).




~|
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:308377
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: (ot) Image Rollovers

2008-07-01 Thread Steve LaBadie
No I haven't, not sure how to use it.

Steve LaBadie, Web Manager
East Stroudsburg University
200 Prospect St.
East Stroudsburg, Pa 18301
570-422-3999
[EMAIL PROTECTED]
http://www.esu.edu

-Original Message-
From: Sonny Savage [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 01, 2008 11:02 AM
To: CF-Talk
Subject: Re: (ot) Image Rollovers

My reply is in reference to what is called the IE hasLayout() rendering
bug... have you tried it?

On Tue, Jul 1, 2008 at 10:04 AM, Sonny Savage [EMAIL PROTECTED]
wrote:

 I think you've run into an infamous layout bug in IE.  Try setting the
 width of the absolutely positioned div (class=weather).






~|
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:308378
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: (ot) Image Rollovers

2008-07-01 Thread Robert Harrison
You must have fixed it... http://www4.esu.edu/inside/index.cfm 

Rollovers are working for me on IE 7.

Robert B. Harrison
Director of Interactive services
Austin  Williams
125 Kennedy Drive, Suite 100 Hauppauge NY 11788
T : 631.231.6600 Ext. 119 
F : 631.434.7022
www.austin-williams.com

Great advertising can't be either/or... It must be .



~|
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:308379
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 query timing out

2008-07-01 Thread Richard White
i have noticed that if i run the query without the line:

mergedColumnsQuery.#currentColumn#

and if i dont add the mergedColumnsQuery query onto the from line then it works 
fine but when i add these then it actually doesnt even time it, it just keeps 
on loading the page and doesnt ever stop and jrun shoots up to use 70-80% of 
the processing speed

does anyone have any clue why this would happen?

thanks

richard


 cfquery name=newQuery dbtype=query
 select query.subjectID
 cfif queryType neq subject
  ,
 query.projectID
 /cfif
   
 cfif queryType eq testOccasion or queryType eq test
  ,
 query.testOccasionID
 /cfif
   
 cfif arraylen(newColumnArray) gt 0
  ,
 #arraytolist(newColumnArray)#
 /cfif
   
,
mergedColumnsQuery.#currentColumn#

from query, mergedColumnsQuery
/cfabort


~|
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:308380
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: (ot) Image Rollovers

2008-07-01 Thread Steve LaBadie
Your right it was working. When I refreshed the screen they disappeared
and they were loading in the wrong place.

Steve LaBadie, Web Manager
East Stroudsburg University
200 Prospect St.
East Stroudsburg, Pa 18301
570-422-3999
[EMAIL PROTECTED]
http://www.esu.edu

-Original Message-
From: Robert Harrison [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 01, 2008 11:21 AM
To: CF-Talk
Subject: RE: (ot) Image Rollovers

You must have fixed it... http://www4.esu.edu/inside/index.cfm 

Rollovers are working for me on IE 7.

Robert B. Harrison
Director of Interactive services
Austin  Williams
125 Kennedy Drive, Suite 100 Hauppauge NY 11788
T : 631.231.6600 Ext. 119 
F : 631.434.7022
www.austin-williams.com

Great advertising can't be either/or... It must be .





~|
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:308381
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: post limit and site wide error handler

2008-07-01 Thread Dave Watts
 Can anyone verify for me that CF *does* or *does not* handle 
 POST size errors with a site wide error handler?

It does not. I think you can use the JRun web server error handler for this;
with IIS, you'd specify an errorurl entry in wsconfig\1\jrun.ini (assuming
that IIS is the first web server configured for use with CF).

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!

~|
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:308382
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Mid to Senior Cold Fusion Developer needed!

2008-07-01 Thread douglas brownell
Location: 

Washington, DC (Foggy Bottom Metro Stop) 




Security Requirements:

US Citizen: Must be eligible for a secret clearance. 




Client:

Dept. of State 




Additional Job Description/Information: 

Our team supports the Information Resource Management Division at the U.S. 
Department of State in the development and maintenance of ColdFusion 7 
applications. The development team consists of eight software development 
personnel including web designers, developers, testers, and analysts. Under the 
direction of the project manager, the candidate will be responsible for 
developing enhancements to existing applications using ColdFusion, Fusebox and 
SQL, and planning and executing migration from a custom ColdFusion content 
management application to SharePoint MOSS (with assistance from the on-site 
SharePoint team). 

Expertise developing ColdFusion applications, including the use of CF 
Components and a strong grasp of object-oriented programming 

Knowledge of ColdFusion development frameworks including Fusebox, Model-Glue or 
similar 

Strengths in data modeling, relational database creation and performance tuning 
utilizing tools such as stored procedures, triggers and views 

Experience in defining and documenting application architecture. 

Experience leveraging tools to automate unit testing and builds/deployment 

Strong SQL Skills and Microsoft SQL Server experience 

Solid understanding of and experience with the standard Software Development 
Lifecycle 

Good communication, planning, and analysis skills 




“Must Have” Requirements: 

3-6 years of Cold Fusion Development Experience  SQL. 




“Nice to Have” Requirements: 

Fusebox, Model-Glue or similar 

Strengths in data modeling, relational database creation and performance tuning 
utilizing tools such as stored procedures, triggers and views 

SharePoint and .Net experience a plus! 




Experience: 

ColdFusion – 3+ years 

SQL - 6 years 

T-SQL or PL/SQL - 2 years 

HTML/CSS/JavaScript - 6 years 

Subversion (or similar version control system) 

Software Development Lifecycle - 6 years 

B.S. in Computer Science 

3 to 5 yrs of experience



Please contact Douglas Brownell @ [EMAIL PROTECTED]

~|
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:308383
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 query timing out

2008-07-01 Thread Jochem van Dieten
Richard White wrote:
 is there any reason why a basic query of query with only if statements 
 and no loops would make the jrun processor shoot up and for it to 
 eventually time out

 cfquery name=newQuery dbtype=query
 select query.subjectID

 ,mergedColumnsQuery.#currentColumn#
   
 from query, mergedColumnsQuery
 /cfabort

This is an unconstrained / cartesian join. Make sure you have a where 
clause to reduce the size of the resultset.

Jochem

~|
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:308384
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: post limit and site wide error handler

2008-07-01 Thread Rick Root
On Tue, Jul 1, 2008 at 11:32 AM, Dave Watts [EMAIL PROTECTED] wrote:
 Can anyone verify for me that CF *does* or *does not* handle
 POST size errors with a site wide error handler?

 It does not. I think you can use the JRun web server error handler for this;
 with IIS, you'd specify an errorurl entry in wsconfig\1\jrun.ini (assuming
 that IIS is the first web server configured for use with CF).

as instructed here?

http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_19300

But that would have to be a very generic error page for any jrun error
right, I couldn't perform CF processing and display a friendly error
message based on the actual error that occurred (presumably, other
errors SHOULD NOT occur but you never know!)

I found this blog comment:

http://coldfused.blogspot.com/2007/08/coldfusion-8-changes-with-file-upload.html

Down on the page, a guy named rupesh kumar said:

Let the post size be there in the server and set an error page for
this in the web.xml. Thats because your site error handler and
application error handler will also not get a chance to handle it.

but goes into no further detail...

Rick

~|
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:308385
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: cfajaximport/IE issues

2008-07-01 Thread Claude Schneegans
 When I import the cfwindow libraries via cfajaximport, my simple 
javascript menus will flicker in Internet Explorer and sometimes close 
themselves.

This is the trouble with such libraries: they include all what you 
need,... but also 99% of what you don't need.

Look all what you have:
script type=text/javascript 
src=/CFIDE/scripts/ajax/package/cfajax.js/script
script type=text/javascript 
src=/CFIDE/scripts/ajax/yui/yahoo-dom-event/yahoo-dom-event.js/script
script type=text/javascript 
src=/CFIDE/scripts/ajax/yui/animation/animation-min.js/script
script type=text/javascript 
src=/CFIDE/scripts/ajax/ext/adapter/yui/ext-yui-adapter.js/script
script type=text/javascript 
src=/CFIDE/scripts/ajax/ext/ext-core.js/script
script type=text/javascript 
src=/CFIDE/scripts/ajax/ext/package/resizable.js/script
script type=text/javascript 
src=/CFIDE/scripts/ajax/ext/package/dragdrop/dragdrop.js/script
script type=text/javascript 
src=/CFIDE/scripts/ajax/ext/package/util.js/script
script type=text/javascript 
src=/CFIDE/scripts/ajax/ext/build/state/State-min.js/script
script type=text/javascript 
src=/CFIDE/scripts/ajax/ext/package/widget-core.js/script
script type=text/javascript 
src=/CFIDE/scripts/ajax/ext/package/dialog/dialogs.js/script
script type=text/javascript 
src=/CFIDE/scripts/ajax/package/cfwindow.js/script

This may represent lots of code, and apparently it slows down MSIE.

-- 
___
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:308386
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: (ot) Image Rollovers

2008-07-01 Thread Steve LaBadie
I justy created a new rollover for webmail and it works fine. Either the
positioning or something else in the header must be causing the problem.

Steve LaBadie, Web Manager
East Stroudsburg University
200 Prospect St.
East Stroudsburg, Pa 18301
570-422-3999
[EMAIL PROTECTED]
http://www.esu.edu

-Original Message-
From: Robert Harrison [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 01, 2008 11:21 AM
To: CF-Talk
Subject: RE: (ot) Image Rollovers

You must have fixed it... http://www4.esu.edu/inside/index.cfm 

Rollovers are working for me on IE 7.

Robert B. Harrison
Director of Interactive services
Austin  Williams
125 Kennedy Drive, Suite 100 Hauppauge NY 11788
T : 631.231.6600 Ext. 119 
F : 631.434.7022
www.austin-williams.com

Great advertising can't be either/or... It must be .





~|
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:308387
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 query timing out

2008-07-01 Thread Richard White
thanks Jochem, no wonder is was timing out!!!

thanks for spotting that

Richard White wrote:

 cfquery name=newQuery dbtype=query
 select query.subjectID

 ,mergedColumnsQuery.#currentColumn#
  
 from query, mergedColumnsQuery
 /cfabort

This is an unconstrained / cartesian join. Make sure you have a where 
clause to reduce the size of the resultset.

Jochem 

~|
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:308388
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: (ot) Image Rollovers

2008-07-01 Thread Steve LaBadie
Figured it out, it was the DIV tag surrounding the rollover. Placed the
class inside of the link and they show.

The only issue left is in IE7 they don't position correctly.

Steve LaBadie, Web Manager
East Stroudsburg University
200 Prospect St.
East Stroudsburg, Pa 18301
570-422-3999
[EMAIL PROTECTED]
http://www.esu.edu

-Original Message-
From: Steve LaBadie [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 01, 2008 11:22 AM
To: CF-Talk
Subject: RE: (ot) Image Rollovers

Your right it was working. When I refreshed the screen they disappeared
and they were loading in the wrong place.

Steve LaBadie, Web Manager
East Stroudsburg University
200 Prospect St.
East Stroudsburg, Pa 18301
570-422-3999
[EMAIL PROTECTED]
http://www.esu.edu

-Original Message-
From: Robert Harrison [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 01, 2008 11:21 AM
To: CF-Talk
Subject: RE: (ot) Image Rollovers

You must have fixed it... http://www4.esu.edu/inside/index.cfm 

Rollovers are working for me on IE 7.

Robert B. Harrison
Director of Interactive services
Austin  Williams
125 Kennedy Drive, Suite 100 Hauppauge NY 11788
T : 631.231.6600 Ext. 119 
F : 631.434.7022
www.austin-williams.com

Great advertising can't be either/or... It must be .







~|
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:308389
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 query timing out

2008-07-01 Thread Richard White
i am getting the exact same problem with the following query but cannot see why 
it is taking so long and what is missing - would also appreciate your help with 
this one:

cfquery name= dbtype=query
  select   
query.subjectID,query.projectID,query.testOccasionID,query.subjectHeight,query.subjectWeight

  from query, mergedColumnsQuery

  where query.subjectID NOT IN (#ValueList(mergedColumnsQuery.subjectID)#)
  and query.projectID NOT IN (#ValueList(mergedColumnsQuery.projectID)#)
  and query.testOccasionID NOT IN 
(#ValueList(mergedColumnsQuery.testOccasionID)#)
/cfquery 

~|
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:308390
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


(ot) MS SQL Server

2008-07-01 Thread Ian Skinner
If I convert an column in a table that is curently a type of 
'varchar(8000)' to a type of 'text(16)', does this truncate the data? 

I'm using Enterprise manager, when I put the conversion in, I note I can 
not change the size, so I presume that text is always size '16' and that 
this references the rest of the text however MS SQL Server handles this 
data type.  When I do this, I get the 'data could be truncated' 
message.  Is this just a proforma message, or am I possible not setting 
this up properly so that there is enough space for the current data in 
the field.

TIA
Ian

~|
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:308391
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 query timing out

2008-07-01 Thread Brad Wood
Why is the mergedColumnsQuery included in the from clause?
You are not using any of its columns in the select clause, nor are you
filtering it in the where clause.  Not only, but you again have not
specified any join criteria to join it to the query query.  (perhaps
there's a better name for that one).

You do not need to have the mergedColumnsQuery query in the from list to
do the valuelist() stuff.

~Brad

-Original Message-
From: Richard White [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 01, 2008 11:38 AM
To: CF-Talk
Subject: Re: query of query timing out

i am getting the exact same problem with the following query but cannot
see why it is taking so long and what is missing - would also appreciate
your help with this one:

cfquery name= dbtype=query
  select
query.subjectID,query.projectID,query.testOccasionID,query.subjectHeight
,query.subjectWeight

  from query, mergedColumnsQuery

  where query.subjectID NOT IN
(#ValueList(mergedColumnsQuery.subjectID)#)
  and query.projectID NOT IN (#ValueList(mergedColumnsQuery.projectID)#)
  and query.testOccasionID NOT IN
(#ValueList(mergedColumnsQuery.testOccasionID)#)
/cfquery 

~|
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:308392
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: (ot) MS SQL Server

2008-07-01 Thread Brad Wood
16, is the size of the text pointer which points to another storage
location where the actual text is stored.  I'm not sure why it would
tell you that the data will be truncated since a text field should hold
far more than 8000 characters.  Perhaps it is a just-in-case message.

Are you on SQL Server 2000?  If you are on 2005, the varchar(max) is
much better than text.

~Brad

-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 01, 2008 11:41 AM
To: CF-Talk
Subject: (ot) MS SQL Server

If I convert an column in a table that is curently a type of 
'varchar(8000)' to a type of 'text(16)', does this truncate the data? 

I'm using Enterprise manager, when I put the conversion in, I note I can

not change the size, so I presume that text is always size '16' and that

this references the rest of the text however MS SQL Server handles this 
data type.  When I do this, I get the 'data could be truncated' 
message.  Is this just a proforma message, or am I possible not setting 
this up properly so that there is enough space for the current data in 
the field.


~|
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:308393
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: (ot) MS SQL Server

2008-07-01 Thread Dave Watts
 If I convert an column in a table that is curently a type of 
 'varchar(8000)' to a type of 'text(16)', does this truncate 
 the data? 
 
 I'm using Enterprise manager, when I put the conversion in, 
 I note I can not change the size, so I presume that text is 
 always size '16' and that this references the rest of the 
 text however MS SQL Server handles this data type. When I do 
 this, I get the 'data could be truncated' message. Is this 
 just a proforma message, or am I possible not setting this 
 up properly so that there is enough space for the current 
 data in the field.

Text and ntext fields are always listed as that size. That's the size of the
pointer to the actual storage location. I don't think you'll truncate your
data in the conversion.

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!

~|
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:308394
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 query timing out

2008-07-01 Thread Richard White
ok thanks brad, i have taken it out of the from list, you learn something new 
everyday

i hadnt realised that by putting that in there that it would think that i am 
joining it, even if i had not specified any columns from that query but would 
still attempt to join it. to be honest i thought i needed it to do the 
valuelist stuff as you said. 

it has sped it up thanks. you stated that i hadnt added any join clauses but as 
i think you guessed there was not meant to be a join

thanks brad

Why is the mergedColumnsQuery included in the from clause?
You are not using any of its columns in the select clause, nor are you
filtering it in the where clause.  Not only, but you again have not
specified any join criteria to join it to the query query.  (perhaps
there's a better name for that one).

You do not need to have the mergedColumnsQuery query in the from list to
do the valuelist() stuff.

~Brad

i am getting the exact same problem with the following query but cannot
see why it is taking so long and what is missing - would also appreciate
your help with this one:

cfquery name= dbtype=query
  select
query.subjectID,query.projectID,query.testOccasionID,query.subjectHeight
,query.subjectWeight

  from query, mergedColumnsQuery
   
  where query.subjectID NOT IN
(#ValueList(mergedColumnsQuery.subjectID)#)
  and query.projectID NOT IN (#ValueList(mergedColumnsQuery.projectID)#)
  and query.testOccasionID NOT IN
(#ValueList(mergedColumnsQuery.testOccasionID)#)
/cfquery 

~|
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:308395
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: post limit and site wide error handler

2008-07-01 Thread Dave Watts
 as instructed here?
 
 http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_19300

Yes.

 But that would have to be a very generic error page for any 
 jrun error right, I couldn't perform CF processing and 
 display a friendly error message based on the actual error 
 that occurred (presumably, other errors SHOULD NOT occur but 
 you never know!)

Yes, that's correct. That page wouldn't receive any error variables, and
should be a static file. Other errors may well occur, and if those errors
occur CF pages may not be available at all. In fact, I don't even know if a
CF page will work there at all.

 I found this blog comment:
 
 http://coldfused.blogspot.com/2007/08/coldfusion-8-changes-wit
 h-file-upload.html
 
 Down on the page, a guy named rupesh kumar said:
 
 Let the post size be there in the server and set an error 
 page for this in the web.xml. Thats because your site error 
 handler and application error handler will also not get a 
 chance to handle it.
 
 but goes into no further detail...

Rupesh is the author of the blog, and is (or was) on the CF 8 development
team.

Here's what this means, generally:
http://www.jguru.com/faq/view.jsp?EID=318806

That said, I haven't tried it. I assumed that the connector would handle
file upload throttle errors. I might be wrong about that, though.

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!

~|
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:308396
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 query timing out

2008-07-01 Thread Brad Wood
Glad it's working for you.

I really wish QofQ would support the INNER JOIN table_name tn ON
tn.column_name =  syntax.  To me, it is a lot easier to visually see
how each table is being tied into the results.

I have seen an incomplete join bring down the server when two large
tables were joined together with no criteria.  Like Jochem said, that is
a Cartesian join, which means EVERY POSSIBLE combination of records from
both tables will be returned.

Let's say you join two tables together that both have only 1,000
records.
You're going to get 1,000,000 records back.  This effect grows
exponentially.

~Brad


-Original Message-
From: Richard White [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 01, 2008 12:13 PM
To: CF-Talk
Subject: Re: query of query timing out

ok thanks brad, i have taken it out of the from list, you learn
something new everyday

i hadnt realised that by putting that in there that it would think that
i am joining it, even if i had not specified any columns from that query
but would still attempt to join it. to be honest i thought i needed it
to do the valuelist stuff as you said. 


it has sped it up thanks. you stated that i hadnt added any join clauses
but as i think you guessed there was not meant to be a join

thanks brad

~|
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:308397
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Simple cfmail driving me crazy!

2008-07-01 Thread Rick King
I've set up an email form (with a captcha) that will submit an email to a 
seller on my website. The TO attribute is simply a query variable. But for 
some reason, I keep getting the following error. 

Attribute validation error for tag CFMAIL.  The value of the attribute TO is 
invalid. The length of the string, 0 character(s), must be greater than or 
equal to 1.

I use a cfdump and it alwsys returns a valid email address, so I can't figure 
out why the cfmail thinks the TO field is empty.

Below is my code. Thanks in advance. Rick

---

cfparam name=URL.ProdID default= 

cfquery  name=getproducts datasource=DB
SELECT ProdID, Email
FROM Products P 

JOIN Users U
ON P.UserID = U.UserID

WHERE P.ProdID = cfqueryparam value=#Val(URL.ProdID)#  
cfsqltype=cf_sql_integer maxlength=4

/cfquery


cfset sendEmail = #getproducts.Email#

cfdump var=#sendEmail#


!--- create captcha ---
cfif not structKeyExists(application, captcha)
cfset application.captcha = createObject(component, 
captchaService).init(configFile=captcha.xml) /
cfset application.captcha.setup()
/cfif

cfparam name=form.name default=
cfparam name=form.email default=
cfparam name=form.comments default=
cfparam name=form.phone default=
cfset showForm = true

cfif structKeyExists(form, sendcomments)
cfset error = 
cfif not len(trim(form.name))
cfset error = error  Please include your name.br
/cfif
cfif not len(trim(form.email)) or not isValid(email, form.email)
cfset error = error  Please include a valid email 
address.br
/cfif
!---cfif not len(trim(form.comments))
cfset error = error  It's called a Comment Form, 
stupid.br
/cfif---
cfif not application.captcha.validateCaptcha(form.hash, form.captcha)
cfset error = error  You did not match the image text. 
Please try again.br
/cfif

cfif error is 
cfmail to=#sendEmail# bcc=[EMAIL PROTECTED] from=[EMAIL 
PROTECTED] subject=I'm interested in your dress on WoreItOnce.com 
server=mail.domain.com 
From: #form.name# (#form.email#)
Phone: #form.phone#
Comments:
#form.comments#
/cfmail
cfset showForm = false
/cfif
/cfif

cfif showForm
cfif structKeyExists(variables, error)
cfoutput
p
bPlease correct these errors:br
#error#
/b
/p
/cfoutput
/cfif

cfoutput
form action=test2.cfm method=post
table
tr
tdYour Name:br /
input type=text name=name value=#form.name#/td
/tr
tr
tdYour Email:br /
input type=text name=email 
value=#form.email#/td
/tr
tr
  tdYour Phone:br /
input name=phone type=text id=phone 
value=#form.phone#/td
/tr
tr
tdYour Comments:br /
textarea 
name=comments#form.comments#/textarea/td
/tr
tr
tdEnter Text Shown in Picture:br /

input type=text name=captchabr
!--- Captcha ---
cfset captcha = 
application.captcha.createHashReference()
img src=captcha.cfm?hash=#captcha.hash#
input name=hash type=hidden value=#captcha.hash# 
/  /td
/tr
tr
tdnbsp;
input type=submit name=sendcomments value=Send 
Comments/td
/tr
/table
/form
/cfoutput
cfelse
cfoutput
p
Thank you for sending your comments, #form.name#.
/p
/cfoutput
/cfif 

~|
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:308398
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Simple cfmail driving me crazy!

2008-07-01 Thread Charlie Griefer
for grins, try this:

cfset sendEmail = #getproducts.Email[1]#

On Tue, Jul 1, 2008 at 10:20 AM, Rick King [EMAIL PROTECTED] wrote:
 I've set up an email form (with a captcha) that will submit an email to a 
 seller on my website. The TO attribute is simply a query variable. But for 
 some reason, I keep getting the following error.

 Attribute validation error for tag CFMAIL.  The value of the attribute TO is 
 invalid. The length of the string, 0 character(s), must be greater than or 
 equal to 1.

 I use a cfdump and it alwsys returns a valid email address, so I can't 
 figure out why the cfmail thinks the TO field is empty.

 Below is my code. Thanks in advance. Rick

-- 
A byte walks into a bar and orders a pint. Bartender asks him What's
wrong? Byte says Parity error. Bartender nods and says Yeah, I
thought you looked a bit off.

~|
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:308399
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 query timing out

2008-07-01 Thread Richard White
your right, i wish they would support so much more in QoQ. i have read that it 
was not meant to be used in the way that so many people are now trying to use 
it. but i hope they realise that they have started the need for something that 
can really help people out and they should really satisfy the need they have 
created

i havent read or heard about any enhancements to the QoQ in version 9 though, 
its a real shame if they don't

thanks for your help again






Glad it's working for you.

I really wish QofQ would support the INNER JOIN table_name tn ON
tn.column_name =  syntax.  To me, it is a lot easier to visually see
how each table is being tied into the results.

I have seen an incomplete join bring down the server when two large
tables were joined together with no criteria.  Like Jochem said, that is
a Cartesian join, which means EVERY POSSIBLE combination of records from
both tables will be returned.

Let's say you join two tables together that both have only 1,000
records.
You're going to get 1,000,000 records back.  This effect grows
exponentially.

~Brad


ok thanks brad, i have taken it out of the from list, you learn
something new everyday

i hadnt realised that by putting that in there that it would think that
i am joining it, even if i had not specified any columns from that query
but would still attempt to join it. to be honest i thought i needed it
to do the valuelist stuff as you said. 


it has sped it up thanks. you stated that i hadnt added any join clauses
but as i think you guessed there was not meant to be a join

thanks brad 

~|
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:308400
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: left outer join on query of query function

2008-07-01 Thread Richard White
ok im getting there and have narrowed it down to 1 more problem - i hope!!

the problem is coming from the second part of the union where i am trying to 
find the rows that are eliminated in the first inner join part

this problem only stems from the fact that i have more than 1 primary key

if i had only 1 primary key then saying where queryA.ID not in 
#valuelist(queryB.id)# would work fine but what i have been doing is the 
following:

where queryA.ID1 not in #valuelist(queryB.id1)# 
and queryA.ID2 not in #valuelist(queryB.id2)#
and queryA.ID3 not in #valuelist(queryB.id3)#

and this is returning nothing, which is now obvious to me as it is not looking 
correctly at all the 3 ids to see which combination of the ids dont exist, it 
is looking at one column at a time and to see which id1 are not there, then 
which id2's are not there etc... instead of looking at them as a combination of 
three

does anyone know how i can achieve this:

if this explanation is not clear then i can provide an example 

thanks for your help



~|
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:308401
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Simple cfmail driving me crazy!

2008-07-01 Thread Rick King
hmm...that didn't seem to work. As soon as I hit the submit button on the form 
(and don't fill in the Captcha correctly so it returns the error message), the 
cfdump returns an empty string for the email address. For some reason, I 
can't get that email address to stick.

Any other ideas?
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:308402
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Simple cfmail driving me crazy!

2008-07-01 Thread Charlie Griefer
directly *after* the cfif error is , do a cfdump
var=#sendEmail#cfabort /.  is the value there?  is it what you
expected?



On Tue, Jul 1, 2008 at 11:32 AM, Rick King [EMAIL PROTECTED] wrote:
 hmm...that didn't seem to work. As soon as I hit the submit button on the 
 form (and don't fill in the Captcha correctly so it returns the error 
 message), the cfdump returns an empty string for the email address. For 
 some reason, I can't get that email address to stick.

 Any other ideas?
 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:308403
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Simple cfmail driving me crazy!

2008-07-01 Thread morgan l
Looks like you're posting the form to itself, but not carrying over the
URL.ProdID used in the where clause of the query in the form, so the second
time through, nothing is returned by the query.

On Tue, Jul 1, 2008 at 1:32 PM, Rick King [EMAIL PROTECTED] wrote:

 hmm...that didn't seem to work. As soon as I hit the submit button on the
 form (and don't fill in the Captcha correctly so it returns the error
 message), the cfdump returns an empty string for the email address. For
 some reason, I can't get that email address to stick.

 Any other ideas?
 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:308404
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


(ot) Anyone run into this issue w/ CrystalTech.com

2008-07-01 Thread Che Vilnonis
Just noticed it myself. Amazing that in 2008 that this is an issue.
http://forums.crystaltech.com/index.php/topic,33421.0.html

~Che


~|
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:308405
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: left outer join on query of query function

2008-07-01 Thread Brad Wood
This is off the top of head, but what if you did:

where not (queryA.ID1 in #valuelist(queryB.id1)# 
and queryA.ID2 in #valuelist(queryB.id2)#
and queryA.ID3 in #valuelist(queryB.id3)#)

That way the valuelists are done together as a group, and then the not
applies to all of them combined.

Does that even make sense?

~Brad

~|
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:308406
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Simple cfmail driving me crazy!

2008-07-01 Thread Rick King
You're correct...how would I carry over URL.ProdID? I'm drawing a blank.

Looks like you're posting the form to itself, but not carrying over the
URL.ProdID used in the where clause of the query in the form, so the second
time through, nothing is returned by the query.



 

~|
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:308407
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Simple cfmail driving me crazy!

2008-07-01 Thread Charlie Griefer
oooh good catch.

few ways to do it.  you could stick it in the form in a hidden field,
or you can append it to the form's action.

form action=test2.cfm?prodID=#URL.prodID# method=post

if you go the hidden form field route, i did a quickie blog post a
couple weeks back on form/URL vars...

http://charlie.griefer.com/blog/index.cfm/2008/5/30/dealing-with-form-and-URL-variables
(which was inspired by a thread here) :)

On Tue, Jul 1, 2008 at 11:52 AM, Rick King [EMAIL PROTECTED] wrote:
 You're correct...how would I carry over URL.ProdID? I'm drawing a blank.

Looks like you're posting the form to itself, but not carrying over the
URL.ProdID used in the where clause of the query in the form, so the second
time through, nothing is returned by the query.





 

~|
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:308408
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Simple cfmail driving me crazy!

2008-07-01 Thread morgan l
I'd pass it as a hidden field in the form, and then check at the top of the
page for it in the url or form scope, throw it in a variables.ProdID, and
use that in the query:


cfif StructKeyExists(form,ProdID)

cfset variables.ProdID = form.ProdID

cfelseif StructKeyExists(URL,ProdID)

cfset variables.ProdID = url.ProdID

cfelse

cfset variables.ProdID = 

/cfif

On Tue, Jul 1, 2008 at 1:52 PM, Rick King [EMAIL PROTECTED] wrote:

 You're correct...how would I carry over URL.ProdID? I'm drawing a blank.

 Looks like you're posting the form to itself, but not carrying over the
 URL.ProdID used in the where clause of the query in the form, so the
 second
 time through, nothing is returned by the query.
 
 
 
 

 

~|
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:308409
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: left outer join on query of query function

2008-07-01 Thread Richard White
Hi Brad, i thought that would work but not producing the result as expected, it 
still returns no rows on 2 queries where i know queryb has 15 rows that are not 
in querya therefore it should be returning those 15 but is not

thanks

This is off the top of head, but what if you did:

where not (queryA.ID1 in #valuelist(queryB.id1)# 
and queryA.ID2 in #valuelist(queryB.id2)#
and queryA.ID3 in #valuelist(queryB.id3)#)

That way the valuelists are done together as a group, and then the not
applies to all of them combined.

Does that even make sense?

~Brad 

~|
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:308410
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Simple cfmail driving me crazy!

2008-07-01 Thread Gerald Guido
Try commenting out the cfmail part and see what To: is returning

You should probably un-comment this line as well: ;-)

   !---cfif not len(trim(form.comments))
   cfset error = error  It's called a Comment Form,
stupid.br
   /cfif---



G

On Tue, Jul 1, 2008 at 1:20 PM, Rick King [EMAIL PROTECTED] wrote:

 I've set up an email form (with a captcha) that will submit an email to a
 seller on my website. The TO attribute is simply a query variable. But for
 some reason, I keep getting the following error.

 Attribute validation error for tag CFMAIL.  The value of the attribute TO
 is invalid. The length of the string, 0 character(s), must be greater than
 or equal to 1.

 I use a cfdump and it alwsys returns a valid email address, so I can't
 figure out why the cfmail thinks the TO field is empty.

 Below is my code. Thanks in advance. Rick



-- 
If everything seems under control, you're not going fast enough
-- Mario Andretti


~|
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:308411
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: left outer join on query of query function

2008-07-01 Thread Brad Wood
Maybe I should back up and make sure I understand what it is you want.
What you have written is a left outer join, but what you described was a
right outer join.

If you want the records in query B which do not exist in query A, then
you need to flip flop,  Query B needs to be in your FROM clause and
Query A needs to be in the value list stuff.

Here is a simple example I just tried that seems to work fine for me.  

cfquery datasource=your_datasource name=queryA
SELECT 11 AS ID1, 21 AS ID2, 31 AS ID3, 'exists in both' as
description
UNION SELECT 12, 22, 32, 'exists in both'
UNION SELECT 13, 23, 33, 'exists only in A'
UNION SELECT 14, 24, 34, 'exists only in A'
/cfquery

cfquery datasource=your_datasource name=queryB
SELECT 11 AS ID1, 21 AS ID2, 31 AS ID3, 'exists in both' as
description
UNION SELECT 12, 22, 32, 'exists in both'
UNION SELECT 15, 25, 35, 'exists only in B'
UNION SELECT 16, 26, 36, 'exists only in B'
/cfquery

cfquery dbtype=query name=qry_left_outer
SELECT *
FROM queryB
WHERE NOT (queryB.ID1 in (#valuelist(queryA.id1)#) and
queryB.ID2 in (#valuelist(queryA.id2)#) and queryB.ID3 in
(#valuelist(queryA.id3)#))
/cfquery

cfdump var=#qry_left_outer#

~Brad

-Original Message-
From: Richard White [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 01, 2008 2:13 PM
To: CF-Talk
Subject: Re: left outer join on query of query function

Hi Brad, i thought that would work but not producing the result as
expected, it still returns no rows on 2 queries where i know queryb has
15 rows that are not in querya therefore it should be returning those 15
but is not

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:308412
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: left outer join on query of query function

2008-07-01 Thread Richard White
thanks for the description brad, yes sorry i wrote it wrong they do exists in 
query a and not in query b so i want to find those that exist in querya and not 
in query b.

however your example is quite detailed and shows that the 'where not ()' clause 
should do the trick so there must be something else i am missing either in my 
code or previous outputs. i will output everything slowly to see why it is not 
returning the rows as expected

thanks again for your help




Maybe I should back up and make sure I understand what it is you want.
What you have written is a left outer join, but what you described was a
right outer join.

If you want the records in query B which do not exist in query A, then
you need to flip flop,  Query B needs to be in your FROM clause and
Query A needs to be in the value list stuff.

Here is a simple example I just tried that seems to work fine for me.  

cfquery datasource=your_datasource name=queryA
   SELECT 11 AS ID1, 21 AS ID2, 31 AS ID3, 'exists in both' as
description
   UNION SELECT 12, 22, 32, 'exists in both'
   UNION SELECT 13, 23, 33, 'exists only in A'
   UNION SELECT 14, 24, 34, 'exists only in A'
/cfquery

cfquery datasource=your_datasource name=queryB
   SELECT 11 AS ID1, 21 AS ID2, 31 AS ID3, 'exists in both' as
description
   UNION SELECT 12, 22, 32, 'exists in both'
   UNION SELECT 15, 25, 35, 'exists only in B'
   UNION SELECT 16, 26, 36, 'exists only in B'
/cfquery

cfquery dbtype=query name=qry_left_outer
   SELECT *
   FROM queryB
   WHERE NOT (queryB.ID1 in (#valuelist(queryA.id1)#) and
queryB.ID2 in (#valuelist(queryA.id2)#) and queryB.ID3 in
(#valuelist(queryA.id3)#))
/cfquery

cfdump var=#qry_left_outer#

~Brad

Hi Brad, i thought that would work but not producing the result as
expected, it still returns no rows on 2 queries where i know queryb has
15 rows that are not in querya therefore it should be returning those 15
but is not

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:308413
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: left outer join on query of query function

2008-07-01 Thread Brad Wood
Ok, good luck.  Note: I had to fiddle a little bit for my example to
work.  For instance, there needed to be () around the output of the
valuelist etc, but I assumed that had been omitted in your post as an
oversight or for simplicity.

You can start by dumping your two queries and visually confirming that
what you think exists in them actually does.

~Brad

-Original Message-
From: Richard White [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 01, 2008 3:14 PM
To: CF-Talk
Subject: Re: left outer join on query of query function

thanks for the description brad, yes sorry i wrote it wrong they do
exists in query a and not in query b so i want to find those that exist
in querya and not in query b.

however your example is quite detailed and shows that the 'where not ()'
clause should do the trick so there must be something else i am missing
either in my code or previous outputs. i will output everything slowly
to see why it is not returning the rows as expected

thanks again for your help


~|
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:308414
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Datasource Issue - CF7

2008-07-01 Thread Scott Mulholland
We had a test server recently run low on space and neo-query.xml became
corrupt.  We replaced it with a backup but since them any Access datasources
and ODBC Socket datasources always say they are not found.  If we try to
update them in the cf admin we get:

 

TCP/IP error, connection refused.
The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC
Driver]TCP/IP error, connection refused.

 

Anyone else have this issue and no the cause/fix?

 

Thanks,
Scott



~|
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:308415
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Killing registry keys

2008-07-01 Thread Bilal Soylu
If you can you temporarily switch storage back to registry and select the 
Purge Registry option to a shorter time.
Once cold fusion purged the registry entries you will have to compact registry 
with a tool: 
http://technet.microsoft.com/en-us/sysinternals/bb897426.aspx



~|
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:308416
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: left outer join on query of query function

2008-07-01 Thread Richard White
thanks brad no i hadn't omitted them for simplicity, i will try that as well 
then

thanks again you have been really helpful, will let you know what happens

Ok, good luck.  Note: I had to fiddle a little bit for my example to
work.  For instance, there needed to be () around the output of the
valuelist etc, but I assumed that had been omitted in your post as an
oversight or for simplicity.

You can start by dumping your two queries and visually confirming that
what you think exists in them actually does.

~Brad

thanks for the description brad, yes sorry i wrote it wrong they do
exists in query a and not in query b so i want to find those that exist
in querya and not in query b.

however your example is quite detailed and shows that the 'where not ()'
clause should do the trick so there must be something else i am missing
either in my code or previous outputs. i will output everything slowly
to see why it is not returning the rows as expected

thanks again for your help 

~|
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:308417
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Another Regex ?

2008-07-01 Thread Will Tomlinson
I'm trying to make sure a cfscript if or for statement has no spaces in it. 

if(someVar gt 0){
do this
}

I thought I had my regex workin, but it returns true on this:

cfset str = 'with the staff (measure expressions, note articulations,'

cfset re = [if|for]+\s+\(|\)\s+\{

cfoutput#reFindNoCase(re, str)#/cfoutput

That ain't good. WHat am I doin wrong?

Thanks,
Will 

~|
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:308419
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: left outer join on query of query function

2008-07-01 Thread Richard White
actually just looked at my real example and i do have the brackets!!! i think 
tiredness is getting me now, ill stop till tomorrow and try again, i find 
sometimes just taking my mind away from it makes it easier when i come back

thanks again

richard

thanks brad no i hadn't omitted them for simplicity, i will try that as well 
then

thanks again you have been really helpful, will let you know what happens

thanks again for your help 

~|
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:308418
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Another Regex ?

2008-07-01 Thread Will Tomlinson
I replaced the brackets with parenthesis and it seems to work now. 

(if|for)+\s+\(|\)\s+\{

Thanks,
Will 

~|
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:308420
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Simple cfmail driving me crazy!

2008-07-01 Thread Rick King
Thanks guys, it works now!
I added the hidden field to the form, tested for either a form or URL variable, 
and threw it in the variables.ProdID. Perfect!
Rick 

~|
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:308421
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Can't access variable scope in cfc?

2008-07-01 Thread Ian Rutherford
I'm trying to play nice with OOP and CFCs and using init methods to start them 
up but am running into a crazy problem that must have a simple fix.

I instantiate the cfc in the application scope:
cfset Application.cartCFC = createObject(component, 
cart).init(application.ds)

In the init method I have the following:
cfcomponent hint=I handle all cart interaction. output=false
cffunction name=init access=public output=false 
returntype=cart
cfargument name=ds required=true type=string
cfscript
variables.ds=arguments.ds;
/cfscript
cfreturn this
/cffunction

Then when I try to use variables.ds in another method call, it says that 
variables.ds doesn't exist even though when I set a breakpoint in the debugger 
right before that variable is called, it is there. What am I missing?

cffunction name=CalculateCartLinePricing access=public 
displayname=Calculate Line Item Price hint=I calculate the line item price 
and cost in a shopping cart. output=false returntype=Struct
cfargument default=1 name=CartDetail_Pk required=true 
type=Numeric

cfstoredproc procedure=pr_getCartLineTotals 
datasource=#variables.ds# 

~|
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:308422
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Can't access variable scope in cfc?

2008-07-01 Thread Ian Rutherford
Oh, here is the call I'm making which appears to be calling the correct cfc

cfinvoke component=#Application.cartCFC# method=getCart 
returnvariable=getWebCartDetails
cfinvokeargument name=UserID value=#variables.UserID#
/cfinvoke 

~|
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:308423
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Can't access variable scope in cfc?

2008-07-01 Thread Alan Rother
Real simple.

Here you invoked the CFC and dropped it into the Application scope

When you use CFINVOKE, you are re-instantiating the CFC, thus killing the
one you already had open.

Don't use CFINVOKE


do this instead

cfscript
variables.args=StructNew();
variables.args.UserID=variables.UserID;
getWebCartDetails=
Application.cartCFC.getCart(argumentCollection=variables.args);
/cfscript

On Tue, Jul 1, 2008 at 1:54 PM, Ian Rutherford [EMAIL PROTECTED]
wrote:

 Oh, here is the call I'm making which appears to be calling the correct cfc

 cfinvoke component=#Application.cartCFC# method=getCart
 returnvariable=getWebCartDetails
cfinvokeargument name=UserID value=#variables.UserID#
 /cfinvoke

 

~|
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:308424
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Can't access variable scope in cfc?

2008-07-01 Thread Ian Rutherford
I was wondering if that was the case. If that's true, then the cf docs seem to 
be wrong:

http://livedocs.adobe.com/coldfusion/8/htmldocs/buildingComponents_16.html

They say that cfinvoke doesn't recreate the object, it only calls it. 

~|
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:308425
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Can't access variable scope in cfc?

2008-07-01 Thread Ian Rutherford
Just in case, I tried your code and am getting the same error. 

~|
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:308426
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Can't access variable scope in cfc?

2008-07-01 Thread Ian Rutherford
Okay, I figured it out. I was calling the cfc directly instead of the one in 
the Application Scope from another page which was really throwing the error.

I am pretty sure that the cfinvoke tag does not create a new copy of the 
object. 

~|
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:308427
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Can't access variable scope in cfc?

2008-07-01 Thread Dave Watts
  cfinvoke component=#Application.cartCFC# method=getCart
  returnvariable=getWebCartDetails
 cfinvokeargument name=UserID value=#variables.UserID# 
  /cfinvoke

 Here you invoked the CFC and dropped it into the Application scope
 
 When you use CFINVOKE, you are re-instantiating the CFC, thus 
 killing the one you already had open.

This is not correct. If you use CFINVOKE and set the COMPONENT attribute's
value to an existing CFC instance, as above, it will call the method of the
CFC instance in memory without reinstantiating anything.

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!

~|
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:308428
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Spry accordion in a layoutarea

2008-07-01 Thread Brian McCairn
Why can I do this...

cfajaximport tags=cflayout-border

!--Link the CSS style  sheet that styles the accordion--
link href=assets/SpryAccordion.css rel=stylesheet type=text/css /
!--Link the Spry Accordion JavaScript library--
script src=assets/SpryAccordion.js type=text/javascript/script

cflayout style=height:285px; type=vbox  
cflayoutarea style=height:285px; name=mylyt
cfinclude template=accordionPage.cfm
/cflayoutarea
/cflayout

but not this...

cfajaximport tags=cflayout-border

!--Link the CSS style  sheet that styles the accordion--
link href=assets/SpryAccordion.css rel=stylesheet type=text/css /
!--Link the Spry Accordion JavaScript library--
script src=assets/SpryAccordion.js type=text/javascript/script

cflayout style=height:285px; type=vbox  
cflayoutarea style=height:285px; name=mylyt 
source=accordionPage.cfm

/cflayoutarea
/cflayout

this causes an Error processing Javascript in markup for element in mylyt:

This means I can't use ColdFusion.navigate() to load a page with a Spry 
accordion into a div or layoutarea.

? 

~|
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:308429
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Stored Procedure Not Working

2008-07-01 Thread Phillip Vector
I have a MS SQL database and I have a stored procedure I'm trying to
call with the following code..

cfset FutureTime=DateAdd('', 3, Now())
cfoutput#futureTime#/cfoutput

cfstoredproc procedure=GetDate dataSource=#datasource#
cfprocparam type=IN CFSQLType=CF_SQL_DATE value=#FutureTime#
dbVarName=@Future
cfprocparam type=IN CFSQLType=CF_SQL_VARCHAR
value=#session.UserID# dbVarName=@UserID

cfprocresult name=GetDate
/cfstoredproc

Here is the Stored Procedure

ALTER PROCEDURE [dbo].[GetDate]
@UserID varchar(50),
@Future Datetime

AS
BEGIN
SET NOCOUNT ON;

SELECT [DateTaken]
, [DateExpire]
from TestResults
Where UserID = @UserID
and DateExpire  @Future
Order by Score DESC

END

Here's the kicker... It works perfect on Firefox... IE and Opera, I
get the following coldfusion error...

Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Error converting data
type varchar to datetime.


First of all... Wha???

Second of all, if there is error in the code, why isn't firefox having
a problem displaying it. My boss (who knows a bit about coldfusion
says that firefox may be ignoring the error But that doesn't seem
logical to me..

Can someone shed some light on this?

~|
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:308430
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Stored Procedure Not Working

2008-07-01 Thread Brad Wood
Hmm, right off the bat, I don't think the browser would make any
difference unless you have ColdFusion code that behaves differently
depending on the browser.  Perhaps something is being cached.

Since getdate is the name of a function, maybe you should call your proc
something else.

Regardless, if appears your data types are mixed up.  Your proc params
list the date first and the varchar second, but the proc has the varchar
first and the date second.

~Brad

-Original Message-
From: Phillip Vector [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 01, 2008 4:52 PM
To: CF-Talk
Subject: Stored Procedure Not Working

I have a MS SQL database and I have a stored procedure I'm trying to
call with the following code..

~|
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:308431
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


See Gmail on your Google homepage

2008-07-01 Thread philjperry
Your friend, [EMAIL PROTECTED], has sent you the following Google 
Gadget and included this message:


See Gmail on your Google homepage »




~|
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:308432
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Stored Procedure Not Working

2008-07-01 Thread Phillip Vector
On Tue, Jul 1, 2008 at 2:55 PM, Brad Wood [EMAIL PROTECTED] wrote:
 Hmm, right off the bat, I don't think the browser would make any
 difference unless you have ColdFusion code that behaves differently
 depending on the browser.  Perhaps something is being cached.

I cleared out the cache and still the same issue. Also, no browser
specific code.

 Regardless, if appears your data types are mixed up.  Your proc params
 list the date first and the varchar second, but the proc has the varchar
 first and the date second.

I didn't know that it needs to be the same order. I switched it and
it's working now. Thanks. :)

Wierd though how firefox didn't error out.

~|
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:308433
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Lyla CAPTCHA

2008-07-01 Thread Rick King
Anyone else using Lyla captcha? 

In order to change the configuration of the captcha image, I need to update the 
xml file. OK, that's fine. But how do I re-instantiate the captcha object after 
making changes to the XML file so that I can see the updates on screen?

Thanks, Rick 

~|
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:308434
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Phillip Perry has invited you to open a Google mail account

2008-07-01 Thread Phillip Perry
I've been using Gmail and thought you might like to try it out. Here's
an invitation to create an account.

---

Phillip Perry has invited you to open a free Gmail account.

To accept this invitation and register for your account, visit
http://mail.google.com/mail/a-f23f08bf6f-4bfc5ddc1f-e86d8607a5

Once you create your account, Phillip Perry will be notified with
your new email address so you can stay in touch with Gmail!

If you haven't already heard about Gmail, it's a new search-based webmail
service that offers:

- Over 2,700 megabytes (two gigabytes) of free storage
- Built-in Google search that instantly finds any message you want
- Automatic arrangement of messages and related replies into
  conversations
- Powerful spam protection using innovative Google technology
- No large, annoying ads--just small text ads and related pages that are
  relevant to the content of your messages

To learn more about Gmail before registering, visit:
http://mail.google.com/mail/help/benefits.html

And, to see how easy it can be to switch to a new email service, check
out our new switch guide: http://mail.google.com/mail/help/switch/

We're still working every day to improve Gmail, so we might ask for your
comments and suggestions periodically.  We hope you'll like Gmail.  We
do.  And, it's only going to get better.

Thanks,

The Gmail Team

(If clicking the URLs in this message does not work, copy and paste them
into the address bar of your browser).

~|
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:308435
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Stored Procedure Not Working

2008-07-01 Thread Brad Wood
Named parameters didn't work in CF7.  There was a Hotfix that made them
work but I don't think it was ever part of the 7.0.1 or 7.0.2 release.

I don't know if it made it into CF 8 or not.

Chances are ColdFusion was defaulting to the usual practice of going off
the order of the proc param tags.

FWIW, running a trace on the database while you made the call would
probably have shown the inputs going in the wrong place.

~Brad

-Original Message-
From: Phillip Vector [mailto:[EMAIL PROTECTED] 

I didn't know that it needs to be the same order. I switched it and
it's working now. 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:308436
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Stopping Vacation Messages on BCC'd emails

2008-07-01 Thread Dan LeGate
Is there a way to get my mail server NOT to send a vacation message when 
I'm BCC'd on an email?  Is there some sort of email header I can inject 
with CFMAILPARAM?  (We use Exchange here, but hopefully there is 
something more generic in the protocol?)

I have a bunch of forms that post information, and many of them BCC me 
in the background.  When I setup a vacation message, all people who use 
this form get my vacation messages, and are very confused.

Any way to stop this, short of removing my vacation message?  (Yes, I 
know some people are vehemently opposed to using vacation messages - 
let's not go down that road here)

Thanks,

Dan

~|
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:308437
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Coldfusion Mapping

2008-07-01 Thread sam menon
Hi,
  Where will coldfusion mapping will be stored, I mean any xml file or 
something like that.

I need to get a mapping from CF admin, but I don't have access to the cf admin, 
so trying to get mapping info.
Can anyone please help me to find the details

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:308438
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: (ot) Anyone run into this issue w/ CrystalTech.com

2008-07-01 Thread Jim Davis
 -Original Message-
 From: Che Vilnonis [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, July 01, 2008 2:45 PM
 To: CF-Talk
 Subject: (ot) Anyone run into this issue w/ CrystalTech.com
 
 Just noticed it myself. Amazing that in 2008 that this is an issue.
 http://forums.crystaltech.com/index.php/topic,33421.0.html

I've not see it, but CrystalTech uses the Serv-U FTP Server (an
off-the-shelf server) - the bug is apparently in there.

If you're on a dedicated box you could enable the built-in Windows server to
upload the file.

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;203748912;27390454;j

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


Coldfusion Mapping

2008-07-01 Thread sam menon
Hi,
  Where will coldfusion mapping will be stored, I mean any xml file or 
something like that.

I need to get a mapping from CF admin, but I don't have access to the cf admin, 
so trying to get mapping info.
Can anyone please help me to find the details

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:308440
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Coldfusion Mapping

2008-07-01 Thread Jochem van Dieten
sam menon wrote:
   Where will coldfusion mapping will be stored, I mean any xml file or 
 something like that.

neo-runtime.xml

Jochem

~|
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:308441
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Stopping Vacation Messages on BCC'd emails

2008-07-01 Thread Jochem van Dieten
Dan LeGate wrote:
 Is there a way to get my mail server NOT to send a vacation message when 
 I'm BCC'd on an email?  Is there some sort of email header I can inject 
 with CFMAILPARAM?

You would have to find how to do it in manual of your mail server and 
once you have done that we can help you program the CF side.

Jochem

~|
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:308442
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Senior CF Developer - Designer Available Now

2008-07-01 Thread Stephen Hoskins
I am seeking a FT telecommute position as ColdFusion Developer.  Having 10 
years of programming experience, I am capable of entry into any phase of a 
project, whether it be from conception through QA or from QA through launch, as 
well as various aspects of work including: migrations, schema 
development/enhancement, code revision, documentation, graphical design and 
user-interface framework. 

I have experience as Lead Designer, Lead Developer and Project Manager. I hold 
a BFA and have worked with all formats of multimedia. Scripting I have used: 
ColdFusion, HTML, DHTML, Java, Javascript, SQL, Actionscript 3, ASP, ASP.NET, 
C# and probably a few more over the years... I am adept with Adobe Creative 
Suite products, hand coding, Eclipse, Server set-up, Access, SQL Server, some 
Oracle. 

I have created e-commerce solutions, goverment intranet and public sites and 
marketing websites and online systems.  

Having telecommuted for the past few years and would prefer to telecommute, 
travel is fine. 

Please find resume and contact information at http://www.Andonia.com

Stephen Hoskins
[EMAIL PROTECTED]


~|
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-Jobs-Talk/message.cfm/messageid:3889
Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11


Re: Senior CF Developer - Designer Available Now

2008-07-01 Thread [BWW] Ravi Gehlot
   Can you please post any future FLEX and ColdFusion jobs also at:
http://groups.google.com/group/adogo-jobs .

Thanks, RG.

On Tue, Jul 1, 2008 at 11:42 AM, Stephen Hoskins [EMAIL PROTECTED]
wrote:

 I am seeking a FT telecommute position as ColdFusion Developer.  Having 10
 years of programming experience, I am capable of entry into any phase of a
 project, whether it be from conception through QA or from QA through launch,
 as well as various aspects of work including: migrations, schema
 development/enhancement, code revision, documentation, graphical design and
 user-interface framework.

 I have experience as Lead Designer, Lead Developer and Project Manager. I
 hold a BFA and have worked with all formats of multimedia. Scripting I have
 used: ColdFusion, HTML, DHTML, Java, Javascript, SQL, Actionscript 3, ASP,
 ASP.NET http://asp.net/, C# and probably a few more over the years... I
 am adept with Adobe Creative Suite products, hand coding, Eclipse, Server
 set-up, Access, SQL Server, some Oracle.

 I have created e-commerce solutions, goverment intranet and public sites
 and marketing websites and online systems.

 Having telecommuted for the past few years and would prefer to telecommute,
 travel is fine.

 Please find resume and contact information at 
 http://www.Andonia.comhttp://www.andonia.com/

 Stephen Hoskins
 [EMAIL PROTECTED]


 

~|
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-Jobs-Talk/message.cfm/messageid:3890
Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11


Re: Senior CF Developer - Designer Available Now

2008-07-01 Thread Judith Dinowitz
It's really considered rude to ask people on one mailing list to go to
some other mailing list without at least contacting the list owner
first.

Judith Dinowitz
Vice President
House of Fusion


On Tue, Jul 1, 2008 at 7:53 PM, [BWW] Ravi Gehlot
[EMAIL PROTECTED] wrote:
   Can you please post any future FLEX and ColdFusion jobs also at:
 http://groups.google.com/group/adogo-jobs .

 Thanks, RG.

~|
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-Jobs-Talk/message.cfm/messageid:3891
Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11