|
lovduv -> *Solved* Custom query design troubles (11/16/2005 10:21:08)
|
I have a DRW with the following custom query:
fp_sQry="SELECT * FROM Blog,Comments WHERE (UserName = 'Missy') ORDER BY DateAdded DESC"
fp_sDefault=""
fp_sNoRecords="No records returned."
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&BlogID=3&UserID=3&UserName=202&DateAdded=135&RemoteAddress=202&Image=202&BlogPost=203&CommID=3&BlogID=3&CommDate=135&CommAddress=202&Comment=203&CommName=202&"
fp_iDisplayCols=6
fp_fCustomQuery=True
BOTID=1
fp_iRegion=BOTID
%>
The DRW uses the custom query to pull from two tables, one table has blogs, one table has comments on the blogs, I joined my tables, and the query works.
However (theres always a however[:(]),
The field value for BlogPost shows for each comment, so it displays like this:
BlogPost 1
Comment (comment 1 on above post)
BlogPost 1
Comment (comment 2 on above post)
BlogPost 1
Comment (comment 3 on above post)
I want it to display like this:
BlogPost 1
Comment 1
Comment 2
Comment 3
I tried building a query in access and using that as my recod source, but that didn't work either, any suggestions?
lovduv
|
|
|
|
