SQL Question Again - (hit enter and sent first attempt)

Discussion in 'MCSD' started by Guest, Sep 18, 2004.

  1. Guest

    Guest Guest

    Trying to create a search string to handle searching within an MSAccess TEXT
    field. Having problems when the variable is numeric
    Tried: (spaces expanded for clarity)

    strWhere = strFieldName & "= ' " & cstr(vVariable) & " ' " - raised an error
    when vVariable is numeric

    tried testing for numeric value first:
    if IsNumeric(vVariable) then
    strWhere = strFieldName & "=" & val(vVariable)
    else
    strWhere = strFieldName & "= ' " & cstr(vVariable) & " ' "
    end if

    This also didn't work. What's the work around on this?
    Thanks in advance for any help offered
    Owen Schwer
     
    Guest, Sep 18, 2004
    #1
    1. Advertisements

  2. Guest

    Guest Guest

    Post question of this sort to the following:
    microsoft.public.access.queries
    microsoft.public.vb.general.discussion
    WKidd
     
    Guest, Sep 18, 2004
    #2
    1. Advertisements

  3. Guest

    Tom Dacon Guest

    For numeric values, it's:
    strWhere = strFieldName & "=" & cstr(vVariable)
    you want it come out something like:
    WHERE Price = 12

    for string values, you need to enclose the string in single-quotes, so it:
    strWhere = strFieldName & "= ' " & vVariable & " ' "
    you want it to come something like:
    WHERE State = 'Washington'

    There are better places than this to post programming questions, especially
    something like a question about an SQL query. Microsoft has many newsgroups
    that are devoted to programming subtopics. Why on earth would you post this
    to a newsgroup that's dedicated to Microsoft MCSD certification instead of
    one of those?

    Tom Dacon
    Dacon Software Consulting
     
    Tom Dacon, Sep 18, 2004
    #3
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.