Navaneeth, Thanks. If I user rownum=1 order by version_no desc, this will give the very first row, but i want the rows with version_no = max(version_no) in every code,unit_id combination. If I have 3 rows with this combination, among the 3 rows i wanted to display the row which is having max(version_no). Kindly help me. Thanks. Regards, Sageetha

Hi Navaneeth, Thank you so much. I understood the rownum=1 will work when i do order by version_no desc. But in this case, order by is dynamic..that is user-given input. So whatever column user wish to come as order by he ll select that. Can u help me how in that case i have to use this query. Thanks lot really!!! Regards,

Hi Friends, I need help in the following query. SELECT A.BILL, A.BILLER, A.VERSION_NO, A.CODE, A.NAME,A.SEGMENT_CODE, A.COMMENT,B.BILL AS BILL, B.BILLER AS DW_BILLER, B.MCN AS DW_MCN, B.SO AS DW_SO, B.BG AS DW_BG, B.CODE AS DW_CODE, B.NAME AS DW_NAME,B.SEGMENT_CODE AS DW_SEGMENT_CODE FROM WEB_REF A, WEB_CUST B WHERE A.BILL=B.BILL AND A.BILLER=B.BILLER ORDER BY A.BILL The above query is working fine. and o/p like below: A3 3A 3 A3 3A 2 A3 3A 1 But now requirement is that, the table A consists VERSION_NO. For any combination that found for A.BILL=B.BILL AND A.BILLER=B.BILLER may have different VERSION_NO. Now I want to fetch only the row which is having max(version_no) for the A.BILL=B.BILL AND A.BILLER=B.BILLER the combination. I needs the o/p shd be A3 3A 3 Likewise for all the rows. Pls help me. Thanks in Advance. Regards,

Hi Friends, I need MCTS 070-528 Materials and dumps. Please help me to get the informations. Thanks and Regards, R. Sangeetha Priya.

Hi Friends, In my VB 6.0 application, I am using database connection in a module. But now i need to place the connection in .ini file so whenver there is a change in connection string i can change .ini file. So pls. help me how to create .ini file for db connection and also how to call that file from my application. Please help me. Thanks and Regards,

Hi, Thanks lot for your response. I ve gone through the site u suggested. If I disable my firewall, I can create a project, it is creating successfully. Just to test, I kept one command button, and written Hi inside the cmd and when I try to run the project, I am getting the following error. "Error while trying to run project: Unable to start debugging on the web server." Can you please suggest me some ideas for the above. I have to start coding...Its very urgent... Thanks in Advance, Regards,

Hi, Yes I have checked. It is running. Even I tried restarting it also.

Hi Thanks for your response. I tried in that way. But again I am getting the same error. Regards,

Hi, Thanks in Advance. I tried in the way as you said. But again I am getting the same error. Thans & Regards,

Hi, It is IIS 5.1

Hi, Thanks. I havent started coding. I am getting the above error, when I tried to open a New project. Regards

Hi Friends, I have installed Microsoft Visual Studio 2003 in my system, and I tried to open a new project, it is giving me the following error. IIS is installed in my system, it was installed before Visual Studio 2003 installed. Error: The Web server reported the following error when attempting to create or open the Web project located at the following URL: "http://localhost/WebApplication1'. A connection with the server could not be established. Please help me. Thanks in Advance, Regards,

Hi Bob, Thanks lot for ur help. Its working well. Regards,

Hi Friends, I am using SQL Server 2005. I am facing the following problem. I need to know how to apply if condition in query. I am having one table called Test1 with two fields c_name, average. CC 7 CC 6 CC 8 IGC 2 IGC 4 IGC 6 HC 4 HC 5 NM 9 NM 6 NC 2 NC 5 NC 9 JC 4 JC 3 JC 1 The above are the values in that table. Now I am using the following query to display the c_name, count(college) with average >5 group by c_name select c_name,count(c_name) as Total from test1 where average>5 group by c_name Result : CC 3 IGC 1 NC 1 NM 2 Based on my query I am getting the above result. In the above result the colleges HC and JC are not coming because it has average only less than 5. But for my case, I want to display the college name with the total as 0 if that college doesnt have average >5. I need to modify the above query to get the result like below. CC 3 IGC 1 NC 1 NM 2 HC 0 JC 0 Please help for this. Thanks in Advance, Regards,

Hi, I have a login page which takes the username and password and connects to the Oracle database. The login details are same as oracle db login details. If the user attempts 5 invalid logins to the application, the user id gets locked in both the application and the database. However, if the user is typing the same wrong invalid password consecutively for 5 times, the user id is not getting locked in the database. This means for the same wrong set of userid and password, the post back is not working. Can you please explain and give a solution? We are using ASP.NET 1.0 with VB.NET. We are not using any components to check validation. Just catching the error number doing things. Thanks in advance! Regards,

Hi, I have a login page which takes the username and password and connects to the Oracle database. The login details are same as oracle db login details. If the user attempts 5 invalid logins to the application, the user id gets locked in both the application and the database. However, if the user is typing the same wrong invalid password consecutively for 5 times, the user id is not getting locked in the database. This means for the same set of userid and password, the post back is not working. Can you please explain and give a solution? We are using ASP.NET 1.0 with VB.NET. Thanks in advance! Regards,

Hi, I have a login page which takes the username and password and connects to the Oracle database. The login details are same as oracle db login details. If the user attempts 5 invalid logins to the application, the user id gets locked in both the application and the database. However, if the user is typing the same wrong invalid password consecutively for 5 times, the user id is not getting locked in the database. This means for the same set of userid and password, the post back is not working. Can you please explain and give a solution? We are using ASP.NET 1.0 with VB.NET. Thanks in advance!

Hi Friends, I have devleoped one application in VB 6.0. Packaged it and try to installing in others system. But when i install in others system, for few of the systems the application is not installing and giving the following error message. Setup cannot continue because some system files are out of date on your system. Click OK if you would like setup to update these files for you now. You will need to restart Windows before you can run setup again. Click cnacel to exit setup without updating system files. Kindly help me for this issue. Application developed in Windows XP , professional Edition...The system where I am getting problem is also windows XP and some are Windows 2000.\ Thanks in Advance, Regards,

Hi Friends, I am using MaskEd control to get From Time and To Time. I have set the Mask property to "##:##" After given from time and to time , I need to find the difference between to time and from time... But it is not allowing since it is string...So can anyone pls..tell me..how can i do that... or how to convert string to integer..... Please Help. Thanks in Advance, Regards

Hi friends, In my application I am converting data from msflexgrid to rxcel by using the following code. Clipboard.Clear 'Clear the Clipboard With MSFlexGrid1 'Select Full Contents (You could also select partial content) .Col = 0 'From first column .Row = 0 'From first Row (header) .ColSel = .Cols - 1 'Select all columns .RowSel = .Rows - 1 'Select all rows Clipboard.SetText .Clip 'Send to Clipboard End With With xlApp.ActiveWorkbook.ActiveSheet .Range("C5").Select 'Select Cell A1 (will paste from here, to different cells) .Paste 'Paste clipboard contents End With ' This makes Excel visible xlApp.Visible = True But when the data is pasted in Excel sheet, there is some cells pasted wrongly it means some row is splited in two rows. Totally i have 11 columns, and no of rows will depends. for some row the last 3 column values are pasted in the next row 2,3,4 columns.The next rows is proceeding at next line from that row. Please can anyone help me out. Its very very urgent for me. Expecting your help. Thanks and Regards,