ColdFusion memory leaks

2010-05-14 Thread Qing Xia

Hi,

I am new to ColdFusion server monitoring, so I am trying to get some ideas
here to get me move in the right direction.

We have a situation where our production ColdFusion applications are using
more and more memory until they bring the server to a halt. I was informed
(I am new here) that our systems administrator actually wrote a batch script
to automatically restart the ColdFusion server every Sunday morning to avoid
this very problem. Despite this, the memory leaks still make it necessary to
manually restart the ColdFusion server from time to time (could be every
couple of weeks).

CF8 comes with pretty decent server monitoring tools including memory
monitoring but I dare not run it in production since it is such a memory
monster. Without purchasing other monitoring software like SeeFusion or
BlueDragon, what are my options here? I see that there is an option in
CFAdmin to periodically recycle JVM memory once it reaches a threshold, but
I am a little too concerned to use it--it is not really like fixing the
problem.

Any idea will be most appreciated!

Thanks,

Qing Xia


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


Re: Scheduled task isn't running the item in the url

2010-04-21 Thread Qing Xia

Logging is your friend. :-) Create a log file for your scheduled task.

Does this page sit in an application that requires authentication? If so,
make sure to specify the username and password.

On Wed, Apr 21, 2010 at 10:48 AM, daniel kessler  wrote:

>
> I have the following task (CF7).  The URL that it specifies is not being
> run.  This is my first task so I assume I'm doing something wrong.  I run
> that url separately and it works fine.  I check my list of scheduled tasks
> and my task shows up in that list and appears to be set up the way I expect.
>  However, it doesn't work.  What the heck is wrong with it?
>
>
> Help. . . please . . .
>
>
> 
> 
> 
>
>
> action="update"
>task="facilities_daily_notification"
>interval="600"
>operation="httprequest"
>startdate="#start_date#"
>starttime="#start_time#"
>url="
> http://sph.umd.edu/home/facilities_request/email/daily_notifcation.cfm";
> >
>
> 

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


Re: ColdFusion dateDiff() function?

2010-04-05 Thread Qing Xia

Hmm... thanks Brad and Mike for your quick replies. I have thought about
your answers deeply and decided they do make sense. :-)

I read the CF Docs too quickly and made the assumption (never good to
assume!) that the CF dateDiff() function works the same way as the SQL
dateDiff() function, which says: "When the user tells me where to look, I
only look at that value." So a specified "d" means disregard the hour and
minute values, and just return the difference in days.

Thanks again for your input!

On Mon, Apr 5, 2010 at 10:41 PM, Mike Chabot  wrote:

>
> If only two minutes separate timestamps, that is less than a day from
> my perspective, so the value should be 0. If 24 hours separate the two
> timestamps, that would be a one day difference.
>
> There are plenty of solutions to the problem. One is to remove the
> time element before doing the comparison. The best solution would
> depend on what you are trying to achieve, which I could only guess at.
>
> -Mike Chabot
>
> On Mon, Apr 5, 2010 at 10:05 PM, Qing Xia  wrote:
> >
> > Okay, I am probably splitting hairs over here, but I ran into an icky
> > situation with the native ColdFusion function DateDiff() today and just
> > thought I'd check whether anyone else has experienced this before.
> >
> > Basically, I wrote a CF Scheduled Task that is supposed to go to a
> directory
> > and delete all PDF files that are created before today. Simple enough,
> > right? It should be really, but the DateDiff() function is behaving
> > strangely. Try running the code below:
> >
> > 
> > 
> > today - yesterday = #dateDiff("d",yesterday,today)#
> >
> > You see how it thinks the the date difference is ZERO??? Shouldn't it be
> > ONE???!!! There are ways to get around this (elegantly or otherwise)...
> but
> > now I am just irked and curious. Is this expected behavior and I am just
> not
> > understanding the function correctly or is this a bug that should get
> fixed?
> >
> >
> >
>
> 

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


Re: Best way to return generated html from cfc

2010-04-05 Thread Qing Xia

I have a cfc that will generate some html to be displayed inline.  I
was just going to reuturn a string rather than have it output directly.  Is
this the proper way to do that?

I've been struggling to draw a clear line between the usage of CFCs and
Custom Tags, but one general trend I see developers practicing seems to be
to put "display code for reuse" in Custom Tags rather than in CFCs. For
example, I have a Custom Tag that can spit out either a printable HTML
invoice or the same invoice in PDF--and customize contents of the invoice
based on user input. The same logic can very well be encapsulated in a CFC
instead, but the Custom Tag is better for black-box processing like this
one. It's hard to tell without knowing more of your situation, but just
thought I'd share the thought. :-)


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


ColdFusion dateDiff() function?

2010-04-05 Thread Qing Xia

Okay, I am probably splitting hairs over here, but I ran into an icky
situation with the native ColdFusion function DateDiff() today and just
thought I'd check whether anyone else has experienced this before.

Basically, I wrote a CF Scheduled Task that is supposed to go to a directory
and delete all PDF files that are created before today. Simple enough,
right? It should be really, but the DateDiff() function is behaving
strangely. Try running the code below:



today - yesterday = #dateDiff("d",yesterday,today)#

You see how it thinks the the date difference is ZERO??? Shouldn't it be
ONE???!!! There are ways to get around this (elegantly or otherwise)... but
now I am just irked and curious. Is this expected behavior and I am just not
understanding the function correctly or is this a bug that should get fixed?


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


Re: Decrypt CF scheduled job password?

2010-04-05 Thread Qing Xia

Thanks to all who replied! Your suggestions on Googling "coldfusion decrypt
datasource password" were most helpful.

I just switched jobs where my new job practices Agile Programming (a.k.a.
paired programming). While this practice is so far interesting and
rewarding, it has definitely reduced my reading time on the CFTalk list. :-(
Need to catch up on all the interesting discussions going on here.

On Wed, Mar 31, 2010 at 8:40 AM, Paul Alkema wrote:

>
> Yeah if you do google "coldfusion decrypt datasource password" make sure
> you
> click on what's currently the 4th option entitled "How To Crack Coldfusion
> Datasources ". I think you'll find that the most helpful. ;)
>
> Paul Alkema
> AlkemaDesigns.com
>
>
> -Original Message-
> From: b...@bradwood.com [mailto:b...@bradwood.com]
> Sent: Tuesday, March 30, 2010 10:45 PM
> To: cf-talk
> Subject: RE: Decrypt CF scheduled job password?
>
>
> I've never tried it, but if the cron passwords are stored the same way
> data source passwords are, then they probably are crackable.
> Google "coldfusion decrypt datasource password"
>
> Note:  The people who figured out how to decrypt CF passwords had to
> decompile CF's source Java code so enter at your own legal risk.  :)
>
> ~Brad
>
>
>  Original Message 
> Subject: Decrypt CF scheduled job password?
> From: Qing Xia 
> Date: Tue, March 30, 2010 8:09 pm
> To: cf-talk 
>
>
> Hello folks,
>
> I was just wondering, does anyone happen to know if the password in the
> CF
> scheduled job XML file (cfroot\lib\neo_cron.xml) is crackable?
>
>
>
>
> 

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


Decrypt CF scheduled job password?

2010-03-30 Thread Qing Xia

Hello folks,

I was just wondering, does anyone happen to know if the password in the CF
scheduled job XML file (cfroot\lib\neo_cron.xml) is crackable? I swear, I
have no ill intent! I am only just curious! :-) (no, seriously) The "char
code" value in the password block looks suspiciously like some kind of key
for decryption so it just got me thinking...

Anyway, here is what the neo_cron.xml file in my own development (CF9) looks
like.  I put in test/test as username/password in the CFAdmin scheduled job
interface.

  test
 -  (/:/!LJ*'XN@

  Thanks in advance for your thoughts!

  Cheers,

  Qing Xia


 - 


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


Re: onSessionEnd not firing

2010-02-17 Thread Qing Xia

>
> Why are the values for cookies the same as before? I thought expired
> cookies don't get sent by the browser anymore. But maybe I am mistaken and
> the CF server checks if cookies are expired?
>

If I remember correctly, the jSessionID/CFID/CFToken values are associated
with the browser instance, not the session instance.  If you did this in IE,
then open up another browser and go to the same test page.  You should see
that the jSession/CFID/CFToken values in your log file is now different.


> Why is the onSessionEnd handler not called? If I remove the ## stuff in
> onSessionEnd() so there's just text logged, it also does not appear in my
> log, suggesting it does not fire.

This is bad since I cannot rely on a sessionEnd e.g. handler to end a user
> session via 


I have found this very confusing myself as well. However, the fact that
onSessionStart() gets called again indicates that it is indeed a new
session--that the previous session has ended. If you try the following code,
and go to the test page intermittently, you will see that every time
onSessionStart() gets called, the session scope (with the exception of
CFID/CFToken) values are empty.  If I understand you correctly--you want to
use  to force login again after the user has been idle for 10
seconds or longer, correct? If that is the case, you can either do  in your application.cfc or put
idleTimeOut="10" in your  tag.  Both methods logs the user out when
they have been idle for at least 10 seconds. I'd go with the first method
because it is good to have session timeout value equal the login timeout.
Generally, you only need to use  when you want to give users the
option of manually expiring their own sessions before the session timeout
value is reached.  Hope this helps!

*In your Application.cfc: *








 







 

I am a new session--put the user login form here!!


 


 



*In your test file: *

Hello world, and the time now is: #NOW()#!






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


Re: jquery ajax tabs & cfinclude

2010-02-17 Thread Qing Xia

>
>
> Apologies, I found what I was doing wrong :
>
> http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330837
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: jquery ajax tabs & cfinclude

2010-02-17 Thread Qing Xia

I do not believe you could include query strings after the template name
when you are doing cfinclude.

You can use  instead, or you can do cfmodule and pass in
the values in ATTRIBUTES, like you would with a custom tag.

On Wed, Feb 17, 2010 at 1:01 PM, Sachin Mohan  wrote:

>
> Code would help, right - here it is :
>
> CODE:
> --
>
> Here's my js call to add new tabs:
> $("#tabcontent").tabs("add",pgurl + "?mln=" + MNUM, tabtitle.substr(0,
> 18));
>
> Here's the coldfusion page  that the above line calls:
> 
> 
>
> 
> 
>
> 
>   
> 
> 
>
>
> Firebug response:
> ---
> The web site you are accessing has experienced an unexpected error.
> ...
> Could not find the included template divShInstr.cfm?MLN=94197969
>
>
> divMkApp.cfm and divShInstr.cfm are in the same directory..
>
> Thank you!
>
>
>
>
>
> 

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


Re: jquery ajax tabs & cfinclude

2010-02-17 Thread Qing Xia

Actually I took out all the complication and put the cfincluded files in the
same directory as the calling page "dispAppointments.cfm". It still gives
the same issue.

Hmm... peculiar. What happens if your put the following code directly into
your jQuery tabs?








Your file exists in this directory (#variables.thisDirectory#):
#GetFileFromPath("#variables.thisPath#/#variables.yourFile#")#







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


Re: Combing Multiple Queries Into One Table

2010-02-10 Thread Qing Xia

>
> Ok, I have multiple queries. I have to have multiple queries to massage the
> data differently for some of the columns. I want to combine all those
> queries into one table or cfgrid. How do I do that?
>

Check out the Query...() functions such as QueryNew(), QueryAddColumn() and
etc.

The other option to consider is to use SQL Server (or whatever your back-end
database is) to do the heavy-lifting data manipulation.  It is usually much
faster, and tends to create cleaner code.


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


Re: IDE for coldfusion 9

2010-02-09 Thread Qing Xia

>
> The default is in the global prefs (Windows > Preferences), and each
> project has it's own setting the project properties.
>
>
Neat, thanks! One more reason to like CFEclipse! [?]


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


Re: IDE for coldfusion 9

2010-02-09 Thread Qing Xia

Well, well, the lesson is never to assume. My version of CFEclipse was *NOT*
the latest. The latest is 1.3.5.201002010103. Once I upgraded my CFEclilpse
plugin, I am defaulted to the CF9 dictionary.

BTW, the dropdown at the top of Dictionary View lets you select which
version of the dictionary you want..


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


Re: IDE for coldfusion 9

2010-02-09 Thread Qing Xia

>
> You have to specify which version of CF you're using on your project,
> and if you upgraded, you'll still be set on CF8.  Not sure what the
> default is, but it could well be CF8 as well, since CF9 is still lower
> adoption.
>
>
>
Oh yeah, you are right Barney. My dictionary view is set to CF8. Trying to
figure out how to update it to CF9 now...


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


Re: IDE for coldfusion 9

2010-02-09 Thread Qing Xia

>
>
> > Can anyone tell me if there is a new CFEclipse plugin for Coldfusion 9?
>

I am using CFEclipse plugin version 1.3.4.200906240705, which seems to be
the latest version.  I noticed certain new CF9 tags, such as CFIMAP, are not
recognized.


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


Re: with specific folders?

2010-02-07 Thread Qing Xia

- When polling Gmail, the item counts returned by cfimap may not match the
same in Gmail (Gmail bug).
You are right on this one, Aaron.  Gmail groups messages by "conversation",
which is really just the email subject lines. For example, I've got this
Gmail folder that has 8 "conversations" but 15 individual email "messages".
However, when I used CFImap to download all messages in that folder, I got
only 10! Upon closer examination, I saw that this is because 5 of the email
messages are from me myself but they got grouped in the "conversations"
because they share the subject lines with those who legitimately belong in
this folder.

I guess if you think about this, it sort of makes sense since the email
messages sent by me are really in the "sent" folder and they only appear in
the "conversation" groups for the sake of completeness. But this grouping
really does create confusion.

- When retrieving emails from Gmail, an email labeled x times, may be
downloaded x times (Gmail quirk).
Yep, you are right on this, too. I guess this is another hazard of the Gmail
system of virtual folders/labels, where a message can have multiple labels.
 Not necessarily a bad thing but definitely something to watch out for.

However, you should not see these issues if you use cfimap to connect to an
IMAP-compliant mail server (instead of Gmail).
Yep, Yahoo has no problem with these issues since they don't allow 1-to-many
relationship between email messages and folders.

BTW, it is disappointing that CFImap does not allow lists in the "folder"
attribute. You've got to use the  tag
twice to get two folders. Maybe something to add to the wish list for CF10!
[?]

Great ideas Aaron, thanks for sharing! Thanks Leigh for the code example,
that really helped.


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


Re: with specific folders?

2010-02-07 Thread Qing Xia

Well, well, this just proves my theory--ColdFusion has a tag for
EVERYTHING! [?]

I've got CF8 running on my personal development machine because I am
preparing for the certificate exam.  I'm going to install CF9 instead and
try this out!

Thanks!! You guys are the best!

On Sun, Feb 7, 2010 at 4:48 AM, Aaron Neff  wrote:

>
> Hi Qing Xia,
>
> If you wish to use cfimap w/ Gmail, here are a couple of things you may
> want to watch out for:
>
> - When polling Gmail, the item counts returned by cfimap may not match the
> same in Gmail (Gmail bug).
>
> - When retrieving emails from Gmail, an email labeled x times, may be
> downloaded x times (Gmail quirk).
>
> However, you should not see these issues if you use cfimap to connect to an
> IMAP-compliant mail server (instead of Gmail).
>
> Thanks!,
> -Aaron Neff
>
> >say I want to download all email messages in
> >my "CFTalk" folder off my Gmail account...how would I go about doing that?
>
> 

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


with specific folders?

2010-02-06 Thread Qing Xia

Hello folks,

Does anyone know of a way to get/delete emails in a *specific* folder, of a
POP email account? It seems that this cannot be done alone (or at all) with
the  tag. For example, say I want to download all email messages in
my "CFTalk" folder off my Gmail account...how would I go about doing that?

I know this can be done to emails sitting on an exchange server through the
 tag but I can't think of a way to do that with a POP email
account.

Any thought is welcome and most appreciated!

Thanks,

Qing Xia


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


Re: IE8 is killing my website

2010-02-02 Thread Qing Xia

In theory, you could use the native CF URLSessionFormat() function to
conditionally pass the CFID and CFToken values if the user's browser either
wouldn't or couldn't accept cookies. This idea is explained in some detail
in Chapter 20 of CF8 WACK book I.

I have never tested this theory myself--never had to yet.  I don't think
this is a very good idea for your situation since it takes some code
rewrite... but it is an idea! Now someone else come up with a better
solution please.



On Tue, Feb 2, 2010 at 12:34 PM,  wrote:

>
> The curse of the Microsoft browsers continues.  This time, it's not even a
> design issue, it's a functional issue, and it's ruining our user
> experience.
>
> Plainly put, a certain subset of IE8 users are unable to log in to our
> site.
> Mind you, this is a signup/login process that has worked, literally for
> years.  Along comes IE8, and suddenly there has to be a problem.
>
> It appears that IE8 is not storing our cookies, that track a successful
> login.  Every other browser works fine.  Some group of IE8 users, however,
> get our "successful login" screen, but when they click to go to a members
> area of the site, they are NOT logged in.
>
> We've done everything, including the setup of a P3P policy.  This should
> work, for everyone, but it does not.  I'm at my wits end here, and
> embarrassed as hell that I can't figure out what this issue is.  I can't
> even reproduce it here, but I've seen it happen via remote desktop on some
> (gracious) member's PCs.
>
> We've tried telling them to check their security settings, clear cache,
> clear cookies, and more.  But damn, they shouldn't HAVE to do all this
> stuff.  Not this many people (and growing).  They can accept cookies and
> view other sites (presumably), just not ours.
>
> I need ideas... fast.  Can I solicit the help of the CF community on this?
> I have no idea where else to look.
>
> Thanks,
>
> Marc
>
>
>
> 

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


Re: CF8 Advanced Status?

2010-01-31 Thread Qing Xia

Yeah, for CF7 it was 85% and 80% for CF6... but now I can't find what it is
for CF8.

On Sun, Jan 31, 2010 at 10:55 PM, lists  wrote:

>
> In the past it's been 85% I believe.
>
> -Original Message-
> From: Qing Xia [mailto:txiasum...@gmail.com]
> Sent: Sunday, January 31, 2010 9:18 PM
> To: cf-talk
> Subject: CF8 Advanced Status?
>
>
> Does anyone know what the % score needed to get the "Advanced Certified
> Status" in CF8 is? I went searching for it (high and low!) but no dice.
>
> Hmm, maybe the Pentagon needs to hire Adobe to guard its papers.
>
>
>
>
> 

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


CF8 Advanced Status?

2010-01-31 Thread Qing Xia

Does anyone know what the % score needed to get the "Advanced Certified
Status" in CF8 is? I went searching for it (high and low!) but no dice.

Hmm, maybe the Pentagon needs to hire Adobe to guard its papers.


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


Re: cferror / cfmail issue

2010-01-28 Thread Qing Xia

What does your sendError page look like? Same as quoted in your first
email? If so, do a dump on #variables#. I wonder if  is not liking
the mail server attribute.

Also put in a simple cfmail tag in the sendError file to generate an email
to yourself. Does that email go out correctly?

Oh, and check your mail spool folder--has anything got stuck there?




On Thu, Jan 28, 2010 at 4:09 PM, Tim Do  wrote:

>
> so I put back both cferror tags one for request and one for exception.  I
> forced a db error and I see the dump from the sendError page, but when I
> wrap a cfmail around it, I get nothing but the text from the errorPage.
>
> -Original Message-----
> From: Qing Xia [mailto:txiasum...@gmail.com]
> Sent: Thursday, January 28, 2010 12:21 PM
> To: cf-talk
> Subject: Re: cferror / cfmail issue
>
>
> When type="request", the error template is not supposed to contain any CFML
> tags, and you may only refer to a handful of special variables in the error
> scope.
>
> When you said you have both and request and exception values... did you
> mean
> you have two CFError tags in application.cfm, one with type="request" and
> the other with type="exception"?
>
> Maybe the type="exception" template itself contained an error and never got
> to the mail generation part. To be sure, in your development environment:
>
>1. Purposefully put in some wacky code to generate errors
>   2. For now, comment out the 
>   3. Try cfdump and cfabort in the type="exception" error template, from
>top down, until you get to the CFMail tag.
>
>
> 

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


Re: cferror / cfmail issue

2010-01-28 Thread Qing Xia

When type="request", the error template is not supposed to contain any CFML
tags, and you may only refer to a handful of special variables in the error
scope.

When you said you have both and request and exception values... did you mean
you have two CFError tags in application.cfm, one with type="request" and
the other with type="exception"?

Maybe the type="exception" template itself contained an error and never got
to the mail generation part. To be sure, in your development environment:

   1. Purposefully put in some wacky code to generate errors
   2. For now, comment out the 
   3. Try cfdump and cfabort in the type="exception" error template, from
   top down, until you get to the CFMail tag.


On Thu, Jan 28, 2010 at 2:56 PM, Tim Do  wrote:

>
> went from 7 to 9.  I have both request and exception but still doesn't
> work.  just looking through my logs again... I haven't received an error
> email in a few days so not sure it's related to the upgrade.  I can't say my
> code is that solid, usually get a couple a day, so most likely this has not
> sent in a few days.  any other ideas??  I tried wrapping the error info into
> cfsavecontent and still shows the error info and doesn't send.
>
> -Original Message-
> From: Qing Xia [mailto:txiasum...@gmail.com]
> Sent: Thursday, January 28, 2010 11:53 AM
> To: cf-talk
> Subject: Re: cferror / cfmail issue
>
>
> What CF version were you on before this recent upgrade to CF9? Try changing
> the TYPE attribute in the CFError tag to type="exception", and see what
> happens.
>
>
>
> On Thu, Jan 28, 2010 at 2:41 PM, Tim Do  wrote:
>
> >
> > We just upgraded to cf9 and my error handling is no longer working the
> way
> > it used to.  In my application.cfm I have:
> >
> >  >template="errorPage.cfm"
> >mailto="webmas...@wng.com">
> >
> > and within errorPage.cfm I have:
> > 
> >Error:
> >
> >Session:
> >
> >Client:
> >
> >Application:
> >
> >Request:
> >
> >Form:
> >
> >Url:
> >
> >Cookie:
> >
> > 
> >
> >
> > The page error shows up fine with my error notice, BUT the cfmail section
> > it just displays :
> >
> > Error:
> > Session:
> >
> > Client:
> >
> > Application:
> >
> > Request:
> >
> > Form:
> >
> > Url:
> >
> > Cookie:
> >
> > Without the variables, and the email does not go out.  Why would it
> display
> > the code inside of the cfmail tags instead of sending??  All other cfmail
> > tags work fine throughout the site.
> >
> > Thanks!
> >
> >
> >
>
>
>
> 

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


Re: cferror / cfmail issue

2010-01-28 Thread Qing Xia

What CF version were you on before this recent upgrade to CF9? Try changing
the TYPE attribute in the CFError tag to type="exception", and see what
happens.



On Thu, Jan 28, 2010 at 2:41 PM, Tim Do  wrote:

>
> We just upgraded to cf9 and my error handling is no longer working the way
> it used to.  In my application.cfm I have:
>
> template="errorPage.cfm"
>mailto="webmas...@wng.com">
>
> and within errorPage.cfm I have:
> 
>Error:
>
>Session:
>
>Client:
>
>Application:
>
>Request:
>
>Form:
>
>Url:
>
>Cookie:
>
> 
>
>
> The page error shows up fine with my error notice, BUT the cfmail section
> it just displays :
>
> Error:
> Session:
>
> Client:
>
> Application:
>
> Request:
>
> Form:
>
> Url:
>
> Cookie:
>
> Without the variables, and the email does not go out.  Why would it display
> the code inside of the cfmail tags instead of sending??  All other cfmail
> tags work fine throughout the site.
>
> Thanks!
>
>
> 

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


Re: (ot) Adobe error messages

2010-01-27 Thread Qing Xia

I submitted to this portal as well and was raving mad afterwards.  (well,
maybe that was an exaggeration).

They took my submission--and even had a dropdown for me to select the CF
server version--but afterwards I saw ONLY CF9 errors are displayed. I can't
even find my own submission when trying to search for it.  How very user
un-friendly.  Talking about black hole...

On Wed, Jan 27, 2010 at 11:33 AM,  wrote:

>
> The Adobe go/wish form is a black hole.  The only ColdFusion bug tracker
> I know of that is public and allows voting is the CF9 bug tracker:
>
> http://cfbugs.adobe.com/cfbugreport/flexbugui/cfbugtracker/main.html
>
> Frankly, I don't know why
> 1) It has such an ugly url
> 2) It's so darn hard to find (I have to Google for several minutes to
> find the stupid thing every time)
> 3) And it only seems to apply to CF9 ("Adobe Beta Software or related
> documentation")
>
> ~Brad
>
>  Original Message 
> Subject: Re: (ot) Adobe error messages
> From: Qing Xia 
> Date: Tue, January 26, 2010 4:11 pm
> To: cf-talk 
>
>
> >
> >
> > What NULL ? We're talking about the log file, not the tag.Regardless, log
> > it in Adobe's bug tracker and then post back with the number
> > so other people can vote for it.
> >
> > I did submit it to the wish list at
> > https://www.adobe.com/cfusion/mmform/index.cfm?name=wishform, but I
> don't
> > believe I was given a confirmation number.
>
>
>
> 

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


Re: Drop down subselect

2010-01-27 Thread Qing Xia

Without going into coding detail, here is (my) theory: assuming you are on
CF8, you can easily use cfselect data binding to make the two selects
related.

Then you can use jQuery (or plain old JavaScript) to "toggle" the 2nd select
so that it is only visible when something from the first select is
selected.

Or better yet, enforce the related dropdown logic with jQuery as well.


On Wed, Jan 27, 2010 at 8:37 AM, Keith McGee wrote:

>
> I have a drop down with a list of values, when the user selects a value I
> need to display another list of values in a drop down associated with the
> value they selected. I can do this reloading the page, but I want to do this
> with out reloading the page.
>
> table a
> subjectID subject description
>
> table b
> sub_subjectID subjectID sub_subject description
>
> any suggestions
>
> Thanks
> Keith
>
> 

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


Re: Determine Site-Wide Error Handler

2010-01-26 Thread Qing Xia

Assuming the language in the error template are not dynamically generated by
pulling some database record, could you do a global search among your CF
templates for the language used in the error template? Like, search for the
phrase "We are awfully sorry but you've hit an error on Orange Whip Studio;
this must be the result of the attack of the clones."

On Tue, Jan 26, 2010 at 5:09 PM, Tony Bentley  wrote:

>
> How about if you customize the degugging template?
>
> C:\ColdFusion8\wwwroot\WEB-INF\debug\classic.cfm
>
> Add a cffile action=write to the classic.cfm and dump out all of the
> debugging somewhere.
>
> This is of course if debugging is turned on. Otherwise, I think you need a
> Java guy.
>
> 

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


Re: (ot) Adobe error messages

2010-01-26 Thread Qing Xia

>
>
> What NULL ? We're talking about the log file, not the tag.Regardless, log
> it in Adobe's bug tracker and then post back with the number
> so other people can vote for it.
>
> I did submit it to the wish list at
> https://www.adobe.com/cfusion/mmform/index.cfm?name=wishform, but I don't
> believe I was given a confirmation number.


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


Re: (ot) Adobe error messages

2010-01-26 Thread Qing Xia

It is definitely nice to have--makes the code far cleaner. Plus, it makes
the tag more consistent--there is no semantic reason why the NULL attribute
should work with some functions but not others.

On Tue, Jan 26, 2010 at 7:05 AM, Tom Chiverton  wrote:

>
> On Monday 25 Jan 2010, Qing Xia wrote:
> > I wonder how long it is going to take Adobe to replace all the
> > "[Macromedia]" in CF error messages to "[Adobe]".  Completely irrelevant
> > maybe, but nice to have so new CF people don't have to wonder.
>
> You could only do that in a major release (like CF10) because you don't
> know
> what is parsing those logs.
> And is it really that important ?
>
> --
> Helping to simultaneously embrace seamless next-generation enterprise-class
> front-end convergence as part of the IT team of the year 2010, '09 and '08
>
> 
>
> 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
> Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  A
> list of members is available for inspection at the registered office
> together with a list of those non members who are referred to as partners.
>  We use the word “partner” to refer to a member of the LLP, or an employee
> or consultant with equivalent standing and qualifications. Regulated by the
> Solicitors Regulation Authority.
>
> 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 2500.
>
> For more information about Halliwells LLP visit www.halliwells.co
>
> 

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


Re: (ot) Adobe error messages

2010-01-25 Thread Qing Xia

Kind of like tacit advertising if it can be fixed... But then on the other
hand, I agree this wouldn't be on the top of my wish list for Adobe.

I'd rather they fix the problem of not checking NULL=#YesNoFormat(NOT
isDefined('form.someFromField'))# in the CFQueryParam tag first.

