I don't have a Mambo solution, but here is some HTML/JavaScript that will work:
<table id="tbl_explanation" style="display='none'">
<tr><td>blah</td></tr>
</table>
<a href="#" onClick="javascript: document.getElementById('tbl_explanation').style.display='';">open</a>
<a href="#"...
I don't have any specific suggestions, but here is a link that could help you find something:
http://www.hotscripts.com/PHP/Scripts_and_Programs/FAQ_and_Knowledgebase/index.html
Peter Sankauskas
Web Developer
http://www.kangasoft.com/
I am fairly confident that what you are trying to do cannot be done in SQL alone. You need just a little bit of code to do some processing after the SQL statement has been executed. You could write a stored proceedure or use another scripting/programming language to do what you are after.
What...
If you want to just add a column with all ones, then you can do the following:
SELECT NAME, 1 AS GM
FROM employees
Peter Sankauskas
Web Developer
http://www.kangasoft.com/
Ok, first of all, Coldfusion's query of a query does not perform very efficiently and should probably be avoided if possible.
I believe you can simplify your code a great deal. Since both of your database queries are in the same datasource, you can do everything in one <cfquery>
To start, try...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.