RE: reg ex for url extraction..

2006-03-27 Thread Munson, Jacob
I meant to remove the email address suggestion, but forgot. HOF doesn't list the email address in the archives (thankfully). -Original Message- From: Munson, Jacob Sent: Monday, March 27, 2006 1:00 PM You can just search the archives for your name and/or email address: http

RE: Security image based on string

2006-03-27 Thread Munson, Jacob
I second that. There are a number of functions out there, some free and some not. A search for captcha will wrangle you some good results. -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Monday, March 27, 2006 3:53 PM Search the House of Fusion for

RE: Can I change query results?

2006-03-24 Thread Munson, Jacob
The QuerySetCell function should work, if you use the row_Number parameter (loop over all rows): http://techfeed.net/cfQuickDocs/?querysetcell -Original Message- From: Phill B [mailto:[EMAIL PROTECTED] Sent: Friday, March 24, 2006 9:37 AM I query a database and receive multiple

RE: Regex on a big data

2006-03-24 Thread Munson, Jacob
The results were a little surprising to me. CF Tags did better when processing a million lines in 265 files but the java objects did better when processing 1 large file (100MB). That's very interesting. Looking at your results, I'd think Perl is faster than both. But I haven't tested it.

RE: CFIF and null values

2006-03-24 Thread Munson, Jacob
cfif expr3 = This should be 'eq' not '='. You knew that, I'm sure, just a slip. :) [INFO] -- Access Manager: This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended

RE: CFIF and null values

2006-03-24 Thread Munson, Jacob
Use the isNull() function directly in the SQL. FYI, coalesce() is ANSI standard, isNull() is proprietary Microsoft syntax. --- [INFO] -- Access Manager: This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If

RE: Regex on a big data

2006-03-23 Thread Munson, Jacob
So the regex works on smaller files? If so, you may want to use Perl to do this instead. CF is pretty bad at bulk text processing. I've got some Perl scripts that you could use to do what you need, with slight modifications. Email me off-list if you want to try this with Perl.

RE: Regex on a big data

2006-03-23 Thread Munson, Jacob
As a CF evangelist, it is hard to me using a solution except CF. May me I must be more professional. :) Well, I see it as using a better tool for the task. ColdFusion is clearly not good for large text processing tasks. You can probably find a work around (sounds like you already did), but

RE: Regex on a big data

2006-03-23 Thread Munson, Jacob
That's a good idea. I don't have time to read all your articles, so could you tell me if you cover using regex to do parsing and find/replace, stuff like that? That's what I mean by text processing, not just file management. If people have done that stuff with Java, and found it's faster and

RE: CF CMS recommendation

2006-03-23 Thread Munson, Jacob
Has anyone implemented FarCry in ModelGlue? I am thinking about this and was just wondering if anyone has successfully done it. I hate to jump to conclusions, but my understanding is that FarCry is a plug and play product. Sure, you have do some customizing, but I'm not sure why you'd want to

RE: Merging two queries

2006-03-22 Thread Munson, Jacob
I don't want to beat a dead horse, but query objects are very useful and don't have to come from DB queries. In cfQuickDocs, I manually create a query object from the data I get from livedocs. Then for the function/tag searches I just do QofQ on the query object. And none of cfQuickDocs ever

RE: Merging two queries

2006-03-22 Thread Munson, Jacob
: Munson, Jacob Sent: Wednesday, March 22, 2006 10:35 AM I don't want to beat a dead horse, but query objects are very useful and don't have to come from DB queries. In cfQuickDocs, I manually create a query object from the data I get from livedocs. Then for the function/tag searches I

RE: text replace

2006-03-22 Thread Munson, Jacob
I'm glad you figured it out, but I wanted to comment on your Perl comment. I don't see why you'd need a 'Perl server' if you wanted to use Perl for this. Perl is very small, and it plays nicely with others. So you could put it on any PC/Server and just run it from the command line. This is all

RE: text replace

