I'd better qualify that to say I can at least get form, url, cgi,
request
and session scopes - haven't tried others besides those and variables.
As one would expect, it also work with the application scope.
--
___
REUSE CODE! Use custom tags;
See
1. The error is happening on a page that is *likely* to throw an error
This is the kind of situation you get when you are still developing,
testing and debugging
your application, I have no problem with that, and I have plenty of tools
and techniques to deal with it.
2. The error is happening
I am trying to strip out everything except the content between h2
tags and end up with a comma delimitered list.
You could do this very easily with CF_REextract.
This tag can return all your H2.../H2 strings in one list or one query.
See
cf datetime objects are decimal days since 31-dec-1899
Gee, I didn't know CF was that old!
(sorry, just couldn't resist ;-)
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this
My personal experience with it is this: I have yet to have any of
these database instances to be corrupted or bloated in over five years
of very active usage.
Same with me, in over 12 years !
Another advantage is that you can easily make the database downloadable
by the customer, so that
he
but why would you use that over SQL 2005 Express edition?
The environment one client - one database - one file has many advantages
and makes many things much simpler than the one database server
environment.
Again, simplicity is an advantage for simple applications, for more
complex
That's simply not going to happen. The ampersand is the character used to
mark the start of an entity.
Ok, but in HTML, there is no entity inside an attribute, (unless you
decide to pass an HTML string in the attribute).
Changing this would require changing every XML parser in existence.
Ok,
If you want to include, say, a copyright symbol in a submit button, how
would you do that without using the appropriate character entity in the
VALUE attribute of the button?
Then I will use an HTML string, since I know the value is to be finally
used and displayed as an HTML string.
But if I
I have a client using access (I know Access sucks for web stuff, but
he's using it...)
Access does not sucks.
Access works perfectly for many sites for what it has been made for, ie
small and medium databases.
Unless you have thousands hits a day on your site, it is a perfect
solution, and
've mostly heard bad stuff about it.
Me too, but they are mostly urban legends.
Like for instance Access is really bad when serving many users at the
same time.
This affirmation just does not make sense for WEB applications.
This may be true for an Access application on a lan,
but since when
n both SGML and XML, the ampersand character () declares the
beginning
of an entity reference (e.g., reg; for the registered trademark symbol
(r)).
Well, this is true for HTML, but here we are inside a url address.
You're not supposed to pass HTML in a url address, aren't you ?
The document you
For what it's worth, I've seen similar behaviour from certain search
engines, where links have ampersands in them.
That's the case: the make an url to their own site, passing the result
link as a parameter.
In the process they escape all characters, which they should not do.
It's trivial to
it discusses the HREF attribute of an element.
Ok, I see now. But it applies to XHTML, not standard HTML
Anyway, this is obviously in contradiction with RFC 1738.
In HTML, what's inside an attribute is NOT HTML, it is just a string value.
Of course, one can pass a string contaning HTML in a
You can also set up some rewrite rules with Apache's mod_rewrite or
one of
the IIS filters.
Ah good idea, I'll see what I can do.
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this
furthermore, one can read in http://www.ietf.org/rfc/rfc1738.txt :
Many URL schemes reserve certain characters for a special meaning:
their appearance in the
scheme-specific part of the URL has a designated semantics. If the
character corresponding
to an octet is reserved in a scheme, the
this is how NOT to develop a site.
Well, as the name says, it is open, but in this occurrence, it is
straight wide open ;-)
Apparently, they didn' bother with login stuff.
Note however that this is also the way the ubiquitous Wikipedia works.
--
___
REUSE
Did everyone miss the function that I posted earlier that fixes the
problem?
No, I've seen it and eventually going to implement it.
For the moment I'm trying to implement a filter on IIS server as
suggested by Russ, but
it does not look trivial ;-)
--
___
You can also set up some rewrite rules with Apache's mod_rewrite or
one of the IIS filters.
Which IIS filter?
I can see about ISAPI filters in IIS, but where are they?
Do I have to develop my own ?
--
___
REUSE CODE! Use custom tags;
See
So, if a user's input fails server-side validation, do you not
give an error message to the user?
Not exactly. What I mean is that I will let standard error messages
through, like
invalid datatype for an invalid date from the database driver, or
null values not allowed, etc...
With client side
client-side innocent errors (e.g. typos) get user-friendly
messages.
Right.
Anything making it through client-side, but failing
server-side gets the raw error messages.
Also right, only hackers will get to the server with invalid data, so
why should I care about them?
--
But what about, as already mentioned, somebody browsing with
Javascript turn off
In that case they get the message Your browser should have Javascript
turned on to proceed and no form at all.
--
___
REUSE CODE! Use custom tags;
See
but how 'user friendly is this if done?
IMO the user friendliness you gain being able to use many JS tools that
can make a site look more efficient
largely compensates for the apparent roughness toward paranoid who
deactivate their Javascript.
--
___
REUSE
If it's not turned on just send them a message: You must enable
Javascript to use this form. If they choose not to, so be it.
Bravo! We should start a union of developers about this ;-)
It's like people who refuse to use HTML email... I think it's time for
these folks to come into the light
In CF5 I was able to set the datasource
to automatically index files after writing new records.
What a weird decision. Isn't the datasource supposed to automatically
update all indexes anyway?
Hope your database is just a very small one.
--
___
REUSE CODE!
then why would you EVER take the risk of 10% of the potential market
not being
able to access your application?
does this figures suppose that 10% of visitors having Javascript
disabled IS a potential market?
I mean many of those 10% hits are simply eMail sniffers, spamers or
whatever,
validation like That order number is not found in our database. How
would you do that in JavaScript without going to the server anyway?
Ajax man, Ajax! ;-)
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
its an old dbase 3 database
As far as you have an ODBC driver to support it and able to re-index
tables, it should also take care of indexes
when updating.
I don't see your point.
--
___
REUSE CODE! Use custom tags;
See
does this figures suppose that 10% of visitors having Javascript
disabled IS a potential market?
further more, how many among those 10% just didn't know they had JS
disabled and will be so glad
you told them that they will buy anything in your boutique? ;-)
--
But what about the people that don't use HTML email because they feel it
has no added value
Same as for people that does to Macdo for a gastronomic event ;-)
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
But what about the people that don't use HTML email because they feel it
has no added value
... which makes a pretty good reason to show them how to enable JS.
They will be grateful.
--
___
REUSE CODE! Use custom tags;
See
I haven't been able to figure out
how to use the Merant driver in MX7, is this possible?
In MX 7 you can still use the ODBC socket and connect to any ODBC
connection set in Windows,
using Microsoft Foxpro or dBase driver, and probably also the Merant driver.
--
You've got that backwards - it's HTML mail that's super-sized, full
of lard
and bad for you.
BTW, I don't know what kind of crippled mail reader you're using, but
its bad habit to strip the
References header from your replies make the thread particularly
difficult to follow.
--
because they feel it
has no added value and all the colors, backgrounds and images only
distract from the content?
You don't have to go to extreme just because you are using HTML.
Just as you don't have to make any Word document look like a master piece.
Sometimes some italic or bold
But why not incorporate the server-side validation into the
client-side validation using Ajax
Because it is barely more efficient than server side validation.
The advantage of JS validation is that it can be done without any
interaction with the server.
Ajax should be used only when the
Client-side validation is going to have to server-side validation, too,
which means the server is going to have to handle all the validation
that the client-side does. So there's just as much stress on the server.
Not really, because server side validation is done only once, by the
submitted
so where's the benefit to the server after all's been done?
Just to make sure all's been done, in case someone is trying to hack
your system and bypass your client side validation.
See client side validation as some mat at your door, a convenience so
that your guests can clean up their feet
Hi,
I have some page the address of which is ...index.cfm?p=page*id*=12
I have noticed that sometimes I have an error message that id is not
defined.
Actually, the visitor was sent on my page by some search engine.
The search shows the correct address ...index.cfm?p=pageid=12,
but actually
Does the JS and CF validation have to be totally independent in
functionality?
Basically yes ;-)
I mean:
1º Javascript is so useful for so many things, I simply won't let a user
fill a form if they have Javascript disable, period.
2º the main reason for validating data client side is for the
You should only be doing AJAX validation when you can not do the
validation
on the client-side (such as validating against a database.)
Absolutely true.
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please
If anyone has any comments in this approach, I'm all ears.
I agree with you, but let me just add that server side validation does
not have to work exactly the same way.
What I mean is that client side validation is to be preferred and used
mostly for the user comfort,
when server side is
and using Ajax to send the form data over to a CF page for
validation, but I couldn't get everything to work correctly.
I'm not sure it's a good approach. Ajax has its price: the time needed
for a request on your server;
May be not as long as reloading the page, but not far.
The advantage of
I've used ajax validation successfully in one case: the user is
signing up
with a unique username,
Very good example indeed.
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this
How about if you listLast the Rightmost, say 100, characters?
That was the idea. I'd be curious to know if there is a significant
difference in performance.
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
the listLast method completed in around 5.5
seconds. The rightmost chars method completed in 80 MILLIseconds.
Ok, so this confirm that the listLast function is not optimised.
H... poor programing :-/
--
___
REUSE CODE! Use custom tags;
See
If I get the last 100 chars
and then do a find on them, I should be good to go?
It should not only be good, it should be much better ;-)
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to
What would be the *best* way to delete the
last line of a 8500 line file? Can it be done in one statement?
Well, this should do it: (not tested)
cfset foo = right(tempvar,100)
CFSET lastLineLen = len(listLast(foo,chr(10)))
CFSET tempvar = left(tempvar, len(tempvar) - lastLineLen)
Of course,
listDeleteAt(ListLen(list,delim))
Definitely not *the best*, according to the discussion in this thread.
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL
I knew there had to be a list function that I forget about!
I may be wrong, but I'd be surprised if the listLast function was smart
enough to parse the string backward in order to find the first
occurrence of the delimiter and extract the last item in the list.
If It does, then fine, you've
I was agreeing with you - you CAN'T directly get schema metadata
through SQL.
Oops, sorry, I read too fast ;-/
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL
f I recall correctly, you can't directly get Access schema metadata
through SQL.
Right, but the info you can get is quite limited; you can get a list of
tables, I think columns too,
and that's about it.
--
___
REUSE CODE! Use custom tags;
See
Anyone know of a way to find the Primary Key in a table using CFMX
and SQL?
CFX_ODBCinfo will do this for you. You will need an ODBC connection on
your datasource.
See http://www.contentbox.com/claude/customtags/ODBCInfo/E/TestODBCInfo.cfm
--
___
REUSE
I don't pay for code though
Not for 15 bucks? Then do it yourself ;-))
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
I don't know what the REExtract thing does exactly
It returns all strings between two matching REs in a list or in a query,
with positions and lengths of all strings
Pretty handy when it is easier to describe what delimits strings than to
describe the strings themselves.
For example,
I'm sure there has to be a better way of doing it than that,
You're quite right:
Have a look at CF_REextract:
http://www.contentbox.com/claude/customtags/REextract/testREextract.cfm
--
___
REUSE CODE! Use custom tags;
See
It doesn't read the NULL value
It is a bad flaw in design, from the very begining of CF: it never takes
in account empty elements in lists.
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any
How would I go about doing this?
Hi,
This is really a job for CF_REextract.
See http://www.contentbox.com/claude/customtags/REextract/testREextract.cfm
Then try it with your sample on line:
http://www.contentbox.com/claude/customtags/REextract/testingREextract.cfm
- Enter [^(]*\(mid:[[:space:]]
using Rick Root's imap.cfc
Since you're using this code, can't you simply change the column name it
generates?
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL
If you have other ideas for the site, please let me know.
Very good initiatory Ray.
May I suggest you add Association portal in the list of categories.
Associations are not really business nor charity.
May be also a field for the language(s) of the site would be interesting.
--
Therefore, I want to log user web browser (#CGI.HTTP_USER_AGENT#)
Not really useful. Differences in browser can cause script errors on
client side,
but are rarely responsible for errors on server.
Use CFERROR, collect anything you can, like session variables, etc. and
store it in a memo
Anyone know of a discussion/tutorial on the best way to go about
creating a website traffic management/reporting system?
Only my own experience on the subject.
You'll have to parse the headers to distinguish robots from human
visitors, otherwise your statistics will be biased.
This does not
I think there must be a way of
converting this data into Unicode direct in SQL level. Or another better
solution?
Personally, my own framework still has to be CF5 and CFMX compatible,
depending on the customer's server.
The simplest way I found was to stick with ISO-8859-1 (or whatever you
Sure it does, its just not in the default installation.
Ah thanks for sharing this info.
Just a bit weird that IIS 7 is not running ISAPI by default, considering
that ISAPI was made especially for it ;-)
--
___
REUSE CODE! Use custom tags;
See
Sure it does, its just not in the
default installation. (At least on Vista, which I've been running for 3
days now, you have to go into:
We have been through this already, it seems to be working for CFMX, but
apparently,
the CF5 running module is not recognized as a proper ISAPI filter by IIS
I think the point was that in order to get IIS with Vista, you have to
go to the Business, Enterprise or Ultimate version.
Exact, but what developer would only get the home version anyway ?
--
___
REUSE CODE! Use custom tags;
See
Has any one tried to install CF5 under Vista?
I know it sounds like an anachronism, but some of our clients are still
under CF5,
so we have to keep CF5 running on our working station at least for testing.
One of us just acquired a new portable equipped with Vista.
When he installs CF5 on it,
I am sure it is possible, I haven't tried but will do once I get my
VM Vista
installed.
Apparently there is definitely a problem :
http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?forumid=1catid=2threadid=1242953highlight_key=ykeyword1=vista
You can't use CF 5 with IIS 7.
The only reason it could be so would be that IIS 7 does not support the
ISAPI protocol anymore,
weird enough...
Or the problem is more general about dlls and Vista.
We have been able to run CF5 in CGI mode, but not with ISAPI.
--
is there a method to running .cfm files from within a .bat file
without opening a browser window?
How about using a schedules task?
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to
It works on my
local machine but won't work on the server(Windows 2003, with IIS 6)
Make sure your IIS is configurated to handle .pdf files.
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any
even if it saves then
hundreds of hours of development time. I think that is plain stupid.
I would even add that it does not help developers because it constitutes
an unfair competition
and prevents others from offering a better commercial product.
In that sense, it can be seen as a betrayal
Since most of you disagree with me
I agree with you. In a contest, there is always something to win, but
when the only winner is the one who set up the contest, it is not a
contest, it's a rip-off ;-)
--
___
REUSE CODE! Use custom tags;
See
Couldn't that be said of EVERY contest?
No, generally, in a contest, there is something to win.
It is a rip-off when the winner wins nothing.
but we are talking about a group of people who
dedicate a lot of their own time for the benefit of the community.
This is what they say. IMHO they
Anyone with *any* business sense at all knows that contests are an
*extremely* good marketing/growth tool.
I don't remember anyone ever said here that constests are bad.
The only issue is about contests where the only one who wins is the
one who set it up.
--
I need to validate for a strong password with the following requirements:
With such annoying requirements, you don't even need to ask for a password:
nobody will bother to register in such a site anyway ;-)
--
___
REUSE CODE! Use custom tags;
See
Sorry for the KOT question, but this is a general developer question
after all.
Has any one tried IE7, and is it possible to run both version IE6 and
IE7 concurrently on the same machine?
Question of verifying code for both versions of course.
--
___
REUSE
However, you might find this helpful:
It sure helps. Thanks
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
Yeah, IE7 standalone is *not* an installed and working copy of IE7, it
cannot be trusted (for developing, not in general!)
Ok, then what's about standard IE7 + IE6 stand alone? Is it possible?
--
___
REUSE CODE! Use custom tags;
See
People said that about Linux too, but things change.
People said that about Unix too, about 30 years ago, and nothing has
changed ;-)
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to
I tried creating table for each row so that the data is displayed as
it fetches it but here the problem is aligning successive tables.
You could declare fixed width for each cell.
--
___
REUSE CODE! Use custom tags;
See
Can anybody think of unusual reasons for a specific session variable
to randomly disappear?
Yeah, when CFHTTPing from a template, the called template is not aware
of the current session and will open a new one.
This one kept me busy for quite a while some times ;-)
--
My wife has been after me to do all the things mentioned on
the blog... except the dying part.
Watch out, wifes rarely give up! ;-)
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this
Hi,
Anyone aware of any tool that would analyse the mail logs produced by CF
and give a list of all failed mails, error messages, etc.?
Thanks.
~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 MX7 integration create
So. anyone worked out a solution where lone developers form a
relationship
to take over one another's work if something happens to one of them?
I've signed an agreement with my friends who host my customers on their
server.
They also are CF developers.
Our agreement just stipulates that if,
who are basically being given the company you built, provide
a percentage payment of business profit from your clients back to
your survivors?
Eventually, when the company will be more profitable.
--
___
REUSE CODE! Use custom tags;
See
I use is for numeric comparisons and eq for
all others.
How about IS EQ ?
That would be more correct syntaxically ;-)
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address:
Syntactically correct
Ooops sorry, I used the French word ;-)
~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 MX7 integration create powerful cross-platform RIAs
because CF will automatically convert
whatever value you give it to a valid date.
Sure, but CF has a bad habit of assuming that the whatever value is a
date in american format,
so better make sure you transmit the date in a correct format first.
--
___
I started on 4 and you're all talking like it was 6 odd years ago...
Young man, I started with version 1.2, about 12 years ago...
I remember, the docs was just an MSWord document by that time. ;-)
And can you believe this: queries name could only be used once in a
template.
If you had a query
But anywhere from 1-3 seconds later, a GET request is sent from the
same IP address for the form submission page, and the listed referring
page is the forms processing page.
Would you have by any chance some onsubmit function that does a submit()
on the form?
That would cause the form to be
What is the best way to automatically insert the current date into a
data table?
How about a time stamp?
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL
Also remember that you can still use Java with CF5, you just need to
build it a cfx tag.
This is precisely what I've done, ... but in C, a much better language
than Java... ;-))
--
___
REUSE CODE! Use custom tags;
See
Ah, so there you go! You already have the tag!
Sure, and with C, it is faster to develop than even finding the docs
about Java ;-)
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this
How do you prevent someone from entering the URL in their browser to
a file that requires a login in an app to reveal?
1. Put those files in a special directory and add .cfm to the file name;
2. store in your databse both the original and the storage file names;
3. Put in the same directory an
When I noted ColdFusion, I really mean Java,
Ah, ok, then it is also CMFX only.
I am not sure why you would want to do that, as it would go against the
purpose of LastModified date.
For many reasons, the first being to fix a problem with FTP which go
against the
purpose of LastModified date
Indeed, but I think it's probably quite rare that people are not on
MX now
Right, I develop undex CFMX, but most of my clients are under CF5, and I
still have to keep my apps
compatible.
Nevermind, I just add another attribute to my tag CFX_ListDir to update
creation, last modified, and last
Hi,
Does any one know about some tool or custom Tag able to set new dates to
files on the server,
like date last modified, date created, or date last access?
Also, any tool that will enable setting the statuses like read-only,
archive, etc ?
--
___
REUSE
Yeah, ColdFusion
Really? How?
I don't mean reset lastModifiedDate to Now() just by overwriting the file.
I mean set lastModifiedDate to ANY date-time value.
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
Does anyone have a list of keywords or code for detecting if a request
is coming from a mobile browser?
I don't know, but I think that testing the total screen width should be
accurately enough.
--
___
REUSE CODE! Use custom tags;
See
Hi,
I was tired of not being able to use CFDIRECTORY because of many flaws
in the way it was designed and implemented.
So I made CFX_ListDir as a more accurate and more versatile replacement
for CFDIRECTORY ACTION=list
Those interested can see its description here:
an algorithm called Soundex
Yeah, but soundex is not a panacea either. All what matters with soundex
is the first syllable;
after that, about anything will match.
It might detect Martine and Matinez as being the same, but Martin,
Martinovitch and Martinelli as well.
So anyway, some human
901 - 1000 of 2701 matches
Mail list logo
