Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_web_howto thread: Unterminated String Constant


Message #1 by "Nadia Hamza" <hamzan@s...> on Fri, 29 Mar 2002 00:13:11
Hi,

I've got some very long sql statements that I don't want to put all on the 
same line.  I get the following error when I try and split it up.

Unterminated string constant 

/conferences/2002/marina/edit353.asp, line 93 

sql = "SELECT tContacts.CID, tContacts.Title, tContacts.FName, 
tContacts.LName, tContacts.Wcompany,_

What am I doing wrong?

Thanks!!!!!

Nadia


Message #2 by Sonderman Fred W Contr OD4/DM <Fred.Sonderman@O...> on Fri, 29 Mar 2002 04:59:41 -0000
try this 

sql = "select tContacts.CID, tContacts.Title, tContacts.FName," &_
	"tContacts.LName, tContacts.Wcompany"

Bill

-----Original Message-----
From: Nadia Hamza [mailto:hamzan@s...]
Sent: Thursday, March 28, 2002 4:13 PM
To: ASP Web HowTo
Subject: [asp_web_howto] Unterminated String Constant


Hi,

I've got some very long sql statements that I don't want to put all on the 
same line.  I get the following error when I try and split it up.

Unterminated string constant 

/conferences/2002/marina/edit353.asp, line 93 

sql = "SELECT tContacts.CID, tContacts.Title, tContacts.FName, 
tContacts.LName, tContacts.Wcompany,_

What am I doing wrong?

Thanks!!!!!

Nadia



---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20
Message #3 by "John" <jpmiller@a...> on Fri, 29 Mar 2002 10:47:31 -0500
Try something like this:

sql = "SELECT tContacts.CID, tContacts.Title, tContacts.FName, "
sql = sql & "tContacts.LName, tContacts.Wcompany,..."

HTH,
John Miller
jpmiller@a...


----- Original Message -----
From: "Nadia Hamza" <hamzan@s...>
To: "ASP Web HowTo" <asp_web_howto@p...>
Sent: Friday, March 29, 2002 12:13 AM
Subject: [asp_web_howto] Unterminated String Constant


> Hi,
>
> I've got some very long sql statements that I don't want to put all on the
> same line.  I get the following error when I try and split it up.
>
> Unterminated string constant
>
> /conferences/2002/marina/edit353.asp, line 93
>
> sql = "SELECT tContacts.CID, tContacts.Title, tContacts.FName,
> tContacts.LName, tContacts.Wcompany,_
>
> What am I doing wrong?
>
> Thanks!!!!!
>
> Nadia
>
>
>
> ---
>
> Improve your web design skills with these new books from Glasshaus.
>
> Usable Web Menus
> http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
> r-20
> Constructing Accessible Web Sites
> http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
> r-20
> Practical JavaScript for the Usable Web
> http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
> r-20


  Return to Index