Re: Outputting Structure Key Problem

2004-10-12 Thread sp
d 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

RE: Outputting Structure Key Problem

2004-10-11 Thread Matthew Walker
Ah right whoops sorry. How about trying ?   _   From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Tuesday, 12 October 2004 4:23 p.m. 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 da

RE: Outputting Structure Key Problem

2004-10-11 Thread James Holmes
truct. -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 w

Re: Outputting Structure Key Problem

2004-10-11 Thread Umer Farooq
hmm.. just dump out score.. to see whats in there.. [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: >  >#Score["Sleep"]# > > Tried that and got the following errror: > > Element Sleep is undefined in a CFML structure referenced as part of an > _expression_ > > Interestingly if I hard code the str

Re: Outputting Structure Key Problem

2004-10-11 Thread Josh
Was your message cut off?  Seems like you were in the middle of explaining this further? -Josh -- Exciteworks, Inc Expert Hosting for less! *Ask for a free 30 day trial!* http://exciteworks.com Plans starting at -$12.95- including MS SQL Server! [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: > >

RE: Outputting Structure Key Problem

2004-10-11 Thread James Holmes
2004 10:29 To: CF-Talk Subject: RE: Outputting Structure Key Problem You've created a query record set, not a structure. You could use query of queries to retrieve the matching record from your record set or you could use a UDF like this: http://cflib.org/udf.cfm?ID=586 [Todays Thre

RE: Outputting Structure Key Problem

2004-10-11 Thread Matthew Walker
2004 2:00 p.m. To: CF-Talk Subject: Outputting Structure Key Problem The following code below can be seen at http://www.tcmtests.com/files/codetest.cfm When I try append the following code to it I get an error that the variable Sleep is not defined #Score.Sleep# How can I output the structur

Re: Outputting Structure Key Problem

2004-10-11 Thread sp
>#Score["Sleep"]# Tried that and got the following errror: Element Sleep is undefined in a CFML structure referenced as part of an _expression_ Interestingly if I hard code the structure with [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donation

RE: Outputting Structure Key Problem

2004-10-11 Thread James Holmes
#Score["Sleep"]# [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Outputting Structure Key Problem

2004-10-11 Thread sebastian palmigiani
The following code below can be seen at http://www.tcmtests.com/files/codetest.cfm When I try append the following code to it I get an error that the variable Sleep is not defined #Score.Sleep# How can I output the structure key value that I want? --- select AVG(QuizPercent) as

Outputting Structure Key Problem

2004-10-11 Thread sp
The following code below can be seen at http://www.tcmtests.com/files/codetest.cfm When I try append the following code to it I get an error that the variable Sleep is not defined #Score.Sleep# How can I output the structure key value that I want? --- select AVG(QuizPercent) as A