Thats what cfthrow and cfrethrow are for.
No.
This is to trigger an execution error in the system.
This kind of errors are not to be reported to the user.
If all you want is to warn the user he has done something wrong, you just need
to display some message in the returned page and that's
your HTML will not get rendered correctly if
you simply abort a page, which may result in your friendly error message not
being displayed properly, if at all.
Yet another grtuitous statement...
Your HTML will not get rendered correctly if you do not write it correctly,
period. ;-)
Ex: do not
incorrect blanket statements
I think this is exactly what I was looking for when I wrote gratuitous
statement, I hope this is correct too ;-)
~|
Order the Adobe Coldfusion Anthology now!
It may depend on the code between the two lines
cfparam name=capability_detail.capability_id default=0
cfset cur_cap=#capability_detail.capability_id#
For instance, this works:
cfparam name=capability_detail.capability_id default=0
cfset cur_cap=#capability_detail.capability_id#
It is assigned to a function that returns a query.
Oh, I think you cannot assign a value to a column name in a query, neither with
CFSET, neither with CFPARAM. You must use querySetCell ()
~|
Order the Adobe Coldfusion
I'm looking for a udf to capitalize uppercase text.
What do you actually mean by Capitalize?
- Having only the first character upper case in a word;
- Having the whole word in small capitals;
~|
Order the Adobe Coldfusion
A cross table is definitely THE standard way to do it.
Although it is not considered good practice by database ayatollah,
a delimited list may be an option when a reasonable number of possible values
is involved.
there are several advantages:
1º it is simpler to update in the database in case
a delimited list is a great idea
Did I say that?
I said may be an option
I just hate ayatollahs and never do and always do
Good practice is a harmonious combination of common sense and intelligence,
both being the fruit of experience, not just a set of black or white rules.
Any ideas why the original where clause stopped working? I thought CF
treated all NULL value fields in a record set as an empty string.
probably the CF9 code is more consistent with SQL.
Right, if a field is returned NULL in a query, CF treats it as an empty string,
but apparently, the NULL
Does anyone have an idea about why this is happening.
May be a stupid question, but are you sure your gif file is valid?
- Are you able to open the file with any image reader?
- Are you having the problem with any gif file?
~|
a corrupted email that cf
cannot process. Really CF should delete it.
Better, it moves it into the Undelivered directory so you can see what's wrong
in the message.
~|
Order the Adobe Coldfusion Anthology now!
I agree that would help, but it just leave the message sitting in the spool
and the spool crashes.
Ooops, never seen that.May be the problem is not with the message but with CF
itself.
~|
Order the Adobe Coldfusion Anthology
The domain name hasn't changed so I guess the API key is still valid.
Not so sure. For unknown reason, I had to get a new API key from Google for a
couple of domains these past months. But you should get a message in this case.
if I remember correctly CF9 has a Maps API key setting in the admin. have
you tried putting your key there?
Personnaly, I'm still looking for the use of this setting, since a CF server is
aimed to manage several domain names and Google requires a different key for
each domain.
I need a function that is passed an image and gets the precise color of a
specified pixel.
I have a custom tag that returns the RGB color precise to the pixel and which
works for GIF, JPEG or PNG formats.
CFX_MapClick
IMAGEFILE= full path name of the image file
[X]
In IE8 I think the function itself needs to return false
Sure, and I'm even surprise it does not need it in IE9.
I would use:
script
function makeWin(x,y,z,num,title) {
ColdFusion.Window.create('ImageWindow'+num,title,'Image.cfm?ID='+z,{x:150,y:y+80,height:640,width:840});
return false; }
What is the best way to store the value? I mean in which scope?
Definitely in the session scope.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
I will need the values
to be available for multiple browsers. I mean, the user might want to open a
new browser using 'CTRL + N',
This is actually not a new browser, but a new window in the same browser.
Session variables are available in any window of the same browser.
There is no need to
C'Mon Claude, store a 4 character value to the db
If the Tax year is the ONLY information needed, then a cookie may be used.
But in my mind, there are often more informations to store about the user,
like his name, eMail, address, etc. Then the database approach is better.
if someone submits some text to their own site that
they know is going to be displayed and it has email addresses in it, they
probably don't care much about the subject.
May be they do care, but they just don't know how to hide their address.
And there are also all those who do care and do not
That is a nice captcha.. most of them are so hard for people to read
that it discourages some people.
You've got a point.
Never forget that a Web site is first intended to be comfortable for the
visitor, not for the programmer.
With a captcha, the programmer can sleep quietly, but the visitor
getAddress ()
I mean getMail ()
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
How about the honeypot method that was presented
on CFMeetup a few months ago?
Never heard of it. Any reference ?
~|
Order the Adobe Coldfusion Anthology now!
The bot doesn't realize the field is hidden and puts something
in it. Check the field when the form is submitted for the
presence of a value in the field.
OK, I see. But there is no guaranty the bot will fill the field.
I prefer the reverse : add a field in a onclick event and check for the
Can you describe using an onclick event a little more?
Here is a example:
SCRIPT
function validateForm(b)
{
var NewInput = document.createElement(input );
NewInput.setAttribute('name','validateForm');
NewInput.setAttribute('type','hidden');
b.form.appendChild(NewInput);
but then I convinced myself that it wasn't the most efficient way to deliver
the images, so I switched my solution to static files.
And you are right.
The purpose of a database is to store data in some structured way to make
possible sorting and searching.
If you have nothing to sort or
For something like passwords you could use HASH store them in the data base.
Further more, a hash value cannot be decrypted, then the passwords in the
database are 100% protected.
~|
Order the Adobe Coldfusion Anthology now!
The user copys the text from the word document, then instead of
pasting it straight into the editor, click the paste from word
I never implemented fckEditor, mainly because the programer could not force
cleaning from Word automatically.
The was a button Paste and another one Paste from Word.
leaving only the Paste From Word option available.
... then you will have users calling you to ask How can I paste if not from
Word? ;-)
~|
Order the Adobe Coldfusion Anthology now!
the paste from word button turns it in to plain ASCII text
Last time I looked at the clean function in FCK, I think it did not cut
elementary and non harmful HTML, like Bold, italic, etc.
However most of pasted text include styles and classes, which is almost
impossible to clean efficiently
and sometimes changes document changes don't refresh
Are you using Explorer ?
There is a well known bug in IE about caching Ajax requests.
See
http://coldfusion.tcs.de/coldfusion-ie-cache-problem-with-repeating-ajax-requests/
I've added this at the top of the called template, and it solved
Nope... no IE for dev. Always FF with FB.
OK, but still, use these headers, in case you have some users under IE.
~|
Order the Adobe Coldfusion Anthology now!
you can add
something like '?cachebuster=' + new Date().getTime() to your request URL.
Right, but I prefer the first method.
First because my Ajax function is getting the url in a parameter, sometimes
with ?values in it, sometime with none, so sometimes ?cachebuster=should be
added, sometimes
Here is the problem: 'timestamp' is being changed to 'x' because times is
the special character entity for x.
Can you identfy the process which changes times for 'x' ?
Because it's wrong, x is times; not just times
~|
Order
If the image being uploaded is 72dpi, it works fine. If the image is 97 dpi
or up, the image is processed appropriately and saved as 72 dpi.
I don't know if it's what's causing your error, but if it's for publishing on
the web, what really counts is the width in pixels. The dots per inch is
CFDOCUMENT requires OpenOffice to be on the server,
Although it does not answer your question, I understand you don't want to use
OpenOffice.
I recently installed the last version, tried to open some simple Word documents
with it and the result was just horrible. If OpenOffice works that
Hmm the only error Firebug shows is the same oForm.auto_approve is
indefined..
The problem with Ajax is when there is an error in the template called by the
function.
This causes an error in the application because it cannot find what is expected
in the text returned by the template. Instead,
dateformat(foodate,'mm/dd/')
Here is your problem: use CeateODBCDateFormat instead:
#CeateODBCDateFormat(foodate)#
Also #CeateODBCDateFormat(now())#
Furthermore, this will work provided foodate always contains a valid date.
If it is empty, it will cause an error.
In this case, you have to
line 53*
Do not take the line number as a hint.
When there is an error in a query, the error is returned by the driver and CF
doesn't know which line caused the error.
It will indicate any line in the query.
~|
Order the
This might be caused by the persitent cache in bug in Explorer.
I put these lines in the template called by the Ajax function, and the problem
is solved.
cfheader name=Cache-Control value=no-store /
cfheader name=Pragma value=no-cache /
cfheader name=Expires value=Tue, 16 Oct 1973 00:00:00 GMT
Hi,
Since a few days, I have all my sites receiving requests in which a string like
/**/or/**/1=@@version)-- is added in the URL.
Has someone any idea what this guy is actually trying to do ?
~|
Order the Adobe Coldfusion
Good old cfqueryparam has been working like a charm!
If your template is not using URL parameters in a query, cfqueryparam wont help.
And if the parameter is text, the scrap will get into your database as well.
Happily, my moron trap is more general. ;-)
If your site returned what they wanted, in this case SQL server
version information
Ok, I see. In my case, I doubt the 403 error they get in return will help them
a lot ;-)
~|
Order the Adobe Coldfusion Anthology now!
The cfqueryparam tag doesn't care where data comes from
What I mean is that cfqueryparam will not protect you against attacks, il will
just prevent attacks to be succesful.
A better approach is to check for a couple of key words like
user
declare
script
@@
exec,... (provided you don't use them
I have designed a custom tag able to create all sub images from one gif image
and manages all frame parts.
See : CF_EasyFrame http://www.cftagstore.com/tags/cfxeasyframe.cfm
~|
Order the Adobe Coldfusion Anthology now!
The specified directory attribute value
\\blah\AppDev\ParisDocs\blah\docs\
What is the double \\ for?
Sometimes it is taken as equivalent as one single \, but some other time it may
not.
This could explain why DirectoryExists says it doesn't but it is found when
being created.
I'm having a similar problem, although in a completely different context, since
I migrate my development server from XP to Windows 7.
I'm still using ColdFusion Studio, and starting with W7, when I search for some
string in files and it finds one say in C:\inetsrv\wwwroot\myProjet\myFile.cfm,
The other option is I completely toss what they use and get the system to
name the file.
I always rename the file using CreateUUID() and store both the original and new
name in the database.
This way I can reset the original name when visitors download the file.
But beside uploading and
All credibility is lost with that statement.
No, there used to be a server side Javascript language, during the good times
of Netscape.
This language was a PITA, but it did exist.
~|
Order the Adobe Coldfusion Anthology now!
Hi,
At least 12 years ago I developped my own visual database management system,
mainly because no one able to fulfill my needs was available on the market.
This manager includes a powerful visual query builder which generated not only
SQL code, but SQL integrated within CF code.
Now that many
Is there a CF image function or tag that will compare one image with
another? If not, is there a java function or something I can use?
I have made a CFX tag which calculates a CRC-32 checksum for a file.
If two files have the same CRC-32, probability that they are identical is very
high,
Hi,
According to CF docs for GetBaseTagData(tagname [, instancenumber ]),
instancenumber = (Optional) Number of ancestor levels to jump before
returning data. The default value is 1 (closest ancestor).
Then, suppose I call the function from a custom tag with its own name in
parameter (I
I suppose the namefirst variables come from some Query?
cfloop index = i from = 1 to = 50
input type=text class=txt name=namefirst#i# size=25
value=cfoutput#evaluate ('nameFirst' i)#/cfoutput /br /
/cfloop
However, if the variables namefirst come from a form or some other structure,
/* note: your cfparam needs form.namefirst not just namefirst */
Furthermore, if they are text fields, you don't need to set default values.
Only for checkboxes or radios
~|
Order the Adobe Coldfusion Anthology now!
I tried it twice and both times it crashed chrome.
May be because both the video and Chrome are programed in PHP ? ;-)
~|
Order the Adobe Coldfusion Anthology now!
Hi,
I kind of remember having read sometimes somewhere that one could generate a
page with text laid out in multi-column mode in a pdf CFdocument, but I cannot
find any trace of this in the CF docs.
Was I dreaming or what ?
Hi,
I'm creating a pdf document which contains color and greysacle jpg image.
About half of the greyscale images are much whiter than the original.
I've read about some problem with image scaling, but not about this one.
Any idea ?
I think you can use 2 column layout html template Using Dreamweaver
Well, I suppose that it is simply some table in which one can fill in some text
by hand.
I know haow to designe a two column page in HTML, the problem is to have it
automatically generated from a database.
What I was thinking
unless you
include a file that includes the file you're including.
Even this will work, provided you have a test to stop the recursive loop.
~|
Order the Adobe Coldfusion Anthology now!
Aren't they all also relative to the original including templates path
though even though they're nested?
I would say yes. Better do this in the same directory.
Any way, I do not relly see a good occasion for using recursive includes,
because they will all work on the same variable scope.
I
You cannot use a cfinclude on a .htm page
Well, actually you can, ... but it will include nothing ;-)
~|
Order the Adobe Coldfusion Anthology now!
What would happen if you set up a scheduled task for 02:30 on the
day that we return to standard time since there would theoretically be
two 02:30's for that morning? Would it run twice?
There is a simple way to make sure an application is run at least one and only
one time:
Say you have it
Is there a way a can create a blank page without the browser automatically
adding:
In my case with Explorer, this is what I get:
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
HTMLHEAD
META content=text/html; charset=windows-1252 http-equiv=Content-Type/HEAD
BODYPRE/PRE/BODY/HTML
Most of the case, the user does not want a new item to be published bedore it
is completed.
For existing items, only little adjustements are made and this may be done on
line.
If it is your case, just add some Active logical field in the table and display
the item only if the active flag is
I am trying to display a
list of Parent and Child pages, with children arranged under their
respective parents, thus:
This is one of the best case a recursive custom tag can be used.
Every row in the table should have a column with parentId pointing to its
parent.
No need for parents pointing
You cannot embed #...# delimitors like this.
Try with
cfloop from=1 to=4 index=idx
#detail[off idx _street]#br /
/cfloop
~|
Order the Adobe Coldfusion Anthology now!
Hi, I have an application (CMS) running fine for about 14 years under CF.
In IIS 6, I have set .txt files to be treated by CF as well as .cfm file, so I
can use a dynamic Robots.txt file.
It has been working nice for years, but now I noticed that all requests for
.txt files give an error 405
some URL rewriting
Is it possible with IIS?
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
Are you using CFFORM?
I never use it, but I kind of remember there is something special witf input
fields containing _date.
~|
Order the Adobe Coldfusion Anthology now!
The data is actually being posted back from paypal.
Ok, I see. Well the problem is that CF is not able to parse the date in the
format supplied by Paypal.
Personally, I use createODBCDateTime(Now()) to register the date time. It will
be the time related to your sever instead of Paypal's one,
You also have to configure CF to do something with them, by editing web.xml.
Arhhh ! I knew they would have made it more difficult to do exactly the same
thing :-(
http://www.talkingtree.com/blog/index.cfm/2006/2/17/CF-Custom-File-Extensions
Ok, I made exactly what is said here, it makes no
Ok, I made exactly what is said here, it makes no difference.
Ok, I restarted IIS and now I get something. Thanks.
~|
Order the Adobe Coldfusion Anthology now!
Call me kooky, but that seems like a lot of steps / effort for something
that should be bone simple - a checkbox or text field in the CF
Administrator maybe?
IMHO not even.
CFMX is full of such undocumented and useless features.
Since IIS is passing an HTTP request to CF, why should CF also
The web server actually sends ALL requests to CF by default -
Really ? My Web server (IIS) only sends to CF requests for files having an
extension defined in the IIS configuration, ie .cfm, .cfc,...
By defaut the Web server will just pass the file as is to the browser.
Hi,
I have CF9 installed on W7 using an Access database.
In a table I have a currency value of -488.7
The windows is French, but I have set the delimiter for both the decimal values
AND currency values to dot instead of comma.
Though I get this error in CF:
The value -488,7 cannot be converted
Can you reply with the line of code throwing that error and perhaps a few
relevant lines above it?
It has nothing to do with the code, which by the way works perfectly on my
production server under W 3000 in English.
The problem occurs in #numberFormat(paiementMontant, _9.99)#
The error is
Ok, I got it!
The query is produced by a UNION, ans in one of the sub SELECTs, the column was
set to '0' instead of 0. This tiggered a converstion to text for the same
column in the next SELECT, probably in the ODBC driver, and this conversion
implied the use of a comma instead of a dot. For
but fails when used inline in Coldfusion.
Please define fails.
- No record returned?
- wrong data?
- error thrown?
~|
Order the Adobe Coldfusion Anthology now!
datepart(q, datecolumn), column1, column2
It might be that the query has no name for the datepart column.
Try
datepart(q, datecolumn) AS quarter, column1, column2
~|
Order the Adobe Coldfusion Anthology now!
Too few parameters. Expected 1
This is supposed to mean that one of le column names is not found in the table.
Why don't you post the whole query here?
~|
Order the Adobe Coldfusion Anthology now!
newdir = tests/doc.html
According to the example you give, what you're looking for is not an array but
a substring.
How about
newdir = listGetAt(dir, listLen(dir, /)-1, /) / listLast(dir, /)
~|
Order the Adobe Coldfusion
»I can't give any clues on error messages, because this
is part of a cfc on the back end of an ajax call.
No errors show up in firebug or elsewhere.
This is a problem with Ajax calls.
If the template called by Ajax throws an error, the text returned by the CF
server is not compatible with Ajax
I'll have to work on translating this into jQuery.
... or simply use my function it as is. It has been working fine for years,
long before jQuery was on the market.
~|
Order the Adobe Coldfusion Anthology now!
The problem with IP blocking is that 99% of the time the IP is a fake IP,
I'm not a protocol specialist, just curious, but how can an IP be forged?
~|
Order the Adobe Coldfusion Anthology now!
http://en.wikipedia.org/wiki/IP_address_spoofing
Thanks.
I can't believe it is that simple.
It would be so simple if the protocol was something like:
- sender: I have a message for you my IP is x.x.x.x
- receiver: Ok, here is the key: (UUID)
- sender: Ok, your key is (UUID), here is the
Is anyone using the CF9/OpenOffice to convert Word/Excel documents to PDF?
How well is it working?
Pretty badly. I even didn't try it under CF since I never was able to get a
proper conversion from MS Word to Open Office. It might work well with plain
text, but forget about formating.
12 years of documents to convert
For 12 years old MS Word documents, I can believe Open Office is capable of
interpreting the document properly, but for more recent ones, Op.Of seems to be
far behind.
~|
Order the Adobe
this is the official way to do it.
http://www.robotstxt.org/
The problem with Robots.txt is that it is only obeyed by well behaved bots.
Well behaved bots won't cause traffic problem, even if they are a dozen sucking
your site in the same time.
I've seen bad bots reading robots.txt and
What would be nice if the companies that create the likes of IIS and Apache
and others, got together and defined a protocol at the server level.
IMHO, the only rule that would be really useful would be to force Robots to
1. identify the web page were they discribe their purpose and what they
Frameworks exist because they help solve problems
This is why the best framework is the one you design yourself to solve your
problems.
Solutions for other people's problems ar not always good for you and may even
cause more problems you will ever encounter.
- Powerful spam protection
This must be essencially for ingoing spam I suppose?
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
#794625 MOD 256# will return 1, #794626 MOD 256# will return 2, etc.
That will give you your folder number. If the result is 0, then the
folder would be 256.
Then use ((property - 1) MOD 256) + 1, this should go from 1 to 256
Ex:
CFLOOP INDEX=n FROM=794620 TO=794630
CFOUTPUTn = #n#, ((n - 1)
Cold Fusion is written in JAVA which means, generally, that a ColdFusion
program will run slower than a program written directly in JAVA.
Yet another statement from a guy who doesn't know what he is talking about.
Java programs AND CF templates are compiled into Java byte code.
CF templates
What's wrong with the below?
Don't you need RESET=yes inside the CFCONTENT tag?
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
Try this:
(Note that for the last one you will get 0s at the end of the integer part,
this is probably because of an overflow error. If you really have such large
numbers, a function that works exclusively on the string will be needed.)
CFSCRIPT
function thSepar(n)
{
var integerPart =
I doubt you can achieve this just using regex.
Regex are great for doing things, but not for not doing.
~|
Order the Adobe Coldfusion Anthology now!
I actually need the isvalid function to return false if the sign is on the
right. is there a way to do this?
Try this :
CFSCRIPT
function isValidInteger (value)
{
return (REFind (^(\+|-)?[0-9]+$, value) NEQ 0);
}
/CFSCRIPT
CFOUTPUT
isValidInteger (12345) = #isValidInteger
Hi,
I came across a problem with CFCONTENT. Even if the attribute RESET=yes is
used, the content which was previously set by cfhtmlhead is not reset.
Ex 1:
cfhtmlhead text = 'This is in the head section'
cfcontent type=text/html; charset=ISO-8859-1 RESET=yes
This shouldn't have the head
Once you use any
functionality that explicitly writes part of the response (CFHTMLHEAD,
CFHEADER, etc) you can't use functionality that lets you manipulate
the storage buffer (CFCONTENT, CFFLUSH).
Not so sure about this.
I've noticed that the effect of CFHTMLHEAD is to find the HEAD.../HEAD
Once you use any
functionality that explicitly writes part of the response (CFHTMLHEAD,
CFHEADER, etc) you can't use functionality that lets you manipulate
the storage buffer (CFCONTENT, CFFLUSH).
I think it is actually the opposite:
Once you have used CFCONTENT, CFFLUSH, you cannot use any
201 - 300 of 518 matches
Mail list logo
