Sorting four columns using sql query in query analyzer

nagmvs

New Member

Join Date: Aug 2008

Posts: 49
#1

Sorting four columns using sql query in query analyzer

Sep 1 '08, 08:45 AM

Hi to all

I have one table with 6 columns and 20 rows.I want to sort each and every column when i click the column name in the table.

for sorting i create one more page.when i click the column name it connect to sorting page and then page will be sorting. like this i wnat to write the code.
i wrote some code,but it not working properly.my code is

For first page:

<%userdetails=s ession("userdet ails")
userpoint=instr (1,userdetails, ",")
'mt=mid(userdet ails,1,userpoin t-1)
sort_var=reques t.querystring(" valb4")

%>

<td bgcolor="black" nowrap><a href="hco_Qc_St atus1_sort123.a sp?valb4=#_id" > #</td>
<td bgcolor="black" nowrap><a href="hco_Qc_St atus1_sort123.a sp?valb4=id_id" > ID</td>
<td bgcolor="black" nowrap><a href="hco_Qc_St atus1_sort123.a sp?valb4=name" > Nam e</td>
<td bgcolor="black" nowrap><a href="hco_Qc_St atus1_sort123.a sp?valb4=team_n ame1" > Tea m</td>
<td bgcolor="black" nowrap><a href="hco_Qc_St atus1_sort123.a sp?valb4=Acc_no " > ACC </td>
<td bgcolor="black" nowrap><a href="hco_Qc_St atus1_sort123.a sp?valb4=job_no " > Job </td>
<td bgcolor="black" nowrap><a href="hco_Qc_St atus1_sort123.a sp?valb4=qc_id" > Sta tus</td>
<td bgcolor="black" nowrap><a href="hco_Qc_St atus1_sort123.a sp?valb4=type_n ame" > Typ e</td>


<td bgcolor="black" nowrap><a href="hco_Qc_St atus1_sort123.a sp?valb4=error_ name" > Err or</td>

---

if sort_var="qc_id " then

''sqlqr="Select client_id,edito r_id,qc_id,job_ no,tc_time,qc_d ate,dictator_na me1,dictation_l ength,wt from tws_stats where qc_date='"&date &"'and job_no <> '' order by "& sort_var &" desc"
' sqlqr="Select id_id,team_name 1,Acc_no,job_no ,type_name,erro r_name,name from tws_stats where qc_date='"&date &"'and job_no <> '' order by "& sort_var &" desc"
sqlqr="select Id,name from tws_stats where qc_date='"&date &"' ORDER BY name DESC "
'sqlqr="Select name from tws_stats order by sort_var"
' Response.Write sqlqr

else
'sqlqr="Select client_id,edito r_id,qc_id,job_ no,tc_time,qc_d ate,dictator_na me1,dictation_l ength,wt from tws_stats where qc_date='"&date &"'and job_no <> '' order by "& sort_var &" asc"

'sqlqr="Select id_id,team_name 1,Acc_no,job_no ,type_name,erro r_name,name from tws_stats where qc_date='"&date &"'and job_no <> '' order by "& sort_var &" asc"
sqlqr="select Id,name from tws_stats where qc_date='"&date &"' ORDER BY name ASC "

And for sorting page code is :

%userdetails=se ssion("userdeta ils")
userpoint=instr (1,userdetails, ",")
'mt=mid(userdet ails,1,userpoin t-1)
sort_var=reques t.querystring(" valb4")
%>

<td align="middle" bgcolor="black" nowrap><A href="Copy of Grades-Unacceptable.as p?valb4=#_id">#</a></td>
<td align="middle" bgcolor="black" nowrap>< A href="Copy of Grades-Unacceptable.as p?valb4=ID_id"> ID</a></td>
<td align="middle" bgcolor="black" nowrap>< A href="Copy of Grades-Unacceptable.as p?valb4=name">Name</a></td>
<td align="middle" bgcolor="black" nowrap>< A href="Copy of Grades-Unacceptable.as p?valb4=team_na me1">Team</A></td>
<td align="middle" bgcolor="black" nowrap>< A href="Copy of Grades-Unacceptable.as p?valb4=Acc_no" >ACC</a></td>
<td align="middle" bgcolor="black" nowrap>< A href="Copy of Grades-Unacceptable.as p?valb4=job_no" >Job</a></td>
<td align="middle" bgcolor="black" nowrap>< A href="Copy of Grades-Unacceptable.as p?valb4=qc_id"> Status </a></td>
<td align="middle" bgcolor="black" nowrap>< A href="Copy of Grades-Unacceptable.as p?valb4=type_na me">Type</a></td>
<td align="middle" bgcolor="black" nowrap>< A href="Copy of Grades-Unacceptable.as p?valb4=error_n ame">Error</a></td>

<%
if sort_var="qc_id " then
'sqlqr="Select client_id,edito r_id,qc_id,job_ no,tc_time,qc_d ate,dictator_na me1,dictation_l ength,wt from tws_stats where qc_date='"&date &"'and job_no <> '' order by "& sort_var &" desc"
' sqlqr="Select id_id,team_name 1,Acc_no,job_no ,type_name,erro r_name,name from tws_stats where qc_date='"&date &"'and job_no <> '' order by "& sort_var &" desc"
'ex table name = infos_today
sqlqr="select Id,name from infos_today where qc_date='"&date &"' ORDER BY name DESC "

'Response.Write sqlqr
else
'sqlqr="Select client_id,edito r_id,qc_id,job_ no,tc_time,qc_d ate,dictator_na me1,dictation_l ength,wt from tws_stats where qc_date='"&date &"'and job_no <> '' order by "& sort_var &" asc"
'sqlqr="Select id_id,team_name 1,Acc_no,job_no ,type_name,erro r_name,name from tws_stats where qc_date='"&date &"'and job_no <> '' order by "& sort_var &" asc"
sqlqr="select Id,name from infos_today where qc_date='"&date &"' ORDER BY name ASC "

'Response.Write sqlqr
end if
dim rs
'set rsIn =myconn.execute (sqlqr)
set rs=myconn.execu te(sqlqr)
if not(rs.eof and rs.bof) then
get1=rs.getrows
set rs=nothing
get2=ubound(get 1,2)
for i=0 to get2
%>

please check the above code.

please tell me the sql query for sorting 5 columns in a table.
Tags: None
code green

Recognized Expert Top Contributor

Join Date: Mar 2007

Posts: 1726
#2

Sep 1 '08, 11:57 AM

please check the above code

No thanks. This looks like a VB problem not SQL server
Comment
nagmvs

New Member

Join Date: Aug 2008

Posts: 49
#3

Sep 2 '08, 04:07 AM

Originally posted by code green

No thanks. This looks like a VB problem not SQL server

Hello sir,

Thanks for ur reply.Sir actually i want the sql query for sorting 5 columns in a table using query analyzer.If u know means please tell me.

thanks,
nagesh.
Comment
code green

Recognized Expert Top Contributor

Join Date: Mar 2007

Posts: 1726
#4

Sep 2 '08, 07:59 AM

i want the sql query for sorting 5 columns in a table using query analyzer.

Are you asking how to use the ORDER BY clause?

Code:

ORDER BY col1,col2,col3.....
Comment

Previous template Next

Sorting four columns using sql query in query analyzer

Sorting four columns using sql query in query analyzer

Comment

Comment

Comment