Search On FOX Data!

Discussion in 'ASP General' started by Amir Davoodi, Oct 18, 2003.

  1. Amir Davoodi

    Amir Davoodi Guest

    Dear Friends,
    I've got a web application using ASP, 65001 codepage and
    Microsft Access As DataStore.
    I have imported some data from FOX(DOS) into access and
    when I try to search on this data using T-SQL LIKE, it
    dosn't work correctly.
    Would you please help me,

    Thanks,
    Amir Davoodi.
     
    Amir Davoodi, Oct 18, 2003
    #1
    1. Advertising

  2. Amir Davoodi

    Dan Sikorsky Guest

    T-SQL uses LIKE '%abc%' syntax
    ACCESS uses LIKE '*abc*' syntax

    "Amir Davoodi" <> wrote in message
    news:094601c3957e$88d84a80$...
    > Dear Friends,
    > I've got a web application using ASP, 65001 codepage and
    > Microsft Access As DataStore.
    > I have imported some data from FOX(DOS) into access and
    > when I try to search on this data using T-SQL LIKE, it
    > dosn't work correctly.
    > Would you please help me,
    >
    > Thanks,
    > Amir Davoodi.
    >
     
    Dan Sikorsky, Oct 18, 2003
    #2
    1. Advertising

  3. Amir Davoodi

    Bob Barrows Guest

    Dan Sikorsky wrote:
    > T-SQL uses LIKE '%abc%' syntax
    > ACCESS uses LIKE '*abc*' syntax
    >

    This is true. However, if you use dynamic sql from your asp app, then you
    must use the ODBC wildcards: % and _. No matter what the database is.

    Bob Barrows
    --
    Microsoft MVP - ASP/ASP.NET
    Please reply to the newsgroup. This email account is my spam trap so I
    don't check it very often. If you must reply off-line, then remove the
    "NO SPAM"
     
    Bob Barrows, Oct 18, 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. mehul
    Replies:
    8
    Views:
    5,411
    Oliver Wong
    Nov 9, 2005
  2. Jack Klein

    Re: fox toolkit

    Jack Klein, Jul 10, 2003, in forum: C++
    Replies:
    0
    Views:
    446
    Jack Klein
    Jul 10, 2003
  3. gamaron

    Fox: best GUI Lib?

    gamaron, Oct 31, 2004, in forum: C++
    Replies:
    17
    Views:
    4,800
    Benjamin Lau
    Nov 11, 2004
  4. Pete
    Replies:
    2
    Views:
    318
    Phlip
    Apr 15, 2006
  5. Abby Lee
    Replies:
    5
    Views:
    443
    Abby Lee
    Aug 2, 2004
Loading...

Share This Page