asp

sql string

[vanjamier]

This is my sql statement:
sqlstr = "SELECT LoanTab.TransId, ItemTab.Item, relationTab.Quantity FROM ItemTab INNER JOIN

relationTab ON ItemTab.ItemId = relationTab.ItemId INNER JOIN

LoanTab ON relationTab.TransactionId = LoanTab.TransId INNER JOIN

UserTab ON LoanTab.BorrowerId = UserTab.Id
WHERE (UserTab.Name = &strUser& )

set rs = objConn.execute(sqlstr)

However this is the error i get:

Unterminated string constant
sqlstr = "SELECT LoanTab.TransId, ItemTab.Item, relationTab.Quantity FROM ItemTab INNER JOIN
--------------------------------------------------------------------------------------------^

[txbakers]

In VB you can't put a carriage return without closing the string. VB sees the CR as the end of statement much the same way Java sees the semi-colon.

You can make one long string, or concatenate on separate lines for clarity:

sqlstr = sqlstr & " blah blah "

etc.

[mattglet]

Change it to:

sqlstr = "SELECT LoanTab.TransId, ItemTab.Item, relationTab.Quantity FROM ItemTab INNER JOIN " & _
"relationTab ON ItemTab.ItemId = relationTab.ItemId INNER JOIN " & _
"LoanTab ON relationTab.TransactionId = LoanTab.TransId INNER JOIN " & _
"UserTab ON LoanTab.BorrowerId = UserTab.Id " & _
"WHERE (UserTab.Name = &strUser& )"

set rs = objConn.execute(sqlstr)

[vanjamier]

Thanks New.

Cheers