RE: Pausing using CF

2002-04-11 Thread Rick Osborne [mojo]
Michael Tangorre asked: > Can anyone think of a way that I can achieve a pause for like 30 > seconds to a minute between iterations in a loop? This question gets asked quite a bit, so I figured I'd forward my alternative. Elapsed: #Elapsed#ms It's nicer p

RE: record session timeout

2002-04-09 Thread Rick Osborne [mojo]
I can think of several different ways, each with their own pros and cons. Instead of thinking in terms of when a Session *has timed out*, think in terms of when a Session *will time out*. 1. Update your DB with the current time {NOW()} plus your session timeout length every time the user hits a

CF & IIS - Directories with '.com'

2002-03-28 Thread Rick Osborne [mojo]
I've run up against IIS's wonderful inability to correctly parse virtual paths before, but this one has me stumped. If I have a folder "test.com" on my web server (a domain name for a client's site we are working on), any CF files that are under the directory with the ".com" in the name are all p

RE: Reading ID3-Tags w/ColdFusion

2002-03-25 Thread Rick Osborne [mojo]
I wrote a CFX tag that parses out ID3v2 tags, but it is more Prrof-of-Concept that production-quality. It comes with full source, so you are welcome to hack on it to do what you want. http://www.rixsoft.com/ColdFusion/CFX/MP3Dir/ HTH, -R -Original Message- From: VAN VLIET, SCOTT E (S

RE: alternating rows

2002-03-18 Thread Rick Osborne [Mojo]
Whoops. That last one was from me. Sorry about that, folks. I think I pasted Michael's email into the From field instead of the CC field. Didn't want anyone to think I was trying to pull a fast one or anything ... -R -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED

Decryption Licensing Verbiage/Copy

2002-03-07 Thread Rick Osborne [Mojo]
We're looking to add some verbiage/copy to our licensing agreements that says something to the effect of "decrypting any encrypted templates violates the terms of this license". Our management-types want it to sound more authoritative (and nastier) than that. Does anyone have anything in their l

RE: request scope.

2002-01-31 Thread Rick Osborne [Mojo]
Jeffry Houser said: > I don't see much use beyond "A way to avoid sending > parameters to custom tags." Unless I'm mistaken the > only difference between the variables scope and the > request scope is that variables in the request scope > are available to custom tags. Actually, I just thought

RE: Build your own

2002-01-10 Thread Rick Osborne [Mojo]
Ron Anderson asked: > Has anyone reached the point of frustration with CFGraph, > where they've just built their own? I did, but I did it in Perl with the GD module. http://www.rickosborne.org/<-- Look at the Insomniograph for an example I've got a coworker here who says his friend built a

RE: Cfcontent performance issues?

2002-01-04 Thread Rick Osborne [Mojo]
Kay Smoljak asked: >> Also, the other recommendation was to get the web server >> to handle this. I will be on IIS5 on Win2K, on shared >> hosting, but my host is usually quite accomodating when >> it comes to setting things up for me. To which Dave Watts replied: > You might be able to do some

RE: general question about naming conventions

2001-12-21 Thread Rick Osborne [Mojo]
Mark Smeets asked: > When dealing with databases, how do you name your columns? Personally, I use the following structure, but I don't really have any rationale for it. foo_id int foo_dt datetime foo_d date is_foo boolean foo_tx string (could be char, or varchar,

RE: Listing MP3 files and alowing either Download or Run

2001-12-17 Thread Rick Osborne [Mojo]
I set up a music server for our Intranet a few months ago and wrote a CFX tag and a really quick-n-simple browser interface for it. (For those whom using a file interface was too difficult. :p~~~ ) It uses IceCast running on a Linux server, but it could just as easily use NFS or SMB or whatever

RE: Writing to text file

2001-12-11 Thread Rick Osborne [Mojo]
Dave recommended using a single variable: : : : : : : Actually, you could take this one step further and make it pretty transparent: #fname#,#lname# Then, your CF_SaveFileContent tag is really simple: You can do pretty much *anything* you want in that first set of tags. Ou

RE: regex find form vars in queries?

2001-12-07 Thread Rick Osborne [Mojo]
That solution will only work in Perl. The CF regex engine cannot handle non-greedy matching. If you do more than a little work with regexes you may want to consider downloading my (completely free) PCRegEx CFX tag, which gives CF Server Perl-Compatible regexes, including non-greedy matching. URL

RE: CFX for Solaris (not offering a solution, just an AOL and a gripe)

2001-12-06 Thread Rick Osborne [Mojo]
Jordie Fike asked: > Is there somewhere to go to get popular custom tags that > have been ported over to run on Solaris? Does anyone have > a URL that might point me in the right direction? AOL I don't have a solution for you, however I sincerely hope you do find one. If you do, please let m

RE: Text Compression Utility?

2001-12-05 Thread Rick Osborne [Mojo]
Alex wrote: > Then this has nothing to do with coldfusion. Your webserver > handles this. IIS has compression and Apache has mod_gzip > as a compressor. Actually, theoretically, you *could* do this with CF. Use CFHEADER to return the correct Content-Encoding (or Transfer-Encodeing) header and t

RE: Text Compression Utility?

2001-12-04 Thread Rick Osborne [Mojo]
You may want to look into the "Content-Encoding" HTTP header. Your web server can actually compress the text file on the fly, and if your web browser is smart enough to accept it you will accomplish exactly what you are looking for. I think IIS5 has an ISAPI filter that does this automagically.

RE: Regular Expression

2001-12-04 Thread Rick Osborne [Mojo]
Don Vawter wrote: > Pardon me for being naive but isnt it a lot easier to just > combine regex and regular find trying to match a substring > like this? > [...] > If find regex invaluable but sometimes combining with a plain > old find makes my life simpler. Very, very true. There's more than o

RE: Regular Expression

2001-12-04 Thread Rick Osborne [Mojo]
I know it looks nasty, but this is what I came up with: ]+textline\.cfm[^>[:space:]]*([[:space:]]+[^M][^A=]? [^X=]?[^H=]?[^S=]?[^I=]?[^Z=]?[^E=]?[_[:alnum:]]*=("[^"]*"|[^>[:space:]]*))+ [[:space:]]*> I used the following test cases: It correctly found the 3 lines that do *not* have the M

RE: Best practices storing CC

2001-11-16 Thread Rick Osborne [Mojo]
Don Vawter asked: > Any advice on storing credit card info? We're pretty radical about our beliefs on CC#'s: We don't keep them *anywhere*. We keep the last 4 digits and the CC type, and that's it. The CC# gets immediately PGP encrypted [1] and emailed to our processing center, where it is sto

RE: REFindNoCase and "]"...

2001-11-15 Thread Rick Osborne [Mojo]
Lee Fuller asked: > Ok.. I've tried just about every way I know of to escape > this puppy (the "]" character) so that I can search for it > in a string using REFindNoCase. In a character class, you have to make the right bracket the first character: []whatevr]+ -R

RE: Merant ODBC driver docs

2001-11-15 Thread Rick Osborne [Mojo]
Jim- I can't help you with your first problem, (and it looks like some people already have) but I may be able to help you with your second. > > SELECT table1.*, table2.something > FROM table1 INNER JOIN table2 ON table2.key1 = table1.key1 > WHERE table1.id = #somevalue# > > gives an error: > [

RE: Val() vs. IsNumeric

2001-11-15 Thread Rick Osborne [Mojo]
Chris Norloff asked: > The question is whether to use Val() or IsNumeric to prevent > non-numeric characters from being inserted/updated to the > database. I know this is an individual choice based on your > own need, but I'm curious what others use. > Val() or IsNumeric? Personally, I use IsNume

Request for comments : CFThreaded

2001-11-15 Thread Rick Osborne [Mojo]
What would be really useful to me would be the ability to asynchronously thread sections of my CF code. So, here's my recommendation. If I can get some feedback from y'all, then I'll throw it at the development team at Allaire/Macromedia and see what they think of it. I wish I'd thought to do t

RE: find inputs with no maxlength

2001-11-09 Thread Rick Osborne [Mojo]
Maybe something like: It's not perfect, but it worked on a couple of really rudimentary tests I just ran. -R -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Friday, November 09, 2001 17:37 To: CF-Talk Subject: RE: find inputs with no maxlength > Does anyone know

RE: Really delayed evaluation

2001-10-30 Thread Rick Osborne [Mojo]
How are you summing the data? Is it coming from a query? One of the hacks I use quote a bit is basically a one-line QuerySum() function: I tend to find it takes a fraction of the time that looping over the query does. If your situation is a bit more complex, you may want to consider using a

RE: Delaying template execution

2001-10-29 Thread Rick Osborne [Mojo]
Brian Ferrigno said: > the code does work by creating a deadlock for the session Deadlock, not race condition. Quite right. Too many Krispy Kremes for me. Point being, it blocks and *does not* spike your processor or anything lame like that. The only downside is that it blocks all other locks

RE: Delaying template execution

2001-10-29 Thread Rick Osborne [Mojo]
Brian Ferrigno asked: > What would be the best way to dealy the execution of a cf > tamplate by x amount of seconds? Simplest way: Elapsed: #Elapsed#ms Of course, this will lock your entire session. Anything else trying to obtain a lock in that sessionwi

RE: CFmail Recount

2001-10-29 Thread Rick Osborne [Mojo]
Tom Muck said: > That would be good for small jobs, but I need to take jobs > of 400,000 Actually, the system I described works on jobs of ~200,000 mails. I think we run ~20,000 mails per hour, if memory serves. Yeah, that would take 20 hours to process your list of 400,000, but then that's th

RE: CFmail Recount

2001-10-29 Thread Rick Osborne [Mojo]
I said: >> We had a similar problem and got around it by making our code smart enough >> to only spool mail if there is less than 200 files in the spool directory. >> Otherwise, it waits a minute and tries again. Sure, you may not be getting >> optimal efficiency out of your mail spool, but you'

RE: CFmail Recount

2001-10-29 Thread Rick Osborne [Mojo]
Tom muck said: > Unfortunately, ColdFusion doesn't give us the option to split the > spool directory into mulitple directories, so the server will > automatically write all the spool files out to that directory up to > 65,535 files before crapping out. Then it only sifts through them at > the rat

RE: *** Complicated SQL riddle

2001-10-29 Thread Rick Osborne [Mojo]
Jason asked: >That's the problem - I need to keep it flexible to accommodate any >number of levels because I want to output a tree illustrating the >hierarchy: >I think I've heard someone talking about "self-joins" but am not sure >how they'd work and whether they'd be flexible enough - anyone h

RE: Bar Code Scan

2001-08-21 Thread Rick Osborne [Mojo]
Paris Lundis asked: > in order to get the clueless cat to work with the cold fusion app, > do I only need to install the cue cat software? Or is there something > else instead to use... You don't even need that much. Actually, I think installing (and running) their software would probably interf

RE: Bar Code Scan

2001-08-21 Thread Rick Osborne [Mojo]
Back when CueCats were all the rage, I wrote a CF app that would take the input from it, decode it, and do neat things with the UPC. Being the geek that I am, I didn't have much use for it beyond cataloguing my (comic) books. But, it all really depends on your scanning hardware. The CueCat is a

RE: Alternating BG colors on a

2001-08-21 Thread Rick Osborne [Mojo]
Chad Gray asked: > When using a tag on a table how do i get every other > to have a background color? My favorite way: .evenrow { background-color: silver; } .oddrow { background-color: gray; } #CurrentRow# This allows me to define any styles I want in the STYLE part, including back

RE: WAY OT: Project Management Tools

2001-08-21 Thread Rick Osborne [Mojo]
pport resources, visit: http://www.macromedia.com/support/ For Customer Service and all Macromedia contacts, visit: http://www.macromedia.com/macromedia/index_contact.fhtml -Original Message----- From: Rick Osborne [Mojo] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 21, 2001 11:39 To: CF-T

RE: WAY OT: Project Management Tools

2001-08-21 Thread Rick Osborne [Mojo]
Brian Yager asked: > My management is sick of Microsoft Project and wants to find another > project management tool. Actually, this may not be as OT as you think. I got this email the other day. I haven't had a chance to check it out yet, so I can't give you any recommendations, but it might be

Black Hats (was: Developers Exchange very slow)

2001-08-20 Thread Rick Osborne [Mojo]
Billy Cravens said: > There's no telling what's running [on the Allaire site]. I know it's > a different system, but about a month ago I hit the beta.allaire.com > forums, and it crashed, and [...] I got a standard Access database error! Speaking of which ... I think this raises an interesting p

RE: An extra line of defense for you IIS-types

2001-08-14 Thread Rick Osborne [Mojo]
Tom said: >Basically you're saying that it's an option now but the next >worm may be able to circumvent this as well using >simple reverse DNS lookup. Yes and no. We can get away with it because we are using pure virtual hosting. If someone does a reverse lookup of our primary server they get a

An extra line of defense for you IIS-types

2001-08-13 Thread Rick Osborne [Mojo]
Rick OsborneI realize this is a bit off-topic, but ... I spent a few hours last week going through logs in an attempt to analyze how much we were affected by Code Red, even though we were never actually vulnerable. (We have a guy here who is a patch zealot.) I was just curious to see how many t

RE: CF Studio: Can Regular expression replace form.* ?

2001-08-09 Thread Rick Osborne [Mojo]
This works for me: Replace: #(Form.[[:alnum:]_]+)# With: #Trim(\1)# Of course, if you want it to handle more complex scenarios (Functions, Structures, etc), you'll have to do a bit of tweaking. -R P.S. - Regexs under CF suck! -Original Message- From: Mark W. Breneman [mailto:[EM

RE: How can I use CF to push data into a statistical package or an Ex cel spreadsheet?

2000-12-04 Thread Rick Osborne [Mojo]
Tim Dempsey asked: > How do I take that data and get it into Excel on the client's machine? We had to do something like this last month (with Doughnut charts instead of Pie charts, but it's close enough). I never could get it to work 100% in CF, as Excel wouldn't honor my Quit() command and woul

RE: Excel Charts

2000-11-13 Thread Rick Osborne [Mojo]
Strike that, I found it: http://www.cfcomet.com/cfcomet/excel/ -R -Original Message- From: Rick Osborne [Mojo] [mailto:[EMAIL PROTECTED]] Sent: Monday, November 13, 2000 20:05 To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Subjec

RE: Excel Charts

2000-11-13 Thread Rick Osborne [Mojo]
This URL seems to be toasty. Does anyone happen to know where it might have been moved to? -Original Message- From: Simon Horwith [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 26, 2000 17:11 To: CF-Talk Subject: RE: Excel Charts go to: http://www.cfm-resources.com/members/comet/

RE: Novell Advanced Security Woes

2000-11-05 Thread Rick Osborne [Mojo]
FYI, I wrote an ISAPI DLL for IIS to do pretty much exactly what Steve talks about at the end there. It is completely free and comes with source. It is available at: http://www.rixsoft.com/NWAuth/ Of course, it means that IIS does the authentication instead of CF, but that may be good or bad d

RE: Finding a query in a file

2000-10-24 Thread Rick Osborne [Mojo]
Something like this will probably work for you: This will deal with the case of having non-alphanumeric tag attributes in random order. -Rick -Original Message- From: Christopher S Martin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 24, 2000 12:25 To: CF-Talk Subject: Finding a

RE: SP2 Enhancement Speculation (was Threading Issue)

2000-10-19 Thread Rick Osborne [Mojo]
I said: >> >> >> >> To which Dave said: > You can do this in 4.5.x with StructInsert. If you specify a fourth > argument, you can allow it to both insert and update: > Ummm, not quite. It'd be more like: But, you can't do that because the StructFind() will fail if var is not alread

SP2 Enhancement Speculation (was Threading Issue)

2000-10-19 Thread Rick Osborne [Mojo]
Is there documentation anywhere on what some of these enhancements (will) do? Just looking at the function names, I have a few questions. The beta site seems to have a definite paucity of information in this respect, but maybe I'm just not finding it. (Yes, yes, I know, it's beta so the functio

RE: What sort of RegEx does Cold Fusion Support?

2000-10-17 Thread Rick Osborne [Mojo]
Christopher S Martin asked: > How well does ColdFuison support Regular Expressions? Ah, the topic has come 'round again. :) This question gets asked about once a month, so I guess it was time again. :) But, if no one asked it, then I wouldn't have an excuse to plug my CFX tag. Ahem-hem. Th

RE: Thanks was RE: returning top 10

2000-10-16 Thread Rick Osborne [Mojo]
Easiest way? Recycle your new "Top 10" query as a subquery. SELECT student_pop FROM table1 WHERE student_pop NOT IN ( SELECT top 10 student_pop FROM table1 ORDER BY whatever ) -Rick -Original Message- From: Jim Watkins [mailto:[EMAIL PROTECTED]] Sent: Monday, October 16, 2000 22:

MS SQL Server connectivity from Solaris?

2000-10-06 Thread Rick Osborne \(Mojo\)
Does anyone have MS SQL Server connectivity running on Solaris? I know that Merant has a Linux driver for MSSS, but I wasn't able to find a parallel for Solaris. I was also thinking I could just use the Informix Sybase drivers (hello, same codeline, and it works in Win32), but that went bottoms-

RE: Harder Math Question (Cayley-Purser)

2000-10-03 Thread Rick Osborne \(Mojo\)
It's the Cayley-Purser Algorithm for encryption. See: http://www.cayley-purser.ie/ I thought this was a broken algorithm? Yes, no? As for translating it to CF, why? Why not just use RSA or Twofish or DES? (Or, if you want to be really topical, use Rijndael. (sp?)) The patent for RSA is ove

[announce] PCRegEx final alpha (first beta) v0.1a available

2000-09-28 Thread Rick Osborne \(Mojo\)
I've wrapped up initial work on CFX_PCRegEx and am freezing the code for everything except bug fixes. It now does everything the REFind, REReplace, and their case-insensitive equivalents do, and more. It's primary objective is to support perl-style regexes, which it does exceedingly well. CFX_P

RE: [Very OT] Embedding the PCRE Engine in a CFX

2000-09-27 Thread Rick Osborne \(Mojo\)
I thought about going the COM object route, but that's more of a pain than it's worth at this point. Maybe eventually. As for CORBA, I've never done any CORBA programming. I'll have to look into it. -Original Message- From: Jared Clinton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, Sept

[Kinda OT?] Embedding the PCRE Engine in a CFX

2000-09-26 Thread Rick Osborne \(Mojo\)
(This may be OT, as I'm not sure what the list's policy is on this kind of thing, but I'm just tryin' to help, so I'll give it a shot.) In light of the vast number of questions we get on the list about the brokenness of the regular expression engine in CF, I've created a CFX tag that uses the PCR

RE: CFMODULE and weird space

2000-09-26 Thread Rick Osborne \(Mojo\)
I noticed that 4.5.1 does this. I fiddled with tags all over the place, and making sure that I never called a module from withing CFOUTPUT tags, and that seems to have cleared it up. I don't know specifically what did it, though. I'm just letting you know that you're not crazy, as it is indeed

RE: Money for Nothing & Chicks for Free?

2000-09-25 Thread Rick Osborne \(Mojo\)
Someone going by the nym "Hydra" said: >I continue to be mystified by these kinds of discussions. Would >someone take a moment to explain this phenomenon? Kindly. >If someone really writes a "FreeCF" and the Allaire Corp. goes >down the tubes, then will we really all be better off? What what?

RE: Crazy idea? (topical, but not programming)

2000-09-23 Thread Rick Osborne \(Mojo\)
Allaire gets how many thousand dollars per copy of CF? Do we *really* think they're going to GPL (or even just OpenSource) it any time soon? I'm naive, but I'm not *that* naive. :) I've often pondered the feasibility of writing a "FreeCF" of some sort. (More and more lately, actually.) Of cou