Friends Problem in SQL statement

Results 1 to 2 of 2

Thread: Friends Problem in SQL statement

  1. #1
    Prashanth Guest

    Default Friends Problem in SQL statement

    Friends I have written a SQL query to insert records into SQL SERVER database table. I have a field "name" If i enter characters, it enters data into the database table, but if I give the special characters such as " or &#039 in the name field it is giving me database error as shown below<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80040e14&#039 <BR><BR>[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near &#039asdfjsklfj&#039. <BR><BR>how to rectify this error <BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default Your Code please!!

    Can you paste your code here, I would like to see the chunk and then may be I can tell you something.<BR>Happy Programming.<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts