*Solved* Custom query design troubles

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Solved Custom query design troubles

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> *Solved* Custom query design troubles

Page: [1]


lovduv Posts: 152 Joined: 8/30/2005 Status: offline	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 < Message edited by lovduv -- 11/16/2005 23:28:09 >


Spooky Posts: 26606 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: Custom query design troubles - 11/16/2005 14:27:38 Check out this : http://www.outfront.net/spooky/adv_grouping.htm _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem ��k� Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to lovduv)


lovduv Posts: 152 Joined: 8/30/2005 Status: offline	RE: Custom query design troubles - 11/16/2005 23:27:16 Thank you! I love this site! I can't wait until I can help out and actually answer a question, instead of just asking them . lovduv (in reply to Spooky)