RE: condition

[Everett, Al \(NIH/NIGMS\) [C]]

That should do what you want. It also eliminates the use of evaluate().

If you want to keep it as two separate s for clarity, you could do





-Original Message-
Alright, my brain is locked-up today, so I'm just going to ask.
I need to make a set of cfif statements to so that if the dropdown value
is '' then it skips the action.  If the dropdown is 'other', then it
needs to check to see if fname and lname both have values before it does
the action.  If the dropdown is anything else, then it does the action
but doesn't need to do the fname, lname check.

Do I just need to have the action in there twice?  If so, I can make a
file out of it and include it.


here's my current failure:

   
  

   action: do something

 
   


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

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

RE: Wierd CF Output IE Problem

[Everett, Al \(NIH/NIGMS\) [C]]

Spaces in the input fields?

Did you examine the resulting query in your debug output?

You're going to use  when you finalize this, right? 

-Original Message-
I am doing a very, very simple search on two database columns, "Title"
and "Link".

For my query, I am also doing the simplistic:

 SELECT * FROM my_table WHERE
0=0 AND Title LIKE '%#FORM.SearchText#%' OR Link LIKE
'%#FORM.SearchText#%'


On the output, I just do a simple output query of search.

Now for my problem.  In Firefox, the search will return the appropriate
results, as expected.  However, in IE 6.0, the exact same search returns
nothing.  

I have gone cross-eyed trying to figure out what could possibly be
happening.

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

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

RE:

[Everett, Al \(NIH/NIGMS\) [C]]

Add a CHR(13) and/or CHR(10) character to the end of the line. 

-Original Message-
I'm using a  inside  to output a query.
 

 
...
...
...
Your positions include:
PositionStateRegionNotes

#Title##State# #Description# #ProjTitleUrl#
 


...
...
 
The problem is how it is output. Instead of one set of data per line the
result is concantenated into a long string. It did okay when I was
sending it as html but a copy goes to their listserv and it is stripping
all html code so I'm back to plain text messages.
 
Any idea on how to get this output one line at a time?

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

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

RE: Error invoking CFC for gateway myGateway: String index out of range: -1

[Everett, Al \(NIH/NIGMS\) [C]]

(Trying again, as this seems to have not been received.) 

Well, thanks for all the feedback.

Oddly, all of the gateways on our development server throw this error,
but the same gateways work fine in our test and production environments.
Code is all the same and the servers are SUPPOSED to be identical.

Any ideas? 

> "Error invoking CFC for gateway myGateway: String index out of range:
-1 "
> 
> Anyone have any experience with this error?
> 
> The cfc is essentially empty at this point. It's an initiator gateway
and all I have (after removing things trying to debug) is just an
> onIncomingMessage() function that doesn't do anything.
> 
> I've restarted the gateway after each code change, but the error stays
the same.
> 
> Ideas?

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

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

RE: WebService Issue w/Special Characters being sent to XMLParse

[Everett, Al \(NIH/NIGMS\) [C]]

You may have other issues there. If an ampersand is properly encoded as
&, your replace() statement will make that &

Shouldn't the source of that XML be escaping the ampersand?


-Original Message-
From: James Blaha [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 13, 2007 11:33 AM
To: CF-Talk
Subject: Re: WebService Issue w/Special Characters being sent to
XMLParse

All,

Thanks for your posts, issue resolved using:






 

Have a great weekend!

-Jim



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

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

RE: What conditions would cause a new jsessionid to be assigned to a user session?

[Everett, Al \(NIH/NIGMS\) [C]]

Something monkeying with the jsession cookie, I imagine. A
poorly-conceived spyware blocker, perhaps, or a poorly configured proxy
server.

Can you find any commonality among the users this is happening to?
Browser version? Company or IP address?

-Original Message-
I know this may be a rather rookie question, but I want as much input as
possible on this so I'm asking it anyways.  

We're having problems with users being timed out prematurely, before the
2hr time limit our client has decided upon.  Everything has been setup
in CFadministrator correctly, as 95% of the users are able to stay
logged in for the 2hr time frame and have no problems.  With the small
percentage of users that are not being able to stay logged, the timeout
is random and the server assigns a NEW jsessionid to them.  Of course,
when this happens all of the user info that is stored in session is
lost, therefore they are gracefully kicked out of the site and asked to
log in again.

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

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

RE: Finding one line of text in a large text file.

[Everett, Al \(NIH/NIGMS\) [C]]

You might want to look into the Java string-handling functions. There's
probably something there that will serve and should be plenty fast. 

-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 10, 2007 1:01 PM
To: CF-Talk
Subject: Finding one line of text in a large text file.

Hello all. I am reading the contents of a tab delimited text file using
 and the new line character. It may have up to 8500 lines. The
last line will have a single line of text that reads "eof,lines:WXYZ"
where WXYZ is the number of lines in the file. This last line signifies
that the file is complete and not a partial file.

Once I load the contents of the file with , what would be the
*most
efficient* way that I could verify that the last line of this text file
contains the needed text "eof,lines:"? Would the  function be my
best bet, or something else?

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

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

RE: Arrays | Array + Structure

[Everett, Al \(NIH/NIGMS\) [C]]

I don't know about speed and memory efficiency, but I would think that
option 3 would be the easiest to work with and offer the best data
integrity.

Of course, I wouldn't write to the SESSION scope in each loop iteration.
I'd write to a local variable and only write to SESSION when it was all
done. 

-Original Message-
Let's say I have table of building info. I need to
recurse the info multiple times
attach temporary variables to each building's info
have the data persistent over multiple pages
speed is essential (part of an emergency notification system)

I see multiple ways to do this.

1) Load the data into a multi-dimensional array (except I still have a
mental block on doing this)

2) Load the data into parallel arrays, e.g.,
SESSION.arrBldgNames
SESSION.arrBldgWardens
SESSION.arrBldgWardenEmail
SESSION.arrBldgWardenEmailSent  (temporary info)
etc.
Where arrBldgWardens[5] would match with arrBldgNames[5] (and there are
several more fields of data to be accessed).

3) Use an array + structure, e.g.,




...

etc.


Does anyone have any idea which is more efficient insofar as memory used
or speed of accessing the data?

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

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

RE: Returning a user's roles?

[Everett, Al \(NIH/NIGMS\) [C]]

> I'm using cflogin to authenticate users on a site.  Is there a way to
return the roles that a user is in (i.e. the roles that are passed 
> in using CFLOGINUSER)?  I'm using a very hackish method of looping
through all of the roles for a site and using isuserinrole() to 
> determine this, but was hoping that there was a more elegant solution.

Apparently not. You'll probably need to put something in the SESSION
scope to keep track of that.

IsUserInRole() does accept a comma-delimited list of roles, if that
helps.

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

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

RE: Scheduler settings

[Everett, Al \(NIH/NIGMS\) [C]]

I found the scheduler in version 5.0 and lower to be inherently
unreliable. When we still had CF5.0, we used the NT scheduler and the
CFML.EXE executable for our scheduled tasks. 

-Original Message-
I have version 5.0 of CF.

In the Scheduler I have set a cfm page to run every day at 9:15, but it
does not.

Its is checked as Daily at 09:15:00. There is a Start date of yesterday.

Are there inherent problems with the Scheduler that I don't know about
or is there a better way to do this?

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

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

RE: Werid error...

[Everett, Al \(NIH/NIGMS\) [C]]

> null="#iif(COURSE.COU_LANGUAGE_STUDY IS '',de('Yes'),de('No'))#"

Why not #yesNoFormat(COURSE.COU_LANGUAGE_STUDY IS '')#  ?

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

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

RE: Browser default home page

[Everett, Al \(NIH/NIGMS\) [C]]

I think the JavaScript window.home() is what you're looking for. 

