I have a two dropdown lists (Job Catogory and Sub Job Catagory). The values are populated from the database in the following manner, when a user chooses a particular job catagory from the Job Catagory list, the corrosponding sub job catagories are populated into the Sub Job Catagory list. I am using asp as the server side script and sql server as the database. Now whats happening is that when a user chooses a particular job catagory, the form reloads and thn only the sub job catagory list is populated. Is there anyway that this can by done without reloading the page. Probable using a combination of asp and javascript
I posted the same problem in XML forum as someone told me that this can be done through it.
I am creating a site with ASP. I have a master page with a flash object before the runat server form and every time I click a link (asp:menuitem) to change a contentplaceholder, the flash object refreshes and does its start-up animation. Is there anyway to stop this? Or is that more of a Flash question.
I have a web page where i have given links called add to favourites. So in case of user click that will be added to that favourite items in the database.
there are 3 ways to do as far as i know, 1. submitting the page passing that code as url value and reloading that page again.(not user freindly )
2. pop up a window with that url value and then do the db part in that pop up window page (if pop up blocker is there in the IE then that page wont have chance to do that operation)
3. using a 0 width i frame page..
I just heard about the 3 rd option but dont know how to do that part.
I've been searching the forums for a bit of code (maybe Javascript) that will help me populate a select list using a variable pulled from another select list without refreshing the entire page.
I need to pull the values in the second select list from a database based on search criteria from the first select list. I don't know how to get past the stateless nature of HTML. I'm developing this app using javascript and php for extremely low-bandwidth users and I'm stumped on this one.
I am trying to add record to the database (Ms Access) from a ASP page, which is the easy part. Now I am faced with a simple but hard to me problem. I've a select menu where user can pick multiple value, but when there's a option is not there I was user to be able enter a new option vale and select it.
right now I am redirecting them to a page where by they can add but in process I am lossing the information they entred before hand in other fields.
what I like to do is: from the page where user enter info be able to put a pop-up window then ask them for info and copy the info and add to the option box for selection without reloading the page. is this possible?
I have a page that allow user to update their contents of their address book.
When users click on a button on the page, a new window will pop-out with all the address book contacts. User will select one of the option and i will retrieve the values on put them into the main page without re-loading the page.
To achieve the above effect, is it better to combine a) ASP with Java Script or b) ASP with VBScript
I just created a page that checks logon credentials before it loads the page.
The problem is that when I left the program and came back, it loaded the page that was cached without doing the login check. As soon as I refreshed the page, it did the logon check.
Is there a way at the top of my asp (asp.net and html) to tell it to refresh certain pages, no matter what?
im running an asp page where by i can upload a xls file- which adds data to a database provided it passed validation. this then sends a success message to the user. what i need is a button where i can call the data which was recently added into the database- but dont know how to go about it or code.
I'm wondering for a way to reload my included page (with a few recordsets) from time to time and display and alert for a trigger limit (based on recordset results)..
I tried to reload it using js, but in that case it reloads the whole page and not only the included file...
<script type="text/javascript"> function page_reload(){
window.location.reload() } function page_reload() { var t=setTimeout("page_reload(),30000) } </script>
I have a page that displays results of a database query that is paged to 5 records per page and i have some very messy code for the navigation.
Firstly i have a "First/Previous/Next/Last" navigation set then i have direct page numbering which is limited to 10 pages and as you move through the pages the page numbers change depending where you are in the page set.
If that makes any sense.
i.e. if you are on pages 1 to 5 it shows pages 1 to 10, if you then go to page 10 it shows pages 5 to 14 etc.
This all seems to work quite well, not sure how but it dose.
What i am having problems with is the URL's the links point to as the page can have various parameters. the URL always calls the same ASP page but the parameters can be different.
example:
Page.asp (default page) page.asp?page=5 (default but on page 5) page.asp?user=userID&page=5 (page with specific user and on page 5)
at the moment there is only the user parameter apart from the pages but this could change.
I need to be able to build the URL's for the links dynamically so it includes all previous parameters from the existing page but then changes the page number when navigating through the pages.
Anyone got a good solution to this one, i keep hitting a snag with the parameter separator whether to use ? or &.
Command text was not set for the command object. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OleDb.OleDbException: Command text was not set for the command object. Code:
I am unable to access an Access database through a webpage I built, but only if the database is on a server running Windows NT 4.0 Server. If I copy the database to a pc using NT Workstation then there is no problem. I have a user account set up on the sever as IUSR_pcname. It is a domain user with full privileges. This is the connection code:
I developed an ASP page which has 2 input fields- First Name and Last Name.I used Access 2002 as database. Once I click the Submit button,
it has to perform 3 tasks----- 1) It has to update the First Name and Last Name in the MS-Access database in their corresponding fields. 2) It has to go to the Home Page(which I already did) 3) It has to update the date/time in the "Time" field in the MS-Access database.
The following is the code I wrote to connect to the database and update the fields in the Access table---
<% set MyConn = Server.CreateObject("ADODB.Connection") set rs = Server.CreateObject("ADODB.RecordSet") MyConn.Open "driver={Microsoft Access Driver
(*.mdb)};;DBQ=c:/documents and
settings/adcguest/desktop/webpage_html ewsecurity.mdb;" rs.Open sqlqry,MyConn,2,2 rs.AddNew rs("firstname") = first name rs("lastname") = last name rs.update
rs.close myconn.close %>
Can somebody please help me in figuringout if I am missing something.
Dim id If (id = "") then id = Request.QueryString("id") End If If (id = "") then id = 1 End If
I use a QueryString request function, so when an id is called, that page loads into the current one. This is perfect, however if say the user directly types a link into the url, like index.asp?id=999, then basically the code is flawed, it breaks up.
Secondly if say a page has been erased from the database, and the link still is available, the code is equally flawed, so it would be good to have a page in my id, say id=50 that displays a page with data from the database, explaining that the page you are trying to reach did not exist or no longer exists, because so far, I get a page error:
ADODB.Field (0x800A0BCD) Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. /mjhw/functions/functions2.asp, line 21
I have created a asp project local.and have created a access database local. Iam trying to use the access database from the asp page. But It is not accessing the database file.
once i changed the rights of the access file and checked it.It inserted the records.And after some time, iam not able to access it.some times it accesses and some times it doesnt.
I have a question on DB Connection. My ASP requires me to create 2 DB connections to 2 different database.
2004.mdb & Information.mdb. In this 2004.mdb, I have 12 tables(tbl1,tbl2...tbl12).
And in Information.mdb, I have a table called t_information. This table houses all the names of tables from 2004.mdb.
In my ASP page, there is a drop down list. As you can guess, this drop down list retrieves the values from table t_information that resides in Information.mdb.
When I select the table that I want to display & click the submit button, I will have to create connection to this 2004.mdb that has all the tables(tbl1..tbl12) and display the selected table. Am I right? So, to achieve the displaying of the selected data, I have to create connection to both 2004.mdb & Information.mdb right? Is that possible? I mean, can I really create/establish these 2 database connections on the same ASP page?
I really need advices on this people. Do hope to see replies here. And I understand that we can TableDef in Access? Can anyone explain to me what does TableDef do? And how to go about creating it?
I can display information to a webpage from a database and handle the connections etc. My next task is a bit more complicated for myelf. Id like to have a page the pulls information from a record set and displays like this.
down one side
the container numbers
along the top
the products in the containers
the information in the middle would be the amount of product that came on that container.
Im just wondering how the best way to setup my database would be, and the best way to setup the asp webpage. (oh) nearly forgot, it has to repeat the information till all the records are finished but i guess that gos without saying.
I wrote a script to compact my access databases from my admin section. Everything is working except I get this error:
Provider error '80040e4d'
Authentication failed.
Is their some reason the JRO.JetEngine needs authentication? I don't have direct access to this server and was wondering how to get around this problem or how to fix it. It fails when this link is run:
None of the databases have a username or password. Would I have to have the host company setup an account for this action to take place? And why could I do everything except compact the database? Is their a vulnerability issue when accessing this function?
i wanna connect front page forms with the database for searching and updation .. how can i do it.. in asp it ask to host the web it doesn't works on disk drive..any one help to solve this proplem..any alternative
how to stop sending data to the database when refreshing the page,i use access database with asp,all the time that i refresh the page same data goes to the database again and again
i have 25 data in the database, each of this data i will assigned them to be displayed in an 5*5 table(asp page), that means, each data assigned to one cell in my table.
but if the data inside the database is not 25, thats means in my timetable, there will be one cell thet is empty and this page cannot be view since i am trying to displays an empty database!
i am updating client's table(i.e insert one new client) from one asp page and after that it is being redirected to html page on that page i have one link which selects records from client's table and then displays it in the form of list. The problem is that when a new client is added it is not shown in the list. If anyone can please guide me on how to refresh the asp page after every database updates.
I show information from a database in a table format. I will be showing more and more data and would like to show it one page at a time with a next page back page option. Can I do this on a web page and does anyone know where I could look to find out how
strSQL="SELECT * FROM MyTable;" rsSet.Open strSQL, adoCon ...do some stuff... rsSet.Close adoCon.Close
Set rsSet=Nothing Set adoCon=Nothing
I have a couple queries stored in the database that I use when in MS Access. Can I call these queries instead of using a string to specify the SQL command?
The above seems kind of verbose for making use of a database. Can it be simplified at all?
Unless you declared those session variables earlier, they have no data in them. Assuming this information is coming from a form, try using request.form("fieldname") instead of the session variables.
If this doesn't address your problem, give more detail about what "isn't working"
There's an access database on an iisserver and asp makes updates to it. The database got moved to a newer server. The users used to be able to open the database and use the asp pages at the same time. Now when the database is open the asp pages won't update.
I would like to know that ,is there any way that the asp page would get refreshed automatically when there is an update in a tbale in SQL Server. The page should get refresh automatically on updates in SQL Server. The user will not hit refresh button neither I want the page to have meta-refresh tag.
I have a bunch of .dbf files stored in a folder called dbf. My index.asp page is one level above that (let's call it the root). My asp page uses the following function to retrieve all of the .dbf files: ....
what I want to make actually is to take the results of a search engine that I use, which are in form of HTML or ASP and transport that results in a DataBase. For example, I wont to place as registrations in the DataBase the equivalents URLs and their descriptions from the results of search. I use MS Access, code asp, HTML , Javascript .
QUESTION! How can I insert the content from an HTML or ASP page into a dataBase? How can I determine from what point to what point a string it will be entered in the first cell of table and afterwards in the next and next ....
