Re: ajaxonload() problem

2007-10-04 Thread Azadi Saryev
Thanks for your reply, Dale!

yes, my cfgrid is bound to a cfc  and you say it won't work then?... 
hmm... there must be a way

if i understand you correctly:
ajax UI stuff is loaded and rendered first, and then any data is loaded 
into ajax controls;
and ajaxonload() fires inbetween the two?

it does make sense

so is there any way i can make my showTtlrows js function rnu AFTER the 
data is loaded into my cfgrid?
can i somehow listen to a loadData or some similar event in the 
cfgrid? is there such an event?

or is having my cfc.function write query.recordcount to a session var 
and then outputting that on calling page the only way to return 'total 
number of matches found' data?
any other ideas?

as for wrong count: you are wrong there.  calling my js function from a 
button click returns correct totalrecords, not per grid page, but total 
underlying query.recordcount
if you look at JSON data returned by queryConvertForGrid() function, it 
includes TOTALROWCOUNT element which is query.recordcount

thanks for your help on this - really appreciate it.

Azadi


Dale Fraser wrote:
 If you grid is using a binding, it will not work.

 As the Ajax and grid have loaded but the call to get the data hasn't
 occurred yet. Since binded data is paged, it would return the wrong count
 anyway.

 If your grid is not using binding, then im not sure.

 Regards
 Dale Fraser

 http://learncf.com

 -Original Message-
 From: Azadi Saryev [mailto:[EMAIL PROTECTED] 
 Sent: Thursday, 4 October 2007 1:29 PM
 To: CF-Talk
 Subject: ajaxonload() problem

 my second attempt at getting some help here...

 i am trying to use a cfset ajaxonload(showTtlrows) at the bottom of 
 my page to call a js function which gets total number of records from a 
 cfgrid (see js code below; yes, the function in itself is correct and 
 works).
 my cfgrid is bound to a cfc and works fine.  the js function is correct 
 and works, too - if i call my js function from an onclick event of a 
 button, it works just fine and returns correct number of records from my 
 cfgrid.

 the ajaxonload() call, however, does not work - it fires after the 
 cfgrid is drawn on the page but BEFORE it is populated with data: the 
 alert(totalrecords); pops up an alert over an empty cfgrid shell - only 
 the header and footer of the cfgrid are there, nothing else (no empty 
 rows, no data).

 i am far from an ajax pro, and maybe i am misunderstanding thsomething, 
 but i was under the impression that ajaxonload() fires after all ajax UI 
 elements on the page have fully loaded am i wrong?
 how can i make the ajaxonload() call run AFTER my cfgrid is populated 
 with data?

 thanks for any help!

 my js function:

 showTtlrows = function(){
 var mygrid = ColdFusion.Grid.getGridObject('resultsGrid');
 var mygridData = mygrid.getDataSource();
 var ttlrecords = mygridData.getTotalCount();
 //var ttlrecords = mygridData.totalLength;
 alert(ttlrecords);
 //document.getElementById('ttlrows').innerHTML = ttlrecords;
 }

   

-- 

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com


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

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


RE: CFIMAGE Resize Slow

2007-10-04 Thread Todd Mathews
Try Efflare. CFIMAGE is nice for some things but still has a ways to go
before it can catch up to ImageCR.

Todd 

 -Original Message-
 From: Eron Cohen [mailto:[EMAIL PROTECTED] 
 Sent: Wednesday, October 03, 2007 9:58 AM
 To: CF-Talk
 Subject: CFIMAGE Resize Slow
 
 I wondering if anyone has any advice about ColdFusion 8's 
 CFIMAGE being slow when resizing images.  Its REALLY slow.  I 
 have even brought my server down trying to resize a hundred 
 or so images.  Is this something that Adobe will eventually 
 fix?  I have another solution right now, but I am unhappy 
 with the quality of the thumbnails that it is creating.
 
 I have read this thread from August regarding the same 
 complaint, but I want to know if anything has changed:
 
 http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadi
d:53049#286647
 
 Thank you 
 
 

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

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


Re: error with ColdFusion 8 ODBC Agent

2007-10-04 Thread Vinu Kumar
I am trying to add a datasource to my new install of CF8 developer
edition.  When I went to do so in cf admin, the admin said The
ColdFusion ODBC Server service is not running or has not been
installed.  So I figured the service wasn't set to automatic and went
into services to start it up.  When I tried to start the service, I got
this error:
Could not start the ColdFusion 8 Odbc Server service on Local computer.
Error 3 The system cannot find the path specified.
 
I did a clean install of windows and CF 8.

Due to a bug, the ODBC required files are not laid down properly of 
documentation is not selected. Can you do a reinstallation with documentation 
selected?

- Vinu 

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

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


RE: error with ColdFusion 8 ODBC Agent

2007-10-04 Thread Hareni Venkatramanan
Hi Jim,

Just a small check, in the line

createObject(component,cfide.adminapi.administrator).login(admin)

Instead of admin, you need to provide your admin password. Is your
admin password the same?


Thanks,
Hareni


-Original Message-
From: Jim Easterly [mailto:[EMAIL PROTECTED] 
Sent: 04 October 2007 01:04
To: CF-Talk
Subject: Re: error with ColdFusion 8 ODBC Agent

Hi,
I have this same issue on a fresh install of CF8 Standard edition using
IIS.  When I run the scripts it returns this message,

The current user is not authorized to invoke this method.

I am logged in as the Administrator.

How should these .cfm pages be run?


Hi Matthew,

Sometimes, it might happen that the ODBC services Coldfusion8 ODBC
Agent
and Coldfusion 8 ODBC Server do not get installed properly for new J2EE
deployment and in services property the path keeps pointing to an old
deployment directory and hence they do not start up. 

What you can do is, remove the existing ODBC services using
remove-odbcservices.cfm having the script given below:

cfscript


createObject(component,cfide.adminapi.administrator).login(admin)
;

myObj =
createObject(component,cfide.adminapi.datasource);

writeOutput(Removing ODBC Services...br);

returnValue = myObj.removeODBCservice();

writeOutput(ODBC Services removed);

/cfscript



And then, install the ODBC services using install-odbcservices.cfm
having the script given below:

cfscript


createObject(component,cfide.adminapi.administrator).login(admin)
;

myObj =
createObject(component,cfide.adminapi.datasource);

writeOutput(Installing ODBC Services...br);

returnValue = myObj.installODBCservice();

writeOutput(ODBC Services installed);

/cfscript

Then, try starting ColdFusion ODBC Server service.

Thanks,
Hareni

I am trying to add a datasource to my new install of CF8 developer
edition.  When I went to do so in cf admin, the admin said The
ColdFusion ODBC Server service is not running or has not been
installed.  So I figured the service wasn't set to automatic and went
into services to start it up.  When I tried to start the service, I got
this error:
Could not start the ColdFusion 8 Odbc Server service on Local computer.
Error 3 The system cannot find the path specified.
 
I did a clean install of windows and CF 8. 



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

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


RE: Next lowest number from array (or list).

2007-10-04 Thread Asha K S
Hey thanks a lot for correcting I have just started learning. And one
more thing in the code I posted was we need to  break once the res has
been set in order to avoid looping through the whole list.


Thanks,
Asha.

-Original Message-
From: Patti Lee [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 04, 2007 1:21 AM
To: CF-Talk
Subject: Re: Next lowest number from array (or list).

That was kind of my point.  Pound signs within IF/ELSE/ELSEIF
statements are wholly unnecessary and are, to me at least, somewhat
indicative of a person who doesn't understand how ColdFusion processes
variables.  Not meant as harshly as it sounds, I promise, but might be
a useful thing to remember .

 I don't think it is necessary to put pound signs around your variables
 until and unless you need to print them on the screen. You can try
 removing them from the code given by Asha.



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

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


Re: Decimalformat() to round

2007-10-04 Thread ismail cassiem
Hi, Thank You but it still does not work

it returns a value of 
100.00 = 1
87.66 = 8 

I then tried #NumberFormat(test,'000')# but the I get for 78,77 = 078

Regards



Try
#NumberFormat(test,'0')#

_ 

Jake Churchill 
Team Leader
11204 Davenport, Ste. 100
Omaha, NE  68154 
http://www.cfwebtools.com 
402-408-3733 x103 


Hi, Need help.

#Decimalformat(test)#  
Result = 87.666

I want a result of 88. 

Anyone please assist.

Regards 

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

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


RE: Decimalformat() to round

2007-10-04 Thread Dale Fraser
#int(variable)#


Regards
Dale Fraser

http://learncf.com


-Original Message-
From: ismail cassiem [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 4 October 2007 5:59 PM
To: CF-Talk
Subject: Re: Decimalformat() to round

Hi, Thank You but it still does not work

it returns a value of 
100.00 = 1
87.66 = 8 

I then tried #NumberFormat(test,'000')# but the I get for 78,77 = 078

Regards



Try
#NumberFormat(test,'0')#

_ 

Jake Churchill 
Team Leader
11204 Davenport, Ste. 100
Omaha, NE  68154 
http://www.cfwebtools.com 
402-408-3733 x103 


Hi, Need help.

#Decimalformat(test)#  
Result = 87.666

I want a result of 88. 

Anyone please assist.

Regards 



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

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


RE: ajaxonload() problem

2007-10-04 Thread Dale Fraser
There is probably a way of getting the CFC to access the page. Using
javascript and innerHTML.

I've tried it myself recently without luck. So im not sure if there are any
technical reasons that the CFC wouldn't be able to access the page via
javascript.

Someone here should know.

Regards
Dale Fraser

http://learncf.com


-Original Message-
From: Azadi Saryev [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 4 October 2007 4:09 PM
To: CF-Talk
Subject: Re: ajaxonload() problem

Thanks for your reply, Dale!

yes, my cfgrid is bound to a cfc  and you say it won't work then?... 
hmm... there must be a way

if i understand you correctly:
ajax UI stuff is loaded and rendered first, and then any data is loaded 
into ajax controls;
and ajaxonload() fires inbetween the two?

it does make sense

so is there any way i can make my showTtlrows js function rnu AFTER the 
data is loaded into my cfgrid?
can i somehow listen to a loadData or some similar event in the 
cfgrid? is there such an event?

or is having my cfc.function write query.recordcount to a session var 
and then outputting that on calling page the only way to return 'total 
number of matches found' data?
any other ideas?

as for wrong count: you are wrong there.  calling my js function from a 
button click returns correct totalrecords, not per grid page, but total 
underlying query.recordcount
if you look at JSON data returned by queryConvertForGrid() function, it 
includes TOTALROWCOUNT element which is query.recordcount

thanks for your help on this - really appreciate it.

Azadi


Dale Fraser wrote:
 If you grid is using a binding, it will not work.

 As the Ajax and grid have loaded but the call to get the data hasn't
 occurred yet. Since binded data is paged, it would return the wrong count
 anyway.

 If your grid is not using binding, then im not sure.

 Regards
 Dale Fraser

 http://learncf.com

 -Original Message-
 From: Azadi Saryev [mailto:[EMAIL PROTECTED] 
 Sent: Thursday, 4 October 2007 1:29 PM
 To: CF-Talk
 Subject: ajaxonload() problem

 my second attempt at getting some help here...

 i am trying to use a cfset ajaxonload(showTtlrows) at the bottom of 
 my page to call a js function which gets total number of records from a 
 cfgrid (see js code below; yes, the function in itself is correct and 
 works).
 my cfgrid is bound to a cfc and works fine.  the js function is correct 
 and works, too - if i call my js function from an onclick event of a 
 button, it works just fine and returns correct number of records from my 
 cfgrid.

 the ajaxonload() call, however, does not work - it fires after the 
 cfgrid is drawn on the page but BEFORE it is populated with data: the 
 alert(totalrecords); pops up an alert over an empty cfgrid shell - only 
 the header and footer of the cfgrid are there, nothing else (no empty 
 rows, no data).

 i am far from an ajax pro, and maybe i am misunderstanding thsomething, 
 but i was under the impression that ajaxonload() fires after all ajax UI 
 elements on the page have fully loaded am i wrong?
 how can i make the ajaxonload() call run AFTER my cfgrid is populated 
 with data?

 thanks for any help!

 my js function:

 showTtlrows = function(){
 var mygrid = ColdFusion.Grid.getGridObject('resultsGrid');
 var mygridData = mygrid.getDataSource();
 var ttlrecords = mygridData.getTotalCount();
 //var ttlrecords = mygridData.totalLength;
 alert(ttlrecords);
 //document.getElementById('ttlrows').innerHTML = ttlrecords;
 }

   

-- 

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com




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

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


RE: Decimalformat() to round

2007-10-04 Thread Asha K S
Hi,

Why don't you try #round(test)#.


Thanks,
Asha.

-Original Message-
From: ismail cassiem [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 03, 2007 9:17 PM
To: CF-Talk
Subject: Decimalformat() to round

Hi, Need help.

#Decimalformat(test)#  
Result = 87.666

I want a result of 88. 

Anyone please assist.

Regards




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

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


CFGrid HTML Questions

2007-10-04 Thread Dale Fraser
I have a host of grid questions, google has helped me a lot but stuck on
some.

 

1.  Can I deselect the selected row using javascript so that either a
different row or no row is selected.

2.  Can the binded CFC modify the HTML, ie can the CFC do a Grid.refresh or
even change the element of a grid or form.

3.  Can I detect in my bound CFC the action that occurred, ie refresh,
navigate between pages etc

4.  Can I have a bound CFC without paging.

 

Regards

Dale Fraser

 

http://learncf.com

 



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

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


Re: Decimalformat() to round

2007-10-04 Thread ismail cassiem
Great... Thank You it works!!!


#int(variable)#


Regards
Dale Fraser

http://learncf.com


Hi, Thank You but it still does not work

it returns a value of 
100.00 = 1
87.66 = 8 

I then tried #NumberFormat(test,'000')# but the I get for 78,77 = 078

Regards 

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

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


Re: Decimalformat() to round

2007-10-04 Thread ismail cassiem
Thanks, this also works... 
Thanks

Hi,

Why don't you try #round(test)#.


Thanks,
Asha.

Hi, Need help.

#Decimalformat(test)#  
Result = 87.666

I want a result of 88. 

Anyone please assist.

Regards 

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

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


RE: Next lowest number from array (or list).

2007-10-04 Thread Dale Fraser
The reason I didn't break was in case the list wasn't in order.

My version would work on an unordered list.

Regards
Dale Fraser

http://learncf.com


-Original Message-
From: Asha K S [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 4 October 2007 4:59 PM
To: CF-Talk
Subject: RE: Next lowest number from array (or list).

Hey thanks a lot for correcting I have just started learning. And one
more thing in the code I posted was we need to  break once the res has
been set in order to avoid looping through the whole list.


Thanks,
Asha.

-Original Message-
From: Patti Lee [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 04, 2007 1:21 AM
To: CF-Talk
Subject: Re: Next lowest number from array (or list).

That was kind of my point.  Pound signs within IF/ELSE/ELSEIF
statements are wholly unnecessary and are, to me at least, somewhat
indicative of a person who doesn't understand how ColdFusion processes
variables.  Not meant as harshly as it sounds, I promise, but might be
a useful thing to remember .

 I don't think it is necessary to put pound signs around your variables
 until and unless you need to print them on the screen. You can try
 removing them from the code given by Asha.





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

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


RE: Decimalformat() to round

2007-10-04 Thread Dale Fraser
Hope you realise they are different.

int(variable) will round down
round(variable) will round average (up or down depending on if  .5 or not)
celling(variable) will round up

Regards
Dale Fraser

http://learncf.com


-Original Message-
From: ismail cassiem [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 4 October 2007 6:36 PM
To: CF-Talk
Subject: Re: Decimalformat() to round

Thanks, this also works... 
Thanks

Hi,

Why don't you try #round(test)#.


Thanks,
Asha.

Hi, Need help.

#Decimalformat(test)#  
Result = 87.666

I want a result of 88. 

Anyone please assist.

Regards 



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

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


RE: CFGrid HTML Questions

2007-10-04 Thread Dale Fraser
Also,

I think I have a bug. I am manually controlling the page in a paged list by
setting the page variable. It works fine, so that (20 per page) when record
21 is added it takes you to page two, all is good except, the paging
controls don't refresh, it does display that there are 2 pages, but there is
no  to get to page one and still  to get to the next page. As it still
thinks it's on page one.

And one more, anyone know if column sorting can be disabled.

Regards
Dale Fraser

http://learncf.com

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

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


Re: Next lowest number from array (or list).

2007-10-04 Thread Andrew Scott
What would be more interesting is if you ordered the list would it be
faster to execute compared to unordering the list?


On 10/4/07, Dale Fraser [EMAIL PROTECTED] wrote:
 The reason I didn't break was in case the list wasn't in order.

 My version would work on an unordered list.

 Regards
 Dale Fraser

 http://learncf.com


 -Original Message-
 From: Asha K S [mailto:[EMAIL PROTECTED]
 Sent: Thursday, 4 October 2007 4:59 PM
 To: CF-Talk
 Subject: RE: Next lowest number from array (or list).

 Hey thanks a lot for correcting I have just started learning. And one
 more thing in the code I posted was we need to  break once the res has
 been set in order to avoid looping through the whole list.


 Thanks,
 Asha.

 -Original Message-
 From: Patti Lee [mailto:[EMAIL PROTECTED]
 Sent: Thursday, October 04, 2007 1:21 AM
 To: CF-Talk
 Subject: Re: Next lowest number from array (or list).

 That was kind of my point.  Pound signs within IF/ELSE/ELSEIF
 statements are wholly unnecessary and are, to me at least, somewhat
 indicative of a person who doesn't understand how ColdFusion processes
 variables.  Not meant as harshly as it sounds, I promise, but might be
 a useful thing to remember .

  I don't think it is necessary to put pound signs around your variables
  until and unless you need to print them on the screen. You can try
  removing them from the code given by Asha.





 

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

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


Re: XML Compression Script

2007-10-04 Thread Jochem van Dieten
jonese wrote:
 No we want to remove line breaks, carriage returns spaces etc. and then save
 it in our DB as a text data.

I have something for that.

Jochem


!--
Copyright (c) 2007, Jochem van Dieten
All rights reserved.

Redistribution and use in source and binary forms, with or without
modification, are permitted provided that the following conditions are
met:

* Redistributions of source code must retain the above copyright notice,
   this list of conditions and the following disclaimer.
* Redistributions in binary form must reproduce the above copyright
   notice, this list of conditions and the following disclaimer in the
   documentation and/or other materials provided with the distribution.

THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS AS
IS AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED
TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A
PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE AUTHORS OR
CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR
PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF
LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
---
cffunction access=public name=trimXML output=false 
hint=Recursively walk through an XML object and trim all whitespace out 
of XMLtext
   cfargument name=old type=any required=yes
   cfargument name=xmlObj type=any required=no

   cfset var new = 0
   cfset var structList = 
   cfset var xmlList = 
   cfset var i = 0

   cfif IsArray(old)
 cfset new=ArrayNew(1)
 cfloop from=1 to=#ArrayLen(old)# index=i
   cfset new[i] = trimXML(old[i])
 /cfloop
 cfreturn new
   /cfif

   cfif IsStruct(old)
 cfset new=structNew()
 cfset structList = StructKeyList(old)
 cfloop list=#structList# index=key
   cfset new[key] = trimXML(old[key])
 /cfloop
 cfreturn new
   /cfif

   cfif IsXMLDoc(old)
 cfset new=XmlNew()
 cfset xmlList = StructKeyList(old)
 cfloop list=#xmlList# index=elem
   cfset new[elem] = trimXML(old[elem], new)
 /cfloop
 cfreturn new
   /cfif

   cfif IsXmlElem(old)
 cfset new=XmlElemNew(arguments.xmlObj,arguments.old.XMLName)
 cfif Len(Trim(arguments.old.XMLText))
   !--- Only create new XMLText when there is something left after 
trimming ---
   cfset new.XMLText = arguments.old.XMLText
 /cfif
 cfif NOT StructIsEmpty(old.XMLAttributes)
   cfset new.XMLAttributes = Duplicate(old.XMLAttributes)
 /cfif
 cfset structList = StructKeyList(old)
 cfloop from=1 to=#ListLen(structList)# index=i
   cfset new.XmlChildren[i] = 
TrimXML(old.XmlChildren[i],arguments.xmlObj)
 /cfloop
 cfreturn new
   /cfif

   cfif IsSimpleValue(old)
 cfreturn old
   /cfif

/cffunction

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

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


Passing query value via a javascript to next form

2007-10-04 Thread ismail cassiem
Hi, I need help passing the value through to the next form via javascript
it does not like the value =+'#trim(Corp_Cust_Code)#'; 

cfoutput query=get_info
tr onclick=onCust();
 td
   #cust#
 /td 
/tr
/cfoutput

script language=javascript
   function onCust()
   {
 location.href=Mis012F3.cfm?dblib=#dblibCorp=+'#trim(Corp_Cust_Code)#'; 
   }
/script

Please any help, Regards 

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

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


Re: Passing query value via a javascript to next form

2007-10-04 Thread ismail cassiem
Sorry I copied it incorrectly buut still does not work. 

  location.href=Mis012F3.cfm?dblib=#dblib#Corp=+'#trim(Corp_Cust_Code)#'; 


I think your missing a quote and a #.

Change

location.href=Mis012F3.cfm?dblib=#dblibCorp=+'#trim(Corp_Cust_Code)#';

to

location.href='Mis012F3.cfm?dblib=#dblibCorp#='+'#trim(Corp_Cust_Code)#';

but it still doesn't make sense why the + is in there.

Regards
Dale Fraser

http://learncf.com


Hi, I need help passing the value through to the next form via javascript
it does not like the value =+'#trim(Corp_Cust_Code)#'; 

cfoutput query=get_info
tr onclick=onCust();
 td
   #cust#
 /td 
/tr
/cfoutput

script language=javascript
   function onCust()
   {
 location.href=Mis012F3.cfm?dblib=#dblibCorp=+'#trim(Corp_Cust_Code)#';

   }
/script

Please any help, Regards 

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

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


Re: Case Sensitivity

2007-10-04 Thread David Low
Tim Ashworth wrote:
 I was under the impression that coldfusion was entirely case insensitive
 regardless of if it is on a windows or linux OS.  So I'm quite happily
 writing everything in lower case and camel case, but my colleague is
 convinced that this is wrong.  Whilst I appreciate that it's a good idea to
 stick to a convention and not be too sloppy I have to confess I'm getting a
 bit fed up checking case when I'm sure it's not an issue.  I have done some
 tests and it all *seems* case insensitive, but I'd appreciate some back-up
 from a more experienced CF developer.

I've seen people have big problems with case sensitivity on Linux, when 
they didn't capitalise the 'A' in 'Application.cfm' and so on.

Other than for file operations though, it shouldn't matter within the 
CFML itself.

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

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


Case Sensitivity

2007-10-04 Thread Tim Ashworth
Hi All,
 
This is just a quickie, and really not too important.  However it will clear
up an argument that I'm having with my rather conservative colleague.
 
I was under the impression that coldfusion was entirely case insensitive
regardless of if it is on a windows or linux OS.  So I'm quite happily
writing everything in lower case and camel case, but my colleague is
convinced that this is wrong.  Whilst I appreciate that it's a good idea to
stick to a convention and not be too sloppy I have to confess I'm getting a
bit fed up checking case when I'm sure it's not an issue.  I have done some
tests and it all *seems* case insensitive, but I'd appreciate some back-up
from a more experienced CF developer.
 
Cheers
 
Tim 
 
*hopes that he's right or he'll have to check the last app he wrote*


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

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


RE: Passing query value via a javascript to next form

2007-10-04 Thread Dale Fraser
I think your missing a quote and a #.

Change

location.href=Mis012F3.cfm?dblib=#dblibCorp=+'#trim(Corp_Cust_Code)#';

to

location.href='Mis012F3.cfm?dblib=#dblibCorp#='+'#trim(Corp_Cust_Code)#';

but it still doesn't make sense why the + is in there.

Regards
Dale Fraser

http://learncf.com


-Original Message-
From: ismail cassiem [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 4 October 2007 9:01 PM
To: CF-Talk
Subject: Passing query value via a javascript to next form

Hi, I need help passing the value through to the next form via javascript
it does not like the value =+'#trim(Corp_Cust_Code)#'; 

cfoutput query=get_info
tr onclick=onCust();
 td
   #cust#
 /td 
/tr
/cfoutput

script language=javascript
   function onCust()
   {
 location.href=Mis012F3.cfm?dblib=#dblibCorp=+'#trim(Corp_Cust_Code)#';

   }
/script

Please any help, Regards 



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

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


Re: Case Sensitivity

2007-10-04 Thread J.J. Merrick
From what I have encountered most things are case insensitive. The
only thing I would say is if you are working with *nix disk access is
that directories and filenames are case-sensitive or if you are
calling anything in Java that that is case-sensitive. The only reason
to check case would be for readability and to be that anal about it is
a tad overboard. As long as you aren't typing them in all-caps
(::cough:: ::cough:: Ray ::cough::) You should be ok in my book :-)


J.J.

On 10/4/07, Tim Ashworth [EMAIL PROTECTED] wrote:
 Hi All,

 This is just a quickie, and really not too important.  However it will clear
 up an argument that I'm having with my rather conservative colleague.

 I was under the impression that coldfusion was entirely case insensitive
 regardless of if it is on a windows or linux OS.  So I'm quite happily
 writing everything in lower case and camel case, but my colleague is
 convinced that this is wrong.  Whilst I appreciate that it's a good idea to
 stick to a convention and not be too sloppy I have to confess I'm getting a
 bit fed up checking case when I'm sure it's not an issue.  I have done some
 tests and it all *seems* case insensitive, but I'd appreciate some back-up
 from a more experienced CF developer.

 Cheers

 Tim

 *hopes that he's right or he'll have to check the last app he wrote*


 

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

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


RE: Passing query value via a javascript to next form

2007-10-04 Thread Dale Fraser
You are still missing a ' after the href=

Regards
Dale Fraser

http://learncf.com

-Original Message-
From: ismail cassiem [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 4 October 2007 9:36 PM
To: CF-Talk
Subject: Re: Passing query value via a javascript to next form

Sorry I copied it incorrectly buut still does not work. 

  location.href=Mis012F3.cfm?dblib=#dblib#Corp=+'#trim(Corp_Cust_Code)#'; 


I think your missing a quote and a #.

Change

location.href=Mis012F3.cfm?dblib=#dblibCorp=+'#trim(Corp_Cust_Code)#';

to

location.href='Mis012F3.cfm?dblib=#dblibCorp#='+'#trim(Corp_Cust_Code)#';

but it still doesn't make sense why the + is in there.

Regards
Dale Fraser

http://learncf.com


Hi, I need help passing the value through to the next form via javascript
it does not like the value =+'#trim(Corp_Cust_Code)#'; 

cfoutput query=get_info
tr onclick=onCust();
 td
   #cust#
 /td 
/tr
/cfoutput

script language=javascript
   function onCust()
   {

location.href=Mis012F3.cfm?dblib=#dblibCorp=+'#trim(Corp_Cust_Code)#';

   }
/script

Please any help, Regards 



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

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


Re: Passing query value via a javascript to next form

2007-10-04 Thread ismail cassiem
Thank You for Your Assistance, I got it going.
onclick=onCust('#trim(Corp_Cust_Code)#');

 function onCust(cust)
 {
   location.href=Mis012F3.cfm?dblib=#dblib#Corp=+cust;
 }

Thank You

You are still missing a ' after the href=

Regards
Dale Fraser

http://learncf.com

Sorry I copied it incorrectly buut still does not work. 

  location.href=Mis012F3.cfm?dblib=#dblib#Corp=+'#trim(Corp_Cust_Code)#'; 


location.href=Mis012F3.cfm?dblib=#dblibCorp=+'#trim(Corp_Cust_Code)#';

   }
/script

Please any help, Regards 

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

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


RE: Case Sensitivity

2007-10-04 Thread Dale Fraser
Beware,

ColdFusion is becoming more case sensitive, so you should be careful.

These new ColdFusion features (which are javascript) are case Sensitive.

ColdFusion.Grid.refresh('gridName');

For example. Im not sure but I think (due to file system stuff)

cfset me = createObject(component, com.company.Class) /

Might be case sensitive on *nix as the com.company.Class bits are file
references.

Regards
Dale Fraser

http://learncf.com


-Original Message-
From: J.J. Merrick [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 4 October 2007 8:53 PM
To: CF-Talk
Subject: Re: Case Sensitivity

From what I have encountered most things are case insensitive. The
only thing I would say is if you are working with *nix disk access is
that directories and filenames are case-sensitive or if you are
calling anything in Java that that is case-sensitive. The only reason
to check case would be for readability and to be that anal about it is
a tad overboard. As long as you aren't typing them in all-caps
(::cough:: ::cough:: Ray ::cough::) You should be ok in my book :-)


J.J.

On 10/4/07, Tim Ashworth [EMAIL PROTECTED] wrote:
 Hi All,

 This is just a quickie, and really not too important.  However it will
clear
 up an argument that I'm having with my rather conservative colleague.

 I was under the impression that coldfusion was entirely case insensitive
 regardless of if it is on a windows or linux OS.  So I'm quite happily
 writing everything in lower case and camel case, but my colleague is
 convinced that this is wrong.  Whilst I appreciate that it's a good idea
to
 stick to a convention and not be too sloppy I have to confess I'm getting
a
 bit fed up checking case when I'm sure it's not an issue.  I have done
some
 tests and it all *seems* case insensitive, but I'd appreciate some back-up
 from a more experienced CF developer.

 Cheers

 Tim

 *hopes that he's right or he'll have to check the last app he wrote*


 



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

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


Re: Verity server inaccessible after Cf8 upgrade

2007-10-04 Thread Rick Root
so.. where can I download an installer for re-installing verity
without reinstalling coldfusion?

On 10/3/07, Rick Root [EMAIL PROTECTED] wrote:
 On 10/2/07, Jayesh Viradiya [EMAIL PROTECTED] wrote:
  You should also be able to download the Verity server from the place you
  got your CF8. And that verity should be able to install with your CF8
  license key.

 Nope, it's not.

 I went here:

 http://www.adobe.com/products/coldfusion/

 Clicked on Download a free trial

 Only coldfusion installers are on that page.  I clicked on See All
 Downloads and there's nothing there about Verity.

 I googled reinstall verity coldfusion

 I found this page:

 http://www.adobe.com/support/coldfusion/verity_reg/register/index.cgi

 But that's for Coldfusion 7... I tried my CF7 product key just in case
 the CF8 verity downloads are behind that page, but it wouldn't accept
 my CF7 product key.

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



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

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290157
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: Query Help

2007-10-04 Thread Rick Root
I figured this out finally.

Turned out that my data types for the row_id field were different...
my query_results.row_id was an int, while giftab1.row_id was a
nvarchar(7)... I didn't make the original giftab1 table so I have no
idea WHY it was such, since row_id contains only unique integers!)

Once I matched up the data types, the clustered index scan became a
clustered idnex seek and performed MUCH better.

Rick

On 10/3/07, Rick Root [EMAIL PROTECTED] wrote:
 Damn, this is killing me!  People rarely generate printed reports in
 our system, but this issue will make it nearly impossible to do a
 printed report with more than a few entities, since it takes 7 seconds
 per entity for the subreport containing the query in question to
 execute.


 On 10/2/07, Rick Root [EMAIL PROTECTED] wrote:
  Man, I'm having all kinds of brain farts today.
 
  I'm trying to optimize the following query:
 
  SELECT DISTINCT (fieldlist)
  FROM  GIFTAB1 B INNER JOIN QUERY_RESULTS C
  ON B.ROW_ID = C.ROWID
  WHERE C.QUERYID = #param.QUERYID#
  AND C.ENTITYID = '#param.ENTITY_ID#'
  ORDER BY B.ENTITY_ID, B.CREDTDAT DESC
 
  GIFTAB1 contains almost million rows of data, and query_results
  contains a varying amount of rows, depending on activity, time of day,
  etc..  specifically in this case, QUERY_RESULTS contains 341 rows that
  match the aboe criteria, and currently contains about 8000 rows total.
 
  This query takes 7 seconds to return 7 rows of data given a specific
  queryid and entity id.  I have indexes on all relevant columns, and
  row_id on giftab1 is actually a unique clustered index.
 
  I show the query execution plan, and my biggest hit (92%) is a
  Clustered Index Scan on giftab1 ... the row id join.
 
  A similar query in our legacy application performs MUCH better:
 
  SELECT DISTINCT (fieldlist)
  FROM  GIFTAB1 B INNER JOIN GIFTREPORTS C
  ON B.ROW_ID = C.ROW_ID
  WHERE C.USERNAME='GROLWR'
  AND C.ENTITY_ID = '88'
  ORDER BY B.ENTITY_ID, B.CREDTDAT DESC
 
  The problem appears to be in my first query, that the clustered indes
  scan lists actual number of rows as 3.9 million - the FASTER query
  doesn't do this... the faster query uses an index scan on giftreports
  and an index seek on giftab1.  Both contain 7 rows.
 
  --
  Rick Root
  Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at
  www.opensourcecf.com
 


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



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

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

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


RE: Passing query value via a javascript to next form

2007-10-04 Thread Bobby Hartsfield
I don't know what is in your variable but #justStringFormat()# is a big
headache saver when you are not sure either.

..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com

-Original Message-
From: ismail cassiem [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 04, 2007 7:01 AM
To: CF-Talk
Subject: Passing query value via a javascript to next form

Hi, I need help passing the value through to the next form via javascript it
does not like the value =+'#trim(Corp_Cust_Code)#'; 

cfoutput query=get_info
tr onclick=onCust();
 td
   #cust#
 /td
/tr
/cfoutput

script language=javascript
   function onCust()
   {
 location.href=Mis012F3.cfm?dblib=#dblibCorp=+'#trim(Corp_Cust_Code)#';

   }
/script

Please any help, Regards 



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

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


date format display

2007-10-04 Thread Orlini, Robert
Hello,

I brought this up before, but I need a date (displayed for example as: 
20071104) to be formatted to display 
as 11-04-2007. It is not a date/time field just a char field in SQL.
The name of the field is enddate.
Thanks as always.
Robert O.
I tried: #dateformat(get.enddate,MMDD)#, but get
Parameter validation error for function DATEFORMAT. 
The value of the parameter 1, which is currently get.enddate, must be a class 
java.util.Date value. 

Tried formatting with CreateODBCDate, but get: {d '56852-10-23'}
or
DateFormat(CreateODBCDate(get.enddate),  d, ),  I get : October 23, 
56852






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

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


Re: code not working

2007-10-04 Thread Kris Jones
You could just cfparam the value with a zero:
cfparam name=form.availabletest default=0 /
.. . .

INNER JOIN dbo.People AS p ON p.people_id=ps.peopleSummary_peopleID
WHERE peopleSummaryPeriod=#getcurrentperiod.peopleSummaryPeriod#
AND ps.peopleSummary_peopleID IN (#form.availabletest#)
.. . .

And, yes, you can use a cfqueryparam, but it doesn't address this issue.

Cheers,
Kris

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

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


Re: CFGRID Binding without Paging

2007-10-04 Thread gary gilbert
Hi Dale,

You should be able to access the underlying EXT Grid and remove the footer
panel.

script language=javascript
removeFooter = function()
{
mygrid = ColdFusion.Grid.getGridObject('thegridname');
mygrid.getView().getFooterPanel().remove();
}
/script

then at the end of your cfm page

cfset ajaxOnLoad(removeFooter)

Regards,
-- 
Gary Gilbert
http://www.garyrgilbert.com/blog


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

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


SPRY Image Loading Question

2007-10-04 Thread Chad McCue
I am running the latest version of SPRY and ColdFusion 7 and I am using
the SpryPagedView.js functionality for displaying my products. The
problem I am having (only on IE 6) is that the first page loads fine and
displays all my information including the product thumbnails, but if I
hit Next Page only some of the product thumbnails load and the rest
have my designers Grey background box that is supposed to be behind all
the thumbnails.
 
Again this is only happening on IE 6


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

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


Re: Voting System: Not allowing multiple votes

2007-10-04 Thread Tom Chiverton
On Thursday 04 Oct 2007, [EMAIL PROTECTED] wrote:
 Thoughts?

Someone asked on the newsgroup a few months back.
The up shot is you can't.
Even if you have a Java app that reads the NIC's MAC, it's trivial to change 
the MAC through software.
Ditto a hardware hash.

It depends what the likely attack method / threat profile is really as to how 
far you go.
Even if you took the non preferred option of requiring email address, and a 
click on a link you email them, that trivial for an attacked to automate. For 
instance.

-- 
Tom Chiverton
Helping to conveniently industrialize front-end eyeballs
on: http://thefalken.livejournal.com



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 St 
James's Court Brown Street Manchester M2 2JF.  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 8008.

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

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

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


RE: Case Sensitivity

2007-10-04 Thread Andy Matthews
Dale...

The ColdFusion.navigate functionality is only case-sensitive because
Javascript is a case-sensitive language. So when CF creates javascript code,
it has to abide by the requirements of that language.

Cutter and I have disagreed about case before as well. His logic about case
being an issue when migrating between OS is sound in all but one way. If the
OS itself didn't implement case-sensitivity then code wouldn't have to
either.

I find no good reason that Andy.cfm should be different than andy.cfm. 


andy



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

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


Re: date format display

2007-10-04 Thread Paul Hastings
Orlini, Robert wrote:
 Thanks Paul. How is this incorporated into the dateformat function? I'm new 
 to this.

you can either build a real date object from date using createDate() or if 
you're simply going to display it:

#thisMonth#-#thisDay#-#thisYear# or whatever.

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

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


RE: date format display

2007-10-04 Thread Marius Milosav
cfoutput#dateformat(CreateDate (thisYear, thisMonth,
thisDay),-MM-DD)#/cfoutput

Marius 

-Original Message-
From: Orlini, Robert [mailto:[EMAIL PROTECTED] 
Sent: October 4, 2007 9:23 AM
To: CF-Talk
Subject: RE: date format display

Thanks Paul. How is this incorporated into the dateformat function? I'm new
to this.

-Original Message-
From: Paul Hastings [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 04, 2007 8:58 AM
To: CF-Talk
Subject: Re: date format display


Orlini, Robert wrote:
 I brought this up before, but I need a date (displayed for example as:
20071104) to be formatted to display 

and if you did you'll have been told to parse your date string.

thisYear=left(get.enddate,4);
thisMonth=mid(get.enddate,5,2);
thisDay=right(get.enddate,2);





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

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


RE: date format display

2007-10-04 Thread Orlini, Robert
Thanks.

Removing quotes however produced: 568521023.

Not nayhting near: 11-04-2007

-Original Message-
From: Marius Milosav [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 04, 2007 8:55 AM
To: CF-Talk
Subject: RE: date format display


Try removing the quotes around get.enddate
#dateformat(get.enddate,MMDD)#

Marius Milosav 
ScorpioSoft Corp.
www.scorpiosoft.com
It's not about technology, it's about people

-Original Message-
From: Orlini, Robert [mailto:[EMAIL PROTECTED] 
Sent: October 4, 2007 8:43 AM
To: CF-Talk
Subject: date format display

Hello,

I brought this up before, but I need a date (displayed for example as:
20071104) to be formatted to display 
as 11-04-2007. It is not a date/time field just a char field in SQL.
The name of the field is enddate.
Thanks as always.
Robert O.
I tried: #dateformat(get.enddate,MMDD)#, but get
Parameter validation error for function DATEFORMAT. 
The value of the parameter 1, which is currently get.enddate, must be a
class java.util.Date value. 

Tried formatting with CreateODBCDate, but get: {d '56852-10-23'}
or
DateFormat(CreateODBCDate(get.enddate),  d, ),  I get : October
23, 56852










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

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


Re: Voting System: Not allowing multiple votes

2007-10-04 Thread Greg Morphis
Make them log into your website.. one vote per login.
Other than that, I doubt you'd be able to always block a dupe voter..



On 10/4/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
 All,  We all know the scenario, we want to limit the amount of time a person 
 can vote or at least vote within a 24 hour timeline.   That's all fine and 
 dandy, but how can we prevent a user from clearing their cookies or closing 
 and restarting the browser to simply  come back and vote again with a 
 different name and email address.  Yes we could force the verify your email 
 address before you vote is counted, but what if we don't want to do that?  
 What's a developer to do?  Wouldn't it be great if we could read the MAC 
 address on their nic card.  Not sure how unique that would be, but it would 
 be great to be able to bypass the firewall ips and get something right from 
 the client to uniquely identify the user that the user can not delete or 
 remove.  Ok, so I'm sounding like Big brother.

 Thoughts?

 Thanks all.

 D-

 

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

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


Re: Case Sensitivity

2007-10-04 Thread Cutter (CFRelated)
Very good point, and one I've been caught on before. No, CF tag and 
function syntax is not case sensitive, so cfquery name=qry and 
CFQUERY NAME=qry are the same, as is createobject( and CreateObject(.

That being said, and as mentioned before, anything related to the file 
system will be. If you have a cfc at Com/myCo/Class, and have a 
component call as createobject(component,com.myco.class), it will 
break on *nix. I once had a small app I wrote on Windows, which had to 
be run on Linux, and had to spend four hours fixing all of my object 
calls. Lessons learned.

An older version of mySQL also required case sensitivity of table and 
column names, so SQL had to be carefully reviewed for case.

It makes sense to be 'case sensitive' when writing your code. You never 
know when business requirements might change, and a system is migrated 
to a different OS, a different DB, or what-have-you. I use lower case 
for all CF tags and attributes because that's the standard for XHTML, 
and writing my CF that way keeps me on track when writing display. I 
even close single tags when I can (cfset /) while leaving those alone 
that I can't (cfelse). I use camel case when writing function calls, 
or cfscript blocks, because that's the ECMA standard, and keeps me 
focused when writing JavaScript or ActionScript.

Conventions help you stay consistent. Guidelines keep everyone in a 
group writing consistent code. This assists in maintaining an 
application, as you might not be the one making changes to code you 
originally wrote.

Steve Cutter Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer
_
http://blog.cutterscrossing.com

Dale Fraser wrote:
 Beware,
 
 ColdFusion is becoming more case sensitive, so you should be careful.
 
 These new ColdFusion features (which are javascript) are case Sensitive.
 
 ColdFusion.Grid.refresh('gridName');
 
 For example. Im not sure but I think (due to file system stuff)
 
 cfset me = createObject(component, com.company.Class) /
 
 Might be case sensitive on *nix as the com.company.Class bits are file
 references.
 
 Regards
 Dale Fraser
 
 http://learncf.com
 
 
 -Original Message-
 From: J.J. Merrick [mailto:[EMAIL PROTECTED] 
 Sent: Thursday, 4 October 2007 8:53 PM
 To: CF-Talk
 Subject: Re: Case Sensitivity
 
 From what I have encountered most things are case insensitive. The
 only thing I would say is if you are working with *nix disk access is
 that directories and filenames are case-sensitive or if you are
 calling anything in Java that that is case-sensitive. The only reason
 to check case would be for readability and to be that anal about it is
 a tad overboard. As long as you aren't typing them in all-caps
 (::cough:: ::cough:: Ray ::cough::) You should be ok in my book :-)
 
 
 J.J.
 
 On 10/4/07, Tim Ashworth [EMAIL PROTECTED] wrote:
 Hi All,

 This is just a quickie, and really not too important.  However it will
 clear
 up an argument that I'm having with my rather conservative colleague.

 I was under the impression that coldfusion was entirely case insensitive
 regardless of if it is on a windows or linux OS.  So I'm quite happily
 writing everything in lower case and camel case, but my colleague is
 convinced that this is wrong.  Whilst I appreciate that it's a good idea
 to
 stick to a convention and not be too sloppy I have to confess I'm getting
 a
 bit fed up checking case when I'm sure it's not an issue.  I have done
 some
 tests and it all *seems* case insensitive, but I'd appreciate some back-up
 from a more experienced CF developer.

 Cheers

 Tim

 *hopes that he's right or he'll have to check the last app he wrote*



 
 
 
 

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

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


Voting System: Not allowing multiple votes

2007-10-04 Thread coldfusion . developer
All,  We all know the scenario, we want to limit the amount of time a person 
can vote or at least vote within a 24 hour timeline.   That's all fine and 
dandy, but how can we prevent a user from clearing their cookies or closing and 
restarting the browser to simply  come back and vote again with a different 
name and email address.  Yes we could force the verify your email address 
before you vote is counted, but what if we don't want to do that?  What's a 
developer to do?  Wouldn't it be great if we could read the MAC address on 
their nic card.  Not sure how unique that would be, but it would be great to be 
able to bypass the firewall ips and get something right from the client to 
uniquely identify the user that the user can not delete or remove.  Ok, so I'm 
sounding like Big brother. 

Thoughts?

Thanks all.

D-

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

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


RE: date format display

2007-10-04 Thread Marius Milosav
Try removing the quotes around get.enddate
#dateformat(get.enddate,MMDD)#

Marius Milosav 
ScorpioSoft Corp.
www.scorpiosoft.com
It's not about technology, it's about people

-Original Message-
From: Orlini, Robert [mailto:[EMAIL PROTECTED] 
Sent: October 4, 2007 8:43 AM
To: CF-Talk
Subject: date format display

Hello,

I brought this up before, but I need a date (displayed for example as:
20071104) to be formatted to display 
as 11-04-2007. It is not a date/time field just a char field in SQL.
The name of the field is enddate.
Thanks as always.
Robert O.
I tried: #dateformat(get.enddate,MMDD)#, but get
Parameter validation error for function DATEFORMAT. 
The value of the parameter 1, which is currently get.enddate, must be a
class java.util.Date value. 

Tried formatting with CreateODBCDate, but get: {d '56852-10-23'}
or
DateFormat(CreateODBCDate(get.enddate),  d, ),  I get : October
23, 56852








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

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


Re: date format display

2007-10-04 Thread Paul Hastings
Orlini, Robert wrote:
 I brought this up before, but I need a date (displayed for example as: 
 20071104) to be formatted to display 

and if you did you'll have been told to parse your date string.

thisYear=left(get.enddate,4);
thisMonth=mid(get.enddate,5,2);
thisDay=right(get.enddate,2);

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

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


RE: date format display

2007-10-04 Thread Paul Vernon
I seem to remember someone else responded that you need to drop your quotes
from the first example you gave last time you asked this.

#dateformat(get.enddate,MMDD)#

SHOULD BE:

#dateformat(get.enddate,MMDD)#

The difference being, get.enddate is a string and get.enddate is a date.

Paul




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

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


Re: CF and Xandros (Debian) Linux

2007-10-04 Thread Tom Chiverton
On Thursday 04 Oct 2007, [EMAIL PROTECTED] wrote:
 and he's anti-Microsoft. I think he's made his choice based on Xandros's
 claim of working better as a server on a network of Windows clients. He's

How can he claim that ?!? It's all just Samba...

-- 
Tom Chiverton
Helping to apprehensively entrench seamless eyeballs
on: http://thefalken.livejournal.com



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 St 
James's Court Brown Street Manchester M2 2JF.  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 8008.

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

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

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


RE: date format display

2007-10-04 Thread Orlini, Robert
Thanks Paul. How is this incorporated into the dateformat function? I'm new to 
this.

-Original Message-
From: Paul Hastings [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 04, 2007 8:58 AM
To: CF-Talk
Subject: Re: date format display


Orlini, Robert wrote:
 I brought this up before, but I need a date (displayed for example as: 
 20071104) to be formatted to display 

and if you did you'll have been told to parse your date string.

thisYear=left(get.enddate,4);
thisMonth=mid(get.enddate,5,2);
thisDay=right(get.enddate,2);



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

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


RE: date format display

2007-10-04 Thread Orlini, Robert
Thanks Marius.

OK. Works for year, month, but not day

I did this code to format the date: 20071104

CFSET thisYear=left(get.enddate,4)
CFSET thisMonth=mid(get.enddate,5,2)
CFSET thisDay=right(get.enddate,2)

I got

Year: 2007
Month: 11
Day: 

Works for Year and month, but does not display the day: 04

-Original Message-
From: Marius Milosav [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 04, 2007 9:31 AM
To: CF-Talk
Subject: RE: date format display


cfoutput#dateformat(CreateDate (thisYear, thisMonth,
thisDay),-MM-DD)#/cfoutput

Marius 

-Original Message-
From: Orlini, Robert [mailto:[EMAIL PROTECTED] 
Sent: October 4, 2007 9:23 AM
To: CF-Talk
Subject: RE: date format display

Thanks Paul. How is this incorporated into the dateformat function? I'm new
to this.

-Original Message-
From: Paul Hastings [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 04, 2007 8:58 AM
To: CF-Talk
Subject: Re: date format display


Orlini, Robert wrote:
 I brought this up before, but I need a date (displayed for example as:
20071104) to be formatted to display 

and if you did you'll have been told to parse your date string.

thisYear=left(get.enddate,4);
thisMonth=mid(get.enddate,5,2);
thisDay=right(get.enddate,2);







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

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


Re: Case Sensitivity

2007-10-04 Thread Tom Chiverton
On Thursday 04 Oct 2007, [EMAIL PROTECTED] wrote:
 I find no good reason that Andy.cfm should be different than andy.cfm.

Let introduce you to my friend, Mr A. Sci-Code :-)

-- 
Tom Chiverton
Helping to advantageously harness prospective materials
on: http://thefalken.livejournal.com



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 St 
James's Court Brown Street Manchester M2 2JF.  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 8008.

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

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

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


Re: Case Sensitivity

2007-10-04 Thread Kris Jones
Not sure about CF8, but previously, Application.cfm, OnRequestEnd.cfm
are also treated with case sensitivity. On a *nix system, CF wouldn't
find them (i.e., wouldn't treat them as it should) if they weren't
spelled with the case-sensitive name.

Again, on *nix, since java is case-sensitive, it's best to be careful
of your case when naming your cfc's too. Think this has to match the
object call type, including case.

Cheers,
Kris

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

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


Re: Voting System: Not allowing multiple votes

2007-10-04 Thread Tom Chiverton
On Thursday 04 Oct 2007, [EMAIL PROTECTED] wrote:
 Make them log into your website.. one vote per login.

Obvious work around, multiple accounts.

-- 
Tom Chiverton
Helping to assertively embrace global e-tailers
on: http://thefalken.livejournal.com



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 St 
James's Court Brown Street Manchester M2 2JF.  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 8008.

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

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

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


Re: Voting System: Not allowing multiple votes

2007-10-04 Thread Tero Pikala
 All,  We all know the scenario, we want to limit the amount of time a 
 person can vote or at least vote within a 24 hour timeline.   That's 

You could consider using mobile phone number (send SMS with code that is 
required to vote) or postal address (send letter that has instructions how to 
vote and code) to ensure little bit better than one person only votes once. 
Some countries have pretty good systems to identify identities online but that 
depends on your target market. 

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

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


RE: date format display

2007-10-04 Thread Orlini, Robert
All works now. Thanks Paul V., Paul H., and Marius!

I did:

CFSET thisYear=left(get.enddate,4)
CFSET thisMonth=mid(get.enddate,5,2)
CFSET thisDay=mid(get.enddate,8,2)

Contract will expire on: #thisMonth#/#thisday#/#thisYear#

Displays as: 11/4/2007 

-Original Message-
From: Paul Hastings [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 04, 2007 9:29 AM
To: CF-Talk
Subject: Re: date format display


Orlini, Robert wrote:
 Thanks Paul. How is this incorporated into the dateformat function? I'm new 
 to this.

you can either build a real date object from date using createDate() or if 
you're simply going to display it:

#thisMonth#-#thisDay#-#thisYear# or whatever.



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

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


Re: Odd cfqueryparam issue

2007-10-04 Thread Scott Weikert
Hey folks,

Still having this issue, and would like some more eyes on it, if 
possible. Below is my original post from earlier this week.

 I'm getting an odd error when using cfqueryparam. I've got the type 
 set to cf_sql_integer - the value I'm passing is an integer (even 
 throwing Int() into the mix - and yet, I'm getting the error:

 [Macromedia][SQLServer JDBC Driver]Value can not be converted to 
 requested type.

 However, when I remove the cfqueryparam and just throw in the raw 
 variable, i.e. var = #Int(myNumericVariable)#, it works fine.

 Throwing in some debugger code to check the variable being passed into 
 the script, the length is fine, it passes the IsNumeric() check, everything.

 It gets better!

 The same code (with the cfqueryparam call) on my development box works 
 fine. It's on my production box that it hiccups.

 On top of that, there's another query right after, that's very similar - 
 using a cfqueryparam set for integer, but using a different passed in 
 variable - and it works fine.

 Both boxes are running CF8 - though there are differences - dev box is 
 still running Win 2k server, and had CF upgraded - while the production 
 box is new, running fresh installs (no upgrades) of Win 2k3 server and CF8.


 

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

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


CF8, Flex, and Remoting over SSL

2007-10-04 Thread Rick Root
So I upgraded my server to CF8 this weekend, and of course once again,
all my flex remoting calls are going over http instead of https.

so I went into the remoting-config.xml (apparently this is where the
destination Coldfusion is now defined... and I changed the default
channel to my-cfamf-secure - a channel that is predefined in CF8's
services-config.xml file

I restarted the CF instances and recompiled my flex app... only now
the attempted remoting request goes to
https://advanceweb.ads.duke.edu/flex2gateway/cfamfsecure - as defined
in services-config.xml

This causes the following error:

Channel.Connect.Failed error NetConnection.Call.Failed: HTTP: Failed:
url: 'https://advanceweb.ads.duke.edu/flex2gateway/cfamfsecure'

The raw post (as seen by Fiddler2):

POST /flex2gateway/cfamfsecure HTTP/1.1
Accept: */*
Accept-Language: en-US
Referer: https://advanceweb.ads.duke.edu/Enquire/Enquire.swf
x-flash-version: 9,0,60,120
Content-Type: application/x-amf
Content-Length: 223
UA-CPU: x86
Accept-Encoding: gzip, deflate
User-Agent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET
CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.2)
Host: advanceweb.ads.duke.edu
Connection: Keep-Alive
Cache-Control: no-cache
Cookie: CFID=xxx; CFTOKEN=xxx; FLASHCOOKIE=xxx; JSESSIONID=xxx;
CFID=xxx; CFTOKEN=xxx; FLASHCOOKIE=xxx

The raw response from the server:

HTTP/1.1 200 OK
Date: Thu, 04 Oct 2007 14:17:55 GMT
Server: Microsoft-IIS/6.0
X-Powered-By: ASP.NET
Expires: Sat, 25 Dec 1999 00:00:00 GMT
Cache-Control: no-cache
Content-Type: application/x-amf
Content-Length: 331

There's no indication of an error - the response is status 200... but
the method I'm calling is never called.

In CF7, since I want *ALL* remoting requests to go over ssl, I just
modified the my-cfamf endpoint to use SSL, without changing the
default channel used or anything like that for the Coldfusion
destination.  I tried that in CF8 also with the broken results.

How do I get my Flex remoting to work over SSL?


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

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

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


Re: CF8 Problem with DB2 JDBC driver

2007-10-04 Thread Tom Chiverton
On Thursday 04 Oct 2007, [EMAIL PROTECTED] wrote:
 After the upgrade to CF8, we've found that Coldfusion seems to be
 sending multiple authentication attemps - as many as 9 - in the case
 of an invalid password.

Could this be connection pooling related ? Does turning that off help ?

-- 
Tom Chiverton
Helping to confidentially mesh strategic metrics
on: http://thefalken.livejournal.com



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 St 
James's Court Brown Street Manchester M2 2JF.  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 8008.

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

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

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


Re: Voting System: Not allowing multiple votes

2007-10-04 Thread Greg Morphis
True..  I don't believe you can then.. However you can make it such a
pain that would deter most people.
Force log in, unique to email, verify email, use CAPTCHA. Record IP, etc..
a combination of all those would deter a lot of people.


On 10/4/07, Tom Chiverton [EMAIL PROTECTED] wrote:
 On Thursday 04 Oct 2007, [EMAIL PROTECTED] wrote:
  Make them log into your website.. one vote per login.

 Obvious work around, multiple accounts.

 --
 Tom Chiverton
 Helping to assertively embrace global e-tailers
 on: http://thefalken.livejournal.com

 

 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 
 St James's Court Brown Street Manchester M2 2JF.  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 8008.

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

 

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

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


Re: CF 8 Load Time Problem

2007-10-04 Thread Tom Chiverton
On Thursday 04 Oct 2007, [EMAIL PROTECTED] wrote:
 We are still having a huge problem with createObject calls in
 ColdFusion 8 taking up to 300 seconds.  Please help!  Below is a stack
 trace from Fusion Reactor.

What are you creating ? What does the object do at startup ?

-- 
Tom Chiverton
Helping to synergistically orchestrate turn-key communities
on: http://thefalken.livejournal.com



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 St 
James's Court Brown Street Manchester M2 2JF.  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 8008.

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

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

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


CF8 Problem with DB2 JDBC driver

2007-10-04 Thread Rick Root
So another weird little issue with the CF8 upgrade.

We authenticate our users to the mainframe like this:

cflog log=APPLICATION text=[authByUsername] Authorization attempt
for #UNAME# from #CGI.REMOTE_ADDR#
cfquery name=auth datasource=DB2Logins username=#UNAME#
password=#PWORD#
SELECT 1 FROM SYSIBM.SYSDUMMY1
/cfquery
cflog log=APPLICATION text=[authByUsername] Authorization success
for #UNAME#

Note the logging before and after the query.

After the upgrade to CF8, we've found that Coldfusion seems to be
sending multiple authentication attemps - as many as 9 - in the case
of an invalid password.

This causes users to get revoked after a single authentication attempt - BAD!

I'm probably going to call Adobe about this one unless someone can
suggest why a single query request (above) would cause the JDBC driver
to attempt to authenticate 9 times.


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

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

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


Re: CF 8 Load Time Problem

2007-10-04 Thread Ryan Duckworth
Thank you for your recommendations.

We do have Save Class Files turned on for our productions servers.

We are still having a huge problem with createObject calls in
ColdFusion 8 taking up to 300 seconds.  Please help!  Below is a stack
trace from Fusion Reactor.

customerImport2.cfm:13 is a createObject CFC call.


Thread Stack Trace
Trace Time:   10:32:50.156 03-Oct-2007
Request ID:   8190
Script Name:  http://intranet.uhlig.com/lp_company/import/customerImport2.cfm
Started:  10:28:36.850 03-Oct-2007
Exec Time:253306ms
Memory Used:  (30%)304,194KB
Memory Free:  705,597KB
Thread ID:0x5dfd (24061)
Thread Name:  jrpp-69
Priority: 5
Hashcode: 11926779
State:RUNNABLE

jrpp-69 prio=5 runnable

java.lang.Class.getDeclaredConstructors0(Class.java:???)[Native Method]
java.lang.Class.privateGetDeclaredConstructors(Class.java:2389)
java.lang.Class.getConstructor0(Class.java:2699)
java.lang.Class.newInstance0(Class.java:326)
java.lang.Class.newInstance(Class.java:308)
coldfusion.runtime.TemplateClassLoader.newInstance(TemplateClassLoader.java:444)
coldfusion.runtime.TemplateClassLoader.newInstance(TemplateClassLoader.java:415)
coldfusion.runtime.TemplateProxyFactory.getCFCInstance(TemplateProxyFactory.java:240)
coldfusion.runtime.TemplateProxyFactory.resolveName(TemplateProxyFactory.java:166)
coldfusion.runtime.TemplateProxyFactory.resolveName(TemplateProxyFactory.java:157)
coldfusion.runtime.TemplateProxyFactory.resolveName(TemplateProxyFactory.java:1292)
coldfusion.cfc.ComponentProxyFactory.getProxy(ComponentProxyFactory.java:28)
coldfusion.runtime.ProxyFactory.getProxy(ProxyFactory.java:65)
coldfusion.runtime.CFPage.createObjectProxy(CFPage.java:4688)
coldfusion.runtime.CFPage.CreateObject(CFPage.java:4533)
cfcustomerImport22ecfm987450325._factor0(G:\www\intranet.uhlig.com\lp_company\import\customerImport2.cfm:13)
cfcustomerImport22ecfm987450325._factor58(G:\www\intranet.uhlig.com\lp_company\import\customerImport2.cfm:4)
cfcustomerImport22ecfm987450325.runPage(G:\www\intranet.uhlig.com\lp_company\import\customerImport2.cfm:1)
coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192)
coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366)
coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:2644)
cfApplication2ecfc1091553182$funcONREQUEST.runFunction(G:\www\intranet.uhlig.com\Application.cfc:28)
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418)
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360)
coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324)
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56)
coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277)
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192)
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448)
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308)
coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:74)
coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:243)
coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:269)
coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
coldfusion.CfmServlet.service(CfmServlet.java:175)
coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
com.intergral.fusionreactor.filter.FusionReactorFilter.B(null:???)
com.intergral.fusionreactor.filter.FusionReactorFilter.A(null:???)
com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(null:???)
jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
jrun.servlet.FilterChain.service(FilterChain.java:101)
jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:284)
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)

Re: CF8, Flex, and Remoting over SSL

2007-10-04 Thread Tom Chiverton
On Thursday 04 Oct 2007, [EMAIL PROTECTED] wrote:
 Content-Length: 331

What the content here say ?

-- 
Tom Chiverton
Helping to interactively syndicate sticky meta-services
on: http://thefalken.livejournal.com



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 St 
James's Court Brown Street Manchester M2 2JF.  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 8008.

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

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

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


Flash forms not doing anything.

2007-10-04 Thread Ian Skinner
I have the simplest test of a flash form and nothing is happening.  I 
mean nothing, no errors displayed or logged, no output to the browser, 
nothing.

body
Start
cfform name=foo action=form_test.cfm format=flash
  cfinput type=text name=bar/
/cfform
End
/body


The output in the browser:

!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN 
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd;
html xmlns=http://www.w3.org/1999/xhtml;
head
meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /
titleFlash Form Test/title
script type=text/javascript src=/cfide/scripts/cfform.js/script
script type=text/javascript src=/cfide/scripts/masks.js/script
/head

body
Start

End
/body
 
/html


I've checked everything I can think to check.  Any advice most appreciated I 
just don't know where to even start here.

Ian

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

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


Re: Voting System: Not allowing multiple votes

2007-10-04 Thread Tom Chiverton
On Thursday 04 Oct 2007, [EMAIL PROTECTED] wrote:
 once. Some countries have pretty good systems to identify identities online
 but that depends on your target market.

The trouble with that is you can no longer be sure the person placing the vote 
isn't being coerced.

-- 
Tom Chiverton
Helping to augmentatively engage efficient models
on: http://thefalken.livejournal.com



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 St 
James's Court Brown Street Manchester M2 2JF.  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 8008.

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

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

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


Re: CF8, Flex, and Remoting over SSL

2007-10-04 Thread Rick Root
On 10/4/07, Tom Chiverton [EMAIL PROTECTED] wrote:
 On Thursday 04 Oct 2007, [EMAIL PROTECTED] wrote:
  Content-Length: 331

 What the content here say ?

Fiddler doesn't decode AMF content...  When I highlight the hex
content, it says the length is 331... so that must be it :)

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

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

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


Re: CF8 Problem with DB2 JDBC driver

2007-10-04 Thread Rick Root
I have the log file from DB2 as well...

08:44:36.07 USER(myusername  ) GROUP(ADUADS  ) NAME(ROOT, RICK  ) 149
LOGON/JOB INITIATION - INVALID PASSWORD
08:44:37.10 USER(myusername  ) GROUP(ADUADS  ) NAME(ROOT, RICK  ) 152
LOGON/JOB INITIATION - INVALID PASSWORD
08:44:38.13 USER(myusername  ) GROUP(ADUADS  ) NAME(ROOT, RICK  ) 155
LOGON/JOB INITIATION - INVALID PASSWORD
08:44:39.17 USER(myusername  ) GROUP(ADUADS  ) NAME(ROOT, RICK  ) 158
LOGON/JOB INITIATION - INVALID PASSWORD
08:44:40.20 USER(myusername  ) GROUP(ADUADS  ) NAME(ROOT, RICK  ) 162
LOGON/JOB INITIATION - EXCESSIVE PASSWORDS OR INACTIVE USER
08:44:41.21 USER(myusername  ) GROUP(ADUADS  ) NAME(ROOT, RICK  ) 164
LOGON/JOB INITIATION - REVOKED USER ACCESS ATTEMPT
08:45:08.41 USER(myusername  ) GROUP(ADUADS  ) NAME(ROOT, RICK  ) 168
LOGON/JOB INITIATION - REVOKED USER ACCESS ATTEMPT
08:45:09.42 USER(myusername  ) GROUP(ADUADS  ) NAME(ROOT, RICK  ) 170
LOGON/JOB INITIATION - REVOKED USER ACCESS ATTEMPT
08:45:10.43 USER(myusername  ) GROUP(ADUADS  ) NAME(ROOT, RICK  ) 172
LOGON/JOB INITIATION - REVOKED USER ACCESS ATTEMPT
08:45:11.44 USER(myusername  ) GROUP(ADUADS  ) NAME(ROOT, RICK  ) 174
LOGON/JOB INITIATION - REVOKED USER ACCESS ATTEMPT
08:45:13.79 USER(myusername  ) GROUP(ADUADS  ) NAME(ROOT, RICK  ) 176
LOGON/JOB INITIATION - REVOKED USER ACCESS ATTEMPT
08:45:14.80 USER(myusername  ) GROUP(ADUADS  ) NAME(ROOT, RICK  ) 178
LOGON/JOB INITIATION - REVOKED USER ACCESS ATTEMPT

This log actually represents TWO authentication attempts, each one
resulting in 6 authorization requests to RACF.  The first 6
authorization attempts occurred in about 5 seconds..same with the
second set of 6 attempts.

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

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

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


CFReportParam question

2007-10-04 Thread Christopher Jordan
Has anyone here successfully passed a query object into the report builder
via the cfreportparam tag?

I've got the following code snippet:

cfreport name=myReport format=PDF template=#reporttemplate#
query=#ReportData#
cfreportparam name=advisor value=#advisor.Description#
cfreportparam name=AdvisorAddressLine1
value=#advisor.AddressLine1#
cfreportparam name=AdvisorAddressLine2
value=#advisor.AddressLine2#
cfreportparam name=AdvisorAddressLine3
value=#advisor.AddressLine3#
cfreportparam name=FullName value=#personalData.FirstName#
#personalData.LastName#
cfreportparam name=AccountType
value=#personalData.AccountTypeDescription#
cfreportparam name=AccountNumber
value=#personalData.AccountNumber#
cfreportparam name=CompanyName value=#personalData.CompanyName#
cfreportparam name=PortfolioAddressLine1
value=#personalData.AddressLine1#
cfreportparam name=CityStateZip value=#personalData.City#,
#personalData.State# #personalData.ZipCode#
cfreportparam name=AssetClassTotals value=#AssetClassStruct#
cfreportparam name=PortfolioCashInvested
value=#PortfolioCashInvested#
cfreportparam name=PortfolioCostBasis value=#PortfolioCostBasis#
cfreportparam name=PortfolioCurrentValue
value=#PortfolioCurrentValue#
cfreportparam name=PortfolioPercentDollarGain
value=#PortfolioPercentDollarGain#
cfif form.SelectedReport eq 2
cfreportparam chart=AssetAllocation query=#AssetAllocation#
/cfif
/cfreport

I've gotten this much from the online documentation, however I don't know
what to do inside the report builder to complete this process. I run the
chart control wizard several times, and it seems that you either have to
specify all the labels and values upfront, or you can build a query from
within the report builder.

My problem is that my query is hand built using the QueryNew(),
QueryAddRow() and QuerySetCell() functions. The data contained in this query
object doesn't exist in the database, but rather has to be calculated on the
fly. So each time a report is run, my calling CFM page makes these
calculations, and stores them in this query object. I'm storing them in a
query object specifically for charting purposes.

I've been fiddling with this for a couple of days now, and I'm just not
getting anywhere. I'd really appreciate any help I could get.

Thanks heaps,
Chris

-- 
http://cjordan.us


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

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


Re: Voting System: Not allowing multiple votes

2007-10-04 Thread Tom Chiverton
On Thursday 04 Oct 2007, [EMAIL PROTECTED] wrote:
 a combination of all those would deter a lot of people.

As I said, look at your threat profile.
If you are intending to run (say) a nation wide election for prime minister, 
none of the above is good enough because your attacker is likely to be well 
funded.

-- 
Tom Chiverton
Helping to revolutionarily develop high-end convergence
on: http://thefalken.livejournal.com



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 St 
James's Court Brown Street Manchester M2 2JF.  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 8008.

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

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

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


Case Sensitivity

2007-10-04 Thread Tim Ashworth
Oh well, guess the consensus is not on my side.  Oh well.  *mopes off to
check app*


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

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


Re: CF8 Problem with DB2 JDBC driver

2007-10-04 Thread Rick Root
On 10/4/07, Tom Chiverton [EMAIL PROTECTED] wrote:
 On Thursday 04 Oct 2007, [EMAIL PROTECTED] wrote:
  After the upgrade to CF8, we've found that Coldfusion seems to be
  sending multiple authentication attemps - as many as 9 - in the case
  of an invalid password.

 Could this be connection pooling related ? Does turning that off help ?

Where do I disable that?

For the record, I have a third party DB2 JDBC Driver (StarSQL) that we
use for changing passwords via JDBC, since the DataDirect drivers
don't support that.  This issue does NOT occur with *THAT* jdbc
driver, but we don't have the licenses to use that on all our servers.

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

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

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


Re: CF8, Flex, and Remoting over SSL

2007-10-04 Thread Tom Chiverton
On Thursday 04 Oct 2007, [EMAIL PROTECTED] wrote:
 On 10/4/07, Tom Chiverton [EMAIL PROTECTED] wrote:
  On Thursday 04 Oct 2007, [EMAIL PROTECTED] wrote:
   Content-Length: 331
 
  What the content here say ?

 Fiddler doesn't decode AMF content...  When I highlight the hex
 content, it says the length is 331... so that must be it :)

If you set the logging in services-config.xml to level=Debug does the CF log 
indicate it sent stuff back ?

-- 
Tom Chiverton
Helping to simultaneously restore plug-and-play ROI
on: http://thefalken.livejournal.com



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 St 
James's Court Brown Street Manchester M2 2JF.  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 8008.

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

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

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


Best Instant Messanger to Use With CF 8

2007-10-04 Thread Eron Cohen
Can anyone recommend the best free instant messenger server to use with 
ColdFusion's Instant Messaging Event Gateway?  

Thank you 

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

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


Re: CFReportParam question

2007-10-04 Thread Kris Jones
I've used the query attribute of the cfreport tag without issue. I
have not used the cfreportparam tag to pass in a query. In the report
builder, this query should show-up in your objects pallette per
normal.

Cheers,
Kris

 Has anyone here successfully passed a query object into the report builder
 via the cfreportparam tag?
..
 I've gotten this much from the online documentation, however I don't know
 what to do inside the report builder to complete this process. I run the
 chart control wizard several times, and it seems that you either have to
 specify all the labels and values upfront, or you can build a query from
 within the report builder.

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

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


CF8/IIS6 issues

2007-10-04 Thread todd sharp
I moved my blog to my VPS last night - the VPS account is Windows 
2003/IIS6/CF8.  I added a new site in IIS, removed and reran all connectors and 
I'm still getting nothing but a blank page for all .cfm pages under this site.  
There is a cflocation at the root (http://cfsilence.com) that works - it will 
forward you to http://cfsilence.com/blog/client.  But nothing shows up.  Any 
help will be massively appreciated. 

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

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


Re: CF8 Problem with DB2 JDBC driver

2007-10-04 Thread Tom Chiverton
On Thursday 04 Oct 2007, [EMAIL PROTECTED] wrote:
 Where do I disable that?

Settings for the DSN in CF admin.

-- 
Tom Chiverton
Helping to carefully cultivate cross-platform content
on: http://thefalken.livejournal.com



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 St 
James's Court Brown Street Manchester M2 2JF.  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 8008.

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

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

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


Re: MS SQL Triggers and Coldfusion 8

2007-10-04 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Thanks, Ben!  

For some reason the hotfix isn't resolving the issue for me, which is weird.  
But the AlwaysReportTriggerResults=true trick works fine, so I'll just use that.

Thanks for your help!
Jim Sullivan


 Hey Jim,
 
 that issue was fixed with the latest hotfix.

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

 It's not listed in the notes, but I was the one who reported the bug 
 and received an email back stating it was an official bug and that it 
 would be fixed in the first hotfix.

 There is also a workaround to add the argument: 
 AlwaysReportTriggerResults=true to your neo-datasource.xml file for 
 that particular datasource. Or you can select Other as the driver 
 type and enter in the jdbc driver manually as below:

jdbc:macromedia:sqlse 
rver://dbdev01:1433;databaseName=awayx;AlwaysReportTriggerResults=true

 Ben


 - Original Message 
 From: [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED]
 To: CF-Talk cf-talk@houseoffusion.com
 Sent: Wednesday, October 3, 2007 3:48:18 PM
 Subject: MS SQL Triggers and Coldfusion 8

 Hi all.  We're in the process of switching over from CF7 to CF8.  We 
 have a query that updates a row in a MS SQL database, which then 
 causes a trigger to return a date value to Coldfusion.  It worked in 7 
 but it doesn't seem to be working in 8.  Coldfusion 8 is telling me 
 that the query is undefined while that is not the case with the same 
 query in Coldfusion 7.

 I searched the docs and release notes and the web, and the only clue I 
 can find are the last few comments under this Ben Forta blog post:
 http://www.forta.com/blog/index.
 cfm/2007/7/6/ColdFusion-8-Can-Return-Identity-Values
 It seems that other people are having the same problem.  

 So does anyone know if MS SQL triggers that return values officially 
 don't work with Coldfusion 8?

 Thanks,
 Jim Sullivan 



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

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


Re: CF8 Problem with DB2 JDBC driver

2007-10-04 Thread Rick Root
On 10/4/07, Tom Chiverton [EMAIL PROTECTED] wrote:
 On Thursday 04 Oct 2007, [EMAIL PROTECTED] wrote:
  Where do I disable that?

 Settings for the DSN in CF admin.

the reason I asked the question is because I looked there, and there
is no mention of connection pooling on the page titled Data 
Services  Datasources  DB2 Universal Database 

the only time the letters pool appear on that page is Max Pooled Statements

Could you be more specific?

There's no mention of connection pooling on any of my DSNs - for DB2
or for SQL Server.

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

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

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


Re: CF8/IIS6 issues

2007-10-04 Thread todd sharp
I should also mention that i have another site running just fine on the same 
setup (http://cfsnippets.org) 

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

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


SOT: Rollback db changes in CFCUnit/CFUnit tests

2007-10-04 Thread Janet MacKay
Does anyone know of an article(s) explaining how to work rollbacks into unit 
testing? I want to test a series of DAO's, but am not sure how to incorporate 
this into my tests. 

Janet


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

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


RE: Odd cfqueryparam issue

2007-10-04 Thread Bobby Hartsfield
Are you sure that's the line where the error is happening... CF likes to
BOLD a line in queries when a DB error occurs but it's hardly ever that line
that is the problem. Let's see the whole query.

..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com


-Original Message-
From: Scott Weikert [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 04, 2007 10:33 AM
To: CF-Talk
Subject: Re: Odd cfqueryparam issue

Hey folks,

Still having this issue, and would like some more eyes on it, if possible.
Below is my original post from earlier this week.

 I'm getting an odd error when using cfqueryparam. I've got the type 
 set to cf_sql_integer - the value I'm passing is an integer (even 
 throwing Int() into the mix - and yet, I'm getting the error:

 [Macromedia][SQLServer JDBC Driver]Value can not be converted to 
 requested type.

 However, when I remove the cfqueryparam and just throw in the raw 
 variable, i.e. var = #Int(myNumericVariable)#, it works fine.

 Throwing in some debugger code to check the variable being passed into 
 the script, the length is fine, it passes the IsNumeric() check,
everything.

 It gets better!

 The same code (with the cfqueryparam call) on my development box works 
 fine. It's on my production box that it hiccups.

 On top of that, there's another query right after, that's very similar 
 - using a cfqueryparam set for integer, but using a different passed 
 in variable - and it works fine.

 Both boxes are running CF8 - though there are differences - dev box is 
 still running Win 2k server, and had CF upgraded - while the 
 production box is new, running fresh installs (no upgrades) of Win 2k3
server and CF8.


 



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

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


Re: Case Sensitivity

2007-10-04 Thread Jochem van Dieten
Andy Matthews wrote:
 Cutter and I have disagreed about case before as well. His logic about case
 being an issue when migrating between OS is sound in all but one way. If the
 OS itself didn't implement case-sensitivity then code wouldn't have to
 either.

You are getting this the wrong way around. Everything is inherently case 
sensitive because the bit sequence for an a is inherently different 
from the bit sequence for an A. Case insensitivity is implemented on 
top of case sensitivity by defining extra rules that allow a string 
comparison between a and A to sometimes say they are the same.

The price you pay for that is that those extra rules are only valid in a 
certain context, a collation. This collation depends on for instance the 
language and the country. For example, the capital STRASSE in Germany 
has a lowercase Straße, while in Switzerland it is Strasse. And even in 
English the meaning of words can change depending on the case, i.e. SPAM 
is something else then spam.

Jochem

PS This list drops the charset headers so to properly see the example 
make sure you view this message in UTF-8.

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

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


RE: Case Sensitivity

2007-10-04 Thread Andy Matthews
No no. I understand that they ARE different in the underlying ascii code.
But the point is, it simply presents confusion to people when a file name
can be spelled the exact same, but be two unique files. 

I had a discussion about programming with a co-worker this morning. We
decided that much of the programming behaviour for early languages (C, C++,
Java, etc) was based originally on hardware limitations. So, it could be
that the original UNIX systems HAD to force the differences, and so the code
was forced to be case sensitive.

Anyway, I find no use for case-sensitivity. It's only redeeming quality is
that it forces programmers to be consistent in the way their code is
written.

:)

-Original Message-
From: Tom Chiverton [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 04, 2007 9:08 AM
To: CF-Talk
Subject: Re: Case Sensitivity

On Thursday 04 Oct 2007, [EMAIL PROTECTED] wrote:
 I find no good reason that Andy.cfm should be different than andy.cfm.

Let introduce you to my friend, Mr A. Sci-Code :-)

--
Tom Chiverton
Helping to advantageously harness prospective materials
on: http://thefalken.livejournal.com



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
St James's Court Brown Street Manchester M2 2JF.  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 8008.

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



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

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


Re: CFReportParam question

2007-10-04 Thread Christopher Jordan
Thanks Kris,

I'm using the query attribute of the cfreport tag without problems too, but
the query attribute of the cfreportparam tag doesn't seem to be working, or
isn't working the way I'd expect it to. What do you mean by show-up in your
objects pallet? Are you talking about the Fields and Parameters section
or something entirely different?

If nobody here knows about passing a query into a chart specifically using
cfreportparam, is there a better place for me to post the question?

Chris

On 10/4/07, Kris Jones [EMAIL PROTECTED] wrote:

 I've used the query attribute of the cfreport tag without issue. I
 have not used the cfreportparam tag to pass in a query. In the report
 builder, this query should show-up in your objects pallette per
 normal.

 Cheers,
 Kris

  Has anyone here successfully passed a query object into the report
 builder
  via the cfreportparam tag?
 ..
  I've gotten this much from the online documentation, however I don't
 know
  what to do inside the report builder to complete this process. I run the
  chart control wizard several times, and it seems that you either have to
  specify all the labels and values upfront, or you can build a query from
  within the report builder.

 

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

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


Re: CF8/IIS6 issues

2007-10-04 Thread C. Hatton Humphrey
 I moved my blog to my VPS last night - the VPS account is Windows 
 2003/IIS6/CF8.
 I added a new site in IIS, removed and reran all connectors and I'm still 
 getting nothing
 but a blank page for all .cfm pages under this site.  There is a cflocation 
 at the root
 (http://cfsilence.com) that works - it will forward you to 
 http://cfsilence.com/blog/client.
 But nothing shows up.  Any help will be massively appreciated.

Looks to me like CF *is* parsing the files but there's something not
right on the code.  The CFLocation worked and I tried
http://cfsilence.com/blog/client/thisshouldcreateanexception.cfm just
to see what kind of 404 I got.  I got the standard CF 404.

Hatton

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

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


RE: Rollback db changes in CFCUnit/CFUnit tests

2007-10-04 Thread Rich
 Does anyone know of an article(s) explaining how to work rollbacks into
 unit testing? I want to test a series of DAO's, but am not sure how to
 incorporate this into my tests.
 
 Janet
 

You can incorporate a tool like DBUnit into your workflow
(http://dbunit.sourceforge.net/).

HTH,
Rich Kroll


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

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


Re: CFReportParam question

2007-10-04 Thread Kris Jones
Yes, I mean the Fields and Parameters section, under the Query Fields item.

I don't believe that query is legal parameter of cfreportparam
tag--only of the cfreport tag. From the livedocs, only name and
value are legal attributes of the cfreportparam tag.

I have not been successful passing multiple queries into a report. I'd
love to be able to, and if anyone knows how this can be done, please
enlighten me.

Cheers,
Kris

 I'm using the query attribute of the cfreport tag without problems too, but
 the query attribute of the cfreportparam tag doesn't seem to be working, or
 isn't working the way I'd expect it to. What do you mean by show-up in your
 objects pallet? Are you talking about the Fields and Parameters section
 or something entirely different?

 If nobody here knows about passing a query into a chart specifically using
 cfreportparam, is there a better place for me to post the question?

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

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


Re: Rollback db changes in CFCUnit/CFUnit tests

2007-10-04 Thread Janet MacKay
You can incorporate a tool like DBUnit into your workflow
(http://dbunit.sourceforge.net/).

HTH,
Rich Kroll

Thanks. I'm new to unit testing in general, so sorry if this is a dumb question 
:) .. I think I understand the concept of DBUnit, but I can't visualize where 
it fits into picture. Are DBUnit tests something separate, written in java, or 
do they somehow tie into my CFUnit/CFCUnit tests? Can you give me a high-level 
description of how it hooks into the process?  

Janet



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

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


Re: ajaxonload() problem

2007-10-04 Thread Brian Kotek
Instead of binding the grid to a CFC directly, use the cfajaxproxy. Bind the
grid to a JavaScript function, and set the grid's bindOnLoad attribute to
true so it runs that JavaScript function when the Grid loads the first time.
Then, in your JavaScript function, make a call to the CFC proxy and set up a
callback handler. When the CFC returns the data, it will run the callback
handler function. In the callback function, you can do whatever you want
(look at the grid, look at the data that came back from the CFC, etc.) and
render your count total. Full details on using cfajaxproxy can be found in
the documentation.

On 10/4/07, Azadi Saryev [EMAIL PROTECTED] wrote:

 Thanks for your reply, Dale!

 yes, my cfgrid is bound to a cfc  and you say it won't work then?...
 hmm... there must be a way

 if i understand you correctly:
 ajax UI stuff is loaded and rendered first, and then any data is loaded
 into ajax controls;
 and ajaxonload() fires inbetween the two?

 it does make sense

 so is there any way i can make my showTtlrows js function rnu AFTER the
 data is loaded into my cfgrid?
 can i somehow listen to a loadData or some similar event in the
 cfgrid? is there such an event?

 or is having my cfc.function write query.recordcount to a session var
 and then outputting that on calling page the only way to return 'total
 number of matches found' data?
 any other ideas?

 as for wrong count: you are wrong there.  calling my js function from a
 button click returns correct totalrecords, not per grid page, but total
 underlying query.recordcount
 if you look at JSON data returned by queryConvertForGrid() function, it
 includes TOTALROWCOUNT element which is query.recordcount

 thanks for your help on this - really appreciate it.

 Azadi


 Dale Fraser wrote:
  If you grid is using a binding, it will not work.
 
  As the Ajax and grid have loaded but the call to get the data hasn't
  occurred yet. Since binded data is paged, it would return the wrong
 count
  anyway.
 
  If your grid is not using binding, then im not sure.
 
  Regards
  Dale Fraser
 
  http://learncf.com
 
  -Original Message-
  From: Azadi Saryev [mailto:[EMAIL PROTECTED]
  Sent: Thursday, 4 October 2007 1:29 PM
  To: CF-Talk
  Subject: ajaxonload() problem
 
  my second attempt at getting some help here...
 
  i am trying to use a cfset ajaxonload(showTtlrows) at the bottom of
  my page to call a js function which gets total number of records from a
  cfgrid (see js code below; yes, the function in itself is correct and
  works).
  my cfgrid is bound to a cfc and works fine.  the js function is correct
  and works, too - if i call my js function from an onclick event of a
  button, it works just fine and returns correct number of records from my
  cfgrid.
 
  the ajaxonload() call, however, does not work - it fires after the
  cfgrid is drawn on the page but BEFORE it is populated with data: the
  alert(totalrecords); pops up an alert over an empty cfgrid shell - only
  the header and footer of the cfgrid are there, nothing else (no empty
  rows, no data).
 
  i am far from an ajax pro, and maybe i am misunderstanding thsomething,
  but i was under the impression that ajaxonload() fires after all ajax UI
  elements on the page have fully loaded am i wrong?
  how can i make the ajaxonload() call run AFTER my cfgrid is populated
  with data?
 
  thanks for any help!
 
  my js function:
 
  showTtlrows = function(){
  var mygrid = ColdFusion.Grid.getGridObject('resultsGrid');
  var mygridData = mygrid.getDataSource();
  var ttlrecords = mygridData.getTotalCount();
  //var ttlrecords = mygridData.totalLength;
  alert(ttlrecords);
  //document.getElementById('ttlrows').innerHTML = ttlrecords;
  }
 
 

 --

 Azadi Saryev
 Sabai-dee.com
 http://www.sabai-dee.com


 

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

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


Re: Voting System: Not allowing multiple votes

2007-10-04 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
What I ended up doing is using cookies and storing the email in a table.
We decided to use email verification and allow multiple votes but only one vote 
each day. So we can control the amount of votes by a single user each day
and fake, made up emails still have to verified via email. If an email isn't 
verified, then the vote won't be counted.

Thanks everyone for your feedback.  What a great group!

D

 The trouble with that is you can no longer be sure the person placing 
 the vote 
 isn't being coerced.
 
 -- 
 Tom Chiverton
 Helping to augmentatively engage efficient models
 on: http://thefalken.livejournal.com
 


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

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


How to re-install Verity for CF8

2007-10-04 Thread Rick Root
Starting a new thread for this so maybe I'll get an answer.

With Coldfusion 7, there was a place on the web site you could
download an installer that could be used for re-installing Verity.

Well, my verity is messed up and I'd like to reinstall it... but can't
find a Verity installer on Adobe's web site for CF8, and that's where
I got my installer from (since I got my licenses via subscription
upgrade online, I don't have a coldfusion 8 DVD)

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

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

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


Expiration Settings of Client Variables

2007-10-04 Thread Alex Ismail
We are in need to expire client variables at the same rate as session 
variables. In our case this is 2 hours.

Unfortunately, our client variables expire randomly well before 2 hours are 
passed.
What are correct settings to achieve this?

Our configuration:
- Client variables are stored in their own separate database.
- The checkbox 'Purge data for clients that remain unvisited for 0 days' is 
checked and days is set to 0.
- The checkbox 'Disable global client variable updates' is not checked.
- The 'Purge Interval' is set to 2 hours and 0 minutes.

Thank you,

Alex Ismail 


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

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


cfmail stuck in spool

2007-10-04 Thread Tim Do
Anybody know why this happens every once in a while?  Using cfmx 7.01
and exchange.  Last couple weeks I've noticed that mail stops going out
and just sits in the spool folder.  Once I restart cf services they all
go out at once.  Been happening more often lately so I'm getting a
little worried.

 

Thanks,

Tim



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

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


RE: Rollback db changes in CFCUnit/CFUnit tests

2007-10-04 Thread Rich
 Thanks. I'm new to unit testing in general, so sorry if this is a dumb
 question :) .. I think I understand the concept of DBUnit, but I can't
 visualize where it fits into picture. Are DBUnit tests something separate,
 written in java, or do they somehow tie into my CFUnit/CFCUnit tests? Can
 you give me a high-level description of how it hooks into the process?
 
 Janet


-- disclaimer --
I am not a DBUnit expert, and am only using a small portion of its features!
-- end disclaimer --

With that said...I will give you an overview of how I am using DBUnit.  

Step 1:
I start by seeding my database.  Once that is done I use DBUnit to export a
snapshot of the database.

Step 2:
Proceed to develop new features, bug fixes, etc.  

Step 3:
When development is complete and prior to running my unit tests, I use
DBUnit to reset the db back to a last known good state to remove any data
that was inserted during development.

Step 4:
I run my unit tests that test functionality with limited / no data and let
my unit tests populate the db.  This allows for testing of how the system
performs with and without expected data. 

Step 5:
I run a cleanup script that includes a DBUnit reset.

Step 6:
goto step 2 and repeat.


HTH,

Rich Kroll


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

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


Re: CF 8 Load Time Problem

2007-10-04 Thread Ryan Duckworth
We may have found a problem... We create a bunch of functions and put
them in the request scope.  On that page, just before the createObject
calls was a call to one of those functions in the request scope but is
was missing the request scope.


Correctly Scoped Call:
request.param(form.action,);

Incorrectly Scoped Call:
param(form.action,);



Example request function:
cffunction name=param output=false returnType=void
cfargument name=name type=string required=yes
cfargument name=default type=any required=no
cfif isdefined(arguments.default)
cfparam name=#arguments.name# default=#arguments.default#
cfelse
cfparam name=#arguments.name#
/cfif
/cffunction


cfscript
request.param = param;
/cfscript



We were not getting an error because we were using the onRequet
instead of onRequestStart and onRequestEnd in the Application.cfc


Thanks,
Ryan


On 10/4/07, Tom Chiverton [EMAIL PROTECTED] wrote:
 On Thursday 04 Oct 2007, [EMAIL PROTECTED] wrote:
  We are still having a huge problem with createObject calls in
  ColdFusion 8 taking up to 300 seconds.  Please help!  Below is a stack
  trace from Fusion Reactor.

 What are you creating ? What does the object do at startup ?

 --
 Tom Chiverton
 Helping to synergistically orchestrate turn-key communities
 on: http://thefalken.livejournal.com

 

 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 
 St James's Court Brown Street Manchester M2 2JF.  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 8008.

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

 

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

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


RE: Case Sensitivity

2007-10-04 Thread Billy Cox
I can see lots of benefit to having both application.cfm and Application.cfm
in the same directory. It's like killing two stones with one bird.  :)



-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 04, 2007 12:05 PM
To: CF-Talk
Subject: RE: Case Sensitivity


No no. I understand that they ARE different in the underlying ascii code.
But the point is, it simply presents confusion to people when a file name
can be spelled the exact same, but be two unique files. 

I had a discussion about programming with a co-worker this morning. We
decided that much of the programming behaviour for early languages (C, C++,
Java, etc) was based originally on hardware limitations. So, it could be
that the original UNIX systems HAD to force the differences, and so the code
was forced to be case sensitive.

Anyway, I find no use for case-sensitivity. It's only redeeming quality is
that it forces programmers to be consistent in the way their code is
written.

:)

-Original Message-
From: Tom Chiverton [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 04, 2007 9:08 AM
To: CF-Talk
Subject: Re: Case Sensitivity

On Thursday 04 Oct 2007, [EMAIL PROTECTED] wrote:
 I find no good reason that Andy.cfm should be different than andy.cfm.

Let introduce you to my friend, Mr A. Sci-Code :-)

--
Tom Chiverton
Helping to advantageously harness prospective materials
on: http://thefalken.livejournal.com



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
St James's Court Brown Street Manchester M2 2JF.  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 8008.

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





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

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


Re: Expiration Settings of Client Variables

2007-10-04 Thread Brian Kotek
I'm pretty sure client variables don't work like that (though it's been so
long since I used them that I could be mistaken). I'm pretty sure all the
purge interval does is set the frequency that the server will actually check
to see if it should purge anything, not the time that a given client
variable will exist. In other words, I'm pretty sure that if a user hits
your app 1 minute before the next purge is set to run, their client
variables will be deleted in the next minute. If you want granular control
less than a day, you're going to have to write your own code to do it. You
could set a client variable with a time stamp each time they run a request.
Then, you can compare that timestamp to the current time, and if it is
greater than the internal you want to set (2 hours I'm assuming), then you
can delete the client variables yourself (and probably redirect the user to
a login page or something).

On 10/4/07, Alex Ismail [EMAIL PROTECTED] wrote:

 We are in need to expire client variables at the same rate as session
 variables. In our case this is 2 hours.

 Unfortunately, our client variables expire randomly well before 2 hours
 are passed.
 What are correct settings to achieve this?

 Our configuration:
 - Client variables are stored in their own separate database.
 - The checkbox 'Purge data for clients that remain unvisited for 0 days'
 is checked and days is set to 0.
 - The checkbox 'Disable global client variable updates' is not checked.
 - The 'Purge Interval' is set to 2 hours and 0 minutes.

 Thank you,

 Alex Ismail


 

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

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


RE: CFIMAGE Resize Slow

2007-10-04 Thread Jayesh Viradiya
I had posted this yesterday but somehow didn't reach on HouseOfFusion.

---
Hi Eron

CF8 Offers a lot many different options for algorithms/Perf-Quality
parameter to be set with ImageResize() function. Refer Documentation for
more info on ImageResize().

Depending upon the parameter you select, your Resizing performance will
vary.

Thanks  Regards,
Jayesh Viradiya
Adobe CF Team

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

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


Re: Expiration Settings of Client Variables

2007-10-04 Thread Brian Kotek
I wrote a custom tag a long, long time ago that will do something like this.
However, I haven't looked at it in about 8 years so you're on your own as
far as how well it actually works! ;-)

http://www.adobe.com/cfusion/exchange/index.cfm?event=extensionDetailextid=1000977


On 10/4/07, Brian Kotek [EMAIL PROTECTED] wrote:

 I'm pretty sure client variables don't work like that (though it's been so
 long since I used them that I could be mistaken). I'm pretty sure all the
 purge interval does is set the frequency that the server will actually check
 to see if it should purge anything, not the time that a given client
 variable will exist. In other words, I'm pretty sure that if a user hits
 your app 1 minute before the next purge is set to run, their client
 variables will be deleted in the next minute. If you want granular control
 less than a day, you're going to have to write your own code to do it. You
 could set a client variable with a time stamp each time they run a request.
 Then, you can compare that timestamp to the current time, and if it is
 greater than the internal you want to set (2 hours I'm assuming), then you
 can delete the client variables yourself (and probably redirect the user to
 a login page or something).

 On 10/4/07, Alex Ismail [EMAIL PROTECTED] wrote:
 
  We are in need to expire client variables at the same rate as session
  variables. In our case this is 2 hours.
 
  Unfortunately, our client variables expire randomly well before 2 hours
  are passed.
  What are correct settings to achieve this?
 
  Our configuration:
  - Client variables are stored in their own separate database.
  - The checkbox 'Purge data for clients that remain unvisited for 0 days'
  is checked and days is set to 0.
  - The checkbox 'Disable global client variable updates' is not checked.
  - The 'Purge Interval' is set to 2 hours and 0 minutes.
 
  Thank you,
 
  Alex Ismail
 
 
  

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

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


RE: CFIMAGE Resize Slow

2007-10-04 Thread Jayesh Viradiya
Hi Todd,

We appreciate your feedback. It would be good if you can pinpoint
something specifically which we can take as an item on our TO DO list.

Thanks  Regards,
Jayesh Viradiya
Adobe CF Team

-Original Message-
From: Todd Mathews [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 03, 2007 10:54 PM
To: CF-Talk
Subject: RE: CFIMAGE Resize Slow

Try Efflare. CFIMAGE is nice for some things but still has a ways to go
before it can catch up to ImageCR.

Todd 

 -Original Message-
 From: Eron Cohen [mailto:[EMAIL PROTECTED] 
 Sent: Wednesday, October 03, 2007 9:58 AM
 To: CF-Talk
 Subject: CFIMAGE Resize Slow
 
 I wondering if anyone has any advice about ColdFusion 8's 
 CFIMAGE being slow when resizing images.  Its REALLY slow.  I 
 have even brought my server down trying to resize a hundred 
 or so images.  Is this something that Adobe will eventually 
 fix?  I have another solution right now, but I am unhappy 
 with the quality of the thumbnails that it is creating.
 
 I have read this thread from August regarding the same 
 complaint, but I want to know if anything has changed:
 
 http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadi
d:53049#286647
 
 Thank you 
 
 



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

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


Re: Rollback db changes in CFCUnit/CFUnit tests

2007-10-04 Thread Janet MacKay
Thanks Rich. That is helpful.  Off to download and review DBUnit.

Thanks,
Janet


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

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


Re: cfmail stuck in spool

2007-10-04 Thread Cutter (CFRelated)
See if this helps any:

http://blog.cutterscrossing.com/index.cfm/2006/12/10/ColdFusion-Mail-Spool-Lock

Steve Cutter Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer
_
http://blog.cutterscrossing.com

Tim Do wrote:
 Anybody know why this happens every once in a while?  Using cfmx 7.01
 and exchange.  Last couple weeks I've noticed that mail stops going out
 and just sits in the spool folder.  Once I restart cf services they all
 go out at once.  Been happening more often lately so I'm getting a
 little worried.
 
  
 
 Thanks,
 
 Tim
 
 
 
 

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

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


Re: Flash forms not doing anything.

2007-10-04 Thread Ian Skinner
Ian Skinner wrote:
 I have the simplest test of a flash form and nothing is happening.  I 
 mean nothing, no errors displayed or logged, no output to the browser, 
 nothing.
 
 body
 Start
 cfform name=foo action=form_test.cfm format=flash
   cfinput type=text name=bar/
 /cfform
 End
 /body
 

 The output in the browser:

 !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN 
 http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd;
 html xmlns=http://www.w3.org/1999/xhtml;
 head
 meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /
 titleFlash Form Test/title
 script type=text/javascript src=/cfide/scripts/cfform.js/script
 script type=text/javascript src=/cfide/scripts/masks.js/script
 /head

 body
 Start

 End
 /body
  
 /html


 I've checked everything I can think to check.  Any advice most appreciated I 
 just don't know where to even start here.

 Ian
Bump

I have spent all day searching for any rhyme or reason why a cfform 
format=flash... will return absolutely nothing, no errors, no markup, 
nothing.  It fails completely silently.  I have found postings here and 
there of others experiencing the same behavior, but nothing with 
anything approaching a solution or even an avenue to investigate.

Any ideas anybody?

Ian


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

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


  1   2   >