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 derfloh 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: vituja
  • Order by date
  1. vituja

    Using Application Varaibles correctly.

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

    Using Application Varaibles correctly.

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

    DropDownList

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

    Table Datatype vs local and global temp tables

    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).
  5. vituja

    Table Datatype vs local and global temp tables

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

    Table Datatype vs local and global temp tables

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

    sql server update statement with string concatination?

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

    sql server update statement with string concatination?

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

    sql server update statement with string concatination?

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

    sql server update statement with string concatination?

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

    Error opening MS Access from ASP

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

    Using DISTINCT with CrystalReports7

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

    Find if specific date exsit in a week range

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

    Trigger doesn't fire.

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

    Specfic Date exists in a weekrange

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

    Specfic Date exists in a weekrange

    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/' +...
  17. vituja

    Specfic Date exists in a weekrange

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

    Trigger Question

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

    Trigger Question

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

    Trigger Logic and SPs

    Excellent! It worked. Thanks for the great help

Part and Inventory Search

Back
Top