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

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.


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

WEBINAR:

On-Demand

Application Security Testing: An Integral Part of DevOps


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
×
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.
Thanks for your registration, follow us on our social networks to keep up-to-date