At 02:24 PM 7/23/00 -0500, you wrote:
>I have a query that needs to produce a random output(or itemID #), based on
>which category the user selected?thanks
>
><cfquery name="GetDetail" datasource="#odbc#">
>SELECT * FROM Items WHERE ItemID='LA-BV912XL'
></cfquery>
I don't have the code with me, but it think it goes like this:
<cfset RandomRow = RandRange(1,GetDetail.RecordCount)>
<cfoutput>
#GetDetail.ColumnName[RandomRow]#
</cfoutput>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
