ColdFusion Interview Questions, Answers, and Explanations: ColdFusion Certification Review

By Equity Press

The Ultimate Reference & Learning Guide for ColdFusion Careers!

It’s clear that ColdFusion is a must-have for today’s web developer, and finding a clear and comprehensive resource can be difficult. Over 100 Certification Questions, Answers, and Explanations will guide you through your learning process. From helping to assess your skill levels to evaluating job candidates, this guidebook will help you understand what you really need to know. The book thoroughly explains ColdFusion Markup Language, SMS, ColdFusion as middleware in a service oriented architecture, and its applicability to data-driven websites or intranets. More than just a rehash of documentation and sales presentations, each section is based on product knowledge and experience gained on successful ColdFusion implementations.

Key certification and interview topics include:

• ColdFusion as a productivity layer or as middleware
• Configuration for asynchronous events such as SMS or instant messaging
• Coldfusion Markup Language
• Applicability to computer software development and dynamic web sites
• Security and maintenance

• Language: English
• Publisher: Equity Press
• Release date: Jun 3, 2011
• ISBN: 9781603322362

Book preview

COLDFUSION Interview Questions and Answers

By: Terry Sanchez-Clark

Copyright 2006 Equity Press

Smashwords Edition

Smashwords Edition, License Notes

This ebook is licensed for your personal enjoyment only. This ebook may not be re-sold or given away to other people. If you would like to share this book with another person, please purchase an additional copy for each recipient. If you’re reading this book and did not purchase it, or it was not purchased for your use only, then please return to Smashwords.com and purchase your own copy. Thank you for respecting the hard work of this author.

COLDFUSION Interview Questions and Answers

ISBN 1-933804-53-X

Copyright© 2006 Equity Press and IT COOKBOOK all rights reserved. No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording or otherwise) without either the prior written permission of the publisher or a license permitting restricted copying in the United States or abroad.

The scanning, uploading and distribution of this book via the internet or via any other means with the permission of the publisher is illegal and punishable by law. Please purchase only authorized electronic editions, and do not participate in or encourage piracy of copyrighted materials.

The programs in this book have been included for instructional value only. They have been tested with care but are not guaranteed for any particular purpose. The publisher does not offer any warranties or representations not does it accept any liabilities with respect to the programs.

Trademarks: All trademarks are the property of their respective owners. Equity Press is not associated with any product or vender mentioned in this book.

Please visit our website at www.itcookbook.com

TABLE OF CONTENTS

Question 01: Cold Fusion

Question 02: Easy to operate

Question 03: Cold Fusion Development

Question 04: Installing CFmx7 on XP home

Question 05: Best way to create dynamic pdf's

Question 06: cfoutput inside JavaScript

Question 07: Fetch numbers and put them in my query variable

Question 08: Join

Question 09: Inserting Variables

Question 10: CFOUPUT - best practice

Question 11: Forgot password

Question 12: File Upload Problem

Question 13: FuseTalk

Question 14: Re-Replace question

Question 15: cfhttp and posting xml

Question 16: Grab something out of a string

Question 17: CFSelect Dropdownvalue Problem

Question 18: Password Strength Meter

Question 19: cfloop help

Question 20: Hash () and the forgotten password

Question 21: Finding dates

Question 22: Listing items by one column's attributes

Question 23: Client Side Validation

Question 24: query/display results with a foreign key

Question 25: Joining Two Queries

Question 26: Appending a PDF file with CFMX 7

Question 27: doesn't send message to hotmail users

Question 28: XML attribute Is Defined

Question 29: Parsing XML

Question 30: Remove parts of string

Question 31: Programmatically access debugging IPS

Question 32: Determine if a port is open on Remote Server

Question 33: CFLOOP=query in CFLOOP=query

Question 34: Recordcount of Query results

Question 35: Plus Operation

Question 36: Building formatted ASCII file

Question 37: NMEA checksum or C to CF translation

Question 38: Passing only filled form objects to URL

Question 39: Multiple counts within same sql statement

Question 40: Login Page

Question 41: Parse form variable to insert in my query

Question 42: Specify folder for cfinput type file to start in

Question 43: Migrating MySQL Windows to Mac

Question 44: Instant Layout Preview

Question 45: Cfselect

Question 46: Listing menu choices from a database then linking them

Question 47: Substring in CF

Question 48: Upload multiple images

Question 49: Session variable compared to stored value

Question 50: Cfif LIKE in cfquery statement

Question 51: Update code

Question 52: Delete Read Only File

Question 53: Dynamic Link for List Box to SQL Table

Question 54: Site Maintenance

Question 55: Catch error and reprocess form

Question 56: ColdFusion Code Review Processes

Question 57: Radio buttons

Question 58: Session variables security

Question 59: Remove contact from table by using email address

Question 60: Send email when a visitor comes to site

Question 61: Upgrade server and remove the older version

Question 62: Saving CF generated Excel file

Question 63: Calculate number of days between date fields

Question 64: ColdFusion Ping

Question 65: Connection Failure using http post and SSL

Question 66: Calculating a date range

Question 67: Confirmation Page

Question 68: Email Validation

Question 69: Check for a session

Question 70: Create an elapse time

Question 71: Change CF variable via JavaScript

Question 72: Using variable output within variable names

Question 73: Find highest value in list

Question 74: Multithreading in Cold Fusion

Question 75: Check execution time

Question 76: Math: sin function

Question 77: Delete files by date range

Question 78: Form that calculates totals in Coldfusion

Question 79: Extracting a Structure from within an Array

Question 80: Long string() display issue

Question 81: Running CF site from a CD

Question 82: IIS is confused by displaying wrong websites

Question 83: cfdirectory and thumbnails

Question 84: Form

Question 85: Alphabet filter

Question 86: Adding new rows on page

Question 87: Output repeats itself

Question 88: Number as text

Question 89: Recovering ColdFusion administration password

Question 90: Auto size graph

Question 91: Extract values from multiple select

Question 92: Online source editor

Question 93: Getting current physical path

Question 94: Rotating email

Question 95: Permanent cookie not read

Question 96: Comparing two lists

Question 97: Adding dates but omitting Sunday

Question 98: Run Update query when new session initiated

Question 99: Securing Pages

Question 100: ReadOnly Version

Acknowledgements

Question 01: Cold Fusion

What exactly is Cold Fusion?

A: It is a Web Application Server. Cold Fusion is an application that runs on a web server. Currently, it runs on Linux, Solaris, and Windows Servers (even personal web server on win98). The Cold Fusion Web Application Server works with the HTTP server to process requests for web pages. Whenever a Cold Fusion page is requested, the Cold Fusion Application Server executes the script or program the page contains.

It is a programming Language. Cold Fusion is a language. It can create and modify variables just like other languages you may be familiar with. It has program flow controls like IF, Switch Case, Loop, etc. It has many built in functions for performing more complicated tasks (like finding what day the 3rd of august will be in 2007:

DayOfWeekAsString(DayOfWeek('2007/08/03'))

It is a Database Language:

OK, not a Database Language, but Cold Fusion makes interacting with your database (Sybase, Oracle, MySQL, SQL, or Access) simple. Using standard SQL (Structured Query