Search results for query: *

I'm trying to write a stored procedure which can identify which database it has been called from. Using the following example: USE database1 GO CREATE PROC dbo.uspPrintDbName AS PRINT DB_NAME() if I call it from a different database: USE database2 GO EXEC database1.dbo.uspPrintDbName it...

I am trying to set up a function which takes a string containing a set of conditions and returns a bit to indicate whether the condition is true or false. Basically, I need something similar to the Javascript eval() function. eg. INPUTSTRING='((5 = 5) AND (40 = 40))', RESULT=1...

Morning All. I've set up a table which self joins to form a heirarchical structure. Simplified example of the table: CREATE TABLE Assets ( AssetID int IDENTITY(0,1) PRIMARY KEY CLUSTERED, ParentAssetID int NOT NULL DEFAULT(0), CONSTRAINT fk_Assets_ParentAssetID_AssetID FOREIGN...

I have written a script which downloads some data from an intranet site (using XMLHTTP), does a bit of analysis and then uploads the results to a database table (using ADODB). This combination is causing the VirusScan on-access scanner to flag it as a VBS/Psyme virus. Has anyone experienced this...

Hi All, I need to find a way to reference the childNodes of a form by their id/name. I have pasted an example of what i am trying to do. I can reference the node by number (eg. document.f1.childNodes[1]) but not by name. document.getElementById("d2") will not work because there is more than one...

Hi All, I've written a simple drawing program which, so far, consists of drawing shapes of various colours using the usual pen drag type method and then filling in these shapes using the recursive function below. Filling in small shapes is not a problem, but filling in bigger shapes causes a...

Hello all, I am trying to find an api function that will allow me to loop through the system tray icons and give me info on them (ie. nid, window hwnd, tooltip,etc..) Ultimately I want to be able to remove an icon based on this info. I know how to use the Shell_NotifyIcon function but need to...

Hi people, I have set up some VBA script in Outlook which moves any read receipts to a folder in my 'Personal Folders' box and sets the UnRead property to False. The thing is although the mail is marked as read the envelope icon in the system tray that says 'You have new unopened items.' does...