Re: Control Download File List

2011-10-21 Thread Charlie Stell

Hi Mark

As far as I know, you'd need to do this use cfcontent/cfheader to deliver a
file, that itself sits outside of the web root but still accessible to the
CF server. If the file is within the web root, and someone has the url, CF
(as far as i know) cant control access to it if the file-url is requested
directly.

On Fri, Oct 21, 2011 at 7:29 PM, Mark Rogers  wrote:

>
> I am trying to create a CF template that will allow users to download files
> that that have names matching a specific criteria.
>
>
>
> For example,
>
>
>
> Sample File Names  in directory
>
>
>
> 133555_xyz
>
> 133600_abc
>
> 223450_abc
>
> 340126_oop
>
> 349888_abc
>
>
>
> If id code ='349234'
>
> allow download of any file name like '34%'
>
>
>
> In this example should only allow files 340126_oop 349888_abc
>
>
>
> for download list.
>
>
>
> Any help would be greatly appreciated
>
> Mark Rogers
> Vice President- Information Services
> National Association of Insurance and Financial Advisors
> 2901 Telestar Court
> Falls Church, VA 22042
>
> (703) 770-8130
>
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348300
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Its ColdFusion's Fault

2011-07-26 Thread Charlie Stell

"Myspace failed because it was full of ugly sites with content no-one
wanted to read."

Absolutely. And to add to it - then came along an alternative,  facebook,
which was not "full of ugly sites with content no-one wanted to read." So
myspace failed.

On Tue, Jul 26, 2011 at 6:16 AM, James Holmes wrote:

>
> I guess when Google+ finally destroys Facebook, the same open source tools
> he's glorifying will have caused that failure. Regardless, Myspace hasn't
> run on CF for a long time (as suggested, they migrated to .NET via
> BlueDragon ages ago).
>
> Myspace failed because it was full of ugly sites with content no-one wanted
> to read.
>
> --
> WSS4CF - WS-Security framework for CF
> http://wss4cf.riaforge.org/
>
>
> On 26 July 2011 18:00, Kevin Pepperman  wrote:
>
> >
> > Just to add to that-- ColdFusion is responsible for the success of Bank
> of
> > America as well as many other successful websites (well one of the
> reasons
> > anyway ;-)
> >
> > Didn't MySpace convert to .NET at some point?
> >
> > --
> > /Kevin Pepperman
> >
> > "*Never memorize what you can look up in books*."
> > --Albert_Einstein
> >
> >
> >
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346329
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Odd issue with DB "pausing"

2011-05-16 Thread Charlie Stell

If the cache filling up is the cause - the following should provide a useful
look at whats feeling it up -

SELECT  total_worker_time/execution_count AS [Avg CPU Time],
SUBSTRING(st.text, (qs.statement_start_offset/2)+1,
((CASE qs.statement_end_offset
  WHEN -1 THEN DATALENGTH(st.text)
 ELSE qs.statement_end_offset
 END - qs.statement_start_offset)/2) + 1) AS
statement_text,qs.creation_time,last_execution_time,execution_count
FROM sys.dm_exec_query_stats AS qs
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS st
ORDER BY qs.creation_time desc

Your looking for the "same" query listed many times in the above's output -
by "same" I mean queries that only differ by the values that would
be parameterized... Your wanting to see as few rows as possible
with execution_count = 1. According to my notes, on the system I had this
happen, before adding cfqueryparam, the average(execution_count) was 1.2 -
afterwards the average was in the thousands.



On Mon, May 16, 2011 at 1:13 PM, Scott Weikert  wrote:

>
> What I'm finding now, in the last little bit, is that in the case of a
> content-save triggering the hang, the content *does* seem to save - the
> queries being the "larger" ones as far as raw data being moved around.
>
> I'm in the process of poking about some older code that executes after
> those queries and param-ing them up, to see that helps.
>
> Errors: When a hang hits, I don't seem to get any SQL errors - no
> timeouts and the like - just running a simple query in the query
> analyzer tool, it just spins until it finally resolves, however long it
> takes.
>
> As far as the sql logs, my server guy hasn't indicated anything special
> showing up.
>
> On 5/16/11 10:48 AM, Charlie Stell wrote:
> > Other than an eventual timeout thrown by CF - are you getting any SQL
> errors
> > when this situation arises? (from either cf trying to run a query or when
> > trying to execute a query via analyzer)  Do any errors show up in the SQL
> > logs?
> >
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344550
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Odd issue with DB "pausing"

2011-05-16 Thread Charlie Stell

Other than an eventual timeout thrown by CF - are you getting any SQL errors
when this situation arises? (from either cf trying to run a query or when
trying to execute a query via analyzer)  Do any errors show up in the SQL
logs?



On Mon, May 16, 2011 at 12:37 PM, Charlie Stell wrote:

> An increase of the number of queries being executed via cfquery
> where queryparam isn't being used - regardless of it being from a user
> request or a scheduled process...
>
>
> On Mon, May 16, 2011 at 12:13 PM, Scott Weikert wrote:
>
>>
>> No, no recent updates (that I'm aware of), no increase in traffic.
>>
>> When you say "request increase" are you talking about behind-the-scenes
>> DB requests? Or an increase in usage by people with a corresponding
>> increase in DB traffic?
>>
>> On 5/16/11 10:06 AM, Charlie Stell wrote:
>> > Have you recently upgraded versions of MS-SQL?  And/or recently had a
>> > significant increase in requests?
>> >
>> > In the system I was referring to, it had been running for 3 years
>> without
>> > this being an issue - then we upgraded to SQL 2005 and had a request
>> > increase of about 25% - at this point we started having DB hangs about
>> every
>> > other day. I don't know if it was the load increase or a change in
>> execution
>> > plan handling by SQL... but the db hangs stopped as soon as we
>> incorporated
>> > cfqueryparam.
>> >
>> >
>>
>>
>> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344545
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Odd issue with DB "pausing"

2011-05-16 Thread Charlie Stell

An increase of the number of queries being executed via cfquery
where queryparam isn't being used - regardless of it being from a user
request or a scheduled process...

On Mon, May 16, 2011 at 12:13 PM, Scott Weikert  wrote:

>
> No, no recent updates (that I'm aware of), no increase in traffic.
>
> When you say "request increase" are you talking about behind-the-scenes
> DB requests? Or an increase in usage by people with a corresponding
> increase in DB traffic?
>
> On 5/16/11 10:06 AM, Charlie Stell wrote:
> > Have you recently upgraded versions of MS-SQL?  And/or recently had a
> > significant increase in requests?
> >
> > In the system I was referring to, it had been running for 3 years without
> > this being an issue - then we upgraded to SQL 2005 and had a request
> > increase of about 25% - at this point we started having DB hangs about
> every
> > other day. I don't know if it was the load increase or a change in
> execution
> > plan handling by SQL... but the db hangs stopped as soon as we
> incorporated
> > cfqueryparam.
> >
> >
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344544
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Odd issue with DB "pausing"

2011-05-16 Thread Charlie Stell

Have you recently upgraded versions of MS-SQL?  And/or recently had a
significant increase in requests?

In the system I was referring to, it had been running for 3 years without
this being an issue - then we upgraded to SQL 2005 and had a request
increase of about 25% - at this point we started having DB hangs about every
other day. I don't know if it was the load increase or a change in execution
plan handling by SQL... but the db hangs stopped as soon as we incorporated
cfqueryparam.


On Mon, May 16, 2011 at 11:53 AM, Scott Weikert  wrote:

>
> Yep, there's quite a few queries without cfqueryparam - but again, this
> is behavior that has popped up of late - this is code that's been around
> for years that hasn't had this sort of issue. So I don't know that this
> is a problem.
>
> I'm unsure as to recovery model - we have a hosting guy who maintains
> the DB box.
>
> On 5/16/11 9:50 AM, Charlie Stell wrote:
> > Do you have many queries (especially queries ran very often) that do not
> use
> > cfqueryparam? Those symptoms remind me of system I worked in once where
> most
> > of the queries were not using queryparam or any other form of binding -
> and
> > as a result sql's query cache was filling up too often... though I'm sure
> > many other things could be the culprit : )
> >
> > What recovery model is your db using?
> >
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344539
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Odd issue with DB "pausing"

2011-05-16 Thread Charlie Stell

Do you have many queries (especially queries ran very often) that do not use
cfqueryparam? Those symptoms remind me of system I worked in once where most
of the queries were not using queryparam or any other form of binding - and
as a result sql's query cache was filling up too often... though I'm sure
many other things could be the culprit : )

What recovery model is your db using?


On Mon, May 16, 2011 at 11:30 AM, Mark A. Kruger wrote:

>
> Scott,
>
> It might pay to eliminate networking as a possible issue. For example - are
> the ports on the switch trying to "scale up" to 1000/mbs from 100?  This
> could cause what looks like a temporary "hang".  (try statically setting
> ports end to end between the server and db).
>
> Or perhaps you have  a mixed environment with XP, Linux, Windows server 00
> or 03 along with 2008r2 in it... the 08 OS defaults to larger packet sizes
> on the network and this can cause detrimental effects in mixed networks
> when
> it kicks in.
>
> -Mark
>
>
> Mark A. Kruger, MCSE, CFG
> (402) 408-3733 ext 105
> www.cfwebtools.com
> www.coldfusionmuse.com
> www.necfug.com
>
>
> -Original Message-
> From: Scott Weikert [mailto:li...@alphageek.cc]
> Sent: Monday, May 16, 2011 9:58 AM
> To: cf-talk
> Subject: Odd issue with DB "pausing"
>
>
> Ok I've got a headscratcher here, would love some input from some other
> brains out there. Sometimes it sucks to be the lone gunman developer. :(
>
> Got CF8 running using MSSQL. Lately, every now and again (too often) the
> DB appears to hang, anywhere from a minute or so to several minutes. As
> best I can tell (from previous times when it's happened, and I was
> remoting our DB box at the time) the CPU isn't spiking during these
> hangs. It seems to just be connections from our webservers to the
> database that is affected.
>
> Based on comments from one of my employers working in the system at the
> time, and from a few clients, it seems these hangs are triggered by a
> specific action in our system - a content-save to a particular table,
> that holds the lion's share of client content (webpage content).
>
> I've tried making changes to said script a couple of times - adjusting
> the query, storedproc-ing it up. There seems to be no rhyme or reason to
> it - different times it hangs, there's different amounts of content
> being saved. One client tends to stuff the most in there - another, not
> nearly so much - and both seem to trigger the hang.
>
> This behavior is pretty recent - just the last few weeks. And I can't
> for the life of me puzzle out what's different. We had an issue recently
> with an old bug, the "corrupt table" issue, and there was a little bit
> of fiddling with the datasource settings before this issue was somewhat
> resolved, so I have to wonder if something adjusted during that episode
> isn't the cause of this behavior. Nothing in the datasource settings
> screams "ME ME ME I'M THE ONE".
>
> When the hangs occur, triggered by whatever use on our main webserver,
> it affects the DB connections on the other servers as well - even a web
> environment that is using other databases (dev env) but said other DBs
> are on the same DB server. All servers just sit on "waiting on..." in
> the browser status 'til the hang passes, then all is well again.
>
> I'm about at my wit's end trying to puzzle this one out - I sure could
> use some nudging in the right direction.
>
> Thanks in advance -
> --Scott
>
>
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344534
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Regex Question

2011-04-28 Thread Charlie Griefer

Could be as simple as \w{3} 

Would that do it (searching for 3 consecutive word characters)?

-- 
Charlie Griefer
http://charlie.griefer.com

I have failed as much as I have succeeded. But I love my life. I love my wife. 
And I wish you my kind of success.
On Thursday, April 28, 2011 at 10:10 AM, Rick Colman wrote: 
> 
> input looks like:
> 
> (A XXX)(B YYY)(C ZZZ) 
> 
> I need to pull out:
> 
> XXXYYYZZZ ...
> 
> Can somebody help?
> 
> TNX.
> 
> Rick.
> 
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344026
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: "Corrput Table" error with queries with cachedwithin

2011-04-25 Thread Charlie Stell

Are you using any *s in your select statement?

On Mon, Apr 25, 2011 at 2:05 PM, Scott Weikert  wrote:

>
> I've done some digging on this and everything I'm finding is ancient
> (circa 2007).
>
> Today I started getting a "corrupt table" error with every query that
> has a "cachedwithin" set on it on one of my servers.
>
> On another server, a backup for the main server, with (as best I can
> tell) the same CF admin settings and codebase - no problems.
>
> This is a codebase with a bunch of cachedwithins set up, some that have
> been around for years.
>
> The error pops even with a little one-off test script.
>
> The CF version shows the same on both server's info page - 8,0,0,176276.
> I'm unsure whether the old hotfix that is supposed to handle this issue
> was ever applied. (I'm not the server admin in this case)
>
> I'm furiously running through my code, commenting out the cachedwithins
> and posting, but this is a temp thing - need to figure out what's up.
>
> Thoughts?
>
> Thanks much in advance -
>
> --Scott
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343979
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: IIS Question

2011-04-23 Thread Charlie Stell

You'd likely want to defined two iis sites, one for dev and one for prod.

For each site, the home directory should be the respective code base for each, 
and you'd want to add a virtual directory pointing to cfide on each. The 
differing drives should be no problem.

Hope that helps!
Charlie



On Apr 23, 2011, at 1:15 PM, fun and learning  wrote:

> 
> Hi All -
> 
> I have a IIS/coldfusion question. I am working with a client, who has both 
> production and development stuff on the same machine. He has two drives, C 
> and E. C drive has development files and E drive has production. The IIS 
> configuration points to E drive.
> 
> C drive the has the following structure:
> 
> C:/
> - Coldfusion 9
> - Inetpub
>   - coldfusion files
> 
> E:/
> - Web
>- coldfusion files
> 
> But confused if IIS can point to two different drives? How to find out which 
> drive the IIS point out to.. I hope I am not vague with my question
> 
> Thanks a lot. 
> 
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343913
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Odd issue with Query

2011-04-07 Thread Charlie Stell

So this was a weird one... the error is resolved, but I was wondering if
anyone could explain what was causing my error.

I had a query that was timing out (its one of those nice long monster
queries - so I'm not pasting it in its entirety) - but when I copied/pasted
out of the cfcatch.sql (from error thrown on timeout) into SQL Query
Analyzer - or another template, it completed in under a second.

In the query there was a join that looked like this -

LEFT JOIN tableA on ColX

= ColY

= ColZ


Changing it to either of the following resolved the issue
Solution 1:
LEFT JOIN tableA on ColX 
= ColY

= ColZ


Solution 2:

LEFT JOIN tableA on ColX = ColY

LEFT JOIN tableA on ColX = ColZ


So I'm assuming there was something going on related to the carriage return
following "ColX " - and in addition to the two solutions above, the process
of copy-pasting also must have resolved it.

If it makes any difference - I'm using SeeFusion for monitoring and so all
my datasources use:
JDBC URL:
jdbc:seefusion:jdbcwrapper:{jdbc:macromedia:sqlserver://server1:1433;
databaseName=dbname; SelectMethod=direct;
sendStringParametersAsUnicode=false; MaxPooledStatements=1000};
Driver Class: com.seefusion.Driver

Anyone have any idea on the root problem?

Thanks!
charlie


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343607
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: who's in charge around here?

2011-03-22 Thread Charlie Griefer

On Tuesday, March 22, 2011 at 9:49 AM, Dave Watts wrote:
> 
> > The person in charge is Michael Dinowitz. He's kick ass, but busy with about
> > 300 children and tons of extra circular activities.
> 
> I'm not sure what an extra circular activity is, but I guess it has
> something to do with having 300 kids!
Hey, when one of you slackers does get around to re-doing the web interface, 
can you add a "Like" button? Because it's a crime that I can't "like" this 
reply :) 

-- 
Charlie Griefer
http://charlie.griefer.com

I have failed as much as I have succeeded. But I love my life. I love my wife. 
And I wish you my kind of success. 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343214
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Storing decimal parts of a second & cfqueryparam

2011-02-28 Thread Charlie Griefer

I think your code is fine, but take a look at the precision value for the 
column in SQL Server. Ensure that it's set to 2.

-- 
Charlie Griefer
http://charlie.griefer.com

I have failed as much as I have succeeded. But I love my life. I love my wife. 
And I wish you my kind of success.
On Saturday, February 26, 2011 at 8:08 PM, Pete Ruckelshaus wrote: 
> 
> OK, just not my night with decimal values.
> 
> Trying to store distances (for throwing and jumping events), which are
> measured in feet and inches. In order to maintain proper sort order, I
> decided to convert feet and inches (with fractions of an inch as decimal
> value) to inches with fractions of an inch as decimal values.
> 
> Again, database is SQL Server 2008, and I'm using cfqueryparam. Data type
> for the column in question is decimal(18, 4), and I'm using CF_SQL_DECIMAL
> as the cfsqltype value. I can see in the debug output that the decimal
> portion of the value is part of the value to be inserted, for instance,
> 825.25, but looking at the database table, the stored value is 825.
>  Here's the debug output for that query:
> 
> *insertResult* (Datasource=track, Time=2ms, Records=1) in
> C:\inetpub\wwwroot\track\enter_results.cfm @ 21:59:59.059
> 
>  INSERT INTO tblEventResults(eventid, athleteid, time, distance,
> competition)
>  VALUES (?,
>  ?,
>  ?,
>  ?,
>  ?)
> 
> 
> Query Parameter Value(s) -
> Parameter #1(CF_SQL_INTEGER) = 1
> Parameter #2(CF_SQL_INTEGER) = 1
> Parameter #3(CF_SQL_TIMESTAMP) =
> Parameter #4(CF_SQL_DECIMAL) = 825.25
> Parameter #5(CF_SQL_BIT) = NO
> 
> Should I be using a different precision value for the decimal datatype? Or
> am I just doing something idiotic?
> 
> Thanks,
> 
> Pete
> 
> On Sat, Feb 26, 2011 at 4:59 PM, Pete Ruckelshaus 
> wrote:
> 
> > Hey, that did it! Thanks!
> > 
> > Pete
> > 
> > 
> > On Sat, Feb 26, 2011 at 4:43 PM, Charlie Griefer <
> > charlie.grie...@gmail.com> wrote:
> > 
> > > 
> > > Hi Pete:
> > > 
> > > Have you tried cf_sql_timestamp as the cfsqltype (as opposed to
> > > cf_sql_time)?
> > > --
> > > Charlie Griefer
> > > http://charlie.griefer.com
> > > 
> > > I have failed as much as I have succeeded. But I love my life. I love my
> > > wife. And I wish you my kind of success.
> > > On Saturday, February 26, 2011 at 2:33 PM, Pete Ruckelshaus wrote:
> > > > 
> > > > I'm building an app for keeping track of high school track meet results
> > > > using CF9 and MS SQL Server 2008. I am using the "time(7)" data type in
> > > the
> > > > database, and when doing the insert query, I'm using  with
> > > a
> > > > sqltype of cf_sql_time. However, when entering a time value of, for
> > > > example, "00:01:22.05", the value that actually gets inserted drops the
> > > > decimal part of the seconds. When I do the insert query without using
> > > > , it works fine. I prefer using cfqueryparam for obvious
> > > > reasons and am always hesitant to not use it, so is there a way to get
> > > it to
> > > > work and still have it retain the decimal portion of the second?
> > > > 
> > > > Thanks,
> > > > 
> > > > Pete
> 
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342611
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Storing decimal parts of a second & cfqueryparam

2011-02-26 Thread Charlie Griefer

Hi Pete:

Have you tried cf_sql_timestamp as the cfsqltype (as opposed to cf_sql_time)? 
-- 
Charlie Griefer
http://charlie.griefer.com

I have failed as much as I have succeeded. But I love my life. I love my wife. 
And I wish you my kind of success.
On Saturday, February 26, 2011 at 2:33 PM, Pete Ruckelshaus wrote: 
> 
> I'm building an app for keeping track of high school track meet results
> using CF9 and MS SQL Server 2008. I am using the "time(7)" data type in the
> database, and when doing the insert query, I'm using  with a
> sqltype of cf_sql_time. However, when entering a time value of, for
> example, "00:01:22.05", the value that actually gets inserted drops the
> decimal part of the seconds. When I do the insert query without using
> , it works fine. I prefer using cfqueryparam for obvious
> reasons and am always hesitant to not use it, so is there a way to get it to
> work and still have it retain the decimal portion of the second?
> 
> Thanks,
> 
> Pete
> 
> 
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342600
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Re: Change in ColdFusion management

2011-02-15 Thread Charlie Griefer

Adam posted that from his gmail account. Doesn't seem that he was acting in any 
official capacity for his company there (also no sig indicating that he's an 
Adobe employee).

Yeah, I understand that there are some politics in play, but regardless of the 
position we hold, or the company for whom we work, I think people should 
generally be allowed to express their opinions outside of that, without fear of 
repercussion. 
-- 
Charlie Griefer
http://charlie.griefer.com

I have failed as much as I have succeeded. But I love my life. I love my wife. 
And I wish you my kind of success.
On Tuesday, February 15, 2011 at 11:48 AM, Judah McAuley wrote: 
> 
> On Tue, Feb 15, 2011 at 10:42 AM, Brian Kotek  wrote:
> > 
> > That's one way to look at it. But the much more likely view (and the one
> > Adobe sees) is that the people who think he's guilty of "bad behavior" are
> > not only a tiny minority, but are also wrong.
> 
> Perhaps I have a misunderstanding of the Adobe corporate culture, but
> if I was acting in an official capacity for my company and called one
> of our customers a dick on a public mailing list, I'm pretty sure that
> my boss would consider that bad behavior.
> 
> Judah
> 
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342301
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: coldfusion errors

2011-02-08 Thread Charlie Griefer

There's a whole section on it in the livedocs :)

http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSc3ff6d0ea77859461172e0811cbec22c24-7fc4.html

On Tue, Feb 8, 2011 at 6:30 PM, Richard  Steele  wrote:
>
> Is there anyway to catch coldfusion programming errors?
>
> #999sdflkjsdf;lk# is caught by my error handler.
>
> But #alsdk;fjlkj# is not.
>
> Thanks in advance.
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342026
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Charge for meetings

2011-02-07 Thread Charlie Griefer

On Mon, Feb 7, 2011 at 4:33 PM, Sean Corfield  wrote:
>
> On Mon, Feb 7, 2011 at 6:15 AM, Marc Funaro  
> wrote:
>> Sean, it would be interesting to learn what source code repository + 
>> ticketing system you use.
>
> Unfuddle.com seems to be the most accessible for clients in terms of
> friendly terminology etc.
>
> And I use git with it.

Hey wow.  Me too :)

-- 
Charlie Griefer
http://charlie.griefer.com/

I have failed as much as I have succeeded. But I love my life. I love
my wife. And I wish you my kind of success.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341959
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: SQL query question

2011-02-01 Thread Charlie Stell

This might be an issue I've had to deal with before.

Do something to change the "fingerprint" (no idea what the correct term
would be) of the query - or restart cf. By change the "fingerprint", it
could be something as simple ad swapping p.* and pt.* (swapping as
in their ordinal position in the select clause). In the past, what has
happened is I'll have some query with at least one * in the select statement
followed by one or more columns and I add a column to whatever I was
selecting * from. If the query stays the same, it uses the same result-set
template (again, im making up words - no idea what its really called)  It
doesn't know to check the underlying structure of the table. But the newly
added column gets returned by the db - offsetting all the columns in the
rest of the result set.

So as crazy as it sounds - just change something in the sql, and give it a
try. It doesn't have to actually change anything about what the query does -
adding ,getdate() as helloworld will fix it - and then you can undo the
change after one successful run. I assume this is something on CF's side -
as restarting the CF service also fixes it.



On Tue, Feb 1, 2011 at 4:23 PM, Debbie Morris wrote:

>
> Since everyone should be in a SQL Join state of mind...here's another one.
>
> I have a weird issue that I haven't been able to narrow down yet. I'm
> trying to add a new field to one of my tables to store some additional
> information, but once I add the column, my previously working query breaks.
>
> Here's the query (obviously the person that originally wrote it is in the
> 'the fewer characters, the better' camp):
>
> SELECT p.*, pt.*, pm.Type AS mtype, s.fname AS sfname, s.lname AS slname,
> pa.DateActive AS PenAmountDate, pa.MonthlyAmount AS PenAmt, pa.Note AS
> PenAmtNote, s.SSN AS sssn, s.DOB AS sdob, spm.Type AS smt
>
> FROM   PensionerMedicalType spm
> INNER JOIN PensionerSpouse s ON spm.MedicalID = s.MedicalType
> RIGHT OUTER JOIN PensionersActive p
> INNER JOIN PensionerType pt ON p.PensionerType = pt.PensionerTID
> LEFT OUTER JOIN PensionAmounts pa ON p.PenActID = pa.PenID
> LEFT OUTER JOIN PensionerMedicalType pm ON p.MedicalType = pm.MedicalID ON
> s.SpouseID = p.Spouse
> WHERE  (p.PenActID = 
> AND pa.active = 1)
>
>
> As soon as I add a column named 'lifeInsType' to the PensionersActive (p)
> table, I get the following error when the same query runs:
>
> Error Executing Database Query.
> [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested
> type.
>
> What am I overlooking?
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341803
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Anyone know anything about this new ColdFusion conference?

2011-01-31 Thread Charlie Griefer

Ben - if you think there's a venue in which the discussion *could* be
had productively, I'd love to be a part of it, or at the very least,
do whatever I could to help make it happen.  Just say the word.

On Mon, Jan 31, 2011 at 7:46 PM, Ben Forta  wrote:
>
> Charlie,
>
> I'd love to have a productive discussion on this subject. And yes, I have
> opinions on this one, I've shared them before and am happy to do so again.
> And no, as much as I admire Adam's passion for ColdFusion (it's why I nudged
> him into the role), I don't fully agree with his take on things. But
> regardless, I don't think this thread can be steered anywhere. When
> conversations denigrate to emotional rants and accusations and
> unsubstantiated sweeping generalizations, that's when I back away.
>
> --- Ben
>
>
> -Original Message-
> From: Charlie Griefer [mailto:charlie.grie...@gmail.com]
> Sent: Monday, January 31, 2011 9:28 PM
> To: cf-talk
> Subject: Re: Anyone know anything about this new ColdFusion conference?
>
>
> Rather than ignore it... is it worth trying to steer in a more productive
> direction?  Can it be a productive discussion?
>
> I've gone on record before as saying I don't think the existence of the
> alternate engines spells the doom of Adobe ColdFusion.  I may be wrong, but
> lord I hope not.  Adobe ColdFusion has been -very- good to me over the past
> 15 years, not just professionally, but personally.
> Many of the people that I consider my best friends are friends that I've
> made in the CF community.  So I've got both a personal and professional
> interest in this, and it's a subject that I care about quite a bit.
>
> If it can't be done here... so be it.  Just seems that we have
> representation from all sides, and nobody seems to be too shy about sharing
> how they feel.  All we need to do is steer the discussion in a direction
> where it's more productive and constructive.  Assuming that direction...
> y'know... exists.
>
> On Mon, Jan 31, 2011 at 7:14 PM, Ben Forta  wrote:
>>
>> Good point, I guess I blocked those from my memory.
>>
>> Oh well, I guess I'll just have to ignore this pointless banter up for
>> a few more days before the thread makes it to the CF-Talk Rogues Gallery.
>>
>> --- Ben
>>
>>
>> -Original Message-
>> From: Dave Watts [mailto:dwa...@figleaf.com]
>> Sent: Monday, January 31, 2011 8:58 PM
>> To: cf-talk
>> Subject: Re: Anyone know anything about this new ColdFusion conference?
>>
>>
>>> I officially nominate this thread as the least productive on cf-talk
> ever.
>>
>> I'm sorry, Ben, but this one isn't even close. Are you forgetting all
>> the "why isn't CF/CFB free" threads? Or the "is CF dying" threads?
>> This one will need at least twenty more replies before it's even in
>> the same category.
>>
>> Dave Watts, CTO, Fig Leaf Software
>> http://www.figleaf.com/
>> http://training.figleaf.com/
>>
>> Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA
>> Schedule, and provides the highest caliber vendor-authorized
>> instruction at our training centers, online, or onsite.
>>
>>
>>
>>
>
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341778
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Anyone know anything about this new ColdFusion conference?

2011-01-31 Thread Charlie Griefer

Rather than ignore it... is it worth trying to steer in a more
productive direction?  Can it be a productive discussion?

I've gone on record before as saying I don't think the existence of
the alternate engines spells the doom of Adobe ColdFusion.  I may be
wrong, but lord I hope not.  Adobe ColdFusion has been -very- good to
me over the past 15 years, not just professionally, but personally.
Many of the people that I consider my best friends are friends that
I've made in the CF community.  So I've got both a personal and
professional interest in this, and it's a subject that I care about
quite a bit.

If it can't be done here... so be it.  Just seems that we have
representation from all sides, and nobody seems to be too shy about
sharing how they feel.  All we need to do is steer the discussion in a
direction where it's more productive and constructive.  Assuming that
direction... y'know... exists.

On Mon, Jan 31, 2011 at 7:14 PM, Ben Forta  wrote:
>
> Good point, I guess I blocked those from my memory.
>
> Oh well, I guess I'll just have to ignore this pointless banter up for a few
> more days before the thread makes it to the CF-Talk Rogues Gallery.
>
> --- Ben
>
>
> -Original Message-
> From: Dave Watts [mailto:dwa...@figleaf.com]
> Sent: Monday, January 31, 2011 8:58 PM
> To: cf-talk
> Subject: Re: Anyone know anything about this new ColdFusion conference?
>
>
>> I officially nominate this thread as the least productive on cf-talk ever.
>
> I'm sorry, Ben, but this one isn't even close. Are you forgetting all the
> "why isn't CF/CFB free" threads? Or the "is CF dying" threads?
> This one will need at least twenty more replies before it's even in the same
> category.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> http://training.figleaf.com/
>
> Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule,
> and provides the highest caliber vendor-authorized instruction at our
> training centers, online, or onsite.
>
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341768
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Coldfusion Hosting

2011-01-28 Thread Charlie Griefer

When you're paying $75 a year for CF hosting, you don't get the luxury
of folks getting to see it in multiple browsers :D

On Fri, Jan 28, 2011 at 12:16 PM, DURETTE, STEVEN J (ATTASIAIT)
 wrote:
>
> Strange it came up for me in Firefox, but my Corporate version of IE8
> gets the following error:
>
> Forbidden
> You don't have permission to access / on this server.
>
> Additionally, a 404 Not Found error was encountered while trying to use
> an ErrorDocument to handle the request.
>
> -Original Message-
> From: Charlie Griefer [mailto:charlie.grie...@gmail.com]
> Sent: Friday, January 28, 2011 2:10 PM
> To: cf-talk
> Subject: Re: Coldfusion Hosting
>
>
> Weird.  Comes up for me.  Came up for me a few minutes ago (I brought
> the site up to check the price).  Hmm...
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341662
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Coldfusion Hosting

2011-01-28 Thread Charlie Griefer

Weird.  Comes up for me.  Came up for me a few minutes ago (I brought
the site up to check the price).  Hmm...

On Fri, Jan 28, 2011 at 12:09 PM, DURETTE, STEVEN J (ATTASIAIT)
 wrote:
>
> That's funny, http://hostingatoz.com/ returns "FORBIDDEN" You don't have
> permission to access/ on this server!
>
> Steve
>
> -Original Message-
> From: Charlie Griefer [mailto:charlie.grie...@gmail.com]
> Sent: Friday, January 28, 2011 2:03 PM
> To: cf-talk
> Subject: Re: Coldfusion Hosting
>
>
> Well, if you believe in the old adage of "you get what you pay for"...
> then "decent" and "cheap" are mutually exclusive :)
>
> That being said... since "decent" is a subjective term (altho I guess
> "cheap" is as well), a while back I hosted my blog at
> http://hostingatoz.com/.  Their most expensive package (which includes
> ColdFusion 8) is $75 a year.
>
> When I was with them, it was... "decent".  There were downtimes, but I
> sort of expected that going into a $75/yr host.  I will say the
> downtimes weren't nearly as frequent as I expected, and the support
> was very good, at least in terms of responsiveness.
>
> I know others who used them (some at my recommendation back then), who
> didn't have as good of an experience.
>
> At $75/yr, you takes your chances :)
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341654
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Coldfusion Hosting

2011-01-28 Thread Charlie Griefer

Well, if you believe in the old adage of "you get what you pay for"...
then "decent" and "cheap" are mutually exclusive :)

That being said... since "decent" is a subjective term (altho I guess
"cheap" is as well), a while back I hosted my blog at
http://hostingatoz.com/.  Their most expensive package (which includes
ColdFusion 8) is $75 a year.

When I was with them, it was... "decent".  There were downtimes, but I
sort of expected that going into a $75/yr host.  I will say the
downtimes weren't nearly as frequent as I expected, and the support
was very good, at least in terms of responsiveness.

I know others who used them (some at my recommendation back then), who
didn't have as good of an experience.

At $75/yr, you takes your chances :)

On Fri, Jan 28, 2011 at 11:49 AM, Adam Bourg  wrote:
>
> Can anyone recommend a decent yet cheap web host for ColdFusion?
>
> Right now I'm hosting my site at DreamHost (Simple wordpress as CMS site).
>
> I'm looking for
> SQL
> PHP 5
> and Coldfusion 8 support
> all under $6.
>
> Am I dreaming?
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341650
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Subtracting two dates

2011-01-28 Thread Charlie Griefer

