Skip to Content.
Sympa Menu

internetworkers - RE: [internetworkers] coldfusion, access, and issues

internetworkers AT lists.ibiblio.org

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

List archive

Chronological Thread  
  • From: "Jesse D.d.m. Wilbur" <jdwilbur AT yahoo.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 13:51:51 -0700 (PDT)

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




Archive powered by MHonArc 2.6.24.

Top of Page