List:General Discussion« Previous MessageNext Message »
From:Banyan He Date:March 25 2007 9:50am
Subject:Re: SPAM ?
View as plain text  
What's kind of the message you guys mentioned?

----- Original Message ----- 
From: "LP" <lplp98@stripped>
To: "'MySQL List'" <mysql@stripped>
Sent: Saturday, March 24, 2007 10:13 PM
Subject: Re: SPAM ?


> Hi,
>
> I also get the problem of  keep receiving the email from the email list
>
> Regards
>
> KEVIN
>
>
>
> ----- Original Message ----- 
> From: "Jacques Brignon" <jacbrignon@stripped>
> To: "'Jerry Schwartz'" <jschwartz@stripped>
> Cc: "'MySQL List'" <mysql@stripped>
> Sent: Saturday, March 24, 2007 10:45 PM
> Subject: SPAM ?
>
>
> Hi,
>
> I keep receiving this message by several dozens each day, how can this
> be stopped?
>
> Regards
>
> Jacques
>
>> -----Message d'origine-----
>> De : Jerry Schwartz [mailto:jschwartz@stripped]
>> Envoyé : jeudi 22 mars 2007 17:53
>> À : peter.brawley@stripped; 'James Tu'
>> Cc : 'MySQL List'
>> Objet : RE: Finding a record in a result set
>>
>> I don't think that will work. If there are 1,000 records that qualify
> but
>> none for Joe, then it will return 1,001. If Joe is in record 1 of the
>> retrieved record set, and there are 999 other people who match the
> WHERE
>> clause, then it will retrieve 1,000.
>>
>> Am I missing something?
>>
>> Regards,
>>
>> Jerry Schwartz
>> Global Information Incorporated
>> 195 Farmington Ave.
>> Farmington, CT 06032
>>
>> 860.674.8796 / FAX: 860.674.8341
>>
>>
>> > -----Original Message-----
>> > From: Peter Brawley [mailto:peter.brawley@stripped]
>> > Sent: Thursday, March 22, 2007 12:33 PM
>> > To: James Tu
>> > Cc: MySQL List
>> > Subject: Re: Finding a record in a result set
>> >
>> >  >I want to do a query of all employees from Maine, ordered
>> > by hiring date,
>> >  >and figure out where Joe falls in that list. (i.e. which
>> > record number
>> > is he?)
>> >
>> > If 'Joe' is a unique name LOL...
>> >
>> > SELECT 1 + COUNT(*)
>> > FROM employees
>> > WHERE name <> 'Joe' AND state = 'MA' AND hiredate <
> <datevalue>;
>> >
>> > PB
>> >
>> > James Tu wrote:
>> > > Is there some quick way to do the following in MySQL?  (I
>> > know I can
>> > > use PHP to search through the result set, but I wanted to see if
>> > > there's a quick way using some sort of query)
>> > >
>> > > Let's say I know that Joe is from Maine.
>> > > I want to do a query of all employees from Maine, ordered by
> hiring
>> > > date, and figure out where Joe falls in that list. (i.e.
>> > which record
>> > > number is he?)
>> > >
>> > > -James
>> > >
>> > >
>> > > --MySQL General Mailing List
>> > > For list archives: http://lists.mysql.com/mysql
>> > > To unsubscribe:
>> > > http://lists.mysql.com/mysql?unsub=1
>> > >
>> > >
>> > >
>> > > --No virus found in this incoming message.
>> > > Checked by AVG Free Edition.
>> > > Version: 7.5.446 / Virus Database: 268.18.17/730 - Release Date:
>> > > 3/22/2007 7:44 AM
>> > >
>> > >
>> >
>> > --
>> > MySQL General Mailing List
>> > For list archives: http://lists.mysql.com/mysql
>> > To unsubscribe:
>> > http://lists.mysql.com/mysql?unsub=1
>> >
>> >
>>
>>
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> 
Thread
Finding a record in a result setJames Tu22 Mar
  • Re: Finding a record in a result setPeter Brawley22 Mar
    • Re: Finding a record in a result setRolando Edwards22 Mar
    • RE: Finding a record in a result setJerry Schwartz22 Mar
      • Re: Finding a record in a result setFrancesco Riosa23 Mar
      • SPAM ?Jacques Brignon24 Mar
        • Re: SPAM ?LP24 Mar
        • Re: SPAM ?Martijn Tonies24 Mar
        • Re: SPAM ?Stephen Cook25 Mar
          • RE : SPAM ?Jacques Brignon25 Mar
            • RE : RE : SPAM ? SOLVEDJacques Brignon25 Mar
        • Re: SPAM ?Banyan He25 Mar
          • RE : SPAM ?Jacques Brignon25 Mar
            • Re: SPAM ?Banyan He25 Mar
  • Re: Finding a record in a result setRolando Edwards22 Mar
  • Re: Finding a record in a result setMaciej Dobrzanski24 Mar
    • Re: Finding a record in a result setJames Tu26 Mar
  • Re: Finding a record in a result setJames Tu26 Mar
  • Re: Finding a record in a result setJames Tu4 Apr
    • RE: Finding a record in a result setJerry Schwartz4 Apr
      • Re: Finding a record in a result setDan Buettner4 Apr
        • Re: Finding a record in a result setJames Tu4 Apr
          • Re: Finding a record in a result setDan Buettner4 Apr
      • Re: Finding a record in a result setJames Tu4 Apr