SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SQL Exam Updates?????
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Amberrosereynolds
Starting Member

United Kingdom
9 Posts

Posted - 01/18/2012 :  04:48:43  Show Profile
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  Show Profile  Visit GilaMonster's Homepage
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
Go to Top of Page

Amberrosereynolds
Starting Member

United Kingdom
9 Posts

Posted - 01/18/2012 :  06:39:54  Show Profile
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.
Go to Top of Page

DonAtWork
Flowing Fount of Yak Knowledge

2165 Posts

Posted - 01/18/2012 :  06:40:48  Show Profile
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.aspx
How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

For ultra basic questions, follow these links.
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 01/18/2012 :  07:06:33  Show Profile  Visit GilaMonster's Homepage
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
Go to Top of Page

Amberrosereynolds
Starting Member

United Kingdom
9 Posts

Posted - 01/18/2012 :  09:39:40  Show Profile
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....
Go to Top of Page

Transact Charlie
Flowing Fount of Yak Knowledge

United Kingdom
3451 Posts

Posted - 01/18/2012 :  10:00:55  Show Profile  Visit Transact Charlie's Homepage
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
Go to Top of Page

Amberrosereynolds
Starting Member

United Kingdom
9 Posts

Posted - 01/18/2012 :  10:11:24  Show Profile
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
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 01/18/2012 :  10:42:39  Show Profile
>> Don't really see how that could annoy anyone...Never mind..SORRY

How about when you're asked a question, you don't respond, and you post a snide answer?

How could ANYONE get annoyed at that

Age or Sex???

Just Sayin

http://www.sqlteam.com/forums/pop_profile.asp?mode=display&id=73690





Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/


Go to Top of Page

Amberrosereynolds
Starting Member

United Kingdom
9 Posts

Posted - 01/18/2012 :  10:49:23  Show Profile
quote:
Originally posted by X002548

>> Don't really see how that could annoy anyone...Never mind..SORRY

How about when you're asked a question, you don't respond, and you post a snide answer?

How could ANYONE get annoyed at that

Age or Sex???

Just Sayin

http://www.sqlteam.com/forums/pop_profile.asp?mode=display&id=73690





Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/






Don't get what you mean? Sorry, been a long day....
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37466 Posts

Posted - 01/18/2012 :  15:44:49  Show Profile  Visit tkizer's Homepage
You still haven't posted the error. You say the page errors, so why not post it?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Amberrosereynolds
Starting Member

United Kingdom
9 Posts

Posted - 01/19/2012 :  03:23:41  Show Profile
quote:
Originally posted by tkizer

You still haven't posted the error. You say the page errors, so why not post it?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog



Haven't posted it, because I don't know it, my boss didn't tell me it, and he's wasn't available to ask...Its been sorted now though anyway...thanks!
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000