Skip to Content.
Sympa Menu

freetds - Re: Insert into MS SQL

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Wasson, Tim" <WassonT AT kochind.com>
  • To: "'TDS Development Group'" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Insert into MS SQL
  • Date: Mon, 20 Nov 2000 07:44:17 -0600


Simple question: is the username and password you're using permissioned to
do adds, etc in the SQL db?
Are the strings you are sending it going into string fields or number
fields? Numbers shouldn't have quotes.

Tim Wasson
Koch Industries
PHP3/Linux/freetds, NT4.0/Sql6.5/7

> -----Original Message-----
> From: Albert Mok [SMTP:doneeta AT hotmail.com]
> Sent: Monday,November 20,2000 4:34 AM
> To: TDS Development Group
> Subject: [freetds] Re: Insert into MS SQL
>
> Unfortunately no :( but a friend told me to try to upgrade the version of
> my
> freetds to 0.51 pre2. Hope it might work.
>
>
> >From: "Geoff Winkless" <geoff.winkless AT farmline.com>
> >Reply-To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
> >To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
> >Subject: [freetds] Re: Insert into MS SQL
> >Date: Mon, 20 Nov 2000 09:35:14 -0000
> >
> >"Albert Mok" <doneeta AT hotmail.com> wrote:
> > > I would like to have some information regarding the 'insert' statement
> > > into MS SQL. I have tried for some times but I still can't make it
> while
> >I
> > > can do the 'select' statement already. By the way, I'm using PHP 4.03
> in
> >a
> > > Linux box and MS SQL 7.0 under Win2k. I wrote the code as follows:
> > >
> > > $result = mssql_query("insert into $xxx values ('xxx', 'xxx')");
> >
> >Interesting. Does it work if you specify the column names in the query
> >statement?
> >
> >Geoff
> >
> >
> >---
> >You are currently subscribed to freetds as: [doneeta AT hotmail.com]
> >To unsubscribe, forward this message to
> >$subst('Email.Unsub')
>
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
> Share information about yourself, create your own public profile at
> http://profiles.msn.com.
>
>
> ---
> You are currently subscribed to freetds as: [WassonT AT kochind.com]
> To unsubscribe, forward this message to
> $subst('Email.Unsub')





Archive powered by MHonArc 2.6.24.

Top of Page