Search Multiple Forms
I am searching for a specific record based on different criteria:
First Name, Middle Name, Last Name, City, State, Zip Code, File Number
I am using sql server to store all the information.
I am searching for a specific record based on different criteria:
First Name, Middle Name, Last Name, City, State, Zip Code, File Number
I am using sql server to store all the information.
I am dynamically generating multiple forms E.g.,
form1
form2
form3....depending upon the records
Onclick of a button i am passing the form name to another page through a querystring. I am opening the popup through window.open function. I want the value that calculates from that page to the opener page. For that I want the dynamic form name.
How will i write the form name in the code below:
window.opener.<form_Name>.<field_name>.value="aaa"
In that page i have 2 forms with exactly the same names on it's fields, but one is called form1 and the other one form2.
What i want to do is specifiy from which form i want to read it's fields using Request.Form
Is it something like Request.Form("form1.name_of_field") ??
Is it possible to have more than one form in an ASP page and determine via "request.form....." which form you want to draw results from?
example:
Can you do something like, "request.form.projecttype("id")" for the form named, "projecttype", and later in the page have another form called, "projectmanager" and do the same thing, "request.form.projectmanager("id")"
Can I have one page "prod.asp" with 2 forms (form1 with ONE Submit Button and form2 with 2 submit buttons) submiting to same page "prod.asp" again?
View Replies View RelatedI have multiple pages based on a template (using Dreamweaver MX). This template is split in two parts (div); a menu area and an info (main) area. Each area contains a form. In the menu area form I have different form elements which determine the content of the info area (e.g. a combobox controlling which page is loaded).
Two of these elements are text fields holding dates. I need to fill the info area with a table of N rows, where N is the numbers of days between the two dates. As far as I know, the page has to be submitted to the server with these date and generated serverside. What is the best approach when I want to display result on the same page which submits the dates?
It is common with form collection to ASP that only one form is submitted to the server at any one time. The webmaster can save the information submitted right away.However when many forms are submitted at once, the prior data are deleted to let the new data be carried in the ASP.How can this problem be solved with ASP? Is this a limitation with ASP?Is CGI a better way of form data collection?
View Replies View Relatedi am trying to build an online test that records user input one question at a time. So each question is a form by itself. I want to make a single ASP file that will validate all the form results and write it to a database. How can I know which form is
calling the ASP file?
Also, there may be multiple users accessing the quiz at the same time. Do I have to do anything special for such a case?
I Need to collect about 400 pieces of text information (of various types and sizes) in about seven forms in seven different pages and post all the data finally to a database. I would like to know what is the best mechanism to pass data from form1 through form 7.
Users should be able to go to previous pages and edit entered data. Should I pass them as hidden variables or retain them as session variables or are there other more efficient ways to do this?
Also, I want to be able to later retrieve the data and porpulate the forms with the data so that users can edit the data and post it again. I am using ASP to do this (not .net). Any help from a generous programmer?
I'm having trouble passing hidden fields between forms. I have a total of four forms. I have the 1st form passing its field to the 2nd form, and the 2nd form passing its field to the 3rd form, but the 1st form's field then is not passed into the 3rd form. So obviously, my summary form (the 4th form) is not getting the 1st form's field or the 2nd form's field, only the 3rd form's field. Code:
View Replies View RelatedI have a query on a page that displays the results of a recordset. Each row has a check box that has the table ID associated with the row of data.
I am trying to figure out how do I send every row checked to another page and have that page know the ID's that were checked so the next page can query the table for those ID's and fill out a submission form. I know the form fields I can write so it dynamically names the value based on the script, that part is easy, but trying to figure out how to have the script accept multiple ID's so it can go through each and display the results is not.
Now this is simple if I am just sending one ID to the next page, I can just use a "Post" and append a ?id=xxx to the URL and then do a request.querystring for the ID. Where I am confused is trying to send multiple ID = 's to the next page so it reads more then one ID if more then one was checked on the previous page which 99% of the time it will be.
HERE IS MY MAIN QUESTION:
What should I look up to point me in the right direction to create a classic VBScript/ASP code to parse through the ID's that were checked on the previous page and have the next page query each ID for the data?
I can pretty much figure out how if I know what I am looking to do. I was just looking for some sort of direction that I can pursue to understand how do do this task. What is it I am trying to do? IS there a term or set of terms I need to consider looking up to get examples so I can tweak and write it from there?
How to perform multiple search using asp in website, the search from local adn remote database.
the local search is working properly, but the remote search stil kinda stuck with it...
my local search script(work well):
dim Connection
set Connection = server.createobject("ADODB.Connection")
Connection.open "Provider=SQLOLEDB;DATA SOURCE=PROTOS;UID=smc;PWD=project;DATABASE=Virtual-Observatory"
how to attach the remote database search for the same website??
i need to make some choices in my search code by adding 1 drop-down box or more like that
<SELECT size=1 name="items">
<OPTION selected value="all" >all</OPTION>
<OPTION value="1" >item 1</OPTION>
<OPTION value="2" >item 2</OPTION>
<OPTION value="3" >item3</OPTION>
<OPTION value="4" >item 4</OPTION>
</SELECT>
so my search string will be
select * from table where rs("itemID") = '"&items&"'
and my quiz is if i want 2 make the drop-down box (items) = all i mean i want the sql statment sellects all of the names what should b the value of the all option ?
note im using 3 or 4 drop-down box and i may nedd the value of some of them to b all and the othere takes any value.
i have a form (22 different criteria although I'm only showing 3) and want to be able to enter criteria into and have it search the database. Code:
View Replies View RelatedI want to do is search through a database based on what was selected on a form.It will be based on state, county, and category.Out of the search I just want one field out of the database, the email field. Now, at first I had one table to mess with so I was using this:
strSQL = "SELECT DISTINCT EMail FROM Info WHERE Category='" & category &"' AND State='" & state &"' AND County='" & county &"'"
the way the database is going to be set up now what I need to do is search through one table that will have all the states, counties, category, and UserID fields.Then it has the other table that will have a UserID field and an email field.So I guess it needs to go through the first table and depending on what state, cat, county were selected it will take that UserID and match it to the UserID in the email table and then pull the emails that match UserID.UserID? Would this use JOIN? UNION? How would this be done, to take the form info and search the one table and then depending on what userid matches the state, county, and category in that table it matches that userid to the userid in the email table and pulls the emails from the email field.
i have a simple search page which i want to search mutiple tables with different layouts so i can return the search results in one recordset. how owuld i do this?
View Replies View Relatedhow to search multiple fields in an access database?Basically I want the code to search an entire table, field irrelevant.While I'm at it, does anyone know how to make the same search not care about word order or placement?
Such as:
Search string: "John went to the store"
returns the same results as
Search string: "The store went to John"
Just thought I would throw these out there and see what direction anyone can lead me.
I have a small form which searches a SQL DB on several fields - ie.
WHERE Field1 = xxx AND Field2 = xxx AND Field3 = xxx
How can I do this so that if one search criteria is left blank, it ignores it instead of trying to match it in the DB?
I am trying to make a search page. Once a serach word or words is put in I need it to serach multiple product tables and output the description of any prioduct if the search word is present in the description.
However, If i put in 2 keywords like "paper sticker" I get no results. How do you search multiple keywords? Code:
I have a form on one page where someone selects a bunch of options and details about a specific category. Then on the next page they fill out a form with contact information, name, address, email, etc.
Well what I want to know is when they click Submit on that contact form is there a way to have it so it goes through and searches the database for any that match the state and county(which they will select from a )??
So what I basically want right now is for the first form to be filled out, then the second form to be filled out, then when they are submitted it will go through the database and select everyone in there with that state and county, then on the next page display the results of both forms AND the matches in the db(obviously whatever fields I want it to display).
I already have both forms(basic html), I already have the dynamic dropdown for state and county(classic asp), what Im wondering is how do I put that dynamic dropdown in the contact form and then when submitted it will go through and search the db based on what was selected there. Would this be some sort of onClick for the submit button tellin it to search the db based on the dropdown or how would I get started on something like this?
There will be other information on the dropdown like name address email so one problem I was wondering about was my dropdown menu. When you select the state it refreshes the page and then loads the counties, so wouldnt that erase anything that was filled out on the form?
I could make it so they actually type the name of their state and county but that causes problems too because if they mispell either then it wont return any results.
I am trying to search for clients contained within a database using multiple search criteria that the user is able to select using a front end form.
The user is able to select there criteria by selecting one or more check boxes and the results are thus retrieved based on what the user has selected. The search works fine until you try and select multiple client types Code:
Just as the title says I am trying to do something impossible with a single SQL statement. I am doing an ASP webpage for internal use at the company I work for.
I want to know if there is a way to insert/update data into multiple tables in 1 SQL statement.
If it requires functions | views or anything else that is fine but I don't want to have 3-4 different SQL statements to update 2-3 different columns in different tables.
I have a search option on my website, which should perform a search on 4 fields, as follows:
tblNews
headline
content
tblDatabank
filename
description
It only needs to return matches which are an exact match of their search criteria. For instance, searching for "I am here" would return a record which contained "I am here", but not just "I" or "I am" etc.
I need to return all these records as part of one recordset preferably, as I want to be able to order them etc., though I imagine you may suggest I use an array somehow to merge two recordets etc., then reorder them?
i get the ref url that come to my site and i want to convert it to find
out what was the query in (google or other searcher sites)
foe example : if someone goes to google and search some text and my
site was in his resaults and he click on it , in my site i see his link
ref like
http://www.google.co.il/search?hl=i...91-Google&meta=
i want to know (in asp and save it to DB) what was the word or words
that the user write in search engine.
i hav problem with updating the data. In the asp page i hav displayed records based on search criteria. in display mode im displaying the to be updated field in combo box for each similar contract_no. each contract_no will hav different no of rows and to be updated combo box.
based on the selected value in the combo boxes of different contract_nos i hav to update the combo value with old value. user select multiple combo values at a time I need anybody's help with detailed programming logic.
I am trying to write a simple script that will allow me to have someone complete a form and depending on which location they choose an email will be sent to a specific person.
I have a page that validates and sends and email to me correctly, now I am trying to simply add a case statement that will allow me to change the recipient to the individual it needs to go to. What am I doing wrong? Is there another way of doing this?
Basicly I would like to know how to transfer data entered on a form one one page, to another - for example a signup:
Page one - Contains initial form
Page two - other details form ] both pages emailed through the same form.
I am trying to take that is submitted in a form and put it into a querystring. I have a text field with the name "company_name" and has the value of <%= cCompany%> when submitted I want to take the value of the text field and send it to another page called submit.asp. then from the submit page I will append it into a table. I can append to the table fine but when I pass the value its blank. I have tried Request.Form(company_name) and Response.Write(cCompany). None of these seem to work the variable is always blank when I submit it. I can use javascript to get the value, which works correctly but cant dont think I can pass a javascript variable into a querystring.
View Replies View Relatedhow come the second one has the forms lined under eachother
when the first one looks like it does?
How do i make the "boxes" in a straight line under eachother?
I’m working on an Invoice page. The user may edit some of the vars on the page. Then The user will want to re calculate the totals. Then after seeing the re calculated totals then I will want to submit this info to the next page where the data will be put into a DB.
The question is how do I do this without using 2 forms, It looks like you can not put a form with in a form. Yet it looks like that’s the only way to be able to pass the vars iEither to the page where were calculate the vars, or the other page where we submit the data to the DB.
i have
printerdropdown = printerdropdown & "<option value=" & rsPrinter("id") & ">" & rsPrinter("id") & " " & rsPrinter("name") & " ( " & rsPrinter("location") & " )</option>"
and want to pass two variables across my forum by selecting just the one.
i.e. rather then just passing rsPrinter("id") id also liek to pass rsPrinter("ccid")
But dont know how to without making it joined when i cann it on the next page via request.form("printerid")
Is it possible to call ASP functions from event handlers? I am trying to find a way to have a form call an ASP function, if there is a better way let me know.
View Replies View RelatedIs it possible to create a form that will authenicate against a 2003 domain?
View Replies View Related