Home > SQL Development > how to order by field and subfield ?

how to order by field and subfield ?

Originally posted by : goodlook (deloenzien@goodlook.be) Hi, how do i sort my database first on the field "dienst" and then on the field "dokter" <%SQL = "SELECT * FROM Medical ORDER BY " & Request("dienst")%> for example dienst : dokter a : dr.1 b : dr.2 a : dr.2 b : dr.1 b : dr.3 sould be : dienst : dokter a : dr.1 a : dr.2 b : dr.1 b : dr.2 b : dr.3 <%SQL = "SELECT * FROM Medical ORDER BY " & Request("dienst")%> best regards, The Belgium

Guest

Originally posted by : Graham Masters (graham_masters@yahoo.com) Your example is a little unclear in that the request object is referencing names that look like a table columns ("dokter" and "dienst")versus a field name such as "user_sort_field1", "user_sort_field2". If your sort columns are known a priori then you can simply write: <%SQL = "SELECT * FROM Medical ORDER BY dokter, dienst"%> If the sort columns are derived a run time from a form then something like: <%SQL = "SELECT * FROM Medical ORDER BY " & Request.QueryString ("Sort_Field1") & ", " Request.QueryString ("Sort_Field2") %> However, make sure the requests return non empty valid column names otherwise you'll have either syntax or invalid object errors. Graham ------------ goodlook at 5/23/2001 2:37:04 PM Hi, how do i sort my database first on the field "dienst" and then on the field "dokter" <%SQL = "SELECT * FROM Medical ORDER BY " & Request("dienst")%> for example dienst : dokter a : dr.1 b : dr.2 a : dr.2 b : dr.1 b : dr.3 sould be : dienst : dokter a : dr.1 a : dr.2 b : dr.1 b : dr.2 b : dr.3 <%SQL = "SELECT * FROM Medical ORDER BY " & Request("dienst")%> best regards, The Belgium

Was this answer helpful ? Yes No

Guest

Originally posted by : GoodLook (deloenzien@goodlook.be) Hi, i'm a new ASp'er... bellow you find the asp page where i data sould br sorted first by "dienst" & then by "Name" hope you can help me ? ------------------------------------------------ <HTML> <BODY> <%mydienst = "HD" mywaar = "SF" fotocount = 0 rijen = 3 %> <% Set MyConn = Server.CreateObject("ADODB.Connection") MyConn.Open "FILEDSN=c:dsnMyTable_dsn.dsn" %> <table border="0" width="100%" height="22" bordercolor="#008080" bgcolor="#FFCCCC"> <%SQL_query = "SELECT * FROM Medical" Set RS = MyConn.Execute(SQL_query) WHILE NOT RS.EOF %> <% if rs("dienst") = mydienst AND rs("waar") = mywaar then %> <tr> <td width="5%" height="13" align="left"><%=RS("dienst")%></td> <td width="12%" height="13" align="left"><%=RS("NAME")%></td> <td width="12%" height="13" align="center" bgcolor="#FFFFE1"><%=RS("MAANDAG")%></td> <td width="12%" height="13" align="center" bgcolor="#CFEFED"><%=RS("DINSDAG")%></td> <td width="12%" height="13" align="center" bgcolor="#CFEFED"><%=RS("WOENSDAG")%></td> <td width="12%" height="13" align="center" bgcolor="#CFEFED"><%=RS("DONDERDAG")%></td> <td width="12%" height="13" align="center" bgcolor="#CFEFED"><%=RS("VRIJDAG")%></td> <td width="12%" height="13" align="center" bgcolor="#CFEFED"><%=RS("ZATERDAG")%></td> </tr> <%else response.write "" END IF%> <% RS.MoveNext WEND RS.Close %> </table> best regards, the belgium with the bad english... ------------ Graham Masters at 5/23/2001 3:08:40 PM Your example is a little unclear in that the request object is referencing names that look like a table columns ("dokter" and "dienst")versus a field name such as "user_sort_field1", "user_sort_field2". If your sort columns are known a priori then you can simply write: <%SQL = "SELECT * FROM Medical ORDER BY dokter, dienst"%> If the sort columns are derived a run time from a form then something like: <%SQL = "SELECT * FROM Medical ORDER BY " & Request.QueryString ("Sort_Field1") & ", " Request.QueryString ("Sort_Field2") %> However, make sure the requests return non empty valid column names otherwise you'll have either syntax or invalid object errors. Graham ------------ goodlook at 5/23/2001 2:37:04 PM Hi, how do i sort my database first on the field "dienst" and then on the field "dokter" <%SQL = "SELECT * FROM Medical ORDER BY " & Request("dienst")%> for example dienst : dokter a : dr.1 b : dr.2 a : dr.2 b : dr.1 b : dr.3 sould be : dienst : dokter a : dr.1 a : dr.2 b : dr.1 b : dr.2 b : dr.3 <%SQL = "SELECT * FROM Medical ORDER BY " & Request("dienst")%> best regards, The Belgium

