Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Outputing variables that start with a number!

Status
Not open for further replies.

1510982

Programmer
Joined
Feb 17, 2002
Messages
57
Location
SI
Hello.

I have an old database, that has many linked tables and forms - so redefining names doesn't come handy.

The problem is the names start with number, for instance 1days, 2days, 3days.

Now, when I output them using #data.1days# the parser returns an error. How to let him now that i don't want to perform mathematical operation but do the query!

Please help, thanks
 
Try treating the query like a structure, see if that works:

QueryName
Code:
[
"ColumnName"
Code:
]
Code:
[
RowNumber
Code:
]

=== START CODE EXAMPLE ===
<cfoutput query=&quot;data&quot;>
[COLOR=666666]<!--- Get current row number --->[/color]
<cfset r = data.currentRow>
#data
Code:
[
&quot;1days&quot;
Code:
]
Code:
[
r
Code:
]
#

</cfoutput>
=== END CODE EXAMPLE === - tleish
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top