On Fri, Jan 28, 2011 at 11:45 AM, Adam Bourg  wrote:
>
> I'm trying to figure out how to subtract two dates and return the number of 
> days between then.
>
> My dates are cprAdultExp, which is a database column, I typically write it 
> as: #dateformat(cprAdultExp,"mm/dd/")#
>
> The other is Now()
> Which I also format as: #dateformat(Now(),"mm/dd/")#
>
> What's the easy way to do this?

http://www.cfquickdocs.com/cf9/#datediff

-- 
Charlie Griefer
http://charlie.griefer.com/

I have failed as much as I have succeeded. But I love my life. I love
my wife. And I wish you my kind of success.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341645
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: why is cf_builder so expensive?

2011-01-26 Thread Charlie Griefer

You missed the part where he said, "And I'm the sole breadwinner."

On Wed, Jan 26, 2011 at 10:32 PM, Eric Roberts
 wrote:
>
> I am sure you also make a lot more than I do (combined household that
> is...especially if your wife has an MBA...mine is going for her CAN
> certificate) Sean ;-)
>
> -Original Message-
> From: Sean Corfield [mailto:seancorfi...@gmail.com]
> Sent: Wednesday, January 26, 2011 22:21
> To: cf-talk
> Subject: Re: why is cf_builder so expensive?
>
>
> We all have priorities and choices and there are pros and cons to all of
> them.
>
> I also have a wife (of 11+ years now) and we're still paying off her MBA
> loans (from Pepperdine). We have no human kids but we have a lot of
> four-legged furry 'kids' that eat us out of house and home. And I'm the sole
> breadwinner. Luckily my wife makes me spend money on stuff for my consulting
> business (esp. in November / December as the end of the tax year looms
> large) so each year normally sees an appropriate amount of software and
> hardware purchased. And of course conference attendance counts too (so,
> apart from missing me when I'm not home, she's very supportive / encouraging
> of me attending conferences).
>
> I know we've had this discussion before and I suspect we'll just have to
> agree to disagree.
>
> Sean
>
> On Wed, Jan 26, 2011 at 7:45 PM, Eric Roberts
>  wrote:
>> Yeah...wife...and an ex-wife, 2 kids (one lives with us, other with
>> ex) plus
>> 3 step kids (one lives with us)...plus wife is going to school and the
>> step daughter that lives with us also has a daughter and is not
>> employed so I am the sole breadwinner for the household...so
>> yeah...300 is a shitload of money to me.
>
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341499
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Return boolean from a CFC query -- UPDATE: Solved

2011-01-26 Thread Charlie Griefer

On Wed, Jan 26, 2011 at 12:30 PM, Ezra Parker  wrote:
>
> On Wed, Jan 26, 2011 at 10:43 AM, Charlie Griefer
>  wrote:
>> 
>
> Unless I'm missing something, this should be:
>
> 

Y'know, I'd bring up the fact that I've been working in script much
more than tags lately... but "=" *still* wouldn't be the correct
operator.

*sigh* :)

-- 
Charlie Griefer
http://charlie.griefer.com/

I have failed as much as I have succeeded. But I love my life. I love
my wife. And I wish you my kind of success.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341433
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Return boolean from a CFC query -- UPDATE: Solved

2011-01-26 Thread Charlie Griefer

d'oH!  Good catch.

So if you go the implicit boolean conversion route, switch the "return
true" for "return false"...

On Wed, Jan 26, 2011 at 12:06 PM, Scott Stroz  wrote:
>
> Actually, these will not return the same value.
>
> Lets assume the query returns 0 records.
>
>  will return true
>
>  will return false
>
>
> On Wed, Jan 26, 2011 at 1:43 PM, Charlie Griefer
>  wrote:
>>
>> On Wed, Jan 26, 2011 at 11:31 AM, Adam Bourg  wrote:
>>>
>>> I solved it with the first couple of posts help.
>>>
>>>      
>>>          
>>>      
>>>          
>>>      
>>
>> Glad you got it working.
>>
>> You can tighten that return up a bit by doing:
>>
>> 
>>
>> Then no need for the conditional.
>>
>> You could also drop the comparison itself since CF does implicit
>> boolean conversion.
>>
>> 
>>
>> ^That'll do the same thing.
>>
>> --
>> Charlie Griefer
>> http://charlie.griefer.com/
>>
>> I have failed as much as I have succeeded. But I love my life. I love
>> my wife. And I wish you
>>
>>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341423
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Return boolean from a CFC query -- UPDATE: Solved

2011-01-26 Thread Charlie Griefer

Well, it will return the actual recordcount... which is a number.  But
CF implicitly converts numeric values to boolean values. Any non-zero
value is true, while any zero value is false.

So given the following code:

do something

... assuming myMethod returns a numeric value, your page will output
"do something" as long as the value returned is not zero.

On Wed, Jan 26, 2011 at 12:02 PM, Che Vilnonis  wrote:
>
> Charlie, is this true only when the return type is "Boolean"?
> Otherwise, it should return the actual recordcount, right?
>
> Thanks, Che
>
>
>
>
> You could also drop the comparison itself since CF does implicit boolean
> conversion.
>
> 
>
> ^That'll do the same thing.
>
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341419
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Return boolean from a CFC query -- UPDATE: Solved

2011-01-26 Thread Charlie Griefer

On Wed, Jan 26, 2011 at 11:31 AM, Adam Bourg  wrote:
>
> I solved it with the first couple of posts help.
>
>      
>          
>      
>          
>      

Glad you got it working.

You can tighten that return up a bit by doing:



Then no need for the conditional.

You could also drop the comparison itself since CF does implicit
boolean conversion.



^That'll do the same thing.

-- 
Charlie Griefer
http://charlie.griefer.com/

I have failed as much as I have succeeded. But I love my life. I love
my wife. And I wish you 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341402
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Return boolean from a CFC query

2011-01-26 Thread Charlie Griefer

Got a few questions about your CFC method...

1) where is the variable DSN coming from?
2) Should your WHERE be: WHERE profileID = #session.profile.profileID#
? (essentially the reverse of what you have)
3) consider using  in your SQL when using dynamic values
(yeah, I know... that's not a question)
4) along those same lines, you should var scope your query name.
, and then run the cfquery.  It
may or may not be a big deal for this particular method... but in
general, you want to var scope any variable used in a method.  This
ensures that the variable is bound to that method and that method
only.
5) you're running the query, but returning true regardless of the
result of the query.  Should there perhaps be a conditional in there?
6) As Michael F. suggested, you might want to pass the profileID
variable in as an argument to the method.  It's generally considered
to be bad practice to reference session (or any outside scope) from
within a cfc method, as that breaks encapsulation (meaning the method
should only know about itself... nothing about the 'outside world'...
anything it needs to know should be sent in to it... think "black
box").
7) To see what the query is returning, you can always do a  right after the  and
above the 

On Wed, Jan 26, 2011 at 10:47 AM, Adam Bourg  wrote:
>
> Here's what I'm trying to do. I'm building a module that only our 
> Professional Staff can access, I am trying to identify where the person 
> logged in is a pro staff member or a student staffer. When they log into our 
> CMS, there is a session variable that returns their profile id. it is: 
> #Session.Profile.profileID#
>
> We have two tables:
> Table 1: pro_profile
> Primary key: profileID
> This contains all users, their information etc...
>
> Table 2: mod_userStatus
> Primary key:
> Sec Key: profileID
> This is simply a primary key with a secondary key of profileID. If a person 
> is on this list they are a prostaffer, if not they are a student.
>
> I'm trying to query the database and return boolean if the user exists on 
> mod_userStatus. If yes, they can access the page, if no, redirect.
>
> Here's the CFC.
>
>    
>        
>                SELECT
>                profileID
>            FROM
>                mod_userStatus
>                WHERE
>                #Session.Profile.profileID# = profileID
>        
>
>      
>    
>
> When I run this, it just gives me a blank page, returns nothing and no error.
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341393
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: why is cf_builder so expensive?

2011-01-25 Thread Charlie Griefer

On Tue, Jan 25, 2011 at 8:14 PM, Michael Firth  wrote:
>
> Sorry to hear that coming from a CTO of a leading company, but your opinion 
> is your opinion and I can respect that.  Actually, I have gotten some good 
> perspectives and while I think it could be cheaper my aim was to get a 
> discussion going about it because I have been away for a while.  I just wish 
> you had offered a wider perspective on it.

Not sure what you're sorry to hear... everything Dave said was spot-on
(he's more spot-on than Wikipedia).  As far as his (or anybody's)
perspective... again, it's not necessarily a productive use of
anybody's time (yours or theirs).  I can tell you that it has "feature
X", which absolutely ROCKS!  But you might not have a need for
"feature X", or you just might not like "feature X".

There's a trial period that allows you to form your own perspective on
it.  Asking other people "why should I buy it", without having
downloaded it yourself and trying it... doesn't seem like the most
judicious use of anybody's time.

-- 
Charlie Griefer
http://charlie.griefer.com/

I have failed as much as I have succeeded. But I love my life. I love
my wife. And I wish you my kind of succes

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341303
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: why is cf_builder so expensive?

2011-01-25 Thread Charlie Griefer

On Tue, Jan 25, 2011 at 7:48 PM, Michael Firth  wrote:
> I am surprised that nobody has really tried to say why cf builder is so good 
> likes it features.  in other words, nobody has really provided a good reason 
> as to why should I invest in it.

Because "good" is relative.  What I think is "good", you might not...
so why don't *you* download the trial and take it for a spin.  See if
*you* think it's good.  Or, at the very least, worth $299 (which also
includes FlashBuilder).

As far as why it's different than CFEclipse... already been put
together for you.

www.adobe.com/products/coldfusion/whitepapers/pdf/cfb_overview.pdf

-- 
Charlie Griefer
http://charlie.griefer.com/

I have failed as much as I have succeeded. But I love my life. I love
my wife. And I wish you my kind of success

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341284
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Is Coldfusion losing it biggest asset?

2011-01-13 Thread Charlie Griefer

On Thu, Jan 13, 2011 at 5:39 PM, Sean Corfield  wrote:

> Remember: the success of PHP, Ruby and other languages has come about
> _without_ a company spending money on marketing. Those languages have
> become popular because their users - their communities - have
> evangelized and created tutorials and books and great free open source
> software and so on. You can't lay the fault at Adobe's door...

Sure, but PHP, Ruby and other languages don't have an up front cost
associated with them.  So yeah, nobody had to market those languages,
but at the same time, those languages didn't have to overcome the
objections of "why should I pay $x per server up front and then the
costs of upgrades..."

I think the CF community has done OK in creating tutorials and the
like.  Books, maybe not so much since version 6, but I think that's
more due to publishers not being so interested in publishing
ColdFusion books.  Great free open source software?  Yeah, we may be
lacking in that area compared to other languages... but I think that
price tag issue still comes into play there.  You can set up a PHP
server and grab wordpress and be up and running.  If you want
ColdFusion OSS, you still need to buy the ColdFusion license... so I
don't know that the demand has been there enough to justify the
effort.

Don't get me wrong... you and I have had this conversation at CFUG
meetings.  There just doesn't seem to be as much enthusiasm in general
within the CF community as there is in some other, younger
communities.  We've talked about some of the reasons why that might be
(mature language, many users content to get by using what they
know...), and that's unfortunate.

But CF is, and likely always will be, a niche product.  We'll never
have the sheer numbers that PHP or Ruby do.  So as enthusiastic as our
army may ever be... we'll never have the numbers to go out and really
make a significant impact on the programming community as a whole.
We're just not big enough (and yeah, i know, that's what she said).

So yes... I think there's some responsibility in the community to
evangelize and help spread the word.  But I do think we are perfectly
justified in laying a good amount of the responsibility at Adobe's
door.  It's their product.  They charge for it (the product, the
support).  I think they share a huge chunk of the responsibility in
helping to spread the word, and I'd personally love to see them make
more of an effort in that area.  If Microsoft could show up as a
sponsor at a CF conference, why doesn't Adobe show up at MS events?
Or other non Adobe-specific events?  Where's the advertising in the
media targeting other developers?  I see lots of it for Flex and AIR
and "hey let's all go be Android developers and f*ck Apple".  Don't
see nearly that much time/energy/effort in saying, "hey let's all go
be CF developers and f*ck Ruby or .NET or whomever else".

Just my $0.02 :)

-- 
Charlie Griefer
http://charlie.griefer.com/

I have failed as much as I have succeeded. But I love my life. I love
my wife. And I wish you my kind of success.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340805
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Is Coldfusion losing its biggest asset?

2011-01-12 Thread Charlie Griefer

On Wed, Jan 12, 2011 at 8:42 AM, Irvin Gomez  wrote:
>
> Thanks, everyone for all the different perspectives. I know that if I were 
> looking at coldfusion for the first time these days, with all the OOP and 
> framework talk dominating the 'airwaves', I'd probably go with PHP or 
> something else...

I think if you were looking at CF for the first time these days, you'd
be looking at the features that were consistent with your skill set.
If you were a beginner, you'd probably be pretty happy that CF can get
you up and writing web applications pretty darn quickly.  If you were
more advanced, you'd probably be looking for stuff like, "are there
frameworks?" (yes!), "does it do ORM?" (yes!), "can I write components
in script?" (yes!)...

CF is a very unique animal.  As a beginner, you can get up and running
very quickly.  As a more experienced developer, you can take advantage
of a number of powerful features.  I don't think that beginners should
be concerned with the frameworks, ORM, etc.  Those features are there
when and if that person needs them.

For all of the advances that CF has made in recent years, this still
works, and is "valid" CFML:

#b#

If you were a beginner, I would think that would look more appealing
over most other languages :)

-- 
Charlie Griefer
http://charlie.griefer.com/

I have failed as much as I have succeeded. But I love my life. I love
my wife. And I wish you my kind of success.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340674
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Auto Complete

2011-01-05 Thread Charlie Griefer

Ooh nice.  I (obviously) hadn't used the built-in functionality.  Did
a quick google before answering, but all I saw in the results (at a
quick glance) were using the jQuery autocomplete in conjunction with
CF, so I assumed it wasn't there (built-in).

My bad :)

On Wed, Jan 5, 2011 at 2:12 PM, Adrocknaphobia  wrote:
>
> It's actually built-in to ColdFusion 8's  tag.
>
> 
>
> http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_i_07.html
>
> -Adam
>
> On Wed, Jan 5, 2011 at 2:42 PM, Charlie Griefer
> wrote:
>
>>
>> On Wed, Jan 5, 2011 at 12:32 PM, George Campbell 
>> wrote:
>> >
>> > Hello All,
>> >
>> >     I am running CF8 and I would like to implement a text box that would
>> auto-complete with a drop down. I would like it to work as if I was using
>> Outlook to look up a person in the Data-base.
>>
>> http://jqueryui.com/demos/autocomplete/
>>
>> Works a treat.  I just implemented it for a customer running CF 7.
>>
>> --
>> Charlie Griefer
>> http://charlie.griefer.com/
>>
>> I have failed as much as I have succeeded. But I love my life. I love
>> my wife. And I wish you my kind of succes
>>
>>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340483
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Auto Complete

2011-01-05 Thread Charlie Griefer

On Wed, Jan 5, 2011 at 12:32 PM, George Campbell  wrote:
>
> Hello All,
>
>     I am running CF8 and I would like to implement a text box that would 
> auto-complete with a drop down. I would like it to work as if I was using 
> Outlook to look up a person in the Data-base.

http://jqueryui.com/demos/autocomplete/

Works a treat.  I just implemented it for a customer running CF 7.

-- 
Charlie Griefer
http://charlie.griefer.com/

I have failed as much as I have succeeded. But I love my life. I love
my wife. And I wish you my kind of succes

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340479
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Diplaying struct info when you dump an array with strcts in it's elements...

2010-12-24 Thread Charlie Griefer

The value for label can be any value you want... literal string or variable.

On Fri, Dec 24, 2010 at 7:33 PM, Eric Roberts
 wrote:
>
> Any way to ge that dynamically label structures instead of just putting
> array or struct?
>
> -Original Message-
> From: Charlie Griefer [mailto:charlie.grie...@gmail.com]
> Sent: Friday, December 24, 2010 19:51
> To: cf-talk
> Subject: Re: Diplaying struct info when you dump an array with strcts in
> it's elements...
>
>
> You can add the "label" attribute?
>
> 
>
> 
>
> On Fri, Dec 24, 2010 at 6:21 PM, Eric Roberts
>  wrote:
>>
>> Is there a way to get cfdump to display the struct name when it dumps?
>> I have an array that contains a struct and I am having some issues
>> adding some vars for display so I want to make sure I am addressing it
> correctly.
>> Currently, all cfdump shows is the word "struct".  It looks like
>> everything is addressed properly, but I am getting errors saying that
>> the vars aren't defined.  I am learning a new application (new
>> position) so I am immersed in a rather steep learning curve at the
>> moment while trying to get stuff done that needs to be done next week
>> :-D  Nothing like hitting the ground running!
>>
>>
>>
>>
>>
>>
>>
>> Eric
>>
>>
>>
>>
>
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340273
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Diplaying struct info when you dump an array with strcts in it's elements...

