On 8/6/00, <CFNEWBIE> penned:
>I have been researching a way to input a timestamp into the same =
>position as I input a text note. I know how to generate the timestamp..I =
>am not clear on how to input 2 items in 1 db cell. It is probably =
>rather straightforward but I would appreciate a point in the right =
>direction.
I always use something like this as a timestamp:
<cfset thisdate = dateformat(createdate(year(now()), month(now()),
day(now())), "YYMMDD")>
<cfset thistime = timeformat(createdate(minute(now()), hour(now()),
second(now())), "hhmmss")>
<cfset mytimestamp = thisdate & thistime>
As far as inserting, just put two variables in the same the value:
<CFQUERY DATASOURCE="mydatasource">
INSERT INTO
(somefield)
VALUES
('#mytimestamp##form.field#')
</CFQUERY>
Of course, you can enter the values however you like, not necessarily
run together:
'#mytimestamp#: #form.field#'
'#mytimestamp#-#form.field#'
'#mytimestamp#, #form.field#'
'#mytimestamp# #form.field#'
etc.
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