On Mon, Jan 25, 2010 at 3:20 PM, DURETTE, STEVEN J (ATTASIAIT) <
sd1...@att.com> wrote:

>
> I don't know about that...  I think it would be a perfect project for
> Junior Engineers just starting in the group to get into.
>
> Gets them deep into the code without having them do anything too complex
> to begin with!
>
> Steve
>
>
> -Original Message-
> From: Dave Watts [mailto:dwa...@figleaf.com]
> Sent: Monday, January 25, 2010 3:18 PM
> To: cf-talk
> Subject: Re: (ot) Adobe error messages
>
>
> > I can think of plenty of other things I would prefer Adobe engineers
> > spend their time doing.
>
> I agree completely.
>
> > -Camero
>
> who?
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> http://training.figleaf.com/
>
> Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
> GSA Schedule, and provides the highest caliber vendor-authorized
> instruction at our training centers, online, or onsite.
>
>
>
> 

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


(ot) Adobe error messages

2010-01-25 Thread Qing Xia

I wonder how long it is going to take Adobe to replace all the
"[Macromedia]" in CF error messages to "[Adobe]".  Completely irrelevant
maybe, but nice to have so new CF people don't have to wonder.


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


Re: language for mailer

2010-01-25 Thread Qing Xia

I'd be the first to admit that I am a die-hard CF fan, but if you want an
off-the-shelf software solution, check out Campaign Enterprise:
http://www.arialsoftware.com/enterprise.htm

It gives average users the
ability to create simple HTML email messages, where the recipient list can
be defined by a query pulling from your own backend database like SQL
server.

We have it at work, and for the most part, it gives us what we want.

On Mon, Jan 25, 2010 at 4:40 AM, Maureen  wrote:

>
> I would question why you would want to build it at all when so many
> already exist - in all languages.
>
> On Sun, Jan 24, 2010 at 11:39 PM, Carey  Duryea
>  wrote:
> >
> > i was positive there was some hook into creating more efficiency.  just
> like building a dragster, you basically can only go straight, but thats all
> you really wanna do!  i am sort of a beginning developer in CF and a few
> other technologies, but non such as java or C,  i have a potiential contract
> to build such a server device with a web application interface for control
> of these mailing actions.
> > i know myself very well, that if i decide to contract this sort of work,
> i'll probably end up reading three books on java.  the more ya knwo, the
> less you pay, i wonder who coined that phrase.  so its like, build java
> application mail server, that exploits resourses, build flex cf web
> application as interface to server applicati
>
> 

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


Re: Email Format question

2010-01-25 Thread Qing Xia

Hmm... have you tried using ?

On Mon, Jan 25, 2010 at 10:58 AM, Rob Voyle  wrote:

>
> Hi folks
>
> I thought I had this fixed butnow I am baffled.
> I have an cf email that lists a series of values such as
>
> '#title#
> '#prog#
> '#programvalue#
>
> which results in the email list being sent as:
>
> 'Restoring Hope: Appreciative Strategies to Resolve Grief and Resentment
> 'hopeLacey 'This was a great program
>
> If I put #chr(10)# in the list:
>
> '#title#
> '#prog##chr(10)#
> '#programvalue#
>
> I get:
>
> 'Restoring Hope: Appreciative Strategies to Resolve Grief and Resentment
> 'hopeLacey
>
> 'This was a great program
>
> When what I really want is:
>
> 'Restoring Hope: Appreciative Strategies to Resolve Grief and Resentment
> 'hopeLacey
> 'This was a great program
>
> Any ideas why this is happening or what I can do to get it to work?
>
> Rob
>
> Robert J. Voyle, Psy.D.
> Director, Clergy Leadership Institute
> For Coaching and Training in Appreciative Inquiry
> Author: Core Elements of the Appreciative Way
> http://www.clergyleadership.com/
> 503-647-2378 or 503-647-2382
>
>
>
> 

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


