;[EMAIL PROTECTED]>
Sent: Wednesday, April 11, 2001 3:02 PM
Subject: RE: insert help
> > does anyone see anything wrong w/ this insert statement?
> > > datasource="catlingalleries"
> > dbtype="ODBC">
> > INSERT INTO OtherImages (SmallIm
; <[EMAIL PROTECTED]>
Sent: Wednesday, April 11, 2001 2:00 PM
Subject: RE: insert help
> I think that Date is a reserved word... Try changing that to myDate or
> something else.
>
> Jeff Garza
> Web Developer/Webmaster
> Spectrum Astro, Inc.
> 480.892.8200
your insert statement looks ok by itself, you may want to look at the data
being passed.
How are the fields in your table set up, do you allow zero length strings,
if not are you checking for validation before passing the data? you could
look at the date field, in the code you are not formattin
> does anyone see anything wrong w/ this insert statement?
> datasource="catlingalleries"
> dbtype="ODBC">
> INSERT INTO OtherImages (SmallImage, ArtistID, TypeID, ArtName,
> Price, Size, Date)
> VALUES ('#fileName#', #ArtistID#, #TypeID#, '#RealName#',
> '#Price#', '#Size#', '#
I think that Date is a reserved word... Try changing that to myDate or
something else.
Jeff Garza
Web Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200
[EMAIL PROTECTED]
http://www.spectrumastro.com
-Original Message-
From: Jay Patton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday,
Shot in the dark here, but try this as your insert statement:
INSERT INTO OtherImages (SmallImage, ArtistID, TypeID, ArtName, Price, Size, Date)
VALUES ('#fileName#', #ArtistID#, #TypeID#, '#RealName#', '#Price#', '#Size#',
###Date###)
hth,
Brian Simmons
[EMAIL PROTECTED]
ColdFusion 4.5 Certi
Hi Jay,
Date is a reserverd word in SQL. Change your column name.
Aaron Johnson, MCSE, MCP+I
Allaire Certified ColdFusion Developer
MINDSEYE, Inc.
617.350.0339
617.350.8884
66172567
[EMAIL PROTECTED]
> -Original Message-
> From: Jay Patton [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday,
Double check your data types; for example, are Price, Size and Date really
text fields? (Its value is surrounded by single quotes in the statement.)
FYI - Try to name your date fields something other than "date".
-Original Message-
From: Jay Patton [mailto:[EMAIL PROTECTED]]
Sent: Wednes
8 matches
Mail list logo