Search results for query: *

I can't figure out how to set the path for the results of a verity search. If I have collection that catalogues and entire site, how do you link to the returned files given that these might be in distinct folders and subfolders. The only workaround I've found is to create a collection for every...

I'm using ultra dev 4.01 and can't get the server behaviour of restrict access to page to do anything much at all. In IE, it simply shows the cf code and the page beneath. In netscape, you move directly to the page with no trouble. I'm using a simple access database to authenticate users -- this...

Is it possible to use a form to interact with the cfreport tag? I'd like to be able to have users call information dynamically from a crystal report based on what is entered on a form. I will need to include cfif and else statements so that data doesn't have to appear in each form field.

I'm trying to setup a coldfusion forum that relies on an msaccess database. I've set the database up both using cold fusion administrator and as a system database under nt's control panel. Cold Fusion administrator makes a connection to the database -- it's there. Whenever I try and hit the...

Thanks to all who've contributed. Yes, the levels of grouping appears to be the solution. The data is now appearing the correct number of times. Now on to wrestle with getting it to display in the tables... Thanks again, cflearning.

I tried it with inner cfoutput tags as well before sending my last response. Adding cfoutput around student name, for example, results in the student name being duplicated. Adding it around cyb_course_code duplicates the course code and so on.

Thanks again. I tried to group by the first sort field as well -- same results, single entry for course but multiple entries for name, etc.

I've stripped out most of the table layout in the output, but you can see the complete query from here <CFQUERY name=&quot;Tracking&quot; datasource=&quot;datasource&quot; dbtype=&quot;ODBC&quot;> SELECT cyb_required_course_mast.&quot;cyb_org_id&quot...

I haven't got this all resolved yet. When I group by last name, the problem of the multiple names is addressed. But things like the course code and the lesson title continue to appear more than once in the output. If i put them in CFOUTPUT they really multiply. Is there a way of creating...

Thanks. I'll give that a try.