Skip to Content.
Sympa Menu

freetds - Re: How to insert a '*' via FreeTDS / Microsoft SQL V7 etc?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Francis Smit <francis AT oztel.com>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: How to insert a '*' via FreeTDS / Microsoft SQL V7 etc?
  • Date: Thu, 17 Feb 2000 09:03:41 +1100


Umm this works fine for me I can do:

INSERT INTO star(stars) Values('*')
SELECT * FROM Test.dbo.star

Are you by any chance doing

INSERT INTO star(stars) Values("*")
SELECT * FROM Test.dbo.star

or equivalent if you are the MSSQL Server is thinking
that you want the field (*) the string (*) is denoted as
'*' or any string can be 'string' but never "string".


Karl Pielorz wrote:

> Hi All,
>
> I know this is off topic (probably) - and after having seen the difference
> between MySQL and MS-SQL V7 on inserting ' (quotes), I can probably guess
> where the problem lies (me)...
>
> Anyone know why I can't seem to insert a "*" (asterisk) into our MS-SQL V7
> server via FreeTDS?
>
> I can do the same in Delphi (not a real good comparison) by just setting the
> column value to "*", alas not from PHP/FreeTDS though...
>
> Any suggestions, or pointers would be gratefuly received...
>
> -Karl
>
> ---
> You are currently subscribed to freetds as: francis AT oztel.com
> To unsubscribe, forward this message to $subst('Email.Unsub')

--

Grisly . oo
`oO
Francis Smit


Knowledge By Design/OzTel
Suite 201, 683 George st
Sydney 2000 NSW

mailto:francis AT kbd.com.au

Tel: +61 2 9212 1399
Fax: +61 2 9212 5727
___________________________________
m$: How can we stuff you up today?






Archive powered by MHonArc 2.6.24.

Top of Page