create a field that has a default value of the current date/time. that value depends on your database. in SQL Server, it's getDate(). in Access, it's now(). not sure about other databases.
On 6/26/07, Steven Sprouse <[EMAIL PROTECTED]> wrote: > Does anyone know how I can insert a date and time stamp into a SQL database > when someone goes on our website and uploads something? > > I created a form where someone can input the title and body of a press > release but I also want it to automatically record the time that it is > uploaded, store it in the database and also output it on the list of press > releases. > > How do I do this??? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282331 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4