SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Jan 2007
    Posts
    11
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    use of wild card in filters

    Iam using a filter in asp and it doesn't work with the wildcard '_' or even using IN it only works with LIKE '% (anydata) %'.
    In my table i have a column, which stores values as 1,23,40 etc.
    How do i get it to bring back all rows where X='1' and not X LIke '%1%'


    I get the following error message:

    'Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.'

    Thanks

  2. #2
    SitePoint Member
    Join Date
    Jan 2007
    Posts
    11
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Please ignore, i wasn't thinking straight when i wrote this. I know why it wasn't working.


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
  •