List:General Discussion« Previous MessageNext Message »
From:Michael T. Babcock Date:December 4 2002 4:05am
Subject:Re: RES: SQL Select Idea
View as plain text  
On Tue, Dec 03, 2002 at 07:02:02PM -0200, Felipe Moreno - MAILING LISTS wrote:
> 2) What I get is I use the SELECT * FROM processo_arquivos ORDER BY DATE
> DESC LIMIT 0,3 (considering that I only want 3)

[ that worked as described ]

> 3) The problem getting the result like this:
> 
> Since I have a link in the header of the tabel that make the ORDER BY work,
> when I select de COD after the result above, I should get:

[ you didn't give the EXACT SQL QUERY that you're typing in; please give it ]

I'm assuming that you're forgetting a step, or misunderstanding a step
involved.  Are you doing anything with that data you're selecting, or just
selecting it and leaving it?  You might be wanting to select it into a new
table or something; look up "INSERT INTO ... SELECT FROM ...".
-- 
Michael T. Babcock
CTO, FibreSpeed Ltd.     (Hosting, Security, Consultation, Database, etc)
http://www.fibrespeed.net/~mbabcock/
Thread
Blob accepts LongBlob without errorRyan @ Common Ground . To3 Dec
  • re: Blob accepts LongBlob without errorVictoria Reznichenko3 Dec
    • SQL Select IdeaFelipe Moreno - MAILING LISTS3 Dec
      • RE: SQL Select IdeaMike Hillyer3 Dec
      • RE: SQL Select IdeaJim Esten3 Dec
        • RES: SQL Select IdeaFelipe Moreno - MAILING LISTS3 Dec
          • Re: RES: SQL Select IdeaMichael T. Babcock4 Dec
            • RES: RES: SQL Select IdeaFelipe Moreno - MAILING LISTS4 Dec
              • Re: RES: RES: SQL Select IdeaMichael T. Babcock4 Dec
                • RES: RES: RES: SQL Select IdeaFelipe Moreno - MAILING LISTS5 Dec
        • RE: SQL Select IdeaJim Esten4 Dec
Re: Blob accepts LongBlob without errorJan Steinman3 Dec