I have an Access database containing 10 Tables with a lot data in each Table. I need to copy the database with no data in another directory. Is there an ASP code or object that allows me to clear data in all Table at once? How can I clear all data from Access DB?
I have a website that would set two cookies when a user logs in successfully.
<% response.cookies("login_status")="OK" response.cookies("login_id")="12345"'This value is from database. response.cookies("login_id").domain="mysitexyz.com" %>
and I have a question in "removing/deleting/cleaning the cookie when the user logs out.
From my understanding there are two methods -
#1 (I am currently using) response.cookies("login_status")="" response.cookies("login_id")=""
My questions is, what's the difference, advantage and disadvantage of these two methods?
I am asking this because I have noticed that there are some problems in #1. In my computer (I use IE7) if I login as one user, logout, and then login as another user, the cookie value will get mixed up. Somehow the response.cookies("login_status") can display correctly but response.cookies("login_id") cannot. But if I clean my browser cache, close my IE and reopen it, both cookies work fine.
When I submit information i post it to a page and when it’s reloaded it runs as code accordingly if I refresh it re runs the asp because the information is still posted. How do I clear the posted information? Or possibly after it runs the asp code alter a value in the posted information.
i have a form with a textarea(the value is taken out from the database) i would like to know if it is possible to erase contents in that file and not delete it using asp or javascript? or is there a way to select all the text in that textarrea and clear it?
How do i clear a page of boxes and only allow the last response.write to show? And is there a way to allow the page to show for a while the response.write and then bring it to another page by a certain timing?
Is there a way that i can force a drop of all connections to a database. My problem is Access keeps locking my database, i have multiple users using this database, at different periods of the day, and i need a way to clear all connections, i.e at set points throughout the day or at request.
I do close the connection and set all record sets to nothing not sure what else i am missing?
I have a form submission page that I am using some session variables that are created on the page in order to keep track of the information that they have already inputted - so when they click submit if there are any errors the fields that are correct remain populated.However, I am wondering is there a way that if they navigate away from this one page all the session variables that are created are removed so if they come back to the page they need to re-enter the information?
Something like "on page exit - remove session("name")..." ?
I am worried of accumulated old cart product selections from expired browser windows or other unforseen events. I am holding selected productID's & quantities & userID & sessionID in a sql table from a shopping cart.
I allow user to clear their cart from a button and also automatically clear their cart on user logon. Also on checkout I clear their cart. I am storing selections with sessionID & UserID so they will be unique,. But does anyone reccomend any other cart selection maintenance procedure i could use,.
The back button that appears on every browser has a list that allows moving back to a specific page quickly, I'm sure you all know the one I mean. Is there a means of clearing said list? perhaps some DHTML method or the like?
I have an image gallery in a database and I display one item at random with each refresh. I also have 2 buttons "next" and "previous" to show next or previous items in my recordset. Everything works well except for the fact that once the user has used either "next" or "previous" it leaves my query string in the url bar: index.asp?action=previous therefore, if I click "refresh" it continues to display either the next or previous entries instead of dislaying at random like it should.
How can I clear the query string from the url if the commend comes from the refresh button?
Is there any method to clear a form collection after a post without have to do a response.redirect? I am trying to avoid having the form re-submitted a second time on a page refresh.
I am trying to get a thorough understanding of a code where a addition or deletion of records can be done from a list of records. For addition part of the form, data is being obtained from set of input boxes. Code:
This is my query.i have a access database, hooked up to dreamweaver mx. inside the database are 3 tables. sun/moons/planets. the planets table is linked to the moons table. In the planets table are the fields: planet name; Text_1; Text_2; planetID; Distance; Pic_1; Pic_2; What i wish to do is from my index.asp page click on a link which then displays the planet and EITHER text_1 or Text_2, and seperately Pic_1 or Pic_2.
I have tried using random nos 1 or 2 but i dont know how to pull the number and access the right table/field
i want to display DATA stored in Access DB by using ASP script.i can read data from access so that task is only to display data is a list like.i have a record of some users and i just want to display the users name in a list.how can i do this.
i am working on a interanet application for Inventory handling, i have a problem while submitting the data to server, the problem goes like this
Data base : Ms-Access Front End : ASP
how to comit the data "say Invoice" to main database is two persons tries to make invoice at same time at different computers, How to maintain the series of Invoice unaffected, how to allocat Invoice number to them, and how to put a check that both of them can't make a invoice of same customer at a same time at different computers.
i am wondering if there's oledb provider for DB2? and where can i get it ? we use asp, not asp.net , therefore we can't install .NET framework , is there any other solution ?
Im trying to write some asp code to copy MS Access Data into an Oracle database. I have one connection open to the access database but when I try and open the oracle connection it says that the ms access tables does not exist.
Basically what Im trying to do is get the data from a row in the Access db and insert it into a row in an oracle db.
I am using winXP pro + IIS5.1 to develop my site offline.
My data is in a folder outside the web, and I am told "my IUSR account needs to have read/write/modify NTFS permissions to the directory housing the file"
I can find no info on how actually to do this. Can anyone explain?
I'm attempting a login script where I first authenticate a user's login info for a valid connection. When I use a valid ID/Password everything works. When I use a bad user/password I get an error page stating the login failed.
I would prefer to redirect the user to another page on a failed login. This is the part that doesn't work. I'm new to ASP and JavaScript, but have done this kind of thing with PHP with no problems.
I'm using Dreamweaver MX with ASP VBScript and using a MS Access Database. For about the longest time now, I've been trying to make a Mailing List form online and when you submit the data, [data] goes into the Access Database.
The Form is obviously working fine, although sometimes I do get errors, I'm mainly trying to get this data skullduggery working. Is that even possible (with ASP even)? I have to use ASP and I can't use SQL (because I would), but I think my n00b self has tried everything I could think of. Code:
I have an access database with about 5 tables. One of which i want to populate data to. Specially 1000 enties at one time(In this example im adding employee numbers to a database table. Initially i want to add the for the employee name field " Unassigned" and when i ready to append a real employee name to the fields add if through a script(Can this be done?
Or is there a better way to do this?)This way, in my script i can call one of of those 1000 entries or employee numbers from a dropdowlist (ex. 1-1000). This way if go to use one of those entries from the dropdownlist the database would not get the " EOF/BOF error ". What logical suggestions do you guys have ?