Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Visual Basic
Expertise: Beginner
Oct 1, 1996

Problems With Single Quotes

Question:
Single quotes are messing up my queries. What can I do to fix the following problem?
Dim Criteria as String
Criteria="Name LIKE '" & SearchName & "'" 

'SearchName="Sam O'Brien"
'At this Point Criteria="Name LIKE 'Sam O'Brien'"
'I am unable to execute the next statement because of the
'Single quote in the middle of my search criteria

Ds.FindFirst Criteria

Answer:
The underlying problem here is that a single quote is a special character to most databases. It is used to delimit character values, just like the double quote is used in Visual Basic to do the same thing. However, if you convert your single quotes to two single quotes when you are performing actions on the database where a single quote could appear, the database will work correctly. Just create a function that takes a string as input and returns a string. You can just call that within your SQL statement and you will not have to worry what your data looks like.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date