|
That error will occur if you click the button when you have not selected any of the radio buttons on the RadioButtonList1. So you need to check whether the selection has first happened. Probably using:
if (RadioButtonList1.SelectedIndex != -1)
lbltemp.Text = RadioButtonList1.SelectedItem.Text;
|
|
|
|
|
I am inserting record in table using stored procedure.
CREATE PROCEDURE add_member(
@UserName Varchar( 50 ),
@Password Varchar( 50 ),
@dob datetime,
@education Varchar(50),
@designation Varchar(50),
@name Varchar(50)
) AS
If Exists( SELECT username FROM member WHERE username = @username )
RETURN -1
ELSE
BEGIN
DECLARE @ID int -- new ID value holder
INSERT member (
username, password, dob, education, designation, name
) VALUES (
@username, @password, @dob, @education, @designation, @name
)
-- get the new identity column value
SET @id = @@IDENTITY
END
GO
-------------------------------
I am using classic asp to add records in this way -
sql = "add_member " & "'" & request.form("username") & "'" & "," & "'" & request.form("password") & "'" & "," & "'2/2/2'" & "," & request.form("education") & "," & request.form("designation") & "," & "'" & request.form("name") & "'"
set rsAdd = Server.CreateObject("ADODB.Recordset")
rsAdd.Open sql, con
Its adding new record successfully But I am not able to read id of newly added record.
Plzzzzzzz help
|
|
|
|
|
That's because you aren't returning it. You set @ID, but you need to either set an output parameter or select @ID to return it to your code.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
How to return and read in asp please explain in detail
Thanks in advance
|
|
|
|
|
You can either use an OUTPUT parameter in your query (search SQL Help for OUTPUT PARAMETER) or simply do a select and return the value in a recordset just like any other select statement does. An output parameter is more efficient.
To be honest, its so long since I used ADODB that I can't remember the syntax for retriving output parameters, but I do remeber you have to close the recordset first, strange as it seems.
Hopefully this will give you some pointers to enable you to resolve your problem after a little work on Google.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Add this as you last line.
Select @ID as ID
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Then How to read this value in asp
|
|
|
|
|
The resilt can be used as either executescalar directly to a varaible or as a dataset/table using .fill.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi dear,
I have one problem so u please solve that.
i am using sql server 2000.
In my working time sudennly sql server service manager is stopped,then i tried to start the sql server service manager,but it can't start...how to solve this problem...
please help me.
thanks in advance...
modified on Thursday, October 23, 2008 5:45 AM
|
|
|
|
|
Have you looked in task manager to see if its really gone? You may have to kill the process. Failing that, how about a reboot?
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Hi...
can anyone please tell me "What are the various debug visualizers in visual studio ?"
thanks
deep.
|
|
|
|
|
Text Visualizer, XML Visualizer, HTML Visualizer
|
|
|
|
|
I have a problem when rollback a transaction. I create a stored procedure as follow:
CREATE PROCEDURE [dbo].[sp_test] AS
begin transaction
declare @Res int
select * into abc from sysusers
delete from abc123 --an error is raised cause there is no abc123 table
Set @Res = @@Error
if @Res <> 0
Rollback transaction
else
Commit transaction
When I execute this stored procedure from Querry Analyzer:
Exec sp_test
It shows an error message:
Invalid object name 'abc123'.
Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 0, current count = 1.
The problem here is that: when a statement makes error (select,delete, insert), SQL Server 2000 stop executing other statement. So, the rollback transaction statement has no meaning.
Please help me to solve this problem. All I want is to rollback a stored procedure when never there is an error.
Thanks.
adfafafa
|
|
|
|
|
If there is no table abc123 then the proc will not compile so you are not getting a data error you are getting a syntax error in your code.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I create this proc in SQL Server 2000 and I think this proc will be compiled because there is no syntax error (I have checked syntax error after creating). Instead, it will cause run-time error because there is no abc123 table in the data base.
The problem is SQL Server 2000 stop executing other statement when it gets an error in select,delete,insert or update statement.
I've tried to use:
SET XACT_ABORT ON
to rollback other statements in the transaction but it still making error cause: ROLLBACK or COMMIT are not executed after BEGIN TRAN.
Please run my proc then help me to solve this problem.
Thank you very much.
CREATE PROCEDURE [dbo].[sp_test] AS
SET XACT_ABORT ON
DECLARE @Res int
begin transaction
select * into abc from sysusers
delete from abc123
Set @Res = @@ERROR
if @Res <> 0
ROLLBACK TRANSACTION
else
COMMIT TRANSACTION
GO
adfafafa
|
|
|
|
|
I don't think you are going to get transaction processing to do what you want, you are using the wrong tool, you should check for the existence of the table before you attempt to process against that table.
[rant]
IMHO your design stinks, if there is a possibility that a table does not exist in the database I am betting your design is wrong.
Another thing - relying on transactions stink, this is a classic "programming by error", if there is no error then it worked and we can continue when you should validate the data before attempting to process it. Error traps/transaction are to trap faults they are not a tool to make your programming life easier, the only time you should get into an error trap is during development or there is an environment issue.
[/rant]
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I am using 'ADOX.Catalog' namespace and the following code to create a new MS Access database.
Private Function CreateAccessDatabase() As Boolean
'-------------------------------------------------------
'This method is called to create a new Access database
'Required: NewDBConnectionString
'-------------------------------------------------------
Dim ADOXCatalog As New ADOX.Catalog
Try
If Me.NewDBConnectionString.Trim.ToString.Length = 0 Then Throw New Exception("Connection string is not specified")
'Call create method to create a new database
ADOXCatalog.Create(Me.NewDBConnectionString.Trim.T oString)
Return True
Catch ex As Exception
Throw ex
Return False
Finally
If Not ADOXCatalog Is Nothing Then
ADOXCatalog = Nothing
End If
End Try
End Function
The moment it created database, it is also leaving a .ldb file in the same directory. I don't want that .ldb file. If I tried to delete the file forcedly, it is passing an exception "The file is being used....". All the connection strings are properly closed.
Can anyone help me to remove this .ldb file.
|
|
|
|
|
|
SELECT COLUMN_NAME FROM USER_TAB_COLUMNS WHERE TABLE_NAME = 'ONE_ROW_TABLE';
Will get me the column names, ok, when this table is meant to be a one-row table, how can I get the column names of that table that has a value of say '0'
Example:
ONE_ROW_TABLE
COL1 COL2 COL3 COL4 COL5
---- ---- ---- ---- ----
1 0 1 0 0
I want to see an output like:
COL1
COL3
Thank you guys!
All generalizations are wrong, including this one!
(\ /)
(O.o)
(> <)
<div class="ForumMod">modified on Wednesday, October 22, 2008 4:45 AM</div>
|
|
|
|
|
You can create a query using UNION to make it row based or a dynamic query using the case statement for a column based answer.
Need software developed? Offering C# development all over the United States, ERL GLOBAL, Inc is the only call you will have to make.
Happiness in intelligent people is the rarest thing I know. -- Ernest Hemingway
Most of this sig is for Google, not ego.
|
|
|
|
|
How??
All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)
|
|
|
|
|
What you could try:
- select everything from the table
- use PIVOT to 'turn' the results (make columns rows and vice versa)
- use the result as inline view in FROM section
- create a select around inline view and restrict rows based on values
so the keyword in this is PIVOT.
Hope this helps,
Mika
The need to optimize rises from a bad design.
My articles[ ^]
|
|
|
|
|
Dear Friend's
 i have an float value 2.796 and 2.792 i want it in two digit value when i use round keyword it give me output as 2.80 and 2.79 but i want it as 2.79 and 2.79 can it possible if yes please tell me how to do it in sql server 2005
i have use Round and STR keyword from sql for this but in vain
CODE
--USING STR
select STR(2.792,25,2) as ID
select STR(2.796,25,2) as ID
OUTPUT
2.79
2.80
--END
--USING ROUND
select round(2.792,2) as ID
select round(2.796,2) as ID
OUTPUT
2.790
2.800
--END
Sasmi
|
|
|
|
|
Actually, you're asking for this output!, if you dont want a decimal, then simply skip it! here
SELECT ROUND(2.792) FROM ....;
All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)
|
|
|
|
|
Actually i want last two digit i mean if i have value 2, 2.7312467 and 2.796 then the output should be 2.00, 2.73 and 2.79
thanks for the code but it's giving me error "The round function requires 2 to 3 arguments."
CODE
select round(2.792) as ID
select round(2.796) as ID
OUTPUT
Msg 189, Level 15, State 1, Line 7
The round function requires 2 to 3 arguments.
Msg 189, Level 15, State 1, Line 8
The round function requires 2 to 3 arguments.
Sasmi
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
