i am working with asp 3.0.whenever i enter new data and want to view the data. i can,t view latest data(it shoows the page last visited), i have to refresh the page , then i can view the latest updated records from database.
View RepliesI am using a ASP page(User_Account.asp) to create username and password & updating the info into the database through another ASP page(User_Account_Upload.asp).
The problem I am facing is that, at random instances the data gets duplicated. I tried to check if the user Id exixts in the database before updating. After implementing this logic, whenever I create a new user, if the ASP page tries to store the username for the 2nd time, it generates an error message that the user_id exists and doesn't update the database. However, this error message is displayed on the screen even though the user_id was created for the 1st time ....
I figured out how to display data from an Access mdb file using ASP, but my database is continually being updated in real time. The only way for the end user to get the most current data is they have to refresh, or I have to code the html to refresh like every minute, which is really cumbersome, and bloats the logs. Code:
View Replies View RelatedI have a asp code that shows the values from a database. But here it shows all the values in one page. I want to make each record appear in a new page. How can i do it. Code:
View Replies View RelatedI have a datbase (db2.mdb) on the server
Here is the information:
DB name-Addresses
Input - user
Input - password
Here is the script that I'm using to try to view, unsuccessfully, the user in this database. Does anyone see the error? Code:
I'm looking for some advice in creating a page to allow me to view the data stored in am access database. I want to be able to see all of the saved records. Is there a simple way to do this?
I did recently create a page to put the data in this database. I'm proud of this. I still haven't grasped with all my reading, etc. the function of all the code.
i often to make a user interface in access for data entry using Grid view. is there a possibility to make Data Entry user interface using Grid in ASP?
View Replies View RelatedI keep getting an error that says:
Error Type:
Microsoft JET Database Engine (0x80004005)
The Microsoft Jet database engine cannot open the file 'c:inetpubwwwrootannoneil\_databaseannoneil_AN D.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
/annoneil/artist.asp, line 96
The code was working fine a few days ago but now I cannot figure this out.
I m developing a site n creating a enable/disable page. In this page when I enabled a user then in DB field user enable once n value is entered "Y" but when I updated user field n I disabled then DB is not update plz help me friends.
View Replies View RelatedI am using an Insert command in my asp code that Inserts a rows in my database. After the Insert command i create a recordset and ask for all the rows in the table that i aplied the insert command Some times the rows i get are correct but sometimes the database is not updated by the time the recordset is opened.
Is there any way to wait until the table is updated with the new rows and then open the
recordset? ...
my work lended me a book, Active Server Pages 3.0 for Beginners by WROX.So far its been pretty good, but here is the bummer,its kinda old. Since I am new to ASP, am I better off just sticking with this book and getting through it, or do any of you recommend one that is more "updated" or such and could be just as beneficial? This thing was reprinted in 2000.
View Replies View RelatedI use a popup window to add a record to a database that is displayed on the webpage. How do I trigger the parent page to refresh from the popup?This could either be a hyperlink or to happen upon closure of the popup.
View Replies View RelatedDoes anybody have code to add a "Database Last Updated...." line on your webpages that are generated from an MDB? There is simple ASP and javascript for 'page last updated', but the code that I have found just detects the time when the page was generated, which is every time the page loads since it is querying the database.
Im looking for code that queries when the database was last updated, then displays that info on the page.
I'm trying to create an XML guestbook. I'm using a form for the user to input his name, e-mail, message etc. an .asp file to update the xml file and an .htm file with javascript to display the xml file. The .asp file contains a <meta> tag to redirect the user from the .asp file to the guestbook.htm file. Following the submission of the form the script in the .asp file runs fine and updates the xml file but the problem is that when the xml file is accessed by guestbook.htm in appears to be accesing a cached version. For it to display the latest entry i need to access the xml file directly (http://....../guestbook.xml), refresh it and then return to the .htm file.
View Replies View RelatedI'm unable to update a session variable
btween pages. I can read them after I set in global.asa
and I can change its value within the same script but when
I go to another page, the session variable remains
unchanged.
I think this should be simple but cannot find it:
I use a update query like
sSQL = "UPDATE PLAATSEN SET PROVINCIE='1' WHERE PROVINCIE='Noord-Brabant'"
ADORSEXECUTE(sSQL)
2 things I want to do, check if query is success and display message with number of changed records. How can I do this?
I have a SQL database with a ASP frontend. I can update my record without a problem. What I am looking to do is update the record by pressing the submit button and when the record is updated display on the same page that the record was successfully updated. When I update my record now, I have it where it redirects me to a different page. I would like the message to appear on the same page.
View Replies View RelatedI'm using VBScript to display a list of the ten most recently updated
pages on my web site. Right now, the script lists the filenames and
the date modified in a given directory.
What I want to know is if there is any way to extract the page title
and display that instead of the file name? Can I use .asp and VBscript
to "delve" into the file and extract the title? Code:
I've got IIS installed and running on Win 2000 Professional. However it
seems that I cannot view asp code. To test I've used the good old "Hello
world" example.
When run through localhost I'm met with page cannot be displayed.
When run through c:inetpubwwwroot, I'm met with a blank page yet I can
view the text in HTML.
I've checked my properties for home directory and I've got TCP port 80,
execute permissions as script only and application protection as
medium(pooled).
The local path address is correct and its set to Read, Log visits and Index
this resource.
I have a registered user that buys a product online. The user supplies his/her email during the order also for verification purposes.
What I want to do as an Administrator is to be able to see that users first name and surname on my "Completed Orders" page (which dynamically refreshed every time a new order is made) using the email to get them from the database.
Code: .....
i had created an asp file and want to upload it to the server...however, when i uploaded
the file..the file cannot be viewed through internet...why?do i need to set anything at the server?
I recently upgraded my PC from Windows XP Home to XP
Professional, so that I can use XP Pro's build in IIS
functionality to build ASP pages off of my home PC. I
have installed IIS 5.1, configured it and tried several
other things (restarting the server, configuring a web
project, etc.).
When I attempt to view the page using
the project name and computer name (in this case, it
would be http://apollo/twinadev/), the status bar shows
that IE is attempting to connect to the page, but after a
long timeout period, I finally receive a Page Cannot Be
Displayed Error.
I actually want tree view which can dynamically display
all the child nodes(undifinte) dynamically.
I have a soccer database I am working on. My boys play once a week. I would like to have a way to query past games meaning the one they play the week before. So another words we played this sunday score was 1 -0, on my home page with my query I would like it to show 1 - 0 against so and so. Next week when we play again, I want the next team we played then to show up on the home page. So in essance the most recent game played to be displayed. In data base i Have a table called schedule, in that schedule I have a field called GameDate which defines the day of the game. How would I create a query that would pull all recent games played up until the next game day.
View Replies View Relatedyet my colleague can? (when looking at exactly the same page - same destination folder etc)
Is there some sort of setting, so that you dont only see those small yellow ASP blocks when looking at the design view, and see the layout of the page , with the tables etc?
I realise that most of you gurus dont use the design view at all, but it is something that using ASP,
How can we disable the browser to view the code..
i faced this question in interview..
what would be answer for this
I have designed a page that list department projects. I have decided to add sub projects to main projects that are listed. I would like to be able to view the sub projects on the main page where all of the main projects are listed. I would like it to look like something in Access when you have sub records that are related to a main record.
In Access you click on the + sign and it opens up the related records and then you can click on the - to close them. Even something like is on this page up at the top where it has the main folder (ASP Free Forums) with a sub folder connected to it. (Post New Thread) Something like that would be perfect.
I am able to show the associated sub projects when I click on a detail button that isolates that record, but I can't think of how I would do this on the main page with several records. Any ideas how I could do this or examples of where I can find some similar code that will accomplish this? I'm not even what sure as to what key words to type into Google.
I expect this has been covered before but I can't anything to reflect this. How (with code) can you view folders within a directory from within a drop down menu?
View Replies View RelatedI installed iis and wrote a simple script.I get a password protected pop up when I access:
localhost/tests/tests.asp
I want to add record in my form. Previously i can only add 1 record and click on Add button to add 2nd record. Is it possible for me to directly add 2nd record? So i will have 2 options here, view the list and add 2nd record or directly add 2nd record.
View Replies View Relatedi had created an .asp file for my website.however, it cannot be viewed using internet but through local computer, it can be viewed. the address http://www.perak.uitm.edu.my --> click on ''pengurusan atasan''link under UiTM Perak menu. tq.
View Replies View Relatedafter a member log in and he is redirected to the memberpage.as and there are a link to view his profile or details which is in the database in members table.
how can i view his details and he can make changes to it??? how many pages i have to do ? and the page which has his details should it be html with a form or should be asp page?
I have 2 tables, one has id, fname, lname, and the other has id, amount. I need to create a view to sumarize the total amount of each person, what's wrong with this:
create view myView (id, firstname, lastname, totalamount) as select d.id, firstname, lastname, sum(amount) as totalamount from mtcdata d, mtcbilling b where b.id=d.id