Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: BobRodes
  • Content: Threads
  • Order by date
  1. BobRodes

    After many years of ignorance, I have learned the meaning of "Wombat" as used here by some

    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...
  2. BobRodes

    Permissions problem executing stored procedure

    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...
  3. BobRodes

    How to vary the type of a List<T> method parameter at runtime?

    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...
  4. BobRodes

    Create a table with all permutations of two source tables

    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...
  5. BobRodes

    Our application stores image binary

    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"...
  6. BobRodes

    Cannot find the symmetric key 'master key', because it does not exist.

    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...
  7. BobRodes

    Canceling the focus change on the blur event

    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...
  8. BobRodes

    Having trouble pulling javascript into separate file from htm

    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...
  9. BobRodes

    Another &quot;VB6 is a toy&quot; comment from a C++'er: responses invited

    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.
  10. BobRodes

    Concurrency problem, vb6/sql server

    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...
  11. BobRodes

    Suppressing showing return value on interactive stored proc execution

    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 =...
  12. BobRodes

    Problem using SendKeys, cmd.exe, Vista

    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...
  13. BobRodes

    Join (select... vs. where ... in (

    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...
  14. BobRodes

    having trouble with converting from datetime to varchar

    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...
  15. BobRodes

    OptionButton control array allows multiple selections

    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...
  16. BobRodes

    Need help optimizing large stored procedure

    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(*)...
  17. BobRodes

    Assigning constructor values in object arrays

    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[]...
  18. BobRodes

    Taxi problem

    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...
  19. BobRodes

    card problem

    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?
  20. BobRodes

    Problems with PHP mail function using localhost

    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...

Part and Inventory Search

Back
Top