sql questions, problem with select *
I am using coldfusion to pass a URL variable in a link:
I know it is being passed correctly because it shows up in the address bar of the linked page called docDetail.
<a href="docDetail.cfm?Job_Number=<cfoutput>#url.RecordID#</cfoutput>">View documents for this record</a>
On the docDetail page is my sql query:
The problem is that it is only displaying one record - the last one - for any given job number. I may have several different documents that all have the same job number but only the last one is being displayed. I am simply using cfoutput to display them in a table.
<cfquery name="q_docDetails" datasource="PLOG">
WHERE Job_Number = '#URL.Job_Number#'
ORDER BY DocName DESC
"i walk in stride with people much taller than me and partly it's the boots but mostly it's my chi and i'm becoming transfixed with nature and my part in it which i believe just signifies i'm finally waking up "