Re: Multiple update statements

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

On Wed, Oct 14, 2009 at 12:20 AM, Frediano Ziglio <[email protected]>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 <[email protected]>:
> > 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: [email protected]
> > [mailto:[email protected]] 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 <[email protected]>:
> >> 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
> > [email protected]
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> > _______________________________________________
> > FreeTDS mailing list
> > [email protected]
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> >
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>



-- 

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