require me to replicate the rows many times depending on the amount of
records in the database.
Not trivial, but feasible.
I have done some work where I generate congress badges with many fields and
even images like logo and photographs.
Open Office is definitely not a solution. I've never
Can you see any other easier way we could achieve this?
Yes:
identify each field with some string,
Close the document in RTF format which is a pure text file,
then read the file and search-replace the fields by their values.
The result is readable under MS Word.
Any suggestions on anything else I can look at, or what steps I can try?
Have you checked the date on the server? It might have been reset to
1998 or so.
~|
Order the Adobe Coldfusion Anthology now!
Hi,
Is any one aware of some utility that would decode RFC 2047
encoded-words, like message subjets, under CF 5?
Thanks.
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of
Are other people seeing this?
Same thing here.
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
Simply define an ODBC datasource using the Microsoft txt ODBC driver.
Then requst the datasaource to get all records.
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion
thanks for your help
You would have better help if you show us your CFDOCUMENT tag.
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
I want to display (print) the description on subsequent CFM pages.
Well, print and display are two different things.
Do you mean that the characters look ok when displayed in a CF page and
not when you print the same page from your browser?
I'm processing DB columns with text containing #8211; and #8212;.
This means you are storing HTML code in your db text fileds.
By doing so, you are not supposed to use these data for other purpose
than HTML rendering.
If you need to use them for other purpose like generating text under
some
The characters look like glyphs when displayed in the browser. But,
the actual DB content has #8211;/#8212;. This text will only be used
for display on a CFM page.
Then like Paul said, the font used when printing has probably not those
glyphs defined.
You have double quotes inside a double quoted string in
[##%/\\*?|:$'@,(){}~`^!+;=[]
Try using '[##%/\\*?|:$'@,(){}~`^!+;=[]' instead.
Further more, you should escape special RegExp characters like []{}(),
etc. like \[\]\{\}\(\), then try :
'\[##%/\\\*\?\|:\$'@,\(\)\{\}~`\^!\+;=\[\]'
Here is the format of the cell: Smith, Jim
I want to end with jsmith
How about this:
CFSET cell = Smith, Jim
CFOUTPUT#LCase (left(trim(listLast(cell)), 1)
listFirst(cell))#/CFOUTPUT
provided that cell is always a list of at least two names.
Hi,
Can any one recommand a good command line video converter for Windows
that could
- be executed from ColdFusion (any command line converter should do it)
- convert to FLV Flash format;
- retrieve metadata from input file like duration, original width and
height;
- extract thumbnail images;
Get the size however I'm not sure. I haven't had a reason to work
with that sort of thing,
Well, the reason is simple enough.
I can resize the flash player to any size, but the best is to start with
the original size of the video.
Hi,
I have a content management system on a CF 5 server.
A couple of customers asked me to put some videos on their site.
They all come up with different solutions and implementations for Flash
players, ActiveX players, etc.
It is out of question I implement a different solution for each
OpenBD uses FlowPlayer, which is actually pretty slick:
Pretty clean and simple indeed.
And the domain name unlimited licence is most convenient also.
Just one question: do you know if it is possible to get the actual width
and height from the flv file
in order to adapt the size of the viewer
Getting this on a query.
Define Getting. Where are these values displayed?
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
wrap dateformat() around the dateadd() function.
NO. createOdbcDate expects a date value as a parameter.
One should never submit a formated date to this function,
the date will be de-formated anyway, with the risk that the format is
not compatible
(ie: european date format).
BSC here, in math/physics, and MSC in computer technologies.
Actually, CF may be the 20th language I learned and used.
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion
It seems that NEQ or is not doesn't care about case.
Exact. Use the Compare () function for case sensitive comparison.
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion
The Invoice will not change
This is absolutely true,... until the guy who said it will not change is
changed ;-)
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion
what are your experiences of the above and others?
The best library I ever used is the one I developed myself over the years.
1º it contains about everything I need;
2º it does not contain anything I don't need;
3º it can be enhanced easily any time.
(c) What the hell are they doing?
Some will search for copyrighted images and, if they find some, they
will send you some lawyer letter
with a bill of 1500$ or so for using their image. (ie: Getty images,...)
Most of them are simply looking for email addresses they could collect
and sell to
in case it's a search spider, you can try adding appropriate robots.txt
robots.txt file may be useful for well behaved robots like Google or
Yahoo, but bad bot disguise themselves
like Explorer or Mozilla and they do not comply to robots.txt
directives.
Most of them never read it, and some of
lets say we have 650 elements in our list.
split them into seperate lists with a maximun of 100 elements.
I just showed you how to do it in the message you are replying to.
The example will work on any list of any length.
remember, each list must be in a variable
Which variable? I could
i need to have the values of each sublist in variables
How about hving them in a list of lists? Then you could get each sublist
pretty easily.
Try this:
!--- Create a 1000 elements list ---
CFSET thelist = repeatString (0,1,2,3,4,5,6,7,8,9,, 100)
!--- Replace every 100th comma delimiter by
How do you split this list into equal lengths of 100?
1. make a function to split the list into the first 100 elements and the
rest.
2. loop on the rest until its length is = 100
~|
Want to reach the ColdFusion community with
Hi,
I've been using the same coldFusion 5 server for about 9 years with no
problem.
Suddenly the scheduler started acting crazy: all task are reexecuted
every 2 min.
starting at 00:00.
It happened twice in a couple of weeks.
Any one ever seen such an issue?
The slashes here are not needed:
Right, I had a problem while testing and I thought slashes were needed,
but the problem was somewere else
and I forgot to remove the slashes.
~|
Want to reach the ColdFusion community with
cfset thelist =aa,bb,cc,dd,ee,ff,uu,vv,ww,xx,yy,zz
What would be the most efficient way to split the list into two lists,
Try this :
cfset thelist =aa,bb,cc,dd,ee,ff,uu,vv,ww,xx,yy,zz
CFSET st = REFind (([^\,]*\,){6}, thelist, 1, true)
CFSET list1 = mid(theList, 1, st.len[1]-1)
CFSET list2 =
I'm not sure if your method is quicker
IMO, the longer is the list, the quicker it will be.
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
Hi,
I have a CF 5 server, but I never use Remote Development, so I don't
need the RDS service.
The service is disabled in the Windows services.
However I get this line every 2 seconds in the executive.log:
Error,1716,09/28/09,16:21:15,,Unexpected Windows NT error
number 1058 occurred while
... other than stopping the Executive service as well.
Which of course I can't do, or all scheduled tasks won't run.
I recommend you simply disregard these errors as they are harmless.
No, they are harmless, except for building a hudge file for nothing.
I have to remember to delete it from
All that said, you should be able to do this from CF in
Application.cfc/cfm, which could be shared across multiple websites if
you choose to set it up that way. Just look at CGI.REQUEST_METHOD.
Yeah, this is the way I finally went.
Especially that I can use the same code to return errors to
Have you tested this?
Actually not really tested, but at least experimented.
Sometimes I get errors in my error log table caused by pages requested
with OPTIONS or HEAD.
Apparently, the CF template is run just like the method was GET.
The error is actually caused by url parameters that would
The question was to detect a user's OS and its CPU architecture
I don't know about your CPU architecture, but I'm pretty sure about what
you smoke ;-)
~|
Want to reach the ColdFusion community with something they want? Let
Hi,
I recently found in my error logs a request to a page using
METHOD=OPTIONS...
I didn't even know this couls exist.
Apparently, thes requests are sent by Microsoft Office, in this
occurrence, while receiving some CSV file.
This caused an error in my system because no parameter the template
Thanks for tis clarification.
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
Just a word of warning - PUT will in fact place a file on the webserver
Ok, but I do not need this feature.
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing
(I don't know how many CFers do that).
Not me anyway ;-/
IIS Manager Right-click the website Properties Home Directory
tab Configuration Button Mappings Find .cfm, .cfc and any other
extensions that you are worried about for CF Edit Verbs: Limit to ...
Ah ok, and I enter a list
script src=http://bgadf.cn/script
Arg... chinese junk again :-(
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
I can see mostly two reasons:
1. an infinite loop, this would be in your code,
2.. some memroy leak, this would be some in other's code.
~|
Want to reach the ColdFusion community with something they want? Let them know
on the
... hmmm, a memroy leak is not good, but a memory leak is even worse ;-/
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
I'm running batch files using pkzip25.exe.
I may be wrong, (DOS is far away), but aren't batch files supposed to
contain some sort of exit command,
otherwise they may stay waiting for some one to enter the next command ?
~|
Hi,
From time to time, I find in my error log errors due to undefined form
variables.
The reason being that the template was requested using method GET
instead of POST.
Of course, there are dumb bots that would GET any address they find in a
page,
but there are also true visitors, even
One thing though, if the values are showing up in the url then your form
itself must be using GET, otherwise they wouldn't show in the URL.
I thought it was clear in my initial post that the form was indeed
submitted using POST.
and of course I do validate the values received.
The problem is
request.data = url;
StructAppend(request.data, form);
This will work if the GET request transmits the form parameters in the
url instead, but it is not the case: the url contains no value.
~|
Want to reach the ColdFusion
After processing the form, redirect the browser (302 redirect,
cflocation) to the 'thank you, your form is submitted' page.
Good point, except many times, the input process is not finished.
There may be 4 or 5 steps of form to fill before I can say thank you.
Not really simple to pass all
Create a required variable and use that to redirect them back to the
form.
Redirect them back to the form was indeed what I intent to do.
However, testing CGI.REQUEST_METHOD NEQ post seems more logical.
~|
Want to reach the
ive put in in the following place but its not doing anything
To my knowledge, the TEXTAREA tag takes no MAXLENGTH attribute, on INPUT
tag has one.
~|
Want to reach the ColdFusion community with something they want? Let them
Most of the companies I work for INSIST on *everything* Microsoft
because in their eyes, *only* Microsoft is suitable for stuffed shirt
corporate work.
True, And IMHO the only reason is the incompetence of managers.
The bigger the organization is, the higher the decision maker is,
And the
I don't know the processor and its capabilities
This is too bad, because I would say that the performance will mostly
depend on the speed
of the processor, and the amount of RAM it has.
~|
Want to reach the ColdFusion
Do you see any potential security issues with this i.e. sql injection
via the email
As far as SQL injection is concerned, the risk is pretty low with an
Access database, since it cannot process
multi-statement SQL command. Unless there are tricks I don't know, all
SQL injections are based
on
is there a function to do this in a line of code
Try this:
MyList = RepeatString(,VarChar, arrayLen(MyArray))
The comma at the begining will be considered as an empty element
which is ignored by CF.
However, if you rather have a clean list, use this:
MyList = mid(RepeatString(,VarChar,
Yet another solution, assuming that the array length is at least 1:
MyList = VarChar RepeatString(,VarChar, arrayLen(MyArray) - 1)
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House
Can anyone please help me in knowing what is causing this problem?
May be some redirection in some /Trying/Jsonlearn/Application.cfm ?
~|
Want to reach the ColdFusion community with something they want? Let them know
on the
The client I'm doing this for is only willing to part with $450.
For that price, I would advise him to do it himself, it will be even
cheaper.
~|
Want to reach the ColdFusion community with something they want? Let them know
Making $450 doing something beats making $0 just sitting around.
Well, if you have nothing to work on, there is still something better
that sitting around:
looking for other customers!
~|
Want to reach the ColdFusion
PS not responsible for keyboard damage!
You bet: my dog went crazy, jumped over the keyboard and scrapped my
liquid plasma screen!
~|
Want to reach the ColdFusion community with something they want? Let them know
on the
An attack can be made
to inject SQL on a CF application using CFQuery that cannot be prevented
with cfqueryparam.
Well... it depends what you mean by SQL injection
One thing CFQUERYPARAM cannot prevent is inserting malicious content in
a text field,
like links or simply reference, to porn
2) could prepared statements have an adverse effect on performance?
On readability, yes, but certainly not on performance.
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of
No, they can certainly have a bad effect on performance.
I must admit two things here:
1. I was more quoting many people here about performance than giving my
own experience,
2. personnally, I don't like CFQUERYPARAM, I use it only when really
necessary, ie. only on text fields
coming
Store them outside of the webroot and use cfcontent to serve them to the
browse when necessary.
Some people have no access to folders outside the webroot.
In that case, one solution is to :
1. register all files in your database with their original name and type
(pdf, doc, etc.)
2. store any
any other idea without cfcontent ?
Nope.
Any solution to give access or not must be based on some CF code to
abort the request
if the user has no access, or send the document if he has.
And the proper tag for CF to send the document is CFCONTENT.
As Dominic said, putting the entire sql statement in as a variable in
ColdFusion isn't necessary.
Please, there IS a very good reason one would put an SQL statement in a
variable:
when using some tool to generate build queries for instance.
I have many examples in my own CMS, like a report
And with preserveSingleQuotes() you have to hope you're better at
cleaning input than hackers are at writing SQL injection.
When I'm talking about a CMS, I'm talking about some tool some customers
have paid for
and that is only accessible by approved users with authentication.
Now if they want
Internal security problems are far more common than external ones.
Within a large organization, not all users may be trustworthy.
C'mon, if they are users and they have access to the system, if they go
crazy,
do they really need SQL injection to harm the system ?
They can simply delete all
With XSS they can do that while making it look like someone else did it.
Probably, but my clients barely know the difference between a computer
and a toaster,
and I spend more of my time explaining them that in order to press
Ctrl, they must find a key
on their keyboard with the letters Ctrl
Also, you talk about this like your speaking of only internal
applications
or applications that could never go on a production environment.
Indeed, we were talking about building SQL queries in a variable inside
a Content management system.
Of course, for parts of the site exposed to public,
In order to query MSysObjects you must have some permissions set in the
security settings
of the database.
If you have CF 8, you should also be able to use CFdbInfo.
Otherwise, there is still CFX_ODBCinfo:
http://customtags.internetique.com/ODBCInfo/E/TestODBCInfo.cfm
which is not free, but
does it clear the vagueness?
Hmmm I hardly imagine an inventory system which is not part of some
product management system.
In order to make an inventory, you need a list of products.
So what you are looking for is rather some store or warehouse management
system.
If you already have
Most of these Ajax features are pretty bloated in terms of the amount
of JS
and CSS that need to be downloaded.
Exactly, personally I do all my Ajax with about 15 lines of code ;-)
~|
Want to reach the ColdFusion community
Are you talking about using non-cf8 built-in ajax tags or ajax
functions that you built on your own using popular js libraries?
First I usually develop my own Javascript code with ONLY the features I
need, and try to avoid popular libraries,
secondly I do not need custom tags to use
If so any ideas on the best way to achieve this?
Simply use CFIF tag and now() function.
You'll be able to generate or not any code whenever you need.
~|
Want to reach the ColdFusion community with something they want? Let
MS Access is fine for basic office use, but for web apps you're
better off picking Derby, H2, MySQL, Postgres, etc - or one of the free
'Express' editions of Oracle or MS SQL Server.
Legend, pure urban legend !
Access applications have a bad reputation, but do not forget that
accessing an
There is very few reasons why you would want a Web App with Access.
None of them that I can think of would be useful in a web app that is
worked on by 2 or more people (which most web apps are).
1. Access is not sensitive to SQL injection.
2. Only one file for the whole database, the whole
now if I add 'GROUP BY clust' then it gives an error.
Where do yo add the GROUP BY clause ?
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
now if I add 'GROUP BY clust' then it gives an error.
In a GROUP BY clause, you must enumerate all fields in your SELECT
See :
http://msdn.microsoft.com/en-us/library/aa259187(SQL.80).aspx#_group_by_clause
~|
Want to reach
ID and SITE will always have unique values no duplicates allowed.
Ok, but you still have to list all columns in your SELECT list, it is a
matter of SQL syntax, not logic.
In pure logic, a GROUP clause should be enough, since one has no choice,
but this is the way SQL has been designed.
Microsoft Access is terrible.
Well, yet another legendary Access database bashing :-(
Access database are GREAT for any small/medium web application.
Most databases implement the string comparison to be case insensitive by
default.
They also have provisions to change it either globally or
the COMPARE function should do the trick for you.
The COMPARE function is a CF function. What is needed here is an SQL
function.
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House
Anyone have recommendations for CAPTCHA?
Yes: don't use captcha. Users hate them.
what other programming can be used to figure out if the submission
was done by a human?
-Add some hidden check value by javascript on submit. I don't thing many
bots execute correctly Javascript.
- Add some
Thanks all for your suggestions.
I also received this one from my server host support : MailEnable
Any one aware of it ?
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion
Hi,
For this type of parsing, you should have a look at CF_REextract:
http://customtags.internetique.com/REextract/testREextract.cfm
~|
Want to reach the ColdFusion community with something they want? Let them know
on the
Hi,
I'm moving my CF applications to a new dedicated server, and I need to
both send messages and receive,
for several users under several domains.
Any suggestion ?
~|
Want to reach the ColdFusion community with something
Another solution is to assign files with extension .txt to CF as well.
Then CF will be able to generate correct paths.
Unless you have very large other txt files that would then been parsed
by CF as well and consume too much time.
Hi,
I'm considering moving my application to a dedicated server.
The package includes Windows 2003 or 2008 at the same price.
Is there a major difference, as far as CF is concerned.
Memory requirements?
Performance?
~|
Want to
anyone got any idea , what is going wrong
Sure ! There must be some error in the submitted template...
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing
Hi,
I have a new customer for whom I must import most data as I can from
their Filemaker Pro database to my own CMS.
I plan to import their data (mostly tables for members and
organizations) into an Access database, then work from there and collect
what I can.
Has any one here some
There's a driver that's included with filemaker and several available
on the web. Simply install the driver on your copy of CF and create a
datasource.
Ok, but then I still need to install the Filemaker database on my
development server.
Is it possible to just copy one file, like with an
I doubt this is feasible, however youd would certainly have more
accurate answers from the Mozilla forum:
http://forums.mozillazine.org/
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get
i am now wondering whether there is really a need to encrypt the
columns, but instead just to control the access to that data through the
cf application.
You are telling yourself exactly what I was thinking ;-)
~|
Adobe®
yes, a cf app that has alot of security. and only people that have
been given rights to the secure data
Then what's the big idea to encrypt data, if they have the rights to see
it anyway?
If there are columns they should not see, just not provide them with the
possibility to display those
what do you think about this?
First point: if your database is correctly stored in a safe area not
accessible by HTTP, the risk is really low.
If is is stored in an area vieable by HTTP, then so is your template to
decrypt and view data any way.
It's like hanging the key of your house on the
how would i get around the issue of encypting data in integer
columns? - as some of the columns are set as smallint(2) for example.
You need to create an extra column to contain the encrypted value. I
know no encrypting algorithm capable of encrypting a smallint into a
smallint, except may
we appreciate your feedback
Who will be able to open and read your database, and from which
application? Some CF app?
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
First, start by writing standards compliant HTML with a valid Strict
DOCTYPE - this is the best way to avoid most of the browser bugs in the
first place.
Of course, this will work... at least for all visitors having browsers
supporting Strict DOCTYPE with no bug ;-)
1) seeing as this can be run on any column (even integer fields) is
it possible to encrypt an integer and then place the resulting encrypted
string back into the integer column of the database
If the encrypted data is also an integer, then yes, but if is can be any
string, forget it. Not
That's the step the end users try to avoid. They want something on the
fly, letting CF to do the trick automatically after the file is
uploaded.
Have some HTML editor on your site like FCKeditor.
Client opens his Word document;
Ctrl-A, Ctrl-C, back in FCKeditor, Ctrl-V
I think it wasn't free before.
Can the free version be used commercially ?
Or is the soft free, but you have to buy licenses? ;-)
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the
1 - 100 of 2701 matches
Mail list logo