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
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
