Search results

Hi all, I'm trying to display a decimal data field however the trailing zeros for some reason get truncated. Ex. 100 would display 1, 150 would display 15. Please help. I'm coding in ASP. I even tried to round up the to 2 decimal places but still don't help FormatNumber(rs("quant"),2). Has...

I'm using ASP and SQL for my progress database. I want to display orders within the last 7 days (from today's date). I try the DateAdd function in VBScript but it errors: Unable to understand after DateAdd. I'm not sure if Progress recognizes this DateAdd function or is there something wrong...

Hi all, I'm trying to display a decimal data field however the trailing zeros for some reason get truncated. Ex. 100 would display 1, 150 would display 15. Please help. I'm coding in ASP. Thanks in advance!

Hello, I am using Progress 9.1C Database and Merant 3.60 Progress SQL92 for my ASP Pages. I am trying to issue a select statement with a Date condition: CustNum=Request.QueryString("custnum_form") mydate=Request.QueryString("date_form") ... ... str="SELECT * FROM pennaux Where...

Hi all, I'm trying to display a decimal data field however the trailing zeros for some reason get truncated. Ex. 100 would display 1, 150 would display 15. Please help. I'm coding in ASP. Thanks in advance!

I have a query that returns the order history of a customer based on their search catagory either by the item number or its description and customer number. There's an optional checkbox, if checked, will return the order history of that particular customer AND all the order history that belongs...

I'm trying to display a decimal field. For some reason the trailing zeros get deleted for all numbers with trailing zeros. For example 100 would be displayed as "1", 250 would be "25", 1230 would be "123", etc... Does anyone know what's the problem? I'm using Progress V 9.2 and ODBC Link to...

I'm writing sql statement and I need to convert decimal field into integer field. Please suggest me which convert function supported by Progress. I am using progress v9.2. Thank you.

I'm trying to display a decimal field. For some reason the trailing zeros get deleted for all numbers with trailing zeros. For example 100 would be displayed as "1", 250 would be "25", 1230 would be "123", etc... Does anyone know what's the problem? I'm using Progress V 9.2 and ODBC Link to...

Hello everyone, I'm having trouble displaying an array field, qty\-ordered[1]. I added a backslash (\) before the hyphen (-) because that's the rule when you have a hyphen in a field name. I put brackets in array 1 and it works fine in my sql select statement. But when I tried to display the...

Can someone please help me.. I have my asp pages and configured my ODBC link & DSN to connect to the database. Everything works fine in my pc.. now I need to transfer my asp pages on a SQLServer.. do I need to move the Progress db to the SQLServer also or can I just set the ODBC DSN to point to...

I'm query from 2 tables that have the same field names. How can I distinguish one from another when I do Response.Write?? I can't do Response.Write rs("table1.description")... and I tried str="SELECT DISTINCT table1.description as des1, table2.description des2 from mydb.table1...

Does anyone know of a good SQL for Progress Database book?? Please let me know! thanks!

Hi Andy, I'm not sure why the code is not displayed.. I'm sending as an attachment.

Hi Andy, I'm including my program instead of partial codes so you can see it more clear. In this program the user enters an item number. The program will search and display this item's order date and order number. I'm not sure about how to define the number data type. Do I have to define it...

test

Hello Andrew, Thank you for your reply. I already got the Progress DB connection working. But I'm still having some other problems I hope you can help me. I'm querying from a Progress DB, selecting the the items that the customer had ordered (including the item#, date ordered, price, etc...)...

Hi all! I'm completely new to progress db. Can someone help me on the codes how to connect to a progress database? Can I write asp codes: set cn=Server.CreateObject("ADODB.connection") set rs=Server.CreateObject("ADODB.Recordset") cn.Open "DSN=database" str="SELECT * FROM table1 " I...