Previous Discussion	Next Discussion

Categorised SQL Listing Hello All. Wondered if there would be anyone from days of yore still knocking around like ghosts in the machine. If so, someone might be able to help me. I have a small data list on a SQL server table named techInfo. I am using ASP.NET and MS SQL server 2000 although I think the SQL command string is independant of parent file type? I can do the obvious [SELECT * FROM techInfo order By techInfoTitle] Which renders in a Repeat Region Steam driven Wristwatch Steam driven Wristwatch manual Steam driven Wristwatch Steam driven Wristwatch Tech Data Steam driven Wristwatch Steam driven Wristwatch Gauantee Forms   Solar Powered Pogostick Solar Powered Pogostick manual Solar Powered Pogostick Solar Powered Pogostick Tech Data Solar Powered Pogostick Solar Powered Pogostick Gauantee Forms Whereas, what I would like to create is Steam driven Wristwatch Steam driven Wristwatch manual Steam driven Wristwatch Tech Data Steam driven Wristwatch Gauantee Forms   Solar Powered Pogostick Solar Powered Pogostick manual Solar Powered Pogostick Tech Data Solar Powered Pogostick Gauantee Forms Where the category only shows the first instance I have been experimenting along the lines of [SELECT techInfoTitle FROM techInfo AS Product, techInfoLink GROUP BY techInfoTitle ORDER BY By techInfoTitle] Any pointers would be greatly appreciated. Started By Jockrock on Jul 11, 2009 at 3:14:07 PM

12 Response(s) | Reply

Earlier Replies | Replies 6 to 12 of 12 | Later Replies Goto Page: 2 1

bod1467 on Jul 13, 2009 at 12:45:20 AM (# 6) Nothing will happen unless he also removes the ' at the start of the line. ;-) Jockrock on Jul 13, 2009 at 5:39:32 AM (# 7) LOL @ Bod1467 Monte - Same result! I am close to giving up and devising another method - transfer to XML or something! Monte on Jul 13, 2009 at 6:48:02 AM (# 8) This message has been edited. What is MEcatInner supposed to be? Is it a class you have defined somewhere? If so, what does Filter look like? Here are a few articles regarding the error: http://www.adopenstatic.com/FAQ/800a0bb9.asp http://support.microsoft.com/kb/197323 http://support.microsoft.com/kb/190743 http://www.daniweb.com/forums/thread48281.html# And one more... http://kb2.adobe.com/cps/190/tn_19069.html So based on those, it looks like it could possibly be a Query error. Jockrock on Jul 13, 2009 at 7:26:02 AM (# 9) This message has been edited. MEcat is the recordset that reads the category table and MEcatInner is the recordset that reads the categorised content table. I'll check out those links. Thanks Monte on Jul 13, 2009 at 7:38:14 AM (# 10) Let me know what the result is. If you find a solution, I'd be curious as to what it is. Monte on Jul 20, 2009 at 8:10:39 AM (# 11) Did you figure this out, Jockrock? Jockrock on Aug 4, 2009 at 2:47:56 AM (# 12) Never have figured it yet. It is part of a very large project but I have sidelined that issue until I get back to it. Which is looming!!!

Earlier Replies | Replies 6 to 12 of 12 | Later Replies Goto Page: 2 1

To respond to a discussion, you must first logon.

If you are not registered, please register yourself to become a member of the SiteExperts.community.