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:
From:
Tom Brandt <[log in to unmask]>
Reply To:
Tom Brandt <[log in to unmask]>
Date:
Thu, 12 Oct 2000 11:48:11 -0400
Content-Type:
text/plain
Parts/Attachments:
text/plain (12 lines)
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