I'm not sure about the datatype. I do know that CF's SQL engine does not support ODBC formatted dates - so perhaps if some manipulation is done, you might be able to utilize the columns as datetime fields.
-- Billy Cravens >From: RICARDO SANOJA <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: [EMAIL PROTECTED] >Subject: Query of Query question >Date: Thu, 25 Oct 2001 09:46:17 -0700 (PDT) > >Once the original query is ran, does the data retain it's data type? This >question is for a friend, and I do not have the oppurtunity to test out (no >5.0). He says that if he tries to perform a query on an existing dataset >using date fields, that the data comes back screwy. I am assuming that the >recordset now contains the date as a string so sorts are alphanumeric >instead of by date. Or selections based on when date "between" date1 and >date2, do not work. > >Any insite? > >Sincerely, >Ricardo Sanoja > > > > > >_______________________________________________________ >http://inbox.excite.com > > > >------------------------------------------------------------------------- >This email server is running an evaluation copy of the MailShield anti- >spam software. Please contact your email administrator if you have any >questions about this message. MailShield product info: www.mailshield.com > >----------------------------------------------- >To post, send email to [EMAIL PROTECTED] >To subscribe / unsubscribe: http://www.dfwcfug.org _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