Re: Why .Net is on its last legs

2010-01-22 Thread Qing Xia

>
>
> I can admit, I have some really sloppy code from my first years as a coder.
>
> So did I--like you said, I imagine most did with their first applications.


  And those were the ones that mattered most. They don't care about

> frameworks, OO, languages, wire frames, documentation or preferences, they
> want solutions yesterday and for less money than the "other guy". I always
> took the best of what I knew the most, at that time and delivered
> it as fast as I could.


I agree fast delivery is essential, and it is definitely the most important
thing as far as clients are concerned. It makes no sense to be a code snob
if that results in the project being 2 weeks past due. On the other hand,
the practice of being a disciplined developer usually results
in collecting/creating a toolbox of non-business-specific utility functions
that you can deploy readily with no development time.

I wish I knew how to strike the perfect balance between being fast and being
good, but it is fun to keep trying.


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


Re: Why .Net is on its last legs

2010-01-21 Thread Qing Xia

I second that.

I took a 5-month certificate program for ASP.NET with C# last Spring at a
prestigious university in the DC metropolitan area. (Not naming names
here)  The teacher is an extremely well qualified individual with over
half a dozen MS certificates, including one in ASP.NET web development.
 However, it always seemed to take him forever to write a simple
functionality, such as querying against several tables with simple joins and
then output the result in a table.

One thing I would say in ASP.NET's favor is that it forces developers to use
a multi-tier approach to their applications, while CF does not.  Now, is
that a good thing? I am not sure. If you are a disciplined developer who
adheres to best practices and OOP techniques, this seems hardly necessary.
 If you are new to programming, this enforcement does seem to foster good
habits.

The unfortunate thing is that sometimes companies decide to blame it on
ColdFusion, instead of individual developers, when they discover the tangled
web of sloppy code written in ColdFusion.  It is our responsibility, as
ColdFusion developers, to give it a good reputation.


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


Re: Why i fear ColdFusion is on its last legs

2010-01-21 Thread Qing Xia

Now, here's the ultimate test: let's post a "ASP.NET is dying" thread to
their mailing list and see if the response is as strong.  [?]

On Thu, Jan 21, 2010 at 4:36 PM, Dave Watts  wrote:

>
> > Is that so strange?India has different problems that the rest of
> > the world does not.  Canada  has different problems that the rest of
> > the world does not.   England  has different problems that the rest of
> > the world does not.  France  has different problems that the rest of
> > the world does not.  China  has different problems that the rest of
> > the world does not.  Indonesia  has different problems that the rest
> > of the world does not.  Hell, even the USA  has different problems
> > that the rest of the world does not.
> >
> > Why wouldnt Australia?
>
> Why would you then generalize your specific problems to the world?
>
> Look, if your problem is with the Australian sales team at Adobe, what
> is the point of posting "CF is dying" to a worldwide programmers'
> list?
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> http://training.figleaf.com/
>
> Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
> GSA Schedule, and provides the highest caliber vendor-authorized
> instruction at our training centers, onli
>
> 

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


Re: Article feed for website

2010-01-20 Thread Qing Xia

Do you mean like an RSS feed...?

On Wed, Jan 20, 2010 at 7:05 PM, Mike Little  wrote:

>
> hi guys,
>
> my client wishes to make available code (javascript??) that website
> visitors can embed in their own websites/blogs to display the most recent
> articles.
>
> this is the first time i am trying this so any pointers in the right
> direction would really be appreciated.
>
> could this be an iframe they embed, or is it better suited to a javascript
> function that would consume a webservice from the clients website??
>
> mike
>
> 

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


Re: More Efficient (Faster) Method

2010-01-17 Thread Qing Xia

*Here are my two cents:*
*On the subject of "Premature Optimization": I agree with Dave that as
developers, sometimes our tendency to create "clever" code could result in
cryptic code, albeit "short".  That said, I also believe there are definite
lines between decent and sloppy code.  For example, I was working on a
legacy application recently and there were lines of code like .  (What it meant to say is  ).  So, the real question is--when is it best to optimize?
Personally, my rule of thumb has been "do not reinvent the wheel".  If there
is a native CF function or tag that can be used to get your idea across,
then by all means use it. That is probably an overly simplified view, but it
is a start. *

*On the subject of using the database to store calculated date values:
Assuming the shipping date calculation is the only one you would be doing on
a regular bases for this application, I think it is a bit of an overkill.
 However, there are situations when doing that is a good idea.  For example,
I used to work for a company with an application that processes
payroll-related data.  As such, it constantly needs to refer to X business
days before or after current date. *

*Now, on a microscopic level: *
When I suggested the UDF BusinessDaysAdd(), I had meant it for that block of
code to set the NewDay value, which does not include Saturday as the new day
(delivery date). So you could rewrite it as: 

As for the loops... Is the inner loop for query qryGetShipCosts really
necessary? For each shopping cart, your query should retrieve only one row
from the database--one shipping cost for each delivery date option, correct?
 If so, get rid of that loop and just refer to #qryGetShipCosts.NextDay# and
etc, like the following:



#LSDateFormat(variables.newDay, "mmm-dd-")# -
#DayOfWeekAsString(DayOfWeek(variables.newDay))#


#qryGetShipCosts.NextDay#


#qryGetShipCosts.TwoDay#



#qryGetShipCosts.Standard#

#qryGetShipCosts.Saturday#







*Finally, a couple of personal habits if I may be so indulged to go on...*
*I always include SELECT TOP 1... in a query if I expect that query to
return one and only one row.  I think it makes it clearer to the reader what
is to come. *

*I have an obsessive compulsion to scope ALL of my variables.  I think it
makes your code far more readable and easier to maintain. In your code for
example, if the reader sees the line of code  they will
probably guess NewDay is a local variable. However, it is still nice to
explicitly scope NewDay everywhere so wherever the reader's eyes land first,
he/she knows it is a local variable.  I know the CF books tell you
*sometimes* it is a good idea not to scope variables because it makes your
code more flexible.  There are certainly situations where that is true. For
example, maybe you have a page that expects a product_id to display a
certain product, and this product_id could come either in FORM or URL
scopes.  However, I am not convinced this flexibility is worth it at the
cost of readability.  You could always cast your URL scopes in FORM scope
either by way of some JavaScript or through settings in a framework like
Fusebox. *

Just a few thoughts... [?]

>


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


