By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,181 Members | 1,169 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,181 IT Pros & Developers. It's quick & easy.

[URGENT] Error incorrect syntax near

P: n/a
Dax
When i insert some values float in a form made with ASP
appear an error message like this:
Microsoft OLE DB Provider for SQL Server (0x80040E14)
Line 1: Incorrect syntax near ','.

sql="select id from tbl_monete where id_taglio="&idtaglio
rs1.open sql, conn

idTaglio it's the value of money that can be like 0,5 0,2,
0,1 etc etc
If i try one or two times it'll work correctly, why?
Table tbl_monete has field id_taglio that is float.
What can I do?

Thanks,
Daniele

Feb 13 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Dax wrote:
When i insert some values float in a form made with ASP
appear an error message like this:
Microsoft OLE DB Provider for SQL Server (0x80040E14)
Line 1: Incorrect syntax near ','.

sql="select id from tbl_monete where id_taglio="&idtaglio
rs1.open sql, conn

idTaglio it's the value of money that can be like 0,5 0,2,
0,1 etc etc
If i try one or two times it'll work correctly, why?
Table tbl_monete has field id_taglio that is float.
What can I do?
Use a period to delimit the decimal instead of a comma. Better yet, use
parameters:
http://groups-beta.google.com/group/...e36562fee7804e

Personally, I prefer using stored procedures:
http://groups.google.com/group/micro...09dc1701?hl=en

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Feb 13 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.