Recent content by oppcos

Well.. because.. 'cause you're making it too easy without a loop!

Well, upon having tried that in a number of variations I was unable to get it to work. I think I'm going to have to go figure out cursors even though I have tried to avoid them because I heard they are bad for performance. If you still think there's a way to do it with WHILE @@ROWCOUNT > 0 I'd...

Great, I have wide gaps in my knowledge and @@rowncount was one of them. :-) Thanks!

Hi, We had someone that was big on "object oriented" table design where there is an "X" table that basically lets you dynamically add columns to a table. So you have a table like this: FOREIGN_KEY FIELD_NAME FIELD_VALUE You then do endless left joins against the same table to get all the...

Wow, figures someone named Einstein would make it look easy. ;-) That's perfect, thanks!

Yikes, sounds somewhat painful! I guess it is as much as I expect though..

Is there a way to measure text in javascript? I want to determine if the text has overflowed the container and then perform an operation based upon that eventuality. The text is added to the container programatically so I could do the test after that is done. I was thinking the only way would...

Great, thanks a lot guys. :)

Hi, We have a legacy app that was originally built on site but, of course, the source code disappeared long ago. Well wouldn't you know it but the sa username and password is hard coded into that app and it isn't very "strong". The SQL database is isolated however, so we aren't too worried...

Cool, I didn't realize a query like that would relate each row with what must be a new select for each in the where clause by doing the co_num = t.co_num. Thanks for that great example.

Hi, I have a table with company #, items, and dates. An example might be: co_num | items | dates -------------------------- 1 abc 2007-04-06 1 xyz 2007-04-06 1 ghi 2006-12-18 ... 2 jkl 2007-01-01 2 mno 2006-12-18...

I have an Outlook .NET add-in that creates a toolbar and can receive the HWND of that toolbar. Outlook, of course, is unmanaged code. Is there a way for me to add a .NET control to that HWND using some sort of Win32 interop? I'm having trouble knowing where to start looking... Thanks for any...

Hi, I'm tring to access my public folders data from MSSQL Server so that I can do joins against the databases other data. I started with using the Exchange OLE DB Provider but got the error: Could not locate registry entry for OLE DB provider 'exoledb.DataSource.1' After a little research I...

PHP 5 as ISAPI DLL (seems to be working just fine otherwise). Primarily it improves performance for people making lots of requests to the server in a row. It just keeps the TCP session alive instead of closing it, so no caches or anything are involved. When the client requests Connection...

Hi, I'm running IIS 6 and have persistent HTTP connections turned on as the default. All page requests to the server do persist just fine except for PHP ones. I've turned output buffering on in PHP.ini in case that had anything to do with it, but so far no effect. Any other ideas on what I...