If I am updating a list of records for a user on an asp page, is there
a way to hold the page updating, even if they refresh the page, until I
have updated all the records.
i.e. rather than them seeing records change 1 at a time if they
refreshed their page, all the records would update together in 1 go, a
bit like a batch update ?
The source is from a MySQL db which is fed from an MS Access front end.
This could be an MS Access issue, in which case I will post there
instead.
I'm looking for the best software out there that can create simple websites for clients. Basically, a client pays a small monthly fee and they're given a website where they can display whatever they'd like. Something sorta like Geocities in a way. I've searched aspin.com but I couldn't find what I was looking for. Can anyone point me in the right direction? I'd rather buy something already made then to start from scratch and develop my own.
I have registered a domain that forwards every hit to my home PC. I have configured Default Web site to show one Web from my PC. So when people navigate to www.mydomain.com they see that site. What if I want to how more then one web site? Is there a way of doing that?
I can't afford M$ CMS. What I am after used to be called Content Deployment in Site Server 3.0.Does anyone know of any other software that will let me define a series of hosts and then FTP to all of them at once?How do you guys update your clusters?
i first used this forum to find code for coldfusion, but now want to learn ASP. are there any websites out there that show you the code for various things such as counters, guestbooks, database stuff, etc.etc.
I'm trying to update an Access db: if link is ok, then status=up else status=down, in a form with 3 fields: names, link, status:
<% Server.ScriptTimeout = 1500 %>
<% Session.timeout = 1 If IsObject(Session("press_conn")) Then Set conn = Session("press_conn") Else Set conn = Server.CreateObject("ADODB.Connection") conn.open "press","","" Set Session("press_conn") = conn End If
sql = "SELECT names, status, link from websites order by names" Set rs = Server.CreateObject("ADODB.Recordset") rs.Open sql, conn, 3, 3 rs.MoveFirst
Dim GotothisURL
Do Until rs.EOF GotothisURL = rs("link") Set GetConnection = CreateObject("Microsoft.XMLHTTP") GetConnection.Open "get", GotothisURL, False on error resume next GetConnection.Send ResponsePage = GetConnection.responseText
if ResponsePage="" then sql = "UPDATE (websites) set status=(offline) WHERE names = '"&rs("names")&"' AND link = '"&rs("link")&"'" conn.Execute(sql) else sql = "UPDATE (websites) set status=(online) WHERE names = '"&rs("names")&"' AND link = '"&rs("link")&"'" conn.Execute(sql) end if
Set GetConnection = Nothing Set ResponsePage = Nothing
rs.MoveNext
Loop
conn.close set conn = nothing rs.close set rs = nothing %>
I get no errors at all. The path to db is ok.
The script acts very very strange. On the first run, it seems that everything is ok, but the page freezes on half [the blue bar on bottom of browser]. If I'll stop the script, on the second run, the page loads very quick, but nothing happens.
I'd like to be able to list IIS websites and information in a web page (presumably using ADSI). Similar to the list you get in the MMC plug-in. Does anyone have a simple script I could start with? I'm only interested in reading info at the moment.
I need to offer a questionaire to approximately every 10th user of my website when then are leaving.
My first thoughts were to use an application variable to determine the number of users but this falls over because it would not instantly release the variable when the user left the site.
I am going to construct a housing search website ... similar to www.mls.ca ... is there anyway I can populate the data(s) stores in their database? So when my user search for one kind of house, my website will return the data from the MLS database? Or there is similar way to get data from public websites?
Also, if a user search "sport" in my search text box, it will returns all the related links ... just like those search engine ... how can I acheive that? Or I need to pay or register to get the function?
The VIRTUALSITE name is really the virtual directory created under IIS.
I clone my website multiple times, to cater for different people. So, each person gets a different VIRTUALSITE name.
This gets messy when I need to update the websites. I can't do a diff/merge because the files of each site had a "search & replace" applied to them to change the VIRTUALSITE name to the corresponding person.
Has anyone experienced this problem? Can someone give me some tips/solution on how to resolve this?
I am working with IIS 5.0 and would like use the property CentralBinaryLoggingEnabled which if set true will create one single binary log file in place of a separate log file for multiple websites.
This property is available in IIS 6.0. I would like to know if there is a patch available for IIS 5.0 which will create this property in IIS 5.0.
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 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
