Data Access With JavaScript
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.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Asp+access Data
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
Access Data
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.
Access Data
i want 2 asked 2 howwe can acces the data from database using combo box.and how we can save the data to the database from combo box.
Data Access Permissions
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?
Can't View Data In Access DB
I 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:
Data From ASP Web To Access Database
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:
Populating Data With Asp And Access
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 ?
Cannot Show Up Data From Access
My code show no error but the record cannot appear. My code = if request("tarikh") = "" then tarikh = Date() else tarikh = request("tarikh") if isdate(tarikh) = false then ralat = "Sila masukkan tarikh dalam format dd/mm/yyyy" tarikh = Date() end if end if sql = "select * from audit_trail where cstr(tarikhlogin) = '"&tarikh &"' order by masalogin desc" set rs = conn.execute(sql) response.write sql = select * from audit_trail where cstr(tarikhlogin) = '04/02/2005' order by masalogin desc Storing record have no problem but this code cant display any data.
How Can I Clear All Data From Access DB?
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?
Entering Data Into Access.
I am having a problem with entering long ammounts of information (roughly 400 characters) into a database. The database field is set to memo. Seems that whenever I want to enter strange characters it gives me an error. (I need to enter strange characters for an important reason). Also I am having some problems with using ASP on Netscape (not testing...just clients are having problems). Does anybody have an idea of whats going on??
Retrieve Data From MS Access
I am trying to retrieve some data from a table which is the link table from another Ms Access database of my network computer but i got a error message "It is already opened exclusively by another user, or you need permission to view its data."
Access Data Base
a website connected to access database, i have a table which contains the names of all ppl members and users, users table. if someone can help me in giving me the code of a login page .. how it can check if the password and username are correct, i had already entered information of few users for testing. by the way i dont use java messages, i have to give a message wich will be shown in a new page and the user should press back button to retain to the login page.
Access Data To Excel Using Asp
I have an intranet application written in asp using access as the backend database. My users have requested they be able to download certain data into an excel spreadsheet. I have limited asp experience and could use some help. Ideally, the user would be prompted to save and name the file (save as dialogue) and then the data would be selected and saved into that file. I know I can use a select statement to select data directly into an excelspreadsheet using: SELECT * INTO [Excel 8.0;Database=" & lcPathFile & "].[Sheet1] FROM myTable But I'm not sure that is the right approach.
Limiting Data Access
I have 40 different users. Each user manages a subset of the total database. Currently I have a pull-down menu to let the user select their subset and then manage the data within it. I'd like to use their login info to pre-select the subset so that they have access only to their assigned areas. How do I "send" the subset name from one asp page to another? the db is "2004" the table is "Students" .
Data Not Saving In MS Access
I have an MS Access database within the same folder as the web pages on my IIS server. I input data into the forms but the data isn't being saved to Access. Is there a problem with this code?
Migrating Data (MS Access)
if i have 2 datasources with different table names and column headers that i want to merge i.e. "ptitle" and "name" whats the best way of doing this? are there any standard routines or should i use something intermediary like xml?
Input Data In Access Db
I think u don't seem to understand my question. I'm not talking about ur coding. what do type in the url address to open ur htm page? is it D:messageform.htm or something using http:// ?
Retrive Data From Ms Access
i am designing a database using Ms Access and ASP. i have 3 tables in access namely 'PERSONAL', other as 'POLICY' and 3rd one is named as 'STAFF'. in the contact table i have ID, Name, Children as fields. Also in policy table the firlds are:- ID, date_of_policy, no_policy, amount_paid, amount_balance and similarly the 3rd ie., staff has few fields. all three are linked my a common field which is ID all i want is when the user searches for a perticular name (from frontend) it should search through table- 'PERSONAL' (fields- Name and Children). once it get the perticular name with the help of the ID it should retrive the datafrom both 'POLICY' and 'STAFF' of that perticular Name. i do know how to search and retrive data from the same table but got a bit confused on how to retrive data from different tables using the 'PERSONAL' table just for reference and linking to the other 2 tables.
Data Into A Access Table
I have coded a form which enters data into a access table however I want the same recordset when clicked to go to another table in the same database then when clicked again to go to another table within that database...is this possible?
Access Data Base
This error occured with me when i want to open my access database: ---------------------------------- Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x888 Thread 0x1288 DBC 0x2e8f014 Jet'. /AAA/Afghanistan.asp, line 374 ----------------------------------
Hiding Paths In ASP To Data In MS Access
Does someone have a reasonable method for concealing the paths to data when using ASP to MS Access? I maintain a website where some data is intended to be released according to date:time. Some visitors like to "jump the release date" and just copy-n-paste the visible short cuts so they can get an early view of the material stored in a MS Access database. Because I do want to continue using a straightforward naming convention for the various files, I was hoping someone might have information on how they had kept from pre-releasing information in this situation.
Inserting Data/time To An Access Db
i have an access db with a "date/time" data type with a format of "Long format"; i want to add the date/time automatically in DB when a user submit a form. i tried using the xdate = formatdatetime("var",1) and putting that var in the DB, but i get an error can someone show me how to do it right?
Data Type Relation Between SQL/ASP And Access
I am trying to insert data from one table to another but it always errors me on type mis matches or parameters. Basically the SQL statement looks like this: sql6 = "Insert Into tblWeeklyFixtures_Div3 Select * From tblAllFixtures_div3 Where GameDate > date() <=date()+7" conn.execute(sql6) and it gives me error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. /DIGFootball/Admin/FriDiv3/update2.asp, line 142] I tihnk it has to be that i havent declared that i will be importing into a Date/Time field in access but when i change this in acess it gives me more errors so for a peacful life i chnaged the field back to text but by doing this the above SQL statement is pretty useless.
Data Loads Slowly From Access...
I am using a script for my site's songs, Forexample Song is: ASP Song And Artist is: SitePoint It shows the songs data in the form of: <td height="-1" bgcolor="<%=co%>" class="t"> <a href="player.asp?song=<%=rs("song")%>&artist=<%=rs("artist")%></a> by <%=rs("Artist")%> </td> It produces like : "ASP song by SitePoint" on songs.asp But the problem is I have 62 songs, And they takes a lot of time to load, Is there any other way to call the song details from the database and it will load fast ?
Access Data Retrieval And Creation
Already have an asp page showing results from an access database table (supplies) Need to know way select items from this list w/o the need of retyping to another form. Also would like to be able to insert order_date automatically to another access table (orders).
Pulling Data From Access Database
I have an access database from which I am pulling records. The main table contains all the info for a specific person and their business. I am retrieving the data and sorting based on last name, and I am also retrieving and sorting the data based on the specific region a person is in. What I would like to do is also sort based on a sector that a person’s business is a part of. I would be able to retrieve all the records for each sector and sort them just as I did with region, but I don’t want to list ALL the sub-sectors. Code:
Trouble Displaying Access Data
I have a drop down list which pulls Names from a column called 'Name' from an SQL Server view. In this view is another column called 'ref' and each person has their own unique ref no. I have linked a drop down list to the Name column (so user can pick name from the list) but now after selecting a particular name, I want my page to also display the corresponding ref for that particular name underneath. The ref can be displayed just as text on the page.
Error Accessing MDB, But Can't Access The Data?
I have uploaded a few ASP scripts that that a friend wrote and that work well. The scripts connect to an Access MDB db on my windows host server. I often need to make changes to the Access db by adding certain new entries etc, so... the way I do this is; I grab a copy of the mdb off my server I add the records to the MDB on my laptop I then re-upload the MDB to the db/ dir on my server However... I then get the following message: Code:
Adding Reg Form Data To MS Access DB
I am trying to test a form at home which is for registration purposes. I dont have a server connection yet. Im wondering if it is possible to check whether the form is working offline or whether my code just isnt working! ? I should also say that my html files, asp files and database are in the same folder. Code:
Data Access Vista/IIS&/Access2000
Have just installed IIS7 on Vista and am trying to access a .mdb file through ASP. Getting server error. I think the problem is in the file permission. Under XP Pro/IIS6 is used to have to set the .mdb file security via windows explorer to give IUSR_machinename full permissions on this file for anonymous web access. Cant seem to do this with Vista explorer - says object cannot be found. Also, getting conflicting statements from IIS Help - it tells me firstly that a. By default, IIS 7.0 uses IUSR as the account for anonymous access. This account is created when you install IIS 7.0. and then b. Similarly, a new Windows built-in account named IUSRS replaces the local IUSR_MachineName anonymous account from IIS 6.0. Anyway, whatever syntax I use, I cant seem to add anonymous web user permission to daters.mdb via the security tab in Windown Explorer.
Selecting Data With Autonumber In Access...
I have a line of code in my script that looks like this: Set User = objDBCon.Execute("SELECT * FROM tblsUsers WHERE ID = '" & request.form("user") & "'") This gives me an error of data type not the same. Anyone know what the problem might be?
Displaying Data From Access Table
I am calling the values from a table and displaying them in a table, no biggie, i have not used a for loop to create the Html table, rather i have created it myself using a for loop so i can specify the table values i want. What i am calling from the table is All of the fixtures for the football games in a season but i want to put a seperator or insert a spece of some sort just to seperate the fixtures by date otherwise it just comes out in a long list of fixtures, no nice on the eyes. here is the code from selecting the data form the table to displaying it:
Pass Data To MS Access Database
I'm new to this and I'm trying to take data collected from this nice form I created, and pass it to a MS Access database. To simplify my learning, I created a database name test.mdb. It has one table, customers. The table has 3 fields, name, address, and phone. There are 3 form fields that have the same names as the table field names.
Access And Join Data From 2 Sources
I need to use data from multiple tables that are located in 2 different databases. Most of the tables are in SQL Server 2000 but 1 one the tables I need to include in my query resides in an Access2002 mdb file. I need to do this via ASP/ADO on IIS5. How do I combine (join in a query) tables from different databases? they are each opened from a different connection object? I have only had to access tables from one source before and I used the recordset.Open "sql statement", connectionObjectVariable syntax. Can I this even be done?
Calculating Totals With Data From Access
I have done a fair amount of coding but very little in the way of maths type stuff <code> While Not objRSC.EOF Response.Write "<tr><td>" Response.Write objRSc("Item_Quantity") & "</td><td>" Response.Write objRSc("Stock_item") & "</td><td>" Response.Write objRSc("Stock_description") & "</td><td>" Response.Write objRSc("Item_Price") & "</td></tr>" objRSc.MoveNext Wend </code> What I now want to do is to add all the Item_Prices together, .
Data From MS Access 2000 Into XML File
what I want to be able to do it take data from one of my Access 2000 queries and automatically export that to an XML file. then that XML file is going to be loaded with Google Maps API for use. What options do I have in exporting the data in access automatically? would it be just implemented everytime i call the function, lets say an ASP page? to give a little more (hopefully helpful) information, I want users to go to my site which has the Google Maps API implemented, and it will show them the rainfall and lake level data in my area. I figured XML would be best as I have seen someone implement a similar design in Canada using an XML file, however, I need to be able to get the information from the query in Access so it can be loaded onto the map for people to see recent data. Again, I'm guessing ASP would be the best bet in accessing the data from the database.
Inserting Arabic Data Into Access Database
I am trying to save arabic data from asp and it's not being saved with right encoding. i tried with both code pages 1252 and 1256. each time i am getting different set of characters in db, but not as i am entering in asp page. when i retrieve arabic data from database and display in web pages it's showing correct text. i am using following code in asp side: ....
Form Submit Data Into Access Database With Date()
I have an ASP form that has a field that automatically places the current date into it. It uses the function Date(). The problem I am having is when the form is submitted into my Access database the date is coming out wrong in the Access field. The datatype for the field is Date/Time but it still is not coming out right. Example: the date in the ASP form shows as 12/19/2006 and the entry in the Access form shows 12:00:27 AM. If I change the format of the Date/Time field to Short Date, the result is: 12/30/1899. Does anyone know how I can get the data that is posted to the Access database to come out the same as the ASP form?
Parses And Excel File And Inserts The Data In An Access Table
I have created a script that parses and excel file and inserts the data in an Access table. The script works perfectly fine, however I also need to extract a column comments via my script.Column comment is like a tool tip for any given column and therefore it occurs only on mouse hover, not in the actual column data.
VBasic Text Field (phone Number) Calculating Data Before Inserting Into Access
I have a text field in a web page I am working on that seems to be calculating phone numbers before inserting them into an Access database. i.e., 867-5309 will result as -4442 in the Access text field. My guess is that the webserver or client is processing it before inserting it. Is there any way to stop this other than using a validation script?
ASP Attempting To Access MS Access 2000 On File Share
I have a Development server that is running Win2k, IIS 5.0, and ASP enabled. I am trying to gain access to an Access 2000 DB located on a file server within my domain. I'm pretty sure I have all the correct permissions set, but I am having problems when trying to access the DB. The error is similar to: The Microsoft Jet Database engine cannot open the file '******'. It is already opened exclusively by another user, or you need permission to view its data. I'm looking for ways to fix this... Microsoft suggests turning off the ability for IIS to sync passwords. Unfortunately, this is not a viable solution for me. Is it possible to create a new virtual server that is a share to my file server? Put my ASP and MDB file in there and have it work? Anyone have any other ideas?
|
TRACKER
