Re: Truncate?

es be the same time, unless of course you are concerned about the time of day. TRUNC() lets you compare apples to apples. -Rice -Original Message- From: Dina Hess [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 10:41 AM To: CF-Talk Subject: Truncate? Uh...

Truncate?

Uh...would someone mind briefing me on the TRUNC or TRUNCATE function? Can't find either in my SQL or CF references. - Original Message - From: Rice, John J To: CF-Talk Sent: Thursday, August 30, 2001 8:35 AM Subject: RE: Systdate Query This should work: /**/ WHER

Re: SQL

Don't know about the truncate thing, but this should delete all rows leaving you with an empty table: DELETE FROM TABLE_NAME - Original Message - From: Rayna Evans To: CF-Talk Sent: Wednesday, August 29, 2001 2:35 PM Subject: SQL I am trying to clear some data out of a t

Re: Dates in Access

To work with Access dates configured as either OLE-DB or ODBC data sources, use single quotes ('03/31/2000') or double pound signs (##03/31/2000##). The CreateDate and CreateODBCDate functions can only be used with an ODBC data source. - Original Message - From: Snyder, Jason T

Re: setting up win2000 ftp

I haven't done this before, but you may want to try using the FrontPage File | Import feature to download an existing web onto your computer...let me know if that works... Dina - Original Message - From: PB To: CF-Talk Sent: Saturday, August 25, 2001 10:41 AM Subject: OT: se

Re: Quick query question (qqq)

You may need to substitute an asterisk (*) for the percent sign (%) when using the multiple character wildcard and a question mark (?) for the underscore ( _ ) when using a single character wildcard. Dina - Original Message - From: Diana Nichols To: CF-Talk Sent: Saturday, Aug

Re: which web server do you use for CF?

ent List should contain references to the following files: Default.htm, Default.asp, and Default.cfm. Hope that helps... Dina Hess - Original Message - From: John Quarto-vonTivadar To: CF-Talk Sent: Friday, August 24, 2001 10:11 AM Subject: which web server do you use for CF?

Re: How can I insert a new record with no values?

Philip, I thank you again for your suggestion, however neither of the two fields in the table will accept a null since one is an autonumber and one contains a default value. Re: maintenance There is only one instance of this code in my application, so that won't be a problem when I migrate to

Re: How can I insert a new record with no values?

am pretty sure that it works in SQL Server. Was not sure about Access. -- Guy M. Saenger [EMAIL PROTECTED] 214.448.8887 - Original Message - From: "Dina Hess" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, August 01

Re: How can I insert a new record with no values?

insert a new record with no values? Have you tried just: INSERT INTO Table ? Pete Freitag ([EMAIL PROTECTED]) CFDEV.COM ColdFusion Developers Resources http://www.cfdev.com/ -Original Message- From: Dina Hess [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 01, 2001 1

Re: How can I insert a new record with no values?

erver, you just set identity insert off, but I don't think Access has that. Isn't it easier to just insert a null value into a garbage field and be done with it? -Original Message----- From: Dina Hess [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 01, 2001 10:20 A

Re: How can I insert a new record with no values?

Philip, The autonumber field in my query does not accept nulls...but thank you for your input... Dina - Original Message - From: Philip Arnold - ASP To: CF-Talk Sent: Wednesday, August 01, 2001 12:50 PM Subject: RE: How can I insert a new record with no values? > Would

Re: How can I insert a new record with no values?

PROTECTED] 214.448.8887 - Original Message - From: "Dina Hess" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, August 01, 2001 12:20 PM Subject: How can I insert a new record with no values? > Hello all, > &

How can I insert a new record with no values?

Hello all, Would anyone be able to tell me how I can insert a row into a table that requires no values. My MS Access table stores only an auto number and an expiration date. The auto number, of course, is generated by the dbms and the expiration date, which is set to a default value, is also g

Re: Newbie question

Hello newbie...welcome to my club :-) The only thing I see wrong with your code is the comment tags...these should be , not - Original Message - From: [EMAIL PROTECTED] To: CF-Talk Sent: Tuesday, July 31, 2001 5:37 AM Subject: Newbie question Hi all I've got a problem

<    1   2   3