Data type mismatch in criteria expression ??? WHAT?

Discussion in 'C#' started by cuni18, Feb 28, 2008.

0
  1. #1
    Hi

    i keep getting this error
    Data type mismatch in criteria expression.

    on this line

    SQLDef1 = "SELECT kartice_osobe_upit.* FROM kartice_osobe_upit WHERE kartice_osobe_upit.id_user=" & session("id_dealer")

    ? can someone help me

    Urgent
     
    cuni18, Feb 28, 2008 IP
  2. dylanmills

    dylanmills Peon

    Messages:
    50
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #2
    With the way the expression is set up, the value assigned to kartice_osobe_upit.id_user needs to be a number. Most likely, you are receiving the error because session("id_dealer") is a string.

    If kartice_osobe_upit.id_user needs to be a number, try changing the expression to:

    SQLDef1 = "SELECT kartice_osobe_upit.* FROM kartice_osobe_upit WHERE kartice_osobe_upit.id_user=" & cLng(session("id_dealer"))

    If kartice_osobe_upit.id_user needs to be a string, try changing the expression to:

    SQLDef1 = "SELECT kartice_osobe_upit.* FROM kartice_osobe_upit WHERE kartice_osobe_upit.id_user='" & session("id_dealer") & "'"
     
    dylanmills, Feb 28, 2008 IP
  3. cuni18

    cuni18 Well-Known Member

    Messages:
    314
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    105
    #3
    it works now thanks ...
     
    cuni18, Feb 28, 2008 IP