2010-12-24 Thread Charlie Griefer

You can add the "label" attribute?





On Fri, Dec 24, 2010 at 6:21 PM, Eric Roberts
 wrote:
>
> Is there a way to get cfdump to display the struct name when it dumps?  I
> have an array that contains a struct and I am having some issues adding some
> vars for display so I want to make sure I am addressing it correctly.
> Currently, all cfdump shows is the word "struct".  It looks like everything
> is addressed properly, but I am getting errors saying that the vars aren't
> defined.  I am learning a new application (new position) so I am immersed in
> a rather steep learning curve at the moment while trying to get stuff done
> that needs to be done next week :-D  Nothing like hitting the ground
> running!
>
>
>
>
>
>
>
> Eric
>
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340271
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Variable Scoping in CF8, CF9

2010-12-23 Thread Charlie Griefer

On Thu, Dec 23, 2010 at 10:16 AM, Matthew Reinbold
 wrote:
>
> I know that correctly scoping variables in ColdFusion is important to prevent 
> unexpected results if a variable is "accidentally" reused elsewhere in a CFC. 
> But, if I remember correctly, in CFMX there were some pretty nasty memory 
> leaks that could occur if variables weren't scoped correctly.
>
> Does that apply to newer (8,9) versions of ColdFusion?

Yup.  All function-local variables in a CFC should be var scoped.  CF
9 did introduce the "local" scope inside of CFC methods, so doing
this:


 


is functionally equivalent to doing:


 


