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