Skip to content

Instantly share code, notes, and snippets.

@isapir

isapir/dbsample.cfm

Created July 10, 2012 05:31
Show Gist options
  • Save isapir/3081318 to your computer and use it in GitHub Desktop.
Save isapir/3081318 to your computer and use it in GitHub Desktop.
Download ZIP
Basic Database Connection, Random Query, Display Result, equivalent to PHP script at http://css-tricks.com/snippets/php/basic-database-connection-random-query-display-result/
Raw
dbsample.cfm
<!--- first select from db !--->
<cfquery name="qTestinmonials">
SELECT testimonial, author
FROM recommendations
ORDER BY rand() LIMIT 1
</cfquery>
<!--- now output the data !--->
<cfoutput query="qTestinmonials">
<p id="quote">#testimonial#</p>
<p id="author">&ndash; #author#</p>
</cfoutput>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment