svchost.exe @ constant 50%
Our dual proc cfmx server has the svchost.exe running at 50%, seemingly tying up a whole processor. I don't think this is normal. Any ideas on what to check? Thanks, Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
changing MX stand alone server root
Where do I change the web root for the MX stand alone server? Also, what would be the best solution for be able to point between different roots as needed? This is for a local install, and I often need to change as I work on different sites. Is it possible to use multiple port mappings like the 8500, with each pointing to a different site? Thanks, Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
clear access ldb
I know of both the bad query and cfusion_dbconnections_flush() methods for clearing an access db connection, but neither seem to work in MX. Is there any programmatic way to clear connections to an access db so that you can pull/delete it from the server? Thanks, Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
(resend) cfcontent for ms word file fails on prod, not dev
(I sent this a couple of hours ago, but it doesn't seem to have made it. Please forgive the re-post) cfheader name=Content-Disposition value=filename=quotareq.doc cfcontent file=#expandPath(quotareq.doc)# deletefile=No type=application/msword That is all the code that is in the template. It works fine on our dev box, but fails on our production server. I have compared the files on both and they are synched. The only difference is that our production server is ssl-only. Could that be the issue? Anything else I can check? Thanks for any help. Here's the error IE gives: Internet explorer cannot download quotareq.cfm from (domain) Internet Explorer was not able to open this Internet site. The requested site is either unavailable or cannot be found. Please try again later. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Loss of CLIENT variables due to empty quotes in an HTML tag?
I ran into a client var disappearing in the past. I believe that pre-MX CF had a 65000 length limit on the total data per client, and when it was exceded a client variable would become undefined. What is the total length of the values of all your client variables? Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Kevin Langevin [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 9:30 AM To: CF-Talk Subject: Loss of CLIENT variables due to empty quotes in an HTML tag? I tried sending this last night, but it doesn't seem to have made it to the list, so here it is again... I've just spent hours trying to figure out what's causing some really bizarre issues with SOME of the client-scoped variables set in an application I'm running to disappear. We've been trying to nail down at what point they disappear, and it's very elusive. The weirdest part of it all is that we've narrowed the cause of this to four lines of code in a page that you land on after logging in (which sets a number of these client variables). These lines of code were four tds each of which contains an img tag with an empty src attribute (ie. src=). If we remove these four lines, everything works fine. If we put them back in, on any kind of page refresh or clicking on any link at all, our script which checks for the existence of CLIENT.lastAccess and checks to see if it's more than x minutes old triggers because client.lastaccess doesn't exist anymore.I can verify that the very last line of my ONREQUESTEND.CFM file sets and displays CLIENT.lastAccess just fine. I'm not aware of HTML throwing errors or having a problem with empty quotes, nor am I aware of ColdFusion having any such problem (empty quotes in HTML tags, not CF tags). We've crawled every line of code being run through the whole process, and haven't been able to determine anything else. Just that if we remove those lines of code with the img tags in it, or put anything at all inside those quotes, everything works fine. Anyone able to shed some light on this situation? -Kev ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Loss of CLIENT variables due to empty quotes in an HTML tag?
Not just that variable, but ALL client variables for that user. So if you are setting more than one client variable, it would be the length of all the data in all the client variables per user. For instance, if a user has one client variable with a length of 6 and another client variable with a length of 1, that would cause one to end up undefined. Also, it's a non-issue if you are on MX, I believe. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Kevin Langevin [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 2:27 PM To: CF-Talk Subject: RE: Loss of CLIENT variables due to empty quotes in an HTML tag? Unfortunately this can't be the problem...it's just a simple date/time (ie #now()#) -Original Message- From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 2:23 PM To: CF-Talk Subject: RE: Loss of CLIENT variables due to empty quotes in an HTML tag? I ran into a client var disappearing in the past. I believe that pre-MX CF had a 65000 length limit on the total data per client, and when it was exceded a client variable would become undefined. What is the total length of the values of all your client variables? Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Kevin Langevin [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 9:30 AM To: CF-Talk Subject: Loss of CLIENT variables due to empty quotes in an HTML tag? I tried sending this last night, but it doesn't seem to have made it to the list, so here it is again... I've just spent hours trying to figure out what's causing some really bizarre issues with SOME of the client-scoped variables set in an application I'm running to disappear. We've been trying to nail down at what point they disappear, and it's very elusive. The weirdest part of it all is that we've narrowed the cause of this to four lines of code in a page that you land on after logging in (which sets a number of these client variables). These lines of code were four tds each of which contains an img tag with an empty src attribute (ie. src=). If we remove these four lines, everything works fine. If we put them back in, on any kind of page refresh or clicking on any link at all, our script which checks for the existence of CLIENT.lastAccess and checks to see if it's more than x minutes old triggers because client.lastaccess doesn't exist anymore.I can verify that the very last line of my ONREQUESTEND.CFM file sets and displays CLIENT.lastAccess just fine. I'm not aware of HTML throwing errors or having a problem with empty quotes, nor am I aware of ColdFusion having any such problem (empty quotes in HTML tags, not CF tags). We've crawled every line of code being run through the whole process, and haven't been able to determine anything else. Just that if we remove those lines of code with the img tags in it, or put anything at all inside those quotes, everything works fine. Anyone able to shed some light on this situation? -Kev ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Loss of CLIENT variables due to empty quotes in an HTML tag?
I not really sure. Once we found out about this, I didn't spend a lot of time playing with it. We just recoded a bit and kept a lot more info sql-side and used cached queries rather than set everything to client variables. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Kevin Langevin [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 3:01 PM To: CF-Talk Subject: RE: Loss of CLIENT variables due to empty quotes in an HTML tag? Hmmm...I was not aware of this. I don't know if we're hitting thatr limit or not. Is there any rhyme or reason to which one(s) would get dropped? Is it the last modified, perhaps? -Kev -Original Message- From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 3:37 PM To: CF-Talk Subject: RE: Loss of CLIENT variables due to empty quotes in an HTML tag? Not just that variable, but ALL client variables for that user. So if you are setting more than one client variable, it would be the length of all the data in all the client variables per user. For instance, if a user has one client variable with a length of 6 and another client variable with a length of 1, that would cause one to end up undefined. Also, it's a non-issue if you are on MX, I believe. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Kevin Langevin [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 2:27 PM To: CF-Talk Subject: RE: Loss of CLIENT variables due to empty quotes in an HTML tag? Unfortunately this can't be the problem...it's just a simple date/time (ie #now()#) -Original Message- From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 2:23 PM To: CF-Talk Subject: RE: Loss of CLIENT variables due to empty quotes in an HTML tag? I ran into a client var disappearing in the past. I believe that pre-MX CF had a 65000 length limit on the total data per client, and when it was exceded a client variable would become undefined. What is the total length of the values of all your client variables? Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Kevin Langevin [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 9:30 AM To: CF-Talk Subject: Loss of CLIENT variables due to empty quotes in an HTML tag? I tried sending this last night, but it doesn't seem to have made it to the list, so here it is again... I've just spent hours trying to figure out what's causing some really bizarre issues with SOME of the client-scoped variables set in an application I'm running to disappear. We've been trying to nail down at what point they disappear, and it's very elusive. The weirdest part of it all is that we've narrowed the cause of this to four lines of code in a page that you land on after logging in (which sets a number of these client variables). These lines of code were four tds each of which contains an img tag with an empty src attribute (ie. src=). If we remove these four lines, everything works fine. If we put them back in, on any kind of page refresh or clicking on any link at all, our script which checks for the existence of CLIENT.lastAccess and checks to see if it's more than x minutes old triggers because client.lastaccess doesn't exist anymore.I can verify that the very last line of my ONREQUESTEND.CFM file sets and displays CLIENT.lastAccess just fine. I'm not aware of HTML throwing errors or having a problem with empty quotes, nor am I aware of ColdFusion having any such problem (empty quotes in HTML tags, not CF tags). We've crawled every line of code being run through the whole process, and haven't been able to determine anything else. Just that if we remove those lines of code with the img tags in it, or put anything at all inside those quotes, everything works fine. Anyone able to shed some light on this situation? -Kev ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Dreamweaver MX and Ecrypted Templates
I ran into something similar when trying to upload an encrypted template. I think you have to transfer the encrypted ones as binary rather than ascii via ftp. I don't use dreamweaver too much so I wouldn't know the setting. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Eric Hoffman [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 20, 2003 8:17 PM To: CF-Talk Subject: Dreamweaver MX and Ecrypted Templates Just got Dreamweaver MX...but found one terribly odd issue. We have a site that we are using check in/out on...and everytime I put an encrypted file, I see it on the server in its jumbled glory. If I put with normal FTP program...it goes up and remains intact. Anyone can explain, a setting or shortcoming? Regards, Eric J Hoffman DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: easy path question
Unfortunately, I'm helping out with a site that another developer at a remote site wrote. We are bouncing files back and forth. I have some stuff dependent on paths and wanted to make it portable so differences on the site's root wouldn't affect functionality. A mapping is about the same as hard coding it. Thanks though. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Friday, February 21, 2003 1:35 PM To: CF-Talk Subject: RE: easy path question Have you looked at mappings in the administrator? Here's what I do ... Setting a mapping in the administrator Then set this in the Application.cfm request.cfmapping=/mymapping/ Then in my code: cfinclude template=#request.cfmapping# hth H. -Original Message- From: Smith, Matthew P -CONT(DYN) [SMTP:[EMAIL PROTECTED]] Sent: Friday, February 21, 2003 11:33 AM To: CF-Talk Subject: easy path question I'd like to have an expression in Application.cfm that tells me the path to the current site, basically the web path to the directory Appication.cfm is in. So if we are in c:\interpub\wwwroot\subSite\Application.cfm And I call http://myserver.com/subSite/subdirectory/subsubDirectory/page.cfm http://myserver.com/subSite/subdirectory/subsubDirectory/page.cfm I would have a var available in Application.cfm that resolves to: /subSite/ Hmm, seemed simple but I'm not explaining it well... Basically the web path to Application.cfm, so I can set it to a var and append it like: #sitePath#subdirectory/subsubDirectory/page.cfm As the site may be moved to different directories. I know it's doable but mixing all the getBaseTemplateScriptNamePath functions gets tricky for me. Thanks! Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: easy path question
Yes, that was what I was playing with. I was just hoping there were a couple of nested template functions that would give me what I needed without complex parsing. Thanks. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED]] Sent: Friday, February 21, 2003 1:45 PM To: CF-Talk Subject: RE: easy path question That's a nasty problem, because the Application.cfm file might not be in the same directory as the base template, because CF looks up the directory tree until it finds one. I think you'll want to start with cgi.script_name and getBaseTemplatePath() in your base template. The compute the part of the full path that'd different from the script_name, and then compare that to the response getCurrentTemplatePath(), and see what's different. Then you can apply those differences to cgi.script_name to compute the URL to Application.cfm. That assumes that if you call getBaseTemplatePath() from Application.cfm, that it will return the template path of the actual requested page, but that might not be the case. barneyb -Original Message- From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]] Sent: Friday, February 21, 2003 11:33 AM To: CF-Talk Subject: easy path question I'd like to have an expression in Application.cfm that tells me the path to the current site, basically the web path to the directory Appication.cfm is in. So if we are in c:\interpub\wwwroot\subSite\Application.cfm And I call http://myserver.com/subSite/subdirectory/subsubDirectory/page.cfm http://myserver.com/subSite/subdirectory/subsubDirectory/page.cfm I would have a var available in Application.cfm that resolves to: /subSite/ Hmm, seemed simple but I'm not explaining it well... Basically the web path to Application.cfm, so I can set it to a var and append it like: #sitePath#subdirectory/subsubDirectory/page.cfm As the site may be moved to different directories. I know it's doable but mixing all the getBaseTemplateScriptNamePath functions gets tricky for me. Thanks! Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: easy path question
Thanks, James. Worked a treat.
Cheers,
Matthew P. Smith
Web Developer, Object Oriented
Naval Education Training Professional
Development Technology Center
(NETPDTC)
(850)452-1001 ext. 1245
[EMAIL PROTECTED]
-Original Message-
From: James Ang [mailto:[EMAIL PROTECTED]
Sent: Friday, February 21, 2003 2:09 PM
To: CF-Talk
Subject: RE: easy path question
Fun question. I have been mulching on this for a while now, and here is
my *current* solution:
In Application.cfm:
cfscript
sttCFG = StructNew();
sttCFG.strAppPhysDir = GetDirectoryFromPath(GetCurrentTemplatePath());
// sttCFG.strAppPhysDir = GetDirectoryFromPath(ExpandPath(..\));
sttCFG.strBasePhysDir = GetDirectoryFromPath(GetBaseTemplatePath());
// sttCFG.strBasePhysDir = GetDirectoryFromPath(ExpandPath(scripts/));
sttCFG.nLenAppPhysDir = Len(sttCFG.strAppPhysDir);
sttCFG.nLenBasePhysDir = Len(sttCFG.strBasePhysDir);
sttCFG.strBaseWebRelPath = Reverse(ListRest(Reverse(CGI.SCRIPT_NAME),
/)) /;
sttCFG.nLenBaseWebRelPath = Len(sttCFG.strBaseWebRelPath);
if (sttCFG.nLenAppPhysDir EQ sttCFG.nLenBasePhysDir) {
sttCFG.strAppWebRelPath = sttCFG.strBaseWebRelPath;
} else {
sttCFG.strAppWebRelPath = Left(sttCFG.strBaseWebRelPath,
sttCFG.nLenBaseWebRelPath - (sttCFG.nLenBasePhysDir -
sttCFG.nLenAppPhysDir));
}
/cfscript
cfdump var=#sttCFG#
BIG ASSUMPTION:
NO VIRTUAL FOLDERS under the approot. :P
Note:
The two commented out lines were for testing purposes. :P And the code
is intentionally verbose. You can optimize, and obfuscate however you
like. :)
James Ang
Programmer/Product Engineer
MedSeek, Inc.
[EMAIL PROTECTED]
-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Friday, February 21, 2003 11:45 AM
To: CF-Talk
Subject: RE: easy path question
That's a nasty problem, because the Application.cfm file might not be in
the
same directory as the base template, because CF looks up the directory
tree
until it finds one. I think you'll want to start with cgi.script_name
and
getBaseTemplatePath() in your base template. The compute the part of
the
full path that'd different from the script_name, and then compare that
to
the response getCurrentTemplatePath(), and see what's different. Then
you
can apply those differences to cgi.script_name to compute the URL to
Application.cfm. That assumes that if you call getBaseTemplatePath()
from
Application.cfm, that it will return the template path of the actual
requested page, but that might not be the case.
barneyb
-Original Message-
From: Smith, Matthew P -CONT(DYN)
[mailto:[EMAIL PROTECTED]
Sent: Friday, February 21, 2003 11:33 AM
To: CF-Talk
Subject: easy path question
I'd like to have an expression in Application.cfm that tells me
the path to
the current site, basically the web path to the directory
Appication.cfm is
in.
So if we are in c:\interpub\wwwroot\subSite\Application.cfm
And I call
http://myserver.com/subSite/subdirectory/subsubDirectory/page.cfm
http://myserver.com/subSite/subdirectory/subsubDirectory/page.cfm
I would have a var available in Application.cfm that resolves to:
/subSite/
Hmm, seemed simple but I'm not explaining it well... Basically
the web path
to Application.cfm, so I can set it to a var and append it like:
#sitePath#subdirectory/subsubDirectory/page.cfm
As the site may be moved to different directories.
I know it's doable but mixing all the getBaseTemplateScriptNamePath
functions gets tricky for me.
Thanks!
Matthew P. Smith
Web Developer, Object Oriented
Naval Education Training Professional
Development Technology Center
(NETPDTC)
(850)452-1001 ext. 1245
[EMAIL PROTECTED]
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: who on here did the death clock?
I read an article a while back about a company that is already doing this. I wish I could remember were I saw it... The company has some custom software running that tries all possible permutations and bounces each result against a filter to eliminate obvious gibberish and such. I think it was only stories and food recipes right now; I don't think they were trying to generate any code. For the recipes, they pull the most promising ones and have a staff of chefs to try them out. Most turn out awful, but they had come up with a couple that added one or two weird ingredients to traditional recipes that turned out surprisingly good. The whole million monkeys for a million years thing... On the wall of their office, the have a poster on which is printed one of the software's early writings: To be, or not to be. I will be interesting to see where this heads. Will computers eventually make even creativity obsolete? Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: David R. McGraw [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 2:48 PM To: CF-Talk Subject: RE: who on here did the death clock? By then all code will be written by a program that can code in any language I thought of an idea for a movie once, calling it Duce Ex Machina - it's latin for God machine. Think about a program that systematically goes through every combination of 1,000,000 chars... and then checks it to see if its executable... Eventually, it will code its self but better, Eventually it will code everything... and excute it. It would write novels, movie scripts, And in theroy, it would eventually write a 1,000,000 character story about YOU, ever detail being 100% correct. So if it creates itself but better, it will eventually create the perfect AI. and therefore become the God Machine Although it would create Tera bytes of worthless crap too. But its a neat idea for a movie. David R. McGraw II ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
date diff help
I need a conditional that will reveal a link starting at midnight tonight.
My brain seems a bit fired right now, and I can't get this working.
Doing this:
#datediff( d , {ts '2003-02-07 00:00:01'} , now() )#
gives me a 0
but so does this:
#datediff( d , {ts '2003-02-06 00:00:00'} , now() )#
(with a 6 instead of a 7 for the day)
I've also tried y.
Can anyone provide the syntax to do what I need.
It'll just be in a simple cfif.
Last thing for today, then I can go home, and I rather not come in tonight.
Thanks, all.
Matthew P. Smith
Web Developer, Object Oriented
Naval Education Training Professional
Development Technology Center
(NETPDTC)
(850)452-1001 ext. 1245
[EMAIL PROTECTED]
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: date diff help
Whoa, nice. I was heading down a whole bunch of
cfif datepart( , now() ) lt 2004 and datepart( d , now() ) gte 6
etc, etc.
So cf naturally parses plain language dates like that? wow
Thanks, Raymond, works a treat.
Matt
-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 06, 2003 4:38 PM
To: CF-Talk
Subject: RE: date diff help
Why not keep it simple?
cfif now() gte February 7, 2003
hello
cfelse
not
/cfif
===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
Email: [EMAIL PROTECTED]
WWW : www.camdenfamily.com/morpheus
Yahoo IM : morpheus
My ally is the Force, and a powerful ally it is. - Yoda
-Original Message-
From: Smith, Matthew P -CONT(DYN)
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 06, 2003 4:28 PM
To: CF-Talk
Subject: date diff help
I need a conditional that will reveal a link starting at
midnight tonight. My brain seems a bit fired right now, and I
can't get this working.
Doing this:
#datediff( d , {ts '2003-02-07 00:00:01'} , now() )#
gives me a 0
but so does this:
#datediff( d , {ts '2003-02-06 00:00:00'} , now() )#
(with a 6 instead of a 7 for the day)
I've also tried y.
Can anyone provide the syntax to do what I need.
It'll just be in a simple cfif.
Last thing for today, then I can go home, and I rather not
come in tonight.
Thanks, all.
Matthew P. Smith
Web Developer, Object Oriented
Naval Education Training Professional
Development Technology Center
(NETPDTC)
(850)452-1001 ext. 1245
[EMAIL PROTECTED]
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfhttp, Connection Failure: Status code unavailable
We just migrated our production server over to cfmx yesterday, and are running into a couple of issues regarding cfhttp. A call to a web service we are using for user validation using cfhttp is returning the following: Connection Failure: Status code unavailable Here's the code: cfhttp url=https://www.foo.com/whatever/member.verify; method=POST port=443 username=foo password=foo resolveurl=false timeout=90 throwonerror=Yes cfhttpparam type=URL name=RULE value=#attributes.rule# cfhttpparam type=URL name=PNID value=#attributes.ssn# cfhttpparam type=URL name=IDTYP value=#attributes.IDTYP# cfhttpparam type=URL name=LN value=#attributes.lastName# cfhttpparam type=URL name=DOB value=#attributes.birthDate# cfhttpparam type=URL name=APPL value=#attributes.APPL# /cfhttp Please note that this was working just fine on CF5. Unfortunately, due to network restrictions, this was the one bit of code that we could not test on the development box prior to the mx cutover. After a bit of research, I found an alternate to cfhttp. http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=2 http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=2threadid =350305highlight_key=ykeyword1=cfhttpkeyword2=ssl threadid=350305highlight_key=ykeyword1=cfhttpkeyword2=ssl I have it working fine, but unfortunately it seems that after implementing the solution below, the server started crashing every 5-10 minutes, requiring a manual restart of the iis/cf services. This is the first time I've used cfobject, so I'm not sure if I'm doing something wrong. I'm not sure if the object created has to be closed in some way, or if the concurrent calls may be causing the problem and a named lock may be required to single thread the cfobject call. The high use of this code really mandates avoiding a single threaded approach. cfobject action=Create name=objSrvHTTP class=MSXML2.ServerXMLHTTP cfset temp = objSrvHTTP.open(GET, https://www.foo.com/whatever//Member.Verify?RULE=#attributes.rule#IDTYP=#at tributes.IDTYP#APPL=#attributes.APPL#LN=#attributes.lastName#PNID=#attrib utes.ssn#DOB=#attributes.birthDate#,false, foo , foo ) cfset temp=objSrvHTTP.send() cfset myResult = objSrvHTTP.responsetext Lastly, I seem to remember someone mentioning a java class that they had come up with for use as an alternate to cfhttp. As we have full control over the server, we have the flexibility to use cfx tags or any other option. If anyone knows another method to hit a remote web service, I would be up for trying it. Thanks for any help. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MX doesn't work with recursive stored procedure using temp ta ble
Not really an answer, more a suggestion for a slightly different approach. Perhaps use a table variable(instead of a global temp table), as well as a single stored proc. You shouldn't need to have the procedure call itself, just have all the sql you need in the proc within a conditional loop to run while child records are found. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Richard Fantini [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 22, 2003 1:59 PM To: CF-Talk Subject: MX doesn't work with recursive stored procedure using temp table Getting a strange error calling a stored procedure after upgrading to MX. Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name '##GetSubMembersTemp'. The procedure recursively calls itself to walk through a parent-child tree structure, using a temp table to store the results. This code works perfectly on CF5, not sure what the deal is. I'm using CFSTOREDPROC, returning two result sets and a return code. The servers are Win 2000, database is SQL 2000. Any help would be more than appreciated. Thanks. -Rich ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
multi homed sever, 443 will not display
We've just migrated our production web server to a new box. We have several virtual sites set up in iis. The default web site will display via both port 80 and 443, however the virtual sites will only display over post 80. We are getting a network connection refused when trying to access the virtual sites via ssl. We have recreated the sites several times, but still can't get them to work. We have changed the cachRealPath attributes in the c:/cfusionmx/runtime/servers/default/SERVER-INF/jrun.xml to false. Any ideas/help would be greatly appreciated. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: multi homed sever, 443 will not display
After a little research, it seems that at least one user has run into the same problem. Unfortunately, it appears that it was not resolved. Perhaps a rollback to updater 1? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: multi homed sever, 443 will not display
Thanks, all. Sorted it out. We did have a cert for each one, they just hadn't been applied correctly. Again, thanks for the help. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Ryan Kime [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 12:30 PM To: CF-Talk Subject: RE: multi homed sever, 443 will not display Mark is right. A cert is bound to a URL address and cannot be used on vdirs. You can get a wildcard cert for a domain so that *.domain.com will be covered, but it will not cover *.*.com -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 12:06 PM To: CF-Talk Subject: RE: multi homed sever, 443 will not display Matt, Each SSL Certificate must be applied to a separate IP address. You cannot do virtuals that each have their own cert. How will the web server know which certificate to serve without looking at the header (which it cannot access until it establishes a secure socket). -Mark ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfmail custom tag
I know I have seen a smart cfmail custom tag that automatically does multipart email and (I think) had a testing mode. We're in the need for something like this, but I can't track it down in my list archives nor in the macromedia forums. If anyone knows what I might be talking about, and where I can get it, please let me know. I'm pretty sure it was a free tag. Thanks, Matt ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfmail custom tag
Thanks for all the help. Jochem's was what I was looking for. Unfortunately, we are mid MX migration, and apparently the two are not compatible. I appreciate the other options suggested, and will definitely check them out. Thanks again to all for the help, Matt -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 16, 2003 4:06 PM To: CF-Talk Subject: Re: cfmail custom tag http://jochem.vandieten.net/coldfusion/customtags/advancedemail/advancedemai l.html HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MS SQL obdc data source timeout settings
Thanks so much, John. Exactly what I was looking for. Matt -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]] Sent: Friday, January 10, 2003 10:23 AM To: CF-Talk Subject: Re: MS SQL obdc data source timeout settings Under CF5, a timeout of 0 meant a permanent (no timeout) database connection -- don't know for sure if this holds under CFMX, but since you're on CF5, that's the problem. But if you're working on a nightly backup, I wouldn't rely on the connection timeout. If the db is unavailable during the backup, your site isn't really available either (at least the db portions). You could use xp_cmdshell to stop the coldfusion server (ensuring that there are no remaining cf db connections) and then run the backup and restart the cf server all in T-SQL (assuming appropriate permissions, etc.) Depends on the size of the backup -- but shouldn't be more than 5 minutes. Of course, that's a long time on a 24x7 site. But honestly, SQL 2000 can backup a database while it is in use. Backups can fail if you're creating/deleting database files or shrink commands, but just having an active connection isn't a dealkiller. I'm running one right now on a reporting database (2.5 GB) while a couple of huge reports are running (11 table joins, including composite keys of text fields -- don't ask) and it's working fine. There are 34 connections, 5 users, and about 8 running/runable tasks. And I'm doing sp_who, etc to check these things while the backup is running. Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
MS SQL obdc data source timeout settings
A couple of questions regarding connection timeout settings for a MS SQL 2K obdc data source: While trying to run a backup job on the db, the job said that it was unable to go into single-user mode because of the cf connection. This was without any activity on the site, and profiler shows that the CF account was maintaining the connection. After checking the data source settings in cf administrator, I noticed that the connection timeout was set to 0 minutes for several of the data sources. So, would having the connection timeout set to 0 cause CF to maintain the connection indefinitely? What is the recommended setting for connection timeout? This is a low-to-medium traffic intranet site. Also, this is for a CF5 server. Are the recommended settings different for CF MX? Thanks, Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: page load times (not just on the server)...
Off the top of my head, here's the only way I could see doing this: Convert EVERY link to a form.(yuck) Or assign an ID to each link and write a javascript function that monitors for clicks and compares all the ids to the id of the clicked link(or some such). Use javascript to set a hidden form field to the user's current time then submit onClick for the link. On the next page, onLoad take the users current time, pop a hidden window that submits the prior time(from the form field) and the current time. Server side code to compute the difference and store in db. Take them to the link they clicked if the storage mechanism needs an interim update page. I'm sure there are a hundred ways to go about this, and I usually avoid javascript when possible so I'm not tops with the language. Just some ideas. t/ Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: cftalk [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 8:29 AM To: CF-Talk Subject: page load times (not just on the server)... I am needing to find the page load times from the CLIENT side. Does anyone have a tool or know a way to do this? Brian Yager President - North Alabama Cold Fusion Users Group http://www.nacfug.com Ground-Based Midcourse Defense JPO Contractor CSC (256)313-9397 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Unsubscribing
You guys cook at work sometimes? Matt -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 1:13 PM To: CF-Talk Subject: RE: Unsubscribing *wry chuckle* Over here we have 'pot able' days all the time. And it doesn't mean alcohol. -Gel -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 2:37 PM To: CF-Talk Subject: RE: Unsubscribing I used to work at a place that had Potable Fridays. That meant the company president would buy us all alcohol after lunch. Are you have a potable Thursday, Gel? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Happy Birthday!!
http://forums.fark.com/cgi/fark/comments.pl?IDLink=394524 -Original Message- From: Robert Bailey [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 02, 2003 12:43 PM To: CF-Talk Subject: RE: Happy Birthday!! Wait, nm, wasn't it born in 1969? Yeah yeah, Oct 29, 1969 when the first 2 computers talked to each other over the network, Sept 2 when the first computer talked to a router of the same year, so 20 years of what? And mosaic browser came out in 1993. OK, I am lost. I bite, what came out 20 years ago? -Original Message- From: Jacob [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 02, 2003 10:24 AM To: CF-Talk Subject: Happy Birthday!! Happy Birthday to you Happy Birthday to you Happy Birthday Dear Internet Happy Birthday to you... 20 years old ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
verify that updater 2 has been applied
I need to verify that the latest updater has been applied to a CF MX install. I poked around administrator and also looked at the debug info, but nothing jumped out. Where should I look? t/ Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: verify that updater 2 has been applied
That's what I show. Time for updater 2. Thanks for the help. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: verify that updater 2 has been applied
AHH!! Oh no, I applied and it crashed my hard drive! Heh, jk. Good thing I'm slow. No worries. ;) t/ Matt -Original Message- From: Jesse Houwing [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 31, 2002 10:30 AM To: CF-Talk Subject: Re: verify that updater 2 has been applied Damn... typo... that should be if you have *Updater 2* installed... sorry! Jesse ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: OT sql order by
How would you use the cf-side sorted list within a SELECT statement to return the records in the proper order? Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 10:22 AM To: CF-Talk Subject: Re: OT sql order by FYIthat function would be used after the data is retrieved. If you want to get it out of the DB in the proper order, use that function to sort the list before you insert it into the DB. HTH Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 8:15 AM Subject: Re: OT sql order by ListSort(YourField,numeric) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Tim Do [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 8:04 AM Subject: OT sql order by hello... I have a varchar field in sql2000 that I use as unit #'s for apts. They can enter as 1,2,3a,4b,10. I would like to order that by the unit number, but since its a varchar, it comes out 1,10,2,3a,4b. How would I order it like this: 1,2,3a,4b,10 TIA ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Can't Reach the Updater 2
Useless Digressions on Friday ; ) -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 12:56 PM To: CF-Talk Subject: RE: Can't Reach the Updater 2 Friday, hmmm? Don't forget UDF = Universal Disk Format. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 1:23 PM To: CF-Talk Subject: Re: Can't Reach the Updater 2 So let's see in CF there is: ColdFusion...often confused with Cold Fusion (the theoretical power souce) ColdFusion Components (CFC) and CFCs are Chlorafloracarbons (spl?) and now updater 2 AKA U2 the band It's Friday and that's my reason for this little observation ;-) and now back to your regulary scheduled CF-Talk Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Lincoln Milner [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, December 13, 2002 9:39 AM Subject: RE: Can't Reach the Updater 2 That's U2 (not the band, the CFMX file...) -Original Message- From: Ryan Kime [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 11:51 AM To: CF-Talk Subject: RE: Can't Reach the Updater 2 OKgot sick of the cookie bull. Here's the address of the actual download (I think)...can someone verify that this is the U2? Our http usage is monitored here and I don't want to waste 17 MB of my quota if it's not the right one. :P http://download.macromedia.com/pub/coldfusion/updater/cfmx_updater_win.exe U1 or U2? -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 10:17 AM To: CF-Talk Subject: Re: Can't Reach the Updater 2 Are u using Internet Explorer? if so.. go to tool/internet options.. and find where your Temp internet files are stored... You can go to the diretory and delete everything.. Doesnt do any harm. Then MM again.. we are all able to get to the site fine! Joe On Fri, 13 Dec 2002 10:54:56 -0500 Stacy Young [EMAIL PROTECTED] wrote: Ok I deleted any MM cookies I had and cleared cache and I still can't reach the Updater download. Brings me to a notify me page. -Stace AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Form validation 508 compliancy
I had to ask around, and the consensus was that they are not compliant. I think that the problem is that anything that changes the focus for the user is frowned upon. I'm not sure if it's a technical one, like the screen-readers would have a problem with it, or if it's a more general usability no-no. I'll try to research it a bit further and let you know (our 508 guru already left), but I my rule of thumb is to steer clear of it. On a side note, I prefer to keep it server side any way, as I have heard figures ranging from 5 to 20 percent of browser have JS disabled. Also, it keeps malicious users from entering bad data, and if they are there to do so, they would most certainly disable all the client side validation. So if you are going to do server side to protect your app/data anyway, why even invest the extra work in JS... My 2 cents. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 2:31 PM To: CF-Talk Subject: OT: Form validation 508 compliancy I realize that sometimes it's better to use client side validation on forms... Sometimes server side... Sometimes both. Are there any rules of thumb to using client side (JavaScript) validation on 508 compliant forms? Thanks :-) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Form validation 508 compliancy
Agreed. I'm not sure if it's presence is considered a violation of compliance, though I would think that a user that it would cause problems for would have it disabled. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Scott Brady [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 4:15 PM To: CF-Talk Subject: RE: Form validation 508 compliancy So if you are going to do server side to protect your app/data anyway, why even invest the extra work in JS... Because as a User I prefer client-side validation to save me some trips to the server, if possible. For the 90% of users with it enabled, it can be user-friendly. Of course, you should ALWAYS do server-side . . . . And, for most forms, the client-side validation is pretty quick easy to do [paricularly if you have a set of standard validation functions you call]. Scott Scott Brady http://www.scottbrady.net/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: access odbc connection
I believe you have to map the drive rather than use a unc. I might be wrong though. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Steve Dworman [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 3:58 PM To: CF-Talk Subject: access odbc connection Here's the deal. We need to connect to an access database that resides on another server. I know to use the UNC path, and to make sure the ColdFusion service has rights to open the database on the other machine. There is no username and password for the database. The issue is that CF cannot verify the data source. I can set it up in Windows 2000 server and I can connect to it using SQLCon32. What else do I need to do in order to make CF verify the connection? TIA Steven D Dworman Macromedia Certified Developer - Web Consultant Systems Administrator ComSpec International - http://www.comspecinternational.com http://www.comspecinternational.com/ phone: 248.647.8841 cell: 248.767.9925 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com http://www.empower-xl.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: access odbc connection
Yes, but I mean map the remote drive to a local drive letter. (sorry, but I might not be using the correct terminology). \\othercomputer\c$ is mapped to j: locally(cfserver). So the cfserver would have a mapped drive, j:, which is actually c: on the other computer. Can someone verify this is the proper way to accomplish what Steve is trying to do? I searched the macromedia forums but couldn't find it. I could have sworn I saw this somewhere though. I'll try locally and email shortly. -Original Message- From: Steve Dworman [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 4:15 PM To: CF-Talk Subject: RE: access odbc connection CF will only read local drives. I'm positive you have to use the UNC path. -Original Message- From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 5:05 PM To: CF-Talk Subject: RE: access odbc connection I believe you have to map the drive rather than use a unc. I might be wrong though. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Steve Dworman [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 3:58 PM To: CF-Talk Subject: access odbc connection Here's the deal. We need to connect to an access database that resides on another server. I know to use the UNC path, and to make sure the ColdFusion service has rights to open the database on the other machine. There is no username and password for the database. The issue is that CF cannot verify the data source. I can set it up in Windows 2000 server and I can connect to it using SQLCon32. What else do I need to do in order to make CF verify the connection? TIA Steven D Dworman Macromedia Certified Developer - Web Consultant Systems Administrator ComSpec International - http://www.comspecinternational.com http://www.comspecinternational.com/ phone: 248.647.8841 cell: 248.767.9925 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com http://www.empower-xl.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
client variables disappearing
Is there a limit to the total amount of information stored in client variables per user? I am having random client variables become undefined for no reason. It is not consistently the same variable, it's not a loss of state issue as we have cfid/cftoken in the url and I'm allowing cookies to be set in my browser as well. cfloop list=#getclientvariableslist()# index=i cfset variables.testvar = variables.testvar evaluate(client. i) /cfloop cfdump var=#len(variables.testvar)# The length of variables.testvar = 66817, which makes me wonder if I am hitting a 65000 limit somewhere. We are storing client variables in a sql2k db. I have tried upping the Long Text Buffer Size up to the max it will allow(99), but this doesn't seem to help. (I'm not sure if it should or not, but something to try). Does the cf service need to be restarted for this change to take effect? What else might be causing this? The macromedia forums don't seem to have any entries similiar to this, but it's hard to believe no one has hit this limit before. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: client variables disappearing
Thanks, Debbie. I assume the same limit does not apply to session variables so I might just recode a few areas. -Original Message- From: Debbie Dickerson [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 3:44 PM To: CF-Talk Subject: RE: client variables disappearing If you're using CF5 or earlier, yes, there is a limit (65k). http://www.macromedia.com/v1/Handlers/index.cfm?ID=22902Method=Full -Original Message- From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 4:28 PM To: CF-Talk Subject: client variables disappearing Is there a limit to the total amount of information stored in client variables per user? I am having random client variables become undefined for no reason. It is not consistently the same variable, it's not a loss of state issue as we have cfid/cftoken in the url and I'm allowing cookies to be set in my browser as well. cfloop list=#getclientvariableslist()# index=i cfset variables.testvar = variables.testvar evaluate(client. i) /cfloop cfdump var=#len(variables.testvar)# The length of variables.testvar = 66817, which makes me wonder if I am hitting a 65000 limit somewhere. We are storing client variables in a sql2k db. I have tried upping the Long Text Buffer Size up to the max it will allow(99), but this doesn't seem to help. (I'm not sure if it should or not, but something to try). Does the cf service need to be restarted for this change to take effect? What else might be causing this? The macromedia forums don't seem to have any entries similiar to this, but it's hard to believe no one has hit this limit before. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
sum values in list
I have a comma delimited list of integer values. Is there a cf function that will add all the values together? Or do I have to loop through the list adding each value to get the sum? Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: sum values in list
Thanks, Mike. It works(sorta). Below is my original code: cfloop query=qry_licenseInfo cfif len(qry_licenseInfo.softwareUsers) cfset variables.totalSoftwareUsers = variables.totalSoftwareUsers + val(qry_licenseInfo.softwareUsers) /cfif cfif len(qry_licenseInfo.softwareUsers) cfset variables.totalCurrentLicenses = variables.totalSoftwareUsers + val(qry_licenseInfo.currentLicenses) /cfif cfif len(qry_licenseInfo.softwareUsers) cfset variables.totalRequiredLicenses = variables.totalSoftwareUsers + val(qry_licenseInfo.requiredLicenses) /cfif cfif len(qry_licenseInfo.softwareUsers) cfset variables.totalRequiredUpgrades = variables.totalSoftwareUsers + val(qry_licenseInfo.requiredUpgrades) /cfif /cfloop Here's what I did with your suggestion: cfset variables.totalSoftwareUsers = arraySum(listToArray(valueList(qry_licenseInfo.softwareUsers))) cfset variables.totalCurrentLicenses = arraySum(listToArray(valueList(qry_licenseInfo.currentLicenses))) cfset variables.totalRequiredLicenses = arraySum(listToArray(valueList(qry_licenseInfo.requiredLicenses))) cfset variables.totalRequiredUpgrades = arraySum(listToArray(valueList(qry_licenseInfo.requiredUpgrades))) However, I've run into a snag. The query I'm working with is returning empty strings for some of the records. When this occurs, I am getting this for output: Total Software Users: 2.12453679578E-314 Is there something I can tweak? The single cfset is much more economical overhead wise, but I'm not sure what to change to get a 0 when nothing but empty strings are contained in the result set for each aggregate list. Thanks again for the help! Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED]] Sent: Friday, November 29, 2002 12:01 PM To: CF-Talk Subject: RE: sum values in list Try #ArraySum(ListToArray(myList))# HTH -Original Message- From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]] Sent: Friday, November 29, 2002 17:56 To: CF-Talk Subject: sum values in list I have a comma delimited list of integer values. Is there a cf function that will add all the values together? Or do I have to loop through the list adding each value to get the sum? Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: sum values in list
Because me dba is taking a 4 day holiday weekend, and I'm just trying a cf solution. ;) -Original Message- From: Ken Wilson [mailto:[EMAIL PROTECTED]] Sent: Friday, November 29, 2002 12:26 PM To: CF-Talk Subject: RE: sum values in list Why not just return the totals as a part of your query? Let the database do it's job. Ken -Original Message- From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]] Sent: Friday, November 29, 2002 1:13 PM To: CF-Talk Subject: RE: sum values in list Thanks, Mike. It works(sorta). Below is my original code: cfloop query=qry_licenseInfo cfif len(qry_licenseInfo.softwareUsers) cfset variables.totalSoftwareUsers = variables.totalSoftwareUsers + val(qry_licenseInfo.softwareUsers) /cfif cfif len(qry_licenseInfo.softwareUsers) cfset variables.totalCurrentLicenses = variables.totalSoftwareUsers + val(qry_licenseInfo.currentLicenses) /cfif cfif len(qry_licenseInfo.softwareUsers) cfset variables.totalRequiredLicenses = variables.totalSoftwareUsers + val(qry_licenseInfo.requiredLicenses) /cfif cfif len(qry_licenseInfo.softwareUsers) cfset variables.totalRequiredUpgrades = variables.totalSoftwareUsers + val(qry_licenseInfo.requiredUpgrades) /cfif /cfloop Here's what I did with your suggestion: cfset variables.totalSoftwareUsers = arraySum(listToArray(valueList(qry_licenseInfo.softwareUsers))) cfset variables.totalCurrentLicenses = arraySum(listToArray(valueList(qry_licenseInfo.currentLicenses))) cfset variables.totalRequiredLicenses = arraySum(listToArray(valueList(qry_licenseInfo.requiredLicenses))) cfset variables.totalRequiredUpgrades = arraySum(listToArray(valueList(qry_licenseInfo.requiredUpgrades))) However, I've run into a snag. The query I'm working with is returning empty strings for some of the records. When this occurs, I am getting this for output: Total Software Users: 2.12453679578E-314 Is there something I can tweak? The single cfset is much more economical overhead wise, but I'm not sure what to change to get a 0 when nothing but empty strings are contained in the result set for each aggregate list. Thanks again for the help! Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED]] Sent: Friday, November 29, 2002 12:01 PM To: CF-Talk Subject: RE: sum values in list Try #ArraySum(ListToArray(myList))# HTH -Original Message- From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]] Sent: Friday, November 29, 2002 17:56 To: CF-Talk Subject: sum values in list I have a comma delimited list of integer values. Is there a cf function that will add all the values together? Or do I have to loop through the list adding each value to get the sum? Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: sum values in list
Correct. We will probably modify the root proc with an additional method to return aggregates, but I'd like to wrap this up so it's ready to go Monday morning and I don't have it hanging over me all weekend. The loop works fine, I was just exploring additional options for personal knowledge. The #ArraySum(ListToArray(myList))# is a nifty little trick to know, which is why I like to bounce stuff off this list. -Original Message- From: Lofback, Chris [mailto:[EMAIL PROTECTED]] Sent: Friday, November 29, 2002 12:33 PM To: CF-Talk Subject: RE: sum values in list So you're using Stored Procedures, not CFQUERY, and you can't change the SPs? Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: sum values in list
Nope, still getting the 2.12453679578E-314 Thanks though. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Lofback, Chris [mailto:[EMAIL PROTECTED]] Sent: Friday, November 29, 2002 1:06 PM To: CF-Talk Subject: RE: sum values in list The wrap makes this confusing. Don't miss the space in the parameters... ArraySum(ListToArray(ListChangeDelims(ValueList(qMyQuery.MyColumn),,, ))) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
silly rereplace
cfset form.SSN = reReplace( form.SSN, [[:Space:]], , all ) this is not stripping out spaces like I want it too...? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: silly rereplace
Yep, works great. Thanks for the help. Any reason why the original doesn't work? It seems like it should, or am I misunderstanding the [[:Space:]] ? -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 27, 2002 9:50 AM To: CF-Talk Subject: RE: silly rereplace cfset form.SSN = Replace(form.SSN, ' ', '', 'all') why not just do this? ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 27, 2002 10:28 AM To: CF-Talk Subject: silly rereplace cfset form.SSN = reReplace( form.SSN, [[:Space:]], , all ) this is not stripping out spaces like I want it too...? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: silly rereplace
cfset form.ssn = REReplace(form.SSN,[^0-9],,ALL) I was stripping out the dashes the step before, but this is a much better solution. Nice! Thanks to all for the help. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 27, 2002 10:22 AM To: CF-Talk Subject: Re: silly rereplace cfset form.SSN = reReplace( form.SSN, [[:Space:]], , all ) this is not stripping out spaces like I want it too...? imho you're apt to have people try to put hyphens and stuff in there also... I'd probably go with a negate: cfset form.ssn = REReplace(form.SSN,[^0-9],,ALL) s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
can't refernce #attributes# on cf5?
I'm in the unenviable position of working a site with a development server running cfmx and the production server running cf 5. I have a bit of code that verifies the form and cfmodules back to the form if an error is found passing the entire attributes scope to maintain the user entries. Works perfect on the dev(mx) box, but dies on the prod(cf5) box. I can't even do a cfdump var=#attributes# The below code shows attributes.birthDateDay, but gets an undefined error on the cf dump on the cf 5 server. It works fine on the mx box... cfset attributes.birthDateDay = form.birthDateDay cfoutput#attributes.birthDateDay#/cfoutputbr cfdump var=#attributes#cfabort Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: can't reference #attributes# on cf5?
Wouldn't setting a variable in the attributes scope cause it to be defined? Here's a bit more expanded view of the code: cfif variables.errorsFound cfset attributes.ssn = form.ssn cfset attributes.lastName = form.lastName cfset attributes.birthDateYear = form.birthDateYear cfset attributes.birthDateMonth = form.birthDateMonth cfset attributes.birthDateDay = form.birthDateDay cfmodule template=login.cfm errorslist=#variables.errorsList# attributeCollection=#attributes# cfabort /cfif It errors out on the attributeCollection=#attributes#, line above the cfabort. I added in you snippet, and it's working now. Thanks so much. I'm just curious as to why setting a var wouldn't create the structure? cfif variables.errorsFound cfif NOT IsDefined(attributes) cfset attributes = structNew() /cfif cfset attributes.ssn = form.ssn cfset attributes.lastName = form.lastName cfset attributes.birthDateYear = form.birthDateYear cfset attributes.birthDateMonth = form.birthDateMonth cfset attributes.birthDateDay = form.birthDateDay cfmodule template=login.cfm errorslist=#variables.errorsList# attributeCollection=#attributes# cfabort /cfif -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 27, 2002 11:41 AM To: CF-Talk Subject: RE: can't refernce #attributes# on cf5? Perhaps the attribute struct is not yet created when that line of code executes. That may cause the error in CF5...and in MX it would auto create the struct if it didn't exist. cfif NOT IsDefined(attributes) cfset attributes = structNew() /cfif HTH Stace ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Would anyone want a CFX_HTTP tag written in Java?
Me 2 Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Mike Brunt [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 27, 2002 1:04 PM To: CF-Talk Subject: RE: Would anyone want a CFX_HTTP tag written in Java? Yes we are interested also, thank you. Kind Regards - Mike Brunt, CTO Webapper Blog http://www.webapper.net Web site http://www.webapper.com Downey CA Office 562.243.6255 AIM - webappermb Web Application Specialists -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 27, 2002 10:52 AM To: CF-Talk Subject: Would anyone want a CFX_HTTP tag written in Java? So, I just wrote a CFHTTP tag in Java that actually works. Right now, it only does get operations, but if anyone would want to play with it, I can set up a website tonight where you guys can download it. So, anybody interested? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
can't listappend w/ double pipe delimiter?
cfset request.mainNavigationList=listAppend( request.mainNavigationList, oneOne|OneTwo , || ) cfset request.mainNavigationList=listAppend( request.mainNavigationList, twoOne|twoTwo , || ) cfdump var=#request.mainNavigationList#brcfabort results in: oneOne|OneTwo|twoOne|twoTwo (single pipe in middle) but I want : oneOne|OneTwo||twoOne|twoTwo (double pipe in middle) I could work around by changing up the cfsets, but I would like to know how to listAppend with a double character delimeter. Thanks for any help. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: can't listappend w/ double pipe delimiter?
Thanks, Ben. -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 21, 2002 2:30 PM To: CF-Talk Subject: RE: can't listappend w/ double pipe delimiter? This applies to CF5 for sure, and I think all other versions as well. Delimiters in CF native lists are always single characters. When reading a list, you may select multiple delimiters, but if you select ,; as the delimiters, a,b,;c;d is a list of a and b and c and d with an empty list element (ignored) between b and c. In short, if you want to use a double char as a list delimiter, you're going to have to do it manually (or write your own UDFs to do it). CF doesn't handle it natively. --Ben Doom Programmer General Lackey Moonbow Software : -Original Message- : From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]] : Sent: Thursday, November 21, 2002 3:12 PM : To: CF-Talk : Subject: can't listappend w/ double pipe delimiter? : : : cfset request.mainNavigationList=listAppend( request.mainNavigationList, : oneOne|OneTwo , || ) : cfset request.mainNavigationList=listAppend( request.mainNavigationList, : twoOne|twoTwo , || ) : cfdump var=#request.mainNavigationList#brcfabort : : results in: : : oneOne|OneTwo|twoOne|twoTwo : : (single pipe in middle) : : but I want : : : oneOne|OneTwo||twoOne|twoTwo : : (double pipe in middle) : : I could work around by changing up the cfsets, but I would like : to know how : to listAppend with a double character delimeter. : : Thanks for any help. : Matthew P. Smith : Web Developer, Object Oriented : Naval Education Training Professional : Development Technology Center : (NETPDTC) : (850)452-1001 ext. 1245 : [EMAIL PROTECTED] : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Stored Proc list input
Server I have yet to find a way to pass a list to a stored procedure I found this a couple of days back; haven't tried it yet. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 19, 2002 12:52 PM To: CF-Talk Subject: Re: Stored Proc list input Likely you're going to run into a larger issue with your database not being able to interpret the @PassVariable value as an integer... at least with MS SQL Server I have yet to find a way to pass a list to a stored procedure without passing it as a varchar and then using exec (@mysqlstatement) or exec sp_executesql @mysqlstatement which somewhat defeats the purpose of the storedprocedure being pre-processed. I need to pass a string such as 1,2 in to a stored procedure. The variable is then used like this: Where MYVariable IN (@PassVariable) Now the problem is that MYVariable is an INT and I am passing in the @PassVariable as a string. I get this error: Syntax error converting the varchar value '1,2' to a column of data type int. I need to figure some way around this. Any ideas? Thanks, Neil S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
java cfx and administrator woes
I'm having a bit of trouble on the java side of things and was hoping someone could help. Two problems, actually, but I feel they may be related so I'll just throw them both out in the hopes that there may be a single solution to both. First, when ever I try to use any of the browse functionality within the cf administrator, the applet(it is an applet, right?) fails to load and instead displays an error message within the applet window, something similar to this: exception: java.lang.NoClassDefFoundError: netscape/application/Targ(cut off can't read) I've posted a screen shot: https://160.125.208.40/adminJavaError.jpg The problem only occurs in ie (6.0.2600.); netscape 4.7 works fine. I'm also having a problem getting cfx_rapidDiet to run as well. On my local install of mx (127.0.0.1:8500), it works without problem, but on the cf 5 server, it won't work. java.lang.ClassNotFoundException: rapidDiet. Java exception occurred in call to method. I've searched the macromedia forums pretty extensively. I didn't spot much on the administrator problem. The cfx problem has many posts, but most seem to be related to proper configuration settings for the jvm and class paths in administrator, which I think I have. I've tried just about every permutation, and restarted the service each time to test. Could the two be related? I just installed the latest Java SDK(j2sdk-1_4_0_02-windows-i586.exe), hoping it would help, but no dice. Any suggestions on what to try next? Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: java cfx and administrator woes
I looked over those listed here: http://www.macromedia.com/v1/Handlers/index.cfm?ID=20371Method=Full#50 The only one that seemed to remotely apply was: ColdFusion Server 5: Hot Fix for Applets When Using Java Plug-in Versions Greater Than 1.3.1_01a ( Article 23150 ) I installed as required but no change. Is there a different one I should try? Thanks, Matt -Original Message- From: Zac Spitzer [mailto:zac;datagear.net] Sent: Wednesday, November 13, 2002 9:43 AM To: CF-Talk Subject: Re: java cfx and administrator woes -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 | Any suggestions on what to try next? do you have the CF 5.0 hotfixes installed? z -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE90nMU1lRHdy8ASusRAi9WAJ9ij1hsFR9XDwft+/0YuoNW+2vt5QCfe+ok 1sqA4Y8fy51re9SfhR7mHJM= =NmnJ -END PGP SIGNATURE- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: java cfx and administrator woes
http://java.sun.com/getjava/installer.html the coffee is steaming, so I assume that means I have a good install? Matt -Original Message- From: Craig Dudley [mailto:craig;netstep.co.uk] Sent: Wednesday, November 13, 2002 9:51 AM To: CF-Talk Subject: RE: java cfx and administrator woes Your 1st problem sounds like a browser issue, does IE6 have a java plugin installed? Try testing it with other java applets? -Original Message- From: Smith, Matthew P -CONT(DYN) [mailto:Matthew.P.Smith;cnet.navy.mil] Sent: 13 November 2002 15:32 To: CF-Talk Subject: java cfx and administrator woes I'm having a bit of trouble on the java side of things and was hoping someone could help. Two problems, actually, but I feel they may be related so I'll just throw them both out in the hopes that there may be a single solution to both. First, when ever I try to use any of the browse functionality within the cf administrator, the applet(it is an applet, right?) fails to load and instead displays an error message within the applet window, something similar to this: exception: java.lang.NoClassDefFoundError: netscape/application/Targ(cut off can't read) I've posted a screen shot: https://160.125.208.40/adminJavaError.jpg The problem only occurs in ie (6.0.2600.); netscape 4.7 works fine. I'm also having a problem getting cfx_rapidDiet to run as well. On my local install of mx (127.0.0.1:8500), it works without problem, but on the cf 5 server, it won't work. java.lang.ClassNotFoundException: rapidDiet. Java exception occurred in call to method. I've searched the macromedia forums pretty extensively. I didn't spot much on the administrator problem. The cfx problem has many posts, but most seem to be related to proper configuration settings for the jvm and class paths in administrator, which I think I have. I've tried just about every permutation, and restarted the service each time to test. Could the two be related? I just installed the latest Java SDK(j2sdk-1_4_0_02-windows-i586.exe), hoping it would help, but no dice. Any suggestions on what to try next? Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: java cfx and administrator woes
at allaire.cfide.CFNavigation.init(CFNavigation.java:50) at netscape.application.Application.run(Application.java:233) at netscape.application.FoundationApplet.run(FoundationApplet.java:106) at java.lang.Thread.run(Thread.java:536) java.lang.NoClassDefFoundError: netscape/application/CheckButtonImage at netscape.application.ScrollBar.init(ScrollBar.java:127) at netscape.application.ScrollGroup.createScrollBar(ScrollGroup.java:235) at netscape.application.ScrollGroup.init(ScrollGroup.java:82) at allaire.controls.CFTree.init(CFTree.java) at allaire.controls.CFTree.init(CFTree.java) at allaire.cfide.CFDirectoryTree.init(CFDirectoryTree.java:34) at allaire.cfide.CFNavigation.init(CFNavigation.java:51) at netscape.application.Application.run(Application.java:233) at netscape.application.FoundationApplet.run(FoundationApplet.java:106) at java.lang.Thread.run(Thread.java:536) java.lang.NoClassDefFoundError: allaire/controls/CFTreeItem at allaire.controls.CFTree.init(CFTree.java) at allaire.controls.CFTree.init(CFTree.java) at allaire.cfide.CFDirectoryTree.init(CFDirectoryTree.java:34) at allaire.cfide.CFNavigation.init(CFNavigation.java:51) at netscape.application.Application.run(Application.java:233) at netscape.application.FoundationApplet.run(FoundationApplet.java:106) at java.lang.Thread.run(Thread.java:536) -Original Message- From: Rob Rohan [mailto:rob;cardinalweb.com] Sent: Wednesday, November 13, 2002 11:02 AM To: CF-Talk Subject: RE: java cfx and administrator woes When you hit the admin directory listing double click on the coffee cup by your clock on the taskbar. that might give a bit more info on what is happening. -Original Message- From: Smith, Matthew P -CONT(DYN) [mailto:Matthew.P.Smith;cnet.navy.mil] Sent: Wednesday, November 13, 2002 8:43 AM To: CF-Talk Subject: RE: java cfx and administrator woes http://java.sun.com/getjava/installer.html the coffee is steaming, so I assume that means I have a good install? Matt -Original Message- From: Craig Dudley [mailto:craig;netstep.co.uk] Sent: Wednesday, November 13, 2002 9:51 AM To: CF-Talk Subject: RE: java cfx and administrator woes Your 1st problem sounds like a browser issue, does IE6 have a java plugin installed? Try testing it with other java applets? -Original Message- From: Smith, Matthew P -CONT(DYN) [mailto:Matthew.P.Smith;cnet.navy.mil] Sent: 13 November 2002 15:32 To: CF-Talk Subject: java cfx and administrator woes I'm having a bit of trouble on the java side of things and was hoping someone could help. Two problems, actually, but I feel they may be related so I'll just throw them both out in the hopes that there may be a single solution to both. First, when ever I try to use any of the browse functionality within the cf administrator, the applet(it is an applet, right?) fails to load and instead displays an error message within the applet window, something similar to this: exception: java.lang.NoClassDefFoundError: netscape/application/Targ(cut off can't read) I've posted a screen shot: https://160.125.208.40/adminJavaError.jpg The problem only occurs in ie (6.0.2600.); netscape 4.7 works fine. I'm also having a problem getting cfx_rapidDiet to run as well. On my local install of mx (127.0.0.1:8500), it works without problem, but on the cf 5 server, it won't work. java.lang.ClassNotFoundException: rapidDiet. Java exception occurred in call to method. I've searched the macromedia forums pretty extensively. I didn't spot much on the administrator problem. The cfx problem has many posts, but most seem to be related to proper configuration settings for the jvm and class paths in administrator, which I think I have. I've tried just about every permutation, and restarted the service each time to test. Could the two be related? I just installed the latest Java SDK(j2sdk-1_4_0_02-windows-i586.exe), hoping it would help, but no dice. Any suggestions on what to try next? Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: java cfx and administrator woes
Thanks, that did it. I uninstalled every thing that had the word Java in it, rebooted, and it now works fine. Thanks for the help. RE: Navy LOL, no I'm just a contractor for a private company. My father was 28 years Navy, and I did a 2 year stint in the Army. As far as joining, it depends: If you haven't gone to college and CAN afford it, get the degree and go in as an officer. If you haven't gone to college and CAN'T afford it, go in for the minimum enlistment, grab the college cash, and run. If you already have a degree, go for it. Again, thanks to all for the help. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Rob Rohan [mailto:rob;cardinalweb.com] Sent: Wednesday, November 13, 2002 11:16 AM To: CF-Talk Subject: RE: java cfx and administrator woes I have seen this kind of thing before. Firstly, close all instances of your browsers (looks like Netscape from this). Then retry. If it still doesn't work, you make have a couple plugins installed on your machine. I have found browsers get very confused if this is the case. You can check it by looking in control panel. If you have more then one, uninstall ALL of them and reinstall only the one you want. Also if you have mozilla and Netscape 6/7 installed on the same windows box they seem to not like to get along. I was thinking about joining the navy. Do you like it? good luck rob -Original Message- From: Smith, Matthew P -CONT(DYN) [mailto:Matthew.P.Smith;cnet.navy.mil] Sent: Wednesday, November 13, 2002 9:08 AM To: CF-Talk Subject: RE: java cfx and administrator woes I was just looking for those... What's odd is that I have two of them, and there were three a little while ago. Is that normal, or is that indicative of a problem? Here's the console output; doesn't mean much to me, but maybe it will help someone: (long code) ava.lang.NoClassDefFoundError: netscape/application/Target at java.lang.ClassLoader.defineClass0(Native Method) at java.lang.ClassLoader.defineClass(ClassLoader.java:509) at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:123) at sun.applet.AppletClassLoader.findClass(AppletClassLoader.java:146) at sun.plugin.security.PluginClassLoader.findClass(PluginClassLoader.java:189 ) at java.lang.ClassLoader.loadClass(ClassLoader.java:306) at sun.applet.AppletClassLoader.loadClass(AppletClassLoader.java:112) at java.lang.ClassLoader.loadClass(ClassLoader.java:262) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:322) at java.lang.Class.getDeclaredConstructors0(Native Method) at java.lang.Class.privateGetDeclaredConstructors(Class.java:1576) at java.lang.Class.getConstructor0(Class.java:1748) at java.lang.Class.newInstance0(Class.java:266) at java.lang.Class.newInstance(Class.java:249) at sun.applet.AppletPanel.createApplet(AppletPanel.java:548) at sun.plugin.AppletViewer.createApplet(AppletViewer.java:1627) at sun.applet.AppletPanel.runLoader(AppletPanel.java:477) at sun.applet.AppletPanel.run(AppletPanel.java:290) at java.lang.Thread.run(Thread.java:536) java.lang.NoClassDefFoundError: netscape/application/CommandEvent at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:130) at allaire.cfide.CFNavigationApplet.classForName(CFNavigationApplet.java:38) at netscape.application.FoundationApplet.instantiateObjectOfClass(FoundationA pp let.java:222) at netscape.application.FoundationApplet.run(FoundationApplet.java:82) at java.lang.Thread.run(Thread.java:536) java.lang.NoClassDefFoundError: netscape/application/AWTComponentView at netscape.application.FoundationPanel.init(FoundationPanel.java:29) at netscape.application.FoundationApplet.createPanel(FoundationApplet.java:27 3) at netscape.application.FoundationApplet.setupCanvas(FoundationApplet.java:18 4) at netscape.application.Application.init(Application.java:120) at allaire.cfide.CFNavigation.init(CFNavigation.java) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAcc es sorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstr uc torAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:274) at java.lang.Class.newInstance0(Class.java:296) at java.lang.Class.newInstance(Class.java:249) at netscape.application.FoundationApplet.instantiateObjectOfClass(FoundationA pp let.java:223) at netscape.application.FoundationApplet.run(FoundationApplet.java:82) at java.lang.Thread.run(Thread.java:536
RE: Compare code on two pages...
That's what I use. A friend showed it to me and now I'm hooked. My 2 cents. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:Neil.Robertson- [EMAIL PROTECTED]] Sent: Tuesday, November 12, 2002 10:24 AM To: CF-Talk Subject: RE: Compare code on two pages... use WinDiff. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
mx local install gives administrator (almost) blank page
I've just installed MX locally, using the standalone web server. I did tell it to install the web files into a different directory(which it advised against). Now, when I bring up the administator page(http://127.0.0.1:8500/CFIDE/administrator/index.cfm) and login, after log in I get a partial page, just the top logo section. Anything I should check? t/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: mx local install gives administrator (almost) blank page
Ahh, thanks so much. It was actually that I had JavaScript disabled, same same. I had looked at the source code and only saw the head section, didn't even think to scroll down and look for JavaScript. Thanks so much for the help. -Original Message- From: S. Isaac Dealey [mailto:info;turnkey.to] Sent: Thursday, November 07, 2002 11:19 AM To: CF-Talk Subject: Re: mx local install gives administrator (almost) blank page I've just installed MX locally, using the standalone web server. I did tell it to install the web files into a different directory(which it advised against). Now, when I bring up the administator page(http://127.0.0.1:8500/CFIDE/administrator/index.cfm) and login, after log in I get a partial page, just the top logo section. Anything I should check? Turn off any popup-killers on your machine. The admin page is wanting to prompt to copy your settings from your CF 5 install to your new MX install, but it's in a popup window, so that's why you don't see it. S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
deleteclientvariable on mx not working?
I'm downloading the mx cfml reference now, but I figured I would fire this off in case anyone knows the answer. I'm sure it is something obvious, but I can't find it. I'm trying to delete a client variable, but it doesn't seem to be working. It works fine on my local box, which is cf5. But when I upload the same app to our MX development server, the client variable is not deleted when it is supposed to be, which is(obviously) causing problems. Does anyone have an idea where it is going wrong? cfif isDefined(client.wddxFormBuffer) cfwddx action=WDDX2CFML input=#client.wddxFormBuffer# output=attributes cfset DeleteClientVariable(wddxFormBuffer) /cfif I have also tried the following: cfset tmp = DeleteClientVariable(wddxFormBuffer) cfset tmp = DeleteClientVariable(client.wddxFormBuffer) Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: deleteclientvariable on mx not working?
That's what gets me: If I try to output it immediately afterwards in that section of code, it throws an undefined error, as it should. But on the recursive call, even though the delete was run on the client variable, it is defined. Here's some more code so you can get an idea what I'm trying to do. Remember, it works perfectly on CF5. cfif notLoggedIn and not fusebox.isCustomTag !--- preserve their formfields if they just submitted a form --- cfif isDefined(form.fieldNames) cfwddx action=CFML2WDDX input=#attributes# output=client.wddxFormBuffer /cfif cfset client.authenticationReturnFuseAction = #attributes.fuseaction# cflocation addtoken=No url=#self#/fuseaction/authentication.go/index.cfm /cfif cfif isDefined(client.wddxFormBuffer) cfoutputI am still defined/cfoutput cfwddx action=WDDX2CFML input=#client.wddxFormBuffer# output=attributes cfset DeleteClientVariable(wddxFormBuffer) !--- throws error if uncommented --- !--- #client.wddxFormBuffer# --- /cfif -Original Message- From: Adrian Lynch [mailto:adrian.l;thoughtbubble.net] Sent: Monday, November 04, 2002 10:18 AM To: CF-Talk Subject: RE: deleteclientvariable on mx not working? I use DeleteClientVariable() alot and it works ok. Try out putting the var after you delete it. cfif isDefined(client.wddxFormBuffer) cfwddx action=WDDX2CFML input=#client.wddxFormBuffer# output=attributes cfset DeleteClientVariable(wddxFormBuffer) cfoutput#CLIENT.wddxFormBuffer#/cfoutput cfabort /cfif That way you can be sure if it's being deleted or not, chances are it's just being created elsewhere. Ade -Original Message- From: Smith, Matthew P -CONT(DYN) [mailto:Matthew.P.Smith;cnet.navy.mil] Sent: 04 November 2002 15:55 To: CF-Talk Subject: deleteclientvariable on mx not working? I'm downloading the mx cfml reference now, but I figured I would fire this off in case anyone knows the answer. I'm sure it is something obvious, but I can't find it. I'm trying to delete a client variable, but it doesn't seem to be working. It works fine on my local box, which is cf5. But when I upload the same app to our MX development server, the client variable is not deleted when it is supposed to be, which is(obviously) causing problems. Does anyone have an idea where it is going wrong? cfif isDefined(client.wddxFormBuffer) cfwddx action=WDDX2CFML input=#client.wddxFormBuffer# output=attributes cfset DeleteClientVariable(wddxFormBuffer) /cfif I have also tried the following: cfset tmp = DeleteClientVariable(wddxFormBuffer) cfset tmp = DeleteClientVariable(client.wddxFormBuffer) Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Big Trouble in T-SQL land
Try turning the NOCUNT OFF right before the SELECT * FROM ##xyz then back on for the drop? Just a SWAG, perhaps it is similar to resultsets from stored procedures... Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Rob Rohan [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 12:21 PM To: CF-Talk Subject: Big Trouble in T-SQL land This move to MX has been quite the learning experience. Now, we seem to be unable to create temporary tables. The following query returns 0 records in CFMX but 1 record in query analyzer. Anyone else? Suggestions? Glass of hemlock? CFQUERY NAME=test DATASOURCE=foobardb DBTYPE=ODBC SET NOCOUNT ON CREATE TABLE ##xyz (a varchar(10)) INSERT INTO ##xyz ( a )VALUES ( 'foo' ) SELECT * FROM ##xyz DROP TABLE ##xyz SET NOCOUNT OFF /CFQUERY We are using MX with SQL 7. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Recall: Big Trouble in T-SQL land
Smith, Matthew P -CONT(DYN) would like to recall the message, Big Trouble in T-SQL land. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Big Trouble in T-SQL land
Try turning the NOCOUNT OFF right before the SELECT * FROM ##xyz then back on for the drop? Just a SWAG, perhaps it is similar to resultsets from stored procedures... Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Rob Rohan [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 12:21 PM To: CF-Talk Subject: Big Trouble in T-SQL land This move to MX has been quite the learning experience. Now, we seem to be unable to create temporary tables. The following query returns 0 records in CFMX but 1 record in query analyzer. Anyone else? Suggestions? Glass of hemlock? CFQUERY NAME=test DATASOURCE=foobardb DBTYPE=ODBC SET NOCOUNT ON CREATE TABLE ##xyz (a varchar(10)) INSERT INTO ##xyz ( a )VALUES ( 'foo' ) SELECT * FROM ##xyz DROP TABLE ##xyz SET NOCOUNT OFF /CFQUERY We are using MX with SQL 7. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: SQL Server Backup
Check BOL for transactional replication My dba's have it set up. As I understand it, every transaction is replicated from a publisher to subscribers. Basically what you are looking for, I think. They set it up so I'm not very knowledgeable about it. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 2:47 PM To: CF-Talk Subject: SOT:SQL Server Backup Does anyone know off hand if there is a tool or if SQL Server has this built in where you can replicate what's on one DB Server to a second DB Server? We need to build a failover server as a backup to our SQL Server System but want all the data on the backup server to be in synch with the main server. I know Win2k has the briefcase thing where you can sync up folders, but that seems to be a bit for just a typical end user, I'm guessing where SQL Server is enterprise level that it may have something built in? Thanks, Ben Ben Densmore Web Developer eSupport.com,Inc. 1538 Turnpike St. North Andover, MA 01845 Phone: (978) 686-6468 x333 Email: [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: QofQ and dates...(FIXED)
Does cfqueryparam speed up QofQ as it does with a normal db query? I would
think not, but it would be cool if it did. Just curios if anyone knows...
Matthew P. Smith
Web Developer, Object Oriented
Naval Education Training Professional
Development Technology Center
(NETPDTC)
(850)452-1001 ext. 1245
[EMAIL PROTECTED]
-Original Message-
From: John Beynon [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 01, 2002 9:57 AM
To: CF-Talk
Subject: RE: QofQ and dates...(FIXED)
Using CFQUERYPARAM fixed the problem,
Query becomes:
!--- filter the recordset ---
cfquery name=FilteredBlogArticles dbtype=query
Select * from BlogArticles
where (articledate = cfqueryparam cfsqltype=cf_sql_date
value=#CreateODBCDate(targetdate)#)
order by articledate DESC
/cfquery
-Original Message-
From: John Beynon [mailto:[EMAIL PROTECTED]]
Sent: 01 October 2002 15:29
To: CF-Talk
Subject: RE: QofQ and dates...
Still bitchessame error message - but the SQL at the bottom of the
page
changes to:
SQLSelect * from BlogArticles where articledate = {d
apos;2002-09-24apos;} order by articledate DESC
What's with the apos; stuff?
-Original Message-
From: Mike Townend [mailto:[EMAIL PROTECTED]]
Sent: 01 October 2002 15:25
To: CF-Talk
Subject: RE: QofQ and dates...
Try adding a createodcdate around it...
cfset FilterDate = dateadd('d', arguments.AgeArticlesOnHomePage,
now())
cfquery name=FilteredBlogArticles dbtype=query
Select * from BlogArticles
where articledate = #CreateODBCDate(FilterDate)#
order by articledate DESC
/cfquery
HTH
-Original Message-
From: John Beynon [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 1, 2002 15:19
To: CF-Talk
Subject: QofQ and dates...
should i be able to do date comparisons in a QofQ?
i'm using:
cfset FilterDate = #dateadd('d', #arguments.AgeArticlesOnHomePage#,
now())#
!--- filter the recordset ---
cfquery name=FilteredBlogArticles dbtype=query
Select * from BlogArticles
where articledate = #FilterDate#
order by articledate DESC
/cfquery
and getting:
Query Of Queries syntax error.
Encountered articledate = { at line 3, column 31. Incorrect conditional
expression, Expected one of [like|null|between|in|comparison] condition,
returned. Also just noticed:
SQL Select * from BlogArticles where articledate = {ts
apos;2002-09-24 15:12:35apos;} order by articledate DESC
Please try the following:
tucked away at the bottom of the page
thanks for the help,
jb.
* [EMAIL PROTECTED] * +44 (0)1372 367147 * http://www.era.co.uk/
http://www.era.co.uk/
*
Copyright ERA Technology Ltd. 2002. (www.era.co.uk). All rights reserved.
The information supplied in this email should be treated in confidence. No
liability whatsoever is accepted for any loss or damage
suffered as a result of accessing this message or any attachments.
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Strange threading issue, cflock?
cfloop condition=(#datediff('S', tick, now())# LT 5)/cfloop
Loops like that spike to 100% cpu utilization, not a good method. You can
use a tag like cfx_sleep, or the deadlock timeout, which is great on hosts
that charge for cfx component installation/use.
Matthew P. Smith
Web Developer, Object Oriented
Naval Education Training Professional
Development Technology Center
(NETPDTC)
(850)452-1001 ext. 1245
[EMAIL PROTECTED]
-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 23, 2002 3:21 PM
To: CF-Talk
Subject: Re: Strange threading issue, cflock?
On 9/23/02, jon hall penned:
Using CF5, I have a database insert that I need to pause a few
seconds, then select a value back out that is updated from withing
the db. My code looks something like this:
cfquery .../ // Insert Query
cfset name = Hash(CreateUUID())/
cflock name=#name# type=readonly timeout=1
cflock name=#name# type=exclusive timeout=5
throwontimeout=No/cflock
/cflock
cfquery .../ // Select Query
What is strange is that the second query is not executing after the
cflock times out. It seems that it must be executing _before_ the
cflock starts! The database usually takes about 1 second to update
the field, and even if I set the timeout to 20 seconds the recordset
returned always contains data that would indicate that the query
didn't wait until the cflock timed out, but executed before the
cflock...
I'm not exactly sure if I'm reading your post correctly, but if you
simply want some code to delay executing for a set amount of time,
you can use a conditional loop. CFLOCK doesn't actually lock the code
at that point for the timeout value. The timeout value is how long CF
will wait until either throwing an error or moving on to the next
section of code.
In the same below, the Select query will run 5 seconds after the Code
to activate database Update.
cftry
cflock name=mylockname timeout=10 type=exclusive
throwontimeout=yes
cfset tick = now()
Code to activate database Update begins at
CFOUTPUT#TimeFormat(tick, h:mm:ss)#/CFOUTPUTp
cfloop condition=(#datediff('S', tick, now())# LT 5)/cfloop
Select query runs at CFOUTPUT#TimeFormat(now(), h:mm:ss)#/CFOUTPUT
/cflock
cfcatch type=lock
The process timed out. Try again.
/cfcatch
/cftry
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Add Column to Query...
Word of warning, though, you will have to loop through the record set and add the value one record at a time. Not a big deal for small stuff, but I ran into the same problem and it was prohibitively slow with a large (5000+) records. Always better to let the db do stuff like that if possible. OR Is if possible to do every column at once? I've tried QofQ, but that doesn't allow update statements, which would be super. Or is there to do a querySetCell(), but have if affect all records, and have it set it to each records information like SET col3 = col1 + col2 Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 12:09 PM To: CF-Talk Subject: Re: Add Column to Query... That looks very promising! and jeeze... right under my nose the whole time. That's embarrassing. Thanks Jochem At 01:53 AM 9/23/02, you wrote: Brian Scandale wrote: How do I go about adding a column to a query dataset? QueryAddColumn()? Jochem __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Add Column to Query...
But to populate the array with concatenated values you would still have to loop through the record set, I would think? I'm sure it would depend on what you were trying to do. Matt -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 1:29 PM To: CF-Talk Subject: Re: Add Column to Query... Smith, Matthew P -CONT(DYN) wrote: Word of warning, though, you will have to loop through the record set and add the value one record at a time. You can add an entire column at once, you just need to have an array with the right values. Jochem __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cflocking de-mystified (was RE: WHYYYYY!!!!!!)
But if you access two variables in the same scope(ie session) at the same time because of different names, can't that cause corruption? Also, readonly locks are simply pointers; the only time they are locked down is during an exclusive lock as used during a write. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Jason Egan [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 12:06 PM To: CF-Talk Subject: RE: cflocking de-mystified (was RE: WHY!!) Right - I use the name attribute for cflock rather than scope (occasionally) because my understanding is that when you lock on the scope you Lock the entire scope down for that transaction -- if you use names, then they are all (potentially) unique and you won't have a usually fast process waiting on a slow process - essentially denying client access because of scope locking... Jason CFDynamics.com -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 7:53 AM To: CF-Talk Subject: cflocking de-mystified (was RE: WHY!!) my man, My Man! thank you dave. that's probably the funniest thing I have read this morning and the most informative email I have gotten in a long time in regards to locking (kinda wish I'd made it to the locking session last year @ devcon) but anyway, it makes sense, plain and well done. thank you! ps...i implemented this into my code @ my office @ my real job this morning, and things are humming along now, I guess my next question would be, is the cflock timeout sort of an arbitrary guess as to what would be a good amount of time? I mean, how long are the lock timeouts on the heaviest hit cf pages set for? whats a good number? ...tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 1:52 AM To: CF-Talk Subject: RE: WHY!! i havent used locks on session vars, havent needed to, and having never formally learned cf, not really 100% down with the thought process behind locking session var setting... The thought process is very simple. If you're running CF 5 or earlier, and you're using session variables, and you don't lock them, bad things will happen. Memory variables can be accessed by concurrent requests, and CF doesn't handle that well, by default. While you might not think session variables would be used by concurrent requests, there are many possible cases in which more than one request from the same user might be running concurrently. any good books on that topic? A book would be overkill, just for this topic. If you're using CF 5 or earlier, just follow these simple rules: 1. Dvery time you put Session, Application or Server in your code, use CFLOCK around it. 2. If you're using any version of CF which supports the SCOPE attribute (4.5+, I think), use that with your CFLOCK tags around memory variables. 3. If you're reading a memory variable, use TYPE=READONLY in your CFLOCK; if you may change the variable's value, use TYPE=EXCLUSIVE. 4. There is no rule 4. 5. Reread rule 1. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 : dream :: design :: develop : MXDC 02 :: Join us at this all day conference for designers developers to learn tips, tricks, best practices and more for the entire Macromedia MX suite. September 28, 2002 :: http://www.mxdc02.com/ (Register today, seats are limited!) :: __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SOT : javascript, onchange, and noscript
In a shopping cart, for each item's quantity I have a select box that allows them to set it to 0 to remove, or to a different amount to adjust the quantity they have for the item. I would like to use onchange=document.cartForm.submit() on each select box for those with javascript enabled, but would like to have a update cart submit button for those that don't have javascript. I would like to hide the update cart for those that have JS as they shouldn't need it. Can noscript be used in this capacity, down in the page rather than in the head, and are there any problems I'm not seeing? Thanks! __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Multiple Inserts
You can do a lot: cfquery name=qry_allTaxologyKeysBelow connectstring=#request.dbConnectionString# dbtype=dynamic SET NOCOUNT ON DECLARE @tblVar#listFirst(GetFileFromPath(GetCurrentTemplatePath()), .)# TABLE ( tablePK int identity(1,1), tblProductTaxologyPK varchar(10) ) DECLARE @continue int INSERT INTO @tblVar#listFirst(GetFileFromPath(GetCurrentTemplatePath()), .)# SELECT tblProductTaxologyPK FROM#request.sqlObjectPrefix#tblProductTaxology WHERE parentFK = cfqueryparam value=#attributes.taxologyKeyList# cfsqltype=CF_SQL_INTEGER SET @continue = @@ROWCOUNT WHILE @continue 0 BEGIN INSERT INTO @tblVar#listFirst(GetFileFromPath(GetCurrentTemplatePath()), .)# SELECT tblProductTaxologyPK FROM #request.sqlObjectPrefix#tblProductTaxology WHERE parentFK IN ( SELECT DISTINCT tblProductTaxologyPK FROM @tblVar#listFirst(GetFileFromPath(GetCurrentTemplatePath()), .)# ) AND tblProductTaxologyPK NOT IN ( SELECT DISTINCT tblProductTaxologyPK FROM @tblVar#listFirst(GetFileFromPath(GetCurrentTemplatePath()), .)# ) SET @continue = @@ROWCOUNT END SET NOCOUNT OFF SELECT * FROM @tblVar#listFirst(GetFileFromPath(GetCurrentTemplatePath()), .)# /cfquery -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 12:37 PM To: CF-Talk Subject: OT: Multiple Inserts Can you do multiple insert statements in one CFQUERY statement? ie cfquery ... Insert into Insert Into ... Insert Into ... /cfquery If yes, is there something special that needs to be added? Thanks Paul Giesenhagen QuillDesign __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Returning columns with null values when specific columns are unknown at runtime
Always for a single record at a time? -Original Message- From: Patti G. L. Hall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 10:58 AM To: CF-Talk Subject: Re: Returning columns with null values when specific columns are unknown at runtime Sorry, but you made the same mistake that simon did. I don't want to return select * I want to return select (only columns that are null and I don't know what they are up front) where primarykey = some number I didin't actually have any questions regarding the where statement at all. I'm aware that I'll probably have to use the whole IS NULL dealie... but where I'm stuck is how do I selectively return columns when I don't know which columns fit my criteria (containing null values only). Thanks - Patti - Original Message - From: Candace Cottrell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 11:23 AM Subject: Re: Returning columns with null values when specific columns are unknown at runtime How about this or am I still missing something Select * from TABLENAME WHERE col1 IS NULL OR col2 IS NULL OR col3 IS NULL OR col4 IS NULL Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] [EMAIL PROTECTED] 9/18/2002 11:17:41 AM Thanks, but that doesn't get me where I want. I ONLY want to return the columns that ARE null, and I never know which ones those are when I run this query... so what I need is something for the select statement. -Patti - Original Message - The only thing I can think to do is create a bunch of OR statements i.e.: WHERE colA IS NULL OR colB IS NULL OR colN IS NULL ~Simon -Original Message- Is there a way to write a MSSQL 2k query that will return a result set that contains only columns with null values when you don't know explicitly which columns those will be? So if I have this data pk | col 1 | col 2 | col 3 | col 4| 1 1 2nullnull 2null4 nullnull I'd like a query that would return col 3 and col 4 where pk = 1 or col 1, col 3 and col 4 where pk=2. Is this possible? -Patti __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Not in?
I think there is better performance, and only one db call, by doing a left outer join on the table you want all records from and adding where table2column is not null. That is, of course, unless they are the same table, but you could self-join the table with the same technique... Why two recordsets instead of two tables? -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 12:20 PM To: CF-Talk Subject: RE: Not in? A simple way of doing this would be: select firstname from tableA where recordid not in (select recordid from TableB) You may want look into a join depending on the use. Mark W. Breneman -Macromedia Certified ColdFusion Developer -Network / Web Server Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 11:46 AM To: CF-Talk Subject: Not in? I have 2 queries one that contains the enitre recordset of the table and 1 that contains my flagged results. What I need to do is find a way to display all of the records that aren't part of query #2's recordset. Please help KP Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT - MS SQL help
Is it possible to join two tables, and have a list of keys returned from one of the tables as a column of a recordset? tblOnePK| name 1 | threeFriends tableTwoPK | tblOneFK 1 | 1 2 | 1 3 | 1 And the record set should be: tblOnePK| name| listOfKeys 1 | threeFriends| 1,2,3 Make sense? I could do it programmatically in CF, but would like to pull this in one query and avoid a recordset/requery loop. Also, can't use a stored proc, unfortunately. Thanks for any help. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: List to stored proc
T-SQL is really a pain to do string manipulation in, especially after being
spoiled by all the great functions CF has. You can do quite a few things,
though, you just have to works a bit harder with them.
Here's how to loop through a list:
CREATE PROCEDURE showLoop
@listOfKeys VARCHAR(100) = '1,2,3,4,5,6,7,8,9'
AS
-- This is used to locate each separator character
DECLARE @delimiterPosition INT
-- This holds each condition value from the list as it is returned
DECLARE @currentValue INT
DECLARE @delimiter CHAR (1)
SET @delimiter = ','
-- Loop through the string searching for separator characters
WHILE patindex('%' + @delimiter + '%' , @listOfKeys) 0
BEGIN
-- patindex matches the pattern against a string
SET @delimiterPosition = patindex('%' + @delimiter + '%' ,
@listOfKeys)
-- Pull the value of the current position
SET @currentValue = left(@listOfKeys, @delimiterPosition -
1)
-- print current value, this is where you would do what you
want
PRINT @currentValue
-- This replaces what we just processed with an empty
string, removing it from a list
SET @listOfKeys = stuff(@listOfKeys, 1, @delimiterPosition,
'')
END
GO
Matthew P. Smith
Web Developer, Object Oriented
Naval Education Training Professional
Development Technology Center
(NETPDTC)
(850)452-1001 ext. 1245
[EMAIL PROTECTED]
-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 10, 2002 8:13 AM
To: CF-Talk
Subject: RE: List to stored proc
I have a similar question...
in the stored proc, say you pass in a comma delimited list, how do you
break it apart?
Are there list functions within T-SQL?
Mike
-Original Message-
From: Joe Eugene [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 10, 2002 9:01 AM
To: CF-Talk
Subject: Re: List to stored proc
You can pass the whole String(List) into the StroredProc.. just as
VARCHAR
depends on what you want to do with the LIST...
put into different fields.. u have split it in the stored proc..
Joe
- Original Message -
From: Tipton Josh (orl1jdt) [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, September 10, 2002 7:39 AM
Subject: List to stored proc
I have a comma delimited list that I want to pass into a procedure. Any
help. I am using nvarchar(4000) as the data type but I get invalid cast
spec.
Josh
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Big problem- session vars not saved in IE6 on CF5
This has come up a few times in discussion. I think we really need a good solution for the p3p policy and cold fusion, as I feel this is the root of the problem. P3p enforcement might be adopted by other(all) browers down the line, so it would probably be a good idea to get it solved now. I wonder if we could come up with a generic p3p policy document that people could incorporate into their site to allow the cookies we need for our CF apps? Funny thing is, asp.net apps have absolutely no problem placing their cookies. Who woulda guessed? Here's a good thread about the issue: http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=3threadid= 230279highlight_key=ykeyword1=cookieskeyword2=p3p Anyone know of a good tutorial to get p3p implemented? I really don't want to know the ins and outs, just get around the default ie6 settings... I guess that was what I was alluding to above. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 9:44 AM To: CF-Talk Subject: RE: Big problem- session vars not saved in IE6 on CF5 There seems to be a bug the Internet Explorer 6 privacy settings. Despite significantly lax restrictions, we have had a lot of problems with IE 6 users and sites that use cookies to track sessions. In troubleshooting the issue, we've attempted to add P3P privacy policies to our sites. We have tried altering the domain attribute on the cookies. We tried just about everything we could think of. The only workaround that we've found is to have the client add the site to their list of allowed sites (In the Web Sites section of the Privacy tab). This fixes the problem in every instance we've encountered. This is reasonably good work around for Intranet/Extranet sites. Obviously, however, it is not so good for public Internet sites. So far, we've left these sites broken and simply pointed our fingers at Microsoft. So, if someone has a true fix, please share it. Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 5:32 AM To: CF-Talk Subject: RE: Big problem- session vars not saved in IE6 on CF5 And you know what - I'm debugging an app that used to work but doesn't anymore since the other day! Darn M$ Jb. -Original Message- From: Sandy Clark [mailto:[EMAIL PROTECTED]] Sent: 29 August 2002 02:23 To: CF-Talk Subject: RE: Big problem- session vars not saved in IE6 on CF5 I had the exact same problem this week when I upgraded my ie6 with the newest M$ patches. I have a form, which sends a login page to a script. Because the login page uses a submit button, the cookies for CFID and CFTOKEN would normally be set there. After processing, the login script cflocations the person to a new page. The funny thing is that I am not using CFLocation, but the Fusebox CF_Location tag which was not cookie problematic. The app works fine on Opera, Netscape 4.x and 6.2 as well as on IE 6. The application was definitely losing cookies, I cfdumped all session variables and http_cookie changed each time. My ultimate solution was to pass (during the first CF_Location only), the CFID and CFTOKEN on the URL. After that I don't pass them and the application works fine. I checked all my settings in IE 6 and they were all accepting cookies. Very weird. Any other better solutions (or even better rational explanations for the problem) would be much appreciated. Sandy Clark -Original Message- From: Kym Kovan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 8:14 PM To: CF-Talk Subject: Re: Big problem- session vars not saved in IE6 on CF5 Hi Don, I am having a big problem with an old standard login system. This is the most simple login system I know and have used it for years. It consists of: Login form page Login action page Main page Session variables tracking who is logged in The user enters in their login acct, the action page compares it against the db, then sets some session variables and uses cflocation to forward them to a new page or back to the login page if they fail. The application page checks for the session variable to see if they're logged in and uses cflocation to send them back to the login page if the var doesn't exist. I am slightly surprised that this has ever worked if I understand it correctly. Session and Client variables normally use cookies to control themselves, if not you have to use CFID and CFToken in your URLs. cflocation has a proviso that if you use it then any cookies set in the page before the cflocation tag will _not_ actually get sent to the browser under normal circumstances. This means that if you have a cflocation in your initial entry then your session may not well
get cfpplication name?
Is there any way to output the value of the application created with the cfapplication tag from within an app's template? CFAPPLICATION name=FOO I want to get FOO. Thanks. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
unresponsive threads crashing cf
I am having a problem with unresponsive threads crashing the server. It seems that they are not being released even after they exceed the timeout specified in cf administrator(90 seconds). It took over 37 minutes for the same template to generate unresponsive threads. Why doesn't CF drop them when they exceed the time limit? Information,238,08/28/02,05:52:49,,The ColdFusion Application Server started. Warning,88,08/28/02,06:53:12,,Template: D:\Inetpub\wwwroot\webServices\deersValidation.cfm, Ran: 101 seconds. Warning,304,08/28/02,06:53:13,,Template: D:\Inetpub\wwwroot\foo\dverify.cfm, Ran: 102 seconds. Warning,426,08/28/02,07:06:19,,A request exceeded the timeout. The unresponsive thread count is up to 1. [D:\Inetpub\wwwroot\foo\dverify.cfm] Error,426,08/28/02,07:06:19,, !! CFTrace::logThread(304) has no entry for thread 304 Warning,426,08/28/02,07:12:19,,A request exceeded the timeout. The unresponsive thread count is up to 2. [D:\Inetpub\wwwroot\Cantrac\dverify.cfm] Error,426,08/28/02,07:12:19,, !! CFTrace::logThread(324) has no entry for thread 324 Warning,426,08/28/02,07:16:49,,A request exceeded the timeout. The unresponsive thread count is up to 3. [D:\Inetpub\wwwroot\foo\dverify.cfm] Error,426,08/28/02,07:16:49,, !! CFTrace::logThread(88) has no entry for thread 88 Warning,426,08/28/02,07:18:19,,A request exceeded the timeout. The unresponsive thread count is up to 4. [D:\Inetpub\wwwroot\foo\dverify.cfm] Error,426,08/28/02,07:18:19,, !! CFTrace::logThread(464) has no entry for thread 464 Warning,426,08/28/02,07:21:19,,A request exceeded the timeout. The unresponsive thread count is up to 5. [D:\Inetpub\wwwroot\Cantrac\dverify.cfm] Error,426,08/28/02,07:21:19,, !! CFTrace::logThread(327) has no entry for thread 327 Warning,426,08/28/02,07:43:49,,A request exceeded the timeout. The unresponsive thread count is up to 6. [D:\Inetpub\wwwroot\foo\dverify.cfm] Error,426,08/28/02,07:43:49,, !! CFTrace::logThread(568) has no entry for thread 568 Warning,426,08/28/02,07:55:49,,A request exceeded the timeout. The unresponsive thread count is up to 7. [D:\Inetpub\wwwroot\Cantrac\dverify.cfm] Error,426,08/28/02,07:55:49,, !! CFTrace::logThread(129) has no entry for thread 129 Warning,554,08/28/02,07:56:44,,Template: D:\Inetpub\wwwroot\webServices\deersValidation.cfm, Ran: 210 seconds. Information,129,08/28/02,07:56:45,,A long-running request returned. The unresponsive thread count is down to 6. [D:\Inetpub\wwwroot\foo\dverify.cfm]. Warning,129,08/28/02,07:56:45,,Template: D:\Inetpub\wwwroot\foo\dverify.cfm, Ran: 211 seconds. Warning,426,08/28/02,08:00:19,,A request exceeded the timeout. The unresponsive thread count is up to 7. [D:\Inetpub\wwwroot\foo\dverify.cfm] Error,426,08/28/02,08:00:19,, !! CFTrace::logThread(308) has no entry for thread 308 Warning,426,08/28/02,08:04:49,,A request exceeded the timeout. The unresponsive thread count is up to 8. [D:\Inetpub\wwwroot\foo\dverify.cfm] Error,426,08/28/02,08:04:49,, !! CFTrace::logThread(554) has no entry for thread 554 Warning,426,08/28/02,08:07:49,,A request exceeded the timeout. The unresponsive thread count is up to 9. [D:\Inetpub\wwwroot\foo\dverify.cfm] Error,426,08/28/02,08:07:49,, !! CFTrace::logThread(129) has no entry for thread 129 Fatal,426,08/28/02,08:09:19,,Unresponsive thread threshold reached. Restarting service. Information,177,08/28/02,08:09:23,,The ColdFusion Application Server started. (ETC) The template uses a custom tag call that does a cfhttp call to another template on the same server, trying my hand at a pseudo web service. Basically: 1. Template calls custom tag for validation. 2. Custom tag calls (local/same cf server) web service url 3. Web service url/template checks if local cache(ms sql db) if user validation expired. If not expired and validates properly, returns 1. 4. If expired: Calls a third party web service, which we validate against. Validation fails, return 0 Validation succeeds, insert to local db cache, return 1 I hope that makes sense. Could that cause problems? I would guess that it would take two threads as one template calls another... But that shouldn't be to bad. We've tried tweaking cf administrator a bit, but we're not really sure which setting to play with. Thanks for any help. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: unresponsive threads crashing cf
Thanks for the response. I have done some research online, both with Google and on the Macromedia Forums. http://www.macromedia.com/v1/handlers/index.cfm?ID=22707Method=FullPageCal l=/support/index.cfm Above states that the error no entry for thread is harmless. However, is seems directly related to the unresponsive threads, although I think this is really just a symptom. As far as the why they take so long: Well, when the validation is cached locally, it only takes 0 to 30 ms. The remote call to the third party web service seems to be hit or miss, and that's where the delay seems to be occurring. It was only taking 6 seconds most of the time, although it would slow once in a while. What bothers me is two things: 1. It seems the templates are being allowed to exceed the timeout in CF administrator, CF administrator setting: Timeout requests after 90 seconds Warning,304,08/28/02,06:53:13,,Template: D:\Inetpub\wwwroot\foo\dverify.cfm, Ran: 102 seconds. 2. It also seems to be ignoring the cfhttp timeout attribute (timeout=90) When a request is made, does that take an entire thread until the request is finished processing? Why aren't the threads being reallocated after the 90 second timeout? As you can see, the first unresponsive thread remained in the count for 37 minutes. It would seem CF should be able to reuse this thread once the request times out I will try to adjust the unresponsive requests. This is a bit of an old server, especially for production. But on a single processor, allocated 3 threads, it would reboot after only 1 or two by your recommendations. That would seem to just make the server restart more often in this case. ; ) The CFadmin default setting makes the restart number greater than the total number of threads, so CF never restarts even if all threads are unresponsive. CF admin settings: Limit simultaneous requests to 10 Restart at 10 unresponsive requests What is the difference between a thread and a request? Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Chris Norloff [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 12:14 PM To: CF-Talk; [EMAIL PROTECTED] Subject: Re: unresponsive threads crashing cf Search the Macromedia knowledge base, I think there's information there about CF admin settings. Also, search on information about how CF handles threads. You need to find why your .cfm templates are running so slowly - that's what's killing you. It sounds like the restart at X number of unresponsive threads is set too low. Generally that should be 80% of the number of threads. The number of threads should be about 3 to 5 per processor. The CFadmin default setting makes the restart number greater than the total number of threads, so CF never restarts even if all threads are unresponsive. Chris Norloff -- Original Message -- from: Smith, Matthew P -CONT(DYN) [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Wed, 28 Aug 2002 10:30:22 -0500 I am having a problem with unresponsive threads crashing the server. It seems that they are not being released even after they exceed the timeout specified in cf administrator(90 seconds). It took over 37 minutes for the same template to generate unresponsive threads. Why doesn't CF drop them when they exceed the time limit? Information,238,08/28/02,05:52:49,,The ColdFusion Application Server started. Warning,88,08/28/02,06:53:12,,Template: D:\Inetpub\wwwroot\webServices\deersValidation.cfm, Ran: 101 seconds. Warning,304,08/28/02,06:53:13,,Template: D:\Inetpub\wwwroot\foo\dverify.cfm, Ran: 102 seconds. Warning,426,08/28/02,07:06:19,,A request exceeded the timeout. The unresponsive thread count is up to 1. [D:\Inetpub\wwwroot\foo\dverify.cfm] Error,426,08/28/02,07:06:19,, !! CFTrace::logThread(304) has no entry for thread 304 Warning,426,08/28/02,07:12:19,,A request exceeded the timeout. The unresponsive thread count is up to 2. [D:\Inetpub\wwwroot\Cantrac\dverify.cfm] Error,426,08/28/02,07:12:19,, !! CFTrace::logThread(324) has no entry for thread 324 Warning,426,08/28/02,07:16:49,,A request exceeded the timeout. The unresponsive thread count is up to 3. [D:\Inetpub\wwwroot\foo\dverify.cfm] Error,426,08/28/02,07:16:49,, !! CFTrace::logThread(88) has no entry for thread 88 Warning,426,08/28/02,07:18:19,,A request exceeded the timeout. The unresponsive thread count is up to 4. [D:\Inetpub\wwwroot\foo\dverify.cfm] Error,426,08/28/02,07:18:19,, !! CFTrace::logThread(464) has no entry for thread 464 Warning,426,08/28/02,07:21:19,,A request exceeded the timeout. The unresponsive thread count is up to 5. [D:\Inetpub\wwwroot\Cantrac\dverify.cfm] Error,426,08/28/02,07:21:19,, !! CFTrace::logThread(327) has no entry for thread 327 Warning,426,08/28/02,07:43:49
RE: programmer vs. developer
About $30-50k a year. ; ) -Original Message- From: Phoeun Pha [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 12:42 PM To: CF-Talk Subject: programmer vs. developer whats the difference? __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Many or Minimal CFOUTPUTS
I find that it is easier to just put a cfoutput at the top and bottom of my pages. Query output is just a cfloop query=. I'm not really sure if it makes that much of an impact on performance, but it definitely makes the code a lot cleaner to read and maintain(for me at least). Not hunting down those why didn't this work, (view source), oh, forgot to cfoutput this section, rinse, repeat during development. One less thing to worry about. I would think that it might take the first run/compiling a little slower, as the engine would have to parse through a lot of irrelevant code. But after that, I would think that only those variables that need resolving, ala #var#, would even get considered by cf. Anyone know for sure? Also, it helps cut down on white space if you've got your logic/data in separate files from your display, as fusebox does. Enablecfoutputonly, and only your dsp_files have those cfoutputs. But this goes more with personal coding style, and may be a hassle if, for instance, you have long pages of cf/display code with alternating sections of query then display, query then display, etc. Not the way I would code even if I wasn't using fusebox, but to each their own. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Monday, August 26, 2002 1:20 PM To: CF-Talk Subject: Many or Minimal CFOUTPUTS This is very minimal I am sure, but curious, is it better to have many cfoutputs on a page as opposed to 1-2 cfoutputs that encompass lots of code. I guess the question would be is it harder for CF to open and close cfoutputs or read through HTML code and other bits of information to find the outputs. I know that it probably makes little difference if much at all, but what do you find yourselves doing? Paul Giesenhagen QuillDesign __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
protect connection string password
How can I protect the SQL uid/password used in a connection string of a cfquery from prying eyes? It's on a crystaltech server, so I have to use the connectionstring attributes with user name/password of the MS SQL account. Is there some kind of encryption/hash/whatever to protect it from someone with access to the cf templates? Cf's template encryption is weak, so I would prefer something else. Thanks for any help. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ANY Major Company using Cold Fusion
NETPDTC uses it for all web development. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Friday, August 16, 2002 8:46 AM To: CF-Talk Subject: RE: ANY Major Company using Cold Fusion Lots and lots of branches of the US Federal government. Some I can think of offhand are: The Senate (www.senate.gov) Air Force (lots of cool Flash too) Army DOT DOJ FEMA HUD SSA NIST CIA US Mint NIH State Department NHTSA FAA USDA NASA GSA (purchasing) Attorney General NSF Federal Reserve You'd be hard pressed to find a Federal agency that does not have some CF in it. There are also lots of state and local government sites too. --- Ben -Original Message- From: Sandy Clark [mailto:[EMAIL PROTECTED]] Sent: Friday, August 16, 2002 9:25 AM To: CF-Talk Subject: Re: ANY Major Company using Cold Fusion Boeing uses it internally. So do a lot of sites within the Federal Govt. NIST (National Institute of Standards and Technology under Department of Commerce) NIH (National Institute of Health) FEMA Run this on Google for a listing: gov filetype:cfm - Original Message - From: Ryan Kime [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 5:24 PM Subject: RE: ANY Major Company using Cold Fusion U. ATT Ford Motor Company Sprint PCS -Original Message- From: Corrine Clark [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 4:16 PM To: CF-Talk Subject: ANY Major Company using Cold Fusion I need some major companies that are using cold fusion. If you know of some please let me know. Thank you, Corrine Clark __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Order By Problem
You don't have an order by in your second query? Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 10:41 AM To: CF-Talk Subject: Order By Problem ok below i commented what im trying to do. basically make the output dispaly in the order i want. but it is seems to be reordering itself... any help would be great. look below. thanks. -paul !--- This query grabs the value ID's to be used to display the content below --- cfquery name=qryServCom datasource=360 dbtype=ODBC SELECT SurveyID, surveys.[Self-Review] AS Self FROM surveys WHERE surveys.RevieweeID = #FORM.RevieweeID# ORDER BY surveys.[Self-Review]; /cfquery !--- I just put this here to make sure the id's are in the order i want Which they are. example 55, 73, 63, 56, 23, 22, --- cfoutput query=qryServCom group=SurveyID#qryServCom.SurveyID#, /cfoutputbr !--- now i match up the id's to out put my text --- cfquery name=qryArtCom datasource=360 SELECT Artists.SurveyID, ArtistCOMMENTS FROM Artists WHERE Artists.SurveyID IN (cfoutput query=qryServCom group=SurveyID#SurveyID#, /cfoutput) /cfquery cfoutput query=qryArtCom group=ArtistCOMMENTS#SurveyID# #ArtistCOMMENTS#br::br/cfoutput !--- Output the text here... but now the order is back to numeric from the SurveyID ASC; instead of the order i want! example 22 he leads by example. :: 23 Comments for #2. The Reviewee tends to set extremely high action plans that lead to a tendency for project teams to work at an unsustainable level over extended periods of time. Comments for #3. Reviewee expects all team members to perform to his level when they either may not wish to or are unable. Improved team relationships is the only aspect of this question preventing it from being a six. Comments for #4. The Reviewee excells at communication with the client. More attentive listening to consultants and team members would be beneficial. :: 55 :: 56 very competent. And as a lot of leader ship potiential. Needs to stand- up more for what he believes. :: 63 :: --- __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF MX bugs/transition problems info
Is there a somewhere that I can find the following: 1. Known bugs/limitations with CF MX 2. Known issues with CF5 apps sent over to a MX server. Boss wants to know if we should upgrade, and also which version(ent vs. pro). I've got the comparison of ent and pro done, need a good resource on the bugs. Thanks all. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
MS SQL global temp tables and CF's connections
I am hoping that some of you better versed in MS-SQL and CF could clear this up for me. Is there an issue with multiple users accidentally hitting the same data set that is contained in either a local(#tbl_name) or global(##tbl_name) temporary table? Books Online says that a local temp table is local to the current session, but how does a session relate to the connections that CF maintains, ie connection pooling? If we have, say 5 select intos (selecting into a global/local temp table, one after another in a stored proc, and while user 1 is on the 3'rd select into, user2 is on the first select into, and both are selecting into the same global/local table, based upon different where clauses, will this cause bad data, ie data that doesn't meet the where clauses per user, to enter the temp table? And thus the resulting record set returned would be incorrect? I know that this has a slim margin of happening, but I'm thinking concurrent access, same as the old insert new user, select max id problem. I would like to avoid a transactional lock because of the bottle neck, I would prefer a more proper approach. My feeling is that this is an issue, my dba doesn't, but both of us don't really know for sure. I hope I made sense, let me know if I didn't. Thanks. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX WACK
Flash Fusion. Where is that? Is it a mailing list or a site? I'm starting to get my feet wet with flash. Thanks -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 07, 2002 10:10 AM To: CF-Talk Subject: Re: CFMX WACK No, the book was designed and written before they knew the branding strategy was going to be ColdFusion MX. They left it ColdFusion X because they didn't know what it was going to be. Least, that's what I remember hearing Ben tell everyone over at Flash Fusion. ~Todd On Wed, 7 Aug 2002, S. Isaac Dealey wrote: It also says coldfusion x ... I guess the m left to go be a part of generation mx or something... -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
MS SQL global temp tables and CF's connections
I am hoping that some of you better versed in MS-SQL and CF could clear this up for me. Is there an issue with multiple users accidentally hitting the same data set that is contained in either a local(#tbl_name) or global(##tbl_name) temporary table? Books Online says that a local temp table is local to the current session, but how does a session relate to the connections that CF maintains, ie connection pooling? If we have, say 5 select intos, one after another in a stored proc, and while user 1 is on the 3'rd select into, user2 is on the first, and both are selecting into the same global/local table, based upon different where clauses, will this cause bad data, ie data that doesn't meet the where clauses per user, to enter the temp table? And thus the resulting record set returned would be incorrect? I know that this has a slim margin of happening, but I'm thinking concurrent access, same as the old insert new user, select max id problem. I would like to avoid a transactional lock because of the bottle neck, I would prefer a more proper approach. My feeling is that this is an issue, my dba doesn't, but both of us don't really know for sure. I hope I made sense, let me know if I didn't. Thanks. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Can you use cfqueryparam with an insert?
I try to use cfqueryparam for a little better performance(I'll be converting
to a stored proc in a bit).
I've used it with no prob for selects, but can you use it for an INSERT or
UPDATE statement?
After running the query below, the DB is storing an actual ? for the
values, rather than the actual values sent. The debug info shows the
correct values being sent.
cfquery name=qry_insertNew datasource=deersData dbtype=ODBC
INSERT INTO loginInfo (ssn, lastName, birthDate,
lastVerified)
Values ('cfqueryparam value=#attributes.SSN#
cfsqltype=CF_SQL_VARCHAR maxlength=50', 'cfqueryparam
value=#attributes.lastName# cfsqltype=CF_SQL_VARCHAR maxlength=50',
'cfqueryparam value=#attributes.birthdate# cfsqltype=CF_SQL_VARCHAR
maxlength=50', #CreateODBCDateTime(now())#)
/cfquery
DEBUG INFO:
qry_insertNew (Records=0, Time=16ms)
SQL =
INSERT INTO loginInfo (ssn, lastName, birthDate, lastVerified, hits)
Values ('?', '?', '?', {ts '2002-07-31 16:00:41'},
?)
Query Parameter Value(s) -
Parameter #1 = 123456789
Parameter #2 = Davis
Parameter #3 = 19430214
Parameter #4 = 1
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Can you use cfqueryparam with an insert?
Thanks, worked like a charm.
Been using nothing but stored procs for awhile; forgot about that gotcha.
Matthew P. Smith
Web Developer, Object Oriented
Naval Education Training Professional
Development Technology Center
(NETPDTC)
(850)452-1001 ext. 1245
[EMAIL PROTECTED]
-Original Message-
From: Kelly Tetterton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 4:05 PM
To: [EMAIL PROTECTED]
Subject: RE: Can you use cfqueryparam with an insert?
Don't quote the cfqueryparam; ie do
Values(cfqueryparam value=#attributes.SSN#
cfsqltype=CF_SQL_VARCHAR maxlength=50,
rather than
Values('cfqueryparam value=#attributes.SSN#
cfsqltype=CF_SQL_VARCHAR maxlength=50',
-Original Message-
From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 4:03 PM
To: CF-Talk
Subject: Can you use cfqueryparam with an insert?
I try to use cfqueryparam for a little better performance(I'll be
converting
to a stored proc in a bit).
I've used it with no prob for selects, but can you use it for an INSERT or
UPDATE statement?
After running the query below, the DB is storing an actual ? for the
values, rather than the actual values sent. The debug info shows the
correct values being sent.
cfquery name=qry_insertNew datasource=deersData dbtype=ODBC
INSERT INTO loginInfo (ssn, lastName, birthDate,
lastVerified)
Values ('cfqueryparam value=#attributes.SSN#
cfsqltype=CF_SQL_VARCHAR maxlength=50', 'cfqueryparam
value=#attributes.lastName# cfsqltype=CF_SQL_VARCHAR maxlength=50',
'cfqueryparam value=#attributes.birthdate# cfsqltype=CF_SQL_VARCHAR
maxlength=50', #CreateODBCDateTime(now())#)
/cfquery
DEBUG INFO:
qry_insertNew (Records=0, Time=16ms)
SQL =
INSERT INTO loginInfo (ssn, lastName, birthDate, lastVerified, hits)
Values ('?', '?', '?', {ts '2002-07-31 16:00:41'},
?)
Query Parameter Value(s) -
Parameter #1 = 123456789
Parameter #2 = Davis
Parameter #3 = 19430214
Parameter #4 = 1
__
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Proper way to catch a connection failure for cfhttp
A couple of questions... There is a url I am calling, which allows us to validate a user against the DEERS db(military thing). I am sending it a few url params through cfhttp. Does this classify it as a web service? It returns a string, not an XML document, does that matter? Also, what is the proper way to trap (ie cftry/cfcatch style) a failed cfhttp call? The service tends to be iffy, so: If the user is verified, I return a 1 If the user verification fails, I return 0 If the cfhttp call fails, I want to return -1 Currently, I am doing this: cfhttp url=https://foo.com; cfhttpparam type=URL name=RULE value=foo /cfhttp cfif cfhttp.fileContent eq Connection Failure cfoutput-1/cfoutput cfabort /cfif Is this the correct way to trap it? Or is there a cfcatch type=something that would be better? Thanks for the help. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
what scope are the variables in when a template is called via cfh ttp?
I have a template that I am calling via cfhttp. How do I access the variables being passed to it? I am passing them via cfhttpparam type=URL name=foo valuefoo. In the called template, though, referencing url.foo throws an error. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: what scope are the variables in when a template is called via cfh ttp?
Thanks, Shawn. Been working this all day, and my brain is starting to get a bit foggy. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 6:46 PM To: CF-Talk Subject: RE: what scope are the variables in when a template is called via cfh ttp? Local - to within the page request. The requested page is then returned via the CFHTTP.FileContent (hope I got that right) variable. This variable is then local to your calling page. The Called page, is fully rendered at this time, and you are dealing with the resulting HTML. Shawn Grover -Original Message- From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 5:38 PM To: CF-Talk Subject: what scope are the variables in when a template is called via cfh ttp? I have a template that I am calling via cfhttp. How do I access the variables being passed to it? I am passing them via cfhttpparam type=URL name=foo valuefoo. In the called template, though, referencing url.foo throws an error. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Session not being killed on close of browser
I thought that by omitting it, the default value sent WAS now? Matt -Original Message- From: Cornillon, Matthieu [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 10:01 AM To: CF-Talk Subject: RE: Session not being killed on close of browser Adrian, Is that CFIF block supposed to kill the cookies, thus detaching the session? If so, the only thing I can think of is to specify, in the CFCOOKIE statements, the parameter expires=NOW. Perhaps omitting it sends a value which some browsers interpret differently than others? Matthieu -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 7:49 AM To: CF-Talk Subject: Session not being killed on close of browser Sorry for bring up this old chestnut, I've searched the web, the archives, under the sofa and still can't find an answer. I'm using this code in Application.cfm.. CFAPPLICATIONNAME=myApp CLIENTMANAGEMENT=Yes SESSIONMANAGEMENT=Yes APPLICATIONTIMEOUT=#CreateTimeSpan(1,0,0,0)# CLIENTSTORAGE=myApp_clientData SETCLIENTCOOKIES=Yes cfif IsDefined(Cookie.CFID) AND IsDefined(Cookie.CFTOKEN) cfset cfid_local = Cookie.CFID cfset cftoken_local = Cookie.CFTOKEN cfcookie name=CFID value=#cfid_local# cfcookie name=CFTOKEN value=#cftoken_local# /cfif which I understand, and which works for some people in my office. But not for me. I have IE6 where as they run IE5.* I've closed ALL my browsers, leaving it a long time before opening afresh, and even loggin in this morning I had the same session running. We're running MX on NT if that makes a difference. Could it be the browser is the problem? Is there anything wrong with the code? Has anyone coming across this before? Are there any pitfalls to be aware of in the rest of the code in the site? Any thought would be nice? Adrian Lynch Thoughtbubble Ltd -- United Kingdom http://www.thoughtbubble.net Ph: +44 (0) 20 7387 8890 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s) . Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0) 20 7387 8890 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Session not being killed on close of browser
Dude, no need to apologize, I was just trying to help same as you were. No worries. The best part of this list is that we have many great minds to pick when solving a problem. At least you replied and tried to help, ya know? : ) Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Cornillon, Matthieu [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 10:26 AM To: CF-Talk Subject: RE: Session not being killed on close of browser Oops! I'm sorry. I should have read the documentation before sending that answer. Omitting the EXPIRES attribute makes it so that the cookie stays open only as long as the browser is open. That's exactly what Adrian was shooting for. Okay. Now that I understand that, I can only suggest that you look at the security settings in the Internet Options. I know that the options there have different entries for cookies and per-session cookies, so that you can enable/disable them independently. Perhaps your version of the browser handles this differently? It seems crazy, but maybe it's forcing the per-session cookies to be written to the machine somehow? Again, sorry about the shooting-from-the-hip silly answer. Matthieu -Original Message- From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 11:13 AM To: CF-Talk Subject: RE: Session not being killed on close of browser I thought that by omitting it, the default value sent WAS now? Matt -Original Message- From: Cornillon, Matthieu [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 10:01 AM To: CF-Talk Subject: RE: Session not being killed on close of browser Adrian, Is that CFIF block supposed to kill the cookies, thus detaching the session? If so, the only thing I can think of is to specify, in the CFCOOKIE statements, the parameter expires=NOW. Perhaps omitting it sends a value which some browsers interpret differently than others? Matthieu -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 7:49 AM To: CF-Talk Subject: Session not being killed on close of browser Sorry for bring up this old chestnut, I've searched the web, the archives, under the sofa and still can't find an answer. I'm using this code in Application.cfm.. CFAPPLICATION NAME=myApp CLIENTMANAGEMENT=Yes SESSIONMANAGEMENT=Yes APPLICATIONTIMEOUT=#CreateTimeSpan(1,0,0,0)# CLIENTSTORAGE=myApp_clientData SETCLIENTCOOKIES=Yes cfif IsDefined(Cookie.CFID) AND IsDefined(Cookie.CFTOKEN) cfset cfid_local = Cookie.CFID cfset cftoken_local = Cookie.CFTOKEN cfcookie name=CFID value=#cfid_local# cfcookie name=CFTOKEN value=#cftoken_local# /cfif which I understand, and which works for some people in my office. But not for me. I have IE6 where as they run IE5.* I've closed ALL my browsers, leaving it a long time before opening afresh, and even loggin in this morning I had the same session running. We're running MX on NT if that makes a difference. Could it be the browser is the problem? Is there anything wrong with the code? Has anyone coming across this before? Are there any pitfalls to be aware of in the rest of the code in the site? Any thought would be nice? Adrian Lynch Thoughtbubble Ltd -- United Kingdom http://www.thoughtbubble.net Ph: +44 (0) 20 7387 8890 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s) . Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0) 20 7387 8890 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF_ThreeSelectsRelated : Difficulty when using Default Values
This is a known issue(I think). I posted the same problem and someone provided a customized version of it. Let me track it down. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Stephen Cassady [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 12:21 PM To: CF-Talk Subject: CF_ThreeSelectsRelated : Difficulty when using Default Values I am experiencing some difficulty with the CF_ThreeSelectsRelated when utilizing the DEFAULT1,2,3 values. I was wondering if there are any common mistakes I could be making with the setup that would result in the following problem: When populating with DEFAULT values: The First Box: acts fine The Second Box: Won't refresh third box correctly The Third Box: Lists the choices for the First box's set, not the set chosen. EXAMPLE: (Data Set) --- Not Selected ------ n/a --- n/a 3 64 7 Canada Alberta Calgary1 11 1 Canada Alberta Edmonton 1 11 2 Canada Ontario Toronto1 5 3 Canada Ontario Ottawa 1 5 4 USA California Los Angeles2 18 5 USA New York New York 2 47 6 (Query) SELECT RegionCountry.CountryName, RegionState.StateName, RegionCity.CityName, RegionCountry.RegionCountryID, RegionState.RegionStateID, RegionCity.RegionCityID FROM RegionCountry LEFT OUTER JOIN RegionState ON RegionCountry.RegionCountryID = RegionState.RegionCountryID LEFT OUTER JOIN RegionCity ON RegionState.RegionStateID = RegionCity.RegionStateID WHERE (RegionCountry.Active = '1') AND (RegionState.Active = '1') AND (RegionCity.Active = '1') ORDER BY RegionCountry.CountryName What I select: [picture lost in plain text] What I get on Default: [picture lost in plain text] As you can see, the use of the site with out a default works correctly! Canada, Ontario, and Choice of Toronto and Ottawa. But if I prepopulate for those values, the system actually defaults to Canada à Ontario à Calgary! Do you have any suggestions? Thank you for your time. Stephen R. Cassady [EMAIL PROTECTED] http://www.lopedia.com CFIF isDefined(form.formresponse) CF_ThreeSelectsRelated QUERY=q_threeLocations HTMLAFTER1=BR HTMLAFTER2=BR NAME1=country NAME2=state NAME3=city VALUE1=RegionCountryID VALUE2=RegionStateID VALUE3=RegionCityID DISPLAY1=CountryName DISPLAY2=StateName DISPLAY3=CityName DEFAULT1=#form.country# DEFAULT2=#form.state# DEFAULT3=#form.city# SIZE1=1 SIZE2=1 SIZE3=1 AUTOSELECTFIRST=YES MULTIPLE3=No FORCEWIDTH1= FORCEWIDTH2= FORCEWIDTH3= FormName=addnewtarget CFELSE CF_ThreeSelectsRelated QUERY=q_threeLocations HTMLAFTER1=BR HTMLAFTER2=BR NAME1=country NAME2=state NAME3=city VALUE1=RegionCountryID VALUE2=RegionStateID VALUE3=RegionCityID DISPLAY1=CountryName DISPLAY2=StateName DISPLAY3=CityName DEFAULT1=3 SIZE1=1 SIZE2=1 SIZE3=1 AUTOSELECTFIRST=YEs MULTIPLE3=No FORCEWIDTH1= FORCEWIDTH2= FORCEWIDTH3= FormName=addnewtarget /CFIF FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF_ThreeSelectsRelated : Difficulty when using Default Values
The reusethecube part allows you to use the three selects related multiple times on the same page. This tag was developed by Len Bucchino for WorkArea.com weblinc.com If you use it, be sure to thank him. I've cut and pasted my call to it, let me know if you need any help. Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Stephen Cassady [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 12:21 PM To: CF-Talk Subject: CF_ThreeSelectsRelated : Difficulty when using Default Values I am experiencing some difficulty with the CF_ThreeSelectsRelated when utilizing the DEFAULT1,2,3 values. I was wondering if there are any common mistakes I could be making with the setup that would result in the following problem: When populating with DEFAULT values: The First Box: acts fine The Second Box: Won't refresh third box correctly The Third Box: Lists the choices for the First box's set, not the set chosen. EXAMPLE: (Data Set) --- Not Selected ------ n/a --- n/a 3 64 7 Canada Alberta Calgary1 11 1 Canada Alberta Edmonton 1 11 2 Canada Ontario Toronto1 5 3 Canada Ontario Ottawa 1 5 4 USA California Los Angeles2 18 5 USA New York New York 2 47 6 (Query) SELECT RegionCountry.CountryName, RegionState.StateName, RegionCity.CityName, RegionCountry.RegionCountryID, RegionState.RegionStateID, RegionCity.RegionCityID FROM RegionCountry LEFT OUTER JOIN RegionState ON RegionCountry.RegionCountryID = RegionState.RegionCountryID LEFT OUTER JOIN RegionCity ON RegionState.RegionStateID = RegionCity.RegionStateID WHERE (RegionCountry.Active = '1') AND (RegionState.Active = '1') AND (RegionCity.Active = '1') ORDER BY RegionCountry.CountryName What I select: [picture lost in plain text] What I get on Default: [picture lost in plain text] As you can see, the use of the site with out a default works correctly! Canada, Ontario, and Choice of Toronto and Ottawa. But if I prepopulate for those values, the system actually defaults to Canada à Ontario à Calgary! Do you have any suggestions? Thank you for your time. Stephen R. Cassady [EMAIL PROTECTED] http://www.lopedia.com CFIF isDefined(form.formresponse) CF_ThreeSelectsRelated QUERY=q_threeLocations HTMLAFTER1=BR HTMLAFTER2=BR NAME1=country NAME2=state NAME3=city VALUE1=RegionCountryID VALUE2=RegionStateID VALUE3=RegionCityID DISPLAY1=CountryName DISPLAY2=StateName DISPLAY3=CityName DEFAULT1=#form.country# DEFAULT2=#form.state# DEFAULT3=#form.city# SIZE1=1 SIZE2=1 SIZE3=1 AUTOSELECTFIRST=YES MULTIPLE3=No FORCEWIDTH1= FORCEWIDTH2= FORCEWIDTH3= FormName=addnewtarget CFELSE CF_ThreeSelectsRelated QUERY=q_threeLocations HTMLAFTER1=BR HTMLAFTER2=BR NAME1=country NAME2=state NAME3=city VALUE1=RegionCountryID VALUE2=RegionStateID VALUE3=RegionCityID DISPLAY1=CountryName DISPLAY2=StateName DISPLAY3=CityName DEFAULT1=3 SIZE1=1 SIZE2=1 SIZE3=1 AUTOSELECTFIRST=YEs MULTIPLE3=No FORCEWIDTH1= FORCEWIDTH2= FORCEWIDTH3= FormName=addnewtarget /CFIF FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
browse to mdb and java error problem.
java.lang.NoClassDefFoundError: netscape/application/Target I'm trying to register a local access mdb in 127.0.0.1/cfide/administrator When I click on the Browse Server for Database File under odbc, it installed a cab, then the java window in the browser just shows this error message and sits there. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: Little Nervous
Heck, why wait till you're nervous? ; ) - Original Message - From: Tangorre, Michael [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 17, 2002 2:13 PM Subject: RE: OT: Little Nervous If you get nervous, picture Hal Helms, Ben Forta, etc... in their skibbys :-) Problem solved. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 2:04 PM To: CF-Talk Subject: Re: OT: Little Nervous Break a leg. :) On Wed, 17 Jul 2002, Bill Wheatley wrote: I'm going to be doing a seminar tonight with a friend in Miami about Macromedia MX line. I'll be doing CF and some of the other products and my friend will be doing the remainder of the MX line for his graphics side of it. And then after that I'm going to start teaching a CF class at the CADD institute of Miami. So I'm a little nervous since this would be my first paid group learning I will be doing. :) I already talked with Adam C. about his tips now anyone else have any other tips. Besides - Don't forget to zip your fly lol. Though I'm excited and I'm sure it will be great so we'll just have to see! Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
