freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- 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')
-
Insert into MS SQL,
Albert Mok, 11/19/2000
- <Possible follow-up(s)>
- Re: Insert into MS SQL, Geoff Winkless, 11/20/2000
- Re: Insert into MS SQL, Albert Mok, 11/20/2000
- Re: Insert into MS SQL, Wasson, Tim, 11/20/2000
Archive powered by MHonArc 2.6.24.