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 Rhinorhino 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
  • Order by date
  1. bzeng

    recordcount return -1

    Interesting.... I went to the table - Mapping and set MappingID as the PK. THen it works. So, the recordcount only works for those tables which contain PK? (I have checked all those tables return -1 are the tables which have no PK) What does record cout to do with PK??
  2. 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...
  3. bzeng

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

    Hi, tsuji: Thanks very much!! projectDate=split(projectDate,"/")(2) & "/" & _ split(projectDate,"/")(0) & "/" & _ split(projectDate,"/")(1) although I think there should be a simple command to do that. Like...
  4. bzeng

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

    Hi, Thanks all for your reply. I guess I need to provide more info regarding to my question. 1. The database is MS Access and the field where projectDate comes from is defined as "Date/Time". Therefore projectDate is not a string or number or anything else. It is defined in Access...
  5. 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...
  6. 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...
  7. bzeng

    error when use EXIT FOR

    hi, thanks for all the replies. I acutally figure out the problem: I move if isNull(rs0("studentid")) then bgcolor="white" notinclass=true else bgcolor="#FF9966" end if into the FOR loop and then it works! here is the...
  8. 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;))...
  9. bzeng

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

    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;)) then bgcolor=&quot;white&quot...
  10. bzeng

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

    Hi, Thanks very much again for the script SELECT * FROM Contact LEFT JOIN ContactProfile ON Contact.ContactID = ContactProfile.ContactID WHERE ContactProfile.ContactID is NULL It fixed all the problems I had in the system. Just out of curiosity what could have been the problem for the...
  11. bzeng

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

    Bingo! The following script respond in 1 sec. SELECT * FROM Contact LEFT JOIN ContactProfile ON Contact.ContactID = ContactProfile.ContactID WHERE ContactProfile.ContactID is NULL I have to go to the next steps --> fix the ASP page which were not responding. The sql on the ASP page is totally...
  12. bzeng

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

    Hi, Thanks for all the replies! I have tried the sql Select Distinct Contact.* From Contact INNER JOIN ContactProfile ON Contact.ContactID <> ContactProfile.ContactID directly on the database, it doesn't respond at all. (Maybe it takes even longer..) I have checked that the...
  13. 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