Im getting HTTP 500 error with code below. If I use WHERE ID=12345 and not data("SOMEID") it works well for that ID.
Am I typing wrong syntax for rs.Open "select ID from USERS WHERE ID=" & data("SOMEID") &"", conn???
Set conn = Server.CreateObject("ADODB.Connection") conn.Open "Provider=SQLOLEDB;Server=SERVER;Uid=USER;Pwd=PASSWORD;Database=TEST" set rs = Server.CreateObject("ADODB.Recordset") rs.Open "select ID from USERS WHERE ID=" & data("SOMEID") &"", conn If data("SOMEID")<>rs("ID") then record("SOMEID_style") = "style=""background:red""" end if
Thank you!