![]() |
admin 11/25/2017 |
I recommend to enable detailed error messages in IIS settings. This way you can see the actual error message and fix your code quicker. |
V
|
VORONOY author 11/30/2017 |
I have two tables in 2 databases on different servers. I am trying to check if "ID"=data("SOMEID") exist in second "USERS" table and if does not exist - make cell red. 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")
|