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: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Multiple update statements
  • Date: Wed, 14 Oct 2009 09:20:30 +0200

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
>




Archive powered by MHonArc 2.6.24.

Top of Page