For one reason or another, I've ended up the proud owner of
some 500
undelivered cfmail files, which I need to deliver to the intended
recipient.
Here is a nice little mail spooler that runs off a scheduled task.
It's worth a look if you often end up with .undeliv due to email
RewriteRule ^/(.*) /my/landingpage.cfm
[E=MY_REQUEST_URI:%{REQUEST_URI},QSA,PT]
Now I can access #CGI.MY_REQUEST_URI# to retrieve the
original URI without worrying about what ColdFusion provides.
More testing will be done, but it looks pretty solid as far
as I can tell.
Nice tip
I was wondering which one are best practices when doing a db
insert/update:
cfqueryparam value=#lfield# cfsqltype=CF_SQL_INTEGER
null=#iif((filed eq ), de(yes), de(no))# /,
or
cfif val (field) gt 0)
cfqueryparam value=#lfield#
cfsqltype=CF_SQL_INTEGER / cfelse
null
Cfqueryparam allows to to specify that NULL values are
allowed anyway, so you don't need to do that check.
Can you explain what you mean? ColdFusion has no concept of null. The
NULL attribute, if set to 'YES' means that CFQUERYPARAM ignores the
value in the VALUE attribute and passed the
Hi, is it possible in the cf java tree for the cursor to
change into a hand icon when it is placed over a node that is
hyperlinked?
Pretty sure this isn't possible.
This was one of a set of related issues that made one of our clients ask
for a replacement for CFTREE (ended up using one of
computers, and i dont really see the point of having a java
applet just for a tree, can you recommend a javascript one
that you found?
There are plenty these days. The one I built was around 12 months ago
and customised one of the oldie scripts (see below for more recent
ones):
Hi,
Was just wondering if there was anyway to create a Working Set in
CFEclipse containing a subset of the main project files, and then export
only those files within the Working set to the File System. Every time
I do it with the Export wizard, it ignores the Working Set and exports
the whole
The two cfeclipse mailing lists are:
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Thanks Mark.
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers,
to my code and it is not refelcted for several mintues. I can
tell this because I get an error code on the page that
reflects the old settings of the page and will keep a time
stamp of generally for to five minutes in the past instead of
reflecting the change. I've tried the obvious
Our credit card gateway provider renewed their SSL
certificate, and now our CFHTTP call to the https:// address
simply spits back a connection failure message. I googled
for this, but didn't get any useful information. We're using
mx6.1... does anyone have any ideas?
Have you tried
Thanks for the help. I did have that checked. I am still
experiencing a delay of a few minutes but that might help
diminish the problem.
No probs, I often get it even with this checkbox unchecked.
Guess something weird happens with the file timestamp and I usually get
by it adding a
Have you tried imported their new SSL certificate into the Jrun
keystore?
Nope! Never knew that was needed, nor do I know how. Got a
link for me?
Here is the link:
http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_19139#enableC
F
It's for LDAP but the section I linked to has
Thanks. I do plan on trying this. But a question that's
bugging the hell out of me is... I didn't have to do this
before - we just used CFHTTP with an https site, and it just
worked. Why now does it not?
The keystore comes prepopulated with certificates from industry trusted
CA's
I then used the keytool and saved both the certificate and
the intermediate certificate. Bounced the CF server, still no joy.
Very frustrating, I am still at square one.
I've been round this kind of merry-go-round before...
In the past we (and when I say 'we', I really mean the
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.
Grasping at straws, but could it be something to do with where his
Company IT
Subject: Can 6.1 and 7.0.2 co-exist?
J2EE install and multiple instances.
http://www.adobe.com/devnet/coldfusion/articles/multi_instances.html
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
Can anyone tell me of a way to generate thumbnails of web
pages from ColdFusion? A co-worker is asking for a personal
project he is working on (so I'm guessing that he is looking
for a no/low cost solution).
Colleague passed me this link for javascript version of what I think you
are
I have pdf files in a directory that CF reads using
cfdirectory. It finds the filename under the user's name such
as jsmith.pdf, but at times a user may have two pdf files
in the directory such as jsmith.pdf and jsmith2.pdf.
How can I have it find both instances? Can I use a wildcard
No, I don't think that you're missing anything. I was
thinking of includes and application variables and hadn't
used cfFile in quite a while so I didn't think of it.
Is there any reason why I shouldn't just write out a .cfm so
that I can easily include it and that can designate multiple
I have seen in a number of examples the following:
cfset variables.myVar = arguments.someArg / any particular
reason/advantage why the arguments are assigned to a local
variable inside a cfc function instead of using it directly?
To make it persistant in the lifetime of the CFC
See Ray
Sorry for the off topic, but I cant find an answer so far.
Can Apache's log files pick up the users screen resolution?
Can any web servers's log files?
Or is this something you need to add yourself to track?
No, it's client side information.
You could code some javascript that fired on
Yes, they can, using the js file provided with urchin (and
probably google analytics). Urchin has js that forces a
download of a gif to which it appends the screen resolution
among other things.
Hahah splitting hairs here but that is just Javascript trickery using a
gif file that will
An exception occurred when performing the FTP getfile operation.
The cause of this exception was that: IOException caught
while copying..
Rather than cffile, do you mean cfftp?
~|
Introducing the Fusion Authority
An exception occurred when performing the FTP getfile operation.
The cause of this exception was that: IOException caught while
copying..
Rather than cffile, do you mean cfftp?
This may help
http://www.mail-archive.com/list@list.dfwcfug.org/msg00225.html
I have a directory without an application file where there is
a form to register for an event. I have a directory within
that that has an application file and that's set up to keep
out people that aren't logged in because it contains all the
reports or other interactions with the
An exception occurred when performing the FTP getfile operation.
The cause of this exception was that: IOException caught while
copying..
Rather than cffile, do you mean cfftp?
This may help
http://www.mail-archive.com/list@list.dfwcfug.org/msg00225.html
Yeah, I
I am tiring to update multiple records with different values.
I am getting the following error
Error Executing Database Query.
Syntax error (missing operator) in query expression
'fld_item_ID = 'evaluate(1235,1237,1236,1236 1)' update
tbl_865_orders_items set fld_qty_shipped =
I'm pretty suprised no one's mentioned Ant and the many, many tools
around it for the deployment side of things. Regardless of the SCC
system, Ant is a nobrainer for automating deployment,
.
Thirty minutes of time just saved hours of hunting down problems.
As an aside, I'll be
Outside shot, try wrapping in cfoutput (anywhere you can, especially if
using cfxml)... Caught me a few times when enablecfoutputonly is set to
yes so you end up trying to parse an empty string
--
dc
~|
Logware
Category Path: Sports - Hockey - Teams - Buffalo Sabres
You want to find anything that is a member of the hockey
category and any sub category within.
Really busy but recommend googling (and the HoF archives) on Joe Celko ,
he seems to be the master of the parent-child tree in SQL :)
Hidden form field... Get it in next submission...
Alternatively... Have the text in CF before it and use the var in the
javascript.
cfscript
cfset didit = Are you sure you want to delete? / /cfscript
script type=text/javascript
var doit = confirm('#JSStringFormat(didit)#');
/script
his CF log folder from his server, now is there an easier way to parse
through the files to see where the errors are occurring than just
opening them up in Notepad?
If you use eclipse you could use the log file watcher that has been
suggested by someone else and I bookmarked (altho as usual
If you use eclipse you could use the log file watcher that has been
suggested by someone else and I bookmarked (altho as usual
I haven't
used it much yet but it is working in my 3.1 Eclipse).
That's a really cool tool and I've added it to the list of
things to install for Eclipse;
Mike Nimer has build a CF Log Tail plugin for Eclipse which
is pretty cool...
http://www.mikenimer.com/eclipse/logviewer/index.cfm
Cheers jedihomer... Might go and have to get that one too :)
--
dc
~|
Find out how
You guys know of any good tools which has a color spy and
also shows similar - related colors (colors that go well with
the color you spied)? Free would be best..
One I used and a decent article for the color-ly challenged.
http://www.ficml.org/jemimap/style/color/wheel.html
I'd say that's a slightly kludgy hack that I only mention
because the 'right' solution was proposed and overruled.
You're implicitly coercing the numeric result returned by
'len' into a boolean value, which works, because of the
typeless nature of CF. By using a numeric comparison that
I am having a nightmare trying to replicate a 3 column site
with CSS - it nearly make me want to use table's (did i say
that out loud)
This page should get you started! Best CSS list I've came across.
http://css-discuss.incutio.com/?page=ThreeColumnLayouts
HTH
--
David
Whilst I agree with you about implicitly coercing the
numeric result,
I'm sure I've heard Mr Cofield (or rathter certain guidelines)
advocate that very method in coding guidelines... Are the
ones I got
out of date of have I got my memories completely mixed up?
You're mixed up -
cfoutput#MyVar#/cfout (improperly closed tag)
OR
cfoutput#MyVar/cfoutput (var not enclosed in ##)
Hi
One approach that I've used is... (pretty much covering the same ground
Ewok did!)
!--- Variables.isDebug is tied to an environment variable which either
shows the errors in 'dev', might
h...now I had tried thatand it does not catch those
errors..that's
why I askedperhaps I'm missing something?? I'll test it again to
confirm
Ye gawds Bryan you're right! Just tested it and I was totally convinced
that the REQUEST handler got these types!
Not got time to play
Those are compiling errors. You catch them by running your
code on a dev
instance before putting it on production. Oops - error! I
must fix it! Those
files will never compile into java byte code. So, there's no
way for them to
be caught by any of CF's error handling.
What about a
Could you tell a little bit about the application and how the users are
using it (i.e. publicly accessible on web, intranet, users behind proxy
etc)
--
dc
~|
Find out how CFTicket can increase your company's customer support
Once happened in a place I work
Internet Explorer (and maybe other browsers) stored the cookies in a
network place connected to the logged in user...
Thing was when they set up a row of computers to use (for
matriculation), they logged them all in with the same username and
password. When the
Yup. I've read so much CF DOC about sessions that I am get dizzy.
I can't figure this out. How in the world would a user in one
location get
the identity of a user at another location?
It comes down to identification done either by jsessionid or cfid and
cftoken
Do you use CFTOKEN and
For two, specifically speaking, I can point to a couple
instances where I've annoyed the heck out of a DBA by
forgetting to join a couple of million+ record tables before
running the query.
I can think of a million ways a dba's annoyed me :) sorry, I'll get
back to work
--
dc
I need to set scheduled task to run at specific time
intervals like at 11:00 AM, 2:00 PM, 7:30 PM at 11:00 PM.
How can i set a single scheduled task to run at these timings
Another lame way...
Call it hourly and check the time and only do action if matches the time
required?
--
dc
So what is the best way to handle errors in a CFC?
Throw it? That's what I've been doing... Then document what you will
throw so that any calling code can catch any errors and decide what to
do.
Hopefully I'm on track with that one :)
--
dc
Lets say something gets by all my validation and a bad
variable makes it to a query in a CFC method. Now I have an
error. So I put a try catch around the query to control the
errors in the CFC. Since I need the results from the CFC
query, I'll get an error on the page calling it because
And if you don't agree with me, I'll take my Property p = new
Property(Ball.Color(Red)) and Structure.Home.Go()
That's one of the funniest things I've read all week!!! (It's been a
hard one :)
--
dc
~|
Logware
Hi there
Got a physical directory set up on Unix with my .cfm pages. The
webserver runs off another directory with symbolic links to the actual
physical directory, details as follows:
Files:
/homes/siteinquestion/
Symobolic link:
/usr/webserver/siteinquestion/ (which points to
I'm using getCurrentTemplatePath() and getBaseTemplatePath()
to calculate an 'adjust' variable.
Thing is that it all works fine until a certain point with
both CF Functions reporting on the symbolic link path, but
when I do a specific redirect, all of a sudden
getCurrentTemplatePath()
Sorry got confused, he did find a solution but I have no find's In the
code that is running.
Has anyone else expericnced issues with using getCurrentTemplatePath in
Application.cfm?
--
dc
~|
Logware (www.logware.us): a new and
Wow, too much for so little, Just use Richard's method
RUN YOUR INSERT QUERY
Then directly after the insert get the records ID...
cfquery name=mid datasource=
SELECT MAX(TheID) as LatestID FROM TABLENAME
/cfquery
Sorry but have to chime in here rather than lurking
OK it'll work,
What's right for one application is quite possibly overkill
for another. Did I mention it was access?
**ducks**
Yeah the database is Access at the moment. And the application at the
moment is using access... But it might get upgraded... The same
priniciple might be used in another
I am rapidly coming to the conclusion that I need some
educatin' with respect to structures, arrays, evaluation
function, list creation/manipulation .all that sort of stuff
Like this when I started
http://www.depressedpress.com/depressedpress/Content/Development/ColdFu
I don't think there's a neat way of doing it for Access, I
could be wrong though.
http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=79
Couple of methods ... Could be rewritten in CF if needed
--
dc
~|
Logware
Are there any CF tutorials on the www for this as it will be a
different process to just simply uploading a doc to a file server ?
http://www.macromedia.com/devnet/mx/coldfusion/xml_xslt.html
I would suggest to start from here:
Well, not too late to fix that!
CFEverywhere is the new kid on the block so we should prolly change.
What do you suggest?
I misread the instructions and called it CFAnywhere... Not very exciting
I know but...
--
dc
Interested in a portable CFML dev enviroment that fits on a
USB drive? Check out
http://philcruz.com/blog/2005/01/portable-cfml-development-env
ironment.htm
Thoughts?
Very nice... I'll give that a try on my iRiver at lunchtime and let you
know :)
--
dc
Are you using cflocation on the same page?
http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_17023
Maybe the cookie is not being set
--
dc
~|
Logware: a new and convenient web-based time tracking application.
Thanks for the clarification Jochem, I thought it was a database issue!
variables is impossible. The only thing you need to make sure is
that you don't just use the query string and name as keys, but
the bind variables as well.
Sorry, I'm not sure what you mean here though (may be too
variables is impossible. The only thing you need to make sure is
that you don't just use the query string and name as keys, but the
bind variables as well.
Sorry, I'm not sure what you mean here though (may be too
early in the morning and I'm being dumb)
Yeah it was too early, I
Oh MM, sort it out!
Not got anything to do with MM AFAIK... It's more a database issue cos
it uses bind variables which denote that the value will prolly change
from query to query but still allows the database to build a compiled
execution plan.
When you try and do a cachedwithin query in cf
free as in beer? I suspect there's quite a bit of time and work
involved in learning to use FOP and setting it up on top of your CF
server.
Learning this kind of stuff (ie FOP) is an investment in myself and
keeping sharp in learning new technologies... Most of the time these
investments
Just a couple of suggestions for you...
http://www.houseoffusion.com/cf_lists/index.cfm/method=messagesthreadid
=24060forumid=4
Which suggest getting an XML parsing custom tag from the devx
Or
http://www.box-one.org/new-2148376-4547.html
Which (pretty cooly) suggest using cfwddx
Someone might
Eric, go and join the other thread about 'What is it £$*£$ about'
--
dc
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message:
Think I got this lot from Rob Rohan
http://cybersonic.blogspot.com/2004/09/eclipse-and-cf-eclipse-shortcuts.
html
http://www.spike.org.uk/cfeclipse/comments/Snippets
http://sourceforge.net/projects/aseclipseplugin/
http://graysky.sourceforge.net/
http://jseditor.sourceforge.net/
function isEmail(str) {
var emailFilter=/[EMAIL PROTECTED],4}$/;
var illegalChars= /[\(\)\\\,\;\:[\]]/;
var error='';
if (str.length = 0) {
error = 'Your emailaddress was empty, no desert for you.\n';
}
if (!(emailFilter.test(strng))) {
Hey Micha
Would be good if you could get away with it though! Could have a right
laugh with the users. Hehehe
Sorry for the OT, just gave me a wee chuckle...
--
dc
~|
Special thanks to the CF Community Suite Silver Sponsor -
4guysfromrolla.com
Terminology to do most things in a web application is the same
regardless of the language so just search their archives for terms that
describe what you are trying to do and prolly be a tutorial on how to do
it.
--
dc
I figured most on this board would have more knowledge of
other things than CF. Sorry you are so limited.
Ain't limited mate, just wanting you to do your own legwork instead of
one of us
--
dc
~|
Special thanks to the CF
Zvon.org for most of your xml needs
--
Dc
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187753
Archives:
Hi Chris
I can see that when you dump out cferror, the thrown exception is stated
in the structure, my problem lies in that I can't seem to get Cold
Fusion to go to the correct template... The two scenarios are below and
it goes against what my thinking was...
- SCENARIO ONE TEMPLATE
cferror
I'm creating a calendar and need to know how to make the days
start on the day the month starts one.. IE.. December has 31
days and starts on Wednesday. So for December I have created
First get the DayOfTheWeek of the start and end of the month.
Then work out the number steps back from the
Whats the learning curve from dreamweaver, kinda busy the now but
getting sick of DW and it's 'features'! And thinking if I get the hang
of it in half a day or so, I would take the plunge
--
Dc
~|
Special thanks to the CF
Check out my CFEclipse Resource page, it will help you out.
http://www.dopefly.com/pages/cfeclipse.cfm
Magic Nathan, just what I've been looking for :)
Love the 'sand dunes' at the bottom of your site... Looks fantastic :)
Cheers
--
David
(wannabe designer but ended up developer :)
Anyone has an idea? or where could i read on div and iframe
for firefox?
http://mozref.com/
--
dc
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message:
The image preview doesn't work in Mozilla Firebird 0.7
I'm curious as to why you have a reason to test in Firebird 0.7... Am I
not realising something?
Off the top of my head, I would have thought 1.0PR at a minimum now for
testing in Firefox/bird since it has been officially released.
--
I am donating some time to a charitable organization. They
need a web calendar like the monthly view in Outlook. Were
the day is broken down in 1 hour increments and those one
hour slots can be booked.
Sorry to be pedantic but that is the week/day view... The month view is
like a normal
Actually all three views would be great. Is there a demo
http://calendar.viviotech.net/
Think you need to register... A few details are in the thread I posted.
I just remembered that there had been a thread about this a few days
ago, not tried it out myself :-/
hth
--
dc
I'm not that one that did it :)
Hey Rick, sorry didn't mean to imply it was you (or anyone in
specific)... Was just interested in the comment and whether anyone else
was continuing to test for the Pre release Firefox... CMIIAW, but it was
mainly just us developers that were kicking about with
My example code is being truncated from this list somehow.
Prolly the hyphens... If you have -- (or a some other amount) in the
code it cuts it. Make sure there isn't and the message isn't too long
--
dc
~|
Special thanks
Can someone confirm that this isn't right and I'm not missing something
obvious? Cheers.
ISSUE
Week() uses Monday as it's first day of the week
DayOfWeek() uses Sunday as it's first day of the week
CODE
cfscript
test = structNew();
test.saturday = structNew();
Seems that it reports correctly in CF5... But doesn't on CFMX Anyone
got any ideas what gives with this?
-Original Message-
From: COLLIE David
Sent: 24 November 2004 13:20
To: '[EMAIL PROTECTED]'
Subject: Week() and DayOfWeek() issues
Can someone confirm that this isn't right
If you fancy writing your own functions this link should be useful :
http://snipurl.com/iso_week_number
Cheers for that Stephen... Think I'm going to need to now :(
--
dc
~|
Special thanks to the CF Community Suite Gold
'Document root element is missing' any idea why?
I think the xml should be something like this,
root
itemsomething1/item
itemsomething2/item
itemsomething3/item
itemsomething4/item
/root
which it doesn't look like it is... Ie the only element is the root one
that has lists of when certain changes to the cfml launguages
.. i guess its up to 6.1
http://www.jamwerx.com/cfmTaghistory/index.htm
Cheers dave :)
--
dc
~|
Special thanks to the CF Community Suite Gold Sponsor -
think i should zip it up and have it to download?
Yeah... Would be good for out intranet...
only prob with that is i have no idea how i got it and if it
steps on anyones toes
Well, give it a day and if nobody hollers then ... meshrugs / ... Why
not
:)
--
dc
You got it from the MM site. The zip is available for download there!
And here they are for anyone that doesn't have them... Cheers dave and
Pascal
http://www.macromedia.com/support/coldfusion/ts/documents/cfmlhistory.ht
m
--
Dc
Hi there
Currently reading RFC2245 for iCal and planning on implementing a
app/cfc for creating/parsing iCal compliant files...
Anybody else coded similar and can point to any good resources for it?
Any better standards out there that I should be looking at? Any XML
calendar standards out
there a few pitfalls like the removal of Carriage Returns and
Line feeds in the description.
Yeah that line folding looks a bit mad :)
There are different implantations of iCal from diff versions
of Office so be wary of that. Also be aware that other apps
do not conform at all to the
I reckon vCal as it's the most widely used.
Cheers Neil :) Looked at vCal long time ago...
More docs for lunchtime consumption then for a refresher :)
--
dc
~|
Special thanks to the CF Community Suite Gold Sponsor -
Let me know if you need any more info/tips as the dev goes on.
Cheers Neil, will do :)
--
dc
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message:
(Plus, I helped created the vCal spec many many years ago,
not that that makes it better in any way, but it does explain
why I may be biased g).
All the more reason to use it :)
Cheers Ben.
--
dc
~|
Special thanks to the
Yes
Didn't find anything in first couple passes at googling apart from
server side javascript reading em... Care to elaborate? Is that what
you meant by yes?
--
Dc
~|
Special thanks to the CF Community Suite Gold Sponsor -
For those who have had problems with the signin section, it
is now working. Any additional errors should be sent to me
with a high priority and I'll nail them down. I will be
altering the layout and features of the section so let me
know what you want. Thanks
If this get's through then
Application.cfm is case sensitive on *nix flavours of Unix
If it is not named Application.cfm (and OnRequestEnd.cfm) it will not
run automatically on every request.
--
dc
~|
Special thanks to the CF Community Suite Gold
Code untested but I think this is what you mean :)
This would parse the string of values for you
cfscript
aKeyValue = listToArray(yourString, );
for (i=1; i lte arrayLen(aKeyValue); i=i+1) {
thisKey = listGetAt(aKeyValue[i], 1, =);
thisValue =
98 matches
Mail list logo