Results 1 to 2 of 2

Thread: SQL Statement and Type Mismatch

  1. #1

    Thread Starter
    Addicted Member Mage33's Avatar
    Join Date
    Aug 2000
    Location
    Petaluma, California
    Posts
    138

    Arrow

    Any idea why this:

    strSQL = "SELECT * "
    strSQL = strSQL & "FROM t_events "
    strSQL = strSQL & "WHERE " & inSTR 1,te_keywords,vKeyWords) > 0
    strSQL = strSQL & " AND " & inSTR(1, te_region,vRegion) > 0

    rs.Open strSQL

    would give me a type mismatch (on the very first line)
    Stephen Haney- 115 116 101 118 101 31 72 65 78 69 89
    -ShardsOfSilence.net- ^ My name in ASCII ^
    You forget something new every day
    | WinME | VB6 Pro | MSC++ | Lambda MOO |

  2. #2

    Thread Starter
    Addicted Member Mage33's Avatar
    Join Date
    Aug 2000
    Location
    Petaluma, California
    Posts
    138

    Um... Duh!

    Nevermind, I figured out that I can't do that and instead went with "like" which is working.
    Stephen Haney- 115 116 101 118 101 31 72 65 78 69 89
    -ShardsOfSilence.net- ^ My name in ASCII ^
    You forget something new every day
    | WinME | VB6 Pro | MSC++ | Lambda MOO |

Posting Permissions

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



Click Here to Expand Forum to Full Width