Re: CFForms/XML format suddenly giving error messages

[Robertson-Ravo, Neil (RX)]

I think it is more a case of how little people use CFFORM anymore, it could
be that it's use in the past was an easy option for forms and a kind of
beginners tool.

I know we never use CFFORM anymore for this reason and we never looked at
x-forms cause we generated most our forms on the fly.

As for Flash forms, urgh...nothing good to say.

:-)

 

 


"This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number 678540.  It contains information which is
confidential and may also be privileged.  It is for the exclusive use of the
intended recipient(s).  If you are not the intended recipient(s) please note
that any form of distribution, copying or use of this communication or the
information in it is strictly prohibited and may be unlawful.  If you have
received this communication in error please return it to the sender or call
our switchboard on +44 (0) 20 89107910.  The opinions expressed within this
communication are not necessarily those expressed by Reed Exhibitions." 
Visit our website at http://www.reedexpo.com

-Original Message-
From: Mike Kear
To: CF-Talk
Sent: Mon Nov 13 05:38:42 2006
Subject: Re: CFForms/XML format suddenly giving error messages

Thanks to Roland Collins on an other list, who pointed me at the solution.

What surprises me most about this is that so few people have tried the
XML forms.  They run FAR faster than the flash versions and are MUCH
more flexible as to look and feel.   However flash is the buzz-word of
the moment and so few people know anything about CSS.  Anyway 

So I'm suddenly getting this problem ...  I think its to do with the
location of the default scripts, css and xsl files.  I have a solution
- kind-of.

I created a folder called CFFORMS under the root of my site and moved
a clean new copy of the /cfide/scripts/CSS folder and
/cfide/scripts/XSL folder in there.  Then I changed the CFFORM tag to
access the skin file directly, rather than by name.  e.g.

Instead of :



I now use




And that seems to have done the trick.   I was trying to change the
scriptsrc attribute to fix the problem,  but instead it was the
location of the skin xsl file that was the problem.


Thanks for your help, Roland.

I'm sorry if this problem has been cross-posted, but  I was having
problems finding anyone who knows anything about XML forms.  If you
haven't played with the XML forms, I strongly suggest you give them a
try - all the validation stuff works as advertised (unlike the clunky
version in CF5).  Rather than waiting for a full minute for a flash
form to render, it renders instantly like html,  you can build them
automatically from a table definition too as I do every day.  They are
the great unsung hero of CF7.



Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks Pty Ltd
http://afpwebworks.com Full Scale ColdFusion hosting from A$15/month



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260144
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CFForms/XML format suddenly giving error messages

[Mike Kear]

Thanks to Roland Collins on an other list, who pointed me at the solution.

What surprises me most about this is that so few people have tried the
XML forms.  They run FAR faster than the flash versions and are MUCH
more flexible as to look and feel.   However flash is the buzz-word of
the moment and so few people know anything about CSS.  Anyway 

So I'm suddenly getting this problem ...  I think its to do with the
location of the default scripts, css and xsl files.  I have a solution
- kind-of.

I created a folder called CFFORMS under the root of my site and moved
a clean new copy of the /cfide/scripts/CSS folder and
/cfide/scripts/XSL folder in there.  Then I changed the CFFORM tag to
access the skin file directly, rather than by name.  e.g.

Instead of :



I now use




And that seems to have done the trick.   I was trying to change the
scriptsrc attribute to fix the problem,  but instead it was the
location of the skin xsl file that was the problem.


Thanks for your help, Roland.

I'm sorry if this problem has been cross-posted, but  I was having
problems finding anyone who knows anything about XML forms.  If you
haven't played with the XML forms, I strongly suggest you give them a
try - all the validation stuff works as advertised (unlike the clunky
version in CF5).  Rather than waiting for a full minute for a flash
form to render, it renders instantly like html,  you can build them
automatically from a table definition too as I do every day.  They are
the great unsung hero of CF7.



Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks Pty Ltd
http://afpwebworks.com Full Scale ColdFusion hosting from A$15/month

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260143
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: How to strip a #

[Kevin Aebig]

Ah... why not just escape it by doubling up?



Cheers,

!k

-Original Message-
From: John Cox [mailto:[EMAIL PROTECTED] 
Sent: Sunday, November 12, 2006 6:51 PM
To: CF-Talk
Subject: How to strip a #

I am trying to strip out a # (pound) from a string.  I would have thought
this would have worked:



That didn't work, as it thought it was a var (missing an argument).  I tried
to escape it:



But that didn't seem to work (i think it is looking for ## at that point).
Any suggestions?




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260142
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: How to strip a #

[Bobby Hartsfield]

3 solutions (including one of your own original ones) work for replacing
#'s. maybe you should take a closer look at the contents of foo?

-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED] 
Sent: Sunday, November 12, 2006 9:36 PM
To: CF-Talk
Subject: RE: How to strip a #

Assuming the Chr(35) is correct for a "#",
how about this...






-Original Message-
From: John Cox [mailto:[EMAIL PROTECTED] 
Sent: Sunday, November 12, 2006 8:13 PM
To: CF-Talk
Subject: Re: How to strip a #

On 11/12/06, Snake <[EMAIL PROTECTED]> wrote:
>
> Try this
> 



hmm, that doesn't work either, seems like it should though.






~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260141
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Source control recommendation

[Qasim Rasheed]

Look at. www.cvsdude.com. I believe they provide SVN + Trac with a backup
every 10 mins.

Thanks,

Qasim

On 11/12/06, Rob Wilkerson <[EMAIL PROTECTED]> wrote:
>
> On 11/12/06, Nick Gleason <[EMAIL PROTECTED]> wrote:
> > Hi there.  We've been hosting our source code in VSS in the past but are
> > considering moving to a new source control system and / or provider.  We
> are
> > basically interested in paying an affordable monthly fee to use a well
> > regarded source control system with an experience host who is diligent
> about
> > nightly backups, maintenance, and so forth.
> >
> > If you have any recommendations for source control systems and even
> > providers that you have been happy with, please let me know.
>
> I can't recommend Subversion enough.  I recently moved my company's
> source code from VSS and couldn't be happier.  I also added Trac for
> documentation and bug tracking with fantastic results.  The latter, of
> course, is optional.  Subversion, and it's convenient integration with
> Ant tasks has made my life a lot easier.
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260140
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CFForms/XML format suddenly giving error messages

[Mike Kear]

Is there no one on this list who uses the XML forms?

I am finding even more broken forms on sites that havent been touched
in months now.   I am wondering if there has been an update to the
java runtime or something like that which has caused this error.

For those who are helpfully suggesting that it's something i might
have done in writing the XML,you should know that the XML is all
written by ColdFusion.   A developer doesnt write any XML in order ot
use teh XML forms.  All you do is use the CFFORM tags with the
format="XML" rather than format="Flash" in the cfform tag.

Suddenly, all of my cfforms that use the XML format are broken, with
the following error message:

[quote]
javax.xml.transform.TransformerConfigurationException:
javax.xml.transform.TransformerException:
org.xml.sax.SAXParseException: Content is not allowed in prolog.
[/quote]


No one got any ideas?


Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260139
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: SQL Server 2005 vs MySQL 5?

[Snake]

To cut your cost for SQL Server find an SPLA partner and pay $10 month
instead.

Russ 

-Original Message-
From: Matthew Chambers [mailto:[EMAIL PROTECTED] 
Sent: 12 November 2006 23:57
To: CF-Talk
Subject: SQL Server 2005 vs MySQL 5?

Hi,

I've been working on a website built using MySQL and have been frustraited
by it on numerious occasions over the past 8 months. Admittedly we are
running v4.1 however because I've got much more experience with SQL Server
(and from what I've read it is the better choice) I'm looking for some
feedback on MySQL 5 vs SQL Server 2005?

Some of my frustrations with MySQL are:
- Only 1 query per 
- Unable to handle complex join queries e.g. I ran a complex query in a
trail version of SQL Server 2000 and it returned in 3 seconds, it took 33
mins in MySQL (this may be becuase we are using a non enterprise version -
are there different versions???)
- The server grinds to a holt with my complex queries which in turn kills
the website. The same thing happens when I try to export a backup of the
entire DB.

I obviously have to justify the cost of SQL Server however would anyone
argue the MySQL 5 enterprise would be better?

By the way, I can't really understand the pricing structures of both
products. We are only using the DB for the website, so does that mean we
only need 1 liecence? If so does that mean I'm correct in saying that MySQL
basic would be $595/year, where as SQL Server 2005 (5-Client) would be $1550
outright? Why does MySQL having an ongoing cost?

Also, can anyone recommend MySQL Silver? Is the enterprise dashboard really
worth it?

Cheers
Matthew



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260138
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Code Question

[Richard Dillman]

I could list a few but these guys did a great job.
http://sniptools.com/tipstricks/speed-up-dreamweaver-mx-some-performance-boosting-tips


On 11/12/06, Dawson, Michael <[EMAIL PROTECTED]> wrote:
>
> Thanks.  I didn't know about the file types tip.  It seems to have
> helped a bit when selecting large amounts of text quickly.
>
> M!ke
>
> -Original Message-
> From: Doug Brown [mailto:[EMAIL PROTECTED]
> Sent: Sunday, November 12, 2006 6:30 PM
> To: CF-Talk
> Subject: Re: Code Question
>
> Damn, I need to go back to school and learn how to spell...or type :)
>
>
>
> D.B.
>
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260137
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: How to strip a #

[Rick Faircloth]

Assuming the Chr(35) is correct for a "#",
how about this...






-Original Message-
From: John Cox [mailto:[EMAIL PROTECTED] 
Sent: Sunday, November 12, 2006 8:13 PM
To: CF-Talk
Subject: Re: How to strip a #

On 11/12/06, Snake <[EMAIL PROTECTED]> wrote:
>
> Try this
> 



hmm, that doesn't work either, seems like it should though.




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260136
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: How to strip a #

[John Cox]

On 11/12/06, Snake <[EMAIL PROTECTED]> wrote:
>
> Try this
> 



hmm, that doesn't work either, seems like it should though.


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260135
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: How to strip a #

[Snake]

Try this

--

Russ Michaels



-Original Message-
From: John Cox [mailto:[EMAIL PROTECTED] 
Sent: 13 November 2006 00:51
To: CF-Talk
Subject: How to strip a #

I am trying to strip out a # (pound) from a string.  I would have thought
this would have worked:



That didn't work, as it thought it was a var (missing an argument).  I tried
to escape it:



But that didn't seem to work (i think it is looking for ## at that point).
Any suggestions?




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260134
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

SQL Server 2005 vs MySQL 5?

[Matthew Chambers]

Hi,

I've been working on a website built using MySQL and have been frustraited by 
it on numerious occasions over the past 8 months. Admittedly we are running 
v4.1 however because I've got much more experience with SQL Server (and from 
what I've read it is the better choice) I'm looking for some feedback on MySQL 
5 vs SQL Server 2005?

Some of my frustrations with MySQL are:
- Only 1 query per 
- Unable to handle complex join queries e.g. I ran a complex query in a trail 
version of SQL Server 2000 and it returned in 3 seconds, it took 33 mins in 
MySQL (this may be becuase we are using a non enterprise version - are there 
different versions???)
- The server grinds to a holt with my complex queries which in turn kills the 
website. The same thing happens when I try to export a backup of the entire DB.

I obviously have to justify the cost of SQL Server however would anyone argue 
the MySQL 5 enterprise would be better?

By the way, I can't really understand the pricing structures of both products. 
We are only using the DB for the website, so does that mean we only need 1 
liecence? If so does that mean I'm correct in saying that MySQL basic would be 
$595/year, where as SQL Server 2005 (5-Client) would be $1550 outright? Why 
does MySQL having an ongoing cost?

Also, can anyone recommend MySQL Silver? Is the enterprise dashboard really 
worth it?

Cheers
Matthew

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260133
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

How to strip a #

[John Cox]

I am trying to strip out a # (pound) from a string.  I would have thought
this would have worked:



That didn't work, as it thought it was a var (missing an argument).  I tried
to escape it:



But that didn't seem to work (i think it is looking for ## at that point).
Any suggestions?


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260132
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Code Question

[Dawson, Michael]

Thanks.  I didn't know about the file types tip.  It seems to have
helped a bit when selecting large amounts of text quickly.

M!ke 

-Original Message-
From: Doug Brown [mailto:[EMAIL PROTECTED] 
Sent: Sunday, November 12, 2006 6:30 PM
To: CF-Talk
Subject: Re: Code Question

Damn, I need to go back to school and learn how to spell...or type :)



D.B.


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260131
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Code Question

[Doug Brown]

Damn, I need to go back to school and learn how to spell...or type :)



D.B.


- Original Message - 
From: "Doug Brown" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Sunday, November 12, 2006 5:25 PM
Subject: Re: Code Question


> Here is a few snippets for forta's website. They deem to work pretty good.
>
> Here's another tip to improve Dreamweaver load time. In Preferences select
> the File Types / Editors screen and add .cfm and .cfc to the Open in Code
> View list. You'll lose support for design view and the Insert bar, but the
> load speed will be much faster. (Applies to: Dreamweaver MX)
>
> When the Dreamweaver Application window is open (particularly with the
> Databases or Component tab selected) Dreamweaver will keep refreshing
window
> content. This can have a real impact on Dreamweaver performance, and so it
> is best to keep the Application window closed when it is not being used.
> (Applies to: Dreamweaver MX)
>
> Suffering from a sluggish Dreamweaver? One quick tip is to turn off
"Refresh
> Local File List Automatically" and "Refresh Remote File List
Automatically"
> in the Site settings. (Applies to: Dreamweaver MX)
>
>
>
>
>
> - Original Message - 
> From: "Dawson, Michael" <[EMAIL PROTECTED]>
> To: "CF-Talk" 
> Sent: Sunday, November 12, 2006 5:02 PM
> Subject: RE: Code Question
>
>
> > "Granted Dreamweaver outa the box is a bit of a resource hog untill you
> > turn off some stuff.  but once ya have it under controll it does
> > everything i need so far."
> >
> > Please elaborate.  I love DW, but it's a big sluggish every now and
> > then.  I'd like to know what you mean by disabling some stuff to improve
> > performance.
> >
> > M!ke
> >
> >
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260130
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Never seen this one...

[Eric Roberts]

Yes...the file is not accessible while it is being overwritten...

Eric 

-Original Message-
From: Will Tomlinson [mailto:[EMAIL PROTECTED] 
Sent: Sunday, 12 November 2006 11:22
To: CF-Talk
Subject: Never seen this one...

I've just never noticed this one before. 

I was uploading an include page that I'd made some changes to, and I hit the
site while the file was uploading. 

I got this:
Diagnostics Could not find the included template includes/footer.cfm.  

Well, the file was there. I was just uploading a fresh one. Is this normal? 

Thanks,
Will



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260129
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Code Question

[Doug Brown]

Here is a few snippets for forta's website. They deem to work pretty good.

Here's another tip to improve Dreamweaver load time. In Preferences select
the File Types / Editors screen and add .cfm and .cfc to the Open in Code
View list. You'll lose support for design view and the Insert bar, but the
load speed will be much faster. (Applies to: Dreamweaver MX)

When the Dreamweaver Application window is open (particularly with the
Databases or Component tab selected) Dreamweaver will keep refreshing window
content. This can have a real impact on Dreamweaver performance, and so it
is best to keep the Application window closed when it is not being used.
(Applies to: Dreamweaver MX)

Suffering from a sluggish Dreamweaver? One quick tip is to turn off "Refresh
Local File List Automatically" and "Refresh Remote File List Automatically"
in the Site settings. (Applies to: Dreamweaver MX)





- Original Message - 
From: "Dawson, Michael" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Sunday, November 12, 2006 5:02 PM
Subject: RE: Code Question


> "Granted Dreamweaver outa the box is a bit of a resource hog untill you
> turn off some stuff.  but once ya have it under controll it does
> everything i need so far."
>
> Please elaborate.  I love DW, but it's a big sluggish every now and
> then.  I'd like to know what you mean by disabling some stuff to improve
> performance.
>
> M!ke
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260128
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Code Question

[Dawson, Michael]

"Granted Dreamweaver outa the box is a bit of a resource hog untill you
turn off some stuff.  but once ya have it under controll it does
everything i need so far."

Please elaborate.  I love DW, but it's a big sluggish every now and
then.  I'd like to know what you mean by disabling some stuff to improve
performance.

M!ke

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260127
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: GetTempDirectory & CFFILE

[Snake]

There is no automatic process I am aware of, if you don't move it, it will
stay there.

Russ 

-Original Message-
From: Ken [mailto:[EMAIL PROTECTED] 
Sent: 12 November 2006 23:00
To: CF-Talk
Subject: Re: GetTempDirectory & CFFILE

Thanks Russ,
However, my situation is a bit different. I am using the temp directory as
the destination. Once the file is uploaded, I give the user different
options to do with the file. But I want to remove the file once the user has
exit.
My question again is:
Is there a Cold Fusion process that automatically deletes the temp files in
the temp directory after a certain time period? I am using CF MX 7. OR, do I
have to writing something to clean out the temp directory?

Thanks.

On 11/12/06, Snake <[EMAIL PROTECTED]> wrote:
> Once a file is moved to your destination folder using CFFILE afte rthe 
> upload, it is deleted from the temp folder.
>
> Russ
>
> -Original Message-
> From: Ken [mailto:[EMAIL PROTECTED]
> Sent: 12 November 2006 22:42
> To: CF-Talk
> Subject: GetTempDirectory & CFFILE
>
> I am using GetTempDirectory() & CFFILE to upload files to a server 
> into the TempDIrectory.
>
> My question... Is there a Cold Fusion process that automatically 
> deletes the temp files in the temp directory after a certain time 
> period? I am using CF MX 7.
>
> OR, do you have to writing something yourself to clean out the temp 
> directory?
>
>
> Thanks,
> Ken
>
>
>
> 



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260126
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CFForms/XML format suddenly giving error messages

[Mike Kear]

Thanks Will,

The puzzle is that i dont use a XML file on this site, although i use
it elsewhere on other sites.   The XML is purely the ColdFusion
generated stuff wtih the CFFORMs.  (well except that it can't be
because it's giving this error).

Can anyone zip up their CFIDE/Scripts folder and send it to me please,
so i know i'm using a pristine, out-of-the-box set?  I've tinkered
around so much now I'm not sure i have a pure set any more.

What i need are the cfide/scripts,  cfide/scripts/css and
cfide/scripts/xsl folders.  That way i can compare the out-of-the-box
files with the ones i have.  The differences must be the cause. I
would surmise.

Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month



On 11/13/06, Will Tomlinson <[EMAIL PROTECTED]> wrote:
> Mike,
>
> 1. I love X-Forms just as much as you. :)
>
> 2. The only time I've seen "content is not allowed in prolog" is when I was 
> trying to read/load application settings from an xml config file. If I had 
> the path wrong to my xml file, I got that prolog error everytime.
>
> Maybe something changed on your server where the xml can't be read?
>
> Just a guess...
>
> Will
>

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260125
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Question regarding my first consulting job

[Peterson, Chris]

Mark,

I am in Michigan.  What rate would you think is more appropriate?

Also, do you have any advice as to accounting for hours? Should I use 1/2 hour 
increments or 15 minute?

Thanks a ton for your reply!

Chris


-Original Message-
From: Mark Leder [mailto:[EMAIL PROTECTED]
Sent: Sun 11/12/2006 6:38 PM
To: CF-Talk
Subject: RE: Question regarding my first consulting job
 
 
>> Rate?  I am thinking of charging $60 / hour for development
Depends where you are.  $60 is too low in my estimation, if you're in the
US.

>> Should I ask for 20% ahead of time, or just wait till completion for
payment?
Get minimum 50% up front before you move a mouse.  This keeps people from
pulling the plug without you getting paid for work already completed.

>> Should I setup a visual structure first
Yes, mapping the business process first is always a good idea - clarifies
everyone's thinking and eliminates a bunch of rewrites.

>> convert his access DB to SQL?
Absolutely, get it out of Access and into a relational db.


Thanks,
Mark





~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260124
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Code Question

[Bobby Hartsfield]

I rarely take my hands off the keyboard anymore either and for all of you
shortcut / snippet / macro junkies out there like me... I absolutely love
this keyboard and you probably would too.

1) 18 macro keys under 3 profiles = 64 shortcut/macros/hotkeys
2) LCD to read sender and subject of a pop3 account
3) LCD also has a stopwatch on it (2 actually) that keeps track of hours
rather well :-)

The quick keys can be set to macros (their definition of macros is simply
recorded keystrokes) or to any single keystroke, or to any file/dir/app
shortcut you want.

http://www.logitech.com/index.cfm/products/details/US/EN,CRID=2166,CONTENTID
=10717

It's wired (USB only) but w worth the price. It saves me a ton of
time everyday.

no I don’t work for or have stock in Logitech.






-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.430 / Virus Database: 268.14.3/530 - Release Date: 11/11/2006
6:53 PM
 



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260123
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Question regarding my first consulting job

[Mark Leder]

 
>> Rate?  I am thinking of charging $60 / hour for development
Depends where you are.  $60 is too low in my estimation, if you're in the
US.

>> Should I ask for 20% ahead of time, or just wait till completion for
payment?
Get minimum 50% up front before you move a mouse.  This keeps people from
pulling the plug without you getting paid for work already completed.

>> Should I setup a visual structure first
Yes, mapping the business process first is always a good idea - clarifies
everyone's thinking and eliminates a bunch of rewrites.

>> convert his access DB to SQL?
Absolutely, get it out of Access and into a relational db.


Thanks,
Mark



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260122
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Question regarding my first consulting job

[Peterson, Chris]

 



From: Ken [mailto:[EMAIL PROTECTED]
Sent: Sun 11/12/2006 5:59 PM
To: CF-Talk
Subject: Re: GetTempDirectory & CFFILE



 just looking for some advice regarding my first consulting job. A guy I used 
to work with at my current job now needs some CF help.  It involved re-writing 
his current maintenance database (access DB and a 'guy who knows some CF')  I 
have a public co-hosted server, so I can put development work online.  I'm 
thinking of setting up a subversion server to keep all my code history, and 
getting my home system setup for local development.  I just have a few 
questions to anyone else doing consulting:

a) Rate?  I am thinking of charging $60 / hour for development, but I'm really 
not sure. Will that hamper me later if I need to raise it?  Is it too cheap, or 
too much?  I have been doing development now for going on 5 years internally on 
intranet type apps, and I feel very comfortable doing what my customer is 
requesting.

b) Anyone have quote / invoice templates that look nice?  I dont have a company 
name really, should I come up with something or just put my name on it?

c) How should I structure payment?  Should I ask for 20% ahead of time, or just 
wait till completion for payment?

d) The customer has had this job on hold (from internal requests) since July 
2005.  How should I structure development?  He has expressed an interest in 
having the whole thing re-written, as there are many cumbersom things in it 
(many clicks to do simple things)  Should I setup a visual structure first, 
convert his access DB to SQL?

e) Any advice you can give me on getting started with this would be greatly 
aprpeciated!

 

Chris



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260121
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

OT: State / County / City Tax Database?

[Ben Koshy]

