Search results for query: *

Thanks for the reply RTomes. So it is more common to put the connect string into the web.config? I am an asp3 programmer. I'm still learning the ropes in ASP.NET. So in your second example <appSettings>, that goes into the config file? Then when I need to use it, how do I access the...

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

I agree with SQLSister. We use asp (version 3) extensively as well. All if not most of our SQL calls are made through Stored Procedures. The only exception is when a simple select statement (select * from tbl order by).

Thanks SQLSister for the info. We had instances when a pure temp table was used (##TEMP_TBL) and there were times when two or more users acessed the SP which caused the temp table to exhibit blank rows. Temp tables in SQL2000 do not seem to be created in an isolated session. Of course I...

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

That was it. Thanks Chopstik. The size of the field was too small. Thanks also to SQLSister!

Insteresting. That could be the case. So the syntax is fine then?

The sql statement, Update ID_TBL set rights=rights + 'TMEPJMAINT1' where netid in ('vituja','leelil','howlro','schwsu','kerkel') returned an error: Server: Msg 8152, Level 16, State 9, Line 1 String or binary data would be truncated. The statement has been terminated.

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 &quot;12/29/2003 - 01/05/2004&quot; (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...

Thank you for the help. I didn't know that. Is there a way to test a trigger. I can not find any error when the trigger is fired except for the data not be inserted. How can I debug a trigger: CREATE TRIGGER [YearEndProcessing_Mgr] ON [TimeSheet_MGR_TBL] FOR UPDATE AS DECLARE @netid...

I tried this trigger but get an error when the trigger fires saying 'Invalid object name UPDATED': CREATE TRIGGER [YearEndProcessing_Mgr] ON [TimeSheet_MGR_TBL] FOR UPDATE AS DECLARE @netid varchar(6) select @netid = netid from updated DECLARE @DTE varchar(10) select @DTE ='01/01/' +...

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 &quot;12/30/2002 -...

Maybe my whole understanding of triggers need review. I tried the following code CREATE TRIGGER javtest2 ON [TimeSheet_Mgr_tbl] FOR INSERT AS BEGIN if (select date1 from inserted)='01/01/2004' exec YearEnd_Accrual_Personal '01/01/2004','leelil' END but when I insert a new row with a...

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

Excellent! It worked. Thanks for the great help