I have a textarea tag named status ,where I copy a list of
numbers . When the user submits the number using the submit button
the code
Select numbers from table where numbers in (' #status# ')
<cfoutput> #status#)</cfoutput>
I know at least one of the numbers are in the database but my
output returns nothing. Could the problem be that the textarea tag
only excepts text?:???
If numbers is a numeric field, your query should crash
because of your quotes. If numbers is a char field, you still want
to get rid of the quotes and use the ListQualify function.
The problem could also be with your list. Does it look like
this:
1
2
3
In that case, the first part of my previous post answers your
question. The only thing I would add is, if you field is char, get
rid of all the spaces in your list before you apply the list
qualify function.