Welcome to WebmasterWorld Guest from 3.80.38.5

Forum Moderators: ocean10000

Message Too Old, No Replies

how can I break this into multiple lines

     
5:58 pm on Jun 25, 2010 (gmt 0)

Preferred Member

10+ Year Member

joined:Nov 24, 2005
posts:429
votes: 0


How can I break this into multiple lines to avoid so much horizontal scrolling on my screen?


strQuery = "Update tblBrokerRegistration set FNAME=@FNAME, LNAME=@LNAME, COMPANY=@COMPANY, ADDRESS=@ADDRESS, CITY=@CITY, STATE=@STATE, ZIP=@ZIP, PHONE=@PHONE, FAX=@FAX, REP_NAME=@REP_NAME, MAILING_LIST=@MAILING_LIST, EMAIL_ADDRESS=@EMAIL_ADDRESS, USERNAME=@USERNAME, PASSWORD=@PASSWORD, ACTIVE=@ACTIVE, ROLE_LEVEL=@ROLE_LEVEL, LAST_UPDATED=@LAST_UPDATED WHERE ID=@ID"
6:20 pm on June 25, 2010 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Feb 1, 2005
posts:732
votes: 0


You can do one of the following:

dim strQuery as String
strQuery = "UPDATE tblBrokerRegistration "
strQuery += "SET FNAME=@FNAME, LNAME=@LNAME, COMPANY=@COMPANY, "
strQuery += "ADDRESS=@ADDRESS, CITY=@CITY, STATE=@STATE, ZIP=@ZIP, PHONE=@PHONE, FAX=@FAX, "
etc... etc...


or

dim strQuery as String
strQuery = "UPDATE tblBrokerRegistration " & _
"SET FNAME=@FNAME, LNAME=@LNAME, COMPANY=@COMPANY, " & _
"ADDRESS=@ADDRESS, CITY=@CITY, STATE=@STATE, ZIP=@ZIP, PHONE=@PHONE, FAX=@FAX, " & _
etc... etc...
7:09 pm on June 25, 2010 (gmt 0)

Preferred Member

10+ Year Member

joined:Nov 24, 2005
posts:429
votes: 0


Thanks Marcel. #2 seems a little easier and it worked fine.
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members