Re: OT: Netscape 7.1
Yeah NS 7.1 is pretty good, however I just discovered a quirk last night regarding CSS. I've got a major CSS file that sets padding, and a host of other elements in tables. When I generated the page using the !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Final//EN My main navigation table in NS 7.1 had a gap in it, not in IE though. I decided to do a what the heck and used !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2 Final//EN and there was no gap! Not understanding this if I want to ensure standards compliance, I'll need to figure out which CSS, XHTML or DOM element NS 7.1 doesn't support, or if I need to reference a local URI or something. (I'm Just now learning the finer points of advanced CSS and DOM control). So for me, it's cross-browser testing as usual! The real question though is, now that AOL signed another multi-year agreement to use the IE engine in AOL ACK cough - sputter and laid off more NS staff, how long will it be before NS goes completely open source? Ultimately I'm an NS FANatic since NS 0.9 beta and an anti-corporate kind of a guy, however I have no desire (YET) to explore Linux, Opera, or any of the other dozen anti-Bill solutions for Intel based PCs. Rafael At 11:05 PM 7/27/03, you wrote: Lil bit OT but it may be worthy. ;) I had to do some regression testing on an app today and was forced to install Netscape 7.1, ACK!...and I must admit I was pleasantly surprised. I believe it's *finally* caught up to (and surpassed) IE. Built-in pop-up blocking for one...and every IE feature I used to complain that it didn't have. I even found my google bar! ;) http://googlebar.mozdev.org/ Cheers, Stace AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Printing
Hi List, Here is the background -Scheduled task at 2am on the 15th of the month -10minute process -3000 PDF docs created What I want to do is automatically print those documents I've found two solutions to help me so far: http://www.funasset.com/SilentPrint.htm and http://www.traction-software.co.uk/batchprint/index.html does anyone have any experience using either of the two, or can you offer an alternative? Cheers and thanks Greg Hamm [EMAIL PROTECTED] Partner Coreillia Development ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: Hurricane in Houston?
Sorry to take up bandwidth on non-technical issues, but it does relate to ColdFusion services and development in an obtuse kind of way ... A supplier of services has claimed that the reason they didn't meet a deadline on Sunday 13 July was because there was a severe hurricane in Houston TX and damaged their datacenter, so they didn't have access to their server equipment for two days. Can anyone verify (or otherwise) that there was a hurricane in the Houston area that day please? Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Session is invalid on CFMX
You're right Jim. You have to setClientCookies to no in cfapplication, and then you don't get any CFID/CFTOKEN cookies anymore. I've also explicitly added the session timeout in cfapplication to see if it solves my problem/bug. I'll keep you informed! Thanks. Benoit Hediard www.benorama.com -Message d'origine- De : Jim Davis [mailto:[EMAIL PROTECTED] Envoyé : lundi 28 juillet 2003 03:48 À : CF-Talk Objet : RE: Session is invalid on CFMX -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED] Sent: Sunday, July 27, 2003 9:31 PM To: CF-Talk Subject: Re: Session is invalid on CFMX On Sunday, Jul 27, 2003, at 16:51 US/Pacific, Jim Davis wrote: From what I can tell it doesn't create them if J2EE session management is enabled. However they still ARE created for CF Client Management (Client Scope). That may be where the confusion is. Basically if you enable J2EE sessions and disable clientmanagement the cookies don't look like they're being set. Ah, thanx for that clarification Jim. That makes a lot of sense really. Although I have client variables turned off in the admin but still see the cookies. I guess I need to explicitly disable client management in my cfapplication tag? I'm really not sure... I know I had specific problems due to this (CFTOKEN/CFID not existing when J2EE sessions were enabled) and that's when I sorted it all out. However that was the original MX release. If things are different now perhaps it's an Updater change? Jim Davis ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: Hurricane in Houston?
It's BOGUS. The hurricane didn't hit Texas til TUESDAY the 15th. If a DEADLINE was for the 13th, that means they had to have completed what they were to do TWO DAYS before the hurricane hit. FROM NASA: http://www.gsfc.nasa.gov/topstory/2003/0715claudette.html Category 1 Hurricane Claudette, the first Atlantic hurricane of 2003, made landfall on the middle of the Texas coast midday Tuesday, according to the National Hurricane Center. With maximum winds still at 80 mph, the NHC predicts five to eight inches of rain will fall due to Claudette. These images from the Moderate-resolution Imaging Spectroradiometer (MODIS) aboard the Terra satellite capture the eye just passing over the coastline at 1:00 PM EDT today, July 15, 2003. Credit: Image courtesy Courtesy NASA and Space Science and Engineering Center, University of Wisconsin-Madison En At 01:48 AM 7/28/03, you wrote: Sorry to take up bandwidth on non-technical issues, but it does relate to ColdFusion services and development in an obtuse kind of way ... A supplier of services has claimed that the reason they didn't meet a deadline on Sunday 13 July was because there was a severe hurricane in Houston TX and damaged their datacenter, so they didn't have access to their server equipment for two days. Can anyone verify (or otherwise) that there was a hurricane in the Houston area that day please? Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Hurricane in Houston?
Maybe they went surfing on the 13th. :-) Hurricane Claudette didn't make landfall on the Texas coast until Tuesday, July 15th. http://www.chron.com/cs/CDA/ssistory.mpl/outdoors/2012834 Surfside Beach near Freeport was jammed with surfing traffic July 13 as the then-tropical storm meandered across the open Gulf. Unfortunately, two days later the small community suffered extensive damage as the intensifying storm billowed past, but on that sunny summer Sunday it was Surf's up! -- a rendezvous of perhaps unprecedented proportions. - Original Message - From: Mike Kear [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 28, 2003 12:48 AM Subject: OT: Hurricane in Houston? Sorry to take up bandwidth on non-technical issues, but it does relate to ColdFusion services and development in an obtuse kind of way ... A supplier of services has claimed that the reason they didn't meet a deadline on Sunday 13 July was because there was a severe hurricane in Houston TX and damaged their datacenter, so they didn't have access to their server equipment for two days. Can anyone verify (or otherwise) that there was a hurricane in the Houston area that day please? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Hosting Revisited.
i tried replyong just to you... i would def hammer it.. I need one more person to test out my servers. I really would like it to be some one that's going to hammer it. Flash Remoting, CFCs, and Web Services will need to be tested hard. Let me know if your interested Tim --- [This E-mail scanned for viruses by Declude Virus] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Missing form fields - anyone experienced this error ?
Let me describe the problem I'm experiencing -- there's a form on our site that is very long and contains many inputs (of type hidden, text, select, etc.). When the submit button is pressed, it submits to a second page. This all worked perfectly for many months, but this week we upgraded to ColdFusion MX from 5.0. Now the page still works for me, but about 10 times a day from other users I get an error email saying that on the second page, the form fields are undefined. The error occurs on the very first form field that the page tries to access, which is a select box. From reading others' suggestions, I've moved the form and /form tags to outside the table, and I've fixed all ill-formed HTML. I've also run the ColdFusion updater to make sure that we have the latest version and patches. The problem is still occurring. I see in this forum that several people have experienced this problem and no solution was ever posted. If anyone has any info on this problem, please let me know. Thanks so much, Rob Kogan ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Tutorials for creating Java classes for CF
Hi all, Can anyone point me in the direction of a good tutorial of two on the creation of Java classes for use in Cold Fusion via the CreateObject() function? I'm relatively okay with the way the language works because I come from a C++ background, it's just compiling a class for use in CF that stumps me. Any pointers, tutorials, advice will be readily welcomed. -- Oliver Tupman Key Systems Geotechnical ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: Netscape 7.1
Rafael Alan Bleiweiss wrote: Yeah NS 7.1 is pretty good, however I just discovered a quirk last night regarding CSS. I've got a major CSS file that sets padding, and a host of other elements in tables. When I generated the page using the !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Final//EN My main navigation table in NS 7.1 had a gap in it, not in IE though. I decided to do a what the heck and used !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2 Final//EN and there was no gap! What is so strange about that? If you are using elements that are in HTML 4 but not in 3.2, they will be ignored in 3.2 but rendered in 4. That is intended behaviour. Did you validate your HTML in both cases? Why not write XHTML? The real question though is, now that AOL signed another multi-year agreement to use the IE engine in AOL ACK cough - sputter and laid off more NS staff, how long will it be before NS goes completely open source? Never. Netscape is just as dead as standalone versions of IE. If you want a browser that continues to evolve, look at Firebird or Opera. If you want a communications suite that continues to evolve, look at Mozilla. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Persistent Session variables
Could the fact that CF(MX?) treats the CLIENT scope as a structure
internally allow you to use CLIENT[varname] = myValue; ?
Ade
-Original Message-
From: s. isaac dealey [mailto:[EMAIL PROTECTED]
Sent: 25 July 2003 20:34
To: CF-Talk
Subject: RE: Persistent Session variables
Great suggestion... The only thing I'd add is that you might consider a user
defined function for setting client/session variables...
function setSession(varname,myvalue) {
session[varname] = myvalue;
client.#varname# = myvalue;
}
I'm not sure off the top of my head if that works... I'm inclined to expect
it to throw an error on client.#varname# = in the function call even
though it works outside of cfscript... and as there's no setclientvariable()
function and client isn't a structure, I'm not sure how else I'd
accomplish it... in any event -- the idea is that you don't want to have to
remember to set 2 variables every time you want to set that session
variable, so the function lets you do it with just the one statement...
cfset setSession(userid,myquery.userid)
Original Message ---
I thought some of you might find this interesting.
For an application I needed to have the speed of reading Session variables
from RAM, combined with the persistence of Client variables that don't go
away if the Coldfusion server is cycled (restarted) and RAM is tossed out.
(something that happens too often on a shared server)
The solution is relatively simple:
I kept these 'persistent session variables' all together in a structure
just to make working with them easier.
Every time I needed to write (change) the variables I updated both a session
variable AND a client variable.
Every time I needed to read the variables I simply read from a session
variable.
I have code that runs before every page (Fbx_settings for Fusebox or
Application.cfm otherwise) that checks if there is no current session (NOT
IsDefined('session.insession')). If not, then I mark the current session (
session.insession='yes') and copy the client variable to a session variable.
Think of the client variable as a 'backup' for the session variable.
Slight speed hit on writes in return for persistence across reboots and
restarts.
-Peter Theobald
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community.
http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Missing form fields - anyone experienced this error ?
If it's the first FORM variable you try to use that isn't there, it's probably someone accessing the page directly rather than via the form post. Run the page and see if the same error occurs. Ade -Original Message- From: Robert Kogan [mailto:[EMAIL PROTECTED] Sent: 28 July 2003 09:01 To: CF-Talk Subject: Missing form fields - anyone experienced this error ? Let me describe the problem I'm experiencing -- there's a form on our site that is very long and contains many inputs (of type hidden, text, select, etc.). When the submit button is pressed, it submits to a second page. This all worked perfectly for many months, but this week we upgraded to ColdFusion MX from 5.0. Now the page still works for me, but about 10 times a day from other users I get an error email saying that on the second page, the form fields are undefined. The error occurs on the very first form field that the page tries to access, which is a select box. From reading others' suggestions, I've moved the form and /form tags to outside the table, and I've fixed all ill-formed HTML. I've also run the ColdFusion updater to make sure that we have the latest version and patches. The problem is still occurring. I see in this forum that several people have experienced this problem and no solution was ever posted. If anyone has any info on this problem, please let me know. Thanks so much, Rob Kogan ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: Netscape 7.1
Saw this on another list re netscape's future http://www.meyerweb.com/eric/thoughts/2003c.html#t20030715 -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 6:02 AM To: CF-Talk Subject: Re: OT: Netscape 7.1 Rafael Alan Bleiweiss wrote: Yeah NS 7.1 is pretty good, however I just discovered a quirk last night regarding CSS. I've got a major CSS file that sets padding, and a host of other elements in tables. When I generated the page using the !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Final//EN My main navigation table in NS 7.1 had a gap in it, not in IE though. I decided to do a what the heck and used !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2 Final//EN and there was no gap! What is so strange about that? If you are using elements that are in HTML 4 but not in 3.2, they will be ignored in 3.2 but rendered in 4. That is intended behaviour. Did you validate your HTML in both cases? Why not write XHTML? The real question though is, now that AOL signed another multi-year agreement to use the IE engine in AOL ACK cough - sputter and laid off more NS staff, how long will it be before NS goes completely open source? Never. Netscape is just as dead as standalone versions of IE. If you want a browser that continues to evolve, look at Firebird or Opera. If you want a communications suite that continues to evolve, look at Mozilla. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Select TOP X form all Groups
Ian Skinner wrote: I have a table something like the below. I would like to create a select that will retrieve the TOP 2 records for each category? I can't seem to get my head around this one, is it really that difficult? Desired Results: TYPE NAMEVIEWS CampgroundX 4 CampgroundBar 3 So which results do you want if there are 3 names with the same number of views? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: Netscape 7.1
http://news.bbc.co.uk/1/hi/technology/3074031.stm Saw this on another list re netscape's future http://www.meyerweb.com/eric/thoughts/2003c.html#t20030715 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: Netscape 7.1
Well, I did validate html and it's all clear. Why not XHTML? Cause I'm just now teaching myself enough about CSS to become proficient in it. Haven't even begun to explore XHTML. I did find out that my !Document... reference was incorrect so I'm going from there... Are there any good CSS lists? What is so strange about that? If you are using elements that are in HTML 4 but not in 3.2, they will be ignored in 3.2 but rendered in 4. That is intended behaviour. Did you validate your HTML in both cases? Why not write XHTML? The real question though is, now that AOL signed another multi-year agreement to use the IE engine in AOL ACK cough - sputter and laid off more NS staff, how long will it be before NS goes completely open source? Never. Netscape is just as dead as standalone versions of IE. If you want a browser that continues to evolve, look at Firebird or Opera. If you want a communications suite that continues to evolve, look at Mozilla. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: Netscape 7.1
http://www.css-discuss.org -Original Message- From: Rafael Alan Bleiweiss [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 8:08 AM To: CF-Talk Subject: Re: OT: Netscape 7.1 Well, I did validate html and it's all clear. Why not XHTML? Cause I'm just now teaching myself enough about CSS to become proficient in it. Haven't even begun to explore XHTML. I did find out that my !Document... reference was incorrect so I'm going from there... Are there any good CSS lists? What is so strange about that? If you are using elements that are in HTML 4 but not in 3.2, they will be ignored in 3.2 but rendered in 4. That is intended behaviour. Did you validate your HTML in both cases? Why not write XHTML? The real question though is, now that AOL signed another multi-year agreement to use the IE engine in AOL ACK cough - sputter and laid off more NS staff, how long will it be before NS goes completely open source? Never. Netscape is just as dead as standalone versions of IE. If you want a browser that continues to evolve, look at Firebird or Opera. If you want a communications suite that continues to evolve, look at Mozilla. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: Netscape 7.1
At 06:22 AM 7/28/03, you wrote: http://www.css-discuss.org Excellent resource - thanks for posting this! After all these years in this industry, just now getting past my knees in CSS as a consistent solution feels both awkward and comfortable at the same time! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMX Wiki
Does anyone know of any easy to use CF based Wiki's? I have played with some of the ASP ones, but would prefer on written in CF (Ideally MX). Can anyone help? Neil ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: Netscape 7.1
Did you validate your HTML in both cases? Why not write XHTML? Jochem, Thanks for asking me why not XHTML... I've done some reading up on it and yeah, it's pretty clear that I need to start learning this as well! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF Administrator Jibberish HELP
Jon, Thanks for the idea. I have checked all those settings and they are correct. My test server is configured the exact same way and it is stillworking. DO you have any other suggestions. I am desparate... BPowers ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX Wiki
Neil, Does anyone know of any easy to use CF based Wiki's? I have played with some of the ASP ones, but would prefer on written in CF (Ideally MX). Can anyone help? There's CFWiki (http://www.cdsi-solutions.com/cfwiki/), which I've re-written a bit (zip file in the mail), but at the moment it only uses standard feature of CF. By 'written in CF (Ideally MX)' are you saying you want a wiki that uses specific features of CFMX that are only available in MX or just a wiki that will run on MX? Regards Stephen ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX Wiki
By 'written in CF (Ideally MX)' are you saying you want a wiki that uses specific features of CFMX that are only available in MX or just a wiki that will run on MX? For now, just running in MX, but ultimately something CFC based would be nice. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
parsing in CF 5
Hey everyone. I am looking for some advice or better ways of doing the following: I am on CF 5 and trying to located 10 words in a word document. In CFMX and Red Sky I can read the M$ Word doc with cffile and parse through it no problem... without COM! In CF5 I can not seem to parse is consistantly (I never get the same results from the same document). In addition, since there seems to be some variable size limitations or limitations on the amount of data that can be passed to some string functions (CF 5: FindNoCase, Find, REFind) I try and loop over the text I read from the cffile in 2500 character chunks. The code I am using is below... can anyone see a way to parse a word doc out in CF 5 resulting in consistant results? If not I can use COM. although Id rather avoid it. Code Currently Used: cfoutput cffile action=READ file=D:\http\medialinq\temptest.doc variable=docText / cfset textToFind = automobile / cfloop from=1 to=#Len(docText)# step=2500 index=currentBlock cfset currentText = Mid(docText,currentblock,2500) / cfif FindNoCase(textToFind,currentText) NEQ 0 preBLOCK [#currentBlock#] - YES/prebr #currentText#br hr cfelse preBLOCK [#currentBlock#] - NO/prebr #currentText#br hr /cfif /cfloop /cfoutput Thanks! Mike ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Persistent Session variables
Very possibly. I'm pretty sure it doesn't work with CF5. I hadn't heard anything about
changes to the client scope in mx specifically... I know that with previous versions
of the server there were frequently other collections of variables that weren't
structures that would become structures with later versions.
Could the fact that CF(MX?) treats the CLIENT scope as a
structure
internally allow you to use CLIENT[varname] = myValue; ?
Ade
-Original Message-
From: s. isaac dealey [mailto:[EMAIL PROTECTED]
Sent: 25 July 2003 20:34
To: CF-Talk
Subject: RE: Persistent Session variables
Great suggestion... The only thing I'd add is that you
might consider a user
defined function for setting client/session variables...
function setSession(varname,myvalue) {
session[varname] = myvalue;
client.#varname# = myvalue;
}
I'm not sure off the top of my head if that works... I'm
inclined to expect
it to throw an error on client.#varname# = in the
function call even
though it works outside of cfscript... and as there's no
setclientvariable()
function and client isn't a structure, I'm not sure how
else I'd
accomplish it... in any event -- the idea is that you
don't want to have to
remember to set 2 variables every time you want to set
that session
variable, so the function lets you do it with just the one
statement...
cfset setSession(userid,myquery.userid)
Original Message ---
I thought some of you might find this interesting.
For an application I needed to have the speed of reading
Session variables
from RAM, combined with the persistence of Client
variables that don't go
away if the Coldfusion server is cycled (restarted) and
RAM is tossed out.
(something that happens too often on a shared server)
The solution is relatively simple:
I kept these 'persistent session variables' all together
in a structure
just to make working with them easier.
Every time I needed to write (change) the variables I
updated both a session
variable AND a client variable.
Every time I needed to read the variables I simply read
from a session
variable.
I have code that runs before every page (Fbx_settings for
Fusebox or
Application.cfm otherwise) that checks if there is no
current session (NOT
IsDefined('session.insession')). If not, then I mark the
current session (
session.insession='yes') and copy the client variable to a
session variable.
Think of the client variable as a 'backup' for the session
variable.
Slight speed hit on writes in return for persistence
across reboots and
restarts.
-Peter Theobald
~~
~~~|
Archives:
http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/cf_lists/index.
cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these
lists and provide more resources for the community.
http://www.fusionauthority.com/ads.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/uns
ubscribe.cfm?user=633.558.4
s. isaac dealey972-490-6624
new epoch http://www.turnkey.to
lead architect, tapestry cms http://products.turnkey.to
tapestry api is opensource http://www.turnkey.to/tapi
team macromedia volunteer http://www.macromedia.com/go/team
certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics.
http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
DRK4 Red Sky
Hi all: I grabbed the DRK4 files this past weekend and noticed that RSS Untangle required Red Sky (or the 1.4 JVM). I'm sort of surprised Macromedia would put out a DRK that isn't even supported on the current CFMX release. Any idea why this occurred? My guess is Red Sky is very close. -Rich ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Caching custom tag article somewhere?
Thanks much. Very cool. How've you found the performance with this? (then again it is your CHILD, heheh) -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Sunday, July 27, 2003 11:11 PM To: CF-Talk Subject: RE: Caching custom tag article somewhere? That would be an article I wrote. The tag was called scopeCache and was pretty simple. This is the MX version. The nonMX version would need loads of locks. This shold be extended to support things like timeouts, etc. cfif not isDefined(attributes.name) or not isSimpleValue(attributes.name) cfthrow message=scopeCache: The name attribute must be passed as a string. /cfif cfif not isDefined(attributes.scope) or not isSimpleValue(attributes.scope) or not listFindNoCase(application,session,server,attributes.scope) cfthrow message=scopeCache: The scope attribute must be passed as one of: application, session, or server. /cfif !--- create pointer to scope --- cfset ptr = structGet(attributes.scope) !--- init cache root --- cfif not structKeyExists(ptr,scopeCache) cfset ptr[scopeCache] = structNew() /cfif cfif isDefined(attributes.clear) and structKeyExists(ptr.scopeCache,attributes.name) cfset structDelete(ptr.scopeCache,attributes.name) cfexit /cfif cfif thisTag.executionMode is start !--- determine if we have the info in cache already --- cfif structKeyExists(ptr.scopeCache,attributes.name) cfoutput#ptr.scopeCache[attributes.name]#/cfoutput cfexit /cfif cfelse cfset ptr.scopeCache[attributes.name] = thistag.generatedcontent /cfif === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Rich Z [mailto:[EMAIL PROTECTED] Sent: Sunday, July 27, 2003 6:36 PM To: CF-Talk Subject: Caching custom tag article somewhere? Guys: I could have SWORN I'd read an article that explained a custom tag (very simple one actually) that gave the user the option of defining which scope to cache the content, etc. Real neat little tag. I THINK the article was in CFDJ, but I can't find it in the archives. Can someone help? Rich ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Persistent Session variables
This works in CFMX
cfset CLIENT[Hella] = cool /
Ade
-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: 28 July 2003 14:05
To: CF-Talk
Subject: RE: Persistent Session variables
Very possibly. I'm pretty sure it doesn't work with CF5. I hadn't heard
anything about changes to the client scope in mx specifically... I know that
with previous versions of the server there were frequently other collections
of variables that weren't structures that would become structures with later
versions.
Could the fact that CF(MX?) treats the CLIENT scope as a
structure
internally allow you to use CLIENT[varname] = myValue; ?
Ade
-Original Message-
From: s. isaac dealey [mailto:[EMAIL PROTECTED]
Sent: 25 July 2003 20:34
To: CF-Talk
Subject: RE: Persistent Session variables
Great suggestion... The only thing I'd add is that you
might consider a user
defined function for setting client/session variables...
function setSession(varname,myvalue) {
session[varname] = myvalue;
client.#varname# = myvalue;
}
I'm not sure off the top of my head if that works... I'm
inclined to expect
it to throw an error on client.#varname# = in the
function call even
though it works outside of cfscript... and as there's no
setclientvariable()
function and client isn't a structure, I'm not sure how
else I'd
accomplish it... in any event -- the idea is that you
don't want to have to
remember to set 2 variables every time you want to set
that session
variable, so the function lets you do it with just the one
statement...
cfset setSession(userid,myquery.userid)
Original Message ---
I thought some of you might find this interesting.
For an application I needed to have the speed of reading
Session variables
from RAM, combined with the persistence of Client
variables that don't go
away if the Coldfusion server is cycled (restarted) and
RAM is tossed out.
(something that happens too often on a shared server)
The solution is relatively simple:
I kept these 'persistent session variables' all together
in a structure
just to make working with them easier.
Every time I needed to write (change) the variables I
updated both a session
variable AND a client variable.
Every time I needed to read the variables I simply read
from a session
variable.
I have code that runs before every page (Fbx_settings for
Fusebox or
Application.cfm otherwise) that checks if there is no
current session (NOT
IsDefined('session.insession')). If not, then I mark the
current session (
session.insession='yes') and copy the client variable to a
session variable.
Think of the client variable as a 'backup' for the session
variable.
Slight speed hit on writes in return for persistence
across reboots and
restarts.
-Peter Theobald
~~
~~~|
Archives:
http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/cf_lists/index.
cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these
lists and provide more resources for the community.
http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/uns
ubscribe.cfm?user=633.558.4
s. isaac dealey972-490-6624
new epoch http://www.turnkey.to
lead architect, tapestry cms http://products.turnkey.to
tapestry api is opensource http://www.turnkey.to/tapi
team macromedia volunteer http://www.macromedia.com/go/team
certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Persistent Session variables
awesome. :)
This works in CFMX
cfset CLIENT[Hella] = cool /
Ade
-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: 28 July 2003 14:05
To: CF-Talk
Subject: RE: Persistent Session variables
Very possibly. I'm pretty sure it doesn't work with CF5. I
hadn't heard
anything about changes to the client scope in mx
specifically... I know that
with previous versions of the server there were frequently
other collections
of variables that weren't structures that would become
structures with later
versions.
Could the fact that CF(MX?) treats the CLIENT scope as a
structure
internally allow you to use CLIENT[varname] = myValue; ?
Ade
-Original Message-
From: s. isaac dealey [mailto:[EMAIL PROTECTED]
Sent: 25 July 2003 20:34
To: CF-Talk
Subject: RE: Persistent Session variables
Great suggestion... The only thing I'd add is that you
might consider a user
defined function for setting client/session variables...
function setSession(varname,myvalue) {
session[varname] = myvalue;
client.#varname# = myvalue;
}
I'm not sure off the top of my head if that works... I'm
inclined to expect
it to throw an error on client.#varname# = in the
function call even
though it works outside of cfscript... and as there's no
setclientvariable()
function and client isn't a structure, I'm not sure how
else I'd
accomplish it... in any event -- the idea is that you
don't want to have to
remember to set 2 variables every time you want to set
that session
variable, so the function lets you do it with just the
one
statement...
cfset setSession(userid,myquery.userid)
Original Message ---
I thought some of you might find this interesting.
For an application I needed to have the speed of reading
Session variables
from RAM, combined with the persistence of Client
variables that don't go
away if the Coldfusion server is cycled (restarted) and
RAM is tossed out.
(something that happens too often on a shared server)
The solution is relatively simple:
I kept these 'persistent session variables' all together
in a structure
just to make working with them easier.
Every time I needed to write (change) the variables I
updated both a session
variable AND a client variable.
Every time I needed to read the variables I simply read
from a session
variable.
I have code that runs before every page (Fbx_settings for
Fusebox or
Application.cfm otherwise) that checks if there is no
current session (NOT
IsDefined('session.insession')). If not, then I mark the
current session (
session.insession='yes') and copy the client variable to
a
session variable.
Think of the client variable as a 'backup' for the
session
variable.
Slight speed hit on writes in return for persistence
across reboots and
restarts.
-Peter Theobald
~
~
~~~|
Archives:
http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.
cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support
these
lists and provide more resources for the community.
http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/uns
ubscribe.cfm?user=633.558.4
s. isaac dealey972-490-6624
new epoch http://www.turnkey.to
lead architect, tapestry cms http://products.turnkey.to
tapestry api is opensource http://www.turnkey.to/tapi
team macromedia volunteer
http://www.macromedia.com/go/team
certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816
~~
~~~|
Archives:
http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/cf_lists/index.
cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by
CFHosting.com. The place for dependable ColdFusion
Hosting.
http://www.cfhosting.com
Unsubscribe: http://www.houseoffusion.com/cf_lists/uns
ubscribe.cfm?user=633.558.4
s. isaac dealey972-490-6624
new epoch http://www.turnkey.to
lead architect, tapestry cms http://products.turnkey.to
tapestry api is opensource http://www.turnkey.to/tapi
team macromedia volunteer http://www.macromedia.com/go/team
certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
RE: Caching custom tag article somewhere?
Have I found the performance? Do you mean have I done performance testing? Nothing formal. === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Rich Z [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 7:12 AM To: CF-Talk Subject: RE: Caching custom tag article somewhere? Thanks much. Very cool. How've you found the performance with this? (then again it is your CHILD, heheh) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF Administrator Jibberish HELP
Still having trouble with CF Admin just displaying jibberish instead of the login dialog page. To see it yourself, just visit http://www.keene.edu/cfide/administrator/index.cfm BP ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
how to free up some log space in SQL server 2000?
hi all My log file is full. And I need to free some space in log file. Could you please show me how to do it? Thanks John __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF Administrator Jibberish HELP
do you have iis setup to handle .cfm pages correctly? which os? which websever? which version of cf? tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 9:31 AM To: CF-Talk Subject: CF Administrator Jibberish HELP Still having trouble with CF Admin just displaying jibberish instead of the login dialog page. To see it yourself, just visit http://www.keene.edu/cfide/administrator/index.cfm BP ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF Administrator Jibberish HELP
Looks like it isn't processing the cfm page at all. Its just servering it as text .. What version? Check your mappings or .cfm mappings in your webserver etc... WG -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 28 July 2003 14:31 To: CF-Talk Subject: CF Administrator Jibberish HELP Still having trouble with CF Admin just displaying jibberish instead of the login dialog page. To see it yourself, just visit http://www.keene.edu/cfide/administrator/index.cfm BP ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Listing Number of Results
Is there a way, without having to write separate queries for each instance, to list the number of records sorted by a specific field? For example, I've got a table of products listed by a number of countries. On one page, I'd like a summary: US 12 products found INDIA 23 products found ITALY 10 products found. There's close to 40 countries in the database. Certainly don't want to put 40 queries on one page just to count the number for each country! What's Best Practice here? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF Administrator Jibberish HELP
Anyone who was wondering, servering is a techincal term. :-) WG -Original Message- From: webguy [mailto:[EMAIL PROTECTED] Sent: 28 July 2003 15:02 To: CF-Talk Subject: RE: CF Administrator Jibberish HELP Looks like it isn't processing the cfm page at all. Its just servering it as text .. What version? Check your mappings or .cfm mappings in your webserver etc... WG -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 28 July 2003 14:31 To: CF-Talk Subject: CF Administrator Jibberish HELP Still having trouble with CF Admin just displaying jibberish instead of the login dialog page. To see it yourself, just visit http://www.keene.edu/cfide/administrator/index.cfm BP ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Select TOP X form all Groups
I need the top X records, if more then X records could be considered the top, I just need X records based on any other order of convenience. For example: NAMEVIEWS rec14 rec23 rec33 rec43 In this case, I would want rec1 and any one of the following 3. Another example: NAMEVIEWS rec15 rec25 rec35 rec43 In this case, I would want any two of the first three records, either random, alphabetically, or unordered would be fine. Thank You -- Ian Skinner Web Programmer BloodSource Sacramento, CA -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 3:51 AM To: CF-Talk Subject: Re: Select TOP X form all Groups Ian Skinner wrote: I have a table something like the below. I would like to create a select that will retrieve the TOP 2 records for each category? I can't seem to get my head around this one, is it really that difficult? Desired Results: TYPE NAMEVIEWS CampgroundX 4 CampgroundBar 3 So which results do you want if there are 3 names with the same number of views? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Listing Number of Results
need db layout and can-do, but truly, its going to involve a count(somthingtoCount) and group by statement at the end :) tw tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 9:57 AM To: CF-Talk Subject: Listing Number of Results Is there a way, without having to write separate queries for each instance, to list the number of records sorted by a specific field? For example, I've got a table of products listed by a number of countries. On one page, I'd like a summary: US 12 products found INDIA 23 products found ITALY 10 products found. There's close to 40 countries in the database. Certainly don't want to put 40 queries on one page just to count the number for each country! What's Best Practice here? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF Administrator Jibberish HELP
ok good, I was wondering, since we are playing a new game of techno-bs-Bingo @ our office today, each week, we get a list, and when we have made a bingo we win...words likeBest-Practices, Best-Of-Breed, etc :) it's a fun game! tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: webguy [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 10:08 AM To: CF-Talk Subject: RE: CF Administrator Jibberish HELP Anyone who was wondering, servering is a techincal term. :-) WG -Original Message- From: webguy [mailto:[EMAIL PROTECTED] Sent: 28 July 2003 15:02 To: CF-Talk Subject: RE: CF Administrator Jibberish HELP Looks like it isn't processing the cfm page at all. Its just servering it as text .. What version? Check your mappings or .cfm mappings in your webserver etc... WG -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 28 July 2003 14:31 To: CF-Talk Subject: CF Administrator Jibberish HELP Still having trouble with CF Admin just displaying jibberish instead of the login dialog page. To see it yourself, just visit http://www.keene.edu/cfide/administrator/index.cfm BP ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Administrator Jibberish HELP
Don't forget these popular winners... my last manager used these daily! wrapped-around-the-axle, down-in-the-weeds, thin-client and my personal creation... VLOG, pronounced like BLOG but with a V :-) LOL. Mike - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 28, 2003 10:06 AM Subject: RE: CF Administrator Jibberish HELP ok good, I was wondering, since we are playing a new game of techno-bs-Bingo @ our office today, each week, we get a list, and when we have made a bingo we win...words likeBest-Practices, Best-Of-Breed, etc :) it's a fun game! tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: webguy [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 10:08 AM To: CF-Talk Subject: RE: CF Administrator Jibberish HELP Anyone who was wondering, servering is a techincal term. :-) WG -Original Message- From: webguy [mailto:[EMAIL PROTECTED] Sent: 28 July 2003 15:02 To: CF-Talk Subject: RE: CF Administrator Jibberish HELP Looks like it isn't processing the cfm page at all. Its just servering it as text .. What version? Check your mappings or .cfm mappings in your webserver etc... WG -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 28 July 2003 14:31 To: CF-Talk Subject: CF Administrator Jibberish HELP Still having trouble with CF Admin just displaying jibberish instead of the login dialog page. To see it yourself, just visit http://www.keene.edu/cfide/administrator/index.cfm BP ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF Administrator Jibberish HELP
I did that. My entire site is .cfm and all the pages are working except those in cfide... .cfm is mapped to jrun.dll BP -Original Message- From: webguy [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 10:02 AM To: CF-Talk Subject:RE: CF Administrator Jibberish HELP Looks like it isn't processing the cfm page at all. Its just servering it as text .. What version? Check your mappings or .cfm mappings in your webserver etc... WG -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 28 July 2003 14:31 To: CF-Talk Subject: CF Administrator Jibberish HELP Still having trouble with CF Admin just displaying jibberish instead of the login dialog page. To see it yourself, just visit http://www.keene.edu/cfide/administrator/index.cfm BP ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: IE Browser Progress Bar runs
I have a framed cfmx site, that seems to at least 75% of the time show the bottom progress bar for IE at some point between zero and 100% after the page has already loaded. I am using Iframes on this site. But they are for form submissions only, and so are not being continuously used. Using IE 6.0.28 Has anyone had this happen to them? Thanks for any input. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF Administrator Jibberish HELP
Sorry, Win2k Server IIS 5.0 CFMX BP -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 9:51 AM To: CF-Talk Subject:RE: CF Administrator Jibberish HELP do you have iis setup to handle .cfm pages correctly? which os? which websever? which version of cf? tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 9:31 AM To: CF-Talk Subject: CF Administrator Jibberish HELP Still having trouble with CF Admin just displaying jibberish instead of the login dialog page. To see it yourself, just visit http://www.keene.edu/cfide/administrator/index.cfm BP ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
JDBC Driver problem with MS SQL Server 2000
Thanks for the response. A couple of things here.
* SP is not applicable for this application since this is a generic purpose component
(constraint one, may not have permission to create an SP with a client's db).
* As you know, it's dynamic query, my syntax and flow and yours would come to same
resultset, the slight difference,
the syntax of select var = ... should be same as set var = ... while I forgot to
mention that I had set nocount on on top. To verify it, I tested it using set var
= ..., got same CF err msg.
It seems quite likely the JDBC driver fails to parse quotes properly.
EXEC('select ' + @col1 + ' as col1, ' + @col2 + '
as col2, ' + @col3 + ' as col3 from ' + @obj + ' order
by ' + @col2);
What your trying to do above.. should really be done in a Stored Procedure..
If you cant do that.. try to build the SQL Statement first.
i.e
declare @sqlStmt varchar(500)
if (@chkCols = 3)
set @sqlStmt = 'select ' + @col1 + ' as col1, ' + @col2 + 'as col2, ' +
@col3 + ' as col3 from ' + @obj + ' order by ' + @col2;
else
set @sqlStmt = 'select ' + @col1 + ' as col1, ' + @col2 + '
as col2, ' + @col3 + ' as col3 from ' + @obj + ' order by ' + @col2;
exec(@sqlStmt)
You might also want to look into sp_executesql.
Your problem really might be some casting/invalid quotes.
Joe Eugene
-Original Message-
From: LI, Chunshen (Don) [mailto:[EMAIL PROTECTED]
Sent: Sunday, July 27, 2003 8:21 PM
To: CF-Talk
Subject: JDBC Driver problem with MS SQL Server 2000
My environment, CFMX Prof, Windows XP Pro OS, MS SQL
Server 2000 DB server.
The following query executes fine with Query Analyzer
and the query execution shows up fine by CF debugging,
however, I got the following annoying err msg, please
note, I must use column alias for referencing later,
and if I don't use column alias the JDBC driver seems
to be OK but how come? column alias is a simple
function with any DBMS, no reason JDBC driver fails to
support it. Any one shied some light? Thanks.
Macromedia][SQLServer JDBC
Driver][SQLServer]Incorrect syntax near the keyword
'as'.
...
cfquery name=getStuff datasource=#Attributes.ds#
136 :set nocount on
137 :declare @obj varchar(150)
--
--
SQL stmt ommitted here
DATASOURCE XXXyyyZZZds
VENDORERRORCODE 156
SQLSTATE HY000
declare @obj varchar(150)
declare @col1 varchar(25)
declare @col2 varchar(350)
declare @col3 varchar(350)
declare @chkCols int
select @chkCols =
(select count(name)
from syscolumns
where id = 2137058649);
select @obj =
(select name
from sysobjects
where id = 2137058649);
select @col1 =
(select name
from syscolumns
where id = 2137058649
and colid = 1);
select @col2 =
(select name
from syscolumns
where id = 2137058649
and colid = 2);
select @col3 =
(select name
from syscolumns
where id = 2137058649
and colid = 3);
set nocount off;
if (@chkCols = 3)
Begin
EXEC('select ' + @col1 + ' as col1, ' + @col2 + '
as col2, ' + @col3 + ' as col3 from ' + @obj + ' order
by ' + @col2);
End
else
Begin
EXEC('select ' + @col1 + ' as col1, ' + @col2 + '
as col2 from ' + @obj + ' order by ' + @col2);
End
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at
http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Writing Custom Tags in XML?
Is it possible to write custom tags in well-formed XML? The reason I ask is that I'd like to take advantage of CFMX's XML parsing to create documented views by simply pointing to the custom tag. Will this render the tags unusable? For example: ?xml version=1.0 encoding=UTF-8? CustomTag name=makebold description=This tag makes the passed on text attribute bold. CFPARAM default=YourText name=text type=string hint=The text passed in that will be made bold. CFOUTPUTb#attributes.text#/b/CFOUTPUT /CustomTag Notice I added attributes to the CFPARAM tags (attributes I'm assuming CFMX will ignore?) as well as wrapped the whole thing in a root element. What will CF do with this? Of course, I could just try this myself - but I'm too damn lazy. Heh. Thanks, Rich ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: IE Browser Progress Bar runs
Yep see this as well, using IFRAMES and CFMX and again the frames are a mixture of posting hidden data, and some visual display needs. We are using javascript heavily though, and use it for form posts. I assumed it may have been a bug in my JS somewhere and have not had time to look for image preload problems and the like. -Original Message- From: John Stanley [mailto:[EMAIL PROTECTED] Sent: 28 July 2003 15:25 To: CF-Talk Subject: OT: IE Browser Progress Bar runs I have a framed cfmx site, that seems to at least 75% of the time show the bottom progress bar for IE at some point between zero and 100% after the page has already loaded. I am using Iframes on this site. But they are for form submissions only, and so are not being continuously used. Using IE 6.0.28 Has anyone had this happen to them? Thanks for any input. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: how to free up some log space in SQL server 2000?
Do a backup of the transaction log, and under the 'options' tab in SQL Ent. Manager select the 'remove inactive entries from transaction log' option. You'll probably want to have the transaction log backed up regularly (at least daily) - so when you do the transaction log backup, also select the option to schedule the job. These might be of some help... http://www.sqlteam.com/FilterTopics.asp?TopicID=115 http://www.sqlteam.com/FilterTopics.asp?TopicID=116 HTH, Alex -Original Message- From: John Ho [mailto:[EMAIL PROTECTED] Sent: 28 July 2003 14:51 To: CF-Talk Subject: how to free up some log space in SQL server 2000? hi all My log file is full. And I need to free some space in log file. Could you please show me how to do it? Thanks John __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Writing Custom Tags in XML?
Are you asking if you can write wrapper tags? If so, yes, you can: cf_foo blah blah blah /cf_foo You can access the crap on the inside. You can even do: cf_foo cf_goo cf_zoo /cf_goo /cf_foo and all the children/parents/etc can access each other. You can get super-complex. :) === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Rich Z [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 8:30 AM To: CF-Talk Subject: Writing Custom Tags in XML? Is it possible to write custom tags in well-formed XML? The reason I ask is that I'd like to take advantage of CFMX's XML parsing to create documented views by simply pointing to the custom tag. Will this render the tags unusable? For example: ?xml version=1.0 encoding=UTF-8? CustomTag name=makebold description=This tag makes the passed on text attribute bold. CFPARAM default=YourText name=text type=string hint=The text passed in that will be made bold. CFOUTPUTb#attributes.text#/b/CFOUTPUT /CustomTag Notice I added attributes to the CFPARAM tags (attributes I'm assuming CFMX will ignore?) as well as wrapped the whole thing in a root element. What will CF do with this? Of course, I could just try this myself - but I'm too damn lazy. Heh. Thanks, Rich ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: IE Browser Progress Bar runs
same here with the js, thanks for your input. i was hoping to find a window property like (window.progress_bar.size = 0 )that I could set manually, but am having no luck. there is window.status, but that refers to the text area to the left of the progress bar. -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 10:31 AM To: CF-Talk Subject: RE: IE Browser Progress Bar runs Yep see this as well, using IFRAMES and CFMX and again the frames are a mixture of posting hidden data, and some visual display needs. We are using javascript heavily though, and use it for form posts. I assumed it may have been a bug in my JS somewhere and have not had time to look for image preload problems and the like. -Original Message- From: John Stanley [mailto:[EMAIL PROTECTED] Sent: 28 July 2003 15:25 To: CF-Talk Subject: OT: IE Browser Progress Bar runs I have a framed cfmx site, that seems to at least 75% of the time show the bottom progress bar for IE at some point between zero and 100% after the page has already loaded. I am using Iframes on this site. But they are for form submissions only, and so are not being continuously used. Using IE 6.0.28 Has anyone had this happen to them? Thanks for any input. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
testing for format isNumeric
this is pulling from an old oracle database i don't have access to correct any problems with data type mismatches. so looks like there may be alpha characters or other junk in a gallons numeric field that is displayed... what i want to do is if i cant do a calculation to a field do to a data type miss match. to show say a RED X instead of its normal number. this way the database admin can physically correct the problem, but the record set will still display the rest of the content.. so how would i check for mis match. cfif isNumeric(gallons) cfset tgallons=tgallons+gallons CFELSE cfset tgallons=SetX /cfif cfif isNumeric(tgallons)cfoutput#NumberFormat(tgallons,9.99)#/cfoutput cfelse strongfont color=#FFX/font/strong/font /cfif you help is much appreciated! thank you -paul ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Writing Custom Tags in XML?
A lot of CFMX built in error handling messages is output with XML, using the cf tags CFSWICTH and CFCASE for the structure of the XML document. -Original Message- From: Rich Z [mailto:[EMAIL PROTECTED] Sent: 28 July 2003 15:30 To: CF-Talk Subject: Writing Custom Tags in XML? Is it possible to write custom tags in well-formed XML? The reason I ask is that I'd like to take advantage of CFMX's XML parsing to create documented views by simply pointing to the custom tag. Will this render the tags unusable? For example: ?xml version=1.0 encoding=UTF-8? CustomTag name=makebold description=This tag makes the passed on text attribute bold. CFPARAM default=YourText name=text type=string hint=The text passed in that will be made bold. CFOUTPUTb#attributes.text#/b/CFOUTPUT /CustomTag Notice I added attributes to the CFPARAM tags (attributes I'm assuming CFMX will ignore?) as well as wrapped the whole thing in a root element. What will CF do with this? Of course, I could just try this myself - but I'm too damn lazy. Heh. Thanks, Rich ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: DRK4 Red Sky
On Monday, July 28, 2003, at 09:10 AM, Rich Z wrote: Hi all: I grabbed the DRK4 files this past weekend and noticed that RSS Untangle required Red Sky (or the 1.4 JVM). I'm sort of surprised Macromedia would put out a DRK that isn't even supported on the current CFMX release. Any idea why this occurred? My guess is Red Sky is very close. Yes, Red Sky is close. I've been saying this summer all summer, and we are certainly well into the summer. There are a couple of ColdFusion projects on DRK 4 which require Red Sky in certain circumstances, but there are always work-arounds. For instance, RSS Untangle only requires Red Sky for the updated JVM, which means you can just update the JVM with your existing installation of ColdFusion and RSSU will work fine. Pollster needs Red Sky on Unix platforms (other than OS X) because all the components in the application are mixed case, which is not supported by the current version of ColdFusion MX. If you don't have Red Sky, the work-around is to create lower case symbolic links, as described in the documentation. We wrote Red Sky specific code only where we thought it actually would make configuration and usage easier. For instance, RSSU requires a new JDK for it's built-in XML support. The XML parsing is done in Java (not ColdFusion), so we couldn't rely on ColdFusion's ability to parse XML, or the Java libraries underneath it since ColdFusion encapsulates the functionality well enough that future implementations might contain different versions of the underlying Java libraries. We needed an XML implementation we could count on not changing for a while, so rather than requiring the usage of third-party parsers, we decided to use the functionality that Sun already provides. Christian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Select TOP X form all Groups
Ian, Have you tried using TOP in your query. I have used it with SQLServer7.0 Here is an example form the SQLServer Online Books: Limiting Result Sets Using TOP and PERCENT The TOP clause limits the number of rows returned in the result set. TOP n [PERCENT] n specifies how many rows are returned. If PERCENT is not specified, n is the number of rows to return. If PERCENT is specified, n is the percentage of the result set rows to return: TOP 120 /*Return the top 120 rows of the result set. */ TOP 15 PERCENT /* Return the top 15% of the result set. */. If a SELECT statement that includes TOP also has an ORDER BY clause, the rows to be returned are selected from the ordered result set. The entire result set is built in the specified order and the top n rows in the ordered result set are returned. The other method of limiting the size of a result set is to execute a SET ROWCOUNT n statement before executing a statement. SET ROWCOUNT differs from TOP in these ways: The SET ROWCOUNT limit applies to building the rows in the result set before an ORDER BY is evaluated. Even if ORDER BY is specified, the SELECT statement is terminated when n rows have been selected. n rows are selected, then ordered and returned to the client. The TOP clause applies to the single SELECT statement in which it is specified. SET ROWCOUNT remains in effect until another SET ROWCOUNT statement is executed, such as SET ROWCOUNT 0 to turn the option off. -Mario -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 10:03 AM To: CF-Talk Subject: RE: Select TOP X form all Groups I need the top X records, if more then X records could be considered the top, I just need X records based on any other order of convenience. For example: NAMEVIEWS rec14 rec23 rec33 rec43 In this case, I would want rec1 and any one of the following 3. Another example: NAMEVIEWS rec15 rec25 rec35 rec43 In this case, I would want any two of the first three records, either random, alphabetically, or unordered would be fine. Thank You -- Ian Skinner Web Programmer BloodSource Sacramento, CA -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 3:51 AM To: CF-Talk Subject: Re: Select TOP X form all Groups Ian Skinner wrote: I have a table something like the below. I would like to create a select that will retrieve the TOP 2 records for each category? I can't seem to get my head around this one, is it really that difficult? Desired Results: TYPE NAMEVIEWS CampgroundX 4 CampgroundBar 3 So which results do you want if there are 3 names with the same number of views? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOLVED - RE: CFX_ESRIMAP
After rebuilding the server a second time, I was able to solve my CF5 / ArcIMS problem. It looks like software on the server may have been installed in the incorrect order as specified in ESRI support document http://support.esri.com/index.cfm?fa=knowledgebase.techarticles.articleS howd=24750. Never would have thought this installation would be so tricky, but it was. M -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: Friday, July 25, 2003 4:17 PM To: CF-Talk Subject: Re: CFX_ESRIMAP Hmmm... I was afraid of this, I actually installed it properly but it still does not want to work. these are all in the same dir as cfx_esrimap.dll (or maybe in a path)? aimsutil.dll cfxesrimap_root.res emaplink.dll icudata.dll icui18n.dll icuuc.dll xerces-c_1_3.dll znlib.dll did you upgrade over previous arcIMS? if so maybe delete that tag re-register it (sorry these are sort of guesses, but hard for me to find a cf5 box let alone one w/arcIMS4.01 anymore). also probably a dumb question but are you sure arcIMS is up running ok? the diags returned ok? i do recall the nightmares getting it properly intalled with tomcat, etc. under cf5--its a breeze w/mx. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Select TOP X form all Groups
Yes, I tried the TOP X command, but in my original post, I mentioned that I need the TOP X rows for each of a group a categories. See below. If there are more then two results that match as top of the category, I don't care which two I get, just so I get only the TOP X for each category. Desired Results: TYPENAMEVIEWS Campground X 4 Campground Bar 3 Trail Here3 Trail There 3 LakeMed 3 LakeSmall 2 From Table: TYPENAMEVIEWS Campground Foo 2 Campground Bar 3 Campground X 4 Campground Y 3 Trail Joe's 1 Trail Pac 2 Trail Here3 Trail There 3 LakeBig 1 LakeSmall 2 LakeMed 3 For example: NAMEVIEWS rec14 rec23 rec33 rec43 In this case, I would want rec1 and any one of the following 3. Another example: NAMEVIEWS rec15 rec25 rec35 rec43 In this case, I would want any two of the first three records, either random, alphabetically, or unordered would be fine. -- Ian Skinner Web Programmer BloodSource Sacramento, CA -Original Message- From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 7:54 AM To: CF-Talk Subject: RE: Select TOP X form all Groups Ian, Have you tried using TOP in your query. I have used it with SQLServer7.0 Here is an example form the SQLServer Online Books: Limiting Result Sets Using TOP and PERCENT The TOP clause limits the number of rows returned in the result set. TOP n [PERCENT] n specifies how many rows are returned. If PERCENT is not specified, n is the number of rows to return. If PERCENT is specified, n is the percentage of the result set rows to return: TOP 120 /*Return the top 120 rows of the result set. */ TOP 15 PERCENT /* Return the top 15% of the result set. */. If a SELECT statement that includes TOP also has an ORDER BY clause, the rows to be returned are selected from the ordered result set. The entire result set is built in the specified order and the top n rows in the ordered result set are returned. The other method of limiting the size of a result set is to execute a SET ROWCOUNT n statement before executing a statement. SET ROWCOUNT differs from TOP in these ways: The SET ROWCOUNT limit applies to building the rows in the result set before an ORDER BY is evaluated. Even if ORDER BY is specified, the SELECT statement is terminated when n rows have been selected. n rows are selected, then ordered and returned to the client. The TOP clause applies to the single SELECT statement in which it is specified. SET ROWCOUNT remains in effect until another SET ROWCOUNT statement is executed, such as SET ROWCOUNT 0 to turn the option off. -Mario -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 10:03 AM To: CF-Talk Subject: RE: Select TOP X form all Groups I need the top X records, if more then X records could be considered the top, I just need X records based on any other order of convenience. For example: NAMEVIEWS rec14 rec23 rec33 rec43 In this case, I would want rec1 and any one of the following 3. Another example: NAMEVIEWS rec15 rec25 rec35 rec43 In this case, I would want any two of the first three records, either random, alphabetically, or unordered would be fine. Thank You -- Ian Skinner Web Programmer BloodSource Sacramento, CA -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 3:51 AM To: CF-Talk Subject: Re: Select TOP X form all Groups Ian Skinner wrote: I have a table something like the below. I would like to create a select that will retrieve the TOP 2 records for each category? I can't seem to get my head around this one, is it really that difficult? Desired Results: TYPE NAMEVIEWS CampgroundX 4 CampgroundBar 3 So which results do you want if there are 3 names with the same number of views? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
List of Variables.
Is there a way to list the variables used in a .cfm file? What we are trying to do is create a list of the names of the variables for our error handling routines. cfdump is not an option as it can put out very large e-mails (our error handling is e-mailed to us) sometimes up to 12 meg! Any ideas would be appreciated. Thanks Steve ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Listing Number of Results
Does the country appear in a field? If so, you could use something like this: CFSET US_Count = ListValueCountNoCase(ValueList(qryMyQuery.CountryField),US) CFSET INDIA_Count = ListValueCountNoCase(ValueList(qryMyQuery.CountryField),INDIA) ...etc... Chris -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 9:57 AM To: CF-Talk Subject: Listing Number of Results Is there a way, without having to write separate queries for each instance, to list the number of records sorted by a specific field? For example, I've got a table of products listed by a number of countries. On one page, I'd like a summary: US 12 products found INDIA 23 products found ITALY 10 products found. There's close to 40 countries in the database. Certainly don't want to put 40 queries on one page just to count the number for each country! What's Best Practice here? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: List of Variables.
12 megs? ummm, that is a lot of TEXT. - Original Message - From: DURETTE, STEVEN J (AIT) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 28, 2003 11:07 AM Subject: List of Variables. Is there a way to list the variables used in a .cfm file? What we are trying to do is create a list of the names of the variables for our error handling routines. cfdump is not an option as it can put out very large e-mails (our error handling is e-mailed to us) sometimes up to 12 meg! Any ideas would be appreciated. Thanks Steve ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOLVED - RE: CFX_ESRIMAP
oi Mike!! i've had /many/ occasions where i have had to install the thing /multiple/ times Monday, July 28, 2003, 10:58:37 AM, you wrote: HM After rebuilding the server a second time, I was able to solve my CF5 / HM ArcIMS problem. It looks like software on the server may have been HM installed in the incorrect order as specified in ESRI support document HM http://support.esri.com/index.cfm?fa=knowledgebase.techarticles.articleS HM howd=24750. Never would have thought this installation would be so HM tricky, but it was. HM M HM -Original Message- HM From: Paul Hastings [mailto:[EMAIL PROTECTED] HM Sent: Friday, July 25, 2003 4:17 PM HM To: CF-Talk HM Subject: Re: CFX_ESRIMAP Hmmm... I was afraid of this, I actually installed it properly but it still does not want to work. HM these are all in the same dir as cfx_esrimap.dll (or maybe in a path)? HM aimsutil.dll HM cfxesrimap_root.res HM emaplink.dll HM icudata.dll HM icui18n.dll HM icuuc.dll HM xerces-c_1_3.dll HM znlib.dll HM did you upgrade over previous arcIMS? if so maybe delete that tag HM re-register it (sorry these are sort of guesses, but hard for me to find HM a cf5 box let alone one w/arcIMS4.01 anymore). also probably a dumb HM question but are you sure arcIMS is up running ok? the diags returned HM ok? i do recall the nightmares getting it properly intalled with tomcat, HM etc. under cf5--its a breeze w/mx. HM ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: List of Variables.
In MX, you can dump Variables. Before MX, you can dump Session, Application, URL, Form. Client and COokie I _think_ are only dumpable in MX, although you CAN get them using various functions. Server - MX only. Basically, prior to MX, everything but Server and Variables, but you may have to do some work instead of just cfdump In MX: Every darn thing in the world. Oh, shoot, I see cfdump isn't an option. Well, you can just get your variable names by doing: cfset currentVariables = structKeyList(variables) but again, that's MX only. === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 9:07 AM To: CF-Talk Subject: List of Variables. Is there a way to list the variables used in a .cfm file? What we are trying to do is create a list of the names of the variables for our error handling routines. cfdump is not an option as it can put out very large e-mails (our error handling is e-mailed to us) sometimes up to 12 meg! Any ideas would be appreciated. Thanks Steve ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: List of Variables.
Never mind, figured it out myself. cfset myList = structKeyList(Variables, ,) Thanks anyway. Steve -Original Message- From: DURETTE, STEVEN J (AIT) Sent: Monday, July 28, 2003 11:07 AM To: CF-Talk (E-mail) Subject: List of Variables. Is there a way to list the variables used in a .cfm file? What we are trying to do is create a list of the names of the variables for our error handling routines. cfdump is not an option as it can put out very large e-mails (our error handling is e-mailed to us) sometimes up to 12 meg! Any ideas would be appreciated. Thanks Steve ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Select TOP X form all Groups
Ian Skinner wrote: I need the top X records, if more then X records could be considered the top, I just need X records based on any other order of convenience. For example: NAME VIEWS rec1 4 rec2 3 rec3 3 rec4 3 In this case, I would want rec1 and any one of the following 3. Something like this should work: SELECT a.type, a.name, a.views FROMtable a WHERE ( SELECT COUNT() FROMtable b WHERE a.type = b.type AND ( b.views a.views OR ( b.views = a.views AND b.name a.name ) ) ) 2 Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: List of Variables.
When you do a cfdump, it returns all of the contents of all of the queries that run. That can be large for some of our applications. -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 11:11 AM To: CF-Talk Subject: Re: List of Variables. 12 megs? ummm, that is a lot of TEXT. - Original Message - From: DURETTE, STEVEN J (AIT) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 28, 2003 11:07 AM Subject: List of Variables. Is there a way to list the variables used in a .cfm file? What we are trying to do is create a list of the names of the variables for our error handling routines. cfdump is not an option as it can put out very large e-mails (our error handling is e-mailed to us) sometimes up to 12 meg! Any ideas would be appreciated. Thanks Steve ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SOLVED - RE: CFX_ESRIMAP
Isn't it annoying? I mean, I like ArcIMS and all, but setup can be a beast. I hope my experiences with the percularities of the server help someone else. M -Original Message- From: Critz [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 11:13 AM To: CF-Talk Subject: Re: SOLVED - RE: CFX_ESRIMAP oi Mike!! i've had /many/ occasions where i have had to install the thing /multiple/ times ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
all caps in CF-Studio
is there way to take some normal text in a .cfm page and turn it to ALL CAPS using a custom button in CF-Studio? thanks. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: List of Variables.
What about having the error handler dump the data to separate files, and send links to them in an email? It's possible every single query's data isn't necessary for every problem, and based on the error message, the developer who's recieving the problem emails could follow the link to the relevant dump or variable list. - Jim DURETTE, STEVEN J (AIT) wrote: When you do a cfdump, it returns all of the contents of all of the queries that run. That can be large for some of our applications. -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 11:11 AM To: CF-Talk Subject: Re: List of Variables. 12 megs? ummm, that is a lot of TEXT. - Original Message - From: DURETTE, STEVEN J (AIT) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 28, 2003 11:07 AM Subject: List of Variables. Is there a way to list the variables used in a .cfm file? What we are trying to do is create a list of the names of the variables for our error handling routines. cfdump is not an option as it can put out very large e-mails (our error handling is e-mailed to us) sometimes up to 12 meg! Any ideas would be appreciated. Thanks Steve ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: all caps in CF-Studio
Select. Right click. Selection - Convert to Uppercase. === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Wurst, Keith D. [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 9:27 AM To: CF-Talk Subject: all caps in CF-Studio is there way to take some normal text in a .cfm page and turn it to ALL CAPS using a custom button in CF-Studio? thanks. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: all caps in CF-Studio
CTRL-A, then right click... Selection - convert to uppercase HTH -Original Message- From: Wurst, Keith D. [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 16:27 To: CF-Talk Subject: all caps in CF-Studio is there way to take some normal text in a .cfm page and turn it to ALL CAPS using a custom button in CF-Studio? thanks. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: all caps in CF-Studio
is there way to take some normal text in a .cfm page and turn it to ALL CAPS using a custom button in CF-Studio? thanks. 1. Select the text 2. Right-click on the highlighted text 3. Scroll down to Selection-Convert to Upper Case Regards, Dave. _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Select TOP X form all Groups
This is something to work from... I threw it together from the Northwind DB that ships with SQL Server SELECT C1.CategoryName AS CATEGORY, Count(C2.ProductID) AS 'TOTAL IN CATEGORY' FROM Categories C1, Products C2 WHERE C1.CategoryID = C2.CategoryID GROUP BY C1.CategoryName Mike - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 28, 2003 11:21 AM Subject: Re: Select TOP X form all Groups Ian Skinner wrote: I need the top X records, if more then X records could be considered the top, I just need X records based on any other order of convenience. For example: NAME VIEWS rec1 4 rec2 3 rec3 3 rec4 3 In this case, I would want rec1 and any one of the following 3. Something like this should work: SELECT a.type, a.name, a.views FROM table a WHERE ( SELECT COUNT() FROM table b WHERE a.type = b.type AND ( b.views a.views OR ( b.views = a.views AND b.name a.name ) ) ) 2 Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: all caps in CF-Studio
no but, on the code layer http://www.cflib.org/udf.cfm?ID=488 tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Wurst, Keith D. [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 11:27 AM To: CF-Talk Subject: all caps in CF-Studio is there way to take some normal text in a .cfm page and turn it to ALL CAPS using a custom button in CF-Studio? thanks. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: List of Variables.
ugh, cfdump outputs only what you tell it, so not ALL queries are dumped at once. You can dump a single scope also. So, cfdump var=#session# will dump the session scoped vars, first level of only, only. Is there a way to list the variables used in a .cfm file? --- which variables are you speaking of? Doug -Original Message- From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 11:17 AM To: CF-Talk Subject: RE: List of Variables. When you do a cfdump, it returns all of the contents of all of the queries that run. That can be large for some of our applications. -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 11:11 AM To: CF-Talk Subject: Re: List of Variables. 12 megs? ummm, that is a lot of TEXT. - Original Message - From: DURETTE, STEVEN J (AIT) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 28, 2003 11:07 AM Subject: List of Variables. Is there a way to list the variables used in a .cfm file? What we are trying to do is create a list of the names of the variables for our error handling routines. cfdump is not an option as it can put out very large e-mails (our error handling is e-mailed to us) sometimes up to 12 meg! Any ideas would be appreciated. Thanks Steve ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: all caps in CF-Studio
Select the text you want in caps, right click then choose 'selection-convert to uppercase' -Original Message- From: Wurst, Keith D. [mailto:[EMAIL PROTECTED] Sent: 28 July 2003 16:27 To: CF-Talk Subject: all caps in CF-Studio is there way to take some normal text in a .cfm page and turn it to ALL CAPS using a custom button in CF-Studio? thanks. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: all caps in CF-Studio
if you select the text and right-click on it, choose 'selection', then 'convert to uppercase' -Original Message- From: Wurst, Keith D. [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 9:27 AM To: CF-Talk Subject: all caps in CF-Studio is there way to take some normal text in a .cfm page and turn it to ALL CAPS using a custom button in CF-Studio? thanks. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: all caps in CF-Studio
highlight your text -- right click your mouse over the highlit region -- choose selection -- convert to uppercase Doug -Original Message- From: Wurst, Keith D. [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 11:27 AM To: CF-Talk Subject: all caps in CF-Studio is there way to take some normal text in a .cfm page and turn it to ALL CAPS using a custom button in CF-Studio? thanks. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Does CFMX install require restart?
It's been a while since I installed CFMX on a server I can't remember if it asks to restart the box or not, does it? What about updater 3? I didn't see anything in the release notes, but I want to make sure. This will help determine when we install it today as the box has other services running. BTW, it's a Windows 2000 Server (not AS). Thanks, Ryan Kime mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Web Developer Webco Industries ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOLVED - RE: CFX_ESRIMAP
Isn't it annoying? I mean, I like ArcIMS and all, but setup can be a beast. I hope my experiences with the percularities of the server help someone else. if you install under mx it works 100% first time all the time. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Listing Number of Results - One More Question
:: CFSET US_Count = ListValueCountNoCase(ValueList(qryMyQuery.CountryField),US) :: CFSET INDIA_Count = ListValueCountNoCase(ValueList(qryMyQuery.CountryField),INDIA) This works great! Thanks! I suddenly realized that I've got one further problem though... In the database, I've got (for example) two fields Country | Prod_Category I suddenly realize that I'm trying to count the number of distinct categories for each country, not the number of times each country appears... So, if the category is red (and there's several hundred catagories), how many red for the US, how many red for Nepal... A compound SQL query using DISTINCT ?? Not sure. Suggestions? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: all caps in CF-Studio
I take that back, not that I know of but here you can do it for presentation... http://www.cflib.org/udf.cfm?ID=488 :) tony tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 11:30 AM To: CF-Talk Subject: RE: all caps in CF-Studio no but, on the code layer http://www.cflib.org/udf.cfm?ID=488 tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Wurst, Keith D. [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 11:27 AM To: CF-Talk Subject: all caps in CF-Studio is there way to take some normal text in a .cfm page and turn it to ALL CAPS using a custom button in CF-Studio? thanks. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMX and JSP's
Hey, just checking here, but when using JPS's with CFMX Enterprise (NOT CFMX FOR J2EE), for each web application in your web root directory, do you, or should I say is it recommended practice to create a WEB-INF folder containing a LIB and CLASSES directory as well as the web.xml, referencing your jars, like you do in apache. Its just that someone told me that with regards to this simple app structuring JRUN and TOMCAT are the same. Would this be the correct way to work with JSP in CFMX? J ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Does CFMX install require restart?
I'm not sure about the CFMX install, but I know the updates only require a service restart. Of course, after a major software installation like CFMX, it is a good idea to restart anyways, just in case Dave -Original Message- From: Ryan Kime [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 11:36 AM To: CF-Talk Subject: Does CFMX install require restart? It's been a while since I installed CFMX on a server I can't remember if it asks to restart the box or not, does it? What about updater 3? I didn't see anything in the release notes, but I want to make sure. This will help determine when we install it today as the box has other services running. BTW, it's a Windows 2000 Server (not AS). Thanks, Ryan Kime mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Web Developer Webco Industries ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: Netscape 7.1
A lot of the browsers use !DocType to sniff what type of mode to put their browser in. Standards mode means the browser tries to render Standards compliant. Quirks Mode means that it tries to render it the way it used to. A listing of the various modes and browser compliance can be found at: http://www.hut.fi/~hsivonen/doctype.html Yeah NS 7.1 is pretty good, however I just discovered a quirk last night regarding CSS. I've got a major CSS file that sets padding, and a host of other elements in tables. When I generated the page using the !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Final//EN My main navigation table in NS 7.1 had a gap in it, not in IE though. I decided to do a what the heck and used !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2 Final//EN and there was no gap! Not understanding this if I want to ensure standards compliance, I'll need to figure out which CSS, XHTML or DOM element NS 7.1 doesn't support, or if I need to reference a local URI or something. (I'm Just now learning the finer points of advanced CSS and DOM control). So for me, it's cross-browser testing as usual! The real question though is, now that AOL signed another multi-year agreement to use the IE engine in AOL ACK cough - sputter and laid off more NS staff, how long will it be before NS goes completely open source? Ultimately I'm an NS FANatic since NS 0.9 beta and an anti-corporate kind of a guy, however I have no desire (YET) to explore Linux, Opera, or any of the other dozen anti-Bill solutions for Intel based PCs. Rafael At 11:05 PM 7/27/03, you wrote: Lil bit OT but it may be worthy. ;) I had to do some regression testing on an app today and was forced to install Netscape 7.1, ACK!...and I must admit I was pleasantly surprised. I believe it's *finally* caught up to (and surpassed) IE. Built-in pop-up blocking for one...and every IE feature I used to complain that it didn't have. I even found my google bar! ;) http://googlebar.mozdev.org/ Cheers, Stace AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SOLVED - RE: CFX_ESRIMAP
If I remeber correctly: I think they mentioned (the ArcIMS crew) in San Diego that one of the things that they were looking at for next version, 9, was to make installation easier. - Hugo Ahlenius E-Mail: [EMAIL PROTECTED] Project OfficerPhone:+46 8 230460 UNEP GRID-Arendal Fax: +46 8 230441 Stockholm Office Mobile: +46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: Haggerty, Mike [mailto:[EMAIL PROTECTED] | Sent: Monday, July 28, 2003 16:59 | To: CF-Talk | Subject: SOLVED - RE: CFX_ESRIMAP | | | After rebuilding the server a second time, I was able to | solve my CF5 / | ArcIMS problem. It looks like software on the server may have been | installed in the incorrect order as specified in ESRI support document | http://support.esri.com/index.cfm?fa=knowledgebase.techarticle s.articleS | howd=24750. Never would have thought this installation would be so | tricky, but it was. | | M | | -Original Message- | From: Paul Hastings [mailto:[EMAIL PROTECTED] | Sent: Friday, July 25, 2003 4:17 PM | To: CF-Talk | Subject: Re: CFX_ESRIMAP | | | Hmmm... I was afraid of this, I actually installed it | properly but it | still does not want to work. | | these are all in the same dir as cfx_esrimap.dll (or maybe in a path)? | | aimsutil.dll | cfxesrimap_root.res | emaplink.dll | icudata.dll | icui18n.dll | icuuc.dll | xerces-c_1_3.dll | znlib.dll | | did you upgrade over previous arcIMS? if so maybe delete that tag | re-register it (sorry these are sort of guesses, but hard for | me to find | a cf5 box let alone one w/arcIMS4.01 anymore). also probably a dumb | question but are you sure arcIMS is up running ok? the | diags returned | ok? i do recall the nightmares getting it properly intalled | with tomcat, | etc. under cf5--its a breeze w/mx. | | | | ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Select TOP X form all Groups
Hi Ian, Can you try this query: SELECT Type, Name, Views, (type + name) FROM dbo.Your_Table a WHERE type + name IN (SELECT TOP 2 type + Name FROM dbo.Your_Table b WHERE a.type = b.type ORDER BY views DESC) ORDER BY type, views DESC Mario -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 11:31 AM To: CF-Talk Subject: Re: Select TOP X form all Groups This is something to work from... I threw it together from the Northwind DB that ships with SQL Server SELECT C1.CategoryName AS CATEGORY, Count(C2.ProductID) AS 'TOTAL IN CATEGORY' FROM Categories C1, Products C2 WHERE C1.CategoryID = C2.CategoryID GROUP BY C1.CategoryName Mike - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 28, 2003 11:21 AM Subject: Re: Select TOP X form all Groups Ian Skinner wrote: I need the top X records, if more then X records could be considered the top, I just need X records based on any other order of convenience. For example: NAME VIEWS rec1 4 rec2 3 rec3 3 rec4 3 In this case, I would want rec1 and any one of the following 3. Something like this should work: SELECT a.type, a.name, a.views FROM table a WHERE ( SELECT COUNT() FROM table b WHERE a.type = b.type AND ( b.views a.views OR ( b.views = a.views AND b.name a.name ) ) ) 2 Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: all caps in CF-Studio
I was upset to see this excluded from DW. :( Or at least I never found the option... Stace -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 11:30 AM To: CF-Talk Subject: RE: all caps in CF-Studio Select. Right click. Selection - Convert to Uppercase. === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Wurst, Keith D. [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 9:27 AM To: CF-Talk Subject: all caps in CF-Studio is there way to take some normal text in a .cfm page and turn it to ALL CAPS using a custom button in CF-Studio? thanks. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: all caps in CF-Studio
I was upset to see this excluded from DW. :( Or at least I never found the option... While I agree with you, there are DW extensions for this. Try: http://www.bellavite.com/web/dreamweaver.cfm Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Comparing two listvars and deleting dups
How would I make one list that combines the elements of list1 that changed in list2? For example List1: State:FL, City:Jax, County:Duval, Zip:32246 List2: State:FL, City:Jax, County:St Johns, Zip:32259 Output: County:Duval changed to County:St Johns, Zip:32246 changed to Zip:32259 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: Smarter.com and IE
Here is the solution: Open IE and go to Tools/Internet Options Click the Programs tab and select Reset Web Settings - you needn't reset your home page. Cary Gordon The Cherry Hill Company At 03:44 PM 7/25/2003 -0500, you wrote: Anyone else have this problem? I have had my IE Browser start opening the Search on the left... and it brings up smarter.com. I can not seem to get it to quit. When I go places it will randomly pop up. Not just when searching. I can click on a page and it will pop up. then it will not for a while. I have Ad-Aware and it cleaned my system but does not fine this one. I will give these points and a grade of A to the person who helps me remove this from my browser. I do have the google toolbar, Yahoo toolbar installed. I have Microsoft IE Browser 6.0 and Win XP. Not sure what else you need to know to find out what to do to this but hope this is enough. I have used spyware, ad-aware, Browser Hijack Blaster, BHODemon, and MSConfig to remove smarter.com but no luck. Thanks ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Comparing two listvars and deleting dups
Check cflib.org there are 2 UDFs in there that will do this. Mike - Original Message - From: Den Melton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 28, 2003 12:40 PM Subject: Comparing two listvars and deleting dups How would I make one list that combines the elements of list1 that changed in list2? For example List1: State:FL, City:Jax, County:Duval, Zip:32246 List2: State:FL, City:Jax, County:St Johns, Zip:32259 Output: County:Duval changed to County:St Johns, Zip:32246 changed to Zip:32259 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Comparing two listvars and deleting dups
Sorry, I read your post too fast.. the two UDFs will help you do what you are trying to do. - Original Message - From: Michael T. Tangorre [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 28, 2003 12:40 PM Subject: Re: Comparing two listvars and deleting dups Check cflib.org there are 2 UDFs in there that will do this. Mike - Original Message - From: Den Melton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 28, 2003 12:40 PM Subject: Comparing two listvars and deleting dups How would I make one list that combines the elements of list1 that changed in list2? For example List1: State:FL, City:Jax, County:Duval, Zip:32246 List2: State:FL, City:Jax, County:St Johns, Zip:32259 Output: County:Duval changed to County:St Johns, Zip:32246 changed to Zip:32259 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: all caps in CF-Studio
Hi Sorry to piggy back on someone else's thread but my question is slightly related. I can't find the setting which turns the automatic capitlization of tags off in CFstudio. Can anyone remember? Thanks Kola -Original Message- From: Massimo Foti [mailto:[EMAIL PROTECTED] Sent: 28 July 2003 17:18 To: CF-Talk Subject: Re: all caps in CF-Studio I was upset to see this excluded from DW. :( Or at least I never found the option... While I agree with you, there are DW extensions for this. Try: http://www.bellavite.com/web/dreamweaver.cfm Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: all caps in CF-Studio
Options-setings-markup languages-lowercase all inserted tags ??? -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED] Sent: 28 July 2003 17:48 To: CF-Talk Subject: RE: all caps in CF-Studio Hi Sorry to piggy back on someone else's thread but my question is slightly related. I can't find the setting which turns the automatic capitlization of tags off in CFstudio. Can anyone remember? Thanks Kola -Original Message- From: Massimo Foti [mailto:[EMAIL PROTECTED] Sent: 28 July 2003 17:18 To: CF-Talk Subject: Re: all caps in CF-Studio I was upset to see this excluded from DW. :( Or at least I never found the option... While I agree with you, there are DW extensions for this. Try: http://www.bellavite.com/web/dreamweaver.cfm Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Comparing two listvars and deleting dups
This is probably bloated code, but it's the best I can do before lunch :) Marlon cfset List1=State:FL, City:Jax, County:Duval, Zip:32246 cfset List2=State:FL, City:Jax, County:St Johns, Zip:32259 cfset myStruct = structNew() cfloop list=#list1# delimiters=, index=li cfset myStruct[#listfirst(li,:)#] = listlast(li,:) /cfloop cfloop list=#list2# delimiters=, index=li cfset myStruct[#listfirst(li,:)#] = listlast(li,:) /cfloop cfset list3 = cfloop collection=#myStruct# item=li cfset list3 = listappend(list3,#li#:#myStruct[li]#,,) /cfloop cfdump var=#list3# -Original Message- From: Den Melton [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 11:40 AM To: CF-Talk Subject: Comparing two listvars and deleting dups How would I make one list that combines the elements of list1 that changed in list2? For example List1: State:FL, City:Jax, County:Duval, Zip:32246 List2: State:FL, City:Jax, County:St Johns, Zip:32259 Output: County:Duval changed to County:St Johns, Zip:32246 changed to Zip:32259 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Comparing two listvars and deleting dups
At 12:40 PM 7/28/2003 -0400, you wrote: How would I make one list that combines the elements of list1 that changed in list2? For example List1: State:FL, City:Jax, County:Duval, Zip:32246 List2: State:FL, City:Jax, County:St Johns, Zip:32259 Output: County:Duval changed to County:St Johns, Zip:32246 changed to Zip:32259 Will your two lists always consist of those same fields? State, City, County, Zip? If so, that'll make it easier... First, create a variable to hold your output comments, just a blank var. Do a loop from 1 to the length of either of those lists (i.e. ListLen(List1)). Since those lists are comma delimited, that'll be fine. Let's say you use the index var 'pos' on this loop. Then compare ListLast(ListGetAt(List1, pos), :) to ListLast(ListGetAt(List2, pos), :). Note we're using : as a delimeter for these mini-lists. If the two values different, then use ListAppend to append to your output variable list: ListGetAt(List1, pos) changed to ListGetAt(List2, pos) That should do it. --Scott ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Persistent Session variables
We did something similar with our Application Variables. We needed some way
for them to be automatically re-generated after a server cycle. What we do
is write a simple text file whenever the Application variables are updated,
then check for the existence of the necessary Application (again all grouped
into a structure for convenience [Application.State.var1,
Application.State.var2, ect]. If the State structure does not exist in
Application, then the text file is read and parsed to create it.
--
Ian Skinner
Web Programmer
BloodSource
Sacramento, CA
-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: Monday, July 28, 2003 6:35 AM
To: CF-Talk
Subject: RE: Persistent Session variables
awesome. :)
This works in CFMX
cfset CLIENT[Hella] = cool /
Ade
-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: 28 July 2003 14:05
To: CF-Talk
Subject: RE: Persistent Session variables
Very possibly. I'm pretty sure it doesn't work with CF5. I
hadn't heard
anything about changes to the client scope in mx
specifically... I know that
with previous versions of the server there were frequently
other collections
of variables that weren't structures that would become
structures with later
versions.
Could the fact that CF(MX?) treats the CLIENT scope as a
structure
internally allow you to use CLIENT[varname] = myValue; ?
Ade
-Original Message-
From: s. isaac dealey [mailto:[EMAIL PROTECTED]
Sent: 25 July 2003 20:34
To: CF-Talk
Subject: RE: Persistent Session variables
Great suggestion... The only thing I'd add is that you
might consider a user
defined function for setting client/session variables...
function setSession(varname,myvalue) {
session[varname] = myvalue;
client.#varname# = myvalue;
}
I'm not sure off the top of my head if that works... I'm
inclined to expect
it to throw an error on client.#varname# = in the
function call even
though it works outside of cfscript... and as there's no
setclientvariable()
function and client isn't a structure, I'm not sure how
else I'd
accomplish it... in any event -- the idea is that you
don't want to have to
remember to set 2 variables every time you want to set
that session
variable, so the function lets you do it with just the
one
statement...
cfset setSession(userid,myquery.userid)
Original Message ---
I thought some of you might find this interesting.
For an application I needed to have the speed of reading
Session variables
from RAM, combined with the persistence of Client
variables that don't go
away if the Coldfusion server is cycled (restarted) and
RAM is tossed out.
(something that happens too often on a shared server)
The solution is relatively simple:
I kept these 'persistent session variables' all together
in a structure
just to make working with them easier.
Every time I needed to write (change) the variables I
updated both a session
variable AND a client variable.
Every time I needed to read the variables I simply read
from a session
variable.
I have code that runs before every page (Fbx_settings for
Fusebox or
Application.cfm otherwise) that checks if there is no
current session (NOT
IsDefined('session.insession')). If not, then I mark the
current session (
session.insession='yes') and copy the client variable to
a
session variable.
Think of the client variable as a 'backup' for the
session
variable.
Slight speed hit on writes in return for persistence
across reboots and
restarts.
-Peter Theobald
~
~
~~~|
Archives:
http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.
cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support
these
lists and provide more resources for the community.
http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/uns
ubscribe.cfm?user=633.558.4
s. isaac dealey972-490-6624
new epoch http://www.turnkey.to
lead architect, tapestry cms http://products.turnkey.to
tapestry api is opensource http://www.turnkey.to/tapi
team macromedia volunteer
http://www.macromedia.com/go/team
certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816
~~
~~~|
Archives:
http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/cf_lists/index.
cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by
CFHosting.com. The place for dependable ColdFusion
Comparing two listvars and deleting dups
The fields are form elements being passed to a DB page. They will always match. So the first part is the form element (County:, State:, etc.) The second part (Fl, Jax, etc) are the original values upon page load and the new values after the page is submitted. I need to output only those fields that have changed. At 12:40 PM 7/28/2003 -0400, you wrote: How would I make one list that combines the elements of list1 that changed in list2? For example List1: State:FL, City:Jax, County:Duval, Zip:32246 List2: State:FL, City:Jax, County:St Johns, Zip:32259 Output: County:Duval changed to County:St Johns, Zip:32246 changed to Zip:32259 Will your two lists always consist of those same fields? State, City, County, Zip? If so, that'll make it easier... First, create a variable to hold your output comments, just a blank var. Do a loop from 1 to the length of either of those lists (i.e. ListLen(List1)). Since those lists are comma delimited, that'll be fine. Let's say you use the index var 'pos' on this loop. Then compare ListLast(ListGetAt(List1, pos), :) to ListLast(ListGetAt(List2, pos), :). Note we're using : as a delimeter for these mini-lists. If the two values different, then use ListAppend to append to your output variable list: ListGetAt(List1, pos) changed to ListGetAt(List2, pos) That should do it. --Scott ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: List of Variables.
See, the problem was that if you did a cfdump var=#Variables# to get the values of the variables in the Variables scope, you would get all of the queries, objects, etc. You also get a whole bunch of other stuff that is generally not needed when doing a debug. Notice I said generally, I know there are uses for the information, but when you are trying to see what certain variables are getting set to you generally don't need to see all the objects, etc. Now what we are trying to do is loop through the Variables and if it is a simple value to display it. If not then just list the variable name and not simple. We do store the larger cfdump into a database, but if we are just trying to catch something small then we like the simple information in the e-mail so we don't have to go looking for it. (i.e. cfset myVar = myVar - 1 when it should have been cfset myVar = myVar + 1) Steve -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 11:32 AM To: CF-Talk Subject: RE: List of Variables. ugh, cfdump outputs only what you tell it, so not ALL queries are dumped at once. You can dump a single scope also. So, cfdump var=#session# will dump the session scoped vars, first level of only, only. Is there a way to list the variables used in a .cfm file? --- which variables are you speaking of? Doug -Original Message- From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 11:17 AM To: CF-Talk Subject: RE: List of Variables. When you do a cfdump, it returns all of the contents of all of the queries that run. That can be large for some of our applications. -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 11:11 AM To: CF-Talk Subject: Re: List of Variables. 12 megs? ummm, that is a lot of TEXT. - Original Message - From: DURETTE, STEVEN J (AIT) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 28, 2003 11:07 AM Subject: List of Variables. Is there a way to list the variables used in a .cfm file? What we are trying to do is create a list of the names of the variables for our error handling routines. cfdump is not an option as it can put out very large e-mails (our error handling is e-mailed to us) sometimes up to 12 meg! Any ideas would be appreciated. Thanks Steve ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
how to free up some log space in SQL server 2000?
Do a backup of the transaction log, and under the 'options' tab in SQL Ent. Manager select the 'remove inactive entries from transaction log' option. You'll probably want to have the transaction log backed up regularly (at least daily) - so when you do the transaction log backup, also select the option to schedule the job. These might be of some help... http://www.sqlteam.com/FilterTopics.asp?TopicID=115 http://www.sqlteam.com/FilterTopics.asp?TopicID=116 HTH, Alex -Original Message- From: John Ho [mailto:[EMAIL PROTECTED] Sent: 28 July 2003 14:51 To: CF-Talk Subject: how to free up some log space in SQL server 2000? hi all My log file is full. And I need to free some space in log file. Could you please show me how to do it? Thanks John __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
how to free up some log space in SQL server 2000?
thanks Alex John ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Help!
Hi, I have linked a Global Address List to a MS Access table. As far as I can tell it went smoothly and the linked table is fully readable. The problem is I cant seem to reference it in a query at all...Access just freezes. Does anyone have any ideas? THX!! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
