I am trying to write a web application that can retrieve information from an access database, store it in a recordset, update it, then update the access database. However, when I try to update the recordset, I get an error (500).
I have checked my field names a million times (so I am pretty sure it isn't a spelling mistake or anything like that), but nothing is working. I included my code so you can take a look at it. Code:
I have a date field which I use var1 = new Date() to save under MS-Access field with "text" to be the data type (date/time is NOT accepting). I have tried using
var2 = new Date(oRS("field1")) var2.getMonth() does not get the right saved month
how to retrieve the date and time using Javascript? Or I should use var2 = new String(oRS("field1")) The result of var2 would be "Thu Mar 31 11:11:11 EST 2005". Is checking the location of spaces the only way to get date and time?
I am submitting data to a database field, and the data is being submitted in the following manner to a table in the database:
5,3,4,4,3,3,4,5,4,5,5
It's all comma delimeted. Now, what I would like to do is have an update page in which a user can update these values. I am trying to place the values in a repeated text box that corresponds with a repeated question.
The questions that I am displaying are in a repeated field and each question has a text box that will hold the value that corresponds to. I would like to be able to bring in each value into a repeated text box. Right now, each repeated text box contains the above information. (5,3,4,4,3,3,4,5,4,5,5). Is this possible?
I have a search set up on my site to compare between two <select> values and the value in the data base, but not sure if I have the sql statment correct, my search returns all rows from the table, I want specific row that is between one form select and another... ie. below
for this particular example I want to know if the database AD_PRICE field is between <select name=price> and <select name=price1> and if so, return the only those rows, currently all rows are being returned... Code:
Just wondering. I am developing a blog. I would like to display the message post on the blog to be limited to, say, 100 words rather than the whole message itself as this will increase the page length.
I would like to know if there is a method to count the words from the record in database and display only 100 hundred words from the actual message..
I am currently working on a document management system for my company's Marketing department. They wish to be able to upload files to the server.
Rather than deal with the many permissions issues we have had in the past with saving and deleting these files to the server's file system, this time we are trying to use SQL server BLOB fields to store the files.
The premise is simple -- a user clicks on the link and the file is then shown in the browser. The documents are mostly word, Quark, and Adobe Illustrator documents. I was thinking the code would go something like this: Code:
I have sucessfully installed IIS 5.1 on XP Pro, and have validated a couple of test .asp pages.
When I try to connect to Access through Front Page, i get the following error:
The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.
I am using a Replace function to replace single quotes with double when submitting a text field in the database i.e. Replace (q, "'", "' ' ") which works fine. When I retrieve the field from the database which has apostrophe I am getting 'Object expected' error message. Is there a way to fix this?
I have about 26 checkboxes that place all of my contacts into categories so in my database for contacts i have a field called categories that contains all of the categeories that each contact belongs to seperated by a ",". 1,5,17 etc.
I need help getting these values out of the database so that when I user select category 17 they get all of the contacts that containg the 17 in their respective categories field.
I have this page with photo thumbnails that are clickable. Each photo has corresponding info saved on a database. When the thumbnail is click, im trying to show the data in an asp page called info.asp.
sample: Photo #1 when clicked goes to: info.asp?no=1 Photo #2 when clicked goes to: info.asp?no=2 so on so forth..
the database fields are: no picname date details
I only know how to display ALL info from a database.
But i cant figure out how to display SPECIFIC info triggered by a query string. Example. Photo #1 is clicked. I only want the data that corresponds to Photo 1 to be displayed. How can i do this?
I want to seach though the drives i.e c or d drives and find for the folders and subfolders and even the files and by that order only it should be inserted into the database.I am using MSACCESS database.
I am trying to search for clients contained within a database using multiple search criteria that the user is able to select using a front end form.
The user is able to select there criteria by selecting one or more check boxes and the results are thus retrieved based on what the user has selected. The search works fine until you try and select multiple client types Code:
I want to move my only window shosted client to linux. The site they have access a Microsoft Access database with the below code but i can't get it to work under Linux.
I have an ASP page needs to access a remote MS Access2000 database, I got error "The Microsoft Jet database engine cannot open the file 'F:Collect.mdb'. It is already opened exclusively by another user, or you need permission to view its data. ".
The 'F:' is a mapped drive from remote machine where the access database loactes. If I copy the database back to local box, no problem.
I'm looking to make an online multiplayer game which will utilize Access Database... basically I require thousands of people writing and reading from the same database... I was wondering if this is possible for that... or is mdb file restricted to 1 person at a time...
If it is limited what would you suggest as the best way to control an interactive online environment? .txt files possibly?
I have four input variables from a form (first name, Last name, registration number and pin number). I want to check if this variables conform to the data I have in a database (mind you the Pin number is initially not related to the registration number, first name and last name and it is a list of numbers in a separate table in the database;I want to have the flexibility to supply any Pin number, tie this number to the registration number, first name and last name for the purpose of accessing other data in the database for a specified number of times) . how can I do this in an asp environment ?
I'm trying for the longest while to access a database and i keep saying error 3219 which states that the operation is not allowed in this context.
The error occurs when i add obj.AddNew. I have declared a variable called obj which handles the microsoft access database. i set it to obj.Open tablename, connection,0,3,2 and after assigning the values to the fields i then said obj.Update.
I'm creating a form for users to fill out and submit the form via email(outlook). But at the same time I want their names and phone numbers to be registered in an Access database(once submitted). I can't figure the ASP coding to do this.
I have a whole database set up in MS Access with all the menus etc. It's a flight reservation database for a school project. Is there a way to import everything (including the interface) to a website using ASP or ANY other kind of software?
i want to write a intranet webpage (can be in ASP / HTML) to connect our Access Database and to search in the Database. We are using WinNT Server here, and php is not allow. And i have no permission to install anything to the server ... I have experience with php and mySQL, but have no experience with asp ... 1. what is ODBC ? how to link db with ODBC in intranet ? (coz' i only saw instructions to link db to local computer) 2. any sample codes of ASP with access database to follow?
Hope that i could find my solution here.i'm working on an asp page and i need to display data from 2 different databases one is in sql server and the other is in access currently i have linked the sql tables into the access database but problems occur where i have to refresh the tables regulary so what i need is to be able to select from the sql and access seperatly in one select statment How could i create the connections for both of them to be able to do so?
What code do I use? Bear in mind that each ACCESS record has an Auto-ID, but since some records may have been deleted, the number of records in the database does not equal the maximum ID number.
For a new project I just got,I am being asked to code a small web site but it has to be in ASP. The company doesnt have alot of money, and wants to use ASP and an Microsoft Access database.I had thought that ASP was only able to use MS SQL, but maybe that is wrong.
I am very adept in PHP and MySQL, and have programmed a little in ASP, but never with ASP+ and a database. Could someone please recommend a site or give some examples on using ASP with MySQL or with Access?
I am trying to get records from an Access database that can be viewed from a WAP enabled phone.I understand that I have to create a WML file, but dont know how to do this.
i have a form that adds subjects to access Database.It works very well but the problem is when i request the fields by their Name and not by Id. If the subject have to 2 words or more between the 2 words, there is Space so it take Only the First Word and ignore the rest of the words.
they have a database which stores information about their properties.. as well as one image of the property from the outside and 3 or interior images of the property.they would like the 'property' section of the website to pull the images and descriptions from this database.
they would also like to edit the properties section on a daily basis using forms.. (deleting properties.. adding properties.. deleting images.. uploading new images.. ) does this sound viable in asp and also some tutorials on uploading files i think will benefit me.
I have a single table, with 8 fields. I want to allow users to filter their selections on 3 fields, specifically County, DistrictName, and Date. I would like users to be able to chose one a specific field from each of these 3 or default to all. Users will not be able to update the database, they will simply be returned data.
Add to this one of the fields is an amount field in which a user can see the sum of the data returned. In conjunction I will also need a flag for amounts which have not yet posted so that these do not report in the sum amount. I would be most grateful for any assistance or if i can be pointed to a product which will aid me in completing this task.
How can I secure an Access database that I use on my Web site? That is, I don't want users to be able to guess the URL of my Access .mdb file and download my database.