[SOLVED] MySQL Update Query - What am I doing wrong?

[brandonio21]

Brandon, even with the addition of the adapter as suggested, no rows are being affected. Code is still returning the ELSE statement: "Card info NOT updated!"

So this means that everything is working properly, but the Query is simply not doing anything.

Well, the only thing that I can think of is this line:

"WHERE ccID = @ccID"

Here, you provide a direct link between ccID (Which is an INT in the database) with @ccID (Which is a string in your application).

So, instead of using "ListViewCard.SelectedItems(0).ToString" as your ccID Parameter, I think you should switch the line to:
[code2=vbnet].Parameters.AddWithValue("@ccID", CInt(ListViewCard.SelectedItems(0).ToString))[/code2]

Maybe that will do something. Maybe.