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:
Here's my scenario: I send an email to my customers which contains an embedded URL with a recordnumber within it. What I want to do is create a variable for the recordnumber, write a select statement against my database using the variable as the argument for the WHERE clause, and display the results of the SELECT (its always a single value) within an HTML page.
Here are snippets of the code. The recordnumber is represented by strCallID and the resultset that I'm trying to display is strATG (shown near the bottom of the HTML) All the connection string stuff has already been taken care of, so that's not included in this code:
I have an access database that holds among other info, web addresses and email addresses. They are in a hyperlink format in Access. When I run the ASP code, they disappear. I want to pull the data out, with the web addresses as hyperlinks.
I have a login script up and running and i have used a session variable to greet the user when they successfully login. what i am trying to do now is create a query to select other information from my database using the session variable, their username. i have been trying all sorts of different things and just cant get it to work.
I know that i have to do a select * where users = session variable(username)
but i dont get where in the code i put it... Here is the code of my protected page: Code:
I came across a topic regarding joining three tables, but couldn't apply it to what I am doing. I have three tables: Accounts, Reservations, Invoices. My goal is to put together a statment for each Account showing all outstanding Reservations and Invoices in chronological order.
Both Reservations and Invoices tables have their own date fields (Reservations - actual date of service, Invoices - date when invoice was created).
so basically Go through Accounts and then for each account that has either UNPAID Reservations or UNPAID Invoices populate a list of transactions where Reservations. ServiceDate and Invoices.CreatedDate should be listed in one column and sorted chronologically.
I have a database that has an email column that either contains an email address someemailaddy@mail.com or a value "n/a" All I want to do is loop through the column in ASP by checking to see if the "@" is in the address and if it is feed the email address into a mailto: href tag . I think something is wrong with my code because it just returns the name but not the href.
I am making an asp page that kind of gives a summary of a table I have on my SQL server. I have one field on the page of:
{rs_analyst_summary.TICKET_NUM}
Is there a way i can make another recordset that would use that field on the same page?
Basically what I have setup is a listing of all the tickets for one person. I need to have a score for each ticket as well. I have to start off on my first page by selecting my analyst. I want the page it links to have all of the analysts tickets and their score on each.
I have a table with 30 or so columns. I'm pulling the data and putting them into variables like so:
objRS.Open query, db UserID = objRS("UserID")
That's obviously not including the db conn info or even the query itself. Rather than manually typing out each and every variable and pulling the data from the RS object, is there a function that will automatically store all the data from the RS into its respective variable? I'm basically just lazy and the carpal tunnel kicked in after 10 or so variables.
I am working on a site where you must log in to access the site. On this site we have a link to an off site that needs a user name and password to access it. We have made the user names and passwords the same for our site and the offsite.
the thing that we are doing is when they click on the link to the off site we want to pull thier name and password form a data base (which is already made) and input it into the user name and password.
I am not sure exactly how to code this to pull the name from the data base.
I as of right now have it HARD CODED with a user name and password and it works. But I need to some how have it pull the "correct" name and login.
I work for a smaller Insurance firm and these names are for our reps. We can not have just anyones name getting pulled from the database due to each rep is working on differnt cases. Code:
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 a two pages. The first is a data entry screen (which saves the form data to a DB) and the second page displays the text that was inputted on the previous page( pulled from DB). Is there a way to insert <%=date()%> into one of the text areas and have it be processed on the second page when that text is pulled from the 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.
I am trying set up a page where the user can view records chosen by the year. I want to use a dropdown menu/list. Having trouble figuring out the sql behind this.
My db table has about 10 fields in it, one of which is the year this record was created. i want the enduser to be able to enter the page, and first step is to select a year to view. Again, i want this to be chosen using a drop down menu. After clicking I would like the page to show a simple table pulling up all the records from that year.
i know this sounds simple enough, but i cannot find this info/tutorial anywhere.. you guys are my only hope.
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 have a member registration form that when the user clicks the submit button the form info is sent to a file name validate.asp.
The file validate.asp checks all the information to see if it correct and now I would like to have the data that was submitted added to an access database named members into a table that I named reginfo (registration info) and I have tried numerous ways to do this and spent countless hours browsing through websites but cant seem to get it to work. Code:
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?
I want to insert the data into the MS Access Database using Visual Basic 6.0. Anybody please heplp me to tell the steps to insert the data into the database.
I'm trying to pull the last 5 records from my database.
<% j=5 rs.MoveLast While ((j>0) AND (NOT rs_article.BOF))%> ''Execute HTML and data insertion here
<%rs_article.MovePrevious j=j-1 Wend%>
Everytime I attempt to run this code, I recieve an HTTP 500- Internal Server Error. It tells me no more than that. I know that my connection settings are OK because when I move forward through the database (first five records), the code executes without error. And yes, my Cursor type is Dynamic.
Alternatively, I would also like to know how to add new recordset to the beginning of a database rather than the end.
I'm current working on a project which need to upload local data to live server database.
Meanings that, i'm current having a server in my local mechine. I need upload data from local database to live database which host at oversea company. But i really have no idea how to do this in asp.
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?
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.