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
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
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: 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 - 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#') - 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. 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#) ** 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
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=8&BI;=240&UL;=/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
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 5&mode=nocomment&threshol= 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
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
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
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
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 Second template 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: > > > > > > > > > > > > > > > > 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: 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 or 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: 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: 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: 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 :) insert into users(userid,firstname,lastname,email) values(#max_ID#,'#trim(attributes.firstname)#','#trim(attributes.lastnam e)#','#attributes.email#') -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... update dailyimpressions where record = #record# 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
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: 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: 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
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: 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. This 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. 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
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: 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: 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). Select name, anidate from ani where AniDate = DatePart("ww", now()) 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
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
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: 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: 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: 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=gn&FR=0&qry=log%20file%20time&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=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: 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: 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
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: 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
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: HELLO!Welcome to http://www.worm.com !Hacked By Chinese! 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: /default.ida?NNN
CFUG in CT
This is a multi-part message in MIME format. --=_NextPart_000_01C0_01BFCE8F.AEF2DBE0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hey Folks - I know there's supposedly a CFUG in Westport, CT, but that's somewhat of = a drive for me. Does anyone know of a CFUG located in Eastern CT / = Providence, RI? Thanks, Jay --=_NextPart_000_01C0_01BFCE8F.AEF2DBE0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hey Folks - I know there's supposedly a CFUG in = Westport, CT,=20 but that's somewhat of a drive for me. Does anyone know of a CFUG = located=20 in Eastern CT / Providence, RI? Thanks, Jay --=_NextPart_000_01C0_01BFCE8F.AEF2DBE0-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Replacing crlf with
This is a multi-part message in MIME format. --=_NextPart_000_01E6_01BFC738.EB595720 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi - I need to replace the crlf characters with the tag so that line = breaks people enter while editing database content show up when they are = displayed. I found a custom tag that will do this, but I'd like to = avoid calling it multiple times on the same page? Doing this should be possible with the replace function (or so I think), = but I'm not sure how to go about it. Any ideas? Thanks, Jay --=_NextPart_000_01E6_01BFC738.EB595720 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi - I need to replace the crlf characters = with the=20
tag so that line breaks people enter while editing database = content=20 show up when they are displayed. I found a custom tag that will do = this,=20 but I'd like to avoid calling it multiple times on the same = page? Doing this should be possible with the = replace=20 function (or so I think), but I'm not sure how to go about it. Any = ideas? Thanks, Jay --=_NextPart_000_01E6_01BFC738.EB595720-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Caching Queries and CACHEDAFTER
Joseph - I could do that, but it's not very feasible - I can't just go tell my client "well, for the sake of performance, stuff you add to the database will only be available up to 24 hours after you enter it. Also, any edits or deletes you make won't be online up to 24 hours after you make the changes." - Original Message - From: "Joseph Eugene" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, May 21, 2000 5:42 PM Subject: Re: Caching Queries and CACHEDAFTER > Why wouldnt you use Cachewithin=#CreateTimeSpan(Days, hours, minutes, > seconds)# > > if you are caching the data which will not be pretty much changed > (this is if you know how often the data changes) > and if you set it for a day or , the query only runs once that day > and you should see any performance hits.. > > > - Original Message - > From: "Jay Sudowski - Handy Networks LLC" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Sunday, May 21, 2000 4:00 PM > Subject: Caching Queries and CACHEDAFTER > > > > This is a multi-part message in MIME format. > > > > --=_NextPart_000_04FE_01BFC33D.B4E4AD10 > > Content-Type: text/plain; > > charset="iso-8859-1" > > Content-Transfer-Encoding: quoted-printable > > > > Hey all - > > > > I'm currently developing a site that I'd like to use query caching on, = > > and I have a few questions about how I should go about setting query = > > caching up. > > > > Because the site will only be periodically updated, I figured that I = > > would store the date/time a table is modified as an application variable = > > and then just use that variable as the cachedafter value. I'm wondering = > > though, if this is going to work at all - the Allaire docs say that I = > > should specify a date value for cachedafter parameter - will cahcedafter = > > work with a date time value? If it will, how should I format my = > > date/time value? > > > > Generally speaking, is using cachedafter and storing the date/time a = > > specific table was modified in an application variable a good way to go = > > about caching queries? > > > > Thanks, > > > > Jay > > > > > > --=_NextPart_000_04FE_01BFC33D.B4E4AD10 > > Content-Type: text/html; > > charset="iso-8859-1" > > Content-Transfer-Encoding: quoted-printable > > > > > > > > > http-equiv=3DContent-Type> > > > > > > > > > > Hey all - > > > > I'm currently developing a site that = > > I'd like to=20 > > use query caching on, and I have a few questions about how I should = > > go=20 > > about setting query caching up. > > > > Because the site will only be = > > periodically updated,=20 > > I figured that I would store the date/time a table is modified as an = > > application=20 > > variable and then just use that variable as the cachedafter value. = > > I'm=20 > > wondering though, if this is going to work at all - the Allaire docs say = > > > > that I should specify a date value for cachedafter parameter - will = > > > > cahcedafter work with a date time value? If it will, how should I = > > format=20 > > my date/time value? > > > > Generally speaking, is using = > > cachedafter and=20 > > storing the date/time a specific table was modified in an application = > > variable a=20 > > good way to go about caching queries? > > > > Thanks, > > > > Jay > > > > > > --=_NextPart_000_04FE_01BFC33D.B4E4AD10-- > > > > -- > > > Archives: http://www.eGroups.com/list/cf-talk > > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Caching Queries and CACHEDAFTER
This is a multi-part message in MIME format. --=_NextPart_000_04FE_01BFC33D.B4E4AD10 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hey all - I'm currently developing a site that I'd like to use query caching on, = and I have a few questions about how I should go about setting query = caching up. Because the site will only be periodically updated, I figured that I = would store the date/time a table is modified as an application variable = and then just use that variable as the cachedafter value. I'm wondering = though, if this is going to work at all - the Allaire docs say that I = should specify a date value for cachedafter parameter - will cahcedafter = work with a date time value? If it will, how should I format my = date/time value? Generally speaking, is using cachedafter and storing the date/time a = specific table was modified in an application variable a good way to go = about caching queries? Thanks, Jay --=_NextPart_000_04FE_01BFC33D.B4E4AD10 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hey all - I'm currently developing a site that = I'd like to=20 use query caching on, and I have a few questions about how I should = go=20 about setting query caching up. Because the site will only be = periodically updated,=20 I figured that I would store the date/time a table is modified as an = application=20 variable and then just use that variable as the cachedafter value. = I'm=20 wondering though, if this is going to work at all - the Allaire docs say = that I should specify a date value for cachedafter parameter - will = cahcedafter work with a date time value? If it will, how should I = format=20 my date/time value? Generally speaking, is using = cachedafter and=20 storing the date/time a specific table was modified in an application = variable a=20 good way to go about caching queries? Thanks, Jay --=_NextPart_000_04FE_01BFC33D.B4E4AD10-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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=sts&body=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=lists&body=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=lists&body=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." > > > > > > > > > > > > You first ;-) > > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Session vars in a clustered environment
> > > > 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=lists&body=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=lists&body=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=lists&body=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=lists&body=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=lists&body=lists/cf_talk > or > > > send a message to [EMAIL PROTECTED] with 'unsubscribe' > in > > > the body. > > > > > > > -- > > > > > Archives: http://www.eGroups.com/list/cf-talk > > > To Unsubscr
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—îë‘.%;ã¶.."Rl‡„â’Tz.K‹cèk > „/Le > ¦Å.Âáï.b.™,n¹ðîDëÉ¢Æú3.†Ž:ÊzŸ0P×<êú.(.≠ > 9;-á8Dü28£ > %)¬¶£@ò¯Åâà¯ÂYÅ...ØDCŒ.‹å›`, > > ÍO&^ƒ—$å€ò'ü=~ÕNEßRzgš.¿…Zõ.Š'‚ > > Ù÷ ..ÚÑ´Àu2®‹à~ò 4LÞnE. > > |œ¾æ > > »‹~ÜÐ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=lists&body=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=lists&body=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=sts&body=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=sts&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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=lists&body=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=lists&body=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 ... Name: #session.fname# #session.lname#, #session.title# Company: #session.coname# Phone: #session.phone# E-mail: mailto:#session.email#">#session.email# 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 > > clientmanagement="Yes" > sessionmanagement="Yes" > setclientcookies="Yes" > sessiontimeout="#createtimespan(0,0,20,0)#" > applicationtimeout="#createtimespan(1,0,0,0)#"> > > > > > > > > > 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; > > > :Last Name > :First Name > : Email > : Phone Number > : Company Name > : Title > > > > > > screen2.cfm; > > > Hello #session.fname# #session.lname# > Your email address is : #session.email# > > > 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=lists&body=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=lists&body=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=lists&body=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=lists&body=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=lists&body=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=lists&body=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=lists&body=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=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Resetting CF Admin Password?
Is there any easy way to reset the CF admin password? I set the password months ago and can't remember it. TIA, Jay -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Win 2000 Nightmare ... OLEDB not installed?
Will, Thanks for that tidbit of info :-) I honestly was unaware of that - I had previously setup a Win2K server with CF 4.01 and didn't have any ole db issues. - Jay > Which I'd like to point out is NOT Microsoft's fault. No I'm not a MS > supporter, but bashing MS for everything is getting very tiring. Allaire > stated that Server versions below 4.5.1 were not supported on Windows 2000. > > - Original Message - > From: "Dave Watts" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Tuesday, April 25, 2000 5:28 AM > Subject: RE: Win 2000 Nightmare ... OLEDB not installed? > > > > > Right now I'm testing a new server we've been setting up for > > > the past week or so, and I've come the conclusion that OLE DB > > > hasn't been installed properly. I downloaded the MDAC Com Checker > > > and when I check to see which OLEDB components are installed I > > > get a CoCreateInstance failed error. So, I figure I could just > > > download MDAC and reinstall, right? Not the way MS planned things > > > out - I can't install the most current version of MDAC because > > > Windows insists I already have it installed. > > > > > > What's the easiest way to proceed now? The only option I can > > > see it to reinstall Win 2000 and hope the OLE DB stuff gets > > > installed the second time around. Anyone have any better options? > > > > Installing versions of CF prior to 4.5.1 on Win2K will break OLEDB. I was > > able to fix this by putting the Win2K CD in the machine, and selecting > > "Upgrade your operating system" from the menu. This will fix OLEDB, but > will > > break any third-party device drivers, so you'll then have to reinstall > them. > > > > Recently, someone posted a command-line upgrade option, but I don't > remember > > what it was, and I don't know whether it works. If you search the previous > > list posts, you can probably find it. > > > > Dave Watts, CTO, Fig Leaf Software > > http://www.figleaf.com/ > > voice: (202) 797-5496 > > fax: (202) 797-5444 > > > > -- > > > Archives: http://www.eGroups.com/list/cf-talk > > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT: Win 2000 Nightmare ... OLEDB not installed?
This is a multi-part message in MIME format. --=_NextPart_000_01D9_01BFAE54.F1E955B0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Well, well, well Windows never fails to impress me. Right now I'm testing a new server we've been setting up for the past = week or so, and I've come the conclusion that OLE DB hasn't been = installed properly. I downloaded the MDAC Com Checker and when I check = to see which OLEDB components are installed I get a CoCreateInstance = failed error. So, I figure I could just download MDAC and reinstall, = right? Not the way MS planned things out - I can't install the most = current version of MDAC because Windows insists I already have it = installed. What's the easiest way to proceed now? The only option I can see it to = reinstall Win 2000 and hope the OLE DB stuff gets installed the second = time around. Anyone have any better options? Thanks - Jay --=_NextPart_000_01D9_01BFAE54.F1E955B0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Well, well, well Windows never = fails to=20 impress me. Right now I'm testing a new server = we've been=20 setting up for the past week or so, and I've come the conclusion that = OLE DB=20 hasn't been installed properly. I downloaded the MDAC Com Checker = and when=20 I check to see which OLEDB components are installed I get a = CoCreateInstance=20 failed error. So, I figure I could just download MDAC and = reinstall,=20 right? Not the way MS planned things out - I can't install the = most=20 current version of MDAC because Windows insists I already have it=20 installed. What's the easiest way to proceed = now? The=20 only option I can see it to reinstall Win 2000 and hope the OLE DB stuff = gets=20 installed the second time around. Anyone have any better=20 options? Thanks - Jay --=_NextPart_000_01D9_01BFAE54.F1E955B0-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Fw: Query Cache Question
This is a message I sent this weekend but was bounced . I'm still curious about structures :-) - Original Message - From: Jay Sudowski <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, April 21, 2000 1:48 PM Subject: Re: Query Cache Question > Hey Pete, > > Thanks for the structure example :-). I have a few questions though - > seeing as how the whole purpose of the structure is to avoid hitting the > database, how would I go about outputting an entire list of products from > the structure? Or say, just a list of products in a certain category? I > guess I could query the db for just product ID's and then loop through the > structure, but that pretty much defeats the purpose of a structure, huh? > > Also, in the section of the code, why do you refer to the > structure as attributes.getProductDetails? Would it still work if I used > application.getProductDetails ...? > > I've never used structures before, but its apparent they're lots more > efficient than hitting that database again and again for the same info, so > go easy on me, huh? > > Thanks, > > Jay > > - Original Message - > From: Pete Freitag <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, April 20, 2000 2:31 AM > Subject: RE: Query Cache Question > > > > This is a good example of a query not to cache this way, let me explain > > why... > > Your idea with the dynamic query name shows that you have an idea why this > > might not work. It will cache the query in memory with the value that you > > first executed it with. Keep in mind that cold fusion can only have 100 > > queries cached at once, so you don't want to use them all up in one place. > > > > Here's how I would solve your situation... > > > > > >SELECT * FROM Product > > > > > > > > > > > > > > > > > > > > > > > > > > Now you can refer to a field based on your primary key, like this... > > > > > #attributes.getProductDetails[Attributes.PdtID].Price# > > > > > > ___ > > Pete Freitag > > CFDEV.COM > > Cold Fusion Developer Resources > > http://www.cfdev.com/ > > > > -Original Message- > > From: Ken M. Mevand [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, April 20, 2000 2:01 AM > > To: 02 cf-talk > > Subject: Query Cache Question > > > > > > lets say i have a query : > > > > > CACHEWITH="#CreateTimeSpan(0,1,0,0)#"> > > SELECT * FROM Product WHERE Pdt_ID = #Attributes.PdtID# > > > > > > thus, for every product request, this query will be recached since the > query > > statement will be different. would it be better to rename the query to > > something like NAME="getProductDetails_#Attributes.PdtID#" instead? > > > > thanks > > > > > > -- > -- > > -- > > Archives: http://www.eGroups.com/list/cf-talk > > To Unsubscribe visit > > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Stuctures and Arrays, huh? :-)
Hi All, For the past year or so, actually a little longer, I've been doing pretty rudimentary ColdFusion programming - lots of simple queries, some cfhttp, cfcontent, tons of loops, cookies - you know, all the easy stuff. I've definitely avoided using arrays, and more recently, structures (you see, I didn't know about structures until just a while ago ...). Basically, I'm having a few conceptual problems on just simply how to make, create, edit and add stuff to them. But, even past that, I can't think of any practical applications for arrays and structures. Obviously, there must be a ton, otherwise they wouldn't be in CF. So - I'm just wondering - are there any good novice tutorials to arrays and structures? I've considered taking the advanced CF class offered by Allaire but it is a little pricey. I'm also wondering, what are people really using arrays and structures for? Thanks, Jay -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: how to execute a file from within a file?
Mirza, I think you want to use a Here's an example Test.cfm Does this help you any? - Jay Sudowski * HANDY NETWORKS, LLC 4364 W. Point Loma Blvd., #G San Diego, California 92107-1197 Tel.: 1-888-423-3932 Fax: 1-888-800-2FAX http://www.HandyNetworks.com ICQ 15601511 | AIM Jay Suds - NT Hosting | Web Design Telecom | Connectivity - Original Message - From: mirza baig <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 27, 2000 5:38 PM Subject: how to execute a file from within a file? > Please see the code that says URL="TestAction.cfm", I > am trying to call this file with > ** > Hi List, > > Please help me. I am about to pull my hair. I don't > get an error,but I do not get the desired output. > > I have the three files below, please let me know why > the third file(testAction.cfm) never gets executed. I > have put break points in the file and went into debug. > The program never goes there at all. > > Also, for the purpose of printing the testAction.cfm > in CFHTTP.FileContents is there a better way of having > the testAction executed and I get the html of that > file and my ultimate purpose is to send an email of > the executed page as an attachment. > > Please let me know if you need any other information. > Also > let me know if I am on the wrong street? > > > THanks. > TestForm.cfm > > > > > > > > > > > Test.cfm > > > > > method="POST" > resolveurl="true" > throwonerror="yes"> > > value="#form.id#" > > > > > > TESTING:#CFHTTP.FileContent# > > > > TestAction.cfm** > > > > > > > This is a test! > Test is successful! > This is the id:#id# > > > > > *** > > __ > Do You Yahoo!? > Talk to your friends online with Yahoo! Messenger. > http://im.yahoo.com > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Search Engine Friendly Variables (?)
Allen, I'm not sure about the internetsoccer link you have there, but the first link is from a Vignette StoryServer. I've actaully got a friend who just landed a job at sportal, and they're teaching him TCL, the lanague that StoryServer is based upon. Each set of numbers between the comma's mean something to Story Server, but I don't have a clue ;-). The major problem, as I understand it, with search engines not indexing ColdFusion based urls is that they don't visit and URLs that have a question mark in them. IE, Altavista wouldn't spider something like www.yoursite.com/order.com?a=1234&b=5345867. Many moons ago, there was a long thread about how to create search engine friendly links on the Allaire Forums. The gist of it was to create a link using /'s rather than question marks, equal signs and ampersands. IE, to make that URL above search engine friendly, you link to www.yoursite.com/order.cfm/a/1234/b/5345867. A URL like this will still get executed by the CF server, you just have to create a list, using the / as a delimiter, and then set your vars using the list. Sorry I don't have any specific code examples. This topic was discusssed long ago and I never go around to implementing it into any of my sites. - Jay > > Hello, > > I've noticed some URL's set up in ways like these two. Could someone please > explain them for me? The little understading I have it is so that the > search engines will index the pages. Is that correct? > > How the commas function? As "="? > > ( http://www.sportal.co.uk/football/news/article/0,5081,47198,00.html ) > http://www.internetsoccer.com/handler.cfm/article,display/Con_ID,2/Locatio > nCode,NAmerica/ID,26307/At_ID, ) > > > Thank you. > == - == == - ==== - == > Allen Graetz > USI - Web Application Programmer > 1-800-USINTERNET x241 > 612-253-3241 > > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFHTTP Issue and CFFILE with 4.5 Enterprise
From: Tracy Smith <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 27, 2000 2:30 PM Subject: RE: CFHTTP Issue and CFFILE with 4.5 Enterprise > I had a somewhat similar issue that I am just beginning to research. > > We just upgraded to CF Enterprise 4.5 from CF Pro on NT 4.0/IIS 4.0. > One of our pages allows you to download a screensaver program. This > page was returning a CGI error every time it was run and keeping the > memory locked on the Web server for this process. Every time a new > request to download this screensaver was made, a new NT Process was > created it for it, the page would error, and the process would not > be released. Thus, it was eating up all of our memory. > Wouldn't it make more sense to use cflocation to direct the browser to the proper file to download? I'm currently a project that stores links to points the browser to the proper streaming media file. I was going to use CFHTTP, as you have, but read somewhere on the Allaire forums that there's less overhead on the CF server and there's less chance of the download being corrupted (or in my case, less chance of a frames downloading in the wrong order). Of course, using cflocation like this probably creates a whole mess of state management problems. Comments? - Jay -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Access Database and sum function - Major Problems!
Disregard my last message. Sometimes I feel like I'm programming with my head where the sun don't shine :-(. - Jay -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Access Database and sum function - Major Problems!
Hi All, Hopefully you guys can help me out here. I'm really stumped. Here's the situation. I have 3 tables - clients, billing_client, and payments_clients. In billing_client and payments_clients, I have the following fields ... billing_client: id, client_id, amount, bill_desc payments_clients: bill_id, client_id, payment_id, amount, pay_desc. I want to get the value of total payments (payments_clients.amount) and the total bills (billing_client.amount) along with the client contact information I need to display. I've managed to piece together a query that should work. Unfortunately, Access doesn't like something I'm doing and multiplies the sum values by 14!! (Ie, if I'm supposed to get a 1, access returns 14) I stripped down my query and was able to get access to return the right value, but I don't see why this problem is happening in the first place. Also, I don't get all the information I need with this stripped down query. Thanks in advance! - Jay select sum(billing_client.amount) as billed, sum(payments_clients.amount) as paid, client.org, client.client_id from billing_client, payments_clients,client where billing_client.type = 'charge' and billing_client.client_id = #client# and billing_client.client_id = client.client_id group by client.org, client.client_id select sum(billing_client.amount) as billed from billing_client where billing_client.type = 'charge' and billing_client.client_id = #client# -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.