I have a textarea that I use to retrieve comment from users. In the database it displays like the following.

Department Feed Back: 2, 1,

As you can see the 1 was the first data that was updated then number 2 is second update that was done. How can I get it to read the other way around like 1, 2, 3 etc.. In other words how can I get it that colum to display left to right?
________________________________________

What about when it's being updated! I could do something like this but I am getting errors. Can you help me debug it? Tell me if it will work or not.

Thanks

I am getting the following errors:

Microsoft OLE DB Provider for SQL Server error '80040e14'

Incorrect syntax near the keyword 'ORDER'.

/forms/Updated_Successfully.asp, line 52


strSQL = "UPDATE Escalation_Forms SET Status='"& request.form("Status") &"', ORDER BY Wip_Com DESC ='"& request.form("Wip_Com") &"' Where Ticket_Number=" & Session("TicketNum")

After you update the DB you then create another strSQL2 and SELECT * FROM Table_name ORDER BY whatever_here.

Hi I tried it and I am coming up with the following error
Line 1: Incorrect syntax near '='.

/forms/Updated_Successfully.asp, line 54

strSQL = "UPDATE Escalation_Forms SET Status='"& request.form("Status") &"', Wip_Com ='"& request.form("Wip_Com") &"' Where Ticket_Number=" & Session("TicketNum")

strSQL2 = "Select * from Escalation_Forms ORDER BY Wip_Com DESC;"

This line 54: ObjRS.open strSQL, ObjConn, 3, 3

Calibus,

You are running an update statement that doesn't return any result to be stored into a recordset and process later. So why do you want to use this?
ObjRS.open strSQL, ObjConn, 3, 3

Instead use
ObjConn.Execute(strSQL)

Hope that helps
Cheers!

_________________________
- Vijay G
Strive for Perfection