| Author |
 Topic  |
|
|
Amberrosereynolds
Starting Member
United Kingdom
9 Posts |
 Posted - 01/18/2012 : 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! :)
|
Edited by - Amberrosereynolds on 01/18/2012 05:36:27
|
|
|
GilaMonster
Flowing Fount of Yak Knowledge
South Africa
4507 Posts |
Posted - 01/18/2012 : 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 Shaw
SQL Server MVP |
 |
|
|
Amberrosereynolds
Starting Member
United Kingdom
9 Posts |
Posted - 01/18/2012 : 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
Flowing Fount of Yak Knowledge
2111 Posts |
|
|
GilaMonster
Flowing Fount of Yak Knowledge
South Africa
4507 Posts |
Posted - 01/18/2012 : 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 Shaw
SQL Server MVP |
|
|
|
Amberrosereynolds
Starting Member
United Kingdom
9 Posts |
Posted - 01/18/2012 : 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 Shaw
SQL Server MVP
So don't answer then??? Just a suggestion.... |
|
|
|
Transact Charlie
Flowing Fount of Yak Knowledge
United Kingdom
3425 Posts |
Posted - 01/18/2012 : 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 Shaw
SQL 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 1736
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
Amberrosereynolds
Starting Member
United Kingdom
9 Posts |
Posted - 01/18/2012 : 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 Shaw
SQL 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 1736
The 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
United Kingdom
9 Posts |
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
|
Amberrosereynolds
Starting Member
United Kingdom
9 Posts |
|
| |
Topic |
|
SQL Exam Updates?????
Topic Locked
