List:General Discussion« Previous MessageNext Message »
From:Jerry Schwartz Date:January 8 2007 3:58pm
Subject:RE: How to access an array variables in a single query
View as plain text  
Thanks. I might actually adapt our code, in my infinite free time.

Regards,

Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341


> -----Original Message-----
> From: Brent Baisley [mailto:brenttech@stripped]
> Sent: Monday, January 08, 2007 10:13 AM
> To: Jerry Schwartz; 'VenuGopal Papasani'; 'ViSolve DB Team'
> Cc: mysql@stripped; 'bharath kumar'
> Subject: Re: How to access an array variables in a single query
>
> If this is in PHP, just use implode to create the string. The
> there is no need to strip trailing commas and no loops.
>  $instring    = implode('","', $a);
>
> As for the query, where are you getting your "1000" values
> from? You can do joins on queries if your values are the
> result of a some
> complex query.
>
>
> ----- Original Message -----
> From: "Jerry Schwartz" <jschwartz@stripped>
> To: "'VenuGopal Papasani'" <venu.papasani@stripped>;
> "'ViSolve DB Team'" <mysqlsupport@stripped>
> Cc: <mysql@stripped>; "'bharath kumar'" <chbharathk@stripped>
> Sent: Monday, January 08, 2007 9:38 AM
> Subject: RE: How to access an array variables in a single query
>
>
> > Within the limits of an overall query, the IN clause can be
> arbitrarily
> > long. You'll use a loop in your program to construct a
> string such as
> > $instring .= "'$a[$i]',"
> > and then remove the unneeded trailing comma.
> >
> > Our code here does that with very large lists that are the
> result of a
> > query. I don't like it, because it might fail mysteriously
> if the query gets
> > too long, but I inherited it and haven't thought of a good
> way to rewrite
> > it.
> >
> > Regards,
> >
> > Jerry Schwartz
> > Global Information Incorporated
> > 195 Farmington Ave.
> > Farmington, CT 06032
> >
> > 860.674.8796 / FAX: 860.674.8341
> >
> >
> >> -----Original Message-----
> >> From: VenuGopal Papasani [mailto:venu.papasani@stripped]
> >> Sent: Saturday, January 06, 2007 4:22 AM
> >> To: ViSolve DB Team
> >> Cc: mysql@stripped; bharath kumar
> >> Subject: Re: How to access an array variables in a single query
> >>
> >> but that is not static for 3 variables what if array contains
> >> 1000 elements
> >> in cannot be used in such cases
> >>
> >> Thanks and Regards,
> >> venu
> >>
> >> On 1/6/07, ViSolve DB Team <mysqlsupport@stripped> wrote:
> >> >
> >> > Hi,
> >> >
> >> > IN operator will do.
> >> >
> >> > For Instance.
> >> >
> >> > SELECT * FROM TABLE1 WHERE id IN ('i1','i2','i3');
> >> >
> >> >
> >> > Thanks
> >> > ViSolve DB Team.
> >> >
> >> > ----- Original Message -----
> >> > From: "VenuGopal Papasani" <venu.papasani@stripped>
> >> > To: <mysql@stripped>
> >> > Cc: "bharath kumar" <chbharathk@stripped>
> >> > Sent: Saturday, January 06, 2007 2:07 PM
> >> > Subject: How to access an array variables in a single query
> >> >
> >> >
> >> > > Dear all,
> >> > >   I have got an array variable say a[]={"i1","i2",i3""}
> >> now i need to
> >> > get
> >> > > the values from the database that matches i1,i2,i3 for example
> >> > >
> >> > >                         select * from tablename where
> i1=a[1]  and
> >> > > simillaryly to a[2] and a[3] but my list is too big one
> >> more option i
> >> > can
> >> > > write it through loop but it takes time.Is there any
> >> possibility of
> >> > > writing
> >> > > a single query to retrieve all that data.
> >> > >
> >> > >           Awaiting your reply
> >> > >
> >> > > Thanks and Regards,
> >> > > venu
> >> > >
> >> > > --
> >> > > ????????????,
> >> > > ??????????  ???????.
> >> > >
> >> >
> >> >
> >>
> >>
> >> --
> >> ????????????,
> >> ??????????  ???????.
> >>
> >
> >
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
> >
>
>



Thread
How to access an array variables in a single queryVenuGopal Papasani6 Jan
  • Re: How to access an array variables in a single queryViSolve DB Team6 Jan
    • Re: How to access an array variables in a single queryVenuGopal Papasani6 Jan
      • Re: How to access an array variables in a single queryDan Nelson6 Jan
      • RE: How to access an array variables in a single queryJerry Schwartz8 Jan
        • Re: How to access an array variables in a single queryBrent Baisley8 Jan
          • RE: How to access an array variables in a single queryJerry Schwartz8 Jan
  • Re: How to access an array variables in a single queryViSolve DB Team6 Jan