So while there are now 2 ways to declare a variable as local to a
given function (assuming you're on CF 9), the requirement still
remains that you do need to scope these variables properly in order to
avoid leakage.

-- 
Charlie Griefer
http://charlie.griefer.com/

I have failed as much as I have succeeded. But I love my life. I love
my wife. And I wish you my kind of success.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340256
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: (ot) jQuery question

2010-12-12 Thread Charlie Griefer

You don't need the i or o arguments for the code I posted.  They were
remnants from copying your original code.

>From the docs (http://api.jquery.com/each/):

.each( function(index, Element) )

so the first argument is the index.  .each() is looping over an array
(the array of selected DOM elements), so for each iteration, 'i' (or
whatever argument you declare) would be the position in the array of
the current element.

The second argument is the element itself, which can optionally be
passed in.  Not sure why I couldn't get it to work using "o" rather
than creating a new instance of $( this ) for each iteration... I'd
imagine passing the element in would be more performant, but probably
not enough of a difference to be noticeable.

On Sun, Dec 12, 2010 at 10:32 AM, Rick Faircloth
 wrote:
>
> Thanks, Charlie!  That gives me the correct output.
> Now I can move on to the AJAX, JSON, and CF CFC processing
> of data.
>
> Would you be so kind as to actually explain what function
> the "i" and "o" play in "function(i,o)" ?  They're variables/values
> passed into the function, right?
>
> I tested their necessity by taking them out of your
> code and just using function() instead of function(i,o)
> and the code still ran the same.  And even some of the
> example code I found performing this kind of functionality for lists
> used both i and o in the (), but only referenced the "o"
> in the actual function.
>
> I've always been confused about the role these variables
> playing in function(i,o) and whatever was in the ().
> Does the first argument (in this case, "i") always mean something
> specific because it's in the first argument position?  And the
> same with the variable that's in the second position?
>
> I scoured the Internet trying to get a good explanation of using
> these arguments, but haven't found what I needed to understand.
>
> Thanks for any insight you'd share!
>
> Rick
>
>
> -Original Message-
> From: Charlie Griefer [mailto:charlie.grie...@gmail.com]
> Sent: Saturday, December 11, 2010 10:51 PM
> To: cf-talk
> Subject: Re: (ot) jQuery question
>
>
> You're missing a # in your selector for #myTable.
> Even with the #, couldn't get your code to run... but the following
> seems to work:
>
> $( document ).ready( function() {
>        var staffOrder = "";
>
>        $( '#myTable tr' ).each( function( i,o ) {
>                if ( staffOrder.length ) {
>                        staffOrder += "," + $( this ).attr( 'class' );
>                } else {
>                        staffOrder = $( this ).attr( 'class' );
>                }
>        });
>
>        alert('staffOrder = ' + staffOrder);
> });
>
> On Sat, Dec 11, 2010 at 8:36 PM, Rick Faircloth
>  wrote:
>>
>> Hope some of you jQuery and CF users can answer what
>> seems to me should be an easy question, but I can't
>> figure out how to write this jQuery to product a list
>> of values.  (I'll use AJAX and JSON to send the value list
>> to a cffunction for processing).
>>
>> Given this HTML:
>>
>>        
>>
>>                
>>                        1
>>                
>>
>>                
>>                        2
>>                
>>
>>                
>>                        3
>>                
>>
>>                
>>                        4
>>                
>>
>>                
>>                        5
>>                
>>
>>        
>>
>> How can I modify this jQuery to produce
>> a list of the classes of the tr's above?
>>
>> (Output I'm looking for is "1,2,3,4,5" .)
>>
>> I get "staffOrder = " in the alert.  It's as if
>> the "each" function below isn't working at all.
>>
>> Suggestions?
>>
>> Thanks!
>>
>> Rick
>>
>>
>>        $(document).ready(function() {
>>
>>                var staffOrder = '';
>>
>>                $('myTable tr').each(function(i,o) {
>>
>>                        if      (       staffOrder.length
>> )
>>                                {       staffOrder += ',' + o.class;
>> }
>>                        else    {       staffOrder = o.class
>> }
>>
>>                });
>>
>>                alert('staffOrder = ' + staffOrder);
>>
>>        });
>>
>>
>>
>>
>>
>>
>
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340020
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: (ot) jQuery question

2010-12-11 Thread Charlie Griefer

You're missing a # in your selector for #myTable.
Even with the #, couldn't get your code to run... but the following
seems to work:

$( document ).ready( function() {
var staffOrder = "";

$( '#myTable tr' ).each( function( i,o ) {
if ( staffOrder.length ) {
staffOrder += "," + $( this ).attr( 'class' );
} else {
staffOrder = $( this ).attr( 'class' );
}
});

alert('staffOrder = ' + staffOrder);
});

On Sat, Dec 11, 2010 at 8:36 PM, Rick Faircloth
 wrote:
>
> Hope some of you jQuery and CF users can answer what
> seems to me should be an easy question, but I can't
> figure out how to write this jQuery to product a list
> of values.  (I'll use AJAX and JSON to send the value list
> to a cffunction for processing).
>
> Given this HTML:
>
>        
>
>                
>                        1
>                
>
>                
>                        2
>                
>
>                
>                        3
>                
>
>                
>                        4
>                
>
>                
>                        5
>                
>
>        
>
> How can I modify this jQuery to produce
> a list of the classes of the tr's above?
>
> (Output I'm looking for is "1,2,3,4,5" .)
>
> I get "staffOrder = " in the alert.  It's as if
> the "each" function below isn't working at all.
>
> Suggestions?
>
> Thanks!
>
> Rick
>
>
>        $(document).ready(function() {
>
>                var staffOrder = '';
>
>                $('myTable tr').each(function(i,o) {
>
>                        if      (       staffOrder.length
> )
>                                {       staffOrder += ',' + o.class;
> }
>                        else    {       staffOrder = o.class
> }
>
>                });
>
>                alert('staffOrder = ' + staffOrder);
>
>        });
>
>
>
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340013
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Diagnosing DB / CF problem

2010-11-29 Thread Charlie Stell

I ran into a problem in the past where queries were getting hung - queries
that usually executed all the time without issue (and queries that I could
copy and paste into analyzer and run just fine). It turned out to be SQL
running out of memory and not being able to compile an execution plan. The
root cause was us not using cfqueryparam in our queries - making SQL not use
its cache effectively. No idea if your problem is similar - but theres my
two cents!


On Sun, Nov 28, 2010 at 9:12 PM, Russ Michaels  wrote:

>
> well I can tell you one of the causes for hung requests, it is visitors
> closing your page before the request is complete which leaves it in a hung
> state as there is no where to send the response back to. Not sure if this
> could cause a hung db request though, I wouldn't have thought so as that is
> between cf and the db not the client, but I spose it is possible that CF
> may
> also hang the db request if it know sthe client request has been terminated
> prematurely.
>
> Russ
>
> On Mon, Nov 29, 2010 at 1:42 AM, Dan Crouch  wrote:
>
> >
> > I see similar things like that happen sometimes and SeeFusion won't kill
> > them either. In those cases, many times what I can do is run an sp_who on
> > the database and look for the offending query, use a dbcc
> > inputbuffer(processid) if need be and then kill that process id. Most of
> the
> > time, that will allow me to kill the hung thread in SeeFusion so that no
> > restart is needed. I haven't tried FusionReactor so I am not sure it
> works
> > the same way, but the problem is very similar to what I have seen, just
> > viewed it through SeeFusion instead. I dont know why it happens,
> something
> > just seems to temporarily have gotten stuck on stupid.
> >
> > Dan
> >
> >
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339565
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: REGEX hell

2010-11-25 Thread Charlie Griefer

... since we're throwing out recommendations for our favorite "so glad this
exists because of how badly I suck at reg ex" apps, I've found
http://gskinner.com/RegExr/desktop/ to be a -very- valuable tool.

On Thu, Nov 25, 2010 at 8:56 AM, Dave Merrill  wrote:

>
> Be a little careful, Regex Coach works with perl regex syntax; cf
> needs java syntax usually, with some differences.
>
> I can't recommend Regex Buddy highly enough. It's not free, but it's
> really quite excellent, supports a variety of different flavors.
>
> Dave
>
>
> On Thu, Nov 25, 2010 at 10:17 AM, Jerry Barnes 
> wrote:
> >
> > Regex that is useful but unfortunately, my skills are pretty weak in that
> > area.
> >
> > I use an application named "The Regex Coach' to build my code.  It has a
> > place to put the string you are trying to match and another place to put
> > your regex code.  As you modify the regex code, it highlights how much of
> > the string matches.
> >
> > The program is free with the option of donating via paypal to the creator
> if
> > you like it.
> >
> >
> >
> > J
> >
> > -
> >
> > No man's life, liberty, or property is safe while the legislature is in
> > session. - Mark Twain
> >
> >
> >
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339533
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Free ColdFusion Hosting

2010-11-24 Thread Charlie Griefer

If this is just a project that you're working on for the sake of honing your
skills, and it doesn't have to be publicly accessible, there's no reason you
couldn't continue to work on it locally using the developer edition of CF.

Free CF hosting is going to be hard to come by.  Outside of the resource you
mentioned, I can't think of any.  There was one that Pablo Varando was
running, but I'm not sure if it's still around.  Even if it is, it was
marketed as being for "development only", in which case... well, yeah... the
developer edition of CF running locally works a treat.


On Wed, Nov 24, 2010 at 11:03 AM, Matthew Lowrey  wrote:

>
> Hello Fellow HoFer's:
>
> Because of the economy and me being out of work until this year for almost
> 2 years I had to let my personal website hosted by GoDaddy go the way of the
> buffalo.  I was basically using it to work on a home project of building a
> family tree program.  I was doing it for fun and for using new skills I have
> learned at work and school.  Plus, it would give me a chance to take all my
> family's (and wife's family's) information on the web to share with family
> members and our kids when they get old enough to be interested in.
>
> I was hopping to find a place where I could host my ColdFusion code while
> building this project (basically from scratch) for free.  I know this is
> almost impossible but it couldn't hurt to ask and google.
>
> I found one place: http://www.cfmldeveloper.com/ but it's out of country
> (USA) which, I don't have a problem with, but at the same time I'm hesitant
> to just go anywhere with the way the world is today.  Do any of you have any
> recommendations?  Even if they aren't for free, I'm curious your thoughts on
> this subject.
>
> GoDaddy.com has been a great service and very reasonable, I just can't
> afford to go back right now.
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339512
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: cfscript based components formatting

2010-11-15 Thread Charlie Griefer

/* This is me agreeing */

I agree!

On Mon, Nov 15, 2010 at 3:35 PM, Matt Quackenbush wrote:

>
> No comments driving behavior!  :-)
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339247
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: jquery

2010-11-05 Thread Charlie Griefer

Maybe because you recently changed your style sheet?  Can you view source
and verify that the style you expect to be applied (which I assume is an
external .css file) is being included with the correct path?

On Fri, Nov 5, 2010 at 9:23 PM, Monique Boea  wrote:

>
> why would my jquery validation code styles not show up?
>
> I recently changed my style sheet on an app...before I made changes the
> jquery styling showed up (yellow background...red text).
>
> Now I get the "This field is required" message but with no style.
>
> Any suggestions?
>
> TIA
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338898
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: What is wrong with this loop update?

2010-11-02 Thread Charlie Griefer

You say you're trying to update multiple rows... but your WHERE is stating,
"WHERE project_id = #URL.projectID#".

Since URL.projectID most likely isn't changing during the iteration of that
loop, you'll only ever be updating one row 'x' number of times.


On Tue, Nov 2, 2010 at 4:28 PM, Rick Colman  wrote:

>
> I am trying to update multiple rows by looping through:
>
> 
>
> (diagnostics) row: #GetExpOrg.currentrow# id:
> #GetExpOrg.ExpOrg_ID#
>
> 
> update Project_ExpOrg
> set OrgValue=(select org_value from expressionorganism3
> where exporg_id = #GetExpOrg.ExpOrg_ID#)
> where project_id = #url.ProjectId#
> 
>
> 
>
> my diagnostics give me:
>
> row: 1 id: 2
> row: 2 id: 693
> so that is ok.
>
> but both rows are updated with the last value (693) instead of being
> individually updated?
>
> What's wrong with this?
>
> TNX if you can help.
>
> Rick.
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338777
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: ColdFusion Companies in Baltimore/DC/VA

2010-11-01 Thread Charlie Griefer

While I agree with John's suggestion of reaching out to local CFUGs, I can
think of 3 companies off the top of my head (but I'm sure there are others).

In no particular order...

Fig Leaf (http://www.figleaf.com/)
AboutWeb (http://www.aboutweb.com/)
Teratech (http://www.teratech.com/)

On Mon, Nov 1, 2010 at 12:23 PM, John M Bliss  wrote:

>
> Perhaps you could also direct this question toward your local CFUG's and
> their members:
>
> http://groups.adobe.com/group/1021
> http://groups.adobe.com/group/349
> http://groups.adobe.com/group/782
> http://groups.adobe.com/group/303
>
> On Mon, Nov 1, 2010 at 2:09 PM, John Bono  wrote:
>
> >
> > Hello,
> >
> > We are getting ready for a major undertaking to involve a complete
> overhaul
> > of our very large Web site/CMS system to include a new design,
> information
> > architecture, marketing strategy, CMS platform, etc. We plan on issuing 2
> > RFPs: one for the design/marketing strategy and one for the technical
> > implementation.
> >
> > However, finding companies in the Baltimore/Washington, DC/Virginia area
> > with a preference for ColdFusion has proven to be very difficult.
> >
> > We have a preference for a company that uses ColdFusion as one of its
> > technologies. Does anyone know of any companies in this area that would
> be
> > able to perform such work?
> >
> > Thanks in advance!
> >
> >
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338727
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Javascript Cfquery

2010-10-12 Thread Charlie Griefer

On Tue, Oct 12, 2010 at 1:20 PM, fun and learning
wrote:

>
> Hi All -
>
> I am trying to do the following:
>
> 
>  function abc(arg1, arg2) {
> 
>select * from table1 where col1 = arg1
> 
> ..
>  }
>
> 
>
> Is it possible to pass javascript arguments to a coldfusion query which is
> in turn present in the javascript block?
>

ColdFusion runs on the server.  JavaScript runs on the client.  By the time
the browser has rendered the page, ColdFusion has done its duty and is
probably hanging out smoking a cigarette or using the little application
server room.

You can output CF variables to JS just like you do to HTML...


 var myName = "#myName#";


... but it's not a two-way conversation (much like my conversations with my
wife).  If you want them to talk to each other, you need to introduce AJAX
into the equation.

So short answer is, no... a JavaScript variable can't be used to manipulate
a ColdFusion variable (but the converse works a treat), without utilizing
AJAX.

And maybe worth noting that the "language" attribute of the 

Re: Simple question

2010-10-07 Thread Charlie Griefer

If it does, you can try 

On Thu, Oct 7, 2010 at 12:29 PM, Dan Baughman wrote:

>
> So if you set the output to blank it doesn't over write the contents of the
> file?
>
> On Thu, Oct 7, 2010 at 1:13 PM, John M Bliss  wrote:
>
> >
> > cffile action="write" file="c:\temp\temp.txt" output=""
> >
> > On Thu, Oct 7, 2010 at 2:05 PM, Dan Baughman 
> > wrote:
> >
> > >
> > > Hi All,
> > >
> > >
> > > What is the easiest way in coldfusion to "touch" a file. IE. updates
> it's
> > > modified time to be now.
> > >
> > > I can think of a few hacks, but was looking for something super easy
> and
> > > graceful.
> > >
> > > Dan
> > >
> > >
> > >
> >
> >
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337946
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Reading text files

2010-10-01 Thread Charlie Griefer

On Fri, Oct 1, 2010 at 10:14 AM, Larry Lyons  wrote:

>
> >nope! :)
> >
> >>
> >> Oh CF, is there anything you can't do?
> >>
>
>
> what about make coffee, and bring my slippers and the morning paper. If it
> could do that CF would truly rock.



Have you checked Riaforge?

-- 
Charlie Griefer
http://charlie.griefer.com/

I have failed as much as I have succeeded. But I love my life. I love my
wife. And I wish you my kind of success.


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337747
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: List Sort help

2010-09-22 Thread Charlie Griefer

On Wed, Sep 22, 2010 at 3:16 PM, Leigh  wrote:

>
> > What would be the difference between *really* working and
> > just seeming to?
>
> For me ... more testing and more coffee ;-) Specifically with a greater
> range of values, such as version numbers before and after the "3.x.x" range.


OK you twisted my arm into indulging in another cup of coffee (mmm
coffee).  You're correct.  It only "seemed to" work with the originally
given values.

Changing the list to: 

Resulted in a "sorted" list of: 3.6.1, 3.6.3, 10.2.4, 1.2.5, 3.6.5, 3.6.10



> >> I was more
> >> surprised that it seemed to have worked than I would have
>
> Exactly, and that is why I am suspicious.  I was not expecting "text" to
> work at all, for obvious reasons. Neither was I expecting "numeric" to work
> because values like 3.6.1 are not numeric. At least not in the strict sense.
> Hence my reluctance to say it "it works"


CF -is- treating these like some sort of numeric value tho... because if I
added a value like 10.2.5.4 to the original list, a numeric listSort fails
saying a non-numeric value was found.  So CF sees x.x.x as a valid numeric
value, but apparently not base 10 based on the sorted result above.

-- 
Charlie Griefer
http://charlie.griefer.com/

I have failed as much as I have succeeded. But I love my life. I love my
wife. And I wish you my kind of success.


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337343
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: List Sort help

2010-09-22 Thread Charlie Griefer

On Wed, Sep 22, 2010 at 2:25 PM, Leigh  wrote:

>
> > On CF9, the following works:
>
> Does it *really* work .. or just seem to? I cannot test it at the moment,
> but I would not have expected either sort to yield the desired results.


What would be the difference between *really* working and just seeming to?

I output the listSorted()'d values, they looked to be sorted.  So it seems
to.  As to whether or not it *really* works, I will admit that I hadn't had
a full cup of coffee when testing.  But I agree with you... I was more
surprised that it seemed to have worked than I would have been had it not.

FWIW, sorting by text did not work.  Well, it worked as one might have
expected it to (putting 3.6.10 and 3.6.1 next to each other), but not in the
way that the OP was looking for it to work.

-- 
Charlie Griefer
http://charlie.griefer.com/

I have failed as much as I have succeeded. But I love my life. I love my
wife. And I wish you my kind of success.


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337341
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: List Sort help

2010-09-22 Thread Charlie Griefer

What version of CF?

On CF9, the following works:



#appVers##listSort( appVers, 'numeric', 'desc' )#


On Wed, Sep 22, 2010 at 9:26 AM, Tom Jones  wrote:

>
> thanks,
> but I get an error saying cant convert "3.6.1" to numeric.
>
> tom
>
> >ListSort should work:
> >
> >http://www.cfquickdocs.com/cf8/#ListSort
> >
> >Although you might need to use the text sort instead of numeric.
> >
> >
> >
> >andy
> >
> >Hello,
> >I have a lit of version numbers and I need to sort them in the right
> order.
> >
> >
> >
> >How do I sort these so that they show in the right order starting with the
> >highest first?
> >
> >Thanks,
> >tom
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337325
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Looping through arrays with structures

2010-09-17 Thread Charlie Griefer

He didn't use the array attribute.  He used the exact same index loop that
you did (from="1" to="#arrayLen(myArray)#").

On Fri, Sep 17, 2010 at 6:56 PM, Andrew Scott wrote:

>
> You can't be serious asking that sort of question, the array Attribute was
> introduced in ColdFusion 8. So that means people who are still running
> ColdFusion 5 - 7 will not be able to use that code.
>
> Regards,
> Andrew Scott
> http://www.andyscott.id.au/
>
>
> > -Original Message-
> > From: Michael Grant [mailto:mgr...@modus.bz]
> > Sent: Saturday, 18 September 2010 11:09 AM
> > To: cf-talk
> > Subject: Re: Looping through arrays with structures
> >
> >
> > What version of cf won't my code work in?
> >
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337205
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: OOP Principles question

2010-08-04 Thread Charlie Griefer

On Wed, Aug 4, 2010 at 3:22 AM, Scott Stewart wrote:

>
> I understand the "black box" principle of CFC's, make sure that your cfc's
> can stand on their own as black boxes. When doing OOP based development,
> does this paradigm
>
> extend to  non-cfc ColdFusion files, IE: display and action pages.
>

I think the concept of modularity and code reuse extends beyond OO.  In
views, when you find yourself reusing code, you throw it into an include.
 If it needs attributes passed in, you throw it into a custom tag.

There's nothing that I think is particularly OO about it... it's just about
working smarter and not harder :)

-- 
Charlie Griefer
http://charlie.griefer.com/

I have failed as much as I have succeeded. But I love my life. I love my
wife. And I wish you my kind of success.


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335978
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Output newest one item from each category

2010-08-02 Thread Charlie Stell

If your using MS SQL 2005 or newer, you could use the row_number() feature-

one query using a funciton:
with f(catg, nltitle, nldate, nth) as (
Select catg, nltitle, nldate, row_number() over (partition by catg order by
catg, nldate desc) as nth
from newsletters)
select * from f where nth = 1

or create a view:
Select catg, nltitle, nldate, row_number() over (partition by catg order by
catg, nldate desc) as nth
from newsletters

select * from view where nth = 1


On Mon, Aug 2, 2010 at 2:12 PM, UXB Internet wrote:

>
> I was actually thinking about this and like yourself have not found a way
> to
> do it in one query.  I have a crude solution.  This assumes you only have
> the one table.  In either case you need to get a unique list of the
> categories then loop over it to create a dynamic query.
>
> 
> Select Distinct catg as 'thecategory'
> From  newsletters
> Order by catg
> 
>
>
> 
> 
> Select top 1 nldate, catg, nltitle
> From newsletter
> Where catg = '#thecategory#'
> Order by nldate desc
> UNION
> 
> Select top 1 nldate, catg nltitle
> From newsletter
> Where 0=1
>
> Order by {column number}
>
> 
>
> It may be crude but this approach at least puts all your date into one
> query
> object.
>
>
>
> Dennis Powers
> UXB Internet - A Website Design & Hosting Company
> P.O. Box 6028
> Wolcott, CT 06716
> 203-879-2844
> http://www.uxbinternet.com
>
>
>
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335928
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Need a west coast (US) based CF host

2010-07-29 Thread Charlie Griefer

Mike:

The current host has severs on east coast time as well as GMT.
 Unfortunately, the app is architected in such a way that it can't handle
timezone offsets, whether it's east coast or GMT... it expects that the time
entered is going to be the time displayed :\

On Thu, Jul 29, 2010 at 7:16 PM, Mike Kear  wrote:

>
> I would have thought most hosting companies would have their servers set to
> UTC ( or Greenwich Mean Time) . Is that not true?
>
> I have servers in California, but ours are on UTC so we can move them from
> place to place if we choose and it makes no difference to the code.
>
>
> Cheers
> Mike Kear
> Windsor, NSW, Australia
> Adobe Certified Advanced ColdFusion Developer
> AFP Webworks
> http://afpwebworks.com
> ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month
>
>
>
>
> On Fri, Jul 30, 2010 at 12:02 PM, Charlie Griefer <
> charlie.grie...@gmail.com
> > wrote:
>
> >
> > I -think- it's 2k8, but based on my discussion with the previous
> developer,
> > I'm not sure database tweaks are going to do it.
> >
> > I've pitched Andy's trigger idea to the client.  Still waiting to hear
> > back...
> >
> > On Thu, Jul 29, 2010 at 6:55 PM, Maureen  wrote:
> >
> > >
> > > Which version of SQL Server, because timezone data is handled
> > > differently between 2005 and 2008, and if it is 2008 you could likely
> > > fix this issue with some database tweeks.
> > >
> > > On Thu, Jul 29, 2010 at 12:29 PM, Charlie Griefer
> > >  wrote:
> > > >
> > > > Hey Scott:
> > > >
> > > > Hmm... not sure that the current site will run under Railo.  Also,
> > their
> > > > current database is SQL Server (I probably should have mentioned
> that).
> > > >  Looks like Alurium is exclusively Railo/mySQL (
> > >
> > >
> >
> >
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335881
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Need a west coast (US) based CF host

2010-07-29 Thread Charlie Griefer

I -think- it's 2k8, but based on my discussion with the previous developer,
I'm not sure database tweaks are going to do it.

I've pitched Andy's trigger idea to the client.  Still waiting to hear
back...

On Thu, Jul 29, 2010 at 6:55 PM, Maureen  wrote:

>
> Which version of SQL Server, because timezone data is handled
> differently between 2005 and 2008, and if it is 2008 you could likely
> fix this issue with some database tweeks.
>
> On Thu, Jul 29, 2010 at 12:29 PM, Charlie Griefer
>  wrote:
> >
> > Hey Scott:
> >
> > Hmm... not sure that the current site will run under Railo.  Also, their
> > current database is SQL Server (I probably should have mentioned that).
> >  Looks like Alurium is exclusively Railo/mySQL (
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335877
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Need a west coast (US) based CF host

2010-07-29 Thread Charlie Griefer

Hey Andy:

I ran that past the previous developer and he said he thinks that could
work.

I'll run it past the client and see if they want to invest the time in me
identifying which fields would need the trigger, or if they'd rather just
move the site and be done with it :)

Thanks for the suggestion.

On Thu, Jul 29, 2010 at 12:58 PM, Andy Matthews wrote:

>
> Can I throw out a suggestion?
>
> Consider a trigger on the database that updates a new record and changes
> it's timestamp when it's inserted or updated? Then you don't need to
> migrate.
>
>
> andy
>
> -Original Message-
> From: Charlie Griefer [mailto:charlie.grie...@gmail.com]
> Sent: Thursday, July 29, 2010 2:52 PM
> To: cf-talk
> Subject: Re: Need a west coast (US) based CF host
>
>
> Nothing against Railo.  My main project right now is a Railo site (altho
> we're keeping it CF9 compatible) with a mySQL database.  Works a treat.
>
> I just don't know this other site well enough to be able to say, "yeah,
> let's jump over to Railo and convert your MS SQL database to mySQL" :)
> There's also a flex-based admin area and I'm not sure how well that would
> work.
>
> At this point in time... probably not something that the client would want
> to undertake (all of the UAT that would be necessary to ensure that all
> facets of the site still function properly).  They're a small non-profit
> and
> I don't think they have the manpower to even do that, nor do I think they'd
> want to pay me to take that on.
>
> Appreciate the feedback tho.  I'd heard Alurium's name mentioned before.
>  Their prices do look appealing.  Just not a good fit for this particular
> client right now :\
>
> On Thu, Jul 29, 2010 at 12:40 PM, Scott Stewart
> wrote:
>
> >
> > Charlie, I think they are exclusively MySQL... I ported over an
> > implementation of blogCFM and it works fine, Railo's pretty complete
> > as far as tag support goes..
> >
> > On Thu, Jul 29, 2010 at 3:29 PM, Charlie Griefer
> >  wrote:
> > >
> > > Hey Scott:
> > >
> > > Hmm... not sure that the current site will run under Railo.  Also,
> > > their current database is SQL Server (I probably should have mentioned
> that).
> > >  Looks like Alurium is exclusively Railo/mySQL (?)
> > >
> > > Thanks,
> > > Charlie
> > >
> > > On Thu, Jul 29, 2010 at 12:12 PM, Scott Stewart
> > > wrote:
> > >
> > >>
> > >> Charlie,
> > >>
> > >> I think Alurium is located on the West Coast, plus they're cheap
> > >> and you can run CFML (Railo) http://www.alurium.com
> > >>
> > >> On Thu, Jul 29, 2010 at 3:09 PM, Charlie Griefer
> > >>  wrote:
> > >> >
> > >> > Hey all...
> > >> >
> > >> > I know this topic ("can somebody recommend a CF host") comes up
> > >> > frequently... I hate to bring it up again, but I must :)
> > >> >
> > >> > I have a client that needs to be on shared hosting (they don't
> > >> > have
> > the
> > >> > funds for VPS, unfortunately) on a server with the clock set to PST.
> > >> >  They're a company that's physically based in CA... recently
> > >> > moved
> > hosts
> > >> to
> > >> > an east-coast based company, and now timestamps are off by 3
> > >> > hours
> > when
> > >> they
> > >> > add events.
> > >> >
> > >> > According to the previous developer, they're using a calendaring
> > system
> > >> > (specifically, a particular version of a calendaring system) that
> > isn't
> > >> set
> > >> > up to handle time zone differences.  He's told me that trying to
> > update
> > >> the
> > >> > code to handle this would "open a whole new can of worms".
> > >> >
> > >> > I've explored the options, and the path of least resistance seems
> > >> > to
> > be
> > >> to
> > >> > relocate the site to a server based on the west coast.  Or at the
> > >> > very least, a server whose clock is set to PST.
> > >> >
> > >> > A quick google turned up Illuminated Hosting (
> > >> > http://www.illuminatedhosting.com/), but I'm not familiar with
> them.
> > >>  Does
> > >> > anybody know of this company?  Or of any others that have servers
> > >> > set
> > to
> > >> > pacific time?
> > >> >
> > >> > Thanks!
> > >> > Charlie
> > >> >
> > >> > --
> > >> > Charlie Griefer
> > >> > http://charlie.griefer.com/
> > >> >
> > >> > I have failed as much as I have succeeded. But I love my life. I
> > >> > love
> > my
> > >> > wife. And I wish you my kind of success.
> > >> >
> > >> >
> > >> >
> > >>
> > >>
> > >
> > >
> >
> >
>
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335871
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Need a west coast (US) based CF host

2010-07-29 Thread Charlie Griefer

Nothing against Railo.  My main project right now is a Railo site (altho
we're keeping it CF9 compatible) with a mySQL database.  Works a treat.

I just don't know this other site well enough to be able to say, "yeah,
let's jump over to Railo and convert your MS SQL database to mySQL" :)
 There's also a flex-based admin area and I'm not sure how well that would
work.

At this point in time... probably not something that the client would want
to undertake (all of the UAT that would be necessary to ensure that all
facets of the site still function properly).  They're a small non-profit and
I don't think they have the manpower to even do that, nor do I think they'd
want to pay me to take that on.

Appreciate the feedback tho.  I'd heard Alurium's name mentioned before.
 Their prices do look appealing.  Just not a good fit for this particular
client right now :\

On Thu, Jul 29, 2010 at 12:40 PM, Scott Stewart
wrote:

>
> Charlie, I think they are exclusively MySQL... I ported over an
> implementation of blogCFM and it works fine, Railo's pretty complete
> as far as tag support goes..
>
> On Thu, Jul 29, 2010 at 3:29 PM, Charlie Griefer
>  wrote:
> >
> > Hey Scott:
> >
> > Hmm... not sure that the current site will run under Railo.  Also, their
> > current database is SQL Server (I probably should have mentioned that).
> >  Looks like Alurium is exclusively Railo/mySQL (?)
> >
> > Thanks,
> > Charlie
> >
> > On Thu, Jul 29, 2010 at 12:12 PM, Scott Stewart
> > wrote:
> >
> >>
> >> Charlie,
> >>
> >> I think Alurium is located on the West Coast, plus they're cheap and
> >> you can run CFML (Railo)
> >> http://www.alurium.com
> >>
> >> On Thu, Jul 29, 2010 at 3:09 PM, Charlie Griefer
> >>  wrote:
> >> >
> >> > Hey all...
> >> >
> >> > I know this topic ("can somebody recommend a CF host") comes up
> >> > frequently... I hate to bring it up again, but I must :)
> >> >
> >> > I have a client that needs to be on shared hosting (they don't have
> the
> >> > funds for VPS, unfortunately) on a server with the clock set to PST.
> >> >  They're a company that's physically based in CA... recently moved
> hosts
> >> to
> >> > an east-coast based company, and now timestamps are off by 3 hours
> when
> >> they
> >> > add events.
> >> >
> >> > According to the previous developer, they're using a calendaring
> system
> >> > (specifically, a particular version of a calendaring system) that
> isn't
> >> set
> >> > up to handle time zone differences.  He's told me that trying to
> update
> >> the
> >> > code to handle this would "open a whole new can of worms".
> >> >
> >> > I've explored the options, and the path of least resistance seems to
> be
> >> to
> >> > relocate the site to a server based on the west coast.  Or at the very
> >> > least, a server whose clock is set to PST.
> >> >
> >> > A quick google turned up Illuminated Hosting (
> >> > http://www.illuminatedhosting.com/), but I'm not familiar with them.
> >>  Does
> >> > anybody know of this company?  Or of any others that have servers set
> to
> >> > pacific time?
> >> >
> >> > Thanks!
> >> > Charlie
> >> >
> >> > --
> >> > Charlie Griefer
> >> > http://charlie.griefer.com/
> >> >
> >> > I have failed as much as I have succeeded. But I love my life. I love
> my
> >> > wife. And I wish you my kind of success.
> >> >
> >> >
> >> >
> >>
> >>
> >
> >
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335868
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Need a west coast (US) based CF host

2010-07-29 Thread Charlie Griefer

You'd think, right? :)

I haven't even looked at the code yet.  Just came onto this project last
nite.  But the previous developer is a friend and I trust what he says.  He
wrote the current site, and he told me in no uncertain terms that the time
zone issue would not be even remotely easy to remedy via code.

I don't know why, exactly, but I trust what I've been told.

At some point I'm sure I'll dig into the code and find out.  But for now, it
looks like moving hosts will be the path of least resistance.

On Thu, Jul 29, 2010 at 12:26 PM, Eric Cobb  wrote:

>
> Now() + 3 shouldn't be that hard to implement.  ;)   (assuming all of
> the date/time stamps are being entered via CFML instead of the DB itself)
>
> Just a note, Railo allows you specify the time zone for each site, so if
> you want to use a Railo host, it doesn't matter where they're physically
> located.  Your site can have it's own time zone independent of the
> server time zone. (again, assuming all of the date/time stamps are being
> entered via CFML instead of the DB itself)
>
> Thanks,
>
> Eric Cobb
> ECAR Technologies, LLC
> http://www.ecartech.com
> http://www.cfgears.com
>
>
>
> Charlie Griefer wrote:
> > Hey all...
> >
> > I know this topic ("can somebody recommend a CF host") comes up
> > frequently... I hate to bring it up again, but I must :)
> >
> > I have a client that needs to be on shared hosting (they don't have the
> > funds for VPS, unfortunately) on a server with the clock set to PST.
> >  They're a company that's physically based in CA... recently moved hosts
> to
> > an east-coast based company, and now timestamps are off by 3 hours when
> they
> > add events.
> >
> > According to the previous developer, they're using a calendaring system
> > (specifically, a particular version of a calendaring system) that isn't
> set
> > up to handle time zone differences.  He's told me that trying to update
> the
> > code to handle this would "open a whole new can of worms".
> >
> > I've explored the options, and the path of least resistance seems to be
> to
> > relocate the site to a server based on the west coast.  Or at the very
> > least, a server whose clock is set to PST.
> >
> > A quick google turned up Illuminated Hosting (
> > http://www.illuminatedhosting.com/), but I'm not familiar with them.
>  Does
> > anybody know of this company?  Or of any others that have servers set to
> > pacific time?
> >
> > Thanks!
> > Charlie
> >
> >
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335866
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Need a west coast (US) based CF host

2010-07-29 Thread Charlie Griefer

Hey Scott:

Hmm... not sure that the current site will run under Railo.  Also, their
current database is SQL Server (I probably should have mentioned that).
 Looks like Alurium is exclusively Railo/mySQL (?)

Thanks,
Charlie

On Thu, Jul 29, 2010 at 12:12 PM, Scott Stewart
wrote:

>
> Charlie,
>
> I think Alurium is located on the West Coast, plus they're cheap and
> you can run CFML (Railo)
> http://www.alurium.com
>
> On Thu, Jul 29, 2010 at 3:09 PM, Charlie Griefer
>  wrote:
> >
> > Hey all...
> >
> > I know this topic ("can somebody recommend a CF host") comes up
> > frequently... I hate to bring it up again, but I must :)
> >
> > I have a client that needs to be on shared hosting (they don't have the
> > funds for VPS, unfortunately) on a server with the clock set to PST.
> >  They're a company that's physically based in CA... recently moved hosts
> to
> > an east-coast based company, and now timestamps are off by 3 hours when
> they
> > add events.
> >
> > According to the previous developer, they're using a calendaring system
> > (specifically, a particular version of a calendaring system) that isn't
> set
> > up to handle time zone differences.  He's told me that trying to update
> the
> > code to handle this would "open a whole new can of worms".
> >
> > I've explored the options, and the path of least resistance seems to be
> to
> > relocate the site to a server based on the west coast.  Or at the very
> > least, a server whose clock is set to PST.
> >
> > A quick google turned up Illuminated Hosting (
> > http://www.illuminatedhosting.com/), but I'm not familiar with them.
>  Does
> > anybody know of this company?  Or of any others that have servers set to
> > pacific time?
> >
> > Thanks!
> > Charlie
> >
> > --
> > Charlie Griefer
> > http://charlie.griefer.com/
> >
> > I have failed as much as I have succeeded. But I love my life. I love my
> > wife. And I wish you my kind of success.
> >
> >
> >
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335865
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Need a west coast (US) based CF host

2010-07-29 Thread Charlie Griefer

Hey all...

I know this topic ("can somebody recommend a CF host") comes up
frequently... I hate to bring it up again, but I must :)

I have a client that needs to be on shared hosting (they don't have the
funds for VPS, unfortunately) on a server with the clock set to PST.
 They're a company that's physically based in CA... recently moved hosts to
an east-coast based company, and now timestamps are off by 3 hours when they
add events.

According to the previous developer, they're using a calendaring system
(specifically, a particular version of a calendaring system) that isn't set
up to handle time zone differences.  He's told me that trying to update the
code to handle this would "open a whole new can of worms".

I've explored the options, and the path of least resistance seems to be to
relocate the site to a server based on the west coast.  Or at the very
least, a server whose clock is set to PST.

A quick google turned up Illuminated Hosting (
http://www.illuminatedhosting.com/), but I'm not familiar with them.  Does
anybody know of this company?  Or of any others that have servers set to
pacific time?

Thanks!
Charlie

-- 
Charlie Griefer
http://charlie.griefer.com/

I have failed as much as I have succeeded. But I love my life. I love my
wife. And I wish you my kind of success.


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335862
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Regex Help

2010-07-26 Thread Charlie Griefer

troublemaker :D

On Mon, Jul 26, 2010 at 12:02 PM, Andy Matthews wrote:

>
> http://www.cftagstore.com/tags/cfreextract.cfm
>
> :)
>
> -Original Message-
> From: Robert Harrison [mailto:rob...@austin-williams.com]
> Sent: Monday, July 26, 2010 1:00 PM
> To: cf-talk
> Subject: Regex Help
>
>
> I want to replace any occurrence of multiple -- in string so the entire
> string only contains one - in a row after filtering.
>
> Something like this does (sort of):
>
>#Replacelist("#mayvar#","-,,---,--","-,-,-,-")#
>
> But with regex more like:
>
>#ReReplace("#myvar#","--,"-","ALL")#
>
> How do I write a reg to change all multiple -- to result in only one -?
>
> Thanks
>
>
>
>
> Robert B. Harrison
> Director of Interactive Services
> Austin & Williams
> 125 Kennedy Drive, Suite 100
> Hauppauge NY 11788
> P : 631.231.6600 Ext. 119
> F : 631.434.7022
> http://www.austin-williams.com
>
> Great advertising can't be either/or.  It must be &.
>
> Plug in to our blog: A&W Unplugged
> http://www.austin-williams.com/unplugged
>
>
>
>
>
> __ Information from ESET Smart Security, version of virus signature
> database 5315 (20100726) __
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335724
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Regex Help

2010-07-26 Thread Charlie Griefer

rereplace( myvar, '-+', '-', 'all' )

On Mon, Jul 26, 2010 at 10:59 AM, Robert Harrison <
rob...@austin-williams.com> wrote:

>
> I want to replace any occurrence of multiple -- in string so the entire
> string only contains one - in a row after filtering.
>
> Something like this does (sort of):
>
>#Replacelist("#mayvar#","-,,---,--","-,-,-,-")#
>
> But with regex more like:
>
>#ReReplace("#myvar#","--,"-","ALL")#
>
> How do I write a reg to change all multiple -- to result in only one -?
>
> Thanks
>
>
>
>
> Robert B. Harrison
> Director of Interactive Services
> Austin & Williams
> 125 Kennedy Drive, Suite 100
> Hauppauge NY 11788
> P : 631.231.6600 Ext. 119
> F : 631.434.7022
> http://www.austin-williams.com
>
> Great advertising can't be either/or.  It must be &.
>
> Plug in to our blog: A&W Unplugged
> http://www.austin-williams.com/unplugged
>
>
>
>
>
> __ Information from ESET Smart Security, version of virus signature
> database 5315 (20100726) __
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335720
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Extracting part of a string (part 2)

2010-07-20 Thread Charlie Griefer

For that specific string, \$(\S+) seems to work.  The \S is any character
that is not a whitespace character, so it'd work for $400.01 as well.
 \$(\w+) should also return the same result.

On Tue, Jul 20, 2010 at 8:24 AM, Che Vilnonis  wrote:

>
> I also have a regex I can't seem to get right and could you some help.
> Take the following string... "buick 322 engine (76023) $400 (dallas)"
>
> How would I extract just the price ($400) without the dollar sign?
>
> TIA, Che
>
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335546
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Best conference?

2010-07-13 Thread Charlie Griefer

On Tue, Jul 13, 2010 at 1:25 PM, Andrew Clarke  wrote:

>
> I posted a similar question on cf-community a week or two ago, but it sort
> of got buried and only got one response (thanks ** Private ** for your
> response).
>
> I understand this is probably a loaded question, but what are peoples'
> opinions on the "best" conference to attend?  I've been developing
> ColdFusion apps for about 13 years now and have most of the features that
> have been around for a while down pretty well.  However, I have only one
> client using CF8, and am just in the process of installing CF9 for my first
> client right now.  I'd love to especially learn how people are using some of
> the new features in CF9, as well as Railo.


They've all got their pros and cons.

I think CFUnited has the widest variety of content (from beginner to
somewhat advanced), and it's certainly one of the biggest CF-based
conferences (probably second only to MAX).  Lots of networking and good
times with friends.

Based on what you've said, I'd look at cf.Objective().  It's a smaller
conference with more advanced topics, and probably more that you'd find
relevant.

While conferences like NCDevCon may feature Flash/Flex etc, you shouldn't
let that dissuade you.  As long as there are enough sessions specific to
what you want to learn, doesn't really matter how many other sessions there
might be, or how "off-topic" they are.  And as far as NCDevCon goes, you
can't beat the price.

IMO, regardless of which one you may choose to attend, it'll be worthwhile.
 Of the conferences that I've been fortunate enough to get to (CFUnited,
cf.Objective(), and MAX), it's evident that the folks behind them make every
effort to ensure that it's both a valuable and fun experience.


-
Charlie Griefer
http://charlie.griefer.com/

I have failed as much as I have succeeded. But I love my life. I love my
wife. And I wish you my kind of success.


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335319
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: ordering by lowest price (across two columns)

2010-07-05 Thread Charlie Griefer

On Mon, Jul 5, 2010 at 1:09 PM, Mike Little  wrote:

>
> hi guys, slightly off-topic...
>
> my product table contains normalprice and saleprice (not really named this
> but as an example). i wish to give the customer the ability to order by
> lowest to highest price taking into account both the normal and sale price.
>
> not quite sure how to achieve this using an efficient mysql query.
>

I'm no SQL guru (as the SQL gurus that I've worked with will tell you), but
off the top of my head, a CASE statement that compares saleprice and
normalprice, and sets a column based on the lowest one:

SELECT
 name,
 description,
 normalprice,
 saleprice,
 CASE
  WHEN normalprice < saleprice THEN normalprice
  ELSE saleprice
 END AS orderbyprice
FROM
 tablename
ORDER BY
 orderbyprice

untested... but something like that?

-- 
Charlie Griefer
http://charlie.griefer.com/

I have failed as much as I have succeeded. But I love my life. I love my
wife. And I wish you my kind of success.


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335067
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CF Shopping carts

2010-06-29 Thread Charlie Griefer

No, the fact that it's not elitist makes it not elitist.

Dave's analogy about the auto mechanic and the tools was spot-on (as per
usual).  If you want to do a job, you're expected to have the tools to do
the job.

I also agree 100% with what many have said about this particular client.
 I've dealt with those toxic clients before, because like yourself, I
couldn't afford to turn anybody away.  I learned right quick that often,
it's better (and more profitable) to -not- take on certain clients.  I can
virtually assure you that things with this particular client are not going
to end well.  Been there, done that.  It's never ended well.

I feel for your situation.  We just made a move as well, and we're hurting
from it.  I'm also freelancing right now and I definitely feel the pressure
to put food on our table.  We're a single income family of 5, and it's
definitely challenging at times.  But the fact of the matter remains... it's
not an elitist attitude to expect that somebody who wants to perform a
particular job will have, or be able to obtain, the tools necessary.

In all sincerity, I wish you the best of luck and hope things work out in
the end.  But sniping at folks who are only trying to offer assistance, even
if you don't agree with their perspective, isn't going to get you out of the
hole any faster.  If anything, it'll only make it worse :\

On Tue, Jun 29, 2010 at 9:38 AM, Eric Roberts <
ow...@threeravensconsulting.com> wrote:

>
> Actually, I don’t want to do freelance work, but I am forced to do so.  And
> just because you share his attitude doesn't make it not elitist.
>
> -Original Message-
> From: Dave Watts [mailto:dwa...@figleaf.com]
> Sent: Tuesday, June 29, 2010 11:15 AM
> To: cf-talk
> Subject: Re: CF Shopping carts
>
>
> > I pushed that...he doesn't like PayPal for some reason...he is under the
> > impression that people don't like it.   Not something that I have ever
> > heard...but he has that stuck in his head. I have suggested several other
> > free options.  It's not decision unfortunately.  I even suggested that he
> > use café press for now until; he gets some sales (He wants to do a
> t-shirt
> > site...I questioned whether or not this would even take off as he would
> be
> a
> > really small fish in a huge ocean of t-shirt sites).  He insists on doing
> > his own site...so finding a good cart to integrate into this that he can
> > afford is the difficulty...which is why I asked here and instead of
> getting
> > advice from folks like Sean, I was told that if I can't afford the carts
> out
> > there for 200, I shouldn't even be a developer.  So if you really want to
> > point a finger, I was just defending myself.
>
> This is all so screwed up, it's not even wrong.
>
> 1. $200 for any software development product is on the extreme low-end
> of the scale. If you can't afford to buy the tools you need to do a
> job, you shouldn't do the job. This doesn't reflect on your skills as
> a developer, etc, it's just a fact of life. That's all that Sean was
> saying, and he's absolutely right, and you're absolutely wrong to
> label it as "elitist BS". There's a cost of entry into any field that
> goes beyond your own skills. If you want to be a freelance programmer,
> you have to buy a certain amount of stuff, like a computer. If you
> want to be a car mechanic, you have to buy tools. Etc, etc, etc. So, I
> point the finger at you for mischaracterizing Sean's response. I'm
> sorry you don't have the money you need to do this job, but there you
> go. And, you have a history of doing this with Sean specifically, and
> it's out of line, and I think you should stop.
>
> 2. You're working for nothing for a client that's going to make
> nothing. You have bigger problems than the cost of an ecommerce
> package. If your client wants specific functionality that's in a COTS
> package, he needs to buy the package, not you. If it's too rich for
> his taste, that's his problem, not yours. But you're just wasting your
> time doing this work. Clients like this, who aren't willing to pay for
> what they want, or can't pay for what they want, they're toxic and you
> should avoid them. This guy wants Amazon functionality on a Paypal
> budget, and you're not going to be able to make him happy, which leads
> to ...
>
> 3. You're using the wrong tools for the job. If you want to do
> low-margin work, you need to use low-margin tools. You know, that
> might mean PHP, because there's a much larger FOSS ecosystem around
> PHP than CF. CF simply has never really aimed at that market. Frankly,
> if I were you and I wanted to go after that range of clients, I'd drop
> CF like a stone. Not because PHP is better, of course, and I wouldn't
> like it, but it makes sense in that market.
>
> I'm sorry for being harsh, if you perceive this as harsh, but the
> facts are what they are. I do wish you good luck in your future
> development endeavors, though.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.

Re: Facebook Connect and coldfusion

2010-06-23 Thread Charlie Griefer

Reading between the lines, I think Jeff might want you to share some code :)

On Wed, Jun 23, 2010 at 10:47 AM, Jeff Gladnick wrote:

>
> Kris,
>
> Would you be willing to share some code?  I'm having a hell of a time
> interfacing with the API
>
>
> >We're using FBConnect for a site in development now. It works fine, no
> >problem. Except when FB does something stupid and breaks the API.
> >Which happens every couple of weeks.
> >
> >Cheers,
> >Kris
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334773
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: php.org is written in ColdFusion

2010-06-21 Thread Charlie Griefer

True, but still kinda have to appreciate the irony :)

