Hi all,
Got a bizarre problem here..
sSQL = "SELECT c.*, a.* "
sSQL = sSQL & "FROM tbl_Content_Page AS c LEFT JOIN tbl_Asset AS a ON
c.p_asset_id = a.asst_id "
sSQL = sSQL & "WHERE c.p_id = " & iCurrID
The above is my query, which is pretty straight forward. If data doesn't
exist in table A, it should return a recordset with empty fields in the
relevant A fields. Which it does fine when I run the query in Access.
However when I run the query in ASP, it returns an empty recordset. It's
doing my nut in here! Anyone any ideas why this might be?
Code is dead simple -
Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open sConn
sSQL = "SELECT c.*, a.* "
sSQL = sSQL & "FROM tbl_Content_Page AS c LEFT JOIN tbl_Asset AS a ON
c.p_asset_id = a.asst_id "
sSQL = sSQL & "WHERE c.p_id = " & iCurrID
Set oRS = oConn.Execute(sql)
I'm stumped!
Alastair
------------------------ Yahoo! Groups Sponsor --------------------~-->
Yahoo! Domains - Claim yours for only $14.70
http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/saFolB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
