> 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
