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 bkrike 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: rajkum
  • Content: Threads
  • Order by date
  1. rajkum

    Select question

    Hi, I have a dataset which looks like this: ID Seqnum Seqnum2 Date =========================== 1 0 0 1/1/2005 1 1 0 1/2/2005 1 1 1 1/3/2005 2 0 0 2/1/2005 3 0 0 1/1/2005 3 1 0 1/2/2005 4 0 0 1/2/2005...
  2. rajkum

    SELECT question

    Hi, Table ---------------- Fld1 Fld2 ---------------- JOHN 2 JACK 1 PETER 2 JOHN 13 --------------- How do I query to return all the Names in Fld1 where Fld2 is 2 AND 13. I do not want to list PETER. Thanks in advance.
  3. rajkum

    Database Connection from ASP

    Hi, All of a sudden I get this message today when I try to access ASP pages with DB connections. [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. I have been running the pages for the past one year and it was working fine. I can access the SQL server...
  4. rajkum

    Display problem

    Hi, The HTML below works fine in IE and safari but NOT in Netscape. Netscape does not hide the scrolling panel of the Select box. Is there any way i can hide it? I am using Netscape 6.2.1. Thanks in advance. <html> <head> <title> TITLE </title> <script language="JavaScript">...
  5. rajkum

    JOIN Problem

    Hi, I am not being able to figure out how to SQL my requirement. Any help would be greatly appreciated. Table 1: -------- codeID -PK codeNum -PK title dept_cd status_cd --------- Table 2:(History of Table 1) Note : CodeNum in Table 1 could change. It is when this change occurs...
  6. rajkum

    DTS FROM ASP

    Hi, When I try executing DTS package FROM ASP I received this error : Executing DTS_PACKG_1 from server_name 1 Step [DTSStep_DTSDataDrivenQueryTask_1] failed Task "Data Driven Query Task: UPDATE TABLE ..." Package [DTS_PACKG_1] failed Done The code I am using is as below ...
  7. rajkum

    DTS - UPDATE Record

    Hi, REQUIREMENT : 1. Regularly update DATA FROM Database (DB1) to Database (DB2) say FROM TABLE1 to TABLE2 2. IF row in TABLE1 is new INSERT in TABLE2 3. IF row in TABLE2 says the row has to be overwritten (SQL UPDATED) THEN UPDATE the row. (TABLE2 has a flag which says whether the row has...
  8. rajkum

    Implementing AND / OR Relationship

    Hi, Table 1: destinationCodeTable { destinationID destinationNm } Table 2: personHoliday { personID destination??????? } Example data set of destinationCodeTable is as follows: Bahamas Ontario Tokyo Angkor Vat . . The destination in personHoliday could be defined as Bahamas AND(Tokyo OR...
  9. rajkum

    IFRAME - getElementByID error!!

    Please Help!! Everytime I access the page below .. i get the following error : "'document.getElementById(...).contentWindow.document.body' is null or not an object" The page is as below: Its simple .. I am just trying to put some stuff in an editable iframe. <HTML> <HEAD>...
  10. rajkum

    code tables

    Hi, Is it good to have many code tables in a database? Background: I have a form which has many dropdowns. I have created a table each for each dropdowns on the web form. (It is on the form of item_cd and item_nm) I have a main table where I insert all the codes and some extra info which is...
  11. rajkum

    bulk insert

    Hi, I have a requirement where I have to load a set of data from datawarehouse into a database server. How do i ensure the next time i update that i am inserting only new records. Thanks, Raj
  12. rajkum

    bulk insert

    Hi, I have a requirement where I have to load a set of data from datawarehouse into a database server. How do i ensure the next time i update that i am inserting only new records. Thanks, Raj
  13. rajkum

    automatic Email

    Hi, I have a requirement where i have to look up the data for expiry dates and if a certain product is due to expire in 1 month the system has to shoot out an email with the details of the product. Is there anyway I can do it? I am using SQL server,ASP. Thanks, Raj
  14. rajkum

    Email from SQL server - Automatic

    Hi, I have a requirement where i have to look up the data for expiry dates and if a certain product is due to expire in 1 month the system has to shoot out an email with the details of the product. Is there anyway I can do it in SQL server? Thanks, Raj
  15. rajkum

    show generated Autonumber on successfull Insert!

    Hi, I have a Stored Proc for inserting Data from the Web into a table with a Identity column. i want to show back the autoNumber created to the User on successfull insert. Please help!! Thanks, Raj
  16. rajkum

    length of string variable is &gt; 8000 characters

    Hi I have a string variable in Stored Proc which is greater than 8000 characters. how do i deal with it? It is a SQL statement i am generating dynamically for a report. Thanks, Raj
  17. rajkum

    Report - Stored Procedure

    Hi, I have a requirement to create a report from a table which looks as under: id subject type sex id is the id of a person. subject is the subject the person is interested (subject1,subject2,subject3..) type is the subject type (type1,type2,type3,type4) sex is either male or female...
  18. rajkum

    Stored Procedure - returning recordset and its recordCount

    Hi, I have a stored procedure which returns a recordset. I am using ASP to list the data from recordet and it works pretty fine. The part which bothers me is 1)..i cannot get the recordcount of the recordset. 2)..I am not being able to use value from the return parameter until I use the...
  19. rajkum

    error while fetching recordset using stored proc in ASP

    Hi, I am trying to fetch a RecordSet in ASP using Stored Procedure. I have been using Stored procedure for returning single fields and Insert / Update and it works fine..but here I am stuck!! Please help. The error message I get is as below: --------------------------------------- Microsoft...
  20. rajkum

    problem fetching a recSet thru Stored procedure (in ASP)

    Hi, I am trying to fetch a RecordSet in ASP using Stored Procedure. I have been using Stored procedure for returning single fields and Insert / Update and it works fine..but here I am stuck!! Please help. The error message I get is as below: --------------------------------------- Microsoft...

Part and Inventory Search

Back
Top