Why do I get tmp date
I have a form where I upload a picture to my webserver then use a function (CFML) that takes the filename of the picture and adds it to my SQL Server 7.0 database.
[Microsoft][ODBC SQL Server Driver][SQL Server]The name 'gif' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
the field datatype is vnarchar
Luc Deault
----------------------------------
If the minimum wasn't acceptable it wouldn't be called the minimum
-----------------------------------
Peter J. Boettcher posted this at 17:10 — 9th January 2002.
They have: 812 posts
Joined: Feb 2000
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?
PJ | Are we there yet?
pjboettcher.com
LukeD posted this at 17:13 — 9th January 2002.
They have: 22 posts
Joined: Sep 2000
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!
Luc Deault
----------------------------------
If the minimum wasn't acceptable it wouldn't be called the minimum
-----------------------------------
Peter J. Boettcher posted this at 21:01 — 9th January 2002.
They have: 812 posts
Joined: Feb 2000
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 posted this at 21:10 — 9th January 2002.
They have: 22 posts
Joined: Sep 2000
yes and yes it does! Strange though. I have tried everything!!
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.