Try #DateFormat(Now(), "dd mmm yy")# The Now() is a call to get the current time from the computers clock. You'll use it a lot. Ed ----- Original Message ----- From: "CF-Talk" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, May 28, 2000 5:49 PM Subject: CF-Talk V1 #54 > CF-Talk Sun, 28 May 2000 Volume 1 : Number 54 > > In this issue: > > Date Created Field > Mailing list archive > RE: Mailing list archive > RE: <cfmail> > ODBC Drivers for Palm DB > Re: Mailing list archive > RE: Another Query to Table > Re: ODBC Drivers for Palm DB > Re: <cfmail> > Re: Date Created Field > > > ---------------------------------------------------------------------- > > Date: Sun, 28 May 2000 14:06:49 -0700 > From: LH Rothman <[EMAIL PROTECTED]> > To: CF Talk <[EMAIL PROTECTED]> > Subject: Date Created Field > Message-ID: <[EMAIL PROTECTED]> > > I'm a very confused newbie. I want to add a new record and have the > date that record is create automatically appear in a "DateCreated" > field. I've been looking at the following code and don't know if I'm on > the right track. > > Date Created: #DateFormat(File.TimeCreated,'DD MMM YY')# > > Any help is very appreciated. Thank you. > -Laura > > ------------------------------ > > Date: Sun, 28 May 2000 14:24:36 -0700 > From: "Splash! Designs Ink." <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Subject: Mailing list archive > Message-ID: <017f01bfc8eb$1fd0a360$[EMAIL PROTECTED]> > > I would like to archive the data input to a form & sent to a mailing list > using <CFMAIL>? For example, I have a mailing list where the > list owner sends out a message to the list via a web-based form. > This works great, but, I would also like to capture the data & > have it write to an archive page at the same time. Can this be done > without setting up another database? Or would I have to have > the form variables write to a database and then use a query/output > sequence to display the data? > > thanks, > Kristin > [EMAIL PROTECTED] > > > > ------------------------------ > > Date: Sun, 28 May 2000 15:19:57 -0700 > From: "Dave Notik" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Subject: RE: Mailing list archive > Message-ID: <000701bfc8f2$dbeac420$[EMAIL PROTECTED]> > > Technically, you can use CFFILE and write to a file directly. You'd want to > write HTML to the specific file and format it as you wish. The negative > side of this is that you won't have flexibility later on when working with > the data, and you won't be able to perform conditions (or at least not > easily) on the data, dynamic formatting and display and so on. > > Why not just create an additional table in your database? Storing these > archives in your database ultimately gives you much more coding flexibility. > > -Dave > -VBHelp.com > > -----Original Message----- > From: Splash! Designs Ink. [mailto:[EMAIL PROTECTED]] > Sent: Sunday, May 28, 2000 2:25 PM > To: [EMAIL PROTECTED] > Subject: Mailing list archive > > > I would like to archive the data input to a form & sent to a mailing list > using <CFMAIL>? For example, I have a mailing list where the > list owner sends out a message to the list via a web-based form. > This works great, but, I would also like to capture the data & > have it write to an archive page at the same time. Can this be done > without setting up another database? Or would I have to have > the form variables write to a database and then use a query/output > sequence to display the data? > > thanks, > Kristin > [EMAIL PROTECTED] > > > > -------------------------------------------------------------------------- -- > -- > Archives: http://www.eGroups.com/list/cf-talk > 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. > > ------------------------------ > > Date: Mon, 29 May 2000 08:36:41 +1000 > From: "Andrew Scott" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Subject: RE: <cfmail> > Message-ID: <[EMAIL PROTECTED]> > > Use the mimeattach attribute. > > > -----Original Message----- > From: nair ajit [mailto:[EMAIL PROTECTED]] > Sent: Sunday, 28 May 2000 8:51 PM > To: [EMAIL PROTECTED] > Subject: <cfmail> > > > how can i send images using <cfmail> tag. > I want to send greeting cards thro' my site. > > ----------------------------------------------- > FREE! The World's Best Email Address @email.com > Reserve your name now at http://www.email.com > > > -------------------------------------------------------------------------- -- > -- > Archives: http://www.eGroups.com/list/cf-talk > 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. > > ------------------------------ > > Date: Sun, 28 May 2000 18:43:08 -0500 > From: Jaeson Tanner <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: ODBC Drivers for Palm DB > Message-ID: <[EMAIL PROTECTED]> > > Is anyone aware of an ODBC driver that could access a palm DB? > > ...J:) > > Ask about our AWARD WINNING WEB DESIGN service. > http://www.rogue.org/jaeson/portfolio > ~ sapere aude ~ > [EMAIL PROTECTED] Web page design & Hosting http://www.kingston.net > InterNet Kingston, 177 Wellington St., Kingston, Ontario, K7L 3E3 > Tel:(613)547-6939x24 Support: 9a-10p 7 days/wk Fax:(613)547-5436 > InterNet Kingston: Chamber of Commerce Business of the Year 1998 > > ------------------------------ > > Date: Sun, 28 May 2000 17:21:49 -0700 > From: "Splash! Designs Ink." <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Subject: Re: Mailing list archive > Message-ID: <018b01bfc903$e1c915c0$[EMAIL PROTECTED]> > > This makes perfect sense, thanks Dave. I am using Access 2000, > do you think this will cause any problems as the list/post grows? > > Kristin > > ----- Original Message ----- > From: Dave Notik <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Sunday, May 28, 2000 3:19 PM > Subject: RE: Mailing list archive > > > > Technically, you can use CFFILE and write to a file directly. You'd want > to > > write HTML to the specific file and format it as you wish. The negative > > side of this is that you won't have flexibility later on when working with > > the data, and you won't be able to perform conditions (or at least not > > easily) on the data, dynamic formatting and display and so on. > > > > Why not just create an additional table in your database? Storing these > > archives in your database ultimately gives you much more coding > flexibility. > > > > -Dave > > -VBHelp.com > > > > -----Original Message----- > > From: Splash! Designs Ink. [mailto:[EMAIL PROTECTED]] > > Sent: Sunday, May 28, 2000 2:25 PM > > To: [EMAIL PROTECTED] > > Subject: Mailing list archive > > > > > > I would like to archive the data input to a form & sent to a mailing list > > using <CFMAIL>? For example, I have a mailing list where the > > list owner sends out a message to the list via a web-based form. > > This works great, but, I would also like to capture the data & > > have it write to an archive page at the same time. Can this be done > > without setting up another database? Or would I have to have > > the form variables write to a database and then use a query/output > > sequence to display the data? > > > > thanks, > > Kristin > > [EMAIL PROTECTED] > > > > > > > > -------------------------------------------------------------------------- > -- > > -- > > Archives: http://www.eGroups.com/list/cf-talk > > 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. > > > > -------------------------------------------------------------------------- > ---- > > Archives: http://www.eGroups.com/list/cf-talk > > 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. > > ------------------------------ > > Date: Sun, 28 May 2000 17:25:57 -0700 > From: "David Gassner" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Subject: RE: Another Query to Table > Message-ID: <000001bfc904$7559e120$0100000a@dga> > > Patric, you'll need to use the index array method of getting to query data. > Here's some code which does what you want, assuming a query named "q" and a > field called "fieldvalue": > > <!--- If number of items isn't divisible by three, > add one row ---> > <cfset numRows = q.recordcount / 3> > <cfif (numRows mod 3)> > <cfset numRows = int(numRows) + 1> > </cfif> > > <table cellpadding="5" cellspacing="0"> > <cfloop from=1 to="#numRows#" index="currentRow"> > > <!--- Start the row with alternating colors ---> > <cfoutput> > <tr bgcolor=#iif(currentRow mod 2, > de("silver"), > de("white"))#> > </cfoutput> > > <cfloop from="1" to="3" index="cellNumber"> > <cfset dataIndex = (numRows * (cellNumber-1)) + currentRow> > <td> > <cfif dataIndex lte q.recordcount> > <cfoutput>#dataindex#-#q.fieldvalue[dataIndex]#</cfoutput> > </cfif> > </td> > </cfloop> > </tr> > > </cfloop> > </table> > > David Gassner > Vintage Business Applications > > > but i wanted it like > > > > 1 5 9 > > 2 6 10 > > 3 7 11 > > 4 8 12 > > > > Hope this is possible...!?! > > ------------------------------ > > Date: Sun, 28 May 2000 20:30:31 -0400 > From: "Joseph Eugene" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Subject: Re: ODBC Drivers for Palm DB > Message-ID: <000801bfc905$19c3e030$a10e1e26@gemini> > > Do you know what DB the palm pilot uses? > Can you get Access to it? > When you sync it with your PC, > you could be able to import the data to Excel or > Access and then read, it the data is in some other format! > > > ----- Original Message ----- > From: "Jaeson Tanner" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Sunday, May 28, 2000 7:43 PM > Subject: ODBC Drivers for Palm DB > > > > Is anyone aware of an ODBC driver that could access a palm DB? > > > > ...J:) > > > > Ask about our AWARD WINNING WEB DESIGN service. > > http://www.rogue.org/jaeson/portfolio > > ~ sapere aude ~ > > [EMAIL PROTECTED] Web page design & Hosting http://www.kingston.net > > InterNet Kingston, 177 Wellington St., Kingston, Ontario, K7L 3E3 > > Tel:(613)547-6939x24 Support: 9a-10p 7 days/wk Fax:(613)547-5436 > > InterNet Kingston: Chamber of Commerce Business of the Year 1998 > > > > -------------------------------------------------------------------------- > ---- > > Archives: http://www.eGroups.com/list/cf-talk > > 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. > > > > ------------------------------ > > Date: Sun, 28 May 2000 20:32:44 -0400 > From: "Joseph Eugene" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Subject: Re: <cfmail> > Message-ID: <000b01bfc905$69041d40$a10e1e26@gemini> > > You could also use > > <CFMAILPARAM > FILE="file-name" > > inside the body of your cfmail tag > > > ----- Original Message ----- > From: "Andrew Scott" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Sunday, May 28, 2000 6:36 PM > Subject: RE: <cfmail> > > > > Use the mimeattach attribute. > > > > > > -----Original Message----- > > From: nair ajit [mailto:[EMAIL PROTECTED]] > > Sent: Sunday, 28 May 2000 8:51 PM > > To: [EMAIL PROTECTED] > > Subject: <cfmail> > > > > > > how can i send images using <cfmail> tag. > > I want to send greeting cards thro' my site. > > > > ----------------------------------------------- > > FREE! The World's Best Email Address @email.com > > Reserve your name now at http://www.email.com > > > > > > -------------------------------------------------------------------------- > -- > > -- > > Archives: http://www.eGroups.com/list/cf-talk > > 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. > > > > -------------------------------------------------------------------------- > ---- > > Archives: http://www.eGroups.com/list/cf-talk > > 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. > > > > ------------------------------ > > Date: Sun, 28 May 2000 20:39:58 -0400 > From: "Joseph Eugene" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Subject: Re: Date Created Field > Message-ID: <001001bfc906$6b93d360$a10e1e26@gemini> > > Laura, > Do you want your field the database to be populated and at the > same time show the current date in the Date Created field? If so > Use > #DateFormat(now(), "DD-MMM-YYYY")# > > This also depends on your database, oracle has strict date > validations. > > Joe > > > > ----- Original Message ----- > From: "LH Rothman" <[EMAIL PROTECTED]> > To: "CF Talk" <[EMAIL PROTECTED]> > Sent: Sunday, May 28, 2000 5:06 PM > Subject: Date Created Field > > > > I'm a very confused newbie. I want to add a new record and have the > > date that record is create automatically appear in a "DateCreated" > > field. I've been looking at the following code and don't know if I'm on > > the right track. > > > > Date Created: #DateFormat(File.TimeCreated,'DD MMM YY')# > > > > Any help is very appreciated. Thank you. > > -Laura > > > > -------------------------------------------------------------------------- > ---- > > Archives: http://www.eGroups.com/list/cf-talk > > 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. > > > > ------------------------------ > > End of CF-Talk V1 #54 > ********************* > -------------------------------------------------------------------------- ---- > Archives: http://www.eGroups.com/list/cf-talk > 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. > > ------------------------------------------------------------------------------ Archives: http://www.eGroups.com/list/cf-talk 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.
