Re: cfstoredproc vs cfquery

[Sapporo Sapporo]

Thanks for your input, Dave. My concern is the processing overhead that is 
incurred by using CFSTOREDPROC. Do you know of any way to access multiple 
recordsets in CFQUERY? As it stands now, CFQUERY only returns the 1st recordset 
while ignoring the rest. The ability to pull multiple recordsets, in my 
opinion, 
is the only advantage to CFSTOREDPROC.

Jim

>> Anyone know if there is an advantage either way when it comes 
>> to calling a stored procedure?
>
>In the example you provided, there's no difference, but stored procedures
>can be much more complex than a single SQL statement. Stored procedures can
>return multiple recordsets, they can accept and return parameters. The
>CFSTOREDPROC tag allows for all that. Also, you can't use CFQUERY on all
>platforms to execute stored procedures, as I recall. But if you don't have
>any of these issues there's nothing wrong with using CFQUERY instead, and
>there are some advantages, such as the ability to use
>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!

~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/

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

RE: Best way to restrict only one registration

[Bobby Hartsfield]

I assume you ask for an email address during registration and make it
required. Make the email address field unique in the database first and do
not allow the same address twice.

I'm also sure there is no way for a person to collect a prize without giving
their REAL information... like first name, last name, phone number, address,
etc...

Check for a match of first name, last name AND either MAILING address or
phone number with a query like...

Select field from existingEntries
Where emailaddress = '#form.emailaddress#'
Or
(
firstname = '#form.firstname#'
And lastname = '#form.lastname#'
And (
phonenumber = '#form.phonenumber#'
or 
streetaddress = '#rereplace(form.streetaddress, "[^0-9]",
"", "all")#'
)
)

If a match is found, they have already entered.

Be sure to store and compare phone numbers only after stripping all
characters but numbers with a regex like [^0-9] because (555)-555- and
55 are not the same strings and will not match but should.

Good luck


