It takes two queries but you could: <cfquery name="TipIDs"> select ID from ... </cfquery>
<cfquery name="Tip"> select Tip from ... where ID = #TipIDs.ID[RandRange(1,TipIDs.RecordCount)]# </cfquery> <cfoutput>Tip: #Tip.Tip#</cfoutput> - Daniel -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Javier Flores Sent: Tuesday, May 03, 2005 4:05 PM To: [email protected] Subject: RE: Ramdom tip... Ups! Sorry I'm using Access... Javier -----Mensaje original----- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] En nombre de Ryan Everhart Enviado el: Lunes, 02 de Mayo de 2005 09:47 p.m. Para: [email protected] Asunto: Re: Ramdom tip... If you are using SQL server you can write a query like this SELECT Tip_ID, Tip FROM TipTable ORDER BY NEWID() The key is the ORDER BY NewID() On 5/2/05, Javier Flores <[EMAIL PROTECTED]> wrote: > > > > > I would like to RAMDOM a tip on my home pageâ do you have any code to do > this? > > > > I have and ID and the TIP on the tableâ > > > > Thanks, > > > > Javier NÅhÂà ÂÃÂj)mÂXÂÂÃÃqà ÂÂÂÃàÂ&ÃâÃiÃÃ0ÃÃÃqà ÂÂ?~ÅÃ1ÃâzÂ'ÂÃÃrÂâyÃÃNâ.nÃ+âÂÂÂÃà 0uà ~Ã(ÂÃÂÂÅzfàÅÃkjÃÂÂÃà ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
