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:
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.
I 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 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.
I am doing a drop down list for example list of countries... when i choose one i want it to refresh the page and add new label as another drop down list or input type text and so on till all the information is given then when i submit i want all the information to stored in a databse .... so plz if u know the way will u send me a small example between two drop down lists
and one more question i know that i am asking too much but i want to know "if i could choose in a page an item which has a price and it is hyperlinked to another page which is a form and when i fill it and submit it i want the name of this item which is not included in the form and also the price ... my question is could i do it or not ? and if i can will you show me how .... as i know i might put the name and the price of this item in a hidden input and then when the form is submitted i send it to the database ..
My application is written in .NET (C#) with the inline Edit mode from DataGrid. When a SAVE button is pressed it will perform a action on the database either to add, edit or delete data that a user has entered.
When the refresh button is pressed at the top of the page the same exact data is re-submitted again resulting duplicate transaction in the database. Is there anyway of stopping this happening? From client-side script, how can we detect that the "Refresh" button is click?
I have a page with 2 frames. The first one has a link that loads a page in the second frame. This page has a button on it. When the button is hit, the page does some processing and loads another page in the same frame (the second).
I use ASP and response.redirect or javascript in the onclick event of the button to do the redirection. When I refresh the page by clicking the button on the browser (IE), the second frame becomes empty. Please note that the src attribute of the frame is not set.
If I set the src attribute of the second frame to some asp page and then navigate to another page inside the same frame, when I refresh the page, the initial asp page is loaded in the frame regardless of the asp page currently loaded into the frame.
It seems that when you refresh the page, the frames are reinitialized no matter what pages are currently loaded in the frames.
I solved the problem by redirecting to the main page in the top frame, passing some parameters and resetting the src of the frame to the desired asp page. Thus, when the page is refreshed, all the frames are properly refreshed too.
I have an ASP site that uses frames two frames. (yes I should be using include files, but we started ou using frames so we have been stuck with frames.)
When I get a page expired warning (I am not caching pages) and a user clicks refresh from the menu bar the user is taken back to the home page! The home page is a frame with a top frame that is repeated on each subsequent asp pages
The lower half of the home page is a login screen.
After login the next page is shown in the lower half of the frame. Refreshing within the individual frames is ok.
But when the Refresh from the menu bar is used the home page is returned any ideas why?
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.
there is a JavaScript/ASP function that that will check for new Private Message (PM) Inbox. New PM will be referred as "NEW" in the status field in the database and "READ" for all the old PM.hen there is a new PM, a popup will appear in my page. But I have to press the REFRESH BUTTON before I get the popup ALERT! Can this be done in AJAX? (Alert me without refreshing the page?)
I Have a list of groups that are assigned to users. I want to list groups for a particular user in order by name. I want to then have a drop down list that shows all the groups that the user is not in at the moment. Users can then add groups to that user.
How i have it setup: I have a table that has an id and group name. I have another table that has id, userid and groupid Do anyone have any ideas how to diplay it. Keep in mine that the groups have to be in order of the group name. Thats tge part that is confussing me.
I am creating a resource website and pulling from an access databse, I have 1 page that loads with a list of catagories, when you click a catagory the page reloads with a querystring attached that loads only the contents of that catagory.
All of this is coming from the same table in the database, I have an ID column that is shared by the articles in the same catagory.. (i.e. ID is set to 1 for all the items in catagory 1, set to 2 for all in catagory 2 and so on).
I currently have articles in about 6 of 16 catagories. Everything displays fine but if you click on a catagory that has no articles, I would like a message to appear such as "There are no articles found for that catagory". How can I get the ASP script to see that there are no (we will say) entries for ID 8 in the databse, and display the message.
We're working on creating a site that tracks club sports results - we originally created a form that inserts the results into a database, but the folks using it have decided they'd rather enter the information in a spreadsheet and upload it.
what is the best practice for this data - should I write some code that just reads the content of the excel file and displays that on a results page or should I take their data and import it into the database we initially designed.
here is an RSS feed for top stories from a local news station. http://lex18.com/Global/category.as...&clienttype=rss.I need to display this data on my own website. I know ASP, but not XML.I have read some documentation and browsed websites, but I cannot figure it out.
I know this is probably a stupid question, however I'm trying to display the contents of a recordset into columns spanning across the page rather than down the page,
i.e.
CATEGORY CATEGORY2 subcat1 subcat1 ... subcat2
And so on. This is a 2 column table that I want to use. But I don't know how once one column is long enough then go across to the next column and fill that column with the remaining data. I know its simple if you have go down a page, but can't figure out to go across.
Someone asking me in the PM yesterday. How did I managed to display data in 3 cols & rows i.e category,sub-cat, search result and form in CSS table-less layout?
I have use it in my site article,freeware,recipe,link directory,lyrics,template and games section. I was able to display the data in 3 cols and rows using CSS layout. It took me quite a while to figured it out. In ASP, you should know where the loop start and end, otherwise the div container stack up each other. I was thinking of writing a tutorial with sample code in ASP. Maybe next time.
My next project is to convert Maxwebportal and snitzforum into CSS layout. To see an example, visit my site and go to this section of the site: article,freeware,recipe,link directory,lyrics,template and games. These pages are CSS table-less layout.
I 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.
I 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.
how do i get data from a user on one page and display the result on the other page actually i have written a prgoram that displays a set of checkboxes and based on the checkboxes selected the related data is displayed .but the problem is the data is displayed on the same page below the list of check boxes. Code:
I want to display a system maintenance notification on my webpage using a splash screen. I got the code for splash screen from Dynamic Drive and added it on my web page. Now here is my problem. I have created a table in my SQL database with these two fields, Flag and Description. I am trying to connect this splash screen to this table.
This is because-if the flag is set to 1 the splash screen will pop up and display the data in the description field on the splash screen and if it is set 0 the screen will not pop-up at all. Two things I am having trouble with-
1. Displaying the data on the splash screen. I made the connection to my db but can't get it to display it on my splash screen.
2. How to make the splash screen pop-up only if the Flag field is set to 1.
Write an exe/dll (which will be better please tell me)..which has code to only control my logic or rather data conversion/manipulation of the raw data recieved thru and .mdb file and then display the exe/dll manipulated data thru an asp page.??
I have a page that shows the skillsets our analysts are on here. We have 10 skills, each one a different recordset to pull their data, so the page takes a while to load (7 seconds). What I was wondering if its possible to do is just show the heading (the name of each skillset), but when clicked on, a response.write of somesort would show the cell underneath and then pull the data. Hopefully it makes sense what I am saying, if not i'll try to post something up.
How i display DATA from Browser to Text file.In my web page there is a script that fatches data from this URL: http://www.rediff.com/rss/newsrss.xml and display data on the web browser.now ,how i get that displayed data from the browser to a text file.
I would like to know if you can display only certain data into a field between commas or any other symbol without using the curshort feature. For example. I have the following.
Part, A3472, Desc: Controller: Price$ 45.00
I just need this out of it in a single form field.
A3472
I cannot use the cutshort feature because my part numbers are different lengths.
If i created three different type of table. Inside these tables, they might have the same key field's name. Example:
Table A - ExecNo, Month, Year, CustCode Table B - ExecNo, Month Year, DestCode
as u can see that these two tables have almost the same key field but they r actually keeping different data. how can i list these different data out in an asp page? it is because i am having the problem whereby.
where the table want to display data from table B, it actually misplace by table A . how can i write the sql function to differentiate both of them.