Results 1 to 2 of 2

Thread: select db value [resolved]

  1. May 1st, 2004, 03:47 PM #1
    marvinklein
    marvinklein is offline

    Thread Starter
    Registered User
    Join Date
    Jul 2001
    Posts
    283

    select db value [resolved]

    database.Tables("Table1").Select("value='" & "t'h'i's i's t'h'e v'a'l'u'e" & "'")(0)

    this select statement dosn't work because the selection string has single quotes in it. how can i fix this error. the db value i want to select has quotes in it.
    Last edited by marvinklein; May 1st, 2004 at 04:14 PM.
    Reply With Quote Reply With Quote
  2. May 1st, 2004, 04:14 PM #2
    marvinklein
    marvinklein is offline

    Thread Starter
    Registered User
    Join Date
    Jul 2001
    Posts
    283
    i got it:

    selectByThisValue.tostring.replace(" ' "," ' ' ")

    (without the spaces)
    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