Question:
Why do I get an “unterminated string constant” error message in this code?
<%set rs = server.CreateObject("adodb.recordset")rs.Open "select job_description from job_code_table where job_code = 'X123'", connString%>
Answer:
You can’t let your strings wrap onto multiple lines without using a continuation character. The continuation character is the underscore character, and you can build a long string like this:
rs.Open "select job_description " _ & "from job_code_table " _ & "where job_code = 'X123'", connString