On Mon, Jun 21, 2010 at 1:52 PM, Ben Forta  wrote:

>
> Does not seem to be a valid site, more of a traffic troll, I think. :-(
>
>
> -Original Message-
> From: Andy Allan [mailto:andy.al...@gmail.com]
> Sent: Monday, June 21, 2010 4:49 PM
> To: cf-talk
> Subject: Re: php.org is written in ColdFusion
>
>
> It's just a resource site sitting on a CF shared host.
>
> Now if it was php.net that was running on ColdFusion, that would be
> something to get interested in.
>
> Andy
>
> On 21 June 2010 21:15, Justin Scott  wrote:
> >
> >> "http://php.org/ appears to be written completely in ColdFusion."
> >
> > Looks like one of those generic directory/information sites where
> > someone pulled a bunch of stuff off Wikipedia and embedded Google ads
> > to generate revenue.  There's likely 1,000 other sites running on the
> > same platform and has very little to do with promoting PHP outside of
> getting some ad clicks.
> >
> > A reverse IP check at www.yougetsignal.com shows a whole bunch of
> > these types of sites and other questionable material hosted on the same
> IP
> block.
> > They all appear to be CF as well.
> >
> >
> > -Justin
> >
> >
> >
> >
>
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334708
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CF9 Developer Edition - IP Addresses

2010-06-16 Thread Charlie Griefer

On Wed, Jun 16, 2010 at 6:52 AM, Paul Alkema wrote:

>
> Does anyone know how to edit the allowed allocated IP addresses for the CF9
> developer edition license?


AFAIK, not configurable.  The allowed addresses are 127.0.0.1, and whatever
the first 2 addresses that hit the server are.

You can reset them by restarting the CF service, but you can't configure
which 2 external addresses they are.

-- 
Charlie Griefer
http://charlie.griefer.com/

I have failed as much as I have succeeded. But I love my life. I love my
wife. And I wish you my kind of success.


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334593
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Comma delimited list

2010-05-28 Thread Charlie Griefer

On Fri, May 28, 2010 at 7:37 PM, Bill Hartley  wrote:

>
> I am trying to display feature codes from a comma delimited list inside a
> database.  Here is my setup:
>
> Table: Listings has a column called FEATURE_CODES and example of the data
> in this column is "B01,E09,E20,G12,J07"
>
> Then I have another table inside the same database called FeatureCodes the
> data inside this table is arranged
> FEATURE_CODE FEATURE_DESCRIPTION
> B01  Sold As Is
> E09  Frame and Stucco
> and so on
> I need to display the feature description from the FeatureCodes table on
> the display page by reading the feature_codes from the listing table


Agreed with the previous responses.  If it's at all an option, I'd normalize
the table and get rid of the comma-delimited lists.

If you can't do that, another route could be using a query or sub-query with
IN:

assuming variable "codes" is 'B01,E09,E20,G12,J07'...

first you'll want to qualify the list elements with single quotes:

  // note that's a single quote
enclosed in double-quotes

SELECT
 { columns }
FROM
 { tablename }
WHERE
 feature_code IN ( )

That, of course, assumes you can make two distinct queries (the first would
actually get the value assigned to the variable "codes").  You may be able
to massage it into a subquery and do it all in one swell foop.  Something
like:

SELECT
 { columns }
FROM
 { tablename }
WHERE
 feature_code IN ( SELECT feature_codes FROM listings WHERE { where
condition here } )

-- 
Charlie Griefer
http://charlie.griefer.com/

I have failed as much as I have succeeded. But I love my life. I love my
wife. And I wish you my kind of success.


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334105
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Comma delimited list

2010-05-28 Thread Charlie Stell

In the long run - your best option is to create third table that will link
listsings to multiple feature codes. This is true for many many reasons.

If your looking for a quick solution that doesnt involve changing tables -
you could use a sql split function (good ex.
http://geekswithblogs.net/AngelEyes/archive/2007/04/12/111504.aspx), this
will serve as a psuedo table for what i described above.

On Fri, May 28, 2010 at 10:37 PM, Bill Hartley  wrote:

>
> I am trying to display feature codes from a comma delimited list inside a
> database.  Here is my setup:
>
> Table: Listings has a column called FEATURE_CODES and example of the data
> in this column is "B01,E09,E20,G12,J07"
>
> Then I have another table inside the same database called FeatureCodes the
> data inside this table is arranged
> FEATURE_CODE FEATURE_DESCRIPTION
> B01  Sold As Is
> E09  Frame and Stucco
> and so on
> I need to display the feature description from the FeatureCodes table on
> the display page by reading the feature_codes from the listing table
>
> Any Suggestions?? Please!!
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334103
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: cflock and cfloop question

2010-05-26 Thread Charlie Stell

How are #current_ListingID# and #currentow# getting set? My guess would be
that within your loop over allimages, these are never being changed, so all
these copies are to the same destination file... resulting in only the last
file in the source directory being in the destination directory.

Also, Im not sure what the second cffile-copy is trying to do, but I dont
remember being able to copy a directory with cffile (not sure though)

On Wed, May 26, 2010 at 4:23 PM, cfcom  wrote:

>
> Am having some un predictable results with a loop.
> My code is supposed to copy upload jpegs from a temp folder to the images
> Folder. But only one jpeg is being moved from temp folder to images
> folder and the loop isn't grabbing any additional pictures.
> When the cflock was removed, it grabbed a second image but no more.
> Any help would be most appreciated - thank you again in advance.
>
> 
> directory="#house_dir#\temp\#client.userID#" name="allimages"
> filter="*.jpg">
>
> source="#house_dir#\temp\#client.userID#\#name#"
> destination="E:\webs\xyz\images_houses_new\#current_ListingID#_#currentr
> ow#.jpg"   nameconflict="overwrite">
>
> destination="E:\webs\xyz\images_houses\#current_ListingID#_#currentrow#.
> jpg"  nameconflict="overwrite">
>
>
>
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334023
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Retrive query cell value by key/value pair instead of row number?

2010-05-26 Thread Charlie Stell

When I've had to deal with the same situation previously, I usually
created a "lookup" structure based on the column ill use as a handle -
mystruct[value I want to ref by]=row index from query (this struct
would get populated by looping over whole query) . This index then can
be used to get at that row... I do seem to remember however that
there's now a cfscript verion of cfquery (I don't remember if it
supports query of querys). If that doesn't work, you could write a
function that takes a colname, col value and query name, and perform a
qoq- assuming the function will have access to the original query...

Hope that helps!

On 5/26/10, Jon Sala  wrote:
>
> Is it possible to retreive from a query in memory a cell value by a key
> value pair, ie other than the usual row number: myquery.columname[i]?
> Something like myquery.columname[myquery.keyval:thisquery.Id]
> For example, in a  block I'm looping through a query, and under
> certain conditions I need to retrieve a cell value from a previous query
> using a current keyval.
>
> I guess the real problem is I'm looking for a simple equivalent to 
> usable inside . Is coldfusion.server.ServiceFactory the only way
> out?
>
> Don't even know if any of this makes sense... I think I need to get some
> sleep.
>
> --
> Jon
>
> This message and any attached documents are only for the use of the intended
> recipient(s), are confidential and may contain privileged information. Any
> unauthorized review, use, retransmission, or other disclosure is strictly
> prohibited. If you have received this message in error, please notify the
> sender immediately, and then delete the original message. Thank you.
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334004
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Need CF help- is anyone available

2010-05-25 Thread Charlie Griefer

You'd have a greater likelihood of having more sets of eyes on it (and thus
a greater likelihood of getting a solution) if you were to just post the
question/code to the list.

IMO, of course :)

On Tue, May 25, 2010 at 1:47 PM, cfcom  wrote:

>
> Having serious problem with a piece of code
> Is there anyone who could take a look
> Been racking my head on this all day
>
> Please contact off list
>
> And thank you in advane
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333989
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Coldfusion 9 Windows vs Linux

2010-05-23 Thread Charlie Griefer

On Sun, May 23, 2010 at 11:50 AM, Beru  wrote:

>
> > Sad...


On 23 May 2010 20:41, Wil Genovese  wrote:

>
> > THREE CHEERS FOR THAT
>


Now that both sides have been equally represented, how about we move on? :)

-- 
Charlie Griefer
http://charlie.griefer.com/

I have failed as much as I have succeeded. But I love my life. I love my
wife. And I wish you my kind of success.


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333947
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: idea paint

2010-05-22 Thread Charlie Griefer

On Sat, May 22, 2010 at 5:14 PM, Matt Quackenbush wrote:

>
> It's called spam.


Nah, Brian's a CF developer.  I suspect he was just trying to share what he
thought was kind of a cool idea.

Might have been less misunderstood if he prefaced the link with, "hey, this
is kind of a cool idea..." :)

-- 
Charlie Griefer
http://charlie.griefer.com/

I have failed as much as I have succeeded. But I love my life. I love my
wife. And I wish you my kind of success.


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333920
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Is there a way to do an arbitrary sort order on a specific cell?

2010-05-14 Thread Charlie Griefer

case statement in the ORDER BY should work.

See http://www.devx.com/tips/Tip/17288

On Fri, May 14, 2010 at 9:24 AM, Les Mizzell  wrote:

>
> Is there a way to do an arbitrary sort order on a specific cell?
>
> For example, let's say I have a cell "colour".
> Possible values:
> 1. blue
> 2. cyan
> 3. green
> 4. orange
> 5. red
> 6. silver
>
> I want to sort on this cell, BUT, I want the order to show all
>
> red first
> blue second
> green third
>  ... blah ...
>
>
> __ Information from ESET NOD32 Antivirus, version of virus
> signature database 5115 (20100514) __
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.com
>
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333702
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Help With CF8 Regular Expressions

2010-05-05 Thread Charlie Griefer

On Wed, May 5, 2010 at 9:34 PM, denstar  wrote:

>
> On Mon, May 3, 2010 at 11:46 PM, James Holmes wrote:
> >
> > I hope you have your flameproof suit handy :-P
>
> Ah, the cleansing fire of a good library battle.  :)
>
> It's hot in here.  Normally I sleep in this thing, but if nobody's
> interested, the suit is going on the hook.



Oh dear God please let him be wearing something under that suit...

-- 
Charlie Griefer
http://charlie.griefer.com/

I have failed as much as I have succeeded. But I love my life. I love my
wife. And I wish you my kind of success.


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:96
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Remove multple EXTRA spaces from string

2010-04-23 Thread Charlie Griefer

On Fri, Apr 23, 2010 at 1:26 PM, UXB Internet wrote:

>
> I am having a senior moment and can't for the life of me figure this dumb
> thing out.  I am trying to remove all "extra" spaces from a string but
> leave
> the single space there.  Example:
> var="this has   many   extra  spaces" and return with "this has
> many extra spaces"


var myString = "this has many extra   spaces";

myString = rereplace( myString , \s+ , ' ' , 'all' );

-- 
Charlie Griefer
http://charlie.griefer.com/

I have failed as much as I have succeeded. But I love my life. I love my
wife. And I wish you my kind of success.


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333113
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Bind / CFC Question

2010-04-13 Thread Charlie Griefer

I haven't done much with binding, but can possibly offer some advice...

Presumably, you have an existing method that returns a query with all of the
columns from the table.

You can go one of two routes that I can think of...

1) create a new method that only queries the table for the single column
you're looking for.  You can even get creative and pass in the column name
as an argument so that you can return a specific column.

2) create a new remote method that calls your existing method (the one that
returns all columns), and within that new method, do a QoQ (or if the query
only returns a single record, you can do myQuery.columnName[1] and return
that.  The only drawback here is that you're still running a SELECT * when
all you really need is one specific column.  But if you're only returning a
single record, the overhead shouldn't be noticeable.

On Mon, Apr 12, 2010 at 11:13 AM, Chad Baloga  wrote:

>
> I am fairly new to CFCs and binding and have only used query returns with 1
> column. I was wondering how to bind to a cfinput with a certain column when
> my query is selecting * from a table.
>
> Thanks
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332846
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Joni Mitchell and Cold Fusion

2010-04-07 Thread Charlie Griefer

So there's no chance of -not- hosting it with GoDaddy?  'cuz I bet that'd
help a bit.

On Wed, Apr 7, 2010 at 1:22 PM, Les Irvin  wrote:

>
> Help me, I think I'm falling... here's an odd request for a certain
> individual.  Joni's official site is hosted on a GoDaddy server (don't
> ask) running CF8.  They keep shutting it down for overloading the
> server - asking me to streamline the code to avoid continued
> violations.  I'm sure my code sucks, but it's been on other servers
> without issue from those hosts.
>
> Would anyone out there, perhaps a Joni fan, volunteer to take a look
> at some code, shake their head in disgust at the awfulness of it, and
> help me rewrite inefficient sections?  This feels a bit like walking
> naked through a crowd, but hey
>
> In return, I'll put a link to whatever site you want in the footer of
> every page, and of course you'll have the satisfaction of helping out
> all the Joni fans across the globe.  The site gets about 2500 unique
> visitors a day.
>
> http://jonimitchell.com
>
> Thanks in advance,
> Les
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332718
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CFDocs

2010-04-07 Thread Charlie Griefer

Not familiar with that site.

But you could always use http://www.cfquickdocs.com or http://cfmldocs.com/ ,
both of which contain CF9 docs

On Wed, Apr 7, 2010 at 9:31 AM, Dave Sueltenfuss wrote:

>
> Does anyone know if the creator of cfdocs.org has plans to update the site
> to use the latest versions of CF Documentation
> It's still pointing to CF7'd documents
>
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332710
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: test

2010-04-07 Thread Charlie Griefer

this one?

http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332658

On Wed, Apr 7, 2010 at 7:07 AM, fun and learning wrote:

>
> Hello,
>
> This is a a test message. My previous two posts are not displayed on house
> of fusion
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332702
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Regex to remove script and style blocks

2010-04-07 Thread Charlie Griefer

See
http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSc3ff6d0ea77859461172e0811cbec0a38f-7ffb.html
for
the flag to trigger multi-line capabilities in regex.

(?m)]*>.*?

should do it.

]*>.*?' , '' , 'all' )>

On Tue, Apr 6, 2010 at 9:29 PM, UXB Internet wrote:

>
> I am at a loss as to how to structure a regex to remove a JavaScript block
> from a file using CF5.  What I am trying to do is remove the " everything including and between /script>". something like this:
>
> 
>
> 
>
> I have tried this but it give me and error: Bad regular expression
>
> .*?","",
> "all")>
>
> Assistance would be appreciated.
>
>
> Dennis Powers
> UXB Internet - A Website Design & Hosting Company
> P.O. Box 6028
> Wolcott, CT 06716
> 203-879-2844
> http://www.uxbinternet.com
>
>
>
>
>
>
>
>
>
>
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332688
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: using cfhttp

2010-04-06 Thread Charlie Griefer

On Tue, Apr 6, 2010 at 9:24 AM, Andy Matthews wrote:

>
> Additionally you can make the request a little lighter by just making a
> HEAD
> request instead of a get or post.
>
> http://www.andymatthews.net"; method="head">
>
> It doesn't return the entire body of the site in the filecontent key.
>

Nice!  I did not know that.

-- 
Charlie Griefer
http://charlie.griefer.com/

I have failed as much as I have succeeded. But I love my life. I love my
wife. And I wish you my kind of success.


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332645
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: using cfhttp

2010-04-06 Thread Charlie Griefer

d'oH!  yeah, cfhttp.statusCode.  not cfhttp.fileStatus.  :)

On Tue, Apr 6, 2010 at 8:41 AM, Kevin Pepperman  wrote:

>
> Using cfhttp will return a cfhttp.statusCode, which if is "200 OK" you know
> the URL has resolved correct.
>
>
> --
> /Kevin Pepperman
>
> "They who can give up essential liberty to obtain a little temporary
> safety,
> deserve neither liberty nor safety." - Benjamin Franklin
>
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332641
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: using cfhttp

2010-04-06 Thread Charlie Griefer

On Tue, Apr 6, 2010 at 8:36 AM, Orlini, Robert  wrote:

>
> Hello,
>
> Is there a way to use cfhttp to see if a site is down? Does it involve
> using #HTMLCodeFormat(cfhttp.FileContent)# to see if a 403 error is
> downloaded?
>

check the cfhttp.filestatus to see if it contains the string "200"

-- 
Charlie Griefer
http://charlie.griefer.com/

I have failed as much as I have succeeded. But I love my life. I love my
wife. And I wish you my kind of success.


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332639
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: ColdFusion Builder Team is on Twitter

2010-04-01 Thread Charlie Griefer

On Thu, Apr 1, 2010 at 4:55 PM, Adrocknaphobia wrote:

>
> Sorry for the change-up, but we've switched twitter accounts to @CFBuilder
> (donated by an awesome community member, Dale Fraser)!
>
> Follow us at: http://www.twitter.com/CFBuilder
>
> It only costs $299 to follow the @CFBuilder account, but we will retweet
> @Flash_Builder with no extra charge! ZING! (too soon?)
>

That's ridiculous.  You created that twitter account on top of Twitter's
existing infrastructure.  No way did you put the effort in to justify that
price.

-- 
Charlie Griefer
http://charlie.griefer.com/

I have failed as much as I have succeeded. But I love my life. I love my
wife. And I wish you my kind of success.


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332549
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: smush.it

2010-04-01 Thread Charlie Griefer

On Thu, Apr 1, 2010 at 10:27 AM, Jeff Gladnick wrote:

>
> I just tried out Yahoo's smush.it for image compression.  Even on images
> that were HAND optmized in photoshop, this still knocked off another 5%.
>
> Has anyone used smush.it with coldfusion?  Is there a way to send images
> to the server and bring em back into you app?
>

http://developer.yahoo.com/yslow/smushit/faq.html#faq_api

IS THERE A *SMUSH.IT* API I CAN ACCESS SO THAT MY IMAGES ARE AUTOMATICALLY
SMUSHED WHEN THEY ARE PUBLISHED?

The API currently is not available for public use. We are working towards
making this publicly accessible .

I'd imagine that when/if they open up the public API, it should be easy
enough to do.

-- 
Charlie Griefer
http://charlie.griefer.com/

I have failed as much as I have succeeded. But I love my life. I love my
wife. And I wish you my kind of success.


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332534
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Strange form field behavior based on its name

2010-04-01 Thread Charlie Stell

Ive had a similar issue when working with a form with a field named
"action".

On Thu, Apr 1, 2010 at 11:53 AM, Mark A. Kruger wrote:

>
> Yes I don't know anyone who really used that feature since CF 4.x ...
> it
> was actually pretty crude. Useful for intranets or whatever - but that's
> about it.
>
> -mark
>
>
> Mark A. Kruger, MCSE, CFG
> (402) 408-3733 ext 105
> www.cfwebtools.com
> www.coldfusionmuse.com
> www.necfug.com
>
>
> -Original Message-
> From: Raymond Camden [mailto:rcam...@gmail.com]
> Sent: Thursday, April 01, 2010 10:32 AM
> To: cf-talk
> Subject: Re: Strange form field behavior based on its name
>
>
> Which, thankfully, CF9 finally gave us a way to turn off.
>
> On Thu, Apr 1, 2010 at 9:51 AM, Dave Watts  wrote:
> >
> >> Are out_start and out_end reserved keywords for form fields?  I looked
> for
> >> documentation found no references.  When I output their value after
> submission, they're
> >> get translated to {t '00:00:00'}.  If name them out_xstart and out_xend,
> the proper date
> >> values show.  Just an oddity to share.
> >
> > Yes, they're used for server-side validation of CFINPUT with range
> > attributes, I think.
> >
> > Dave Watts, CTO, Fig Leaf Software
> > http://www.figleaf.com/
> > http://training.figleaf.com/
> >
> > Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
> > GSA Schedule, and provides the highest caliber vendor-authorized
> > instruction at our training centers, online, or ons
> >
> >
>
>
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332531
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: ColdFusion Builder Released!

2010-03-30 Thread Charlie Griefer

I don't think the overall number of CF developers matters.  CFBuilder isn't
really aimed at -every- CF developer (I don't think... this, of course, is
purely conjecture on my part).

Not too long ago, Ben F. blogged that only a relatively small number of CF
developers even use CFCs.  Let's say it's 20% (i think that's actually
higher than the % Ben had suggested).  So 80% of CF developers are "5
taggers".  They're not going to see the value in most of the features of CF
Builder.

So... I'd say the 2% might be pretty close to what they've actually
targeted.  And given that they may be targeting a very small percentage of
their user base, it wouldn't make sense to price it too low.

And since I got sucked back into the convo (I'm an asshole), I'll also say
that I don't agree with the assertion that Adobe thinks CF Builder is worth
$50.  I'd argue that they're bundling it at a discount and considering the
"loss" an investment in attempting to cross-promote between CF and Flex
communities.  If they convert 'x'% of Flex developers (who currently don't
use CF on the server side) to CF, the short-term loss turns into a long term
gain.

(again, IMO).


On Tue, Mar 30, 2010 at 2:40 PM, Andrew Scott wrote:

>
> No its not Dave.
>
> I think the proof will be in the pudding, Adobe has 800k ColdFusion
> developers. So that means if they have it priced right they should get
> around 40% plus buying the program.
>
> My forecast is that they will be lucky to reach 2% in sales of all those
> ColdFusion Developers.
>
>
>
> -Original Message-
> From: Dave Watts [mailto:dwa...@figleaf.com]
> Sent: Wednesday, 31 March 2010 2:43 AM
> To: cf-talk
> Subject: Re: ColdFusion Builder Released!
>
> Is this really the first time you've encountered product bundling? Do
> you really think that the additional cost of a bundled product
> translates directly into the value of the product if sold separately?
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> http://training.figleaf.com/
>
> Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
> GSA Schedule, and provides the highest caliber vendor-authorized
> instruction at our training centers, online, or onsite.
>
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332465
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: ColdFusion Builder Released!

2010-03-30 Thread Charlie Griefer

On Tue, Mar 30, 2010 at 11:15 AM, denstar  wrote:

>
> Leave it to Dave to reply with something helpful, vs. calling Charlie
> the scum-ridden afterbirth of a syphilistic-cow with hemorrhoids (I
> heard he has sex with goats, too!), or some such.
>
>
Oh ffs.  Y'know, you do something one time... ONE time  *sigh* :)

-- 
Charlie Griefer
http://charlie.griefer.com/

I have failed as much as I have succeeded. But I love my life. I love my
wife. And I wish you my kind of success.


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332457
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: ColdFusion Builder Released!

2010-03-30 Thread Charlie Griefer

Heh... I know I did my part to contribute to the spiraling thread of death,
but I agree.  We've long passed the point of diminishing returns here and
seem to be stuck in a loop.

Somebody... anybody... feel free to call me an asshole so Michael shuts down
the thread due to personal attacks :)

On Tue, Mar 30, 2010 at 10:25 AM, G Allen R Souliere <
al...@electricedgesystems.com> wrote:

>
> Though I'm not a particularly religious man, AMEN!
>
> Roger Austin wrote:
> > This whole discussion has gotten tedious and needs to go off-line.
> > Adobe software has never been cheap. Acrobat, Photoshop, etc. People
> > purchase the packages because they need them and have no other
> > choices, or because they believe they are a good value for their
> > situation.
> >
> > I don't plan on purchasing CFBuilder any time soon since I don't
> > believe it is ready at version 1. I have been using CFEclipse
> > lately and it does almost everything that I need. I may change
> > my mind later when corporate IT allows us to use CF9. Or, maybe
> > Josh Adams will convince me tonight at the TACFUG event in RTP.
> > --
> > http://www.linkedin.com/pub/roger-austin/8/a4/60
> > http://twitter.com/RogerTheGeek
> > http://www.misshunt.com/ Home of the Clean/Dirty Magnet
> > http://www.ncdevcon.com/ TACFUG 2010 Conference in North Carolina
> >
> >
> >
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332450
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: ColdFusion Builder Released!

2010-03-23 Thread Charlie Griefer

On Tue, Mar 23, 2010 at 6:56 AM, Eric Cobb  wrote:

>
> Charlie Griefer wrote:
> "Bundling it with FlashBuilder may be their way of trying to increase the
> uptake of the language as a whole and thus ultimately sell more server
> licenses.  By doing this, they're potentially introducing CF to PHP
> developers, Java developers, etc."
>
> I have to say that I don't agree with that last statement.  FlashBuilder
> 4 (Standard Edition) with CFBuilder costs $299, and FlashBuilder 4
> (Standard Edition) without CFBuilder costs $249.  So for an existing
> PHP/Flex developer who has no use for CF, do you think they're going to
> pay $299 to get an extra IDE for a language they don't use, or spend $50
> less and just get the IDE they need?
>

No, I think you're right in that scenario.  A Flex developer out to upgrade
to FlashBuilder -Standard- isn't going to go, "Oh... I can spend an extra
$50 and buy ColdFusion Builder instead, which contains FlashBuilder."  Sure
:)

But the FlexBuilder 3 Professional folks who are going to upgrade to
FlashBuilder 4 are going to get ColdFusion Builder as part of that upgrade.
 They're the PHP developers, Java developers, etc to whom I was referring.

-- 
Charlie Griefer
http://charlie.griefer.com/

I have failed as much as I have succeeded. But I love my life. I love my
wife. And I wish you my kind of success.


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332108
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: ColdFusion Builder Released!

2010-03-22 Thread Charlie Griefer

On Mon, Mar 22, 2010 at 5:04 PM, Casey Dougall <
ca...@uberwebsitesolutions.com> wrote:

>
> OK Plain and simple... Why ColdFusion builder should be FR$$!
>
> And these clients in return purchase ColdFusion. We are their Marketing in
> this department. It's in Adobe's best interest to allow ColdFusion
> Developers access to tools that assist with development on their platform,
> because it actually costs money to install on the server.
>

I'm not disagreeing that there could be value there.  But there could also
be value in the cross-promotion efforts.  The two are not mutually
exclusive, but Adobe chose to go with one over the other.  Doesn't make it
wrong.


> Look at Flex, Flash, ActionScript These platforms or whatever are
> available on X amount of computers around the world, at no additional cost
> to the client or the developer.
>
> Two totally different business models.
>
> Look at how Macromedia did it... ColdFusion Report Builder is FREE! Totally
> separate product that can be used in conjunction with one of products you
> have to pay to install on a device... ColdFusion
>
> Yes, you should pay for anything that needs to interact with their FREE
> scripting languages, but not the paid for ones!
>

Not sure I see the correlation.  But looking back at Macromedia, if memory
serves, ColdFusion Studio (when it was an IDE and not a product suite) was
not free.  So OK, let's look at how Macromedia did it ;)

Oh, and ColdFusion Studio was $495.  10 years later we have a better product
(arguably... at least in its potential) and it costs $200 less.

HomeSite/HomeSite+... also not free.

I think those are better correlations than CF Report Builder.


> Every ColdFusion license should come with 1 Builder License.
>

Hey don't get me wrong, I wouldn't be against this :)  But I'm also not
going to rail against Adobe because it doesn't.


> Separate license that can be given out as promotional value to a new
> developer who is interested in CFML. They in return, start using it, love
> it, and tell their clients to install it on their server. $$$
>

Those same developers can download the 60 day trial (that's 2 months... I've
downloaded trials that expired in 15 days, well before I even had the chance
to give 'em a fair shake).  That should be more than enough time to start
loving it, telling their clients to use it, and then shelling out the $300
for it (-and- by virtue of doing so gaining exposure to FlashBuilder).
 Win/win.


> They don't need to do that with their other languages, it's a given so the
> fact that you need to purchase a development tool there is a given.
> ColdFusion, not so much so.
>

This goes back to the ever-present debate about the cost of ColdFusion
server versus the cost of other similar platforms.  Yes, CF costs.  PHP does
not, ASP does not, etc.  We make up for the cost via rapid application
development and in the end, save a metric assload of money.  I don't see the
IDE argument factoring in here at all.


> > You  might stop doing so because you're upset about
> > the fact that the CFBuilder pricing isn't catered to your needs... a
> > handful
> > of others might as well.  But I'd venture to guess that it won't be a
> > statistically significant amount of people.  CF server is the product we
> > use
> > and love.
>
> No, I totally love CFML. Adobe lucked out when they bought Macromedia!
>

I agree.  I think most developers will agree.  I don't think Adobe's going
to lose a lot of existing developers over this, but they stand to gain
(many?) more.

> A number of us will shell out the $300 for CFBuilder -and-
> > FlashBuilder.  A number of us will continue to use CFEclipse or TextMate
> or
> > Coda or BBEdit or...
> >
> >
> That's misleading. It's $600 ish as you need to purchase FlashBuilder
> Premium, I don't have Flex Builder currently.
>

It's not misleading.  CFBuilder, which costs $299, comes with FlashBuilder
standard.

>From http://www.adobe.com/products/coldfusion/buy/#cfb :

"Additionally, easily create rich interfaces for your applications with a
complimentary copy of Flash Builder 4 Standard  included
with ColdFusion Builder."

So it's not $600 ish.  It's $299 and you get both ColdFusion Builder and
FlashBuilder.  Which is pretty much saying, "Buy FlashBuilder and get
CFBuilder for free" (or vice-versa).  Much better deal than CFStudio for
$500 :)


-- 
Charlie Griefer
http://charlie.griefer.com/

I have failed as much as I have succeeded. But I love my life. I love my
wife. And I wish you my kind of success.


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332084
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: ColdFusion Builder Released!

2010-03-22 Thread Charlie Griefer

On Mon, Mar 22, 2010 at 4:05 PM, Eric Roberts <
ow...@threeravensconsulting.com> wrote:

>
> Lets say you drive a ford and I give you a piston for a Chevy for free.
> Unless you happen to also have a Chevy with the engine that fits, I
> basically gave you a useless piston...but it was free...  So to say this
> bundle is beneficial to all is a misstatement.


OK.  Show me where I (or anyone in this or any other thread) said "this
bundle is beneficial to all".  Take your time and look hard.


> They should offer other
> options.  That would be the right thing to do.


The "right" thing to do is highly subjective.  For you, it might be the
right thing to do, and as I've said (repeatedly), I understand that.  This
is the direction that Adobe's chosen to take.  And while I get that it's not
beneficial for everybody, I see where there is the potential for it to be
beneficial by way of cross-promoting CF to Flex people and Flex to CF
people.  That, to me, doesn't seem like the "wrong thing".  All I'm asking
people to realize is that because it's not "right" for them does not make it
wrong.  There is no scenario under which it would be "right" for everybody.


> It's the same reason why
> many of us stopped using Dreamweaver.  While DW is a great package, it has
> a
> lot of features that are completely useless to us as developers, while Home
> site or Eclipse was just right as far as an environment for developers as
> opposed to designers. If I don't use flash or flex, what is the value of
> Flash builder to me?  (hint:  $0)


I stopped using DW because I found it to be bloated, sluggish, and
unresponsive.  I've heard that it's gotten better, but I've not had the
opportunity to try it out lately.

To you, the value of FlashBuilder is $0.  I can't say, "I get that" any more
than I already have.  To others, there's value.  Perhaps I've been wanting
to try my hand at Flex, but wasn't prepared to shell out the $ for
FlexBuilder/FlashBuilder.  Now I've got a reason.  There's some value.

So again... no value to -you- specifically != no value.


> Considering that as far as CF is
> concerned, we are the marketing team since they can't seem to have the
> drive
> to market it themselves, making us happy is a good idea.  We are the ones
> that suggest CF to clients and employers.  We are the ones that push for
> upgrades.  Adobe makes lots money from our actions.
>

I agree that there have been issues with marketing CF.  For years I'd have
loved to have seen a CF ad in a trade magazine that promoted CF to
developers of other languages.  But do you not see the marketing effort
here?  Cross promoting FlashBuilder to CF developers, and CF to Flex
developers (who may be PHP or Java or Ruby people)?  There's value in that
effort.  It may not work, but I applaud the effort.

People seem to keep coming back to, "Adobe needs to take care of us to grow
the community".  I don't get that.  If they take care of us they keep the
community content, but it doesn't grow.  We're still going to push CF to
clients and employers.  You  might stop doing so because you're upset about
the fact that the CFBuilder pricing isn't catered to your needs... a handful
of others might as well.  But I'd venture to guess that it won't be a
statistically significant amount of people.  CF server is the product we use
and love.  A number of us will shell out the $300 for CFBuilder -and-
FlashBuilder.  A number of us will continue to use CFEclipse or TextMate or
Coda or BBEdit or...

I just don't think anybody's getting screwed here.  If anything, people are
getting something for nothing.  If you don't want what they're offering for
nothing, you're not getting screwed.  You're no worse off than you were
yesterday.

-- 
Charlie Griefer
http://charlie.griefer.com/

I have failed as much as I have succeeded. But I love my life. I love my
wife. And I wish you my kind of success.


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332077
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


  1   2   3   4   5   6   7   8   9   10   >