How To Check If A Specific Record Was Checked Off In A Form.
I have a server using a webapp built on classic ASP, and I use a library that creates/manipulates a datagrid-style display on the page.
I am displaying a large chart with sufficient data that it will likely be paged, and there are several columns that are toggles (using checkboxes for these, with the entire column having the same checkbox NAME, but different values depending on the record).
I have a piece of script that for loops through the records present on the page (determined by a collection of hidden form values), and then I need to check if the collection formed by a given column contains that value, something like the following (pseudo-code):
View Replies
ADVERTISEMENT
I hope that subject title made sense, but I am looking for a way, and I am not sure if it is ASP or Javascript, but I only want a particular check box to show up if another particular checkbox is checked.
So I have like 5 options, but a "hidden" 6th option. If option #1 is checked, I want option 6 to show up. But if option 2 - 5 is checked, I don't want option 6 to show.
View Replies
View Related
I have a database with two fields: product and photo. The page should display pictures of the product, which are on the photo field and if there is no picture (in this case there is no registers in the database) I need to display a message like "hey dude, no pics right now". Code:
View Replies
View Related
I have a few ASP pages that go out and query a database and return data that meets a requirement. For example I have Department hyperlinks in a Nav bar that select just the records associated with that department. The returned records are placed in a table to be viewed. In that table I have a field hypelinked to a PDF image. 100+ records could be returned.
How could I place a hyperlink, or check box, in one of the fields that would select that specific record and display the data on another ASP Page. What I am trying to get at is when I get the returned set of records, being able to click ONE of them and display that information as well as any associated images connected to that single record.
View Replies
View Related
i have a shopping cart that gets its information from the cookie.
is it possible to add a remove item to my shopping cart so that i can delete a specific item from my cart?
View Replies
View Related
I am developing a budget app using asp, access and Dreamweaver. What I need is a way to loop so that I can display months starting with a designated begininng fiscal month. In this case it is July. I need to display 6 months in a row starting with July and in a separate table below I need to display the rest of the months in the fiscal year Jan - Jun. Like so....
7 8 9 10 11 12
1 2 3 4 5 6
I think it will take two separate while loops.
View Replies
View Related
cmdTemp.CommandText = "Select * From users"
cmdTemp.CommandType = 1
Set cmdTemp.ActiveConnection = DataConn
rstContacts.Open cmdTemp, , 1, 3
rstContacts.Move CLng(Request("Record"))
i only want this command to display from the users table the details
of the user that has the username (from the database) equal to the username of the person who has just logged in from my login form (uname input box) this code at the moment displays the first record, i dont want that.
View Replies
View Related
I'm reading data from an XML form and prepopulating a FORM. For the text inputs I have no problem prepopulating the Values from the file...
document.forms[0].elements['FormName'].value=xmlObj.childNodes(0).childNodes(0).firstChild.text;
But one of my fields is based on input from a radio input (three inputs with a value of 1,2,3). Since they all have the same name using the code above will not set they value for any of them. Anybody else run into this, or have a suggested way I should do this.
View Replies
View Related
I have a database with two tables:
Table 1: Human
Table 2: Exempt
I have created the following code for creating a record, which works fine. But what I would like to do is to check if I add a record on the "Human" table to verify if the record number already exists on the "Exempt" table. I have already created an error handler for it to check if it exists within the same table which works fine. But I can get to do the rest. I created a separate file where I created two functions, but I don't think I did it right. Code:
View Replies
View Related
I want to know how to check if the record I am about to add already exist? I would like to refer to the field of "icno" in the database. Code:
View Replies
View Related
I have a database in which I have to on a daily basis enter the information for that day. I would like to update this on a bi-hourly basis to prevent any possible data loss.
Using INSERT INTO, I create a new table line. Using UPDATE, I get an error on the inital creation of the table line.I am really unsure how to check to see if that line exists or if there is an easier way around this.
View Replies
View Related
How can i check if a vlaue exists ? Sample to get the idea: Code:
set con=server.createobject("adodb.connection")
con.open "Menu1"
sTempquery ="Select * FROM Voorkeur Where gebruikersnaam = '"& Request.Servervariables("LOGON_USER") &"'"
Set autor=Server.CreateObject("adodb.recordset")
autor.Open STempquery, Con
The idea is that if the "LOGON_USER" does not exist in the Dbase he must execute code. How can i do that?
View Replies
View Related
How can I check that the form is not posted from a local html page As title?
View Replies
View Related
how to write to check verification valid email thru nslookup or mx record or dns record. Is it possible to do that. Is there any tutorial from sitepoint, previously found it but i lost the link.
example to check assume test@domain.com is not a real email, abc@domain.com is real email
how do u check it.
View Replies
View Related
I have a page that processes a form and one of the fields might be empty as it's optional if it gets selected or not.
In my process page I would like to check if the form field news_image is empty or not.
How would I do this?
<% If Request.Form("news_image") = "" Then %>
Is that how you do it?
View Replies
View Related
I'm working on a form where the user is not required to fill out every text input. How mught I check for that in an ASP script. Here's what I have:
If Request.Form("mp3title1") == ""
amnt = 0;
Else If Request.Form("mp3title2") == ""
amnt = 1;
Else If Request.Form("mp3title3") == ""
amnt = 2;
Else If Request.Form("mp3title4") == ""
amnt = 3;
Else If Request.Form("mp3title5") == ""
amnt = 4;
End If
Pretty straight forward, its checking in order if the first element is left blank, is the correct technique:
== "", or is there more to it?
View Replies
View Related
How can I check to see if a form element exists on a form that has been submited? I have a load of checkboxes called box1 box2 box3 etc. I want to create a loop which gets the value of the box (checked or not), but there is an unknown amount of boxes so I want a loop:
Do While (box(i) exists)
check value
i=i+1
Loop
how do I do this?
View Replies
View Related
I have this page set up at www.kevinhall.org/headcount/headcount.asp
what is the easiest way to check where the user has entered a value
and submit the row to the db. Maybe i'm going about the form wrong.
Each box has its one name but I was hoping i could get around using a
request.form on each one and useing the isEmpty. Its so tedious and
non efficient there has to be an easier way.. Maybe with .net possibly?
View Replies
View Related
write a simple function to check the user input from a form. I need to check that the string contains only numbers, has a maximum leght of say 15 and that the first number is zero.
View Replies
View Related
I have a web page that creates dynamical forms, depending of what kind of product it regards. When the user has chosen a product, data is collected from SQL Server and a form is created.
Some forms contains check boxes and some not. My questions is: How can I check if someone has UNCHECKED a check box? Because if that happens, I want to delete that entry from the database.
Since a form just posts the value of a check box if it is checked, this causes a dilemma.
Any ideas, I can't be the first one having this problem?
View Replies
View Related
From the past I have been adding records with a form with 2 pages.
One with the form and the other a add.asp page to actually take the values from that form and add to Access database.
Just for example I had the form on:
p1.asp and when they click submit it goes to
p1add.asp and adds it, but is there a way to add it with just p1.asp?
View Replies
View Related
We have a facility on our intranet where users can log problems, comments &
suggestions about the site to a DB.
I'm building a page that lists the outstanding entries, and allows use to
mark any number of entries as being 'done'
That is, we have a number of rows, with the last field in each row being a
checkbox to indicate the entry has been dealt with. At the end, there is an
Update button which submits the form.
The question is.. how to handle this...?
The best solution I have thought of so far is to use the record ID as the ID
for each checkbox. Then to Split() the resulting Request.Form into an array,
loop through the array picking out the record IDs.
It's not a bad solution, but I figured this must be a fairly common
procedure and that somebody might have a slicker way of doing it...
View Replies
View Related
I am trying query the data from db and populate in the web form's textbox field. so far I cannot put that record into the text field box. anyone has idea on that, below is my sample code:
View Replies
View Related
I'm new to ASP so I'm using DWMX as a crutch. It created the db connection and recordset code for me and all I want to do is have the page update the db with the result of a variable.
In plain English, I'm trying to update a field called Score in the table quizOne with the results of the variable score where the username field matches the session variable MM_Username. The recordset is called update_score.
Based on other tutorials and forums, I tried this: ....
View Replies
View Related
In my SQL Database, I have some records that display a single zero '0' in a field called ORACLE_ANAL. However, on my dreamweaver Form, when a record is selected, i wish to have the single zero '0' displayed as Four zeros '0000'. Is there some code I could use to have the 0 diplayed as 0000 on the dreamweaver form.
View Replies
View Related
I've got the following problem:
I'm retrieving data from an SQL Server database. And I want my form to
display a checked box in the state corresponding to the value saved in
the DB. But somehow that doesn't work!?
SQL tells me the value is 1.
My ASP page tells me it's 'True'??
So I tried it like this:
<input name="checkbox" type="checkbox" value="checkbox" <%If
rsDemande.Fields.Item("lien").Value = 1 Then Response.Write("
checked='checked'") : Response.Write("")%>>
and like this:
<input name="checkbox" type="checkbox" value="checkbox" <%If
cstr(rsDemande.Fields.Item("lien").Value) = "True" Then Response.Write("
checked='checked'") : Response.Write("")%>>
But neither works. The checkbox remains unchecked!?
What am I doing wrong?
View Replies
View Related
I'm retrieving data from an SQL Server database (the data itslef was
entered by an ASP form). And on an 'edit form' I want to display a
checked box in the state corresponding to the value saved in the DB. But
somehow that doesn't work!?
SQL tells me the value is 1.
My ASP page tells me it's 'True'??
So I tried it like this:
<input name="checkbox" type="checkbox" value="checkbox" <%If
rsDemande.Fields.Item("lien").Value = 1 Then Response.Write("
checked='checked'") : Response.Write("")%>>
and like this:
<input name="checkbox" type="checkbox" value="checkbox" <%If
cstr(rsDemande.Fields.Item("lien").Value) = "True" Then Response.Write("
checked='checked'") : Response.Write("")%>>
But neither works. The checkbox remains unchecked!?
View Replies
View Related
How would I get the max record + 1 to auto-populate in the GMVINC form field? I have a feeling that my query is not correct. Code:
View Replies
View Related
Within a submitted page that has mutilple checkboxes with
the same name, the request.form("mycheckboxes") has a
comma separated list of the values of all the ones
checked....
but I also need to know which ones are not checked... How
can I know that ?
View Replies
View Related
i m getting value of blnPermit is True .but still not show my checkbox as checked .alredy spent a hour for this. what i m missing? Code:
<input type="checkbox" class="checkbox" id="blnPermit" name="blnPermit" onClick="ChangeStatus()" <%if blnPermit then %>checked<%end if%>>dd
View Replies
View Related
I have two columns in the database table where one is the "id" and the other "text_data".
I filled on a page checkboxes for the id and textareas for "text_data" per id. Code:
View Replies
View Related
How can I show a checkbox as checked based off of the variable stored in a database?
View Replies
View Related
I have two columns in the database table where one is the "id" and the other "text_data".
I filled on a page checkboxes for the id and textareas for "text_data" per id.
<input type="submit" value=" Search " size="100" title="Search everything selected">
for....
<input type="checkbox" value="<%=RS("id")%>" name="id"><br/>
<%
Response.Write "<textarea "
response.write "name=""Keywordh"""
response.write "value=""Keywordh"""
response.write "rows=""3"" "
response.write "cols=""64"">"
response.write "</textarea>"
next....
There must be something wrong right of the start because when press "search" without checking anything it searches every textarea within the for-next loop. My intention is to search ONLY the textareas that are checked.
But I'm also wondering if it is necessary to have a textarea to make these searches. Is it possible to simply slap the "text_data" alone in the for-next, check the ones I choose and search?
View Replies
View Related
