[thelist] ASP Question

[Ken Kogler]

> [Microsoft][ODBC Microsoft Access Driver] Data type
> mismatch in criteria expression.

You've got the Data Type for one of these columns set to something other
than "text" or "memo". Fire up Access and check your db.

If it's the day field that's set to date, then this SQL should work for
you:

  sql = "INSERT INTO stuff(PostedBy,IpAddr,Day,Message) VALUES
  ('"&straddr&"',#"&strday&"#,'"&strip&"','"&strmsg&"')"

And if the IP field is set to number, then this should work:

  sql = "INSERT INTO stuff(PostedBy,IpAddr,Day,Message) VALUES
  ('"&straddr&"','"&strday&"',"&strip&",'"&strmsg&"')"

And if it's both:

  sql = "INSERT INTO stuff(PostedBy,IpAddr,Day,Message) VALUES
  ('"&straddr&"',#"&strday&"#,"&strip&",'"&strmsg&"')"

If none of those work for you, let us know and we can help further! :)

HTH!
--Ken