Concatenate lines of code with underscore?

General
1

Trying to write out my sql but i would like it to look like it does in my sql builder and not as one very long string. i tried this but i get a syntax error
sql=“SELECT " _
“e.employee_first_name” _
“,e.employee_last_name” _
“,d.departments_name” _
“,et.employee_type_name” _
“,p.position_name " _
“,wt.wage_name” _
" FROM employees e” _
" JOIN departments d ON employee_department = d.departments_id” _
" JOIN employee_type et ON employment_type=et.employee_type_id" _
" JOIN positions p ON employee_rank=p.position_id" _
" LEFT JOIN wage_type wt ON employee_wage_type=wt.wage_id" _
" WHERE employee_id=" + super_session.userID

2

You need to use the concatenation operator, IE:

var sql = "line1" + _
"line2" + _
"line3"
2 Likes
3

Ah thank you!

1 Like