C
C#•2y ago
Ossie

MySQL Connector Paramerts.AddWithValue, not working?

Hello, I'm trying to do a prepared mysql query, however it doesn't seem to wanna bind my values. My code is the following: https://sourceb.in/9gNZINmB4C It shows the follwing in my console with the debugs: https://i.imgur.com/AvlrWlV.png In my database it becomes like this: https://i.imgur.com/bSoRCD9.png Which tells me it doesn't bind my params to the SQL statement, am I doing something wrong? I tried following this: https://dev.mysql.com/doc/connector-net/en/connector-net-programming-prepared.html
Imgur
Imgur
2 Replies
Zendist
Zendist•2y ago
Your SQL query is wrapping the prepared variable in single quotes. Remove that, otherwise it's just considered to be a static value.
Ossie
Ossie•2y ago
Thanks!
Want results from more Discord servers?
Add your server
More Posts
How do I efficiently stream data to disk from a websocket client?I'm consuming realtime data from a websocket client and I want to be writing it into a .txt file. `Is there a good way to use a object from Type Type in a generic method?```c Type type = typeof(object); GenericMethod</*use Type here*/>(); ``` I have a lot of seriaGit Moving from feature branch to main [Answered]Hi! I have made a new branch for a new feature and have made some commits in there, how can I push tSlash Command purge [Answered]Hi, I'm trying to use my old purge command as a slash command, but I end up giving me the Discord Erwait for processes [closed]I want to wait for a process to close to perform some action how can I do that?Collection was modified enumeration operation may not executeHi - I am working on a client - server chat application for my school project. The server app has a