HP3000-L Archives

October 2000, Week 2

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Re: SQL INSERT statement syntax
From:
Tom Brandt <[log in to unmask]>
Reply To:
Tom Brandt <[log in to unmask]>
Date:
Thu, 12 Oct 2000 11:50:16 -0400
Content-Type:
text/plain
Parts/Attachments:
text/plain (14 lines) 
Arrggh - I misspelled "doesn't"
At 11:48 AM 10/12/2000 -0400, Tom Brandt wrote:
>I am using SQL to insert a row into a table, with the following syntax:
>
>INSERT INTO Survey VALUES ('<val1>', '<val2>', '<val3>',...'<valn>')
>
>I am using a single quote (') to delimit text strings.   The problem is
>that if a user types a single quote into one of the fields, the result is
>something like 'This does'nt work'.  The single quote looks the ending
>delimiter of the string, and confuses SQL.
>
>Can I use other delimiters besides single or double quotes to delimit text
>strings?

ATOM RSS1 RSS2