RE: CFMX Taking all CPU Resources?
Joe, After reading your recent slew of posts, I feel compelled to speak up (as others already have) for the majority of CFMX users on this list that are doing just fine with the product. Sure, some things are running slower (COM for sure) and waiting for page compilations on _development_ boxes is a slight nuisance. But in the overall scheme of things, most of us are doing just fine with CFMX and we're finding similar results with our production applications as Macromedia did with their tests (read the performance brief: http://www.macromedia.com/software/coldfusion/whitepapers/pdf/cfmx_perfo rmance_brief.pdf). For what is basically a 1.0 release, it's pretty damn good. I believe this is where Sean and others are coming from on this. We're not having your type of trouble with our code (I should note here that I'm not paying attention to CPU usage. Rather I'm monitoring response times and throughput which matter more to the end user's experience). So this leads us to the question that Sean has been asking all along, what are YOU doing in YOUR tests? The more information you can provide about your specific situation the better. Response times and code samples would be the best place to start. Have you run your app. with debugging turned on? If so, what pages are bottlenecking the application? Can we get some code samples from those? There are many of us that would like to help in this situation, but I have to agree with Sean, the lack of details on your behalf is making it rather difficult. If you really want to get to the root of your issues, give us a something more to go on. Chris Kief -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 28, 2002 10:46 PM To: CF-Talk Subject: Re: CFMX Taking all CPU Resources? On Sunday, July 28, 2002, at 09:06 , Joe Eugene wrote: If you have personally done some convincing TESTS ... we would be happy to know your TEST results. While I ran CF5 and CFMX (pre-release) on the same Win2K system, my experience was that CFMX was faster (once the templates had been compiled on the first pass). CPU usage is higher with CFMX while it is compiling (obviously) but I'm not sure that the overall average CPU usage was higher with CFMX. As I said, I don't believe 100% CPU usage is a problem per se. I am NOT asking you to comment on what I SAY/DO/TEST/CODE... rather YOUR TEST results... But I am very interested in the *code* of your tests - I want to know what the response times are with your code (something you haven't told us). If you have none...why dont you tune yourself out of this THREAD. Perhaps if you were less unpleasant about this whole matter people would be more co-operative with you? I'm trying really hard to help you here but you haven't produced anything concrete for folks to work with. You've just been nasty and pointed fingers all around - while other people are quite clearly not having the same problems that you believe you are seeing. Stop raising your voice and show us the code and the response times. Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ 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: Japanese plain text email
Matthew Walker wrote: I'm coping with creating Japanese language pages using META http-equiv=Content-Type content=text/html; charset=SHIFT_JIS But now I need to send plain text Japanese emails. Anybody know how to do this? Check your mailbox for Korean spam. Replace the Korean charset with a Japanese one and you have a template for your email. Jochem __ 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: CFMX Taking all CPU Resources?
Joe. Please track down the portion of your app that causes the CPU spike and post the code. Then I'm sure plenty of folks will have ideas on how to optimize. Stace -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 28, 2002 11:25 PM To: CF-Talk Subject: RE: CFMX Taking all CPU Resources? This is really funny over and over.. no facts/proofs of test by anybody I would really be exited and happy to know that CFMX Scales... If i can see some facts/proofs. Joe -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 28, 2002 11:05 PM To: CF-Talk Subject: Re: CFMX Taking all CPU Resources? On Sunday, July 28, 2002, at 05:57 , Joe Eugene wrote: I am having a hard time.. conveying the messsage.. Yes, so it seems :) We are talking about basic code in ColdFusion.. every answer i get is like.. Custom Tags..(oh for CFMX u need to do this.. or this is how you can Optimize.. for CFMX...CFC .. function blah blah) That's because you are not being specific about what code you are testing that is running slower. Show us your code! Nobody has said.. alright.. if you code CFLOOP this way in CF5.0 you can speed it up writing CFLOOP like THIS(.) in CFMX. Because the code fragment you posted did not seem to be real code (a simple cfloop that created an impossibly long string). No one has suggested that such basic constructs need rewriting in CFMX. Custom tag invocation is definitely faster - several people here have testified to that. ARE YOU GUYS SAYING THAT CFMX is 10% FASTER THAN CF5.0? If so.. What were the TESTS you did to prove this? READ THE PERFORMANCE BRIEF! As Todd (I think?) said, people are beginning to tune you out because you are not providing any facts. Try to be specific. Show us code that you've tested that is slower on CFMX and then we can see why that is. NOTE: Sean... i read quite a lot from here and there.. its awfully.. hard for me to write down who the author,published date.. etc everytime i read something. Why is it hard? You read something, you make a note of the article. C'mon Joe, you're whining a lot but you're not backing it up with details. . If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ 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 + Linux + Apache Segmentation Fault
Number 1: Slackware is not supported (nessecary caveat) Number 2: I suggest that if you have not, upgrade to the latest version of Apache for security fixes. Number 3: You have to be running a forced EAPI Apache server, correct? Number 4: I have noticed that this segfault happens one in maybe 20-30 times. The biggest reason is EAPI compatibility, and I am currently dogging out a possible fix, I need to know what modules you have loaded into apache, and what you compiled Apache with. Everyone, please note: 95% of ALL internal QA was handled with stock updated Red Hat Linux machines and the version of Apache Shipped, with patches by Red Hat. Jesse Noller [EMAIL PROTECTED] Macromedia Server Development Unix/Linux special guy -Original Message- From: Matt Goodman [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 28, 2002 10:01 PM To: CF-Talk Subject: CFMX + Linux + Apache Segmentation Fault Hi all, I have just installed Coldfusion MX Server, but it keeps crashing my Apache with the following error (in error_log): [notice] child pid 27386 exit signal Segmentation fault (11) There are dozens of them, after which comes the following: [notice] jrApache[init] added/activated proxy 127.0.0.1:51010 I am running: Slackware Linux w/ 2.4.18 Kernel Apache 1.3.26 w/ PHP 4.2.2 and mod_perl 1.2.7 Please help, 18 posts on the Macromedia forum, and no response yet from Macromedia. Has anyone successfully got Linux + CFMX working? What could these seg faults be from? Thanks a ton. __ 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 Taking all CPU Resources?
Stace, I think we've been trying to tell him that since the beginning and he's yet to do such. He's one of those guys that would rather sit and complain than actually tracking down the problem. I think everyone on the list that has confronted Joe has been more than helpful (except Joe, of course), especially Sean. Sean's a busy guy and to get ... 5-6 responses from him on a single topic, those better be damn good questions imho. ;) (sigh... all those wasted keystrokes! ;) ehhehehe) ~Todd p.s.: Sean C., yes, I'm the one that say tune out... nanananananananananananananan On Mon, 29 Jul 2002, Stacy Young wrote: Joe. Please track down the portion of your app that causes the CPU spike and post the code. Then I'm sure plenty of folks will have ideas on how to optimize. Stace -- 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
RE: quotation marks and their rules...
yes, status_code was set to 0 prior to the beginning of the loop ;) ..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: Sunday, July 28, 2002 10:50 PM To: CF-Talk Subject: RE: quotation marks and their rules... cfloop condition=isDefined(status_code) and Len(#status_code#) why doesnt this make sense? How would CF ever exit from that loop? Are you setting status_code equal to an empty string within the loop? In any case, try this: cfloop condition=IsDefined('status_code') and Len(status_code) ... Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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: quotation marks and their rules...
cfloop condition=isDefined(status_code) and Len(#status_code#) why doesnt this make sense? it keeps buggin on me ARGHHH! yes, status_code was set to 0 prior to the beginning of the loop ;) If status_code is being set to 0 before the loop, then the isDefined() isn't needed Also, Len(status_code) will only break out of the loop if status_code is set to When do you want it to stop looping? Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** __ 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: quotation marks and their rules...
In that case len(status_code) will always return 1, cause status_code=0 has a length of 1. The condition I you may be trying for is: Isdefined(status_code) and status_code This will trigger the false you were looking for since when status_code evaluates to 0, coldfusion will recognize that as the boolean for false. -Patti Tony Weeg wrote: yes, status_code was set to 0 prior to the beginning of the loop ;) ..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: Sunday, July 28, 2002 10:50 PM To: CF-Talk Subject: RE: quotation marks and their rules... cfloop condition=isDefined(status_code) and Len(#status_code#) why doesnt this make sense? How would CF ever exit from that loop? Are you setting status_code equal to an empty string within the loop? In any case, try this: cfloop condition=IsDefined('status_code') and Len(status_code) ... Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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
Issue: Update a tracker database with an index.html file.
Issue: Update a tracker database with an index.html file. I have a user that needs to track hits for there site and he has to use an index.html file. Normally I use basic CF code that get the users information like below and that would insert into my DB. I need to figure out a way to get this information and have it happen transparently from the user. Right now I have a basic script in the body tag that opens a CF page that grabs the users information and closes quickly. I want to know if there is a way to call a CF page and not have it open so I can grab the info I need when the user hits the home page. What's in the index.html file: BODY BGCOLOR=#FF LEFTMARGIN=0 TOPMARGIN=0 MARGINWIDTH=0 MARGINHEIGHT=0 aLink=#ff link=#0033CC vLink=#0033CC Onload=window.open('SiteLog.cfm','jav','menubar=no,toolbar=no,scrollbars=no,width=5,height=5,resizable=yes'); background=background/background.gif When the script page loads I grab the users information insert into my DB and run body onLoad=setTimeout(window.close, 1). Can anyone think of a better way of doing this so if the user has a slow connection they wont see a glimpse of the window I open and close? Sincerely, James Blaha CFQUERY NAME=TrafficLog DATASOURCE=Stats insert into siteTracker ( datetimestamp, referrer, client_address, client_host, client_browser, resource,tracker_id ) values ( getdate(), CFIF #left(cgi.http_referer,128)# neq '#left(cgi.http_referer,128)#' CFELSE NULL /CFIF, CFIF #left(cgi.remote_addr,128)# neq '#left(cgi.remote_addr,128)#' CFELSE NULL /CFIF, CFIF #left(cgi.http_host,128)# neq '#left(cgi.http_host,128)#' CFELSE NULL /CFIF, CFIF #left(cgi.http_user_agent,128)# neq '#left(cgi.http_user_agent,128)#' CFELSE NULL /CFIF, CFIF #left(cgi.script_name,128)# neq '#left(cgi.script_name,128)#' CFELSE NULL /CFIF, CFIF #val(attributes.tracker_id)# neq '#val(attributes.tracker_id)#' CFELSE NULL /CFIF ) /CFQUERY __ 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
GEOFENCING
Greetings, not a CF question but the place to ask, I want to set up a GEO-Fence for Northern Ireland, I want the geofence to be comprised of four areas, the North West, the South West, the North East and the South East I have got the four corresponding Lat and Lons for each area, the only thing is I am searching for a formula that will check if a certain set of co-ordinates is in a designated area (there-fore checking if its within their set of four points). I'm trying other sources as well but thought someone's math here would be a lot better than mine, Respectfully, J __ 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: Issue: Update a tracker database with an index.html file.
If they're installed, you could use a server side include (SSI) tag to include the ColdFusion module where you want the counter to appear. This is done with hit counters written in PERL to display plain-text hit counts rather than those god-awful graphical hit counters. The cfm would then be able to run your script and display the count. The include tags would look like this: !--#include virtual=/dir/tracker.cfm-- !--#include file=subdir/tracker.cfm-- The other thing you have to check for is that SSI may not work on .html since they're not always enabled for the .html or .htm extensions ( the intended extension was .shtml )... hth Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 __ 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: Issue: Update a tracker database with an index.html file.
I've never gotten SSI to kick off a .cfm page successfully, how did you do this Isaac or .. are you just suggesting this without having tried this for yosuelf? ~Todd On Mon, 29 Jul 2002, S. Isaac Dealey wrote: If they're installed, you could use a server side include (SSI) tag to include the ColdFusion module where you want the counter to appear. This is done with hit counters written in PERL to display plain-text hit counts rather than those god-awful graphical hit counters. The cfm would then be able to run your script and display the count. The include tags would look like this: !--#include virtual=/dir/tracker.cfm-- !--#include file=subdir/tracker.cfm-- The other thing you have to check for is that SSI may not work on .html since they're not always enabled for the .html or .htm extensions ( the intended extension was .shtml )... hth Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 -- 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
CF MX Debugging
This is my one and only gripe thus far with CF MX, and maybe someone knows a way to fix it. I am not liking the floating debugging window, nor do I like it docked to the left of the page. Is there a way to get debugging info to show up at the bottom of the page like it used to with CF 5 and down? Thanks, -chris.alvarado [ application developer ] 4 Guys Interactive, Inc. http://www.4guys.com -- I can picture in my mind a world without war, a world without hate. And I can picture us attacking that world, because they'd never expect it. -- Jack Handy __ 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: CF MX Debugging
Yeah, switch it to 'classic' debugging.. and apply a patch that Sean Corfield suggested in order to make sure that all the variables are on it's own line: I have a .zip file of it on my server: http://blog.web-rat.com/archives/15.html ~Todd On Mon, 29 Jul 2002, chris.alvarado wrote: This is my one and only gripe thus far with CF MX, and maybe someone knows a way to fix it. I am not liking the floating debugging window, nor do I like it docked to the left of the page. Is there a way to get debugging info to show up at the bottom of the page like it used to with CF 5 and down? Thanks, -chris.alvarado [ application developer ] 4 Guys Interactive, Inc. http://www.4guys.com -- I can picture in my mind a world without war, a world without hate. And I can picture us attacking that world, because they'd never expect it. -- Jack Handy __ 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: problems with SSL and host-headers
pretty much correct. in IIS, you cannot use host headers to differentiate sites AND use an SSL cert on those sites. the request is encrypted (obviously, it's SSL), and IIS can't see the encrypted host header to know which site to send it to (and which SSL cert to use to decrypt it). -Original Message- From: cf-talk [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 27, 2002 5:16 PM To: CF-Talk Subject: OT: problems with SSL and host-headers Hi list, I have a CF-shared box with one IP-adress. I would like to do the following: Having access to https://subdomain.domain.com:443 I have a valid certificate for this subdomain from Thawte but when I try to connect to that URL I get an error, that there is no such server. I am sure it has s.th. to do with host-headers. Someone else told me, that you can only run one certificate with one port (e.g. 443) on the same IP using host-headers (HTTP 1.1) Can s.o. verify this ? Thanks Uwe __ 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: CF MX Debugging
Sure, it's a setting in CF Admin in the Debug screen, set it to classic instead of dockable. --- Ben -Original Message- From: chris.alvarado [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 9:20 AM To: CF-Talk Subject: CF MX Debugging This is my one and only gripe thus far with CF MX, and maybe someone knows a way to fix it. I am not liking the floating debugging window, nor do I like it docked to the left of the page. Is there a way to get debugging info to show up at the bottom of the page like it used to with CF 5 and down? Thanks, -chris.alvarado [ application developer ] 4 Guys Interactive, Inc. http://www.4guys.com -- I can picture in my mind a world without war, a world without hate. And I can picture us attacking that world, because they'd never expect it. -- Jack Handy __ 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: problems with SSL and host-headers
They were correct. Since IIS can't see the header, your request is going to be sent directly to port 443, which is most likely listened to by the default or admin virtual domain.. \ However, this is possible. I have done this in the past using the undefined ports starting at 28000. If you set your SSL port to 28000 for that virtual domain, this should work. You just have to remember to code all your links to point to the correct port. - Original Message - From: Christopher Olive [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 29, 2002 9:28 AM Subject: RE: problems with SSL and host-headers pretty much correct. in IIS, you cannot use host headers to differentiate sites AND use an SSL cert on those sites. the request is encrypted (obviously, it's SSL), and IIS can't see the encrypted host header to know which site to send it to (and which SSL cert to use to decrypt it). -Original Message- From: cf-talk [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 27, 2002 5:16 PM To: CF-Talk Subject: OT: problems with SSL and host-headers Hi list, I have a CF-shared box with one IP-adress. I would like to do the following: Having access to https://subdomain.domain.com:443 I have a valid certificate for this subdomain from Thawte but when I try to connect to that URL I get an error, that there is no such server. I am sure it has s.th. to do with host-headers. Someone else told me, that you can only run one certificate with one port (e.g. 443) on the same IP using host-headers (HTTP 1.1) Can s.o. verify this ? Thanks Uwe __ 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: Issue: Update a tracker database with an index.html file.
Use an image tag. The src= can be your CF code which returns a gif. Gif could be transparent. Pass all your user info to the cf page. Ex:cfoutput img src=mycfUserINfoPage.cfm?referrer=#cgi.referer#whateverElse=#wewew# width=0 heifht=0 border=0 /cfoutput - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 29, 2002 9:25 AM Subject: Re: Issue: Update a tracker database with an index.html file. I've never gotten SSI to kick off a .cfm page successfully, how did you do this Isaac or .. are you just suggesting this without having tried this for yosuelf? ~Todd On Mon, 29 Jul 2002, S. Isaac Dealey wrote: If they're installed, you could use a server side include (SSI) tag to include the ColdFusion module where you want the counter to appear. This is done with hit counters written in PERL to display plain-text hit counts rather than those god-awful graphical hit counters. The cfm would then be able to run your script and display the count. The include tags would look like this: !--#include virtual=/dir/tracker.cfm-- !--#include file=subdir/tracker.cfm-- The other thing you have to check for is that SSI may not work on .html since they're not always enabled for the .html or .htm extensions ( the intended extension was .shtml )... hth Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 -- 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) | __ 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: Stored Proc wizard
Man I love this list! Thanks Phillip Broussard Tracker Marine Group 417-873-5957 - Original Message - From: Adam Churvis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, July 27, 2002 7:36 AM Subject: Re: Stored Proc wizard That would be ours, at www.ProductivityEnhancement.com. Enjoy! :) Respectfully, Adam Phillip Churvis Advanced Intensive ColdFusion MX Training http://www.ColdFusionTraining.com E-mail: [EMAIL PROTECTED] Phone: 770-446-8866 - Original Message - From: Phillip B [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 26, 2002 4:33 PM Subject: Stored Proc wizard I think I saw something recently about a stored procedure wizard. I look in the archives but I didn't see what I was looking for. Some one posted a link to the site it could be down loaded from. Anyone know what I am talking about and can point me in the right direction? Thank you. Thank you very much. Phillip Broussard Tracker Marine Group 417-873-5957 __ 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 MX Debugging
You need to get into the Administrator and change the debugging setting to classic instead of Dockable. At 08:20 AM 7/29/2002 -0500, you wrote: This is my one and only gripe thus far with CF MX, and maybe someone knows a way to fix it. I am not liking the floating debugging window, nor do I like it docked to the left of the page. Is there a way to get debugging info to show up at the bottom of the page like it used to with CF 5 and down? Thanks, -chris.alvarado [ application developer ] 4 Guys Interactive, Inc. http://www.4guys.com -- I can picture in my mind a world without war, a world without hate. And I can picture us attacking that world, because they'd never expect it. -- Jack Handy __ 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: Issue: Update a tracker database with an index.html file.
This won't work if the file is an index.html file - your server won't recognize the pound signs. We've gotten around this using Javascript: !--- begin XED clickthru measurement script --- script language=javascript function PageQuery(q) { if(q.length 1) this.q = q.substring(1, q.length); else this.q = null; this.keyValuePairs = new Array(); if(q) { for(var i=0; i this.q.split().length; i++) { this.keyValuePairs[i] = this.q.split()[i]; } } this.getKeyValuePairs = function() { return this.keyValuePairs; } this.getValue = function(s) { for(var j=0; j this.keyValuePairs.length; j++) { if(this.keyValuePairs[j].split(=)[0] == s) return this.keyValuePairs[j].split(=)[1]; } return false; } this.getParameters = function() { var a = new Array(this.getLength()); for(var j=0; j this.keyValuePairs.length; j++) { a[j] = this.keyValuePairs[j].split(=)[0]; } return a; } this.getLength = function() { return this.keyValuePairs.length; } } function queryString(key){ var page = new PageQuery(window.location.search); return unescape(page.getValue(key)); } function displayItem(key){ if(queryString(key)=='false') { var me = 1; } else { var nnn = queryString(key); document.write('img src=http://blahblahblah/recorder/clickrecorder.cfm?ID=' + nnn + 'page=home width=1 height=1'); } } displayItem('ID'); /script You can rebuild this, I think, to grab the referring page... Ian -Original Message- From: WebMaster [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 6:44 AM To: CF-Talk Subject: Re: Issue: Update a tracker database with an index.html file. Use an image tag. The src= can be your CF code which returns a gif. Gif could be transparent. Pass all your user info to the cf page. Ex:cfoutput img src=mycfUserINfoPage.cfm?referrer=#cgi.referer#whateverElse=#wewew# width=0 heifht=0 border=0 /cfoutput - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 29, 2002 9:25 AM Subject: Re: Issue: Update a tracker database with an index.html file. I've never gotten SSI to kick off a .cfm page successfully, how did you do this Isaac or .. are you just suggesting this without having tried this for yosuelf? ~Todd On Mon, 29 Jul 2002, S. Isaac Dealey wrote: If they're installed, you could use a server side include (SSI) tag to include the ColdFusion module where you want the counter to appear. This is done with hit counters written in PERL to display plain-text hit counts rather than those god-awful graphical hit counters. The cfm would then be able to run your script and display the count. The include tags would look like this: !--#include virtual=/dir/tracker.cfm-- !--#include file=subdir/tracker.cfm-- The other thing you have to check for is that SSI may not work on .html since they're not always enabled for the .html or .htm extensions ( the intended extension was .shtml )... hth Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 -- 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
RE: site wide missing template handler not working in MX
I took another look at the server this morning. I believe I owe you an apology. I realize now that I made more changes after the ones I told you to make, but had forgotten about those. Here is the way that I have it as I look at it now. This is working for me. I hope it will for you as well. I have a physical dummy directory\file: C:\Inetpub\wwwroot\error\error_404.cfm with the following code in it: cfsetting enablecfoutputonly=yes !--- include the actual error_404.cfm file --- cfinclude template=/error/error_404.cfm cfsetting enablecfoutputonly=no Do not share this forlder. Ok that takes care of the Missing Template Handler file requirements. In CF Settings I have: /error/error_404.cfm This should work for the Site-wide Error Handler as well. Now, because my templates use files in a virtual directory that looks just like the physical one, I had to create a virtual directory in the website mapped to the actual error directory for the website. I have in IIS error mapped to D:\web\error\ (I can see all the files in the physical directory below) I have in CF Mappings /error mapped to D:\web\error\ I have an physical directory D:\web\error\ I hope this helps. Mike At 03:00 PM 26/07/02 -0500, you wrote: I had a problem with ours that I resolved. I will tell you how it is arranged and what I did. You can decide it is similar to your problem. We had an absolute path in cf5 that went to another drive letter and path for our file. In MX it uses relative paths only. It also has to be inside of the webroot directory. Ours was not. To solve this I created an physical directory in the webroot with the same name as the folder where my file existed. I then created a dummy file with the same name as the one I wanted to use and inside this dummy file I placed a CFINCLUDE of the actual file. Because it was relative, inside the webroot and could run cf code, it worked just fine. I had tried using virtual directories and spent several days trying to get it to work being as creative as I could. This was the only way I could actually get it to run. I could have just placed the actual files there, I know, but I keep my files elsewhere and wanted to keep it that way. This approach allows me to do that. Good Luck. Mike -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 1:16 PM To: CF-Talk Subject: Re: site wide missing template handler not working in MX Yeah, I tried that. Has anyone got this working? Can someone running CFMX confirm that this is a bug please? Or just me.. At 02:44 PM 26/07/02 -0300, you wrote: AFAIK, this path in MX is now relative to the web root directory. Did you try this? Regards, Marcello Frutig. -- Astrolábio Has ANYBODY been able to get the site wide error handler templates to work in CFMX? Everytime I try to add one in the admin it tells me the path is wrong. I've tried every combination of path variations under the sun. I've also seen a thread in the mm forums where other people are having the same problem with no answer yet. At 11:29 AM 26/07/02 -0300, you wrote: Jesse and folks, we don't experience the same when dealing with ASP/PHP/Perl and even JSP (afaik). Ok, this natural on any programming language such as pure Java, C++ and so on, but I don't agree that such behaviour is natural and expected in server-side scripts/languages such as CF and ASP. Maybe MM could go forward on this and provide something to perform the compilation faster or/and do it on the time we save a cfm template. I have a friend that says the following about CFMX: it seens that CFMX takes a long turn (gets more time and server resources) to get back to the same place we can start (or just walk a little bit) with JPS. I think this is a crap (CFML is easy, rapid and lovely) but the point is: are the price for the Java World too high for merely mortals that just want to do little things with CF (which is the perfect server-side architeture for that)? Abraços! Alex. -Original Message- From: Jesse Noller [mailto:[EMAIL PROTECTED]] Sent: 26/07/2002 9:44 AM To: CF-Talk Subject: RE: It's official: CFMX is 10% faster than CF5 /takes off tinfoil hat Uh, just to throw this in, compilation of code is something you deal with almost any programming language. C, C++, Java, etc. It's a bit of a movement of a literal line by line read, but overall, it does increase the speed of the end result. Saying that's Java is incorrect. That's Programming would be more apt. Jesse Noller [EMAIL PROTECTED] Macromedia Server Development Unix/Linux special guy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 8:39 AM To: CF-Talk Subject: Re: It's official: CFMX is 10% faster than CF5 Yea it is a pain in the ass to have it compile the first time but thats java
Re: Issue: Update a tracker database with an index.html file.
sure it will work. just map .html to cf - Original Message - From: Ian Lurie [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 29, 2002 9:47 AM Subject: RE: Issue: Update a tracker database with an index.html file. This won't work if the file is an index.html file - your server won't recognize the pound signs. We've gotten around this using Javascript: !--- begin XED clickthru measurement script --- script language=javascript function PageQuery(q) { if(q.length 1) this.q = q.substring(1, q.length); else this.q = null; this.keyValuePairs = new Array(); if(q) { for(var i=0; i this.q.split().length; i++) { this.keyValuePairs[i] = this.q.split()[i]; } } this.getKeyValuePairs = function() { return this.keyValuePairs; } this.getValue = function(s) { for(var j=0; j this.keyValuePairs.length; j++) { if(this.keyValuePairs[j].split(=)[0] == s) return this.keyValuePairs[j].split(=)[1]; } return false; } this.getParameters = function() { var a = new Array(this.getLength()); for(var j=0; j this.keyValuePairs.length; j++) { a[j] = this.keyValuePairs[j].split(=)[0]; } return a; } this.getLength = function() { return this.keyValuePairs.length; } } function queryString(key){ var page = new PageQuery(window.location.search); return unescape(page.getValue(key)); } function displayItem(key){ if(queryString(key)=='false') { var me = 1; } else { var nnn = queryString(key); document.write('img src=http://blahblahblah/recorder/clickrecorder.cfm?ID=' + nnn + 'page=home width=1 height=1'); } } displayItem('ID'); /script You can rebuild this, I think, to grab the referring page... Ian -Original Message- From: WebMaster [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 6:44 AM To: CF-Talk Subject: Re: Issue: Update a tracker database with an index.html file. Use an image tag. The src= can be your CF code which returns a gif. Gif could be transparent. Pass all your user info to the cf page. Ex:cfoutput img src=mycfUserINfoPage.cfm?referrer=#cgi.referer#whateverElse=#wewew# width=0 heifht=0 border=0 /cfoutput - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 29, 2002 9:25 AM Subject: Re: Issue: Update a tracker database with an index.html file. I've never gotten SSI to kick off a .cfm page successfully, how did you do this Isaac or .. are you just suggesting this without having tried this for yosuelf? ~Todd On Mon, 29 Jul 2002, S. Isaac Dealey wrote: If they're installed, you could use a server side include (SSI) tag to include the ColdFusion module where you want the counter to appear. This is done with hit counters written in PERL to display plain-text hit counts rather than those god-awful graphical hit counters. The cfm would then be able to run your script and display the count. The include tags would look like this: !--#include virtual=/dir/tracker.cfm-- !--#include file=subdir/tracker.cfm-- The other thing you have to check for is that SSI may not work on html since they're not always enabled for the .html or .htm extensions ( the intended extension was .shtml )... hth Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 -- 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) | __ 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
Cert Resources for CFMX
I am planning to take the Cert Exam for CFMX at DEVCON. Are there any studying guides at this point or is it to early? Thanks, Frank M. __ 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
Compliation
When does the compile take place with CFMX? When moving templates from DEV to PROD won't they have to be re-compiled? Thanks __ 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: cfdev
Tilbrook, Peter wrote: This is only supported by IE. and mozilla! z __ 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: Issue: Update a tracker database with an index.html file.
Hrm. I guess you can do that but the reason we went the JavaScript route was for clients who have index.html files on non-CF servers. I may have misunderstood. Sorry about that... -Original Message- From: WebMaster [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 7:00 AM To: CF-Talk Subject: Re: Issue: Update a tracker database with an index.html file. sure it will work. just map .html to cf - Original Message - From: Ian Lurie [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 29, 2002 9:47 AM Subject: RE: Issue: Update a tracker database with an index.html file. This won't work if the file is an index.html file - your server won't recognize the pound signs. We've gotten around this using Javascript: !--- begin XED clickthru measurement script --- script language=javascript function PageQuery(q) { if(q.length 1) this.q = q.substring(1, q.length); else this.q = null; this.keyValuePairs = new Array(); if(q) { for(var i=0; i this.q.split().length; i++) { this.keyValuePairs[i] = this.q.split()[i]; } } this.getKeyValuePairs = function() { return this.keyValuePairs; } this.getValue = function(s) { for(var j=0; j this.keyValuePairs.length; j++) { if(this.keyValuePairs[j].split(=)[0] == s) return this.keyValuePairs[j].split(=)[1]; } return false; } this.getParameters = function() { var a = new Array(this.getLength()); for(var j=0; j this.keyValuePairs.length; j++) { a[j] = this.keyValuePairs[j].split(=)[0]; } return a; } this.getLength = function() { return this.keyValuePairs.length; } } function queryString(key){ var page = new PageQuery(window.location.search); return unescape(page.getValue(key)); } function displayItem(key){ if(queryString(key)=='false') { var me = 1; } else { var nnn = queryString(key); document.write('img src=http://blahblahblah/recorder/clickrecorder.cfm?ID=' + nnn + 'page=home width=1 height=1'); } } displayItem('ID'); /script You can rebuild this, I think, to grab the referring page... Ian -Original Message- From: WebMaster [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 6:44 AM To: CF-Talk Subject: Re: Issue: Update a tracker database with an index.html file. Use an image tag. The src= can be your CF code which returns a gif. Gif could be transparent. Pass all your user info to the cf page. Ex:cfoutput img src=mycfUserINfoPage.cfm?referrer=#cgi.referer#whateverElse=#wewew# width=0 heifht=0 border=0 /cfoutput - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 29, 2002 9:25 AM Subject: Re: Issue: Update a tracker database with an index.html file. I've never gotten SSI to kick off a .cfm page successfully, how did you do this Isaac or .. are you just suggesting this without having tried this for yosuelf? ~Todd On Mon, 29 Jul 2002, S. Isaac Dealey wrote: If they're installed, you could use a server side include (SSI) tag to include the ColdFusion module where you want the counter to appear. This is done with hit counters written in PERL to display plain-text hit counts rather than those god-awful graphical hit counters. The cfm would then be able to run your script and display the count. The include tags would look like this: !--#include virtual=/dir/tracker.cfm-- !--#include file=subdir/tracker.cfm-- The other thing you have to check for is that SSI may not work on html since they're not always enabled for the .html or .htm extensions ( the intended extension was .shtml )... hth Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 -- 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) | __ 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: Compliation
oi Frank!! yeap. takes place on the first hit of the page -- Critz Macromedia Certified Advanced ColdFusion Developer CFX_BotMaster Network=Efnet Channel=ColdFusion Monday, July 29, 2002, 10:06:03 AM, you wrote: FM When does the compile take place with CFMX? When moving templates from DEV to PROD won't they have to be re-compiled? FM Thanks FM __ 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: Compliation
And, of course, every single change you made on it. []'s Alex -Original Message- From: Critter [mailto:[EMAIL PROTECTED]] Sent: 29/07/2002 11:14 AM To: CF-Talk Subject: Re: Compliation oi Frank!! yeap. takes place on the first hit of the page -- Critz Macromedia Certified Advanced ColdFusion Developer CFX_BotMaster Network=Efnet Channel=ColdFusion Monday, July 29, 2002, 10:06:03 AM, you wrote: FM When does the compile take place with CFMX? When moving templates FM from DEV to PROD won't they have to be re-compiled? FM Thanks FM __ 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: CFMX Taking all CPU Resources?
I will admit that I think that our organization has codeing issues :) I am trying to show this and get past it, but the code analyzer blows up before it get very far. I run it and it churns for about 2 minutes maybe and then returns an error in one of its templates with a wddx error. I really want to try this tool out! Any suggestios ? Thanks, Mike -Original Message- From: Todd [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 27, 2002 9:12 AM To: CF-Talk Subject: RE: CFMX Taking all CPU Resources? Joe you're not using the fusebox methodology by any chance are you? Personally I'd love to see Joe submit this code for the app so we can break it apart for him and show him why it's not scaling well. I think it's time for those people that have CFMX running take a stand and say, Gee, well.. I've been running it for over 2 months and ... whew... does it fly. Every situation is unique I realize, but this is not rocket science here and no one will ever admit that the fault just might lie in their code. It's very easy to stand up and start swearing and place the blame and it's always time consuming to get to the root of the problem and swearing and placing the blame isn't going to get you there any faster... Has anyone on the list thought about creating a peer review mailing list? I realize that not everyone can sit and stare at code (we all have our own stuff to do), I myself would be curious about being reviewed by my peer to see if I'm on the right track. ~Todd At 09:53 AM 7/27/2002 -0400, you wrote: Is the app large? Are you able to break the test down to just portions at a time? Long shot but perhaps there's a particular operation taking place that causes the memory spike. Stace -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 27, 2002 2:55 AM To: CF-Talk Subject: RE: CFMX Taking all CPU Resources? Alright guys.. i have tried almost what everybody generally knows to CFMX perfomance.. COM, Trusted Cache, Caching template size, Compile takes time etc... Is there anything else that has NOT been brought up? (MM Docs suck) This is really pityfull... CFMX! might do some EXTRA stuff.. but if it cant scale...atleast close to CF5.0... Why buy DAMN CFMX Sorry on my language.. but this is really frustrating! Joe -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 8:41 PM To: CF-Talk Subject: RE: CFMX Taking all CPU Resources? No we are not using any COM objects. Joe -Original Message- From: Jesse Houwing [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 6:38 PM To: CF-Talk Subject: Re: CFMX Taking all CPU Resources? Joe Eugene wrote: None of the below have IMPROVED Performance. 1. Trusted Cache (Enabled) 2. Increased Template Cache Size (decrease Cache pops) 3. Decreased Consecutive Request to 5 4. Restarted CF APP Service serveral times after setting changes. NONE of these have done any good so far. That's weird. Are you using COM objects? Those have had a severe slowdown in MX. If you are using COM, try replacing them with java or cfc's if possible. Otherwise generate stub's for them (that should speedup COM objects quite a bit). Jesse Todd Rafferty ([EMAIL PROTECTED]) http://www.web-rat.com/ Team Macromedia Volunteer for ColdFusion http://www.macromedia.com/support/forums/team_macromedia/ Moderator @ FlashCFM.com - http://www.flashCFM.com/ Back-end Moderator @ Ultrashock.com - http://www.ultrashock.com/ __ 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: Compliation
So, if you get a chance... make a spider. :) ~Todd On Mon, 29 Jul 2002, Alex Hubner wrote: And, of course, every single change you made on it. []'s Alex -Original Message- From: Critter [mailto:[EMAIL PROTECTED]] Sent: 29/07/2002 11:14 AM To: CF-Talk Subject: Re: Compliation oi Frank!! yeap. takes place on the first hit of the page -- 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) | __ 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
DWMX Webservice Web services types
I have a question that I'm curious about. I've been playing around with DWMX to put webservices into a page since its pretty snazzy. I goto www.xmethods.com and I notice they have like 4 or 5 different type of services. Cold, .net, soap, glue etc etc I cant always the methods onto the page via DWMX. Is this because CFMX doesn't support .net services yet? or is this a bug in DWMX or what? Enlighten me those who have not played with webservices yet. PS this is a prime topical to write and FAQ about for the HOF lists if nobody else does I'll write about it once I figure it all our myself :) Danks Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 __ 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: Issue: Update a tracker database with an index.html file.
I've never gotten SSI to kick off a .cfm page successfully, how did you do this Isaac or .. are you just suggesting this without having tried this for yosuelf? No, it's an assumption. I know that it works with PERL and ASP files ... It's actually the only way that ASP can process included files, which sucks ( for them ) because it means that includes are always processed prior to any logical operators, etc. so dynamic inclusion isn't actually dynamic. But because PERL files given the .pl ( or I'm guessing also .cgi ) extension are ( or can be ) run through the PERL interpreter when they're included this way, I would imagine there's got to be a way to do this with cfm's ... I don't know all the specifics tho, 'cause I've never personally had cause to or been asked to set it up. Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 On Mon, 29 Jul 2002, S. Isaac Dealey wrote: If they're installed, you could use a server side include (SSI) tag to include the ColdFusion module where you want the counter to appear. This is done with hit counters written in PERL to display plain-text hit counts rather than those god-awful graphical hit counters. The cfm would then be able to run your script and display the count. The include tags would look like this: !--#include virtual=/dir/tracker.cfm-- !--#include file=subdir/tracker.cfm-- The other thing you have to check for is that SSI may not work on .html since they're not always enabled for the .html or .htm extensions ( the intended extension was .shtml )... hth Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 -- 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) | __ 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: Issue: Update a tracker database with an index.html file.
Assumptions can make an ass out of u and me... :) ~Todd On Mon, 29 Jul 2002, S. Isaac Dealey wrote: I've never gotten SSI to kick off a .cfm page successfully, how did you do this Isaac or .. are you just suggesting this without having tried this for yosuelf? No, it's an assumption. I know that it works with PERL and ASP files ... It's actually the only way that ASP can process included files, which sucks ( for them ) because it means that includes are always processed prior to any logical operators, etc. so dynamic inclusion isn't actually dynamic. But because PERL files given the .pl ( or I'm guessing also .cgi ) extension are ( or can be ) run through the PERL interpreter when they're included this way, I would imagine there's got to be a way to do this with cfm's ... I don't know all the specifics tho, 'cause I've never personally had cause to or been asked to set it up. Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 -- 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) | __ 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
Macromedia Pet Market demo
I have to say I am blown away by this application. If someone has loaded it, how much of it is CF? Do you have to have MX enterprise to run it, or will MX Pro run the application? http://examples.macromedia.com/petmarket/flashstore.html Great job MM! __ 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: Macromedia Pet Market demo
Front-end Flash, back-end CF. Lots of details about it (how it was made, design notes, all sorts of stuff) at http://www.macromedia.com/desdev/ --- Ben -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 10:40 AM To: CF-Talk Subject: Macromedia Pet Market demo I have to say I am blown away by this application. If someone has loaded it, how much of it is CF? Do you have to have MX enterprise to run it, or will MX Pro run the application? http://examples.macromedia.com/petmarket/flashstore.html Great job MM! __ 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
Studio MX and Homesite - Where is Homesite?
Hi all, I just bought MX Studio - where is Homesite? I need to do a site-wide find and replace. Can I do it in DWMX? Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 __ 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: problems with SSL and host-headers
right. this changes the one of three rule for site identification in IIS. three things identify a virtual site in IIS: 1) IP address. 2) Port number. 3) Host header. change at least one of the three, and you have a different site in IIS. SSL will not work, however, if you're using host headers as your one of three. chris -Original Message- From: WebMaster [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 9:37 AM To: CF-Talk Subject: Re: problems with SSL and host-headers They were correct. Since IIS can't see the header, your request is going to be sent directly to port 443, which is most likely listened to by the default or admin virtual domain.. \ However, this is possible. I have done this in the past using the undefined ports starting at 28000. If you set your SSL port to 28000 for that virtual domain, this should work. You just have to remember to code all your links to point to the correct port. - Original Message - From: Christopher Olive [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 29, 2002 9:28 AM Subject: RE: problems with SSL and host-headers pretty much correct. in IIS, you cannot use host headers to differentiate sites AND use an SSL cert on those sites. the request is encrypted (obviously, it's SSL), and IIS can't see the encrypted host header to know which site to send it to (and which SSL cert to use to decrypt it). -Original Message- From: cf-talk [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 27, 2002 5:16 PM To: CF-Talk Subject: OT: problems with SSL and host-headers Hi list, I have a CF-shared box with one IP-adress. I would like to do the following: Having access to https://subdomain.domain.com:443 I have a valid certificate for this subdomain from Thawte but when I try to connect to that URL I get an error, that there is no such server. I am sure it has s.th. to do with host-headers. Someone else told me, that you can only run one certificate with one port (e.g. 443) on the same IP using host-headers (HTTP 1.1) Can s.o. verify this ? Thanks Uwe __ 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: Macromedia Pet Market demo
MX Pro will run it. Download Petmarket (look for a link in the macromedia desdev section) and check it all out for yourself. ~Todd On Mon, 29 Jul 2002, Chad Gray wrote: I have to say I am blown away by this application. If someone has loaded it, how much of it is CF? Do you have to have MX enterprise to run it, or will MX Pro run the application? http://examples.macromedia.com/petmarket/flashstore.html Great job MM! -- 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) | __ 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: Studio MX and Homesite - Where is Homesite?
You should be able to in DWMX, just hit cntrl-f and take a look at your options there. ~Todd On Mon, 29 Jul 2002, Matthew R. Small wrote: Hi all, I just bought MX Studio - where is Homesite? I need to do a site-wide find and replace. Can I do it in DWMX? Matthew Small IT Supervisor -- 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) | __ 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: Studio MX and Homesite - Where is Homesite?
look in the homesite+ directory on the studio MX cd ;) i had the same issues. Now you're going to have to download the VTM HELP files from the web becuase homesite+ doesnt come with CF HELP *go figure* if you need those links i can try to dig them up if vern doesnt have them handy :) Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 - Original Message - From: Matthew R. Small [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 29, 2002 10:42 AM Subject: Studio MX and Homesite - Where is Homesite? Hi all, I just bought MX Studio - where is Homesite? I need to do a site-wide find and replace. Can I do it in DWMX? Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 __ 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: Issue: Update a tracker database with an index.html file.
Ian, My case is also the the index.html file is on a non CF box. How do you do what you do? You capture the same information I'm looking for? James Blaha Ian Lurie wrote: Hrm. I guess you can do that but the reason we went the JavaScript route was for clients who have index.html files on non-CF servers. I may have misunderstood. Sorry about that... -Original Message- From: WebMaster [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 7:00 AM To: CF-Talk Subject: Re: Issue: Update a tracker database with an index.html file. sure it will work. just map .html to cf - Original Message - From: Ian Lurie [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 29, 2002 9:47 AM Subject: RE: Issue: Update a tracker database with an index.html file. This won't work if the file is an index.html file - your server won't recognize the pound signs. We've gotten around this using Javascript: !--- begin XED clickthru measurement script --- script language=javascript function PageQuery(q) { if(q.length 1) this.q = q.substring(1, q.length); else this.q = null; this.keyValuePairs = new Array(); if(q) { for(var i=0; i this.q.split().length; i++) { this.keyValuePairs[i] = this.q.split()[i]; } } this.getKeyValuePairs = function() { return this.keyValuePairs; } this.getValue = function(s) { for(var j=0; j this.keyValuePairs.length; j++) { if(this.keyValuePairs[j].split(=)[0] == s) return this.keyValuePairs[j].split(=)[1]; } return false; } this.getParameters = function() { var a = new Array(this.getLength()); for(var j=0; j this.keyValuePairs.length; j++) { a[j] = this.keyValuePairs[j].split(=)[0]; } return a; } this.getLength = function() { return this.keyValuePairs.length; } } function queryString(key){ var page = new PageQuery(window.location.search); return unescape(page.getValue(key)); } function displayItem(key){ if(queryString(key)=='false') { var me = 1; } else { var nnn = queryString(key); document.write('img src=http://blahblahblah/recorder/clickrecorder.cfm?ID=' + nnn + 'page=home width=1 height=1'); } } displayItem('ID'); /script You can rebuild this, I think, to grab the referring page... Ian -Original Message- From: WebMaster [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 6:44 AM To: CF-Talk Subject: Re: Issue: Update a tracker database with an index.html file. Use an image tag. The src= can be your CF code which returns a gif. Gif could be transparent. Pass all your user info to the cf page. Ex:cfoutput img src=mycfUserINfoPage.cfm?referrer=#cgi.referer#whateverElse=#wewew# width=0 heifht=0 border=0 /cfoutput - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 29, 2002 9:25 AM Subject: Re: Issue: Update a tracker database with an index.html file. I've never gotten SSI to kick off a .cfm page successfully, how did you do this Isaac or .. are you just suggesting this without having tried this for yosuelf? ~Todd On Mon, 29 Jul 2002, S. Isaac Dealey wrote: If they're installed, you could use a server side include (SSI) tag to include the ColdFusion module where you want the counter to appear. This is done with hit counters written in PERL to display plain-text hit counts rather than those god-awful graphical hit counters. The cfm would then be able to run your script and display the count. The include tags would look like this: !--#include virtual=/dir/tracker.cfm-- !--#include file=subdir/tracker.cfm-- The other thing you have to check for is that SSI may not work on html since they're not always enabled for the .html or .htm extensions ( the intended extension was .shtml )... hth Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 -- 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
Re: Studio MX and Homesite - Where is Homesite?
On Monday, July 29, 2002, at 07:42 , Matthew R. Small wrote: I just bought MX Studio - where is Homesite? I need to do a site-wide find and replace. Can I do it in DWMX? Yes, DWMX will do site-wide find and replace. Note that Dreamweaver MX - part of the Studio MX bundle - contains HomeSite+. You can read the FAQs about CF Studio and HomeSite here: http://www.macromedia.com/software/coldfusionstudio/productinfo/faq/ http://www.macromedia.com/software/homesite/productinfo/faq/ http://www.macromedia.com/software/homesite/productinfo/faq/dw_hs_faq.html Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ 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
Farewemll
Well folks it's been fun, A little too much email for me these days. Been really busy. Thanks for all the help. :) Bye Tim Heald Developer Schoollink, Inc. 910.223.2116 x 122 http://www.schoollink.net Providing technology solutions for educators Fusebox Advisory Committee http://www.fusebox.org Fayetteville ColdFusion User Group http://www.fcfug.org __ 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: FileExists WINNT Mapped Drive Permissions
I agree with Brook. Try UNC paths. Also you may have to set up a CF service account with basic network privileges to be able to browse the network, so to speak, and run the CF service as that account. Be sure to add that user to your Administrators group on the local machine so that it reserves the same rights it had as the local system account. Hope that helps. Mike -Original Message- From: David Fafard [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 28, 2002 3:32 PM To: CF-Talk Subject: Re: FileExists WINNT Mapped Drive Permissions Can we see your code? Sure, watch the wrap. cfset theFormCadNumber = REReplace(#getForms.FormCadNumber#,-| ,,ALL) cfif Len(theFormCadNumber) is not 0 !-- Test for files existance.. if true, build the path.. can one use UNC? -- cfset filePath = P:\Inetpub\wwwroot\CAD_PDF\ #theFormCadNumber# .pdf cfif FileExists(filePath) cfset CadExists =true cfset theURL = http://my.domain.com/Cad_pdf/; #theFormCadNumber# .pdf cfelse cfset CadExists =false /cfif /cfif - Original Message - From: brook [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, July 28, 2002 4:29 PM Subject: Re: FileExists WINNT Mapped Drive Permissions We use UNC paths. This is a better idea, because I beleive (correct me if I am wring) a mapped drive is not automatically mounted at startup. So if your machines reboots, you wil not have access to the mapped drive until you log in. UNC paths are alllow with CF and work fine. Can we see your code? Brook At 02:42 PM 7/28/02 +0200, you wrote: David Fafard wrote: Having a problem getting FileExists to work on an Win NT 2K Server. My Files needed to check are on a mapped drive but it seems CFMX can not see them. ( I would use UNC path but I believe that is not allowed ) It doesn't help since it is a permmissions issue. I'm thinking it's a permissions thing with CFMX service running as LOCAL. Correct. Is there any way to test for a files existance without changing the service to something other than LOCAL? You could use cfimpersonate if you are not on MX yet. Else, change the service. Jochem __ 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
Coldfusion Hiermenus
Hi Has anybody used or had any experience in working with the hiermenus script from http://www.webreference.com/dhtml/hiermenus/ If so as anybosy had any major problems (with positioning etc) with it while implementing the script into their websites? I would be interested to hear if anybody on the list ahs had the same problems as myself. Regards Ian __ 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
Suggestions on importing fixed length file into database
I am going to have to import a fixed length text file into a database. It will be scheduled to happen everyday in the AM. The file could be around 7 or more megs. I have CF 5 on its own box and a SQL 2000 on another. This is what I thought I should do. I will dump the table of the previous days info, open the file with CF and some how loop over its contents and insert into the table. Should I even attempt to do this with CF or see if there is something in SQL 2000 that could handle it better/faster? Thanks, Phillip Broussard Tracker Marine Group 417-873-5957 __ 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: Issue: Update a tracker database with an index.html file.
Hi James, The script below parses the page query string and builds a list of field:value pairs. It then builds an IMG SRC=http://addressofcftemplateonanotherserverhere; tag that calls the CFM template, which is hosted on ANOTHER server that supports CF. Here's the gist - let's say www.portentinteractive.com is not on a CF server. Our measurement software is on another server which DOES support CF - the script that records each click is called clickerrecorder.cfm. So, we include the script below in the index.html page. Then, if you go to http://www.portentinteractive.com/index.html?ID=4, the script writes img src=http://www.servername.com/clickrecorder.cfm?ID=4; into the page, which then calls the .cfm template on . If you need to record the referrer, I'm pretty sure you can grab the referrer using Javascript and then use the script below to build img src=http://www.servername.com/yourcfmpage.cfm?referrer=thepageyoucamefrom; . Does that make sense? I hope this helps... Ian -Original Message- From: James Blaha [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 7:45 AM To: CF-Talk Subject: Re: Issue: Update a tracker database with an index.html file. Ian, My case is also the the index.html file is on a non CF box. How do you do what you do? You capture the same information I'm looking for? James Blaha Ian Lurie wrote: Hrm. I guess you can do that but the reason we went the JavaScript route was for clients who have index.html files on non-CF servers. I may have misunderstood. Sorry about that... -Original Message- From: WebMaster [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 7:00 AM To: CF-Talk Subject: Re: Issue: Update a tracker database with an index.html file. sure it will work. just map .html to cf - Original Message - From: Ian Lurie [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 29, 2002 9:47 AM Subject: RE: Issue: Update a tracker database with an index.html file. This won't work if the file is an index.html file - your server won't recognize the pound signs. We've gotten around this using Javascript: !--- begin XED clickthru measurement script --- script language=javascript function PageQuery(q) { if(q.length 1) this.q = q.substring(1, q.length); else this.q = null; this.keyValuePairs = new Array(); if(q) { for(var i=0; i this.q.split().length; i++) { this.keyValuePairs[i] = this.q.split()[i]; } } this.getKeyValuePairs = function() { return this.keyValuePairs; } this.getValue = function(s) { for(var j=0; j this.keyValuePairs.length; j++) { if(this.keyValuePairs[j].split(=)[0] == s) return this.keyValuePairs[j].split(=)[1]; } return false; } this.getParameters = function() { var a = new Array(this.getLength()); for(var j=0; j this.keyValuePairs.length; j++) { a[j] = this.keyValuePairs[j].split(=)[0]; } return a; } this.getLength = function() { return this.keyValuePairs.length; } } function queryString(key){ var page = new PageQuery(window.location.search); return unescape(page.getValue(key)); } function displayItem(key){ if(queryString(key)=='false') { var me = 1; } else { var nnn = queryString(key); document.write('img src=http://blahblahblah/recorder/clickrecorder.cfm?ID=' + nnn + 'page=home width=1 height=1'); } } displayItem('ID'); /script You can rebuild this, I think, to grab the referring page... Ian -Original Message- From: WebMaster [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 6:44 AM To: CF-Talk Subject: Re: Issue: Update a tracker database with an index.html file. Use an image tag. The src= can be your CF code which returns a gif. Gif could be transparent. Pass all your user info to the cf page. Ex:cfoutput img src=mycfUserINfoPage.cfm?referrer=#cgi.referer#whateverElse=#wewew# width=0 heifht=0 border=0 /cfoutput - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 29, 2002 9:25 AM Subject: Re: Issue: Update a tracker database with an index.html file. I've never gotten SSI to kick off a .cfm page successfully, how did you do this Isaac or .. are you just suggesting this without having tried this for yosuelf? ~Todd On Mon, 29 Jul 2002, S. Isaac Dealey wrote: If they're installed, you could use a server side include (SSI) tag to include the ColdFusion module where you want the counter to appear. This is done with hit counters written in PERL to display plain-text hit counts rather than those god-awful graphical hit counters. The cfm would then be able to run your script and display the count. The include tags would look like this: !--#include virtual=/dir/tracker.cfm-- !--#include file=subdir/tracker.cfm-- The other thing you have to check for is that SSI may not work on html since they're not always enabled for the .html or .htm extensions ( the intended extension was .shtml )... hth Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 --
Re: Suggestions on importing fixed length file into database
Right tool for the job. Doesn't SQL Server have this import capability? On Mon, 29 Jul 2002, Phillip B wrote: I am going to have to import a fixed length text file into a database. It will be scheduled to happen everyday in the AM. The file could be around 7 or more megs. I have CF 5 on its own box and a SQL 2000 on another. This is what I thought I should do. I will dump the table of the previous days info, open the file with CF and some how loop over its contents and insert into the table. Should I even attempt to do this with CF or see if there is something in SQL 2000 that could handle it better/faster? Thanks, Phillip Broussard Tracker Marine Group 417-873-5957 __ 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: Suggestions on importing fixed length file into database
For the love of all that's holy and good, say after me...DTS. SQL2000 has a wonderful set of tools that let you pull and push data around. And you can schedule them. And you can even get CF to trigger the DTS packages. But for simple scheduling, stick with what SQLServer 2000 has avialable. It will get you there easily (as in point and click through 5 screens easily). Jerry Johnson [EMAIL PROTECTED] 07/29/02 11:17AM I am going to have to import a fixed length text file into a database. It will be scheduled to happen everyday in the AM. The file could be around 7 or more megs. I have CF 5 on its own box and a SQL 2000 on another. This is what I thought I should do. I will dump the table of the previous days info, open the file with CF and some how loop over its contents and insert into the table. Should I even attempt to do this with CF or see if there is something in SQL 2000 that could handle it better/faster? Thanks, Phillip Broussard Tracker Marine Group 417-873-5957 __ 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: Suggestions on importing fixed length file into database
I never noticed the schedule later box. If I set it up to run at 4 AM does it get ran like a scheduled task in windows? Disclaimer: I still a newbie when it comes to sql server Phillip Broussard Tracker Marine Group 417-873-5957 Phillip Broussard Tracker Marine Group 417-873-5957 - Original Message - From: Jerry Johnson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 29, 2002 10:38 AM Subject: Re: Suggestions on importing fixed length file into database For the love of all that's holy and good, say after me...DTS. SQL2000 has a wonderful set of tools that let you pull and push data around. And you can schedule them. And you can even get CF to trigger the DTS packages. But for simple scheduling, stick with what SQLServer 2000 has avialable. It will get you there easily (as in point and click through 5 screens easily). Jerry Johnson [EMAIL PROTECTED] 07/29/02 11:17AM I am going to have to import a fixed length text file into a database. It will be scheduled to happen everyday in the AM. The file could be around 7 or more megs. I have CF 5 on its own box and a SQL 2000 on another. This is what I thought I should do. I will dump the table of the previous days info, open the file with CF and some how loop over its contents and insert into the table. Should I even attempt to do this with CF or see if there is something in SQL 2000 that could handle it better/faster? Thanks, Phillip Broussard Tracker Marine Group 417-873-5957 __ 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: Issue: Update a tracker database with an index.html file.
Hi Ian, James, Seems we are getting more info now. OK, so you can't map html to cf. So your choices are PERL,PHP or whatever cgi your provider allows. If they don't allow cgi you could still use the image route and do it using JavaScript as suggested by Ian. You can gather all the info you need from JavaScript and put this into new image() and set the src to the coldFusion page you want. Ian's code below actually shows you how to do this. Nice work Ian. Here is another example: NOTE: I have not tested this so there may be syntax errors. Also note the spelling of referrer. In cgi it is incorrectly spelt with one r. script language=javascript newImg = new image(1,1) // Creates a new image var infoNeeded = ?referrer= + document.referer // Sets infoNeeded to ?referrer=theReferringDocument infoNeeded = infoNeeded + port= + document.port // appends any other needed info to infoNeeded // This code will make the src for the new image call a CF page. This page should return an image. // the code on this page can do whatever you want with the info passed. newImage.src=http://yourdomain.com/yourColdFusionPage.cfm; + infoNeeded //This code will run when the page is loaded, or you can put it in a function and call it with onLoad in the body tag. /script - Original Message - From: James Blaha [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 29, 2002 10:45 AM Subject: Re: Issue: Update a tracker database with an index.html file. Ian, My case is also the the index.html file is on a non CF box. How do you do what you do? You capture the same information I'm looking for? James Blaha Ian Lurie wrote: Hrm. I guess you can do that but the reason we went the JavaScript route was for clients who have index.html files on non-CF servers. I may have misunderstood. Sorry about that... -Original Message- From: WebMaster [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 7:00 AM To: CF-Talk Subject: Re: Issue: Update a tracker database with an index.html file. sure it will work. just map .html to cf - Original Message - From: Ian Lurie [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 29, 2002 9:47 AM Subject: RE: Issue: Update a tracker database with an index.html file. This won't work if the file is an index.html file - your server won't recognize the pound signs. We've gotten around this using Javascript: !--- begin XED clickthru measurement script --- script language=javascript function PageQuery(q) { if(q.length 1) this.q = q.substring(1, q.length); else this.q = null; this.keyValuePairs = new Array(); if(q) { for(var i=0; i this.q.split().length; i++) { this.keyValuePairs[i] = this.q.split()[i]; } } this.getKeyValuePairs = function() { return this.keyValuePairs; } this.getValue = function(s) { for(var j=0; j this.keyValuePairs.length; j++) { if(this.keyValuePairs[j].split(=)[0] == s) return this.keyValuePairs[j].split(=)[1]; } return false; } this.getParameters = function() { var a = new Array(this.getLength()); for(var j=0; j this.keyValuePairs.length; j++) { a[j] = this.keyValuePairs[j].split(=)[0]; } return a; } this.getLength = function() { return this.keyValuePairs.length; } } function queryString(key){ var page = new PageQuery(window.location.search); return unescape(page.getValue(key)); } function displayItem(key){ if(queryString(key)=='false') { var me = 1; } else { var nnn = queryString(key); document.write('img src=http://blahblahblah/recorder/clickrecorder.cfm?ID=' + nnn + 'page=home width=1 height=1'); } } displayItem('ID'); /script You can rebuild this, I think, to grab the referring page... Ian -Original Message- From: WebMaster [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 6:44 AM To: CF-Talk Subject: Re: Issue: Update a tracker database with an index.html file. Use an image tag. The src= can be your CF code which returns a gif. Gif could be transparent. Pass all your user info to the cf page. Ex:cfoutput img src=mycfUserINfoPage.cfm?referrer=#cgi.referer#whateverElse=#wewew# width=0 heifht=0 border=0 /cfoutput - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 29, 2002 9:25 AM Subject: Re: Issue: Update a tracker database with an index.html file. I've never gotten SSI to kick off a .cfm page successfully, how did you do this Isaac or .. are you just suggesting this without having tried this for yosuelf? ~Todd On Mon, 29 Jul 2002, S. Isaac Dealey wrote: If they're installed, you could use a server side include (SSI) tag to include the ColdFusion module where you want the counter to appear. This is done with hit counters written in PERL to display plain-text hit counts rather than those god-awful graphical hit counters. The cfm would then be able to run your script and display the count. The
Checking form info
I have a form with with 5 text fill ins, and I want to check to see if some aren't entered. For instance, I might have Field 1,2, and 5 filled in and 3 and 4 blank. I was using code like this: CFLOOP index=Answers from=1 to=5 step=1 CFSET Form.AnswerHeading=Form[AnswerHeadingAnswers] CFSET Form.AnswerValue=Form[AnswerValueAnswers] CFSET Form.AnswerID=Form[AnswerIDAnswers] To get the data from the form fields, but if the field is blank this crashes, and I can't get an IsDefined to work - I was using this: CFIF IsDefined(Form[AnswerValueAnswers] Any ideas would be appreciated. T __ 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: FileExists WINNT Mapped Drive Permissions
Good suggestion on the CF Service Account.. thanks. Dave - Original Message - From: Mike Byers [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 29, 2002 11:11 AM Subject: RE: FileExists WINNT Mapped Drive Permissions I agree with Brook. Try UNC paths. Also you may have to set up a CF service account with basic network privileges to be able to browse the network, so to speak, and run the CF service as that account. Be sure to add that user to your Administrators group on the local machine so that it reserves the same rights it had as the local system account. Hope that helps. Mike -Original Message- From: David Fafard [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 28, 2002 3:32 PM To: CF-Talk Subject: Re: FileExists WINNT Mapped Drive Permissions Can we see your code? Sure, watch the wrap. cfset theFormCadNumber = REReplace(#getForms.FormCadNumber#,-| ,,ALL) cfif Len(theFormCadNumber) is not 0 !-- Test for files existance.. if true, build the path.. can one use UNC? -- cfset filePath = P:\Inetpub\wwwroot\CAD_PDF\ #theFormCadNumber# .pdf cfif FileExists(filePath) cfset CadExists =true cfset theURL = http://my.domain.com/Cad_pdf/; #theFormCadNumber# .pdf cfelse cfset CadExists =false /cfif /cfif - Original Message - From: brook [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, July 28, 2002 4:29 PM Subject: Re: FileExists WINNT Mapped Drive Permissions We use UNC paths. This is a better idea, because I beleive (correct me if I am wring) a mapped drive is not automatically mounted at startup. So if your machines reboots, you wil not have access to the mapped drive until you log in. UNC paths are alllow with CF and work fine. Can we see your code? Brook At 02:42 PM 7/28/02 +0200, you wrote: David Fafard wrote: Having a problem getting FileExists to work on an Win NT 2K Server. My Files needed to check are on a mapped drive but it seems CFMX can not see them. ( I would use UNC path but I believe that is not allowed ) It doesn't help since it is a permmissions issue. I'm thinking it's a permissions thing with CFMX service running as LOCAL. Correct. Is there any way to test for a files existance without changing the service to something other than LOCAL? You could use cfimpersonate if you are not on MX yet. Else, change the service. 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: Session Woes
Tony, I've proofread twice your statement against what's in the CF Studio help for CFAPPLICATION, and I can see nothing wrong. The only things I can imagine: 1) Do you have another Application.cfm in some folder that could be fouling things up? 2) Is it possible that what seems to be the 20-minute timeout comes really from an accidental erasure or modification of the session variable in question? I would search the application for all instances of the session variable name to be sure that I'm not erasing/changing it elsewhere. 3) If none of that does it, then I would take your existing CFAPPLICATION tag, paste it into a blank file, and save that as Application.cfm in a new subfolder. Change the application name to something new. Then put one other file in that folder and check the variable, to be 100% sure that there is some problem other than a typo or something. I hope this is helpful, Matthieu -Original Message- From: Tony Gruen [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 27, 2002 9:23 PM To: CF-Talk Subject: RE: Session Woes Ken, Thanks for the reply. I have the session and application set to 1 day in the admin. It seems to last about 20 minutes (although I have not timed it specifically). I seem to remember that 20 minutes is default unless you over-ride it with the scope setting that's what has me scratching my head. I was thinking I overlooked something simple (which is usually the case). Tony -Original Message- From: Ken Wilson [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 27, 2002 6:14 PM To: CF-Talk Subject: RE: Session Woes What's the max timeout value set to in the CF Admin? Doesn't matter what you set it to in your cfapplication tag...if the admin setting is less it will timeout. Ken -Original Message- From: Tony Gruen [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 27, 2002 8:34 PM To: CF-Talk Subject: Session Woes Hello List-Members, I have an issue with sessions that is escaping me. I have the session setup using the scope below yet it still seems to timeout pre-maturely. It is important that I not have the session timeout for 5-8 hours because the application is being used over the course of a normal work day. Have I missed something? I have been researching what other settings I may need and cannot find the culprit. CFAPPLICATION NAME=AppName CLIENTMANAGEMENT=Yes CLIENTSTORAGE=Registry SETCLIENTCOOKIES=Yes SESSIONMANAGEMENT=Yes SESSIONTIMEOUT=#CREATETIMESPAN(0, 5, 0, 0)# APPLICATIONTIMEOUT=#CREATETIMESPAN(0, 5, 0, 0)# SETDOMAINCOOKIES=No __ 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: Coldfusion Hiermenus
We got them to work and they were great on a fast machine, but testing from an older P150 machine they were incredibly slow to build. Of course we wanted to have multiple levels, etc. We tore them apart and tried removing as much 'optional' code, still leaving them cross-browser, and we couldn't get them to be any faster. Single level menus would have been fine, but that didn't meet our needs. Positioning was never a problem ... probably been two years since we did it, so we didn't have Netscape 6+ to deal with at the time. Dan -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 8:10 AM To: CF-Talk Subject: Coldfusion Hiermenus Hi Has anybody used or had any experience in working with the hiermenus script from http://www.webreference.com/dhtml/hiermenus/ If so as anybosy had any major problems (with positioning etc) with it while implementing the script into their websites? I would be interested to hear if anybody on the list ahs had the same problems as myself. Regards Ian __ 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
anyone having list troubles ?
Sorry for the OT post, but I seem to be receiving this list sporadically. The last post I received was from [EMAIL PROTECTED] (suject: Re: Issue: Update a tracker database with an index.html file. content: Assumptions can make an ass out of u and me... :)) My ISP insists my mail server is ok. Before I hassle them, have there been any posts since then? TIA -Craig __ 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: FileExists WINNT Mapped Drive Permissions
I have found Service Accounts very handy. Reduces password administration issues as well as many security concerns. Glad I could help. Mike -Original Message- From: David Fafard [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 10:35 AM To: CF-Talk Subject: Re: FileExists WINNT Mapped Drive Permissions Good suggestion on the CF Service Account.. thanks. Dave - Original Message - From: Mike Byers [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 29, 2002 11:11 AM Subject: RE: FileExists WINNT Mapped Drive Permissions I agree with Brook. Try UNC paths. Also you may have to set up a CF service account with basic network privileges to be able to browse the network, so to speak, and run the CF service as that account. Be sure to add that user to your Administrators group on the local machine so that it reserves the same rights it had as the local system account. Hope that helps. Mike -Original Message- From: David Fafard [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 28, 2002 3:32 PM To: CF-Talk Subject: Re: FileExists WINNT Mapped Drive Permissions Can we see your code? Sure, watch the wrap. cfset theFormCadNumber = REReplace(#getForms.FormCadNumber#,-| ,,ALL) cfif Len(theFormCadNumber) is not 0 !-- Test for files existance.. if true, build the path.. can one use UNC? -- cfset filePath = P:\Inetpub\wwwroot\CAD_PDF\ #theFormCadNumber# .pdf cfif FileExists(filePath) cfset CadExists =true cfset theURL = http://my.domain.com/Cad_pdf/; #theFormCadNumber# .pdf cfelse cfset CadExists =false /cfif /cfif - Original Message - From: brook [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, July 28, 2002 4:29 PM Subject: Re: FileExists WINNT Mapped Drive Permissions We use UNC paths. This is a better idea, because I beleive (correct me if I am wring) a mapped drive is not automatically mounted at startup. So if your machines reboots, you wil not have access to the mapped drive until you log in. UNC paths are alllow with CF and work fine. Can we see your code? Brook At 02:42 PM 7/28/02 +0200, you wrote: David Fafard wrote: Having a problem getting FileExists to work on an Win NT 2K Server. My Files needed to check are on a mapped drive but it seems CFMX can not see them. ( I would use UNC path but I believe that is not allowed ) It doesn't help since it is a permmissions issue. I'm thinking it's a permissions thing with CFMX service running as LOCAL. Correct. Is there any way to test for a files existance without changing the service to something other than LOCAL? You could use cfimpersonate if you are not on MX yet. Else, change the service. Jochem __ 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: anyone having list troubles ?
Yours :) -Original Message- From: Craig Thomas [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 9:52 AM To: CF-Talk Subject: anyone having list troubles ? Sorry for the OT post, but I seem to be receiving this list sporadically. The last post I received was from [EMAIL PROTECTED] (suject: Re: Issue: Update a tracker database with an index.html file. content: Assumptions can make an ass out of u and me... :)) My ISP insists my mail server is ok. Before I hassle them, have there been any posts since then? TIA -Craig __ 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
Email Parser
Anyone know any good places to get a CF based or PERL based email parser to check for INVALID emails? Thanks 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
RE: anyone having list troubles ?
I see that same problem sometimes ... the other day I received 100 list emails at one time, but the threads had continued while I wasn't getting them, so the list server was working fine ... and of course my admin says there's no problem here! Dan -Original Message- From: Craig Thomas [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 8:52 AM To: CF-Talk Subject: anyone having list troubles ? Sorry for the OT post, but I seem to be receiving this list sporadically. The last post I received was from [EMAIL PROTECTED] (suject: Re: Issue: Update a tracker database with an index.html file. content: Assumptions can make an ass out of u and me... :)) My ISP insists my mail server is ok. Before I hassle them, have there been any posts since then? TIA -Craig __ 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: Coldfusion Hiermenus
As previously mentioned, when Hiermenus starts piling on the levels it slows *way* down. I had a 50-page site that looked to be taking about a full second for the menu to appear. Milonic menus are a lot faster. http://californiahia.org has a 68-page menu, and it loads instantly from what I can tell. The thing expands out to 200 if you log in, and still loads fast. I wrote a couple of tags that work with it; one freebie and one that costs a few bucks, but includes a $30 Milonic license in its $35 price tag... Which brings up another HierMenus issue: that aforementioned 50-page site would cost something like $1500 to license, which is ridiculous. --Matt Robertson-- MSB Designs, Inc. http://foohbar.org -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 8:10 AM To: CF-Talk Subject: Coldfusion Hiermenus Hi Has anybody used or had any experience in working with the hiermenus script from http://www.webreference.com/dhtml/hiermenus/ If so as anybosy had any major problems (with positioning etc) with it while implementing the script into their websites? I would be interested to hear if anybody on the list ahs had the same problems as myself. Regards Ian __ 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: anyone having list troubles ?
Sorry, didn't answer your question ... yes, there have been quite a few posts since then ... -Original Message- From: Craig Thomas [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 8:52 AM To: CF-Talk Subject: anyone having list troubles ? Sorry for the OT post, but I seem to be receiving this list sporadically. The last post I received was from [EMAIL PROTECTED] (suject: Re: Issue: Update a tracker database with an index.html file. content: Assumptions can make an ass out of u and me... :)) My ISP insists my mail server is ok. Before I hassle them, have there been any posts since then? TIA -Craig __ 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: Email Parser
Look this CustomTag http://www.cfmentor.com/code/index.cfm?action=scriptid=59 Bye Gianluca Pinelli web developer - Speedlab e-business transforming http://www.speedlab.it [EMAIL PROTECTED] - Original Message - From: Bill Wheatley [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 29, 2002 5:49 PM Subject: Email Parser Anyone know any good places to get a CF based or PERL based email parser to check for INVALID emails? Thanks Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 __ 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: Checking form info
What is it your trying to do in the cfsets? Structure? Ade -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED]] Sent: 29 July 2002 16:33 To: CF-Talk Subject: Checking form info I have a form with with 5 text fill ins, and I want to check to see if some aren't entered. For instance, I might have Field 1,2, and 5 filled in and 3 and 4 blank. I was using code like this: CFLOOP index=Answers from=1 to=5 step=1 CFSET Form.AnswerHeading=Form[AnswerHeadingAnswers] CFSET Form.AnswerValue=Form[AnswerValueAnswers] CFSET Form.AnswerID=Form[AnswerIDAnswers] To get the data from the form fields, but if the field is blank this crashes, and I can't get an IsDefined to work - I was using this: CFIF IsDefined(Form[AnswerValueAnswers] Any ideas would be appreciated. T __ 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: Coldfusion Hiermenus
Hi Has anybody used or had any experience in working with the hiermenus script from http://www.webreference.com/dhtml/hiermenus/ If so as anybosy had any major problems (with positioning etc) with it while implementing the script into their websites? I would be interested to hear if anybody on the list ahs had the same problems as myself. While not having worked with them, the one thing I do know is that they are no longer free and now charge an obscene amount of money for a license. I would recommend looking at these: 1. Milonic (http://milonic.co.uk/menu/) 2. PopUpMenuPro (http://www.quilldesign.com/popupmenupro/index.cfm) 3. Burmees (http://www.burmees.nl/menu/menus.htm) 4. AllWeb Menus (http://www.likno.com/) We were using HierMenus at one point, and I really don't have many complaints. But then they told us a license would be around $10K, I laughed and switched menu systems. Regards, Dave. __ 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: Checking form info
I have a form with with 5 text fill ins, and I want to check to see if some aren't entered. For instance, I might have Field 1,2, and 5 filled in and 3 and 4 blank. I was using code like this: CFLOOP index=Answers from=1 to=5 step=1 CFSET Form.AnswerHeading=Form[AnswerHeadingAnswers] CFSET Form.AnswerValue=Form[AnswerValueAnswers] CFSET Form.AnswerID=Form[AnswerIDAnswers] To get the data from the form fields, but if the field is blank this crashes, and I can't get an IsDefined to work - I was using this: CFIF IsDefined(Form[AnswerValueAnswers] Any ideas would be appreciated. Yea, you don't want to use array notation with IsDefined() generally speaking ... although the syntax above is broken anyway... You would need to use single-quotes within the double-quotes of the IsDefined() for the array notation on the form, and you need to close the isdefined() parenthesis on the end... however... generally speaking, if you want to check to see if a form parameter is defined, I would use cfif isdefined(form.AnswerValue#answers#) and just make sure none of your form field names contain any special characters like hyphens. If you really need a hypen, you can check the keys of the form structure with something like this cfif ListFindNoCase(StructKeyList(form),AnswerValue#answers#) Otherwise, as a general rule, rather than using IsDefined(), I would use a cfparam tag to ensure that the form variable exists ( again, avoid special characters ) ... cfparam name=form.AnswerValue#answers# type=string value= And remember to double-check your form fields with the CF debugging output... if necessary use cfsetting showdebugoutput=yes at the top of your page -- although I think you still have to have your ip address in the cfadmin's debugging ip's for that to work. hth Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 __ 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: Checking form info
To get the IsDefined() to work, try this: CFIF IsDefined(Form.AnswerValue#Answers#) Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 11:33 AM To: CF-Talk Subject: Checking form info I have a form with with 5 text fill ins, and I want to check to see if some aren't entered. For instance, I might have Field 1,2, and 5 filled in and 3 and 4 blank. I was using code like this: CFLOOP index=Answers from=1 to=5 step=1 CFSET Form.AnswerHeading=Form[AnswerHeadingAnswers] CFSET Form.AnswerValue=Form[AnswerValueAnswers] CFSET Form.AnswerID=Form[AnswerIDAnswers] To get the data from the form fields, but if the field is blank this crashes, and I can't get an IsDefined to work - I was using this: CFIF IsDefined(Form[AnswerValueAnswers] Any ideas would be appreciated. T __ 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: Email Parser
What's your definition of INVALID? Do you mean a regular expression to check an email or do you mean a nslookup to check a mx record? On Mon, 29 Jul 2002, Bill Wheatley wrote: Anyone know any good places to get a CF based or PERL based email parser to check for INVALID emails? Thanks Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 __ 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: Email Parser
This question is a good candidate for the new FAQ! This RegEx was recommended recently on the list and it includes the new top-level domains: ^['_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*\.(([a-z]{2,3})|(aero |coop|info|museum|name))$ Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 11:50 AM To: CF-Talk Subject: Email Parser Anyone know any good places to get a CF based or PERL based email parser to check for INVALID emails? Thanks Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 __ 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
Spaces stripped out of query return values?
I have a form that has a SELECT list in which I'm trying to trick into displaying multiple columns in the select list. I'm doing this by how I'm returning the values from my query. I'm querying an Oracle database, and my query is: cfQuery name=defaultList dataSource=#dataSource# SELECT rpad(username, 20, chr(32))|| rpad(project_folder, 20, chr(32))|| rpad(project_file, 20, chr(32))|| rpad(to_char(blk_h, 'DD-MON-'), 20, chr(32)) listItemDisplay ,username||'/'||project_folder||'/'||project_file listItemValue FROM dids_project_file_info WHERE project_submitted = 'SUBMITTED' ORDER BY username, project_folder, project_file, blk_h /cfQuery So I'm basically trying to concatenate four values together, with spaces concatenated to the end of each value out to 20 characters for each value, and return it as one value (listItemDisplay). How when I execute this query against the database with any standard query tool, it displays the results correctly like this: COUTURGDStevens MMW--HRL 24-JUL-2002 COUTURGDStevens WaveBand-MMW18-JUL-2002 OHARAWTBLODGETTacoustic 08-APR-2002 My problem is that when I try to dynamically create the select list with the following code: select id=fileList name=fileList size=10 class=form_field style=width: 450px cfLoop query=defaultList cfOutputoption value=#listItemValue##listItemDisplay#/option/cfOutput /cfLoop /select The displayed values come out with the padded spaces stripped of, and display like this: COUTURGD Stevens MMW--HRL 24-JUL-2002 COUTURGD Stevens WaveBand-MMW 18-JUL-2002 OHARAWT BLODGETT acoustic 08-APR-2002 Does anyone have any ideas why these spaces are being stripped, and how I might be able to keep them so that the values are displayed in the list correctly (as columns)? Any ideas would be greatly appreciated. Thanks in advance. ::YEX:: /* || Robert D. Yexley || Oracle Programmer/Analyst || Easylink Services Corporation || Professional Services || Contractor - Wright Research Site MIS || Det-1 AFRL/WSI Bldg. 45 Rm. 062 || (937) 255-1984 || [EMAIL PROTECTED] || ))) */ Robert D. Yexley (E-mail).vcf __ 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: Email Parser
well Just to first regexp check to make sure the emails in the right format then I want to add something to check it against a list of OBVIOUS mistakes like we have about 25 million emails that are not emailing out and alot of hatmail.com or hotmal.com typos for hotmail.com so I want to check for those matches and update the record to hotmail.com something like that :) thanks Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 - Original Message - From: Alex [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 29, 2002 12:07 PM Subject: Re: Email Parser What's your definition of INVALID? Do you mean a regular expression to check an email or do you mean a nslookup to check a mx record? On Mon, 29 Jul 2002, Bill Wheatley wrote: Anyone know any good places to get a CF based or PERL based email parser to check for INVALID emails? Thanks Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 __ 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: Email Parser
What's your definition of INVALID? Do you mean a regular expression to check an email or do you mean a nslookup to check a mx record? My first guess was to parse returned email from mailerdaemons to determine if the address had transient or permanent fatal errors, retreive the address and do something with it based on the type of errors returned... Though that's just a guess. :) Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 __ 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: Spaces stripped out of query return values?
It's an HTML thing, it will reduce many spaces to one, try replacing the spaces with nbsp; Ade -Original Message- From: Yexley Robert D Contr Det 1 AFRL/WSI [mailto:[EMAIL PROTECTED]] Sent: 29 July 2002 17:06 To: CF-Talk Subject: Spaces stripped out of query return values? I have a form that has a SELECT list in which I'm trying to trick into displaying multiple columns in the select list. I'm doing this by how I'm returning the values from my query. I'm querying an Oracle database, and my query is: cfQuery name=defaultList dataSource=#dataSource# SELECT rpad(username, 20, chr(32))|| rpad(project_folder, 20, chr(32))|| rpad(project_file, 20, chr(32))|| rpad(to_char(blk_h, 'DD-MON-'), 20, chr(32)) listItemDisplay ,username||'/'||project_folder||'/'||project_file listItemValue FROM dids_project_file_info WHERE project_submitted = 'SUBMITTED' ORDER BY username, project_folder, project_file, blk_h /cfQuery So I'm basically trying to concatenate four values together, with spaces concatenated to the end of each value out to 20 characters for each value, and return it as one value (listItemDisplay). How when I execute this query against the database with any standard query tool, it displays the results correctly like this: COUTURGDStevens MMW--HRL 24-JUL-2002 COUTURGDStevens WaveBand-MMW 18-JUL-2002 OHARAWTBLODGETTacoustic 08-APR-2002 My problem is that when I try to dynamically create the select list with the following code: select id=fileList name=fileList size=10 class=form_field style=width: 450px cfLoop query=defaultList cfOutputoption value=#listItemValue##listItemDisplay#/option/cfOutput /cfLoop /select The displayed values come out with the padded spaces stripped of, and display like this: COUTURGD Stevens MMW--HRL 24-JUL-2002 COUTURGD Stevens WaveBand-MMW 18-JUL-2002 OHARAWT BLODGETT acoustic 08-APR-2002 Does anyone have any ideas why these spaces are being stripped, and how I might be able to keep them so that the values are displayed in the list correctly (as columns)? Any ideas would be greatly appreciated. Thanks in advance. ::YEX:: /* || Robert D. Yexley || Oracle Programmer/Analyst || Easylink Services Corporation || Professional Services || Contractor - Wright Research Site MIS || Det-1 AFRL/WSI Bldg. 45 Rm. 062 || (937) 255-1984 || [EMAIL PROTECTED] || ))) */ Robert D. Yexley (E-mail).vcf __ 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[2]: problems with SSL and host-headers
Hello Christopher, Monday, July 29, 2002, 4:43:40 PM, you wrote: CO right. this changes the one of three rule for site identification in IIS. CO three things identify a virtual site in IIS: CO 1) IP address. CO 2) Port number. CO 3) Host header. CO change at least one of the three, and you have a different site in IIS. CO SSL will not work, however, if you're using host headers as your one of CO three. CO chris CO -Original Message- CO From: WebMaster [mailto:[EMAIL PROTECTED]] CO Sent: Monday, July 29, 2002 9:37 AM CO To: CF-Talk CO Subject: Re: problems with SSL and host-headers CO They were correct. Since IIS can't see the header, your request is going to CO be sent directly to port 443, which is most likely listened to by the CO default or admin virtual domain.. \ CO However, this is possible. I have done this in the past using the undefined CO ports starting at 28000. If you set your SSL port to 28000 for that virtual CO domain, this should work. You just have to remember to code all your links CO to point to the correct port. CO - Original Message - CO From: Christopher Olive [EMAIL PROTECTED] CO To: CF-Talk [EMAIL PROTECTED] CO Sent: Monday, July 29, 2002 9:28 AM CO Subject: RE: problems with SSL and host-headers pretty much correct. in IIS, you cannot use host headers to differentiate sites AND use an SSL cert on those sites. the request is encrypted (obviously, it's SSL), and IIS can't see the encrypted host header to know which site to send it to (and which SSL cert to use to decrypt it). -Original Message- From: cf-talk [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 27, 2002 5:16 PM To: CF-Talk Subject: OT: problems with SSL and host-headers Hi list, I have a CF-shared box with one IP-adress. I would like to do the following: Having access to https://subdomain.domain.com:443 I have a valid certificate for this subdomain from Thawte but when I try to connect to that URL I get an error, that there is no such server. I am sure it has s.th. to do with host-headers. Someone else told me, that you can only run one certificate with one port (e.g. 443) on the same IP using host-headers (HTTP 1.1) Can s.o. verify this ? Thanks Uwe CO __ 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: Email Parser
And don't forget all the AOL users who forget the .com or the aol.com (just providing their screen name). That one feels like an epidemic sometimes. -Original Message- From: Bill Wheatley [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 12:12 PM To: CF-Talk Subject: Re: Email Parser well Just to first regexp check to make sure the emails in the right format then I want to add something to check it against a list of OBVIOUS mistakes like we have about 25 million emails that are not emailing out and alot of hatmail.com or hotmal.com typos for hotmail.com so I want to check for those matches and update the record to hotmail.com something like that :) thanks Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 - Original Message - From: Alex [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 29, 2002 12:07 PM Subject: Re: Email Parser What's your definition of INVALID? Do you mean a regular expression to check an email or do you mean a nslookup to check a mx record? On Mon, 29 Jul 2002, Bill Wheatley wrote: Anyone know any good places to get a CF based or PERL based email parser to check for INVALID emails? Thanks Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 __ 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: Re[2]: problems with SSL and host-headers
yes. yes i did write that. co. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 12:19 PM To: CF-Talk Subject: Re[2]: problems with SSL and host-headers Hello Christopher, Monday, July 29, 2002, 4:43:40 PM, you wrote: CO right. this changes the one of three rule for site identification in IIS. CO three things identify a virtual site in IIS: CO 1) IP address. CO 2) Port number. CO 3) Host header. CO change at least one of the three, and you have a different site in IIS. CO SSL will not work, however, if you're using host headers as your one of CO three. CO chris CO -Original Message- CO From: WebMaster [mailto:[EMAIL PROTECTED]] CO Sent: Monday, July 29, 2002 9:37 AM CO To: CF-Talk CO Subject: Re: problems with SSL and host-headers CO They were correct. Since IIS can't see the header, your request is going to CO be sent directly to port 443, which is most likely listened to by the CO default or admin virtual domain.. \ CO However, this is possible. I have done this in the past using the undefined CO ports starting at 28000. If you set your SSL port to 28000 for that virtual CO domain, this should work. You just have to remember to code all your links CO to point to the correct port. CO - Original Message - CO From: Christopher Olive [EMAIL PROTECTED] CO To: CF-Talk [EMAIL PROTECTED] CO Sent: Monday, July 29, 2002 9:28 AM CO Subject: RE: problems with SSL and host-headers pretty much correct. in IIS, you cannot use host headers to differentiate sites AND use an SSL cert on those sites. the request is encrypted (obviously, it's SSL), and IIS can't see the encrypted host header to know which site to send it to (and which SSL cert to use to decrypt it). -Original Message- From: cf-talk [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 27, 2002 5:16 PM To: CF-Talk Subject: OT: problems with SSL and host-headers Hi list, I have a CF-shared box with one IP-adress. I would like to do the following: Having access to https://subdomain.domain.com:443 I have a valid certificate for this subdomain from Thawte but when I try to connect to that URL I get an error, that there is no such server. I am sure it has s.th. to do with host-headers. Someone else told me, that you can only run one certificate with one port (e.g. 443) on the same IP using host-headers (HTTP 1.1) Can s.o. verify this ? Thanks Uwe CO __ 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 Taking all CPU Resources?
Stacy, I am still in the process of Load Testing different sections of the Content App... I suspect.. Its something to do with (Wddx datastore,Custom tags etc) We didnt write this code...and i dont advice the method the app was written. I will post some Code/Results .. when i find out something. Maybe Wddx is implemented different in CFMXdont know. Think there were 2-3 Wddx options added in CFMX. In the mean time.. if you have time to test.. you can try MS Web Load Testing tool. http://www.microsoft.com/technet/treeview/default.asp?url=/TechNet/itsolutio ns/intranet/downloads/webstres.asp?frame=true Optimizing code should be fairly easy.. once we can find the problem. Thanks Joe - Original Message - From: Stacy Young [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 29, 2002 7:10 AM Subject: RE: CFMX Taking all CPU Resources? Joe. Please track down the portion of your app that causes the CPU spike and post the code. Then I'm sure plenty of folks will have ideas on how to optimize. Stace -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 28, 2002 11:25 PM To: CF-Talk Subject: RE: CFMX Taking all CPU Resources? This is really funny over and over.. no facts/proofs of test by anybody I would really be exited and happy to know that CFMX Scales... If i can see some facts/proofs. Joe -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 28, 2002 11:05 PM To: CF-Talk Subject: Re: CFMX Taking all CPU Resources? On Sunday, July 28, 2002, at 05:57 , Joe Eugene wrote: I am having a hard time.. conveying the messsage.. Yes, so it seems :) We are talking about basic code in ColdFusion.. every answer i get is like.. Custom Tags..(oh for CFMX u need to do this.. or this is how you can Optimize.. for CFMX...CFC .. function blah blah) That's because you are not being specific about what code you are testing that is running slower. Show us your code! Nobody has said.. alright.. if you code CFLOOP this way in CF5.0 you can speed it up writing CFLOOP like THIS(.) in CFMX. Because the code fragment you posted did not seem to be real code (a simple cfloop that created an impossibly long string). No one has suggested that such basic constructs need rewriting in CFMX. Custom tag invocation is definitely faster - several people here have testified to that. ARE YOU GUYS SAYING THAT CFMX is 10% FASTER THAN CF5.0? If so.. What were the TESTS you did to prove this? READ THE PERFORMANCE BRIEF! As Todd (I think?) said, people are beginning to tune you out because you are not providing any facts. Try to be specific. Show us code that you've tested that is slower on CFMX and then we can see why that is. NOTE: Sean... i read quite a lot from here and there.. its awfully.. hard for me to write down who the author,published date.. etc everytime i read something. Why is it hard? You read something, you make a note of the article. C'mon Joe, you're whining a lot but you're not backing it up with details. . If you're not annoying somebody, you're not really alive. -- Margaret Atwood __ 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: Email Parser
then I want to add something to check it against a list of OBVIOUS mistakes Why don't you try the CFUSION_VERIFYMAIL?? I think is good for your case. Gianluca Pinelli web developer - Speedlab e-business transforming http://www.speedlab.it [EMAIL PROTECTED] __ 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
query string variable idea
Hi, there. In trying to solve a problem this weekend, it occurred to me that I could easily handle my situation by passing a particular URL variable with every link on my site. Unfortunately, that would mean going through and appending that URL variable to every link on my site, so I ended up going with a different solution. But then it occurred to me that I might be onto an idea for a future project. Why not set up my site so that every link on the site has the local variable AppendToQueryString added to it. So, every link would look like this: a href= http://www.mysite.com/subdir/file.cfm#Variables.AppendToQueryString http://www.mysite.com/subdir/file.cfm#Variables.AppendToQueryString # In the Application.cfm, I set Variables.AppendToQueryString equal to ?noQS. That way, any time that I want to solve a problem by adding a particular query string variable, I can just add it on to Variables.AppendToQueryString in the appropriate page. I can also add things across the site by changing the default value in Application.cfm. This is all hypothetical: for now, I have no need for it. But I was wondering whether taking this infrastructure step is problematic for some reason, or if there is some established better way of doing it. Any thoughts? Thanks, Matthieu __ 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
DB Queries and UDFs
It is my understanding that I cannot run DB queries inside of a UDF. If there is a way, I would like that alot. If there isn't, may I pass the Query results into the UDF? If I can, is it just the name of the query? Is it an Array? Thanks! __ 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: DB Queries and UDFs
If you use CFMX then you can indeed create queries inside of a UDF. And either way, you can pass a query to a UDF. If you are using CFSCRIPT syntax then you'll need to use a loop and access the query members as query.column[row]. --- Ben -Original Message- From: Chris Edwards [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 12:57 PM To: CF-Talk Subject: DB Queries and UDFs It is my understanding that I cannot run DB queries inside of a UDF. If there is a way, I would like that alot. If there isn't, may I pass the Query results into the UDF? If I can, is it just the name of the query? Is it an Array? Thanks! __ 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: DB Queries and UDFs
It is my understanding that I cannot run DB queries inside of a UDF. This is true in CF 5, but not CF MX - you can use the CFFUNCTION tags to declare a UDF, and use CFQUERY within that. If there is a way, I would like that alot. If there isn't, may I pass the Query results into the UDF? If I can, is it just the name of the query? Is it an Array? You can simply pass the query object itself to the UDF; it'll be passed by reference, by default. In that case, any changes made within the function to the query object will be reflected in the query object outside of the function. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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: DB Queries and UDFs
Unless of yourse, you're creating UDFs via cffunction, then I would imagine you could still use cfloop query=queryObjectName.. :) ~Todd On Mon, 29 Jul 2002, Ben Forta wrote: If you use CFMX then you can indeed create queries inside of a UDF. And either way, you can pass a query to a UDF. If you are using CFSCRIPT syntax then you'll need to use a loop and access the query members as query.column[row]. --- Ben -- 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) | __ 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: anyone having list troubles ?
The HoF server tries to send a post as soon as it receives it. If it can't send, then the mail gets cached till later. The cache is tried every hour till it can be sent or I clean it out. Some examples of the connection error messages are: I'm not saying that these errors are always on your or anyone else's side. All I'm saying is that the connection between the HoF server and the 'other' mail server has a problem for some reason. When you think that your missing your fix and that something is up, you can always just go to www.houseoffusion.com/cf_lists to see what the latest messages are. Sorry for the OT post, but I seem to be receiving this list sporadically. The last post I received was from [EMAIL PROTECTED] (suject: Re: Issue: Update a tracker database with an index.html file. content: Assumptions can make an ass out of u and me... :)) My ISP insists my mail server is ok. Before I hassle them, have there been any posts since then? TIA -Craig __ 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: DB Queries and UDFs
As I said If you are using CFSCRIPT g -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 1:14 PM To: CF-Talk Subject: RE: DB Queries and UDFs Unless of yourse, you're creating UDFs via cffunction, then I would imagine you could still use cfloop query=queryObjectName.. :) ~Todd On Mon, 29 Jul 2002, Ben Forta wrote: If you use CFMX then you can indeed create queries inside of a UDF. And either way, you can pass a query to a UDF. If you are using CFSCRIPT syntax then you'll need to use a loop and access the query members as query.column[row]. --- Ben -- 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) | __ 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: Spaces stripped out of query return values?
DOH!! I should have known that. I've been trying since I got your original response to figure out a way to trick it and to put in nbsp; in place of spaces, but I haven't been able to get it working. Does anyone happen to know of a way to get around this? Bob ))) -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 12:13 PM To: CF-Talk Subject: RE: Spaces stripped out of query return values? It's an HTML thing, it will reduce many spaces to one, try replacing the spaces with nbsp; Ade -Original Message- From: Yexley Robert D Contr Det 1 AFRL/WSI [mailto:[EMAIL PROTECTED]] Sent: 29 July 2002 17:06 To: CF-Talk Subject: Spaces stripped out of query return values? I have a form that has a SELECT list in which I'm trying to trick into displaying multiple columns in the select list. I'm doing this by how I'm returning the values from my query. I'm querying an Oracle database, and my query is: cfQuery name=defaultList dataSource=#dataSource# SELECT rpad(username, 20, chr(32))|| rpad(project_folder, 20, chr(32))|| rpad(project_file, 20, chr(32))|| rpad(to_char(blk_h, 'DD-MON-'), 20, chr(32)) listItemDisplay ,username||'/'||project_folder||'/'||project_file listItemValue FROM dids_project_file_info WHERE project_submitted = 'SUBMITTED' ORDER BY username, project_folder, project_file, blk_h /cfQuery So I'm basically trying to concatenate four values together, with spaces concatenated to the end of each value out to 20 characters for each value, and return it as one value (listItemDisplay). How when I execute this query against the database with any standard query tool, it displays the results correctly like this: COUTURGDStevens MMW--HRL 24-JUL-2002 COUTURGDStevens WaveBand-MMW 18-JUL-2002 OHARAWTBLODGETTacoustic 08-APR-2002 My problem is that when I try to dynamically create the select list with the following code: select id=fileList name=fileList size=10 class=form_field style=width: 450px cfLoop query=defaultList cfOutputoption value=#listItemValue##listItemDisplay#/option/cfOutput /cfLoop /select The displayed values come out with the padded spaces stripped of, and display like this: COUTURGD Stevens MMW--HRL 24-JUL-2002 COUTURGD Stevens WaveBand-MMW 18-JUL-2002 OHARAWT BLODGETT acoustic 08-APR-2002 Does anyone have any ideas why these spaces are being stripped, and how I might be able to keep them so that the values are displayed in the list correctly (as columns)? Any ideas would be greatly appreciated. Thanks in advance. ::YEX:: /* || Robert D. Yexley || Oracle Programmer/Analyst || Easylink Services Corporation || Professional Services || Contractor - Wright Research Site MIS || Det-1 AFRL/WSI Bldg. 45 Rm. 062 || (937) 255-1984 || [EMAIL PROTECTED] || ))) */ Robert D. Yexley (E-mail).vcf __ 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: DB Queries and UDFs
I know, I know... I was suggestion an alternative. ;) On Mon, 29 Jul 2002, Ben Forta wrote: As I said If you are using CFSCRIPT g -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 1:14 PM To: CF-Talk Subject: RE: DB Queries and UDFs Unless of yourse, you're creating UDFs via cffunction, then I would imagine you could still use cfloop query=queryObjectName.. :) ~Todd On Mon, 29 Jul 2002, Ben Forta wrote: If you use CFMX then you can indeed create queries inside of a UDF. And either way, you can pass a query to a UDF. If you are using CFSCRIPT syntax then you'll need to use a loop and access the query members as query.column[row]. --- Ben -- 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) | __ 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: Spaces stripped out of query return values?
have you tried HtmlEditFormat() Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Yexley Robert D Contr Det 1 AFRL/WSI [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 29, 2002 10:10 AM Subject: RE: Spaces stripped out of query return values? DOH!! I should have known that. I've been trying since I got your original response to figure out a way to trick it and to put in nbsp; in place of spaces, but I haven't been able to get it working. Does anyone happen to know of a way to get around this? Bob ))) -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 12:13 PM To: CF-Talk Subject: RE: Spaces stripped out of query return values? It's an HTML thing, it will reduce many spaces to one, try replacing the spaces with nbsp; Ade -Original Message- From: Yexley Robert D Contr Det 1 AFRL/WSI [mailto:[EMAIL PROTECTED]] Sent: 29 July 2002 17:06 To: CF-Talk Subject: Spaces stripped out of query return values? I have a form that has a SELECT list in which I'm trying to trick into displaying multiple columns in the select list. I'm doing this by how I'm returning the values from my query. I'm querying an Oracle database, and my query is: cfQuery name=defaultList dataSource=#dataSource# SELECT rpad(username, 20, chr(32))|| rpad(project_folder, 20, chr(32))|| rpad(project_file, 20, chr(32))|| rpad(to_char(blk_h, 'DD-MON-'), 20, chr(32)) listItemDisplay ,username||'/'||project_folder||'/'||project_file listItemValue FROM dids_project_file_info WHERE project_submitted = 'SUBMITTED' ORDER BY username, project_folder, project_file, blk_h /cfQuery So I'm basically trying to concatenate four values together, with spaces concatenated to the end of each value out to 20 characters for each value, and return it as one value (listItemDisplay). How when I execute this query against the database with any standard query tool, it displays the results correctly like this: COUTURGDStevens MMW--HRL 24-JUL-2002 COUTURGDStevens WaveBand-MMW 18-JUL-2002 OHARAWTBLODGETTacoustic 08-APR-2002 My problem is that when I try to dynamically create the select list with the following code: select id=fileList name=fileList size=10 class=form_field style=width: 450px cfLoop query=defaultList cfOutputoption value=#listItemValue##listItemDisplay#/option/cfOutput /cfLoop /select The displayed values come out with the padded spaces stripped of, and display like this: COUTURGD Stevens MMW--HRL 24-JUL-2002 COUTURGD Stevens WaveBand-MMW 18-JUL-2002 OHARAWT BLODGETT acoustic 08-APR-2002 Does anyone have any ideas why these spaces are being stripped, and how I might be able to keep them so that the values are displayed in the list correctly (as columns)? Any ideas would be greatly appreciated. Thanks in advance. ::YEX:: /* || Robert D. Yexley || Oracle Programmer/Analyst || Easylink Services Corporation || Professional Services || Contractor - Wright Research Site MIS || Det-1 AFRL/WSI Bldg. 45 Rm. 062 || (937) 255-1984 || [EMAIL PROTECTED] || ))) */ Robert D. Yexley (E-mail).vcf __ 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: anyone having list troubles ?
Whoops, forgot the list of potential problems. :) Reason: Unknown Reason: Server failed (MAIL) Reason: Couldn't establish SMTP connection on port 25 Reason: Server failed (all recipients deferred) Reason: Server failed (end of DATA) Reason: Server closed SMTP connection (end of DATA) Reason: Server timed out (DATA) (1 message(s)) Reason: MX lookup failure Reason: Server failed (MAIL) Michael Dinowitz Master of the House of Fusion http://www.houseoffusion.com - Original Message - From: Craig Thomas [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 29, 2002 11:51 AM Subject: anyone having list troubles ? Sorry for the OT post, but I seem to be receiving this list sporadically. The last post I received was from [EMAIL PROTECTED] (suject: Re: Issue: Update a tracker database with an index.html file. content: Assumptions can make an ass out of u and me... :)) My ISP insists my mail server is ok. Before I hassle them, have there been any posts since then? TIA -Craig __ 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: Spaces stripped out of query return values?
Change your query to: SELECT replace(rpad(username, 20, chr(7))|| rpad(project_folder, 20, chr(7))|| rpad(project_file, 20, chr(7))|| rpad(to_char(blk_h, 'DD-MON-'), 20, chr(7)), chr(7), 'nbsp;') listItemDisplay You'll want to use a non-printable character for the rpad so you don't end up replacing something in your data. Dan -Original Message- From: Yexley Robert D Contr Det 1 AFRL/WSI [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 10:10 AM To: CF-Talk Subject: RE: Spaces stripped out of query return values? DOH!! I should have known that. I've been trying since I got your original response to figure out a way to trick it and to put in nbsp; in place of spaces, but I haven't been able to get it working. Does anyone happen to know of a way to get around this? Bob ))) -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 12:13 PM To: CF-Talk Subject: RE: Spaces stripped out of query return values? It's an HTML thing, it will reduce many spaces to one, try replacing the spaces with nbsp; Ade -Original Message- From: Yexley Robert D Contr Det 1 AFRL/WSI [mailto:[EMAIL PROTECTED]] Sent: 29 July 2002 17:06 To: CF-Talk Subject: Spaces stripped out of query return values? I have a form that has a SELECT list in which I'm trying to trick into displaying multiple columns in the select list. I'm doing this by how I'm returning the values from my query. I'm querying an Oracle database, and my query is: cfQuery name=defaultList dataSource=#dataSource# SELECT rpad(username, 20, chr(32))|| rpad(project_folder, 20, chr(32))|| rpad(project_file, 20, chr(32))|| rpad(to_char(blk_h, 'DD-MON-'), 20, chr(32)) listItemDisplay ,username||'/'||project_folder||'/'||project_file listItemValue FROM dids_project_file_info WHERE project_submitted = 'SUBMITTED' ORDER BY username, project_folder, project_file, blk_h /cfQuery So I'm basically trying to concatenate four values together, with spaces concatenated to the end of each value out to 20 characters for each value, and return it as one value (listItemDisplay). How when I execute this query against the database with any standard query tool, it displays the results correctly like this: COUTURGDStevens MMW--HRL 24-JUL-2002 COUTURGDStevens WaveBand-MMW 18-JUL-2002 OHARAWTBLODGETTacoustic 08-APR-2002 My problem is that when I try to dynamically create the select list with the following code: select id=fileList name=fileList size=10 class=form_field style=width: 450px cfLoop query=defaultList cfOutputoption value=#listItemValue##listItemDisplay#/option/cfOutput /cfLoop /select The displayed values come out with the padded spaces stripped of, and display like this: COUTURGD Stevens MMW--HRL 24-JUL-2002 COUTURGD Stevens WaveBand-MMW 18-JUL-2002 OHARAWT BLODGETT acoustic 08-APR-2002 Does anyone have any ideas why these spaces are being stripped, and how I might be able to keep them so that the values are displayed in the list correctly (as columns)? Any ideas would be greatly appreciated. Thanks in advance. ::YEX:: /* || Robert D. Yexley || Oracle Programmer/Analyst || Easylink Services Corporation || Professional Services || Contractor - Wright Research Site MIS || Det-1 AFRL/WSI Bldg. 45 Rm. 062 || (937) 255-1984 || [EMAIL PROTECTED] || ))) */ Robert D. Yexley (E-mail).vcf __ 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: Spaces stripped out of query return values?
Well, once you have done your SQL statement, I am assuming that you have strings padded out to the 20 characters or whatever with spaces. Since the problem is at the HTML level, you can--at the CFML level--just replace with nbsp;. So, CFSET TargetVar=Replace(SourceVar, ,nbsp;,ALL) You might have to wrap the Replace() function in # signs (I can never get that right without actually running the code!) In any case, since you are doing this for the entire query set, you may want to CFLOOP through the query and use StructUpdate (see ColdFusion help file) to change the query values to your new values. I hope this is helpful, Matthieu -Original Message- From: Yexley Robert D Contr Det 1 AFRL/WSI [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 1:10 PM To: CF-Talk Subject: RE: Spaces stripped out of query return values? DOH!! I should have known that. I've been trying since I got your original response to figure out a way to trick it and to put in nbsp; in place of spaces, but I haven't been able to get it working. Does anyone happen to know of a way to get around this? Bob ))) -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 12:13 PM To: CF-Talk Subject: RE: Spaces stripped out of query return values? It's an HTML thing, it will reduce many spaces to one, try replacing the spaces with nbsp; Ade -Original Message- From: Yexley Robert D Contr Det 1 AFRL/WSI [mailto:[EMAIL PROTECTED]] Sent: 29 July 2002 17:06 To: CF-Talk Subject: Spaces stripped out of query return values? I have a form that has a SELECT list in which I'm trying to trick into displaying multiple columns in the select list. I'm doing this by how I'm returning the values from my query. I'm querying an Oracle database, and my query is: cfQuery name=defaultList dataSource=#dataSource# SELECT rpad(username, 20, chr(32))|| rpad(project_folder, 20, chr(32))|| rpad(project_file, 20, chr(32))|| rpad(to_char(blk_h, 'DD-MON-'), 20, chr(32)) listItemDisplay ,username||'/'||project_folder||'/'||project_file listItemValue FROM dids_project_file_info WHERE project_submitted = 'SUBMITTED' ORDER BY username, project_folder, project_file, blk_h /cfQuery So I'm basically trying to concatenate four values together, with spaces concatenated to the end of each value out to 20 characters for each value, and return it as one value (listItemDisplay). How when I execute this query against the database with any standard query tool, it displays the results correctly like this: COUTURGDStevens MMW--HRL 24-JUL-2002 COUTURGDStevens WaveBand-MMW 18-JUL-2002 OHARAWTBLODGETTacoustic 08-APR-2002 My problem is that when I try to dynamically create the select list with the following code: select id=fileList name=fileList size=10 class=form_field style=width: 450px cfLoop query=defaultList cfOutputoption value=#listItemValue##listItemDisplay#/option/cfOutput /cfLoop /select The displayed values come out with the padded spaces stripped of, and display like this: COUTURGD Stevens MMW--HRL 24-JUL-2002 COUTURGD Stevens WaveBand-MMW 18-JUL-2002 OHARAWT BLODGETT acoustic 08-APR-2002 Does anyone have any ideas why these spaces are being stripped, and how I might be able to keep them so that the values are displayed in the list correctly (as columns)? Any ideas would be greatly appreciated. Thanks in advance. ::YEX:: /* || Robert D. Yexley || Oracle Programmer/Analyst || Easylink Services Corporation || Professional Services || Contractor - Wright Research Site MIS || Det-1 AFRL/WSI Bldg. 45 Rm. 062 || (937) 255-1984 || [EMAIL PROTECTED] || ))) */ Robert D. Yexley (E-mail).vcf __ 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: anyone having list troubles ?
mike. im sorry to chime in again, about your list. but this list is really sporadic, and you flamed me when I asked the question. no one is downing your list, but please, really, just accept the fact that there are issues with this mailing list, and lets all, as a community help fix it. im sure there is plenty of talent on this list to look into the issue. and just to make sure, I know that my mail server is fine, I manage my own, and get email all day long, instantaneously from all parts of the world! just trying to help. ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 1:23 PM To: CF-Talk Subject: Re: anyone having list troubles ? Whoops, forgot the list of potential problems. :) Reason: Unknown Reason: Server failed (MAIL) Reason: Couldn't establish SMTP connection on port 25 Reason: Server failed (all recipients deferred) Reason: Server failed (end of DATA) Reason: Server closed SMTP connection (end of DATA) Reason: Server timed out (DATA) (1 message(s)) Reason: MX lookup failure Reason: Server failed (MAIL) Michael Dinowitz Master of the House of Fusion http://www.houseoffusion.com - Original Message - From: Craig Thomas [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 29, 2002 11:51 AM Subject: anyone having list troubles ? Sorry for the OT post, but I seem to be receiving this list sporadically. The last post I received was from [EMAIL PROTECTED] (suject: Re: Issue: Update a tracker database with an index.html file. content: Assumptions can make an ass out of u and me... :)) My ISP insists my mail server is ok. Before I hassle them, have there been any posts since then? TIA -Craig __ 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
How to Display a Page incase of Timeout?
Hello, I am fairly new to CF and i need to simply set the site I am building up to display a simple page asking the user to re-login in case of a timeout? Seems like an easy enough task but I'm not sure how to go about it. Any help would be appreciated. Thanks -Paul __ 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: anyone having list troubles ?
I don't think I flamed you but instead suggested that it may have been a new filter. That's besides the point. I am working on the server and trying to move it to a whole new setup. It's slow work because of time and money. Now that all of the list archives are in the new setup I can finalize how the mail is being handled. But again, this is besides the point. The majority of the list participants have no problems with their mail unless the server gets hung. No double posts, no delays, etc. Some, such as you, may get doubles on a regular basis. What I suggest is sending me the headers of all such doubles so I can check them out. Also, as you run your own server, can you check out the address that you have subscribed. No aliases, no passing of messages, no forwarding, nothing funky going on? This is not asked as any sort of attack or flame but as an honest attempt to find and deal with the problem. I'll be watching the deferred directory to see if your domain comes up and if it does, what the error message is. mike. im sorry to chime in again, about your list. but this list is really sporadic, and you flamed me when I asked the question. no one is downing your list, but please, really, just accept the fact that there are issues with this mailing list, and lets all, as a community help fix it. im sure there is plenty of talent on this list to look into the issue. and just to make sure, I know that my mail server is fine, I manage my own, and get email all day long, instantaneously from all parts of the world! just trying to help. ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 1:23 PM To: CF-Talk Subject: Re: anyone having list troubles ? Whoops, forgot the list of potential problems. :) Reason: Unknown Reason: Server failed (MAIL) Reason: Couldn't establish SMTP connection on port 25 Reason: Server failed (all recipients deferred) Reason: Server failed (end of DATA) Reason: Server closed SMTP connection (end of DATA) Reason: Server timed out (DATA) (1 message(s)) Reason: MX lookup failure Reason: Server failed (MAIL) Michael Dinowitz Master of the House of Fusion http://www.houseoffusion.com - Original Message - From: Craig Thomas [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 29, 2002 11:51 AM Subject: anyone having list troubles ? Sorry for the OT post, but I seem to be receiving this list sporadically. The last post I received was from [EMAIL PROTECTED] (suject: Re: Issue: Update a tracker database with an index.html file. content: Assumptions can make an ass out of u and me... :)) My ISP insists my mail server is ok. Before I hassle them, have there been any posts since then? TIA -Craig __ 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: Email Parser
exactly that kinda check ;) lol just seeing if there is something already available so i can build off it to the needs we have. Going through 7 million records you think cf can handle it without going crazy? :) I think i'll have to do it into groups so it doesnt blow up. Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 - Original Message - From: Ben Forta [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 29, 2002 12:17 PM Subject: RE: Email Parser And don't forget all the AOL users who forget the .com or the aol.com (just providing their screen name). That one feels like an epidemic sometimes. -Original Message- From: Bill Wheatley [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 12:12 PM To: CF-Talk Subject: Re: Email Parser well Just to first regexp check to make sure the emails in the right format then I want to add something to check it against a list of OBVIOUS mistakes like we have about 25 million emails that are not emailing out and alot of hatmail.com or hotmal.com typos for hotmail.com so I want to check for those matches and update the record to hotmail.com something like that :) thanks Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 - Original Message - From: Alex [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 29, 2002 12:07 PM Subject: Re: Email Parser What's your definition of INVALID? Do you mean a regular expression to check an email or do you mean a nslookup to check a mx record? On Mon, 29 Jul 2002, Bill Wheatley wrote: Anyone know any good places to get a CF based or PERL based email parser to check for INVALID emails? Thanks Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 __ 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: anyone having list troubles ?
At 01:25 PM 7/29/02 -0400, Tony Weeg wrote: mike. im sorry to chime in again, about your list. but this list is really sporadic, and you flamed me Actually, the list is very rarely sporadic where I am. (It is less sporadic than any of my other lists.) So I would guess that something is being dropped between the list server and yours, and is possibly neither's fault. T __ 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: How to Display a Page incase of Timeout?
Hey Paul, How a timeout-relogin page would be displayed is going to depend greatly on how you manage your sessions. If you're using session variables, the simplest way may be to use something like the following in your application.cfm file: cflock scope=session type=readonly timeout=10 cfset loggedin = YesNoFormat(IsDefined(session.loginid)) /cfif cfif not loggedin cfinclude template=loginform.cfmcfabort /cfif hth Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 Hello, I am fairly new to CF and i need to simply set the site I am building up to display a simple page asking the user to re-login in case of a timeout? Seems like an easy enough task but I'm not sure how to go about it. Any help would be appreciated. Thanks -Paul __ 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
CFGRIDUPDATE: Duplicate Column Name
Hey guys and gals. I got this error when doing a simple CFGRID/CFGRIDUPDATE page: === Oracle Error Code = 957 ORA-00957: duplicate column name Data Source = RELORA SQL = UPDATE VEHICLE_TBL SET COST_CENTER_CD = :1 , COST_CENTER_CD = :2 WHERE VEHICLE_NBR = :3 AND VEHICLE_NBR = :4 The error occurred while processing an element with a general identifier of (CFGRIDUPDATE), occupying document position (12:2) to (16:28) in the template file C:\sites\Reliant Energy\current\admin_vehicletable.cfm. I've never seen this error with a CFGRID before, so I'm a bit confused. The columns are NOT listed twice in the CFGRID tag. I tried updating just one value in the Grid. Any ideas as to what could be the problem? -Gel - Here's the code for the page: The update statement : cfgridupdate grid=vehiclestuff datasource=RELORA tablename=VEHICLE_TBL dbtype=Oracle80 keyonly=Yes The CFGRID statement: cfgrid name=vehiclestuff height=500 width=720 query=GetVehicles insert=Yes delete=Yes sort=Yes font=Verdana fontsize=10 bold=No italic=No appendkey=Yes highlighthref=No griddataalign=CENTER gridlines=Yes rowheaders=No rowheaderalign=LEFT rowheaderitalic=No rowheaderbold=No colheaders=Yes colheaderalign=LEFT colheaderfont=Arial colheaderfontsize=12 colheadertextcolor=##00 colheaderitalic=No colheaderbold=Yes bgcolor=##80 selectcolor=##00FF00 textcolor=##FF selectmode=EDIT picturebar=No cfgridcolumn name=COMPANY header=Company headeralign=LEFT dataalign=LEFT width=100 font=Verdana fontsize=10 bold=No italic=No select=No display=Yes headerbold=No headeritalic=No cfgridcolumn name=LOCATION header=Location headeralign=LEFT dataalign=LEFT width=100 font=Verdana fontsize=10 bold=No italic=No select=No display=Yes headerbold=No headeritalic=No cfgridcolumn name=VEHICLE_NBR header=Vehicle No. headeralign=LEFT dataalign=LEFT width = 80 font=Verdana fontsize=10 bold=No italic=No select=No display=Yes headerbold=No headeritalic=No cfgridcolumn name=VEHICLE_TYPE header=Vehicle Type headeralign=LEFT dataalign=LEFT width=100 font=Verdana fontsize=10 bold=No italic=No select=No display=Yes headerbold=No headeritalic=No cfgridcolumn name=COST_CENTER_CD header=Cost Center Code headeralign=LEFT dataalign=LEFT width=300 font=Verdana fontsize=10 bold=No italic=No select=Yes display=Yes headerbold=No headeritalic=No values=#CodeList# valuesdisplay=#CodeDescription# valuesdelimiter=, /CFGRID __ 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
CFX_CyberCash
has anyone successfully used CFX_CyberCash with CFMX Pro on Linux? i just got off the phone with tech support at Verisign and their basic conclusion at this point is that it does not work and it may never work. we were able to get it to the point where it will actually charge a credit card and log all the information into a debug file, but it never returns any results back to the calling .cfm page so you can let the user know if it was successful or not. (and users tend to want to know that. ;-) ) if nobody has this working, then are there any alternatives? i'd prefer not to migrate to PayFlowPro or another service at this point, especially since they mentioned their Java PFP tag doesn't work on CFMX either. steve __ 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