I have 2 databases, one i write two when i submit the form, that works fine. The other holds contact info. I need for when the Company Initials are typed in(form CSN) that the Pace Administrator info fills automatically(PAName and PAPhone). Code:
View Repliesim trying to create a dynamic sql query based on form user input in ASP. The sql query is then used to filter through a table i have in access. So far i have managed to work with the below code which uses the input from the form and puts it into SQL format.
My form has a field 'PositionTitle1', PositionTitle2' and 'PositionTitle3' all pointing to the one field in my access database. My problem lies in adding functionality for the 'OR' to be used instead of 'AND' in this situation, so that i can place a value in 'PositionTitle1' and 'PositionTitle2' and both will come up in the filtered query.
Any suggestions on how i might be able to alter the below to accomodate for this?
Code:
I'm trying to making a form which can filter the search results. Some of the infomration is in text boxes and other search options are in dropdowns. this is my current query:
Code:
SELECT DefendantCase.VBKey, DefendantCase.PointValue, DefendantCase.CaseNumber, DefendantCase.LastName,
DefendantCase.FirstName, DefendantCase.MiddleName, StatusDescription.[Description] AS Status,
ProsAttyDescription.[Description] AS ADA FROM DefendantCase LEFT JOIN StatusDescription ON
StatusDescription.StatusID=DefendantCase.StatusID LEFT JOIN ProsAttyDescription ON
DefendantCase.ProsAtty=ProsAttyDescription.ProsAtt yID WHERE LastName LIKE '" & lastname & "%' AND FirstName LIKE '" &
firstname & "%' AND DefendantCase.StatusID IN("& statusid &") ORDER BY DefendantCase.LastName, DefendantCase.FirstName
ive been trying this for ages and various ways have all failed! please can some one show me the correct way to achive what i am after!
the ASP code looks like this: PHP Code:
I need to dynamically append a session variable to a querystring to every link on our site. Is this possible in ASP?
View Replies View Relatedit's a dynamic form which should show which option is selected. I've made zillions of these before, and this should work no problem, but there's a bug that I just can't see somewhere... Can anyone see what in god's name I'm missing? Code:
View Replies View RelatedI currently have a form with 5 rows of textboxes (one textbox on each row). I would like when user keyed in something in the last textbox (textbox at 5th row), it will automatically create another row of texbox below it. Can someone please advise me on how I can do that?
View Replies View RelatedI am trying to populate a form field without having to write any Javascript.
I am using dreamweaver and am trying to follow the help guide to create dynamic fields. However it is not the best of examples and i am struggling quite a bit with it.
I am trying to create a form that asks mostly yes or no questions using radio buttons. One question has 5 different radio buttons. The form is dynamic because if they answer say yes to one question it will go another.
If they answer no, it will go to another. The questions should display as a hierarchy, so that they can see all of the questions and what they answered, I also want them to be able to change the answer to previous question. I did it in javascript, but it doesn't work quite as well if they change their previous answers. How do I do it in ASP?
I have a form with 5 textboxes (one on each row). I want it to auto generate another textbox below the last when user key in something in the 5th textbox (which is the last textbox in the form). This will go on until the user has nothing to key. Textboxes will always generate at the last row when user key in the last texbox displayed.
View Replies View RelatedI have a lot of information to fill out on this form. So I'd prefer not to do the submit to itself everytime to rebuild it. I've seen many java script examples on how to dynamically populate a checkbox, combo box etc. but is it possible just to not have the box there at all?
I've seen a .visible=false on spans in aspx, but can you do something similar to this with plain old asp?
Example, i have a combo box, and let's say i select a few options and write a "on change"..... i call a function that makes an attribute .visible false. Is this possible to make a text box disappear off the page without resubmitting the from? If not, any other bright ideas on how to do this one?
If I have say 10 fixed variables, how can I set their values = to that of a form that is built dynamically?
column1column2
email=formvalue(0)
fname=formvalue(1)
lname=formvalue(2)
etc..
lastvar=formvalue(9)
I have a form on an asp page and need to dynamically add rows to it and then be able to insert the dynamic cells to a SQL database.
I have tried this with JAvascript and have kind of hit a wall. Any ideas how to do it with ASP instead? I want to add the next row when a user exits the last cell in the existing row.
I am trying to complete a form validation for a repeated dynamic text box. Someone shared some code with me that doesn't seem to do the trick but it lead me in the right direction. Here is the code that I'm using: Code:
View Replies View RelatedThe problem I have is that I need to be able to allow users select from a drop down list, but if they select other from the list, I need to show a text box where they can enter the details, otherwise keep it hidden. here is my code so far: Code:
View Replies View RelatedI have a form which inputs info into a database. However what I would like is to populate a select box directly from the dbase. When the form is entered the field is updated along with all the other info.
I have enclosed two of my pages - I think I'm nearly there.
My client wants File Uploading in ASP that i can do but the requirement says that i should have one FORM FILE FIELD first to browse the file to upload.
and the moment i click the browse button of first FILE FIELD, a second FILE FIElD is generated beneath it and when the user clicks on the second Browse button it generates the third and this process goes on. Untill the user clicks the upload button to upload all the files.
I know this sounds stupid as it is much easy to provide 5 Form File fields and if user wants more then another five is added on another page, but ti is clients requirement .
I dont know how to dynamically Generate Form FILE FIELD for browsing file to upload AT RUN TIME .
I have a form with dynamic checkboxes, and normal text boxes. If the user doesn't fill out the required items and submits the form they get returned back to the form with their checkbox selection gets lost.
How do i retrieve the values already checked and placed them back.
I have a db with about 15 fields in, what i have a list of all the fields on a form, simply check the checkbox relating to that field and on the next page it creates a table only with those fields in it.
View Replies View RelatedBasically i want to pull a record from a table and based on a few records build a input form.
The idea: I want to be able to design a online logging form, using 4 fields in the table inc_label, inc_group, inc_required and inc_type.
Inc_Label is the name of the item.
Inc_Group is the name of the Group.
Inc_Requried is if the item is required.
Inc_Type is the item type.
Code:
I have the following code (part of a larger asp page) to create the user input form for creating user accounts in AD.
What would be nice is to have the radio control (in red) to be created as the result of interrogating AD to retrieve a list of containers (we have a container per office location) so that only relevant controls are available, and if a new office is opened or they shut one down, the form can stay the same. Is there a way to do this? Code:
I have a form that has both static and dynamic fields. I have no problem validating the static data, but whenever I try and apply form validation to a dynamic text box that has repeated rows, the validation does not seem to take. Do I have to run that validation through a loop? Code:
View Replies View RelatedI am am trying to write some code to perform a INSERT in SQL table using
a loop. What would be great is a way of dynamically entering in data in a
requaest.form ie the final code should look something like:
if Request.Form("type1") = "1" then
where the 1 in "type1" is dynamic so the code would look something like
Request.Form("type" & Rs.("fld_type_id") & ") = "1" then
But not sure how to form this or whether it would work, anyone have any
idea?
I asked a question earlier about creating dynamic pages.
I want to know if its possible to create dynamic form elements based on a condition equating to true.
e.g. as you could have dynamic texts when a condition is true.
Could i have dynamic form elements when a condition is true
e.g. response.write(create radio button)
or create combo box etc
or how is it done ?
Is it valid to get information from a request.form assign that to a value then use that value to get other content on the requested page.
I return a large rs with multiple feild names. I can't use a static feild def because they would overwrite each other on the loop, SO i create dynamic field names then pass the id back to the next page via javascript. I then use that id to add to the feild name to make sure I get the right feild.
Id = Request.Form("Id")
SQL STUFF
CheckedID=Request.Form("Name_"&Id)
I have a page that is populated from a db. It consists of lots of drop downs (dynamic - could be 20 or 32 or...) with the option value set as a number.
Basically they represent the skill level someone has in a skill which is you guessed it - written beside mr drop down.
So once i click on update i awnt them to all go off to the db and update. Any idea of an algorithm on how to do this. Im aware of for loops etc but i just dont see how it would work out.
I need to select the data where the data ID is equal to the variable supplied in the submitted form. Below is the line of code I used for the radio select and the code to do the SQL search on it. I get the following error using this code:
Error Type:
Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.
/MyWeb/CheckIn.asp, line 93
The items are listed by ID 1-X.
<input type=""radio"" name=""CheckIn"" value=x.value>Check In<br>
Dim junk
junk=request.form("CheckIn")
'If Session("UserType") = "User" Or Session("UserType") = "Admin" Then
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("db1.mdb")
Set rs=Server.CreateObject("ADODB.recordset")
'in below, WHERE id = Request.Form("CheckIn")
SQL = "SELECT * FROM CompsIn WHERE ID = junk"
rs.OPEN SQL, Conn, 3, 3
rs.OPEN SQL, Conn, 3, 3 = Line 93
How can I get this line to work? I am trying to get the results entered in a form to be part of my query. I am able to get the form results but I get a error stating Syntax error (missing operator) in query expression 'Assignee = Tom Jones'.Below is the line where the error occurs
Session("dbWhere") = "Assignee = " & Request.Form("assignsearch")
I am trying to use form input (like text from a texbox) in a SQL query. So that way a person can enter a value in a textbox and hit a button to check for that value in a database. I have the connection to the database working fine its just passing that form value into the SQL string. I wish the SQL query would work like this:
SQLCommand = "SELECT * FROM dahliaSchedule WHERE scheduleDate= " & txtDateValue
where scheduleDate = (a value from the textbox from the form.)
i have written some asp code on onclick of one button ,purpose is doing those work without submitting main form ,I am not getting working as files are not getting uploaded on web server any syntex error ? do u think this is write way to do so or suggest and modify code:
View Replies View RelatedI have an ASP form which only includes an option list. The list is dynamically created but includes a default value, which is an instruction "Select a group".
The code is shown at bottom. I want to ensure the user does not submit the form with the default value selected. Code:
I am having trouble with the ordering page. I would like a dynamic form list to look at a database and when the user selects a product code, the text boxes containing description and price change too to reflect the product code.
The user will be entering in their contact details, so I dont want the page to reload too because I will lose that info. Code:
i try to get data form access with asp. The select contains 2 Subselects. If i set this SQl statement in Access it works. But if i set this in ASP it doesn't. Why??? There is no error. It's completly the same statement.
View Replies View Related