> Also brainstorming for other alternatives. It's a simple round robin
> load balancer. I'd rather not have the first unit just by database
> index order selected all the time.
This is what I did...
VacancyID is a primary key...
<cfset theVacancyID = q.VacancyID[RandRange(1, q.recordcount)]>
<cfquery name="queryresult" dbtype="query">
SELECT VacancyID, <lots of other columns>
FROM q
WHERE VacancyID = <cfqueryparam value="#theVacancyID#"
cfsqltype="cf_sql_integer">
</cfquery>
<cfreturn queryresult>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327161
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
