Searching text fields

Results 1 to 3 of 3

Thread: Searching text fields

  1. #1
    J Guest

    Default Searching text fields

    Hi<BR>I have a simple name field text search with asp & access<BR>I get an error if for example o&#039malley is entered, it seems to take the o part on its own &#039o&#039malley and gives out an error is there any fix for this<BR>Thank you in advance.<BR>J

  2. #2
    Join Date
    Dec 1969

    Default RE: Searching text fields

    At some point that string is getting used in a SQL statement - the string delimiter in SQL is a sinlge quote (&#039). So you&#039re problem is that the apostrophe is a premature end-of-string marker.<BR><BR>Answer: replace a sinlge quote (&#039) with two single quotes(&#039&#039, not double quote ").<BR><BR>Dunc

  3. #3
    Join Date
    Dec 1969

    Default RE: Searching text fields

    And while you&#039re at it, please check the FAQs before you post. :)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts