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 ... "

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/


"Brian" <qu******@iol.ie> wrote in message
news:bu**********@kermit.esat.net...

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.

[Tim Slattery]

"Brian" <qu******@iol.ie> wrote:

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")

--
Tim Slattery
MS MVP(DTS)
Sl********@bls.gov