Problem in fetchimg data from SQL Srver 2000 via asp pages

Hi All,

I am using SQL Server-2000, VB 6.0 and ASP. When i fetched data from VB 6.0 using XML string, passed into ASP pages, it shows data more than onc time. Please anyboy can help me to find out what is the problem?

Please reply as soon as possible.


Thanks,
Rahul.

please send some code or error message!

Hi All,

There is no errors. Code works properly. but problem is that asp fetch data more than one time from databse.

example: Table: EmployeeMaster Fields EmpNo,EmpName, PhoneNo ) . Now I want data of Employee where EmpNo=E001. It retrieve data like this : (E001-XYZ-3215365323,E001-XYZ-3215365323).

This is the problem.

Thanks,
Rahul

if you use SQL then please send this code. Now, we can't say anything wise about you problem, at least i can't.
Are you using multiple inputfields with the same name?
Are you using forloops?

as leuvenaar said, can u post ur sql query and its output here?
also the type of the fields like which is text and which is number field(might save time in asking and posting later)!!