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 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.
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 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:
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.
how do i get data from a user on one page and display the result on the other page actually i have written a prgoram that displays a set of checkboxes and based on the checkboxes selected the related data is displayed .but the problem is the data is displayed on the same page below the list of check boxes. Code:
I created a web page from Excel2000, using "Save as web page..."...Publish function. then, I moved htm file to my IIS web server. Then I added a form control, and submit button.
How can get the data on the excel file using ASP from server side? For example, the value of Cell(1,2), Cell(2,3)....
I like to know how to write this specifc function on ASP where the user eg: display a set of records on the webpage. Example the data are ID, Name and address.
Lets say i display the data on the webpage and i set the Name as the <a href>. So when i click on the name, it will move to another page with the id of the specific name. Code:
I have a form.htm page where the user enters an ID to retrieve addresses. Then PAGE1.ASP displays the addresses. From here the user selects an address and submits. Then PAGE3.ASP brings back further information. My question is how do I use one field from the address information on PAGE2.ASP to display on PAGE3.ASP? I know how to do it with textboxs and such but cant get RS data to hope page to page. I get no errors or anthing.
On PAGE2.ASP I have : <input type="hidden" name="CLIENTHIDDEN" value="<%=RS1("CICL_LNG_NM") %>"></td>
On PAGE3.ASP I have: clientname = request.form("CLIENTHIDDEN")
and to display: <td class=rt width="110" height="1">Business Name:</td><td width="849" class=rt height="1"><% =clientname%></td>
I am in the process of developing an application and would like to hide the query strings in the URLs. I want to POST data to a page then validate the data. If there is an error I have to send data back via a long query string. Is there anyway to POST data between pages programmatically?
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 am working on a project involving pulling information from Active Directory (Name, email address, contact no.) and sticking this information in some SQL tables. Using ASP, How do I enable windows authentication (username and password from active directory) ?.
In other words, when the incharge user wants to login to the tables on the web, he must use his/her windows username and password ? On the same project, I want to assign different groups with different security levels. (something similar to the Active Directory security groups), and let the admin asign rights to each group in order to control access and privilege of each user within a group.
I've created a form where the user should be able to select an option, then a second list will be populated based on that selection. The next part is where I am running into trouble.
The user can also select a time window which can limit their search, if they so choose. Code:
The end result of what I want is to display news headlines for specific stocks on my website. I adapted the below code (very unsuccessfully) from pulling data points from yahoo to news headlines. Code:
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.
Is there a way to pull the auto-number of a row entered into a database? IE, if I create an order, automatically pull the order_no from the order_table so that I can insert it into an order_detail table. There has to be a better way then selecting max order_id because that might not be the most current order? I know there is a buiilt in function in php what about asp?
we just migrated to Windows Server 2003 and active directory. On our intranet I would like to personalize some of the pages my users hit. Let's say I login as petertom, when I go to my main page.
Is there a way to grab information form the fields in AD after a person authenticates? Is there a timeout, i.e., user logs in at 8:00 AM, but doesn't hit the intranet until 1:00 PM etc?
Eventually I would like people to get to secure areas without needing a login and password, but based on what AU or group they belong to, is this possible as well? Does any of this require changes to be made via IIS? (The intranet is running Win2k server, not Win2003).
I need to pull dates (years) out of a string. The string can either be a date range like "The date is between 1975 and 1978" or a single year like "The date is 1980".
i am having to write a password protection script that pull the user info from the user accounts on the server. so, that way people within the company can log on using the same user name and password as they would to log on to there computer/the network. any ideas? i will also have to give each user different permissions, but i think i can figure that part out.
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 have a set of db results that I cannot filter completely in my query and I'm trying to figure out how to eliminate the "duplicate entries" after the fact.
My problem is I'm pulling columns for lot number and transaction time, but some (not all) lot numbers have two transaction times so I can't filter out these double entries with a "DISTINCT" statement in my query since the transaction times are distinct, but I only care about the first one. I'm looping through pulling my results as such: Code:
If you click most of the links in the gold nav bar, they will take you to various places within the site. But if you select the one called "Loads", it takes you to http://www.crgm06.com/aval.txt, which I have opened into a new window. As you can see, it's a plain text file, and it is on a different domain, which I have no control over. The data in there changes all the time.
Is there a way I can import this into one of the pages I have control over, and parse it out and display it the way I want? I've never worked with importing plain text that's generated on the fly before.
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 need to pull values from another page to a form in my script. Basically i want to update an entry in my dbase and populate those current values to a form which is working fine for most of the form except the dropdownlist. Also i dont know if this is an issue but i have a "FOR" Script running in my dropdownlist constructed as follows:
<% For x = 0 to 1000%><option value="<%=x%>" selected="<%=Request.QueryString("CabN")%>"><%=x%></option><% Next%></Select>
As you can see i place the Request.Querystring object in my code but the dropdownlist doest recognise this and continues on until it reaches 1000 which at this point it stops. I want the drop downlist to reflect the same value as that which exsist already in the datebase for it. What am I doing wrong?
I am using a file type input box in an HTML form. When a file is selected, the local pathname results. Is there a way to run this form online, and access a file on the visitor's PC from the web? What pathname needs to be used?
OK I'm just starting out in asp, and the site will be mostly asp, which will be based around a shopping cart.
I would like to pull in a header and/or a footer into all of those pages.
Should I look into an ASP solution, or are there compatible ways such as CCS, or similar.
I only have experience with PHP server side includes, this is what I would like to emulate. I know there is normal SSI, but the pages need to be named .shtml, mine will be .aspx