How to lock table while inserting a new record in table? My site has multiple users. Every user can insert new value in table. But when a user inserts a new value he should be able to see previous max value from the table. So I want to lock table while inserting new value. How to do that? Will table locking work or have to do something else?
View RepliesI have a site that I need to distribute to various locations around the country. Each of these sites has they're own developers so I want to lock the code to prevent them from seeing it. Is there anything I can do?
View Replies View Relatedwhat I need to do is the following:-
1) Open a table to insert a new record
2) Lock this table so there is no new entries in it
3) get the maximum call number and add 1 to it
4) insert the new record
5) Unlock the table again.
How can i do it? I know how to insert the record and get the maximum call number. What i do not know is how to lock and unlock the table.
I have a web site that I need to distribute to different sites around the country. Problem is each site has its own developers and I dont want to allow them access to the code, is there anything I can do to lock them out?
View Replies View RelatedI am working on a redesign of an old site and have come across a situation where I will need to use Application variables. Recently I have heard that using Application.Lock() and Application.Unlock() on a Windows 2000 server offers no real benefit.Here's my question: Is what I just said true? If so, is there a performance hit when using the Lock and Unlock methods on a Windows 2000 server?
View Replies View Relatedwhat I need to do is the following:-
1) Open a table to insert a new record
2) Lock this table so there is no new entries in it
3) get the maximum call number and add 1 to it
4) insert the new record
5) Unlock the table again.
How can i do it? I know how to insert the record and get the maximum call number. What i do not know is how to lock and unlock the table.
I have a single asp page that interacts with the client via the post method. Four arrays are created and passed back to the client when the form is submitted.
Question, when the form is being processed server side, should I be locking and unlocking aplication variables and arrays? or can I declare ordinary variables and arrays because its a single page? will ordinary variables get changed by multiple clients on a single page? Im confused what has to be locked down! and what does not.
Is there any way to get a file lock in ASP so that no one else can write to file at that particular time and when I call releaseLock, the lock will be released? I would appreciate any help in this regard.
View Replies View Relatedi m developing client server application but facing problem is that which lock and cursor i use if person in site A enter or updating record. That can person at site B cannot use record until lock or cursor is released.
View Replies View RelatedHow can i lock a textbox in a form !?
so no body can change its value
<input type="text" name="adddate" size="20" value=<%response.write(date())%>>
<input type="text" name="name" size="20" value=Killerpm>
how to lock down a text field so that data displayed within it cannot be altered?
View Replies View RelatedI am using Application.lock to protect a reference to a COM+ object while calling Server.Execute() to another ASP page. I am doing this to pass the object's reference to the other page, and I CAN'T rely on the session object.
Is this a safe way to protect the object reference? i.e. does the Application object remain locked when calling Server.Execute()? .....
i m developing client server application but facing problem is that which lock and cursor i use if person in site A enter or updating record .That can person at site B cannot use record until lock or cursor is released.
View Replies View RelatedI would like to create an auto-lock out module where users are unable to continue login attempt after 3-5 unsuccessful logins. In addition, the user account are automatically suspended after stipulated unsuccessful logins. Is there any sample coding in ASP or Javascript for me to refer to??
View Replies View Related1. How do I create my asp in a way where it does not allow the user to key in wrong password for more than 3 time. It will lock the account once three times has exceeded.
View Replies View RelatedI have signature part in my page (which include signature,name and date). This signature part should be lock together. Let say if the information in the page is about 2 pages, automatically the signature part will be in the 2nd page.
But the problem is, the signature on the 1st page while the name and date on the 2nd page. Is there a way to move the signature to the 2nd page? I've tried make it as a footer and include in the end of the page but doesn't work. Any idea?
I developed a website that posts data to another url via the Inet object.
I should mention that the posting code is wrapped in a VB 6 dll, and that
dll is called from ASP. Code:
I have aproblem to transfer a data from table x to table y based on id. Its mean when 2 table have same id all data table x must move to table y. I don't know which command need to use is it insert into or update?
<%
Dim conn
Dim rs
Dim MYSQL,MYSQL2
Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
Set cmd = Server.CreateObject("ADODB.Recordset")
conn.ConnectionString = "DSN=prmm;UID=administrator;pwd=sa"
conn.Open
startdate=request("tarikh1")
enddate=request("tarikh2")
MYSQL = "SELECT * FROM table_x where paymentdate between '" & tarikh1 & "' and '" & tarikh2 & "'"
rs.open MYSQL,conn ....
I am trying to display the content of a Table called
'Order Detail' directly from the database (e.g., Northwind.mdb). I have the following commands:
Set tableSet = Server.CreateObject("ADODB.Recordset")
tableSet.Open table_name, DB_name, adOpenForwardOnly, _
adLockOptimistic, adCmdTable
where, table_name = ''Order Detail" Or
table_name = 'Order Detail' Or different variations.
I always get error on the second command with the following message:
Syntax error in query. Incomplete query clause
which I believe because of space in the Table Name. How can I resolve this issue? (working with file or table name with space)?
I have a table with many txt boxes which i have inside a form with a submit button to an update page which adds all the details to a db. The problem is i have a another table inside the first e.g. table 2. i want to be able to update table2 by clicking a second submit button that would update it. Is it possible to have a form within a form or how can i do it??
Also i need to update the entire table in one go. For exampple if i have 3 records in table2 i want to be able to update them all by clicking the one update button. Code:
I have the following code but this is inserting manually. I want to make a query from table 1 and automatically enter the records into table 2. What needs to be modified? Code:
View Replies View RelatedHave an app which dynamically creates table rows depending on records, these can be several hundred (don't ask). Hence a very long page at time. Each row includes a hyper link to a new page, and a link back to the original page.
Is there any method (maybe via js) where on leaving the second page l can redirect the browser to the table row the end user clicked on? Hence the bookmarking. Can do this via Visual Basic on the desktop app, but can't work it out on the web app.
I have a table produced with names across the top and services down the left hand side with boxes for numbers for people who recieve services then the info is written into a table in an access db. That works fine and here is that code:
View Replies View RelatedI have two tables. Table A has 20,000 records, Table B has 2,000 records. Table A is what needs to be updated from the data in Table B. Only some fields will be updated and of course, only some records - both tables have the same field as a ClientID so matching up records should be easy.
Anyways, been a while since I have used ASP to work on things like this but would like to work through this one. I understand the process I believe, it is just how to make it go on to the next record once it has finished updating the first.
Basically, I was thinking of having it set up to reaad the top record from Table B, update applicable data in Table A. Delete that record in Table B. Move on to the next.
Hello I have a page for registering users.
I am reciveing this error:
The following errors occured:
- An error occured. -2147217904 : No value given for one or more required parameters.
there are students and teachers. therefore I have 3 tables one for logins and one for staff and on for students.
I have a form designed to capeture the need information.
in the code I am runing an if and elseif statmetn to determin the tables. I then insert the userid and password into the login table.
then i enter the remaining information into ither the staff or student table. what i am trying to do is select the perimary number that is generated as the userid and passeword are enterd. and add this to the second table. Code:
I want MS Access 2000 database column of table 1 = column of table 2. This is what I was doing: Code:
View Replies View RelatedI have a database app that I'm building and displaying my results in a table.
I need to know for anyone who can help how to have one row say red and the next row say green for instance.
I have menubox that shows all the datbases in a directory. When the user highlights a database, the chosen value gets stored in an Application variable(its a control panel).
Id like this Application variable to populate another menubox with a listing of all the tables within the selected database. However, I'm having trouble getting these values and google hasn't been much help. Code:
Can i, using asp code, create whole new table in my DB?
I have clients on my site and each client buys itmes and i want to store the purchase list.so i thought that each client has its own table like member "John" has "JohnOrders" a table reserved only for him..
Which means i need to create a table using code each time a user register.
am i doing this right beacuse i've seen people have just one "ORDERS" table but i cant understand how the stuff all the info about all users into 1 table?
how can i get the table row index so that i can highlight the entire row when the user click on the row.Below is teh code i have tried but failed... cos it only hightlight a single cell.
var oSelected = null;
if (oSelected != null)
{
oSelected.bgColor = "white";
}
oSelected = window.event.srcElement;
oSelected.bgColor = "lightskyblue";
i want to create a table from a txt file seleted by the user and display on the browser. anyone can offer some tips on ow to do it?
View Replies View Relatedhow to convert xml data to access table using asp.
View Replies View RelatedHow can I add table gridlines to this? border of 1 inch?
<%
call OpenDB()
set rs = Dbconn.Execute("EXEC spRES")
Response.Write "<table>"
Response.Write "<tr>"
For Each oField In rs.Fields
Response.Write "<th>" & oField.Name & "</th>"
Next
Response.Write "</tr>"
Do Until rs.EOF
Response.Write "<tr>"
For Each oField In rs.Fields
Response.Write "<td>" & oField.Value & "</td>"
Next
Response.Write "</tr>"
rs.MoveNext
Loop
Response.Write "</table>"
%>