[ic] [if data database::fieldname::key] statement

[Donald Lin]

I need to check if a field in a database has a value. If it does, I would
like to display it and if it doesn't I don't want it displayed. I am trying
to use the
[if data database::name::myName] command but it seems to work only if the
key 1.) has no spaces 2.)is short with a space. (I defined the key to be
varchar(50) ) I believe this is the problem because i inserted a couple of
test values into the database, and the above command would work for names
like 'test', 'test space', 'testlongnamewithoutaspace' but would not work
for values of 'testlongname withspace' and 'testlongername space'. I do not
understand?!?! Can anyone help me out? Is there another way i can do this?
Thanks.

don

ps. here is the code i need to get working for ALL cases

[if database::name::testlongnameherewithoutspace]
THIS WORKS <br> [item-field testlongnamewithoutspace]
[/if]