Stuck - Jeffrey Bardzell Book MX2004 w/asp,coldfusion,php

[hmanvel]

Have struggled thru to chapter 12 of referenced book. Now at a point where I
cannot continue as the code doesnt work. I have triple checked everything,
hoping someone can help. The following code:

re_tourDetail.Source = "SELECT * FROM tbl_tours INNER JOIN tbl_country ON
tbl_country.countryID=tbl_tours.country WHERE tbl_country.region=" &
Request.QueryString("RegionID") & " ORDER BY tbl_country.countryName"
re_tourDetail.CursorType = 0
re_tourDetail.CursorLocation = 2
re_tourDetail.LockType = 1
re_tourDetail.Open()

returns the following error message:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in
query expression 'tbl_country.region='.
/newland/tours_detail.asp, line 14

Line 14 is the last line of code posted above. Missing operator? Does
anybody know whats wrong?

Thanks,
Harry Manvel

[delaneypub]

I don't have the book with me at the moment, but I'll take a guess at it. If
the value of Request.QueryString("RegionID") is blank or contains spaces, that
will cause a syntax error in your SQL. You can get around that by enclosing
that value in single quotes. Snippet:

...tbl_country.region='" & Request.QueryString("RegionID") & "' ORDER...

[hmanvel]

Thanks much. Unfortunately that didnt work.