#65 Exception using 0.7.3
i get the following Exception using 0.7.3 (works with
0.7.2)
ByteFX.Data.MySqlClient.MySqlException: You have an
error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right
syntax to use near 'S, ELBECK, A CO. 8/101ST AVN
REGT SSA PLT UNIT 96157 , APO,
at ByteFX.Data.MySqlClient.Driver.ReadPacket()
at ByteFX.Data.MySqlClient.Driver.SendSql(String sql)
at
ByteFX.Data.MySqlClient.MySqlCommand.ExecuteBatch
(Boolean stopAtResultSet)
at
ByteFX.Data.MySqlClient.MySqlCommand.ExecuteNonQue
ry()
at Amazon.DBClass.ResolveCustomer(DataSet ds) in
F:\Users\brandons\Visual Studio
Projects\delimited\delimited2XML\DBClass.vb:line 84
The Command Is:
INSERT INTO Customers (FirstName, LastName, Address,
City, StateOrProvince, PostalCode, Phone, Email,
BillName, Country) VALUES(@FirstName, @LastName,
@Address, @City, @StateOrProvince, @PostalCode,
@Phone, @Email, @BillName, @Country)
Parameters:
FirstName - LII S
LastName - ELBECK
Address - A CO. 8/101ST AVN REGT SSA PLT UNIT
96157
City - APO
StateOrProvince - AE
PostalCode - 09325-6157
Phone -
Email - elbeckl@yahoo.com
BillName - LII ELBECK
Country - US
Why does the command work exactly as is with .7.2 and
not .7.3?
Brandon
Please let me know if you need any further information.
Logged In: YES
user_id=523261
I should be able to look at this tonight.
Logged In: YES
user_id=823798
I am still getting this error on some queries even using 0.74.
I have gone back to 0.72 where these queries do work.
Will 0.75 fix this, or do you need more information on it?
Logged In: YES
user_id=523261
Can you email me any queries, exactly as you sent them, that
failed to reggie@bytefx.com? I do not know of any current
problems with this but I want to check it before I put out 0.75.
Thanks
Reggie