2. ASPRunnerPro General questions
  3. Display DB sorted by month
This topic is locked

Display DB sorted by month

 		8/13/2003 1:42:55 PM
ASPRunnerPro General questions
swat author

I have DB which includes months , I have created drop down menu using ASPRunner and users enter month. what I need is to display my DB sorted by months:
September
October
November


Second Question: I would like to hide one of my data field . I do not display on the xyz_list.asp however I would like to collect if and edit it
thx
Sergey Kornilov admin 8/13/2003

Hi,
you need to add a field to the table where you store month names. This new field (lets say MonthNumber) should store month numbers from 1 to 12.

When you build ASP pages using ASPRunner, you can order dropdown data by MonthNumber.
Regarding your second question - you can display different list of fields on the list and edit pages.
Sergey Kornilov
swat author 8/13/2003

what I need is to display next 3 months only. Let say now I would like to display only

September/October/November
and is there any SELECT * FROM DB WHERE .... sql code that I can run I have tried couple of but not working?
thx
Sergey Kornilov admin 8/13/2003

Look into Function BuildSelectControl(strName, strValue) that can be found in /include/..._aspfunctions.asp file.
You can find SQL query that you need to change there.
Sergey Kornilov