Re: More Efficient (Faster) Method

2010-01-15 Thread Qing Xia

Check out this UDF: http://www.cflib.org/udf/BusinessDaysAdd

Also, if I may venture to suggest:

   1. You don't need sharp signs inside ColdFusion tags
   2. It would be nice to use cfqueryparam to pass in those variables to
   your query--faster and more secure.

Happy Friday! [?]

On Fri, Jan 15, 2010 at 5:21 PM, Nick Sweeney wrote:

>
> Hey everyone - I was wondering if anyone could suggest a "better" method of
> doing this.
>
> Essentially I am creating a dropdown list of Shipping Prices - based on the
> day they are making the purchase. (Customer defined "Next Day Shipping"
> prices - not UPS)
>
> It's Working - but I wonder if there is a more efficient way of doing the
> same thing... Not so many loops or cfif's...
>
> Thoughts? Ideas?  Thanks! - Nick
>
> Live Example here: http://cf.bigfatdesigns.com/cart/ShipCostTest.cfm
>
> Code:
> 
> 
>
> 
> 
>
>
> 
>  username="#Application.username#" password="#Application.password#">
> SELECT SCostID, MinItemPrice, MaxItemPrice, Standard, TwoDay, NextDay,
> Saturday
> FROM ShipCostChart
> WHERE MinItemPrice < #ThisItemPrice#
> AND MaxItemPrice > #ThisItemPrice#
> 
>
> 
> 
> 
>
> 
> 
>
> 
> 
>
> 
> 
>
> 
> 
>
> 
> 
>
> 
> 
>
> 
>
> START > TODAY > #DayOfWeekAsString(DayOfWeek(TodaysDate))#   #NewDay#
> 
> LIST will actually be a SELECT Drop Down
> 
> 
>
>
>#LSDateFormat(NewDay, 'mmm-dd-')# -
> #DayOfWeekAsString(DayOfWeek(NewDay))#
>
>
>
>
>#qryGetShipCosts.NextDay#
>
>
>#qryGetShipCosts.TwoDay#
>
>
>#qryGetShipCosts.Standard#
>
>#qryGetShipCosts.Saturday#
>
>
>
>
>
>
>
>
> 
> 
>
> 
>
> 

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


Re: jQuery tableSorter & tab plugins

2010-01-14 Thread Qing Xia

D'oh!

Please ignore question! Apparently just writing the question down on paper
helps clear the thought.  Don't know what I was thinking...

I could easily make the table name an attribute to the custom tag and then
do this in my call to the jQuery tableSorter plugin:


 //jQuery table sorter function
$(document).ready(function()
{$("#<cfoutput>#attributes.tableName#</cfoutput>").tablesorter();});



On Thu, Jan 14, 2010 at 4:37 PM, Qing Xia  wrote:

> Hello all,
>
> I am having a dilemma regarding two jQuery plugins: the tableSorter and
> tab.
>
> Here is a brief summary of the problem:
>
>
>1. I have a task list, which is further broken into sub-categories such
>as "Problems", "Maintenance" and "Requests".
>2. I am using the jQuery tab plugin to make each sub-category a tab.
> This works well.
>3. Then for each tab, I am also implementing the tableSorter plugin so
>that users can click on table headers and sort either ascending or
>descending on that column.
>4. The tableSorter plugin only works for the first tab. I've tried
>switching the tabs around and discovered that regardless which one is made
>the first tab, it only works for it.
>5. I've got the tableSorter plugin in multiple places throughout my
>application without tabs so I know it definitely works.
>
> I **think** the cause of the problem is: the task lists are done through a
> custom tag which gets called for each tab to conjure up the list. So even
> though the tableSorter plugin gets called 3 times, they all have the same
> table ID which makes jQuery think they are one big happy table family!
>
> I do not want to not use custom tag for my task lists because that would
> lead to gross duplication of code... but I am also a jQuery newbie... I
> understand in theory that I'd have to pass in a new table ID to the jQuery
> tableSorter plugin each time it is called... but I am a little hazy on the
> syntax of how that can be done.
>
> I am sure someone on this list has done that before. If so, I would be most
> grateful for any suggestions! [?]
>
> Cheers,
>
> Qing Xia
>
>


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


jQuery tableSorter & tab plugins

2010-01-14 Thread Qing Xia

Hello all,

I am having a dilemma regarding two jQuery plugins: the tableSorter and
tab.

Here is a brief summary of the problem:


   1. I have a task list, which is further broken into sub-categories such
   as "Problems", "Maintenance" and "Requests".
   2. I am using the jQuery tab plugin to make each sub-category a tab.
This works well.
   3. Then for each tab, I am also implementing the tableSorter plugin so
   that users can click on table headers and sort either ascending or
   descending on that column.
   4. The tableSorter plugin only works for the first tab. I've tried
   switching the tabs around and discovered that regardless which one is made
   the first tab, it only works for it.
   5. I've got the tableSorter plugin in multiple places throughout my
   application without tabs so I know it definitely works.

I **think** the cause of the problem is: the task lists are done through a
custom tag which gets called for each tab to conjure up the list. So even
though the tableSorter plugin gets called 3 times, they all have the same
table ID which makes jQuery think they are one big happy table family!

I do not want to not use custom tag for my task lists because that would
lead to gross duplication of code... but I am also a jQuery newbie... I
understand in theory that I'd have to pass in a new table ID to the jQuery
tableSorter plugin each time it is called... but I am a little hazy on the
syntax of how that can be done.

I am sure someone on this list has done that before. If so, I would be most
grateful for any suggestions! [?]

Cheers,

Qing Xia


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329694
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 deleting structure in an array

2010-01-12 Thread Qing Xia

Yep, Leigh's solution is much simpler.  [?]

On Tue, Jan 12, 2010 at 9:47 PM, jrmuniz  wrote:

>
> Leigh:  My apologies. When I read your post I stopped at the word "Yes" not
> realizing there was more.  What you are saying makes perfect sense. I'll
> give that a try.  Jaime
>
> See my previous response. You must remove the item in _descending_ order.
> That way the element you are trying to remove will always exist.
>
>
>
>
>
> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329614
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 deleting structure in an array

2010-01-12 Thread Qing Xia

So maybe you can figure out which array index values are NOT selected for
deletion, clear out the original array and insert the un-deleted array
elements back in there.

On Tue, Jan 12, 2010 at 5:10 PM, Qing Xia  wrote:

> Nope, on 2nd thought, Chat was right. If your array index was messed up,
> then the error would have occurred sooner while rendering the form.
>
> I bet the error happens only if item 3 is selected. If you do 1 and 2 then
> you'll get the original number 2 remaining in the array.
>
> On Tue, Jan 12, 2010 at 4:51 PM, Qing Xia  wrote:
>
>> You are looping over the array sequentially from 1 but are you sure your
>> array key values are sequential from 1 as well?
>>
>> Your loop goes 1, 2, 3, which means it will expect to find
>> session.shoppingCart[1].itemid, session.shoppingCart[2].itemid and
>> session.shoppingCart[3].itemid.  But are you sure those are indeed the key
>> values in the session array? If your array key values go 1,3,4 then that
>> will definitely break things.
>>
>> On Tue, Jan 12, 2010 at 4:31 PM, Chad Gray  wrote:
>>
>>>
>>> My best guess is if you remove one item it changes the structure of the
>>> array and when it goes to remove the next one it cannot be found?
>>>
>>> Use CFDump to display the array as you are looping over it to help debug.
>>>  This way you can see the way the array is changing as you are removing
>>> items.
>>>
>>>
>>>
>>> > -Original Message-
>>> > From: jrmuniz [mailto:jrmu...@sfsailing.com]
>>> > Sent: Tuesday, January 12, 2010 4:16 PM
>>> > To: cf-talk
>>> > Subject: Problem deleting structure in an array
>>> >
>>> >
>>> > Hello:
>>> >
>>> > Sorry, I forgot the subject in my last post.
>>> >
>>> > I'm having an issue deleting a form structure that is in a shopping
>>> cart
>>> > array.
>>> > I'm sure it's something simple I'm doing wrong, but it's driving me
>>> crazy.
>>> >
>>> > I have a checkbox to select which items to delete.
>>> > If only one item is selected there is no error and it works fine.
>>> > If more than one item is selected then the error is triggered.
>>> > Strangely, if I resubmit the form after the error it works OK.
>>> >
>>> > If I select two items to delete the error is:
>>> > The error message is "Element at position [3] doesn't
>>> exist in
>>> > array"
>>> >
>>> > Here is the form code:
>>> > 
>>> > 
>>> > 
>>> > 
>>> > 
>>> > 
>>> > >> > value="#session.shoppingcart[i].quantity#" size="3">
>>> > 
>>> > 
>>> > >> > value="#HTMLEditFormat(session.shoppingcart[i].catalog)#" size="10">
>>> > 
>>> > 
>>> > >> > value="#HTMLEditFormat(session.shoppingcart[i].description)#"
>>> > size="40">
>>> > 
>>> > >> > value="#session.shoppingcart[i].price#" size="3">
>>> > 
>>> > 
>>> > 
>>> >
>>> > Here is the cfc code:
>>> > 
>>> >
>>> >   
>>> >  
>>> > 
>>> > 
>>> >
>>> > Any help is greatly appreciated.
>>> >
>>> > Regards,
>>> > Jaime
>>> >
>>> >
>>> >
>>> >
>>> >
>>>
>>> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329604
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 deleting structure in an array

