I am trying to update an excel sheet with asp over a webpage. Now i am able to view the contents of the xls file so my connenction is ok. However if i try to update a cell in the xls the browser just stops responding. I already tried switching of script blocking from norton and also switched of my firewall for a sec. Code:
View RepliesHere is a code for ASP inputs being updated in Excel. However, when I
click to submit the user, the excel does not get updated! Code:
Is it possible for a client to update an excel worksheet sheet online ?
View Replies View Relatedim doin some code on asp where ive got an excel file and run it against a database file. i am trying to code it so that it runs asp code that checks the data in the database and if the data isnt present in the database- the code insert it , but if its already in the database- it should be updated.
Ive used sql commands, connection and a few loops-to run to this- it adds new data to the database but it overrides and re- inserts the data when run a second time.
I want to update Excel file when i update database.
View Replies View RelatedAn user can open the xls file from my website (loaded on the top frame). After filling the Excel, he can click a send button at the bottom frame. By clicking the button i have to save the file in a shared directory on the web server by a unique name. Is it possible ?
View Replies View Relatedthere are two places on the web site where on average 350 items are added or
updated.
When any of these two actions occur, for 3 - 5+ seconds, the CPU usage on
the server is pegged at 100%, and the database is locked for that entire
period. Then, if nobody else is using the database or ordering platform, it
will continue as normal. Code:
why this isn't working?
cid, uid, u, d, and s are numbers
sd, ed are dates
c is text
myC = "INSERT INTO tbl_requests(req_client, req_user, req_unit_id,
req_cat_id, req_shift_id, req_start, req_end, req_sp_req,
req_submitted, req_status) VALUES" & "(" & cid & ", " & uid & ", " &
u & ", " & d & ", " & s & ", #" & sd & "#, #" & ed & "#, '" & c &
"', #" & now() & "#, " & 1 & ")"
conn.execute myc
I am experiencing a problem with our ASP service. OS: windows 2000 server, service pack 4. IIS 5.0 working with Oracle 9i. Our ASP service collapses and restarts once in a while (short while... practically every day). The symptoms are that first we see some of the ASP having the error: |0|ASP_0100_:_8007000e|Out_of_memory 500 0 0 while others work fine.
During that time the virtual memory usage goes up and up and the processiort works at 100%, After about 15 seconds the memory usage goes over the top and the ASP service restarts.
When restarting the ASP's return: Out-of-process+ISAPI+extension+request+failed. 500 1726 4203 (which is probalbly because the service is down). After the restart everythign is fine again -but they become more and more freaquent, and having between 50-300 concurrent users that get kicked out this becomes a real problem.
My site has just started crashing the server. They said that every time my site ran it crashed the server requiring it to be reset. Because this is disrupting other accounts mine has been suspended. Below is the last log before the site crashed.
2003-10-06 09:27:30 64.62.156.55 GET /Logon/join.asp
|-|ASP_0113|Script_timed_out 80 - 81.136.229.48
Mozilla/5.0+(Windows;+U;+Windows+NT+5.1;+en-US;+rv:1.5a)+Gecko/20030728+Mozi
lla+Firebird/0.6.1 http://64.62.156.55/ 500 0 0 .
I am to build a site onto an ASP server. Anyone here used Dreamweaver and is it just a simple matter of opening up a new ASP page in Dreamweaver and build the site like you would normally do with a HTML page and it will handle the ASP coding accordingly and you can just simply upload it onto an ASP server and it will work?
The site I am to build is basically just a standard html website, but my friend wants me to build it for an ASP server so he has asked me to make sure it is an asp site so I am presuming with the extension .asp
If I build it as a html site to begin with, will converting it to asp be hard. Could I just export my pages into asp or is there more to it?
Can a Html website be loaded and working on an asp server or host?
Is it possible to have a site mixed both html and asp, eg. the home page is html and when you click on shopping cart on the home page it goes to a hopping cart page thats .asp or do they all have to have the same extension.
I have to pass form data from my site to another organizations site using POST method... how exactly do I do that? Im familiar with how to do it within a single site/domain, and cant use querystring... I dont know where to begin.
View Replies View RelatedWhenever I do a site that is mostly static but with some semi-dynamic
sections, I've struggled to find a good site search solution without
paying for a hosted search service.
I like the FSO-based search engines, but they fail to pick up on some of
the dynamic part.
I was just creating a Google sitemap and it made me wonder: has anyone
created or seen a script that uses the XML Google sitemap to power a
search engine for your own site?
Seems like if you were keeping it updated for Google, why not use it for
your own site?
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!
Response.Redirect("add.asp?cod_1=" + cod_1 + "&cod_2=" + cod_2 + "&cod_3=" + cod_3 + "&cod_4=" + cod_4 + "&cod_5=" + cod_5 + "&sexo1=" + sexo1 + "&sexo2=" + sexo2 + "&sexo3=" + sexo3 + "&sexo4=" + sexo4 + "&sexo5=" + sexo5)
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?
The goes the add.asp script: ....
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...
Anyone have any thoughts?
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?
View Replies View RelatedI'm trying to create and assign variables with the values from my db but can't work out the code getting my " & ' mixed up.
i = 1
do until i = 6 or rsSet.EOF
rBlock(i) = rsSet("rBlock'" & (i) & "'")
i= i + 1
rsSet.MoveNext
loop
whats better ADO or SQL
for example, an INSERT statement or an objrecordset.update blah blah?
same with .net
should I C# to update or SQL
I have an XML file which i'm trying to append elements to using an html form and ASP with javascript scripting inside the ASP file. Code:
View Replies View RelatedI 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?
View Replies View RelatedI get this error message:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Expected query name after EXECUTE.
I tried hard but nothing, I have a same example working, but when I changed just the field names...it didn't work!! Code:
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:
View Replies View RelatedGot 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?
4. Any other ideas?
I want to let the user of my asp-page fill in a form, and with this data I want to update an existing XML-file The xml-file: Code:
View Replies View RelatedI 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????
and should the cursor type be adOpenDynamic???
I have a stock control database, I want
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 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
end if
I can easily add a new recordset (addnew) but when it comes to updating a recordset, i haven't received much luck.
I usually get this error:
Query-based update failed because the row to update could not be found.
...
Set oRS = Server.CreateObject("ADODB.Recordset")
sSQL = "SELECT * FROM ICR_Item WHERE ItemKey=" &ItemKey &";"
oRS.Open sSQL, dbConnection, 2, 2
oRS("Stock") = Stock
oRS("StockCode") = StockCode
oRS.Update
oRS.Close
Set oRS = Nothing
...
I can't use the simple "UPDATE Table SET..." command. I need to use a recordset.