Skip to Content.
Sympa Menu

freetds - RE: [freetds] Inserting data into tables[Ce message a ete verifie]

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Inserting data into tables[Ce message a ete verifie]
  • Date: Fri, 26 Nov 2004 11:36:49 +0100



> -----Original Message-----
> From: freetds-bounces AT lists.ibiblio.org
> [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Pascal Miquet
> Sent: venerdì 26 novembre 2004 11.28
> To: 'FreeTDS Development Group'
> Subject: RE: [freetds] Inserting data into tables[Ce message
> a ete verifie]
>
>
> Thanks for your reply.
> But I wonder why this request seems to work fine with IIS and
> a "direct" ODBC on a Windows System.
>
> Regards
>
> -----Message d'origine-----
> De : freetds-bounces AT lists.ibiblio.org
> [mailto:freetds-bounces AT lists.ibiblio.org]De la part de
> Thompson, Bill D
> (London)
> Envoyé : vendredi 26 novembre 2004 11:16
> À : FreeTDS Development Group
> Objet : RE: [freetds] Inserting data into tables[Ce message a ete
> verifie]
>
>
> pascal,
>
> The problem appears to the incorrect formation of the
> following SQL that
> is being submitted.
>
> SELECT lbl.LabelMultiLg_Id, lbl.LabelMultiLg_Txt
> FROM LabelMultiLg lbl,LoginParam l
> WHERE l.loginId = :
> AND l.UserParamID = 'f3_langue'
> AND lbl.LabelMultiLg_Lg = l.LoginParamValue
> AND isnull(lbl.LabelMultiLg_Include,0) = 1
>
> SQL server is objecting (quite rightly) to the first line of the where
> clause....
> I'd check the SQL you are sending...
>
> Bill

SQL Query Analyzer say

Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near ':'.

So the error seems ':'. I don't understand where this come... perhaps it's a
problem preparing statement?

freddy77




Archive powered by MHonArc 2.6.24.

Top of Page