OT Modifying Source File in DTS package
I have a DTS package which I use to import IIS log files into SQL Server 2000. How can I change the source file programaticallly and then run the package. I really am a newbie at DTS but I guess you can tell that. I know that I could always do the import with cf but it seems kind of silly to involve cf for a purely database function. TIA Don __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.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 on files
But I will add one thing to your statement, if your using it for large file uploads to the server it could take awhile before the user is even aware of a problem, the webmaster can receive notification no matter what but for someone with a slow link and sending a 1 meg file could take 5 mins before they know something has gone wrong. But at least they would be aware of it, I guess this is why I like CF5.0 because you can flush the output and say uploading until the script finishes, just something someone might wish to keep in mind. -Original Message- From: Andrew Tyrone [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 8 January 2002 1:45 PM To: CF-Talk Subject: RE: CFLOCK on files Remember, though, that you can catch cffile errors with cftry/cfcatch , and inform the user that the operation failed and that they should wait a nd try again. You can also inform system administrators via email if a file operation fails. There are many ways you can use this functionality to create a damage control system for your apps. -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Monday, January 07, 2002 7:25 PM To: CF-Talk Subject: Re: CFLOCK on files Kelly Matthews wrote: as far as I know it's not something that can be done. CFLOCK is strictly for sessions, etc. CFLOCK is for single threading CF. Whatever you do inside that sing le threaded application is not of CFs concern. CFFILE doesn't allow you to add a system level lock on a file nor release a lock. Unfortunately not. Jochem ___ ___ Why Share? Dedicated Win 2000 Server . PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation . $99/Month . Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.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 ZIP archives
Or better still it's described in Bens books (The green one from memory) with code on how you can do it! -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 8 January 2002 4:17 PM To: CF-Talk Subject: Re: Creating ZIP archives cfx_zip, or something like that. check out the developers exchange on allaire's site. - Original Message - From: Nick Texidor [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 07, 2002 6:39 PM Subject: Creating ZIP archives Hi, I have a requirement to zip up some image files together and FTP them to another server. The FTP bit is easy, but I'm wondering if anyone knows how (or whether there are any modules) that will create a ZIP file. Thanks Nick -- Nick Texidor __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.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 on files
No, cflock isn't limited to locking variables. Yes, cflock is used for mem ory variables (server, session, application) but remember cflock doesn't l ock anything, it merely coordinates access between similar locks (same sco pe or same name). If you use cflock with the name attribute, all you're doing is coordinating all the cflocks with that same name attribute. And inside the cflock can be anything - I use it around a cffile so our app doesn't try to write to a particular file when someone else is writing to it at the same time. Chris Norloff -- Original Message -- from: Kelly Matthews [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Mon, 7 Jan 2002 19:18:34 -0500 as far as I know it's not something that can be done. CFLOCK is strictly f or sessions, etc. CFFILE doesn't allow you to add a system level lock on a file nor release a lock. Would be nice though. :) I could be wrong but I don't think it has that capability. -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Monday, January 07, 2002 6:33 PM To: CF-Talk Subject: CFLOCK on files Does CF set an operating system level file lock on files being accessed within a named CFLOCK? Or is this handled by CFFILE? Or at all? Jim __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.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 Modifying Source File in DTS package
I usually create a Visual Basic file out of the DTS package (one of the options when saving DTS packages) and then modifiy them directly from Visual Basic. tom Don Vawter [EMAIL PROTECTED] wrote in message 01b601c1981b$67ae2710$6501a8c0@LAPTOP">news:01b601c1981b$67ae2710$6501a8c0@LAPTOP... I have a DTS package which I use to import IIS log files into SQL Server 2000. How can I change the source file programaticallly and then run the package. I really am a newbie at DTS but I guess you can tell that. I know that I could always do the import with cf but it seems kind of silly to involve cf for a purely database function. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.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: CFMAIL (SOLVED)
I used HTML format in the CFMAIL tag and that seemd to fix my problem. -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Monday, January 07, 2002 4:53 PM To: CF-Talk Subject: CFMAIL I have used CFMAIL before several times without difficulty. In this current case it is working fine, but it does not seem to be formatting like I am used to. When I get the email in my Inbox the data comes over just delimited by spaces not a hard return. Is there something different about CFMAIL in CF5? James __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.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 Modifying Source File in DTS package
If the mods are simple (verifying a numeric value or a particular format - or a date), then use the DTS transformation services and vb to massage the data during the import. The way I do it is to create the package and save it, then go to design view. The transformation connections all say copy at this point. Delete the connections that you want to fiddle with, the select new active X transformation. The interface makes it pretty easy - with common functions listed to the left of the scripting window. Mark -Original Message- From: Don Vawter [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 12:07 AM To: CF-Talk Subject: OT Modifying Source File in DTS package I have a DTS package which I use to import IIS log files into SQL Server 2000. How can I change the source file programaticallly and then run the package. I really am a newbie at DTS but I guess you can tell that. I know that I could always do the import with cf but it seems kind of silly to involve cf for a purely database function. TIA Don __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.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: Fax notification
Hey All, I'm looking for a solution(s) for sending faxes (and/or text messages and/or pages) to designated people based upon specific triggers in a system I'm developing (i.e. when an order is placed certain people will be notified via fax). Now the trigger isn't the issue...just looking for various ways to send the fax/message/page from the site. If anyone knows of a tag/product/service that could help me do this...pass it along ;-) TIA Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.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 on files
Chris, I like your explination. Can you clarify - if I use 2 locks with the same name do they work synchronously then? I had always thought I had to ensure that all my lock names were unique (when using names). Mark -Original Message- From: Chris Norloff [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 5:38 AM To: CF-Talk Subject: RE: CFLOCK on files No, cflock isn't limited to locking variables. Yes, cflock is used for mem ory variables (server, session, application) but remember cflock doesn't l ock anything, it merely coordinates access between similar locks (same sco pe or same name). If you use cflock with the name attribute, all you're doing is coordinating all the cflocks with that same name attribute. And inside the cflock can be anything - I use it around a cffile so our app doesn't try to write to a particular file when someone else is writing to it at the same time. Chris Norloff -- Original Message -- from: Kelly Matthews [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Mon, 7 Jan 2002 19:18:34 -0500 as far as I know it's not something that can be done. CFLOCK is strictly f or sessions, etc. CFFILE doesn't allow you to add a system level lock on a file nor release a lock. Would be nice though. :) I could be wrong but I don't think it has that capability. -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Monday, January 07, 2002 6:33 PM To: CF-Talk Subject: CFLOCK on files Does CF set an operating system level file lock on files being accessed within a named CFLOCK? Or is this handled by CFFILE? Or at all? Jim __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.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 on files
You DO want your names to be unique if they are not the same... thing. For example, if two templates are writing to a file, foo.txt, then they should use the same name for the locks. But, if one writes to jacob.txt, and one ot ray.txt, then you should use differnet names. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 12:53 PM To: CF-Talk Subject: RE: CFLOCK on files Chris, I like your explination. Can you clarify - if I use 2 locks with the same name do they work synchronously then? I had always thought I had to ensure that all my lock names were unique (when using names). Mark -Original Message- From: Chris Norloff [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 5:38 AM To: CF-Talk Subject: RE: CFLOCK on files No, cflock isn't limited to locking variables. Yes, cflock is used for mem ory variables (server, session, application) but remember cflock doesn't l ock anything, it merely coordinates access between similar locks (same sco pe or same name). If you use cflock with the name attribute, all you're doing is coordinating all the cflocks with that same name attribute. And inside the cflock can be anything - I use it around a cffile so our app doesn't try to write to a particular file when someone else is writing to it at the same time. Chris Norloff -- Original Message -- from: Kelly Matthews [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Mon, 7 Jan 2002 19:18:34 -0500 as far as I know it's not something that can be done. CFLOCK is strictly f or sessions, etc. CFFILE doesn't allow you to add a system level lock on a file nor release a lock. Would be nice though. :) I could be wrong but I don't think it has that capability. -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Monday, January 07, 2002 6:33 PM To: CF-Talk Subject: CFLOCK on files Does CF set an operating system level file lock on files being accessed within a named CFLOCK? Or is this handled by CFFILE? Or at all? Jim __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.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 on files
Ah... ok, thanks Ray - I think I get it. Mark -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 8:05 AM To: CF-Talk Subject: RE: CFLOCK on files You DO want your names to be unique if they are not the same... thing. For example, if two templates are writing to a file, foo.txt, then they should use the same name for the locks. But, if one writes to jacob.txt, and one ot ray.txt, then you should use differnet names. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 12:53 PM To: CF-Talk Subject: RE: CFLOCK on files Chris, I like your explination. Can you clarify - if I use 2 locks with the same name do they work synchronously then? I had always thought I had to ensure that all my lock names were unique (when using names). Mark -Original Message- From: Chris Norloff [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 5:38 AM To: CF-Talk Subject: RE: CFLOCK on files No, cflock isn't limited to locking variables. Yes, cflock is used for mem ory variables (server, session, application) but remember cflock doesn't l ock anything, it merely coordinates access between similar locks (same sco pe or same name). If you use cflock with the name attribute, all you're doing is coordinating all the cflocks with that same name attribute. And inside the cflock can be anything - I use it around a cffile so our app doesn't try to write to a particular file when someone else is writing to it at the same time. Chris Norloff -- Original Message -- from: Kelly Matthews [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Mon, 7 Jan 2002 19:18:34 -0500 as far as I know it's not something that can be done. CFLOCK is strictly f or sessions, etc. CFFILE doesn't allow you to add a system level lock on a file nor release a lock. Would be nice though. :) I could be wrong but I don't think it has that capability. -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Monday, January 07, 2002 6:33 PM To: CF-Talk Subject: CFLOCK on files Does CF set an operating system level file lock on files being accessed within a named CFLOCK? Or is this handled by CFFILE? Or at all? Jim __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Better Javascript/DHTML Calender!
similair to Popup Calander XP or whatever, except it's free and not $150 US it's a cross browser, inline DHTML calender http://www.geocities.com/bazillyo/spiffy/calendar/ z __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.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: CFMail and html/text
Does anyone know if there is a limit to the number of emails cf can handle processing? Example, if I wanted to use cfmail to send out a blast to 150,000 users, would there be a problem? - Original Message - From: Michael Wilson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, January 06, 2002 10:43 PM Subject: RE: CFMail and html/text Hi, Could you post this to the list. I must have missed this while I was on vacation. Thank you, Mike -Original Message- You bet!! Joseph DeVore posted exactly that a couple of weeks ago. I will email it to you directly. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.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 on files
Yes, that's my understanding, too. If you think about it terms of locking really being coordinating then it's more clear that locks must be named the same for CF to coordinate the actions inside those locks. This makes named locks faster, I should think, and much much more dangerous - because any little slip and you've got uncoordinated access to memory va riables. I suspect that's why MM/Allaire recommends using scoped locks for memory va riables - even though locking the entire scope is a greater performance hit , it's easier to check and harder to make a simple but deadly mistake. Chris I lock everything Norloff -- Original Message -- from: Raymond Camden [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Tue, 8 Jan 2002 11:04:40 -0500 You DO want your names to be unique if they are not the same... thing. For example, if two templates are writing to a file, foo.txt, then they should use the same name for the locks. But, if one writes to jacob.txt, and one ot ray.txt, then you should use differnet names. Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 12:53 PM To: CF-Talk Subject: RE: CFLOCK on files Chris, I like your explination. Can you clarify - if I use 2 locks with the same name do they work synchronously then? I had always thought I had to ensure that all my lock names were unique (when using names). Mark -Original Message- From: Chris Norloff [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 5:38 AM To: CF-Talk Subject: RE: CFLOCK on files No, cflock isn't limited to locking variables. Yes, cflock is used for mem ory variables (server, session, application) but remember cflock doesn't l ock anything, it merely coordinates access between similar locks (same sco pe or same name). If you use cflock with the name attribute, all you're doing is coordinating all the cflocks with that same name attribute. And inside the cflock can be anything - I use it around a cffile so our app doesn't try to write to a particular file when someone else is writing to it at the same time. Chris Norloff -- Original Message -- from: Kelly Matthews [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Mon, 7 Jan 2002 19:18:34 -0500 as far as I know it's not something that can be done. CFLOCK is strictly f or sessions, etc. CFFILE doesn't allow you to add a system level lock on a file nor release a lock. Would be nice though. :) I could be wrong but I don't think it has that capability. -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Monday, January 07, 2002 6:33 PM To: CF-Talk Subject: CFLOCK on files Does CF set an operating system level file lock on files being accessed within a named CFLOCK? Or is this handled by CFFILE? Or at all? Jim __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.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: CFMail and html/text
64k to the spool file... realistically much less will cause your system to crawl best to do batches of them and run it on scheduler and run that in light of total files in the spooler (do a count) and based on last point you were at (store in db, file or long term variable)... -paris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 11:18 To: CF-Talk Subject: Re: CFMail and html/text Does anyone know if there is a limit to the number of emails cf can handle processing? Example, if I wanted to use cfmail to send out a blast to 150,000 users, would there be a problem? - Original Message - From: Michael Wilson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, January 06, 2002 10:43 PM Subject: RE: CFMail and html/text Hi, Could you post this to the list. I must have missed this while I was on vacation. Thank you, Mike -Original Message- You bet!! Joseph DeVore posted exactly that a couple of weeks ago. I will email it to you directly. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.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: Fax notification
hylafax efax On Tue, 8 Jan 2002, Bryan Stevenson wrote: Hey All, I'm looking for a solution(s) for sending faxes (and/or text messages and /or pages) to designated people based upon specific triggers in a system I'm developing (i.e. when an order is placed certain people will be notified via fax). Now the trigger isn't the issue...just looking for various ways to send the fax/message/page from the site. If anyone knows of a tag/product/service that could help me do this...pas s it along ;-) TIA Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.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: Better Javascript/DHTML Calender!
That link doesn't work The site is down or doesn't exist -Original Message- From: Zac spitzer [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 9:18 AM To: CF-Talk Subject: Better Javascript/DHTML Calender! similair to Popup Calander XP or whatever, except it's free and not $150 US it's a cross browser, inline DHTML calender http://www.geocities.com/bazillyo/spiffy/calendar/ z __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.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: Better Javascript/DHTML Calender!
it's down they have reached their max transfer load for the day, that's a free site for ya -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 11:39 AM To: CF-Talk Subject: RE: Better Javascript/DHTML Calender! That link doesn't work The site is down or doesn't exist -Original Message- From: Zac spitzer [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 9:18 AM To: CF-Talk Subject: Better Javascript/DHTML Calender! similair to Popup Calander XP or whatever, except it's free and not $150 US it's a cross browser, inline DHTML calender http://www.geocities.com/bazillyo/spiffy/calendar/ z __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.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 on files
Even if you can't explicitly lock a file during a CFFILE operation... If CF uses system-level function calls to read and write files (that must be why it's capable of being locked out of a file when another application has it locked), then you would think that during a CF file write operation, the OS must place a lock on the file. Or no? The reason I brought up the point in the first place is that I need to read and write a large number of small text files that are in use by another, very busy service. I'm hoping that by doing so, I wouldn't be causing problems for that application, or for CF itself. Jim - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 07, 2002 5:24 PM Subject: Re: CFLOCK on files Kelly Matthews wrote: as far as I know it's not something that can be done. CFLOCK is strictly for sessions, etc. CFLOCK is for single threading CF. Whatever you do inside that single threaded application is not of CFs concern. CFFILE doesn't allow you to add a system level lock on a file nor release a lock. Unfortunately not. Jochem __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.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 on files
I wouldn't count on there being any automatic file locking with operations like cffile. For our use of cffile, we use it inside named locks that prev ent multiple simultaneous accesses to error log files we generate. This ha s worked well, even with busy error logging with many users ...sigh. So you might be able to get by without an explicit lock, but it's one of th e first places I'd look if there's problems with cfserver stability. best, Chris Norloff BTW, we learned the hard way that when cffile does an action=append, it a ctually reads the ENTIRE file into memory, then appends the new info, then writes the entire file to the disk. So watch your file size and your avail able memory ... -- Original Message -- from: Jim McAtee [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Tue, 8 Jan 2002 09:53:12 -0700 Even if you can't explicitly lock a file during a CFFILE operation... If C F uses system-level function calls to read and write files (that must be why it's capable of being locked out of a file when another application has it locked), then you would think that during a CF file write operation, the O S must place a lock on the file. Or no? The reason I brought up the point in the first place is that I need to rea d and write a large number of small text files that are in use by another, very busy service. I'm hoping that by doing so, I wouldn't be causing problems for that application, or for CF itself. Jim - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 07, 2002 5:24 PM Subject: Re: CFLOCK on files Kelly Matthews wrote: as far as I know it's not something that can be done. CFLOCK is strict ly for sessions, etc. CFLOCK is for single threading CF. Whatever you do inside that single threaded application is not of CFs concern. CFFILE doesn't allow you to add a system level lock on a file nor release a lock. Unfortunately not. Jochem __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.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 on files
Bare in mind that there are multiple reasons to lock, not just server stability. There are also logical reasons to lock. Consider this scenario: A file contains a number. You read the file, add one to the number, and save. Now, without a lock, its possible that two threads might read the file, and append the incorrect number. In this case, the lock is used for logical reason. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 11:53 AM To: CF-Talk Subject: Re: CFLOCK on files Even if you can't explicitly lock a file during a CFFILE operation... If CF uses system-level function calls to read and write files (that must be why it's capable of being locked out of a file when another application has it locked), then you would think that during a CF file write operation, the OS must place a lock on the file. Or no? The reason I brought up the point in the first place is that I need to read and write a large number of small text files that are in use by another, very busy service. I'm hoping that by doing so, I wouldn't be causing problems for that application, or for CF itself. Jim - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 07, 2002 5:24 PM Subject: Re: CFLOCK on files Kelly Matthews wrote: as far as I know it's not something that can be done. CFLOCK is strictly for sessions, etc. CFLOCK is for single threading CF. Whatever you do inside that single threaded application is not of CFs concern. CFFILE doesn't allow you to add a system level lock on a file nor release a lock. Unfortunately not. Jochem __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.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 on files
Note that CFLock is totally indepedent of file locking. CFLock only locks a block of code within a particular context within CF. I was under the impression that the other service Jim was referring to wasn't necessarily a CF application, in which case CFLock would have absolutely ZERO affect on access to the file. My recommendation: when dealing with files in use by third-party applications, things tend to get really messy. (I had a bad experience trashing a FoxPro database in use by a legacy POS system once) I'd recommend forgoing CFFile altogether, and write a COM object that uses the Win32 API to look at the status of the file, and behaves accordingly. - Original Message - From: Chris Norloff [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 11:12 AM Subject: Re: CFLOCK on files I wouldn't count on there being any automatic file locking with operations like cffile. For our use of cffile, we use it inside named locks that prev ent multiple simultaneous accesses to error log files we generate. This ha s worked well, even with busy error logging with many users ...sigh. So you might be able to get by without an explicit lock, but it's one of th e first places I'd look if there's problems with cfserver stability. best, Chris Norloff BTW, we learned the hard way that when cffile does an action=append, it a ctually reads the ENTIRE file into memory, then appends the new info, then writes the entire file to the disk. So watch your file size and your avail able memory ... -- Original Message -- from: Jim McAtee [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Tue, 8 Jan 2002 09:53:12 -0700 Even if you can't explicitly lock a file during a CFFILE operation... If C F uses system-level function calls to read and write files (that must be why it's capable of being locked out of a file when another application has it locked), then you would think that during a CF file write operation, the O S must place a lock on the file. Or no? The reason I brought up the point in the first place is that I need to rea d and write a large number of small text files that are in use by another, very busy service. I'm hoping that by doing so, I wouldn't be causing problems for that application, or for CF itself. Jim - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 07, 2002 5:24 PM Subject: Re: CFLOCK on files Kelly Matthews wrote: as far as I know it's not something that can be done. CFLOCK is strict ly for sessions, etc. CFLOCK is for single threading CF. Whatever you do inside that single threaded application is not of CFs concern. CFFILE doesn't allow you to add a system level lock on a file nor release a lock. Unfortunately not. Jochem __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RegExp help needed
Hello all, I have a text file that's a save of a bunch of messages from Outlook. The messages are error reports from CF sent with CFMail. The formatting sucks - I never expected to get a bunch - I was using it for debugging.. anyway, I have several hundred I need to parse. Silly transaction logs The layout is below. What I need to do is get the datetime string and the message ID from each instance of an error message in that file so I can update our database. start 'record' - x:\inetpub\domain\subdir\errorfile.cfmp DateTime: {ts '2002-01-06 00:44:09'}p URL Message_ID: 23660 p Message: ODBC Error Code = 37000 (Syntax error or access violation)Pp Detail: [Microsoft][ODBC SQL Server Driver][SQL Server]The log file for database 'dsdb' is full. Back up the transaction log for the database to free up some log space.PP end 'record' - The file has this format several hundred times over. Reading it in with cffile is simple. What I can't figure out is how to write the pattern matching code to extract the two variables. Also, the logic to make sure I have matching pairs is pretty easy - it's just the RegExps that are killing me. This is probably simple; I could write this in Perl but can't seem to do it in CF. Thanks in advance, Jeff __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.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: cfcatch and can't catch
Well, well ... thanks Dave. But guess what? The code described below works, and works well (with the possible exception of the original oddity, of errors seeming to be both caught and not-caught at the same time). I see from a re-reading of cfrethrow that it's supposed to do just as you said. I must have missed that before, or I was reading a different description. In my code it works quite well to cfrethrow from inside a cfcatch block and have it caught by the next cfcatch block - thus, I have two cfcatch type=any blocks. Now that I see it's not supposed to work that way I'll see about changing, on the theory that it may not continue to be robust. Another day, another peculiar ColdFusion response! thanks, Chris Norloff -- Original Message -- From: Dave Watts [EMAIL PROTECTED] Date: Mon, 7 Jan 2002 18:07:54 -0500 Thanks for the response. Interesting observation - I AM using a rethrow in a cfcatch, though I don't think that's what's causing the problem. I use a rethrow because timeout errors come in two types here: type=unknown and type=com.allaire.coldfusion.request.timeout. I have 4 cfcatch's: type=expression, type=database, type=any, type=any. Inside the first type=any I check if type=...timeout or if the first 17 characters of cfcatch.message are Request timed out. If so, I rethrow, and the second type=any is actually the cfcatch for timeouts. Since the caught type is database, I don't think this error-handling is getting to the type=any cfcatch statements. We're not using cferror type=monitor, only type=exception. Though perhaps I should be using type=request to catch more things if they slip past the cfcatch's. OK. If you're doing something like this, though, I can see a potential problem: cftry cfquery ... /cfquery cfcatch type=database ... /cfcatch cfcatch type=any cfif something cfrethrow /cfif /cfcatch cfcatch type=any ... /cfcatch /cftry The second CFCATCH won't throw an exception to the third CFCATCH, but instead it'll throw it to a higher-level CFCATCH (if one exists, you'd have this entire CFTRY block wrapped within a CFCATCH in a larger CFTRY!) or to a calling page, if this is a custom tag. However, that doesn't seem to address your specific problem, which is with the first CFCATCH. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.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 on files
I'm clear on the fact that CFLOCK and CFFILE are independent of one another. Originally, I was hoping there was an outside chance that CF might enforce system level file locking when a CFFILE operation was contained within a CFLOCK. I'm also completely clear on the benefits of using CFLOCK's around CFFILE operations and am aware that those locks are only recognized and for the benefit of the CF application server itself. If CFFILE is really as ill-behaved as everyone says, then that has at a least a few implications for its use and usefulness. Jim - Original Message - From: Billy Cravens [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 10:32 AM Subject: Re: CFLOCK on files Note that CFLock is totally indepedent of file locking. CFLock only locks a block of code within a particular context within CF. I was under the impression that the other service Jim was referring to wasn't necessarily a CF application, in which case CFLock would have absolutely ZERO affect on access to the file. My recommendation: when dealing with files in use by third-party applications, things tend to get really messy. (I had a bad experience trashing a FoxPro database in use by a legacy POS system once) I'd recommend forgoing CFFile altogether, and write a COM object that uses the Win32 API to look at the status of the file, and behaves accordingly. - Original Message - From: Chris Norloff [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 11:12 AM Subject: Re: CFLOCK on files I wouldn't count on there being any automatic file locking with operations like cffile. For our use of cffile, we use it inside named locks that prev ent multiple simultaneous accesses to error log files we generate. This ha s worked well, even with busy error logging with many users ...sigh. So you might be able to get by without an explicit lock, but it's one of th e first places I'd look if there's problems with cfserver stability. best, Chris Norloff BTW, we learned the hard way that when cffile does an action=append, it a ctually reads the ENTIRE file into memory, then appends the new info, then writes the entire file to the disk. So watch your file size and your avail able memory ... -- Original Message -- from: Jim McAtee [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Tue, 8 Jan 2002 09:53:12 -0700 Even if you can't explicitly lock a file during a CFFILE operation... If C F uses system-level function calls to read and write files (that must be why it's capable of being locked out of a file when another application has it locked), then you would think that during a CF file write operation, the O S must place a lock on the file. Or no? The reason I brought up the point in the first place is that I need to rea d and write a large number of small text files that are in use by another, very busy service. I'm hoping that by doing so, I wouldn't be causing problems for that application, or for CF itself. Jim - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 07, 2002 5:24 PM Subject: Re: CFLOCK on files Kelly Matthews wrote: as far as I know it's not something that can be done. CFLOCK is strict ly for sessions, etc. CFLOCK is for single threading CF. Whatever you do inside that single threaded application is not of CFs concern. CFFILE doesn't allow you to add a system level lock on a file nor release a lock. Unfortunately not. Jochem __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.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: RegExp help needed
Try this: cffile action=READ file=foo variable=mf cfscript startpos=1; stTime=refindnocase(DateTime\:[ ]*(\{[^\}]*\}),mf,startpos,yes); while(startpos LT len(mf) and startpos GT 0 and stTime.pos[1] GT 0){ if(arraylen(stTime.pos) GT 1) timeval=mid(mf,stTime.pos[2],stTime.len[2]); else timeval=; writeoutput(timeval ---); startpos=stTime.pos[1]+stTime.len[1]; if(startpos GT 0){ stId=refindnocase(Message_Id\:[ ]*([^]*)p,mf,startpos,yes); if(arraylen(stId.pos) GT 1) idval=mid(mf,stId.pos[2],stId.len[2]); else idval=; writeoutput(idval br); startpos=stId.pos[1]+stId.len[1]; } if (startpos GT 0) stTime=refindnocase(DateTime\:[ ]*(\{[^\}]*\}),mf,startpos,yes); } /cfscript HTH - Original Message - From: Jeff Beer [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 10:43 AM Subject: RegExp help needed Hello all, I have a text file that's a save of a bunch of messages from Outlook. The messages are error reports from CF sent with CFMail. The formatting sucks - I never expected to get a bunch - I was using it for debugging.. anyway, I have several hundred I need to parse. Silly transaction logs The layout is below. What I need to do is get the datetime string and the message ID from each instance of an error message in that file so I can update our database. start 'record' - x:\inetpub\domain\subdir\errorfile.cfmp DateTime: {ts '2002-01-06 00:44:09'}p URL Message_ID: 23660 p Message: ODBC Error Code = 37000 (Syntax error or access violation)Pp Detail: [Microsoft][ODBC SQL Server Driver][SQL Server]The log file for database 'dsdb' is full. Back up the transaction log for the database to free up some log space.PP end 'record' - The file has this format several hundred times over. Reading it in with cffile is simple. What I can't figure out is how to write the pattern matching code to extract the two variables. Also, the logic to make sure I have matching pairs is pretty easy - it's just the RegExps that are killing me. This is probably simple; I could write this in Perl but can't seem to do it in CF. Thanks in advance, Jeff __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.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 on files
I don't think it's any more ill-behaved than any other high-level mechanism (like FileScriptingObject) when it comes to manipulating files when there may be contention from multiple sources. It really boils down to knowing who else needs access to the file, and how that interface functions. - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 12:06 PM Subject: Re: CFLOCK on files I'm clear on the fact that CFLOCK and CFFILE are independent of one another. Originally, I was hoping there was an outside chance that CF might enforce system level file locking when a CFFILE operation was contained within a CFLOCK. I'm also completely clear on the benefits of using CFLOCK's around CFFILE operations and am aware that those locks are only recognized and for the benefit of the CF application server itself. If CFFILE is really as ill-behaved as everyone says, then that has at a least a few implications for its use and usefulness. Jim - Original Message - From: Billy Cravens [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 10:32 AM Subject: Re: CFLOCK on files Note that CFLock is totally indepedent of file locking. CFLock only locks a block of code within a particular context within CF. I was under the impression that the other service Jim was referring to wasn't necessarily a CF application, in which case CFLock would have absolutely ZERO affect on access to the file. My recommendation: when dealing with files in use by third-party applications, things tend to get really messy. (I had a bad experience trashing a FoxPro database in use by a legacy POS system once) I'd recommend forgoing CFFile altogether, and write a COM object that uses the Win32 API to look at the status of the file, and behaves accordingly. - Original Message - From: Chris Norloff [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 11:12 AM Subject: Re: CFLOCK on files I wouldn't count on there being any automatic file locking with operations like cffile. For our use of cffile, we use it inside named locks that prev ent multiple simultaneous accesses to error log files we generate. This ha s worked well, even with busy error logging with many users ...sigh. So you might be able to get by without an explicit lock, but it's one of th e first places I'd look if there's problems with cfserver stability. best, Chris Norloff BTW, we learned the hard way that when cffile does an action=append, it a ctually reads the ENTIRE file into memory, then appends the new info, then writes the entire file to the disk. So watch your file size and your avail able memory ... -- Original Message -- from: Jim McAtee [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Tue, 8 Jan 2002 09:53:12 -0700 Even if you can't explicitly lock a file during a CFFILE operation... If C F uses system-level function calls to read and write files (that must be why it's capable of being locked out of a file when another application has it locked), then you would think that during a CF file write operation, the O S must place a lock on the file. Or no? The reason I brought up the point in the first place is that I need to rea d and write a large number of small text files that are in use by another, very busy service. I'm hoping that by doing so, I wouldn't be causing problems for that application, or for CF itself. Jim - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 07, 2002 5:24 PM Subject: Re: CFLOCK on files Kelly Matthews wrote: as far as I know it's not something that can be done. CFLOCK is strict ly for sessions, etc. CFLOCK is for single threading CF. Whatever you do inside that single threaded application is not of CFs concern. CFFILE doesn't allow you to add a system level lock on a file nor release a lock. Unfortunately not. Jochem __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
problem with dynamic data in my select boxes
Hi everyone, Can someone please point to me what the problem here is? I basically have two queries. One pulls out the record set for a particular ID number and is grouped in a cfoutput based on another ID number. The problem is that when I have more than one dynamically populated select box with the HTML below, the ID that is selected is not the right one. It will select the first decID of the first reviewer that is outputted. I am sure this is the right way to reference the variables. Can someone point me to the incorrect logic? Please! I'm about to pull my hair out. See below: CFOUTPUT query=getReviewers group=reviewerID select name=decID option value=0[Select a decision]/option CFLOOP query=getDCodes option value=#decID# CFIF getDCodes.decisionID EQ getReviewers.decisionIDselected/cfif #trim(decisionDescription)#/option /CFLOOP /select /CFOUTPUT Tammy __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.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 on files
I'm clear on the fact that CFLOCK and CFFILE are independent of one another. Originally, I was hoping there was an outside chance that CF might enforce system level file locking when a CFFILE operation was contained within a CFLOCK. The system itself enforces whatever system-level file locking there is, if any, I think. CF is just like any other user in this respect. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.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: RegExp help needed
Holy cow, Don - I was hoping for some tips - you wrote the whole darn thingy! I'll test it right away - thanks mucho for the assist!! Regards, Jeff -Original Message- From: Don Vawter [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 1:29 PM To: CF-Talk Subject: Re: RegExp help needed Try this: cffile action=READ file=foo variable=mf cfscript startpos=1; stTime=refindnocase(DateTime\:[ ]*(\{[^\}]*\}),mf,startpos,yes); while(startpos LT len(mf) and startpos GT 0 and stTime.pos[1] GT 0){ if(arraylen(stTime.pos) GT 1) timeval=mid(mf,stTime.pos[2],stTime.len[2]); else timeval=; writeoutput(timeval ---); startpos=stTime.pos[1]+stTime.len[1]; if(startpos GT 0){ stId=refindnocase(Message_Id\:[ ]*([^]*)p,mf,startpos,yes); if(arraylen(stId.pos) GT 1) idval=mid(mf,stId.pos[2],stId.len[2]); else idval=; writeoutput(idval br); startpos=stId.pos[1]+stId.len[1]; } if (startpos GT 0) stTime=refindnocase(DateTime\:[ ]*(\{[^\}]*\}),mf,startpos,yes); } /cfscript HTH - Original Message - From: Jeff Beer [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 10:43 AM Subject: RegExp help needed Hello all, I have a text file that's a save of a bunch of messages from Outlook. The messages are error reports from CF sent with CFMail. The formatting sucks - I never expected to get a bunch - I was using it for debugging.. anyway, I have several hundred I need to parse. Silly transaction logs The layout is below. What I need to do is get the datetime string and the message ID from each instance of an error message in that file so I can update our database. start 'record' - x:\inetpub\domain\subdir\errorfile.cfmp DateTime: {ts '2002-01-06 00:44:09'}p URL Message_ID: 23660 p Message: ODBC Error Code = 37000 (Syntax error or access violation)Pp Detail: [Microsoft][ODBC SQL Server Driver][SQL Server]The log file for database 'dsdb' is full. Back up the transaction log for the database to free up some log space.PP end 'record' - The file has this format several hundred times over. Reading it in with cffile is simple. What I can't figure out is how to write the pattern matching code to extract the two variables. Also, the logic to make sure I have matching pairs is pretty easy - it's just the RegExps that are killing me. This is probably simple; I could write this in Perl but can't seem to do it in CF. Thanks in advance, Jeff __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.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: problem with dynamic data in my select boxes
When you start iterating through your inner query, it loses its place in the first query - meaning, referencing a column from the outtermost query and expecting it to know what row it is on. Like referencing query.column outside of a query loop, it defaults to the first row's value. You should save the column value in a local variable before entering the inner query loop: cfset thisDecisionID = getReviewers.decisionID CFLOOP query=getDCodes option value=#decID# CFIF getDCodes.decisionID EQ thisDecisionIDselected/cfif - Original Message - From: Tammy Hong [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 12:52 PM Subject: problem with dynamic data in my select boxes Hi everyone, Can someone please point to me what the problem here is? I basically have two queries. One pulls out the record set for a particular ID number and is grouped in a cfoutput based on another ID number. The problem is that when I have more than one dynamically populated select box with the HTML below, the ID that is selected is not the right one. It will select the first decID of the first reviewer that is outputted. I am sure this is the right way to reference the variables. Can someone point me to the incorrect logic? Please! I'm about to pull my hair out. See below: CFOUTPUT query=getReviewers group=reviewerID select name=decID option value=0[Select a decision]/option CFLOOP query=getDCodes option value=#decID# CFIF getDCodes.decisionID EQ getReviewers.decisionIDselected/cfif #trim(decisionDescription)#/option /CFLOOP /select /CFOUTPUT Tammy __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.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: problem with dynamic data in my select boxes
Except for the cfif line, Billy is right. The cfif needs to conform to the same order of operations he mentioned: cfif decisionID EQ thisDecisionIDselected/cfif All that is needed is decisionID, since it is used implicitly within the current query. If you wanted to keep the query name for the sake of the clarity of t he code, you could also do: cfif getDCodes.decisionID[CurrentRow] EQ thisDecisionIDselected/cf if -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 2:37 PM To: CF-Talk Subject: Re: problem with dynamic data in my select boxes When you start iterating through your inner query, it loses its pl ace in the first query - meaning, referencing a column from the outtermost query and expecting it to know what row it is on. Like referencing query column outside of a query loop, it defaults to the first row's value. You should save the column value in a local variable before entering the inner query loop: cfset thisDecisionID = getReviewers.decisionID CFLOOP query=getDCodes option value=#decID# CFIF getDCodes.decisionID EQ thisDecisionIDselected/cfif - Original Message - From: Tammy Hong [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 12:52 PM Subject: problem with dynamic data in my select boxes Hi everyone, Can someone please point to me what the problem here is? I basically have two queries. One pulls out the record set for a particular ID number and is grouped in a cfoutput based on another ID number. The problem is that when I have more than one dynamically populated select box with the HTML below, the ID that is selected is not the right one. It will select the firs t decID of the first reviewer that is outputted. I am sure this is the right way to reference the variables. Can someone point me to the incor rect logic? Please! I'm about to pull my hair out. See below: CFOUTPUT query=getReviewers group=reviewerID select name=decID option value=0[Select a decision]/option CFLOOP query=getDCodes option value=#decID# CFIF getDCodes.decisionID EQ getReviewers.decisionIDselected/cfif #trim(decisionDescription)#/option /CFLOOP /select /CFOUTPUT Tammy ___ ___ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.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: Clustering and CF variables.
I would like to add that Ken's *not necessarily* right - if the server is a dedicated CF server then DO USE THE REGISTRY for client variables. The registry provides the greatest performance when using client variables, which is why it is used by default and why it is even an option. Do you think MM made it an option just because it was possible or because it can be highly useful? There are three options for three or more server environments. Just plan ahead for it. When you build the server, adjust the registry to grow to around 100MB and it won't slow down and cause the server to crap out. Monitor the size of the registry as well, drop the persistance of client variable data from 90 if the registry grows to large or allow the registry to grow larger. Just my two cents. I've said it before I'll say it again the next time some SCREAMS that the registry won't work. One users bad experience shouldn't deter all others from the truth. t ** Tyler M. Fitch Certified Advanced ColdFusion 5 Developer ISITE Design, Inc. 615 SW Broadway Ste. 200 Portland, OR 97205 503.221.9860 ext. 111 http://isitedesign.com ** -Original Message- From: Peter Tilbrook [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 05, 2002 12:52 AM To: CF-Talk Subject: RE: Clustering and CF variables. Ken's right - do NOT use the registry for storing client variables. By default this is exactly what CF does. One of the first things you should do upon installing CF is create an empty database, say called ClientVariables, and make this the DEFAULT storage source (under the CF Administrator which is smart enough to create the necessary tables in a blank database). You will save your system/s from potential problems of the Registry filling up by doing this. You can still setup seperate Client storage databases for each application however. If you don't specify which datasource to use (in your application.cfm file) then the default will be used instead. Client variables are very useful for storing persistent information for a long period of time. I think the CF default is about 90 days. I wrote a neat application for calculating the nutrient content of foods to originally remember what a customer had entered (see http://www.anzfa.gov.au/npc/anzfa_npc) but the powers that be did not want any data to be retained by the server so I had to go back to Session instead. Also remember that when using client/session variables you must track the CLIENT (the web browser itself) through the application by appending the CFID/CFTOKEN to your URL's etc. Ben Forta's masterful Web Application Construction Kit (see www.forta.com) discusses these techniques very well. Cheers! Peter Tilbrook __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.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: problem with dynamic data in my select boxes
This is how I handle this cfset thisDecisionID = getReviewers.decisionID CFLOOP query=getDCodes CFIF getDCodes.decisionID EQ thisDecisionID CFSET select = SELECTED /CFIF option value=#decID# #select# There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown - Original Message - From: Billy Cravens [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 11:37 AM Subject: Re: problem with dynamic data in my select boxes When you start iterating through your inner query, it loses its place in the first query - meaning, referencing a column from the outtermost query and expecting it to know what row it is on. Like referencing query.column outside of a query loop, it defaults to the first row's value. You should save the column value in a local variable before entering the inner query loop: cfset thisDecisionID = getReviewers.decisionID CFLOOP query=getDCodes option value=#decID# CFIF getDCodes.decisionID EQ thisDecisionIDselected/cfif - Original Message - From: Tammy Hong [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 12:52 PM Subject: problem with dynamic data in my select boxes Hi everyone, Can someone please point to me what the problem here is? I basically have two queries. One pulls out the record set for a particular ID number and is grouped in a cfoutput based on another ID number. The problem is that when I have more than one dynamically populated select box with the HTML below, the ID that is selected is not the right one. It will select the first decID of the first reviewer that is outputted. I am sure this is the right way to reference the variables. Can someone point me to the incorrect logic? Please! I'm about to pull my hair out. See below: CFOUTPUT query=getReviewers group=reviewerID select name=decID option value=0[Select a decision]/option CFLOOP query=getDCodes option value=#decID# CFIF getDCodes.decisionID EQ getReviewers.decisionIDselected/cfif #trim(decisionDescription)#/option /CFLOOP /select /CFOUTPUT Tammy __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.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: problem with dynamic data in my select boxes
Errr, won't this mean that every value AFTER the correct one will also be marked selected? Sure the browser will use the first one, but that i'snt good. I'd add a cfset select = before the cfif. -Raymond cfset thisDecisionID = getReviewers.decisionID CFLOOP query=getDCodes CFIF getDCodes.decisionID EQ thisDecisionID CFSET select = SELECTED /CFIF option value=#decID# #select# There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown - Original Message - From: Billy Cravens [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 11:37 AM Subject: Re: problem with dynamic data in my select boxes When you start iterating through your inner query, it loses its place in the first query - meaning, referencing a column from the outtermost query and expecting it to know what row it is on. Like referencing query.column outside of a query loop, it defaults to the first row's value. You should save the column value in a local variable before entering the inner query loop: cfset thisDecisionID = getReviewers.decisionID CFLOOP query=getDCodes option value=#decID# CFIF getDCodes.decisionID EQ thisDecisionIDselected/cfif - Original Message - From: Tammy Hong [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 12:52 PM Subject: problem with dynamic data in my select boxes Hi everyone, Can someone please point to me what the problem here is? I basically have two queries. One pulls out the record set for a particular ID number and is grouped in a cfoutput based on another ID number. The problem is that when I have more than one dynamically populated select box with the HTML below, the ID that is selected is not the right one. It will select the first decID of the first reviewer that is outputted. I am sure this is the right way to reference the variables. Can someone point me to the incorrect logic? Please! I'm about to pull my hair out. See below: CFOUTPUT query=getReviewers group=reviewerID select name=decID option value=0[Select a decision]/option CFLOOP query=getDCodes option value=#decID# CFIF getDCodes.decisionID EQ getReviewers.decisionIDselected/cfif #trim(decisionDescription)#/option /CFLOOP /select /CFOUTPUT Tammy __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.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: problem with dynamic data in my select boxes
Hi, Thank you all for your valuable input. It worked perfectly. Have a nice d ay. Tammy -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 2:18 PM To: CF-Talk Subject: RE: problem with dynamic data in my select boxes Errr, won't this mean that every value AFTER the correct one will also be marked selected? Sure the browser will use the first one, but that i'snt good. I'd add a cfset select = before the cfif. -Raymond cfset thisDecisionID = getReviewers.decisionID CFLOOP query=getDCodes CFIF getDCodes.decisionID EQ thisDecisionID CFSET select = SELECTED /CFIF option value=#decID# #select# There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown - Original Message - From: Billy Cravens [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 11:37 AM Subject: Re: problem with dynamic data in my select boxes When you start iterating through your inner query, it loses its place in the first query - meaning, referencing a column from the outtermost query and expecting it to know what row it is on. Like referencing query.column outside of a query loop, it defaults to the first row's value. You should save the column value in a local variable before entering the inner query loop: cfset thisDecisionID = getReviewers.decisionID CFLOOP query=getDCodes option value=#decID# CFIF getDCodes.decisionID EQ thisDecisionIDselected/cfif - Original Message - From: Tammy Hong [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 12:52 PM Subject: problem with dynamic data in my select boxes Hi everyone, Can someone please point to me what the problem here is? I basically have two queries. One pulls out the record set for a particular ID number and is grouped in a cfoutput based on another ID number. The problem is that when I have more than one dynamically populated select box with the HTML below, the ID that is selected is not the right one. It will select the first decID of the first reviewer that is outputted. I am sure this is the right way to reference the variables. Can someone point me to the incorrect logic? Please! I'm about to pull my hair out. See below: CFOUTPUT query=getReviewers group=reviewerID select name=decID option value=0[Select a decision]/option CFLOOP query=getDCodes option value=#decID# CFIF getDCodes.decisionID EQ getReviewers.decisionIDselected/cfif #trim(decisionDescription)#/option /CFLOOP /select /CFOUTPUT Tammy __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.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 ZIP archives
I wrote a java CFX tag that does exactly this. Email me off list if you would like try it. JS -Original Message- From: Nick Texidor [mailto:[EMAIL PROTECTED]] Sent: Monday, January 07, 2002 6:39 PM To: CF-Talk Subject: Creating ZIP archives Hi, I have a requirement to zip up some image files together and FTP them to another server. The FTP bit is easy, but I'm wondering if anyone knows how (or whether there are any modules) that will create a ZIP file. Thanks Nick -- Nick Texidor __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.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: Clustering and CF variables.
What are the performance implications of allowing your registry to grow like that? A portion of memory allocated to Windows is for the registry, and the bigger the registry, the more memory used. - Original Message - From: Tyler M. Fitch [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 2:01 PM Subject: RE: Clustering and CF variables. I would like to add that Ken's *not necessarily* right - if the server is a dedicated CF server then DO USE THE REGISTRY for client variables. The registry provides the greatest performance when using client variables, which is why it is used by default and why it is even an option. Do you think MM made it an option just because it was possible or because it can be highly useful? There are three options for three or more server environments. Just plan ahead for it. When you build the server, adjust the registry to grow to around 100MB and it won't slow down and cause the server to crap out. Monitor the size of the registry as well, drop the persistance of client variable data from 90 if the registry grows to large or allow the registry to grow larger. Just my two cents. I've said it before I'll say it again the next time some SCREAMS that the registry won't work. One users bad experience shouldn't deter all others from the truth. t ** Tyler M. Fitch Certified Advanced ColdFusion 5 Developer ISITE Design, Inc. 615 SW Broadway Ste. 200 Portland, OR 97205 503.221.9860 ext. 111 http://isitedesign.com ** -Original Message- From: Peter Tilbrook [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 05, 2002 12:52 AM To: CF-Talk Subject: RE: Clustering and CF variables. Ken's right - do NOT use the registry for storing client variables. By default this is exactly what CF does. One of the first things you should do upon installing CF is create an empty database, say called ClientVariables, and make this the DEFAULT storage source (under the CF Administrator which is smart enough to create the necessary tables in a blank database). You will save your system/s from potential problems of the Registry filling up by doing this. You can still setup seperate Client storage databases for each application however. If you don't specify which datasource to use (in your application.cfm file) then the default will be used instead. Client variables are very useful for storing persistent information for a long period of time. I think the CF default is about 90 days. I wrote a neat application for calculating the nutrient content of foods to originally remember what a customer had entered (see http://www.anzfa.gov.au/npc/anzfa_npc) but the powers that be did not want any data to be retained by the server so I had to go back to Session instead. Also remember that when using client/session variables you must track the CLIENT (the web browser itself) through the application by appending the CFID/CFTOKEN to your URL's etc. Ben Forta's masterful Web Application Construction Kit (see www.forta.com) discusses these techniques very well. Cheers! Peter Tilbrook __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.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: Clustering and CF variables.
I would like to add that Ken's *not necessarily* right - if the server is a dedicated CF server then DO USE THE REGISTRY for client variables. The registry provides the greatest performance when using client variables, which is why it is used by default and why it is even an option. Do you think MM made it an option just because it was possible or because it can be highly useful? There are three options for three or more server environments. Just plan ahead for it. When you build the server, adjust the registry to grow to around 100MB and it won't slow down and cause the server to crap out. Monitor the size of the registry as well, drop the persistance of client variable data from 90 if the registry grows to large or allow the registry to grow larger. Just my two cents. I've said it before I'll say it again the next time some SCREAMS that the registry won't work. One users bad experience shouldn't deter all others from the truth. I guess that the problem with the truth is that it can be perceived so subjectively. I've had quite a few bad experiences with using the registry for Client variable storage, though - and they haven't all been mine, personally, but several have been with clients for whom it failed in a relatively dramatic fashion. The reason MM (or, more accurately, Allaire) made it an option is that, at the time, they didn't necessarily know how bad this could be, or more likely, at the time, you weren't likely to get enough traffic for it to be so bad. Client variables were introduced in CF 2.0, and they could only be stored in the registry then. The ability to store them in other places wasn't introduced until CF 4, I think. Back in those days, heavy use didn't mean the same as it does now, and very few people were building line-of-business apps on the web. As for best performance, yes, the registry may be faster than using a database. Using cookies will be just as fast, though. Performance, however, is probably not the only metric most people care about. Reliability is pretty important to most people, and registry storage is far less reliable than database storage. The Windows registry is not your typical database. It's a hierarchical data store, like an LDAP server, rather than a relational data store. It's not designed for transactional processing, like a relational database typically is. The registry is designed to be read often, and written to infrequently. The typical usage pattern for a Windows app using the registry is to read the appropriate keys on startup, then write changes to those keys if necessary on shutdown. That's quite a bit different from constantly writing to the registry. There are several weak points with using the registry. It can become fragmented, just like other files in general. This will slow performance after time. It can become corrupted - and I've encountered this personally - requiring a restore and consequently losing all of the client data. It makes it difficult to migrate an application from one server to another. In summary, I strongly recommend against using the Registry as a Client variable data store. I recommend against using a file-based database like Access for this also - that has its own, very serious, problems. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.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 ZIP archives
Alternately, you can use CFExecute and a command line program like PKZip. - Original Message - From: Jeff Sarsoun [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 2:21 PM Subject: RE: Creating ZIP archives I wrote a java CFX tag that does exactly this. Email me off list if you would like try it. JS -Original Message- From: Nick Texidor [mailto:[EMAIL PROTECTED]] Sent: Monday, January 07, 2002 6:39 PM To: CF-Talk Subject: Creating ZIP archives Hi, I have a requirement to zip up some image files together and FTP them to another server. The FTP bit is easy, but I'm wondering if anyone knows how (or whether there are any modules) that will create a ZIP file. Thanks Nick -- Nick Texidor __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Fwd: FW: Porting CF to ASP
-Original Message- From: Haggerty, Michael A. Sent: Tuesday, January 08, 2002 10:14 AM To: '[EMAIL PROTECTED]' Subject:OT: Porting CF to ASP Hello all; I have been given an assignment to port a Cold Fusion application to ASP. After going through the code, I realized I have a few questions that will have a bearing on how I build the project. Does anyone have any detailed knowledge about the following in ASP? 1) Do the application, session and request scopes exist in ASP similar to the same scopes in CF? How do you instantiate them? 2) Is locking available, similar to the CFLOCK tag? If so, are there any code examples? 3) How does one call a stored procedure in ASP? How do you pass variables into the proc, and is named notation available? 4) I know arrays are available in ASP, but how about structures? Is there any way to create an associative array? Thanks in advance, Michael Haggerty __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.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 ZIP archives
Assuming cfexecute isn't disabled. That's how the tag came into being. JS -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 3:40 PM To: CF-Talk Subject: Re: Creating ZIP archives Alternately, you can use CFExecute and a command line program like PKZip. - Original Message - From: Jeff Sarsoun [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 2:21 PM Subject: RE: Creating ZIP archives I wrote a java CFX tag that does exactly this. Email me off list if yo u would like try it. JS -Original Message- From: Nick Texidor [mailto:[EMAIL PROTECTED]] Sent: Monday, January 07, 2002 6:39 PM To: CF-Talk Subject: Creating ZIP archives Hi, I have a requirement to zip up some image files together and FTP them t o another server. The FTP bit is easy, but I'm wondering if anyone knows how (or whether there are any modules) that will create a ZIP file. Thanks Nick -- Nick Texidor __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.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: Clustering and CF variables.
I'd like to add to this that another reason for not storing client va riables in the registry is for the original reason of this topic: Clustering and Load Balancing. You run right into the same problem that is caused b y using session variables -- use sticky sessions for pseudo-load balancing or nix them and go to client variable storage, using one or more database se rvers with replication. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 3:33 PM To: CF-Talk Subject: RE: Clustering and CF variables. I would like to add that Ken's *not necessarily* right - if the server is a dedicated CF server then DO USE THE REGISTRY for client variables. The registry provides the greatest performance when using client variables, which is why it is used by default and why it is even an option. Do you think MM made it an option just because it was possible or because it can be highly useful? There are three options for three or more server environments. Just plan ahead for it. When you build the server, adjust the registry to grow to around 100MB and it won't slow down and cause the server to crap out. Monitor the size of the registry as well, drop the persistance of client variable data from 90 if the registry grows to large or allow the registry to grow larger. Just my two cents. I've said it before I'll say it again the next time some SCREAMS that the registry won't work. One users bad experience shouldn't deter all others from the truth. I guess that the problem with the truth is that it can be perceiv ed so subjectively. I've had quite a few bad experiences with using the r egistry for Client variable storage, though - and they haven't all been min e, personally, but several have been with clients for whom it failed i n a relatively dramatic fashion. The reason MM (or, more accurately, Allaire) made it an option is t hat, at the time, they didn't necessarily know how bad this could be, or mo re likely, at the time, you weren't likely to get enough traffic for i t to be so bad. Client variables were introduced in CF 2.0, and they could only be stored in the registry then. The ability to store them in other pla ces wasn't introduced until CF 4, I think. Back in those days, heavy use didn't mean the same as it does now, and very few people were building line-of-business apps on the web. As for best performance, yes, the registry may be faster than using a database. Using cookies will be just as fast, though. Performance, however, is probably not the only metric most people care about. Reliability is pretty important to most people, and registry storage is far less r eliable than database storage. The Windows registry is not your typical database. It's a hierarchical data store, like an LDAP server, rather than a relational data store. It 's not designed for transactional processing, like a relational database typically is. The registry is designed to be read often, and written to infrequently. The typical usage pattern for a Windows app using the registry is t o read the appropriate keys on startup, then write changes to those keys i f necessary on shutdown. That's quite a bit different from constantly writing to the registry. There are several weak points with using the registry. It can becom e fragmented, just like other files in general. This will slow perfor mance after time. It can become corrupted - and I've encountered this personally - requiring a restore and consequently losing all of the client data. It makes it difficult to migrate an application from one server to another. In summary, I strongly recommend against using the Registry as a Cl ient variable data store. I recommend against using a file-based databas e like Access for this also - that has its own, very serious, problems. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ___ ___ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFFTP Problem
I know you have heard of this problem before, but I am looking for a solution. When using CFFTP to upload a fil it uploads as 0k. I was going to use the Intrafoundation.TCPClient and do it manually, but unfortunatly this is hosted remotely and not on our server. Does anyone have any suggestions. btw, i think it is just an error with cf server 5 because i have never had this problem before it. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFFTP Problem
When using CFFTP to upload a fil it uploads as 0k. And the problem is? Jim - Original Message - From: Tyler Clendenin [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 1:57 PM Subject: CFFTP Problem I know you have heard of this problem before, but I am looking for a solution. When using CFFTP to upload a fil it uploads as 0k. I was going to use the Intrafoundation.TCPClient and do it manually, but unfortunatly this is hosted remotely and not on our server. Does anyone have any suggestions. btw, i think it is just an error with cf server 5 because i have never had this problem before it. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Content protection?
Hello All, We have a need to display some text on our intranet that a user would not be able to print/copy. Would there be any scripts out there anyone can point me to? I guess it will be a script that pops up the html file into a window without any of the menu options with the right click disabled. I want to also stop the user from highlighting the text and copying it using Ctrl+v. Another method I have thought of is displaying the text as an image in a pop up screen with the menu and right click disabled. Has any one come across such a tag that converts text to image on the fly? I understand that there will always be workarounds and it will never be foolproof. Thanks, Dharmesh Goel Programmer Analyst IT Dept. - Discount Car Truck Rentals 416-744-0123 x290 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFFTP Problem
hehehe, sorry, doesn't look right, that is a zero ... as in zero KB. sorry for the confusion - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 4:07 PM Subject: Re: CFFTP Problem When using CFFTP to upload a fil it uploads as 0k. And the problem is? Jim - Original Message - From: Tyler Clendenin [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 1:57 PM Subject: CFFTP Problem I know you have heard of this problem before, but I am looking for a solution. When using CFFTP to upload a fil it uploads as 0k. I was going to use the Intrafoundation.TCPClient and do it manually, but unfortunatly this is hosted remotely and not on our server. Does anyone have any suggestions. btw, i think it is just an error with cf server 5 because i have never had this problem before it. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFFTP Problem
At 04:07 PM 1/8/02, you wrote: When using CFFTP to upload a fil it uploads as 0k. And the problem is? Jim Usually the physical path to the file is wrong, so it doesn't actually find it to upload, it just creates an empty file with the name given. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.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: Content protection?
Maybe you should consider a simple Flash movie or image. I think the problems of preventing cut and paste are pretty daunting using just client side scripting - and all the measures I can think of can be overcome by even novice web surfers. But I'm sure there's a JavaScript guru out there with the answer g. Mark -Original Message- From: Dharmesh Goel [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 1:09 PM To: CF-Talk Subject: Content protection? Hello All, We have a need to display some text on our intranet that a user would not be able to print/copy. Would there be any scripts out there anyone can point me to? I guess it will be a script that pops up the html file into a window without any of the menu options with the right click disabled. I want to also stop the user from highlighting the text and copying it using Ctrl+v. Another method I have thought of is displaying the text as an image in a pop up screen with the menu and right click disabled. Has any one come across such a tag that converts text to image on the fly? I understand that there will always be workarounds and it will never be foolproof. Thanks, Dharmesh Goel Programmer Analyst IT Dept. - Discount Car Truck Rentals 416-744-0123 x290 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.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: Content protection?
If your intranet is ie only, then you can use a modal window which would seem to fit your requirements much better than converting to an image which can be easily printed. Check it out here http://www.webreference.com/js/column90/ DRE -Original Message- From: Dharmesh Goel [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 2:09 PM To: CF-Talk Subject: Content protection? Hello All, We have a need to display some text on our intranet that a user would not be able to print/copy. Would there be any scripts out there anyone can point me to? I guess it will be a script that pops up the html file into a window without any of the menu options with the right click disabled. I want to also stop the user from highlighting the text and copying it using Ctrl+v. Another method I have thought of is displaying the text as an image in a pop up screen with the menu and right click disabled. Has any one come across such a tag that converts text to image on the fly? I understand that there will always be workarounds and it will never be foolproof. Thanks, Dharmesh Goel Programmer Analyst IT Dept. - Discount Car Truck Rentals 416-744-0123 x290 __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFFTP Problem
Without knowing more about your setup, one can't really suggest much. There's a knowledge base article on a similar issue which might help: http://www.allaire.com/Handlers/index.cfm?ID=22319Method=Full Regards, Joel Parramore -Original Message- From: Tyler Clendenin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 4:16 PM To: CF-Talk Subject: Re: CFFTP Problem hehehe, sorry, doesn't look right, that is a zero ... as in zero KB. sorry for the confusion - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 4:07 PM Subject: Re: CFFTP Problem When using CFFTP to upload a fil it uploads as 0k. And the problem is? Jim - Original Message - From: Tyler Clendenin [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 1:57 PM Subject: CFFTP Problem I know you have heard of this problem before, but I am looking for a solution. When using CFFTP to upload a fil it uploads as 0k. I wa s going to use the Intrafoundation.TCPClient and do it manually, but unfortunatly this is hosted remotely and not on our server. Does anyone have any suggestions. btw, i think it is just an error with cf server 5 because i have ne ver had this problem before it. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.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: Content protection?
A really simple solution, if you're using IE as your browser, is to use the showModalWindow() javascript method. This creates a window that is modal, has no right click, and text cannot be printed nor highlighted You can also use the showModelessWindow() method, if you don't want t he window to be modal. - Original Message - From: Dharmesh Goel [EMAIL PROTECTED] Date: Tuesday, January 8, 2002 2:09 pm Subject: Content protection? Hello All, We have a need to display some text on our intranet that a user would not be able to print/copy. Would there be any scripts out there anyone can point me to? I guess it will be a script that pops up the html file into a windowwithout any of the menu options with the right click disabled. I want to also stop the user from highlighting the text and copying it using Ctrl+v. Another method I have thought of is displaying the text as an image in a pop up screen with the menu and right click disabled. Has any one come acrosssuch a tag that converts text to image on the fly? I understand that there will always be workarounds and it will never be foolproof. Thanks, Dharmesh Goel Programmer Analyst IT Dept. - Discount Car Truck Rentals 416-744-0123 x290 ___ _ __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sideb ar=lists __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.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: Clustering and CF variables.
Well looking at the whole history of things, Dave brings up some good points. Getting in the game at when CF 4.0 was the current version I missed out on some of those 2.0 experiences. The key of my idea is from DevCon where the speaker on managing CF server's recommened use of the registry for client vars for boxes dedicated to hosting CF. He was very much for it, as long as you planned for it properly. Cheers, t ** Tyler M. Fitch Certified Advanced ColdFusion 5 Developer ISITE Design, Inc. 615 SW Broadway Ste. 200 Portland, OR 97205 503.221.9860 ext. 111 http://isitedesign.com ** -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 12:33 PM To: CF-Talk Subject: RE: Clustering and CF variables. I would like to add that Ken's *not necessarily* right - if the server is a dedicated CF server then DO USE THE REGISTRY for client variables. The registry provides the greatest performance when using client variables, which is why it is used by default and why it is even an option. Do you think MM made it an option just because it was possible or because it can be highly useful? There are three options for three or more server environments. Just plan ahead for it. When you build the server, adjust the registry to grow to around 100MB and it won't slow down and cause the server to crap out. Monitor the size of the registry as well, drop the persistance of client variable data from 90 if the registry grows to large or allow the registry to grow larger. Just my two cents. I've said it before I'll say it again the next time some SCREAMS that the registry won't work. One users bad experience shouldn't deter all others from the truth. I guess that the problem with the truth is that it can be perceived so subjectively. I've had quite a few bad experiences with using the registry for Client variable storage, though - and they haven't all been mine, personally, but several have been with clients for whom it failed in a relatively dramatic fashion. The reason MM (or, more accurately, Allaire) made it an option is that, at the time, they didn't necessarily know how bad this could be, or more likely, at the time, you weren't likely to get enough traffic for it to be so bad. Client variables were introduced in CF 2.0, and they could only be stored in the registry then. The ability to store them in other places wasn't introduced until CF 4, I think. Back in those days, heavy use didn't mean the same as it does now, and very few people were building line-of-business apps on the web. As for best performance, yes, the registry may be faster than using a database. Using cookies will be just as fast, though. Performance, however, is probably not the only metric most people care about. Reliability is pretty important to most people, and registry storage is far less reliable than database storage. The Windows registry is not your typical database. It's a hierarchical data store, like an LDAP server, rather than a relational data store. It's not designed for transactional processing, like a relational database typically is. The registry is designed to be read often, and written to infrequently. The typical usage pattern for a Windows app using the registry is to read the appropriate keys on startup, then write changes to those keys if necessary on shutdown. That's quite a bit different from constantly writing to the registry. There are several weak points with using the registry. It can become fragmented, just like other files in general. This will slow performance after time. It can become corrupted - and I've encountered this personally - requiring a restore and consequently losing all of the client data. It makes it difficult to migrate an application from one server to another. In summary, I strongly recommend against using the Registry as a Client variable data store. I recommend against using a file-based database like Access for this also - that has its own, very serious, problems. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.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: Content protection?
You could stick the text in a memo field with an onFocus event to automoatically remove the focus from the memo field. That would at least solve the CTRL+V issue. HTH Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Original Message - From: Dharmesh Goel [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 1:09 PM Subject: Content protection? Hello All, We have a need to display some text on our intranet that a user would not be able to print/copy. Would there be any scripts out there anyone can point me to? I guess it will be a script that pops up the html file into a window without any of the menu options with the right click disabled. I want to also stop the user from highlighting the text and copying it using Ctrl+v. Another method I have thought of is displaying the text as an image in a pop up screen with the menu and right click disabled. Has any one come across such a tag that converts text to image on the fly? I understand that there will always be workarounds and it will never be foolproof. Thanks, Dharmesh Goel Programmer Analyst IT Dept. - Discount Car Truck Rentals 416-744-0123 x290 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.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: Content protection?
Thank you all. This looks like something we can definitely use. Thanks again. Dharmesh Goel Programmer Analyst IT Dept. - Discount Car Truck Rentals 416-744-0123 x290 -Original Message- From: Andre Turrettini [mailto:[EMAIL PROTECTED]] Sent: January 8, 2002 4:13 PM To: CF-Talk Subject:RE: Content protection? If your intranet is ie only, then you can use a modal window which would seem to fit your requirements much better than converting to an image which can be easily printed. Check it out here http://www.webreference.com/js/column90/ DRE -Original Message- From: Dharmesh Goel [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 2:09 PM To: CF-Talk Subject: Content protection? Hello All, We have a need to display some text on our intranet that a user would not be able to print/copy. Would there be any scripts out there anyone can point me to? I guess it will be a script that pops up the html file into a window without any of the menu options with the right click disabled. I want to also stop the user from highlighting the text and copying it using Ctrl+v. Another method I have thought of is displaying the text as an image in a pop up screen with the menu and right click disabled. Has any one come across such a tag that converts text to image on the fly? I understand that there will always be workarounds and it will never be foolproof. Thanks, Dharmesh Goel Programmer Analyst IT Dept. - Discount Car Truck Rentals 416-744-0123 x290 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.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: Content protection?
Off topic a little I'm looking to find out how possible it is to link the data from an excel spreadsheet into a Powerpoint presentation and then run actions (macros) that use the data in calculations to present various views and scenarios. The deal is ... I can link the Excel file, and I can build a macro in Ap VB, but I can't get the 2 things to play nicely together. Anyone help would be greatly appreciated. Mark -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 1:39 PM To: CF-Talk Subject: Re: Content protection? You could stick the text in a memo field with an onFocus event to automoatically remove the focus from the memo field. That would at least solve the CTRL+V issue. HTH Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Original Message - From: Dharmesh Goel [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 1:09 PM Subject: Content protection? Hello All, We have a need to display some text on our intranet that a user would not be able to print/copy. Would there be any scripts out there anyone can point me to? I guess it will be a script that pops up the html file into a window without any of the menu options with the right click disabled. I want to also stop the user from highlighting the text and copying it using Ctrl+v. Another method I have thought of is displaying the text as an image in a pop up screen with the menu and right click disabled. Has any one come across such a tag that converts text to image on the fly? I understand that there will always be workarounds and it will never be foolproof. Thanks, Dharmesh Goel Programmer Analyst IT Dept. - Discount Car Truck Rentals 416-744-0123 x290 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ANNOUNCEMENT: Northern Alberta ColdFusion Users Group Meeting
Northern Alberta ColdFusion Users Group Meeting Date: Jan 9, 2002 Time: 7:00PM - 9:00PM Location: CompuSmart Edmonton - West End 16810 104A Ave. Edmonton Alberta Everybody's welcome to attend. Mark Zukiwsky __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Linux CF 5 Enterprise (Eval)
Does anybody know if the eval version of CF5 on Linux is full-featured? That is, are there any features that are not available in an evaluation version? We're trying to test out a server with CF5 Enterprise for Linux and we get the following error: Error Diagnostic Information Cannot lock session scope CFLock cannot be used to lock the application or session shared scopes without these scopes being established through the use of the CFApplication tag. You must use CFApplication and specify an application name to use the application scope. If you want to use the session scope you need to enable session management as well. Application and/or Session variables must also be enabled in the ColdFusion Administrator. Yes, we have a cfapplication tag and session management is on and application/session variables are enabled in cf admin. This site is currently working on Win2K, CF5 Pro and we just moved the directory over to the Linux box. Any ideas? Mark __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.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: Linux CF 5 Enterprise (Eval)
The one thing that comes to my mind in the case sensative world of *nix is to make sure that your application.cfm is Application.cfm. It appears that it's not being called and that'd probably be why. Once it's called your cfapplication tag will be called and define use of session or app vars. t ** Tyler M. Fitch Certified Advanced ColdFusion 5 Developer ISITE Design, Inc. 615 SW Broadway Ste. 200 Portland, OR 97205 503.221.9860 ext. 111 http://isitedesign.com ** -Original Message- From: Mark Stewart [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 2:54 PM To: CF-Talk Subject: Linux CF 5 Enterprise (Eval) Does anybody know if the eval version of CF5 on Linux is full-featured? That is, are there any features that are not available in an evaluation version? We're trying to test out a server with CF5 Enterprise for Linux and we get the following error: Error Diagnostic Information Cannot lock session scope CFLock cannot be used to lock the application or session shared scopes without these scopes being established through the use of the CFApplication tag. You must use CFApplication and specify an application name to use the application scope. If you want to use the session scope you need to enable session management as well. Application and/or Session variables must also be enabled in the ColdFusion Administrator. Yes, we have a cfapplication tag and session management is on and application/session variables are enabled in cf admin. This site is currently working on Win2K, CF5 Pro and we just moved the directory over to the Linux box. Any ideas? Mark __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.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: Linux CF 5 Enterprise (Eval)
Ooops, forgot about that little anomoly. That was it! Thanks! Mark -Original Message- From: Tyler M. Fitch [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 6:03 PM To: CF-Talk Subject: RE: Linux CF 5 Enterprise (Eval) The one thing that comes to my mind in the case sensative world of *nix is to make sure that your application.cfm is Application.cfm. It appears that it's not being called and that'd probably be why. Once it's called your cfapplication tag will be called and define use of session or app vars. t ** Tyler M. Fitch Certified Advanced ColdFusion 5 Developer ISITE Design, Inc. 615 SW Broadway Ste. 200 Portland, OR 97205 503.221.9860 ext. 111 http://isitedesign.com ** -Original Message- From: Mark Stewart [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 2:54 PM To: CF-Talk Subject: Linux CF 5 Enterprise (Eval) Does anybody know if the eval version of CF5 on Linux is full-featured? That is, are there any features that are not available in an evaluation version? We're trying to test out a server with CF5 Enterprise for Linux and we get the following error: Error Diagnostic Information Cannot lock session scope CFLock cannot be used to lock the application or session shared scopes without these scopes being established through the use of the CFApplication tag. You must use CFApplication and specify an application name to use the application scope. If you want to use the session scope you need to enable session management as well. Application and/or Session variables must also be enabled in the ColdFusion Administrator. Yes, we have a cfapplication tag and session management is on and application/session variables are enabled in cf admin. This site is currently working on Win2K, CF5 Pro and we just moved the directory over to the Linux box. Any ideas? Mark __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.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: RegExp help needed
Don't forget to cflock the call to cffile! :) Sam - Original Message - From: Jeff Beer [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 2:18 PM Subject: RE: RegExp help needed Holy cow, Don - I was hoping for some tips - you wrote the whole darn thingy! I'll test it right away - thanks mucho for the assist!! Regards, Jeff -Original Message- From: Don Vawter [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 1:29 PM To: CF-Talk Subject: Re: RegExp help needed Try this: cffile action=READ file=foo variable=mf cfscript startpos=1; stTime=refindnocase(DateTime\:[ ]*(\{[^\}]*\}),mf,startpos,yes); while(startpos LT len(mf) and startpos GT 0 and stTime.pos[1] GT 0){ if(arraylen(stTime.pos) GT 1) timeval=mid(mf,stTime.pos[2],stTime.len[2]); else timeval=; writeoutput(timeval ---); startpos=stTime.pos[1]+stTime.len[1]; if(startpos GT 0){ stId=refindnocase(Message_Id\:[ ]*([^]*)p,mf,startpos,yes); if(arraylen(stId.pos) GT 1) idval=mid(mf,stId.pos[2],stId.len[2]); else idval=; writeoutput(idval br); startpos=stId.pos[1]+stId.len[1]; } if (startpos GT 0) stTime=refindnocase(DateTime\:[ ]*(\{[^\}]*\}),mf,startpos,yes); } /cfscript HTH - Original Message - From: Jeff Beer [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 10:43 AM Subject: RegExp help needed Hello all, I have a text file that's a save of a bunch of messages from Outlook. The messages are error reports from CF sent with CFMail. The formatting sucks - I never expected to get a bunch - I was using it for debugging.. anyway, I have several hundred I need to parse. Silly transaction logs The layout is below. What I need to do is get the datetime string and the message ID from each instance of an error message in that file so I can update our database. start 'record' - x:\inetpub\domain\subdir\errorfile.cfmp DateTime: {ts '2002-01-06 00:44:09'}p URL Message_ID: 23660 p Message: ODBC Error Code = 37000 (Syntax error or access violation)Pp Detail: [Microsoft][ODBC SQL Server Driver][SQL Server]The log file for database 'dsdb' is full. Back up the transaction log for the database to free up some log space.PP end 'record' - The file has this format several hundred times over. Reading it in with cffile is simple. What I can't figure out is how to write the pattern matching code to extract the two variables. Also, the logic to make sure I have matching pairs is pretty easy - it's just the RegExps that are killing me. This is probably simple; I could write this in Perl but can't seem to do it in CF. Thanks in advance, Jeff __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
File Locking?
I've heard mention of CFLOCKing CFFILE tags on a few occasions now... This is news to me, so I have a few questions... - should the NAME of the lock be the full path of the file? - if CFFILE needs locking, how about CFDIRECTORY? - should I also lock any calls to the DIRECTORYEXISTS() and FILEEXISTS() functions? Any help would be appreciated :) +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Mark Stewart [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 2:54 PM To: CF-Talk Subject: Linux CF 5 Enterprise (Eval) Does anybody know if the eval version of CF5 on Linux is full-featured? That is, are there any features that are not available in an evaluation version? We're trying to test out a server with CF5 Enterprise for Linux and we get the following error: Error Diagnostic Information Cannot lock session scope CFLock cannot be used to lock the application or session shared scopes without these scopes being established through the use of the CFApplication tag. You must use CFApplication and specify an application name to use the application scope. If you want to use the session scope you need to enable session management as well. Application and/or Session variables must also be enabled in the ColdFusion Administrator. Yes, we have a cfapplication tag and session management is on and application/session variables are enabled in cf admin. This site is currently working on Win2K, CF5 Pro and we just moved the directory over to the Linux box. Any ideas? Mark __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.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: RegExp help needed
Had to write it to make sure regex worked lol - Original Message - From: Jeff Beer [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 12:18 PM Subject: RE: RegExp help needed Holy cow, Don - I was hoping for some tips - you wrote the whole darn thingy! I'll test it right away - thanks mucho for the assist!! Regards, Jeff -Original Message- From: Don Vawter [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 1:29 PM To: CF-Talk Subject: Re: RegExp help needed Try this: cffile action=READ file=foo variable=mf cfscript startpos=1; stTime=refindnocase(DateTime\:[ ]*(\{[^\}]*\}),mf,startpos,yes); while(startpos LT len(mf) and startpos GT 0 and stTime.pos[1] GT 0){ if(arraylen(stTime.pos) GT 1) timeval=mid(mf,stTime.pos[2],stTime.len[2]); else timeval=; writeoutput(timeval ---); startpos=stTime.pos[1]+stTime.len[1]; if(startpos GT 0){ stId=refindnocase(Message_Id\:[ ]*([^]*)p,mf,startpos,yes); if(arraylen(stId.pos) GT 1) idval=mid(mf,stId.pos[2],stId.len[2]); else idval=; writeoutput(idval br); startpos=stId.pos[1]+stId.len[1]; } if (startpos GT 0) stTime=refindnocase(DateTime\:[ ]*(\{[^\}]*\}),mf,startpos,yes); } /cfscript HTH - Original Message - From: Jeff Beer [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 10:43 AM Subject: RegExp help needed Hello all, I have a text file that's a save of a bunch of messages from Outlook. The messages are error reports from CF sent with CFMail. The formatting sucks - I never expected to get a bunch - I was using it for debugging.. anyway, I have several hundred I need to parse. Silly transaction logs The layout is below. What I need to do is get the datetime string and the message ID from each instance of an error message in that file so I can update our database. start 'record' - x:\inetpub\domain\subdir\errorfile.cfmp DateTime: {ts '2002-01-06 00:44:09'}p URL Message_ID: 23660 p Message: ODBC Error Code = 37000 (Syntax error or access violation)Pp Detail: [Microsoft][ODBC SQL Server Driver][SQL Server]The log file for database 'dsdb' is full. Back up the transaction log for the database to free up some log space.PP end 'record' - The file has this format several hundred times over. Reading it in with cffile is simple. What I can't figure out is how to write the pattern matching code to extract the two variables. Also, the logic to make sure I have matching pairs is pretty easy - it's just the RegExps that are killing me. This is probably simple; I could write this in Perl but can't seem to do it in CF. Thanks in advance, Jeff __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFFTP Problem
Hi all, Funnily enough I am having exactly the same problem. The ftp fails and I get an empty file left at the destination. Without knowing more about your setup, one can't really suggest much. There's a knowledge base article on a similar issue which might help: http://www.allaire.com/Handlers/index.cfm?ID=22319Method=Full I checked that article and I am already doing that, ie check that the local file is there and then run the cfftp tag. All appears correct but the actual file never gets transferred. We are running CF4.5.1. -- Yours, Kym __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.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: Source Off Site
Has anyone here ever used source off site? Its an add on to make MS Visual Source available over a tcpip connection. Cheers, Duane __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Is Their a Standard Way of Preventing Users from Entering Double Records by Refreshing Browser?
Is Their a Standard Way of Preventing Users from Entering Double Records by Refreshing Browser? So when I submit A name and Email to a database and then hit refresh on the page I was sent to Another entry appears in the Database with the same information duplicated. Is their a Common Practice in your coding to follow to prevent such a small (yet potentially very common) Data Distortion. Thanks, Dave __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.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: Is Their a Standard Way of Preventing Users from Entering Dou ble Records by Refreshing Browser?
cflocation to a success page (or any template other than the action template) Darryl -Original Message- From: PHP [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 9 January 2002 10:57 AM To: CF-Talk Subject: Is Their a Standard Way of Preventing Users from Entering Double Records by Refreshing Browser? Is Their a Standard Way of Preventing Users from Entering Double Records by Refreshing Browser? So when I submit A name and Email to a database and then hit refresh on the page I was sent to Another entry appears in the Database with the same information duplicated. Is their a Common Practice in your coding to follow to prevent such a small (yet potentially very common) Data Distortion. Thanks, Dave __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.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: Is Their a Standard Way of Preventing Users from Entering Dou ble Records by Refreshing Browser?
Well I usually query the database first to see if the name/email combo exists before inserting it, if so I don't allow it to enter again. So if they do refresh it would prevent that. -Original Message- From: PHP [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 7:57 PM To: CF-Talk Subject: Is Their a Standard Way of Preventing Users from Entering Double Records by Refreshing Browser? Is Their a Standard Way of Preventing Users from Entering Double Records by Refreshing Browser? So when I submit A name and Email to a database and then hit refresh on the page I was sent to Another entry appears in the Database with the same information duplicated. Is their a Common Practice in your coding to follow to prevent such a small (yet potentially very common) Data Distortion. Thanks, Dave __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.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: Is Their a Standard Way of Preventing Users from Entering Double Records by Refreshing Browser?
yup...use CFLOCATION to send the user to a confirmation page after a successful INSERT. Then if they refresh that page al they are doing is re-displaying the confirmation message and not re-running the INSERT query. Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Original Message - From: PHP [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 4:56 PM Subject: Is Their a Standard Way of Preventing Users from Entering Double Records by Refreshing Browser? Is Their a Standard Way of Preventing Users from Entering Double Records by Refreshing Browser? So when I submit A name and Email to a database and then hit refresh on the page I was sent to Another entry appears in the Database with the same information duplicated. Is their a Common Practice in your coding to follow to prevent such a small (yet potentially very common) Data Distortion. Thanks, Dave __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.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: Is Their a Standard Way of Preventing Users from Entering Dou ble Records by Refreshing Browser?
Dave, You would probably like to implement a javascript block to stop the form from being submitted twice, as well as an appropriate server side double check (possibly as below) Jared Clinton. -Original Message- From: Kelly Matthews [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 9 January 2002 10:56 AM To: CF-Talk Subject: RE: Is Their a Standard Way of Preventing Users from Entering Dou ble Records by Refreshing Browser? Well I usually query the database first to see if the name/email combo exists before inserting it, if so I don't allow it to enter again. So if they do refresh it would prevent that. -Original Message- From: PHP [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 7:57 PM To: CF-Talk Subject: Is Their a Standard Way of Preventing Users from Entering Double Records by Refreshing Browser? Is Their a Standard Way of Preventing Users from Entering Double Records by Refreshing Browser? So when I submit A name and Email to a database and then hit refresh on the page I was sent to Another entry appears in the Database with the same information duplicated. Is their a Common Practice in your coding to follow to prevent such a small (yet potentially very common) Data Distortion. Thanks, Dave __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.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: Is Their a Standard Way of Preventing Users from Entering Double Records by Refreshing Browser?
about a year ago, I wrote this article (joseph thompson did the write up) w hich covers some ideas to disable back buttons. http://cfhub.com/contributions/backbutton/ with the code you can also catch double clicks, Mahmut Basaran Measure twice Cut once -- Original Message -- from: PHP [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Tue, 08 Jan 2002 19:56:33 -0500 Is Their a Standard Way of Preventing Users from Entering Double Records b y Refreshing Browser? So when I submit A name and Email to a database and then hit refresh on th e page I was sent to Another entry appears in the Database with the same information duplicated. Is their a Common P ractice in your coding to follow to prevent such a small (yet potentially very common) Data Distortion. Thanks, Dave __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.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: Is Their a Standard Way of Preventing Users from Entering Double Records by Refreshing Browser?
Standard database procedures in all cases unless you are 100% certain that the record cannot exists is to read before write..check the database to see if the record exists before inserting it. If it does, and you're on a page that only does inserts, you can throw away the second instance or update the existing record. At 07:56 PM 1/8/02, Dave wrote: Is Their a Standard Way of Preventing Users from Entering Double Records by Refreshing Browser? __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
How to modify a dll
I have an issue with Studio and from searching the forums I need to change the MSVCRT.dll file to an older version by changing the modification date of it to the most current date. Does anyone know how I do that? I'm a bit new to the dll stuff! Jeff _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.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: Error CFPOP in CF5.0 linux
Hi, is anyone try cfpop in coldfusion 5.0 in linux cobalt cube. I try to grab email from exchange server, but there is an error on connection. But when rum on my windows 2000 nt server with coldfusion 5 for windows. It runs well. Thanks. guys FAQ: http://www.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: Open Multiple Rich Text Format (RTF) Files On One Page
If you have the actual RTF code stored in the db then this could work for you. cfset output='' cfoutput query=q cfset output=output rtfData '\page ' /cfoutput You would then need to output the output variable to a temp file and use CFCONTENT to serve that file to the client. HTH, Joseph DeVore VeloxWeb Technologies -Original Message- From: Gary Groomer [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 6:25 PM To: CF-Talk Subject: Open Multiple Rich Text Format (RTF) Files On One Page Does anyone know how to open multiple Rich Text Format (RTF) files on one html page? The text for the RTF files will be stored in a database and each file will have it's own fonts and layout that needs to be maintained. Any ideas would be greatly appreciated. Gary Groomer __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.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: Source Off Site
Yes, It's basically a client to the visual source safe repositry. I had no problems with it (updates, commits, tagging all went smoothly) On Tue, 8 Jan 2002, Duane Boudreau wrote: Has anyone here ever used source off site? Its an add on to make MS Visua l Source available over a tcpip connection. Cheers, Duane __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How to modify a dll
Not sure what you mean here, are you the one creating the dll. If so when you register a dll the system then knows it can use it, if you make changes to this dll, you will need to unregister it with the server. However if this is not the case then you'll need to find a decompiler to turn it into the source that you need (Yes, very legal issues with doing this). Now the other thing is that although you unregistered the dll it might take sometime for it to clear out of the system resources. So I reset of the computer might be needed, what I usually do in this case is register, unregister and give it a number of the classname. But you'll need to remember to put the classname back to what you want it to be. Haven't done this under windows 2000, it might clear it straight away when unregistered anyone else care to comment! -Original Message- From: Jeff Reilly [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 9 January 2002 12:10 PM To: CF-Talk Subject: How to modify a dll I have an issue with Studio and from searching the forums I need to change the MSVCRT.dll file to an older version by changing the modification date of it to the most current date. Does anyone know how I do that? I'm a bit new to the dll stuff! Jeff _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.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: problem with dynamic data in my select boxes
Yeah I forgot to stick that in there. Woops There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown - Original Message - From: Raymond Camden [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 12:17 PM Subject: RE: problem with dynamic data in my select boxes Errr, won't this mean that every value AFTER the correct one will also be marked selected? Sure the browser will use the first one, but that i'snt good. I'd add a cfset select = before the cfif. -Raymond cfset thisDecisionID = getReviewers.decisionID CFLOOP query=getDCodes CFIF getDCodes.decisionID EQ thisDecisionID CFSET select = SELECTED /CFIF option value=#decID# #select# There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown - Original Message - From: Billy Cravens [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 11:37 AM Subject: Re: problem with dynamic data in my select boxes When you start iterating through your inner query, it loses its place in the first query - meaning, referencing a column from the outtermost query and expecting it to know what row it is on. Like referencing query.column outside of a query loop, it defaults to the first row's value. You should save the column value in a local variable before entering the inner query loop: cfset thisDecisionID = getReviewers.decisionID CFLOOP query=getDCodes option value=#decID# CFIF getDCodes.decisionID EQ thisDecisionIDselected/cfif - Original Message - From: Tammy Hong [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 12:52 PM Subject: problem with dynamic data in my select boxes Hi everyone, Can someone please point to me what the problem here is? I basically have two queries. One pulls out the record set for a particular ID number and is grouped in a cfoutput based on another ID number. The problem is that when I have more than one dynamically populated select box with the HTML below, the ID that is selected is not the right one. It will select the first decID of the first reviewer that is outputted. I am sure this is the right way to reference the variables. Can someone point me to the incorrect logic? Please! I'm about to pull my hair out. See below: CFOUTPUT query=getReviewers group=reviewerID select name=decID option value=0[Select a decision]/option CFLOOP query=getDCodes option value=#decID# CFIF getDCodes.decisionID EQ getReviewers.decisionIDselected/cfif #trim(decisionDescription)#/option /CFLOOP /select /CFOUTPUT Tammy __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.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: problem with dynamic data in my select boxes
Should have been like so.. cfset thisDecisionID = getReviewers.decisionID CFLOOP query=getDCodes CFIF getDCodes.decisionID EQ thisDecisionID CFSET select = SELECTED CFELSE CFSET select = /CFIF option value=#decID# #select# There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown - Original Message - From: Raymond Camden [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 12:17 PM Subject: RE: problem with dynamic data in my select boxes Errr, won't this mean that every value AFTER the correct one will also be marked selected? Sure the browser will use the first one, but that i'snt good. I'd add a cfset select = before the cfif. -Raymond cfset thisDecisionID = getReviewers.decisionID CFLOOP query=getDCodes CFIF getDCodes.decisionID EQ thisDecisionID CFSET select = SELECTED /CFIF option value=#decID# #select# There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown - Original Message - From: Billy Cravens [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 11:37 AM Subject: Re: problem with dynamic data in my select boxes When you start iterating through your inner query, it loses its place in the first query - meaning, referencing a column from the outtermost query and expecting it to know what row it is on. Like referencing query.column outside of a query loop, it defaults to the first row's value. You should save the column value in a local variable before entering the inner query loop: cfset thisDecisionID = getReviewers.decisionID CFLOOP query=getDCodes option value=#decID# CFIF getDCodes.decisionID EQ thisDecisionIDselected/cfif - Original Message - From: Tammy Hong [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 12:52 PM Subject: problem with dynamic data in my select boxes Hi everyone, Can someone please point to me what the problem here is? I basically have two queries. One pulls out the record set for a particular ID number and is grouped in a cfoutput based on another ID number. The problem is that when I have more than one dynamically populated select box with the HTML below, the ID that is selected is not the right one. It will select the first decID of the first reviewer that is outputted. I am sure this is the right way to reference the variables. Can someone point me to the incorrect logic? Please! I'm about to pull my hair out. See below: CFOUTPUT query=getReviewers group=reviewerID select name=decID option value=0[Select a decision]/option CFLOOP query=getDCodes option value=#decID# CFIF getDCodes.decisionID EQ getReviewers.decisionIDselected/cfif #trim(decisionDescription)#/option /CFLOOP /select /CFOUTPUT Tammy __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.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 Modifying Source File in DTS package
You want to change the source file of the DTS or of a CFM? The DTS source is typically stored on the DB inside the MSDB database, and is not easy to get to, in fact, I have never actually found all of it. If I remember correctly it is stored in a binary column, which would be very difficult to edit. Can you give me some more info? At 01:06 AM 1/8/2002 -0700, you wrote: I have a DTS package which I use to import IIS log files into SQL Server 2000. How can I change the source file programaticallly and then run the package. I really am a newbie at DTS but I guess you can tell that. I know that I could always do the import with cf but it seems kind of silly to involve cf for a purely database function. TIA Don __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.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: problem with dynamic data in my select boxes
Man I am t tired. I meant to say cfset thisDecisionID = getReviewers.decisionID CFLOOP query=getDCodes CFIF getDCodes.decisionID EQ thisDecisionID CFSET select = SELECTED CFELSE CFSET select = option value=#decID# #select# /CFIF There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown - Original Message - From: Douglas Brown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 7:35 PM Subject: Re: problem with dynamic data in my select boxes Should have been like so.. cfset thisDecisionID = getReviewers.decisionID CFLOOP query=getDCodes CFIF getDCodes.decisionID EQ thisDecisionID CFSET select = SELECTED CFELSE CFSET select = /CFIF option value=#decID# #select# There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown - Original Message - From: Raymond Camden [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 12:17 PM Subject: RE: problem with dynamic data in my select boxes Errr, won't this mean that every value AFTER the correct one will also be marked selected? Sure the browser will use the first one, but that i'snt good. I'd add a cfset select = before the cfif. -Raymond cfset thisDecisionID = getReviewers.decisionID CFLOOP query=getDCodes CFIF getDCodes.decisionID EQ thisDecisionID CFSET select = SELECTED /CFIF option value=#decID# #select# There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown - Original Message - From: Billy Cravens [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 11:37 AM Subject: Re: problem with dynamic data in my select boxes When you start iterating through your inner query, it loses its place in the first query - meaning, referencing a column from the outtermost query and expecting it to know what row it is on. Like referencing query.column outside of a query loop, it defaults to the first row's value. You should save the column value in a local variable before entering the inner query loop: cfset thisDecisionID = getReviewers.decisionID CFLOOP query=getDCodes option value=#decID# CFIF getDCodes.decisionID EQ thisDecisionIDselected/cfif - Original Message - From: Tammy Hong [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 12:52 PM Subject: problem with dynamic data in my select boxes Hi everyone, Can someone please point to me what the problem here is? I basically have two queries. One pulls out the record set for a particular ID number and is grouped in a cfoutput based on another ID number. The problem is that when I have more than one dynamically populated select box with the HTML below, the ID that is selected is not the right one. It will select the first decID of the first reviewer that is outputted. I am sure this is the right way to reference the variables. Can someone point me to the incorrect logic? Please! I'm about to pull my hair out. See below: CFOUTPUT query=getReviewers group=reviewerID select name=decID option value=0[Select a decision]/option CFLOOP query=getDCodes option value=#decID# CFIF getDCodes.decisionID EQ getReviewers.decisionIDselected/cfif #trim(decisionDescription)#/option /CFLOOP /select /CFOUTPUT Tammy __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.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: Source Off Site
What is the OS of the server you have VSS installed on? I installed it on Win2k and when the client tries to download the projects the server produces a beautiful BSOD. Duane -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 9:45 PM To: CF-Talk Subject: Re: OT: Source Off Site Yes, It's basically a client to the visual source safe repositry. I had no problems with it (updates, commits, tagging all went smoothly) On Tue, 8 Jan 2002, Duane Boudreau wrote: Has anyone here ever used source off site? Its an add on to make MS Visua l Source available over a tcpip connection. Cheers, Duane __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.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 Modifying Source File in DTS package
All I want to do is import the log files daily and the name of the logfile changes every day. Right now I am just handling it in CF instead of using DTS but it seems like DTS would be a more efficient way. - Original Message - From: Nick McClure [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 8:23 PM Subject: Re: OT Modifying Source File in DTS package You want to change the source file of the DTS or of a CFM? The DTS source is typically stored on the DB inside the MSDB database, and is not easy to get to, in fact, I have never actually found all of it. If I remember correctly it is stored in a binary column, which would be very difficult to edit. Can you give me some more info? At 01:06 AM 1/8/2002 -0700, you wrote: I have a DTS package which I use to import IIS log files into SQL Server 2000. How can I change the source file programaticallly and then run the package. I really am a newbie at DTS but I guess you can tell that. I know that I could always do the import with cf but it seems kind of silly to involve cf for a purely database function. TIA Don __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.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 Modifying Source File in DTS package
You are probably correct. Unfortunately to the best of my knowledge there is no way to change the input filename. I have run into this before. One of the things you can as part of the DTS is run a batch file, use the Execute Process task. I would create a batch file that would make a copy of the file with name you have selected for your input tasks. At the end of the DTS delete the copy. I have done this before with both text files and Excel spread sheets. It works pretty well as long as you have the disk space to hold the copy. At 08:31 PM 1/8/2002 -0700, you wrote: All I want to do is import the log files daily and the name of the logfile changes every day. Right now I am just handling it in CF instead of using DTS but it seems like DTS would be a more efficient way. - Original Message - From: Nick McClure [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 08, 2002 8:23 PM Subject: Re: OT Modifying Source File in DTS package You want to change the source file of the DTS or of a CFM? The DTS source is typically stored on the DB inside the MSDB database, and is not easy to get to, in fact, I have never actually found all of it. If I remember correctly it is stored in a binary column, which would be very difficult to edit. Can you give me some more info? At 01:06 AM 1/8/2002 -0700, you wrote: I have a DTS package which I use to import IIS log files into SQL Server 2000. How can I change the source file programaticallly and then run the package. I really am a newbie at DTS but I guess you can tell that. I know that I could always do the import with cf but it seems kind of silly to involve cf for a purely database function. TIA Don __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.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: Forums App?
Simple Message Board, though my site is down right now. Email me for the latest release. I'm looking for an inexpensive (read: FREE) canned forums app that I co uld drop into an existing site with minimal modification to the existing cod e. I've looked at the CF-Talk archives and came up with a few leads, includi ng Open Forums and Active Forum. Could anyone recommend any other forum packages? Thanks! Christian N. Abad ColdFusion Web Developer __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
how to prevent user from opening multiple browsers..
hi people... how do u ppl prevent yr user to open multiple internet browsers to run yr application concurrently..? for instance.. if i login into my system as userA.. the system will assign its details.. to specific session variables... but if i open up another browser and login as User.. all the session values will be overwritten... so anyone know how to prevent that to happen.. or any other way to differentiate each browser application...? cheers han __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.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: CFGraph problems / Jrun
No load balancing, and reinstalling isn't an option. Neil - Original Message - From: Ron Anderson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, January 06, 2002 6:40 PM Subject: RE: CFGraph problems / Jrun Are your servers load balanced? -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 06, 2002 10:06 AM To: CF-Talk Subject: CFGraph problems / Jrun Error: I am getting the JRun error again: Could not connect to JRun Connector Proxy When using CFGraph I Have a customer who has this problem over and over again. I even ran the hotfix for zeros in CFgraph but there still is a problem. Is it possible there is a new JVM I should use. Could someone offer some suggestions. Generally to fix the problem I have to restart the graphing service. Thanks, Neil __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: how to prevent user from opening multiple browsers..
Because it becomes reliant on the cookie, if you open a new browser from within the browser it keeps the same properties. However I think if you click on the icon, or run it as a new IE/Netscape it might be different but I think this changed since V4.0 browsers. -Original Message- From: han peng [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 9 January 2002 4:02 PM To: CF-Talk Subject: how to prevent user from opening multiple browsers.. hi people... how do u ppl prevent yr user to open multiple internet browsers to run yr application concurrently..? for instance.. if i login into my system as userA.. the system will assign its details.. to specific session variables... but if i open up another browser and login as User.. all the session values will be overwritten... so anyone know how to prevent that to happen.. or any other way to differentiate each browser application...? cheers han __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists