RE: AOLServer (was: CF/IIS/Windows security class)
What the heck is AOLServer? -Jay -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Monday, November 26, 2001 6:53 PM To: CF-Talk Subject: RE: AOLServer (was: CF/IIS/Windows security class) PSS: Although certain parts of allaire.com run faster now that Macromedia has taken over, the support section still is slow and the KB returns articles that have little relevance to what I type it. That said, I'm tired of waiting around for the web site to actually tell me something useful. Anyone know if CF will run on AOLServer? It should run in CGI mode, with the crappy performance which that entails. I don't think AOLServer supports any of the standard APIs used by other web servers. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: (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
OT: Enterprise Manager / SQL Server
Hi - I'm wondering if Enterprise Manager for SQL Server is available from Microsoft as a free or low cost download. If anyone has details or suggestions, please let me know. Thanks, ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Enterprise Manager / SQL Server
Icks
That's what I was afraid of you saying. People don't react well when I
tell them they need to download a 300MB+ installer to install just a
small subset of the files they actually download.
Oh well :-(. Thanks for the info anyhow.
-Jay
-Original Message-
From: Sicular, Alexander [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 19, 2001 4:34 PM
To: CF-Talk
Subject: RE: Enterprise Manager / SQL Server
Just install sql without the server, it's under the custom install
option.
Good luck,
Alexander Sicular
Chief Technology Architect
Neurological Institute of New York
Columbia University
as867 [at] columbia {dot} edu
|-Original Message-
|From: Jay Sudowski - Handy Networks LLC [mailto:[EMAIL PROTECTED]]
|Sent: Monday, November 19, 2001 4:34 PM
|To: CF-Talk
|Subject: OT: Enterprise Manager / SQL Server
|
|
|Hi -
|
|I'm wondering if Enterprise Manager for SQL Server is
|available from Microsoft as a free or low cost download. If
|anyone has details or suggestions, please let me know.
|
|Thanks,
|
|
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IIS Export from NT to Win2k
Hi Kirk, I really would not recommend upgrading from NT4 to Win2K. I would backup everything, format the drives and start with the fresh install of Win2K (make sure to install all of the service packs and hot fixes). So yes, if you wiped out the machine, you would need to use an IIS import / export utility. If you upgrade, I'm honestly not sure what would happen. I've never don a straight NT4 to Win2K upgrade. I've always done a format / clean install. - Jay -Original Message- From: Kirk Boecker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 3:52 PM To: CF-Talk Subject: Re: IIS Export from NT to Win2k We still have one server pair that is running NT4 - and we want to upgrade that one to the WIN2K advanced that all of our others are running - if I am not moving from one server to the next and just upgrading - will all my IIS setting stay intact or do I need to look at backing them up with a tool like this too?? Kirk - Original Message - From: Larry Juncker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 31, 2001 11:45 AM Subject: RE: IIS Export from NT to Win2k Will; We just did that with the use of a program from adsonline.com Go to http://www.adsonline.co.uk/iisexport There is a shareware version that may help you a little Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] -Original Message- From: Will Ryan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 1:08 PM To: CF-Talk Subject: IIS Export from NT to Win2k Challenge! I have 20 FTP sites 25 Web sites running on a NT 4.0 I'm moving onto a Win2k box, both running IIS. I'm not enjoying spending my day re-entering the IIS info from one machine to another, any suggestions for an export or replication from NT to 2K ~~ 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: UDF's are GREAT
LOL. Bug free as XP. That makes me worry ;-) - Jay -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 30, 2001 3:07 PM To: CF-Talk Subject: RE: UDF's are GREAT Heh, good one. On a serious note, for anyone who is interested, CFLIB.org now has over 250 UDFs released. All are guaranteed as bugfree as WinXP! -RC From: Craig Fisher [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 30, 2001 3:03 PM To: CF-Talk Subject: Re: UDF's are GREAT umm... I believe the syntax is: #ShamelessPlugFormat(I assume you have visited www.cflib.org??)# ~~ 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: Help please
If Sales.Process_ID is a text field in your Access Database, it should be enclosed in single quotes on the query. IE - CFQUERY NAME=GetAllSalesForSession DATASOURCE=#attributes.dsn# SELECT Sales.SaleDate, Sales.ProductID, Products.ProductName, Products.UnitPrice, Sales.Quantity, Sales.PROCESS_ID, Products.ProductID FROM Sales, Products WHERE (Sales.ProductID = Products.ProductID) AND (Sales.PROCESS_ID= '#session.PROCESS_ID#') /CFQUERY - Jay -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 18, 2001 3:17 AM To: CF-Talk Subject: Help please I've run into real strife with this - can anyone help please. Sales.PROCESS_ID is stored as a text value (even though its numeric) as Access can't store a 20 digit integer. It has to be a 20 digit integer. session.PROCESS_ID is numeric as its generated via a rand function. I can't seem to get this to execute. I've tried applying Val to Sales.PROCESS_ID but no joy. CFQUERY NAME=GetAllSalesForSession DATASOURCE=#attributes.dsn# SELECT Sales.SaleDate, Sales.ProductID, Products.ProductName, Products.UnitPrice, Sales.Quantity, Sales.PROCESS_ID, Products.ProductID FROM Sales, Products WHERE (Sales.ProductID = Products.ProductID) AND (Sales.PROCESS_ID= #session.PROCESS_ID#) /CFQUERY ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. ~~ 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: Code Red backdoor triggered?
Gr. We're getting hammered with something across three of our servers. Data transfer is up 600% compared to normal. Today is gonna be one of those days ... -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 18, 2001 10:37 AM To: CF-Talk Subject: RE: Code Red backdoor triggered? even we're getting hammered with syn flood attacks. Rich Wild -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: 18 September 2001 15:52 To: CF-Talk Subject: FW: Code Red backdoor triggered? It seems there may be some unusual network activity today worth noting. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 18 September, 2001 10:49 To: [EMAIL PROTECTED] Subject: RE: Code Red backdoor triggered? Heads up. Pay attention to your servers today. I just started detecting a *ton* of these requests. I think it's a follow-up worm programmed to take advantage of the backdoors Code Red dropped on infected computers. Maybe a Code Red III? -Cameron [09/18/2001 09:25:55.136 GMT-0400] Connection: dhcp181.onewebsystems.com (130.205.102.181) on port 80 (tcp). [09/18/2001 09:25:55.166 GMT-0400] GET /scripts/root.exe?/c+dir HTTP/1.0 Host: www Connnection: close After a more careful reading, I don't think this is an attack at all. I think it's worse than an attack. The GET request doesn't do anything except run the DOS dir command using the command processor. But, if a server responds with an HTTP 200 status code, this indicates that the server is vulnerable to running cmd.exe through the web server. So, my guess is that this is a vulnerability scan. Once a list of vulnerable servers is compiled, a real attack would take much less time than a Code Red-style attack, since you could build the list of vulnerable servers into the attack code! This idea has been discussed a bit in the last month or so - it's called a Warhol worm, the idea being that an attack might cover the mass of vulnerable machines in fifteen minutes. Here's a URL to the article: http://hacktivism.openflows.org/article.pl?sid=01/08/13/123724 5mode=nocommentthreshol= Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 Control your subscriptions to ACFUG lists via the ACFUG website at ~~ 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
FW: Alert: Some sort of IIS worm seems to be propagating
-Original Message- From: Russ [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 18, 2001 11:21 AM To: [EMAIL PROTECTED] Subject: Alert: Some sort of IIS worm seems to be propagating -BEGIN PGP SIGNED MESSAGE- There have been numerous reports of IIS attacks being generated by machines over a broad range of IP addresses. These infected machines are using a wide variety of attacks which attempt to exploit already known and patched vulnerabilities against IIS. It appears that the attacks can come both from email and from the network. A new worm, being called w32.nimda.amm, is being sent around. The attachment is called README.EXE and comes as a MIME-type of audio/x-wav together with some html parts. There appears to be no text in this message when it is displayed by Outlook when in Auto-Preview mode (always a good indication there's something not quite right with an email.) The network attacks against IIS boxes are a wide variety of attacks. Amongst them appear to be several attacks that assume the machine is compromised by Code Red II (looking for ROOT.EXE in the /scripts and /msadc directory, as well as an attempt to use the /c and /d virtual roots to get to CMD.EXE). Further, it attempts to exploit numerous other known IIS vulnerabilities. One thing to note is the attempt to execute TFTP.EXE to download a file called ADMIN.DLL from (presumably) some previously compromised box. Anyone who discovers a compromised machine (a machine with ADMIN.DLL in the /scripts directory), please forward me a copy of that .dll ASAP. Also, look for TFTP traffic (UDP69). As a safeguard, consider doing the following; edit %systemroot/system32/drivers/etc/services. change the line; tftp 69/udp to; tftp 0/udp thereby disabling the TFTP client. W2K has TFTP.EXE protected by Windows File Protection so can't be removed. More information as it arises. Cheers, Russ - Surgeon General of TruSecure Corporation/NTBugtraq Editor -BEGIN PGP SIGNATURE- Version: PGP Personal Privacy 6.5.2 iQCVAwUBO6dmcRBh2Kw/l7p5AQHJCgQA1JHwqF5RjJX+QVMMDUChVqn6yReQXqEH Tm8Ujms5+6ia0tcT1qmZWJV48eHYNzV3+AyyO6Gn8ds/NVYJUupDHB1Yy1DY/po6 iycY2qnARDJP6KNmHI0bAdBUBtsnVo5P9itElIoqKbAorQjamKI2eqd4TdE0yfIOhSW7yN2lhJ= =YAwc -END PGP SIGNATURE- Delivery co-sponsored by Trend Micro, Inc. TREND MICRO SCANMAIL FOR EXCHANGE 2000 -- SECOND to NONE If you are worried about email viruses, you need Trend Micro ScanMail for Exchange. ScanMail is the first antivirus solution that seamlessly integrates with the Microsoft Exchange 2000 virus-scanning API 2.0. ScanMail ensures 100% inbound and outbound email virus scanning and provides remote software management. Download a FREE 30-day trial copy of ScanMail and find out why it is the best: http://www.antivirus.com/banners/tracking.asp?si=8BI;=240UL;=/sme x2000= ~~ 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
SOT: Training Recommendations
Hi All - I'm hoping someone can recommend some ColdFusion training that focuses on a variety of topics at the database level, especially including: * Database Design Techniques * Implementing Stored Procedures * Designing and Using Triggers * Joins I started using ColdFusion on a very casual, teach-myself-as-I-go basis back when CF3 was the latest and greatest. I am very confident with my ColdFusion specific skills, but continue to find that my SQL skills (or lack of) are holding me back. I get especially confused with joins, and moment I prefer to use the old ANSI 88?? style joins. However, when I need to do any complex nested joins, I find myself relying on Access's query builder because I absolutely can't figure out how to write them by hand. I also have very little knowledge about stored procedures, triggers, indexes, etc. I've been able to gather that stored procedures and triggers can make a world of difference performance-wise, and I feel as-if I'm providing a a great disservice to my customers by not knowing how to properly evaluate when I should be using implementing stored-procedures, triggers or whatever. Overall, I want to improve my database design and SQL skills, but I want the information I learn to be delivered in a way so that it's always relating back to ColdFusion. Any suggestions? Jay Sudowski - Handy Networks LLC TEL: 877-70-HANDY FAX: 888-300-2FAX URL: www.handynetworks.com - Providing reseller and dedicated Windows 2000 web hosting solutions. ~~ 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
testing
Jay Sudowski - Handy Networks LLC TEL: 877-70-HANDY FAX: 888-300-2FAX URL: www.handynetworks.com http://www.handynetworks.com - Providing reseller and dedicated Windows 2000 web hosting solutions. ~~ 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: OLE-DB Client Storage Problem
Hi Dina - I don't believe that many folks use OLEDB at all. I tried setting up an OLEDB DSN for my client variables to SQL Server, and that process failed. In some instances I have been forced to develop with Access, and I attempted to use OLEDB, but I had a whole slew of problems and couldn't workaround the issues, so I reverted to ODBC. Jay Sudowski - Handy Networks LLC TEL: 877-70-HANDY FAX: 888-300-2FAX URL: www.handynetworks.com http://www.handynetworks.com - Providing reseller and dedicated Windows 2000 web hosting solutions. -Original Message- From: Dina Hess [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 10:10 AM To: CF-Talk Subject: Re: OLE-DB Client Storage Problem Peter, Thank you for your response. I should probably re-word my question to, Is there anyone on this list who actually uses MS Access (or any other db for that matter) as an OLEDB datasource? I set my database up in CF Admin that way because I thought it would make it more robust (re: Allaire KB article) but OLEDB doesn't seem to be well supported by ColdFusion. By that, I mean there are no OLEDB date functions and, as I've already indicated, CF Admin is unable to make the necessary tables for client variable storage if the datasource is OLEDB. Your suggestion is by far the simplest solution...and I'm ready to bail. :-) Thanks, Dina - Original Message - From: Peter Tilbrook To: CF-Talk Sent: Friday, August 31, 2001 6:39 PM Subject: RE: OLE-DB Client Storage Problem Possibly only supports ODBC connections. Try that first and it should be OK. ~~ 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: Pathing question
cfset file_name = ListLast(cgi.cf_template_path, \) Jay Sudowski - Handy Networks LLC TEL: 877-70-HANDY FAX: 888-300-2FAX URL: www.handynetworks.com http://www.handynetworks.com - Providing reseller and dedicated Windows 2000 web hosting solutions. -Original Message- From: Gary P. McNeel, Jr. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 10:59 PM To: CF-Talk Subject: Pathing question Is there anyway to get the different parts of this broken out. For example, I want to know the last file name of this cgi variable. CF_TEMPLATE_PATH=D:\dacnet\htdocs\DAC-Net\Projects\index.cfm Thanks. Regards, Gary P. McNeel, Jr. Executive Director - DAC-Net Rice University 713-348-6266 dacnet.rice.edu ~~ 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: OT Suggestions for Email Servers
Hi Chris, I'd have to recommend iMS - http://www.coolfusion.com/iMS.cfm. While never using it, it seems to be a much better solutions, as it supports up to 1024 concurrent connections (meaning, you can send up to 1024 emails at once!). If you using CFMAIL, and with the include IIS SMTP server, you'll only be able to send 400 messages a minute max because CFMAIL can only spool 100 messages every 15 seconds. Hope this helps. Jay Sudowski - Handy Networks LLC TEL: 877-70-HANDY FAX: 888-300-2FAX URL: www.handynetworks.com http://www.handynetworks.com - Providing reseller and dedicated Windows 2000 web hosting solutions. -Original Message- From: Chris Martinez [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 28, 2001 4:04 PM To: CF-Talk Subject: OT Suggestions for Email Servers All, Our shop has repeated requests for bulk email apps. Some of our lists are over 100,000 recipients long. Past attempts to provide this service have yielded nothing but headaches. We are using an email server called MailMax. No matter what we do, server cannot handle the number of emails that are sent to it's queue. Now management has tasked me with coming up with a permanent solution. My first suggestion was to move the mail server off the web server and place it on it's own machine. I am also leaning towards Linux as the OS, because of it's stability, and the fact that there is less overhead involved. There are tons of email servers out there, and I just want something that won't have to have a babysitter. What have you had experience with? Would you use it again? What features did you like/dislike. Stability? Limits? If this is too off topic you can email me off list: Thanks, Chris Martinez Chris underscore Martinez at Imaginuity dot 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: Creating CFX tags - DLL's and NT
I'd imagine that you could use: Regsvr32 /u your.dll to unregister it and Regsvr32 your.dll to reregister it Not sure how effective this will be if you are keeping the DLL loaded.\ - Jay Sudowski -Original Message- From: Brian Fox [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 7:43 PM To: CF-Talk Subject: Creating CFX tags - DLL's and NT How can I force NT4.0 to reload a modified dll/cfx tag? Renaming the dll and adding it to the CFX list has become extremely tedious. Thanks, Brian ~~ 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: CFLocation and Passing Complex Data
A simple solution to this URL truncation problem may be to create a table in your database to use a storage repository for the WDDX packet, insert the WDDX packet into the db, and then just pass a UUID through the URL variable, retrieve the wddx packet from the db, and then recreate your structure. - Jay -Original Message- From: Don Vawter [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 7:36 PM To: CF-Talk Subject: Re: CFLocation and Passing Complex Data First Template cfwddx action=CFML2WDDX input=#myStruct# output=packet cflocation url=sometemplate.cfm?packet=#urlencodedformat(packet)# Second template cfwddx action=WDDX2CFML input=#url.packet# output=myStruct myStruct now exists in second template. Again be careful if this is complex or it may get truncated by browser - Original Message - From: Yvette Ingram [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, August 17, 2001 5:18 PM Subject: Re: CFLocation and Passing Complex Data Ok. I'm using CFML2WDDX on the receiving end. So how do I get it over there. I'm totally brain dead at the moment. I know a bell will go off shortly. Hush... I think I may hear it;-) Yvette Ingram Brainbench Certified ColdFusion 4.5 Programmer Email: [EMAIL PROTECTED] or [EMAIL PROTECTED], or [EMAIL PROTECTED] ICQ: 21200397 Website: http://www.tkisolutions.com - Original Message - From: Yvette Ingram [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, August 17, 2001 7:09 PM Subject: Re: CFLocation and Passing Complex Data So I should serialize it before sending. Ok. then how can I send it? I can choose between cflocation, cfmodule, cfinclude. What's the best way to get this to the other file. I'm using WDDX on the receiving end to deserialize it. TIA Yvette Ingram Brainbench Certified ColdFusion 4.5 Programmer Email: [EMAIL PROTECTED] or [EMAIL PROTECTED], or [EMAIL PROTECTED] ICQ: 21200397 Website: http://www.tkisolutions.com - Original Message - From: Don Vawter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, August 17, 2001 7:00 PM Subject: Re: CFLocation and Passing Complex Data You can only pass simple data as a url parameter not complex such as structs. You could serialize the struct with wddx and then pass the resultant string but you would quite likely exceed the character limits on a url if you had a complex struct. You might consider storing the struct in a session var or storing the serialized struct as a client variable. - Original Message - From: Yvette Ingram [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, August 17, 2001 4:44 PM Subject: CFLocation and Passing Complex Data Hi: I'm trying to pass complex data (structure in particular), using cflocation, but I'm not able to. The example is like this: cflocation url=template.cfm?stMemberData=#stMemberInfo# The error I'm getting is saying that I can only pass simple data with cflocation. I need to pass complex data. Is this possible to do? Thanks in advance. Yvette Ingram Brainbench Certified ColdFusion 4.5 Programmer Email: [EMAIL PROTECTED] or [EMAIL PROTECTED], or [EMAIL PROTECTED] ICQ: 21200397 Website: http://www.tkisolutions.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: IIS Log Entry
Correct. IIRC, you only see the attempts by Code Red if you are safe from the worm. If the worm infected your computer, you would never see the attempts in your log file. - Jay -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 14, 2001 9:55 PM To: CF-Talk Subject: Re: IIS Log Entry But since I am patched, then I should not have anything to worry about? - Original Message - From: tom muck [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, August 14, 2001 8:07 PM Subject: Re: IIS Log Entry It means a computer infected with Code Read virus is trying to infect your IIS. tom www.basic-ultradev.com Bruce Sorge [EMAIL PROTECTED] wrote in message 004301c12523$b9202820$[EMAIL PROTECTED]">news:004301c12523$b9202820$[EMAIL PROTECTED]... All this talk about IIS Server logs got me to looking at my raw log files instead of just having WebTrends do the looking for me, and I have found a very interesting entry that I do not know what it is. It is: 2001-08-13 00:35:00 195.124.132.5 - 10.7.128.164 80 GET /default.ida?NNN N%u9090%u6858%ucbd3%u7801%u9090%u6858%ucbd3%u7801%u9090%u6858%uc bd3% ~~ 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: Graphing error
Jim, I would try restarting the ColdFusion Graphing Server in your services control panel. CFGRAPH operates on a very stripped down version of JRUN / MM Generator, which is why you're getting the Jrun error. It'd be nice if CF Server could provide more descriptive error messages :-) - Jay -Original Message- From: Jim Watkins [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 14, 2001 9:50 PM To: CF-Talk Subject: Graphing error My cold Fusion 5 Graphing Server was running fine until now and I get the error: Could not connect to JRun Connector Proxy Please contact the system administrator for this web site. Can someone shed some light on this? Jim Watkins ~~ 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: CFLOCK Scope vs Name attributes !!
Hamid, If you are using a session variable as your cflock name, I'd imagine that you are pretty much defeating the purpose of CFLOCK. You'd have to CFLOCK the CFLOCK ... As for your question, here's info directly from the CF docs ... SCOPE Optional. Specifies the scope as one of the following: Application, Server, or Session. This attribute is mutually exclusive with the NAME attribute. See the Scope section for valuable information (Whenever you display, set, or update variables, in one of the shared scopes, use the SCOPE attribute to identify the scope as Server, Application or Session) NAME Optional. Specifies the name of the lock. Only one request will be able to execute inside a CFLOCK tag with a given name. Therefore, providing the NAME attribute allows for synchronizing access to the same resources from different parts of an application. Lock names are global to a ColdFusion server. They are shared between applications and user sessions, but not across clustered servers. This attribute is mutually exclusive with the SCOPE attribute. Therefore, do not specify the SCOPE attribute and the NAME attribute in the same tag. Note that the value of NAME cannot be an empty string. Hope this helps ... Jay -Original Message- From: Hamid Hossain [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 15, 2001 1:12 AM To: CF-Talk Subject: CFLOCK Scope vs Name attributes !! Hi, I am wondering if there is a real different for using scope or name attribute with CFLOCK CFLOCK SCOPE=SESSION ... or CFLOCK NAME=#SESSION.SessionID# ... Regards, Hamid Hossain ~~ 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: Locked Database
Hi - Usually sending a bad query to the data source will break the lock. You can also set disable database connections in the CF Administrator. If you disable db connections, make sure you enable them again, otherwise your site won't work :-) Jay Sudowski - Handy Networks LLC TEL: 877-70-HANDY FAX: 888-300-2FAX URL: www.handynetworks.com http://www.handynetworks.com - Providing reseller and dedicated Windows 2000 web hosting solutions. -Original Message- From: CFHelp [mailto:[EMAIL PROTECTED]] Sent: Monday, August 06, 2001 10:12 PM To: CF-Talk Subject: Locked Database Is there some code I can put into a page to unlock an access database? Rick Eidson Owner http://www.kchost.net/ KChost is getting ready to launch it's enews service Now you can moderate your own affordable newsletter Promote you products and services even sell advertising. Plans start at $5 a month for 500 emails. FREE Trial account. ~~ 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: Locked Database
I'd have to think that Disable Database Connections would also be immediate (but I'm honestly not sure). And while it may be more intrusive then momentarily unlocking the database with a bad query, if Rick's site is popular, disabling database connections to the db may be the only way to go because other users may relock the database before he can initiate / complete his upload. Similarly, if users try to query his database while he's uploading the database, they will receive an error. I'd also think that it would be very possible some sort of corruption or instability to seep into the file he's uploading if ColdFusion tried to repeatedly open a connection to the database before the upload has been completed. - Jay -Original Message- From: Todd Ashworth [mailto:[EMAIL PROTECTED]] Sent: Monday, August 06, 2001 11:05 PM To: CF-Talk Subject: Re: Locked Database Usually sending a bad query to the data source will break the lock. You can also set disable database connections in the CF Administrator. If you disable db connections, make sure you enable them again, otherwise your site won't work :-) The bogus query is a better option .. it is less intrusive and more immediate than the disable database connections one. The other method I was refering to in my last post is the CFusion_DBConnections_Flush() function. That tends to break all DB connections without having to change anything on the CF server. To use it, set some temp variable to the function .. .eg: cfset Variables.uselessTempVariable CFusion_DBConnections_Flush() Todd Jay Sudowski - Handy Networks LLC TEL: 877-70-HANDY FAX: 888-300-2FAX URL: www.handynetworks.com http://www.handynetworks.com - Providing reseller and dedicated Windows 2000 web hosting solutions. ~~ 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: Lock the database?
Hi Paris, I'd recommend using cftry / cfcatch. Credit for the info below goes to Steve Nelson. He's discussing his cf_max_id tag. Hope this helps. Jay What about locking issues? Microsoft Access in particular may throw errors if you use this tag if simultaneous people try and create records at the same time, even if you use the cftransaction tag and/or the cflock tag. If that is happening, you should probably upgrade to SQL Server or another multi-user database engine. But, in the mean time, let CF error handling fix this problem for you. (this is sooo slick :) cfloop condition=true cftry cftransaction cf_max_ID datasource=#application.mainDSN# tablename=users primarykey=userid cfquery name=addhistory datasource=#application.mainDSN# insert into users(userid,firstname,lastname,email) values(#max_ID#,'#trim(attributes.firstname)#','#trim(attributes.lastnam e)#','#attributes.email#') /cfquery /cftransaction cfbreak cfcatch type=database /cfcatch /cftry /cfloop -Original Message- From: Paris Lundis [mailto:[EMAIL PROTECTED]] Sent: Monday, August 06, 2001 11:19 PM To: CF-Talk Subject: Lock the database? So I have some code that logs page information on every page and across multiple servers... The idea is to slap the data into Access and fold a database file a day vs. the overhead and in box disk issues with SQL Server.. not to mention cost... Scenario 2 users access a page... one on SERVER A the other on SERVER B... Same code .. same database (Access) in both and stored on a NAS storage device... Both folks go to the page at the same time... cfquery name=logactivity datasource=logger update dailyimpressions where record = #record# /cfquery Now that work across a few million pages a month, but generate a few - 50-100 errors a day of : ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] Could not update; currently locked by user 'adm' on machine 'CRAPO1'. SQL = insert into dailyimpressions ETC. WHat would any of you recommend to lock the database call /reduce errors spun out? Interested in hearing everyone's input... Locks.. ehh... -paris ~~ 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
Client Vars in OLEDB
Hi All - I recently setup a Win2K SP2 / CF5.0 Ent server to store client variables in a SQL Server 7 via a OLEDB connection, but whenever accessing any pages using client variables, I would receive this cryptic error: Error Diagnostic Information OLEDB Error Code = 0 Null accessors are not supported by this provider. I did a search for the error over at forums.allaire.com, and noticed that other people were receiving the same error when trying to store their client vars in a OLEDB DSN. I change the DSN to back to ODBC, pointed towards the same exact SQL server, same database, same tables, everything the same - and now I don't get the error anymore. Perhaps not so coincidentally, when I was setting the server up CF server wouldn't create the necessary tables using an OLEDB connection. I had to create a ODBC DSN and use that DSN to create the client variable tables. All of this begs the question ... Why can't I store client vars in a OLEDB DSN, even though OLEDB is recommended over ODBC? Any insight into this rather odd problem would be appreciated. Jay Sudowski - Handy Networks LLC TEL: 877-70-HANDY FAX: 888-300-2FAX URL: www.handynetworks.com - Providing reseller and dedicated Windows 2000 web hosting solutions. ~~ 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: Messy Administrator
Hi Darren, Sounds like you don't have cookies enabled, or for some reason the Admin is loosing track of your session, which is why you can see the first frame, but any subsequent requests are denied, and you get the login page. Jay Sudowski - Handy Networks LLC TEL: 877-70-HANDY FAX: 888-300-2FAX URL: www.handynetworks.com http://www.handynetworks.com - Providing reseller and dedicated Windows 2000 web hosting solutions. -Original Message- From: Darren Labrum [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 04, 2001 3:44 PM To: CF-Talk Subject: RE: Messy Administrator Hey Daryl, Thanks for the reply. I didn't explain the problem very well but is what it does is it will bring up the normal log in screen that asks for the password. The administrator in CF 5 is broken into frames. So when I log in it tries to show the previous log in screen in all those frames. It looks funky... Then after a few seconds it will redirect me to the original log in. Any way, thanks again for the reply. Also, my mother was born in Belfast, N.Ireland. She grew up there until she was 18 then came to America. Half my family is still in that area also. Thanks, Darren Labrum -Original Message- From: Daryl Fullerton [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 04, 2001 1:30 PM To: CF-Talk Subject: RE: Messy Administrator Darren, Do you mean it attempts to download the second page once you login? If so its a mapping extension that is not setup on IIS for .cfm filesme thinks Cheers D Daryl Fullerton, Managing Partner, BizNet Solutions, Allaire Premier Partner (Ireland) 133 - 137 Lisburn Road Belfast BT9 7AG N.Ireland Direct +44 (0) 28 9022 7888 Tel +44 (0) 028 9022 3224 Fax +44 (0) 028 9022 3223 [EMAIL PROTECTED] Http://www.BizNet-Solutions.com [EMAIL PROTECTED] (Chairman) Http://www.cfug.ie The Irish Cold Fusion User Group -Original Message- From: Darren Labrum [mailto:[EMAIL PROTECTED]] Sent: 04 August 2001 20:21 To: CF-Talk Subject: Messy Administrator Hey there, I am having problems with the ColdFusion administration screen. When I log in it looks like the attached file. What is this all about? Has anyone had this happen to them? I have reinstalled CF server and it still does it? I don't know what to do. If anyone has had this occur or knows what is going on please notify me. Thanks, Darren Labrum Infovision, Inc. email: [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: default.ida?
FWIW, I don't believe that Michael is being infected. I remember reading somewhere, that if the machine was vulnerable to the expliot, the code execution would occur before the request was ever written to the log file, and thus there would be no trace of it. On the flip side of things, if the machine is trying to be compromised unsuccessfully, but the proper protection is in place (patch, or remove .idq / .ida from IIS mappings) then the request will show up in the log file. Jay Sudowski - Handy Networks LLC TEL: 877-70-HANDY FAX: 888-300-2FAX URL: www.handynetworks.com http://www.handynetworks.com - Providing reseller and dedicated Windows 2000 web hosting solutions. -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 02, 2001 9:18 AM To: CF-Talk Subject: Re: default.ida? Michael Lugassy wrote: I keep seeing on the log files some default.ida request. are those hacking attempts? what is this file do? You've got to be kidding. Doesn't Code Red ring any bells? Jochem ~~ 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: Reboot windows 2K server?
Michael, There's shutdown.exe, included in the Win2K Server Resource Kit. You can also use iisreset /reboot. Jay Sudowski - Handy Networks LLC TEL: 877-70-HANDY FAX: 888-300-2FAX URL: www.handynetworks.com http://www.handynetworks.com - Providing reseller and dedicated Windows 2000 web hosting solutions. -Original Message- From: Tangorre, Mike [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 02, 2001 9:55 AM To: CF-Talk Subject: Reboot windows 2K server? is there a tool available for rebooting windows 2K server? Michael T. Tangorre Web Applications Developer Office Phone: 703-558-4746 Cellular Phone: 607-426-9277 AIM: CrazyFlash4 Personal Email: [EMAIL PROTECTED] Work Email: [EMAIL PROTECTED] School Email: [EMAIL PROTECTED] This Email contains MillenniuM Information Systems, LLC Privileged Information which is Customer or Business Sensitive. -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 02, 2001 9:52 AM To: CF-Talk Subject: RE: Auto-reboot a server Download the resource kit suppourt tools 4.0 for nt server - theres an app in there called Shutdown - set a scheduled task to run shutdown /c /r and it will force a reboot... I think this is it: http://www.microsoft.com/ntserver/nts/downloads/recommended/ntkit/defaul t.as p -Original Message- From: John Fix 3rd [mailto:[EMAIL PROTECTED]] Sent: 02 August 2001 14:47 To: CF-Talk Subject: OT: Auto-reboot a server Is there a utility that I can run with NT scheduler that will restart an NT server? I'm trying to track down some memory leaks, but if I can't solve it before vacation time I want to just set up a way to restart the server every few days at some time in the early am. Thanks! John www.big-box.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: Reboot windows 2K server?
Matt - Just for clarification, iisreset /reboot is a Windows 2000 native utility, that's included with the base installation of IIS completely free, and actually works. We used to restart all web / IIS / ColdFusion related services nightly as well, until W3SVC would refuse to stop properly. To get things functioning properly, I would have to kill inetinfo and then restart IIS. Has anyone else encountered this problem, or have any suggestions on how I might avoid it? Perhaps there's a command line modifier to net stop that increases the time out? TIA, Jay Sudowski - Handy Networks LLC TEL: 877-70-HANDY FAX: 888-300-2FAX URL: www.handynetworks.com http://www.handynetworks.com - Providing reseller and dedicated Windows 2000 web hosting solutions. -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 02, 2001 3:41 PM To: CF-Talk Subject: RE: Reboot windows 2K server? Mike, As you've already found out, that CFX tag doesn't work. If you want to use a native Win service to do this you have to buy the resource kit. I was able to find a routine called ExitsNT that did work, but its built in scheduler stopped functioning after a time... plus it shows up in the system tray, regardless of whether you tell it not to show up there. I found out the hard way that if you weren't *very* careful while using that icon's right-click menu you could initiate a complete shutdown -- not a restart. One slip of the mouse and you're on the phone to your colo guys with a virtual Stoopid sign rightfully hanging around your neck. I've had a lot more luck with a scheduled comprehensive services stop/start batch file. Individually shutting off all web-related services (not just CF) and restarting them has given me the ability to avoid full restarts for fairly long intervals (as Windows servers go :D). @echo on net stop firedaemon service: servu net stop Mysql net stop Cold Fusion Executive net stop Cold Fusion Application Server net stop Statistics Server net stop Imail Web Service net stop Imail POP3 Server net stop Imail SMTP Server net stop World Wide Web Publishing Service net stop IIS Admin Service echo . net start IIS Admin Service net start World Wide Web Publishing Service net start Statistics Server net start Imail SMTP Server net start Imail POP3 Server net start Imail Web Service net start Cold Fusion Application Server net start Cold Fusion Executive net start Mysql net start firedaemon service: servu Good luck, --- Matt Robertson[EMAIL PROTECTED] MSB Designs, Inc., www.mysecretbase.com --- -- Original Message -- from: Tangorre, Mike [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Thu, 02 Aug 2001 14:27:37 -0400 Thanks John! I actually looke din the tag gallery, and had tried that tag about 2 weeks ago..and knew it didn't work. :-) Oh well, I always like the quote, There are no dumb questions, just dumb people for not asking questions Anyways... Thanks again. Michael T. Tangorre Web Applications Developer Office Phone: 703-558-4746 Cellular Phone: 607-426-9277 AIM: CrazyFlash4 Personal Email: [EMAIL PROTECTED] Work Email: [EMAIL PROTECTED] School Email: [EMAIL PROTECTED] This Email contains MillenniuM Information Systems, LLC Privileged Information which is Customer or Business Sensitive. -Original Message- From: John Lucas [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 02, 2001 2:10 PM To: CF-Talk Subject: RE: Reboot windows 2K server? As long as we are being snippy...I doubt a tag from 98 is going to do the trick. snip from docsThis tag was designed for Windows NT, using InitiateSystemShutdownA from the Windows API. As far as I know, it will not work under Windows 95. Not sure about Windows 98, but I doubt it. If anyone finds out differently, let me know. /snip As far as searching the tag gallery first, cut him some slack. If all the answers were in the tag gallery, the threads would be. Post 1: Ask my question Post 2: Go Look it up in the tag gallery At least if you are going to make the statement along the lines that there is a tag in the tag gallery, you should have searched there first, then you should at least have looked further into the tag before making such a blanket statement. -Original Message- From: Zachary S. Bedell [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 02, 2001 12:26 PM To: CF-Talk Subject: RE: Reboot windows 2K server? Not to be snippy, but please try searching the tag gallery before posting questions like this. Searching for 'reboot' in the Allaire tag gallery comes up with CFX_RestartMachine as it's second result. Here's the direct link to the tag: http://devex.allaire.com/developer/gallery
RE: SQL SERVER 7
Hi Jerry - Why not use DTS and schedule the task to run on intervals. I think that would be the easiest way to do things. Jay -Original Message- From: Jerry Staple [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 12:16 PM To: CF-Talk Subject: SQL SERVER 7 Hi, Could anyone give me any feedback on the following: We have a SQL Server say for example SQL1 based in Belfast, and another SQL Server SQL2 Based in London. What i need to do is write a stored procedure from a database in SQL1 Table1 to insert data into SQL2 Table2,i have a few ideas but any tips and feedback would be most apreciated. Thanks In Advance Jerry Staple Web Applications Developer BizNet Solutions 133 - 137 Lisburn Rd Belfast BT9 7AG Tel: +44 (0)28 9022 3224 Fax: +44 (0)28 9022 3223 www.biznet-solutions.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: Data-modeling for anniversaries...
Hi David, You might want to check into the DatePart function - (the Access DatePart function, not the CF DataPart function. They both work the same way, but have slightly different syntax). cfquery name=weeklyAni datasource=whatever Select name, anidate from ani where AniDate = DatePart(ww, now()) /cfquery HTH. Jay Sudowski - Handy Networks LLC TEL: 877-70-HANDY FAX: 888-300-2FAX URL: www.handynetworks.com http://www.handynetworks.com - Providing reseller and dedicated Windows 2000 web hosting solutions. -Original Message- From: David Grabbe [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 3:17 PM To: CF-Talk Subject: RE: Data-modeling for anniversaries... Is there a way to do the same thing in Access2000? David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 3:09 PM To: CF-Talk Subject: RE: Data-modeling for anniversaries... I would use a series of database functions to turn the original date into a date in the current year, like this (Oracle-ish code since I don't know what DB you're using but am too lazy to find the exact syntax): to_date (to_char(aniv_date_field, 'm-d') + '-' + currentyear(), 'm-d-' ) now I have a date field and can compare to today and today + 7 days. -Original Message- From: David Grabbe [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 1:31 PM To: CF-Talk Subject: Data-modeling for anniversaries... I've run into a data-modeling stumper. I have a database table which contains wedding anniversaries and the respective couple's name. The date is stored as the wedding date, so calculating the anniversary is easy. The primary usage of this is to display the anniversaries on a monthly calendar. However, now i need to select just the anniversaries which will be coming up in the next week. The problem is that since the dates are stored with the original years (i.e. 11/28/1970), I can't just select the dates that are between a specific date range, because the year will throw that all out of whack. So how can i select based just on the month/day, also taking into account that in the middle of the week the month can change to the next month (November-December)? Any ideas? Cheers, David ~~ 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
Code Red Worm: Deadline For Action
I know this is slightly off topic, but since most people are running CF Server on top of WinNT or Win2000, it's highly relevant. CERT believes that Code Red is likely to start spreading again on July 31, 2001, 8:00 PM EDT and has mutated so that it may be even more dangerous. If you are running a Windows NT, or Windows 2000 server and have not patched your system, or removed Index Server mappings from IIS to protect yourself, you need to take immediate action, and either patch your servers yourself, or inform the proper IS / IT people so that the servers can be patched. Here's the official CERT advisory - http://www.cert.org/archive/html/coderedannounce.html Here's the URL to the patch - Windows NT version 4.0: http://www.microsoft.com/Downloads/Release.asp?ReleaseID=30833 Windows 2000 Professional, Server and Advanced Server: http://www.microsoft.com/Downloads/Release.asp?ReleaseID=30800 Idiot Proof Directions on How to Install the Patch - http://www.digitalisland.net/codered/ MS's Security Bulletin - http://www.microsoft.com/technet/treeview/default.asp?url=/technet/secur ity/bulletin/MS01-033.asp Please, patch your systems! Don't be lazy about this, don't procrastinate, just do it! Jay Sudowski HANDY NETWORKS, LLC Tel.: 1-877-70-HANDY Fax: 1-888-800-2FAX http://www.HandyNetworks.com http://www.HandyNetworks.com ICQ 15601511 | AIM Jay Suds - Specializing in Windows 2000 Hosting Solutions Reseller / Managed Dedicated / Colocation Services ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF 5.0 Installation Problems...
Hi Neil, This happened when we tried to upgrade as well. I'm not precisely sure what I did, but finally the installer did open up. I believe I rebooted, stopped all CF services, all IIS services, launched the installer, and then just waited about 5 minutes until it finally came up. The RAM usage of Ikernel.exe skyrocketed the final attempt, but then came crashing down, and then the installer finally launched. Hope this helps. Jay -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 11:06 AM To: CF-Talk Subject: CF 5.0 Installation Problems... When attempting to install CF 5.0 nothing happens! Let me explain: It does mention that CF 4.5 is installed and that it will be upgraded. That is fine. But then nothing. I watch Ikernel.exe, which is Install Shield, just consume memory. The only way to kill it is to end the task in task manager. Once I do that I receive an error about the RPC service is unavailable. The RPC service is running so I don't know what is happening. I manually stopped CF executive and application server in addition to site minder. This made no difference. If anyone has any ideas they would be appreciated. Thanks, Neil ~~ 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 7.0
Just how big do you need to go? -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 12:05 PM To: CF-Talk Subject: RE: SQL 7.0 Sorry I need something bigger than both of these ntext and text provide!! -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Saturday, 28 July 2001 1:54 AM To: CF-Talk Subject: RE: SQL 7.0 Text ~~ 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: WWW-logfiletimestamp is 2 hours behind system time
Hi Uwe, IIS log files use GMT, which is why your log files would be two hours behind your system log files. Hope this helps. Jay Sudowski - Handy Networks LLC TEL: 877-70-HANDY FAX: 888-300-2FAX URL: www.handynetworks.com http://www.handynetworks.com - Providing reseller and dedicated Windows 2000 web hosting solutions. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 21, 2001 5:24 PM To: CF-Talk Subject: OT: WWW-logfiletimestamp is 2 hours behind system time Hi list, I have a strange problem. The system-time on our Win NT 4 - Server (which is correct !!) is two hours ahead of the log-file-time (timestamps) of our WWW-Server (IIS 4) (which is wrong !!). Who could this possibly be and how can I fix this ? I didn't see any options to change it in the MMC on NT. Thanks for ideas. Uwe ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WWW-logfiletimestamp is 2 hours behind system time
Hi Uwe, Not sure, but do you have anything like Daylight Savings over there? Also, check to make sure that your server is in the right time zone? See this URL for more info. http://support.microsoft.com/support/kb/articles/Q271/1/96.ASP?LN=EN-US; SD=gnFR=0qry=log%20file%20timernk=1src=DHCS_MSPSS_gn_SRCHSPR=IIS50 Jay Sudowski - Handy Networks LLC TEL: 877-70-HANDY FAX: 888-300-2FAX URL: www.handynetworks.com http://www.handynetworks.com - Providing reseller and dedicated Windows 2000 web hosting solutions. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 21, 2001 5:39 PM To: CF-Talk Subject: AW: WWW-logfiletimestamp is 2 hours behind system time Thanks Jay and John. I thought the same. But GMT would be 1 hour less than my system time. But if, how can I change it ? Is it possible ? Uwe -Ursprüngliche Nachricht- Von: Jay Sudowski - Handy Networks LLC [mailto:[EMAIL PROTECTED]] Gesendet: Samstag, 21. Juli 2001 22:36 An: CF-Talk Betreff: RE: WWW-logfiletimestamp is 2 hours behind system time Hi Uwe, IIS log files use GMT, which is why your log files would be two hours behind your system log files. Hope this helps. Jay Sudowski - Handy Networks LLC TEL: 877-70-HANDY FAX: 888-300-2FAX URL: www.handynetworks.com http://www.handynetworks.com - Providing reseller and dedicated Windows 2000 web hosting solutions. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 21, 2001 5:24 PM To: CF-Talk Subject: OT: WWW-logfiletimestamp is 2 hours behind system time Hi list, I have a strange problem. The system-time on our Win NT 4 - Server (which is correct !!) is two hours ahead of the log-file-time (timestamps) of our WWW-Server (IIS 4) (which is wrong !!). Who could this possibly be and how can I fix this ? I didn't see any options to change it in the MMC on NT. Thanks for ideas. Uwe ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: PWS for Win2000?
The web server bundled with Win2K Pro is really a cripple-ware version of IIS5. It only allows you to configure one site, and will only accept a few simultaneous connections at once. (The documentation says 10 concurrent connections, but the real world number seems to be 2 or 3). Personally, I've found that the Win2K Pro version of IIS5 isn't the best solution for development work, especially if you are running cfhttp commands against your own machine - IIS will throw an access denied error because too many users are accessing the site simultaneously. Also - if you are working in a LAN environment with a few other people, they may receive the same error denied error. Another word to the wise ... IIS5 in Win2K Pro has ALL of the same security issues as II5 for Win2K Server, thus you really should harden your Win2K Pro as if it's an Internet server, if the machine is serving up any requests that come from the Internet. At the very least, run Win2K SP2 and unmap all of the extensions except for .cfm. You wouldn't want to unknowingly become a DDoS zombie, or Red Worm victim. Hope this helps. Jay Sudowski HANDY NETWORKS, LLC 90 Great Neck Road Waterford, CT 06385 Tel.: 1-877-70-HANDY Fax: 1-888-800-2FAX http://www.HandyNetworks.com http://www.HandyNetworks.com ICQ 15601511 | AIM Jay Suds - Specializing in Windows 2000 Hosting Solutions Reseller / Managed Dedicated / Colocation Services -Original Message- From: Nick McClure [mailto:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 4:34 PM To: CF-Talk Subject: Re: PWS for Win2000? It is still Personal Web Server, they just call it IIS. If you goto the Add Remove Software Control Panel and click the Windows Components Button on the left side you can add IIS. It is basically PWS with a new name. At 03:11 PM 7/20/2001 -0500, you wrote: I know there is no PWS for Win2000 Pro but what do I use to locally host sites using CF single user server on a laptop for demos and development off the lan? Where/how do I set this up? Can anybody point me to the correct resource so I can find out how to add this service? Thanks a lot! Justin Hansen - [EMAIL PROTECTED] Web Application Developer Interactive Business Solutions, Inc 816-221-5200 ext. 1305 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF5 Single User Server ?
Hi Justin - The evaluation versions of CF Server 5 should revert to single user after the 30 day period is up. I'm not 100% positive on this, but I remember our CF5 Enterprise installer (mind, this was a retail package) giving us the option of not providing a serial number, which would install the server in evaluation mode, and then the server would revert to single user mode after 30 days. Jay -Original Message- From: Justin Hansen [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 19, 2001 2:48 PM To: CF-Talk Subject: CF5 Single User Server ? Is there a Single User Server version of CF5? Justin Hansen - [EMAIL PROTECTED] Web Application Developer Interactive Business Solutions, Inc 816-221-5200 ext. 1305 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: I have to ask
You use ColdFusion as the backend for the mailing list? That's pretty crazy ... -Original Message- From: [EMAIL PROTECTED] (Michael Dinowitz) [mailto:[EMAIL PROTECTED] (Michael Dinowitz)] Sent: Wednesday, July 18, 2001 10:57 PM To: CF-Talk Subject: Re: I have to ask The slashes have to be due to your email reader. The comma changing things around is due to the CFX_iMSMail tag that I'm using to send the mail along in place of the CFMAIL tag. I'm looking into it. What's with all the email addresses with \. Such as: \Warrick,Mark\ [EMAIL PROTECTED] \Al Musella,DPM\ [EMAIL PROTECTED] I am seeing a bunch of them today I never saw them before... It can't be just a coincidence. TIA Dick ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Database Question??
Hi Scott - I think it could vary from store to store - because in some states the sales tax varies from county to county. I know in CA the rate varies depending on where the business is located. (Or, at least, I think it works like this. I could be mistaken). Jay -Original Message- From: Scott Brady [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 18, 2001 11:34 PM To: CF-Talk Subject: Re: Database Question?? Umm . . . why does each store need its own sales tax rate for each state? Does the sales tax vary from store to store? Scott - Scott Brady http://www.scottbrady.net/ - Original Message - From: Rich Tretola [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 18, 2001 9:33 PM Subject: Database Question?? I would like to run multiple stores through the same database. This is why I added the a storeid field making the fields State, TaxRate, StoreID. The only problem is that I would need to add 51 records for each store I add. Does anyone have a better idea on how I could setup this table? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
FW: Initial analysis of the .ida Code Red Worm
Hi - Here's some more information about the most recent IIS worm, which was posted to NTBugTraq earlier today. Hope this helps someone. Jay -Original Message- From: Marc Maiffret [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 17, 2001 2:18 PM To: [EMAIL PROTECTED] Subject: Initial analysis of the .ida Code Red Worm The following information was researched by Ryan Permeh ([EMAIL PROTECTED] and Marc Maiffret ([EMAIL PROTECTED] of eEye Digital Security. We would like to specially thank Matthew Asham of Left Coast Systems Corp and Ken Eichman of Chemical Abstracts Service for providing us with logs and needed data to make this analysis possible. Introduction On Friday July 13th we received packet logs and information from 2 network administrators that were experiencing large amounts of attacks targeting the recent .ida vulnerability that eEye Digital Security discovered (http://www.eeye.com/html/Research/Advisories/AD20010618.html) on June 18, 2001. From the first analysis of the logs that were sent to us we were able to deduce that in fact it looked as if someone had released a worm for the ..ida vulnerability. Within the logs we could see connection attempts from over 5 thousand IIS 5 web servers targeting various other IIS web server and sending a .ida exploit to each of them. Evidence also showed that compromised hosts were being used to attack other hosts. We've designated this the .ida Code Red worm, because part of the worm is designed to deface webpages with the text Hacked by Chinese and also because code red mountain dew was the only thing that kept us awake all last night to be able to disassemble this exploit. Details --- Note: Details are going to be short for now. We plan on releasing a full analysis of the worm but felt that it was important to get this message out ASAP as this worm is starting to affect a lot of people. The standard injection vector is a exploit that uses the .ida buffer overflow to execute code (as SYSTEM) on vulnerable remote systems. The worm performs the following on infected systems: * Spawns 100 threads which are used to scan for new IIS web servers to infect * Checks for the existence of c:\notworm and if it is found then it does not try to propagate itself to other hosts. * Defaces web pages with the message: htmlheadmeta http-equiv=Content-Type content=text/html; charset=EnglishtitleHELLO!/title/headbadyhr size=5font color=redp align=centerWelcome to http://www.worm.com !brbrHacked By Chinese!/font/hr/bady/html Analysis Note: Again this is a quick brief analysis, more detail will follow. Upon infection the infected host will spawn 100 threads in a loop. This loop checks for the existence of c:\notworm and if the file does not exist then the worm will proceed to start scanning for vulnerable servers to infect. The worm does scan for random IP addresses. However, the worm uses the same seed for randomization of IP addresses. This means that each new infected host will start at the same IP and continue scanning further down the same track of IP's as every other infected host. The ramifications of this are severe because this means that hosts early in this randomized IP sequence will be hit over and over as new hosts are infected. This creates the potential for a denial of service against early IP addresses in the sequence. Also, evidence has proved that hosts can be infected multiple times therefore creating a drain on system resources. However, normal worm operation seems to have a cut off point as to how many times a host will be re-infected. Early analysis seems to suggest that the worm has a limit of 3 reinfections however that may have just been by chance in our test scenario. Other in house tests of the infections have shown that internal thread rate limiting seems to be broken in certain situations. Which means that some infected systems will continue to spawn new threads until system resources become so low that the entire web server computer crashes or becomes unusable. Summary --- We will be releasing a full detailed analysis, complete with disassembled worm code and comments within the code. We have had reports from a few network administrators that their IDS systems have seen this .ida attack originating from over 5 thousand unique source addresses within a 3 day time span. Hosts early in the IP sequence will be hit with a traffic based denial of service and those hosts vulnerable to this worm will most likely grind to a halt. How to secure your system from this .ida attack --- Microsof patch for this .ida vulnerability http://www.microsoft.com/technet/treeview/default.asp?url=/technet/secur ity/ bulletin/MS01-033.asp eEye Digital Security Advisory http://www.eeye.com/html/Research/Advisories/AD20010618.html The following is part of the packet data that is sent for this .ida Code Red worm attack:
RE: debugging info display and CF5
Hi Kay - I don't think what you want to do is possible. Also - something to consider - when you add all of the IPs manually to the CFAS, everyone in your organization will see your debug info, and they might not appreciate seeing all the debug info. It's also a security issue, depending on what debug info you are showing. You should try to get a dedicated IP from you IT / IS people. Depending on what DHCP server your company is using, you may be able to have your IT / IS people setup a DHCP reservation, which corresponds to your MAC address. So - as long as you login from the same computer each time, you should get the same IP address over and over again. HTH. Jay Sudowski -Original Message- From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 18, 2001 12:35 AM To: CF-Talk Subject: debugging info display and CF5 Hi all, Does CF5 allow you to specify a range of IP addresses to receive debugging info? Everytime I log into our network I get a different IP in our range... so then I have to turn it on to all IPs, then find out what mine is and set it to allow just that. It's really annoying. And I don't want to manually put in all the possible values I could have because that would be a nightmare. Regards, Kay. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Cold Fusion Search tools
Just gave him a call ... on my dime - only got voicemail. - Jay Anybody in the 303 area code wanna give this guy a wake-up call?? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of David Clay Sent: Wednesday, May 17, 2000 1:14 PM To: [EMAIL PROTECTED] Subject: Re: Cold Fusion Search tools I will be out of the office from Wednesday, 5/17 - Friday 5/19. If a page or part of the website is not functioning correctly, please call 303.770.8506 and provide your name, phone number and what is not functioning in as much detail as possible. Thank you. Dave Clay Web Facilitator -- -- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Session vars in a clustered environment
Howard, I've never used session vars in a clustered server setup, but I've read a lot about doing it, so here goes nothing :-) I've never worked with session variables on clustered servers. I read somewhere ... and can't remember where ... that I might have a problem here. You can setup the clustering server to use Sticky Sessions - though, this isn't a truely load balanced solution. Using load balancing, the idea is that the load will be distributed over all the servers in the cluster. With sticky sessions, that happens only to a certain extent - once a user is assigned to a server, the user stays on the server, regardless of the load so that the session vars are preserved. What I want to do is have my forms (as I mentioned in a previous post) transform form vars over a series of submissions into session vars and then collect the session vars at the end for input into the db. But this app is going to live on a server cluster. Can I still do this? If you're using Sticky Sessions, it should be fine. What about client vars? Aren't session vars stored in RAM and client vars in the registry (unless otherwise specified)? And because of that, aren't they confined to a single machine? Configure CF server to store client variables in a database - storing client vars in the registry is a bad idea in any setup beacuse if the registry hits its max size, all sorts of undesireable things will happen :-(. In a clustered setup, if you setup CF to store the cient vars in the db, they should be accessble to all the servers in the cluster. - Jay What are my alternatives? H. = Howard Owens Web Producer InsideVC.com mailto:[EMAIL PROTECTED] = -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Session vars in a clustered environment
Cfif Client.IsLoggedIn neq 0 cfset client.IsLoggedIn = now() /cfif What's neq an abbreviation for? Thanks, Jay -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Session vars in a clustered environment
LMAO - Original Message - From: "Todd Ashworth" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 16, 2000 7:46 PM Subject: Re: Session vars in a clustered environment lol .. speaking of which .. I did a search for "sticky sessions" and the first hit I got was for: 1. Lindsey Dawn Mckenzie http://www.marketplace.co.uk/videos/lindsey_dawn.html Lindsey Dawn Mckenzie stars in these sizzling hot sex videos hehe .. now .. if only we were able to find *those* kinds of sticky session hardware in our server racks ;) - Original Message - From: paul smith [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 16, 2000 6:13 PM Subject: RE: Session vars in a clustered environment At 05:39 PM 5/16/00 -0400, you wrote: Also known as "sticky sessions." !--- Insert dirty joke here --- You first ;-) -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Hi
Dave / Jake - Just checked the mem usage on my cf server - over 80 megs! Whoa. That's never good. Of course, that was in a shared hosting environment, so people are probably running all sorts of junk code. After restarting the CF services, mem usage droped down to 16 megs. Oh yah - that was on Win 2000 / CF 4.5 Pro Looks like I'll be restarting cfserver more often ;-). - Jay - Original Message - From: "David Hannum" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, May 14, 2000 8:45 PM Subject: Re: Hi And cold fusion eats up 10x the memory that ASP did. I haven't even really run any programs except the sample ones and the cfserver.exe was using 30 megs of ram on nt2k Jake, It's gotta be something in your setup. We use CF for some very processor intensive apps, and we NEVER reach anywhere near that kind of RAM usage. The most I've ever seen the meter hit was about 18meg - and I had the thing caught in a loop. (NT4.0 SP5 running CF Enterprise 4.01). I think you'll find CF quite capable of running the "complex" tasks mentioned by Steve as well as ASP. Dave - Original Message - From: Jake Hileman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, May 14, 2000 7:06 PM Subject: Re: Hi Boom! That's exactly why I switched... right now I'm looking for a good resource. ASP has activerserverpages.com, aspin.com etc.. cold fusion falls short in that area. And cold fusion eats up 10x the memory that ASP did. I haven't even really run any programs except the sample ones and the cfserver.exe was using 30 megs of ram on nt2k. My inetinfo which is running asp apps while we speak was only using 7 megs. :-( That really stinks. Anyhow I'm looking for some resources and a good, free or inexpensive shopping cart.. one like www.ihtmlmerchant.com .. something comparable to that! Thanks, Jake - Original Message - From: "Steve Minton" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, May 14, 2000 6:59 PM Subject: RE: Hi The reasons that I decided to turn to CF are: 1) While ASP is great for complex programming tasks, it is awkward and unwieldy for simple tasks such as merely presenting data from a database. 2) Whilst considering CF, I also took a brief look at PHP3, although I found that this would not be suitable for my needs, as its integration with MySQL is too complex. I also primarily work on a Windows based platform and therefore prefer the ODBC support offered by this system. 3) Finally, CF actually looks *fun* to use! It has a good structured development environment (CF Studio) which is where ASP sorely falls short - although there are rumours that MM Ultradev will go some way to resolving this. Regards Steve Minton [EMAIL PROTECTED] -Original Message- From: Tom Harris [mailto:[EMAIL PROTECTED]] Sent: 14 May 2000 21:46 To: [EMAIL PROTECTED] Subject: Re: Hi Steve: I'm sure everyone wants to know... what are the specific reasons you decided on CF? Tom - Original Message - From: "Steve Minton" [EMAIL PROTECTED] To: "Cf-Talk" [EMAIL PROTECTED] Sent: Sunday, May 14, 2000 4:08 PM Subject: Hi Hi Everyone I'm new to this list and just thought I'd briefly introduce myself. My name is Steve Minton and I am a Senior Web Designer/Developer, with Development skills in ASP (3 years). However, I felt the time had come to learn something new, and decided upon Cold Fusion. You will therefore be hearing a lot from me over the coming weeks ;-). Of course if anyone has any ASP queries then feel free to give me a shout. Regards Steve Minton [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- -- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit
Re: CFML be gone!
Todd, Nice question - I'm interested in a tag / functions / pain-in-the-but- work-around that would remove just the CFML tags. Previous to your post, I failed to realize that if I allow people to submit HTML tags along with their text, they could also submit CFML tags, creating a major security hazard. :-( Any ideas, great and wonderful CF gurus? - Jay - Original Message - From: "Todd Ashworth" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 09, 2000 10:07 AM Subject: CFML be gone! I have some forms where people can dump text into a dtabase that is then displayed on another page. I do wish to allow HTML to be submitted, for formatting if they desire, but I DO NOT want them to be able to submit CFML, since I have CFFILE and CFDIRECTORY enabled .. and so-on. I have found several tags that remove HTML or HTML and CFML .. Is there a tag that only removes CFML? Would there be any reason not to allow them to submit HTML as well? If so, is there a way to limit the HTML to only the basic formatting tags (font, p, br, etc.)? .Todd -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Decryption? RE: how to encrypt the entire CF page?
Not sure about this, but can't you call Allaire and have them decrypt the files for you? Someone has mentioned before that they have they cfdecrypt util in house. You might have to pay them some, but depending on the amount of code you have encoded, it's probably well worth it. - Jay - Original Message - From: "Bill Killillay" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 09, 2000 9:54 PM Subject: RE: Decryption? RE: how to encrypt the entire CF page? There is a way out there, but this list is very, Very, VERY guarded about it. I did find it, but it gave over 180 errors when trying to compile it with a C compiler and the des.h header/library that was used with it. So if you can get it to work, your doing good. I don't know what my problem was, probably the des.h file, but I just don't know. Just do a search on cfdecrypt. Good luck, let me know how your endeavors go. -Original Message- From: Allen B. Russell III [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 09, 2000 6:27 PM To: '[EMAIL PROTECTED]' Subject: Decryption? RE: how to encrypt the entire CF page? Does anyone have tools to decrypt cfm files that have been encrypted by others (past employees, etc?) Need some help. Thanks -Original Message- From: Nathan Chen [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 04, 2000 10:12 PM To: [EMAIL PROTECTED] Subject: Re: how to encrypt the entire CF page? There is a syntax for encrypting at the end of the "CFML Language Reference" book that comes with CF server. Ins wrote: Hi, Does anyone know how to encrypt the entire CF page as follows (not only encrypt some strings in the template)? In case the CF page is downloaded by others. Thanks Ins - Allaire Cold Fusion Template Header Size: 54 . n ¤R¬G#8212;îë#8216;.%;ã¶.."Rl#8225;#8222;â#8217;Tz.K#8249;cèk #8222;/Le ¦Å.Âáï.b.#8482;,n¹ðîDëÉ¢Æú3.#8224;#381;:Êz#376;0P×êú.(.=#824 9;-á8Dü28£ %)¬¶£@ò¯Åâà¯ÂYÅ...ØDC#338;.#8249;å#8250;`, ÍO^#402;#8212;$å#8364;ò'ü=~ÕNEßRzg#353;.¿#8230;Zõ.#352;'#8218; Ù÷ ..ÚÑ´Àu2®#8249;à~ò 4LÞnE. |#339;¾æ »#8249;~ÜÐvÃa?.áîÐfÇϯä».°×b¥¾ä.S4åäfTø.BS À Qù __ __ _ http://movies.yahoo.com.au - Yahoo! Australia NZ Movies - Find out what's on at the local cinema with Yahoo! Movies -- -- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Nathan Chen (208)-426-8470 Computer Control Systems, Inc. -- -- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_tal k or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: session variable blues
Spencer, You'll have to set your form variables as sessions variables on screen2.cfm before you can output them ... cfset session.lname = form.lname cfset session.fname = form.fname cfset session.email = form.email cfset session.phone = form.phone cfset session.coname = form.coname cfset session.title = form.title cfoutput Name: #session.fname# #session.lname#, #session.title#br Company: #session.coname#br Phone: #session.phone#br E-mail: a href="mailto:#session.email#"#session.email#/abr /cfoutput That should do it :-) - Jay Okay I'm a newbie and I'm having some trouble using session variables. They are not being stored it seems and therefore not being passed from template to template as the user moves through the app,. My application file looks like this cfapplication name="whatever" clientmanagement="Yes" sessionmanagement="Yes" setclientcookies="Yes" sessiontimeout="#createtimespan(0,0,20,0)#" applicationtimeout="#createtimespan(1,0,0,0)#" !--params for clientinfo table-- cfparam name="session.lname" default="" cfparam name="session.fname" default="" cfparam name="session.email" default="" cfparam name="session.phone" default="" cfparam name="session.coname" default="" cfparam name="session.title" default="" Then the folowing templates ask for the user to input their names etc. in form fields where they get stired for the duration of the visit. like so; form action="screen2.cfm" method="POST" input type="Text" name="lname" size="25" value="":Last Namebr input type="Text" name="fname" size="25" value="":First Namebr input type="Text" name="email" size="25" value="": Emailbr input type="Text" name="phone" size="25" value="": Phone Numberbr input type="Text" name="coname" size="25" value="": Company Namebr input type="Text" name="title" size="25" value="": Titlebr input type="Submit" value="next" screen2.cfm; cfoutput Hello #session.fname# #session.lname#br Your email address is : #session.email#br /cfoutput etc. But the varibles entered on screen1 are not being passed to screen2.cfm? Now this should be really simle but I must be missing something. Can somebody please help me out. I would be eternally grateful. Thanks spencer the newbie -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: QUESTION: VERY weird email from Allaire
Hi Emily, If you're an Allaire Alliance member, Allaire will periodically send you "free" stuff, which gets entered into their shipping system as an "order". I recently got a shipment with CF 4.51 materials - Jay - Original Message - From: "Childress, Emily" [EMAIL PROTECTED] To: "'CF'" [EMAIL PROTECTED] Sent: Saturday, May 06, 2000 1:30 PM Subject: QUESTION: VERY weird email from "Allaire" Did anyone else on this list get an odd email from Allaire? I am wondering if this whole virus thing is manifesting itself into sending out emails from users claiming to be legitimate businesses. The sender is "[EMAIL PROTECTED]" and it's confirming my "recent order". There is no attachment but what the !@#$??? I haven't ordered anything from Allaire in months and there is no mention what what it is I ordered... Any clues? thanks, -e Emily Ellen Childress Corporate Web Development USinternetworking, Inc. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFmail Prob
Hi Everyone, I'm at wits end here - I've got two different sites on the same machine, using CFmail - one of the sites can send mail fine, with the other site, all the mail ends up in the undeliverable queue and I keep on gettting this error in th mail.log file ... "Error","TID=1044","05/05/00","00:26:36","Failed to send the spooled mail file, C:\CFUSION\MAIL\spool\1F8.cfmail. SMTP server replied "Unexpected error. Facility=Mail Code=-2147467259" Moved file to C:\CFUSION\MAIL\undelivr\1FA.cfmail." I'm using MS SMTP server, CF Server 4.51 Pro on Win 2000. The mail server is configured to relay for everyone. I've grabbed one of the e-mails that sends from the spooler before it got send and compared it to the mail that won't send - everything seems fine in the mail thats not sending :-(. If you're wondering, here's a copy of whats in the spooler x-cf-version: 4.5.0 x-cf-server: 209.68.206.195 x-cf-port: 2525 x-cf-timeout: 60 x-cf-from: [EMAIL PROTECTED] x-cf-to: [EMAIL PROTECTED] Content-type: text/plain Date: Fri, 05 May 2000 00:22:50 -0800 From: [EMAIL PROTECTED] Subject: WWW.StepHere.com - Verify Email To: [EMAIL PROTECTED] Test Arghs! This is highly frustrating and any and I would appreciate any assistance or insight anyone might be able to offer TIA, Jay -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFmail Prob
Heh. Suppose I did. It's just simply a matter of changing the port number or IP. Suppose I tend to do foolish things like that when posting a 4 AM. - Original Message - From: "Howie Hamlin" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, May 05, 2000 9:32 AM Subject: Re: CFmail Prob Not sure why the mail is not going through but you did just announce to the world the address of your open-relay mail server. Howie - Original Message ----- From: Jay Sudowski - Handy Networks LLC [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, May 05, 2000 3:58 AM Subject: CFmail Prob Hi Everyone, I'm at wits end here - I've got two different sites on the same machine, using CFmail - one of the sites can send mail fine, with the other site, all the mail ends up in the undeliverable queue and I keep on gettting this error in th mail.log file ... -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Upgrade 4.01 - 4.5 (and patch) Enterprise trouble?
Rob, As far as I know, the "patches" are full installers - no need to install 4.5 and then move to 4.51. You can just download the "updater", install 4.51 and you'll be good to go. - Jay - Original Message - From: "Rob Sherman" [EMAIL PROTECTED] To: "Cf-Talk" [EMAIL PROTECTED] Sent: Wednesday, May 03, 2000 4:09 PM Subject: Upgrade 4.01 - 4.5 (and patch) Enterprise trouble? Has anyone had any trouble, recommendations precautions going from 4.01 server 4.01 studio to 4.5 Enterprise 4.5 Studio? (I'll apply the 4.5.1 patch after install) I just want to make sure something like snippets don't get lost.. or will I have to uninstall my 4.01 server first ? Any unforeseen stuff ? Sincerely, Rob Sherman -- Developer / Allaire Certified Instructor Email:[EMAIL PROTECTED] ICQ:_3266081 AIM:__RobSSherm Yahoo!:RobSherman_CFDev Office:__(310) 543-1622 Office Fax:__(310) 543-0512 VMail/Fax:__(310) 754-6016 ext. 5630 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