Was this answer helpful ? Yes No

Guest

Originally posted by : after looking around the following is the only working one : Thanks for helping out <% SQL_query = "SELECT * FROM Medical WHERE waar='"&mywaar&"' AND dienst='"&mydienst&"' AND type='"&mytype&"' ORDER BY Medical.Dienst, Medical.Name" Set RS = MyConn.Execute(SQL_query) WHILE NOT RS.EOF %> ------------ GoodLook at 5/23/2001 3:52:53 PM Hi, i'm a new ASp'er... bellow you find the asp page where i data sould br sorted first by "dienst" & then by "Name" hope you can help me ? ------------------------------------------------ <HTML> <BODY> <%mydienst = "HD" mywaar = "SF" fotocount = 0 rijen = 3 %> <% Set MyConn = Server.CreateObject("ADODB.Connection") MyConn.Open "FILEDSN=c:dsnMyTable_dsn.dsn" %> <table border="0" width="100%" height="22" bordercolor="#008080" bgcolor="#FFCCCC"> <%SQL_query = "SELECT * FROM Medical" Set RS = MyConn.Execute(SQL_query) WHILE NOT RS.EOF %> <% if rs("dienst") = mydienst AND rs("waar") = mywaar then %> <tr> <td width="5%" height="13" align="left"><%=RS("dienst")%></td> <td width="12%" height="13" align="left"><%=RS("NAME")%></td> <td width="12%" height="13" align="center" bgcolor="#FFFFE1"><%=RS("MAANDAG")%></td> <td width="12%" height="13" align="center" bgcolor="#CFEFED"><%=RS("DINSDAG")%></td> <td width="12%" height="13" align="center" bgcolor="#CFEFED"><%=RS("WOENSDAG")%></td> <td width="12%" height="13" align="center" bgcolor="#CFEFED"><%=RS("DONDERDAG")%></td> <td width="12%" height="13" align="center" bgcolor="#CFEFED"><%=RS("VRIJDAG")%></td> <td width="12%" height="13" align="center" bgcolor="#CFEFED"><%=RS("ZATERDAG")%></td> </tr> <%else response.write "" END IF%> <% RS.MoveNext WEND RS.Close %> </table> best regards, the belgium with the bad english... ------------ Graham Masters at 5/23/2001 3:08:40 PM Your example is a little unclear in that the request object is referencing names that look like a table columns ("dokter" and "dienst")versus a field name such as "user_sort_field1", "user_sort_field2". If your sort columns are known a priori then you can simply write: <%SQL = "SELECT * FROM Medical ORDER BY dokter, dienst"%> If the sort columns are derived a run time from a form then something like: <%SQL = "SELECT * FROM Medical ORDER BY " & Request.QueryString ("Sort_Field1") & ", " Request.QueryString ("Sort_Field2") %> However, make sure the requests return non empty valid column names otherwise you'll have either syntax or invalid object errors. Graham ------------ goodlook at 5/23/2001 2:37:04 PM Hi, how do i sort my database first on the field "dienst" and then on the field "dokter" <%SQL = "SELECT * FROM Medical ORDER BY " & Request("dienst")%> for example dienst : dokter a : dr.1 b : dr.2 a : dr.2 b : dr.1 b : dr.3 sould be : dienst : dokter a : dr.1 a : dr.2 b : dr.1 b : dr.2 b : dr.3 <%SQL = "SELECT * FROM Medical ORDER BY " & Request("dienst")%> best regards, The Belgium

Was this answer helpful ? Yes No

Guest

Answer it

Ask Question About SQL Development

how to order by field and subfield ?

Programming

Related Pages