Dogbonesix Active Member Licensed User Longtime User Aug 29, 2013 #1 Everytime I use an astrophe ( ' ) in a field name of a query - the query fails. What is the best way to overcome this problem? I was hoping httputils2 would help - but not so far. Thanks for any help.
Everytime I use an astrophe ( ' ) in a field name of a query - the query fails. What is the best way to overcome this problem? I was hoping httputils2 would help - but not so far. Thanks for any help.
NJDude Expert Licensed User Longtime User Aug 29, 2013 #2 You have to double the quotes (apostrophe), you can use REPLACE for that. Code: Copy ... Query = "Eat at Joe's" Query = Query.Replace("'", "''") 'Replace ' with '' (2 single quotes) ... Last edited: Aug 29, 2013 Upvote 0
You have to double the quotes (apostrophe), you can use REPLACE for that. Code: Copy ... Query = "Eat at Joe's" Query = Query.Replace("'", "''") 'Replace ' with '' (2 single quotes) ...
Erel B4X founder Staff member Licensed User Longtime User Aug 30, 2013 #3 Are you using HttpUtils2.Download2? Upvote 0
Dogbonesix Active Member Licensed User Longtime User Aug 31, 2013 #4 I figured out how to connect to MySql and do Select, Update, Insert and Delete queries Saw a sample code to download using ...utils2. I did not try it because there was no follow-on sample to upload - Which I would need both. ...utis2 would be a better generic solution - I have tried double quotes without success but yhere about 10,000 ways to put double quotes in a query I will try NJDudes solution but being to use httputil2 both Download and Upload would be most useful. Thanks. Upvote 0
I figured out how to connect to MySql and do Select, Update, Insert and Delete queries Saw a sample code to download using ...utils2. I did not try it because there was no follow-on sample to upload - Which I would need both. ...utis2 would be a better generic solution - I have tried double quotes without success but yhere about 10,000 ways to put double quotes in a query I will try NJDudes solution but being to use httputil2 both Download and Upload would be most useful. Thanks.
