Resuelto! Ayuda con programa simple en ColdFusion
Publicado por Alejandro de la Rosa (5 intervenciones) el 05/06/2010 15:36:52
Resuelto!
<cfquery name="test" datasource="test">
select
companies.company, staff.first, staff.last
from
staff
inner join companies on staff.idcompany = companies.idcompany
order by companies.company, staff.first, staff.last
</cfquery>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Users Report</title>
</head>
<body>
<cfoutput query="test" group="company">
<b><br>#company#<br></b><br>
<cfoutput> -#first#, #last#<br>
</cfoutput>
</cfoutput>
</body>
</html>
<cfquery name="test" datasource="test">
select
companies.company, staff.first, staff.last
from
staff
inner join companies on staff.idcompany = companies.idcompany
order by companies.company, staff.first, staff.last
</cfquery>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Users Report</title>
</head>
<body>
<cfoutput query="test" group="company">
<b><br>#company#<br></b><br>
<cfoutput> -#first#, #last#<br>
</cfoutput>
</cfoutput>
</body>
</html>
Valora esta pregunta
0