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

    Remove repition of records

    I am using duplicate, What it does is removes the repeating records but in some cases it ignores certain records and I am not able to find which records it is missing as the results are huge. It affects the total amount which I am calculating. How do I go about it. Thanks
  2. sandyas

    Remove repition of records

    I have a query which should return records irrespective of the field SHIP_METHOD_ID. The query is select "OePo_Item"."ITEM_ID" from "OePo_Item","OeShipMethod","ArClient","OePo_Header","ApVendor" where ("OePo_Item"."SHIP_METHOD_ID" = "OeShipMethod"."SHIP_METHOD_ID" or...
  3. sandyas

    To check date range

    It's working. I used the = instead of between.
  4. sandyas

    To check date range

    I have two dates(range) which is entered through ASP form in MM/DD/YYYY format. The date in the table is stored as YYYYMMDD. I converted d1 and d2 to that form. It has to be checked with the date in the table. "Select date1 from table1 where date1 between '" & d1 & "' and '" & d2 & "'" I...
  5. sandyas

    Check for string and count

    I got it working
  6. sandyas

    Check for string and count

    I am using ASP and Pervasive SQL. I even tried with various string functions and it gives type mismatch.
  7. sandyas

    Check for string and count

    I basically print COC which is a field in the table and need to increment the value of n and r depending on the value of COC. I need to display the value of n and r at the end of the report. The values of the field COC are 'N' and 'R'. I need the display to be as follows: COC ---- N N R N N...
  8. sandyas

    Check for string and count

    I need to increment values in the IF statement like SELECT IF(SUBSTR(COC,1,1) = 'N', n=n+1, r=r+1) FROM tbl How do I go about it. Thanks
  9. sandyas

    Check for string and count

    Hi, I have to check for conditions in the select statement. The coulumn to be checked is string select.....................,substr(COC,1,1) as nr FROM ......................... How to use case statement while checking for substrings. The field COC contains either N or R. Thanks
  10. sandyas

    Print Date from table

    Thanks for helping, as this is my first program with ASP and Pervasive SQL
  11. sandyas

    Print Date from table

    I tried CONVERT(UNIORDER_QTY,CHAR(15)) and it gives a syntax error. Hope the syntax of Convert is right.
  12. sandyas

    Print Date from table

    I think one is a numeric and the other is character for it prints as PK/100. The tables are third party and they are read-only.
  13. sandyas

    Print Date from table

    I get an error "Incompatible types in expression" rs.open "select OePo_Item.ITEM_ID,OePo_Item.DESC_1,convert(left(OePo_Header.PO_DATE,4)" & '-'& "right(left(OePo_Header.PO_DATE,6),2)" & '-' & "right (OePo_Header.PO_DATE,2),SQL_CHAR),UNITORDER_QTY+'/'+UNITCODE_QTY from OePo_Item,OePo_Header...
  14. sandyas

    Print Date from table

    Hi, How do I concatenate two colums from a table with a '/'. select column1,column2 from table1 The column1 and column2 have to be printed as one column with a '/' in between. How do I do it with concat function or is there any other method. Thanks
  15. sandyas

    Print Date from table

    I got it right and is working. Thanks for the help
  16. sandyas

    Print Date from table

    Hi, I have a table in Pervasive SQL. I am accessing it from ASP and getting certain fileds. I want the date field to be printed in MM/DD/YYYY format, whereas in the database it is stored as YYYYMMDD. How do I get around it. set conn = server.createobject("adodb.connection") set rs =...
  17. sandyas

    Database Date field printing

    Hi, I have a table in Pervasive SQL. I am accessing it from ASP and getting certain fileds. I want the date field to be printed in MM/DD/YYYY format, whereas in the database it is stored as YYYYMMDD. How do I get around it. Select table1.colum1,table1.column2 from table1. <% while not...
  18. sandyas

    Error

    I myself fixed the error. Anyway thanks for the help
  19. sandyas

    Error

    I am trying to connect to Pervasive SQL where I have all the tables. My code is set conn = server.createobject("adodb.connection") set rs = Server.CreateObject("ADODB.recordset") ConnectionString = "DRIVER={Pervasive ODBC Client Interface};ServerDSN=Quantum;ServerName=ntserver;dbq=Quantum"...
  20. sandyas

    OLE DB Error

    I am trying to connect to Pervasive SQL where I have all the tables. My code is set conn = server.createobject("adodb.connection") set rs = Server.CreateObject("ADODB.recordset") ConnectionString = "DRIVER={Pervasive ODBC Client Interface};ServerDSN=Quantum;ServerName=ntserver;dbq=Quantum"...

Part and Inventory Search

Back
Top