THANKS! That solved it. I put a TRIM() around the variable when it was being put into the structure and now #SCORE.Sleep# outputs.
Sebastian
>I checked the source of the page to which you linked; it is indeed adding
>whitespace at the end of the QUIZID column. I'm guessing that instead of
>using a varchar type you used a fixed column width and this is causing the
>problem. Trim() the data before you insert it into the struct.
>
>-----Original Message-----
>From: James Holmes
>Sent: Tuesday, 12 October 2004 11:23
>To: CF-Talk
>Subject: RE: Outputting Structure Key Problem
>
>Score is a struct created with Structnew(), not a query.
>
>I'd check for whitespace in the data in the DB - perhaps there is an
>unintentional space after the word "Sleep" in the DB?
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
- Outputting Structure Key Problem sp
- Outputting Structure Key Problem sebastian palmigiani
- RE: Outputting Structure Key Problem James Holmes
- RE: Outputting Structure Key Problem Matthew Walker
- RE: Outputting Structure Key Problem James Holmes
- RE: Outputting Structure Key Problem James Holmes
- RE: Outputting Structure Key Problem Matthew Walker