I've been researching and just want to get some opinions from the
user-ship here about who some of you might use to get a USA
State/County/City/Zip Tax Database... Commercial solutions are ok with
$2000 max budget and preferably a low yearly update.


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260120
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: cfhttp QUESTION

[Denny Valliant]

On 11/8/06, Robert Harrison <[EMAIL PROTECTED]> wrote:
> Now I'm canning the EXCEL COM object and using CFHTTP to parse a comma
> delimited format. This works fine when the data is perfect. But when this
> data is missing a column from a row and doen't have the right number of
> columns it says wrong number of rows and craps out.

Sorry, been busy staging a picture for Bobby, with me holding a wooden
table over my head, pretending to smash down on the camera. =-P

I've got some code that uses the JExcelAPI to import/export excel
files.  I already
tackled all the issues with not the same number of cols, etc., along
with a little
date conversion and some other little tweaks.  JExcelAPI roxerz!

I'll post a link, if I think about it, as I've got it in google code
somewhere... I may
have posted a link already, not too sure.

You'd need createobject permission, if you're on a shared server.

Ping me off list if you're still looking for a excel solution- I'm
busy and haven't been
watching cf-talk too close.
-D

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260119
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: GetTempDirectory & CFFILE

[Ken]

Thanks Russ,
However, my situation is a bit different. I am using the temp
directory as the destination. Once the file is uploaded, I give the
user different options to do with the file. But I want to remove the
file once the user has exit.
My question again is:
Is there a Cold Fusion process that automatically deletes the
temp files in the temp directory after a certain time period? I am using CF
MX 7. OR, do I have to writing something to clean out the temp
directory?

Thanks.

On 11/12/06, Snake <[EMAIL PROTECTED]> wrote:
> Once a file is moved to your destination folder using CFFILE afte rthe
> upload, it is deleted from the temp folder.
>
> Russ
>
> -Original Message-
> From: Ken [mailto:[EMAIL PROTECTED]
> Sent: 12 November 2006 22:42
> To: CF-Talk
> Subject: GetTempDirectory & CFFILE
>
> I am using GetTempDirectory() & CFFILE to upload files to a server into the
> TempDIrectory.
>
> My question... Is there a Cold Fusion process that automatically deletes the
> temp files in the temp directory after a certain time period? I am using CF
> MX 7.
>
> OR, do you have to writing something yourself to clean out the temp
> directory?
>
>
> Thanks,
> Ken
>
>
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260118
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: GetTempDirectory & CFFILE

[Snake]

Once a file is moved to your destination folder using CFFILE afte rthe
upload, it is deleted from the temp folder.

Russ 

-Original Message-
From: Ken [mailto:[EMAIL PROTECTED] 
Sent: 12 November 2006 22:42
To: CF-Talk
Subject: GetTempDirectory & CFFILE

I am using GetTempDirectory() & CFFILE to upload files to a server into the
TempDIrectory.

My question... Is there a Cold Fusion process that automatically deletes the
temp files in the temp directory after a certain time period? I am using CF
MX 7.

OR, do you have to writing something yourself to clean out the temp
directory?


Thanks,
Ken



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260117
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

GetTempDirectory & CFFILE

[Ken]

I am using GetTempDirectory() & CFFILE to upload files to a server into the
TempDIrectory.

My question... Is there a Cold Fusion process that automatically deletes the
temp files in the temp directory after a certain time period? I am
using CF MX 7.

OR, do you have to writing something yourself to clean out the temp directory?


Thanks,
Ken

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260116
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Code Question

[Richard Dillman]

Just off hand what is the advantage of CFEclipse?  I can make easy shortcuts
in dreamweaver for nearly anything like
*ctrl+Q* to insert:


  Select *
  from [Table]
  Where (0=0)


Or is there a conversation we've already had you all can point me too?

Granted Dreamweaver outa the box is a bit of a resource hog untill you turn
off some stuff.  but once ya have it under controll it does everything i
need so far.


On 11/12/06, Rob Wilkerson <[EMAIL PROTECTED]> wrote:
>
> On 11/12/06, Rick Root <[EMAIL PROTECTED]> wrote:
> > Rob Wilkerson wrote:
> > >
> > > I don't understand why the use of keyboard shortcuts is hindering your
> > > adoption of CFEclipse.  I'm also a keyboard shortcut junkie and
> > > CF/Eclipse offers me every bit of functionality I could ask for.  And
> > > it's just as configurable.  There may some shortcuts that are not
> > > available and/or some that are available that weren't in Homesite+,
> > > but on the whole I've been extremely happy with those
> > > offered/available in CF/Eclipse.
> >
> > The keyboard shortcut issue is really just part of it.  I have a problem
> > going between the "project" based structure of eclipse and the file
> > based structure of homesite.
>
> Yeah, that still bothers me from time to time.  It's definitely an
> adjustment, but I've learned to handle it okay.  And it even offers a
> few advantages that are occasionally helpful.
>
> > I also don't like the way ctrl-tab works
> > in cfeclipse.  I find myself using Homesite's extended find and extended
> > find/replace feature *ALL* the time.  I'm not even sure cfeclipse has
> > that kind of functionality.
>
> Ctrl+H provides that option with even more capability.  Search a
> resource, a project or a workspace.  Pretty flexible.  Plus regex
> search and replace.  Someone mentioned that HS+ offered that, but I
> had never realized it.
>
> > I'm sure it's mostly just a learning curve thing.  I know I *SHOULD* be
> > using cfeclipse, and I'm getting closer (because I essentially *MUST*
> > use eclipse for flex apps)..
>
> I'm not sure it's a normative question like that.  Should or shouldn't
> isn't really an issue when you have options.  Whatever works for you
> is what you should be using.  I switched primarily because I wanted to
> use the same IDE in my windows, linux and mac desktop environments.
> Otherwise, HS+ was meeting all of my needs.
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260115
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Code Question

[Snake]

Shame u weren't at CFDEVCON, Mark did a good talk on Cfeclipse and showed
everyone how to use it.

http://russ.michaels.me.uk/index.cfm/2006/11/11/CFDevCon-2006-Big-success

Russ

-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED] 
Sent: 12 November 2006 19:53
To: CF-Talk
Subject: Re: Code Question

Rob Wilkerson wrote:
> 
> I don't understand why the use of keyboard shortcuts is hindering your 
> adoption of CFEclipse.  I'm also a keyboard shortcut junkie and 
> CF/Eclipse offers me every bit of functionality I could ask for.  And 
> it's just as configurable.  There may some shortcuts that are not 
> available and/or some that are available that weren't in Homesite+, 
> but on the whole I've been extremely happy with those 
> offered/available in CF/Eclipse.

The keyboard shortcut issue is really just part of it.  I have a problem
going between the "project" based structure of eclipse and the file based
structure of homesite.  I also don't like the way ctrl-tab works in
cfeclipse.  I find myself using Homesite's extended find and extended
find/replace feature *ALL* the time.  I'm not even sure cfeclipse has that
kind of functionality.

I'm sure it's mostly just a learning curve thing.  I know I *SHOULD* be
using cfeclipse, and I'm getting closer (because I essentially *MUST* use
eclipse for flex apps)..

Rick



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260114
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: ColdFusion Time Out Error....HELP!!!!!

[Dan Plesse]

Well that could be it. Also increase the size of the pool.

On 11/12/06, Russell Christiansen <[EMAIL PROTECTED]> wrote:
>
> Yes I do.
>
> >>>Timed out trying to establish connection
> >
> >Do you have the "Maintain Connections" parameter checked for this
> datasource
> >in the CF administrator?
> >
> >--
> >___
> >REUSE CODE! Use custom tags;
> >See http://www.contentbox.com/claude/customtags/tagstore.cfm
> >(Please send any spam to this address: [EMAIL PROTECTED])
> >Thanks.
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260113
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Code Question

[Rob Wilkerson]

On 11/12/06, Rick Root <[EMAIL PROTECTED]> wrote:
> Rob Wilkerson wrote:
> >
> > I don't understand why the use of keyboard shortcuts is hindering your
> > adoption of CFEclipse.  I'm also a keyboard shortcut junkie and
> > CF/Eclipse offers me every bit of functionality I could ask for.  And
> > it's just as configurable.  There may some shortcuts that are not
> > available and/or some that are available that weren't in Homesite+,
> > but on the whole I've been extremely happy with those
> > offered/available in CF/Eclipse.
>
> The keyboard shortcut issue is really just part of it.  I have a problem
> going between the "project" based structure of eclipse and the file
> based structure of homesite.

Yeah, that still bothers me from time to time.  It's definitely an
adjustment, but I've learned to handle it okay.  And it even offers a
few advantages that are occasionally helpful.

> I also don't like the way ctrl-tab works
> in cfeclipse.  I find myself using Homesite's extended find and extended
> find/replace feature *ALL* the time.  I'm not even sure cfeclipse has
> that kind of functionality.

Ctrl+H provides that option with even more capability.  Search a
resource, a project or a workspace.  Pretty flexible.  Plus regex
search and replace.  Someone mentioned that HS+ offered that, but I
had never realized it.

> I'm sure it's mostly just a learning curve thing.  I know I *SHOULD* be
> using cfeclipse, and I'm getting closer (because I essentially *MUST*
> use eclipse for flex apps)..

I'm not sure it's a normative question like that.  Should or shouldn't
isn't really an issue when you have options.  Whatever works for you
is what you should be using.  I switched primarily because I wanted to
use the same IDE in my windows, linux and mac desktop environments.
Otherwise, HS+ was meeting all of my needs.

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260112
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Next/Previous Records with UUID

[Dan Plesse]

Sure you can go up down and all over the place without a primary key. The
cfquery object comes packed with a host of features and is the most feature
rich object of the whole coldfusion arsenal. Mastery of this object is
fundamental to understanding coldfusion. You can get record position using
any data inside a row or jump relative to that row.

goto this link
http://tech.groups.yahoo.com/group/java_coldfusion_hacks/

search for 1.next() or 2.cfquery


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260111
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Never seen this one...

[Claude Schneegans]

 >>Well, the file was there. I was just uploading a fresh one. Is this 
normal?

It was there, but temporarily locked by the transfer program (FTP?) 
while it was writing it.
The message "could not OPEN the included file" would be more appropriate 
in that case.

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260110
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Never seen this one...

[Rick Root]

Will Tomlinson wrote:
> I've just never noticed this one before. 
> 
> I was uploading an include page that I'd made some changes to, and I hit the 
> site while the file was uploading. 
> 
> I got this:
> Diagnostics Could not find the included template includes/footer.cfm.  

I also have seen this before.. I've also gotten erros for including a 
template with 0 length, I think, during an upload.

Rick


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260109
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Code Question

[Rick Root]

Rob Wilkerson wrote:
> 
> I don't understand why the use of keyboard shortcuts is hindering your
> adoption of CFEclipse.  I'm also a keyboard shortcut junkie and
> CF/Eclipse offers me every bit of functionality I could ask for.  And
> it's just as configurable.  There may some shortcuts that are not
> available and/or some that are available that weren't in Homesite+,
> but on the whole I've been extremely happy with those
> offered/available in CF/Eclipse.

The keyboard shortcut issue is really just part of it.  I have a problem 
going between the "project" based structure of eclipse and the file 
based structure of homesite.  I also don't like the way ctrl-tab works 
in cfeclipse.  I find myself using Homesite's extended find and extended 
find/replace feature *ALL* the time.  I'm not even sure cfeclipse has 
that kind of functionality.

I'm sure it's mostly just a learning curve thing.  I know I *SHOULD* be 
using cfeclipse, and I'm getting closer (because I essentially *MUST* 
use eclipse for flex apps)..

Rick

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260108
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: ColdFusion Time Out Error....HELP!!!!!

[Russell Christiansen]

Yes I do.

>>>Timed out trying to establish connection
>
>Do you have the "Maintain Connections" parameter checked for this datasource
>in the CF administrator?
>
>-- 
>___
>REUSE CODE! Use custom tags;
>See http://www.contentbox.com/claude/customtags/tagstore.cfm
>(Please send any spam to this address: [EMAIL PROTECTED])
>Thanks.

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260107
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: ColdFusion Time Out Error....HELP!!!!!

[Dan Plesse]

Whoops that should say "I would say its not the database at all and its a
pooled connection error."


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260106
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: ColdFusion Time Out Error....HELP!!!!!

[Dan Plesse]

I would its' not its the database at all. Its between the database and
coldfusion is where the problem is happening. Deep inside
the JDBC pool as the error message clearly states. Sometimes error messages
do tell the truth. Maintain Connections could be
the problem. Sometimes its just better to allow the pool to do its work. The
pool is just like a swimming pool and the water gets
dirty and you need to start over with a fresh pool of water. This is an area
CF 8 needs and needs badly is a way to view pooled conections and see if the
connections are hanging around and not getting recycled as quickly as
needed. And if each new connection gets blocked because backlog it will
timeout. You can add proprieties to the JDBC string or add a proprieties
file for
CF to pickup or increase pooled connection size. Maybe then CF will time to
recycle.


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260105
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: cfeclipse .project file

[Dan Vega]

That was exactly what I was looking for, thanks!

On 11/12/06, Big Mad Kev <[EMAIL PROTECTED]> wrote:
>
> Dan,
>
> Just below the navigator tab to the right there is an arrow pointing down
> click that and select filters then select .* to hide them
>
> HTH
>
> -Original Message-
> From: Dan Vega [mailto:[EMAIL PROTECTED]
> Sent: 12 November 2006 17:23
> To: CF-Talk
> Subject: cfeclipse .project file
>
> Any cfeclipse users out there? I want to hide certain files from view in
> my
> project such as the .project file. Is there a way to hide certain files?
>
> --
> Thank You
> Dan Vega
> [EMAIL PROTECTED]
> http://www.danvega.org
>
>
>
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260104
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CF Project Management Tool - free

[Mark Phillips]

Try Vertabase Pro (disclaimer, I work for them) http://www.vertabase.com.  

Its not free but is a popular CF project management app -was voted a finalist 
as best Web App and best eBusiness Software in CF Journal's readers' choice 
awards.


>I'm looking for a FREE cold fusion built Web project management application.
>
>We don't want an outside Web based solution
>
>We want  ...
>
>For Internal Client
>* login (optional)
>* An internal client submits projects
>* Uploads assets
>* Edit existing projects
>* Share invite people to contribute to a project
>* View all our projects and see where there's is in a timeline
>
>For Web team
>* Make requests for more info on a project
>* Push one poject out a day and other adjust automatically
>* Notify client of timeline change, need for more info
>* Reports
>
>Thanks.
>
>D

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260103
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: cffile question

[Bob Imperial]

Thanks Jon!

Using html tags in the output for the read works fine for me, guess I should
have thought a little more about the specific tag I was having trouble with.
Is it possible to include html tags in the output field for the write? I've
tried several ways/locations within the output for the write to no avail. Is
what I am trying to do even possible? I am emailing a link to the index page
and I'm trying to simply center the output there.

TIA Bob


> file="#BaseDir#\index.cfm"
>  output="Website directories were created successfully on 
> #DateFormat(CreateODBCDate(myDate), " d,  hh:mm:ss")#">


>   variable="confirmation">
>  
>   #HTMLCodeFormat(confirmation)#
>  

You can put any HTML tags into your output, but you may need to escape any
CFML tags in the input by using #chr(60)# for "<" and #chr (62)# for ">" 




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260102
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Next/Previous Records with UUID

[Mark Flewellen]

Anyone got any ideas on next records when using UUID's?

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260101
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Never seen this one...

[Robertson-Ravo, Neil (RX)]

Yep, seen this loads of time when the page has not finished uploaded.. 




"This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number 678540.  It contains information which is
confidential and may also be privileged.  It is for the exclusive use of the
intended recipient(s).  If you are not the intended recipient(s) please note
that any form of distribution, copying or use of this communication or the
information in it is strictly prohibited and may be unlawful.  If you have
received this communication in error please return it to the sender or call
our switchboard on +44 (0) 20 89107910.  The opinions expressed within this
communication are not necessarily those expressed by Reed Exhibitions." 
Visit our website at http://www.reedexpo.com

-Original Message-
From: Will Tomlinson
To: CF-Talk
Sent: Sun Nov 12 17:22:05 2006
Subject: Never seen this one...

I've just never noticed this one before. 

I was uploading an include page that I'd made some changes to, and I hit the
site while the file was uploading. 

I got this:
Diagnostics Could not find the included template includes/footer.cfm.  

Well, the file was there. I was just uploading a fresh one. Is this normal? 

Thanks,
Will



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260100
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Never seen this one...

[Dawson, Michael]

I've seen this before when trying to access a page that is still
"in-transit" to the server.  I learned to wait a few moments when
sending via a VPN or FTP.

M!ke

-Original Message-
From: Will Tomlinson [mailto:[EMAIL PROTECTED] 
Sent: Sunday, November 12, 2006 11:22 AM
To: CF-Talk
Subject: Never seen this one...

I've just never noticed this one before. 

I was uploading an include page that I'd made some changes to, and I hit
the site while the file was uploading. 

I got this:
Diagnostics Could not find the included template includes/footer.cfm.  

Well, the file was there. I was just uploading a fresh one. Is this
normal? 

Thanks,
Will

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260099
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Never seen this one...

[Will Tomlinson]

I've just never noticed this one before. 

I was uploading an include page that I'd made some changes to, and I hit the 
site while the file was uploading. 

I got this:
Diagnostics Could not find the included template includes/footer.cfm.  

Well, the file was there. I was just uploading a fresh one. Is this normal? 

Thanks,
Will

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260098
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Code Question

[Rob Wilkerson]

On 11/12/06, Rick Root <[EMAIL PROTECTED]> wrote:
> Robertson-Ravo, Neil (RX) wrote:
> > I don't really use keyboard shortcuts other than ctrl-s, x, v, and c.
>
>
> I even use alt keys to access menu items... ALT-F, O to open files..
> ALT-S,E for Extended Find/Replace (which can also be accessed via
> SHIFT-CTRL-R).. etc
>
> i make extensive use of ALT-TAB and SHIFT-TAB, I usually use the windows
> start key and the arrow keys to access stuff in the start menu (well, at
> least for start->run and shut down)
>
> And to send this message, I'll hit CTRL-RETURN.

I don't understand why the use of keyboard shortcuts is hindering your
adoption of CFEclipse.  I'm also a keyboard shortcut junkie and
CF/Eclipse offers me every bit of functionality I could ask for.  And
it's just as configurable.  There may some shortcuts that are not
available and/or some that are available that weren't in Homesite+,
but on the whole I've been extremely happy with those
offered/available in CF/Eclipse.

There may be other reasons for not adopting Eclipse, but if this is
the only one or even the primary one then it may be worth another
look.

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260097
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: cfeclipse .project file

[Big Mad Kev]

Dan,

Just below the navigator tab to the right there is an arrow pointing down
click that and select filters then select .* to hide them 

HTH

-Original Message-
From: Dan Vega [mailto:[EMAIL PROTECTED] 
Sent: 12 November 2006 17:23
To: CF-Talk
Subject: cfeclipse .project file

Any cfeclipse users out there? I want to hide certain files from view in my
project such as the .project file. Is there a way to hide certain files?

-- 
Thank You
Dan Vega
[EMAIL PROTECTED]
http://www.danvega.org




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260096
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Source control recommendation

[Rob Wilkerson]

On 11/12/06, Nick Gleason <[EMAIL PROTECTED]> wrote:
> Hi there.  We've been hosting our source code in VSS in the past but are
> considering moving to a new source control system and / or provider.  We are
> basically interested in paying an affordable monthly fee to use a well
> regarded source control system with an experience host who is diligent about
> nightly backups, maintenance, and so forth.
>
> If you have any recommendations for source control systems and even
> providers that you have been happy with, please let me know.

I can't recommend Subversion enough.  I recently moved my company's
source code from VSS and couldn't be happier.  I also added Trac for
documentation and bug tracking with fantastic results.  The latter, of
course, is optional.  Subversion, and it's convenient integration with
Ant tasks has made my life a lot easier.

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260095
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: cffile question

[Bob Imperial]

Thank you Rick!! 

I think the light maybe coming on here lately ;-). I think I've done about
all I can do with being self taught for the most part and trying to figure
it all out by myself ;-), coming out of the shadows and asking questions
here after I've exhausted trying everything my little brain can come up with
is definitely helping things to click for me.

Bob

-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED] 
Sent: Sunday, November 12, 2006 12:39 PM
To: CF-Talk
Subject: Re: cffile question

Jon Clausen wrote:
> On Nov 12, 2006, at 11:57 AM, Bob Imperial wrote:
> 
>> 1.)In outputting my datetime here, how would I go about adding the 
>> AM/PM designation for output?
>>
>>   
>>   >  file="#BaseDir#\index.cfm"
>>  output="Website directories were created successfully on 
>> #DateFormat(CreateODBCDate(myDate), " d,  hh:mm:ss")#">
> 
> #DateFormat(createODBCDateTime(myDate), " dd, ")# #TimeFormat 
> (createODBCDateTime(myDate),"hh:mm:ss tt")#
> 
> ("tt" does not work in the DateFormat() function )

FYI, there is absolutely no need to use createODBCDateTime() here

If "myDate" is already a date, then you can just pass IT to date format. 
  The only purpose of createODBCDateTime() is if you're putting a date time
object in a query and you're *NOT* using CFQUERYPARAM.

so above, you'd be just fine with:

#DateFormat(myDate, " dd, ")# #TimeFormat(myDate,"hh:mm:ss tt")#

Rick



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260094
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CFForms/XML format suddenly giving error messages

[Rob Wilkerson]

On 11/12/06, Mike Kear <[EMAIL PROTECTED]> wrote:

> [quote]
> javax.xml.transform.TransformerConfigurationException:
> javax.xml.transform.TransformerException:
> org.xml.sax.SAXParseException: Content is not allowed in prolog.
> [/quote]
>
> I've checked all the obvious things - looked for files that have
> changed as the possible cause of the issue,  configuratoin changes in
> the site etc  and nothing on the site has changes in a way that might
> cause this.

This error is typically seen when text, whitespace or control
characters precede the XML declaration.  I don't know how this is
applied in forms, exactly, but I can think of at least one thing to
look for.

If you have a DevNet edition of ColdFusion then look for the existence
of a  tag telling you just that.  It is inserted by the
application server and has a nasty habit of breaking XML because of
where it's inserted: if there's a  element then it's appended to
that, but if there's not - as is the case for most XML docs - then
it's just inserted at the top of the file.

Maybe that's coming into play...

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260093
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: cffile question

[Bob Imperial]

Thanks Doug! Had to be that simple eh ;-) 

-Original Message-
From: Doug Brown [mailto:[EMAIL PROTECTED] 
Sent: Sunday, November 12, 2006 12:38 PM
To: CF-Talk
Subject: Re: cffile question

 
  


Doug



- Original Message -
From: "Bob Imperial" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Sunday, November 12, 2006 9:57 AM
Subject: cffile question


> Hi Folks.
>
> while I realize this a question for the cf_newbie list, the response times
> here are always much faster here. First off, thank you Michael D. for your
> response on cf_newbie in regards to my question about cfdirectory. I am
> still working on the basics with many things cf, another being cffile and
> the "write" action and what the limitations are as to what can be put into
> the output. I have a bit of code that creates a few directories and then
> writes and index page with a short message and datetime stamp. Here's what
> I'm using so far after my directories are created.
>
>
> 1.)In outputting my datetime here, how would I go about adding the AM/PM
> designation for output?
>
>   
> file="#BaseDir#\index.cfm"
>  output="Website directories were created successfully on
> #DateFormat(CreateODBCDate(myDate), " d,  hh:mm:ss")#">
>
> OK, here's the simpleton question, can I put any html tags in the output
> above or into the output below? I'd like to put this in a div centered on
> the page.
>
>
>  
>  
>   #HTMLCodeFormat(confirmation)#
>  
>
> TIA ... Bob
>
>
> 



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260092
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: cffile question

[Rick Root]

Jon Clausen wrote:
> On Nov 12, 2006, at 11:57 AM, Bob Imperial wrote:
> 
>> 1.)In outputting my datetime here, how would I go about adding the  
>> AM/PM
>> designation for output?
>>
>>   
>>   >  file="#BaseDir#\index.cfm"
>>  output="Website directories were created successfully on
>> #DateFormat(CreateODBCDate(myDate), " d,  hh:mm:ss")#">
> 
> #DateFormat(createODBCDateTime(myDate), " dd, ")# #TimeFormat 
> (createODBCDateTime(myDate),"hh:mm:ss tt")#
> 
> ("tt" does not work in the DateFormat() function )

FYI, there is absolutely no need to use createODBCDateTime() here

If "myDate" is already a date, then you can just pass IT to date format. 
  The only purpose of createODBCDateTime() is if you're putting a date 
time object in a query and you're *NOT* using CFQUERYPARAM.

so above, you'd be just fine with:

#DateFormat(myDate, " dd, ")# #TimeFormat(myDate,"hh:mm:ss tt")#

Rick

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260091
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: cffile question

[Doug Brown]

 
  


Doug



- Original Message - 
From: "Bob Imperial" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Sunday, November 12, 2006 9:57 AM
Subject: cffile question


> Hi Folks.
>
> while I realize this a question for the cf_newbie list, the response times
> here are always much faster here. First off, thank you Michael D. for your
> response on cf_newbie in regards to my question about cfdirectory. I am
> still working on the basics with many things cf, another being cffile and
> the "write" action and what the limitations are as to what can be put into
> the output. I have a bit of code that creates a few directories and then
> writes and index page with a short message and datetime stamp. Here's what
> I'm using so far after my directories are created.
>
>
> 1.)In outputting my datetime here, how would I go about adding the AM/PM
> designation for output?
>
>   
> file="#BaseDir#\index.cfm"
>  output="Website directories were created successfully on
> #DateFormat(CreateODBCDate(myDate), " d,  hh:mm:ss")#">
>
> OK, here's the simpleton question, can I put any html tags in the output
> above or into the output below? I'd like to put this in a div centered on
> the page.
>
>
>  
>  
>   #HTMLCodeFormat(confirmation)#
>  
>
> TIA ... Bob
>
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260090
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CFForms/XML format suddenly giving error messages

[Will Tomlinson]

Mike,

1. I love X-Forms just as much as you. :)

2. The only time I've seen "content is not allowed in prolog" is when I was 
trying to read/load application settings from an xml config file. If I had the 
path wrong to my xml file, I got that prolog error everytime. 

Maybe something changed on your server where the xml can't be read? 

Just a guess...

Will

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260089
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Code Question

[Robertson-Ravo, Neil (RX)]

Brilliant... It's like magic..






"This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number 678540.  It contains information which is
confidential and may also be privileged.  It is for the exclusive use of the
intended recipient(s).  If you are not the intended recipient(s) please note
that any form of distribution, copying or use of this communication or the
information in it is strictly prohibited and may be unlawful.  If you have
received this communication in error please return it to the sender or call
our switchboard on +44 (0) 20 89107910.  The opinions expressed within this
communication are not necessarily those expressed by Reed Exhibitions." 
Visit our website at http://www.reedexpo.com

-Original Message-
From: Rick Root
To: CF-Talk
Sent: Sun Nov 12 17:34:22 2006
Subject: Re: Code Question

Robertson-Ravo, Neil (RX) wrote:
> I don't really use keyboard shortcuts other than ctrl-s, x, v, and c.


I even use alt keys to access menu items... ALT-F, O to open files.. 
ALT-S,E for Extended Find/Replace (which can also be accessed via 
SHIFT-CTRL-R).. etc

i make extensive use of ALT-TAB and SHIFT-TAB, I usually use the windows 
start key and the arrow keys to access stuff in the start menu (well, at 
least for start->run and shut down)

And to send this message, I'll hit CTRL-RETURN.

See...



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260088
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Code Question

[Rick Root]

Robertson-Ravo, Neil (RX) wrote:
> I don't really use keyboard shortcuts other than ctrl-s, x, v, and c.


I even use alt keys to access menu items... ALT-F, O to open files.. 
ALT-S,E for Extended Find/Replace (which can also be accessed via 
SHIFT-CTRL-R).. etc

i make extensive use of ALT-TAB and SHIFT-TAB, I usually use the windows 
start key and the arrow keys to access stuff in the start menu (well, at 
least for start->run and shut down)

And to send this message, I'll hit CTRL-RETURN.

See...

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260087
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: cffile question

[Jon Clausen]

On Nov 12, 2006, at 11:57 AM, Bob Imperial wrote:

> 1.)In outputting my datetime here, how would I go about adding the  
> AM/PM
> designation for output?
>
>   
> file="#BaseDir#\index.cfm"
>  output="Website directories were created successfully on
> #DateFormat(CreateODBCDate(myDate), " d,  hh:mm:ss")#">

#DateFormat(createODBCDateTime(myDate), " dd, ")# #TimeFormat 
(createODBCDateTime(myDate),"hh:mm:ss tt")#

("tt" does not work in the DateFormat() function )


> OK, here's the simpleton question, can I put any html tags in the  
> output
> above or into the output below? I'd like to put this in a div  
> centered on
> the page.
>
>
>   variable="confirmation">
>  
>   #HTMLCodeFormat(confirmation)#
>  

You can put any HTML tags into your output, but you may need to  
escape any CFML tags in the input by using #chr(60)# for "<" and #chr 
(62)# for ">" 


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260086
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

cfeclipse .project file

[Dan Vega]

Any cfeclipse users out there? I want to hide certain files from view in my
project such as the .project file. Is there a way to hide certain files?

-- 
Thank You
Dan Vega
[EMAIL PROTECTED]
http://www.danvega.org


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260085
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Source control recommendation

[Nick Gleason]

Hi there.  We've been hosting our source code in VSS in the past but are
considering moving to a new source control system and / or provider.  We are
basically interested in paying an affordable monthly fee to use a well
regarded source control system with an experience host who is diligent about
nightly backups, maintenance, and so forth.

If you have any recommendations for source control systems and even
providers that you have been happy with, please let me know.

Thanks!

N

.
..
 
Nick Gleason | CitySoft, Inc. | http://www.citysoft.com
 
Direct: (617) 899-5395 | Fax: (617) 507-0444

 
Spend Less >> Do More - Community Enterprise 
combines great features with an affordable price. 
.
..





~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260084
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

cffile question

[Bob Imperial]

Hi Folks.
 
while I realize this a question for the cf_newbie list, the response times
here are always much faster here. First off, thank you Michael D. for your
response on cf_newbie in regards to my question about cfdirectory. I am
still working on the basics with many things cf, another being cffile and
the "write" action and what the limitations are as to what can be put into
the output. I have a bit of code that creates a few directories and then
writes and index page with a short message and datetime stamp. Here's what
I'm using so far after my directories are created.
 
 
1.)In outputting my datetime here, how would I go about adding the AM/PM
designation for output?
 
  
  
 
OK, here's the simpleton question, can I put any html tags in the output
above or into the output below? I'd like to put this in a div centered on
the page.

  
 
 
  #HTMLCodeFormat(confirmation)# 
 
 
TIA ... Bob


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260083
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Advanced Search

[Dave Watts]

> I looked at the CFForm examples and did some reading on 
> cfform and preserve data.  It appears to work for some fields 
> such as cfinput, cfslider, cftextinput; but it does not 
> appear to assist in retaining values selected in a drop 
> down display.

No, it does allow you to preserve those values as well. At least, it does if
you're using CF 7. I'm not sure about earlier versions.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260082
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Code Question

[Robertson-Ravo, Neil (RX)]

I don't really use keyboard shortcuts other than ctrl-s, x, v, and c.





"This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number 678540.  It contains information which is
confidential and may also be privileged.  It is for the exclusive use of the
intended recipient(s).  If you are not the intended recipient(s) please note
that any form of distribution, copying or use of this communication or the
information in it is strictly prohibited and may be unlawful.  If you have
received this communication in error please return it to the sender or call
our switchboard on +44 (0) 20 89107910.  The opinions expressed within this
communication are not necessarily those expressed by Reed Exhibitions." 
Visit our website at http://www.reedexpo.com

-Original Message-
From: Rick Root
To: CF-Talk
Sent: Sun Nov 12 16:21:52 2006
Subject: Re: Code Question

Robertson-Ravo, Neil (RX) wrote:
> Would have to have a test, but to be honest I haven't "hand coded" a
comment
> in years... That's what Eclipse is for they make it easy with a click of a
> button :)

Taking my fingers off the keyboard to use the mouse while coding annoys 
me.  IT's easier (for me) to just type  than it is to stop 
typing, grab the mouse, click some button, then type in my comment.

My constant use of keyboard shortcuts is what makes it difficult for me 
to move to cfeclipse from homesite+.

Rick



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260081
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: ColdFusion Time Out Error....HELP!!!!!

[Rick Root]

We had timeout problems connecting to db2 whenever we were running heavy 
load jobs on the mainframe because of the way the mainframe was 
configured to give priority to CICS jobs.  When our mainframe was 
originally configured, there was never any thought about using the 
distributed components (ie, connecting via ODBC/JDBC).

My apps are the only ones in the university that actually connected 
through that method, and after about 3 years of complaining, our primary 
mainframe guy finally fiddled around with the configuration to fix it.

So there's ONE reason you could get database connection timed out.

Rick

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260080
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Advanced Search

[Pete]

Hi there

I looked at the CFForm examples and did some reading on cfform and preserve
data.  It appears to work for some fields such as cfinput, cfslider,
cftextinput; but it does not appear to assist in retaining values selected
in a drop down display.

Does anyone else have an idea on how a person can continue to retain the
values which were selected.

Thanks in advance

Pete

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Monday, 13 November 2006 2:22 AM
To: CF-Talk
Subject: RE: Advanced Search

> My question is this -  how to I retain the values that 
> were entered in the search form - so that a user can check 
> that the records returned are correct according to the search 
> criteria entered.

The easiest way to do this is to use CFFORM for your form, and set the
PRESERVEDATA attribute to "YES". For this to work, you need to use CFFORM in
the first search form and in the one you place on the results page, and all
of the fields must be named the same in both forms.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260079
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Code Question

[Rick Root]

Robertson-Ravo, Neil (RX) wrote:
> Would have to have a test, but to be honest I haven't "hand coded" a comment
> in years... That's what Eclipse is for they make it easy with a click of a
> button :)

Taking my fingers off the keyboard to use the mouse while coding annoys 
me.  IT's easier (for me) to just type  than it is to stop 
typing, grab the mouse, click some button, then type in my comment.

My constant use of keyboard shortcuts is what makes it difficult for me 
to move to cfeclipse from homesite+.

Rick

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260078
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: OT:sending mail to cf-talk - Base64 encoded mail is prohibited.

[Rick Root]

Casey Dougall wrote:
> I'm not, just replying to a message like normal. It was the live.com thread.

base64 encoded mail usually implies that you've attached binary files, 
or you're sending html email with embedded images and stuff.

Rick

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260077
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Advice about query caching

[Jon Clausen]

Paul,

I think your method would certainly work, however my experience with  
e-commerce has been that the full recordset of products is almost  
never used.   By using QoQ against your full recordset, you do limit  
yourself in some of the functions like true full-text searching that  
the database just does better (and performs better at) because that's  
what it was designed for.

Add multiple SKU's, Upsells, and the like and now you have to have 2  
or 3 QoQ's for every page request - something that could be  
accomplished in one query using JOIN's.

I also think you open yourself up to problems down the road and make  
life harder instead of easier.   Stock levels are one of those  
areas.   I don't know what you're selling or if you have physical  
inventory, but depending on how your query/tables are structured,  
you're going to have build a bunch of additional functions to handle  
clearing and resetting the application variable whenever a product is  
sold.

IMHO, CachedWithin in your query is a much more maintainable solution  
with fewer workarounds and pitfalls for you as the developer to worry  
about.

Jon

On Nov 12, 2006, at 7:37 AM, Paul Boyd wrote:

> I could after that use the request scope to avoid locking.
> As long as my application is running, I have the recordsets  
> available in memory, and i can use QoQ to do all the drill down  
> data manipulation.
> In other words, I would only have one database connection , during  
> the application startup, if I understood correctly.
>
> If I need to refresh the cache, I would just recall the application  
> variable which store the recordset and overwrite it.



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260076
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Extensions

[Dave Watts]

> Extensions. The normal extension is .cfm, but then there are 
> .cfc files.
> 
> Are there other extensions than these and what are they used for?

No, those are the two extensions used by CF scripts. CFM files are typically
used to render pages, and CFC files are used to define components, which are
somewhat analogous to classes in other languages.

ColdFusion does support other extensions - those used by J2EE web apps - but
you don't use those as a matter of course when writing CF apps.

> Can I call a .cfc file from an form on Post?

You can. Actually, you would call a method defined within a CFC, rather than
just the CFC itself. Your method would then be responsible for rendering the
content of the HTTP response, which would usually contain HTML. Not too many
CF developers do things this way, in my experience. Most CF developers use
CFCs for code that doesn't directly generate output, and CFMs for code that
does generate output.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260075
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Advanced Search

[Dave Watts]

> My question is this -  how to I retain the values that 
> were entered in the search form - so that a user can check 
> that the records returned are correct according to the search 
> criteria entered.

The easiest way to do this is to use CFFORM for your form, and set the
PRESERVEDATA attribute to "YES". For this to work, you need to use CFFORM in
the first search form and in the one you place on the results page, and all
of the fields must be named the same in both forms.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260074
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Advice about query caching

[Dave Watts]

> I'm not too sure how to handle caching. 
> So here is my question. Is it appropriate to store the 
> products recordset in an application variable within 
> onApplicationStart, and use QoQ for for data manipulation 
> in my different templates ? 

Any query that has significant reuse potential as-is, you should cache. If
you have to manipulate it with QoQ, the value of caching will decrease
significantly, as QoQ doesn't perform nearly as well as a direct database
query - your database has a very well-tuned query analyzer, and can take
advantage of indexes, etc.

> or is it better to use Cachedwithin or CachedAfter options 
> from CFquery ? 

Those options are easier to use, but give you less overall control. They
allow specific timeout values, so it's a little easier to keep the in-memory
data fresh. If you use Application/Session/Server, you have to write that
logic yourself. But, frankly, that's not very hard to do, and it lets you
easily handle freshening data when you want - when someone adds a new item,
for example. You can write logic to do that with CACHEDWITHIN/CACHEDAFTER,
but at that point you might as well just have used
Application/Session/Server. And, of course, not being able to use
CFQUERYPARAM in your CACHEDWITHIN/CACHEDAFTER queries is a big downside.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260073
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Advice about query caching

[Dave Watts]

> You should never store database information into a memory 
> variable unless it is within your shopping cart and then I 
> would store it as a array.

I'm sorry, but this is simply wrong.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260072
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Advice about query caching

[Dave Watts]

> Could you tell me why storing a recordset in an application 
> variable is not recommended. I saw this technique used 
> several times, and prefered over the cachedWithin method. 
> Apparently it's easier to control, to flush the cache, and I 
> guess you could use Cfqueryparam as well.

There is absolutely nothing wrong with caching recordsets in the
Application, Session or Server scopes as appropriate. Like any sort of
caching, you have to balance the pros and cons of the value of caching the
specific variable in question, that's all.

> But again, I'm quite confused with the two methods, as both 
> are loaded in the memory anyway..
> I guess if cachedWithin is here, it's probably for a good reason.

CACHEDWITHIN and CACHEDAFTER are there because they're very easy to use.
It's easier to just drop those attributes into a CFQUERY tag than it is to
write the logic needed to explicitly cache data in memory. The flip side of
this is that CACHEDWITHIN/CACHEDAFTER give you less control. My general
recommendation is that, if you're writing an application from scratch, you
use Application/Session/Server scopes. If you're modifying an existing
application, you should consider using CACHEDWITHIN/CACHEDAFTER.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260071
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Group-level security theory

[Claude Schneegans]

 >>I'm building a content management application targeted at
small-businesses.

I quite agree with Barney's description.
What you describe here would be "role based security".
However, for "small business", a permission based security would probably
be more appropriate.
Depends how small is you small business.

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260070
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: ColdFusion Time Out Error....HELP!!!!!

[Claude Schneegans]

 >>Timed out trying to establish connection

Do you have the "Maintain Connections" parameter checked for this datasource
in the CF administrator?

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260069
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Advice about query caching

[Paul Boyd]

I fully agree.
Do you know of any good tools for memory metrics ?

>It would need some memory metrics against it I suppose - what would be more
>efficient: a large 700 resultset residing in memory all the time or X amount
>of calls asking for said query on each request (it is required) which
>resides in memory for the duration of the request... Lots of factors to
>consider however such as scale, query freshness/size etc.. 
>
>
>
>
> 
>
>
>"This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
>Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
>Registered in England, Number 678540.  It contains information which is
>confidential and may also be privileged.  It is for the exclusive use of the
>intended recipient(s).  If you are not the intended recipient(s) please note
>that any form of distribution, copying or use of this communication or the
>information in it is strictly prohibited and may be unlawful.  If you have
>received this communication in error please return it to the sender or call
>our switchboard on +44 (0) 20 89107910.  The opinions expressed within this
>communication are not necessarily those expressed by Reed Exhibitions." 
>Visit our website at http://www.reedexpo.com
>
>-Original Message-
>From: James Holmes
>To: CF-Talk
>Sent: Sun Nov 12 14:13:51 2006
>Subject: Re: Advice about query caching
>
>Oh agreed - it's often better use of resources to query the DB rather
>than to perform elaborate caching when each user needs different
>results etc. It depends on how big the query is, how much memory is in
>the server, where the DB is and so many other things.
>
>I usually cache the content resulting from the queries instead, using
>Ray's Scopecache.
>
>On 11/12/06, Robertson-Ravo, Neil (RX)
><[EMAIL PROTECTED]> wrote:
>> Indeed, not that I would say holding a recordset in the app scope is good
>> practice (unless, as stated, the freshness is not an issue) there are
>> probably loads of apps out there which do it and with the lack of any
>"best
>the
>> intended recipient(s).  If you are not the intended recipient(s) please
>note
>> that any form of distribution, copying or use of this communication or the
>> information in it is strictly prohibited and may be unlawful.  If you have
>> received this communication in error please return it to the sender or
>call
>> our switchboard on +44 (0) 20 89107910.  The opinions expressed within
>this
>and

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260068
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Advice about query caching

[James Holmes]

I'm going to to quote Ben Forta (et al) here:

"ColdFusion is not a database server"

If you intend to do frequent, perhaps complex QoQ on the query in
memory, you may be better off simply going to the DB. Multiple calls
to the DB in a page will reuse the same DB connection and for most
purposes CF will reuse the same connection again on subsequent
requests from all of your pages.

On 11/12/06, Paul Boyd <[EMAIL PROTECTED]> wrote:

> As long as my application is running, I have the recordsets available in 
> memory, and i can use QoQ to do all the drill down data manipulation.
> In other words, I would only have one database connection , during the 
> application startup, if I understood correctly.

-- 
CFAJAX docs and other useful articles:
http://www.bifrost.com.au/blog/

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260067
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Advice about query caching

[Robertson-Ravo, Neil (RX)]

It would need some memory metrics against it I suppose - what would be more
efficient: a large 700 resultset residing in memory all the time or X amount
of calls asking for said query on each request (it is required) which
resides in memory for the duration of the request... Lots of factors to
consider however such as scale, query freshness/size etc.. 




 


"This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number 678540.  It contains information which is
confidential and may also be privileged.  It is for the exclusive use of the
intended recipient(s).  If you are not the intended recipient(s) please note
that any form of distribution, copying or use of this communication or the
information in it is strictly prohibited and may be unlawful.  If you have
received this communication in error please return it to the sender or call
our switchboard on +44 (0) 20 89107910.  The opinions expressed within this
communication are not necessarily those expressed by Reed Exhibitions." 
Visit our website at http://www.reedexpo.com

-Original Message-
From: James Holmes
To: CF-Talk
Sent: Sun Nov 12 14:13:51 2006
Subject: Re: Advice about query caching

Oh agreed - it's often better use of resources to query the DB rather
than to perform elaborate caching when each user needs different
results etc. It depends on how big the query is, how much memory is in
the server, where the DB is and so many other things.

I usually cache the content resulting from the queries instead, using
Ray's Scopecache.

On 11/12/06, Robertson-Ravo, Neil (RX)
<[EMAIL PROTECTED]> wrote:
> Indeed, not that I would say holding a recordset in the app scope is good
> practice (unless, as stated, the freshness is not an issue) there are
> probably loads of apps out there which do it and with the lack of any
"best
> practice" docs other than advice and preference it would probably work.
>
>
>
>
>
>
>
> "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
> Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
> Registered in England, Number 678540.  It contains information which is
> confidential and may also be privileged.  It is for the exclusive use of
the
> intended recipient(s).  If you are not the intended recipient(s) please
note
> that any form of distribution, copying or use of this communication or the
> information in it is strictly prohibited and may be unlawful.  If you have
> received this communication in error please return it to the sender or
call
> our switchboard on +44 (0) 20 89107910.  The opinions expressed within
this
> communication are not necessarily those expressed by Reed Exhibitions."
> Visit our website at http://www.reedexpo.com
>
> -Original Message-
> From: James Holmes
> To: CF-Talk
> Sent: Sun Nov 12 13:50:29 2006
> Subject: Re: Advice about query caching
>
> Huh? Once it's in the Application scope it can stay there for as long
> as you want.
>
> On 11/12/06, Doug Brown <[EMAIL PROTECTED]> wrote:
> > Cachedwithin does load the dataset into server memory but stays there
> until
> > it times out, and then refreshes. Setting it in the application scope
> > requires you to query the database for the data to put into that scope
and
> > store it on every request. That is my understanding.
>
>
> --
>
>
>
> 



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260066
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Advice about query caching

[James Holmes]

Oh agreed - it's often better use of resources to query the DB rather
than to perform elaborate caching when each user needs different
results etc. It depends on how big the query is, how much memory is in
the server, where the DB is and so many other things.

I usually cache the content resulting from the queries instead, using
Ray's Scopecache.

On 11/12/06, Robertson-Ravo, Neil (RX)
<[EMAIL PROTECTED]> wrote:
> Indeed, not that I would say holding a recordset in the app scope is good
> practice (unless, as stated, the freshness is not an issue) there are
> probably loads of apps out there which do it and with the lack of any "best
> practice" docs other than advice and preference it would probably work.
>
>
>
>
>
>
>
> "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
> Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
> Registered in England, Number 678540.  It contains information which is
> confidential and may also be privileged.  It is for the exclusive use of the
> intended recipient(s).  If you are not the intended recipient(s) please note
> that any form of distribution, copying or use of this communication or the
> information in it is strictly prohibited and may be unlawful.  If you have
> received this communication in error please return it to the sender or call
> our switchboard on +44 (0) 20 89107910.  The opinions expressed within this
> communication are not necessarily those expressed by Reed Exhibitions."
> Visit our website at http://www.reedexpo.com
>
> -Original Message-
> From: James Holmes
> To: CF-Talk
> Sent: Sun Nov 12 13:50:29 2006
> Subject: Re: Advice about query caching
>
> Huh? Once it's in the Application scope it can stay there for as long
> as you want.
>
> On 11/12/06, Doug Brown <[EMAIL PROTECTED]> wrote:
> > Cachedwithin does load the dataset into server memory but stays there
> until
> > it times out, and then refreshes. Setting it in the application scope
> > requires you to query the database for the data to put into that scope and
> > store it on every request. That is my understanding.
>
>
> --
>
>
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260065
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Group-level security theory

[Dawson, Michael]

Well, here's what I do. 

I use Active Directory groups to manage access to different areas of our
intranet.  There are a few instances where I create pseudo groups from
our main business system, but in the near future, that's going to change
to use Active Directory as well.

I have an OU, in AD, that contains all groups used for security on my
web site.  If someone needs access to an area, then several people in
our dept can add them.  Eventually, I will create an interface so that
the primary contacts, across campus, can determine, themselves, who has
access to their online resources.  I use the "managedBy" attribute to
tell who is the group's primary contact.

(We have quite a bit of turnover, but accounts don't always get removed
from security groups as they should.  By putting some of the group
administration in the hands of the dept heads, they can help keep our AD
up-to-date.)

When a user logs in, I query AD using CFLAP.  I store their group
membership in an array, or query object, in their session scope.  Then,
where needed, I only have to call a single function that accepts
multiple roles.

It goes something like this:



Most of the intranet is read-only content.  However, there are a few
areas where some people have more access to the data.  In those, cases,
I only have to create a new domain group and add them.

It has worked great for the last few years and I'm getting ready to do
the same thing on the redesign of our intranet.

M!ke

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260064
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Advice about query caching

[Robertson-Ravo, Neil (RX)]

Indeed, not that I would say holding a recordset in the app scope is good
practice (unless, as stated, the freshness is not an issue) there are
probably loads of apps out there which do it and with the lack of any "best
practice" docs other than advice and preference it would probably work.


 




"This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number 678540.  It contains information which is
confidential and may also be privileged.  It is for the exclusive use of the
intended recipient(s).  If you are not the intended recipient(s) please note
that any form of distribution, copying or use of this communication or the
information in it is strictly prohibited and may be unlawful.  If you have
received this communication in error please return it to the sender or call
our switchboard on +44 (0) 20 89107910.  The opinions expressed within this
communication are not necessarily those expressed by Reed Exhibitions." 
Visit our website at http://www.reedexpo.com

-Original Message-
From: James Holmes
To: CF-Talk
Sent: Sun Nov 12 13:50:29 2006
Subject: Re: Advice about query caching

Huh? Once it's in the Application scope it can stay there for as long
as you want.

On 11/12/06, Doug Brown <[EMAIL PROTECTED]> wrote:
> Cachedwithin does load the dataset into server memory but stays there
until
> it times out, and then refreshes. Setting it in the application scope
> requires you to query the database for the data to put into that scope and
> store it on every request. That is my understanding.


-- 



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260063
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Advice about query caching

[James Holmes]

Huh? Once it's in the Application scope it can stay there for as long
as you want.

On 11/12/06, Doug Brown <[EMAIL PROTECTED]> wrote:
> Cachedwithin does load the dataset into server memory but stays there until
> it times out, and then refreshes. Setting it in the application scope
> requires you to query the database for the data to put into that scope and
> store it on every request. That is my understanding.


-- 
CFAJAX docs and other useful articles:
http://www.bifrost.com.au/blog/

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260062
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Advice about query caching

[Paul Boyd]

Here is a quick shot of what I wanted to do, in its basic form.


 
 
 application.objCfc = createObject("component", 
"#variables.componentsPath#.myCfc");
 application.categories = application.objCfc.fnGetCategories();
 application.products = application.objCfc.fnGetProducts();



I could after that use the request scope to avoid locking.
As long as my application is running, I have the recordsets available in 
memory, and i can use QoQ to do all the drill down data manipulation.
In other words, I would only have one database connection , during the 
application startup, if I understood correctly.

If I need to refresh the cache, I would just recall the application variable 
which store the recordset and overwrite it.

Does that make sens, or I'm loosing it ?

>But isn't the dataset set going to be a "fresh" one without using
>cachedwithin in regards to the query itself? If you say
>
>
>SELECT * FROM products
>
>
>Arent you making an unnecessary trip to the database if the dataset is
>already in server memory by using cachedwithin?
>- Original Message - 
>From: "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]>
>To: "CF-Talk" 
>Sent: Sunday, November 12, 2006 6:14 AM
>Subject: Re: Advice about query caching
>
>
>> It shouldn't have to be calling into the app scope for every request -
>only
>the
>> intended recipient(s).  If you are not the intended recipient(s) please
>note
>> that any form of distribution, copying or use of this communication or the
>> information in it is strictly prohibited and may be unlawful.  If you have
>> received this communication in error please return it to the sender or
>call
>> our switchboard on +44 (0) 20 89107910.  The opinions expressed within
>this
>until
>over
>> the cachedWithin method. Apparently it's easier to control, to flush the
>> cache, and I guess you could use Cfqueryparam as well.
>> > But again, I'm quite confused with the two methods, as both are loaded
>in
>unless
>> it
>> > >is within your shopping cart and then I would store it as a array. If
>you
>> > >know for certain that only the prices would be updated weekly, and you
>> know
>> > >for certain on which day, I would use cachedwithin with a timeout of
>say
>for
>>

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260061
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Advice about query caching

[Doug Brown]

But isn't the dataset set going to be a "fresh" one without using
cachedwithin in regards to the query itself? If you say


SELECT * FROM products


Arent you making an unnecessary trip to the database if the dataset is
already in server memory by using cachedwithin?
- Original Message - 
From: "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Sunday, November 12, 2006 6:14 AM
Subject: Re: Advice about query caching


> It shouldn't have to be calling into the app scope for every request -
only
> the first call - onApplicationStart (depending on how fresh you want the
> data).
>
> You would then have to control the flushing yourself.
>
>
>
>
>
>
>
>
>
> "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
> Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
> Registered in England, Number 678540.  It contains information which is
> confidential and may also be privileged.  It is for the exclusive use of
the
> intended recipient(s).  If you are not the intended recipient(s) please
note
> that any form of distribution, copying or use of this communication or the
> information in it is strictly prohibited and may be unlawful.  If you have
> received this communication in error please return it to the sender or
call
> our switchboard on +44 (0) 20 89107910.  The opinions expressed within
this
> communication are not necessarily those expressed by Reed Exhibitions."
> Visit our website at http://www.reedexpo.com
>
> -Original Message-
> From: Doug Brown
> To: CF-Talk
> Sent: Sun Nov 12 13:14:10 2006
> Subject: Re: Advice about query caching
>
> Cachedwithin does load the dataset into server memory but stays there
until
> it times out, and then refreshes. Setting it in the application scope
> requires you to query the database for the data to put into that scope and
> store it on every request. That is my understanding.
>
>
>
> Doug B.
>
>
> - Original Message - 
> From: "Paul Boyd" <[EMAIL PROTECTED]>
> To: "CF-Talk" 
> Sent: Sunday, November 12, 2006 4:55 AM
> Subject: Re: Advice about query caching
>
>
> > Thanks Doug,
> >
> > Your feedback is greatly appreciated.
> > Could you tell me why storing a recordset in an application variable is
> not recommended. I saw this technique used several times, and prefered
over
> the cachedWithin method. Apparently it's easier to control, to flush the
> cache, and I guess you could use Cfqueryparam as well.
> > But again, I'm quite confused with the two methods, as both are loaded
in
> the memory anyway..
> > I guess if cachedWithin is here, it's probably for a good reason.
> >
> > Thanks again Doug :)
> >
> >
> >
> >
> > >Paul,
> > >
> > >You should never store database information into a memory variable
unless
> it
> > >is within your shopping cart and then I would store it as a array. If
you
> > >know for certain that only the prices would be updated weekly, and you
> know
> > >for certain on which day, I would use cachedwithin with a timeout of
say
> 6
> > >days.
> > >
> > >
> > >Hope this helps.
> > >
> > >
> > >Doug B.
> > >
> > >
> > >- Original Message - 
> > >From: "Paul Boyd" <[EMAIL PROTECTED]>
> > >To: "CF-Talk" 
> > >Sent: Sunday, November 12, 2006 4:05 AM
> > >Subject: Advice about query caching
> > >
> > >
> > >> Hello everyone,
> > >>
> > >> First post here, so don't get too hard on me.
> > >>
> > >> I'm developping a small e-commerce application with less than 1000
> > >products ( around 700).
> > >> As far as I know, only product prices would be updated on a weekly
> basis.
> > >>
> > >> I'm not too sure how to handle caching.
> > >> So here is my question. Is it appropriate to store the products
> recordset
> > >in an application variable within onApplicationStart, and use QoQ for
for
> > >data manipulation
> > >> in my different templates ? or is it better to use Cachedwithin or
> > >CachedAfter options from CFquery ?
> > >>
> > >> your advice is more than welcome.
> > >>
> > >>
> >
> >
>
>
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260060
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Advice about query caching

[Robertson-Ravo, Neil (RX)]

It shouldn't have to be calling into the app scope for every request - only
the first call - onApplicationStart (depending on how fresh you want the
data).

You would then have to control the flushing yourself.









"This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number 678540.  It contains information which is
confidential and may also be privileged.  It is for the exclusive use of the
intended recipient(s).  If you are not the intended recipient(s) please note
that any form of distribution, copying or use of this communication or the
information in it is strictly prohibited and may be unlawful.  If you have
received this communication in error please return it to the sender or call
our switchboard on +44 (0) 20 89107910.  The opinions expressed within this
communication are not necessarily those expressed by Reed Exhibitions." 
Visit our website at http://www.reedexpo.com

-Original Message-
From: Doug Brown
To: CF-Talk
Sent: Sun Nov 12 13:14:10 2006
Subject: Re: Advice about query caching

Cachedwithin does load the dataset into server memory but stays there until
it times out, and then refreshes. Setting it in the application scope
requires you to query the database for the data to put into that scope and
store it on every request. That is my understanding.



Doug B.


- Original Message - 
From: "Paul Boyd" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Sunday, November 12, 2006 4:55 AM
Subject: Re: Advice about query caching


> Thanks Doug,
>
> Your feedback is greatly appreciated.
> Could you tell me why storing a recordset in an application variable is
not recommended. I saw this technique used several times, and prefered over
the cachedWithin method. Apparently it's easier to control, to flush the
cache, and I guess you could use Cfqueryparam as well.
> But again, I'm quite confused with the two methods, as both are loaded in
the memory anyway..
> I guess if cachedWithin is here, it's probably for a good reason.
>
> Thanks again Doug :)
>
>
>
>
> >Paul,
> >
> >You should never store database information into a memory variable unless
it
> >is within your shopping cart and then I would store it as a array. If you
> >know for certain that only the prices would be updated weekly, and you
know
> >for certain on which day, I would use cachedwithin with a timeout of say
6
> >days.
> >
> >
> >Hope this helps.
> >
> >
> >Doug B.
> >
> >
> >- Original Message - 
> >From: "Paul Boyd" <[EMAIL PROTECTED]>
> >To: "CF-Talk" 
> >Sent: Sunday, November 12, 2006 4:05 AM
> >Subject: Advice about query caching
> >
> >
> >> Hello everyone,
> >>
> >> First post here, so don't get too hard on me.
> >>
> >> I'm developping a small e-commerce application with less than 1000
> >products ( around 700).
> >> As far as I know, only product prices would be updated on a weekly
basis.
> >>
> >> I'm not too sure how to handle caching.
> >> So here is my question. Is it appropriate to store the products
recordset
> >in an application variable within onApplicationStart, and use QoQ for for
> >data manipulation
> >> in my different templates ? or is it better to use Cachedwithin or
> >CachedAfter options from CFquery ?
> >>
> >> your advice is more than welcome.
> >>
> >>
>
> 



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260059
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Advice about query caching

[Doug Brown]

Cachedwithin does load the dataset into server memory but stays there until
it times out, and then refreshes. Setting it in the application scope
requires you to query the database for the data to put into that scope and
store it on every request. That is my understanding.



Doug B.


- Original Message - 
From: "Paul Boyd" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Sunday, November 12, 2006 4:55 AM
Subject: Re: Advice about query caching


> Thanks Doug,
>
> Your feedback is greatly appreciated.
> Could you tell me why storing a recordset in an application variable is
not recommended. I saw this technique used several times, and prefered over
the cachedWithin method. Apparently it's easier to control, to flush the
cache, and I guess you could use Cfqueryparam as well.
> But again, I'm quite confused with the two methods, as both are loaded in
the memory anyway..
> I guess if cachedWithin is here, it's probably for a good reason.
>
> Thanks again Doug :)
>
>
>
>
> >Paul,
> >
> >You should never store database information into a memory variable unless
it
> >is within your shopping cart and then I would store it as a array. If you
> >know for certain that only the prices would be updated weekly, and you
know
> >for certain on which day, I would use cachedwithin with a timeout of say
6
> >days.
> >
> >
> >Hope this helps.
> >
> >
> >Doug B.
> >
> >
> >- Original Message - 
> >From: "Paul Boyd" <[EMAIL PROTECTED]>
> >To: "CF-Talk" 
> >Sent: Sunday, November 12, 2006 4:05 AM
> >Subject: Advice about query caching
> >
> >
> >> Hello everyone,
> >>
> >> First post here, so don't get too hard on me.
> >>
> >> I'm developping a small e-commerce application with less than 1000
> >products ( around 700).
> >> As far as I know, only product prices would be updated on a weekly
basis.
> >>
> >> I'm not too sure how to handle caching.
> >> So here is my question. Is it appropriate to store the products
recordset
> >in an application variable within onApplicationStart, and use QoQ for for
> >data manipulation
> >> in my different templates ? or is it better to use Cachedwithin or
> >CachedAfter options from CFquery ?
> >>
> >> your advice is more than welcome.
> >>
> >>
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260058
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Advice about query caching

[Paul Boyd]

Thanks Doug,

Your feedback is greatly appreciated.
Could you tell me why storing a recordset in an application variable is not 
recommended. I saw this technique used several times, and prefered over the 
cachedWithin method. Apparently it's easier to control, to flush the cache, and 
I guess you could use Cfqueryparam as well.
But again, I'm quite confused with the two methods, as both are loaded in the 
memory anyway..
I guess if cachedWithin is here, it's probably for a good reason.

Thanks again Doug :)




>Paul,
>
>You should never store database information into a memory variable unless it
>is within your shopping cart and then I would store it as a array. If you
>know for certain that only the prices would be updated weekly, and you know
>for certain on which day, I would use cachedwithin with a timeout of say 6
>days.
>
>
>Hope this helps.
>
>
>Doug B.
>
>
>- Original Message - 
>From: "Paul Boyd" <[EMAIL PROTECTED]>
>To: "CF-Talk" 
>Sent: Sunday, November 12, 2006 4:05 AM
>Subject: Advice about query caching
>
>
>> Hello everyone,
>>
>> First post here, so don't get too hard on me.
>>
>> I'm developping a small e-commerce application with less than 1000
>products ( around 700).
>> As far as I know, only product prices would be updated on a weekly basis.
>>
>> I'm not too sure how to handle caching.
>> So here is my question. Is it appropriate to store the products recordset
>in an application variable within onApplicationStart, and use QoQ for for
>data manipulation
>> in my different templates ? or is it better to use Cachedwithin or
>CachedAfter options from CFquery ?
>>
>> your advice is more than welcome.
>>
>>

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260057
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Advice about query caching

[Doug Brown]

Paul,

You should never store database information into a memory variable unless it
is within your shopping cart and then I would store it as a array. If you
know for certain that only the prices would be updated weekly, and you know
for certain on which day, I would use cachedwithin with a timeout of say 6
days.


Hope this helps.


Doug B.


- Original Message - 
From: "Paul Boyd" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Sunday, November 12, 2006 4:05 AM
Subject: Advice about query caching


> Hello everyone,
>
> First post here, so don't get too hard on me.
>
> I'm developping a small e-commerce application with less than 1000
products ( around 700).
> As far as I know, only product prices would be updated on a weekly basis.
>
> I'm not too sure how to handle caching.
> So here is my question. Is it appropriate to store the products recordset
in an application variable within onApplicationStart, and use QoQ for for
data manipulation
> in my different templates ? or is it better to use Cachedwithin or
CachedAfter options from CFquery ?
>
> your advice is more than welcome.
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260056
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Advice about query caching

[Paul Boyd]

Hello everyone,

First post here, so don't get too hard on me.

I'm developping a small e-commerce application with less than 1000 products ( 
around 700).
As far as I know, only product prices would be updated on a weekly basis.

I'm not too sure how to handle caching. 
So here is my question. Is it appropriate to store the products recordset in an 
application variable within onApplicationStart, and use QoQ for for data 
manipulation
in my different templates ? or is it better to use Cachedwithin or CachedAfter 
options from CFquery ? 

your advice is more than welcome.

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260055
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Group-level security theory

[Tom King]

Just to throw in my two pennies worth:

I have a CMS where there are about 20 websites which use the same  
editor, file upload etc.

I do this the following way - I have a table with the web site  
specifics in, like the various upload directories, image directories  
etc, and then a User table. Each user has a list of approved  
websites, where the Unique ID for the website matches a list of IDs  
in the User entry.

So when they login, I authenticate, then assign the various website  
variables to a session struct/query which are then used to display  
the info they require. Using the session scope means you can only  
assign them the information etc they need. You can then build the  
various templates you need for web page editing around the variables  
set in the session scope.

T


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260054
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Advanced Search

[Pete]

 

Hi there

 

I'm in the process of creating a search form which will be used to search
the database and list records that match certain entered selection criteria.

 

What I would like to do is the following.

 

Display the search form 

 


Your Search


Area of Specialty

 Please Select  Abdominoplasty  Arm lift  Blepharoplasty  Body implants
Body lift  Breast augmentation  Breast lift  Cellulite treatment  Cheek
implants  Chin augmentation  Cosmetic dentistry  Cosmetic tattooing 


Your Locale

 Please Select  Australian Capital Territory  New South Wales  Northern
Territory  Queensland  South Australia  Tasmania  Victoria  Western
Australia 


Your City




Gender

 No Preference  Male  Female 


Keyword





 

In the program I have a hidden field called submit.  The value of submitted
is initially set to 0 - so when a person first opens the page only the
search form and instructions are displayed.  Once a person clicks submit the
value of submit is 1.  Basically I have a 

 

Click search button to search our database.



Display matching records.


Dr Name / Type

Practice Name 

City

Address

Opening Hours 

 


Dr. JOHN CITIZEN 
Cosmetic Surgeon

Cosmetic
  Surgeons

Sydney

Bondi Junction

09:30 AM - 05:30PM 

More
  Info


Dr. FRED FLINSTONE 
Medical Specialist

Bedrock
  Clinic

Sydney

Double Bay 

09:00 AM - 05:30PM 

More
  Info



 

My question is this -  how to I retain the values that were entered in
the search form - so that a user can check that the records returned are
correct according to the search criteria entered.

 

Thanks in advance for feedback.

 

Regards

 

Pete

 

 

 

 




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260053
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

CFForms/XML format suddenly giving error messages

[Mike Kear]

Does anyone know why this might suddenly become a problem with my
CFFORMS (XML format)?   I know not many people use the XML format and
that's a pity because i think they're terrific.  Or at least i did
until this suddenly started happening.

This form is on a CMS that I've been using happily without errors for
almost a year now.  Here's the error message:

[quote]
javax.xml.transform.TransformerConfigurationException:
javax.xml.transform.TransformerException:
org.xml.sax.SAXParseException: Content is not allowed in prolog.
[/quote]

I've checked all the obvious things - looked for files that have
changed as the possible cause of the issue,  configuratoin changes in
the site etc  and nothing on the site has changes in a way that might
cause this.

So that means something in the OS.  Is there anything that my good
friend Mr Gates might have put on in the auto updates to my XPPro that
might cause this?

Or something else i should look for?

I konw it's not the syntax of the forms, because i can remove
everything but the CFFORM tag and still get the error.   Here's the
cfform tag:



-- 
Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260052
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Search Questions

[Robertson-Ravo, Neil (RX)]

Hi Les,

There are certainly options open to you, and of course your problem is not
unique so there is help!

The main issue is that your site was never designed to be searched from the
beginning where Search functionality was more of an afterthought. To get the
most of your search (I presume you will be using the outdated and feature
limited OEM Verity)  you should either index the dynamic pages by pointing a
spider at your site - but you have to ensure that your links all follow etc.
This will give you a good website search.

If you index the content from the DB directly into a collection then it's
relevancy and potential freshness becomes less and indeed may as well stay
in a SQL Full Text Search with you building the front end rather than
Verity.

A good search engine is a must here if you want to perform "real" searches
and utilise things like lemmatisation, synonym addition/conversion etc. But
you will pay for these tools and in most cases it will be a lot :-)











"This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number 678540.  It contains information which is
confidential and may also be privileged.  It is for the exclusive use of the
intended recipient(s).  If you are not the intended recipient(s) please note
that any form of distribution, copying or use of this communication or the
information in it is strictly prohibited and may be unlawful.  If you have
received this communication in error please return it to the sender or call
our switchboard on +44 (0) 20 89107910.  The opinions expressed within this
communication are not necessarily those expressed by Reed Exhibitions." 
Visit our website at http://www.reedexpo.com

-Original Message-
From: Les Mizzell
To: CF-Talk
Sent: Sun Nov 12 02:12:25 2006
Subject: Search Questions

It's been awhile since I've set up a search engine for a site. The last 
site I did a search for was a mixed static/dynamic content, which caused 
a lot of head-scratching. I finally *faked* it by setting a reference 
table that pretty much included "page_content" and "page_link" columns 
and just searched that. PITA, it was.

I'm now working on a much bigger site with the same problem. Half is 
static, the rest is coming from maybe 30 different tables in a MySQL 
database. The site is almost too large for me to try and fake it this time.

This is on a shared server, so I don't have access to the cf admin.

I can create a Verity collection and index through code, but that's not 
going to handle some of the dynamic content.

What's the most optimal way of handling this search? How do the rest of 
you handle searches for mixed static/dynamic content?




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260051
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4