DataRow[] and Select(filter with a like clause) question

Ask a Question related to ASP.NET General, Design and Development.

  1. #1

    Default DataRow[] and Select(filter with a like clause) question

    I am using the Select method on a DataTable to return a DataRow[]
    filter = (width LIKE '%width="[1-9][0-9]%')

    I am getting an exception saying my filter is invalid
    I narrowed it down to the part that reads [1-9][0-9]

    if I eliminate this part it works.
    Is there a way to accomplish what I'm tring to do?


    Thanks,

    Ron Vecchi


    Ron Vecchi Guest

  2. Similar Questions and Discussions

    1. Using 'IN' clause with mutli-select listbox
      Hi All, Common sense tells me I'm missing something, but I need help here! I have a dynamically populated listbox that I'd like to use to query...
    2. IO::Filter::gzip question
      Can someone tell me how to extract the uncompressed data from the returned value using the script below? I try and print the $fio variable, but I get...
    3. DataRow, WebService question
      I am writing a WindowsForms based application that uses WebServices to add records to a SQL Server database, and later query those, and other...
    4. Using Select method and LIKE expression to return DataRow[]
      I am using the Select method on a DataTable to return a DataRow filter = (width LIKE '%width=\"%') I am getting an exception saying my filter is...
    5. Help a newbie! How do I SELECT using a string as a WHERE clause?
      Hi, I'm having a problem. I've found that running a recordset with the query: SELECT * FROM user; works fine, but as soon as I add a...
  3. #2

    Default Re: DataRow[] and Select(filter with a like clause) question

    Heres my filter again, I gave you the Sql version without the escaped ".
    Just to clarify

    filter = width LIKE '%width=\"[1-9][0-9]%'



    "Ron Vecchi" <vencenzo@comcast.net> wrote in message
    news:ei%23CC%23DVDHA.1832@TK2MSFTNGP09.phx.gbl...
    > I am using the Select method on a DataTable to return a DataRow[]
    > filter = (width LIKE '%width="[1-9][0-9]%')
    >
    > I am getting an exception saying my filter is invalid
    > I narrowed it down to the part that reads [1-9][0-9]
    >
    > if I eliminate this part it works.
    > Is there a way to accomplish what I'm tring to do?
    >
    >
    > Thanks,
    >
    > Ron Vecchi
    >
    >

    Ron Vecchi Guest

  4. #3

    Default DataRow[] and Select(filter with a like clause) question

    I am using the Select method on a DataTable to return a DataRow[]
    filter = (width LIKE '%width="[1-9][0-9]%')

    I am getting an exception saying my filter is invalid
    I narrowed it down to the part that reads [1-9][0-9]

    if I eliminate this part it works.
    Is there a way to accomplish what I'm tring to do?


    Thanks,

    Ron Vecchi


    Ron Vecchi 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