Re: ' Character in SQL

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: J P Singh (noemail_at_asIhatespam)
Date: 02/12/04 

Date: Thu, 12 Feb 2004 09:30:08 -0000

Sorry I mean to say the problem is with the Select query.

"J P Singh" <noemail@asIhatespam> wrote in message
news:eQHfqnU8DHA.2480@TK2MSFTNGP10.phx.gbl...
> Hi All
>
> We have an application which uses surname and the date of birth to allow
> people to login.
>
> The SQL gives an error if the user's surname contains the character '
>
> Anybody knows a way around this?
>
>

Relevant Pages

  • Re: PHP query using WHERE with AND
    ... AND (pictures.markername LIKE $surname) ... Just picture it in context of the full query. ... the LIKE operator in SQL is mostly useless without at least ... Worse, failure to escape criteria can lead to SQL injection, ...
    (alt.php)
  • Re: PHP query using WHERE with AND
    ... Just picture it in context of the full query. ... the LIKE operator in SQL is mostly useless without at least ... imagine the following query when $surname ... Worse, failure to escape criteria can lead to SQL injection, ...
    (alt.php)
  • Re: Access Changes SQL and makes unusable
    ... optimizes and compiles the query you build in the query builder for best ... In an earlier post I asked for help on some SQL ... The code works fine until I try to change the surname from SMITH, ... FROM school INNER JOIN [SELECT class FROM school ...
    (microsoft.public.access.forms)
  • Re: How to query for duplicates using two fields?
    ... IF your field and table names consist of only letters, numbers, and underscore characters you can do this in ONE query. ... SELECT GraveYard, Stone, Countas RecordCount ... FROM (SELECT DISTINCT GraveYard, Stone, Surname ...
    (microsoft.public.access.queries)
  • Re: Changing the search field
    ... ie surname, forename, DOB etc. by selecting ... Selecting a different attribute runs separate query. ... AND (Forename = Forms!FormName!TextBoxName ... clause based on the user's search criteria and apply that in the OpenForm or ...
    (microsoft.public.access.queries)