Re: Multiple update statements

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
>