Re: Thousand Separator ONLY

2012-06-26 Thread Jason Fisher
numberFormat(myNum, ,9) From: Richard White rich...@re-base.net Sent: Tuesday, June 26, 2012 12:59 PM To: cf-talk cf-talk@houseoffusion.com Subject: Re: Thousand Separator ONLY thanks for your help Robert although that didnt work as it returns lots of

Re: Thousand Separator ONLY

2012-06-26 Thread Jason Fisher
Then try numberFormat(myNum, ,9.9) From: Richard White rich...@re-base.net Sent: Tuesday, June 26, 2012 1:15 PM To: cf-talk cf-talk@houseoffusion.com Subject: Re: Thousand Separator ONLY thanks Jason, although this strips off all the decimals

Re: Thousand Separator ONLY

2012-06-26 Thread Jason Fisher
Did you try numberFormat(myNum, ,9.9) ? On 6/27/2012 1:34 PM, Richard White wrote: I think i may need to be clearer on what i am trying to achieve: I have any form of number, they could be integer or floats and with varying decimal places such as: 11 1.1 11.11 1.1

re: Installing CF10 on IIS7.5 Win7 64-bit

2012-06-13 Thread Jason Fisher
I had that happen, too. Go through Control Panel and install CGI and re-try it: * Control Panel * Turn Windows features on or off * Internet Information Services * World Wide Web Services * Application Development Features * check CGI and hit OK - Jason

re: Video Streaming Provider

2012-05-02 Thread Jason Fisher
We use Amazon: S3 for storage and CloudFront to stream out the hosted videos from edge locations all over the world. Over the past year, Amazon has added granular permissions at the level of CloudFront 'buckets', so I would think you could manage your permissions right there. Very

re: Admin System - Temp Tables? Advice?

2012-03-21 Thread Jason Fisher
Or have a 'versions' table attached to the 'page' table. Versions can have status, with a maximum of 1 'published' for any given pageID, and versions can have publicationStart and publicationEnd dates. Gives you the flexibility of rolling back to previous versions as well. Just a thought.

Re: How to search for all occurences of a string in a text?

2011-11-18 Thread Jason Fisher
Start by simplifying the regex: cfset reg = [^]+/([^/]+\.(jpg|gif|png)) / (It just gets every image reference inside double-quotes.) Then use REMatchNoCase() to get an array of all matches: cfset test = reMatchNoCase(reg, string) / (REFindNoCase() only gets one match, so it only works if you

Re: Week Weirdness

2011-10-04 Thread Jason Fisher
I know the various JVM versions have had issues with DST settings in the past (like 10 years ago); do your 2 servers have the same JRE configured for CF? On 10/4/2011 6:13 PM, Edward Chanter wrote: Thinking about this on a more technical level, does anyone know where CF ultimately derives

Re: 20USD/Hour Seriously?

2011-09-23 Thread Jason Fisher
Morality, yes, as well as the experience of the person doing the hiring / paying: knowing when that extra 100 hours is BS ... That being said, back when I worked for a custom web development house, we quoted jobs by the project but we often got asked what the underlying hourly rate was. My

Re: matching a whole word

2011-08-17 Thread Jason Fisher
Yes, indeed. You want something like this: keyword = star; myString = The dog sniffed at the starfish and growled; regEx = \b keyword \b; if (reFindNoCase(regEx, myString)) { writeOutput(found it); } else { writeOutput(did not find it); } On 8/17/2011 5:20 PM, Nathan C. Smith

RE: Using excel NumberFormat in coldfusion

2011-08-09 Thread Jason Fisher
##,0 doesn't work? -Original Message- From: fun and learning funandlrnn...@gmail.com Sent: Tuesday, August 09, 2011 3:18 PM To: cf-talk cf-talk@houseoffusion.com Subject: Using excel NumberFormat in coldfusion Hi All - As suggested by a couple of coldfusion developers a weeks

RE: Label Printer

2011-08-03 Thread Jason Fisher
Dymo LabelWriter comes with ActiveX component and code sample that make it easy to do. -Original Message- From: Chad Gray cg...@careyweb.com Sent: Wednesday, August 03, 2011 11:50 AM To: cf-talk cf-talk@houseoffusion.com Subject: Label Printer I have an inventory website and it

Re: Email Management Software

2011-07-21 Thread Jason Fisher
If you're doing large volumes, I recommend ExactTarget. CF can't actually manage things like bounce-backs, since that's all on the email server-side. You could write all those hooks yourself, if your email server allows you to embed applications, but it's more efficient to let the pro's

re: remove high ASCII chars from text

2011-07-11 Thread Jason Fisher
Try this (not tested): Text = reReplace(Text, [^\x20-\x7E], , all); From: Matthew Friedman m...@hozgroup.com Sent: Monday, July 11, 2011 12:48 PM To: cf-talk cf-talk@houseoffusion.com Subject: remove high ASCII chars from text Is there a simple way to

re: Email Addresses with Subdomain causes CFMAIL to fail?

2011-06-24 Thread Jason Fisher
Works fine for me. Goes out through the mail server and then I immediately get an Undeliverable message, as expected. CFMAIL didn't seem to mind at all, whether that was the only address in the 'to' attribute or if it was one of several. From:

Re: CDN and Coldfusion

2011-06-15 Thread Jason Fisher
+1 for CloudFront on Amazon S3. From: Paul Alkema paulalkemadesi...@gmail.com Sent: Wednesday, June 15, 2011 10:50 AM To: cf-talk cf-talk@houseoffusion.com Subject: Re: CDN and Coldfusion Oh yeah! Something else just mentioning is that if your not

Re: CDN and Coldfusion

2011-06-15 Thread Jason Fisher
In that situation specifically I cannot recommend Amazon S3 + CloudFront more. It's been truly outstanding for us. We set up separate S3 buckets for each of our CMS websites and CloudFront takes care of the edge distribution. As someone else has already noted, you can mount an S3 bucket as

Re: What am I missing with this code? (Javascript)

2011-06-12 Thread Jason Fisher
You declared slidePosition as a local variable inside the ready() function, so it doesn't exist for the other functions. Try making it global, like this: script type=text/javascript var slidePosition = 0; $(document).ready(function() {

Re: What am I missing with this code? (Javascript)

2011-06-12 Thread Jason Fisher
Not sure, but now that I look at it, you don't need to pass slidePosition around at all now that it's a global variable. Try this: script type=text/javascript var slidePosition = 1; $(document).ready(function() {

re: CFQuery Select and single quotes in string

2011-06-10 Thread Jason Fisher
Yes, and if this is form input, you should be using cfqueryparam anyway. Please see the news for Sony's latest data hack, which was simple web-based SQL injection. cfsqltype will need to match column datatype in each case. cfquery datasource=#DSN# name=GetResults SELECT Formation, Play,

re: Why would this code return this error?

2011-06-10 Thread Jason Fisher
imagesList = arguments.images, which is a string. The parameter for ValueList() has to be a query.column name and the query has to be available in the scope of the call to ValueList(). From: Rick Faircloth r...@whitestonemedia.com Sent: Friday, June

re: Coldfusion 9 and jQuery

2011-05-26 Thread Jason Fisher
jQuery is all client-side, so it has nothing to do with the ColdFusion server at all. The files just have to be part of the HTML that your users use. You just put the *.js files (the core and any plug-ins) in a directory where your website can include them, and then you embed them in your

Re: Recordcount not working????

2011-05-19 Thread Jason Fisher
There is no difference: we successfully query SQL Server views all the time in several of our apps. Have you checked the permissions? Could it be that the View doesn't allow the CF service user to SELECT data? From: Phillip Vector

re: cfdocumentitem type=pagebreak

2011-05-18 Thread Jason Fisher
Sounds like there's something else going on that would cause a blank at the beginning, if that's what you're seeing, but the code you've got there will also *always* append an extra page break after every record, including the first one. Try this instead: cfdocument format=pdf

Re: Form Field Validation

2011-05-07 Thread Jason Fisher
If startVal, endVal, and lengthVal represent your values in JS [like var startVal = parseInt(myForm.start.value); ], then the following should work: if (startVal % 3 != 0) { alert(Start must be a multiple of 3.); return false; } else if (endVal % 3 != 0) { alert(End must be a

Re: Replace cfhttp with jquery.post()

2011-05-06 Thread Jason Fisher
Not sure if it's just and oversight, but you've got address in the CFHTTP version and address1 in the jQ version. As for the error, don't you get the response struct in Firebug if you click on the URL? On 5/6/2011 6:11 PM, David Mineer Jr wrote: I am trying to replace this: CFhttp

Re: SOT: Select at least one select

2011-05-02 Thread Jason Fisher
(in JavaScript, called on the form tag: form onsubmit=return validateMyForm(this); ) function validateMyForm(frm) { var selectTest = false; if (frm.select1.selectedIndex 0) { var selectTest = true; } else if (frm.select2.selectedIndex 0) { var selectTest = true; } else if if

Re: Problem Using QueryNew

2011-04-23 Thread Jason Fisher
Change all your ntext to nvarchar(MAX), if you can. And run an UPDATE to free up space after the conversion, too ;) ALTER TABLE myTable ALTER COLUMN myNText nvarchar(MAX); UPDATE myTable SET myNText = myNText; That lets SQL keep the first set of chars locally, and only points to the LOB when

Re: Problem Using QueryNew

2011-04-23 Thread Jason Fisher
records that really have long values in myNText). Could you explain a little more, please? nvarchar(MAX) is the new ntext, and ntext is being deprecated, so it's a good move at any rate. Thanks for the warning on this. Jenny -Original Message- From: Jason Fisher [mailto:ja

Re: OT question - is this real or phishing?

2011-04-20 Thread Jason Fisher
We get them all the time for several B-to-B domains that are popular in China. Just DELETE and move on. It's spam. On 4/20/2011 6:37 PM, Casey Dougall wrote: On Wed, Apr 20, 2011 at 6:27 PM, Wil Genovesejugg...@trunkful.com wrote: Has anyone received emails like this for any of their

re: display dynamic algorithm

2011-04-14 Thread Jason Fisher
To get a string to run as code, you have to use Evaluate(), and usually with an extra DE() thrown in for good measure: try this: cfoutput#numberFormat(evaluate(de(result2)))#/cfoutput From: Keith McGee kpmc...@frontiernet.net Sent: Thursday, April 14,

RE: Referencing Variables

2011-04-07 Thread Jason Fisher
Returntype can simply be datasource, in your example, which specifies the type without having to worry about the path, so that may be an option: cffunction name=getDatasource access=public output=false returntype=datasource ... From: Hunsaker,

re: Storing Arrays or Structures in a database

2011-04-06 Thread Jason Fisher
Serialize with WDDX or JSON, I would say. Those are complex variable types which need to be serialized into strings before insertion into a DB. From: Adam Bourg adam.bo...@gmail.com Sent: Wednesday, April 06, 2011 1:49 PM To: cf-talk

re: replacelist question

2011-04-05 Thread Jason Fisher
Per the documentation, the match is case-sensitive. From: Jenny Gavin-Wear jenn...@fasttrackonline.co.uk Sent: Tuesday, April 05, 2011 12:47 PM To: cf-talk cf-talk@houseoffusion.com Subject: replacelist question Hi all, I'm using the following to strip

Re: Including multiple variables within a database response

2011-04-02 Thread Jason Fisher
Can use replaceList() instead. replaceList(mystring, DECISIONMAKER,MYNAME, Bob,Scott) On 4/2/2011 12:57 PM, Scott Williams wrote: LOL -- I was afraid of that! It reminds me of the portrait of Stephen Colbert standing in front of a portrait of Stephen Colbert standing in front of a portrait

re: Session Variable question

2011-04-01 Thread Jason Fisher
In your Application.cfc or somewhere global like that (after session is created), drop this in: cfset cfT = cookie.CFTOKEN / cfset cfI = cookie.CFID / cfcookie name=CFTOKEN value=cfT / cfcookie name=CFIDE value=cfI / By not setting an 'expires' value in CFCOOKIE, this will ensure that the

Re: Session Variable question

2011-04-01 Thread Jason Fisher
question Not sure if that will work if he can't use cookies. :) On 4/1/2011 1:28 PM, Jason Fisher wrote: In your Application.cfc or somewhere global like that (after session is created), drop this in: cfset cfT = cookie.CFTOKEN / cfset cfI = cookie.CFID / cfcookie name=CFTOKEN value=cfT

RE: Session Variable question

2011-04-01 Thread Jason Fisher
Like Dave said, CF / J2EE already are using cookies, but there's a difference between cookies held only in the browser (expires when browser closes) and cookies that are written to the user's HDD. If you're using session or client vars, then you're already using 1 of these, and probably

re: Persisting query data across cflocation

2011-03-23 Thread Jason Fisher
Yes, storing in a Session or Client struct is your only option. Earlier versions of CF would lose sessions set before a CFLOCATION as well, so if you're on CFMX or something, use JavaScript location.href = C.cfm for the redirect to get around that.

re: OWASP ColdFusion security links

2011-03-23 Thread Jason Fisher
Great stuff on there; thanks for the link, Dave. From: Dave Watts dwa...@figleaf.com Sent: Wednesday, March 23, 2011 3:17 PM To: cf-talk cf-talk@houseoffusion.com Subject: OWASP ColdFusion security links This looks like a pretty good set of CF security

Re: ColdFusion 9 Enterprise Features

2011-03-21 Thread Jason Fisher
Looks like Excel support is Enterprise-only: http://www.adobe.com/products/coldfusion/pdfs/cf9_feature_comparison_matrix_ ue.pdf From: Richard White rich...@j7is.co.uk Sent: Monday, March 21, 2011 8:20 AM To: cf-talk cf-talk@houseoffusion.com Subject:

Re: Converting Boolean in the query

2011-03-19 Thread Jason Fisher
Use a cfheader name=Content-Disposition value=attachment; filename=filename.ext That 'attachment' setting should force the browser to give the user the Open / Save dialog. Works a treat thank you - but now I have a new issue if anyone can help please. The CSV file opens in the browser rather

re: Do people still name their UPDATE, INSERT DELETE queries?

2011-03-15 Thread Jason Fisher
I do not and never have. Not against it, but just never saw the need. From: Dain Anderson da...@terradotta.com Sent: Tuesday, March 15, 2011 10:27 AM To: cf-talk cf-talk@houseoffusion.com Subject: Do people still name their UPDATE, INSERT DELETE

RE: ColdFusion License and Builder

2011-03-10 Thread Jason Fisher
Dev and Hot Spare are 2 different things. You can always install full Enterprise on any server in Dev mode for free, and that has a 2 IP limit. Hot spare is a licensing change (came in 8.0.1, iirc) that allows a 'dark' server to have a full installation re-using your production license, but

re: CFC arguments, passing large strings

2011-03-04 Thread Jason Fisher
My recommendation would be to initialize the CFC with the string as an initial argument, then call the different iterative methods without sending the string over and over: just modify the variable within the CFC after the init. Ex: cfcomponent displayName=stringModder cfset

RE: CFC arguments, passing large strings

2011-03-04 Thread Jason Fisher
can't do that... Brook -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: March-04-11 9:56 AM To: cf-talk Subject: re: CFC arguments, passing large strings My recommendation would be to initialize the CFC with the string as an initial argument, then call the different

RE: CFC arguments, passing large strings

2011-03-04 Thread Jason Fisher
, then it would be passed by reference. Wouldn't this alleviate the memory usage issue? Brook -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: March-04-11 10:24 AM To: cf-talk Subject: RE: CFC arguments, passing large strings Oh, well, if it's a singleton, then you're

re: DaysInMonth issue

2011-03-01 Thread Jason Fisher
Nope, when I do #daysInMonth(createDate(2010, 2, 1))# it returns '28' correctly. You would get '31' for #daysInMonth(createDate(2010, 1, 2))#, though, I suppose. From: Jeff Epstein jepst...@sfcg.org Sent: Tuesday, March 01, 2011 11:13 AM To:

RE: I think I'm confused...

2011-02-24 Thread Jason Fisher
One solution is to have a table of sub-domains that refer to the main application config table: lookup domain.com or blog.domain.com or www.domain.com and find the parent config record for www.domain.com. In that case, you can then add dev.domain.com to the sub-domain table, but you'd still

RE: Feedback on this approach to many sites, one codebase (MSOC)

2011-02-23 Thread Jason Fisher
The big caveat I will give about have multiple databases with multi-tenant code is that any change to the shared code has to be reflected in every single database simultaneously. And that's a challenge and a half. From: Rick Faircloth

Re: Feedback on this approach to many sites, one codebase (MSOC)

2011-02-23 Thread Jason Fisher
Yes, I used this method for a long time by putting code right into the CF codebase. I used a different datasource for the DB updates, one that allowed MODIFY / ALTER / CREATE, and then had the code test against existing DB structures to decide which changes needed to be made along with that

Re: SELECT - Option selected

2011-02-17 Thread Jason Fisher
Same. As of CF8 I use CFFORM sometimes, but only for the built-in text editor in CFTEXTAREA ... easier than wiring up tinyMCE or ckEditor, but I don't use it for validation, I use a simple JS library for that. From: Brian Cain bcc9...@gmail.com Sent:

re: Feedback on this approach to many sites, one codebase (MSOC)

2011-02-17 Thread Jason Fisher
Yeah, that works just fine, Rick. Have used variations of that approach for quite a few years, both with and without a 'framework' in place, and in any case that code sits quite well in the Application.cfc as you've outlined. From: Rick Faircloth

RE: Feedback on this approach to many sites, one codebase (MSOC)

2011-02-17 Thread Jason Fisher
I usually use CFSWITCH and assign my own app names, which allows me to use the built-in list nature of CFCASE values: cfswitch expresssion=#cgi.server_name# cfcase value=domain.com,www.domain.com cfset appName = domain / /cfcase cfcase value=mydomain.com,www.mydomain.com cfset

Re: Feedback on this approach to many sites, one codebase (MSOC)

2011-02-17 Thread Jason Fisher
If you're using shared server space, though, no need to spend money on a bunch of separate sites if they all need to use the same codebase. Just point them all the same IP, which I would do even if they're all on separate sites but the same server, but then I get to really have all the code

Re: Feedback on this approach to many sites, one codebase (MSOC)

2011-02-17 Thread Jason Fisher
+1 to databasing all of it ... if you've got a system where these things change a lot, particularly new domains that might impact the Application.cfc, then definitely push the config to the database. As was mentioned before, you can handle redirects there as well: if domain.com is found in

RE: Charge for meetings

2011-02-07 Thread Jason Fisher
+1 to 15-minute increments. As an employee, tracking at this level is annoying, but as an independent contractor, it's crucial. Very easy to get nickel-and-dime'd to pieces, but this way you at least get compensated for it. From: Mark A. Kruger

Re: Charge for meetings

2011-02-05 Thread Jason Fisher
Completely agree. Once into a project, all the project time is client time; bill accordingly. On 2/5/2011 5:37 PM, Brian Cain wrote: I follow the same basic rule. No charge on the initial consult, but hourly after that. It helps force the client to prepare and think through why they

RE: CFImage at 300dpi

2011-02-03 Thread Jason Fisher
Some thoughts on dpi and what it means to screen vs paper. Dpi effectively changes the size an image will print at, relative to its pixel density. http://www.scantips.com/no72dpi.html ~| Order the Adobe Coldfusion

Re: CFImage at 300dpi

2011-02-03 Thread Jason Fisher
Pretty sure that DPI is not an accessible via CFIMAGE. From: Claude Schnéegans schneeg...@internetique.com Sent: Thursday, February 03, 2011 3:22 PM To: cf-talk cf-talk@houseoffusion.com Subject: Re: CFImage at 300dpi But all that still leaves us with

re: Math weirdness

2011-02-03 Thread Jason Fisher
Whoa, creepy. That is certainly very odd. From: Jen McVicker snarkmeis...@gmail.com Sent: Thursday, February 03, 2011 3:57 PM To: cf-talk cf-talk@houseoffusion.com Subject: Math weirdness OK, a coworker sent this over to me and I am puzzled: cfset

re: Query of query help

2011-01-31 Thread Jason Fisher
Yes, QoQ will work here. !--- get your folders --- cfdirectory action=list name=roomList type=dir directory=#roomsDir# !--- get the rooms from the DB --- cfquery datasource=#dsn# name=roomsDB SELECT roomid FROM rooms /cfquery cfoutput query=roomList !--- loop through

Re: Query of query help

2011-01-31 Thread Jason Fisher
no SQL ninja by any means. S On 31 Jan 2011, at 17:54, Jason Fisher wrote: Yes, QoQ will work here. !--- get your folders --- cfdirectory action=list name=roomList type=dir directory=#roomsDir# !--- get the rooms from the DB --- cfquery datasource=#dsn# name=roomsDB SELECT

Re: Query of query help

2011-01-31 Thread Jason Fisher
Nope, nothing wrong with it. There may be a limit on the number of statements in a QoQ WHERE clause, though I don't know. I know the old Microsoft JET database engine used to have a logical limit of 40 statements in the WHERE clause. Just something to note if it bombs on 30,000 statements

Re: favorite coldfusion host

2011-01-26 Thread Jason Fisher
I've been happy with CrystalTech or NewTek ... whatever they're called now. Definitely agree on HMS / Hosting.com ... did *not* have good experiences with them. From: Sean Corfield seancorfi...@gmail.com Sent: Tuesday, January 25, 2011 9:53 PM To:

Re: Clustering ColdFusion - some black holes

2011-01-25 Thread Jason Fisher
I agree with Dave on this one: set sticky sessions on the LB, and let each web server stand independently so there are no single failure points. If you need true failover, refactor the apps to use client vars and store them in a database for clean 'session' replication across the web

Re: Clustering ColdFusion - some black holes

2011-01-25 Thread Jason Fisher
Agreed. Back in the day we did actually need sessions to hold across servers, but we went with the client-vars-in-the-DB to do it. Don't know if AOL still does this, but back in 2004 when many end users (B2C) were still using AOL as their ISP, AOL had a habit of changing a user's IP every 3

Re: Coldfusion Standard and Load balancing env

2011-01-24 Thread Jason Fisher
As Dave notes, hardware load balancing works just fine in front of CF Std servers. The sticky session thing really is key, though, if you have any sort of session management in your applications. Another option to sticky sessions on the LB is to convert session structs to client structs

Re: wireframe for developers

2011-01-18 Thread Jason Fisher
+1 for Balsamiq. Less about design and more about wireframing the layout and functional fell before writing actual code. From: Tom McNeer tmcn...@gmail.com Sent: Tuesday, January 18, 2011 10:55 AM To: cf-talk cf-talk@houseoffusion.com Subject: Re:

re: Regex to strip out non-numerics but leave decimal point

2011-01-18 Thread Jason Fisher
reReplace(rc.hourlyRateInvoicedToClient, [^[:digit:]\.], , all) A set [] takes all the options in it as options, so escape the . with \. and you should be good to go. From: Nando d.na...@gmail.com Sent: Tuesday, January 18, 2011 2:09 PM To: cf-talk

Re: wireframe for developers

2011-01-18 Thread Jason Fisher
Yeah, clients are always going to want to know what it's going to look like. However, I've found it extremely helpful to segregate the wireframing from the design. In my experience, most clients put the cart before the horse, concentrating way too much (or too early, or both) on the

re: (ot) Server Setup Opinions

2011-01-14 Thread Jason Fisher
It used to be very bad to have DB and CF on the same server, but I'm not sure that's still the case ... probably depends largely on the RDBMS you're using. In any event, it is certainly best practice to have production boxes separate. Running dozens of databases (or even 100) on a single DB

re: (ot) job-placement agent

2011-01-14 Thread Jason Fisher
Got great help a number of years ago from TEKSystems and I've had good experiences with Kforce as well. From: John M Bliss bliss.j...@gmail.com Sent: Friday, January 14, 2011 10:25 AM To: cf-talk cf-talk@houseoffusion.com Subject: (ot) job-placement

Re: Accessing Visual Fox Pro

2011-01-13 Thread Jason Fisher
Ach, VFP ... what a pain. Still have a lot in our shop, but hoping to kill most of it this year ;) Not sure if you can actually use SQL Server as the intermediary, like you do with Access, but you can definitely create SSIS scripts to pull VFP data into SQL tables, which is what we do for a

Re: compare using cfcase

2011-01-11 Thread Jason Fisher
OR just use the list nature of CFCASE: cfcase value=-1 string 1 is neither equal nor greater /cfcase cfcase value=0,1 string 1 is equal or greater /cfcase From: Michael Grant mgr...@modus.bz Sent: Tuesday, January 11, 2011 2:59 PM To: cf-talk

re: Concantenate vs Pound Signs within Quotes

2011-01-03 Thread Jason Fisher
Merely stylistic. Depends on the coder's feelings on readability, which is personal preference as much as anything. From: Shannon Rhodes shan...@rhodesedge.com Sent: Monday, January 03, 2011 9:18 AM To: cf-talk cf-talk@houseoffusion.com Subject:

Re: Auto Incrementing Seed vs CF UUID

2010-12-20 Thread Jason Fisher
Using UIDs makes it much easier to move data between servers or databases or even tables later, too, if you ever need to. For instance, moving records from production down to staging, when there's been testing going on in staging ... may have 100 records with IDs between 105 and 204 in each

Re: CFWDDX Serialization and Deserialization

2010-12-07 Thread Jason Fisher
Sounds like the OP's issue is XML, not HTML, where the CDATA blocks can't be nested. Not sure there's a solution for that one ... ~| Order the Adobe Coldfusion Anthology now!

re: Monster Regex

2010-12-06 Thread Jason Fisher
Try this, where x is your original string: clean = replaceList(reReplace(x, \s*;\d+-\d+, , all), ((,)), (,)) From: Rick Colman rcol...@cox.net Sent: Monday, December 06, 2010 2:04 PM To: cf-talk cf-talk@houseoffusion.com Subject: Monster Regex Been

Re: Monster Regex

2010-12-06 Thread Jason Fisher
@houseoffusion.com Subject: Re: Monster Regex this mostly worked, but did not remove one of the last trailing double )) results like: (T ACT) (N AAC) (D GAT) (T ACT) (A GCT) (T ACT) (M ATG) (D GAT) (H CAC) (L CTG) (E GAG) (K AAA) (N AAC) (E GAA) ) On 12/6/2010 11:26 AM, Jason Fisher wrote

