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]

Reply via email to