Breaking line in sql 2

[A1Pat]

Could someone help me to fix the breakdown line in this sql code. It's too long and the break I use is incorrected.

sql1 = "SELECT p1.Cat1ID, p1.Cat2ID, c1.Cat1Name, c2.Cat2Name _
FROM tblProducts AS p1, tblMainCat AS c1, tblCat2nd AS c2 _
WHERE p1.Cat1ID = c1.ID AND p1.Cat2ID = c2.ID AND Cat1Name = '" & request.querystring("maincat") & "'

 

[GaryC123]

You're missing quotation marks from the end of the lines
sql1 = "SELECT p1.Cat1ID, p1.Cat2ID, c1.Cat1Name, c2.Cat2Name" _
FROM tblProducts AS p1, tblMainCat AS c1, tblCat2nd AS c2" _
WHERE p1.Cat1ID = c1.ID AND p1.Cat2ID = c2.ID AND Cat1Name = '" & request.querystring("maincat") & "'"

http://www.eatdrinkandsleep.com

 

[A1Pat]

are you sure GaryC123, b/c I did try that but I got an ERROR:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement

 

[Nevermoor]

sql1 = "SELECT p1.Cat1ID, p1.Cat2ID, c1.Cat1Name, c2.Cat2Name"& _
"FROM tblProducts AS p1, tblMainCat AS c1, tblCat2nd AS c2"& _
"WHERE p1.Cat1ID = c1.ID AND p1.Cat2ID = c2.ID AND Cat1Name = '" & request.querystring("maincat") & "'"

 

[GaryC123]

And from the beginning and &

sql1 = "SELECT p1.Cat1ID, p1.Cat2ID, c1.Cat1Name, c2.Cat2Name" & _
"FROM tblProducts AS p1, tblMainCat AS c1, tblCat2nd AS c2" & _
"WHERE p1.Cat1ID = c1.ID AND p1.Cat2ID = c2.ID AND Cat1Name = '" & request.querystring("maincat") & "'"

http://www.eatdrinkandsleep.com

 

[A1Pat]

Great... Thank you!