Search results for query: *

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??

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...

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...

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...

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...

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...

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...

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;))...

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...

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...

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...

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...

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...