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, 9 Oct 2009 16:22:58 -0700

The way that is written I think you would get a failure. Just a thought,
because there are no SQL terminators in that, so to the server it looks like
one long query string. But I could be wrong about that.

On Fri, Oct 9, 2009 at 1:36 PM, Strumyla, Marius
<MStrumyla AT accordant.net>wrote:

> I'm maintaining someone else's code. Application is written in PHP with
> MS SQL database. Driver installed is FreeTDS 0.64. Platform Solaris 10
> x86.
>
> I came across this query:
> mssql_query("UPDATE user_project SET membership=43 WHERE project=49 AND
> usernum=2UPDATE user_project SET membership=0 WHERE project=49 AND
> usernum=9UPDATE user_project SET membership=0 WHERE project=49 AND
> usernum=10UPDATE user_project SET membership=0 WHERE project=49 AND
> usernum=12UPDATE user_project SET membership=0 WHERE project=49 AND
> usernum=14UPDATE user_project SET membership=0 WHERE project=49 AND
> usernum=15UPDATE user_project SET membership=0 WHERE project=49 AND
> usernum=16")
>
> What is interesting is that records that don't exist are inserted :) If
> I had an empty user_project table, after the execution of the above
> query I would have 7 new records in user_project.
>
> I would like to know whether this is expected and documented somewhere.
>
> Thanks
> _______________________________________________
> 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