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 Rhinorhino 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: *

  1. karthik555

    Class_initialize is not getting fired

    Hi! I use a VB DLL in which I have written code to form DB Connection String (read from the registry) This logic is written in a subroutine (public) in a modlue of the project. I call this subroutine from Class_Initialize of the Class File. When instantiate this DLL in another project and...
  2. karthik555

    Unterminated String Constant

    Tarwn! You were spot on! There was some junk character in the data (in DBMS). I found out it is ascii(10). (God knows what!). Once I use Replaced it with "", now it works fine. Thanks a ton! Regards Karthik
  3. karthik555

    Unterminated String Constant

    Hello! I have a server side array (VBScript). I pass data from this Server side array to a client side array <SCRIPT LANGUAGE=vbscript> <% For intRow = 1 to Ubound(arrMlt,1) For intCol = 1 to UBound(arrMlt,2) %> arrCMlt(<%=intRow%>, <%=intCol%>) = "<%=arrMlt(intRow, intCol)%>" <% Next...
  4. karthik555

    Opening an Excel file in the webserver

    Exactly. The user should be able to see the XLS file without having to type in the UID. In any case even if click cancel on that dialog it opens the file.
  5. karthik555

    Opening an Excel file in the webserver

    Hello! I am facing a problem in opening an XLS file available in the webserver. Let us say I have File1.XLS in server SERV1 in the following Virtual Path. http://SERV1/MyPath/File1.XLS. I have the following piece of code in my ASP Page (Client side javascript) var Server_Address =...
  6. karthik555

    Stacked Bar Chart - Any III Party control available?

    Hello! We have to display the contents in a webpage. When the user selects a value from a multiselect list box a Stacked Bar Chart should display the contents in a portion of a page. (May be I can use a IFRAME) The Chart will display Dates in X Axis and Values in Y Axis. Each date will have...
  7. karthik555

    Query to trace history of change of data in a table

    ...OldAsset, CurrAsset, Status, InpSrlNo FROM #Input WHERE InpSrlNo = @InpSrlNo SELECT @StackIdent = @@Identity -- SELECT '#St after ins',* FROM #Stack SELECT @InpSrlNo_Tmp = @InpSrlNo SELECT TOP 1 @InpSrlNo = InpSrlNo FROM #Input I WHERE I.CurrAsset = (SELECT OldAsset FROM...
  8. karthik555

    Query to trace history of change of data in a table

    Thanks for response... If you see the differece between 11 and 12 it is the status.. Former is cancelled (CAN) and the later is confirmed (CON).. Same is true of 14 and 15. All the four records need to be shown in the output in the same order (apart from other records). Thanks again for your...
  9. karthik555

    Query to trace history of change of data in a table

    There is only an identity column which serves the purpose of Primary key(system key). There is no user key. WHich means A1 can become A2, A2 can become A3 and A3 can become A1 and the whole cycle can repeat again. This adds to the complexity. If the user gives A3 as input I have to retrieve...
  10. karthik555

    Query to trace history of change of data in a table

    Hi! I have data as below CREATE TABLE #Input (OldAsset Char(20), CurrAsset Char(20), Status Char(3), InpSrlNo INT Identity(1,1), GUID uniqueidentifier, InpProcstat char(1)) DECLARE @GUID Uniqueidentifier SELECT @GUID = NewID() INSERT INTO #Input (OldAsset, CurrAsset, Status, GUID...
  11. karthik555

    Script Generation without SET QUOTED_IDENTIFIER OFF

    Thanks for that info. It was an eye opener! Your are right. If I supress them some 90% of my SPs may not work. Thanks again. Karthik
  12. karthik555

    Script Generation without SET QUOTED_IDENTIFIER OFF

    Your solution is for replacing the text in the script which is already generated. I want to know if there is any setting in Enterprise Manager to supress this. Regards Karthik
  13. karthik555

    Script Generation without SET QUOTED_IDENTIFIER OFF

    Hello! I am generating script for all the Stored Procedures in the DB. I have the following text before each SP script. SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO How do I supress this? Thanks in adavnce.
  14. karthik555

    Automating Deployment of ActiveX DLLs

    Hello! I have an application that has DLLs, ActiveX DLLs and SQL Script files as deliverables. I have to write a deployer application in VB to install these deliverables in the host computer. I can write code to deploy SQL Script files and DLLs. But I need to create Package for the ActiveX...
  15. karthik555

    Any way to find the number of DML statements in a SP

    Hello! I have a requirement to find the number of DML statements (SELECT, UPDATE, DELETE) in all Stored Procedures in a database. Is there any way to get it quickly. Thanks in advance. Karthik
  16. karthik555

    Recompiling the SP solves the problem. But how?

    Thanks Rob.... There are over 40000 SPs in our DB. Not sure if I am going to add WITH RECOMPILE in each one of them. I will try with UPDATE STATISTICS.... But since this problem is not simulatable, I won't know the result immediately. Any way, thank you so much for giving these...
  17. karthik555

    Recompiling the SP solves the problem. But how?

    Hello, I have been encountering this problem. But on an increased frequency off late. A Stored Procedure which is not giving desired output. Say returns a wrong row or value in the recordset being returned. When we take the text of the SP from the same database, using SP_Helptext and...
  18. karthik555

    ADO - Connect using DSN without UID/PWD

    Thanks... Is there any reason why it should not be that way... We still provide UID/PWD while creating a DSN. Just want to know. Regards Karthik
  19. karthik555

    ADO - Connect using DSN without UID/PWD

    If any one has any idea to do this, will be helpful.. 1. I am trying to connect to my SQL Server database using a DSN. 2. I have given UID/PWD (SQL Authentication) in my DSN and have given a default DB. 3. I am trying to execute the following code in VB <CODE> Dim oADO As ADODB.Connection...
  20. karthik555

    JOIN SYNTAX - DIfference between SQL-92 and Legacy Syntax

    ...Documentation says, "SQL Server supports both the SQL-92 outer join syntax and a legacy syntax for specifying outer joins based on using the *= and =* operators in the WHERE clause. The SQL-92 syntax is recommended because it is not subject to the ambiguity that sometimes results from the...

Part and Inventory Search

Back
Top