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

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

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

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

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 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 am trying to create a new user for my SQL 2000 server. Unfortunately I am not be able to do it. This is what I did: 1.click SQL server - enterprise manager - database - residency(database name)- right click Users to click - new database user, then "Database user propertes - new user...

I am writing a connection object to connect data on our database server. It just working fine. However when I put this connection object on other server out of our domain, for example, a public web hosting server. The connection does not work any more, even though I used the IP address as server...

I am developing a ASP page to show data to our end users. The data stays in different tables of different database(MS ACCESS 2000) at different server, but the data structures are the same, for example, the field name and data type. I need to combine two tables together for presentation. Does...

I know "crystal report" can be used on the web to generate dynamic report. But do not know how. Please show me what software need to be installed and how to use the components? If there is any examples, I will be very glad to see it . By the way, Is there any free component available...

I have this problem for long time, not sure how to fix it. Right now I am using Windows 2000 as my desktop OS. The login window does not show up when I startup my computer. That means no username and password are required. Anybody can use my computer without putting username and password. This...

I have two dropdown comboboxes in my ASP form, one is dependent on the other. The data is from MS access database. I just want to add a page to allow user to update the items in the database such as 'add', 'modify' and'delete'. Does anyone have this kind of examples? Thanks Longmatch

I would like to get month and year from a date field, and count the record for each month in three years. Does anybody konw how to do it. thanks in advance longmatch

I have a form used to collect resident procedure data. Sometimes, one patient can have more than one procedures. So it is good to pass the same information to next pages such as name, sex, DOB, medical record number etc., if the patient is the same. In this way, we can avoid users to type in...

We are planning to move all of our database from MS access to MS SQL server for our asp web pages. Current the ASP pages can not use SQL server as backend database. The connection always failed. Could anybody show me how to configure the SQL server for ASP page access? Big thanks Longmatch

I want to allow users to select colors for their report. I would like to have the color selector put on my form, when user select one, the color code will be saved into the database for further display for given field. Does anybody know whether there is any good 'color selector' easy to use...