I have the following code on my site that Updates certain fields in the table. When I check the Tables they are all updated perfectly but I keep on getting the following error:
Microsoft JET Database Engine error '80040e14'
Syntax error in UPDATE statement.
This is the code involved:
if strAction = "submitted" then
'lngCount = Request.Form("lngCount")
i = 0
do until i = Request.Form("lngCount")
UpdateSQL = "Update Site_Info SET Site_Accepted = " & Request.Form("acceptance"&i) & ", Site_Date_Accepted = #" & Now() & "# where Site_Seq = " & Request.Form("lngSeq"&i)
oConn.Execute(UpdateSQL)
i = i+1
loop
Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. /changeprofile.asp, line 44
I have a very simple Access database with these fields:
ID | Team | Score
I want a user to enter the new score of the team into a form and then it's updated. All pretty straighforward - except I'm getting an error at the bottom of this page:
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
I got an asp page that supposed to add,delete records from access 2000 mdb file. It loads all the records but when i try to delete or update i get these errrors. Code:
Well, my script consists in check if the typed code doesn't exist in the DATABASE, but thats not the problem... the problem is that the PAGE1.ASP (that check the code) redirects to the ADD.ASP that will add those codes to the database!
That's the line in page1.asp that redirects to the add.asp. So, when the database is completed empty and, the page1.asp checks that there ins't any problem with it and redirect to the add.asp that doesn't update my database!! So, it continues without any record. But, if the database has, at least, one record, the script works normally without any problem!
Another thing that I noticed is that when I, manually, type the adress Http://127.0.0.1/add.asp?cod_1=176096, for example, and the the database is empty, the script does the UPDATE and adds the code to the table!
I have no idea that the problem is. Does any one have a clue?
I'm not sure if this is an ASP thing, a IIS thing, or a GoDaddy (where my domain is registerd and forwarded from) thing...
First I'll start by saying I run my own Windows XP web server and do all the coding myself..
I've noticed in the past (and never really gave it much thought, because the site works fine), that when I switch pages within my site, that the URL line is not always updated.
For example, I go into the pictures section, view a few pictures, then select the "Home" tab... The URL will stay with the variables that were passed when I was viewing the pictures. Therefore, if I do a "refresh", the page goes back to the pictures I was previously looking at, not the home page.
I've tried this on multiple computers at multiple sites, and with multiple browsers... And seems to happen rather consistantly...
I am looking at updating a notes part of my data base. I am calling two fields (first name and last) from the data base and putting them into read only text box (as i dont want the details changing). All of this is contained within a form. I am also calling a feild from the database called notes which originally has been inserted using a <textarea> tag. The problem i face is that you cant put values into a <textarea> (ie. i can put data from the database into the value tag of a textbox but <textarea> doesn't have a value tag). Due to this i am putting existing notes onto the page as text. Under this i have do have a <textarea> to put the new notes in. The problem i have is that i some how need to store the existing data in the notes field and then add it to the new notes that i will be adding. I just don't know how to put the data i am getting from the notes field in the database into a variable.
Having problems writing an update script because in one of my fields I'm adding a chunk of HTML that contains ' characters. Obviously this throws up an error. How do I get around this?
I have a function below that works fine. It takes a XML dox parses it, etc.
What I need to do is after the update of a record, I need to query the same table again for another record. If it finds this second record, I need to update it.
The problem is I can't get it to work, mostly because I don't completely understand the .open() method. Can I requery and the test for the existance of a returned record - if so how? Code:
I placed a post a couple of weeks ago discussing how I was having trouble using ASP and the XMLDOM to differentiate between the text content of Parent and Child Nodes in an XML file.
ie: IF PARENT.text > "" Then 'Do Something with PARENT.text ElseIf CHILD.text > "" Then 'Do something with the CHILD.text End If
The problem being that I couldn't differentiate between the text values of PARENT and CHILD.
I've managed to work around that problem in a fashion but I'm begining to think that I'm going about this with the entirely wrong approach.
All I want to do is edit the following XML file through ASP: * Note that there are attributes with values and some nodes and child nodes have text values as well Code:
I am trying to configure Visual Interdev 6 (running windows xp professional) for debugging. However, while I run a utility viddbg.exe, the debugstatus file shows the following error message.
ASP.DLL Version Information -------------------------------------------------------- Location: C:WINDOWSSystem32inetsrvasp.dll FileVersion query failed File Size: 339456 bytes
VID Debugging requires 4.02.0622 (330448 bytes) or greater. What is the best way to handle this problem.
I was give a site that was created on vb/asp and the owner want the site to b. be a asp.net web site, how difficult is for the site to be updated with the new .net technology?
i'm trying to add the data of such client, some of his data have been added already but if i'm going to add or update his data (additional info.) what happened is the data is being added into new row not on the specific client. Code:
Got a cookie problem, specifically with persisting it when I write to it a second time on another ASP page. Here's the scenario:
Page1.asp: - I have a cookie with serveral keys - I set all the key values - I then set the overall cookie expiration (you don't do this for all the keys right, just at the top level?) - This works fine, the cookie persists, but if I then go to page2.asp...
Page2.asp - I simply use the response.cookie("cookiename")("KeyName") to update some of the prior values.
Once page2.asp gets called, the cookie becomes a session cookie and does not persist.
Questions: 1. I wasn't then re-setting the expiration, do I need to? I tried but still the cookie wouldn't persist.
2. What is the correct order of setting the expiration, before, after setting all the key values? Does it matter?
3. Can you in-fact update a cookie's key values, or is this fundamentally incorrect, do you need to re-write the whole cookie?
I have a script on my asp page which takes values entered from a form and inputs it into a database, in their appropriate fields. It's been working fine, but lately I'm noticing that I've been getting some blank records being entered in my DB table.
I know it's not my form becuase there is no way to leave it entirely blank, so even if you don't enter anything... their are hidden fields which already contains a value that get's passed and goes into the DB.
I am wondering if this is a result of many people entering data into the access db at the same time, and i'm wondering if i have the right locktype parameter.
I am using adLockPessimistic right now... should that be adLockOptimistic or adLockBatchOptimistic????
first the item sold and recorded as sold in the sale table secondly the item will be deleted from the stock table third the item wil be automatically reordered in the order table.
is this possible please. I am using Dreamweaver/access and some of ASP that is generated,
I have a bit of ASP that gets data from the database and then displays it. This part works fine.
I then have anouther page to allow for changing this information, then i want to do two things, first show the updated info, and then update it in the database.
Neither of my updates will work and i can't figure out why.
I get this error: ADODB.Recordset error '800a0cb3'
Object or provider is not capable of performing requested operation.
I have checked the record it displays the info just fine, it will not update however. Here is my code for updating the record: Code:
i'm trying to update my db when the user sessions expires..... So i put the codes below on the golbal.asa file... i tried it a few times but this code wont work... but when i tried in Sub session_on_start it is okay... i notice that we could not use server.mappath or any other objects/variable other than Session or Application variable on global.asa .... have any of u guyz trtied the same thing and works
<script language="vbscript" runat="server"> Sub Session_OnEnd
set adoConn = Server.CreateObject("ADODB.Connection") adoConn.Open "Driver=MySQL ODBC 3.51 Driver; Database=dhl_21Feb; Uid=user;Pwd=user;" set rssession = adoConn.execute("Update session set LogoutTime = '10.20',status = 'Log_'")
I am having trouble updating more than one column in my sql database. I have tried everything I can think of and I am pretty sure it is something simple that I am just missing. Code:
I used this code to add a record to table 'adItems' when I used access. once I added the record, I pulled the new id of it (just after it was created - bolded). Code:
Set rs = Server.CreateObject("ADODB.Recordset") rs.open "select * from adItems",conn,3,3 rs.AddNew rs("catId") = catId rs("expiry") = expiry rs("adTitle") = adTitle rs.Update newid = rs("id") rs.close
now, that I moved to MySql, newid remains blank. why is that? Any idea?
i have a form with two pull-down menus. when the user chooses a value from one, I need to go to the db and execute a query, and then populate the 2nd pull down menu with the retrieved values.how would I go about this? where do I add the listener function that will catch the selection event, and what should go in it?
I'm doing a program using VB.net. Hosting it on a server so it is done in ASPX.
So my problem is as follows. I want to add a new row of data in my access db. I know this code is working but it doesn't update the db once I close the website. EG it will make a temp db I believe but doesnt save it. Here's the line of code that adds the row and the data with all it's corresponding fields. Code:
I have this form that people fill out with information and it updates. I'm fetching from two tables and it doesn't seem to update any forms related to the second table. Code:
