Function call in Asp from Button

[remya1000]

i'm using ASP and Ms Access as database.
i created a submit button like this

<input name="b1" type="submit" VALUE="Submit" />

and while clicking this button, i need to fill two textbox the curent date and last one months date. eg: if today is 5/1/2007 then last month date is 4/1/2007. and while pressing another button, need to display the records in between that dates.

so how can i write a function while clicking this button "submit" or "last one month button".
can you help me to find a solution. i dont have much idea about ASP.

so if you have any idea please help me, how to write functions in ASP for the button click event.

thanks in advance.

[JamieHowarth0]

Hi remya,

Your best bet is to use Javascript's onclick event handler to populate the two fields. Your other option is to use ASP server-side date retrieval and manipulation but this creates a performance hit on the server when the client's computer can do it more quickly using Javascript.
When the user clicks a button, Javascript code retrieves today's date, month and year, and stores this in one field in your form.
It then subtracts 1 from the month value, and saves the data again to your second field.
Finally, you can use Javascript's document.forms().submit() method to submit the form to your server for database processing.
If you would like me to try and produce some sample code PM me and I will see what I can do.

All the best,

medicineworker

[remya1000]

Right now what i did is that, VbScript like this

<script Language = "VBScript">

sub onemonth()
form1.datefrom.value = dateadd("m",-1,date())
form1.dateto.value = date()
end sub
sub threemonth()
form1.datefrom.value = dateadd("m",-3,date())
form1.dateto.value = date()
end sub
sub viewrecords()

end sub
</script>

created buttons and textbox like this.

<form name="form1" method="post">
<input type="button" value="Last 1 Month" name="buttonname" onclick="onemonth"/>
<input type="button" value="Last 3 Month" name="buttonname" onclick="threemonth"/>
<input type="text" name="datefrom" size="20">
<input type="text" name="dateto" size="20">
<input name="b2" type="submit" VALUE="Submit" onclick="viewrecords"/>
<Br><Br>
..........................................
</form>

right now while pressing any button called "onemonth" or "threemonth", its displaying the datefrom and dateto in the textbox. but when i press submit it should display the records in between thoses days. and i need to sort each fiels in that displayed records.
but while pressing submit, the textbox is getting empty. and its not taking the textbox value for the sql. i tried this for checking...
sub onemonth()
a3 = ""
b3 = ""
form1.datefrom.value = dateadd("m",-1,date())
form1.dateto.value = date()
a1 = dateadd("m",-1,date())
b1 = date()
end sub
sub viewrecord()
if a1<>"" and b1<>"" then
form1.datefrom.value=a1
form1.dateto.value=b1
end if
end sub
but the submit is not getting this value at all.

and i have no idea about javascript. if you can please help me in this. i'm really stuck now. if you have any idea how to do this let me know about that. if possible get me some eg: also. that will be very help full to me.
thanks in advance