2010-01-12 Thread Qing Xia

Nope, on 2nd thought, Chat was right. If your array index was messed up,
then the error would have occurred sooner while rendering the form.

I bet the error happens only if item 3 is selected. If you do 1 and 2 then
you'll get the original number 2 remaining in the array.

On Tue, Jan 12, 2010 at 4:51 PM, Qing Xia  wrote:

> You are looping over the array sequentially from 1 but are you sure your
> array key values are sequential from 1 as well?
>
> Your loop goes 1, 2, 3, which means it will expect to find
> session.shoppingCart[1].itemid, session.shoppingCart[2].itemid and
> session.shoppingCart[3].itemid.  But are you sure those are indeed the key
> values in the session array? If your array key values go 1,3,4 then that
> will definitely break things.
>
> On Tue, Jan 12, 2010 at 4:31 PM, Chad Gray  wrote:
>
>>
>> My best guess is if you remove one item it changes the structure of the
>> array and when it goes to remove the next one it cannot be found?
>>
>> Use CFDump to display the array as you are looping over it to help debug.
>>  This way you can see the way the array is changing as you are removing
>> items.
>>
>>
>>
>> > -Original Message-
>> > From: jrmuniz [mailto:jrmu...@sfsailing.com]
>> > Sent: Tuesday, January 12, 2010 4:16 PM
>> > To: cf-talk
>> > Subject: Problem deleting structure in an array
>> >
>> >
>> > Hello:
>> >
>> > Sorry, I forgot the subject in my last post.
>> >
>> > I'm having an issue deleting a form structure that is in a shopping cart
>> > array.
>> > I'm sure it's something simple I'm doing wrong, but it's driving me
>> crazy.
>> >
>> > I have a checkbox to select which items to delete.
>> > If only one item is selected there is no error and it works fine.
>> > If more than one item is selected then the error is triggered.
>> > Strangely, if I resubmit the form after the error it works OK.
>> >
>> > If I select two items to delete the error is:
>> > The error message is "Element at position [3] doesn't
>> exist in
>> > array"
>> >
>> > Here is the form code:
>> > 
>> > 
>> > 
>> > 
>> > 
>> > 
>> > > > value="#session.shoppingcart[i].quantity#" size="3">
>> > 
>> > 
>> > > > value="#HTMLEditFormat(session.shoppingcart[i].catalog)#" size="10">
>> > 
>> > 
>> > > > value="#HTMLEditFormat(session.shoppingcart[i].description)#"
>> > size="40">
>> > 
>> > > > value="#session.shoppingcart[i].price#" size="3">
>> > 
>> > 
>> > 
>> >
>> > Here is the cfc code:
>> > 
>> >
>> >   
>> >  
>> > 
>> > 
>> >
>> > Any help is greatly appreciated.
>> >
>> > Regards,
>> > Jaime
>> >
>> >
>> >
>> >
>> >
>>
>> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329603
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 deleting structure in an array

2010-01-12 Thread Qing Xia

You are looping over the array sequentially from 1 but are you sure your
array key values are sequential from 1 as well?

Your loop goes 1, 2, 3, which means it will expect to find
session.shoppingCart[1].itemid, session.shoppingCart[2].itemid and
session.shoppingCart[3].itemid.  But are you sure those are indeed the key
values in the session array? If your array key values go 1,3,4 then that
will definitely break things.

On Tue, Jan 12, 2010 at 4:31 PM, Chad Gray  wrote:

>
> My best guess is if you remove one item it changes the structure of the
> array and when it goes to remove the next one it cannot be found?
>
> Use CFDump to display the array as you are looping over it to help debug.
>  This way you can see the way the array is changing as you are removing
> items.
>
>
>
> > -Original Message-
> > From: jrmuniz [mailto:jrmu...@sfsailing.com]
> > Sent: Tuesday, January 12, 2010 4:16 PM
> > To: cf-talk
> > Subject: Problem deleting structure in an array
> >
> >
> > Hello:
> >
> > Sorry, I forgot the subject in my last post.
> >
> > I'm having an issue deleting a form structure that is in a shopping cart
> > array.
> > I'm sure it's something simple I'm doing wrong, but it's driving me
> crazy.
> >
> > I have a checkbox to select which items to delete.
> > If only one item is selected there is no error and it works fine.
> > If more than one item is selected then the error is triggered.
> > Strangely, if I resubmit the form after the error it works OK.
> >
> > If I select two items to delete the error is:
> > The error message is "Element at position [3] doesn't
> exist in
> > array"
> >
> > Here is the form code:
> > 
> > 
> > 
> > 
> > 
> > 
> >  > value="#session.shoppingcart[i].quantity#" size="3">
> > 
> > 
> >  > value="#HTMLEditFormat(session.shoppingcart[i].catalog)#" size="10">
> > 
> > 
> >  > value="#HTMLEditFormat(session.shoppingcart[i].description)#"
> > size="40">
> > 
> >  > value="#session.shoppingcart[i].price#" size="3">
> > 
> > 
> > 
> >
> > Here is the cfc code:
> > 
> >
> >   
> >  
> > 
> > 
> >
> > Any help is greatly appreciated.
> >
> > Regards,
> > Jaime
> >
> >
> >
> >
> >
>
> 

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


Re: reorder a query

2010-01-12 Thread Qing Xia

Could it be that one (or more) of the rows in column reOrder is of type
Double while the other rows are all of type string? I am guessing maybe you
want a numeric value in this row but one of more rows got empty.

On Tue, Jan 12, 2010 at 1:34 PM, Chad Gray  wrote:

>
> While I am looking over Roberts code that he sent me why would I get a
> casting error for this code?  I take the ORDER BY statement out of the Query
> of a Query and it does not error.
>
> Error casting an object of type java.lang.Double cannot be cast to
> java.lang.String to an incompatible type.
>
> 
>
> 
> SELECT ColorName
> FROM getColors
> ORDER BY reOrder
> 
>
>
>
>
> > -Original Message-
> > From: Chad Gray [mailto:cg...@careyweb.com]
> > Sent: Tuesday, January 12, 2010 12:55 PM
> > To: cf-talk
> > Subject: reorder a query
> >
> >
> > I am thinking there has to be an easier way to do this then what I
> > currently have.
> >
> > I need to move a row in a Query object up or down.  Like imagine a page
> > with little arrows on each record and you want record 2 to move to the
> > position of record 1 and move record one to the position of record 2.
> >
> > Then I want to delete the records from the table and insert the newly
> > ordered records back into the database.
> >
> > The direction I am currently going is to loop over the query object find
> > the records that needs moved and start creating an Array for the new
> order
> > 2,1,3,4 etc.
> >
> > Then use QueryAddColumn(getColors, "reOrder", "integer", reOrderArray) to
> > insert the array into my query object.
> >
> > Then user a Query of a Query to do a
> > SELECT *
> > FROM getColors
> > ORDER BY reorder
> >
> > Then delete the records and loop over the query object to insert back
> into
> > the table.
> >
> > Seems really overly complicated...  Can anyone think of a better way?
> >
> >
> >
>
> 

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


