-Original Message-
From: Ryan Guill [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 01, 2005 6:19 PM
To: CF-Talk
Subject: Re: COAL- the Coldfusion Open Application Library
Hey guys, sorry to keep resurecting this thread, but wanted some
input. I have had a lot of people that
Hi, been playing around with CFC's and fusebox4.1 for a bit, nothing too
advanced. In the main part I use CFC's to do all of my database work, they
contain all of my calls to the database using stored procedures. My question is
what is the best amd most efficient way to execute them? At the
WHERE (ClientName ='a' AND ClientName 'c')
OR (ClientName ='A' AND ClientName 'C')
--
Serg
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on
oops, misprint :)
WHERE (ClientName ='a' AND ClientName 'e')
OR (ClientName ='A' AND ClientName 'E')
--
Serg
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
On 9/1/05, Barney Boisvert [EMAIL PROTECTED] wrote:
LIKE doesn't support regular expressions. You'd have to do cn LIKE
'a%' OR cn LIKE 'b%' However, definitely check your DB's
documentation to see if there is a regular expression operator. MySQL
has REGEX, for example, which is the same
Sorry, I am totally new to this tag and this function (had a tag that worked
perfectly well in CF 5 but freezes each time in MX6.1).
According to your thinking, do I need to query Active Directory in order to get
the group's and then add? Do I need to add code to the dn and attributes
I'm trying to make a data import script that I am writing more
efficient be combining 2 query of queries (from 2 separate queries)
into one. Unfortunately, I can't get it to work. Does query of
queries in MX7 support subqueries (AKA subselects)?
Thanks
Pete
Well there were two issues that came up after I had a series of
materialized views in production.
During a refresh the table is actually empty. Meaning if you did a
select against the table, you got 0 rows returned. Some of my views
took a substantial amount of time to refresh (querying 500k+ of
Well we usually use
cfinvoke object=application.myCFC method=myMethod
returnVariable=variables.myvar argument1=value argument2=some other
value /
Or the proper way to do it
cfinvoke object=application.myCFC method=myMethod
returnvariable=variables.myvar
cfinvokeparam name=argument1
First, you need the new user's DN which would look like:
CN=MikeDawson,OU=Employees,DC=evansville,DC=edu
You can get the user's DN from an LDAP query.
Then, you need the group's DN which would look like:
CN=MyGroup,OU=Groups,DC=evansville,DC=edu
You also need to get the group's current
Well, except that RDS only has a single user... Well not even a user, just a
password, which is the same for every user. And doesn't RDS allow access to
the entire file system as well?
These questions are likely version dependent...
- Calvin
-Original Message-
From: Dave Watts
Hi, all...
I'm testing Dreamweaver MX 2004 and have been attempting
to use an Efflare tag I purchased a couple of years ago, the CFX_JPG tag,
in the tests.
Everything looks good and behaves normally, but the images
don't show up in the browser. When I right-click the image and select
Properties
Well, except that RDS only has a single user... Well not even
a user, just a password, which is the same for every user.
Yeah, that was a giant step backwards for CFMX, although I don't think too
many people used CF 4/5's Advanced Security functionality to control RDS
access.
And doesn't RDS
There are some new things in cfform for the updater.
- onLoad
- onBlur, onFocus
- cfformitem type=script
However, the 64k and the 32k limits are hard limits inside the .swf
compiler. This means for now we can't fix these without rewriting the
swf compiler. However,
-Original Message-
From: Ryan Guill [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 01, 2005 6:19 PM
To: CF-Talk
Subject: Re: COAL- the Coldfusion Open Application
Library
Hey guys, sorry to keep resurecting this thread, but
wanted some input. I have had a lot of people that
On Friday 02 September 2005 15:25, Dave Watts wrote:
And doesn't RDS allow access to the entire file system as well?
By default, yes, unless you limit the rights of the user account running CF
- which is a very good idea even if you're not using RDS.
Which just emphasis why RDS shouldn't be
I can't say that I've ever had to try a sub-select in a QoQ but I have used
this for combining queries and works well.
http://www.cflib.org/udf.cfm?ID=1021
-Original Message-
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]
Sent: Friday, September 02, 2005 9:48 AM
To: CF-Talk
Subject:
Which just emphasis why RDS shouldn't be used - not secure by
default.
By that criterion, what could you use? Very few things are truly secure by
default. CF isn't. Web servers aren't. This is why systems administrators
get paid more than, say, gas station attendants.
Dave Watts, CTO, Fig
I'd recommend contributing it to the Salvation Army instead tho... see
Dana's comments about her flood experience.
That's extremely generous of you and I'm sure every little
bit will help.
s. isaac dealey 954.522.6080
new epoch : isn't it time for a change?
add features without fixtures
Alright, sounds good. So what type of security are we talking about?
Things like authentication and login models? Or are we talking more
like encryption?
Sorry, but I havent really had a chance to check out those libraries yet.
--
Ryan Guill
BlueEyesDevelopment
[EMAIL PROTECTED]
On Friday 02 September 2005 16:11, Dave Watts wrote:
By that criterion, what could you use? Very few things are truly secure by
default. CF isn't. Web servers aren't.
Web servers don't let you change any file on the file system from anywhere in
the world. Certainly Apache doesn't in it's
I think that's pretty significant, but that's just my take.
The single user thing is a huge deal. And even limiting access on the file
system to just the web directories, means that everyone who uses that
account has access to everyone else's files.
What I'd like to see is the database and
Which just emphasis why RDS shouldn't be used
- not secure by default.
By that criterion, what could you use? Very few
things are truly secure by default. CF isn't.
Web servers aren't. This is why systems
administrators get paid more than, say, gas
station attendants.
Yeah, gas stations
Hey All,
We are trying to change the tab colors in cfform and can't seem to do it? Is
this a bug. We tried using the fill-colors style on TabNavigator and on
Page. Any Help would be great thanks!
Aqil
~|
Logware
-Original Message-
From: Calvin Ward [mailto:[EMAIL PROTECTED]
What I'd like to see is the database and component
functionality placed in a fashion that no longer requires RDS
and can be secured by other more granular methods of access
control,
Personally I think CFMX7's
Sorry about that everyone. (please no tar and feathers...)
Our mail admin turned on the reply to sender rule when our spam filter
detected we were getting spammed and unfortunately CF-Talk emails got caught in
that mess. He's turned off that rule.
BTW - anyone have recommendations for
I believe GFI MailEssentials for Exchange uses SpamAssasin internally
(although I believe most solutions do this). You can also set up a linux
box in front of the exchange that runs spamassasin on it (and certain rules
for sendmail that don't accept mail from known spammers), and then forward
GFI is pretty good if you have someone to really spend time managing it.
When I was on Exchange, I was using it and I liked it just enough to
stop looking around for a replacement. The unfortunate truth seems to be
that spam filtering is *almost* purely reactive. You put something in
place and
Dustin,
First of all I never said you were cheap. I just noted that I was not.
Secondly, your overly dramatic question was preceded by a dirge of
complaints. The subject line misrepresents the cost of ColdFusion. You
are comparing the pro version against the enterprise version. I think
my flip
I'm all for building apps as infrastructure neutral as possible, I'm
sorry, this is pretty stupid. If you're going to pick the lowest
common denominator from ALL DB platforms (or even all common ones),
you're going to be hurting. Unless you're building an app for
distribution that has to run on
Thank you for confirming that Im not quite completely crazy yet ;)
This isnt the first error I have found in this book... Im almost
thinking of not recommending it to anyone anymore.
Ryan Guill
BlueEyesDevelopment
[EMAIL PROTECTED]
www.ryanguill.com
(270) 217.2399
The Coldfusion Open
That'd be nice, but it's not listed in the feature list on macromedia's
site.
I suppose we could just emulate the functionality and figure out an
extension to dreamweaver to integrated it...
-Original Message-
From: Damien McKenna [mailto:[EMAIL PROTECTED]
Sent: Friday, September 02,
Hi all
it's possible to convert DOC and XLS files to PDF using CF MX? Aaron
Johnson talks about Jakarta Project and POI to do that. Anyone have
experience about?
Cheers
MD
~|
Discover CFTicket - The leading ColdFusion Help
I didn't say FTP was any better. More secure in that you can have
per-user credentials, but as you say, it's a major PITA to set up
correctly. FTP over SSH, however, alleviates a lot of the problems,
adds transport security, and doesn't diminish the capabilities in any
way. My fav, though, is
Personally I think CFMX7's administration tags are a step
towards remote management without using RDS, I wouldn't be
surprised if the new Dreamweaver 8 included features for this.
I could be wrong, but I don't think they give you a way to interact with the
filesystem or with datasources, as
Alright, sounds good. So what type of security are we
talking about?
Things like authentication and login models? Or are we
talking more
like encryption?
Sorry, but I havent really had a chance to check out those
libraries yet.
login model / user authentication -- roles and permissions
By that criterion, what could you use? Very few things are
truly secure by default. CF isn't. Web servers aren't.
Web servers don't let you change any file on the file system
from anywhere in the world. Certainly Apache doesn't in it's
default configuration. Can't speak for IIS,
We use GFI Mail Essentials. It's alright, but it never really learns
my valid messages. Most spam does get sent to the junk folder.
M!ke
-Original Message-
From: Robert Redpath [mailto:[EMAIL PROTECTED]
Sent: Friday, September 02, 2005 10:45 AM
To: CF-Talk
Subject: Re: who on this
Also don't forget to var all your variables in the cfc... Since it's cached,
the variables are shared throughout the cfc, and a lot of weird stuff will
start to happen if you use the same variable in multiple places (or even in
the same method probably) under more then a light load.
So if you
I'm having the following problem:
Running on Windows 2003 SP1
Upgraded to CFMX 7 from CFMX 6.1
Applied Cumulative Hotfix 3
Rebooted / Restarted
Now, my scheduled tasks get reset to 00:00:00 at midnight each night. I have
to manually go in and reset them each morning. This was a problem in 6.1
In this issue of ColdFusion conference and training news:
1. Fusebox and Frameworks Conference News - topic survey due TODAY 8/31/05
2. Advanced SQL Server class planned
3. Fusedocs for Better Code interview with Hal Helms
Happy coding
- Michael Smith,
TeraTech, Inc http://www.teratech.com/
http://news.yahoo.com/news?tmpl=storyu=/ap/20050828/ap_on_re_us/soldier_funeral_protests
And a discussion thread on it at another site.
http://msgboard.snopes.com/message/ultimatebb.php?/ubb/get_topic/f/67/t/001879/p/1.html
~|
I assume you meant to send that to community, right man?
-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: Friday, September 02, 2005 1:48 PM
To: CF-Talk
Subject: This just seems to fit todays theme.
Oops, that is what I get for using a different e-mail client. I sent this to
the wrong list. If one is interested please follow up on cf-communtiy.
--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
C code. C code run. Run code run. Please!
- Cynthia
Embarrassed to ask, but can't figure it out:
Trying to insert a number such as 2.65 into a MSSql server db using
this:
Form: INPUT TYPE=TEXT NAME=current_price SIZE=10 value=
Insert attempt:
cfqueryparam cfsqltype=CF_SQL_numeric value=#form.current_price#
but no matter what data type I seem
What's the datatype of your column in the DB? Is it integral? If
it's DECIMAL, how many spaces are allocated for fractional amounts?
cheers,
barneyb
On 9/2/05, Tim Laureska [EMAIL PROTECTED] wrote:
Embarrassed to ask, but can't figure it out:
Trying to insert a number such as 2.65 into a
From: Tim Laureska [mailto:[EMAIL PROTECTED]
Insert attempt:
cfqueryparam cfsqltype=CF_SQL_numeric value=#form.current_price#
cfqueryparam cfsqltype=CF_SQL_DECIMAL value=#form.current_price#
~|
Logware (www.logware.us): a
From: Tim Laureska [mailto:[EMAIL PROTECTED]
Insert attempt:
cfqueryparam cfsqltype=CF_SQL_numeric value=#form.current_price#
Actually, I spoke too soon. Is the data type MONEY? If so, use MONEY in
the queryparam.
~|
Find
there is also a float.
On 9/2/05, Tangorre, Michael [EMAIL PROTECTED] wrote:
From: Tim Laureska [mailto:[EMAIL PROTECTED]
Insert attempt:
cfqueryparam cfsqltype=CF_SQL_numeric value=#form.current_price#
Actually, I spoke too soon. Is the data type MONEY? If so, use MONEY in
the
What should it be for dollars?... int or what?
I changed the queryparam to : CF_SQL_DECIMAL
And currently have the field type as INT but that combination doesn't
cut it either
-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Friday, September 02, 2005 2:01 PM
Ah... the money/money combination worked (queryparam/fieldtype) -
thanks Ryan !
-Original Message-
From: Ryan Guill [mailto:[EMAIL PROTECTED]
Sent: Friday, September 02, 2005 2:11 PM
To: CF-Talk
Subject: Re: numbers with decimal places to the right
there is also a float.
On 9/2/05,
all I can say is... with what is going on elsewhere, this is what they find
to do? My sweet Lord. It takes chutzpah to call yourself a Christian in the
circumstances.
Dana
On 9/2/05, Ian Skinner [EMAIL PROTECTED] wrote:
INT says you want integers: whole numbers without decimal parts. You
should change the column to be MONEY, which will allow for fractional
amounts (cents).
cheers,
barneyb
On 9/2/05, Tim Laureska [EMAIL PROTECTED] wrote:
What should it be for dollars?... int or what?
I changed the
Hey guys,
In the fusebox 4.1 corefiles, it has the cfapplication tag in the
index.cfm file.
Does anyone know if there is a reason for this, instead of it being in
the application.cfm file? It is causing a little trouble for me
althought I have found a way around it. Just curiosity more than
Personally I think CFMX7's administration tags are a step
towards remote management without using RDS, I wouldn't
be
surprised if the new Dreamweaver 8 included features for
this.
I could be wrong, but I don't think they give you a way to
interact with the
filesystem or with datasources,
index.cfm isn't technically a Fusebox core file, only the four files
starting with 'fusebox' and the two starting with 'udf_' are part of
the actual core. The sample app that is shipped with the cores is as
minimal as possible, and therefore has everything inside index.cfm.
There's no other
alright, well im using fusebox410.corefiles.cfmx.zip to get the
corefiles so thats why I assumed that the files included were part of
the corefiles.
But thats what I had assumed, that it really didnt matter.
Thanks,
--
Ryan Guill
BlueEyesDevelopment
[EMAIL PROTECTED]
www.ryanguill.com
(270)
Sorry, I know this is OT, but I had to say something. These people aren't
Christians, but actually a sect. They are not part of any major denomination,
even though they use the name Baptist in their church.
http://en.wikipedia.org/wiki/Westboro_Baptist_Church_(Topeka)
The church is held in
If you wanted a true decimal field (not money) then you would specify column
type like this:
DECIMAL(5,3)
Where 5 is how many total digits you want (excluding the decimal) and 3 is how
many digits you want to the RIGHT of the decimal.
Dave
-Original Message-
From: Barney Boisvert
OK... good to know
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, September 02, 2005 3:04 PM
To: CF-Talk
Subject: RE: numbers with decimal places to the right
If you wanted a true decimal field (not money) then you would specify
column type like this:
What about locking ?
-
snake
-Original Message-
From: Russ [mailto:[EMAIL PROTECTED]
Sent: 02 September 2005 14:59
To: CF-Talk
Subject: RE: CFC's - Most efficient scope?
Well we usually use
cfinvoke object=application.myCFC method=myMethod
returnVariable=variables.myvar
You only need to lock to prevent race conditions. Since
application-scoped CFCs should nearly always be stateless (they have
no instance data, or the instance data does not change once the
component is initialized), locking isn't an issue.
On 9/2/05, Snake [EMAIL PROTECTED] wrote:
What about
Anyone installed the payflow pro CustomTag from verisign on a CF7 JRun
mutli-instance installation.
for thelife of me i can't get it to work and the directions they provide
only talk about standalone.
I've added the Classpaths for Java VM in the settings section of my cfusion
server and i've
This is not always the case. Sometimes CFCs are placed in the application
scope with state that changes all the time. The CFC could be a very busy
manager, and not just a stateless utility or something. It might be in the
application scope because you only want one, and no more.
On 9/2/05,
Here's a program that does it:
http://www.convertzone.com/doc2pdf/help.htm
I've not used, it, just googled for it.
You can call it with command line arguments with CFEXECUTE.
Dave
-Original Message-
From: Michel Deloux [mailto:[EMAIL PROTECTED]
Sent: Friday, September 02, 2005 12:23
Why did you change this to Red Cross? I'm not interested in donating to a now
political organization. I recommend Salvation Army or United Way.
Dave
-Original Message-
From: Jake . [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 01, 2005 5:20 PM
To: CF-Talk
Subject: OT: Katrina
I developed a flash form and tested it locally and on the server, it worked
perfectly when I tested it. However, when I asked my friends to test the same
page on the server, they got following error:
--
Could not find the ColdFusion Component indexquery.
Please
Is this what you want?
http://www.printeccom.com.br/int.cfm?acao=longe_tema
If so, what i did was to set the theme-color at accordin page that
contains my tabnavigator, so I guess that it would work if you do the
same with a hbox or any other container.
Felipe
On 9/2/05, Aqil Mansuri [EMAIL
That's why I said nearly always. If you do end up needing an
application-scoped CFC that changes state, and if race conditions are
a concern, then you need to lock the writes to the instance data of
the CFC.
On 9/2/05, Paul Kenney [EMAIL PROTECTED] wrote:
This is not always the case. Sometimes
I agree, I was interested but due to my experience with the Red Cross as a
flood victim I will NEVER contribute to the Red Cross.
On 9/2/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Why did you change this to Red Cross? I'm not interested in donating to a
now political organization. I
Sorry. You did say that, and I missed it. You are right.
On 9/2/05, Brian Kotek [EMAIL PROTECTED] wrote:
That's why I said nearly always. If you do end up needing an
application-scoped CFC that changes state, and if race conditions are
a concern, then you need to lock the writes to the
But either way you have to understand that simply using a variable without
VARing it, will cause race conditions. This was a problem with our
application a few months back and took me a while to diagnose, until I
realized that all our cfquery name's were named qry and that there was no
cfset var
On 9/1/05, Bryan Stevenson [EMAIL PROTECTED] wrote:
Not to lessen this effort in anyway as I hope it will truly help people
outbut I just saw a news story that showed not only displaced people
looting a Wal-Martbut the local cops were in there doing the same damn
thing!!
Looting
No worries Paul, it's a valid thing to point out.
On 9/2/05, Paul Kenney [EMAIL PROTECTED] wrote:
Sorry. You did say that, and I missed it. You are right.
On 9/2/05, Brian Kotek [EMAIL PROTECTED] wrote:
That's why I said nearly always. If you do end up needing an
application-scoped CFC
You're right, Russ. And how best to ensure this is an ongoing debate.
Some people (myself included) like to put a cfset var local =
structNew() / at the top of methods that will have local variables.
Then, all queries and index loops and other local vars are set as keys
in this struct ie cfset
WIth MX 7 you can do this pretty easily by converting the word file to HTML
(through COM) then using cfdoc to put it into PDF
Adam H
On 9/2/05, Michel Deloux [EMAIL PROTECTED] wrote:
Hi all
it's possible to convert DOC and XLS files to PDF using CF MX? Aaron
Johnson talks about Jakarta
I'm all for building apps as infrastructure neutral as
possible, I'm sorry, this is pretty stupid. If you're
going to pick the lowest common denominator from ALL
DB platforms (or even all common ones), you're going
to be hurting. Unless you're building an app for
distribution that has to
Sorry, but I havent really had a chance to check
out those libraries yet.
Was this comment specifically about my framework?
If so don't sweat it. Everybody's busy, I understand. :)
s. isaac dealey 954.522.6080
new epoch : isn't it time for a change?
add features without fixtures with
-Original Message-
From: Ryan Guill [mailto:[EMAIL PROTECTED]
Sent: Friday, September 02, 2005 11:11 AM
To: CF-Talk
Subject: Re: COAL- the Coldfusion Open Application Library
Alright, sounds good. So what type of security are we talking about?
Things like authentication and login
I could be going crazy, but I could swear I remembered reading that
someone had broken the black-magic code that would allow you to get
the value of getCurrentTemplatePath() from the calling template within
a custom tag...
This just became important at my day job actually ... we (or my boss
All I could find was 3/4 down the page...under new functions...never used it
though
http://www.macromedia.com/v1/documents/cf4/allaire_support/cf4doc_update.cfm
GetCurrentTemplatePath returns the fully specified path of the template
containing this function, regardless of whether it's a
Is it sending back the base template path instead of the current template
path of code provided?
- Original Message -
From: Matthew Blatchley [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Friday, September 02, 2005 11:16 PM
Subject: Re: getCallingTemplatePath()
All I
I've made a significant update to my debugging library available here:
http://www.depressedpress.com/depressedpress/Content/Development/JavaScript/
Extensions/DP_Debug/Index.cfm
This version's new features:
+) Several people requested the ability to dump system objects (document,
window, style,
Hi Richard,
I'm looking to expand my business and would like to hire an employee. At the
present moment I would imagine there would be only about 20 hours or so a
week.
Are you sure you want to employ someone or do you need to engage the
services of a contractor? Employing someone is a
84 matches
Mail list logo