LukeD — Wed, 09 Jan 2002 21:10:34 +0000

yes and yes it does! Strange though. I have tried everything!!

Peter J. Boettcher — Wed, 09 Jan 2002 21:01:11 +0000

I'm not a CF expert, but this looks ok. Have you tried uploading different images types (maybe jpg?), does it give you the same error?

LukeD — Wed, 09 Jan 2002 17:13:54 +0000

INSERT INTO CarInventory(Image)
VALUES ('#imagename#')
WHERE StockNumber = #StockNumber#

The "Image" field has datatype varchar at 50 lenght.

My form looks like this:

#StockNumber#" enctype="multipart/form-data" name="Form" method="post">

Thanks for your help!

Peter J. Boettcher — Wed, 09 Jan 2002 17:10:38 +0000

It's hard to tell without knowing exactly what the function is doing (code & query).

From the error it looks like there is some sort of problem with the datatype or maybe the structure of your query (hence the reference to "Column names are not permitted").

Can you post the code and or SQL query?