-Original Message-
From: ch g [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, March 27, 2007 2:05 PM
To: CF-Talk
Subject: Re: Browser default home page

I just want to redirect to their default home page once they are done
with my site, i don't want to change browser settings. Any other way

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

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

RE: Error invoking CFC for gateway myGateway: String index out of range: -1

[Everett, Al \(NIH/NIGMS\) [C]]

Well, thanks for all the feedback.

Oddly, all of the gateways on our development server throw this error,
but the same gateways work fine in our test and production environments.
Code is all the same and the servers are SUPPOSED to be identical.

Any ideas? 

-Original Message-

"Error invoking CFC for gateway myGateway: String index out of range: -1
"
 
Anyone have any experience with this error?
 
The cfc is essentially empty at this point. It's an initiator gateway
and all I have (after removing things trying to debug) is just an
onIncomingMessage() function that doesn't do anything.
 
I've restarted the gateway after each code change, but the error stays
the same.
 
Ideas?

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

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

Error invoking CFC for gateway myGateway: String index out of range: -1

[Everett, Al \(NIH/NIGMS\) [C]]

"Error invoking CFC for gateway myGateway: String index out of range: -1
"
 
Anyone have any experience with this error?
 
The cfc is essentially empty at this point. It's an initiator gateway
and all I have (after removing things trying to debug) is just an
onIncomingMessage() function that doesn't do anything.
 
I've restarted the gateway after each code change, but the error stays
the same.
 
Ideas?


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

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

SparkPlug CMS

[Everett, Al \(NIH/NIGMS\) [C]]

Anyone know what happened to the 13amp SparkPlug CMS? 
 
13amp.com is suspended by the ISP and 13amp.net redirects to some "learn
Chinese" site.
 


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

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

RE: Comparing two arrays or lists

[Everett, Al \(NIH/NIGMS\) [C]]

Did you look at ListCompare ( http://www.cflib.org/udf.cfm?ID=149 ) ?
ListDiff ( http://www.cflib.org/udf.cfm?ID=660 ) ? listsAreDistinct (
http://www.cflib.org/udf.cfm?ID=960 ) ? 

One of those sounds like it'll do what you want.


-Original Message-
From: Joel Watson [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, March 06, 2007 10:41 AM
To: CF-Talk
Subject: Comparing two arrays or lists

I have two lists that I want to compare and be able to show the
resulting differences.  For example, if my first list has 1,2,3,4 and
the second has 1,2,4,4, I want to be able to output that "3" and "4" are
different.

What would be the best way of going about this?  I applied the
"arrayCompare" UDF from cflib, but it only outputs a bollean for the
entire comparison.  I would like to be able to compare on a more
detailed level and output the results.


~|
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:271736
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: undefined in APPLICATION???

[Everett, Al \(NIH/NIGMS\) [C]]

> What am I doing wrong?

Not scoping your variables. Application is not one of the scopes that CF
searches when presented with an unscoped variable. You have to
explicitly use the application scope prefix.

~|
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:271715
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Insert Looped Form Entry into Database

[Everett, Al \(NIH/NIGMS\) [C]]

For one thing, you have too many pound signs.



Should be



Where is "Results.QuestionID" coming from? If you're using this code
inside of a loop for a query result, you either need to put that value
in a local variable or explicitly name the row.

Results.QuestionID[CurrentRow]


 

-Original Message-
From: Joel Watson [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, March 06, 2007 8:53 AM
To: CF-Talk
Subject: Re: Insert Looped Form Entry into Database

Thanks for the quick response!  This does work, but now I am running
into another problem.  While it submits the right number of entries to
my database (in this case, 7), it submits the same value for all (e.g.,
Havanna, Havanna, Havanna, Havanna, Havanna, Havanna, Havanna).  Here is
the code that I am using:








UPDATE Users
SET AnswerID =
  '#mylist#'
WHERE Username = "existdissolve"

 


The loop gives me the correct number of entries, but does not separate
the values.  If I do a straight loop of the query "Results," it enters
all the values, but duplicates each value per the number of answer
options available.

Again, I really appreciate both your guy's help!

Joel


>Access the FORM struct using array notation:
>
>#FORM[ "Q#QuestionID#" ]# 
>
>This should work the way you expect it to.
>
>.
>Ben Nadel
>Certified Advanced ColdFusion MX7 Developer
>www.bennadel.com
> 
>Need ColdFusion Help?
>www.bennadel.com/ask-ben/
>
>-Original Message-
>From: Joel Watson [mailto:[EMAIL PROTECTED] 
>Sent: Tuesday, March 06, 2007 7:37 AM
>To: CF-Talk
>Subject: Insert Looped Form Entry into Database
>
>I have a cfform that is dynamically populated with test questions and
>answer choices from a database.  The answer choices are also
dynamically
>named based upon the id of the question, e.g., input
>name="Q#QuestionID#". I am currently able, upon submit, to pass the
>values of user-selected answers, producing this:
>
>struct
>FIELDNAMESSUBMIT,Q1,Q2,Q3,Q4,Q5,Q6,Q7
>Q1Mexico City
>Q2Seattle
>Q3London
>Q4Istanbul
>Q5True
>Q6HEre is an essay question
>Q7Here is an essay question
>SUBMITSubmit Test
>
>My question is how do I capture the fieldnames and values (i.e., Q1 -
>Mexico City) so that I can place them in a database when the fieldnames
>are being dynamically created?  I initially tried an insert
>qualification like '#FORM.Q#QuestionID##', but obviously this does not
>work as CF complains about "Q" being undefined.  Any ideas would be
>greatly appreciated!
>
>Joel



~|
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:271699
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Insert Looped Form Entry into Database

[Everett, Al \(NIH/NIGMS\) [C]]

If you know the number range you're using, and there are no gaps,
something like this should do the trick



INSERT INTO ANSWERS
(
QUESTION_ID,
ANSWER
)
VALUES
,

)



The key is using "array notation" rather than "dot notation":
#form["fieldname"] 

-Original Message-
From: Joel Watson [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, March 06, 2007 7:37 AM
To: CF-Talk
Subject: Insert Looped Form Entry into Database

I have a cfform that is dynamically populated with test questions and
answer choices from a database.  The answer choices are also dynamically
named based upon the id of the question, e.g., input
name="Q#QuestionID#". I am currently able, upon submit, to pass the
values of user-selected answers, producing this:

struct
FIELDNAMESSUBMIT,Q1,Q2,Q3,Q4,Q5,Q6,Q7
Q1Mexico City
Q2Seattle
Q3London
Q4Istanbul
Q5True
Q6HEre is an essay question
Q7Here is an essay question
SUBMITSubmit Test

My question is how do I capture the fieldnames and values (i.e., Q1 -
Mexico City) so that I can place them in a database when the fieldnames
are being dynamically created?  I initially tried an insert
qualification like '#FORM.Q#QuestionID##', but obviously this does not
work as CF complains about "Q" being undefined.  Any ideas would be
greatly appreciated!

Joel

~|
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:271689
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: GotCFM.Com Status Report

[Everett, Al \(NIH/NIGMS\) [C]]

What are your plans for duplicates? I see that http://www.macworld.co.uk/ is 
listed twice, for instance. 

-Original Message-
From: Rey Bango [mailto:[EMAIL PROTECTED] 
Sent: Monday, March 05, 2007 8:59 AM
To: CF-Talk
Subject: Re: GotCFM.Com Status Report

Hi Claude,

Please email me with any changes you need and I'll be happy to update the 
records.

Rey

Claude_Schnéegans wrote:
>  >>Also, apart from the list, what else do you see can be put onto the 
> site to help promote CF-based technologies? (everyone should feel free 
> to jump into this discussion and offer suggestions)
> 
> Is it possible to re-edit the records we sent?
> I see that I forgot to update the filed for the CF version, and the 
> version is 3.x by default.
> 
> 



~|
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:271517
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: checking for best approach

[Everett, Al \(NIH/NIGMS\) [C]]

> I'd still parse the inital form into the session scope and just
redisplay that though.

Nothing wrong with either approach, of course. I had a couple of reasons
for thinking form would be better.

- I have to have a form for the configuration button anyway.
- Sessions would have to be enabled.
- If the user navigates away from the confirmation page I don't want the
data to hang around.

Of course, these might not apply in the original poster's case. As with
so many things CF, there are multiple ways to accomplish the same thing.

~|
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:271309
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: checking for best approach

[Everett, Al \(NIH/NIGMS\) [C]]

> And of course, I don't need to warn you about just blindly taking the
data you've saved into the form and got then got handedd back and 
> using it in SQL do I ?

Of course not. I am a zealous user of cfqueryparam.

~|
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:271299
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: checking for best approach

[Everett, Al \(NIH/NIGMS\) [C]]

> Alternatively I could save the form data on the confirmation page to
hidden values and then on the action page use the data in the 
> hidden fields to write to the database.

That's probably how I would approach it.

Uncle Ben's CF_EmbedFields custom tag would make this easy.

http://www.adobe.com/cfusion/exchange/index.cfm?view=sn131&extID=101
#loc=en_us&view=sn131&extID=101&viewName=Adobe%20Exchange&avm=1

~|
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:271291
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Show your support for CF - cfMaps.com

[Everett, Al \(NIH/NIGMS\) [C]]

Whatever happened to the group on Frappr.com? 

-Original Message-
From: Nicholas M Tunney [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, February 28, 2007 10:03 PM
To: CF-Talk
Subject: Show your support for CF - cfMaps.com

I think this fits into the discussion over the last two days well (300k
CF devs and gotcf.com):

I've been putting together a community site for the last few weeks, and
it is finally ready to be released. The site is called cfMaps.com
. Overall, it allows ColdFusion developers and
ColdFusion sites to be geocoded and placed on a map of the world. I
think I should be able to derive some pretty cool statistics in the long
run. Companies can also search by zip code or country to find a CF
developer.

Check out the About
 page to see why I
put this together and get a bigger picture of what the site does. My
goal is to allow developers and managers to see how widespread
ColdFusion really is. If you are a CF developer, I hope you register
. If you
have a ColdFusion site, I hope you register the site
 as well.

- Nic





~|
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:271149
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: upload multiple images

[Everett, Al \(NIH/NIGMS\) [C]]

 

-Original Message-
From: Rick King [mailto:[EMAIL PROTECTED] 
Sent: Thursday, March 01, 2007 9:50 AM
To: CF-Talk
Subject: upload multiple images

Hey all, I'm using the following script to allow users to upload 3
images. It seems to work fairly well, but I have 2 issues.

1. It errors unless a user uploads all 3 images. I'd like to give them
the option of only uploading 1 or 2 images.

2. I have a hidden form variable called IsPrimary that should set the
image in the first upload field to "Yes" and the other 2 to "No" (the
IsPrimary image is the one that shows up in searches, etc.) But with
this script, they're all being set to "Yes"

Any ideas on how to solve these 2 issues?

Thanks
Rick



  

  




SET NOCOUNT ON;
INSERT INTO Products (CatID, UserID, Designer, Model, Color, Price,
Material, Description, Status)
VALUES ('#Trim(FORM.CatID)#',
'#Trim(SESSION.Auth.UserID)#', 
'#Trim(FORM.Designer)#', 
'#Trim(FORM.Model)#', 
'#Trim(FORM.Color)#', 
'#Trim(FORM.Price)#', 
'#Trim(FORM.Material)#', 
'#Trim(FORM.Description)#',
'Pending');
SELECT @@identity AS ProdID FROM Products;










 




   INSERT INTO Images (ProdID, Image, IsPrimary)
   VALUES (#Product.ProdID#,'#cffile['file'&i].serverFile# ',
'#FORM.IsPrimary#')



 
  
  
  
  



~|
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:271145
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Ideas and approaches

[Everett, Al \(NIH/NIGMS\) [C]]

The CFPOP tag returns a query on action="getAll", which has a column
BODY which presumably has the text that you want to manipulate. 

-Original Message-
I have a plain text email that this pushed out when triggered by a third
party app (BaseCampHQ).  Inside Basecamp, I can point this email to any
fixed address I choose.  What I want to do is: receive this email inside
CF, then parse the body, glitz it up with HTML, and resend out to a list
of people.  I would assume that I set up CFPop to receive the mail, but
I don't know how to do is grab the text body of the message, so I can
save in a var and paste into the new HTML message I create with CFMail.
What is/are good approaches to doing that?

Thanks for your help.

Mark

~|
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:271001
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: GotCFM.Com is Launched - Dedicated to CF Evangelism

[Everett, Al \(NIH/NIGMS\) [C]]

If you want to keep the spam down, I suggest using rel="nofollow".

You'll probably need a CAPTCHA at some point, too. 

-Original Message-
From: Rey Bango [mailto:[EMAIL PROTECTED] 
Sent: Monday, February 26, 2007 11:22 PM
To: CF-Talk
Subject: ANN: GotCFM.Com is Launched - Dedicated to CF Evangelism

Guys, for awhile, I've been griping up a storm via my blog and to
whomever would listen that MM & Adobe weren't doing enough to get the
word out about CF. And while I still think that a lot of work needs to
be done, I came to the realization that I also needed to do more than
just post gripes. I recently read this post on Ray Camden's blog:

http://ray.camdenfamily.com/index.cfm/2007/2/22/Help-spread-the-word-at-
the-Peoples-Toolbox

The quote that struck me was:

"apparently they had never heard of it, and I'm having a bit of trouble
convincing them that a) lots of people use ColdFusion and b) that it is
indeed worth adding to their site""

It hit me how bad of a job *all* of us have done in keeping ColdFusion
in the limelight. ColdFusion and CFML just celebrated its 10th year and
here's some new, unknown site questioning CF's worthiness. I was
floored.

So I decided to use a domain that I've had sitting around for some time
as a vehicle for CF-related evangelism.

http://www.gotcfm.com/

I am looking at GotCFM.com as a VERY niche site that's whole focus is to
have information to help promote CF-related technologies. It won't allow
people to search for the best way to create a CFC or which custom tag is
available for zip code locations. There are plenty of top-notch sites
for that. I want to build a place where anyone can go to find specific
information such as:

- A continuously updated list of sites using CF
- Information on how to position CF within your company
- Information on specific features that make CF better than other
technologies
- Case studies on successful implementations of CF
- "Powered by" buttons
- Banner ads that can be added to your site to promote your favorite CF
engine

Some of you may say, "Well, Ben Forta already keeps a list of sites
using CF", and that's certainly true. Ben has done a great job over the
years of trying to get a nice list of sites. But, by no fault of Ben,
its not all encompassing, its not up-to-date and it doesn't appear to
include sites built using other technologies like Ralio, Coral or
BlueDragon. We don't just need a list of Adobe ColdFusion powered sites.

We need a list of ALL *CFML* powered sites. And we need a method of
allowing people to submit these sites themselves.

I hope to flush it out further, especially if I can get community
support. I hope that this type of site, dedicated solely to methods of
bi-partisan CF evangelism, will help spread the word about CFML.

I've already received support from New Atlanta and hope to soon get the
support of Adobe, Ralio and the whole CF-Community.

Your feedback is welcome and your involvement would definitely be
appreciated. You can start by submitting sites that powered by *ANY*
CFML engine. That would be a great first step. If you have other ideas
for the site, please let me know.

Thanks,

Rey Bango...



~|
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:270858
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: ANN: GotCFM.Com is Launched - Dedicated to CF Evangelism

[Everett, Al \(NIH/NIGMS\) [C]]

The U.S. Federal and State Governments love CF. Unfortunately, most of
the uses of it (like mine) are on intranet applications.

http://www.google.com/search?source=ig&hl=en&q=index.cfm+*.gov&btnG=Goog
le+Search gives some of the public ones, though.

~|
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:270800
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Delimited list problems - a bug?

[Everett, Al \(NIH/NIGMS\) [C]]

>Sure. Replace the substring that you want to use as a list delimiter
with a single character, then do your list operation. For the single
>character, be careful to use something that's unlikely to be in your
data already. I like to use a non-printable character for this, like
>the Bell character (ASC 7, I think).

I like to use CHR(30) for that, which is the "record separator"
character.

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: Changes to Daylight Savings Time in 2007 may affect your data bases (DB2, Oracle and others)

[Everett, Al \(NIH/NIGMS\) [C]]

> Is 1.4.2_11 officially approved for use by Adobe for CFMX 6.1 and
7.02?

http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=d2ab4470

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: Better way to send nulls to a Stored Proc?

[Everett, Al \(NIH/NIGMS\) [C]]

> 1. a function that returns true if a string has length, and false if
it doesn't,

I like to use IsNull () ( http://www.cflib.org/udf.cfm?id=644 ) which
should be easy to convert to IsNotNull().

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: cfsearch issue

[Everett, Al \(NIH/NIGMS\) [C]]

>From what I'm reading, only "AND", "OR", and "NOT" will cause problems,
as the other words need to be escaped with brackets in the search
criteria.

You could try this UDF, http://www.cflib.org/udf.cfm?ID=760, but I don't
know if it's up to date for CFMX 7. 

-Original Message-
From: Jason Herbolsheimer [mailto:[EMAIL PROTECTED] 
Sent: Friday, January 12, 2007 2:46 PM
To: CF-Talk
Subject: RE: cfsearch issue

Is there a set list of reserved words that I can/should use?
Is there a udf out there that I could use/modify to replace and surround
these reserved words with single quotes?



-----Original Message-
From: Everett, Al (NIH/NIGMS) [C] [mailto:[EMAIL PROTECTED]
Sent: Friday, January 12, 2007 1:18 PM
To: CF-Talk
Subject: RE: cfsearch issue


If you want to use a reserved word as part of the Verity search, you
need to put it in quotes.

Criteria="Why $50 per Barrel Oil is 'Not' Out of the Question"



-Original Message-
From: Jason Herbolsheimer [mailto:[EMAIL PROTECTED]
Sent: Friday, January 12, 2007 2:06 PM
To: CF-Talk
Subject: cfsearch issue

Hello,
I have run into a problem using a verity index and cfsearch.  The
problem I'm having is that the search string that is being used has the
word "Not"
in it.
The search string is listed below, with the error I'm getting.  The
cfsearch code is listed below that.  Does anyone know how I get around
this issue?
Thanks in advance.

Search string: Why $50 per Barrel Oil is Not Out of the Question

Error: Invalid search CRITERIA specified: Why AND $50 AND per AND Barrel
AND Oil AND is AND Not AND Out AND of AND the AND Question.

Code:
 
Jason Herbolsheimer
11204 Davenport, Suite 200b
Omaha, NE 68154
http://www.cfwebtools.com
402-408-3733 Ext 102

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: cfsearch issue

[Everett, Al \(NIH/NIGMS\) [C]]

If you want to use a reserved word as part of the Verity search, you
need to put it in quotes. 

Criteria="Why $50 per Barrel Oil is 'Not' Out of the Question"



-Original Message-
From: Jason Herbolsheimer [mailto:[EMAIL PROTECTED] 
Sent: Friday, January 12, 2007 2:06 PM
To: CF-Talk
Subject: cfsearch issue

Hello,
I have run into a problem using a verity index and cfsearch.  The
problem I'm having is that the search string that is being used has the
word "Not"
in it.
The search string is listed below, with the error I'm getting.  The
cfsearch code is listed below that.  Does anyone know how I get around
this issue?
Thanks in advance.

Search string: Why $50 per Barrel Oil is Not Out of the Question

Error: Invalid search CRITERIA specified: Why AND $50 AND per AND Barrel
AND Oil AND is AND Not AND Out AND of AND the AND Question.

Code:
 
Jason Herbolsheimer
11204 Davenport, Suite 200b
Omaha, NE 68154
http://www.cfwebtools.com
402-408-3733 Ext 102






~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: List of Sections from an initialisation file

[Everett, Al \(NIH/NIGMS\) [C]]

listOfSections = structKeyList(getProfileSections(inifile.ini))

I've done such a thing. Let me see if I can dig up my code...
























   



I then generally add this structure to the application scope.

HTH

-Original Message-
From: James Buckingham [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 11, 2007 10:13 AM
To: CF-Talk
Subject: List of Sections from an initialisation file

Hi everyone,

Is there any way that I can get a list of all the sections within an ini
file through ColdFusion? 

If I use getProfileSections and dump it I'm seeing each section + all
the variables included with them. All I want, for now, is the section
names.

What I'm looking to do is setup a simple dynamic loop which uses the
list to grab each section, insert its variables into a struct and place
this in my application. That way if I add a new section to the ini. file
I don't have to worry about extending my CF code to accommadate it. 

Or is there an easier way I could be doing this?

Cheers,
James



~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: CF7 and tasks won't run through scheduler

[Everett, Al \(NIH/NIGMS\) [C]]

Are you using any kind of third party user authentication, like
SiteMinder. I ran into exactly this.

When I entered the URLs in my own browser I was already authenticated
with SiteMinder, so they ran. When ColdFusion tried to run them it, of
course, didn't authenticate with SiteMinder. Since Siteminder returns a
"200 OK" no matter what, to ColdFusion the template ran.

Our solution was to create a special website for scheduled tasks that
doesn't use authentication. To keep it secure we restricted the Ips that
it would respond to. 

-Original Message-
From: Earl, George [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 11, 2007 11:09 AM

We're running CF Enterprise 7.0.2 on Win2k.

A couple of days ago I created a whole bunch of scheduled tasks. None of
these tasks work through the scheduler itself nor through clicking on
the 'Run Scheduled Task' icon on the scheduled tasks page in CFAdmin.

If I do the latter I get a message at the top of the scheduled task page
that says the task was run successfully and I get a corresponding entry
in the scheduler.log file. However the task doesn't do what it is
supposed to do - it's like it didn't really run. 

If I let the scheduler run the tasks as scheduled I get the same
messages in scheduler.log that say the tasks ran successfully but they
really haven't.

If I copy the URLs in the scheduled task setup page and drop them into a
browser and run them they work fine.

We restarted the CF Application service and tried again but that didn't
fix the problem.

I deleted and recreated a task but that didn't fix it.

Other tasks that I had created in the past work just fine.

Any ideas what might be causing this problem?

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: Number to currency words

[Everett, Al \(NIH/NIGMS\) [C]]

Of course, if you wanted to roll your own, judicious use of
NumberAsString() should serve you well. 

-Original Message-
From: Everett, Al (NIH/NIGMS) [C] 
Sent: Wednesday, January 10, 2007 3:06 PM
To: CF-Talk
Subject: RE: Number to currency words

Try DollarAsString

http://www.cflib.org/udf.cfm?ID=58 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: Number to currency words

[Everett, Al \(NIH/NIGMS\) [C]]

Try DollarAsString

http://www.cflib.org/udf.cfm?ID=58 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 08, 2007 11:53 AM
To: CF-Talk
Subject: Number to currency words

Is there anything out there that will take a number and convert it to
words like you would have on a check? Example 12.45 would become "twelve
dollars and forty five cents".

 

Lee





~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: dmoz

[Everett, Al \(NIH/NIGMS\) [C]]

> My first organizational request would be for a Mailing Lists section
to showcase all of the ColdFusion specific mailing lists. This does 
> benefit me a little as each list here is a separate entity (like the
various google or yahoo lists), but not all of them are ColdFusion 
> specific.

You'll not get every mailing list with its own listing. Since
houseoffusion.com is listed in the main category, it's unlikely that any
deeplinks from there will be in subcategories. See the editing
guidelines: http://dmoz.org/guidelines/site-specific.html#deeplinks

> I'd be happy to compile a collection of all of the ColdFusion related
lists from Google, Yahoo, and independent sources (CFCDev, CFDJ,
> etc.)

Go for it.

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: Using arrays in a simple bean

[Everett, Al \(NIH/NIGMS\) [C]]

No, no, that's not what I need.

The "sponsor" is just a string value in the meeting object. I don't need
an array of sponsor objects. I just need an array of strings in my
object.

Now that I think about it some more, I'm going to be working with the
data as a list almost exclusively. As such, getSponsorList() and
setSponsorList() are fairly straightforward. How I actually store them
in the instance is really immaterial. Is it a "bad thing" to have
private methods in a bean in case I need to do some manipulation of the
array "under the covers"?

-Original Message-
From: Teddy Payne [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 21, 2006 12:36 PM
To: CF-Talk
Subject: Re: Using arrays in a simple bean

Al,
When you deal with one record or one sponsor at a time, you can use a
getter/setter bean to modify its data.  If you individually want to
modidy a group of them, a typical useage is an array of bean objects.
The array of bean objects gets expensive though creating all of the
objects.  If you just want to just output them, you would create a
gateway, which would just return a query of the sponsors.

Since you are dealing with only 10 though, you may be able to get away
with an array of beans aka value objects.

I would definitely test performance.

Teddy

On 12/21/06, Everett, Al (NIH/NIGMS) [C] <[EMAIL PROTECTED]> wrote:
>
> I'm using a bean cfc for an instance of a meeting. Each meeting can 
> have between 0 and 10 sponsors. (These are just string values.)
>
> Rather than have setSponsor1, getSponsor1, setSponsor2 etc. and have 
> 10 different properties in the instance, I thought I'd put it into an 
> array. This has two other side effects: Memory isn't taken up by 
> undefined variables and it should easily allow for future 
> expansion/contraction if the business rules should change.
>
> I'm having a bit of trouble getting my head around the best way to do 
> the getter/setter methods. Has anyone done something similar that I 
> could crib for ideas?
>
>
> 



~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: Using arrays in a simple bean

[Everett, Al \(NIH/NIGMS\) [C]]

No, no reason, except a structure with numbers as keys is essentially an
array anyway. That doesn't help me with best practices for getting the
data into and out of the instance. 

-Original Message-
From: Qasim Rasheed [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 21, 2006 12:28 PM
To: CF-Talk
Subject: Re: Using arrays in a simple bean

Is there are reason you cannot use Structure for meeting sponsors?

e.g.

  ..

HTH

On 12/21/06, Everett, Al (NIH/NIGMS) [C] <[EMAIL PROTECTED]> wrote:
>
> I'm using a bean cfc for an instance of a meeting. Each meeting can 
> have between 0 and 10 sponsors. (These are just string values.)
>
> Rather than have setSponsor1, getSponsor1, setSponsor2 etc. and have 
> 10 different properties in the instance, I thought I'd put it into an 
> array. This has two other side effects: Memory isn't taken up by 
> undefined variables and it should easily allow for future 
> expansion/contraction if the business rules should change.
>
> I'm having a bit of trouble getting my head around the best way to do 
> the getter/setter methods. Has anyone done something similar that I 
> could crib for ideas?
>
>
> 



~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

Using arrays in a simple bean

[Everett, Al \(NIH/NIGMS\) [C]]

I'm using a bean cfc for an instance of a meeting. Each meeting can have
between 0 and 10 sponsors. (These are just string values.)
 
Rather than have setSponsor1, getSponsor1, setSponsor2 etc. and have 10
different properties in the instance, I thought I'd put it into an
array. This has two other side effects: Memory isn't taken up by
undefined variables and it should easily allow for future
expansion/contraction if the business rules should change.
 
I'm having a bit of trouble getting my head around the best way to do
the getter/setter methods. Has anyone done something similar that I
could crib for ideas?


~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: Posting variables

[Everett, Al \(NIH/NIGMS\) [C]]

I've done something like that. My method was to have a hidden form field
with the original data and compare it to the submitted data.








...
 


Of course, I'd loop on form.fieldnames (or a custom list of field names
to check) so I wouldn't have to repeat the same code for every field.

Another option might be to use JavaScript to disable the unchanged
fields. Disabled fields aren't in the FORM scope of the action page.


-Original Message-
From: Richard White
Sent: Monday, September 25, 2006 1:54 PM
To: CF-Talk
Subject: Posting variables

Hi, i am used to programming standalone computer applications not
internet applications and would really appreciate some advice.

I have a form with quite a few fields (text boxes etc...) on it. For
additiional HCI, when the user edits the form from pre-exsting data, i
like to have the fields all green, then if they edit some of the fields
they turn red, to show that the changed data needs to be saved.  

To lesson the load on the database interation, i would like to program
it so that when the user clicks save changes, it only updates the
database based on the fields that are red. This is quite simple in
standalone computer apps as i just code it to look for the fields that
are red, but of course with the internet apps i cant check this as when
the user clicks submit the fields are gone. 

Can anyone give me some advice on how this can be done. I am a bit lost
with this. Thanks

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

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

RE: SESSION won't save on user's computer

[Everett, Al \(NIH/NIGMS\) [C]]

A software firewall, perhaps, that is blocking cookies? 



-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 22, 2006 11:39 AM
To: CF-Talk
Subject: RE: SESSION won't save on user's computer

I believe so, but it does this in both IE AND a fresh install of
Firefox.
Wouldn't you think that cookies would be turned on by default in FF? I
checked for cookies in IE, but not specifically in FF.

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

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

RE: The best free word editor?

[Everett, Al \(NIH/NIGMS\) [C]]

openoffice.org 


-Original Message-
From: Will Tomlinson 
Sent: Thursday, September 21, 2006 8:48 PM
To: CF-Talk
Subject: OT: The best free word editor?

I haven't been able to reinstall any word editors since my puter crashed
a few months back. What's the best free editor out there? 

I'll google for one but thought I'd get some input. 

Thanks,
Will

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

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

RE: isdefined() error

[Everett, Al \(NIH/NIGMS\) [C]]

Syntactically correct ColdFusion variables contain letters, numbers, and
the underscore. 


-Original Message-
From: Chad Gray 
Sent: Monday, September 11, 2006 11:11 AM
To: CF-Talk
Subject: isdefined() error

Isdefined is giving me an error when a form variable has a slash
character in it.

Error:
Parameter 1 of function IsDefined, which is now
"Form.ItemRemove_/XP106", must be a syntactically valid variable name.

Code:



What is syntactically valid for CF variable names?

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

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

RE: File attachment after user error

[Everett, Al \(NIH/NIGMS\) [C]]

Basically, it can't be done. Not with HTML and JavaScript, anyway. It's
a security issue. What you're seeing is by design.

You'd have to use something other than .

-Original Message-
From: Casey C Cook 
Sent: Thursday, August 31, 2006 3:03 PM
To: CF-Talk
Subject: File attachment after user error

Once again Ive run into one of those "seems so easy, yet its so hard" 
situations. 

Basically, a user has the ability to attach up to 3 files on a form
. If the user throws an error, such as forgetting to
input a required field, the form will submit and go through
validation.cfm since they didnt pass the validation they will come back
to the submission screen. The problem is, I know the user has
input/attached a file, but browser security prevents me from populating
the input field with the previous entry. Does anyone know a good way
around this? I want to keep all the same logic in place, just be able to
somehow recognize the user has already made the effort to attach the
file and be able to submit that information after they correct their
error. So far we have discussed many other solutions which will work,
but require a coding effort greater than what should seem so easy -
populate the freaking value the user has entered previously. Seems like
I run across one of these scenario's once every six months and just
wonder why things seem so easy when talking about it, but next to
impossible in practice. Ive spent way too much time on this, any input
would be greately appreciated.

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

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

RE: directory listener

[Everett, Al \(NIH/NIGMS\) [C]]

One of the sample asynchronous gateways that ships with CFMX 7 is a
directory watcher. 

-Original Message-
From: Crow T Robot 
Sent: Thursday, August 31, 2006 3:14 PM
To: CF-Talk
Subject: directory listener

Anyone know of a way to create a "listener" that would listen to a
directory and send an email out when a file is modified/created?

 

I have a client who is insisting on getting FTP access, and considering
their level of expertise ("I know DreamWeaver!  I can write my own code
now!"), I'd like to be the fly on the wall for a little while.  Strictly
for the sake of entertainment, of course.  :-)

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251672
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 bringing down IIS Application Pool

[Everett, Al \(NIH/NIGMS\) [C]]

> Try downloading the latest wsconfig and rerunning the connection to
IIS.  I believe it will create wsconfig\2 folder with the 
> newer dll in it.  

I'll pass that along.

> If all else fails, reinstall windows,

Unlikely.

> or better yet install apache :-P

Not an option.

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251530
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 bringing down IIS Application Pool

[Everett, Al \(NIH/NIGMS\) [C]]

Following up.

After going round-and-round with the hardware guys, they finally called
Microsoft who had them get a crash dump. MS's analysis says that the
culprit is JRUN_IIS6_WILDCARD.DLL.

00d51264 77bcde94 00d51280 1000d60f 00d532f0 msvcrt!_output+0x6a7 
00d512a0 10001d02 00d522cc 0fff 1000d600 msvcrt!_vsnprintf+0x2d
00d8fe2c 5a32150f 00d93b60  00d934f8
jrun_iis6_wildcard!TerminateExtension+0xa2
00d8fe48 5a3991f1 00d93ad8 10001480 00d8fe74
w3isapi!ProcessIsapiRequest+0x204 
00d8fe7c 5a3992a0   00d934f8
w3core!W3_ISAPI_HANDLER::IsapiDoWork+0x2ac 
00d8fe9c 5a394bf0 00d8fef0 00d928d8 0001
w3core!W3_ISAPI_HANDLER::DoWork+0xae 
[snip]


The file is:

D:\CFusionMX\runtime\lib\wsconfig\1\jrun_iis6_wildcard.dll
Timestamp:Thu Jan 06 14:24:33 2005 (41DD9E81)
File version: 4.0.5.25479
ProductName:  Macromedia JRun Application Server



MS's suggestion is to replace the file with a newer one. Okay, I can see
instructions in the Adobe Knowledgebase on how to do that, but I'm not
finding anything which talks about this file bringing down IIS. Am I
missing it?

Also, how can this file be implicated when the most reliable scheduled
task in bringing down the Application Pools was the one that ran every
61 seconds and called a vanilla HTML file?


-Original Message-

Got a scenario I'm currently investigating. Our test and production
machines are crapping out on a daily basis. It appears that something
ColdFusion is doing is bringing down the IIS application pool. Oddly,
the identically-configured development server is unaffected.
 
What would cause that to happen? A runaway memory leak?


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

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

RE: cfloop conditional help

[Everett, Al \(NIH/NIGMS\) [C]]

I don't think you need to loop at all. Your ranges are 10 numbers
apiece, right?








"\" is the operator for integer division.

72 \ 10 = 7 * 10 = 70 + 1 = 71
71 + 10 = 81 - 1 = 80




-Original Message-
From: [EMAIL PROTECTED]
Sent: Friday, August 25, 2006 3:07 AM
To: CF-Talk
Subject: cfloop conditional help

I want to loop over a URL.VIDEO_ID value and find the numeric range it
falls in. 
The value range needs to be between 1-10 or 11-21 etc. until the
condition is met. 

EXAMPLE: if the URL.VIDEO_ID value is 72 I would want to cfloop until I
found the range that this 72 value fit and then set variables like ...

and


I have ...

 
  

THIS IS WHERE I NEED HELP

 


D-

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

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

RE: storing registry in a datastore

[Everett, Al \(NIH/NIGMS\) [C]]

Do you mean storing CLIENT variables?

-Original Message-
From: Maureen Barger 
Sent: Thursday, August 24, 2006 1:15 PM
To: CF-Talk
Subject: storing registry in a datastore

When doing this, do I need to define any tables or columns? Or simply
create the instance and let ColdFusion do its thing? cfmxe 7.01 under
solaris.

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

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

RE: Sorting by Column Headers

[Everett, Al \(NIH/NIGMS\) [C]]

Well, yeah, because the form variables don't exist because you're not
submitting a form.

There are a couple of ways I would attack this:

1. Cache the initial query to the session scope. Then do a query of
query to sort when one of the headers is clicked.

2. Have the form use method="get" so that query criteria are in the URL,
use URL variables in the query, and adjust the links in the headers to
include the initial criteria.

Option 1 is best, I think, because it only has one trip to the database
per search.

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

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

RE: CFQUERY of non-swequential primary key ids

[Everett, Al \(NIH/NIGMS\) [C]]

How very inefficient. How about something like this: 


SELECT vidwee_id
FROM vidweek







   select vow_up_lgnail_file,vidwee_id,vow_title
   from vidweek
   where vidwee_id = #VAL_ID#





There is also a function on CFLIB to randomly select rows from a
database table:

http://www.cflib.org/udf.cfm?id=524

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]

Sent: Wednesday, August 23, 2006 12:14 PM
To: CF-Talk
Subject: CFQUERY of non-swequential primary key ids

All,

I'm doing a query and randomly displaying images from within each record
but records have been removed so I don't have sequential id values.

PROBLEM:
When I run this code sometime I get images, sometimes I get nothing. 
Should I be running a different random'izer? 8-) Any ideas?

CODE:
   
   
   select *
   from vidweek
   order by vidwee_id desc
   
 
   select *
   from vidweek
   order by vidwee_id asc
   
   
   
   
   select vow_up_lgnail_file,vidwee_id,vow_title
   from vidweek
   where vidwee_id = #VAL_ID#
   






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

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

RE: Parsing an XML Feed

[Everett, Al \(NIH/NIGMS\) [C]]

-Original Message-
How would I write the file to my filesystem, could you explain please.


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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250603
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 Rules on including Application.cfm

[Everett, Al \(NIH/NIGMS\) [C]]

Uh...not as I understand it. CF looks for an Application.cfm in the
current template's directory. If one isn't found it looks in the next
higher directory and keeps moving up the directory tree until it finds
an Application.cfm or reaches the root directory. It never runs more
than one Application.cfm unless you do something like  in an Application.cfm file.

Note that CFMX7 will use Application.cfc if one is found and ignore
Application.cfm.

-Original Message-
From: Munson, Jacob 
Sent: Monday, August 21, 2006 1:00 PM
To: CF-Talk
Subject: RE: CF Rules on including Application.cfm

It is as simple as you stated.  If you run a .cfm file, ColdFusion looks
for an Application.cfm file in it's directory, and in the parent
application's root directory.  It will run both of those (assuming there
is a lower level directory Application.cfm file)

> -Original Message-
> From: Robertson-Ravo, Neil (RX)
> Sent: Monday, August 21, 2006 8:53 AM
> 
> Does anyone know what the rules are for ColdFusion including 
> Application.cfm?  I mean, it cannot be as simple as "you have 
> requested a ..cfm file, I am gonna look for an Application.cfm now" is

> it?  Does it look into headers etc?

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250474
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 bringing down IIS Application Pool

[Everett, Al \(NIH/NIGMS\) [C]]

Hmmm...there is a distinct lack of named locks around some cffile calls
in a scheduled task. (Not my code.) A possible culprit?

The other difficulty here is that this was not happening until after
some access changes had been made to allow a directory to be accessed by
an anonymous web user for a scheduled task. There's nothing really that
exotic going on.



-Original Message-
From: Dave Watts 
Sent: Friday, August 18, 2006 12:48 PM
To: CF-Talk
Subject: RE: CF bringing down IIS Application Pool

> Got a scenario I'm currently investigating. Our test and production 
> machines are crapping out on a daily basis. It appears that something 
> ColdFusion is doing is bringing down the IIS application pool. Oddly, 
> the identically-configured development server is unaffected.
>  
> What would cause that to happen? A runaway memory leak?

The only part of CF that runs within the IIS application pool is the
ISAPI filter and/or extension that is installed by the web server
configuration utility. Generally, all that does is pass requests to the
CF server, but I believe that it handles a more significant part of file
uploads via CFFILE and downloads via CFCONTENT, so I'd look at those
first.

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

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

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

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

CF bringing down IIS Application Pool

[Everett, Al \(NIH/NIGMS\) [C]]

Got a scenario I'm currently investigating. Our test and production
machines are crapping out on a daily basis. It appears that something
ColdFusion is doing is bringing down the IIS application pool. Oddly,
the identically-configured development server is unaffected.
 
What would cause that to happen? A runaway memory leak?


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

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

RE: Register CF 7 after developer install

[Everett, Al \(NIH/NIGMS\) [C]]

Simply go into the ColdFusion Administrator and enter your serial
number. 

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

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

RE: OT: Anyone else affected by the hostmysite outage?

[Everett, Al \(NIH/NIGMS\) [C]]

"Call before you dig!"

I expect there will be a lawsuit or three out of this.

-Original Message-
From: Casey Dougall [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 16, 2006 2:50 PM
To: CF-Talk
Subject: Re: OT: Anyone else affected by the hostmysite outage?

ha... they posted photos of the pipe... I guess we can believe them now.
http://hostmysite.com/emergency/

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

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

RE: Transform Unicode characters

[Everett, Al \(NIH/NIGMS\) [C]]

Couldn't a UDF get close to that?


































#REReplaceByArray(patterns,replacements,myString)#


Needs a bit of tweaking, but...

-Original Message-
From: Dmitrii Dimandt [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 16, 2006 12:08 PM
To: CF-Talk
Subject: Re: Transform Unicode characters

Accepts arrays for both patterns and replacements. From the docs:



But anyway, problem solved... In a way...

On 8/16/06, Everett, Al (NIH/NIGMS) [C] <[EMAIL PROTECTED]> wrote:
>
> What does preg_replace do that REReplace() doesn't?
>
> -Original Message-
> From: Dmitrii Dimandt [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 16, 2006 11:04 AM
> To: CF-Talk
> Subject: Re: Transform Unicode characters
>
> Because it transforms charactrs into garbage (sth. like %C4%B1 for ý). 
> And I need human-readable format :)) Anyway. I guess I'll stick to my 
> XML solution. I read mappings from a UTF-8 encoded XML file into 
> arrays and then iterate over them and replace whatever characters I 
> need. I miss PHP's preg_replace :)))
>
> 



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

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

RE: Transform Unicode characters

[Everett, Al \(NIH/NIGMS\) [C]]

What does preg_replace do that REReplace() doesn't? 

-Original Message-
From: Dmitrii Dimandt [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 16, 2006 11:04 AM
To: CF-Talk
Subject: Re: Transform Unicode characters

Because it transforms charactrs into garbage (sth. like %C4%B1 for ı). And I 
need human-readable format :)) Anyway. I guess I'll stick to my XML solution. I 
read mappings from a UTF-8 encoded XML file into arrays and then iterate over 
them and replace whatever characters I need. I miss PHP's preg_replace :)))

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

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

RE: cfqueryparam acting up

[Everett, Al \(NIH/NIGMS\) [C]]

A space perhaps?




-Original Message-
From: Richard Cooper 
Sent: Wednesday, August 16, 2006 10:51 AM
To: CF-Talk
Subject: cfqueryparam acting up

Hi,

I've recently been getting some odd occurrences when using
. For instance I've have a table products. Everything was
fine until recently when a product was updated via a CMS system.

Each product that was edited after this point had this error when
attempted to view in a listing:

[code]
[Macromedia][SQLServer JDBC Driver]Value can not be converted to
requested type.  
  
The error occurred in W:\inetpub\wwwroot\testsite\www\untitled.cfm: line
4
 
2 : SELECT *
3 : FROM products
4 : WHERE productID = 
5 : 
6 : 


SQLSELECT * FROM products WHERE productID = (param 1) 
[/code]

For example I went to ?productID=285 and it would break but
?productID=395 would be fineboth of which a integers, so both should
work. I removed the cfqueryparam to leave:  WHERE productID =
#URL.productID# and everything worked fine?

To get it working I have to change the SELECT * and list all of the
fields required.

The problem seems to be happening only when using cfqueryparam and only
on columns that are: INTEGER IDENTITY(1,1) PRIMARY KEY

I'm using CF MX 7 & SQL Server 2000 on a windows 2000 platform.

Has anyone else experienced such problems or know if I'm doing something
wrong

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

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

RE: CFDumping a bean

[Everett, Al \(NIH/NIGMS\) [C]]

Did you try getMetaData()? 


-Original Message-
From: Robert Everland III [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 15, 2006 12:23 PM
To: CF-Talk
Subject: CFDumping a bean

I want to dump a bean, but a dump on a bean only gives me a list of the
functions. How do you dump a bean? Do you create a function that
displays the parameter with the value? Or another way?

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

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

RE: ColdFusion extensions for Dreamweaver MX 2004 - non-administr ator

[Everett, Al \(NIH/NIGMS\) [C]]

I'll pass that along, thanks. 

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 15, 2006 11:44 AM
To: CF-Talk
Subject: RE: ColdFusion extensions for Dreamweaver MX 2004 -
non-administr ator

> I cannot install them as I do not have administrative rights to my 
> machine. One of the tech guys can install it as an administrator but 
> it's only installed for that user account and doesn't work for me.

Your administrator can handle this for you, with a little bit of work:

http://www.windowsitpro.com/Article/ArticleID/50102/50102.html?Ad=1

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

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

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

RE: ColdFusion extensions for Dreamweaver MX 2004 - non-administrator

[Everett, Al \(NIH/NIGMS\) [C]]

> CF Eclipse doesn't require an install.  You just execute the exe.
> Although that could have all kinds of policy repercussions I would
imagine.

Indeed. I'm not allowed. Not if I want to stay employed, which I do.

> I'm surprised that NIH is that locked down.  The software is approved
throughout pretty much the entire federal government.

Not necessarily NIH, but the individual institute.

> What is blocking you from installing the extensions?  Can't you just
run the built in extension manager? 

The extension manager runs, but I am informed that I have insufficient
privileges to complete the installation.

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

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

RE: Multiple joins between the same tables.

[Everett, Al \(NIH/NIGMS\) [C]]

So alias it. 

SELECT
c1.COMPANY_NAME AS BRAND_NAME, c2.COMPANY_NAME AS LABEL_NAME,
c3.COMPANY_NAME AS MANUFACTURER_NAME,
c4.COMPANY_NAME AS PUBLISHER_NAME, c5.COMPANY_NAME AS
STUDIO_NAME

-Original Message-
From: James Smith [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 15, 2006 10:40 AM
To: CF-Talk
Subject: RE: Multiple joins between the same tables.

> Look good to me. What's wrong? You can use the same table multiple 
> times or even joing a table on itself. I personally would use a LEFT 
> JOIN, but it depends what your goal is.

The problem with using...

 LEFT JOIN t_PI_Companies c1 ON (c1.CompanyID = m.BrandID)
 LEFT JOIN t_PI_Companies c2 ON (c2.CompanyID = m.LabelID)
 LEFT JOIN t_PI_Companies c3 ON (c3.CompanyID =
m.ManufacturerID)
 LEFT JOIN t_PI_Companies c4 ON (c4.CompanyID =
m.PublisherID)
 LEFT JOIN t_PI_Companies c5 ON (c5.CompanyID = m.StudioID)

Is that the column "CompanyName" in the "t_PI_Companies" table isn't
aliased for each join so whatever the "BrandID" is from the main table
is returned 5 times simply as "CompanyName".  What I need is some way
for the "CompanyName" to be returned 5 times with 5 different names so
each can be accessed separately.

I could do it by leaving out the companies and simply querying them
separately but I would prefer one query to six if at all possible.

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

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

ColdFusion extensions for Dreamweaver MX 2004 - non-administrator

[Everett, Al \(NIH/NIGMS\) [C]]

I work in a locked-down environment. I cannot install software myself
nor choose different tools to use.
 
We're using CFMX 7, so naturally I want the extensions for Dreamweaver
MX 2004.
 
I cannot install them as I do not have administrative rights to my
machine. One of the tech guys can install it as an administrator but
it's only installed for that user account and doesn't work for me.
 
I've not found anything in the Adobe knowledgebase yet. Any ideas?
 
No, I cannot use CFEclipse. No, I cannot get administrative rights to my
machine. Yes, Dreamweaver 8 may be an option, but that's a whole other
request process and who-knows-how-long a wait.


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

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

RE: (Admin) Security bulletin - ColdFusion AdminAPI Authentication Issue

[Everett, Al \(NIH/NIGMS\) [C]]

> their RSS Notification feed

Got an URL?

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

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

RE: CFIF inside a Form

[Everett, Al \(NIH/NIGMS\) [C]]

Me too.

-Original Message-
From: loathe 
Sent: Friday, August 11, 2006 10:39 AM
To: CF-Talk
Subject: RE: CFIF inside a Form

I prefer:








#text#



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

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

RE: OT - "Nice site I will recommend you to all my friends."

[Everett, Al \(NIH/NIGMS\) [C]]

It's likely they're testing their system so they can charge people to
send their spam.

"We can guarantee your message will appear on 50,000 websites and will
be indexed by Google within 1 week!" 


-Original Message-
From: Les Mizzell
Sent: Friday, August 11, 2006 9:50 AM
To: CF-Talk
Subject: Re: OT - "Nice site I will recommend you to all my friends."

Having no link in the message of any kind threw me off at first. Why not
go ahead and try to post all the intended spam the first time around
instead of a two tiered attack? Twice the work to do it that way, right?

. unless there's something a little more sinister in store at a later
date for the "vunerable" form addresses that get collected.

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

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

RE: CFIF inside a Form

[Everett, Al \(NIH/NIGMS\) [C]]

Is it possible there's a null value in that column? That would result in
an empty string for CF and "gt" would be an invalid operator.

 might be better.

-Original Message-
From: Donna French [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 10, 2006 5:02 PM
To: CF-Talk
Subject: CFIF inside a Form

I'm trying to use the following code inside a  tag that uses POST:


  

   


Is there a trick to doing this because I've written similar code without
problems. The error says:

An error occurred while evaluating the expression:

 price GT 0


I'm scoping the price variable and quad checked the name of the query.
What am I missing here??? 

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

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

RE: Storing hard coded data - advice?

[Everett, Al \(NIH/NIGMS\) [C]]

Simplest, to me anyway, would be a config.ini file with the data needed.
Second choice would be XML. Third choice a database table.

Option 3 really requires a front-end, as letting people directly edit in
the database gives me the heebie-jeebies. The other two, not so much,
although it's do-able.


-Original Message-
From: Peterson, Chris 
Sent: Thursday, August 10, 2006 3:25 PM
To: CF-Talk
Subject: Storing hard coded data - advice?

I have about 12 excel pages of GL Accounts that I have been asked to
build reports on. I have separate GL lists for 4 different companies,
and each company's data is grouped into categories (Fuel, Property
Taxes, Payroll, etc), and have a variable number of GL's per category.
Each account is designated as a Major (only match left 4 characters) or
Minor account (match all 6 characters).  The accountants are telling me
this data won't change often (at most they will add an account, or edit
once a year)

My question is, how would you store this information?  Would you just
make a SQL table to store it all, or perhaps a structure or array in a
config.cfm file that stores it all?  Create an XML file? Also, would you
bother putting a front end so the users can edit this, or just leave in
the DB to be edited by IT only? My source data is a mashup of several
iSeries/AS400 data tables.

I know several ways to do this, I am just looking for your thoughts or
idea's, maybe make this more painless down the road. =)

Chris Peterson
Gainey Corporation

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

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

RE: Development Environment Setup

[Everett, Al \(NIH/NIGMS\) [C]]

> Then your security team is full of idiots.

No comment.

I wish to remain gainfully employed so I just deal with it. I have
pointed out several times that this prevents from using some of the
power of source versioning, like branching, and interferes with unit
testing, among other issues.

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

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

RE: Development Environment Setup

[Everett, Al \(NIH/NIGMS\) [C]]

I'd love to do that, but we're not allowed to have "servers" installed on our 
desktop machines for "security reasons".

-Original Message-
From: Oðuz_Demirkapý 
Sent: Wednesday, August 09, 2006 2:37 PM
To: CF-Talk
Subject: RE: Development Environment Setup

Test Server <--->   SVN <---> Production Server

|   
|
Developers 

Test Server: Testing current status of code and deciding production version of 
code.

Production Server: Deploying tested code version from SVN reposity.

Developers: Every developer have their local CF installation and they 
chekin/checkout code from main SVN reposities.


This is what we have here. :)

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

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

RE: Scheduled tasks

[Everett, Al \(NIH/NIGMS\) [C]]

Here's the Google cache

http://216.239.51.104/search?q=cache:kC0aaNbiwDcJ:www.bpurcell.org/blog/
index.cfm%3Fmode%3Dentry%26entry%3D935+coldfusion+service+factory+schedu
led+tasks&hl=en&gl=us&ct=clnk&cd=1&lr=lang_en 


-Original Message-
From: Aaron Rouse
Sent: Wednesday, August 09, 2006 3:42 PM
To: CF-Talk
Subject: Re: Scheduled tasks

I could not get the linke to load and was curious what exactly it
covered?
Often had the needs here to be able to view what all tasks are and more
so to be able to maybe create them.

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

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

RE: Scheduled tasks

[Everett, Al \(NIH/NIGMS\) [C]]

> Is there a way to programmatically get data from currently defined
scheduled tasks without parsing the neo-cron.xml file?

Nevermind. I found an answer.

http://www.bpurcell.org/blog/index.cfm?mode=entry&entry=935

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

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

Scheduled tasks

[Everett, Al \(NIH/NIGMS\) [C]]

Is there a way to programmatically get data from currently defined
scheduled tasks without parsing the neo-cron.xml file?


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

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

RE: Sessions seem to go away for some (CFMX701-Linux)

[Everett, Al \(NIH/NIGMS\) [C]]

Wasn't this problem fixed in CFMX 7?

-Original Message-
From: Kris Jones 
Sent: Wednesday, August 09, 2006 7:57 AM
To: CF-Talk
Subject: Re: Sessions seem to go away for some (CFMX701-Linux)

If you use CFLOCATION on the same template after a CFCOOKIE set, the
cookie will not be set. I've also found this behavior to vary depending
on version of CF (works on 4.5, and 5, but not MX6 or MX7).

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

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

RE: Sessions seem to go away for some (CFMX701-Linux)

[Everett, Al \(NIH/NIGMS\) [C]]

I've seen something very similar that turned out to be an IE problem
with cookies. Can you check the version and even build number of the
browsers where this is happening? 

An option is to set your own cookie variable to use. An encrypted
cartID, for instance.


-Original Message-
From: mom outofchaos.com
Sent: Tuesday, August 08, 2006 9:40 PM
To: CF-Talk
Subject: Sessions seem to go away for some (CFMX701-Linux)

Howdy,

We are running a site on CFMX 7.0.1 on Linux, and encountering a very
strange problem. On one page, an add to cart page, we look for a
shopping cart based on the COOKIE.CFID and COOKIE.CFTOKEN values (for
the session). If we come up empty, we create a cart and insert it into
the DB. We then add an item to the cart (another insert into the DB),
and then CFLOCATION to a page, the view cart page, that looks for a cart
based on COOKIE.CFID and COOKIE.CFTOKEN by doing a select on the DB, and
creates a cart if it does not find one, and then displays the current
cart. The view cart page does this becuase pages on the site have a link
to view the cart, and so you might reach the view cart page without a
cart.

For most users, this works great. We create a cart, put it and the item
into the database, and then view this cart on the view cart page. But
for an unlucky few, a cart is created on the first page, and an item
loaded into it, and then a second cart is created with a different CFID
and CFTOKEN, on the view cart page, and so the user sees an empty cart.
It's like the original session disappears completely and a new session
is created. This frequently happens several times as the user valiantly
tries to put an item into their cart, but to no avail.

I tried setting a cookie on all of the pages that point to the add to
cart page, and then checking for the cookie on the add to cart page, to
rule out folks that are running without accepting cookies for the
session, but the problem persists.
I have not been able to reproduce the problem on my own browser, though
I can get a similar effect by dumping cookies and then blocking
acceptance.

I've used pretty much identical code on sites running on other versions
of ColdFusion, including MX6.1, this is my first MX7 site.

Any ideas? I'm stumped.

Thanks for reading.



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

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

RE: cfquery - single quotes become doubled

[Everett, Al \(NIH/NIGMS\) [C]]

That's by design. ColdFusion is escaping your single quotes.

You need to either wrap your string in the PreserveSingleQuotes()
function or, better, use  

-Original Message-
From: David Carter 
Sent: Monday, August 07, 2006 3:14 PM
To: CF-Talk
Subject: cfquery - single quotes become doubled

Hello all,

I am having a strange problem with a cfquery through SQL Server where I
am building the SQL statement dynamically from form input. I wonder if
anyone here has encountered and over come a similar error in the past,
and could lead me toward a solution.

When the SQL statement is placed into a  tag, the single quotes
which denote the string literal in the WHERE clause become doubled-up
and cause a syntax error.
Dumping the Variables scope gives the value of sql_stmt as:

SELECT user_id, user_name, name_first, name_last, ssn_encrypted FROM
tbl_user WHERE c_encrypted = 'KSNRUy1VUDcvIzI4PAo=' 
(the ending = is a part of the string literal)

Cutting and pasting this value directly into SQL Server's Query Analyzer
generates the single row which I am expecting.

In ColdFusion however, I get this:

Error Executing Database Query.  
[Macromedia][SQLServer JDBC Driver][SQLServer]Line 1: Incorrect syntax
near 'KSNRUy1VUDcvIzI4PAo'.

  
The error occurred in C:\Webs\user\find\search_results.cfm: line 37
 
35 : 

36 :
37 :#sql_stmt#
38 :
39 :
 



 
SQL
   SELECT user_id, user_name, name_first, name_last, c_encrypted FROM
tbl_user
   WHERE c_encrypted = ''KSNRUy1VUDcvIzI4PAo='' (notice the single
quotes are doubled)
DATASOURCE   base_db 
VENDORERRORCODE   170 
SQLSTATE   HY000 

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

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

RE: Numbers to Text

[Everett, Al \(NIH/NIGMS\) [C]]

> > Nice tag apart from it's gramatical problems...

Irony.


Has anyone already suggested the UDF at
http://www.cflib.org/udf.cfm?ID=40 ?

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

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

RE: Security Setup/Array Find

[Everett, Al \(NIH/NIGMS\) [C]]

I'd think a structure.







Abstract it into a function for better code re-use.


-Original Message-
From: David S. Neuman
Sent: Thursday, August 03, 2006 4:00 PM
To: CF-Talk
Subject: RE: Security Setup/Array Find

This question is an extension of the original question about the
security setup.

Is an array even the best way to go about this, or is there a better
way?  Our security setup gives users different permissions for different
parts of the site.  We broke down individual sections of the site into
assets, and for each asset the user gets a specific function.

User 1: Asset   Function
A   edit
B   delete
C   view

When the user comes to the page, we need to check to see if the asset is
there, and if so, the function the user has for that area.  What is the
best way to handle this?

Thanks

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

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

RE: 30 days from now date variable

[Everett, Al \(NIH/NIGMS\) [C]]

-Original Message-
From: Tim Laureska
Sent: Thursday, August 03, 2006 11:38 AM
To: CF-Talk
Subject: 30 days from now date variable

How do you set a variable to be 30 days from today?


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

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

RE: ColdFusion Tag and Attribute Case

[Everett, Al \(NIH/NIGMS\) [C]]

Me too. 


-Original Message-
From: Ken Ferguson 
Sent: Wednesday, August 02, 2006 11:26 AM
To: CF-Talk
Subject: RE: ColdFusion Tag and Attribute Case

As far as tags go, I am an all-lowercase type of guy. Functions and
variable names are where I use mixed-case, but tags are all lower for
me.

--Ferg

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

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

RE: Eclipse and CSS

[Everett, Al \(NIH/NIGMS\) [C]]

How about Aptana?

Someone blogged about it yesterday.
http://www.remotesynthesis.com/blog/index.cfm/2006/7/31/Aptana-EclipseBa
sed-Web-IDE


-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 02, 2006 11:12 AM
To: CF-Talk
Subject: OT: Eclipse and CSS

Now that I have Eclipse running with RDS, CFEclipse and Subversion I
need a plugin for CSS that will work with CFEclipse.

Any recommendations?

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

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

RE: file/directory chooser

[Everett, Al \(NIH/NIGMS\) [C]]

Wouldn't you just use CFTREE and CFDIRECTORY for that?

-Original Message-
From: Brian Dumbledore 
Sent: Wednesday, August 02, 2006 8:49 AM
To: CF-Talk
Subject: file/directory chooser

Can anyone point me to a tag to display "windows file/folder chooser"
type of directory browser? 

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

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

RE: Unofficial CF Developer Salary Survey

[Everett, Al \(NIH/NIGMS\) [C]]

Bonuses? Who gets bonuses?

I'd be happy getting an extra 40 hours PTO. 



-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 01, 2006 5:19 PM
To: CF-Talk
Subject: Re: Unofficial CF Developer Salary Survey

+ bonuses you could find yourself up at 100K USD.

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

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

RE: Advanced Developer Average Salary

[Everett, Al \(NIH/NIGMS\) [C]]

http://www.frappr.com/cfdevelopers 


-Original Message-
From: Dan Plesse 
Sent: Tuesday, August 01, 2006 12:13 PM
To: CF-Talk
Subject: Re: Advanced Developer Average Salary

It seems like a lot of employers are still very interested in the
location of CF developers. Is there a google map where you can plug in
your location for this very purpose? Would this help with the employment
matching process?

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

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

RE: Oracle 8.i and querying for table/field list

[Everett, Al \(NIH/NIGMS\) [C]]

It's guaranteed to bring back 0 records, giving you just the query
columns.

By the way, if that's your real username and password, you should
probably change them, because now the entire world knows it. 


-Original Message-
From: Terry C. Mergl [mailto:[EMAIL PROTECTED] 
Sent: Monday, July 31, 2006 11:08 AM
To: CF-Talk
Subject: RE: Oracle 8.i and querying for table/field list

 
James, not sure what to say but that did it.
It listed all of the tables and fiellds and fast also.
I appreciate it very very  much.

Terry
PS: Why WHERE 0=1 though?
-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED] 
Sent: Monday, July 31, 2006 10:59 AM
To: CF-Talk
Subject: Re: Oracle 8.i and querying for table/field list

Try this


   Select *  From #i#
   WHERE 0=1
   

Yes, I did type that correctly. The fieldnames should still be returned,
even though the recordcount is 0.


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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248241
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Random Characters

[Everett, Al \(NIH/NIGMS\) [C]]

I think you mean CAPTCHA.

If so, there have been a number of conversations about it on this list
in the last couple of weeks. A quick perusal of the archives should
help. 


-Original Message-
From: Steve LaBadie 
Sent: Friday, July 28, 2006 8:06 AM
To: CF-Talk
Subject: Random Characters

I am sure that we have all seen the random character generators at the
bottom of forms these days.  Is there a proper term associated with this
type of form and where can I go to learn how to make it?

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247989
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Event Scheduler question

[Everett, Al \(NIH/NIGMS\) [C]]

Change the end date to yesterday? 

Re-enable by changing the end date to NULL.


-Original Message-
From: kurt schroeder [mailto:[EMAIL PROTECTED] 
Sent: Thursday, July 27, 2006 3:28 PM
To: CF-Talk
Subject: Event Scheduler question

I sometimes have to take a scheduled task off line. I've tried setting
it to one time at a time eairlier that the current time, but this just
starts the task imediately. Is there a way to just aturn a task off
without deleting it?

THanks
KES



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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247917
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

[resolved] uploading large files

[Everett, Al \(NIH/NIGMS\) [C]]

It figures.

It appears that the root of the problem is Siteminder, which is used
here for authentication. Which is hosted on a completely different
server, in a completely different building, and managed by a completely
different group.

I suppose the first clue was when no errors appeared in the ColdFusion
logs or IIS logs.

The wheels of bureaucracy turn slowly, but it'll be managed. It's
completely out of my hands anyway.

Thanks all for your help.

-Original Message-
Searched houseoffusion.com and Google and wasn't able to find anything.
 
I'm working on a small intranet application that has a module where
users can upload files, generally PDFs.
 
Some of these PDFs can be quite large. In fact, on anything larger than
about 2.4MB, the web server throws a 500 error.
 
We're using a multipart form. This is a government installation, so
other options are limited. Third-party applets are right out. FTP is
almost certainly NOT an option (as if we could educate the users how to
use THAT).
 
It seems sure that the problem is with IIS, since it's throwing the
error, not ColdFusion. ("Then why are you posting here?" "Bear with
me.")
 
In a support call with Microsoft, our server guys were walked through
changing an ASP setting and were then able to upload a larger file via
an HTTP POST on an ASP page.
 
So, of course, the problem must now be ColdFusion. *sigh*
 
Servers are Win2K3 and IIS 6.0. As far as I know, no SPs have been
applied. CFMX 7.01.
 
I am SURE that at least a few of you on this list have encountered this
sort of thing before.
 
I've used HTTP POST to upload files larger than 2.5MB elsewhere, so I
don't know where this artificial limit is coming from. Everything works
fine for smaller files.
 
It does not appear to be a timeout issue, as the server comes back
instantly with the 500 error.
 
Any suggestions I should make to the server guys? Any options for code
that I can try? Any CF settings that I might be overlooking?

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

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247342
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: SOT: uploading large files

[Everett, Al \(NIH/NIGMS\) [C]]

My mistake. We're still on CFMX 7.0.

-Original Message-
From: Eric Haskins [mailto:[EMAIL PROTECTED] 
Sent: Friday, July 21, 2006 12:31 PM
To: CF-Talk
Subject: Re: SOT: uploading large files

We are Running 7.0.2 but have you checked under Server Settings ->
Settings there is a field for "Maximum Size of Post Data" by default it
is set to 500MB

Just a thought

~Eric



>
> I've used HTTP POST to upload files larger than 2.5MB elsewhere, so I 
> don't know where this artificial limit is coming from. Everything 
> works fine for smaller files.
>
> It does not appear to be a timeout issue, as the server comes back 
> instantly with the 500 error.
>
> Any suggestions I should make to the server guys? Any options for code

> that I can try? Any CF settings that I might be overlooking?
>

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

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247318
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

SOT: uploading large files

[Everett, Al \(NIH/NIGMS\) [C]]

Searched houseoffusion.com and Google and wasn't able to find anything.
 
I'm working on a small intranet application that has a module where
users can upload files, generally PDFs.
 
Some of these PDFs can be quite large. In fact, on anything larger than
about 2.4MB, the web server throws a 500 error.
 
We're using a multipart form. This is a government installation, so
other options are limited. Third-party applets are right out. FTP is
almost certainly NOT an option (as if we could educate the users how to
use THAT).
 
It seems sure that the problem is with IIS, since it's throwing the
error, not ColdFusion. ("Then why are you posting here?" "Bear with
me.")
 
In a support call with Microsoft, our server guys were walked through
changing an ASP setting and were then able to upload a larger file via
an HTTP POST on an ASP page.
 
So, of course, the problem must now be ColdFusion. *sigh*
 
Servers are Win2K3 and IIS 6.0. As far as I know, no SPs have been
applied. CFMX 7.01.
 
I am SURE that at least a few of you on this list have encountered this
sort of thing before.
 
I've used HTTP POST to upload files larger than 2.5MB elsewhere, so I
don't know where this artificial limit is coming from. Everything works
fine for smaller files.
 
It does not appear to be a timeout issue, as the server comes back
instantly with the 500 error.
 
Any suggestions I should make to the server guys? Any options for code
that I can try? Any CF settings that I might be overlooking?


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

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247308
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Creating a watermark for CFDOCUMENT

[Everett, Al \(NIH/NIGMS\) [C]]

No dice. I tried with the doctype and html element outside CFDOCUMENT
and inside. I even popped a  before it to make
sure my framework code wasn't enforcing a layout on it. Still nothing.
Viewing the output as HTML my background image is there, but CFDOCUMENT
refuses to use it.

I'm giving up. The client will have to be satisfied with the word
"DRAFT" in text at the bottom of every page. I have too many other
defects I need to be working on.

Thanks all for your help.

-Original Message-
From: Sandra Clark [mailto:[EMAIL PROTECTED] 
Sent: Thursday, July 13, 2006 5:51 PM
To: CF-Talk
Subject: RE: Creating a watermark for CFDOCUMENT

I got something working with the following code, the information shows
up in the PDF.  Media style will mean nothing to PDF, it can only print
what it shows.  Notice that the cfdocument must surround both the 
and  tags.  It won't work if you just surround the body or the
information within the body.  (In other words, you must use proper
markup (style belongs in the
) and send all of that to the pdf.


http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd";>

http://www.w3.org/1999/xhtml"; xml:lang="en" lang="en">






body{
background-image: url(hdr_right.jpg);
background-position: top right;
background-repeat: no-repeat;
height: 11in;
width: 8.5in;
padding: .5in;

}



 This is a test



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

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246533
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Creating a watermark for CFDOCUMENT

[Everett, Al \(NIH/NIGMS\) [C]]

Hmmm...I didn't include all of the HTML elements. I'll try that. 


-Original Message-
From: Sandra Clark [mailto:[EMAIL PROTECTED] 
Sent: Thursday, July 13, 2006 5:51 PM
To: CF-Talk
Subject: RE: Creating a watermark for CFDOCUMENT

I got something working with the following code, the information shows
up in the PDF.  Media style will mean nothing to PDF, it can only print
what it shows.  Notice that the cfdocument must surround both the 
and  tags.  It won't work if you just surround the body or the
information within the body.  (In other words, you must use proper
markup (style belongs in the
) and send all of that to the pdf.


http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd";>

http://www.w3.org/1999/xhtml"; xml:lang="en" lang="en">






body{
background-image: url(hdr_right.jpg);
background-position: top right;
background-repeat: no-repeat;
height: 11in;
width: 8.5in;
padding: .5in;

}



 This is a test



Sandra Clark

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

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246525
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Creating a watermark for CFDOCUMENT

[Everett, Al \(NIH/NIGMS\) [C]]

No, no change.

Here's the code I have:




body {

background-image:url(#request.baseURL#images/draft-watermark.gif);
background-position:center;
}



I've tried with 'media="print"' and without. I've tried the style tags
before and after . I am sure that the image file exists
where I say it does. I've tried attaching the image to html and table as
well as body. All give the same result.

I tried changing my browser settings to display background images when
printing. Still nothing.

If I comment out all of the  and child tags, the HTML I get
has a background image.

I'm stumped. 


-Original Message-
From: Qasim Rasheed [mailto:[EMAIL PROTECTED] 
Sent: Thursday, July 13, 2006 5:14 PM
To: CF-Talk
Subject: Re: Creating a watermark for CFDOCUMENT

I think technically those are related. CFDocument uses the styles that
you have defined for printing and take advantage of your printing
preferences.
FWIW.


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

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246472
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Creating a watermark for CFDOCUMENT

[Everett, Al \(NIH/NIGMS\) [C]]

Okay. Got any code to share? I mean, it seems straightforward enough to
me, so I don't see why it's not working.

-Original Message-
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 12, 2006 11:07 PM
To: CF-Talk
Subject: Re: Creating a watermark for CFDOCUMENT

I've done this with CSS and a background image.

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

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246402
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Creating a watermark for CFDOCUMENT

[Everett, Al \(NIH/NIGMS\) [C]]

That shouldn't have anything to do with it, as it's a PDF document.

-Original Message-
From: Qasim Rasheed [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 12, 2006 10:06 PM
To: CF-Talk
Subject: Re: Creating a watermark for CFDOCUMENT

I can be way off but have you tried setting up in printing prerference
of your browser to print backgrond images.

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

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246401
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Creating a watermark for CFDOCUMENT

[Everett, Al \(NIH/NIGMS\) [C]]

I have a report I am creating with CFDOCUMENT. (CFREPORT would have been
better, but this report has a lot of extra logic in it that CFREPORT
wasn't going to allow me to do, but that's beside the point.)
 
What I want is to have a watermark on the document if the user creates
it with the "draft" option, but not if the user selects "final".
 
The in the CFREPORT tag, "backgroundvisible" is set to "yes".
 
However, when creating the document, my image never shows up. I've tried
putting a background image on the html table and tried making it the
background of my page body. If I look at the report as HTML it's fine,
but with the CFREPORT tag the background is not displaying.
 
I am using PDF format.
 
Any clues?


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

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246255
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4