Re: empty strings

2010-01-11 Thread Qing Xia

I didn't test it against an Oracle DB, but the following works against a SQL
Server DB. Be sure to adjust the cfsqltype according to the data type of
your form field.



Hope this helps!


On Mon, Jan 11, 2010 at 4:21 PM, Won Lee  wrote:

>
> I'm not sure what to do a search on this subject so please excuse me if
> this
> question was already asked.
>
> I have a form.  It has an optional field. When I go to insert a new record
> into the Oracle DB, the db will throw an error if the formfield is empty.
>
> I can get around this by using a .  Is there
> a better way to handle this?  Isn't there a performance hit for this sort
> of
> quasi-dymanic sql statement?
>
> The only thing I can think off the top of my head is when I convert it to a
> stored procedure to check for the length there since quasi-dynamic queries
> have less impact on the DB side.
>
>
> TIA,
> W
>
>
> 

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


Re: jquery javascript coldfusion.navigate cflayout cfdiv

2010-01-08 Thread Qing Xia

Awesome! For those of you who don't subscribe to Ray's blog--he's turned
this into an entry with some excellent explanations.

http://www.coldfusionjedi.com/index.cfm/2010/1/8/Interesting-ColdFusion-Ajax-IssueBug

Happy jQuerying! [?]


On Thu, Jan 7, 2010 at 3:54 PM, David Mineer  wrote:

>
> The answer came from the jedi master himself Ray Camden:
>
> if you put the click handler in the root document,
> and switch it to Live(), then it will work.
>
> So changing the event handler to
>   $("#checkboxall").live("click",function()  {
> Makes it work.
>
> Even Ray was a little surprised that Live() was needed in this case.  I
> never even heard of Live() cause I don't use jQuery that much, I should
> start.
>
> But it works now, thanks All.
>
> On Thu, Jan 7, 2010 at 1:39 PM, Qing Xia  wrote:
>
> >
> > I am a jQuery newbie so I definitely feel your pain.  One method that has
> > worked for me is to the bottom-up approach.
> >
> > Start with a bare-bone simple form with just the jQuery stuff and then
> add
> > the other stuff you want in, one by one.  Make sure to also strip down
> your
> > CSS file to just those definitions directly relating to the jQuery
> > stuff. This way you can figure out when it stops working and then narrow
> it
> > down to the prime suspect.
> >
> > The other thing is to test the stuff at each stage in all browsers you
> > have.
> >  If it doesn't work in any of them, then you know the problem is your
> code.
> >
> > On Thu, Jan 7, 2010 at 3:07 PM, David Mineer  wrote:
> >
> > >
> > > It was on the target page (the page that is called by
> > coldfusion.navigate,
> > > checkbox2.cfm)
> > >
> > > Moving it to the parent page (checkboxtest.cfm) actually gets rid of
> the
> > > error message, but the function does not work.
> > >
> > > On Thu, Jan 7, 2010 at 12:30 PM, Martin Franklin <
> > ma...@assetresearch.com
> > > >wrote:
> > >
> > > >
> > > > Have you tried including the jQuery library on target page?
> > > >
> > > > - Original Message -
> > > > From: "David Mineer" 
> > > > To: "cf-talk" 
> > > > Sent: Thursday, January 07, 2010 12:09 PM
> > > > Subject: ***SPAM*** jquery javascript coldfusion.navigate cflayout
> > cfdiv
> > > >
> > > >
> > > > >
> > > > > We cannot get a simple jquery function to work using
> > > coldfusion.navigate,
> > > > > cflayout and a cfdiv.  One of those 3 or a combination is causing
> us
> > > > fits.
> > > > >
> > > > > page 1: checkbox2.cfm
> > > > > --
> > > > > http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js</a>
> > > > "></script<
> > > >
> > >
> >
> <a  rel="nofollow" href="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js%22%3E%3C/script">http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js%22%3E%3C/script</a>
> > > > >
> > > >  >>
> > > > >
> > > > > <script>
> > > > > $(document).ready(function(){
> > > > >
> > > > > $("#checkboxall").click(function()
> > > > >  {
> > > > >   var checked_status = this.checked;
> > > > >   $("input[name=mapid]").each(function()
> > > > >   {
> > > > >this.checked = checked_status;
> > > > >   });
> > > > >  });
> > > > >
> > > > > });
> > > > > 
> > > > >
> > > > > Select All > > > type="checkbox"
> > > > > />
> > > > >
> > > > > 
> > > > > 
> > > > > 
> > > > > 
> > > > > 
> > > > > 
> > > > > Page 2: checkboxtest.cfm
> > > > >
> > > > > 
> > > > >  
> > > > > > > href="javascript:ColdFusion.navigate('checkbox2.cfm','catz')">Click
> > > > > Here
> > > > >  
> > > > > 
> > > > > 
> > > > > 
> > > > >
> > > > > ---
> > > > >
> > > > > The first page, by itself works just fine.  The second page gives
> an
> > > > error
> > > > > and we cannot figure out a solution.  I really like the dynamic
> > nature
> > > of
> > > > > using coldfusion.navigate to load a page into the cfdiv on the fly.
> > > > >
> > > > > How can I make the second page work?
> > > > >
> > > > > --
> > > > > David Mineer Jr
> > > > > -
> > > > > The critical ingredient is getting off your
> > > > > butt and doing something. It's as simple
> > > > > as that. A lot of people have ideas, but
> > > > > there are few who decide to do
> > > > > something about them now. Not
> > > > > tomorrow. Not next week. But today.
> > > > > The true entrepreneur is a doer.
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
> 

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


Re: jquery javascript coldfusion.navigate cflayout cfdiv

2010-01-07 Thread Qing Xia

I am a jQuery newbie so I definitely feel your pain.  One method that has
worked for me is to the bottom-up approach.

Start with a bare-bone simple form with just the jQuery stuff and then add
the other stuff you want in, one by one.  Make sure to also strip down your
CSS file to just those definitions directly relating to the jQuery
stuff. This way you can figure out when it stops working and then narrow it
down to the prime suspect.

The other thing is to test the stuff at each stage in all browsers you have.
 If it doesn't work in any of them, then you know the problem is your code.

On Thu, Jan 7, 2010 at 3:07 PM, David Mineer  wrote:

>
> It was on the target page (the page that is called by coldfusion.navigate,
> checkbox2.cfm)
>
> Moving it to the parent page (checkboxtest.cfm) actually gets rid of the
> error message, but the function does not work.
>
> On Thu, Jan 7, 2010 at 12:30 PM, Martin Franklin  >wrote:
>
> >
> > Have you tried including the jQuery library on target page?
> >
> > - Original Message -
> > From: "David Mineer" 
> > To: "cf-talk" 
> > Sent: Thursday, January 07, 2010 12:09 PM
> > Subject: ***SPAM*** jquery javascript coldfusion.navigate cflayout cfdiv
> >
> >
> > >
> > > We cannot get a simple jquery function to work using
> coldfusion.navigate,
> > > cflayout and a cfdiv.  One of those 3 or a combination is causing us
> > fits.
> > >
> > > page 1: checkbox2.cfm
> > > --
> > > http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js
> > "> >
> http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js%22%3E%3C/script
> > >
> >  >>
> > >
> > >