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

2011-02-21 Thread Steve 'Cutter' Blades
I tend to use a siteId, based upon the query return. I can then reuse that ID for things like the folder name of a SiteSpecific media/assets folder. If the site url changes, the siteId does not, eliminating future heartaches. Steve 'Cutter' Blades Adobe Certified Expert Advanced Macromedia

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

2011-02-21 Thread Steve 'Cutter' Blades
This will work for a few domains, but if you end up running a few hundred (or thousand) sites off of one codebase this will get to be a maintenance nightmare. Steve 'Cutter' Blades Adobe Certified Expert Advanced Macromedia ColdFusion MX 7 Developer http://blog.cutterscrossing.com

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

2011-02-21 Thread Steve 'Cutter' Blades
Though not always the case, my experience with MSOC sites is that you're offering Software As A Service, where you retain all ownership of the code and that is clearly stated within the contract with the client. Steve 'Cutter' Blades Adobe Certified Expert Advanced Macromedia ColdFusion MX 7

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

2011-02-21 Thread Steve 'Cutter' Blades
I'm going to talk more about file structure in a post on my MSOC series, following my current discussions breaking down application event handlers. My experience shows having one base path to a SiteSpecific root: \\(some drive share\SiteSpecific Then I use a subfolder for each site: \\(some

Reflection and Class literal

2011-02-21 Thread Darren Houle
I'm trying to do some reflection in coldfusion, basically to dump the DNS cache InetAddress is currently holding in the JRE at the moment. I found a site that offers a Java language example and I'm trying to convert it to CF tags. I'm having trouble with this line... ClassInetAddress klass =

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

2011-02-21 Thread Rick Faircloth
Sounds like a good idea. So, to implement your approach, I would add a siteID into the database info linked to a domain name? Just an abstract siteID as the main identifier for the site variables, as opposed to using the site domain name, right? Rick -Original Message- From: Steve

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

2011-02-21 Thread Rick Faircloth
Yes, my perspective is that I would be offering SAAS. A client is not so much getting a site, as getting use of a customizable (mainly style) service. -Original Message- From: Steve 'Cutter' Blades [mailto:cold.fus...@cutterscrossing.com] Sent: Monday, February 21, 2011 8:20 AM To:

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

2011-02-21 Thread Rick Faircloth
Do you using IIS mappings or virtual directories for this structure? Or perhaps, CF mappings to implement this? -Original Message- From: Steve 'Cutter' Blades [mailto:cold.fus...@cutterscrossing.com] Sent: Monday, February 21, 2011 8:33 AM To: cf-talk Subject: Re: Feedback on this

Re: string function???

2011-02-21 Thread Richard White
hi, what if I had a string such as: cfset str = '({name1}/365.25)*(datediff({name2},{name3}))' / ... and wanted to only get the values enclosed in parenthesis that exist inside the datediff() part of the string? so effectively the returned array would include only {name2} and {name3} this

Re: string function???

2011-02-21 Thread Dain Anderson
You could use something like this: cfset str = '({name1}/365.25)*(datediff({name2},{name3}))' / cfset match = reFindNoCase(datediff\({([^}]*)},{([^}]*)}\), str, 1, true) / cfset name2 = mid(str, match.pos[2], match.len[2]) / cfset name3 = mid(str, match.pos[3], match.len[3]) / HTH, -Dain On

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

2011-02-21 Thread Steve 'Cutter' Blades
Generally I have a 'sites' table in my db with some basic site level info, and a separate 'sitesUrls' table that then foreign keys to the sites table. My siteId is the autogenerated key for that site's record in the sites table. Steve 'Cutter' Blades Adobe Certified Expert Advanced Macromedia

Re: string function???

2011-02-21 Thread Richard White
thanks dain, this has made me realise i really need to know more about regular expressions, as i could have another string that has now() instead of the parenthesis: cfset str = '({name1}/365.25)*(datediff(now(),{name3}))' / have played around with the expression you suggested to pick up

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

2011-02-21 Thread Steve 'Cutter' Blades
Typically I'll use Virtual Directories (or Alias in Apache) for this, to ref the SiteSpecific folder, and use ExpandPath(/SiteSpecific) to build out absolute paths for internal app use. No db interaction required, pathing automatically changes if the server config changes. (Not sure how this

Re: string function???

2011-02-21 Thread Dain Anderson
I'm curious what exactly you're trying to do, which might reveal a better way of doing it. Are you trying to replace variable placeholders so that you can evaluate the code chunk? On Mon, Feb 21, 2011 at 1:24 PM, Richard White rich...@j7is.co.uk wrote: thanks dain, this has made me realise

Re: Invalid Precision Value from SQL Server CF9

2011-02-21 Thread Nicki Tabb
I have tested the query using 0 instead of No for the default form value (see reply thread) and I am still receiving the Invalid Precision Value error. In the error, it highlights the last line as the issue (although sometimes that is deceiving) cfqueryparam cfsqltype=cf_sql_varchar

Re: string function???

2011-02-21 Thread Richard White
Are you trying to replace variable placeholders so that you can evaluate the code chunk? yes exactly ~| Order the Adobe Coldfusion Anthology now!

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

2011-02-21 Thread Pete Ruckelshaus
What I've done with clients (well, client, I've only had one that left me) who want to move is copy the site using httrack or similar, put it on a CD, and be done with it. I've also given them a copy of their specific web site content in .csv format. On Mon, Feb 21, 2011 at 8:19 AM, Steve

Coldfusion developer Los Angeles, CA

2011-02-21 Thread Gary Kraeger
Immediate need for on-site experience ColdFusion programmer consisting of ColdFusion 9, Jquery, mysql and javascript. Skill set must include a complete understanding of ColdFusion 9, AJAX, Mysql, Jquery and javascript. Must have Coldbox framework experience. Main Responsibilities will be to