SQL problem

Article View: bit.databases.mssql-l

Article #2079

Back to bit.databases.mssql-l Previous Next

#2079

From: Michael Clinton
Date: Thu, 06 Apr 1995 00:00

17 lines
1133 bytes

I have a querry that adds to a table, but the user has the option of 
typing anything into it.  The problem is if they type in a ' like for 
Mike's house or use " for inches my sql errors.. how do I work around 
this.  I am using Visual Basic and a Win NT SQL server.
thanks...


--
----------------------------------------------------------------------
Michael J. Clinton         Internet address: mclinton@csulb.edu
aka NET RUNNER  == o       Home Phone #    : 310-494-9003
        --========< \      Work Phone #    : 310-985-1783
       --========_/\       Pager #         : 310-501-0304
          ---====  /  
                           URL:     http://www.engr.csulb.edu/~mclinton
-----------------------------------------------------------------------

Technical Details

Message-ID: <3m15rg$a0b@garuda.csulb.edu>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f6611,b096b6650ca8fcdd,start
X-Google-Attributes: gidf6611,public
From: mclinton@csulb.edu (Michael Clinton)
Subject: SQL problem
Date: 1995/04/06
Message-ID: <3m15rg$a0b@garuda.csulb.edu>
X-Deja-AN: 100977828
organization: Cal State Long Beach
newsgroups: bit.databases.mssql-l