2006-03-22 Thread Munson, Jacob
get a thousand other very useful Unix tools to help in other areas. On 3/22/06, Munson, Jacob [EMAIL PROTECTED] wrote: I'm glad you figured it out, but I wanted to comment on your Perl comment. I don't see why you'd need a 'Perl server' if you wanted to use Perl for this. Perl is very

RE: Suggestions on scrambling code

2006-03-22 Thread Munson, Jacob
and of course it's basically useless to encrypt your source files as the encryption can be broken using cfdecrypt by a small child and a few mouse clicks Cfdecrypt? What's that? Are you referring to CF's decrypt function? If so, what encryption algorithm do you use do decrypt it, and do

RE: Suggestions on scrambling code

2006-03-22 Thread Munson, Jacob
Ah, I see. I managed to find one using a search engine, and it does indeed decode a cfencode.exe encrypted file. Interesting. However, I /was/ able to stop the tool I found from working by using a different command line paramater than I originally tried. I'm purposefully keeping details low on

RE: counting downloads

2006-03-21 Thread Munson, Jacob
I'm not sure what you want is possible. The document download happens in the client, and unless you can embed something to communicate back to your server, I don't think you'll ever know if they actually download it or not. Someone else suggested using try/catch, and I tried that to see if it

RE: CFQuickDocs...

2006-03-21 Thread Munson, Jacob
Gasp! Thanks for bringing this to my attention, I'm looking into it now. -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 21, 2006 10:36 AM To: CF-Talk Subject: CFQuickDocs... Is getting a 500 error. Jacob...this is you right? Just

RE: CFQuickDocs...

2006-03-21 Thread Munson, Jacob
couldn't get to the site. -Original Message- From: Munson, Jacob [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 21, 2006 1:22 PM Gasp! Thanks for bringing this to my attention, I'm looking into it now. -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED

RE: cfexecute

2006-03-20 Thread Munson, Jacob
Don't know if this helps, but I this is from a comment by cf_Amir on livedocs: If you don't specify a TIMEOUT, the execution is asynchronous. A new thread is spawned to do the work, and there is no output written to the screen nor the variable when outputfile are not provided. So, if you want

RE: Stats tracking logic question

2006-03-20 Thread Munson, Jacob
Then I started wondering if it might be best to create a new table strictly for tracking these stats. Each time someone does one of those things, it gets it's own row in the db. Yes, that is how I'd do it. Plus you can easily add new things to track, as it's not a new column listings

RE: Finding previous page

2006-03-20 Thread Munson, Jacob
This is interesting. How do you usually use this JS value? I thought about setting it as a hidden input field, but ColdFusion can't access a variable that was created on the page until /after/ the page has been submitted. I guess you could send it to a CF function with Ajax. -Original

RE: Finding previous page

2006-03-20 Thread Munson, Jacob
Conclusion: there is no 100% surefire way to ensure that you will *always* have access to this information for every visitor to every page of your site, and your code will have to reflect this. And in most cases this is just stats, which don't need to be 100% accurate. If you get 95% of

RE: Finding previous page

2006-03-20 Thread Munson, Jacob
Sweet. Have you found that that JS works on all the major browsers? -Original Message- From: Tanguy Rademakers Sent: Monday, March 20, 2006 1:55 PM This is interesting. How do you usually use this JS value? I thought about setting it as a hidden input field, but ColdFusion

RE: Application.cfc

2006-03-20 Thread Munson, Jacob
I don't think he meant using cfinclude, but copying the stuff from Application.cfm to Application.cfc, modifying where necessary. -Original Message- From: Oleg Gunkin Sent: Monday, March 20, 2006 3:35 PM Does not seem to be so trivial to me. I tried including application.cfm

RE: CF Server not working after months of flawless service

2006-03-17 Thread Munson, Jacob
In the last few weeks, since I added MS SQLServer2005, the CF Server hasnt started automatically as it's supposed to Aha! Microsoft is intentionally breaking ColdFusion because it's a competitor to ASP! How dare they...the dirty dogs. If you were wondering, I /am/ joking. It's Friday,

RE: Large count query caching

2006-03-17 Thread Munson, Jacob
oddly enough the more ands in the where clause the faster the clustered index seems to go. That does seem odd, but that's the way it usually works. The 'ands' are cutting off chunks of data from the whole, and making the search cover smaller areas. Also, if your 'ands' are part of your

RE: Why is this failing??

2006-03-17 Thread Munson, Jacob
Maybe you have white space after your value, in the data? I don't know if you copy/pasted that result line, but if you did there /is/ a space there. Could just be your email software too. :) -Original Message- From: Richard Colman [mailto:[EMAIL PROTECTED] Sent: Friday, March 17,

RE: threerelatedselects - do you can help?

2006-03-17 Thread Munson, Jacob
I've got a copy I'll send you offline. I'm not sure if it's the same one you've got or not. I will say, however, that these days I'm using AJAX for these kinds of things, it seems to be a lot easier (to me anyway). -Original Message- From: Michel Deloux [mailto:[EMAIL PROTECTED]

RE: Weird error

2006-03-17 Thread Munson, Jacob
I will also check for the type of browser. By the way, it must be some pretty cheap browsr to do so ;-/ I'll bet it's Internet Exploder. ;) [INFO] -- Access Manager: This transmission may contain information that is privileged, confidential and/or exempt from disclosure

RE: Using Pipe character | as a list delimeter in varchar fields

2006-03-17 Thread Munson, Jacob
For what it's worth, there are seome cases where I use a varchar to store a CSV list of flags. I do this sometimes when I have no need to query on specific values. For example, in my CMS, I store permissions to specific modules in such a field, which allows me to add modules without

RE: Dynamic Form Selects and Posting Troubles

2006-03-16 Thread Munson, Jacob
The first time an update occurs, there could be 3 arguments (let's say A133, A150, A120). The second time an update occurs, there could be 8 arguments (A133, A121, A123, A145, and so on). The ARGUMENTS value that is passed contains a permissionsID, which will always be 1 through 5.

RE: Dynamic Form Selects and Posting Troubles

2006-03-16 Thread Munson, Jacob
Let me make sure I understand. You have a set of arguments passed in, each containing a permission id as their value. You need to set your permissionID in the DB to the value of the passed in arguments using a loop. The problem is that you don't know what the argument names are ahead of time,

RE: Dynamic Form Selects and Posting Troubles

2006-03-16 Thread Munson, Jacob
Yes, you are correct. I've been playing around with different looping arrangements, to no avail. Hope someone jumps in here, my head's sore from banging it on the desk for the past two days over this. Thanks, Mark -Original Message- From: Munson, Jacob [mailto:[EMAIL

RE: Weird error

2006-03-16 Thread Munson, Jacob
It could be like someone said. You are only calling stat when your id is blank. But again, if you are doing a cfcatch (I don't see that here), and dumping the URL string, you should not get this error. Unless 'stat' is some kind of reserved word in CF5, or something like that. You might also

RE: Eclipse issues

2006-03-16 Thread Munson, Jacob
To answer your first question, the mailing list for CFEclipse can be found at http://www.cfeclipse.org/ I'm assuming that when you said I have finally dived into Eclipse, you mean Eclipse with the CFEclipse plugin. -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED]

RE: Code Review

2006-03-16 Thread Munson, Jacob
You might check out About Web, or contact Simon Horwith directly. I've heard him mention that their company does code reviews. -Original Message- From: Mehdi, Agha [mailto:[EMAIL PROTECTED] Sent: March 16, 2006 1:53 PM Hi Guys, We need to have ColdFusion code for one of our

RE: Code Review

2006-03-16 Thread Munson, Jacob
Here's Simon's blog: http://www.horwith.com/ -Original Message- From: Munson, Jacob Sent: Thursday, March 16, 2006 4:31 PM You might check out About Web, or contact Simon Horwith directly. I've heard him mention that their company does code reviews. -Original Message

RE: Stress testing software

2006-03-16 Thread Munson, Jacob
I asked a Macromedia employee what he recommended for load testing software, and he suggested OpenSTA. This is an open source, free tool. I haven't tried it, but I thought I'd pass along the info: http://www.opensta.org/ -Original Message- From: Jason Rogoz [mailto:[EMAIL PROTECTED]

RE: Asynchronous vs linear file processing

2006-03-15 Thread Munson, Jacob
This is very cool. I just wish we had Enterprise on our production server so I could do this on more than my developer install. :\ One of the first things I did when CF7 was released was try this asynchronous processing, and I was very impressed. Of interest to note is the fact that setting

RE: Asynchronous vs linear file processing

2006-03-15 Thread Munson, Jacob
I've mentioned to Macromedia in the past (and will have to mention to Adobe) that the async processing is such a great tool that every version of CF should have it. Even if pro is limited to 10 threads, it's still a massive tool. I'll second that! :) --- [INFO] -- Access

RE: Maths with evaluate

2006-03-15 Thread Munson, Jacob
That's very interesting. I've seen similar problems before, and it appears that things like this shine some light on weaknesses in ColdFusion's dynamic typing. I'm eagerly waiting for one of the CF geniuses to give insight on this. :) -Original Message- From: Martin Thorpe

RE: XML feed from Yahoo Orders

2006-03-15 Thread Munson, Jacob
Parsing the XML poses no problem, but when I try to view the HTTP header using GetHttpRequestData() all I get is an empty string. You have to use GetHttpsRequestData() instead of GetHttpRequestData(). Just kidding! Sorry, I couldn't resist. We now return you to your scheduled programming.

RE: Dynamic Form Selects and Posting Troubles

2006-03-15 Thread Munson, Jacob
I your updOBJ2 query, you are using ARGUMENTS.A101, but I don't see where that is getting created. It looks like you are dealing with dynamic variable name problems, but in that query you have the variable name hard coded. Or am I missing something? -Original Message- From: Mark Leder

RE: Dynamic Form Selects and Posting Troubles

2006-03-15 Thread Munson, Jacob
properly to the CFC. In this sense the ARGUMENTS.A155 = 3 I've got that placed in the SET permission ID = because that's that value I want to update. Looping the update is where I'm having trouble. -Original Message- From: Munson, Jacob Sent: Wednesday, March 15, 2006 5:41 PM I

RE: Oracle SQL Developer

2006-03-14 Thread Munson, Jacob
it's nice that Oracle has finally released a tool to compete with TOAD. I'd say that Oracle is competing with Microsoft by releasing this. SQL server 2005 comes with Management Studio which looks a LOT like Oracle's new tool. Toad is a 3rd party tool that is not free. Many companies trying

WebCharts 3D

2006-03-14 Thread Munson, Jacob
I've had a discussion going on my blog about a new version of the charting engine that CF uses. We were wondering if one could purchase that upgrade, and upgrade CF's charts with a new engine. Anybody have any info on this?

RE: Oracle SQL Developer

2006-03-14 Thread Munson, Jacob
There is no way this tool looks anything like SQL Server's tool. The IDE of SQL Server 2005 also comes with a specific version of Visual Studio for SQL Server to design reports and to make SSIS(sql server integration services replaces DTS). It's a good start for Oracle and it will allow

RE: Oracle SQL Developer

2006-03-14 Thread Munson, Jacob
Everybody, if you like doing SQL work from a command line, raise your hand. I don't know if I like it, but I do rely on it - you may or may not have GUI access to a database, but you almost always have access through a command-line interface. Yeah, good point. SQL*Plus is a good backup,

RE: ColdFusion, IE and the transitional doctype...a story of identity crises...

2006-03-14 Thread Munson, Jacob
If these guy's suggestions don't help, check out this blog entry, might do the trick: http://www.techfeed.net/blog/index.cfm/2006/3/3/Cross-browser-element-sp acing -Original Message- From: Steve Brownlee [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 14, 2006 1:23 PM To: CF-Talk

RE: Regex help for email validation

2006-03-13 Thread Munson, Jacob
I agree with his suggestion, but since the code is doing a case insensitive match, you don't need the 'A-Z'. But I'm nitpicking. ;) -Original Message- From: Ben Doom Sent: Monday, March 13, 2006 9:47 AM You'll want to replace all instances of \w left of the @ with something

RE: OT: Copyright Attorney

2006-03-13 Thread Munson, Jacob
I'm joining this thread late, but the first thing that should be done is verifying that their code really is a rip. You could pay a lawyer to do that for you, but in my experience most lawyers won't do that anyway. The first thing they're going to ask is if you've verified that your code is

RE: Regex help for email validation

2006-03-13 Thread Munson, Jacob
+\.)*\w[\w-]{0,66})\.([a-z]{2,6}(?: \.[a-z]{2})?)$/i It looks like its pointing to either the underscore or dash after the 9. Any ideas? Rey... Munson, Jacob wrote: I agree with his suggestion, but since the code is doing a case insensitive match, you don't need the 'A-Z'. But I'm

RE: migration to CFMX and client variables

2006-03-13 Thread Munson, Jacob
I'm just brainstorming here...was your client storage table in place before the migration? Just wondering if maybe the problem could be in the database instead of CF. -Original Message- From: Charlie Hanlon [mailto:[EMAIL PROTECTED] Sent: Monday, March 13, 2006 11:04 AM To: CF-Talk

RE: OT: Copyright Attorney

2006-03-13 Thread Munson, Jacob
It sounds like you guys are all hoping Bud is going to become a millionaire from this. I've got news, if the company is doing something bad, and they've now stopped it, the most Bud can hope for is reimbursement for any money they may have made from his product. I seriously doubt that's very

RE: OT: Copyright Attorney

2006-03-13 Thread Munson, Jacob
It is very unlikely that a lawyer will do this for you. The lawyer may, if necessary, engage a subject matter expert on the topic to serve as an expert witness. This typically entails work by the expert witness to determine the situation before anything is filed, and to serve at

RE: Faster FTP and DW8 Synch for Windoze Servers

2006-03-13 Thread Munson, Jacob
John McKown wrote: Our Linux boxes are insanely fast for FTP and synching DW8 sites, but when we synchronize on Windoze it is painfully slower. Same hardware. Good hardware too. Any suggestions for a FAST Windoze FTP server? Were you just using the Windows FTP server? I've heard a lot

RE: OT: Copyright Attorney

2006-03-13 Thread Munson, Jacob
Well if he's got to buy it, then he'd have to buy it twice - once for himself and again for the subject-matter expert (because I believe the reason for the SME is to avoid conflict of interest isn't it?). So whether or not he wants to buy it for himself first may depend on how much they

RE: Determine Visitors OS

2006-03-10 Thread Munson, Jacob
You could use BrowserHawk if you don't mind paying for this. It will tell you what OS, along with TONS of other stuff about every client that hits your site. -Original Message- From: jonese [mailto:[EMAIL PROTECTED] Sent: Thursday, March 09, 2006 5:31 PM To: CF-Talk Subject: Re:

RE: References for Beginners

2006-03-10 Thread Munson, Jacob
shameless plug http://techfeed.net/cfQuickDocs/ /shameless plug -Original Message- From: Martin Thorpe Sent: Friday, March 10, 2006 2:51 AM I have been asked to compile a list of references by my boss for a Webmaster type who is looking to move to Coldfusion, I have quite a

RE: You know...

2006-03-10 Thread Munson, Jacob
lol In those cases, I hate to say it, but this is what I usually do: ctrl+a delete -Original Message- From: Damien McKenna Sent: Friday, March 10, 2006 8:14 AM You know its bad when you're sick for a week and you finally look at your CF-Talk mailbox to discover 2400 messages.

RE: Determine Visitors OS

2006-03-10 Thread Munson, Jacob
cfif cgi.http_user_agent neq cfset usersOS = CGI.HTTP_USER_AGENT cfelse cfset usersOS = unknown /cfif Now, if you're not sufficiently advanced in CF development, I'd suggest asking for help with this one! Seriously Jonese, I'm sorry to be having fun with this at your

RE: Page visit counter

2006-03-10 Thread Munson, Jacob
Yeah, a cookie that exires at end of session should do the trick. You could create a unique cookie for each page, which should give you the granularity you want. -Original Message- From: Ken [mailto:[EMAIL PROTECTED] Sent: Friday, March 10, 2006 11:54 AM To: CF-Talk Subject: Re:

RE: User Defined Data Fields

2006-03-10 Thread Munson, Jacob
I would suggest you not use user-defined columns but instead you have a table that contains user-defined data. For example, instead of having userdefined1, userdefined2, userdefined3, etc. in your users table, you have a separate table called userFields. Each row would have the user ID and any

RE: why the whitespace?

2006-03-10 Thread Munson, Jacob
Have you tried using cfsaveconent to put it all in a variable, and then strip out all the 'crap' using a regex? -Original Message- From: Bryan Stevenson Sent: Friday, March 10, 2006 4:32 PM Hey All, OK...with or without supressing whitespace I get XML with carriage returns and

RE: CFEclipse - Lost my snipTree?

2006-03-09 Thread Munson, Jacob
I think that's an awesome idea! I personally don't use most of the snippets I have, because I don't remember the trigger text. If there were a content assist UI for the available snippets, I'd probably use all of them. :) -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED]

RE: I still use HomeSite+ 5.5 - Should I Upgrade to something else?

2006-03-09 Thread Munson, Jacob
Not trying to fire off a crazy debate but this seems like a fantastic editor... it's got all of the keystore shortcuts I need to be really productive. However, this editor is 3 years old. Any reason I should use some other tool? Opinions? I've read all the other posts, and the only thing

RE: OT: cf.objective - any advice?

2006-03-09 Thread Munson, Jacob
On 3/9/06, Ken Dunnington wrote: So I've finally got everything set to go to cf.Objective tomorrow (woohoo!) and, since this is my first *real* conference, I was wondering if anyone could offer some advice for getting the most out of it? Last year's CFUnited was my first. I'd suggest you

RE: I still use HomeSite+ 5.5 - Should I Upgrade to something else?

2006-03-09 Thread Munson, Jacob
Plus I've heard that CFEclipse doesn't have a browse tab like Homesite does, and I do use that from time to time when I'm working on layouts and such. CFE does have a built-in browser, but I don't think it's a slick as in HomeSite. It's been a while since I used HS, but if I remember

RE: Source Code Versioning with ColdFusion

2006-03-09 Thread Munson, Jacob
I am researching source code versioning software for our team. We are 4 ColdFusion developers using Dreamweaver and SQL mainly for our development and currently do not use any code versioning software. What would you recommend for us or what are you using and how is that going? I'm sure

RE: cfajax vs ajaxCFC Question.

2006-03-09 Thread Munson, Jacob
For instance, ajaxCFC is easier to set up, but the thing I don't like about it is the passed parameters are transformed and received as array arguments by the CFCs. This isn't true anymore. The latest release, 0.66 I believe, does arguments the same way that cfajax does. I would like

RE: I still use HomeSite+ 5.5 - Should I Upgrade to something else?

2006-03-09 Thread Munson, Jacob
Oh! I didnt remember HS letting you do that! No I don't think it does let you do that, you have to hit ctrl+s :-) It's good to save often anyway. And with Eclipse's built-in version control (the simple version compare stuff), I can't see any reason why people wouldn't be hitting save every 5

RE: cfajax vs ajaxCFC Question.

2006-03-09 Thread Munson, Jacob
I avoided ajaxCFC because of Rob's restricted open source license. I do agree that Arjun hasn't been providing much support. If he had an official open source license, I'd create a cfopen project and release my own derivative work (RabidCFAJAX, anyone?) so that we could have

RE: I still use HomeSite+ 5.5 - Should I Upgrade to something else?

2006-03-09 Thread Munson, Jacob
I hit Ctrl+S when filling out forms within browsers. Lol. I find myself doing the same kinds of things. Also, I hit ctrl+enter to send email messages (in both Outlook and T-Bird), and I always hit that to submit forms. :) - This transmission may contain information that is

RE: SQL-generated primary keys

2006-03-09 Thread Jacob
After the command for inserting the new user, use the following: select @@identity from MyTable cftransaction cfquery What ever your SQL is to insert the new user /cfquery cfquery select @@identity from MyTable /cfquery /cftransaction -Original Message- From: Chris Mueller

RE: SQL-generated primary keys

2006-03-09 Thread Jacob
My mistake... cfquery insert into mytable([columns]) values([values]) select @@identity as user_id /cfquery All in one query, not two like I posted. -Original Message- From: Jacob [mailto:[EMAIL PROTECTED] Sent: Thursday, March 09, 2006 2:13 PM To: CF-Talk Subject: RE: SQL

RE: SQL-generated primary keys

2006-03-09 Thread Munson, Jacob
Something I used to do when I was using PostGres years ago was select a new identity from a table and then use it for all subsequent updates. People tell me you can't do this with SQL Server, but I think this is BY FAR the safest way to handle this. Here's some pseudo code for clarity: select

RE: How do I write a Regex for this?

2006-03-08 Thread Munson, Jacob
BTW, it looks like you might be removing extra notations from a number. If that's the case, you might have problems if people enter other bogus data (like letters, other special characters). It's always better to only allow the data you want, instead of removing possible bad data (like what virus

RE: OOP, why me?

2006-03-08 Thread Munson, Jacob
...I'd love to write a business case for your company outlining how they're hemoraging hundreds of thousands of dollars every year by making their programmers spend many, many extra hours coding by (among other things) reinventing payroll every time they create a new business unit. :P Well,

RE: How do I write a Regex for this?

2006-03-08 Thread Munson, Jacob
Normally you do have to escape those characters in a regex, but in a character class they aren't special characters (but there are other special characters in character classes, like '^'). You've probably picked this up from the other posts, but a character class is anything in [].

RE: How do I write a Regex for this?

2006-03-08 Thread Munson, Jacob
-Talk Subject: RE: How do I write a Regex for this? Hi, Jacob... Actually, it seems the opposite approach has resulted in the error trapping I was looking for. One of the things I wanted to do was allow garbage entries to be caught and an error message and the garbage input

RE: How do I write a Regex for this?

2006-03-08 Thread Munson, Jacob
for this? Jacob...I realized my solution was posted in another thread, so I've included it below... Rick -- -- --- What seems to have covered all the bases in my situation is to run two error traps: Not Len

RE: OOP, why me?

2006-03-08 Thread Munson, Jacob
Okay, I give, it's hopeless... :P Once you get to a) someone else wrote it and they didn't know better and b) I'm not allowed to change it, then you're screwed. :P So anyway, back to my original point, frameworks /can/ work fine with complex data queries, but we've proven that in most cases

RE: dynamic ms-word files

2006-03-08 Thread Munson, Jacob
I never saw anybody respond, so here's an example I've got that works for me: cfcontent type=application/msword cfheader name=Content-Disposition value=attachment; filename=tempfile.doc div style=font-size:16pt; font-face:bold;Here's a dynamic table/div table cfloop index=i from=1 to=5

RE: OT: Popular Open API's

2006-03-07 Thread Munson, Jacob
Here's a huge list of publicly available web services: http://www.xmethods.net/ -Original Message- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 07, 2006 5:42 AM To: CF-Talk Subject: Re: OT: Popular Open API's These are great examples of API's, but I was

RE: OOP, why me?

2006-03-07 Thread Munson, Jacob
From: Ray Champagne Sent: Monday, March 06, 2006 11:36 AM Jacob, mind sharing that blog link? I am learning to hate FrameWorks. I am gung-ho for the concepts that you mentioned, but I don't think that FrameWorks are the only answer. Munson, Jacob wrote: I'm in the same boat

RE: Why do my selects in an iFrame do this?

2006-03-07 Thread Munson, Jacob
You can use both of them at the same time. I can't seem to find the post at the moment, but you can download the exe file (for IE 7), extract the contents using Winzip, and just run it from the folder you extract it to. You have to do a couple of other things that I can't remember, but you don't

RE: OOP, why me?

2006-03-07 Thread Munson, Jacob
While we're on the subject, will one of you framework experts clear something up for me? I work on an Intranet application that leverages data from a few huge databases, some of the tables contain millions of records. The queries we need to write to gather data can be very complex, often times

RE: OOP, why me?

2006-03-07 Thread Munson, Jacob
From: Gareth Sent: Tuesday, March 07, 2006 9:31 AM Jacob, as someone else who's on the fence, has this thread helped your decision making? Well, I just sent in another big email asking for clarifications, so I'm still on the fence. :) As an aside, I was looking at Raymond Camden's

RE: is this thing on?

2006-03-07 Thread Munson, Jacob
Everything's fine on my end. -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 07, 2006 10:08 AM To: CF-Talk Subject: is this thing on? I just don't know what to do when my inbox doesn't flood with CF_Talk mail first thing in the morning

RE: OOP, why me?

2006-03-07 Thread Munson, Jacob
Thanks Isaac, I think you answered my question by stating that most frameworks don't help you with data access. If that is the case, then I could use FB/MG/whatever and then do the data access how I like. They might suggest I put my queries in a specific location, but after that I can make them

RE: How do I write a Regex for this?

2006-03-07 Thread Munson, Jacob
Darn it Claude, you beat me to it. ;) Well, I'll add that you don't need to escape the period and dollar sign because they are in a character class: cfset myStr2 = ReREplace(myStr,[.$,]+,,all) -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Tuesday, March

RE: Cf webservice timeout. Etc.

2006-03-06 Thread Munson, Jacob
How about cftry/cfcatch? cftry cfobject webservice= http://www.../wsdl; name = myobjectname cfcatch type=Application failed /cfcatch /cftry -Original Message- From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED] Sent: Monday, March 06, 2006 9:53 AM To: CF-Talk Subject:

RE: OOP, why me?

2006-03-06 Thread Munson, Jacob
Gareth, I'm in the same boat you are. Especially after reading a blog entry by a prominent figure in the CF community, where the complaint was given that simple changes to a framework based site were /not/ simple. You had to modify a few different files just to make a simple change. Kind of

RE: OOP, why me?

2006-03-06 Thread Munson, Jacob
http://www.cfpetmarket.com/ -Original Message- From: Rick Faircloth Sent: Monday, March 06, 2006 4:35 PM How about a sample (and simple) app that shows the OOP method at work...(as simple as possible to demonstrate the concept) wihtout any jargon in the explanation... Or

RE: Flex 2 and Ben Forta

2006-03-03 Thread Munson, Jacob
Free use for those who never copy, modify or distribute. As long as you never distribute the MySQL Software in any way, you are free to use it for powering your application, irrespective of whether your application is under GPL license or not. It's probably obvious, but I wanted to make it

RE: GMail manipulation remotely

2006-03-03 Thread Munson, Jacob
Maybe I'm over-simplifying your problem, but it's my understanding that you can use google's smtp server for your outgoing email. So you could use that in the cfmail tag, and put all your CCs in yourself. You'd only send out one email, but it would go to a bunch of people (the CC addresses), and

RE: Fatal windows crash

2006-03-03 Thread Munson, Jacob
If it's WinXP, you could try a system restore. Often times I see an event in the restore list that I wasn't aware of, or forgot about, and that could be your culprit. Also, you could try removing services and/or startup items (in msconfig). Regardless of what others say, software does sometimes

RE: StripHtml function that allows some tags

2006-03-03 Thread Munson, Jacob
Here's a process I've used in the past: 1. Replace the good tags with a unique identifier. Example, a* with ~a*~, and /a with ~/a~ 2. Remove all bad tags 3. Replace unique identifiers from step one with original tags You will have to learn some regular expression magic to do this (search

RE: MS SQL and querying it

2006-03-03 Thread Munson, Jacob
What is 'LC_KCALA'? I don't see that in your code. Is it one of the variables you're using (un/pw)? -Original Message- From: Jim Louis [mailto:[EMAIL PROTECTED] Sent: Friday, March 03, 2006 3:14 PM To: CF-Talk Subject: Re: MS SQL and querying it I just found out it is Coded

<    5   6   7   8   9   10   11   12   13   14   >