Search results for query: *

Hi, I have a nubie question. I want to store in an app variable my connection string. Sub Application_Start(ByVal sender As Object, ByVal e As EventArgs) Application("ConnStr") = "Data Source=dev2;uid=sa;pwd=dev2;database=cunet_db" End Sub Then in my public class on the...

Hi, I'm new to ASP.NET. I have a simple page with two controls (datagrid and dropdown box). The dropdown has a 4 digit year while the grid displays data depending on the year. When the dropdown selection changes, I need the selected year to fire. Here is the code I have but on the first...

Hi All, Have some basic questions about temp and table datatype. I've just started using the datatype in a Stored Procedure that is called from a web page, and it seems to be working fine but I have one nagging questions that need some clearification. Lets say two hits to the SP come in at...

Hi All, I'm trying to do something like this: Update ID_TBL set rights=rights + 'TMEPJMAINT1' where TMEPJMAINT where netid in ('vituja','leelil','howlro','schwsu','kerkel') But the rights=rights + is not working. I know this is easy but I've haven't done this type of coding in a while...

Hi, Any idea of what may be causing this other than the obvious. The file is not opened by anyone. Microsoft JET Database Engine error '80004005' The Microsoft Jet database engine cannot open the file '\\cu-master\depts\IT\Common\Helpstar\HSW.MDB'. It is already opened exclusively by...

Hi, I'm using Crystal report 7 and need a way to omit duplicate rows. This sounds easy but I can't seem to find a place to do this in crystal. Either on the Group or Record leave, how do I tell crystal I don't want duplicates of a certain field? It is throwing off an averaging function. Any...

Hi All, I need to check to see if the beginning of a new year is within this weekrange. If so then do something. I have a field (weekrange) that contains "12/29/2003 - 01/05/2004" (changes each week automatically). In the example above 01/01/2004 exists within this weekrange but I...

Hi All, In a continuation to understand triggers, this one listed below does not give me an error, it just doesn't fire. When the column APPROVED='Y' and WEEKRANGE which has '12/29/2003 - 01/05/2004' the variable DTE='01/01/2004' is within the WEEKRANGE, then fire (run the three SPs). Why...

Hi All, looking for some TSQL that will allow me to see if a date falls within a specific weekrange. I'm going to be using the code on a trigger and need an event to fire only on the first day of the new year. So if I have a field called weekrange containing "12/30/2002 -...

CREATE TRIGGER [YearEndProcessing_Mgr] ON [TimeSheet_MGR_TBL] FOR UPDATE AS Hi All, Still learning triggers. I have a table (timesheet_mgr_Tbl what holds all 7 rows for each employee. Each row has a date fields (mon - fri) for a given week. I want the trigger to fire when the APPROVED...

Hi All, I'm new to trigger coding. I'm looking to create a trigger that will fire a few stored procedures when certain conditions are met. If the columns COMPLETE='Y' and Weekrange like "01/01%" and emplid=@emplid on ORDERS_TBL are true then the following Stored procedures should...

Hi All, I have some ASP code (not dot net) that can take a while to run. Sometimes the web page times out. Can the VBScript code be placed as an object inside the IIS server and executed that way? Any help would be appricated. Thanks.

Hi All, Is there a SP on SQLServer 7 where I can find out what Login ID has rights to which tables/columns? I have a bunch of IDs setup by someone else and I need to know what rights do they have amoung all the tables. Any help would be appreciated. Thanks.

Hi all, Is there a way to disable just one item in a dropdown list? I am able to change the color of an element with the code below using style sheets but I've been searching unsucessfully to find how to disable an element. Any help would be appricated. Thanks. <style>option.Odd...

Hi All, I'm trying to interact with our exchange server from within a VB client program. The VB App needs to send a mass mailing to our internal staff. When a button it clicked on the app, it checks the SQL Database and determins who should get this email. My problem is I keep getting this...

Hi All, Can a DTS package be executed from a stored procedure? If so how would I go about writing the SP code to execute the package? Any help would be appreicated. Thanks.