Grabbing values from database with ActiveX controls

Ok, I have what hopefully will be a simple question...

I was playing around in FrontPage and I noticed that you could insert an ActiveX control for a calendar. I would like to be able to use this to integrate with a database - for example, I would like to be able to click on a day of the month and have the page display all data associated with that date (sort of a select * from database where date = "date_clicked_on")

Any helpful hints as to how to use this nifty lil ActiveX control in this way?

Thanks!

the calendar should have a on_click ability where you can grab the value of the date selected.

after that there are several ways you could go,

you could refresh the page and add the date to the url ie:
http://somesite.com/page.asp?date=01/01/2003
and then from there add this to your query.

or you could use a hidden form and post to another page and grab the value from the form.

thats just a couple of the simpler ways. It all comes down to how you want your web-pages to look and work.

Kong.

Is this something that is built in to the ActiveX Component, or would I need to define it in a function in VBScript?

What Im trying to do (I think...) is make a scheduling calendar that would allow us to keep track of three seperate warehouses and when they are expecting deliveries and pickups. What I would like to see is this ActiveX calendar bring up a form with fields for time, warehouse, client, etc. - then when the users fill in those fields and submit it, it adds it to a database using the date that the person clicked on.

I'll play with it some more tomorrow, in the meantime if anyone has any suggestions or comments for me, please feel free!

you will need some vbscript code to help get the date.

the calander control I've been using is the mscal.ocx one.

All you can do with this control is view dates and click on them and it will return the value to a variable etc.

you could create a form and then when it asks for the date you could do a on_click event to a textfield and make the calender appear for the user to select a date.

Kong.