[AccessD] ADO Problem

Let's assume that the original error was the result of 11/28/2006 being interpreted as "11 divided by 28 divided by 2006".  That's near enough to zero to cause the date result of 1/1/1900.  The new error suggests that since "#11" is not a number it is being seen as as a column name which is to be divided by 28 and then by 2006.  #11 does not exist as a column name, hence the error.  Is dtToday dimmed as a date datatype?  If not, that might be the problem.

HTH

Don

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Beach Access Software
Sent: Tuesday, November 28, 2006 11:36 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] ADO Problem

Using:

"SELECT #" & dtToday & "#"

He gets an error message: 

Invalid column name '#11'

dtToaday does contain 11/28/2006

What else could it be?

MTIA

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of McGillivray, Don
[IT]
Sent: Tuesday, November 28, 2006 10:39 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] ADO Problem

Hi, Rocky.  

Just a WAG (I don't know ADO), but how 'bout:

   Conn.Execute "INSERT INTO tWeeklyUpdateSent ( DateSent ) " & _
                 "SELECT #" & dtToday & "#;" 

Don

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Beach Access
Software
Sent: Tuesday, November 28, 2006 10:15 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] ADO Problem

Dear List:

A colleague (who thinks I know ADO) writes in to ask why the following:

   Conn.Execute "INSERT INTO tWeeklyUpdateSent ( DateSent ) " & _
                 "SELECT " & dtToday & ""

Inserts a record into tWeeklyUpdateSent so the conection is OK.  But but the
date is 1/1/1900 instead of today's date.

I had him check the contents of dtToday and it does indeed have 11/28/2006
in it.

Does anyone see what he's doing wrong here?


MTIA

Rocky


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.430 / Virus Database: 268.14.19/555 - Release Date: 11/27/2006
6:09 PM
 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com