Sharing Ideas And Solutions <a href="index.cfm?fuseaction=idea.newsletter_subscribe">Our Newsletter</a> Downloadable Solutions PHP Classes For Small &amp; Medium Enterprise Free For Non-Profit Organization Customer Feedback Contact Us Featured Web Template View More Templates MasRizal In Numbers * 18 years in business. * 6823 corporations in 67 countries have chosen our products and service. * 73.32% are using more than one solutions from us. - MasRizal &amp; Partners -Enhancing Business With Trust Random Query Custom Tag: CF_RandomQueryVersion: 1.0(c) 2004, MasRizal, rizal.firmansyah@masrizal.com CF_RandomQuery is a quick solution to give a random recordset.This custom tag supports any kind of query (recordset) as the datasource, not limited to specific database. Features Requirements Usage Application Example <h1> Fast random recordset generation Database independent.</h1>[h1] Query can be made from any kind of database.[/h1][h1] No need to change your SQL select statement to produce random records.[/h1][h1] This custom tag serves as an add-on after you query from database.[/h1][h1] Ability to output n random records only instead of the whole records in database [/h1]Supported ColdFusion Server: ColdFusion 5 ColdFusion MX 6, 6.1 ColdFusion 7 ColdFusion 8 on all operating systems Supported browsers:This tag works on server side, so all browsers are compatible &lt;cf_randomquery DataSource=&quot;query/recordset source - mandatory&quot; Name=&quot;The name of resulting query. The query name is used later in the page to reference the query's record set - mandatory&quot; MaxRows=&quot;Specifies the maximum number of rows to return in the record set - optional (default all rows)&quot;&gt; You will need this tag mostly when you requires random data queried from database where simple 'select' SQL statement will not work. Another added value of this tag is it supports all type of query. So the database choices is up to you. This tag will works even when the query comes from QoQ (query of query). Some applications that requires this tag are: Online quiz. Both the questions and answers must come in random order. Image directories. Random images will give a refreshment to user. Website with random quotes. e-Commerce websites! Use this tag to give a discount on random products. Don't forget to let the visitor knows that the discounted price is valid for current visit only. This will make your website visitors buy product faster. And many more... Randomize recordset from database query.&lt;!--- query database for information ---&gt;&lt;cfquery name = &quot;GetParks&quot; dataSource = &quot;cfsnippets&quot;&gt;SELECT PARKNAME, REGION, STATEFROM Parks &lt;/cfquery&gt;&lt;cf_randomquery DataSource=&quot;GetParks&quot; Name=&quot;RandomParks&quot;&gt; &lt;!--- RandomParks will contain all rows from GetParks in random order ---&gt;&lt;cf_randomquery DataSource=&quot;GetParks&quot; Name=&quot;RandomPark&quot; MaxRows=&quot;1&quot;&gt; &lt;!--- RandomPark will contain 1 random row from GetParks ---&gt; Randomize recordset from programmatically created query&lt;cfset myQuery = QueryNew(&quot;name, address, phone&quot;)&gt;&lt;cfset newRow = QueryAddRow(MyQuery, 2)&gt;&lt;cfset temp = QuerySetCell(myQuery, &quot;name&quot;, &quot;Fred&quot;, 1)&gt;&lt;cfset temp = QuerySetCell(myQuery, &quot;address&quot;, &quot;9 Any Lane&quot;, 1)&gt;&lt;cfset temp = QuerySetCell(myQuery, &quot;phone&quot;, &quot;555-1212&quot;, 1)&gt;&lt;cfset temp = QuerySetCell(myQuery, &quot;name&quot;, &quot;Jane&quot;, 2)&gt;&lt;cfset temp = QuerySetCell(myQuery, &quot;address&quot;, &quot;14 My Street&quot;, 2)&gt;&lt;cfset temp = QuerySetCell(myQuery, &quot;phone&quot;, &quot;588-1444&quot;, 2)&gt;&lt;cf_randomquery DataSource=&quot;myQuery&quot; Name=&quot;RandomMyQuery&quot;&gt; &lt;!--- RandomMyQuery will contain all rows from myQuery in random order ---&gt;&lt;cf_randomquery DataSource=&quot;myQuery&quot; Name=&quot;RandomMyQuery1&quot; MaxRows=&quot;1&quot;&gt; &lt;!--- RandomMyQuery1 will contain 1 random row from myQuery ---&gt; For a complete example please click this link (Open in new window) (Tabbed page powered by CF_Tab) Price License Purchase $9.99 1 Single developer $99.90 1 Site license $149.85 1 Corporate license Licensing Information Goods and services provided by MasRizal Sold by 2CheckOut.com Inc. (Ohio, USA). 2Checkout &amp; MasRizal accepts customer orders via online checks, Visa, MasterCard, Discover, American Express, Dinners, JCB and debit cards with the Visa and MasterCard logo. PayPal and purchasing using your existing bank account are limited to US currency. Random Query is available for immediate download. After you complete the order, you will receive a confirmation email with your download link. Please ensure your email address is entered correctly during the order process. Customers Who Purchased Random Query Usually Purchased These Products Too 1. CFX_Excel 2. CF_FlashMultiUpload 3. XPMenu - Encrypted Version 4. CF_Tab 5. CF_Email_Validator 6. TrimVars 7. Verify Image 8. Image Processing Pack 9. CSV2Query 10. Related Select Why Customers Choose Us Find out why our valued customers choose MasRizal &amp; Partners solutions. Click here to see their reasons Featured Customers More than 6820 companies rely on MasRizal &amp; Partners solutions. Click here to see our featured customers Free For Non-Profit Organization MasRizal Charity program allows eligible nonprofit organizations to get MasRizal's products at no cost. Click here for program detail Testimonials Take the word of our clients Top Selling Products See our top selling products Let Us Help You Can't find solution you need? Click here to get solution from MasRizal.
sql,cfquery,oracle,tag,access,custom,coldfusion,database,data,cf,query,mysql,random,fusion,randomize,coldSharing Ideas And Solutions

