Search results for query: *

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

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

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

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

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

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

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

Hi, I have created a crystal report. Now I need to generate that report by filtering it. The filteration values are entered in a VB form like ID and a date range. How do I pass these values so that the records needed are printed and not all of them. My VB code is as follow: Private Sub...

Hi, I am creating reports over the intranet using ASP and am a beginner with it. 1. Created a form to get data using ASP 2. Created an Asp to call the dll file when all the data are validated and would return the result. I get the following error when I place a call to the dll file. Error...