My guess is that it's an encoding problem. Use an HTTP sniffer/recording
proxy/whatever to see what's different.
Yeah, this is what I suspect also.
I'm considering using another format to access their geocoder.
Thanks.
--
___
REUSE CODE! Use custom tags;
good content for better search indexing.
And also, being referred by sites having a high rank will increase your
rank.
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address:
Ok, how about this, a bit ugly, but should work on any database:
WHERE
(YEAR #form.from_y#
OR (YEAR = #form.from_y#
AND (MONTH = 0
OR (MONTH = #form.from_m#
AND (DAY = 0 OR DAY = #form.from_d#)
AND
(YEAR #form.to_y#
OR
delimiters=crlf
You're using crlf as delimitior?
No wonder c, r, l f are lost.
You probably meant CR LF, but these are not the delimiters used to
separate field values, the simple comma is used.
So just use
Faculty Supervisor: cfloop list=#form.fac# index=f#f#/cfloop
or more simply:
Faculty
Is there a list of all possible delimiters value?
There only one delimiter: the comma, which is the default delimiter for
all list functions, so you don't need to specify one.
--
___
REUSE CODE! Use custom tags;
See
Is there a list of all possible delimiters value?
If you want to know more about forms and how values are passed, use
CFDUMP var=#form#
in your action template and you'll know everything a young lady should
know before wedding ;-)
--
___
REUSE CODE! Use
the javascripts must be included right after the opening body tag.
Are you sure they really specify right after the opening body tag
or do they just mean inside the body tag?
I cannot think of any valuable technical reason the Javascript couldn't
be right before the /BODY tag.
--
to be sure to count the page in the event that a user clicks away to
another page before the current page is fully loaded.
Ah ok, now this is a valuable reason I didn't think of. ;-)
--
___
REUSE CODE! Use custom tags;
See
I'm thinking about changing from using auto-incrementing integers
to CF-generated UUID's for primary keys in my mysql db's.
Keep in mind that primary keys are by definition indexed, and in order
to maintain an index,
keys are compared to others. Now comparing to numbers takes only one
machine
Hi,
Has anyone succeeded getting the Google geocoder to work underCF5?
I have my API working fine under CFMX, but under CF5 Google keeps
returning code=610
meaning invalid key.
My API calls the geocoder through CFHTTP.
--
___
REUSE CODE! Use custom tags;
See
How about:
and YEAR = #form.from_y# and YEAR = #form.to_y#
and ((MONTH = #form.from_m# and MONTH = #form.to_m#) OR MONTH=0)
and ((DAY = #form.from_d# and DAY = #form.to_d#) OR DAY=0)
--
___
REUSE CODE! Use custom tags;
See
Try searching for dates between 10/15/2006 and 04/14/2007
See the problem?
Yeah, my answer was a bit too easy ;-)
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL
Show us your code.
Well the code works under CF 7 and not with CF5, so I suspect it is
something like Google expecting UTF-8 in headers
or something like that.
Any way, the code is:
CFHTTP
URL=http://maps.google.com/maps/geo?q=#q#output=xmlkey=#googleKey#;
METHOD=GET RESOLVEURL=false
I doubt
Round might round down;
Well, as far as I know, this is what round means, no?
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
put the table holding the images on it's own file group
back that up separately from the main db. you do not have to back up the
images
along w/the rest of the data.
This is true until some one adds a new image to the database, then the
whole table
with all the images will have to be backed
But, you didn't take into account the amount of time it will take
to backup the file system.
What's important is that images are generally not modified, only added
or deleted,
so only new files will have to copied into the backup.
Is the images are in a table, the whole table will have to
Some databases can automatically extract metadata
(EXIF, for example).
Now this is completely ridiculous: if you really need things like what's
in EXIF, you extract it first
and store it in an appropriate record about the file, just as well as
width or height etc.
This does not justify storing
In my opinion, a database is used to organize related data. In this
case, a binary file would be related to its metadata that you would
normally store in a database.
Michael, if you have a table to organize data related to employees, will
you store the employees in the employee table?
--
Is it better to do a file upload, or better to insert to the database?
The basic idea of a database is to organize data in such a way it can be
searched and sorted.
In principle, there is nothing to be searched or sorted in an image, so
put it in the database
will just add an overhead on the
In my opinion, a database is used to organize related data.
Right.
In this case, a binary file would be related to its metadata
Right, the *file* is related, but nothing *inside the file* is, so you store
a reference to the file (ie; file name) in the database, but not what's
inside the
* Rollbacks of failed data transactions won't leave orphaned binary
files.
You have to store the file on disk anyway when it is uploaded.
If you also store the file content in the database, FIRST you have to
copy the file
from its temporary location to the database, which is an extra overhead
Look at the code. If you can read it easily and understand it, this is
fine, because
what ever you choose, soon or later, you will have to modify it, correct
a bug,
add some new feature, customize to fit your specs, anything.
Some libraries are pure jewels on an academic point of view, work
Is there any *WYSIWYG* editor for one of these?
WYSIWYG? For Javascript code?
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
There is really nothing you can do to stop them.
Te prevent them, you're right, but you can definitely stop them, right
after the first attempt:
Ban the IP!
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
Something like what spry extnesions do in DW.
Personally I never understood the need for this:
Just have your browser on the page you're editing, update the file,
refresh the browser.
--
___
REUSE CODE! Use custom tags;
See
That is very interesting. Have you run into these a lot? What do
these look
like?
I'm having such attempts about a dozen every day, all from different
hosts, but
all with the same user agent:
Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727;
..NET CLR 1.1.4322)
I
Thanks all for your replies.
These solutions are implemented in very complex framework.
So I,m trying to understand how the solution works and implement my own
version.
I'm trying to keep my applications simple, my AJAX function is just
about 12 lines long.
I already have a solution working
checkout Really Simple History
Thanks, I found this one too. But it's still not as simple as it claims.
I'm getting the details here:
http://ajax.suaccess.org/options-and-efficiencies/fix-the-browser-back-button/
and I'm implementing the solution to my own ajax solution.
--
Thanks for a quick response. It does work however if I add body as
another
regex, the head section shows up in body. e.g.
Hi,
this is definitely a job for CF_REextract:
See http://www.contentbox.com/claude/customtags/REextract/testREextract.cfm
You can test it here:
For those who may be interested in the solution, I finally found it:
The solution is NOT USE AJAX!
Use the Remote scripting with hidden Frames instead !
100 times simpler!
In your main template
1. add an iframe in your main page, that will not display ie:
iframe
do you see a clear 'flaw'?
Sure!
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
Hi,
Ajax is a nice feature, for instance when only some part of a page must
be changed,
one can populate some internal DIV instead of reloading the entire page.
But the problem is when the visitor hits the back button: he then
doesn't get back
to the previous sub page, but to the page he
Would this be the best way to do this? Other ways?
In my CMS, there are several items the user can choose the order he
wants, ie. paragraphs in a page.
In order to do so, he has a list of all of them and he can move them up
or down (Javascript).
On submit, a list of items is created in order
I'm guessing the Javascript automatically assigns new values
to the hidden field for seq for each paragraph upon reordering?
Not exactly.
I use a table to display elements, each one in its own row TR element.
I use some move up and move down function to switch two TR element in a
table.
The row
but it becomes a pain for the user when they want to move an item (an
agent, in this case) several slots up or down.
Exact.
I favored the arrow method because pages have only a few paragraphs in
average.
For my menu editor however I use the drag'n drop method.
--
The problem is that when i try to refer to the form name
in any CF template
I may be wrong, but AFAIK, the form name is not transmitted by HTTP, it
is only available to
Javascript on client side.
Even if a page contains several forms, only one can be submitted at a time,
and all its fields are
If i make a hidden field and put the ID
value in there, Wouldn't the name of the field be the same for every
form?
Not if you're wise enough to use a separate hidden field with a
different id for each form ;-)
Keep in mind that only ONE form gets to the action page.
--
Mid(getdon.recordcount,2,1)
This will in fact return the second digit from the left, same thing only
for 5 digit numbers.
For the third digit from the right
I would rather use this:
CFSET digits = left(right(getdon.recordcount, 3),1)
___
REUSE CODE! Use
That said, what do *you* do to fail gracefully
I do not fail gracefully, I counter-attack aggressively ;-)
This is my code at the beginning of any template that relies on some
numeric url parameter.
but it can be easily adapted for any kind of string parameter.
!--- Check if id contains a
Is this possible?
With cross compatible code, the answer is no.
If you use Explorer, you will have to make some ActiveX component to do so.
provided the use will accept to load it.
--
___
REUSE CODE! Use custom tags;
See
I'm using the following URL and working to obtain all the image
absolute paths:
May be you should have a look at CF_REextract :
http://www.contentbox.com/claude/customtags/REextract/testREextract.cfm
It will save you lots of coding, and could even CFHTTP the file for you.
--
I'd never heard of CF_REextract.
You should visit us more often ;-)
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
they both have the file name and no directory information can be found.
I'm surprised there even exists a cffile.clientDirectory variable, since
this information is never
provided by any browser. If it was it would constitute a serious breach
in security.
--
Hence it seems that it would have had to know where to get the file
from (i.e. the client's directory and file path).
The server does not get the file, the client sends the file, therefore
the server does not need to know
the directory name.
The server gets the file name, but this is just
Have you seriously looked at what Ext offers?
What's Ext ?
--
___
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 saw FCKeditor and it claimes to be the best.
And it is probably the best, but that's the problem: it is far too best
to be used by low end users. IMHO.
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
3. Use something else that's not integrated.
4. develop your own ;-)
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
For no apparent reason, emails stop being sent by CF.
I'm having this problem about once a year.
The problem is cause by an invalid file in the spool. I mean a file that
contains no information that could
make a valid message. This causes the spooler to loop indefinitely on
the problem.
The
Well, one of my users insists he is uploading a pdf
It may be in PDF format, but does it have a .pdf extension?
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL
CFPARAM NAME=myVar DEFAULT=233 HINT=myHint
What would be the advanteage over simply using
CFPARAM NAME=myVar DEFAULT=233 !--- myHint --- ?
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam
Everyone keeps talking about SQL injection this, and SQL injection
that, but
I would like to see some examples.
Exact, and also all the examples I've ever seen suppose that an extra
SQL statement is added after some ; character.
This won't work with an Acces database, so Access databases are
but I don't think everyone will use that as a rationale to switch to text
based data storage
My intention was not to give the advice to switch to anything, just to
mention
that if someone is using an Access database, may be mostly for simplicity,
he might not worry that much about SQL injection
Either way, use cfqueryparam. It makes injection attacks impossible
Personnaly, I not only defend my sites against SQL injections, but I
definitely close the door.
When I have a parameter in a query which should be numeric, like ?id=...
I use this test:
CFIF val(id) EQ 0 AND (id CONTAINS http
But I am still in the old 4.0 days.
Gee! Are you related to Rick Faircloth? ;-)
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
I need some help with regular expressions.
What you need is the kind of requirement I made CF_REextract for.
See http://www.contentbox.com/claude/customtags/REextract/testREextract.cfm
~|
Adobe® ColdFusion® 8 software 8 is the
Use robots.txt:
This is correct to control good bots, but bad bots don't read it.
Some (very) bad bots even exploit what is in the file to read what's
forbidden.
~|
Adobe® ColdFusion® 8 software 8 is the most important and
Once I started reviewing rankings, I found that my development
site was ranking higher for the content than my client's main site!
Not good!
Exact.
But robot control is not something trivial.
Firstly, there are true and friendly robots, like Google, secondly,
there are bad bots, looking for
If he is simply
trying to prevent search engines from indexing certain folders, he should be
fine?
Let's say 50% fine, since bad bots (may be 50% of all robot traffic) do
not even care reading robots.txt
~|
Adobe® ColdFusion®
The transaction won't actually isolate you from a race condition.
Not if all applications use the same template for the transaction.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the
You should only have
to copy structures by value (using either StructCopy or Duplicate) if you
want to maintain two separate structures, so that changes to one don't
affect the other. That is not the case here.
Ok, I see what you mean, but if you do it this way, won't the
session.form structure
You shouldn't have to duplicate the form. Just copy it into the Session
scope.
I think I tried first with structCopy ans encountered some problem, I
don't remember
which one, so I changed for StructDuplicate. This was years ago.
Anyway, since the form scope is not supposed to contain
When the first bat file is executed, the default drive/directory are
where CF is running,
not where the bat file is stored.
So you should also set the drive and directory correctly before calling
the other bat files.
~|
Adobe®
Stick the form in the session scope maybe?
Definitely:
To save the form:
CFSET session.form = Duplicate(form)
Then in the form action template:
CFIF isDefined(session.form)
!--- For some unknown reason, duplicate() doesn't work here ---
CFLOOP COLLECTION=#session.form# ITEM=field
but the object will remain in the heap because it has another reference.
Ah ok, I see.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
I check the file name and see if it already exists in the database.
If it does, then I return the error. If it doesn't exist, then go and
perform the cffile action.
This is the way you see it, but not the best and easiest way to do it.
This is the way I do it:
- upload the file and rename it on
Is there anyway to configure the CF to run a scheduled task every
M-W-F at a
specified time?
Schedule the task for everyday, and have the task check for the day and
CFABORT on bad days.
~|
Adobe® ColdFusion® 8 software 8 is
The progress bar reflects real state of upload (the vault opens an
additional connection to receive info from server about upload progress)
In this case, the system must know how and where the HTTP server stores
the temporary file while it's being loaded.
So there should be different version
i believe Claude meant a date picker
That's it! Date picker! ;-)
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
so we first check with input mask US and if it says invalid date then
we pass in input mask EU and if it works
Good point.
But this is not really 100% proof, since some dates may be valid in US
format, although they were meant in EU format.
Take 10/11/2008 for instance.
So the date may be
thanks again for all your help claude
You're welcome, and congratulation for you wise shopping ;-)
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
07/24/1978 is an invalid date format
Ok, now I see what your problem is:
If you're using LSdateFormat, the function (and here is the difference
with dateFaormat)
expect a date. Since 07/24/1978 is not a date, but a string, CF will
try to convert it to a date,
but according the English (UK)
it seems to me that lsdateformat function takes an english uk
formated date (dd/mm/)
More precisely, I would say it takes a date in the default locale
format, or the locale previously defined by setLocale()
If your server is English, then yes, you are right.
For servers un US, it will take
IN NO EVENT WILL ZILLOW.COM OR ANY SUPPLIER BE LIABLE FOR
ANY DAMAGES
I'm sorry, but just from the very begining, this statement has
absolutely no value.
I hope you didn't pay a lawyer to write it.
Nobody can state, in advance on not that he is not liable or responsible.
ONLY a judge in court
I don't just want:
permit info,company1
permit info,company2
Why not? If you use the GROUP attribute in CFOUTPUT,
you can make your query really look like
Permit Info
1-Company1
2-Company2
--
___
REUSE CODE! Use custom tags;
See
Then, I sign up for your church's web site and use the same username and
password combination. Now, if someone sniffs that unsecured connection,
they now have my bank username and password.
Ok, but it is not the church responsibility to protect you bank username
and password.
It's your
But the church is also asking about an encrypted connection using an SSL
certificate.
What a meanness! Don't they have some sort of divine protection already? ;-)
--
___
REUSE CODE! Use custom tags;
See
Is this a legal syntax in ColdFusion
Yes it is. And you can even keep all those [EMAIL PROTECTED] dollar signs in
front
of all variable names ;-)
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send
Of course users may not desire the warning about an untrusted cert
and this can be worse than no protection at all.
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address:
In a world of paranoia, SSL is *NEVER* overkill for protecting logins
of any kind.
provided you assume paranoia...
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address:
And how do I adjust the timeout for it? In the template? Somewhere
in CFAdmin?
In CFAdmin, you have a Timout field you can set.
If you schedule the task from CFSCEDULE, this parameter is transmitted
though the requestTimeOut attribute.
--
___
REUSE
Is there anybody out there who can help me do this?
Sure, there is CF_REextract.
It will return all your fields in a list or a query, and even read the
file for you.
See: http://www.contentbox.com/claude/customtags/REextract/testREextract.cfm
Too few parameters. Expected 1
This usually means that one of the column names is erroneous.
Password might also be a reserved word.
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to
Is the SSL encryption overkill for something like this?
IMHO yes.
Unless they are willing to pay for more protection, because it is not free.
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any
doesn't access prefer double quotes?
(getUser.UserLogin = paulw) AND (getUser.Password = 2324986)
It can take both.
Anyway, this is one of the task of the ODBC OR JDBC driver to translate
SQL command
into local db dialect.
For instance, Access needs #...# around dates, but you don't have to
I'm pretty sure you don't need to use all that concatention.
But he still needs preserveSingleQuotes.
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Also beware of quotes and double quotes that may interfere with CF, SQL
or HTML statements.
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
cfif IsDefined(evaluate(form.grp_sort_#myIDX#))
Iiiirk, you're having quotes inside quotes and # inside #... :-(
Try this instead
cfif IsDefined('evaluate(form.grp_sort_#myIDX#)')
Anyway, I doubt this will work: evaluate will either return the value of
form.grp_sort_#myIDX#
if it is defined,
i have just tried it by using dateformat instead of lsdateformat and
it worked fine.
Again, WHERE does is work, and WHERE doesn'it ?
If it is in an UPDATE or INSERT SQL statement, it may work, or not,
depending of the way CF will interpret the data as a date.
In SQL, you should always use
i have dates stored in a mysql db which is in the format /mm/dd
First of all, unless your date field has text type and you store the
date as a string, the db format is not /mm/dd.
It is some floating value specific to the database. Some early db
systems would store it as a string
we use mysql 5.0 and it does store the date as /mm/dd.
This this actually how your database will *display* the date, but
internally, it is stored as a 3 bytes integer value.
(see http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html )
But are you sure the field is defined as a
I think that the dateFormat() functions will consider any string
passed as a
numerical representation of the date unless it's quoted.
All CF function will take ANYTHING, strings, numerics or dates (which
are float values anyway),
if it can be converted to a date, CF will convert it prior
So it definitely seems like CF treats the input differently somehow.
Not really.
CF is a typeless language.
It is SGML compliant and HTML compatible.
So by definition, EVERYTHING is passed as a string in attributes, even
if there is no quotation mark.
For function calls, it is a bit
so I assume it differs somehow.
Well, there is actually a difference:
If you pass the date as a date to dateformat(), ie:
dateFormat(now()...), there is no ambiguity.
It will always work.
However, if you pass it as a string, CF will have to convert it, and if
you work with dates in ISO format,
The guy from leftcorner.com (offline) ported a bunch of CF functions to
JS. I still have a copy. Pretty handy.
Pretty handy indead.
Javascript looks like a retarded language when dealing with strings.
Thanks.
--
___
REUSE CODE! Use custom tags;
See
that's not to say there's not a simple way tho.
The only other way I can think of is using regExp, but not really simpler.
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address:
There's nothing wrong with storing images in a modern RDBMS.
Except may be people having problems and asking questions in forums ;-)
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to
I will then import the tab delimited info and property filenames into
an MySQL database, and place the property photos into the appropriate
local server directory.
Are you under Windows?
The easiest (although not trivial) way to do it is to define an ODBC DSN
using the Microsoft Text Driver
Interesting approach. Is there someplace I can read up on this approach?
Dunno, I managed to set it horsing around with the ODBC manager in Windows.
See Administrative tools -- ODBC manager.
You must have a special directory dedicated to your .csv files, then you
set your txt csv ODBC driver
I was sent with the property information and I didn't see any
column names in the info.
It might be a problem, unless there is a possibility to set the ODBC
connection not to use the first row, I don't know.
But since you get the file by FTP, you can still append it to a one line
file
You don't check in FireFox (20%+ of Europe uses it) ?
I was speaking about my own customers.
In average and roughly, their sites are visited at 80% by MSIE, 10%
Firefox, 10% others.
But 100% of the administrators are using MSIE, and none is in Europe.
So I FIRST check for MSIE compatibility.
401 - 500 of 2701 matches
Mail list logo
