Order by clause...

Originally posted by : Lydia (lydia_chin@hotmail.com)I trying to sort the records by track number.But, the following result will give the answer below:1.10.11.12.13.2.3.4.5.6.7.8.9.sqlstr2="Select * from Tracks where RecordingID = '" & recordingID & "' TrackNumber"set rstemp2=conntemp.execute(sqlstr2) What's wrong with my SQL statement?I expecting to get the result with:1.2.....10.11.12.13.

Originally posted by : Purushotham Rao G (getgprao@rediffmail.com)HiIf your database is Oracle and if RecordId Field is Varchar then you will get output what you have got.For getting output as you wanted You have to convert RecordId in to int while fetching the recordset.Purushotham Rao------------Lydia at 12/9/2001 10:00:49 PMI trying to sort the records by track number.But, the following result will give the answer below:1.10.11.12.13.2.3.4.5.6.7.8.9.sqlstr2="Select * from Tracks where RecordingID = '" & recordingID & "' TrackNumber"set rstemp2=conntemp.execute(sqlstr2) What's wrong with my SQL statement?I expecting to get the result with:1.2.....10.11.12.13.