Hi!
I miss the stored procedures "sp_Accounts_GetCategoryDetails" on page 162 and "sp_Accounts_GetPermissionsInCategory" on page 163.

Can anyone supply the codes for the stored procedures so that I can create them in the database?

Thanx in advance!

I just answered this the other day. Please read the other messages before posting a question.

http://p2p.wrox.com/topic.asp?TOPIC_ID=32886

I did read your posting, but it didn't help me. I think that I did restore from the backup file. I still miss the stored procedures. If you have the code for the stored procedures I would be very thankful if you could post them here.

Ok, I did restore the database from the backup database file. So, if anyone has the time, please, please post the sql-scripts to the stored procedures that I'm missing!
Thanx!

There is evidently more people with the same problem as I have... http://p2p.wrox.com/archive/aspdotne...2002-09/10.asp
Can someone please poste these stored procedures:
sp_Accounts_DeleteUser
sp_Accounts_GetUsers
sp_Accounts_GetPermissionDetails
sp_Accounts_GetCategoryDetails
sp_Accounts_GetPermissionsInCategory

I think you should contact Wrox for this. You can try the Errata form: http://wiley.custhelp.com/cgi-bin/wi...nduser/ask.php or the Contact link at the top of this page.

They may be able to fix this somehow. I notice that some of the procedures in the database have names similar to those that are missing. I don't know the book very well, but could it be possible that just the names in the book are incorrect, and that you do have the procedures with a different name?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: The Bends by Radiohead (Track 2 from the album: The Bends) What's This?

Thanx for your reply.
I checked errdata at http://www.wrox.com/WileyCDA/WroxTit...ew_errata.html and I think it should be listed there in case of errors in the book. I will try the Errdata form.
If someone has the code for the stored procedures plase post them here.

You should pay more attention to detail. The stored procs are in the backup file, just as I said.

In the C# code download (6934download.zip), file "thephile-database-backup".

In the VB.NET code download (8163_code_v7.zip), file "thephile-database-backup".

If you don't believe me, please do a hex dump on this backup file and you'll see the code. Or better yet, just make sure you restore the backup file correctly and look in your database.

I am using the thephlie-database-backup file... The stored procedures are not there!

CREATE PROCEDURE sp_Accounts_DeleteUser
@UserID int
AS
     DECLARE @MemberID int

     SELECT @MemberID = MemberId FROM Forums_Members WHERE UserId = @UserId

     IF @MemberID IS NOT NULL
     BEGIN
          DELETE Forums_Members WHERE UserId = @UserId
          DELETE Forums_Topics WHERE MemberId = @MemberId
          DELETE Forums_Replies WHERE MemberId = @MemberId
     END

     DELETE Accounts_UserRoles WHERE UserId = @UserId
     DELETE ACcounts_Users WHERE UserId = @UserId
GO




Charul Shukla