How to get ContentID Item to display in page????

I cannot get my code to call the ContentID of the Item alon to display. It calls the latest on.
How can I fix me Select Statement to call only the ContentID that matches the Request.QueryString ContentID. PLEASE HELP!!!!!!!

Simple I need to display the RelatedURL of the item being viewed on the page.

<%
DIM objRS, RelatedURL
ContentID = Request.QueryString("ContentID")
'mySQL = "SELECT * FROM Content ORDER BY DateAdded DESC" 
mySQL1 = "SELECT ContentID, ContentType, RelatedURL, DownloadURL, Thumbnail, FeaturedLabel, ShortDesc, LongDesc, Title AS Title " & _ 
	"FROM (Content LEFT JOIN ContentTypes ON Content.ContentTypeId = ContentTypes.ContentTypeId) " & _ 
	"WHERE ContentTypes.ContentTypeId = 7 AND Display=1 AND '" & strContentID &"' ORDER BY Priority, DateAdded DESC"



Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open mySQL1, objConn
%>





<embed src='<% =objRS("RelatedURL") %>&hl=en&fs=1&' width='340' height='260' type='application/x-shockwave-flash' wmode='transparent' allowscriptaccess="always" allowfullscreen="false"/></embed>



 <%

objRS.Close
Set objRS = Nothing
objConn.Close
Set objConn = Nothing
%>

Code (markup):

 

Hello
I Editted Your code but I don't know what's " & strContentID &"
Here is your code

<%
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.CursorLocation = 3
objConn.open strConn

DIM objRS, RelatedURL
ContentID = Request.QueryString("ContentID")
'mySQL = "SELECT * FROM Content ORDER BY DateAdded DESC" 
mySQL1 = "SELECT ContentID, ContentType, RelatedURL, DownloadURL, Thumbnail, FeaturedLabel, ShortDesc, LongDesc, Title " 
mySQL1 = mySQL1 & "FROM (Content LEFT JOIN ContentTypes ON Content.ContentTypeId = ContentTypes.ContentTypeId) " 
mySQL1 = mySQL1 & "WHERE ContentTypes.ContentTypeId = 7 AND Display=1 AND '" & strContentID &"' ORDER BY Priority, DateAdded DESC;"



Set objRS = ObjConn.Execute(mySQL1)
objRS.Open mySQL1, objConn
%>





<embed src='<% =objRS("RelatedURL") %>&hl=en&fs=1&' width='340' height='260' type='application/x-shockwave-flash' wmode='transparent' allowscriptaccess="always" allowfullscreen="false"/></embed>



 <%

objRS.Close
Set objRS = Nothing
Set objConn = Nothing
%>

Code (markup):

 

I think that you are missing something..
In one hand you are taking the queryString on this line:
ContentID = Request.QueryString("ContentID")

Then in the query you are concatinating as follows:
"WHERE ContentTypes.ContentTypeId = 7 AND Display=1 AND '" & strContentID &"' ORDER BY Priority, DateAdded DESC"

Well, where from you are getting data into strContentID????
You have to use Just ContentId like in the first line...


Isaac,
http://www.7Live7.com