If you're asking how to display a hash character (#) inside a CFOUTPUT, just double it up - ie in your code put "##" - that'll display the symbol.
No, I tried this, I retrieve the name of the field. not the data.
The problem, is that the value returned is surrounded by these 2 #.
Which nobody want.
This is only since I upgrade to Access 2007.
I will try on another field.
Thanks for contribution.
What do you get if you CFDUMP liste_ad?
It looks to me liek those extra pound-signs are in your data. If they shouldn't be there: get rid. CF's just doing what it's been told to.
You may be right, CFDUMP gives same result.
But I tried on other fields, and I do not have these problems.
May be, the # are not seen in the Access display table for that field.
May be there because it is an Internet adress, which means something to do for Access ?
I may need to look at Access 2007 fields formats/functions
If you're using the hyperlink data type for your field, I believe this is the default behavior. You could either rewrite the output using CF functions, or change the field data type to a regular character data type.
Dave Watts, CTO, Fig Leaf Software
Good, I understand, I think that's why.