Search results for query: *

Rather than being simply a colorful use of a certain Australian marsupial for an object reference as one may often find on certain of these forums, "WOMBAT" is also an apparently British acronym standing for "Waste Of Money, Brains And Time." One may thank Mr Charles Stross for letting the cat...

I have two stored procedures (actually several, but it boils down to this). I can execute both of them under my userid without problems. We're using a specific userid for running reports. With this userid, I can execute one of the procs and not the other, and they both appear to have the...

I have a generic method, so: public void Export<T>(List<T> exportList, string filePath, byte fileType) where T: class There are two possibilities for <T>: <Category> and <ProductSupplier>. Previous to this call, I have a method which uses reflection to get a List<T> object (at least, I think...

I'm kind of at a loss as to how to formulate my question. Suppose I have two tables, temp0 and temp1. Temp0 contains a set of keys, and temp1 another, so: Temp0 1 2 3 Temp1 a b c I'm trying to work out a select that would result in this in a new table: Temp2 key0 key1 1 a 1...

Our application stores image binary data in a table called Blob. I'm trying to update the Blob field, and running into the above error. Here's the code I'm using (C#): command.CommandText = @" UPDATE dbo.Blob SET Binary = @Binary WHERE BlobGuid = @BlobGuid"...

I'm working with a website that uses ASP.Net and WCF services to serve up data from a SQL Server database. In the code, I'm getting an error: I'm told that the workaround to this is to change the userid in web.config to sa (normal userid is rnd). I suspect that if we go down that road very...

I have some code that, when the user leaves an input box, checks for a valid date. If not, it sends an invalid date alert, wipes out the text, and resets the focus back to the box. Here's the code, after various simplifications: $('#startDate').on('blur', function (event) { if...

I haven't a lot of experience with javascript, Jquery, and html yet. I have an htm page with query and javascript on it. It works the way I want it to, but when I try to pull the code into another file and reference it from there, I just get a blank page. I tried a few tests. I created a...

From another forum: Are we going to take this kind of abuse lying down? :) An unforeseen consequence of the information revolution has been the exponential propagation of human error.

I have a table with two fields: hospitalID (int) PK and internalID (int) FK. The problem is to update the internalid with a new value, that is gotten by finding the first available integer (minimum unused integer). Feel free to say this itself is a bad idea and suggest another. So, I have...

One of my coworkers is running a stored proc from the SQL Server Management Studio (2005), by right clicking on it and selecting Execute Stored Procedure. The resulting query comes up like this: USE [MYDB] GO DECLARE @return_value int EXEC @return_value = [dbo].[BobTest1] @StartDate =...

I can't find anything on this one. I have the following code: Shell "C:\windows\system32\cmd.exe", vbMaximizedFocus SendKeys "cd \" SendKeys "{enter}" I'm using Vista 32 bit. Running this code opens a seemingly random number of instances of the command window, the lowest 45 and the highest...

I have two statements: select * from m2010 where icd9code in ( select distinct icd9code from m2010 group by icd9code having count(icd9code) > 1) and select * from m2010 m join (select distinct icd9code from m2010 group by icd9code having count(icd9code) > 1) d on m.icd9code = d.icd9codeThese...

I'm trying to convert a date format to a string, so I can strip off the characters I want. I'm having problems. I have these three statements: select top 1 effdate from temp0 select top 1 convert(datetime, effdate, 112) from temp0 select top 1 cast(convert(datetime, effdate, 112) as...

I've never run into this before. I've written an application with two option buttons in a control array. The first selection is selected by default. In the compiled version of the application, if the user selects the second button and then reselects the first one, the second one stays...

We have a stored proc that runs VERY slowly, and upon examination it was clear even to me that many sins have been committed in the design here. I've been asked to suggest what I would do, and wanted to avail myself of everyone's experience. So, I have a few questions: 1. Does Count(*)...

I have a class that assigns a string property in the constructor, thus: public class Test { public string StrProp {get; set;} public Test(string myString) { StrProp = myString; } } I'm attempting to create an array of this class. I first attempted it this way: Test[]...

A taxi was involved in a hit and run accident at night. Two taxi companies, the green and the blue, operate in the city. 85% percent of the taxis are green and 15% are blue. A witness identified the taxi as blue.The witness identifies the correct color 80% of the time and fails 20% of the...

You have three cards in a hat. One is white on both sides, one is red on both sides, the third is white on one side and red on the other. You pull a card out of the hat and lay it down. The face is white. What are the chances that the other side of the card is also white?

I'm attempting to set up test email from my development machine. I have code that uses the mail function and works elsewhere. I don't want to use my ISP's SMTP provider unless I have to. I'm getting this error: PHP Warning: mail() [function.mail]: Failed to connect to mailserver at...