x-posted
i have a form that submits data to a sql2000 database via an update statement (that way, i won't have multiple entries for each person that i have to sift through). the problem i'm having is that i need to include the date the form was submitted in the database.
i'm doing all this with frontpage (partly because i have no idea how to do it on my own, but mostly because that's how i have to do it for work). when i was submitting the form with a simple post statement, frontpage gave me the option of sending a timestamp to the database. now that i've changed it to an update statement, it's not letting me do that. so, my question(s):
1) does anyone know how to make frontpage send a timestamp to the database if using an update statement?
2) does anyone have a javascript solution for this? i'd tried just putting the current date on the page, which works, but i can't get it to send that info to the database. i was thinking i might have to put the current date into a textbox and just have that as one of the fields that gets sent, but i can't figure out how to get the date in the box. it should still work if i have that textbox hidden, too, right?
3) any other solution to this problem (other than don't use frontpage or sql2000)?
i'm doing all this with frontpage (partly because i have no idea how to do it on my own, but mostly because that's how i have to do it for work). when i was submitting the form with a simple post statement, frontpage gave me the option of sending a timestamp to the database. now that i've changed it to an update statement, it's not letting me do that. so, my question(s):
1) does anyone know how to make frontpage send a timestamp to the database if using an update statement?
2) does anyone have a javascript solution for this? i'd tried just putting the current date on the page, which works, but i can't get it to send that info to the database. i was thinking i might have to put the current date into a textbox and just have that as one of the fields that gets sent, but i can't figure out how to get the date in the box. it should still work if i have that textbox hidden, too, right?
3) any other solution to this problem (other than don't use frontpage or sql2000)?
