Search results for query: *

I am using Access as my database. Tha drop can be executed now but not the MSysObject.

Thanks for the tips but hv the following errors: When drop column: The database engine could not lock table 'Subject' because it is already in use by another person or process. When check if table exist: Record(s) cannot be read; no read permission on 'MSysObjects'. Where should i correct the...

Hi Travis, "ALTER Table Subject ADD COLUMN ( " & request.form("subjID") & " text (20))" The above code contains syntax error: "Syntax error in field definition" What I have done wrong? another question: How do I detect if a table already exist? Thanks again, Travis Necta

Hi, Tlhawkins Thanks for the tips, now I can create table with field. However, is it posssible to add subsequent field and to delete a field from the created table? How do I do that? Thanks. Necta

Thanks Thawkins. Its meant for the system administrator only.. Compare the two code snippets below, the 'NOT NULL' present in the first but the second one. Any difference between them? CREATE TABLE Contact (FirstName TEXT (20), LastName TEXT (20) NOT NULL, Address TEXT (20)) SQL = "CREATE...

I want to create dynamic table and its fileds by getting the field name from request.form. Can anyone show me how? Thanks

Hi, Tony, Where did i write to the client browser? I don't quite undestand.

Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. /wem/Insert.asp, line 30

Line 27:Response.Redirect("exmAdd.asp")

I have this problem but i couldn't see the cause. What could be wrong? Response object error 'ASP 0156 : 80004005' Header Error /wemes/exmDel.asp, line 27 The HTTP headers are already written to the client browser. Any HTTP header modifications must be made before writing page content...

The result is the same: "5/20/2004

What i intend to do is display a date which stored in database....

I found out that it should be ...Request("marks[i]")...

I have problem insert/update sql statement in IIS (the statement…must be an updateable queries..) but not in win98. I wonder if anyone can help me with this. Thank you.

I intend to display date in dd/mm/yy but the system show mm/dd/yyyy. I have set the system date to dd/mm/yyyy. I am using Window XP. What should I do? Necta

Hi, everyone, I have the problem with if statement below: It keep asking for the 'Then' although i hv already put one, can anyone please help. If (gredRS("mrkMin") > Request.marks[i]) AND( gredRS("mrkMax") > Request.marks[i]) Then grd=Response.Write gredRS("grdID") Necta

as shown below: function calc(frm) {var totalMarks; var totalCredit; var aveMarks; for (i=0; i < frm.subjNo; i++) { if (frm.marks[i].value != -1) totalMarks=totalMarks + (marks[i]*credit[i]); totalCredit=totalCredit + credit[i]...

Hi Patrik, i have change the var place but still get the same result.but the result still the same. no totalMarks or aveMarks value display. rgrds. Necta

I have a dynamic generated form fields which allow only number. I intent to calculate the total and average before submitting it to the database. The total is get by multiple the marks value with a credit and put it in totalMarks. The average is calculate after that and put the value on the...

Sorry for the mistake. I intend to validate text field which carry the numeric input. However I have successfully validate using If (mrk.value ==""). But now the problem is how to validate the input which is a numeric input (include of -1)