get the select statement without hex value using post method

Discussion in 'ASP General' started by eddie wang, Dec 12, 2003.

  1. eddie wang

    eddie wang Guest

    When I use the following to post my value, I got SQL like this:
    SELECT+A%2ECMPL%5FFIELD%5FID%2C+A%2ECMPL%5FFACILITY%.
    How to get the SELECT without those hex value. THanks.


    <FORM NAME='formname' METHOD=POST
    ACTION='ExcelExport.asp?noIncludes=yes'>
    <INPUT TYPE='Hidden' NAME='strSQL'
    VALUE="<%=replace(server.urlencode(strsql),"'","`")%>">
    <tr><td BGCOLOR=E4E4E4 ID='bodytext' COLSPAN='8' align='center'><input
    TYPE=SUBMIT value='export'></td></tr>
    </form>




    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
     
    eddie wang, Dec 12, 2003
    #1
    1. Advertising

  2. eddie wang

    Ray at Guest

    Why are you server.urlencoding it when you're not passing it through the
    url? Just don't server.urlencode it.

    Also, instead of replacing ' with `, replace ' with ''. (That's two
    apostrophes.)


    If my name were Jim O'Brien, I'd be pretty irritated that I showed up as Jim
    O`Brien. Actually, I wouldn't be, because I would have died in a
    parachuting accident in the 80s, but that's beside the point.

    Ray at work

    "eddie wang" <> wrote in message
    news:...
    > When I use the following to post my value, I got SQL like this:
    > SELECT+A%2ECMPL%5FFIELD%5FID%2C+A%2ECMPL%5FFACILITY%.
    > How to get the SELECT without those hex value. THanks.
    >
    >
    > <FORM NAME='formname' METHOD=POST
    > ACTION='ExcelExport.asp?noIncludes=yes'>
    > <INPUT TYPE='Hidden' NAME='strSQL'
    > VALUE="<%=replace(server.urlencode(strsql),"'","`")%>">
    > <tr><td BGCOLOR=E4E4E4 ID='bodytext' COLSPAN='8' align='center'><input
    > TYPE=SUBMIT value='export'></td></tr>
    > </form>
    >
    >
    >
    >
    > *** Sent via Developersdex http://www.developersdex.com ***
    > Don't just participate in USENET...get rewarded for it!
     
    Ray at, Dec 12, 2003
    #2
    1. Advertising

  3. eddie wang

    eddie wang Guest

    Yes, server.urlencode is the problem. Thanks for the help!

    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
     
    eddie wang, Dec 12, 2003
    #3
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Replies:
    10
    Views:
    6,269
    Neredbojias
    Aug 19, 2005
  2. Bengt Richter
    Replies:
    6
    Views:
    485
    Juha Autero
    Aug 19, 2003
  3. jack
    Replies:
    4
    Views:
    596
  4. tim

    hex string to hex value

    tim, Nov 22, 2005, in forum: Python
    Replies:
    8
    Views:
    18,957
  5. tim
    Replies:
    2
    Views:
    1,584
    Dennis Lee Bieber
    Nov 23, 2005
Loading...

Share This Page