I am trying to get a sql string on an ASP.Net page to work. I want the web page to only show spa stores that have a listingtype that is equal to National.
Here's the error code that I am getting:
Compiler Error Message: BC30205: End of statement expected.
Source Error:
|
Line 33:
Line 34: 'Add Order By
Line 35: strSQL = strSQL & "where ListingType="National"
Line 36: strSQL = strSQL & " Order By SpaStoreName"
|
Here's my code:
'Start SQL statement
strSQL = "Select * From SpaStore"
'Add Order By
strSQL = strSQL & "where ListingType="National" strSQL = strSQL & " Order By SpaStoreName"
I also tried 'National'" and '"National"'", but they didn't work.