Author |
Topic |
Amberrosereynolds
Starting Member
9 Posts |
Posted - 2012-01-18 : 04:48:43
|
Hello, My company have created a website where employees will be able to take a test to earn points (CPD hours) which will be updated every time an employee takes the test. I am trying to find a way to update the number of CPD hours each employee has earned by using SQL, and displaying this on their profile page. The number of CPD hours awarded will need to be updated every time they earn more points. Every time they take the test, 2 CPD hours will be added.We have created the tables for this, but when loading the page, an error occurs. This is what we have at the minute,Dim CPDHourUpdate As SqlDataSource = New SqlDataSource() CPDHourUpdate.ConnectionString = ConfigurationManager.ConnectionStrings("Application").ToString() CPDHourUpdate.UpdateCommand = "UPDATE UserDetails SET CPD_Hours = CPD_Hours + 2 WHERE UserId = @UserId" CPDHourUpdate.UpdateParameters.Add("UserId", Session("UserID").ToString()) Dim rowsAffected As Integer = CPDHourUpdate.Update()Any help would be much appreciated!Thanks in advance! :) |
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-01-18 : 06:26:26
|
As I said last time you posted this (http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=170290), you are not giving anywhere close to enough information.You haven't said what error, you haven't said anything about your table design. How exactly do you expect someone to be able to give you useful advice?--Gail ShawSQL Server MVP |
|
|
Amberrosereynolds
Starting Member
9 Posts |
Posted - 2012-01-18 : 06:39:54
|
Well I'm new to this so sorry to have offended you as it seems, but I have no more informations, this is all I've been given. |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2012-01-18 : 06:40:48
|
Try following the HOW TO ASK link in my signature for some help on giving us the information we need to assist you.http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspxHow to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxFor ultra basic questions, follow these links.http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-01-18 : 07:06:33
|
quote: Originally posted by Amberrosereynolds Well I'm new to this so sorry to have offended you as it seems, but I have no more informations, this is all I've been given.
So you have no idea what the error message is, you've never seen the table designs and can't ask for them?I'm not offended, but I can't help you.--Gail ShawSQL Server MVP |
|
|
Amberrosereynolds
Starting Member
9 Posts |
Posted - 2012-01-18 : 09:39:40
|
quote: Originally posted by GilaMonster
quote: Originally posted by Amberrosereynolds Well I'm new to this so sorry to have offended you as it seems, but I have no more informations, this is all I've been given.
So you have no idea what the error message is, you've never seen the table designs and can't ask for them?I'm not offended, but I can't help you.--Gail ShawSQL Server MVP
So don't answer then??? Just a suggestion.... |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2012-01-18 : 10:00:55
|
quote: Originally posted by Amberrosereynolds
quote: Originally posted by GilaMonster
quote: Originally posted by Amberrosereynolds Well I'm new to this so sorry to have offended you as it seems, but I have no more informations, this is all I've been given.
So you have no idea what the error message is, you've never seen the table designs and can't ask for them?I'm not offended, but I can't help you.--Gail ShawSQL Server MVP
So don't answer then??? Just a suggestion....
Yeah -- that's a smart move. Piss of a vastly experienced and capable Microsoft MVP who was trying to help you out.Your question is vague, gives way too little information and we do this for free.bye.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
Amberrosereynolds
Starting Member
9 Posts |
Posted - 2012-01-18 : 10:11:24
|
quote: Originally posted by Transact Charlie
quote: Originally posted by Amberrosereynolds
quote: Originally posted by GilaMonster
quote: Originally posted by Amberrosereynolds Well I'm new to this so sorry to have offended you as it seems, but I have no more informations, this is all I've been given.
So you have no idea what the error message is, you've never seen the table designs and can't ask for them?I'm not offended, but I can't help you.--Gail ShawSQL Server MVP
So don't answer then??? Just a suggestion....
Yeah -- that's a smart move. Piss of a vastly experienced and capable Microsoft MVP who was trying to help you out.Your question is vague, gives way too little information and we do this for free.bye.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION
Didn't mean to piss anyone off, I was just saying...Don't really see how that could annoy anyone...Never mind..SORRY |
|
|
X002548
Not Just a Number
15586 Posts |
|
Amberrosereynolds
Starting Member
9 Posts |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
Amberrosereynolds
Starting Member
9 Posts |
|
|