Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

SQL LIKE doesn't seem to work

so now i have :
"SELECT * From Table where Field LIKE '01*';"

Premise:
1. Field is of type text/string.
2. I'm using IIS v 5.0 of XP service pack 2.
3. I'm using MS Access mdb driver for my connection rather than OLEDB or ODBC.
4. I know my code works beacuse if I use :
"SELECT * From Table where Field LIKE= 'criteria';"
it works fine.
5. I know it should return a match since i efinitely have texts that start with "01".
6. I'm using MS Access of MS office2000.

Question:
1. is this a bug or i'm doing anything wrong?
2. any suggestions or loop around on this?

Thanks in advance.

weaps


Comments

  • sahil_bca18sahil_bca18 Member Posts: 22
    hey dude,

    i think u have messed wid the DSN(data source name)
    have u created a DSN for ur database...???

    if not u shud create one, cause it'll definitely ease up ur coding...
    try this out...!!
    (SHONKS)

  • weapon__xweapon__x Member Posts: 138
    : hey dude,
    :
    : i think u have messed wid the DSN(data source name)
    : have u created a DSN for ur database...???
    :
    : if not u shud create one, cause it'll definitely ease up ur coding...
    : try this out...!!
    : (SHONKS)
    :
    :
    yo dude i think you're the messed up...
    i'm not using ODBC as i've said...
    nice try though... try again...

    baboy... baboy...
    weaps
  • weapon__xweapon__x Member Posts: 138
    : hey dude,
    :
    : i think u have messed wid the DSN(data source name)
    : have u created a DSN for ur database...???
    :
    : if not u shud create one, cause it'll definitely ease up ur coding...
    : try this out...!!
    : (SHONKS)
    :
    :
    premise number 3... states that i'm not using ODBC or OLEDB. (no DSN over here, maybe you don't know why but i can explain-->
    i don't have enough privilege in the server, to make ODBC/DSN...
    thanks though,


    weaps
  • weapon__xweapon__x Member Posts: 138
    this should read...
    "SELECT * FROM Table where Field LIKE '1%'"; instead of

    "SELECT * FROM Table where Field LIKE '1%'";


    baboy... baboy...

    weaps

Sign In or Register to comment.