Problem with % in ASP

Ask a Question related to ASP Components, Design and Development.

  1. #1

    Default Problem with % in ASP

    Hello!
    I have a SELECT comand passed trhough ASP like This:

    SELECT PK_A_MSGID, C3_MSG, C3_MSGPT, C3_MSGEN FROM S_MSGS WHERE C3_MSG LIKE
    ""%Efectuar%"" ORDER BY PK_A_MSGID

    and when i pass it it gives me:

    SELECT PK_A_MSGID, C3_MSG, C3_MSGPT, C3_MSGEN FROM S_MSGS WHERE C3_MSG LIKE
    "ïectuar" ORDER BY PK_A_MSGID

    Why? how can i correct this?
    Thanks


    webfox Guest

  2. Similar Questions and Discussions

    1. contribute problem - access denied file may not existpermission problem
      Recieving the following error message - "access denied file may not exist , or there could be a permission problem" this happened this morning ,...
    2. Problem playing Quicktime thru .DCR embedded in HTML - pathreferencing problem?
      Greetings earthlings and Director heads. Here's the problem: created an HTML file containing shockwave (dcr) movie that calls quicktime movies in...
    3. Uploading problem = weird warning (was: access denied problem.....)
      Hi, I had a problem where my upload form was not working on our production server but was working on two other servers, after checking the...
    4. #21611 [Opn]: Problem with version_compare() (Was: Problem with pear cli and release numbers)
      ID: 21611 Updated by: et@php.net -Summary: Problem with pear cli and release numbers Reported By: jan at horde...
    5. Problem with Apache Web Server config file and PHP (please give advice on what problem may be me)
      HI: Can anyone refer me to someone that can help with the problem below. I installed Apache Web Server on my laptop which has Windows XP. I...
  3. #2

    Default Re: Problem with % in ASP

    Asked and answered in .general, still.
    Again, [url]www.aspfaq.com/5003[/url]

    Ray at home

    "webfox" <webfox@sapo.pt> wrote in message
    news:ewmP49dkDHA.708@TK2MSFTNGP10.phx.gbl...
    > Hello!
    > I have a SELECT comand passed trhough ASP like This:
    >
    > SELECT PK_A_MSGID, C3_MSG, C3_MSGPT, C3_MSGEN FROM S_MSGS WHERE C3_MSG
    LIKE
    > ""%Efectuar%"" ORDER BY PK_A_MSGID
    >
    > and when i pass it it gives me:
    >
    > SELECT PK_A_MSGID, C3_MSG, C3_MSGPT, C3_MSGEN FROM S_MSGS WHERE C3_MSG
    LIKE
    > "ïectuar" ORDER BY PK_A_MSGID
    >
    > Why? how can i correct this?
    > Thanks
    >
    >

    Ray at Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139