query problem

[cmartz]

I have an access database set up to allow multiple people per ticket number. I have the attached code to pull the data. The problem is that it only pulls one person even though there are 6 listed in the database. Any idea why this is? When I do a COUNT(tblTripTransactions.EmpID) I get the number 6 returned so it does know there are 6. Could the problem be that I need a loop around the select statement to be able to pull all 6 employee id's? I guess what I really need to do is get the empid in a string like (12,23,34,45) from the query.

[dave_cozens]

Have you verified that ikt's only returning 1 row.

Try
<cfdump var="#details#">

If that only has 1 row the query is the problem, if it has 6 then you'd probably better post the code to output it...

[cmartz]

That pulls back all 6 rows. I have attached my page code below.

[Dan_Bracuk]

I didn't see <cfoutput query="driver"> anywhere. Mind you I only looked at the visible code.

[dave_cozens]

You need something more like

<cfquery name="details">
details query here
</cfquery>
<Cfloop query="details">
<!---Output details data--->
<cfif details.Employee neq "">
<Cfquery name="driver">
driver query here
</cfquery>
<!---Output driver data--->
</cfif>
</cfloop>

[cmartz]

Could you put that into the current code I have because I am unable to see what you mean. I have the following but that doesn't change anything.

[azadisaryev]

wrong code for outputting the resultset of query "details": your code will always output only first row because you have not defined <cfoutput query="details">. change your page's code to the attached and all should work.