Internetworkers: http://www.ibiblio.org/internetworkers/

["Chris Reeves" <chris.reeves AT religent.com>]

I would highly recommend not using cfinsert or any of the other db
pre-fab tags in cold fusion.

In the test you ran using cfquery, what was the exact code? Also, try
replacing your cfquery beginning and end tags with a cfoutput block (and
add a cfabort at the end) to show exactly what sql is being passed to
your db. Post the code if you still need help

c

-----Original Message-----
From: internetworkers-bounces AT lists.ibiblio.org
[mailto:internetworkers-bounces AT lists.ibiblio.org] On Behalf Of Jesse
D.d.m. Wilbur
Sent: Monday, July 14, 2003 4:43 PM
To: internetworkers
Subject: [internetworkers] coldfusion, access, and issues


hey INW,

I'm working on a client's project where they have me using coldfusion
and (eventually) MS SQL server. But to get it together on my workstation
I'm using Access as a test. However, one incredibly frustrating problem:
I cannot get Access to accept dates from form data. Has anyone
successfully surmounted this problem? If you aren't interested, stop
reading here.

Cos the rest of this is what I've already tried:

cfinsert, using the same database field and form field names. No go.
cfquery, using all sorts of different formats. Access is set to Short
Date with  general date with  Output (from the debugger) looked like
this

1/1/2001
'1/1/2001'
#1/1/2001#
1.1.2001
{d '2003-01-01'}   (this is the output from CreateODBCDate function)

None of those worked. Access just will not accept dates. Is there
anything I should be doing to either CF or Access datatypes to make this
compatible? (besides not using access or coldfusion. I already thought
of that).

All help and input is appreciated. 

Jesse


=====
_____________________________________
 tout comprendre c'est tout pardoner

__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com
---
Come and play at the InterNetWorkers Web site!
http://www.ibiblio.org/internetworkers/
You are currently subscribed to InterNetWorkers mailing list
To unsubscribe visit
http://lists.ibiblio.org/mailman/listinfo/internetworkers