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 John Tel 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: *

  • Users: bzeng
  • Content: Threads
  • Order by date
  1. bzeng

    recordcount return -1

    Hi, I have a very strange problem with recordcount return -1. DB Server : SQL Server 2000 Language: ASP(VB) '------ Code Start ------------- sql1="select * from [Mapping]" rs1.open sql1,conn, 3,3,1 response.write rs1.recordcount However if I change to a different table '------ Code Start...
  2. bzeng

    Can't extract Year, Month, Day out of a date

    Hi, due to the different local setting (Date setting) around the world I have to manually create a standard date format for our online database system.(ASP) We prefer to use YYYY/MM/DD. But the hosting server is MM/DD/YYYY. It works fine if I just want to print out the date...
  3. bzeng

    Can't extract Year, Month, Day out of a date

    Hi, due to the different local setting (Date setting) around the world I have to manually create a standard date format for our online database system.(ASP) We prefer to use YYYY/MM/DD. But the hosting server is MM/DD/YYYY. It works find if I just want to print out the date...
  4. bzeng

    error when use EXIT FOR

    Hi, I want to exit the FOR loop when the rs0.EOF is true, but I got an error message. Here is the code -------------------------------- ... do while not rs0.EOF %> <tr align=center> <%for i=1 to 4 if isNull(rs0(&quot;studentid&quot;))...
  5. bzeng

    no response / very slow when use &quot;NOT IN&quot;

    Hi, I am supporting a web based online management system with DB backend: MS Access2000 IIS5.0/ASP3.0 The major problem is that the advanced search page doesn't respond when the query contains &quot;<field1) NOT IN (select <field2> from...)&quot;. It seems the query runs very slow or...

Part and Inventory Search

Back
Top