Results 1 to 4 of 4

Thread: MySQL: and Quotation Marks **Resolved**

Threaded View

  1. May 30th, 2005, 07:56 PM #1
    Mark Gambo
    Mark Gambo is offline

    Thread Starter
    Giants World Champs!!!! Mark Gambo's Avatar
    Join Date
    Sep 2003
    Location
    Colorado
    Posts
    2,965

    Resolved MySQL: and Quotation Marks **Resolved**

    How would I use the following string to data from a MySQL Table:

    Mark's Computer

    I have tried the following and no luck:

    1) I have used the escape Character (Back Slash \) followed by a single
    quote (\') as documented in the MySQL Help File - No Good
    2) I also tried changing the entire string into Ascii - No Good
    3) I Used the MySQL escape character again '\' and typed the Ascii code
    after it - No Good

    VB Code:
    1. strSQL = "SELECT * FROM MyTable WHERE ComField ='[COLOR=Red]Mark's[/COLOR]'"

    Any Ideas?
    Last edited by Mark Gambo; May 30th, 2005 at 09:23 PM.
    Regards,

    Mark

    Please remember to rate posts! Rate any post you find helpful. Use the link to the left - "Rate this Post". Please use [highlight='vb'] your code goes in here [/highlight] tags when posting code. When a question you asked has been resolved, please go to the top of the original post and click "Thread Tools" then select "Mark Thread Resolved."

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width