Rs.Update Locks Up Page
I have an ASP page which uses QueryString data to determine what the user is wanting to do. It has Upload (which provides a form to enter a category, title, overview, and file), Edit (which gives user a form with the before mentioned sections, minus the file, to change the overview, title, or category), Update (which processes the Edit form), and Delete, which allows the user to delete a file.
A user can upload a file just fine, and a file can be deleted just fine. The problem is with Edit/Update. The Edit form loads fine, with all the correct information in the input boxes, and a hidden field storing the "ID" for the record. This form submits to .asp?Action=Update, where the Select statement is based on the hidden ID. When the user clicks the update button on the Edit page, the next page never loads, the confirmation never comes up.
On our Production (Live) server this caused ALL of our sites to go down, we had to restart the server to bring them back up. Now I've been testing in our Development server trying to solve, it causes this site to go down, but all other sites on the development server continue to function (so we have a different result on this server, but still the problem). Reboot is not required here though, if I wait a few minutes, I can access the page again (maybe a timeout is happening here that isnt on the other server?) Code:
View Replies
ADVERTISEMENT
I have problem i need to carry out a transaction on a ASP page... the page goes like this:
<%
Conn.execute (Sql) ' Where the Sql Gets the Set_Number froom Table1
Conn1.execute(Sql1) ' here the Sql1 inserts the Value (Set_Number + 1 ) 'into the Table2.
%>
This page should be Executed as a transaction or else please help me out how to lock tables so that no other person can execute the same page with same data simultaniously...
I dont use any components in this page..so now how to go about with this...????
View Replies
View Related
I have a very simple database call running on a W2K3 server. I moved it over from a W2K box. However, when it is run on the 2K3 server, it leaves a lock on. It is an ASP page and not and ASPX page. It works perfect on the W2K box.
Anyone else have this probelm or better yet a cure for this problem? I do not have the time to convert it to ASP.NET yet. The ODBC driver is a bit different. One is V 4.00.6205 dated 3/2003 the one on the W2K box is version 4.00.6200 dated 6/2003.
View Replies
View Related
in ado we have 4 locks
adlockreadonly
adlockpessimistic
adlockoptimistic
adlockbatchoptimistic
how can we check this locks work ...means suppose i used adlockpessimistic ..this lock does not allow other user to alter data ...i wanted to check it live.
View Replies
View Related
I'm using application variables for a web based sales tracking application. I use the variables for stuff like connection string, database name, etc. I store the values in a asp file that is included in a login page. The assignments are in a procedure that I then call on the login page. This is done everytime a user connects to
the login page.
what's happening to the variables? Are they being overwritten everytime a user accesses the page? I'm not checking for the existence of the variables. I just call the routine everytime the page is accessed. I know the values are shared for all users but, I was wondering if I should check for the existence of variables? Will it free up resources? Should I be using locks?
View Replies
View Related
Do anyone now how I should do to update my ASP page every 5 sekond.
View Replies
View Related
After updating a record, I want to go back to the results page from a search. Anyone know how to redirect after you update a record to go back a page to see the results again. A simple click of the back button would do the trick, but that can't be done after you click the update.
View Replies
View Related
I want to build a page having a list of products with their individual price, order qty, and total price.
What I would really like is that when a user enters the order qty and tabs out, that the total price is updated instantly. How would I go about doing this?
When the user has finished all his order, then he would press the submit button and not before.
View Replies
View Related
I want to update a database but, NOT do a page refresh.
Like how they do it on Netflix with the "was this review helpful?" you choose yes or no.
I just want to capture the yes or no, without doing a page refresh so the user can make a number of interactions on the page.
View Replies
View Related
How would I go about updating a page without a form submit?when a user types the number 1 in textbox1 and the number 2 in textbox2, textbox3 automatically displays 3.
View Replies
View Related
i am using following code to display purchansed items...
<tr bgcolor=#ffffff>
<td class=h1 class=stocktextfont><b><%=RS("cnt")%></td>
<td class=h1><b><input type=text name=qty<%=RS("Order_Qty")%> class=stocktextfont size=2 value=<%=RS("Order_Qty")%> maxlength=2></td>
<td class=h1><%=RS("Order_Item")%> <input type=hidden name=pname value="<%=RS("Order_Item")%>"></td>
<td class=k1><input type=text name="pval" class=stocktextform size=5 value=<%=RS("Order_Amount")%>></td>
<td class=h1><input type=button name=but value="Update" class=stockbuttonfont2></td>
</tr>
in this i get sr.no by <%=RS("cnt")%> which keeps increasing by 1. when i change some quantity how to capture in next page as i wont be knowing how many itesm are displayed in this page and which item user wants to update.
View Replies
View Related
I developed an ASP page which has 2 input fields- First Name and Last Name.I used Access 2002 as database. Once I click the Submit button,
it has to perform 3 tasks-----
1) It has to update the First Name and Last Name in the MS-Access database in their corresponding fields.
2) It has to go to the Home Page(which I already did)
3) It has to update the date/time in the "Time" field in the MS-Access database.
The following is the code I wrote to connect to the database and update the fields in the Access table---
<%
set MyConn = Server.CreateObject("ADODB.Connection")
set rs = Server.CreateObject("ADODB.RecordSet")
MyConn.Open "driver={Microsoft Access Driver
(*.mdb)};;DBQ=c:/documents and
settings/adcguest/desktop/webpage_html
ewsecurity.mdb;"
rs.Open sqlqry,MyConn,2,2
rs.AddNew
rs("firstname") = first name
rs("lastname") = last name
rs.update
rs.close
myconn.close
%>
Can somebody please help me in figuringout if I am missing something.
View Replies
View Related
I had successfully created a update page for a registration. But now I went into a problem.
1: In REGISTRATION page (Where they submit their data for the first time), they are able to use Drop down button to choose their answers. In my UPDATE page (Where they can edit their data), I can only create textbox for them to change their data which they originally used Drop down button.
For example: In REGISTRATION page, they can choose Yes/No from Drop Down button. In UPDATE page, they need to type in Yes/No instead from Drop Down button.
How can I create drop down button in the update page with their previous answer selected?
View Replies
View Related
i want to update a specific part of a page every 3 seconds without refreshing the whole page, any ideas?
View Replies
View Related
how to Update Record On Page Load. I have one feild in my database that I want to subtract 1 from each time the page is loaded.
View Replies
View Related
i am updating client's table(i.e insert one new client) from one asp page and after that it is being redirected to html page on that page i have one link which selects records from client's table and then displays it in the form of list. The problem is that when a new client is added it is not shown in the list. If anyone can please guide me on how to refresh the asp page after every database updates.
View Replies
View Related
I got a test asp page which connects to Northwind.mdb database. This page
pulls all the rows from the Customers table. One column i.e. GoodStatus has
been added to the customers table. The following is the code to display all
records of the customers table with some customization. Code:
View Replies
View Related
Is it possible using ASP to update the page display by selecting a record from a <select> box, then, search the db for the record selected and update the same page with the content of that record? Code:
View Replies
View Related
How to update, add, delete and save any data that has been called to a page. instance, second.page. The update must be done in second.asp too...
View Replies
View Related
There's an access database on an iisserver and asp makes updates to it. The
database got moved to a newer server. The users used to be able to open the
database and use the asp pages at the same time. Now when the database is
open the asp pages won't update.
View Replies
View Related
I have an asp page in which I use the ļæ½time() function but that just gives the time at the moment the page is loaded. I need to reload/refresh the page once every second so the seconds increase by one continuously.
View Replies
View Related
Microsoft has a service called SUS that allows operating
system files to be updated from a dedicated server
instead of from Windows Update(Microsoft). SUS is a web
app based on .asp. I went ahead and installed SUS on a
Windows 2000 server that already had IIS 5.0 on it.
After the installation of SUS I tried to browse to the
home page,ie: http://localhost/SusAdmin, and got the
error "page not found".
I was able to browse normal html files in the same SUS
virtual directory in IIS and see them with no problem.
Something is wrong with .asp on IIS or with the setup of
SUS.
View Replies
View Related
I'm using formmail.asp which is an emailing utility. Basically, the user
fills out a request page, clicks "Submit" and the page posts to formmail.asp
which emails the user information.
I'm running IIS5 on a Win2k server box and recently ran the Windows Updates
(the last time I do that). Anyway, that emailing form doesn't work now on
any of the sites I host. Any ideas?
View Replies
View Related
I have a form I am validating on a page. Currently I have the page call itself to check the form values for validity. I want to use the form post method to send the form values to the Update page but can't because I am using the "Response.Redirect" which doesn't post the form values to the next page.
What is a good way to validate a form values then direct it to an update page if values are valid. Should I use Client-Side or Server-side script?
View Replies
View Related
Okay there is an unique EventRegID for every registration. When people first register they get pre-registered. Then an admin comes in and confirms or wait list them (based on whatever requirements). My question is how can I tie the EventRegID to a form with multipule ID's so they can batch confirm or wait list the PreReg list? Code:
View Replies
View Related
I have this page that displays a dollor amount code:
<td class="tableValue" width="122">Expiring Premium:</td>
<td width="400" align="left">
<input name="Expiring_Premium" type="text" value="<%=formatcurrency(Expiring_Premium,2)%>" class="tableValue" size="27"></td>
it would display $100.00 when i go to insert that value into the database the value i get is $100.00 and i get an error, i need to get rid of the $ sign but not sure how to do it because the number range can be from 1 to a billion dollars.
I have this code for asp that if the value is null it insert a null instead of a blank, else i get an error message in access.
'Expiring_Premium = request.form("Expiring_Premium")
if (request.form("Expiring_Premium")) ="" then Expiring_Premium = "Null" else _
Expiring_Premium = request.form("Expiring_Premium")
Any ideas on how i can strip off the $
View Replies
View Related
I'm looking to update a column in a datebase that has null values with N/A and I'm using this:
UPDATE tbl_members
SET branch_no = 'N/A'
WHERE branch_no = NULL
The only reason I'm trying to do this, is because I can't seem to do if statement on a null value.
View Replies
View Related
This is hard to explain, but I have wanted to know how to do this. Say you have a website, and you have a news box(where you can report all of your news), made of a picture(s), you know like something that says "news" at the top of the 'box', and the sides of the 'box' are a picture. I have wanted to know how to make one of these 'boxes' without having to use the <div> tag, and type as much text in there as i want, and it wouldnt mess up a table or anything, or realign it, because the <div> automatically wraps around the text, fitting perfectly to it. I was wondering if you can 'wrap' around the text without a <div>, but with pictures. Here is an example, this picture called ex.gif.
I know it is a link menu, but what if you wanted to add a couple more links. How would you get the 'box' to automatically resize so that it does not messup the table. I am not even sure if this is capable in ASP, but I am sure somebody knows what I am talking about.
View Replies
View Related
I have a guestbook form that inserts the fields into an
Access Database. The database is residing in the "fpdb"
folder that was created by FrontPage. The ASP page that
writes the data into the databse uses the
"recordset.addnew" method. The code was working fine a
couple of weeks ago, and now all of a sudden the error
message "Cannot update.Database or object is read-only"
pops up. The ASP code or the database was not changed or
modified in any way, neither were the permissions for the
account.
View Replies
View Related
I have quite strange problem and hope you guys can help me out or provide me with some tips.
when using a update script:
UPDATE categorys SET main_cat_default= '0', banner= '', b_link= '', external_text= 'Nākotnes parks', name = 'Arzemju muzika' WHERE (id = 115)
Then it messes up field EXTERNAL_TEXT. Instead of Nākotnes parks it saves it as Nakotnes parks.
But! when I open Enterprise manager and type in Nākotnes parks manually then it saves it correctly. So I believe there is something with update command or smthing like that.I changed collation also to Latvian and this did not work.
View Replies
View Related
For laptop users who have an ASP application running on their laptops
- is there a way I can have it check when connected to the network
(via the FSO lastmodifieddate) which files need to be updated
(enhancements, etc.), then shoot the ASP pages that have changed down
to the client?
View Replies
View Related
I'm using the following code:
rs.addnew
rs("application")=body
rs.update
body is containing a lot of text with vbcrlf in it.This is basically a form that is emailed and I want to save it to a db just in case the emails don't go through.
For some reason the field in the db (access) is only containg the first line until the first vbcrlf
View Replies
View Related
I am updating some pages "font "style color size" and a few words in several of my asp pages. Most of them will update but I have a few that refuse to even after rebooting the server and clearing the cache on my current computer.
View Replies
View Related