
August 14th, 2003, 08:24 AM
|
|
Moderator
|
|
Join Date: Jun 2002
Location: Raleigh, NC
|
|
|
Trim takes a string or a variable. When you do this:
#Trim(s.stud_ans)#
CF thinks that you are trying to trim a variable called "s.stud_ans" which I'm guessing does not exist. You can try #trim( 's.stud_ans' )#, but clearly there are no spaces there to trim.
Try trimming the variables that you ARE passing to the query, like #table_name#, #stud_id#, etc.
|