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: "Pascal Miquet" <p.miquet AT hafiba.fr>
  • 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 15:39:59 +0100

Hi,

I've started from scratch..
Using a new Database on MS SQL
Defining a new DSN into freetds and odbc(inst).ini

Test were done using tsql isql and an very small php script.

And insertion where successfull.
I'll take a look to the other stuff.

Thanks for your help.
Regards

-----Message d'origine-----
De : freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org]De la part de ZIGLIO,
Frediano, VF-IT
Envoyé : vendredi 26 novembre 2004 11:37
À : FreeTDS Development Group
Objet : RE: [freetds] Inserting data into tables[Ce message a ete
verifie]




> -----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
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds

<<attachment: winmail.dat>>




Archive powered by MHonArc 2.6.24.

Top of Page