SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Thread: HI :query

  1. #1
    SitePoint Member
    Join Date
    Mar 2005
    Posts
    21
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    HI :query

    I m inserting value into sql table
    from excel

    the problem lies that the fiield i.e description contains single qoutes as well as double qoutes. so it is creating probs while inserting value.

    set rs2=db.Execute ("insert into entry(description)values('"& ExcelRS("Description")&"');")


    I want to remove this quotes but this quotes should be there in sql table
    I don't know how to that
    if anyone knows plz reply me

  2. #2
    SitePoint Enthusiast Nawaz Ijaz's Avatar
    Join Date
    Feb 2005
    Location
    Lahore, Pakistan
    Posts
    96
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    To replace " quotes
    replace (ExcelRS("Description"), """, "")
    To replace ' Apostrophe
    replace (ExcelRS("Description"), "'", "''")

    Nawaz Ijaz
    Nawaz Ijaz [Lahore, Pakistan]
    Boy: He is big..i wont like to fight him...
    Achilles: Thatz Y no one wud remember u after thousand years...!!

  3. #3
    SitePoint Member
    Join Date
    Mar 2005
    Posts
    21
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I have tried this but it doesnot work out.because in replace function Replace,
    in this
    replace(expression,find,replace,start,count,compare) is the format of freplace.
    if i write replace("aasas","s","t",3)it delets starting two characters which is creratin probs


Bookmarks

Posting Permissions

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