|
|
I'm quite new to .net and am using v1.1 and IIS. I have built a parts stores search facility for my company and am including an area where parts that have been issued to a machine may be searched to see their usage(by partNo & machineNo). I would like to allow the user to also set a time limit to their search ie. search by 1 day, 1 week etc. eg -(where partNo = @partNo) & (machineNo = @machineNo) [u]&(timePeriod = @timePeriod)[/u] as seen within many results type pages but do not know how to go about it. I envisage the user selection to made from a drop down list but cannot see how each separate parameter can be included(date.now - 1, or date.Now - 7)??? or be passed to the sql. I'm sure there is a well worn method for achieving this but I have not been able to find any examples in the books that I own.
Thanks in advance for any help you can give me
stewart
|
|
|
|
|
|
|
// |
Stewart
