wow I don't believe it, I just went though this nightmare. The field name
date needs to be changed to some other word like upLoadDate or something. I
like to never figured that one out.
Bryan
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 11, 2001 3:02 PM
Subject: RE: insert help
> > does anyone see anything wrong w/ this insert statement?
> > <cfquery name="AddImage"
> > datasource="catlingalleries"
> > dbtype="ODBC">
> > INSERT INTO OtherImages (SmallImage, ArtistID, TypeID, ArtName,
> > Price, Size, Date)
> > VALUES ('#fileName#', #ArtistID#, #TypeID#, '#RealName#',
> > '#Price#', '#Size#', '#Date#')
> > </cfquery>
>
> Assuming you've got your text vs. number datatypes straight, then you
> might consider that "Date" is a reserved word in most dbs, so you could
> either put brackets around it ("[Date]") when calling it by name, or
> rename that column to "myDate" or something.
>
> Also, unless your users are entering the date in perfect ODBC format, or
> your date field is just a text field, you're probably going to want to
> insert the date as #CreateODBCDate(Date)# (no ticks).
>
>
> Ron Allen Hornbaker
> President/CTO
> Humankind Systems, Inc.
> http://humankindsystems.com
> mailto:[EMAIL PROTECTED]
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
