internetworkers AT lists.ibiblio.org
Subject: Internetworkers: http://www.ibiblio.org/internetworkers/
List archive
RE: [internetworkers] coldfusion, access, and issues
- From: "Chris Reeves" <chris.reeves AT religent.com>
- To: "'Internetworkers: http://www.ibiblio.org/internetworkers/'" <internetworkers AT lists.ibiblio.org>
- Subject: RE: [internetworkers] coldfusion, access, and issues
- Date: Mon, 14 Jul 2003 16:56:35 -0400
Run this and let me know what it displays
++++++++++++++++++++++
<CFIF (date IS "") OR (NOT IsDate(date))>
<CFSET date2="NULL">
<CFELSE>
<CFSET date2=CreateODBCDate(date)>
</CFIF>
<cfset dateformatted = DateFormat('#date2#','mm/dd/yyyy')>
<cfoutput>
INSERT INTO test (name, description, date, phone, yesno)<br>
VALUES
('#name#','#description#','#dateformatted#','#phone#','#yesno#')
</cfoutput>
<cfabort>
++++++++++++++++++++
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:52 PM
To: Internetworkers: http://www.ibiblio.org/internetworkers/
Subject: RE: [internetworkers] coldfusion, access, and issues
The exact cfquery code is here:
<CFIF (date IS "") OR (NOT IsDate(date))>
<CFSET date2="NULL">
<CFELSE>
<CFSET date2=CreateODBCDate(date)>
</CFIF>
<cfset dateformatted = DateFormat('#date2#','mm/dd/yyyy')>
<cfoutput>#name#, #description#, #dateformatted#, #phone#,
#yesno#</cfoutput> <cfquery name="qinserttest" datasource="testdb"
DBTYPE="ODBC">
INSERT INTO test (name, description, date, phone, yesno)
VALUES
('#name#','#description#','#dateformatted#','#phone#','#yesno#')
</cfquery>
And the output from the last try I had was
chalfant, For data sources..., 01/01/2003, 9335908, 0
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
-
[internetworkers] coldfusion, access, and issues,
Jesse D.d.m. Wilbur, 07/14/2003
-
RE: [internetworkers] coldfusion, access, and issues,
Chris Reeves, 07/14/2003
-
RE: [internetworkers] coldfusion, access, and issues,
Jesse D.d.m. Wilbur, 07/14/2003
- RE: [internetworkers] coldfusion, access, and issues, Chris Reeves, 07/14/2003
-
Re: [internetworkers] coldfusion, access, and issues,
rthigpen, 07/14/2003
- Re: [internetworkers] coldfusion, access, and issues, Jesse D.d.m. Wilbur, 07/14/2003
-
RE: [internetworkers] coldfusion, access, and issues,
Jesse D.d.m. Wilbur, 07/14/2003
-
RE: [internetworkers] coldfusion, access, and issues,
Chris Reeves, 07/14/2003
Archive powered by MHonArc 2.6.24.