RE: web server for XP home?
now, i'm having the same problem. Apache seems the best ption at the moment but, a few days ago i foung something like this on the microsoft site (you need professional to run a web server on XP, but please note to do not need a dedicated web server to develop OR HOST a website ) I just tried to find it again but couldn't, anyone know what they are on about? -Original Message- From: Ed Gordon [mailto:[EMAIL PROTECTED]] Sent: 26 March 2002 05:29 To: CF-Talk Subject: web server for XP home? I just bought a laptop and we are discussing development (like at the park/beach/pool ;-) ) but I read somewhere that Personal Web Server won't run under XP. I don't really want to upgrade it to XP Pro to use IIS, and I tried two free web servers - when I click on the CF Administrator, analog X web server software somehow goes into a file download dialogue of 127.0.0.1; Savant 3.0 just serves up a screen full of trash... Do you know of a fix to either of these problems, or a decent web server to try? Preferably one with a trial period, I would like to buy before I try... TIA Ed Gordon CF Developer FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ADVANCED - Expression results
Hi Folks I am getting the following error when trying to add a record to my Oracle 8 database through coldfusion 4.5, when I was using Coldfusion 4.0 it worked ok. Any ideas on what it could be or mean? Error Occurred While Processing Request Error Diagnostic Information Expression result cannot be converted to a string Expressions used inside tags like CFOUTPUT, CFQUERY, CFMAIL, etc. must evaluate to a value that can be converted to a string for output or dynamic text accumulation purposes. Complex objects, such as queries, arrays, and COM/DCOM objects, cannot be represented as strings. The error occurred while processing an element with a general identifier of (#url#), occupying document position (50:159) to (50:163). Date/Time: Tue Mar 26 09:05:09 2002 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ADVANCED - Expression results
CF uses that name url for the structure that holds all url variables, so it is trying to convert a structure to string. You'd have to reference it with #url.url# or even better try changing the name of the variable. -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: 26 March 2002 09:02 To: CF-Talk Subject: ADVANCED - Expression results Hi Folks I am getting the following error when trying to add a record to my Oracle 8 database through coldfusion 4.5, when I was using Coldfusion 4.0 it worked ok. Any ideas on what it could be or mean? Error Occurred While Processing Request Error Diagnostic Information Expression result cannot be converted to a string Expressions used inside tags like CFOUTPUT, CFQUERY, CFMAIL, etc. must evaluate to a value that can be converted to a string for output or dynamic text accumulation purposes. Complex objects, such as queries, arrays, and COM/DCOM objects, cannot be represented as strings. The error occurred while processing an element with a general identifier of (#url#), occupying document position (50:159) to (50:163). Date/Time: Tue Mar 26 09:05:09 2002 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
request.imageRoot
Greetings, I am using fusebox for one of our applications, and for all images calling them with #request.imageRoot#, which is a full virtual Address http://www.liveserver.com/images/ I'm wondering when a site is facing heavy traffic does this cause severe overhead with IIS and is there a more performance friendly approach to the whole affair, Respectfully, J .. .. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Time Issue
What version of ColdFusion are you running? There was a bug with the time in CFMAIL in 4.5.0. Deb -Original Message- [EMAIL PROTECTED] wrote: When I send an email through the mail server through POP account - the time is correct - when I send it via cfmail - it is wrong. Any other ideas? __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFHTTP not connection to Authorizenet !!!???!!
On 3/25/02, [EMAIL PROTECTED] penned: Anyone have any ideas why CFHTTP may not be connecting with Authorizenet using the CF Authorize tag? Here is the response message: Your charge was declined for the following reason: An error occurred when attempting to connect with the credit card processor. Sounds like a generic response put out from within the tag. You should probably open it and place at the bottom.. cfoutout#cfhttp.filecontent#/cfoutput Then you can see what is really being returned from authorize.net, if anything. When you find out, let us know and we can probably help more. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How to expire session variables?
On 3/25/02, [EMAIL PROTECTED] penned: Is there a good way to consistently make sessions expire within a 10 min period? sessiontimeout=#createtimespan(0,0,10,0)# goes in the cfapplication tag. createtimespan(Days,Hours,Minutes,Seconds) -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How to expire session variables?
As a general note, that will only make session variables expire if they are inactive for 10 minutes. It will not expire active session variables. If you really wanted to force them to expire after a 10 minute period you could store a Session Variable Creation variable in the session scope. Check it on each page request to see if you should wipe out the session structure. That compiled with the sessiontimeout method ( described below) is probably as close as you are going to come. At 06:51 AM 3/26/2002 -0500, you wrote: On 3/25/02, [EMAIL PROTECTED] penned: Is there a good way to consistently make sessions expire within a 10 min period? sessiontimeout=#createtimespan(0,0,10,0)# goes in the cfapplication tag. createtimespan(Days,Hours,Minutes,Seconds) -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How to expire session variables?
On 3/26/02, Jeffry Houser penned: As a general note, that will only make session variables expire if they are inactive for 10 minutes. I presumed that's what he wanted. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How to expire session variables?
At 07:33 AM 3/26/2002 -0500, you wrote: On 3/26/02, Jeffry Houser penned: As a general note, that will only make session variables expire if they are inactive for 10 minutes. I presumed that's what he wanted. But it wasn't what he asked for. ;) -- Jeffry Houser | mailto:[EMAIL PROTECTED] Need a Web Developer? Contact me! AIM: Reboog711 | Fax / Phone: 860-223-7946 -- My Books: http://www.instantcoldfusion.com My Band: http://www.farcryfly.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: web server for XP home?
You will need XP pro to run any MS web server. Apache works fine. HTH Clint -Original Message- From: Mark Smyth [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 2:16 AM To: CF-Talk Subject: RE: web server for XP home? now, i'm having the same problem. Apache seems the best ption at the moment but, a few days ago i foung something like this on the microsoft site (you need professional to run a web server on XP, but please note to do not need a dedicated web server to develop OR HOST a website ) I just tried to find it again but couldn't, anyone know what they are on about? -Original Message- From: Ed Gordon [mailto:[EMAIL PROTECTED]] Sent: 26 March 2002 05:29 To: CF-Talk Subject: web server for XP home? I just bought a laptop and we are discussing development (like at the park/beach/pool ;-) ) but I read somewhere that Personal Web Server won't run under XP. I don't really want to upgrade it to XP Pro to use IIS, and I tried two free web servers - when I click on the CF Administrator, analog X web server software somehow goes into a file download dialogue of 127.0.0.1; Savant 3.0 just serves up a screen full of trash... Do you know of a fix to either of these problems, or a decent web server to try? Preferably one with a trial period, I would like to buy before I try... TIA Ed Gordon CF Developer FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Looping over a query with CFSCRIPT
More like:
cfscript
for (i=1; i LTE selProd.recordcount; i=i+1) {
writeOutput(selProd.PR_NAME[i] br);
}
/cfscript
Sharon
- Original Message -
From: VAN VLIET, SCOTT E (SBCSI) [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, March 25, 2002 6:47 PM
Subject: Looping over a query with CFSCRIPT
Is this possible? If so, sample code would be appreciated.
I tried the following, and got an access error (i understand that you
can't
modify currentrow, etc, but one can wish, right ^_^):
cfscript
while (selProd.CurrentRow LTE selProd.RecordCount)
{
writeOutput(selProd.PR_NAME);
writeOutput(br);
selProd.CurrentRow = selProd.CurrentRow + 1;
}
/cfscript
Thanks in advance!
--
SCOTT VAN VLIET
SENIOR ANALYST
SBC SERVICES, INC
Tel: 858.886.3878
Fax: 858.653.6763
Email: [EMAIL PROTECTED]
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: web server for XP home?
This is kind of a side thing, but why don't you want to upgrade to XP Pro? I know that when I made the leap from Win98 to Win2k Pro, I was _extremely_ happy. I didn't have to reboot multiple times per day - and in general, everything worked _much_ better. Maybe XP Home isn't as bad as Win98, but if you are going to be doing developer work, I would really recommend XP Pro instead. Just my 2 cents. -ray -Original Message- From: Ed Gordon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 12:29 AM To: CF-Talk Subject: web server for XP home? I just bought a laptop and we are discussing development (like at the park/beach/pool ;-) ) but I read somewhere that Personal Web Server won't run under XP. I don't really want to upgrade it to XP Pro to use IIS, and I tried two free web servers - when I click on the CF Administrator, analog X web server software somehow goes into a file download dialogue of 127.0.0.1; Savant 3.0 just serves up a screen full of trash... Do you know of a fix to either of these problems, or a decent web server to try? Preferably one with a trial period, I would like to buy before I try... TIA Ed Gordon CF Developer FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Which version of Java should be used
Which is better to have on the server, JRE or SDK. The SDK comes with a JVM in a directory called server so I am thinking SDK, but can anyone tell me for sure? Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: web server for XP home?
Caveat: I have 2 WinXP Pro, 1 XP Home, 1 Win2K, and one triple-boot Win2K/Win98SE/Redmond Linux systems at home. You realize that WinXP Home and WinXP Pro are really the same OS, with some functionality removed from the home version, right? http://www.microsoft.com/windowsxp/whichxp.asp Win2K and Win98 really were 2 completely different OS'es, with Win98 built on top of DOS and Win2K using the much more robust NT kernel. I do find it unforgiveable that Microsoft didn't include IIS in XP Home, it is very shortsighted on their part. Pete - Original Message - From: Raymond Camden [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 8:41 AM Subject: RE: web server for XP home? This is kind of a side thing, but why don't you want to upgrade to XP Pro? I know that when I made the leap from Win98 to Win2k Pro, I was _extremely_ happy. I didn't have to reboot multiple times per day - and in general, everything worked _much_ better. Maybe XP Home isn't as bad as Win98, but if you are going to be doing developer work, I would really recommend XP Pro instead. Just my 2 cents. -ray -Original Message- From: Ed Gordon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 12:29 AM To: CF-Talk Subject: web server for XP home? I just bought a laptop and we are discussing development (like at the park/beach/pool ;-) ) but I read somewhere that Personal Web Server won't run under XP. I don't really want to upgrade it to XP Pro to use IIS, and I tried two free web servers - when I click on the CF Administrator, analog X web server software somehow goes into a file download dialogue of 127.0.0.1; Savant 3.0 just serves up a screen full of trash... Do you know of a fix to either of these problems, or a decent web server to try? Preferably one with a trial period, I would like to buy before I try... TIA Ed Gordon CF Developer FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: web server for XP home?
I have to concur w/ the statement about moving from 98 to 2k Pro (which I did two weeks ago). The reason I chose 2K pro was because I had heard so many bad things about XP. At 08:41 AM 3/26/2002 -0500, you wrote: This is kind of a side thing, but why don't you want to upgrade to XP Pro? I know that when I made the leap from Win98 to Win2k Pro, I was _extremely_ happy. I didn't have to reboot multiple times per day - and in general, everything worked _much_ better. Maybe XP Home isn't as bad as Win98, but if you are going to be doing developer work, I would really recommend XP Pro instead. Just my 2 cents. -ray -Original Message- From: Ed Gordon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 12:29 AM To: CF-Talk Subject: web server for XP home? I just bought a laptop and we are discussing development (like at the park/beach/pool ;-) ) but I read somewhere that Personal Web Server won't run under XP. I don't really want to upgrade it to XP Pro to use IIS, and I tried two free web servers - when I click on the CF Administrator, analog X web server software somehow goes into a file download dialogue of 127.0.0.1; Savant 3.0 just serves up a screen full of trash... Do you know of a fix to either of these problems, or a decent web server to try? Preferably one with a trial period, I would like to buy before I try... TIA Ed Gordon CF Developer FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: web server for XP home?
At 07:16 AM 03/26/2002 -0600, Clint Tredway wrote: You will need XP pro to run any MS web server. Apache works fine. Anyone have a link to the steps to set up Apache for CF? I tried it on my system and could never get it to work (Win98) so I went with the Personal Server. T __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
1019 compile error
anyone out there a wap expert? well if you are, i need your help. i am trying to get my website wap enabled and i can't seem to get past this one part. i need to know how you can pass variables to another page in the url within wml. everytime i try to do this i get a 1019 error. i want to pass the variables to the same page so that a can display search results. here is the run dows results.cfm displays 5 search results link back to this page with the search phrase in the url a href=results.cfm?search=web%20hostingamp;next=10MORE/a is this the right way to do this? Anthony Petruzzi Webmaster 954-321-4703 http://www.sheriff.org __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Which version of Java should be used
The JRE is small and is all you need to run applications. The SDK includes a compiler, the JRE, docs, examples and much more. It is intended for those who want to develop Java applications. Greg Alton CFDev - Original Message - From: Robert Everland [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 8:40 AM Subject: Which version of Java should be used Which is better to have on the server, JRE or SDK. The SDK comes with a JVM in a directory called server so I am thinking SDK, but can anyone tell me for sure? Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Which version of Java should be used
So then what is the difference between the virtual machines. There are 2 directories, one called client and one called server. The regular JRE doesn't come with 2 JVM, only one for the client. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Greg Alton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 9:40 AM To: CF-Talk Subject: Re: Which version of Java should be used The JRE is small and is all you need to run applications. The SDK includes a compiler, the JRE, docs, examples and much more. It is intended for those who want to develop Java applications. Greg Alton CFDev - Original Message - From: Robert Everland [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 8:40 AM Subject: Which version of Java should be used Which is better to have on the server, JRE or SDK. The SDK comes with a JVM in a directory called server so I am thinking SDK, but can anyone tell me for sure? Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: web server for XP home?
I am running XP and have been since December and I could not be happier. I am running the Home edition but will be upgrading to the Pro before to long. XP is faster and more stable then Win98 or Win2k(in my opinion) Clint -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 8:07 AM To: CF-Talk Subject: RE: web server for XP home? I have to concur w/ the statement about moving from 98 to 2k Pro (which I did two weeks ago). The reason I chose 2K pro was because I had heard so many bad things about XP. At 08:41 AM 3/26/2002 -0500, you wrote: This is kind of a side thing, but why don't you want to upgrade to XP Pro? I know that when I made the leap from Win98 to Win2k Pro, I was _extremely_ happy. I didn't have to reboot multiple times per day - and in general, everything worked _much_ better. Maybe XP Home isn't as bad as Win98, but if you are going to be doing developer work, I would really recommend XP Pro instead. Just my 2 cents. -ray -Original Message- From: Ed Gordon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 12:29 AM To: CF-Talk Subject: web server for XP home? I just bought a laptop and we are discussing development (like at the park/beach/pool ;-) ) but I read somewhere that Personal Web Server won't run under XP. I don't really want to upgrade it to XP Pro to use IIS, and I tried two free web servers - when I click on the CF Administrator, analog X web server software somehow goes into a file download dialogue of 127.0.0.1; Savant 3.0 just serves up a screen full of trash... Do you know of a fix to either of these problems, or a decent web server to try? Preferably one with a trial period, I would like to buy before I try... TIA Ed Gordon CF Developer FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFFTP
My experience with cfftp has been that CF will handle as many simultaneous connections as your physical server and bandwidth will allow. One solution if you are concerned about load or bandwidth is to create a queueing system and to only allow a limited number of simultaneous connections. -Original Message- From: Jim Curran [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 7:12 PM To: CF-Talk Subject: CFFTP Hi all, Anyone know the limitations / performance issues w/ cfftp? I building an application that will have many simultaneous users accessing templates that cfftp files to many different locations. Questions: 1) How many simultaneous / active connections can the CF Server handle? 2) Is there a better way to do this? __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
session variable renewal
Hello. Do session variables get renewed when you set them? In other words, let's say that my application has a 20-minute session variable timeout. At 10:00, a user hits a page that sets Session.LoggedIn=true. At 10:15, the user hits that page again. Does Session.LoggedIn expire at 10:20 or 10:35? Thanks, Matthieu __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: session variable renewal
10:35 Activity starts things over. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder - Original Message - From: Cornillon, Matthieu [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 8:58 AM Subject: session variable renewal Hello. Do session variables get renewed when you set them? In other words, let's say that my application has a 20-minute session variable timeout. At 10:00, a user hits a page that sets Session.LoggedIn=true. At 10:15, the user hits that page again. Does Session.LoggedIn expire at 10:20 or 10:35? Thanks, Matthieu __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFFILE action = upload
has anyone experimented with the size of files that can be uploaded using cffile? Currently working on a document managment application and some fairly large files need to be uploaded and I was curious about the limitations of cffile. From a 'user experience' standpoint, i know i can use cfflush to present the user with a file uploading type graphic or text, so that aspect can be taken care of for the large load time. Thanks for any and all help, -chris.alvarado [application.developer] 4 Guys Interactive, Inc. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: session variable renewal
10:35 -chris.alvarado [application.developer] 4 Guys Interactive, Inc. -Original Message- From: Cornillon, Matthieu [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 8:59 AM To: CF-Talk Subject: session variable renewal Hello. Do session variables get renewed when you set them? In other words, let's say that my application has a 20-minute session variable timeout. At 10:00, a user hits a page that sets Session.LoggedIn=true. At 10:15, the user hits that page again. Does Session.LoggedIn expire at 10:20 or 10:35? Thanks, Matthieu __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: session variable renewal
Matthieu: It expires after inactivity of 20 minutes. So at 19:59 a link is clicked, the clock startes over. Joel - Original Message - From: Cornillon, Matthieu [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 9:58 AM Subject: session variable renewal Hello. Do session variables get renewed when you set them? In other words, let's say that my application has a 20-minute session variable timeout. At 10:00, a user hits a page that sets Session.LoggedIn=true. At 10:15, the user hits that page again. Does Session.LoggedIn expire at 10:20 or 10:35? Thanks, Matthieu __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: web server for XP home?
XP is a much better and more stable system them Win2k IMHO. Though my belief is you will always hear horror stories about everything. XP pro is nice iis is pretty easy to use with it not terrible Bill Wheatley Director of Development AEPS INC www.aeps.com Macromedia ColdFusion Alliance Consulting Partner Macromedia ColdFusion 5.0 Certified Developer 954-472-6684 X303 ICQ: 417645 - Original Message - From: Clint Tredway [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 9:34 AM Subject: RE: web server for XP home? I am running XP and have been since December and I could not be happier. I am running the Home edition but will be upgrading to the Pro before to long. XP is faster and more stable then Win98 or Win2k(in my opinion) Clint -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 8:07 AM To: CF-Talk Subject: RE: web server for XP home? I have to concur w/ the statement about moving from 98 to 2k Pro (which I did two weeks ago). The reason I chose 2K pro was because I had heard so many bad things about XP. At 08:41 AM 3/26/2002 -0500, you wrote: This is kind of a side thing, but why don't you want to upgrade to XP Pro? I know that when I made the leap from Win98 to Win2k Pro, I was _extremely_ happy. I didn't have to reboot multiple times per day - and in general, everything worked _much_ better. Maybe XP Home isn't as bad as Win98, but if you are going to be doing developer work, I would really recommend XP Pro instead. Just my 2 cents. -ray -Original Message- From: Ed Gordon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 12:29 AM To: CF-Talk Subject: web server for XP home? I just bought a laptop and we are discussing development (like at the park/beach/pool ;-) ) but I read somewhere that Personal Web Server won't run under XP. I don't really want to upgrade it to XP Pro to use IIS, and I tried two free web servers - when I click on the CF Administrator, analog X web server software somehow goes into a file download dialogue of 127.0.0.1; Savant 3.0 just serves up a screen full of trash... Do you know of a fix to either of these problems, or a decent web server to try? Preferably one with a trial period, I would like to buy before I try... TIA Ed Gordon CF Developer FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: session variable renewal
So you wouldn't need the Session.LoggedIn=true statement to renew the session variable? Activity alone renews it? - Original Message - From: Paul Giesenhagen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 9:02 AM Subject: Re: session variable renewal 10:35 Activity starts things over. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder - Original Message - From: Cornillon, Matthieu [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 8:58 AM Subject: session variable renewal Hello. Do session variables get renewed when you set them? In other words, let's say that my application has a 20-minute session variable timeout. At 10:00, a user hits a page that sets Session.LoggedIn=true. At 10:15, the user hits that page again. Does Session.LoggedIn expire at 10:20 or 10:35? Thanks, Matthieu __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: kill session aka Logout page
This is what we use to delete ALL session and client vars, and cookies. Chris Norloff !--- delete the session (all vars, including CFID CFTOKEN) --- cflock timeout=#variables.lock_timeout# throwontimeout=Yes scope=session type=EXCLUSIVE cfset temp = #StructClear(session)# /cflock !--- delete all client vars --- cfset variables.client_var_list = #GetClientVariablesList()# cfloop index=list_element list=#variables.client_var_list# delimiters=, cfset temp = DeleteClientVariable(#list_element#) /cfloop !--- delete cookies --- cfcookie name=CFID value=empty expires=NOW cfcookie name=CFTOKEN value=empty expires=NOW -- Original Message -- from: YC Nyon [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Mon, 25 Mar 2002 22:09:36 +0800 hi, anyone mind to share the code to do a logout page where the session is terminated. thanks Nyon __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Which version of Java should be used
from what i hear the one from ibm is the best z __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFFILE action = upload
has anyone experimented with the size of files that can be uploaded using cffile? Currently working on a document managment application and some fairly large files need to be uploaded and I was curious about the limitations of cffile. From a 'user experience' standpoint, i know i can use cfflush to present the user with a file uploading type graphic or text, so that aspect can be taken care of for the large load time. Thanks for any and all help, The file size is limited only by the amount of RAM your server has. Remember that CFFILE works by first uploading or reading the file into the server's RAM and then performing the appropriate actions. Now you obviously have to keep in mind that larger files are a bit more intensive processing-wise on the server, but that doesn't effect the actual file size limitation...just your server's memory. Regards, Dave. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: web server for XP home?
More stable - and few patches and security flaws (by a factor of 10) than win2k at this point in win2k's release. It never crashes on us - the only thing I hated about it wasthe new desktop appearance. The first thing I did was set it to classic windows mode to retain my sense of continuity g. -mk -Original Message- From: William Wheatley [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 9:10 AM To: CF-Talk Subject: Re: web server for XP home? XP is a much better and more stable system them Win2k IMHO. Though my belief is you will always hear horror stories about everything. XP pro is nice iis is pretty easy to use with it not terrible Bill Wheatley Director of Development AEPS INC www.aeps.com Macromedia ColdFusion Alliance Consulting Partner Macromedia ColdFusion 5.0 Certified Developer 954-472-6684 X303 ICQ: 417645 - Original Message - From: Clint Tredway [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 9:34 AM Subject: RE: web server for XP home? I am running XP and have been since December and I could not be happier. I am running the Home edition but will be upgrading to the Pro before to long. XP is faster and more stable then Win98 or Win2k(in my opinion) Clint -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 8:07 AM To: CF-Talk Subject: RE: web server for XP home? I have to concur w/ the statement about moving from 98 to 2k Pro (which I did two weeks ago). The reason I chose 2K pro was because I had heard so many bad things about XP. At 08:41 AM 3/26/2002 -0500, you wrote: This is kind of a side thing, but why don't you want to upgrade to XP Pro? I know that when I made the leap from Win98 to Win2k Pro, I was _extremely_ happy. I didn't have to reboot multiple times per day - and in general, everything worked _much_ better. Maybe XP Home isn't as bad as Win98, but if you are going to be doing developer work, I would really recommend XP Pro instead. Just my 2 cents. -ray -Original Message- From: Ed Gordon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 12:29 AM To: CF-Talk Subject: web server for XP home? I just bought a laptop and we are discussing development (like at the park/beach/pool ;-) ) but I read somewhere that Personal Web Server won't run under XP. I don't really want to upgrade it to XP Pro to use IIS, and I tried two free web servers - when I click on the CF Administrator, analog X web server software somehow goes into a file download dialogue of 127.0.0.1; Savant 3.0 just serves up a screen full of trash... Do you know of a fix to either of these problems, or a decent web server to try? Preferably one with a trial period, I would like to buy before I try... TIA Ed Gordon CF Developer FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: kill session aka Logout page
Do you put this into the logout page (logout.cfm) or into the application.cfm? At 10:10 AM 3/26/2002 -0500, you wrote: This is what we use to delete ALL session and client vars, and cookies. Chris Norloff !--- delete the session (all vars, including CFID CFTOKEN) --- cflock timeout=#variables.lock_timeout# throwontimeout=Yes scope=session type=EXCLUSIVE cfset temp = #StructClear(session)# /cflock !--- delete all client vars --- cfset variables.client_var_list = #GetClientVariablesList()# cfloop index=list_element list=#variables.client_var_list# delimiters=, cfset temp = DeleteClientVariable(#list_element#) /cfloop !--- delete cookies --- cfcookie name=CFID value=empty expires=NOW cfcookie name=CFTOKEN value=empty expires=NOW -- Original Message -- from: YC Nyon [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Mon, 25 Mar 2002 22:09:36 +0800 hi, anyone mind to share the code to do a logout page where the session is terminated. thanks Nyon __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: web server for XP home?
I hated the new look as well - until I tried it on my 18inch flatscreen. I'm still getting used to 1280x resolution, and the 'fat' buttons on XP actually look nice at that res. On my laptop, at 1080x (or whatever), they do look a bit Plaskool-ish. -rc -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 10:23 AM To: CF-Talk Subject: RE: web server for XP home? More stable - and few patches and security flaws (by a factor of 10) than win2k at this point in win2k's release. It never crashes on us - the only thing I hated about it wasthe new desktop appearance. The first thing I did was set it to classic windows mode to retain my sense of continuity g. -mk __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: session variable renewal
Exactly. You usually just check for it's existence. If it doesn't exist, set it (which is usually false, since it doesn't exist). It'll stay until it either 1) it times out (after 20 minutes), or 2) is deleted by you intentionally. HTH. Joel - Original Message - From: Ricq Pattay [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 10:10 AM Subject: Re: session variable renewal So you wouldn't need the Session.LoggedIn=true statement to renew the session variable? Activity alone renews it? - Original Message - From: Paul Giesenhagen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 9:02 AM Subject: Re: session variable renewal 10:35 Activity starts things over. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder - Original Message - From: Cornillon, Matthieu [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 8:58 AM Subject: session variable renewal Hello. Do session variables get renewed when you set them? In other words, let's say that my application has a 20-minute session variable timeout. At 10:00, a user hits a page that sets Session.LoggedIn=true. At 10:15, the user hits that page again. Does Session.LoggedIn expire at 10:20 or 10:35? Thanks, Matthieu __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: differentiating images
take the checksum of the 2 images if the checksum is the same then the images are the same On Tue, 26 Mar 2002, Abraham Lincoln wrote: File size is same..any thing related to pixls or colors? - Original Message - From: jon [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, March 23, 2002 9:23 PM Subject: RE: differentiating images File size, maybe? -- jon - jon roig senior manager, online production epilepsy foundation tel: 215.850.0710 site: http://www.epilepsyfoundation.org email: [EMAIL PROTECTED] -Original Message- From: Abraham Lincoln [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 23, 2002 6:19 AM To: CF-Talk Subject: differentiating images can any body guide me how to differentiate between two images which have same name __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Another cfexecute question
Is there any way, other than reading an output file, to get a return code from a command executed with cfexecute? Shawn McKee Manager, Web Development NewsStand, Inc. 8620 Burnet Rd., Suite 100 Austin, TX 78757 USA 512-334-5100 Read newspapers and magazines from around the world in a whole new way. NewsStand delivers them to your PC without paper and without delay! Try: http://www.newsstand.com?NSEMC=EMNSI01 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: web server for XP home?
yeah - romper roomish (I see raymond and charlie and Joel and tara... ) -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 9:22 AM To: CF-Talk Subject: RE: web server for XP home? I hated the new look as well - until I tried it on my 18inch flatscreen. I'm still getting used to 1280x resolution, and the 'fat' buttons on XP actually look nice at that res. On my laptop, at 1080x (or whatever), they do look a bit Plaskool-ish. -rc -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 10:23 AM To: CF-Talk Subject: RE: web server for XP home? More stable - and few patches and security flaws (by a factor of 10) than win2k at this point in win2k's release. It never crashes on us - the only thing I hated about it wasthe new desktop appearance. The first thing I did was set it to classic windows mode to retain my sense of continuity g. -mk __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
MS SQL logon help!!! PLEASE!!!!!!!
Sorry for thowing in this MS SQL questions but its an emergency!! My Sys Admin rebooted the server this morning and now I cannot get acces to MS SQL. When I try to start the services, it gives me a 1069 logon failure errordoes anyone know how I can fix this..I am assuming I need to reset a password some where, just dont know where. Thank you so much! __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Which version of Java should be used
The SDK includes Java Plug-in and Swing classes to save you from downloading them. The JREs (the actual runtime environment) is the same and it is all you need to run applications and applets. If Java Plug-in or Swing is called for and the browser supports it (IE), it is automatically downloaded. It can't hurt to install the SDK. It just takes more room. In the end, the only thing that CF cares about is the path to jvm.dll or jvm.so for Unix/Linux. The rest is for the developer. Greg Alton CFDev - Original Message - From: Robert Everland [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 9:25 AM Subject: RE: Which version of Java should be used So then what is the difference between the virtual machines. There are 2 directories, one called client and one called server. The regular JRE doesn't come with 2 JVM, only one for the client. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Greg Alton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 9:40 AM To: CF-Talk Subject: Re: Which version of Java should be used The JRE is small and is all you need to run applications. The SDK includes a compiler, the JRE, docs, examples and much more. It is intended for those who want to develop Java applications. Greg Alton CFDev - Original Message - From: Robert Everland [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 8:40 AM Subject: Which version of Java should be used Which is better to have on the server, JRE or SDK. The SDK comes with a JVM in a directory called server so I am thinking SDK, but can anyone tell me for sure? Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MS SQL logon help!!! PLEASE!!!!!!!
Amanda - do you mean MS SQL is on the server in question? You could try the following: Log in as local adminsitrator (or domain admin) and try starting the service. If it does not start from the services control panel, try resetting the username and password it's using to login (click on login and choose login as). You will need to do this for mssql and sqlserveragent (if you have backup and other jobs scheduled). If that doesn't work you can try the command line options - which starts SQL server in single user mode for emergencies... it's well documented in the server documentation. If the problem is a corrup MASTER database, you will need to follow the instructions for restoring a corrupt master database from backup (not trivial). -Original Message- From: Amanda Stern [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 9:45 AM To: CF-Talk Subject: MS SQL logon help!!! PLEASE!!! Sorry for thowing in this MS SQL questions but its an emergency!! My Sys Admin rebooted the server this morning and now I cannot get acces to MS SQL. When I try to start the services, it gives me a 1069 logon failure errordoes anyone know how I can fix this..I am assuming I need to reset a password some where, just dont know where. Thank you so much! __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Developers Tool. Comment Engine.
Hi all, I've created a new, simple cf tag that allows customers and developers to exchange and keep a record of comments. It provides a comment form for entering new comments and a log of previous comments at the bottom of any web page. It is easy to setup, only requiring a single cfinclude statement. I use the OnRequestEnd.cfm file to do this. It works with both fusebox and non-fusebox applications. It uses a wddx file packet, so it does not require any database setup. Please let me know what you think. Feel free to download it from the developers' exchange at: http://devex.macromedia.com/developer/gallery/info.cfm?ID=3C8D8DE0-40A6-11D 6-83FE00508B94F85Amethod=Download PS. Please remember that it is freeware, with no warranties of any kind. Use at your own risk. Dave Schmidt __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MS SQL logon help!!! PLEASE!!!!!!!
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q282254 Anthony Petruzzi Webmaster 954-321-4703 http://www.sheriff.org -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 10:57 AM To: CF-Talk Subject: RE: MS SQL logon help!!! PLEASE!!! Amanda - do you mean MS SQL is on the server in question? You could try the following: Log in as local adminsitrator (or domain admin) and try starting the service. If it does not start from the services control panel, try resetting the username and password it's using to login (click on login and choose login as). You will need to do this for mssql and sqlserveragent (if you have backup and other jobs scheduled). If that doesn't work you can try the command line options - which starts SQL server in single user mode for emergencies... it's well documented in the server documentation. If the problem is a corrup MASTER database, you will need to follow the instructions for restoring a corrupt master database from backup (not trivial). -Original Message- From: Amanda Stern [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 9:45 AM To: CF-Talk Subject: MS SQL logon help!!! PLEASE!!! Sorry for thowing in this MS SQL questions but its an emergency!! My Sys Admin rebooted the server this morning and now I cannot get acces to MS SQL. When I try to start the services, it gives me a 1069 logon failure errordoes anyone know how I can fix this..I am assuming I need to reset a password some where, just dont know where. Thank you so much! __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Developers Tool. Comment Engine.
Sorry all, Please copy the whole link into the browser. Doggone hit miss outlook. Dave I've created a new, simple cf tag that allows customers and developers to exchange and keep a record of comments. It provides a comment form for entering new comments and a log of previous comments at the bottom of any web page. It is easy to setup, only requiring a single cfinclude statement. I use the OnRequestEnd.cfm file to do this. It works with both fusebox and non-fusebox applications. It uses a wddx file packet, so it does not require any database setup. Please let me know what you think. Feel free to download it from the developers' exchange at: http://devex.macromedia.com/developer/gallery/info.cfm?ID=3C8D8DE0-40A6-11D 6-83FE00508B94F85Amethod=Download PS. Please remember that it is freeware, with no warranties of any kind. Use at your own risk. Dave Schmidt __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How to expire session variables?
set the sessio timeout to 10 minutes On Mon, 25 Mar 2002 [EMAIL PROTECTED] wrote: Is there a good way to consistently make sessions expire within a 10 min period? __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Which version of Java should be used
what are you trying to do with it? to develop you need the jdk On Tue, 26 Mar 2002, Robert Everland wrote: Which is better to have on the server, JRE or SDK. The SDK comes with a JVM in a directory called server so I am thinking SDK, but can anyone tell me for sure? Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: web server for XP home?
This should help. http://www.cfdev.com/apache/ Greg Alton CFDev - Original Message - From: Thane Sherrington [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 9:19 AM Subject: RE: web server for XP home? At 07:16 AM 03/26/2002 -0600, Clint Tredway wrote: You will need XP pro to run any MS web server. Apache works fine. Anyone have a link to the steps to set up Apache for CF? I tried it on my system and could never get it to work (Win98) so I went with the Personal Server. T __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Join up datasources
Is it possible to have a query where you don't specify a datasource and then inside of the query join up more than one datasource. Something like this cfquery Select DSN.Database.Table.Row, differentdsn.database.table.row From dsn.database.table, differentdsn.database.table /cfquery Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SSL Certificates - provider recommendations?
I need to pick up an SSL certificate, any recommendations or pitfalls I should think about it? Eric _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfparam vs. cfif/isDefined/cfset
Here is my application.cfm file: cfapplication name=appname applicationtimeout=#CreateTimeSpan(2, 0, 0, 0)# cfparam name=application.appnameroot default=/appname cfparam name=application.includesDir default=/appname/includes cfparam name=application.imagesDir default=/appname/images cfparam name=application.menusDir default=/appname/menus cfparam name=application.templatesDir default=/appname/templates cfparam name=application.smapDir default=/appname/smap Should I be locking these cfparam tags? Should I wrap them all in one lock or should I lock each one individually? What is the difference between using cfparam tags as I have above and using cfif with isDefined and cfset to accomplish the same thing? Is one method a better practice than the other? Thanks! George [EMAIL PROTECTED] __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfparam vs. cfif/isDefined/cfset
Here is my application.cfm file: cfapplication name=appname applicationtimeout=#CreateTimeSpan(2, 0, 0, 0)# cfparam name=application.appnameroot default=/appname cfparam name=application.includesDir default=/appname/includes cfparam name=application.imagesDir default=/appname/images cfparam name=application.menusDir default=/appname/menus cfparam name=application.templatesDir default=/appname/templates cfparam name=application.smapDir default=/appname/smap Should I be locking these cfparam tags? Yes. Make sure you set TYPE=EXCLUSIVE, since you may be setting the values. Should I wrap them all in one lock or should I lock each one individually? I'd wrap them all in one lock. What is the difference between using cfparam tags as I have above and using cfif with isDefined and cfset to accomplish the same thing? There's no functional difference between the two. Is one method a better practice than the other? That's a good question. I use CFPARAM for this, myself, but I suspect that it performs more slowly in certain situations. In any case, though, the difference will be insignificant, and one line of code is better than three, all other things being equal. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfparam vs. cfif/isDefined/cfset
Definately wrap a lock around those, and I would only run that block if 1 of the vars inside isn't defined (if 1 isn't then they all aren'tlike when CF Server is restarted). As far as CFPARAM goes You are correct in using it herewhy write 3 lines of code when you can write 1 ;-) HTH Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Earl, George [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 8:21 AM Subject: cfparam vs. cfif/isDefined/cfset Here is my application.cfm file: cfapplication name=appname applicationtimeout=#CreateTimeSpan(2, 0, 0, 0)# cfparam name=application.appnameroot default=/appname cfparam name=application.includesDir default=/appname/includes cfparam name=application.imagesDir default=/appname/images cfparam name=application.menusDir default=/appname/menus cfparam name=application.templatesDir default=/appname/templates cfparam name=application.smapDir default=/appname/smap Should I be locking these cfparam tags? Should I wrap them all in one lock or should I lock each one individually? What is the difference between using cfparam tags as I have above and using cfif with isDefined and cfset to accomplish the same thing? Is one method a better practice than the other? Thanks! George [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SSL Certificates - provider recommendations?
I need to pick up an SSL certificate, any recommendations or pitfalls I should think about it? I've always had good service from Thawte, and they're still cheaper than Verisign, despite being owned by Verisign. Be very careful to save all of the key generation information that you create, including the actual key request. If you're installing the key on IIS, create a key backup file, and store that offsite. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SSL Certificates - provider recommendations?
I have heard alot of good things about equifax and their secure certificate. http://www.equifax.com/DigitalCertificates Good Luck Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder - Original Message - From: Eric Dawson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 10:22 AM Subject: SSL Certificates - provider recommendations? I need to pick up an SSL certificate, any recommendations or pitfalls I should think about it? Eric _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: web server for XP home?
XP is a much better and more stable system them Win2k IMHO. Gee, I don't know how much more stable it can be. I can count my Win2K crashes on one hand, and I've been using it since it was in public beta. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfparam vs. cfif/isDefined/cfset
1. You should lock the entire group with a CFLOCK and a scope of application. 2. An IsDefined() with a set is actually slightly faster than a CFAPPLICATION. There's even a UDF that does just this and its still faster even with the small UDF overhead. Note that this is limited to the isdefined() then default. When you start doing the other things that a CFPARAM is useful for then the balance changes. At 11:21 AM 3/26/02, you wrote: Here is my application.cfm file: cfapplication name=appname applicationtimeout=#CreateTimeSpan(2, 0, 0, 0)# cfparam name=application.appnameroot default=/appname cfparam name=application.includesDir default=/appname/includes cfparam name=application.imagesDir default=/appname/images cfparam name=application.menusDir default=/appname/menus cfparam name=application.templatesDir default=/appname/templates cfparam name=application.smapDir default=/appname/smap Should I be locking these cfparam tags? Should I wrap them all in one lock or should I lock each one individually? What is the difference between using cfparam tags as I have above and using cfif with isDefined and cfset to accomplish the same thing? Is one method a better practice than the other? Thanks! George [EMAIL PROTECTED] __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: web server for XP home?
I do find it unforgiveable that Microsoft didn't include IIS in XP Home, it is very shortsighted on their part. I feel exactly the opposite. I think it would be unforgivable if Microsoft put a web server in a home OS. If you want to run a web server, you can always get one, but the vast majority of home users - and end-users in general - neither need to run a web server nor want to. Nor would they understand the potential security implications of doing so. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SSL Certificates - provider recommendations?
They are http://www.geotrust.com now. I've installed about 150 of them over the last year or so. Never had a problem at all. Dan Phillips CFXHosting.com -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 11:32 AM To: CF-Talk Subject: Re: SSL Certificates - provider recommendations? I have heard alot of good things about equifax and their secure certificate. http://www.equifax.com/DigitalCertificates Good Luck Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder - Original Message - From: Eric Dawson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 10:22 AM Subject: SSL Certificates - provider recommendations? I need to pick up an SSL certificate, any recommendations or pitfalls I should think about it? Eric _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SSL Certificates - provider recommendations?
Thawte.com certificates are much cheaper than verisign ones... and they have a partners/resellers program set up so that your second SSL cert will be cheaper. The nice Aussie sounding fellow who hooked me up: [EMAIL PROTECTED] I need to pick up an SSL certificate, any recommendations or pitfalls I should think about it? Eric _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: web server for XP home?
http://www.apache.org/ I use it on my servers and on my laptop development workstation ;) I just bought a laptop and we are discussing development (like at the park/beach/pool ;-) ) but I read somewhere that Personal Web Server won't run under XP. I don't really want to upgrade it to XP Pro to use IIS, and I tried two free web servers - when I click on the CF Administrator, analog X web server software somehow goes into a file download dialogue of 127.0.0.1; Savant 3.0 just serves up a screen full of trash... Do you know of a fix to either of these problems, or a decent web server to try? Preferably one with a trial period, I would like to buy before I try... TIA Ed Gordon CF Developer FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.linklabexchange.com _Miata Link ECU Data Exchange __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Which version of Java should be used
Which is better to have on the server, JRE or SDK. The SDK comes with a JVM in a directory called server so I am thinking SDK, but can anyone tell me for sure? The JRE is all you need, unless you're actually writing Java apps from the server console. I'd recommend installing that, if for no other reason than from a security standpoint, you want to have as little on the server as possible, and this especially applies to development tools. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: web server for XP home?
Well then why not just not install it. I see what you're saying about security, but if they are a home user and they don't need it, they probably wouldn't even know how to install it. It sucks that when I want a new computer now, I will have get professional and pay $100 just to get IIS. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 11:42 AM To: CF-Talk Subject: RE: web server for XP home? I do find it unforgiveable that Microsoft didn't include IIS in XP Home, it is very shortsighted on their part. I feel exactly the opposite. I think it would be unforgivable if Microsoft put a web server in a home OS. If you want to run a web server, you can always get one, but the vast majority of home users - and end-users in general - neither need to run a web server nor want to. Nor would they understand the potential security implications of doing so. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SOT: SQL Server on XP Pro
Hi All, Has anyone here successfully set up SQLServer 2K on WinXP Pro yet? If so what SP? version? Thanks, Duane __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: web server for XP home?
You can also use Sambar if memory serves. It's basically Apache with a web-based interface and some other features. I'm running the free version at home. http://www.sambar.com Hatton Greg Alton wrote: This should help. http://www.cfdev.com/apache/ Greg Alton CFDev - Original Message - From: Thane Sherrington [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 9:19 AM Subject: RE: web server for XP home? At 07:16 AM 03/26/2002 -0600, Clint Tredway wrote: You will need XP pro to run any MS web server. Apache works fine. Anyone have a link to the steps to set up Apache for CF? I tried it on my system and could never get it to work (Win98) so I went with the Personal Server. T __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Server on XP Pro
You'll need SQL Server Developer or MSDE. The full versions of SQL server will not install on XP Pro. Jeff Garza Lead Developer/Webmaster Spectrum Astro, Inc. [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 9:44 AM To: CF-Talk Subject: SOT: SQL Server on XP Pro Hi All, Has anyone here successfully set up SQLServer 2K on WinXP Pro yet? If so what SP? version? Thanks, Duane __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: web server for XP home?
Well, it certainly doesn't need to install it by default, IIS/PWS is in Win98 (and NT4, and Win2K, and WinXP Pro, for that matter) and you have to explicitly install it...but it's there at least. With no IIS download available anymore, XP Home users who want to do web development have no other real choice than to use someone else's web server, and if they want to do ASP development, they are pretty much screwed. Again, I just fail to see the logic, since MS is so good at making themselves as an all in one package. Pete - Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 11:42 AM Subject: RE: web server for XP home? I do find it unforgiveable that Microsoft didn't include IIS in XP Home, it is very shortsighted on their part. I feel exactly the opposite. I think it would be unforgivable if Microsoft put a web server in a home OS. If you want to run a web server, you can always get one, but the vast majority of home users - and end-users in general - neither need to run a web server nor want to. Nor would they understand the potential security implications of doing so. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: web server for XP home?
Well then why not just not install it. I see what you're saying about security, but if they are a home user and they don't need it, they probably wouldn't even know how to install it. It sucks that when I want a new computer now, I will have get professional and pay $100 just to get IIS. I don't know about that. I suspect that a lot of home users just click every available checkbox during install, unless they know what they're doing. Hell, a lot of NT admins do that when they set up IIS on a real server! It may suck for you that you have to pay $100 more to MS if you want to get an MS web server. It sucks less for the rest of us that everyone with a cable-modem won't get infected by Code Red XVIII or the like. If you really need to work against IIS specifically, you'll have to use Win2K Server now or wait until XP/.NET Server arrives, anyway, won't you? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: web server for XP home?
Let's be realistic though, the reason they charge $100 extra is not becuase of security, it's because they planned on doing this from day one. They offered it for free to everyone, and when they crushed everyone else, they come along and charged for the feature that was once free. I am 90% sure also that you can't install IIS on install, you can only install it after you have installed the machine. At least that's how it is with Windows 2000 and I am sure XP would follow the same procedure. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 12:03 PM To: CF-Talk Subject: RE: web server for XP home? Well then why not just not install it. I see what you're saying about security, but if they are a home user and they don't need it, they probably wouldn't even know how to install it. It sucks that when I want a new computer now, I will have get professional and pay $100 just to get IIS. I don't know about that. I suspect that a lot of home users just click every available checkbox during install, unless they know what they're doing. Hell, a lot of NT admins do that when they set up IIS on a real server! It may suck for you that you have to pay $100 more to MS if you want to get an MS web server. It sucks less for the rest of us that everyone with a cable-modem won't get infected by Code Red XVIII or the like. If you really need to work against IIS specifically, you'll have to use Win2K Server now or wait until XP/.NET Server arrives, anyway, won't you? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfparam vs. cfif/isDefined/cfset
I tend to set all the commonly used defaults as Request scope variables. No locking, no cfparam, available anywhere. cfscript REQUEST.dsn = myDSN; REQUEST.dbType = dbtype; REQUEST.webRoot = C:/inetpub/wwwroot/; etc... /cfscript PS, Good to know that UDFs are faster. Are there any exceptions to the rule? Sharon - Original Message - From: Michael Dinowitz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 11:35 AM Subject: Re: cfparam vs. cfif/isDefined/cfset 1. You should lock the entire group with a CFLOCK and a scope of application. 2. An IsDefined() with a set is actually slightly faster than a CFAPPLICATION. There's even a UDF that does just this and its still faster even with the small UDF overhead. Note that this is limited to the isdefined() then default. When you start doing the other things that a CFPARAM is useful for then the balance changes. At 11:21 AM 3/26/02, you wrote: Here is my application.cfm file: cfapplication name=appname applicationtimeout=#CreateTimeSpan(2, 0, 0, 0)# cfparam name=application.appnameroot default=/appname cfparam name=application.includesDir default=/appname/includes cfparam name=application.imagesDir default=/appname/images cfparam name=application.menusDir default=/appname/menus cfparam name=application.templatesDir default=/appname/templates cfparam name=application.smapDir default=/appname/smap Should I be locking these cfparam tags? Should I wrap them all in one lock or should I lock each one individually? What is the difference between using cfparam tags as I have above and using cfif with isDefined and cfset to accomplish the same thing? Is one method a better practice than the other? Thanks! George [EMAIL PROTECTED] __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SSL Certificates - provider recommendations?
Be very careful to save all of the key generation information that you create, including the actual key request. If you're installing the key on IIS, create a key backup file, and store that offsite. I second that!!! Nothing worse than having to pay for a new certificate because the developer that installed the original forgot the passwords, key request files...etc. Sharon DiOrio __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Join up datasources
As far as I know, this isn't possible. What is possible is doing two seperate queries and making your own dataset with either QueryNew() or building a structure. Can you give us some more information? Sharon - Original Message - From: Robert Everland [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 11:15 AM Subject: Join up datasources Is it possible to have a query where you don't specify a datasource and then inside of the query join up more than one datasource. Something like this cfquery Select DSN.Database.Table.Row, differentdsn.database.table.row From dsn.database.table, differentdsn.database.table /cfquery Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL Question
Besides using xp_cmdshell does any know how to execute a dts package from a stored procedure? Joshua Tipton __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SSL Certificates - provider recommendations?
Get the cheapest one. Paying for an SSL cert just proves to people you are who you say you are. For development purposes, intranet, or known counterparty apps you can make your own SSL cert for free. http://www.openssl.org On Tue, 26 Mar 2002, Eric Dawson wrote: I need to pick up an SSL certificate, any recommendations or pitfalls I should think about it? Eric _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: web server for XP home?
Let's be realistic though, the reason they charge $100 extra is not becuase of security, it's because they planned on doing this from day one. They offered it for free to everyone, and when they crushed everyone else, they come along and charged for the feature that was once free. Who got crushed, exactly? I can still download Apache - perfect for CF development - and the price hasn't gone up one bit! In addition, there are plenty of third-party web servers that will run on every MS OS I can think of. I still stand by my contention that IIS isn't an appropriate component for a home OS. I think that recent history has borne that out. If you're a developer, you'll want to use the appropriate tools for a developer. I am 90% sure also that you can't install IIS on install, you can only install it after you have installed the machine. At least that's how it is with Windows 2000 and I am sure XP would follow the same procedure. That is incorrect, at least with Windows 2000 Server. The IIS installation is part of the OS install, which is why you can so quickly have a vulnerable machine when installing Windows 2000 Server - I've seen machines go from completion of OS install to being successfully attacked by IIS worms in under fifteen minutes. IIS is an operating system component in Windows 2000. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfparam vs. cfif/isDefined/cfset
there is however a minute difference between cfparam and the if/else block... the if/else block outperforms the params. more code maybe, but when writing the the application I recommend doing it as quickly as possible and with exclusive locks. - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 4:33 PM Subject: Re: cfparam vs. cfif/isDefined/cfset Definately wrap a lock around those, and I would only run that block if 1 of the vars inside isn't defined (if 1 isn't then they all aren'tlike when CF Server is restarted). As far as CFPARAM goes You are correct in using it herewhy write 3 lines of code when you can write 1 ;-) HTH Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Earl, George [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 8:21 AM Subject: cfparam vs. cfif/isDefined/cfset Here is my application.cfm file: cfapplication name=appname applicationtimeout=#CreateTimeSpan(2, 0, 0, 0)# cfparam name=application.appnameroot default=/appname cfparam name=application.includesDir default=/appname/includes cfparam name=application.imagesDir default=/appname/images cfparam name=application.menusDir default=/appname/menus cfparam name=application.templatesDir default=/appname/templates cfparam name=application.smapDir default=/appname/smap Should I be locking these cfparam tags? Should I wrap them all in one lock or should I lock each one individually? What is the difference between using cfparam tags as I have above and using cfif with isDefined and cfset to accomplish the same thing? Is one method a better practice than the other? Thanks! George [EMAIL PROTECTED] __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: web server for XP home?
Well, it certainly doesn't need to install it by default, IIS/PWS is in Win98 (and NT4, and Win2K, and WinXP Pro, for that matter) and you have to explicitly install it... but it's there at least. With no IIS download available anymore, XP Home users who want to do web development have no other real choice than to use someone else's web server, and if they want to do ASP development, they are pretty much screwed. Again, I just fail to see the logic, since MS is so good at making themselves as an all in one package. It wasn't so long ago that all our servers were getting blasted with IIS worms, and I know that in our logs at least, quite a few were coming from people running IIS on their cable modem and DSL connections. My guess is that most of these people didn't even know they were running IIS! The logic is, the target audience for XP Home users probably isn't developers. It's home users - not even office users! If you want to develop, you're not the intended market for XP Home. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: request.imageRoot
I am using fusebox for one of our applications, and for all images calling them with #request.imageRoot#, which is a full virtual Address http://www.liveserver.com/images/ I'm wondering when a site is facing heavy traffic does this cause severe overhead with IIS and is there a more performance friendly approach to the whole affair. If I understand you correctly, you're simply using one additional variable within your CF pages to point to images, right? The only overhead being imposed by that is the marginal difference when generating the output of each page. From IIS's perspective, or from the browsers' perspective, there isn't any other difference. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Question
Joshua, If you look at www.cfcomet.com or http://www.cfcomet.com/cfcomet/sql_server/ it shows how to execute SQL Server DTS packages from ColdFusion. -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: 26 March 2002 17:10 To: CF-Talk Subject: SQL Question Besides using xp_cmdshell does any know how to execute a dts package from a stored procedure? Joshua Tipton __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: 1019 compile error
figured it out on my own. need to escape any and all and $. Anthony Petruzzi Webmaster 954-321-4703 http://www.sheriff.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 9:17 AM To: CF-Talk Subject: 1019 compile error anyone out there a wap expert? well if you are, i need your help. i am trying to get my website wap enabled and i can't seem to get past this one part. i need to know how you can pass variables to another page in the url within wml. everytime i try to do this i get a 1019 error. i want to pass the variables to the same page so that a can display search results. here is the run dows results.cfm displays 5 search results link back to this page with the search phrase in the url a href=results.cfm?search=web%20hostingamp;next=10MORE/a is this the right way to do this? Anthony Petruzzi Webmaster 954-321-4703 http://www.sheriff.org __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: 500 internal server error wap coldfusion
anyone know why I keep getting a 500 internal server error when trying to use wap with CF. I have the cfcontent tag at the top of the page. This is annoying me. if anyone has gotten wap and cf to work together, plwase help. Lots of people have successfully done this, myself included. It might be helpful for you to provide more information. If you're using the Openwave (phone.com) WAP/WML emulator, what's showing up in the debug window? If you're not using the emulator, you should try doing so - it has a useful debug window! What does your code look like? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: web server for XP home?
I second that. I think the default installation of a web server was one of the major reason for code red being to successful. - Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 10:42 AM Subject: RE: web server for XP home? I do find it unforgiveable that Microsoft didn't include IIS in XP Home, it is very shortsighted on their part. I feel exactly the opposite. I think it would be unforgivable if Microsoft put a web server in a home OS. If you want to run a web server, you can always get one, but the vast majority of home users - and end-users in general - neither need to run a web server nor want to. Nor would they understand the potential security implications of doing so. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Returning only one record HELP PLEASE!!!!
I have 2 queries and I need to know what to do to fix code that looks like this. As you will see I am only getting one record from my second query. In the cfouput tags I have to specify a query and a group because I have nested tags there is a reason for this. I just need to know how to make it work this way.. any suggestions? cfquery Name=query1 Datasource=DSN Select column1, column2 From Table1 Where this = that /cfquery cfquery Name=query2 Datasource=DSN Select column12, column22 From Table1 /cfquery CFOUTPUT Query=query1 Group=column1 CFMAIL TO=[EMAIL PROTECTED] FROM=[EMAIL PROTECTED] SUBJECT=test #query1.column1# nbps; #query2.column22# !--- is onlt pulling one record --- /CFMAIL /CFOUTPUT Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: special characters
CFDJ'ers: Wrong list. When trying to add characters like ñ and Ñ, my SQL 7 server tells me I have not enclosed my strings properly. I'm assuming the tilde is breaking it. Any way around that, other than looking for that character and replacing it, with say the HTML equivalent that works? Or will I just have to do a replace() on the string? I haven't run into this problem, personally, so this is just a shot in the dark. Have you preceded your literal strings with the Unicode marker? INSERT INTO mytable (myfield1, myfield2) VALUES (N'This is a Unicode string', N'This is another Unicode string') Also, are the fields themselves Unicode datatypes (nchar, nvarchar, ntext)? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Question
Sorry didn't read your question right -Original Message- From: Declan Maher Sent: 26 March 2002 17:13 To: CF-Talk Subject: RE: SQL Question Joshua, If you look at www.cfcomet.com or http://www.cfcomet.com/cfcomet/sql_server/ it shows how to execute SQL Server DTS packages from ColdFusion. -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: 26 March 2002 17:10 To: CF-Talk Subject: SQL Question Besides using xp_cmdshell does any know how to execute a dts package from a stored procedure? Joshua Tipton __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Question
I need to do it within a stored procedure -Original Message- From: Declan Maher [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 12:13 PM To: CF-Talk Subject: RE: SQL Question Joshua, If you look at www.cfcomet.com or http://www.cfcomet.com/cfcomet/sql_server/ it shows how to execute SQL Server DTS packages from ColdFusion. -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: 26 March 2002 17:10 To: CF-Talk Subject: SQL Question Besides using xp_cmdshell does any know how to execute a dts package from a stored procedure? Joshua Tipton __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SSL Certificates - provider recommendations?
I have had good results with Thawte as well. We use there PKI system (along with Verisign). That Aussie sounding fellow is, almost without doubt, South African g. At 08:37 AM 3/26/2002 -0800, you wrote: Thawte.com certificates are much cheaper than verisign ones... and they have a partners/resellers program set up so that your second SSL cert will be cheaper. The nice Aussie sounding fellow who hooked me up: [EMAIL PROTECTED] I need to pick up an SSL certificate, any recommendations or pitfalls I should think about it? Eric __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFFTP
Anyone know the limitations / performance issues w/ cfftp? I building an application that will have many simultaneous users accessing templates that cfftp files to many different locations. Questions: 1) How many simultaneous / active connections can the CF Server handle? I would guess that it can handle exactly one connection per worker thread, so if you've got the Number of simultaneous requests setting on the Settings page of CF Administrator set to 5, then you'd be able to support five concurrent CFFTP requests. 2) Is there a better way to do this? I'm not sure what this is. If you just want to be able to let people fetch files, you might be better served by just publishing links to the original FTP servers. That doesn't sound like what you want, though. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SSL Certificates - provider recommendations?
I just signed up with Geotrust as a reseller, and am awaiting my acct setup. You get a good pop despite the low certificate price, and a certificate can be installed in literally a few minutes. You'll often spend more time in IIS generating the request than you will waiting for GeoTrust to deliver the cert. Read the contract they send to you. Mine had a provision stating if there is a breach between the two parties GeoTrust has the right to terminate the agreement -- and revoke *all* issued certificates. I objected to that portion and they removed it. --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 8:22 AM To: CF-Talk Subject: SSL Certificates - provider recommendations? I need to pick up an SSL certificate, any recommendations or pitfalls I should think about it? Eric _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Returning only one record HELP PLEASE!!!!
I don't get what you are trying to do. The GROUP attribute is to group data for nested output from one query. EXAMPLE: (Your Data) ID NAMECOLOR - 1 Quiksilver T-Shirt Blue 1 Quiksilver T-Shirt Red 1 Quiksilver T-Shirt Green 1 Quiksilver T-Shirt Gray 2 Volcom T-Shirt Blue 2 Volcom T-Shirt Black 2 Volcom T-Shirt White (Your Code) cfquery name=selProd datasource=#Application.DSN# SELECT ID, NAME, COLOR FROM PRODUCT ORDER BY NAME /cfquery pre cfoutput query=selProd group=NAME Product Name: #NAME# Available Colors: cfoutput #COLOR# /cfoutput /cfoutput /pre (Your Result) Product Name: Quiksilver T-Shirt Available Colors: Blue Red Green Gray Product Name: Volcom T-Shirt Available Colors: Blue Black White I use this function often when I have a record which has many records in a joined table, so that I can just use one query to grab all of the necessary data for the output. Hope this helps! -- SCOTT VAN VLIET SENIOR ANALYST SBC SERVICES, INC Tel: 858.886.3878 Fax: 858.653.6763 Email: [EMAIL PROTECTED] -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 9:24 AM To: CF-Talk Subject: Returning only one record HELP PLEASE I have 2 queries and I need to know what to do to fix code that looks like this. As you will see I am only getting one record from my second query. In the cfouput tags I have to specify a query and a group because I have nested tags there is a reason for this. I just need to know how to make it work this way.. any suggestions? cfquery Name=query1 Datasource=DSN Select column1, column2 From Table1 Where this = that /cfquery cfquery Name=query2 Datasource=DSN Select column12, column22 From Table1 /cfquery CFOUTPUT Query=query1 Group=column1 CFMAIL TO=[EMAIL PROTECTED] FROM=[EMAIL PROTECTED] SUBJECT=test #query1.column1# nbps; #query2.column22# !--- is onlt pulling one record --- /CFMAIL /CFOUTPUT Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: web server for XP home?
dito - the logs on our farm showed the large percetage - though not all - of incomming bombardment where from class A type ips (earthlink, aol, @home etc.). -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 11:22 AM To: CF-Talk Subject: Re: web server for XP home? I second that. I think the default installation of a web server was one of the major reason for code red being to successful. - Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 10:42 AM Subject: RE: web server for XP home? I do find it unforgiveable that Microsoft didn't include IIS in XP Home, it is very shortsighted on their part. I feel exactly the opposite. I think it would be unforgivable if Microsoft put a web server in a home OS. If you want to run a web server, you can always get one, but the vast majority of home users - and end-users in general - neither need to run a web server nor want to. Nor would they understand the potential security implications of doing so. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Developers Tool. Comment Engine.
Thanks Dave, we will give it a whirl here. Interesting thing, if you hit the partial url (it wraps) the error at MM seems to show that they are using Spectra tags for the Dev Exchange. Mike Brunt Sempra Energy 213.244.5226 An elephant is a mouse with an operating system. -Original Message- From: David Schmidt [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 8:03 AM To: CF-Talk Subject: RE: Developers Tool. Comment Engine. Sorry all, Please copy the whole link into the browser. Doggone hit miss outlook. Dave I've created a new, simple cf tag that allows customers and developers to exchange and keep a record of comments. It provides a comment form for entering new comments and a log of previous comments at the bottom of any web page. It is easy to setup, only requiring a single cfinclude statement. I use the OnRequestEnd.cfm file to do this. It works with both fusebox and non-fusebox applications. It uses a wddx file packet, so it does not require any database setup. Please let me know what you think. Feel free to download it from the developers' exchange at: http://devex.macromedia.com/developer/gallery/info.cfm?ID=3C8D8DE0-40A6-11D 6-83FE00508B94F85Amethod=Download PS. Please remember that it is freeware, with no warranties of any kind. Use at your own risk. Dave Schmidt __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Returning only one record HELP PLEASE!!!!
with that also work with 2 queries? Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 11:40 AM To: CF-Talk Subject: RE: Returning only one record HELP PLEASE I don't get what you are trying to do. The GROUP attribute is to group data for nested output from one query. EXAMPLE: (Your Data) ID NAMECOLOR - 1 Quiksilver T-Shirt Blue 1 Quiksilver T-Shirt Red 1 Quiksilver T-Shirt Green 1 Quiksilver T-Shirt Gray 2 Volcom T-Shirt Blue 2 Volcom T-Shirt Black 2 Volcom T-Shirt White (Your Code) cfquery name=selProd datasource=#Application.DSN# SELECT ID, NAME, COLOR FROM PRODUCT ORDER BY NAME /cfquery pre cfoutput query=selProd group=NAME Product Name: #NAME# Available Colors: cfoutput #COLOR# /cfoutput /cfoutput /pre (Your Result) Product Name: Quiksilver T-Shirt Available Colors: Blue Red Green Gray Product Name: Volcom T-Shirt Available Colors: Blue Black White I use this function often when I have a record which has many records in a joined table, so that I can just use one query to grab all of the necessary data for the output. Hope this helps! -- SCOTT VAN VLIET SENIOR ANALYST SBC SERVICES, INC Tel: 858.886.3878 Fax: 858.653.6763 Email: [EMAIL PROTECTED] -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 9:24 AM To: CF-Talk Subject: Returning only one record HELP PLEASE I have 2 queries and I need to know what to do to fix code that looks like this. As you will see I am only getting one record from my second query. In the cfouput tags I have to specify a query and a group because I have nested tags there is a reason for this. I just need to know how to make it work this way.. any suggestions? cfquery Name=query1 Datasource=DSN Select column1, column2 From Table1 Where this = that /cfquery cfquery Name=query2 Datasource=DSN Select column12, column22 From Table1 /cfquery CFOUTPUT Query=query1 Group=column1 CFMAIL TO=[EMAIL PROTECTED] FROM=[EMAIL PROTECTED] SUBJECT=test #query1.column1# nbps; #query2.column22# !--- is onlt pulling one record --- /CFMAIL /CFOUTPUT Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Returning only one record HELP PLEASE!!!!
What are you trying to accomplish? The GROUP attribute will only work with the QUERY specified in the top-level CFOUTPUT tag. If you have grouped data, the you could join in the second table instead of querying it separately. Please post some sample data so that I can try to help you a little more. -- SCOTT VAN VLIET SENIOR ANALYST SBC SERVICES, INC Tel: 858.886.3878 Fax: 858.653.6763 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 9:49 AM To: CF-Talk Subject: RE: Returning only one record HELP PLEASE with that also work with 2 queries? Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 11:40 AM To: CF-Talk Subject: RE: Returning only one record HELP PLEASE I don't get what you are trying to do. The GROUP attribute is to group data for nested output from one query. EXAMPLE: (Your Data) ID NAMECOLOR - 1 Quiksilver T-Shirt Blue 1 Quiksilver T-Shirt Red 1 Quiksilver T-Shirt Green 1 Quiksilver T-Shirt Gray 2 Volcom T-Shirt Blue 2 Volcom T-Shirt Black 2 Volcom T-Shirt White (Your Code) cfquery name=selProd datasource=#Application.DSN# SELECT ID, NAME, COLOR FROM PRODUCT ORDER BY NAME /cfquery pre cfoutput query=selProd group=NAME Product Name: #NAME# Available Colors: cfoutput #COLOR# /cfoutput /cfoutput /pre (Your Result) Product Name: Quiksilver T-Shirt Available Colors: Blue Red Green Gray Product Name: Volcom T-Shirt Available Colors: Blue Black White I use this function often when I have a record which has many records in a joined table, so that I can just use one query to grab all of the necessary data for the output. Hope this helps! -- SCOTT VAN VLIET SENIOR ANALYST SBC SERVICES, INC Tel: 858.886.3878 Fax: 858.653.6763 Email: [EMAIL PROTECTED] -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 9:24 AM To: CF-Talk Subject: Returning only one record HELP PLEASE I have 2 queries and I need to know what to do to fix code that looks like this. As you will see I am only getting one record from my second query. In the cfouput tags I have to specify a query and a group because I have nested tags there is a reason for this. I just need to know how to make it work this way.. any suggestions? cfquery Name=query1 Datasource=DSN Select column1, column2 From Table1 Where this = that /cfquery cfquery Name=query2 Datasource=DSN Select column12, column22 From Table1 /cfquery CFOUTPUT Query=query1 Group=column1 CFMAIL TO=[EMAIL PROTECTED] FROM=[EMAIL PROTECTED] SUBJECT=test #query1.column1# nbps; #query2.column22# !--- is onlt pulling one record --- /CFMAIL /CFOUTPUT Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfparam vs. cfif/isDefined/cfset
Yes, they MUST be locked. These look like variables that don't change - I'd do a CFIF test on one, and if it doesn't exist then set them all. As long as you always set them all together, you can use the existence of one to test for all. This way the app vars are set only once, and don't bog down your pages, since Application.cfm is called with every request. Chris Norloff -- Original Message -- from: Earl, George [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Tue, 26 Mar 2002 11:21:07 -0500 Here is my application.cfm file: cfapplication name=appname applicationtimeout=#CreateTimeSpan(2, 0, 0, 0)# cfparam name=application.appnameroot default=/appname cfparam name=application.includesDir default=/appname/includes cfparam name=application.imagesDir default=/appname/images cfparam name=application.menusDir default=/appname/menus cfparam name=application.templatesDir default=/appname/templates cfparam name=application.smapDir default=/appname/smap Should I be locking these cfparam tags? Should I wrap them all in one lock or should I lock each one individually? What is the difference between using cfparam tags as I have above and using cfif with isDefined and cfset to accomplish the same thing? Is one method a better practice than the other? Thanks! George [EMAIL PROTECTED] __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Developers Tool. Comment Engine.
I know this is html post, but here is the link again. Perhaps it will work this time. http://devex.macromedia.com/developer/gallery/info.cfm?ID=3C8D8DE0-40A6-11D6 -83FE00508B94F85A Dave -Original Message- From: Brunt, Michael [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 9:45 AM To: CF-Talk Subject: RE: Developers Tool. Comment Engine. Thanks Dave, we will give it a whirl here. Interesting thing, if you hit the partial url (it wraps) the error at MM seems to show that they are using Spectra tags for the Dev Exchange. Mike Brunt Sempra Energy 213.244.5226 An elephant is a mouse with an operating system. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Question
yes. i actually posted this a few weeks ago. search the archives. if you can't find it, i'll dig out the code again. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 12:10 PM To: CF-Talk Subject: SQL Question Besides using xp_cmdshell does any know how to execute a dts package from a stored procedure? Joshua Tipton __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfparam vs. cfif/isDefined/cfset
Yeah, the request rounte it the way to go. I also have a Settings table in
my apps for application/request vars used in a particular application. Take
a look at this snip from my application.cfm
cfscript
request.dsSQL = whatever;
request.RootURL = http://whatever.com;;
request.RootPath = x:\whatever\whatever.com;
request.zeroGUID = ----;
/cfscript
!--- create application.setting.Struct and request.setting.Struct ---
cflock type=READONLY scope=APPLICATION timeout=10
cfset locAppDefined = isDefined(application.setting)
/cflock
cfif locAppDefined eq 0 or isDefined(url.resetapp)
cfquery name=qrySettings datasource=#request.dsSQL#
SELECT SettingName, SettingValue
FROM Settings
/cfquery
cflock type=EXCLUSIVE scope=APPLICATION timeout=10
cfscript
structDelete(application, setting);
application.setting = StructNew();
for (i=1; i lte qrySettings.recordCount; i=i+1) {
application.setting.#qrySettings.SettingName[i]# =
qrySettings.SettingValue[i];
}
/cfscript
/cflock
/cfif
cflock type=READONLY scope=APPLICATION timeout=10
cfscript
request.setting = StructNew();
request.setting = Duplicate(application.setting);
/cfscript
/cflock
Justin Hansen
--
Uhlig Communications
Web Developer / Programmer
--
[EMAIL PROTECTED]
913-498-0123 ext 284
--
-Original Message-
From: Sharon DiOrio [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 11:10 AM
To: CF-Talk
Subject: Re: cfparam vs. cfif/isDefined/cfset
I tend to set all the commonly used defaults as Request scope variables. No
locking, no cfparam, available anywhere.
cfscript
REQUEST.dsn = myDSN;
REQUEST.dbType = dbtype;
REQUEST.webRoot = C:/inetpub/wwwroot/;
etc...
/cfscript
PS, Good to know that UDFs are faster. Are there any exceptions to the
rule?
Sharon
- Original Message -
From: Michael Dinowitz [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, March 26, 2002 11:35 AM
Subject: Re: cfparam vs. cfif/isDefined/cfset
1. You should lock the entire group with a CFLOCK and a scope of
application.
2. An IsDefined() with a set is actually slightly faster than a
CFAPPLICATION. There's even a UDF that does just this and its still faster
even with the small UDF overhead. Note that this is limited to the
isdefined() then default. When you start doing the other things that a
CFPARAM is useful for then the balance changes.
At 11:21 AM 3/26/02, you wrote:
Here is my application.cfm file:
cfapplication name=appname applicationtimeout=#CreateTimeSpan(2, 0, 0,
0)#
cfparam name=application.appnameroot default=/appname
cfparam name=application.includesDir default=/appname/includes
cfparam name=application.imagesDir default=/appname/images
cfparam name=application.menusDir default=/appname/menus
cfparam name=application.templatesDir default=/appname/templates
cfparam name=application.smapDir default=/appname/smap
Should I be locking these cfparam tags? Should I wrap them all in one
lock
or should I lock each one individually?
What is the difference between using cfparam tags as I have above and
using
cfif with isDefined and cfset to accomplish the same thing? Is one method
a
better practice than the other?
Thanks!
George
[EMAIL PROTECTED]
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Returning only one record HELP PLEASE!!!!
OK, is query2 only *supposed* to be outputting one record? I don't think you need to group the first query: CFMAIL TO=[EMAIL PROTECTED] FROM=[EMAIL PROTECTED] SUBJECT=test QUERY=query1 #column1# nbps; #query2.column2# /CFMAIL Sharon DiOrio - Original Message - From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 1:02 PM Subject: RE: Returning only one record HELP PLEASE I am not allowed to post data. but what I put out is very close to what I have.. I have multiple records in both tables and query2 is only outputting one record. cfquery Name=query1 Datasource=DSN Select column1, column2 From Table1 Where this = that /cfquery cfquery Name=query2 Datasource=DSN Select column12, column22 From Table1 /cfquery CFOUTPUT Query=query1 Group=column1 CFMAIL TO=[EMAIL PROTECTED] FROM=[EMAIL PROTECTED] SUBJECT=test #query1.column1# nbps; #query2.column22# !--- is onlt pulling one record --- /CFMAIL /CFOUTPUT Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 11:54 AM To: CF-Talk Subject: RE: Returning only one record HELP PLEASE What are you trying to accomplish? The GROUP attribute will only work with the QUERY specified in the top-level CFOUTPUT tag. If you have grouped data, the you could join in the second table instead of querying it separately. Please post some sample data so that I can try to help you a little more. -- SCOTT VAN VLIET SENIOR ANALYST SBC SERVICES, INC Tel: 858.886.3878 Fax: 858.653.6763 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 9:49 AM To: CF-Talk Subject: RE: Returning only one record HELP PLEASE with that also work with 2 queries? Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 11:40 AM To: CF-Talk Subject: RE: Returning only one record HELP PLEASE I don't get what you are trying to do. The GROUP attribute is to group data for nested output from one query. EXAMPLE: (Your Data) ID NAME COLOR - 1 Quiksilver T-Shirt Blue 1 Quiksilver T-Shirt Red 1 Quiksilver T-Shirt Green 1 Quiksilver T-Shirt Gray 2 Volcom T-Shirt Blue 2 Volcom T-Shirt Black 2 Volcom T-Shirt White (Your Code) cfquery name=selProd datasource=#Application.DSN# SELECT ID, NAME, COLOR FROM PRODUCT ORDER BY NAME /cfquery pre cfoutput query=selProd group=NAME Product Name: #NAME# Available Colors: cfoutput #COLOR# /cfoutput /cfoutput /pre (Your Result) Product Name: Quiksilver T-Shirt Available Colors: Blue Red Green Gray Product Name: Volcom T-Shirt Available Colors: Blue Black White I use this function often when I have a record which has many records in a joined table, so that I can just use one query to grab all of the necessary data for the output. Hope this helps! -- SCOTT VAN VLIET SENIOR ANALYST SBC SERVICES, INC Tel: 858.886.3878 Fax: 858.653.6763 Email: [EMAIL PROTECTED] -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 9:24 AM To: CF-Talk Subject: Returning only one record HELP PLEASE I have 2 queries and I need to know what to do to fix code that looks like this. As you will see I am only getting one record from my second query. In the cfouput tags I have to specify a query and a group because I have nested tags there is a reason for this. I just need to know how to make it work this way.. any suggestions? cfquery Name=query1 Datasource=DSN Select column1, column2 From Table1 Where this = that /cfquery cfquery Name=query2 Datasource=DSN Select column12, column22 From Table1 /cfquery CFOUTPUT Query=query1 Group=column1 CFMAIL TO=[EMAIL PROTECTED] FROM=[EMAIL PROTECTED] SUBJECT=test #query1.column1# nbps; #query2.column22# !--- is onlt pulling one record --- /CFMAIL /CFOUTPUT Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfparam vs. cfif/isDefined/cfset
why use the application scope, when you have the request scope and you don't have to mess with locking. Anthony Petruzzi Webmaster 954-321-4703 http://www.sheriff.org -Original Message- From: Chris Norloff [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 1:11 PM To: CF-Talk Subject: Re: cfparam vs. cfif/isDefined/cfset Yes, they MUST be locked. These look like variables that don't change - I'd do a CFIF test on one, and if it doesn't exist then set them all. As long as you always set them all together, you can use the existence of one to test for all. This way the app vars are set only once, and don't bog down your pages, since Application.cfm is called with every request. Chris Norloff -- Original Message -- from: Earl, George [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Tue, 26 Mar 2002 11:21:07 -0500 Here is my application.cfm file: cfapplication name=appname applicationtimeout=#CreateTimeSpan(2, 0, 0, 0)# cfparam name=application.appnameroot default=/appname cfparam name=application.includesDir default=/appname/includes cfparam name=application.imagesDir default=/appname/images cfparam name=application.menusDir default=/appname/menus cfparam name=application.templatesDir default=/appname/templates cfparam name=application.smapDir default=/appname/smap Should I be locking these cfparam tags? Should I wrap them all in one lock or should I lock each one individually? What is the difference between using cfparam tags as I have above and using cfif with isDefined and cfset to accomplish the same thing? Is one method a better practice than the other? Thanks! George [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
