galahad3
10-02-2009, 01:34 PM
Hi, I've had to undertake a project to fix some administrative problems with a site built using ASP pages and connecting to a mySQL db. I haven't really used ASP much before and I'm trying to work out what's causing these issues.
The page below basically is an editing page for a record pulled from the mySQL db. Each of the fields should be editable, you make the edits you need and click the Submit to enter them into the table in the db.
The problem is, the details just refuse to update. There's no connection error of any kind, the edit just doesn't seem to work at all. I see a brief "0 rows were affected" message page before it goes back to exactly the same screen as before.
The db itself seems to be working ok as items from it are being pulled in and displayed.
Unfortunately the page code is too long for this forum and I've no idea which parts of it are causing the problem, but if someone(s) can give me some ideas as to what to start looking for (bearing in mind I really don't know my round ASP much so in layman's terms if possible) that would be much appreciated.
The page below basically is an editing page for a record pulled from the mySQL db. Each of the fields should be editable, you make the edits you need and click the Submit to enter them into the table in the db.
The problem is, the details just refuse to update. There's no connection error of any kind, the edit just doesn't seem to work at all. I see a brief "0 rows were affected" message page before it goes back to exactly the same screen as before.
The db itself seems to be working ok as items from it are being pulled in and displayed.
Unfortunately the page code is too long for this forum and I've no idea which parts of it are causing the problem, but if someone(s) can give me some ideas as to what to start looking for (bearing in mind I really don't know my round ASP much so in layman's terms if possible) that would be much appreciated.