Hi Bill,
>even with
> <cfoutput query="qget#name#" maxrows=1>
> <tr>
> <td width="40%">
> <font face="Verdana, Arial, Helvetica,
>sans-serif"><b><font size="3" color="red">#ucase(name)#</font></b>
></font></td>
> <td width="60%"> </td>
> </tr>
> </cfoutput>
>
>it still screws up half the time
You are using the same variable "name" twice over, one is part of the name
of the query, which should be fixed, the second is part of the result set,
which is not. You should evaluate the query's name first and put scoping in
at least so it could look like:
<cfset QryName = evaluate("qget#name#")
<cfoutput query="#QryName#" maxrows=1>
<cfset DispName = ucase(evaluate("#QryName#.#name#"))
and the second part is then just: #DispName#
I think that is about right, forgive me if it is not, it is Sunday arvo
here and I am doing manual labour, not exactly in programming mode :-)
Better still change the variable name that you are using to get the query
name so it is something else :-)
--
Yours,
Kym
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
