FROM dbo.tblWeblog, dbo.tblUserComments
WHERE tblWeblog.blogID = MMColParam2
ORDER BY blogDate DESC
variable name = MMColParam2
variable default value = 0
variable Run-Time value = Request.QueryString("blogID")
I'm trying to return the records that have the same blogID in both tables. I created a one to many relationship between the two table using the primary key blogID in tblWeblog and a foreign key field "blogID" in tblUserComments. The above query returns all records in tblUserComments and isn't associated to a specific blogID number.
I'm not sure, is the querystring value in URL string a string value? The data type for the field blogID in both tables is an integer. Could that be the problem? Or, is the problem related to the query?