Skip to Content.
Sympa Menu

freetds - Re: [freetds] Multiple update statements

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Robert Gonzalez <robert AT robert-gonzalez.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Multiple update statements
  • Date: Fri, 16 Oct 2009 11:37:23 -0700

That is a handy piece of information to know. Thanks for posting that.

On Wed, Oct 14, 2009 at 12:20 AM, Frediano Ziglio <freddy77 AT gmail.com>wrote:

> Now I understand !!
> Tokenizer recognize numbers and stop the number when find invalid character
> so
>
> "select 1select 2"
>
> is recognized like "select 1 select 2"
>
> note however that the syntax
>
> "select 1exec sp_who"
>
> is not recognized like
>
> "select 1 exec sp_who"
>
> cause "e" (starting of exec) is used in numbers for exponent like in
>
> "select 1e3"
>
> So to avoid strange side effects I would always add a space between
> statements
>
> freddy77
>
>
> 2009/10/13 Strumyla, Marius <MStrumyla AT accordant.net>:
> > Nope. There are no separators. I copied the statements back from my
> > original email into PHP code and verified that queries were executed.
> >
> > -----Original Message-----
> > From: freetds-bounces AT lists.ibiblio.org
> > [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Frediano Ziglio
> > Sent: Tuesday, October 13, 2009 4:22 PM
> > To: FreeTDS Development Group
> > Subject: Re: [freetds] Multiple update statements
> >
> > 2009/10/13 Strumyla, Marius <MStrumyla AT accordant.net>:
> >> I had a brain fart obviously. The records are inserted earlier in the
> >> code.
> >>
> >> The only thing that's weird is that the query works as is. No
> >> separation of UPDATE statements. I can live with that.
> >>
> >> Thanks
> >>
> >
> > probably there is a row separator not visible.
> >
> > freddy77
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS AT lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS AT lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> >
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>



--

Robert Gonzalez
http://www.robert-gonzalez.com




Archive powered by MHonArc 2.6.24.

Top of Page