Re: variable as a string

2004-06-01 Thread Terry Troxel
try #createodbcdate(dateformat(yourstringvalue,'mm/dd/'))# - Original Message - From: JT To: CF-Talk Sent: Monday, May 31, 2004 4:32 PM Subject: variable as a string Hi Gang, I have a variable as a string Tuesday, June 1, 2004 What I am Trying to figure out is how can I change

variable as a string

2004-05-31 Thread JT
Hi Gang, I have a variable as a string Tuesday, June 1, 2004 What I am Trying to figure out is how can I change it to 06-01-2004 Any one can tell me if it can be done and how? JT [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: variable as a string

2004-05-31 Thread Aaron DC
DateFormat(yourvar, mm-dd-) Aaron - Original Message - From: JT To: CF-Talk Sent: Tuesday, June 01, 2004 9:32 AM Subject: variable as a string Hi Gang, I have a variable as a string Tuesday, June 1, 2004 What I am Trying to figure out is how can I change it to 06-01-2004

RE: variable as a string

2004-05-31 Thread JT
When I do that I get this Error The value Tuesday, June 1, 2004 could not be converted to a date. JT -Original Message- From: Aaron DC [mailto:[EMAIL PROTECTED] Sent: Monday, May 31, 2004 4:54 PM To: CF-Talk Subject: Re: variable as a string DateFormat(yourvar, mm-dd-) Aaron

RE: variable as a string

2004-05-31 Thread Matthew Walker
Have you tried parseDateTime() or lsParseDateTime()? (That's an L not an I) _ From: JT [mailto:[EMAIL PROTECTED] Sent: Tuesday, 1 June 2004 12:34 p.m. To: CF-Talk Subject: RE: variable as a string When I do that I get this Error The value Tuesday, June 1, 2004 could not be converted

RE: variable as a string

2004-05-31 Thread JT
Thanks Matthew, Just What I was Looking For. JT -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED] Sent: Monday, May 31, 2004 5:43 PM To: CF-Talk Subject: RE: variable as a string Have you tried parseDateTime() or lsParseDateTime()? (That's an L not an I) _ From: JT

Declare a variable as a string in SQL

2001-10-25 Thread Dusty Tinashe Shoko
How do I declare a variable as a string in SQL? I want to create tables dynamically in Coldfusion and Access and some of the input will be huge amounts of text And when we think we getting a lil stronger Thats when we weakest of all!! We think we're holding onto something special That very