Use Underscores When Dealing With Long Strings

Use Underscores When Dealing With Long Strings


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%>


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

See also  Comparing different methods of testing your Infrastructure-as-Code

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist