Recent content by longmatch

Dear experts: I am planning to design a website for student to take their tests online. The requirements are: 1.The questions, answers and relative media files should be stored in database in order for them to be able to be modified. 2.The questions should be randomly selected. Each...

I am a novice for sql server 2000. Right now I have a problem need to be solved. I wrote a trigger to copy the inserted records into a new table. But there is a field need to save as a different value into the new table. In this case, I want to save the M and F as sex value instead of Male and...

Hi George: Just as you said, I used the value property. Right now it works. thanks longmatch

I can put data back to all the fields of form from the backend database except for Textarea field. Not sure whether there is any difference between textarea with other controls. Not sure how to make it work. thanks in advance Haijun

Thanks for everybody's input. If my understanding is right, cookies and sessions can only be used in web pages. How can I get Windows login information such as username and password to allow users to login our intranet without login again. Another questions should be how to integrate windows...

I have developed a website for data collection and presentation. The users have to login three time before reach my pages. The first login is the computer login, which allows users to use the computer, then user need to provide login information for our intranet, actually the user name and...

Actually I have a student table, and rotation table as well. The student table has all the information about the resident such as name, id number, grade. the rotation table has the rotation name and their duration. I need to store all the rotation information for three years for a given...

Dear rac2: My database's structure is ID; PK StudentID Grade (first, second or third year) rotationNO rotationname rotationLength Different students may have different number of rotations (or records in database), which depend upon the Rotationlength. some have 15 rotations, others may have...

I have a form used to save multiple records instead of one when it is submitted. I have problems when updating my records using this form. because the record number may be different after updating. I need to insert more records or delete records if the record no is different. I tried to delete...

Dear Shaddow: Thank you for your help. The layer may be the better solution to my problem. There is also better solution than this. My question is that the question in a test ask users to match 5 pictures with 5 answers. For example, question 1: Choice A: mountain Choice...

I do not have enough knowledge for XML and VML. But I tried your code in IE. It works. Could you give me more explanatioin for your code? thanks longmatch

Dear All: I am designing a online test program. Some questions allow users to select answer, which is connected to the corresponding image using a arrowed line. For example, there are 5 choices and 5 images. When a user chooses answer A, the answer should be connected to the picture A with...

I am writing this cross-tab query to generate a report. SELECT category, procedurename, count(procedurename) AS No, SUM(CASE involvement WHEN 'A' THEN 1 ELSE 0 END) AS A, SUM(CASE involvement WHEN 'S' THEN 1 ELSE 0 END) AS S, SUM(CASE involvement WHEN 'P' THEN 1 ELSE 0 END) AS P, SUM(CASE...

Dear All: I will start my study on Macromedia Flash MX and need good books to start with. Please give me a suggestion. I am very new on Flash. thanks Longmatch

You do need to check your connectionstring to make sure you are connected to the right database and right table. Some time other errors result that, not sql itself. Just double check. Longmatch