| Author |
 Topic  |
|
|
redbrad0
Advanced Member
USA
3725 Posts |
 Posted - 08 March 2002 : 17:24:01
|
im trying to insert some text into a sql server where a couple field types are "money" Here is the sql string and then the error message...
INSERT INTO ExhibitParts_Store_Products (Prod_Cag_ID, Prod_Name, Prod_Description, Prod_Picture_URL, Prod_Usual_Price, Prod_Price, Prod_Quanity_In_Stock, Prod_Weight) VALUES ('4', 'Black Pro-style Cap', 'Constructed front cotton/polyester blended cap. Red embroidered Exxon logo. Adjustable self fabric back closure. Black. One size.', '100139_s.jpg', '3.95', '5.95', '25', '1')
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC SQL Server Driver][SQL Server]Disallowed implicit conversion from data type varchar to data type money, table 'exhibitpartscom.exhibitpartscom.ExhibitParts_Store_Products', column 'Prod_Usual_Price'. Use the CONVERT function to run this query.
/employee/edit_products.asp, line 117
I even tried inserting $3.95 and it still didnt work, what am i doing wrong?
INSERT INTO ExhibitParts_Store_Products (Prod_Cag_ID, Prod_Name, Prod_Description, Prod_Picture_URL, Prod_Usual_Price, Prod_Price, Prod_Quanity_In_Stock, Prod_Weight) VALUES ('4', 'Black Pro-style Cap ', 'Constructed front cotton/polyester blended cap. Red embroidered Exxon logo. Adjustable self fabric back closure. Black. One size.', '100139_s.jpg', '$3.95', '$5.95', '25', '1')
Brad
Web Hosting with SQL Server @ $24.95 per month
Snitz Mod Archive
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 08 March 2002 : 17:34:37
|
you are trying to insert them as strings they are floating point numbers, they should not have any ' around them
|
 |
|
|
redbrad0
Advanced Member
USA
3725 Posts |
|
|
Deleted
deleted
4116 Posts |
Posted - 08 March 2002 : 17:45:27
|
Did you try this?
quote:
INSERT INTO ExhibitParts_Store_Products (Prod_Cag_ID, Prod_Name, Prod_Description, Prod_Picture_URL, Prod_Usual_Price, Prod_Price, Prod_Quanity_In_Stock, Prod_Weight) VALUES ('4', 'Black Pro-style Cap', 'Constructed front cotton/polyester blended cap. Red embroidered Exxon logo. Adjustable self fabric back closure. Black. One size.', '100139_s.jpg', 3.95, 5.95, '25', '1')
Think PinkPost v40b03 Patches |
|
|
|
Deleted
deleted
4116 Posts |
Posted - 08 March 2002 : 17:47:56
|
Hmm. That means, that I have to re-open the topic before posting!
Think PinkPost v40b03 Patches |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 08 March 2002 : 18:02:28
|
quote:
Hmm. That means, that I have to re-open the topic before posting!
Think PinkPost v40b03 Patches
?
|
|
|
|
Deleted
deleted
4116 Posts |
Posted - 08 March 2002 : 18:37:15
|
quote:
quote:
Hmm. That means, that I have to re-open the topic before posting!
Think PinkPost v40b03 Patches
?
My (bad) habbit is to open a couple of topic windows at once (from active.asp) and answer them one by one. I do this because I'm on 56K dial-up, and whichever topic comes first, I read that. Look, there are 10 good minutes between your post and mine, and I was not aware that you answered the question already.
Think PinkPost v40b03 Patches |
|
|
|
redbrad0
Advanced Member
USA
3725 Posts |
|
|
Deleted
deleted
4116 Posts |
|
| |
Topic |
|
|
|
Topic Locked
