Discussions

I've been asked to make a *quick* little web page to match people with their pets. You know... match the picture of a pet to the picture of a person kind of thing.

I can do the drag thing with ajax but how do I make the drop target that so I can check the results of the user selection?

As always, I'm not asking you to do my work... but do you have any tips?

cheong wrote:

Do you really need to do that in T-SQL?

Yes, it really has to be SQL.

cheong wrote:

I thought the errors can be retrieved in SqlException (if using .NET ) or Error collection of ADO Connection object. Both of them have those %d or so filled for you already.

You're right, ADO gets the *friendly* error messages from the DBCC OUTPUTBUFFER.

What I'm looking for is a way to parse the DBCC OUTPUTBUFFER (It's Hex and has a lot of stuff other than the message) using TSQL.

Call me crazy...

Rotem Kirshenbaum wrote:



You can get the message from dbo.master.sysmessages according to the error code you get from @@ERROR.

You're close but no cigar. sysmessages contains template messages but does not have the *actual* message. For example:

In sysmessages, error #1023 reads "Invalid parameter %d specified for %ls."

I need it to say something like "Invalid parameter @UserName specified for spGetUser."

Got any suggestions?

I need a way to catch a SQL error message (not the @@ERROR) for use with a calling procedure... Here's an example:

NOTE: I'm USING SQL2000 (not 2005)


DECLARE @RC int
DECLARE @TXID bigint
DECLARE @LogMode nvarchar(50)
DECLARE @ErrMsg nvarchar(1024)

SET @TXID = 1435                -- Transaction to processes
SET @LogMode = 'Verbose'   `-- Logging mode
SET @ErrMsg = NULL              -- Output Error Message


EXECUTE @RC = [PeopleXpress].[dbo].[prc_Task500_Terminate] @TXID, @LogMode, @ErrMsg OUTPUT

SET @ErrorCode = @@ERROR

Now I can check the @@ERROR object for an error number (or 0)


Here's my question, How do I get the actual error message that goes along with number in @ErrorCode.
     1. One answer is to look it up in sysmessages but that doesn't have the actual message, rather it is the template for the message that I desire.

    2. Another answer is to use DBCC OUTPUTBUFFER to get the error message, after all, this is where ADO.NET goes to get it's friendly sql error messages. The problem is that the DBCC OUTPUTBUFFER needs some post-processing before it can be considered *friendly* -- Do you know how to do this?


Any feed back would make me feel all warm and fuzzy inside. And the correct answer may push me over the cliff of happiness, where I can get some sleep.

Thanks you.



   

I got everything I needed from this site: http://silverlight.net/GetStarted/

Good luck

I have tried sooo many tools and sites but none meet my expectations.

I do like the social aspects of sites like del.icio.us but the tools to support it leave me wanting more...

I think tag clouds are a great idea but remember how Yahoo! used to look... I want something like that.

Come on Google, where are you on this?

W3bbo wrote:

Besides, everyone should be using IE7 Does anyone have the current market % figures?

The market figure that most interest me is the % of companies that have migrated to IE7 for their Intranet browser. For me and my business, I can't even consider IE7 for my products because soooo many companies are still on IE6 as their official browser.

What we really need is a light-weight version of IE that is easier to manage through group policy. It's been my experience that corporate IS groups resist upgrades because of the uncertainties surrounding additional features/capabilities (bloat) added with each release.

W3bbo wrote:

NOT Flexwiki, stay away.

...why must you use a .NET wiki? Because MediaWiki (the one that powers Wikipedia) is probably the best out there.

Got to use .NET because I'm not allowed to install PHP or any other server-side code engine.

Harlequin wrote:

...or tell him it's time to move to SharePoint 2007.

I've been telling him that SharePoint has grown up but something bad must have happened in his past with an early version because he will not even consider SharePoint for our portal.

We're using DotNetNuke...

I found this collection of .NET Wiki engines, but don't have time to download, install & evaluate.

http://csharp-source.net/open-source/wiki-engines


Any recommendations would be GREATLY appreciated!

Thanks