21 lines
631 B
Plaintext
21 lines
631 B
Plaintext
|
|
|
|
|
|
|
|
<cfquery name="qRead" datasource="#request.DS#">
|
|
select
|
|
d.abstract_service_id as entity_id, d.abstract_service_doc_id as doc_id, d.abstract_service_doc as title, datalength(d.doc) as doc_size, d.contenttype, d.fname,
|
|
a.login as creator, a.shortname as creator_name, u.login as modifier, u.shortname as modifier_name
|
|
from abstract_service_doc d
|
|
left outer join usr a on (d.creator_id=a.usr_id)
|
|
left outer join usr u on (d.modifier_id=u.usr_id)
|
|
</cfquery>
|
|
<!---<cfdump var=#qRead#/>--->
|
|
|
|
|
|
|
|
|
|
<cfoutput query="qRead">
|
|
<a href="doc_get.cfm?entity=abstract_service&doc_id=#doc_id#&action=download">#title#</a>
|
|
<br/>
|
|
</cfoutput> |