Programming Forums - View Single Post

rjbrynteson · Oct 20th, 2005, 10:22 AM

here is what the page displays now ------------->
10/19/2005
2004 Nissan Maxima
10/19/2005
2003 Dodge Grand Caravan
10/18/2005
2002 Buick Park Avenue
10/18/2005
1997 Honda Accord
10/16/2005
2004 Ford F-150
10/15/2005
1990 Oldsmobile Starfire
------------------------------------------------------
here is what i want it to display
10/19/2005
2004 Nissan Maxima
2003 Dodge Grand Caravan

10/18/2005
2002 Buick Park Avenue
1997 Honda Accord

10/16/2005
2004 Ford F-150

10/15/2005
1990 Oldsmobile Starfire
-----------------------------------------
any suggestions ?

(Toggle Plain Text)

<!--#include virtual="database.asp"-->
<%
dim objConn
DBConnOpen objConn

dim ObjRS

dim CarSQL
dim ShowResults
ShowResults = False

set ObjRS=Server.CreateObject("ADODB.recordset")
	ObjRS.Open CarSQL, objConn

	CarSQL = "Select a.Year, a.Make,a.Model, a.date  from North_Yard a where a.Date >= getDate() - 7  order by a.Date DESC"





<%do until ObjRS.eof%>
                                <tr>
                                  <td width="49" height="15"><b><%=ObjRS("Date")%></b></td>
                                </tr>
                                <tr>
								
                                  <td colspan="3" class="main"></td>
                                </tr> 
                                                  
                          
                                <tr class="SearchResults<%=j%>">
                                  <td><%=ObjRS("Year")%>  </td>
                                  <td width="61"><%=ObjRS("Make")%></td>
                                  <td width="205"><%=ObjRS("Model")%></td>
                                </tr>
								
                                <%
							ObjRS.MoveNext
							
							i = i + 1
							%>
                                <%loop%>

Oct 20th, 2005, 10:22 AM	#1
rjbrynteson Newbie Join Date: Oct 2005 Posts: 7 Rep Power: 0	ASP grouping/date questions here is what the page displays now -------------> 10/19/2005 2004 Nissan Maxima 10/19/2005 2003 Dodge Grand Caravan 10/18/2005 2002 Buick Park Avenue 10/18/2005 1997 Honda Accord 10/16/2005 2004 Ford F-150 10/15/2005 1990 Oldsmobile Starfire ------------------------------------------------------ here is what i want it to display 10/19/2005 2004 Nissan Maxima 2003 Dodge Grand Caravan 10/18/2005 2002 Buick Park Avenue 1997 Honda Accord 10/16/2005 2004 Ford F-150 10/15/2005 1990 Oldsmobile Starfire ----------------------------------------- any suggestions ? (Toggle Plain Text) <!--#include virtual="database.asp"--> <% dim objConn DBConnOpen objConn dim ObjRS dim CarSQL dim ShowResults ShowResults = False set ObjRS=Server.CreateObject("ADODB.recordset") ObjRS.Open CarSQL, objConn CarSQL = "Select a.Year, a.Make,a.Model, a.date from North_Yard a where a.Date >= getDate() - 7 order by a.Date DESC" <%do until ObjRS.eof%> <tr> <td width="49" height="15"><b><%=ObjRS("Date")%></b></td> </tr> <tr> <td colspan="3" class="main"></td> </tr> <tr class="SearchResults<%=j%>"> <td><%=ObjRS("Year")%> </td> <td width="61"><%=ObjRS("Make")%></td> <td width="205"><%=ObjRS("Model")%></td> </tr> <% ObjRS.MoveNext i = i + 1 %> <%loop%> <!--#include virtual="database.asp"--> <% dim objConn DBConnOpen objConn dim ObjRS dim CarSQL dim ShowResults ShowResults = False set ObjRS=Server.CreateObject("ADODB.recordset") ObjRS.Open CarSQL, objConn CarSQL = "Select a.Year, a.Make,a.Model, a.date from North_Yard a where a.Date >= getDate() - 7 order by a.Date DESC" <%do until ObjRS.eof%> <tr> <td width="49" height="15"><b><%=ObjRS("Date")%></b></td> </tr> <tr> <td colspan="3" class="main"></td> </tr> <tr class="SearchResults<%=j%>"> <td><%=ObjRS("Year")%> </td> <td width="61"><%=ObjRS("Make")%></td> <td width="205"><%=ObjRS("Model")%></td> </tr> <% ObjRS.MoveNext i = i + 1 %> <%loop%> Last edited by rjbrynteson; Oct 20th, 2005 at 10:25 AM. Reason: why is there a text box for reason for editing ?