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:
View Replies
ADVERTISEMENT
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:
View Replies
View Related
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.
View Replies
View Related
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:
View Replies
View Related
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.
View Replies
View Related
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.
<% IF InStr(1, contactObjRS("Email"), "@") = 1Then %>
<a href="<A href='mailto%=contactObjRS("Email'>mailto%=contactObjRS("Email") %>"><%=contactObjRS("FirstName") %>
<%Response.Write(" ") %>
<%=contactObjRS("LastName") %></a></font>
<% Else %>
<%=contactObjRS("FirstName") %>
<%Response.Write(" ") %>
<%=contactObjRS("LastName") %>
<% End If %>ted.
View Replies
View Related
In have a CSV with 50 entries all are:
FirstName,LastName,UserName
I have a VB script that specifies were to put (in form) each field. So how would i select parse) it?
View Replies
View Related
Say I want to sort the data in both db's according to similiar properties and read the results in a table.
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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:
View Replies
View Related
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:
View Replies
View Related
Im getting this error message:
Microsoft JET Database Engineerror '80040e07'Data type mismatch in criteria expression.
Im passing a ID value to a pop up window attached to a variable named 'cat'.
Its passing it across fine, but the following code doesnt seem to be working in relation to it:
strsql = "SELECT cat_ID, art_Artist, art_Title, art_FDescription, art_Price, art_PicFull " &_
"FROM eventDisplay WHERE cat_ID='" & cat & "' "
can anybody see what im doing wrong here?
The following code:
View Replies
View Related
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?
View Replies
View Related
does any one just help me with the an example of retrieving data from access data base?
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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: ....
View Replies
View Related
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:
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
We are running into problems with the script below, whose purpose is to allow users to choose values from drop downs populated by an MS Access DB.
THE RESULTS:
(returns a blank page with only HTML Titles)
THE SCRIPT:
(you may notice this is a modified sample script): Code:
View Replies
View Related
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.
View Replies
View Related
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.
<code>Dim MM_connPang_STRING
'MM_connPang_STRING = "dsn=pangDSN"
MM_connPang_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:clientdatabasepangDB.mdb"</code>
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
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
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
is there anyone use asp to acess data in db2?
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 ?
or i can only do that through ODBC ??
View Replies
View Related
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.
View Replies
View Related