Search results for query: *

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

I would like to use OWC (office web components) components to draw some graphs based upon the query result. It is said that we have to install the Microsoft Office if we want to use OWC. I asked our Administrator to install. Unfortunately they do not want to do that, and told me there are same...

I am using SQL Server 7.0 right now. Do you know how to see the trigger I created in for a table? How to know what happened after trigger is fired? I have just started to use SQL server instead of MS Access. thanks longmatch

I have two tables in my sql server database, table1 and table2. There is a trigger in table1 for insert. When records are inserted into table1, the new inserted data will be inserted into table2. When a new record is inserted into table1, I found two records in table2 (two copies). It looks like...

I tried with following code. Still does not work. I forgot to tell you more inforamtion in my previous post. The BaylorID is an integer field, length 4, a six digits number, for example, 130158. The error message for the following code is: ADODB.Command error '800a0bb9' Arguments are of the...

Dear Ian2: I met the same problem as SergeiY - can not make use parameters.append method in my ASP code to add the parameter. I tried your suggestion, it works. I did find many examples using parameters.append. Not sure why my code does not work. My code is following: dim objConn dim...