Our Newsletter
Downloadable Solutions
Free For Non-Profit Organization
Customer Feedback
Contact Us
Image Compressor 2008.
Batch recompress, resize, rotate and watermark your image.
Save up to 10x more in any storage.
Speed up upload, download, and e-mail transmission time.
Featured Web Template
MasRizal In Numbers

* 18 years in business.
* 6823 corporations in 67 countries have chosen our products and service.
* 73.32% are using more than one solutions from us.

- MasRizal & Partners -
Enhancing Business With Trust
Random Query
Custom Tag: CF_RandomQuery
Version: 1.0
(c) 2004, MasRizal, rizal.firmansyah@masrizal.com

CF_RandomQuery is a quick solution to give a random recordset.
This custom tag supports any kind of query (recordset) as the datasource, not limited to specific database.

(Tabbed page powered by CF_Tab)   

Price License Purchase
$9.99 1 Single developer
$99.90 1 Site license
$149.85 1 Corporate license
Licensing Information

2Checkout.com accepts PayPal 2Checkout.com accepts PayPal Pay Later 2Checkout.com accepts these debit and credit cards

Goods and services provided by MasRizal
Sold by 2CheckOut.com Inc. (Ohio, USA).
2Checkout & MasRizal accepts customer orders via online checks, Visa, MasterCard, Discover, American Express, Dinners, JCB and debit cards with the Visa and MasterCard logo. PayPal and purchasing using your existing bank account are limited to US currency.

Random Query is available for immediate download.
After you complete the order, you will receive a confirmation email with your download link.
Please ensure your email address is entered correctly during the order process.



Customers Who Purchased Random Query Usually Purchased These Products Too
1. CFX_Excel 2. CF_FlashMultiUpload 3. XPMenu - Encrypted Version
4. CF_Tab 5. CF_Email_Validator 6. TrimVars
7. Verify Image 8. Image Processing Pack 9. CSV2Query
10. Related Select

Why Customers Choose Us
Find out why our valued customers choose MasRizal & Partners solutions.
Click here to see their reasons

Featured Customers
More than 6820 companies rely on MasRizal & Partners solutions.
Click here to see our featured customers

Free For Non-Profit Organization
MasRizal Charity program allows eligible nonprofit organizations to get MasRizal's products at no cost.
Click here for program detail
Testimonials
Take the word of our clients

Top Selling Products
See our top selling products

Let Us Help You
Can't find solution you need?
Click here to get solution from MasRizal.
© Copyright 1999-2017 MasRizal & Partners
All Rights Reserved.
OISV - Organization of Independent Software Vendors - Contributing Member    Solutions for designers provided by TemplateMonster.com    Payment processing by 2Checkout    2Checkout.com supports Master Card Secure Code    2Checkout.com is verified by Visa
HALF PRICE SLASH TODAY!
Get 50% Discount
on Premium Component Collection

+ FREE Lifetime Upgrade.
Best Investment.


Offer valid until May 31, 2017

Use Coupon: HALFPRICE3
(Copy this coupon and use it during checkout)

Buy Premium Component Collection With 50% Discount

[ X Close This Window ]