Re: Development Server Installation Scenario

2010-06-07 Thread Richard Steele

Yes, that sounds like an interesting solution. I'll explore that. I probably 
overstated the amount of code, it's probably more like 1 gig or less.

> I'd consider moving the 90% - 270GB (images) to amazon S3.
> 
> Joe Danziger has an Amazon S3 Rest wrapper (cfc) that could assist:
> http://www.ajaxcf.com/blog/index.cfm/2006/9/7/Amazon-S3-REST-Wrapper
> 
> and Railo have just an annouced a free S3 extension:
> 
> http://www.railo.ch/blog/index.
c> fm/2010/5/27/Paid-Railo-Extension-Amazon-S3-now-free-moves-to-the-core.
> 
> 
> and Google has an alternative:
> http://arstechnica.
> com/web/news/2010/05/google-storage-for-developers-takes-on-amazon-s3.
> ars
> 
> 30GB of code is a lot of code... hopefully someone else will suggest 
> how best to deal with that!
> 
> 
> > Our production server has over 300 gb of files (90% images and 10% 
> > code). We'd like to a setup a development server that includes all 
> of 
> > those files and thus are considering the following...
> > 
> > 1. Have our isp copy our production server's wwwroot/sites folder 
> with 
> > its 300 gb of files to an external hard drive and have that drive 
> > shipped to us.
> > 2. Create an XP box locally and install CF8 developer on it as our 
> > development server.
> > 3. Copy the contents of that hard drive to the local server's sites 
> 
> > folder.
> > 4. Create a CF datasource that connects remotely to a duplicate of 
> our 
> > production SQL Server database that is on a dedication SQL Server at 
> 
> > our isp.
> > 5. Have our developers install CF8 developer and CFBuilder on their 
> 
> > local computers (outside of our offices).
> > 6. Use CFBuilder RDS to access our development server.
> > 7. Sync changes to the production server (new image files, etc. ) so 
> 
> > that they are automatically updated on the local server. 
> > 8. After testing, have the developers connect to the production 
> server 
> > and upload their new or changed files to it.
> > 
> > This also gives us a nice safety backup of our production server's 
> > critical files.
> > 
> > Does this sound like a good, realistic plan? 
> > 
> > What method would we use to refresh the development server's files 
> > with new or changed files from the production server on a daily 
> > basis?
> > 
> > Thanks in advance.
> > 
> > 


~|
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:334359
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Development Server Installation Scenario

2010-06-07 Thread Richard Steele

> I'd consider moving the 90% - 270GB (images) to amazon S3.
> 
> Joe Danziger has an Amazon S3 Rest wrapper (cfc) that could assist:
> http://www.ajaxcf.com/blog/index.cfm/2006/9/7/Amazon-S3-REST-Wrapper
> 
> and Railo have just an annouced a free S3 extension:
> 
> http://www.railo.ch/blog/index.
c> fm/2010/5/27/Paid-Railo-Extension-Amazon-S3-now-free-moves-to-the-core.
> 
> 
> and Google has an alternative:
> http://arstechnica.
> com/web/news/2010/05/google-storage-for-developers-takes-on-amazon-s3.
> ars
> 
> 30GB of code is a lot of code... hopefully someone else will suggest 
> how best to deal with that!
> 
> 
> > Our production server has over 300 gb of files (90% images and 10% 
> > code). We'd like to a setup a development server that includes all 
> of 
> > those files and thus are considering the following...
> > 
> > 1. Have our isp copy our production server's wwwroot/sites folder 
> with 
> > its 300 gb of files to an external hard drive and have that drive 
> > shipped to us.
> > 2. Create an XP box locally and install CF8 developer on it as our 
> > development server.
> > 3. Copy the contents of that hard drive to the local server's sites 
> 
> > folder.
> > 4. Create a CF datasource that connects remotely to a duplicate of 
> our 
> > production SQL Server database that is on a dedication SQL Server at 
> 
> > our isp.
> > 5. Have our developers install CF8 developer and CFBuilder on their 
> 
> > local computers (outside of our offices).
> > 6. Use CFBuilder RDS to access our development server.
> > 7. Sync changes to the production server (new image files, etc. ) so 
> 
> > that they are automatically updated on the local server. 
> > 8. After testing, have the developers connect to the production 
> server 
> > and upload their new or changed files to it.
> > 
> > This also gives us a nice safety backup of our production server's 
> > critical files.
> > 
> > Does this sound like a good, realistic plan? 
> > 
> > What method would we use to refresh the development server's files 
> > with new or changed files from the production server on a daily 
> > basis?
> > 
> > Thanks in advance.
> > 
> > 


~|
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:334358
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Development Server Installation Scenario

2010-06-07 Thread Andrew Grosset

I'd consider moving the 90% - 270GB (images) to amazon S3.

Joe Danziger has an Amazon S3 Rest wrapper (cfc) that could assist:
http://www.ajaxcf.com/blog/index.cfm/2006/9/7/Amazon-S3-REST-Wrapper

and Railo have just an annouced a free S3 extension:

http://www.railo.ch/blog/index.cfm/2010/5/27/Paid-Railo-Extension-Amazon-S3-now-free-moves-to-the-core.

and Google has an alternative:
http://arstechnica.com/web/news/2010/05/google-storage-for-developers-takes-on-amazon-s3.ars

30GB of code is a lot of code... hopefully someone else will suggest how best 
to deal with that!


> Our production server has over 300 gb of files (90% images and 10% 
> code). We'd like to a setup a development server that includes all of 
> those files and thus are considering the following...
> 
> 1. Have our isp copy our production server's wwwroot/sites folder with 
> its 300 gb of files to an external hard drive and have that drive 
> shipped to us.
> 2. Create an XP box locally and install CF8 developer on it as our 
> development server.
> 3. Copy the contents of that hard drive to the local server's sites 
> folder.
> 4. Create a CF datasource that connects remotely to a duplicate of our 
> production SQL Server database that is on a dedication SQL Server at 
> our isp.
> 5. Have our developers install CF8 developer and CFBuilder on their 
> local computers (outside of our offices).
> 6. Use CFBuilder RDS to access our development server.
> 7. Sync changes to the production server (new image files, etc. ) so 
> that they are automatically updated on the local server. 
> 8. After testing, have the developers connect to the production server 
> and upload their new or changed files to it.
> 
> This also gives us a nice safety backup of our production server's 
> critical files.
> 
> Does this sound like a good, realistic plan? 
> 
> What method would we use to refresh the development server's files 
> with new or changed files from the production server on a daily 
> basis?
> 
> Thanks in advance.
> 
> 


~|
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:334357
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Development Server Installation Scenario

2010-06-07 Thread Richard Steele

Our production server has over 300 gb of files (90% images and 10% code). We'd 
like to a setup a development server that includes all of those files and thus 
are considering the following...

1. Have our isp copy our production server's wwwroot/sites folder with its 300 
gb of files to an external hard drive and have that drive shipped to us.
2. Create an XP box locally and install CF8 developer on it as our development 
server.
3. Copy the contents of that hard drive to the local server's sites folder.
4. Create a CF datasource that connects remotely to a duplicate of our 
production SQL Server database that is on a dedication SQL Server at our isp.
5. Have our developers install CF8 developer and CFBuilder on their local 
computers (outside of our offices).
6. Use CFBuilder RDS to access our development server.
7. Sync changes to the production server (new image files, etc. ) so that they 
are automatically updated on the local server. 
8. After testing, have the developers connect to the production server and 
upload their new or changed files to it.

This also gives us a nice safety backup of our production server's critical 
files.

Does this sound like a good, realistic plan? 

What method would we use to refresh the development server's files with new or 
changed files from the production server on a daily basis?

Thanks in advance.




~|
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:334356
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: List Of Custom Tags

2010-06-07 Thread LRS Scout

Yeah but any .cfm file can be called by the server as a custom tag
anywhere that the cf server has access to.

On Tue, 2010-06-08 at 06:35 +1000, Andrew Scott wrote:
> 
> 
> 
> 
> -Original Message-
> From: Paul Alkema [mailto:paulalkemadesi...@gmail.com] 
> Sent: Tuesday, 8 June 2010 5:54 AM
> To: cf-talk
> Subject: List Of Custom Tags
> 
> 
> Is there any possible way to pull a list of all custom tags available?
> 
> 
> 
> 
> 

~|
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:334355
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


transposing sql rows as columns

2010-06-07 Thread fun and learning

Hi All - 

I have a query which returns result set as follows:

year amt_type amount 

2001 vacation 1000
2001 medical  1000
2001 college 15000
2002 vacation 800
2002 medical  1000
2002 college 1
2003 vacation 400
2003 medical  2000
2003 college 8.

I am trying to make the years 2001, 2002, and 2003 as columns and trying to 
achieve the below output

Amt type2001   2002   2003
vacation1000   800400
medical 1000   1000   2000
college 15000  1  8000

I am able to achieve this perfectly on client side. Right now I am trying to 
achieve the same through using SQL. I am using

DECODE to achieve but my result set looks like below

Amt type2001   2002   2003
vacation1000  
vacation   800
vacation  400
medical 1000
medical1000   
medical   2000
college 15000  
college1  
college   8000


I am trying this on oracle. I am new to this concept. can anyone who worked in 
similar situation help me. Also, the years may change depending upon the 
dropdown selection on client page. Can I transpose rows to columns in SQL for 
dynamic values

Thanks 

~|
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:334354
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: List Of Custom Tags

2010-06-07 Thread Andrew Scott





-Original Message-
From: Paul Alkema [mailto:paulalkemadesi...@gmail.com] 
Sent: Tuesday, 8 June 2010 5:54 AM
To: cf-talk
Subject: List Of Custom Tags


Is there any possible way to pull a list of all custom tags available?




~|
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:334353
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: List Of Custom Tags

2010-06-07 Thread Jason Fisher

Especially true since any tag can be called from any location with 
CFMODULE.



From: "Dave Watts" 
Sent: Monday, June 07, 2010 4:26 PM
To: "cf-talk" 
Subject: Re: List Of Custom Tags

> Is there any possible way to pull a list of all custom tags available?

No, I don't think so. This would be a bit difficult for CF to
accomplish, as custom tags can be invoked many different ways and can
be placed in many different locations.

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-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334352
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: RegEx help

2010-06-07 Thread Jason Fisher

Assuming that those are tabs between the elements, the following will 
expand on Andy's suggestion.



#mid(testString, test.pos[2], test.len[2])#



From: "Andy Matthews" 
Sent: Monday, June 07, 2010 3:32 PM
To: "cf-talk" 
Subject: RE: RegEx help

If you can always depend on Age: before the desired string, and what looks
like a tab afterwards, then it's trivial:

Age:[0-9a-Z]+\t

That assumes that the age will be any combination of letters and numbers,
and also allows for upper and lower case.

andy

-Original Message-
From: Debbie Morris [mailto:ddicker...@macromedia.com] 
Sent: Monday, June 07, 2010 1:51 PM
To: cf-talk
Subject: RegEx help

I need to extract a particular piece of data from one of my query fields 
and
I'm not sure how to go about it.

We have incidents in one table that can have comments in another table
associated with them.

Here's an example of one of the comments in my query results that I need 
to
grab data from:

Case Information   Problem:diff breathing   Patients:1   Four commandment
Information   Age:2 months   Gender:Female   Conscious:Yes   Brea

I need to get the Age information for any comments that contain it. The 
Age
field always begins as shown above and the Gender field always immediately
follows it, so I'm assuming I can work from that, but I just don't know 
how
to go about writing it. Any thoughts would be greatly appreciated!!

Deb 



~|
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:334351
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: List Of Custom Tags

2010-06-07 Thread Dave Watts

> Is there any possible way to pull a list of all custom tags available?

No, I don't think so. This would be a bit difficult for CF to
accomplish, as custom tags can be invoked many different ways and can
be placed in many different locations.

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-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334350
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: ColdFusion and .NET Web Services running WSE 3.0

2010-06-07 Thread Paul Alkema

James, 
I too have had issue connecting to Exact Target's poorly documented API.

I did manage to figure out how to add a user via an older API though.

http://paulalkema.com/post.cfm/how-to-subscribe-a-user-in-exact-target-via-t
heir-api

Regards,
Paul Alkema

-Original Message-
From: Dan O'Keefe [mailto:dan.oke...@gmail.com] 
Sent: Sunday, June 06, 2010 2:36 PM
To: cf-talk
Subject: Re: ColdFusion and .NET Web Services running WSE 3.0


James,

I would be interested in participating on this as well as I have a
current need for the WS-Security piece with ExactTarget API.

Dan


On Sat, Jun 5, 2010 at 7:13 AM, James Holmes  wrote:
>
> OK, I'll finish up the webservice wrapper CFC on which I'm working and
then
> look at what's necessary to add the digest password type (currently I just
> have the text type working) and any other parts of WS-Security that are
> possible in CF.
>
> The code will work in CF8 and higher, although parts of it will probably
> work in CF7 (since that's when we got addSoapRequestHeader()).
>
> mxAjax / CFAjax docs and other useful articles:
> http://www.bifrost.com.au/blog/
>
>
> On 5 June 2010 21:15, Phillip Duba  wrote:
>
>>
>> James, I know I will definitely need something like that in the future.
>> While this project went the .NET route, there are two follow-on projects
>> that will most likely be needed, one requested by my group, so I know
I'll
>> be working on at least one more integration using WS-Securit. Thanks,
>>
>> Phil
>>
>> On Sat, Jun 5, 2010 at 8:12 AM, James Holmes 
>> wrote:
>>
>> >
>> > Coincidentally, I've just finished developing the code necessary to do
a
>> > basic WS-SECURITY call in CF, using standard cf webservices code (i.e.
no
>> > extra Java jars or other external dependencies).
>> >
>> > If people need this sort of thing, let me know because I'm thinking of
>> > starting an open source project to flesh it out.
>> >
>> > mxAjax / CFAjax docs and other useful articles:
>> > http://www.bifrost.com.au/blog/
>> >
>> >
>> > On 5 June 2010 01:04, Phillip Duba  wrote:
>> >
>> > >
>> > > It did for the pure web services, not for the HTTP Post method (not
>> > > recommended for production). It was a proof-of-concept under a tight
>> > > deadline so I didn't have time to follow the web service all the way
to
>> > the
>> > > conclusion I would need for production. I did find a few blog posts
>> that
>> > > got
>> > > me pointed in the direction I probably needed to go. The specific
>> > > implementation was the Username Token profile. I eventually got to
>> > > receiving
>> > > an error of cannot authorize/validate the username token. It probably
>> had
>> > > to
>> > > do with timestamps and the makeup of the token itself. Again, I just
>> ran
>> > > out
>> > > of time and the project was chosen to be done by another organization
>> > > internally doing .NET work for which the WS-Security implementation
was
>> > > seamless using MS's WSE library. It wasn't the deciding factor, but
it
>> > was
>> > > definitely a differentiator,
>> > >
>> > > Phil
>> > >
>> > > On Fri, Jun 4, 2010 at 12:53 PM, Dan O'Keefe 
>> > wrote:
>> > >
>> > > >
>> > > > Philip,
>> > > >
>> > > > Did you authorization require WS-Security?
>> > > >
>> > > > Dan
>> > > > --
>> > > > Dan O'Keefe
>> > > >
>> > > >
>> > > >
>> > > > On Thu, Apr 29, 2010 at 12:13 PM, Phillip Duba 
>> > > wrote:
>> > > > >
>> > > > > Dave, thanks for the response. I've gone to executing the request
>> > using
>> > > > > CFHTTP, creating the soap:Header tag and building it as I go
>> through
>> > > the
>> > > > WSE
>> > > > > spec and examples. I've gotten to the point that I get
unauthorized
>> > so
>> > > > > that's where I'm at now. I may have to use CFHTTP to do it, but
>> we'll
>> > > > see.
>> > > > > Thanks again,
>> > > > >
>> > > > > Phil
>> > > > >
>> > > > >
>> > > > >
>> > > >
>> > > >
>> > >
>> > >
>> >
>> >
>>
>>
>
> 



~|
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:334349
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


List Of Custom Tags

2010-06-07 Thread Paul Alkema

Is there any possible way to pull a list of all custom tags available?


~|
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:334348
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: RegEx help

2010-06-07 Thread Andy Matthews

If you can always depend on Age: before the desired string, and what looks
like a tab afterwards, then it's trivial:

Age:[0-9a-Z]+\t

That assumes that the age will be any combination of letters and numbers,
and also allows for upper and lower case.


andy


-Original Message-
From: Debbie Morris [mailto:ddicker...@macromedia.com] 
Sent: Monday, June 07, 2010 1:51 PM
To: cf-talk
Subject: RegEx help


I need to extract a particular piece of data from one of my query fields and
I'm not sure how to go about it.

We have incidents in one table that can have comments in another table
associated with them.

Here's an example of one of the comments in my query results that I need to
grab data from:

Case Information   Problem:diff breathing   Patients:1   Four commandment
Information   Age:2 months   Gender:Female   Conscious:Yes   Brea

I need to get the Age information for any comments that contain it. The Age
field always begins as shown above and the Gender field always immediately
follows it, so I'm assuming I can work from that, but I just don't know how
to go about writing it. Any thoughts would be greatly appreciated!!

Deb 



~|
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:334347
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: cfquery to json array

2010-06-07 Thread Cutter (ColdFusion)

toJson is better if you have room for the server-side overhead, and 
don't mind writing methods that can't be used in any other scenario than 
via Ajax. CFQueryReader is solely a client side solution, so that you 
can reuse your server-side code in any way that you see fit.

Steve "Cutter" Blades
Adobe Community Professional - ColdFusion
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer

Co-Author of "Learning Ext JS"
http://www.packtpub.com/learning-ext-js/book
_
http://blog.cutterscrossing.com



Richard White wrote:
> in fact toJson is even better for th job: http://tojson.riaforge.org/
>
>   
>> thanks, sorry dont think i was clear enough, i knew about 
>> serializejson but this doesnt work with extjs, in case anyone else 
>> stumbles on this post and is interested i found the following: 
>> http://blog.cutterscrossing.com/index.cfm/CFQueryReader 
>>
>> 
>>> Google is your friend:
>>>
>>> Search "cfquery to json" and get:
>>>
>>> http://www.coldfusionjedi.com/index.
>>>   
>> cfm/2007/9/20/Quick-and-Dirty-JSONQuery-Example
>> 
>>>
>>>   
>
>
> 

~|
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:334346
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Programmatic manipulation of DSN settings

2010-06-07 Thread Ian Skinner

On 6/7/2010 11:57 AM, Dave Watts wrote:
> There may even be earlier versions online.
>

There are.  I occasionally have to go back to some 4.5 documentation for 
our ancient servers, that I am counting down the days to when we can 
replace.



~|
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:334345
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RegEx help

2010-06-07 Thread Debbie Morris

I need to extract a particular piece of data from one of my query fields and 
I'm not sure how to go about it.

We have incidents in one table that can have comments in another table 
associated with them.

Here's an example of one of the comments in my query results that I need to 
grab data from:

Case Information   Problem:diff breathing   Patients:1   Four commandment 
Information   Age:2 months   Gender:Female   Conscious:Yes   Brea

I need to get the Age information for any comments that contain it. The Age 
field always begins as shown above and the Gender field always immediately 
follows it, so I'm assuming I can work from that, but I just don't know how to 
go about writing it. Any thoughts would be greatly appreciated!!

Deb 

~|
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:334344
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Programmatic manipulation of DSN settings

2010-06-07 Thread Dave Watts

> Nice is that new to coldfusion 9?

No. As Ian pointed out, it was introduced in CF 7.

But when questions like this come up again, you can always check
directly against the documentation, which is still online for CF 7 to
CF 9. There may even be earlier versions online.

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-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334343
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Programmatic manipulation of DSN settings

2010-06-07 Thread Jake Churchill

No, the admin api has been around for a few releases now

On Mon, Jun 7, 2010 at 1:45 PM, Dan Baughman  wrote:

>
> Nice is that new to coldfusion 9?
>
> On Mon, Jun 7, 2010 at 12:33 PM, Dave Watts  wrote:
>
> >
> > > Can you update, add, and delete datasources via code in ColdFusion?
> >
> > Yes, through the Admin API:
> >
> >
> http://help.adobe.com/en_US/ColdFusion/9.0/Admin/WSc3ff6d0ea77859461172e0811cbf364104-7fcf.html
> >
> > 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-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334342
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


cfchart ignores scalefrom value

2010-06-07 Thread Monte Chan

Hi all,

I have the following codes in my page.

The style variable holds the custom style.

  
 
 

Before I begin, please go to http://www.monteandjanicechan.com/chart_good.jpg. 
This is how I want my report to come up. On the x-axis, there will always be 
three items as long as at least one of them has values. If an item does not 
have any values (i.e. 2010), there would not be a marker in the chart.

The problem occurs only when only one item has value. Please see 
http://www.monteandjanicechan.com/chart_bad.jpg. As you can see, 2008 and 2010 
do not have any values; y-axis is now scaled from 0 to 100. I have tried 
setting one of the items (ex. 2008) a value of 0 or something off the chart; it 
would scale according to this off-the-chart value and the 2009 value. In short, 
I have to have at least two items with values between 20 and 100 in order for 
cfchart to scale from 20 to 100.

My question is, how can I correct the issue so that cfchart would ALWAYS scale 
from 20 to 100? I am running CF9.

Thanks in advance, Monte


~|
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:334341
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Programmatic manipulation of DSN settings

2010-06-07 Thread Ian Skinner

On 6/7/2010 11:45 AM, Dan Baughman wrote:
> Nice is that new to coldfusion 9?
>

ColdFusion 7, IIRC



~|
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:334340
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Programmatic manipulation of DSN settings

2010-06-07 Thread Dan Baughman

Nice is that new to coldfusion 9?

On Mon, Jun 7, 2010 at 12:33 PM, Dave Watts  wrote:

>
> > Can you update, add, and delete datasources via code in ColdFusion?
>
> Yes, through the Admin API:
>
> http://help.adobe.com/en_US/ColdFusion/9.0/Admin/WSc3ff6d0ea77859461172e0811cbf364104-7fcf.html
>
> 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-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334339
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Programmatic manipulation of DSN settings

2010-06-07 Thread Dave Watts

> Can you update, add, and delete datasources via code in ColdFusion?

Yes, through the Admin API:
http://help.adobe.com/en_US/ColdFusion/9.0/Admin/WSc3ff6d0ea77859461172e0811cbf364104-7fcf.html

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-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334338
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Programmatic manipulation of DSN settings

2010-06-07 Thread Dan Baughman

Can you update, add, and delete datasources via code in ColdFusion?


~|
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:334337
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: cfquery to json array

2010-06-07 Thread Richard White

in fact toJson is even better for th job: http://tojson.riaforge.org/

> thanks, sorry dont think i was clear enough, i knew about 
> serializejson but this doesnt work with extjs, in case anyone else 
> stumbles on this post and is interested i found the following: 
> http://blog.cutterscrossing.com/index.cfm/CFQueryReader 
> 
> >Google is your friend:
> >
> >Search "cfquery to json" and get:
> >
> >http://www.coldfusionjedi.com/index.
> cfm/2007/9/20/Quick-and-Dirty-JSONQuery-Example
> >
> >
> >
> >> 


~|
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:334336
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: cfquery to json array

2010-06-07 Thread Richard White

thanks, sorry dont think i was clear enough, i knew about serializejson but 
this doesnt work with extjs, in case anyone else stumbles on this post and is 
interested i found the following: 
http://blog.cutterscrossing.com/index.cfm/CFQueryReader 

>Google is your friend:
>
>Search "cfquery to json" and get:
>
>http://www.coldfusionjedi.com/index.cfm/2007/9/20/Quick-and-Dirty-JSONQuery-Example
>
>
>
>> 

~|
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:334335
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: cfquery to json array

2010-06-07 Thread Michael Grant

Google is your friend:

Search "cfquery to json" and get:

http://www.coldfusionjedi.com/index.cfm/2007/9/20/Quick-and-Dirty-JSONQuery-Example

On Mon, Jun 7, 2010 at 11:53 AM, Richard White  wrote:

>
> hi,
>
> is there a quick and easy way to convert a cfquery into a json array. i
> will be returning the json array to extjs to present in a grid
>
> thanks
>
> 

~|
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:334334
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


cfquery to json array

2010-06-07 Thread Richard White

hi,

is there a quick and easy way to convert a cfquery into a json array. i will be 
returning the json array to extjs to present in a grid

thanks 

~|
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:334333
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm