Hi All,
I am generating a text area against each recordset to capture the comments from users.
response.write("<textarea name='comments' id='comments' style='width:200px;height:50px;background-color:#8DB6CD;'>" & arcomments &"</textarea>")
when I am reading the data using array –
cust_number=split(Request.Form("cnumber"),",")
acc_sts=split(Request.Form("selACCStatus"),",")
acc_comments=split(Request.Form("comments"),",")
Dim i
dim lower
dim upper
lower=Lbound(cust_number)
upper=Ubound(cust_number)
For i = lower to upper
if trim(acc_sts(i))<>"" then
sql="update top_accounts_review set status='" & trim(acc_sts(i)) &"' , updated_date='" & now() &"', updated_by='" & trim(uname) &"',comments='" & trim(acc_comments(i)) &"' where fiscal_week='" & trim(sel_week) &"' and customer_number='" & trim(cust_number(i)) &"'"
con.execute(sql)
'response.write(sql)
end if

next

everything is working fine here, The only issue I am facing – when user enters the comma (,) in text area, script is considering that as the comment for another recordset as I am splitting the comments based on comma,
what should I change in my script so that, it should not split the data based on comma entered by users.
I hope, I am able to explain the situation.

I am fairly sure adding double speech marks should sort it eg

This is a commer not a single quote right? If so I do not believe adding a double quote is going to help you...

Im not 100% accross exactley what you are trying to achieve but looking at your code I feel the method/design of what you are doing could be better.........anyhow......If you are capturing freet text from a user you need to allow them to punctuate, therefore you have to allow them to use commers (and all other commonly used characters). Based on this IMO you simply need to split the array on a different character.

Hope that helps

__________________
Wind is your friend
Matt