I have a form that has a table that contains a textbox where the user inputs a part number. Depending on what the user enters, when the user tabs to the next textbox, I want it to go to the database and search for the number that was entered.
If found, I want it to populate other textboxes with information found for that item in the database. How can I accomplish this??
I just found your website and it's terrific. I need to know if an Autofill form can be made. The language is ASP. My programmer says it's not possible, is it true?
The idea is to have a search button where the customers inputs the letters of product models (the info comes from a DB) and it's autocompleted or at least, the system searches for the closest model no. ; once the customer clicks on the model they want, all info regarding that model would be displayed in another form.
I have to use the nl2br function in the asp file, luckly I got this code from a site. What I need to do is literally extract the information from a textbox exactly as it is i.e.
the paragraph breaks, the formatting (which I have specified) but most importantly I need to extract the formatting the way it is. When one copies and pastes text in the textbox it extracts the data as an entire paragraph. Code:
How can i lock a textbox in a form !?
so no body can change its value
<input type="text" name="adddate" size="20" value=<%response.write(date())%>>
<input type="text" name="name" size="20" value=Killerpm>
I have an input type text in my 1st asp page....when i go to the 2nd asp page i want to retrieve my textbox value in my previous page...i know how to do this with a form...i want to do it in another way, is that possible?
View Replies View RelatedI am making this application where I basically ask for a password (It is not a login). After the button is clicked - the word in the textbox is compared to an entry in a database. If the word is the same then it sends it to link 1, else it sends it to link 2.
How do you guys suggest I do this?
what i'm doing is trying to take data from a row in Excel and somehow autofill a webform (textboxes) with the information from all 65500 rows in this column and submit to a website. It is a list of product item numbers so I can submit them without typing them all in.
View Replies View RelatedIs there a way to turn off the auto fill.. I have page that a user has to enter their logon and password. I do not want the auto fill to save userid/pswd. Can this be turned off or not displayed while typing?
View Replies View RelatedI have 4 fields from a DB: col01, col02, col03 and col04
I have 3 text fields and a dropdown menu. The dropdown menu will contain a list of all values from col01. Upon selecting a value in that dropdown, I want the 3 textfields to be filled the relevant col02, col3 and col4 data.
have form on asp page with an email address field, when the user enters
their email address I want it to populate another field automatically on the
same page, some kind of OnBlur event. Have worked extensively with dropdown
OnChange events but cant get my head around this one.
Just getting started with ASP (NOT .NET) and have a question:
I have a basic form and I'm trying to add some functionality to it. I want
a user to be able to select a product from a list box. After this product
is selected have another text box, ProductID update to reflect the product
number.
In VB I would use an OnChange type thing. Can anyone point me how to do
this with an ASP page or using some kind of embedded script?
my form contains two text fields(name, address) and two file field control where user can insert image(photo1 and photo2), i want to insert this data in to ms access when the user submits the form?
this is my code for insert text fields to access data base.but i have no idea about the code for image fields. In my access data base i set photo1 and photo2 as herf (binary data). Code:
What I need to do is to create a form of a dynamic size, and then save
everything from the form in a database. The number of forms depends on
a number from the database which I know how to get. I need to have a
comment and a number, for example if the number from queried from the
database is 2, then I need 2 forms, and it would be something like so:
Comment: Something
Number: 4
Comment: SomethingElse
Number: 6
When the user clicks the submit button, this would be saved in a
database in a table, in a new row. I have the database created and
inserting works very good when inserting just one row, but I need to
insert more then one row at a time, so it would be something like
this: Code:
Does anyone know where I can find a great tutorial that will show me how to take information filled out in a form on a web site that will go directly to an Access database?
View Replies View RelatedHave an asp form created and I need to assign a unique id number to each submission. Can this be done w/o a db?
View Replies View RelatedI have created a nice form that i want on my site for users to fill in detail. But i was wondering if anyone knew any good tutorials on how i can get this info sent to my database?
View Replies View Relatedi have been trying to get info from a form into a database on the server for months, i have one form page and one asp page that should send the data to the database on server heres is my code for both pages. here is the form page:
<form action="deantest.asp" method="POST">
<input type="text" name= "name" ><BR>
<input type="Submit" value="Submit">
</form>
and here is the asp page with the code that i use to put the form data into the data base.
<%dim strformfieldvalues
strformfieldvalues =request.Form("name")
response.Write ("your name is ") & strformfieldvalues%>
I have a form that I want to auto fill in with database data. When the customer number is typed into a textbox and a button in clicked, the database will be queryed and pull back that record.
Once pulled from the database I would like the form text boxes to automatically fill in with the data brought back. Can this be done? If so, can someone show me a small example of the easiest way to do this?
i have a form with fields that contain data from a db. the fields can then be edited, and on the click of the "submit" button, the updated information is returned to the database, replacing the old. a bonus would be arrow buttons allowing navigation from one record to the next, with the information populating the form each time. i'm having a hard time with this.
View Replies View RelatedI am trying to have a form that has multiple records on it and the user can check a box on which ones to add to the database. I created the form but cannot get the fields to enter into the database.
View Replies View RelatedI have the following line of code that is part of a form that displays a record from a database;
<textarea name="name" cols="60" rows="20" value="<% =rscms_example("body") %>" </textarea>
Could you please tell me where I am going wrong on it? I know its probably very simple, but I am terrible at forms anyway.
I need to validate an item number from a form field against a MS SQL database
I am using a 2 page process to print barcodes from an entered item number on page 1 and need to only use valid item numbers from the database. If they enter a wrong number I want to give them a page telling them of the error.
I have 32 fields on page 1 to enter 32 items.(one for every label on the second page that contains the barcodes. Here is the connection to the database that I am using for the barcode.(Column IMLITM contains the item numbers) Code:
I currently have a web page that pulls in job vacancies from a search form all written in asp and the database is in access. I will be placing an extra field which will say "apply now" and on selecting this you will be taken to a new page where you can fill in your details and email them to the employer.
My problem is I need to know how to get a field in the form that will automatically fill in the title of the vacancy being applied for from the database.
How can I specify formatting restrictions for special fields like Postal Code
(format X1X 2C2) or date input field MM/DD/YYYY? I have Acces DB with these specs, but when I used FP2002 Database Interface Wizard, it ignores these. Also I am unable to "edit" any of the records utilizing pages generated by this wizard.
There is an error that it will not accept empty fields. I have no problem adding data (even if some fields are empty) or deleting records.
I have a an issue that I would love to solve. The below code adds 111111111111111111 to the field when I want it to sum the amount which in this case totals 18 and then add that total (18) to the field! Code:
View Replies View RelatedI'm building a form select from a record set and then using the selected result to call another record set. This a maybe a dumb problem but it has me stumped. The first record always has a comma after it, theres no comma in the database and no comma in the code. Can someone tell where this comma is coming from? Code:
View Replies View Relatedim working on a database driven website that uses an access database of links and search keywords that users can search through to find a particular page within my site. the search box is in a table and the results come up in an iframe without the page refreshing aside fromt the iframe itself. at the moment when i type a search into the text field and press enter the results come up as i want them to within the iframe.
however if i press the search button next to the text field section of the form as opposed to pressing enter the database does not find any results yet the no results found error still appears within the iframe. i have tried the same searches and pressed enter and they work but as soon as i try to click the search button they do not.
here is the search form code so any of you geniuses out there who can help me can see if any code is missing: Code:
Except for extremely basic ASP programming that I did two years ago and have forgotten I have not touched coding since!
I've taken a look at a couple of tutorials but they all baffle me!
Can anyone tell me how I can just create a simple html form with input fields of FirstName, LastName, Email and Phone amd when the user hits submit it is recorded in an access database?
I can do the HTML part fine. And I believe I've set up access ok although Ive never used it before.
Also, if the server that the database will go on is a Microsoft one i suspect that is ok? Im not sure if all i have to do is upload the database and it will work? or do i need to talk to my hosting company to set up some kind of odbc thing that ive heard about?
My database will just be called clients.mdb and the table is called Customers.
I have a project where i have to use an html asp application form to insert records into an sql database. My problem is finding resources online to practice with to learn, i have basic knowledge of ASP and have attended the microsoft 1 week course on Administering a 2000 SQL Database and i have designed a few small sites so i know html and javascript. I have the database side covered its just the VB code to take the form values and post them to the sql database.
I was wondering if anyone could point me in the right direction of sample codes to play around with as i cant seem to find any which relate to this project.
I made a 2 web surveys with identical code. Although the code is similar in both, values on the last page of one of the survey do not go in the database.
I have tried playing around (coz I really dont understand what the problem is), but nothing works. The same code works on the other survey with absolutely no problems.All thats there in my survey to insert values is
.Fields ("fieldname") = Request.value ("name of text box")
.update
Any suggestions? If someones willing to help me out quick, I will post my code.
my database, sqlplus oracle, has a column ccexpiry, whch is set to date. In my form in asp, there will always be an error whenever i pass in a date that is not in the DD MMM YYYY which is the standard for oracle. My qn is how can i pass in a date that is in DD/MM/YYYY format? Code:
View Replies View RelatedHow to search a database field from form input? is it easy to do i like to have a html form from an html page that will call an asp page to do db search, if user enter a zipcode that match in the database it will pull all the infomation from both talbes and display on the screen
i have 2 tables related to each other
contact table
id, fname, lastname, contactid, email
zip table
id, zip, contactid, city
How can I do it?
View Replies View Related