I'm looking to display information pulled from a database based on
information the user puts into a text box. The user will enter their
sales rep number and I want to hit a table and return their name as
soon as they tab off of the text box. Any ideas or help would be
appreciated
this is a continuation of my little login page I am setting up.
the login pages authenticates the user using Active Directory.
I also have a Database locally in MSSQL that has the users ref number (primary key, incrementing) first name, last name, and user id (same user id as ldap/AD etc)
what I want to do is when the user logs in the page will call the Database and grab the full name as well as the ref number. Later in the page if the user submits a form to add data to another database I want it to populate a column in a table using the ref number. that should be rather easy once I actually have that ref number.so how would I tell the page to go to my database and grab his ref number (as well as his name to be able to display Welcome first Lastname instead of userid?
Pull text in from a simple notepad file on the server...simply looking for the code to place on page...I had it working in root but when I uploaded to server it din't function..checked permissions etc.
View Replies View RelatedI'd like to have a frequently used link page on our intranet that displays
the urls' based on a users's ad group membership, i.e. if from accounting
show general ledger reports, if from loans, show credit report. I'm not much
worried about hiding from enterprising users, i'd just like to make it
simpler rather than having people have to scroll through pages of links.
I have a form where the visitor should enter the e-mail adress, a password and some additional info. When the form is submitted I want to automatically send a confirmation e-mail to the visitor, containing the information from the form (like the procedure when joining this forum :-)). Is it possible to achieve that with ASP? Would be very grateful if anybody can finish the code below... because I don't know how to handle the variables after I have retrieved the form info..
This is enterinfo.htm.....
I have a form where a visitor can enter som information, in this case the e-mail adress, password and some additional info. As soon as the form is submitted I want to send an automatically generated e-mail confirmation to that user's e-mailadress (like the procedure when joining this forum for the first time). When I have retrieved the info from the form in the "confirm.asp" I don't know what to do....
View Replies View RelatedI have created a page that pulls up my data from an access database. A value has a link that goes to a detail page that I want to show all of the information for that value that was clicked.
How do I pass that value and then pull up the information for that value? Do I need to give you my code?
It s very basic question..but stil i am getting a bit confused.I want to have two radio buttons which can be selected as well be deselected. The value shud be inserted in the DB.
How should i go on doing this. Also if i want to see my selection when i return back to the order page..how should i pull it from DB and display the radio button with the dot in it(checked )?
I am using dreamweaver to make an ASP page. I have a table of data
from a MSSQL database that is currently showing on the ASP page. I
want the ability to change the color based on a priority number that's
in the MSSQL database (same recordset that the data comes from).
I
don't have the priority field out on the page but can put it out if
need be. I have 3 different priority numbers and if the first row is
priority 1 I want the font to be red and if the second row is priority
2 I want the color to be yellow and so on.
I want to write the info on a form to a text file. Code:
View Replies View RelatedASP/javascript with a drop down populated by an access database. The drop down works fine but I cant figure out how to get it to change a value of a text field.
I want the value in the text field to change to reflect the data in another column in the table, same row. Code:
I am working on a small application for senior users, so I want to limit the option for incorrect input whatsoever. I have a drop down box that is populated from a query and I want to make it so that when an option is selected, the pertinent text fields are populated based on the selection.
All the info I need is already being extracted from the query so its just a matter of displaying the right info based on the selection. I have been looking for examples of code but they all seem to use javascript. I am not too strong in javascript so I kinda avoided those. if there is a pure asp example, that would be fine!
i trying to randomize a string of text inc. number and alpha. e.g. 024053J
what is the approach to generate a few integer numbers from this string "024053J" ?
i tried to this way of randomize but not very efficient as in sometimes the user will get the same numbers back when the page is refresh.
So i thought to use a string of text to generate the randomize numbers.
randomize()
num_pmax=100
num_pmin=1
r2=Int((num_pmax-num_pmin+1)*rnd+num_pmin)
I'm trying to send email through a form I created and everything works except the email portion. It's not sending the text message. Code:
View Replies View Relatedhow to get some meta info on a number of files, such as author and owner. it is for a .asp web page wich indexes a list of files and shows info about those files (name, type, date last modified, etc)
so that who accesses the page can sort those files by the detail they wish, and i can't discover how to get the author and owner info about those files.
Does anybody know of techniques (or websites) where a graph is generated based on data of an array?
View Replies View RelatedI have a SelectBoxes.asp page that is working with multiple selection
dropdown boxes to extract data and total the selection prices.
Tom & Bob were kind enough to give me a big help getting this page
working and it's working just fine, no problems with this page.
However I then would like this data e-mailed using jmail (my host insists
on this method) and that is the function of the sendEMail2.asp page.
This is failing and only giving me a HTTP 500 - Internal server error and
I'm at a loss as to what's wrong. Code:
I am having an issue figuring out the correct syntax and possible SQL code to display data from one table (CustEndPoints) with a DropDownList used for a GridView to get data from another table. I have been playing with Joins, which is probably correct, as well as ControlParameters. Code:
View Replies View RelatedWhat is the correct data type to use if the phrase I'm saving to my table contains an apostrophe such as in the phrase "yesterda's news". I've tried "text" data type, I've tried "varchar" and "char". They all give me bugs when I save to the database and if I remove the apostrophe from the phrase, then it saves correctly with any data type.
View Replies View RelatedI am doing a project that uses ASP VBScript on Dreamweaver. I try to display data based on the hyperlink on the previous page, where I click on the hyperlink("ID of the informationfile") and the following page will show the detailed information of this particular file.
However, I can't display the next page even if I add the hyperlink and the required parameter on the records that are shown on the first page. I need to ask how can I display the detailed information based on the hyperlink, or in fact the fileID from the first page ??? Code:
I have an asp page that displays informaton from an Access database. I want to create a form that allows users to display only data that matches their search criteria.
I have made many forms like this in Front Page with the Database results wizard, but I want to manually code it. Code:
i have a page which displays a list of events searched for by a particular date. we usually have a lot of events and i don't want the user to have scroll through all of them, especially if they're interested in a particular type of event.
i have created a dynamic drop down menu which consists of all the event types. how can i got about displaying the events returned by the query to a specific event for that date.
so for example, if some one searches for 03/08/2005, they will initially get a list of all events for that day. if they click on "Closed" from the drop down menu, it will display all the "Closed" events for 03/08/2005.
I have 2 textboxes. In first text box i need to enter name, the second text box shud be automatically filled with the person'd id.
Both the name and id is coming from database. I tried using this code, but i'm getting error saying System.NullReferenceException: Object reference not set to an instance of an object. at line 1 Code:
I currently am trying to get a form to send its data to a text file. I use the code I have found in tutorial/help sites around the web, but when I try the code out, nothing happens.
When I click the "Submit" button on my form, I am sent to the .asp file and the code in that file is displayed in the browser. There is nothing written to the text file either.
The code I have in my test.asp file is:
i have 2 text box whom data are generated randomly, how can i get this data and pass it to a access database using ASP?
View Replies View RelatedOk i have a shopping cart got everything pretty much going but it didn't allow for quantities to be updated. So in my cart view i decided to add a quantity box so u could enter a new value and then click update to update that item.
However i don't know how to grab the value from the txt box.
I have the code working for all the db updates cause i tested it by hard coding it in. I just cant grab the value and pass it on from the txt box....
I am trying to pull data from a DB an export it to the user in a comma delimited text file.I found this.Do I need to save the actual textfile or is it possible to stream the text file out to the browser? If the answer is yes, how do I stream it after it is saved and delete it once it is saved by the user?
View Replies View RelatedI know how to enter data to a SQL database from a form.
I am making a form where the user inputs some numbers.
Than other users login to this other place and I want the
number that the person imputed to be shown in a field
multipled at a certain price. I am unsure how to pull the
numbers down to display them and do the multiplcation.
The multiplication will show up in another place on the
page.
Does this make sense?
I am trying to create a pull down box with no button. I need a script that will allow passing one parameter from the sending page to a single template page (jetTemp.asp).
I found this script that I cannot get to work:
<html>
<form name="guideform">
<select name="guidelinks" onChange="window.location='jetTemp.asp?' + document.guideform.guidelinks.options[document.guideform.guidelinks.selectedIndex].value">
<option selected value="PullDown.htm">--Choose--</option>
<option value="size=small">Small Jets</option>
<option value="size=medium">Medium Jets</option>
<option value="size=large">Large Jets</option>
</select>
</form>
</html>
I understand that I need a query in the target page to pickup the parameter.
I have a site that I am trying to pull a text file into from one of my sites on the WWW.
What I am trying to do is have an ASP file go out and every so offten pull a text file and save it to the local folder.Is this possible?
Is this possible to check if a text box on form.htm is in mm/dd/yyyy format before submitting to asp page?
if you enter say 2/2/04 it gives a incorrect date format error. The asp page uses this text box in the select statement for a db2 table query that is a date field.
I'm trying to include a value from a text file for the txRate variable in the code below. I tried using the include function as shown, but the double quotes are of course killing it. I don't want to use a data base to get this value, I just want the info from a text file. Can anyone suggest a solution? Code:
View Replies View RelatedI need some ideas in this if you can please help me.The folllowing is the scenerio:
I have a form which is the normal html with some validations and scripting done in javascript and i have a text box by name ticket no when the user enters a ticket no which exists in my database I need to update all my other form textboxes and textboxes with the data in the database else I need to show a alert that this doent exist in the database.
usually the event handling is done in javascript but now i have to call server side connection I have no clue how to do this.