RE: Ramdom tip...

Tue, 03 May 2005 14:05:59 -0700 

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

Reply via email to