Re: insert help

2001-04-11 Thread Bryan LaPlante
;[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

Re: insert help

2001-04-11 Thread Jay Patton
; <[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

RE: insert help

2001-04-11 Thread Bruce, Rodney
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

RE: insert help

2001-04-11 Thread ron
> 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#', '#

RE: insert help

2001-04-11 Thread Garza, Jeff
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,

Re: insert help

2001-04-11 Thread Brian Simmons
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

RE: insert help

2001-04-11 Thread Aaron Johnson
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,

RE: insert help

2001-04-11 Thread Hayes, David
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