Results 1 to 8 of 8

Thread: Colums

  1. Oct 2nd, 2002, 01:12 PM #1
    Andreex
    Andreex is offline

    Thread Starter
    Fanatic Member
    Join Date
    Apr 2001
    Posts
    843

    Colums

    I know this has been answered quite a few times, but I cant find it with the search. SO here it goes AGAIN.....

    I want to save this text in my database

    I'll go


    but since it has the ' it sends me an error. I did the replace(str,"'","''") but that saves i''l go and I dont want that... I want I'll go

    how can I do this?
    "The difference between mad and genius is the success"
    Reply With Quote Reply With Quote
  2. Oct 2nd, 2002, 01:16 PM #2
    andreys
    andreys is offline
    Frenzied Member andreys's Avatar
    Join Date
    Sep 2002
    Location
    Los Angeles
    Posts
    1,615
    Code:
    myStr=replace(myStr, "'", "''")

'for you understanding same thing but with extra spaces

'replace(myStr," ' ", " ' ' ")
    Reply With Quote Reply With Quote
  3. Oct 2nd, 2002, 02:59 PM #3
    Andreex
    Andreex is offline

    Thread Starter
    Fanatic Member
    Join Date
    Apr 2001
    Posts
    843
    yeah but that will save '' in the database.. I just want one.. '

    like this I'll go
    not... I''ll go

    ??
    "The difference between mad and genius is the success"
    Reply With Quote Reply With Quote
  4. Oct 2nd, 2002, 03:16 PM #4
    andreys
    andreys is offline
    Frenzied Member andreys's Avatar
    Join Date
    Sep 2002
    Location
    Los Angeles
    Posts
    1,615
    It will save just one '.
    Reply With Quote Reply With Quote
  6. Oct 2nd, 2002, 03:27 PM #5
    Andreex
    Andreex is offline

    Thread Starter
    Fanatic Member
    Join Date
    Apr 2001
    Posts
    843
    it doesnt...!! I laredy tried!!
    "The difference between mad and genius is the success"
    Reply With Quote Reply With Quote
  7. Oct 2nd, 2002, 03:28 PM #6
    Andreex
    Andreex is offline

    Thread Starter
    Fanatic Member
    Join Date
    Apr 2001
    Posts
    843
    why is this happening?
    "The difference between mad and genius is the success"
    Reply With Quote Reply With Quote
  8. Oct 2nd, 2002, 03:30 PM #7
    techgnome
    techgnome is offline
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687
    how are you saving the data?
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *
    Reply With Quote Reply With Quote
  9. Oct 2nd, 2002, 03:32 PM #8
    Andreex
    Andreex is offline

    Thread Starter
    Fanatic Member
    Join Date
    Apr 2001
    Posts
    843
    Oh it is working now.. sorry... it is so confusing....
    "The difference between mad and genius is the success"
    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