-Original Message-
From: Bruce Sorge [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 23, 2007 3:51 PM
To: CF-Talk
Subject: Best way to restrict only one registration

I am looking for the best way to keep someone from registering in a
sweepstakes only once. What do you all recommend? I was thinking of using a
GUID but these are machine specific, right? I was also thinking of making it
so that when they enter their information I can check it against the
database and if there is a match, let them know they already registered. But
then again all they have to do is start over and enter information again.
Maybe using a special code or something?

Thanks,

Bruce




~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & 
Flex 2. 
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/

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

Re: Mail Spool Slow

[Nick Tong - http://TalkWebSolutions.co.uk]

Russ - i agree, but the main point i was trying to make was that writing the
files directly to the SMTP folder, I believe, is quicker that using CF to
spool them.

On 23/02/07, Russ <[EMAIL PROTECTED]> wrote:
>
> The slowness is not a problem of the writing the files to the spool
> folder, it's actually pushing the files out.  We were able to generate the
> files fairly quickly, but cf only uses a single thread in the standard
> edition to push files out, so even though we had a dedicated mail server the
> files were going out slow.
>
> As I mentioned, if this hasn't been a problem before, and it is a problem
> now, most likely the culprit is the mail server.
>
> Russ
>
> > -Original Message-
> > From: Nick Tong - TalkWebSolutions.co.uk [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, February 22, 2007 6:58 PM
> > To: CF-Talk
> > Subject: Re: Mail Spool Slow
> >
> > Hi Rob - it's based on a tag by Jochem van Dieten:
> > http://www.vandieten.net/jochem/coldfusion/customtags/advancedemail/
> >
> > it's rather old - but then so is the system. it works well though -
> > sorry i can't share more but my client would be upset.  Let me know
> > how you get on.
> >
> > On 22/02/07, Rob Kopp <[EMAIL PROTECTED]> wrote:
> > > Can you show me some code on how you're doing that?
> > >
> > > > FWIW: we send out thousands and i find it easier to write the files
> > > > directly to the mail root instead of getting CF to send the email
> via
> > > > the cf spool.
> > >
> > >
> > >
> >
> >
>
> 

~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion

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

RE: Best way to restrict only one registration

[Bruce Sorge]

Thanks Dave. I will do just that. And I agree, if they want to waste their
time thinking they are "padding" the contest and that makes them sleep
better, so be it.

Bruce

-Original Message-
From: Dave Francis [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 23, 2007 1:06 PM
To: CF-Talk
Subject: RE: Best way to restrict only one registration


When we run similar competitions, we check their email (required to contact
winners, therefore probably valid and real)against a database, and just
don't add it if it's a duplicate. Then we carry on as if it was OK, "Thank
you for your entry" etc.

We don't mind if cheats want to waste their time trying to enter a dozen or
so.



~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion

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

(Admin) New features and request

[Michael Dinowitz]

As some of you have seen, House of Fusion has some new features. The main one 
is the "ColdFusion Community Search" which is going fantastically. Others are 
rather small like enhancements to the layout (ongoing). If anyone has any 
suggestions for features, please email me off list and let me know. 

Also, if you find a post interesting, please feel free to use the "Digg It" 
button to let others know as well. I'll add 1 or 2 other buttons once I find 
which of these services are the best for what's here.

Thanks

Michael Dinowitz
President: House of Fusion(http://www.houseoffusion.com)
Publisher: Fusion Authority(http://www.fusionauthority.com)
Adobe Community Expert / Advanced Certified ColdFusion Professional

~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/

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

RE: Server help - coldfusion services stop responding

[DURETTE, STEVEN J \(ASI-AIT\)]

FusionReactor may actually be more cost friendly for an ISP.

It's licensed per box (as many instances as you want).  SeeFusion is
licensed per instance.

We had a problem for 3 weeks (it would happen seemingly randomly).  We
couldn't figure it out.  45 minutes after we started FusionReactor (we
bought it, not the demo), we had the problem solved. Turned out that a
user who was granted a little extra access because of his job was
randomly during the day trying to pull down an entire database to his
computer so he could repackage the data for a different site.  He got
his access stripped for that! :)  

It was well worth the money and now allows us to monitor during peak
usage to see if certain things don't work well together.  One thing we
did figure out is that even though separate instances are supposed to
not interfere with each other, two heavily trafficked instances can
cause other instances to slow because the more trafficked ones use up
all of the system's resources.

Steve


-Original Message-
From: Lincoln Milner [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 23, 2007 3:51 PM
To: CF-Talk
Subject: RE: Server help - coldfusion services stop responding


When I've seen this behavior on our servers, I get on a terminal
connection and run "cfstat".  That usually shows a large number of
queued requests and a handful (10 on our systems) that are hanging.  If
your boxes are robust enough, you can bump up simultaneous requests and
see if that clears the bottleneck.  Or your sim. reqs. setting is too
high now and the thing chokes.  We've had both those problems (it being
too low and too high; 10 is a good number for us now).

I'm trying to get SeeFusion or something similar in place to actually
see what 10 are hanging (so I can find the offending code), but
eventually the hanging threads time out, or I just bump CF and all is
well again.

Cheers!
Lincoln

-Original Message-
From: Jason Rogoz [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 23, 2007 3:44 PM
To: CF-Talk
Subject: Server help - coldfusion services stop responding

Hey guys

A client has asked me for some advise on a coldfusion server issue they
are having.  They are reporting that the coldfusion services just stop
responding when their site gets busy (i'm not sure at this point the
number of hits when they consider the site busy), but stopping and
starting the coldfusion services seems to fix the issue. They just don't
want to have to stop and start the services all the time.  

I have the following information regarding the site configuration: 

2 Redhat Linux (Ent 3 on HP/Intel)
2 Sun Solaris 9 (Sparc)
1 MS-SQL Server (Win2003 HP/Intel)
Coldfusion 7.0091690

The situation is that the client had a CMS developed by another company
using CF. The site is hosted at the host company but they apparently do
not have anyone that knows how to manage the CF box.  The hosting
company has contacted me for advice on why the services just stop
responding, so i'm basically stuck in the middle of all this.  My
background is with windows and not linux.

Any tips would be helpful or if anyone has any experience with this sort
of setup in the Calgary area let me know.

Jason





~|
ColdFusion MX7 and Flex 2 
Build sales & marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2

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

RE: Best way to restrict only one registration

[Dave Francis]

When we run similar competitions, we check their email (required to contact
winners, therefore probably valid and real)against a database, and just
don't add it if it's a duplicate. Then we carry on as if it was OK, "Thank
you for your entry" etc.

We don't mind if cheats want to waste their time trying to enter a dozen or
so.


-Original Message-
From: Bruce Sorge [mailto:[EMAIL PROTECTED]
Sent: Friday, February 23, 2007 3:51 PM
To: CF-Talk
Subject: Best way to restrict only one registration


I am looking for the best way to keep someone from registering in a
sweepstakes only once. What do you all recommend? I was thinking of using a
GUID but these are machine specific, right? I was also thinking of making it
so that when they enter their information I can check it against the
database and if there is a match, let them know they already registered. But
then again all they have to do is start over and enter information again.
Maybe using a special code or something?

Thanks,

Bruce




~|
Create Web Applications With ColdFusion MX7 & Flex 2. 
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/

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

Re: AJAX & back button

[Rey Bango]

Hi John,

Do you suggest that as a complimentary method? Also, this should take 
the form of a progressive enhancement correct?

Rey...

John Dowdell wrote:
> Richard Cooper wrote:
>> My question is what is the best way to cope with using back button and 
>> bookmarks.
> 
> Putting an "undo" button in your interface helps people avoid wondering 
> "If I hit the browser's back button will I still go back to the previous 
> HTML page?"
> 
> jd
> 
> 
> 
> 
> 

~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion

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

Re: AJAX & back button

[John Dowdell]

Richard Cooper wrote:
> My question is what is the best way to cope with using back button and 
> bookmarks.

Putting an "undo" button in your interface helps people avoid wondering 
"If I hit the browser's back button will I still go back to the previous 
HTML page?"

jd





-- 
John Dowdell . Adobe Developer Support . San Francisco CA USA
Weblog: http://weblogs.macromedia.com/jd
Aggregator: http://weblogs.macromedia.com/mxna
Technotes: http://www.macromedia.com/support/
Spam killed my private email -- public record is best, thanks.

~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/

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

Best way to restrict only one registration

[Bruce Sorge]

I am looking for the best way to keep someone from registering in a
sweepstakes only once. What do you all recommend? I was thinking of using a
GUID but these are machine specific, right? I was also thinking of making it
so that when they enter their information I can check it against the
database and if there is a match, let them know they already registered. But
then again all they have to do is start over and enter information again.
Maybe using a special code or something?

Thanks,

Bruce


~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/

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

RE: Server help - coldfusion services stop responding

[Lincoln Milner]

When I've seen this behavior on our servers, I get on a terminal
connection and run "cfstat".  That usually shows a large number of
queued requests and a handful (10 on our systems) that are hanging.  If
your boxes are robust enough, you can bump up simultaneous requests and
see if that clears the bottleneck.  Or your sim. reqs. setting is too
high now and the thing chokes.  We've had both those problems (it being
too low and too high; 10 is a good number for us now).

I'm trying to get SeeFusion or something similar in place to actually
see what 10 are hanging (so I can find the offending code), but
eventually the hanging threads time out, or I just bump CF and all is
well again.

Cheers!
Lincoln

-Original Message-
From: Jason Rogoz [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 23, 2007 3:44 PM
To: CF-Talk
Subject: Server help - coldfusion services stop responding

Hey guys

A client has asked me for some advise on a coldfusion server issue they
are having.  They are reporting that the coldfusion services just stop
responding when their site gets busy (i'm not sure at this point the
number of hits when they consider the site busy), but stopping and
starting the coldfusion services seems to fix the issue. They just don't
want to have to stop and start the services all the time.  

I have the following information regarding the site configuration: 

2 Redhat Linux (Ent 3 on HP/Intel)
2 Sun Solaris 9 (Sparc)
1 MS-SQL Server (Win2003 HP/Intel)
Coldfusion 7.0091690

The situation is that the client had a CMS developed by another company
using CF. The site is hosted at the host company but they apparently do
not have anyone that knows how to manage the CF box.  The hosting
company has contacted me for advice on why the services just stop
responding, so i'm basically stuck in the middle of all this.  My
background is with windows and not linux.

Any tips would be helpful or if anyone has any experience with this sort
of setup in the Calgary area let me know.

Jason



~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & 
Flex 2. 
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/

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

Server help - coldfusion services stop responding

[Jason Rogoz]

Hey guys

A client has asked me for some advise on a coldfusion server issue they are 
having.  They are reporting that the coldfusion services just stop responding 
when their site gets busy (i'm not sure at this point the number of hits when 
they consider the site busy), but stopping and starting the coldfusion services 
seems to fix the issue. They just don't want to have to stop and start the 
services all the time.  

I have the following information regarding the site configuration: 

2 Redhat Linux (Ent 3 on HP/Intel)
2 Sun Solaris 9 (Sparc)
1 MS-SQL Server (Win2003 HP/Intel)
Coldfusion 7.0091690

The situation is that the client had a CMS developed by another company using 
CF. The site is hosted at the host company but they apparently do not have 
anyone that knows how to manage the CF box.  The hosting company has contacted 
me for advice on why the services just stop responding, so i'm basically stuck 
in the middle of all this.  My background is with windows and not linux.

Any tips would be helpful or if anyone has any experience with this sort of 
setup in the Calgary area let me know.

Jason

~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion

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

Re: CF Pocket Reference?

[Steve Good]

removed the asterisks from the url

http://download.macromedia.com/pub/coldfusion/documentation/cfml_quick_ref.pdf



Steve Good
[EMAIL PROTECTED]
Portal Hosting
http://www.lanctr.com



mark wrote:
> That link doesn't seem to work for me.
>
> -Original Message-
> From: Casey Dougall [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 23, 2007 7:13 AM
> To: CF-Talk
> Subject: Re: CF Pocket Reference?
>
>
> Coldfusion MX came with a pocket ref. too.
>
> Printing it from PDF might not be what you're looking for but you can
> download it here.
>
> download.macromedia.com/pub/coldfusion/documentation/*cfml*_*quick*_ref.pdf
>
>
>
>
> 

~|
ColdFusion MX7 and Flex 2 
Build sales & marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270606
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 Pocket Reference?

[mark]

That link doesn't seem to work for me.

-Original Message-
From: Casey Dougall [mailto:[EMAIL PROTECTED]
Sent: Friday, February 23, 2007 7:13 AM
To: CF-Talk
Subject: Re: CF Pocket Reference?


Coldfusion MX came with a pocket ref. too.

Printing it from PDF might not be what you're looking for but you can
download it here.

download.macromedia.com/pub/coldfusion/documentation/*cfml*_*quick*_ref.pdf




~|
Create Web Applications With ColdFusion MX7 & Flex 2. 
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/

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

Re: AJAX & back button

[Rey Bango]

Thats very cool! Since I already use jQuery, I'm covered but I'll have 
keep this for future reference.

Rey...

Qasim Rasheed wrote:
> This is a library without using JQuery
> 
> http://codinginparadise.org/weblog/2005/08/ajax-tutorial-saving-session-across.html
> 
> Thanks
> 
> Qasim
> 
> On 2/23/07, Rey Bango <[EMAIL PROTECTED]> wrote:
>> Tackling the back button in Ajax isn't a trivial task and has really
>> frustrated a lot of developers. Several of the frameworks out there
>> offer back button support so you may want to consider switching.
>>
>> As Andy mentioned, jQuery (www.jquery.com) offers a plugin that supports
>> this functionality and makes it easy to implement.
>>
>> The plugin can be found here:
>>
>> http://www.stilbuero.de/jquery/history/
>>
>> Rey...
>>
>> Richard Cooper wrote:
>>> Hi all,
>>>
>>> I've a site that has a lot of onclick content changes using ajax. I'm a
>> creature of habit and have been using the same framework I started with,
>> Simple AJAX Code-Kit.
>>> My question is what is the best way to cope with using back button and
>> bookmarks. Should I change frameworks, or is there simple solutions out
>> there that can be appended to my current framework? I know there is a lot of
>> info out there in goolge land but a bit of guidance will probabley save me a
>> lot of time.
>>> Thanks,
>>>
>>> R
>>>
>>>
>>
> 
> 

~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion

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

Re: getAuthUser() not working

[Raymond Camden]

Are you running cflogin on EVERY rerquest? I believe it is required.
Even though the insides will be ignored when you are logged in - I
think CF has to "see" it to notice security crap.

On 2/23/07, Michael Beins <[EMAIL PROTECTED]> wrote:
> In my application.cfm file I have session management and client management 
> turned on I do not specify the loginstorage so it is using cookies to store 
> login information.  With the cflogin tags I call a custom tag I wrote to 
> handle the authentication.  I pass it the user name and password received 
> from the login form and if authenticated I use the cfloginuser tag with in 
> the custom tag.  I can log in just fine and use the secure section of my 
> site, I can find the cookie set by the cfloginuser tag, but the getAuthUser() 
> function returns an empty string.  I have also verified that I am not passing 
> an empty string to the cfloginuser tag for the name attribute.
>
> Any ideas?
>
> 

~|
Create Web Applications With ColdFusion MX7 & Flex 2. 
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/

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

RE: CF Admin error

[Jacob]

Nevermind.. fixed it!

The file component.cfc (which is 0 bytes) in wwwroot/web-inf/cftags/ was
missing.

 
-Original Message-
From: Jacob [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 23, 2007 11:21 AM
To: CF-Talk
Subject: CF Admin error

On one of my servers, I get the following error when I open the CF
administrator:

 

The system has attempted to use an undefined value, which usually indicates
a programming error, either in your code or some system code. 

 

Null Pointers are another name for undefined values. 



The error occurred in Application.cfm: line 113

-1 : Unable to display error's location in a CFML template.

 

Any ideas?

 

Windows 2003, IIS 6.0, CF 7.0.1

 

Thanks

Jacob





~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/

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

Re: AJAX & back button

[Qasim Rasheed]

This is a library without using JQuery

http://codinginparadise.org/weblog/2005/08/ajax-tutorial-saving-session-across.html

Thanks

Qasim

On 2/23/07, Rey Bango <[EMAIL PROTECTED]> wrote:
>
> Tackling the back button in Ajax isn't a trivial task and has really
> frustrated a lot of developers. Several of the frameworks out there
> offer back button support so you may want to consider switching.
>
> As Andy mentioned, jQuery (www.jquery.com) offers a plugin that supports
> this functionality and makes it easy to implement.
>
> The plugin can be found here:
>
> http://www.stilbuero.de/jquery/history/
>
> Rey...
>
> Richard Cooper wrote:
> > Hi all,
> >
> > I've a site that has a lot of onclick content changes using ajax. I'm a
> creature of habit and have been using the same framework I started with,
> Simple AJAX Code-Kit.
> >
> > My question is what is the best way to cope with using back button and
> bookmarks. Should I change frameworks, or is there simple solutions out
> there that can be appended to my current framework? I know there is a lot of
> info out there in goolge land but a bit of guidance will probabley save me a
> lot of time.
> > Thanks,
> >
> > R
> >
> >
>
> 

~|
ColdFusion MX7 and Flex 2 
Build sales & marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2

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

Re: Conext field in CFSearch

[Raymond Camden]

You have to enable this by doing contextPassages="N" in your cfsearch.

http://www.cfquickdocs.com/?getDoc=cfsearch

On 2/23/07, Orlini, Robert <[EMAIL PROTECTED]> wrote:
> Isn't there a CONTEXT field that can be used in the results set of a CFSEARCH?
>
> I tried it according to the CF MX7 book by Ben Forta and Raymond Camden (p. 
> 1128) but it does not display anything. I could be doing something wrong of 
> course. The book description for the tag is: "Context summary, with search 
> terms bolded". See code below.
>
> Robert O.
> HWW
>
> COLLECTION="database, print"
> TYPE="simple"
> MAXROWS="10"
> SUGGESTIONS="always"
>CRITERIA="#FORM.searchstring#">
>
> 
> #Searchme.context#
> 
>
>
> 

~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/

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

CF Admin error

[Jacob]

On one of my servers, I get the following error when I open the CF
administrator:

 

The system has attempted to use an undefined value, which usually indicates
a programming error, either in your code or some system code. 

 

Null Pointers are another name for undefined values. 



The error occurred in Application.cfm: line 113

-1 : Unable to display error's location in a CFML template.

 

Any ideas?

 

Windows 2003, IIS 6.0, CF 7.0.1

 

Thanks

Jacob



~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & 
Flex 2. 
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/

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

Re: Problem with Server Timing Out

[Jim H]

Are there any other suggestions?  I am hesitant to jump into new drivers.  It 
boggles me as to why the server is timing out while trying to connect to the 
SQL server.  

-JH

>> Where can I find or how can I switch to the jTDS drivers?  We are
>using
>> SQL2000 and a fresh install of 7.02.
>
>http://jtds.sourceforge.net/
>
>Rich Kroll

~|
ColdFusion MX7 and Flex 2 
Build sales & marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270598
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 Report Builder

[Ian Skinner]

At this time the Report Builder only runs on windows.  The reports built by it 
can be installed and run from any ColdFusion system, but the builder is windows 
only.


--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

-
| 1 |   |
-  Binary Sudoku
|   |   |
-
 
"C code. C code run. Run code run. Please!"
- Cynthia Dunning

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 




~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & 
Flex 2. 
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/

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

RE: Mail Spool Slow

[Russ]

The slowness is not a problem of the writing the files to the spool folder, 
it's actually pushing the files out.  We were able to generate the files fairly 
quickly, but cf only uses a single thread in the standard edition to push files 
out, so even though we had a dedicated mail server the files were going out 
slow.  

As I mentioned, if this hasn't been a problem before, and it is a problem now, 
most likely the culprit is the mail server. 

Russ

> -Original Message-
> From: Nick Tong - TalkWebSolutions.co.uk [mailto:[EMAIL PROTECTED]
> Sent: Thursday, February 22, 2007 6:58 PM
> To: CF-Talk
> Subject: Re: Mail Spool Slow
> 
> Hi Rob - it's based on a tag by Jochem van Dieten:
> http://www.vandieten.net/jochem/coldfusion/customtags/advancedemail/
> 
> it's rather old - but then so is the system. it works well though -
> sorry i can't share more but my client would be upset.  Let me know
> how you get on.
> 
> On 22/02/07, Rob Kopp <[EMAIL PROTECTED]> wrote:
> > Can you show me some code on how you're doing that?
> >
> > > FWIW: we send out thousands and i find it easier to write the files
> > > directly to the mail root instead of getting CF to send the email via
> > > the cf spool.
> >
> >
> >
> 
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/

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

CF Report Builder

[Ken K]

Does CF report Builder only run on a Windows? (see requirements link)

http://www.adobe.com/products/coldfusion/productinfo/systemreqs/#reportbuilder

~|
ColdFusion MX7 and Flex 2 
Build sales & marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2

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

RE: Problem with Server Timing Out

[Richard Kroll]

> Where can I find or how can I switch to the jTDS drivers?  We are
using
> SQL2000 and a fresh install of 7.02.

http://jtds.sourceforge.net/

Rich Kroll

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/

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

Language Mapping

[John Eubanks]

Anyone have a good way of language mapping something like content management 
system?  I was thinking of just setting a global variable (something like 
#currpage#) and calling it when a language gets chosen for a current page.

If any ideas, feel free to let me know:  [EMAIL PROTECTED]

~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion

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

Re: Problem with Server Timing Out

[Jim H]

Where can I find or how can I switch to the jTDS drivers?  We are using SQL2000 
and a fresh install of 7.02.

Thanks!

-JH

>> 
>> Error Executing Database Query.
>> [Macromedia][SQLServer JDBC Driver]A problem occurred when attempting
>to
>> contact the server (Server returned: Connection reset).
>
>I'm assuming that you are connecting to a MSSQL server.  We were running
>into these types of timeouts as well as handler errors.  We switched to
>the jTDS drivers instead of the built in CF drivers and this issue
>cleared up.
>
>HTH,
>
>Rich Kroll

~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & 
Flex 2. 
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/

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

CF and OpenLaszlo

[Phill B]

Has anyone on here gotten the two to play together? I'm wanting to
give it a try and was looking for any advice or gotchas that I should
be aware of.

Thanks

-- 
Phil

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270591
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 about looping and the first row in a column

[Andy Matthews]

Thanks Ben...

I'll take a look at that in a little bit! 

-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 23, 2007 11:21 AM
To: CF-Talk
Subject: RE: Question about looping and the first row in a column

Andy,

The way to do it without creating temp variables:

http://bennadel.com/index.cfm?dax=blog:546.view 


...
Ben Nadel
Certified Advanced ColdFusion MX7 Developer www.bennadel.com
 
Need ColdFusion Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Jim Wright [mailto:[EMAIL PROTECTED]
Sent: Friday, February 23, 2007 11:56 AM
To: CF-Talk
Subject: Re: Question about looping and the first row in a column

Andy Matthews wrote:
>  
> When I use that code, and compare to "tempFreq", the code works just
fine.
> Why is this happening? Does anyone have wisdom on this because it's 
> really irritating for me to have to have this extra line of code in
here. Anyone?
>  

I think about the best answer you are going to get is "because that is the
way it is".  It is kind of a rite of passage for CF developers when they
realize that one.

One thing I would look into, though, is whether you can re-write your
queries to use a single query, and then use cfoutput with the "group" 
attribute.  That will proably result in some cleaner looking code.  Most
likely faster, too.





~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270590
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 about looping and the first row in a column

[Ben Nadel]

Andy,

The way to do it without creating temp variables:

http://bennadel.com/index.cfm?dax=blog:546.view 


..
Ben Nadel
Certified Advanced ColdFusion MX7 Developer
www.bennadel.com
 
Need ColdFusion Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Jim Wright [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 23, 2007 11:56 AM
To: CF-Talk
Subject: Re: Question about looping and the first row in a column

Andy Matthews wrote:
>  
> When I use that code, and compare to "tempFreq", the code works just
fine.
> Why is this happening? Does anyone have wisdom on this because it's 
> really irritating for me to have to have this extra line of code in
here. Anyone?
>  

I think about the best answer you are going to get is "because that is
the way it is".  It is kind of a rite of passage for CF developers when
they realize that one.

One thing I would look into, though, is whether you can re-write your
queries to use a single query, and then use cfoutput with the "group" 
attribute.  That will proably result in some cleaner looking code.  Most
likely faster, too.



~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & 
Flex 2. 
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/

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

Re: Problem with Server Timing Out

[Oğuz Demirkapı]

And I heard same story from one of our customers.

They have MS SQL 2005 and they have updated latest JDBC drivers for 2005 
(http://msdn.microsoft.com/data/jdbc/) and lots of problems has been 
resolved.


Richard Kroll wrote:
>> 
>> Error Executing Database Query.
>> [Macromedia][SQLServer JDBC Driver]A problem occurred when attempting
>> 
> to
>   
>> contact the server (Server returned: Connection reset).
>> 
>
> I'm assuming that you are connecting to a MSSQL server.  We were running
> into these types of timeouts as well as handler errors.  We switched to
> the jTDS drivers instead of the built in CF drivers and this issue
> cleared up.
>
> HTH,
>
> Rich Kroll
>
>
>   


-- 

~~~

Oğuz Demirkapı

TeraTech Inc. | Senior Developer
405 East Gude Dr Suite 207, Rockville, MD 20850, USA
Voice: +1 (301) 424-3903 ext 111 | Fax: +1 (301) 762-8185
Web: http://www.teratech.com | E-mail: oguz.demirkapi  teratech.com
Winner in CFDJ awards Best Consulting. Member Team Fusebox.

~~~



~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion

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

RE: Problem with Server Timing Out

[Richard Kroll]

> 
> Error Executing Database Query.
> [Macromedia][SQLServer JDBC Driver]A problem occurred when attempting
to
> contact the server (Server returned: Connection reset).

I'm assuming that you are connecting to a MSSQL server.  We were running
into these types of timeouts as well as handler errors.  We switched to
the jTDS drivers instead of the built in CF drivers and this issue
cleared up.

HTH,

Rich Kroll

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270587
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 about looping and the first row in a column

[Jim Wright]

Andy Matthews wrote:
>  
> When I use that code, and compare to "tempFreq", the code works just fine.
> Why is this happening? Does anyone have wisdom on this because it's really
> irritating for me to have to have this extra line of code in here. Anyone?
>  

I think about the best answer you are going to get is "because that is 
the way it is".  It is kind of a rite of passage for CF developers when 
they realize that one.

One thing I would look into, though, is whether you can re-write your 
queries to use a single query, and then use cfoutput with the "group" 
attribute.  That will proably result in some cleaner looking code.  Most 
likely faster, too.

~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270586
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 about looping and the first row in a column

[Ben Nadel]

Andy,

I think that's just the nature of the beast. ColdFusion has to keep some
sort of internal model going for it's loops and when the get nested, I
think things get a bit screwy.

You might be able to accurately use the Current Row value:




#qOuterLoop[ "id" ][ qOuterLoop.CurrentRow ]#
#qINNERLoop.id#



A bit more verbose, but I think I heard that works.

..
Ben Nadel
Certified Advanced ColdFusion MX7 Developer
www.bennadel.com
 
Need ColdFusion Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 23, 2007 11:37 AM
To: CF-Talk
Subject: Question about looping and the first row in a column

I'm sure that other people have run into this, but I'm baffled as to why
this is happening. I have a query in the variables scope
(VARIABLES.GetThisNavigationLocation). I'm looping over this query just
like you would normally. Then, inside that loop, I'm looping over
another query
(VARIABLES.getChangeFrequencies) to build a dynamic dropdown. So for
each row in GetThisNavigationLocation, there's a dropdown containing
every row in getChangeFrequencies.
 
The problem is that inside the dropdown loop, the cfif seems to be using
the value from the very first row in the outer query in it's comparison
which results in every dropdown showing the same value, even though when
I dump the outer query, the values are clearly different.

selected>#VARIABLES.getChangeFr
eque
ncies.DisplayName#

 
The weird thing comes when I set a temp variable just outside the
dropdown loop like so:

 
When I use that code, and compare to "tempFreq", the code works just
fine.
Why is this happening? Does anyone have wisdom on this because it's
really irritating for me to have to have this extra line of code in
here. Anyone?
 

 
Andy Matthews
Senior Coldfusion Developer

Office:  877.707.5467 x747
Direct:  615.627.9747
Fax:  615.467.6249
[EMAIL PROTECTED]
www.dealerskins.com  
 




~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270585
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 about looping and the first row in a column

[Adrian Lynch]

Yarp, that's been around for a while. You're using the fix everyone else
does.

Adrian

-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED]
Sent: 23 February 2007 16:37
To: CF-Talk
Subject: Question about looping and the first row in a column


I'm sure that other people have run into this, but I'm baffled as to why
this is happening. I have a query in the variables scope
(VARIABLES.GetThisNavigationLocation). I'm looping over this query just like
you would normally. Then, inside that loop, I'm looping over another query
(VARIABLES.getChangeFrequencies) to build a dynamic dropdown. So for each
row in GetThisNavigationLocation, there's a dropdown containing every row in
getChangeFrequencies.

The problem is that inside the dropdown loop, the cfif seems to be using the
value from the very first row in the outer query in it's comparison which
results in every dropdown showing the same value, even though when I dump
the outer query, the values are clearly different.

selected>#VARIABLES.getChangeFreque
ncies.DisplayName#


The weird thing comes when I set a temp variable just outside the dropdown
loop like so:


When I use that code, and compare to "tempFreq", the code works just fine.
Why is this happening? Does anyone have wisdom on this because it's really
irritating for me to have to have this extra line of code in here. Anyone?



Andy Matthews


~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion

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

Re: Line Breaks in Plain Text CFMail - GRRR!

[Rebecca Younes]

Try this:

Attendee Name Badge:
#ARGUMENTS.rsvpUserBadgeName##carr#
Guest Name:
#ARGUMENTS.rsvpGuest01Name##carr#
Guest Name Badge:
#ARGUMENTS.rsvpGuest01BadgeName#

It keeps the extra line breaks within the cfifs, while still maintaining 
readable code.

>So how do I get rid of the extra lines where CFIF statements are bypassed in
>the code?  The savecontent var that I'm building has about 35 cfif
>statements. 
>
>-Original Message-
>From: Dave Phillips [mailto:[EMAIL PROTECTED] 
>Sent: Saturday, January 27, 2007 5:15 PM
>To: CF-Talk
>Subject: RE: Line Breaks in Plain Text CFMail - GRRR!
>
>Remove your 'supresswhitespace' tag.  That supresses carriage returns if I
>remember correctly.
>
>Dave
>
>-Original Message-
>From: Mark Leder [mailto:[EMAIL PROTECTED]
>Sent: Saturday, January 27, 2007 4:10 PM
>To: CF-Talk
>Subject: Line Breaks in Plain Text CFMail - GRRR!
>
>
>I just cannot get this to work. Sending plain text email, want to force a
>line break.  I've tried chr(10), chr(13), chr(13) & chr(10), with and
>without pound signs,  restarted CFMX7. The arguments are outputting
>correctly. What's the trick to this?
>
>
> 
>
>
>
>Attendee Name Badge:
>#ARGUMENTS.rsvpUserBadgeName##carr#
>Guest Name:
>#ARGUMENTS.rsvpGuest01Name##carr#
>Guest Name Badge:
>#ARGUMENTS.rsvpGuest01BadgeName#
>
>
>

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/

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

Question about looping and the first row in a column

[Andy Matthews]

I'm sure that other people have run into this, but I'm baffled as to why
this is happening. I have a query in the variables scope
(VARIABLES.GetThisNavigationLocation). I'm looping over this query just like
you would normally. Then, inside that loop, I'm looping over another query
(VARIABLES.getChangeFrequencies) to build a dynamic dropdown. So for each
row in GetThisNavigationLocation, there's a dropdown containing every row in
getChangeFrequencies.
 
The problem is that inside the dropdown loop, the cfif seems to be using the
value from the very first row in the outer query in it's comparison which
results in every dropdown showing the same value, even though when I dump
the outer query, the values are clearly different.

selected>#VARIABLES.getChangeFreque
ncies.DisplayName#

 
The weird thing comes when I set a temp variable just outside the dropdown
loop like so:

 
When I use that code, and compare to "tempFreq", the code works just fine.
Why is this happening? Does anyone have wisdom on this because it's really
irritating for me to have to have this extra line of code in here. Anyone?
 

 
Andy Matthews
Senior Coldfusion Developer

Office:  877.707.5467 x747
Direct:  615.627.9747
Fax:  615.467.6249
[EMAIL PROTECTED]
www.dealerskins.com  
 


~|
Create Web Applications With ColdFusion MX7 & Flex 2. 
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/

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

Conext field in CFSearch

[Orlini, Robert]

Isn't there a CONTEXT field that can be used in the results set of a CFSEARCH?

I tried it according to the CF MX7 book by Ben Forta and Raymond Camden (p. 
1128) but it does not display anything. I could be doing something wrong of 
course. The book description for the tag is: "Context summary, with search 
terms bolded". See code below.

Robert O.
HWW




#Searchme.context#



~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/

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

Re: Pass a form variable through a hyperlink

[Jim Wright]

[EMAIL PROTECTED] wrote:
> All,
> 
> Is there a way to pass a #form.variable#  to a form from a hyperlink?
> 
> I'm trying to pass a string to a processing page from a hyperlink becuase
> the processing page is not under our control and we're being told there's
> code to handle strings passed via the URL scope.
> 
> Any ideas?
> 

http://theremoteurl.com/somefile.cfm"; method="post" 
name="f" id="f">



The Hyperlink

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/

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

RE: Pass a form variable through a hyperlink

[Andy Matthews]

By default, any variable you pass using a URL goes into the URL scope.
They'd have to have some code on the other end to evaluate your
form.variable=78. 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 23, 2007 10:12 AM
To: CF-Talk
Subject: Pass a form variable through a hyperlink

All,

Is there a way to pass a #form.variable#  to a form from a hyperlink?

I'm trying to pass a string to a processing page from a hyperlink becuase
the processing page is not under our control and we're being told there's
code to handle strings passed via the URL scope.

Any ideas?

Thanks

D


~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & 
Flex 2. 
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/

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

Re: Pass a form variable through a hyperlink

[Charlie Griefer]

you can pass form variables directly in the URL by using the GET
method of the  tag (this is also the default method if you don't
specify one).



If you need a hyperlink from the form's action page, just add it to the URL.

http://www.xyz.com/page.cfm?myVar=#form.fieldName#";>click
here or you suck


On 2/23/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> All,
>
> Is there a way to pass a #form.variable#  to a form from a hyperlink?
>
> I'm trying to pass a string to a processing page from a hyperlink becuase
> the processing page is not under our control and we're being told there's
> code to handle strings passed via the URL scope.
>
> Any ideas?
>
> Thanks
>
> D
>
> 

~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion

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

Pass a form variable through a hyperlink

[coldfusion . developer]

All,

Is there a way to pass a #form.variable#  to a form from a hyperlink?

I'm trying to pass a string to a processing page from a hyperlink becuase
the processing page is not under our control and we're being told there's
code to handle strings passed via the URL scope.

Any ideas?

Thanks

D

~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion

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

RE: Is this the best approach?

[Bruce Sorge]

I found a JS solution for this. I can create a separate .js file and append
a new line to it when they add another sweepstakes. Hopefully that will do
the trick. 

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 22, 2007 8:50 PM
To: CF-Talk
Subject: RE: Is this the best approach?


> Thanks but I do not want to use IIS password protection. I
> wanted to use a ..htaccess page for redirects.

IIS doesn't use .htaccess. Apache uses it.

And in any case, .htaccess isn't designed for redirects, it's an
authentication mechanism. You can use mod_rewrite in Apache, or
ISAPI_Rewrite in IIS, to do what you want.

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!




~|
Create Web Applications With ColdFusion MX7 & Flex 2. 
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/

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

Re: Problem with Server Timing Out

[Tom Chiverton]

On Friday 23 Feb 2007, Eric Haskins wrote:
> Noticed this also I dont think this will cause a timeout but looks like a
> copy and paste error. The same query twice

I was talking about the main query outside the cfloop and cfif, but yes, good 
spot there Eric.
Though if the very first query had a WHERE clause, you'd only need the one 
query inside the loop - doubleplusgood.

-- 
Tom Chiverton
Helping to completely bully low-risk methodologies
at http://thefalken.livejournal.com



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at St 
James's Court Brown Street Manchester M2 2JF.  A list of members is available 
for inspection at the registered office. Any reference to a partner in relation 
to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law 
Society.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 8008.

For more information about Halliwells LLP visit www.halliwells.com.


~|
Create Web Applications With ColdFusion MX7 & Flex 2. 
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/

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

Re: Problem with Server Timing Out

[Jim H]

I made the following changes.














   


SELECT * FROM WebCompanies WHERE CompanyURL='#cgi.HTTP_HOST#'

















http://#getCompanyURLs.CompanyURL#/site.cfm"; 
addtoken="no">



  





  




I am getting this error:


Error Executing Database Query.  
[Macromedia][SQLServer JDBC Driver]A problem occurred when attempting to 
contact the server (Server returned: Connection reset). Please ensure that the 
server parameters passed to the driver are correct and that the server is 
running. Also ensure that the maximum number of connections have not been 
exceeded for this server.  
  
The error occurred in C:\Inetpub\WebSites\route.cfm: line 17
Called from Server returned: line -1
Called from C:\Inetpub\WebSites\route.cfm: line 17
 
15 : 
16 :
17 :SELECT * FROM WebCompanies WHERE CompanyURL='#cgi.HTTP_HOST#'
18 :
19 : 

 


 
SQLSELECT * FROM WebCompanies WHERE CompanyURL='www.jisdbenefits.com'  
DATASOURCE   WebSites 
SQLSTATE   HY000 
 
Resources: 
Check the ColdFusion documentation to verify that you are using the correct 
syntax. 
Search the Knowledge Base to find a solution to your problem. 

 
Browser   Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 
1.1.4322; .NET CLR 2.0.50727; InfoPath.1) 
Remote Address   216.14.33.34 
Referrer
Date/Time   23-Feb-07 09:54 AM 
 
Stack Trace (click to expand)  
at cfroute2ecfm1337773736.runPage(C:\Inetpub\WebSites\route.cfm:17) 
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]A problem occurred 
when attempting to contact the server (Server returned: Connection reset). 
Please ensure that the server parameters passed to the driver are correct and 
that the server is running. Also ensure that the maximum number of connections 
have not been exceeded for this server. at 
cfroute2ecfm1337773736.runPage(C:\Inetpub\WebSites\route.cfm:17) 


java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]A problem occurred 
when attempting to contact the server (Server returned: Connection reset). 
Please ensure that the server parameters passed to the driver are correct and 
that the server is running. Also ensure that the maximum number of connections 
have not been exceeded for this server.
at macromedia.jdbc.base.BaseExceptions.createException(Unknown Source)
at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source)
at macromedia.jdbc.sqlserver.tds.TDSRequest.receive(Unknown Source)
at 
macromedia.jdbc.sqlserver.tds.TDSExecuteRequest.submitRequest(Unknown Source)
at macromedia.jdbc.sqlserver.SQLServerImplStatement.execute(Unknown 
Source)
at macromedia.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at macromedia.jdbc.base.BaseStatement.executeInternal(Unknown Source)
at macromedia.jdbc.base.BaseStatement.execute(Unknown Source)
at 
coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:212)
at coldfusion.sql.Executive.executeQuery(Executive.java:753)
at coldfusion.sql.Executive.executeQuery(Executive.java:675)
at coldfusion.sql.Executive.executeQuery(Executive.java:636)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:236)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:500)
at cfroute2ecfm1337773736.runPage(C:\Inetpub\WebSites\route.cfm:17)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at 
coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:225)
at 
coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69)
at 
coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
at 
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at 
coldfusion.filter.RequestThrottleFilter.invoke(R

Re: Problem with Server Timing Out

[Eric Haskins]

-->   SELECT * FROM WebCompanies WHERE
CID=#getCompanyURLs.CID#
   
   
-->   SELECT * FROM WebCompanies WHERE
CID=#getCompanyURLs.CID#
   
   
   SELECT * FROM WebMainContent WHERE
CID=#getCompanyURLs.CID#
   


Noticed this also I dont think this will cause a timeout but looks like a
copy and paste error. The same query twice

Eric


~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270573
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 Pocket Reference?

[Steve Good]

There is a quick reference, but would take some tweaking when printing 
to get it into a small size.

http://download.macromedia.com/pub/documentation/en/coldfusion/mx7/cfmx7_cfml_qref.pdf


Steve Good
[EMAIL PROTECTED]
Portal Hosting
http://www.lanctr.com



Jim Wright wrote:
> In addition to a Pocket Reference book and the poster mentioned in 
> another thread, it would be nice to have a quick reference...something 
> like Allaire did for JSP here...
> http://tinyurl.com/38srt9 (PDF)
> There are bunch of other ones here...
> http://www.digilife.be/quickreferences/quickrefs.htm
>
> Was there ever a card like that produced for CF?
>
>
> 

~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion

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

Re: Problem with Server Timing Out

[Tom Chiverton]

On Friday 23 Feb 2007, Jim H wrote:
> I left the query open because I needed to select all the records in the
> table. 

Do you ?
>From the code you posted all you do is loop through them looking for one that 
matches the CGI variable. You could pull back just the one record...

> Will not having a WHERE statement in the query cause this kind of 
> problem?

Possibly. It certainly makes you DB and application servers work harder than 
they need to.

-- 
Tom Chiverton
Helping to preemptively fashion proactive clusters
at http://thefalken.livejournal.com



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at St 
James's Court Brown Street Manchester M2 2JF.  A list of members is available 
for inspection at the registered office. Any reference to a partner in relation 
to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law 
Society.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 8008.

For more information about Halliwells LLP visit www.halliwells.com.


~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270571
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 Pocket Reference?

[Michael Wright]

Ben was asking for peoples input about a month ago on the format of the
books for Scorpio.

It is quite a long thread but you can view the discussion and add your input
at:

http://www.forta.com/blog/index.cfm/2007/1/26/Book-Publishing-Dilemma-Input-
Requested

Bringing back a pocket version was one of the suggestions offered.



~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/

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

Re: Problem with Server Timing Out

[Jim H]

I left the query open because I needed to select all the records in the table.  
Will not having a WHERE statement in the query cause this kind of problem?

-JH


> On Friday 23 Feb 2007, Jim H wrote:
> > cachedWithin="#CreateTimeSpan(0,0,30,0)#"> SELECT CID, CompanyURL 
> FROM
> > WebCompanies
> > 
...
> 
> > 
> >
> > 
> 
> Why don't you just add a suitable WHERE clause to the query ?
> 
> -- 
> Tom Chiverton
> Helping to efficiently facilitate end-to-end solutions
> at http://thefalken.livejournal.com
> 
> 
> 
> This email is sent for and on behalf of Halliwells LLP.
> 
> Halliwells LLP is a limited liability partnership registered in 
> England and Wales under registered number OC307980 whose registered 
> office address is at St James's Court Brown Street Manchester M2 2JF.  
> A list of members is available for inspection at the registered office. 
> Any reference to a partner in relation to Halliwells LLP means a 
> member of Halliwells LLP. Regulated by the Law Society.
> 
> CONFIDENTIALITY
> 
> This email is intended only for the use of the addressee named above 
> and may be confidential or legally privileged.  If you are not the 
> addressee you must not read it and must not use any information 
> contained in nor copy it nor inform any person other than Halliwells 
> LLP or the addressee of its existence or contents.  If you have 
> received this email in error please delete it and notify Halliwells 
> LLP IT Department on 0870 365 8008.
> 
> For more information about Halliwells LLP visit www.halliwells.com.

~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion

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

MX6.1 cfindex custom2 max length?

[Dave Phillips]

Does anyone know what the limit of length of a custom2 field in CFINDEX is?
I'm running into what appears to be 2,047 characters, but I want to confirm
(especially be able to find in docs if I can).
 
I can't find it specified anywhere.
 
Thanks!
 
Dave



~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & 
Flex 2. 
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/

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

Re: getAuthUser() not working

[[EMAIL PROTECTED]]

What are your Directory Security Settings in IIS? If it is anonymous I 
believe it will appear to be working as far as logging in, however there 
will be no AuthUser.  Just something to check.



Michael Beins wrote:
> In my application.cfm file I have session management and client management 
> turned on I do not specify the loginstorage so it is using cookies to store 
> login information.  With the cflogin tags I call a custom tag I wrote to 
> handle the authentication.  I pass it the user name and password received 
> from the login form and if authenticated I use the cfloginuser tag with in 
> the custom tag.  I can log in just fine and use the secure section of my 
> site, I can find the cookie set by the cfloginuser tag, but the getAuthUser() 
> function returns an empty string.  I have also verified that I am not passing 
> an empty string to the cfloginuser tag for the name attribute.
>
> Any ideas?
>
> 

~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion

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

Re: Problem with Server Timing Out

[Tom Chiverton]

On Friday 23 Feb 2007, Jim H wrote:
> cachedWithin="#CreateTimeSpan(0,0,30,0)#"> SELECT CID, CompanyURL FROM
> WebCompanies
> 
...
>   
>
>   

Why don't you just add a suitable WHERE clause to the query ?

-- 
Tom Chiverton
Helping to efficiently facilitate end-to-end solutions
at http://thefalken.livejournal.com



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at St 
James's Court Brown Street Manchester M2 2JF.  A list of members is available 
for inspection at the registered office. Any reference to a partner in relation 
to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law 
Society.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 8008.

For more information about Halliwells LLP visit www.halliwells.com.


~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/

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

Re: AJAX & back button

[Rey Bango]

Tackling the back button in Ajax isn't a trivial task and has really 
frustrated a lot of developers. Several of the frameworks out there 
offer back button support so you may want to consider switching.

As Andy mentioned, jQuery (www.jquery.com) offers a plugin that supports 
this functionality and makes it easy to implement.

The plugin can be found here:

http://www.stilbuero.de/jquery/history/

Rey...

Richard Cooper wrote:
> Hi all,
> 
> I've a site that has a lot of onclick content changes using ajax. I'm a 
> creature of habit and have been using the same framework I started with, 
> Simple AJAX Code-Kit.
> 
> My question is what is the best way to cope with using back button and 
> bookmarks. Should I change frameworks, or is there simple solutions out there 
> that can be appended to my current framework? I know there is a lot of info 
> out there in goolge land but a bit of guidance will probabley save me a lot 
> of time.
> Thanks,
> 
> R
> 
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/

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

Problem with Server Timing Out

[Jim H]

I really need help with this one.  I use this page to route a user to a 
specific URL depending on the HTTP_Host.  Does anyone see anything in this code 
that would cause a user's session to drop or cause a time-out on the server?
 This is basically an app that has many different URLs but passes a CID to a 
generic set of pages that displays the URL's site. (It is for school benefit 
sites where each school has a different set of information, but the code is the 
same for each site)

Thanks!  JH

--


SELECT CID, CompanyURL FROM WebCompanies




   



















SELECT * FROM WebCompanies WHERE 
CID=#getCompanyURLs.CID#


SELECT * FROM WebCompanies WHERE 
CID=#getCompanyURLs.CID#


SELECT * FROM WebMainContent WHERE 
CID=#getCompanyURLs.CID#















http://#getCompanyURLs.CompanyURL#/site.cfm"; addtoken="no">





  



  





--

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/

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

getAuthUser() not working

[Michael Beins]

In my application.cfm file I have session management and client management 
turned on I do not specify the loginstorage so it is using cookies to store 
login information.  With the cflogin tags I call a custom tag I wrote to handle 
the authentication.  I pass it the user name and password received from the 
login form and if authenticated I use the cfloginuser tag with in the custom 
tag.  I can log in just fine and use the secure section of my site, I can find 
the cookie set by the cfloginuser tag, but the getAuthUser() function returns 
an empty string.  I have also verified that I am not passing an empty string to 
the cfloginuser tag for the name attribute.

Any ideas?

~|
Create Web Applications With ColdFusion MX7 & Flex 2. 
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/

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

Re: AJAX & back button

[Richard Cooper]

Cheers Andy, I'll check that out now.

~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270562
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 Pocket Reference?

[Jim Wright]

In addition to a Pocket Reference book and the poster mentioned in 
another thread, it would be nice to have a quick reference...something 
like Allaire did for JSP here...
http://tinyurl.com/38srt9 (PDF)
There are bunch of other ones here...
http://www.digilife.be/quickreferences/quickrefs.htm

Was there ever a card like that produced for CF?


~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & 
Flex 2. 
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/

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

Re: CF Pocket Reference?

[Steve Good]

Nice! Not a pocket size, but definitely something I can toss in a binder 
and leave in the office.  I'm already on my 3rd CF WACK because some 
joker took it from my desk while I was out.

-- 
~Steve Good
[EMAIL PROTECTED]
Portal Hosting
http://www.lanctr.com


Casey Dougall wrote:
> Coldfusion MX came with a pocket ref. too.
>
> Printing it from PDF might not be what you're looking for but you can
> download it here.
>
> download.macromedia.com/pub/coldfusion/documentation/*cfml*_*quick*_ref.pdf
>
>
> 

~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion

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

RE: AJAX & back button

[Andy Matthews]

The jQuery library has a "back button" plugin that automatically manages
back button clicks. It works a treat.

-Original Message-
From: Richard Cooper [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 23, 2007 2:31 AM
To: CF-Talk
Subject: AJAX & back button

Hi all,

I've a site that has a lot of onclick content changes using ajax. I'm a
creature of habit and have been using the same framework I started with,
Simple AJAX Code-Kit.

My question is what is the best way to cope with using back button and
bookmarks. Should I change frameworks, or is there simple solutions out
there that can be appended to my current framework? I know there is a lot of
info out there in goolge land but a bit of guidance will probabley save me a
lot of time.
Thanks,

R



~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion

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

RE: CF Pocket Reference?

[Andy Matthews]

The one for CF5 wasn't really a "pocket" reference. It was a trade-sized 
paperback (I have it sitting right beside me). I'd love to have one like 
O'Reilly puts out that's the size of a normal sized paperback. That would be 
excellent!

-Original Message-
From: Eric Roberts [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 22, 2007 11:46 PM
To: CF-Talk
Subject: RE: CF Pocket Reference?

They published one for 5...I don’t know if there is one for 7 (hint hint 
Ben and Ray *snicker*).  I made a lot of use of the one for 5...which is still 
relavant for most tags and functions.  I don’t know if you can still get 
it or not.

Eric

-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 22, 2007 11:21 PM
To: CF-Talk
Subject: Re: CF Pocket Reference?

I have the SQL and PL/SQL pocket refs  - I agree that a CF one would be really 
useful to many folks.

On 2/23/07, Andy Matthews wrote:
> I'd buy that in a heartbeat
>
>
> -Original Message-
> From: Steve Good
> Sent: Thursday, February 22, 2007 4:37 PM
> To: CF-Talk
> Subject: OT: CF Pocket Reference?
>
> I have a PHP and a MySQL Pocket Reference from O'Reilly.  I was 
> wondering if there was a Pocket Reference for CF MX 7.  I love my CF 
> WACK, but it's not very portable, would love to find something similar to the 
> others I have.

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





~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270558
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 7.0 Tags and Functions Poster

[Wolfe, Aaron]

I haven't done a thing about it. :(
Aaron 

-Original Message-
From: DURETTE, STEVEN J (ASI-AIT) [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 22, 2007 5:02 PM
To: CF-Talk
Subject: RE: ColdFusion 7.0 Tags and Functions Poster

This chopped off my reply under my other account.

What I posted was...

Has any more been heard about this. I got my upgrade from MX6 to MX7
through a maintenance agreement, so I didn't get updated documentation
or the poster.

I'd like to know where I can get a copy of the poster or even a PDF.
I'm desperate enough to cut/tape 8 1/2x11 sheets of paper to make the
poster, I just want the updated one.

Steve


-Original Message-
From: Steven Durette [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 22, 2007 3:46 PM
To: CF-Talk
Subject: Re: ColdFusion 7.0 Tags and Functions Poster


> I think he's talking about the big blue and white one from Adobe, not
> the TeraTech version.  I don't know where to get one, I got mine at
> CFUnited 06.
> 
> > -Original Message-
> > From: Bryan Stevenson [mailto:[EMAIL PROTECTED] 
> > Sent: Thursday, October 26, 2006 2:04 PM
> > To: CF-Talk
> > Subject: Re: ColdFusion 7.0 Tags and Functions Poster
> > 
> > Talk to Michael at Tera-tech...he's probably already seen 
> > your post ;-)
> 
->
-
> This transmission may contain information that is privileged, 
> confidential and/or exempt from disclosure under applicable law. If 
> you are not the intended recipient, you are hereby notified that any 
> disclosure, copying, distribution, or use of the information contained

> herein (including any reliance thereon) is STRICTLY PROHIBITED. If you

> received this transmission in error, please immediately contact the 
> sender and destroy the material in its entirety, whether in electronic

> or hard copy format. Thank you. 
> 
=>
=
> "EMF " made the previous annotations.





~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/

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

Spring Conference 2007

[David Hannum]

Spring  Conference 2007
Thursday, March 22, 2007
Athens, OH

Join us for our fifth annual event.  This year the conference will be bigger
than ever.  35 sessions to choose from in 7 tracks, plus three hands on
sessions!  Ben Forta, Adobe's Chief Product Evangelist will be speaking at
the General Session Key Note plus, Ben will be back to give a presentation
at the Lunchtime Session as well.

Choose from session in the following tracks:
Design & User Experience
Using Tools: Tips & Tricks
ColdFusion, Java, PHP & ActionScript
Maximum Development
Web 2.0: Ajax, Flex & Video
Application Security & Performance
Vendor Showcase
Boot Camp: Beginner Level Hands On

Some of this year's speakers include:
Ben Forta, Phillip Kerman, Joseph Lowery, Chris Bate,  Rob Gonda, John
Cummings, D.Lee Beard, Bob Paquette, Dan Switzer, Bailey Bruce, Doug Ward,
Steve Drucker, James Shore, James Shore, Joshua Logsdon, Scott Cantor,
Kevin Hoyte, Jeff Carnes, Joel Stanley, Gary Kraeger, more.

We'll have the Vendor Expo where you can meet with the companies that
provide the software and services you're looking for!

Registration Fee:  $35 [includes your lunch]

Registration is available at http://www.sbconference.com

We hope to see you there!

Spring  Conference 2007 is presented by the Southeast Ohio Creative
Adobe Technologies User Group in partnership with Ohio University, the IT

~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion

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

Re: CF Pocket Reference?

[Casey Dougall]

Coldfusion MX came with a pocket ref. too.

Printing it from PDF might not be what you're looking for but you can
download it here.

download.macromedia.com/pub/coldfusion/documentation/*cfml*_*quick*_ref.pdf


~|
Create Web Applications With ColdFusion MX7 & Flex 2. 
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/

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

Re: Managing multiple CF7 instances to one IIS site

[Beru]

Thank you all for your comments!

Just to re-focus the discussion, I will describe a bit further my procedure,
which "half-works" up to now:

A. Create the instance
1.Login to the ColdFusion Administrator of the default instance
2.Got to Enterprise manager -> instance manager
3.Add a new instance.
Server name: 
Create Windows Service: check this box
Auto Restart Service: check this box

B. Permissions and access for this instance
1.If not already done, create a security group called "CFMXInstances" in
the "/Groups/Web" OU. This group holds all the service accounts for the
different instances.
2.Give this group access to the following folders:
C:\Jrun4\->RX
C:\jrun4\logs\->RW
F:\logs\CF\->RW
F:\CF Cache\->RW
3.Create the user "" in the "Service Accounts" OU:
- Document it in the "Description" field
- Set password to never expire
- Remove remote desktop/terminal services access
4.Make this user a member of the group "CFMX Instances" that you created
above.
5.Give the "" user the following permissions:
C:\jrun4\servers\ApplicationName\->RW
E:\www\\Repository\\->RW
E:\www\\Scripts\\->RO
Please note that these are the standard paths, exceptions may occur!
6.Edit the windows service that ColdFusion will have created
(e.g"Macromedia CFMX AS ", and set it to Log On as
the user
created in step 3. You will be advised by the system that "This account has
been granted Logon as Service rights -> acknowledge.

C. Updating windows services for custom jvm.config files
We now need to edit the windows services for the new instance, to use a
given jrun config file.
1.Run REGEDIT
2.Edit the following KEY.
HKEY_LOCAL_MACHINE/system/CurrentControlSet/Services
3.Select the service "Macromedia CFMX AS "
4.Edit the "Parameters" attribute, if it does not exist, create it (add
new string value). Set the value of this to "-config
C:\JRun4\servers\\jvm.config".
5.Edit the "SystemErr" attribute and set it's value to "F:\Logs\CF\{
jrun.server.name}\{jrun.server.name}-err.log"
6.Edit the "SystemOut" attribute and set it's value to "F:\Logs\CF\{
jrun.server.name}\{jrun.server.name}-out.log"
More info on creating custom jvm.config files can be found here:
http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_18206
7.From the Management Console, start the service "Macromedia CFMX AS
"
8.From the default CFADMIN, go to the instance manager and launch the
CFADMIN for the instance you just added. It will have the same password by
default.

D. Configuring IIS to use your new instance
CF is enabled at the master level in W2K3 by a wildcard mapping in the IIS
master properties. This will be applied to all new sites.
- Open the IIS Manager and take note of the site ID that you want to add the
CF instance to:
- Open "C:\JRun4\lib\wsconfig\wsconfig.properties". Copy the last section of
3 lines, and modify this section as following:
o=IIS,,false,""
o.srv=localhost,""
o.cfmx=true,
Where:
oX=Next number in sequence
oY=IIS site ID
oZ=

- Save the "wsconfig.properties" file.
- Copy the last directory  in "C:\JRun4\lib\wsconfig\" and rename it using
the same sequential number as in the "wsconfig.properties" file:
- In the renamed directory, change the following lines to match the correct
instance:
oserverstore=C:/JRun4/lib/wsconfig//jrunserver.store
obootstrap=127.0.0.1:
where:
oX=the sequential number, used in the "wsconfig.properties" file
oY=the "Proxy" port number, as defined in the JRUN Admin console
- Add the application in IIS management console.
1. Right-click on the directory hosting the application -> select
"Properties" ->"Create"
2. Change "Execute Permissions" to "Scripts Only"
3. Click "Configuration"
4. Click "Edit"
- Browse to add the correct "jrun_iis6_wildcard.dll" extension (this links
the IIS application to the correct CF Instance)
- Authorize IIS to use that mapping:
1. Open "Web Service Extensions"
2. Tab "Required Files"
3. Click "Add…"
4. Browse…
5. Select the appropriate "jrun_iis6_wildcard.dll"


Sorry for this lengthy post, just wanted you to see all the steps I use.
Now, it works on all machines up to step D., where I link the CF Instance to
the IIS site. This step works on 1 of the machines, not on the 2 other...
Any ideas why?

Thanks a million!



On 2/23/07, Matthew Williams < [EMAIL PROTECTED]> wrote:
>
> Yep, great article.  I use this in several environments.  Coupled with
> Robi Sens's JVM tuning, and you get many a happy environment.
>
> Matthew Williams
> Geodesic GraFX
> www.geodesicgrafx.com/blog
>
> Mark A Kruger wrote:
> > I have a decent post on how to get multi server installed with different
> JVM
> > settings per instance.
> >
> > http://www.coldfusionmuse.com/index.cfm/2006/4/17/multiserver
> >
> > -Mark
> >
> > -Original Message-
> > From: Ben Forta 

AJAX & back button

[Richard Cooper]

Hi all,

I've a site that has a lot of onclick content changes using ajax. I'm a 
creature of habit and have been using the same framework I started with, Simple 
AJAX Code-Kit.

My question is what is the best way to cope with using back button and 
bookmarks. Should I change frameworks, or is there simple solutions out there 
that can be appended to my current framework? I know there is a lot of info out 
there in goolge land but a bit of guidance will probabley save me a lot of time.
Thanks,

R

~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & 
Flex 2. 
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/

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