Re: Monster Regex

2010-12-06 Thread Jason Fisher
-talk cf-talk@houseoffusion.com Subject: Re: Monster Regex getting malformed regular expression )\s*) thank you ! On 12/6/2010 12:41 PM, Jason Fisher wrote: Just add a space checker inside the '))', then, something like this: clean = reReplace(replace(reReplace(x, \s*;\d+-\d+, , all

Re: Regex Question

2010-12-03 Thread Jason Fisher
Agreed. /item1/option2/part3/section4 cfoutput item = #listFirst(cgi.path_info, /)# br / option = #listGetAt(cgi.path_info, 2, /)# br / part = #listGetAt(cgi.path_info, 3, /)# br / section = #listLast(cgi.path_info, /)# /cfoutput From: Carl Von

RE: Regex Question

2010-12-03 Thread Jason Fisher
Yep, that'll work. Of course, listGetAt(cgi.path_info, 1, /) is the same as listFirst(cgi.path_info, /), so just passing the integer is a nice solution: returnVar = listGetAt(arguments.path_info, arguments.index, /); From: Robert Harrison

Re: CF9 Service Randomly Restarting

2010-11-29 Thread Jason Fisher
Do you have any developers with CF Builder who might be restarting services on the server from Builder's Server tab? From: Dave Sueltenfuss dsueltenf...@gmail.com Sent: Monday, November 29, 2010 11:01 AM To: cf-talk cf-talk@houseoffusion.com Subject:

Re: Homesite on Windows 7

2010-11-16 Thread Jason Fisher
That would be a pain. I've only ever had that problem over RDS, and that was even before Windows 7. When working on actual local / mapped drives, HomeSite's not giving me that trouble at all. Wonder what the difference is? On 11/15/2010 6:31 PM, Michael Grant wrote: It's when you are

Re: Homesite on Windows 7

2010-11-16 Thread Jason Fisher
OK, so that problem I *do* have, but I'm pretty sure I ran into that even before I moved to Windows 7. I have no troubles saving locally, but saving New directly over RDS (or FTP) usually errors. Very annoying, I agree. From: Michael Grant

Re: Homesite on Windows 7

2010-11-15 Thread Jason Fisher
Works fine for me, on Windows 7 64-bit Home Premium. I still use HomeSite for most of my editing. What problem is it giving you when you try to save? On 11/15/2010 11:53 AM, Rick Colman wrote: I STILL like homesite because it is file based - NOT projects. I don't do projects ...

Re: Where to put your code

2010-11-15 Thread Jason Fisher
Well, I've been using frameworks since Fusebox 2 came out, so I still tend to follow generic CF framework conventions, if you can call them that. * display a message, a menu, or data: dsp.user.cfm, and depending on the framework, all displays probably go in a /views subfolder;

Re: CF Blog software

2010-11-09 Thread Jason Fisher
+1 Ben's idea Some of those are reasonable, but CFCONTENT, CFDUMP, CreateObject()?? Go to CrystalTech for a few bucks a quarter or something. From: Ben Forta b...@forta.com Sent: Tuesday, November 09, 2010 11:37 AM To: cf-talk

Re: CF Blog software

2010-11-09 Thread Jason Fisher
Granted they shouldn't have unrestricted access, but I would argue that you should be able to call them within your own application or else the ability to build complex applications begins to be pretty well hampered, no? From: Dave Watts

Re: CF Blog software

2010-11-09 Thread Jason Fisher
, but Crystaltech has been outstanding and I've been on them for years now without issue. From: Ian Skinner h...@ilsweb.com Sent: Tuesday, November 09, 2010 1:02 PM To: cf-talk cf-talk@houseoffusion.com Subject: Re: CF Blog software On 11/9/2010 9:54 AM, Jason Fisher

re: What is wrong with this loop update?

2010-11-03 Thread Jason Fisher
What you want is this: cfoutput query=GetExpOrg (diagnostics) row: #currentrow# id: #ExpOrg_ID#br cfquery datasource=#application.datasource# name=UpdateExpOrg update Project_ExpOrg set OrgValue=(select org_value from expressionorganism3 where exporg_id = #ExpOrg_ID#) where project_id =

Re: CFSTOREDPROC and invalid SQL

2010-11-03 Thread Jason Fisher
Been awhile since I had to use Oracle, but is sysdate a function? Can you try: datetext := to_char(sysdate(), '-mm-dd'); Hi all, So I'm very stuck and tired of saying mean things to my computer... so I hope you are able to see something I'm missing. In short, in order to trouble

re: Group BY

2010-11-03 Thread Jason Fisher
If this is SQL Server, than the GROUP BY has to match the un-aggregated SELECT columns, so it would need to be something like: SELECT COUNT(intMemberID) AS NewMembers, DATENAME(mm, dteAdded) + '-' + DATENAME(, dteAdded) AS Month FROM TABLE GROUP BY DATENAME(mm, dteAdded) + '-' +

re: Curious problem with CFINDEX

2010-11-02 Thread Jason Fisher
You have to create 2 different collections, one for the 1 document and the other for the 5 database rows and then create a 3rd collection that merges the first two, iirc. From: Kevin Parker tras...@internode.on.net Sent: Monday, November 01, 2010 9:11

RE: Curious problem with CFINDEX

2010-11-02 Thread Jason Fisher
the cfdocs they seem to imply that you can index multiple types in the same collection with an update. The implication could be wrong though, they may simply be using the same collection name in all the code examples. Russ -Original Message- From: Jason Fisher [mailto:ja...@wanax.com

RE: Subversion Software

2010-10-14 Thread Jason Fisher
TortoiseSVN is pretty solid, although I've had to turn off the icon overlays on mapped network drives, just to improve Explorer performance. From: Paul Alkema paulalkemadesi...@gmail.com Sent: Thursday, October 14, 2010 8:32 AM To: cf-talk

Re: Subversion Software

2010-10-14 Thread Jason Fisher
No, there is a VisualSVN plugin for Visual Studio, but the same folks also make a VisualSVN Server package that is a one-step install on Windows server and is kept up to date with SVN patches etc. Very good, and free to boot. http://www.visualsvn.com/server/

Re: Subversion Software

2010-10-14 Thread Jason Fisher
Yep, same here. From: Rick Root rick.r...@gmail.com Sent: Thursday, October 14, 2010 3:35 PM To: cf-talk cf-talk@houseoffusion.com Subject: Re: Subversion Software That's why I use VisualSVN SERVER and TortoiseSVN CLIENT =) On Thu, Oct 14, 2010 at 3:01

RE: Microsoft rumored to be buying Adobe

2010-10-08 Thread Jason Fisher
Oh, man, forgot about Lasso. Back in '98 or '99 I had to convert half a dozen sites from Lasso to ColdFusion. Lasso was fine, I guess, except that it was running on a Mac server :) From: andy matthews li...@commadelimited.com Sent: Thursday, October

  1   2   3   4   5   6   >