Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > splitting lines of code

Reply
Thread Tools

splitting lines of code

 
 
Brian
Guest
Posts: n/a
 
      01-20-2004
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.


 
Reply With Quote
 
 
 
 
Aaron Bertrand - MVP
Guest
Posts: n/a
 
      01-20-2004
stringValue = " ... long line ... " & _
" ... another line ... " & _
" ... another line ... "

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




"Brian" <(E-Mail Removed)> wrote in message
news:bukd8q$jig$(E-Mail Removed)...
> 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.
>
>



 
Reply With Quote
 
 
 
 
Tim Slattery
Guest
Posts: n/a
 
      01-21-2004
"Brian" <(E-Mail Removed)> 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)
http://www.velocityreviews.com/forums/(E-Mail Removed)
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem splitting lines in a file Mothra Perl 1 01-12-2005 02:09 PM
splitting a long token across lines Nakamura Python 4 04-04-2004 10:16 PM
Re: Splitting up the definitions of a class into different files (splitting public from private)? John Dibling C++ 0 07-19-2003 04:41 PM
Re: Splitting up the definitions of a class into different files (splitting public from private)? Mark C++ 0 07-19-2003 04:24 PM
Re: Splitting up the definitions of a class into different files (splitting public from private)? John Ericson C++ 0 07-19-2003 04:03 PM



Advertisments