splitting lines of code

[Brian]

if i wanted to split the below SQL statement on two lines, what would the
syntax be....

SQL = "UPDATE gallery WHERE g_id = " & Request.Form("g_id") &
"SET g_name = " &
Request.Form("g_name") &
"g_add = " &
Request.Form("g_add") "


thanks, brian.

 

[Aaron Bertrand - MVP]

stringValue = " ... long line ... " & _
" ... another line ... " & _
" ... another line ... "

 

[Tim Slattery]

if i wanted to split the below SQL statement on two lines, what would the
syntax be....

SQL = "UPDATE gallery WHERE g_id = " & Request.Form("g_id") &
"SET g_name = " &
Request.Form("g_name") &
"g_add = " &
Request.Form("g_add") "

This is apparently VBScript, so the line continuation character is an
underscore:

SQL = "UPDATE gallery WHERE g_id = " & Request.Form("g_id") & _
"SET g_name = " & Request.Form("g_name") & _
"g_add = " & Request.Form("g_add")