StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>I have used both CF and PHP for a similar purpose: to execute database queries in the backend from a flash movie front end. These flash movies were, similar to your situation, more or less standalone, not heavily integrated into the website</p> <p>I found that there is not much that you can acheive with CF that you can with PHP. Database operations are a tad easier to accomplish in CF than PHP, and that's about it. However, if your SQL skills aren't too shabby, this is not much of an issue.</p> <p>IMHO, your needs are better suited by PHP because it's free, and you can get a <a href="http://www.apachefriends.org/en/xampp-windows.html" rel="nofollow noreferrer">WAMP</a> or <a href="http://www.apachefriends.org/en/xampp-linux.html" rel="nofollow noreferrer">LAMP</a> rig easily set up as your sandbox. If you just want a sandbox for CF, you either have to <strike>pay the sticker price</strike>* for the official Adobe software, or get vastly inferior imitations available, such as <a href="http://www.getrailo.org" rel="nofollow noreferrer">Railo Server</a>.</p> <p>Do note that for me, I was able to accomplish database operations on the backend using WAMP/LAMP and Adobe CF, but not with Railo, so that greatly limits your sandboxing experiments with CF. This was 9 months ago though, so you may want to check if Railo has improved since.</p> <p>As for libraries, there are many more out there available for PHP than CF, due to a much larger developer community. Evidence from Google:<br> <a href="http://www.google.com.au/search?q=php+libraries" rel="nofollow noreferrer">PHP : 15 million hits</a><br> <a href="http://www.google.com.au/search?q=coldfusion+libraries" rel="nofollow noreferrer">CF : 0.5 million hits</a> </p> <p>In summary: go with PHP.</p> <p>HTH</p> <hr> <p>Edit:<br> As mentioned by Al, CF developer's edition is free.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload