Key words: Feedback, answers to reader's questions, information, assistance, Ron Kurtus, School for Champions. Copyright © Restrictions
by Ron Kurtus
Each day readers send in questions and feedback concerning the various lessons in the School for Champions website. A total of 38 letters have been answered.
|Starting to program in CF||General||USA|
|Problem with ColdFusion dates||Dates||India|
|Submitting variable from a drop down list||Dropdown List||India|
|Date query in ColdFusion||Dates||USA|
|Had trouble with CF to PDF method||Australia|
|What type of database can be used?||Populate Matrix||USA|
|Can ColdFusion be used with MS Access?||General||Republic of Tanzania|
|Sending Flash via ColdFusion mail||Email Flash||India|
|Back button doesn't work on some sites||One Page||Canada|
|Having trouble clicking Back in ColdFusion||Session Variables||Uganda|
|Questions on using session variables||Session Variables||USA|
|Want to develop a data driven website using ColdFusion||Overview||USA|
|Help me to create PDF from HTML||India|
|Where do i download UltraDev software?||Dreamweaver||Nigeria|
|PDF file did not come up||USA|
Starting to program in CF
July 16, 2016
Looking at starting to program in CF what are your rates. I have an old CF web site that really needs TLC right now and eventually rewritten in CF2016 I'm not book savoy but hands on I'm good at learning. I've taught myself HTML 5 and css3 but I don't like PHP and would rather stay on the cold fusion platform.
Allan - USA (27151)
ColdFusion is relatively easy to code, as opposed to doing things in PHP. The big disadvantage is the ISP or hosts charge more to be on a CF server. I use HostMySite, although there are a number of other good CF providers.
The advantage of CF2016 is that it has more "bells and whistles." However, there are a number of Deprecated Features which are no longer available.
I'm upgrading my ColdFusion articles, as many our out of date.
Best wishes in your programmatic with CF.
Problem with ColdFusion dates
July 10, 2012
There are problem when comparing date in coldfusion. It behave differently in same situation. when we compare date some time, it behave like dd/mm/yy format after 12, it behave like a mm/dd/yy format.
Sukhvinder - India (22772)
I'm not sure what would be causing that problem. The date should behave the same, if the same code it used.
Submitting variable from a drop down list
August 5, 2011
can you explain wn querys are executed on cfm pages and above problem..
please reply as soon as becoz this is my urgent req
ramesh - India (21859)
When you select an item from the drop-down list, you send the OPTION VALUE variable to the next page, where your database query will exist. If you selected "Apples", your query could be SELECT * FROM fruits_column WHERE fruit = #form.apples#
"form.apples" means the variable apples was sent from the form.
Date query in ColdFusion
February 19, 2010
simple and clear. I'll try it tomorrow, hopefuly my query wont fail.
- USA (19247)
I hope everything worked out fine for you.
Had trouble with CF to PDF method
January 17, 2008
i have used your cf to pdf demo but i must be doing something stupid as it is just producing the spill and not writing any file.
can you see for me.
i have copied your example to the letter.
Ben - Australia (15155)
The method is difficult to do. Unfortunately, your code did not come through my email system. You can try again.
If your server is CF MX7, you can use the tag:
This makes the process much easier. The other method was a work-around.
What type of database can be used?
November 27, 2007
On several pages you reference a "database"... That's pretty broad, so I am curious just what kind of database you are querying. We have data in MySQL tables - is that something that these scripts can access? If so, how?
Skip - USA (14867)
Beginners in ColdFusion often use a Microsoft Access database. Although easy to configure, it also does not work well with multiple users. MySQL is a preferred database. MS SQL Server db is also often used. We use MySQL.
Using ColdFusion tags and SQL, you can access the various databases, as you would with PHP, ASP, etc. The advantage of CF is there is much less code, so it is easy to program and maintain. The disadvantage is that the server must have CF installed, so the host usually charges extra for that.
Can ColdFusion be used with MS Access?
September 5, 2007
Please, can coldfusion assist in linking the web page to my Ms access database?
If yes, how?
Can coldfusion take care of the security issue?
Rainer - Republic of Tanzania (14352)
Your website host must have ColdFusion installed on their server to allow you to interface with your MC Access database that is also on the server, along with your web pages. By coding pages with the standard SQL code, you can then add, edit and delete information through your web page.
The advantage of ColdFusion is that it is easy to use and secure. The disadvantage is that website hosts usually charge extra to have a ColdFusion site. Not all host companies offer ColdFusion. If you have your website on your own server, you would need to purchase ColdFusion from Adobe and install it on your server.
Sending Flash via ColdFusion mail
March 5, 2007
hey- i tried to send the flash movie as a content via cfmail but it's not
worked for me.I am here giving tried code.Please help me out.
if there is any mistake in the below code ,please correct to me.
manu - India (13309)
The principle is really simple. Take the Flash code that you have generated, and everywhere you see # in your flash code, you replace with ##. One place should be the version number: ##version=4,0,0,0. You probably have a higher version than 4. The other two places are for background color. You MUST replace each # with ## or it will not work.
The next thing is to have an absolute link to where your SWF file is located on your server.
Then send your code with CFMAIL, as normal. I just tried it to verify that it does work. Note that your email browser must accept HTML to see the Flash.
Back button doesn't work on some sites
February 26, 2007
At www.frapple.com if you type in the link code BAZ it opens my page (no problem) the back button opens index.cfm (again no problem) Yet if you enter the link code coke37 the back button opens the form script, and the page redirects again.
Also, link NHL and the back button opens the form script, yet link NFL and back button works fine.
Question, how can I make the back button return to index.html every time?
Michael - Canada (13257)
For some reason, marketeers feel that making a site "sticky" in that you cannot exit the page with the back button, that people will look at their content more. In reality, it is a very unfriendly tactic that can get potential customers anger, especially if they have to close their browser to exit. You can get out of the page by looking at your browsing history, but many people don't know that.
I've never really looked into how to deactivate the back button, so I can't help you with that.
Having trouble clicking Back in ColdFusion
July 24, 2006
I have been working on a project where i need a multiple page entry form ( data entry wizard) using coldfusion 6. I have a next, back and finish button where necessary. The next button works well but when i click back, i go back to the previous page but the content previously entered doesnot reappear. I have enable sessions both using cfapplication and in the admin but the problem just doesnt seem to go. I need your help.
You also said that you use type="hidden" to prefill your from. May i get to know how you do that exactly? If you dont mind demonstrate to me using a multiple page data entry form. Thank you very much.
David - Uganda (11539)
I assume that none of the material is added or inserted into the database until the Finish button is clicked. After the person fills out the form in the first page, the variables are sent to the second page. You can display them or set them as type=hidden to send on to the next pages. Another way is to set then as session variables, but I always preferred the extra code with the type=hidden, so I make sure things work correctly.
If you use your browser's Back button, the previous page should display correctly. But if you have a Back button on your form, you are really starting over with the previous page. One way to get around that is to have a duplicate version of each page, with the variables in the form defined as #form.name# etc. The back button on page Page3.cfm would not go to Page2.cfm, but instead to a Page2a.cfm that fills in the form.
Another method is to define or CFSET all your session variables in Application.cfm as null values. Then when they are filled in, they will carry the session variable from then on. But often you have to do some adjustments to get the session variables to work properly. That is why I use the longer method myself.
Note that since this email is a CF form, I cannot write code in the letter, because it will not send properly.
I hope these ideas helped.
Questions on using session variables
May 12, 2006
First of all, thank you for a wonderfully intuitive resouce for "getting started with" COldFusion. As a relative newcommer to the sport, i've not had the opportunity to program on a ColdFusion 5 or earlier system, but i've read CORE Cold Fusion by Ebin Hewitt, so i can recognize that some of what you have explained might be pre-CFMX 6.1 -- which is fine of course, but i would like to know for certain as some things such as the session.variables seem as if they may be handled a bit differently now?
my question is this-- your example shows this bit of code:
which, from the rest of the code at your site, shows that this session.name is going to take the VALUE of form.othername... what about moving on to another page-- isn't that largely the point of sessions? so, if we move to page 2, and there's no form.othername, have we wasted the power of that session, do we expect to use it again at some point when we revist the form.othername variable, OR does it take on a new value on page 2 depending on what is passed to it a second time-- thereby empowering the user to write expressions even if the variables have not yet been set-- as in, so we can populate forms where appropriate?
thank you! i hope this reaches you in good health
jeff - USA (11096)
I really need to update the material to conform to some of the new CF MX features.
Session variables are handy to have when you have a series of pages where you submit a form to go to the next page. With a session variable, you don't have to worry about a variable that has been defined on a previous page.
Personally, I prefer not to use session variables anymore. Instead, I put in inputs with type=hidden with the variable in the form. This is extra coding but it seems I can keep better track of what is going on.
Want to develop a data driven website using ColdFusion
February 14, 2006
I would like to develop a data driven website using coldfusion. What are all the basic software that I need to install and where can find tutorials on how to begin developing with CF.
S - USA (10083)
Your Internet provider must have ColdFusion installed on their server for you to run CF applications on your website or sites you are developing.
Although you can install a developer version of ColdFusion on your computer to test your programs, most people upload the code to their website and test the software there. This is less costly and avoids the major hassle of configuring your computer for using CF.
You can write CF code in any HTML editor, but it is easiest on Macromedia Dreamweaver or Homesite. Dreamweaver is the industry standard for web development and has aids for inserting CFML code. Homesite is a smaller (and less expensive version of DW. Not many know about the program. Both allow FTP to easily upload your files.
The Macromedia site at www.macromedia.com has a number of tutorials in their developer area. I found a book like "ColdFusion for Dummies" a good way to start. It is an inexpensive book that you can often find in used bookstores.
Learning the basics of SQL is very useful with CF in directing your database to send or receive data. Most use MS Access unless it is a corporate application.
Best wishes in using CF. It is a great language.
Help me to create PDF from HTML
January 6, 2006
i am new in Cold fusion. can you help me to create PDF from HTML using CF5.
shashi - India (9567)
The code given in our lesson combines ColdFusion with the PDF mark-up language. It is very sensitive. You can try to duplicate what we have listed.
Note that servers with CF MX now have a tag that creates PDF files. That is the wave of the future.
Where do i download UltraDev software?
November 15, 2005
Please,Where do i download UltraDev software from the net.Am interested in it.
Achi - Nigeria (8964)
UltraDev has been incorporated into Dreamweaver from Macromedia at www.macromedia.com. You may be able to download a trial version, but unfortunately, Dreamweaver is an expensive application but it is considered the standard in web development.
PDF file did not come up
September 28, 2005
Greetings, I was looking at the following page http://www.school-for-champions.com/coldfusion/cftopdf2.cfm and it seemed a likely solution, however, no matter which browser I use to try this page, instead of returning a pdf, it downloads the fdf file. Is this a problem witht he way the server is set up ?
David - USA (8328)
That is interesting. I just tried it and it seems to work fine. Do you have any problems opening a PDF file from another site? Perhaps some security setting?
Note that if your server has CF MX 7.0, you can easily create a PDF file from any form without having to go through all the coding.
Questions and comments
Do you have any questions, comments, or opinions on this subject? If so, send an email with your feedback. I will try to get back to you as soon as possible.
Click on a button to bookmark or share this page through Twitter, Facebook, email, or other services:
Students and researchers
The Web address of this page is:
Please include it as a link on your website or as a reference in your report, document, or thesis.
Where are you now?