No error checking, no try/catch clauses, and the name of the extra differs between the put (mtext) and the get (abc). :rolleyes: How exactly are we supposed to help you? :confused:
"One man's wage rise is another man's price increase." - Harold Wilson
"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons
"You can easily judge the character of a man by how he treats those who can do nothing for him." - James D. Miles
Did you actually read the error message? getcname declares thrown exceptions, so you have to catch or declare them as thrown wherever you call it. That means you can't use getcname in a static initialiser, because there's no way to catch the exception.
Please refer to this http://www.codeproject.com/Messages/1278601/How-to-get-an-answer-to-your-question.aspx[^] for tips on how to ask a question. This is just an unformatted code dump that everyone will just ignore.
Why is common sense not common? Never argue with an idiot. They will drag you down to their level where they are an expert. Sometimes it takes a lot of work to be lazy Please stand in front of my pistol, smile and wait for the flash - JSOP 2012
Oh crap! It was ment too be an integer
Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch
tan873 wrote:
how to zip file with xp_cmdshell in sql server 2005
I suppose that depends on exactly what you mean. First step how would you do it in a command shell? Windows has the 'compact' command built in. Comand line options are documented in the help for that as well as at the following. http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/compact.mspx?mfr=true[^] If you want to use something besides 'compact' then you must explore the command line options for that tool. Once you know how to do it from a regular shell then you explore the options with the shell in sql server.