ASP :: Add Multiple DB Entries By Checkbox

Filter Multiple Entries
I have a database for projects. Some managers are responsible for multiple projects. I want to dynamically populate a list of project managers, choose a manager, and display a complete list of his/her projects. I have a few problems 1) I cannot figure out how to list a project manager's name only once in and 2) I don't have a clue how to compile all the projects for each manager so that when his/her name is chosen it will display all the records.

Multiple Checkbox Only Passing One Value
I have a series of checkboxes:

<td><input type="checkbox" name="reportTo" value="Rob"></td>
<td><input type="checkbox" name="reportTo" value="John"></td>

etc...

but I only get a value passed to the database if just one is selected. If more than one is selected, no value is returned. I thought the value passed was s'posed to be a comma delimited string of all checked boxes?

Multiple Insert With Checkbox...
This is my problem... its for a mailing list with categories...

I have 3 table...

1 : Name,City,Email

2 : Categorie

3 : Name_id , Categorie_id

So when a user fill up the mailing list form, he can check as many categorie he want...

but how i can insert 1 row in my table #3 for each checkbox checked...

Can someone post me a simple script...

Updating Multiple Records Thru Checkbox
I need a code that will update multiple records on a list thru checkbox.

If the record is selected, the details that was updated on the selected
record will copy the same value as what is updated.

ASP, Access, Checkbox, Multiple Delete
I have to develop a page where, based on status some records are selected from the Access database and displayed. A checkbox is displayed beside every record.

Some checkboxes can be selected and the corresponding record should be deleted if the delete bottun is pressed.

I know how to select the records from the database and perform multiple delete. But do not know how to link the database and the checkboxes. Anybody has any ideas??

Persits.Upload.1 And Multiple Checkbox
I have an ASP script which is used to upload files with Persits.Upload.1 object. But I can't get the values from mutliple checkboxes in the form like normally.

<form method="post" ENCTYPE="multipart/form-data"....>
<input type="checkbox" name="language" value="English">English
<input type="checkbox" name="language" value="Spanish">Spanish
<input type="checkbox" name="language" value="Chinese">Chinese ....

Persits.Upload - Submitting Multiple Checkbox
I am using a form to upload images with Persits.Upload object. Now my problem is I cant use multiple checkboxes in the form.

In general forms I can use Form("checkboxName").Count to get the number of checkboxes selected and use Form("checkboxName")(i) to retrieve the value of each check box.

This doesnt work with Upload.Form

INSERT Multiple Records From Checkbox Form With Unique Ids
I have an .asp page with a form to copy job responsibilites form one
job to another. It is a hotmail type interface with checkboxes
besides each responsibility. After submitting, it should copy the
selected resp's to a different job. After that it should renumber
that job's responsibilities.

This is the code I am using now to copy:

copySQL4 = "INSERT INTO
jambue.RESP(POSCODE,IDCODE1,IDCODE2,RESP_NUM,RESP) SELECT '" & id & "'
POSCODE,'" & dept & "' IDCODE1,'" & unit & "' IDCODE2, '999' RESP_NUM,
RESP FROM jambue.RESP WHERE (POSCODE = '" & POSCODE & "' AND IDCODE1 =
'" & sourceDept & "' AND IDCODE2 = '" & sourceUnit & "') AND RESP_NUM
IN (" & Request.Form("chk") & ")"

As you can see the value '999' is hardcoded in there as the new
Responsibility Number to go with the copied responsibility. I use
this because there are no jobs with that many responsibilities. This
works fine if I only select one resp. to copy over. But if I select
more than one that part still runs fine but I get an error with the
below. It says too many rows would be affected. Of course, this must
be because there are now at least 2 responsibilites with the same
RESP_NUM. Code:

Max Entries
i'm trying to limit the ammount of entries a user can put in the access database, here is my code:

Duplicate Entries
I have a problem with Insert statement. Though My SQL Statement executed once only, there are 2 records entered in DB. I am using ASP and SQL Server. Does anybody know the solution?

Client Entries
I want to validate client entries into textbox,checkbox
controls etc. can u do this with asp. Like, is there
onchange and onclick and so on for these controls?

Overwriting Entries
Does anyone know what sort of command I need to use so that if someone posts an entry to my database with a primary key that's already been used, the old entry is overwritten by the new one

Highlighting New Entries In My Asp Table
I have setup a simple site in which users input data to an access database, and then the database results are shown on another page in a table. One of the fields in the databse is Date Added, using the date/time data type.

I would like the table to show new results with a different background colour for a period of time, say one week? Code:

Updating Numerical Entries
I have made a forum script and I know this is very basic stuff but how do you go about updating a number with an increment of +1.

Access Database - Two Tables - Topic and Replies.

In Topic there is a column called replies. When a user views a topic there is a reply form at the bottom which is processed by reply.asp which add the information entered to the database in the replies field. Also added is subjectid to each reply so I can link the two together.

Either I want to be able to update the reply number in the topic table by +1 in the appropriate subject row (the id is passed on to the reply page) or count the number of alike subjectid's in replies to the subject in topics. What is the best way and how do I update numbers by +1.

Deleting Entries From Database
i have a registration form in my website. the requests are going to the database (windows 2003 small business server). I have an other page who the entries are displayied. how i can delete the each entry separately with a button?

How To Count Number Of Entries In Recordset?
I tried the following code to save in a variable, the quantity of entries in my recordset:

if rsEntries.Supports(adApproxPosition) = true then
strCount = rsEntries.RecordCount
end if

It didn't work for me. It's returning a value of -1 and I have close to 100 entries in my recordset. Is there an alternative to this? What code can I use to accomplish that?

Limit On HTML Listbox Entries?
I have an ASP app (developed with Interdev 6) which uses
a DTC listbox (server-side) bound to a recordset to allow
the user to make a selection. This works fine until the
number of records in the record set seems to hit a limit
(not determined the exact limit, but seems to be c. 400).
If there are too many records, the app just hangs until
it hits the scripttimeout limit.

I've tried increasing
both the command timout (I'm using an ADO command object
to generate the recordset) and the scripttimeout to no
avail. Does anyone know whether there IS a defined limit
on the number of entries in a listbox? Also, any better
ideas on how to allow the user to select from a large
number of records (> 1000)?

Possible IIS Cache Issue Ghost Entries
User clicks on a button [BUY NOW], item is added to cart. User can either
continue shopping or view cart. The order here doesn't matter. When user
views cart, two items are added, the one selected and the last one in the
product file. The product file is a CSV file.

The last entry is called BAD-Product. It is a debug entry during site
development so the developer knows the product name is entered wrong, i.e.
misspelled. If the name was omitted an error would occur so there is a
name.

This only happens with Firefox and Netscape. IE experiences no problems.
The last entry is not added.

Accidental temporary solution:

In review of the code, a debug line was put in to make validate the product
item being returned. After saving the page (.asp add item page), the error
disappeared. The debug line was then commented out and the error still has
no resurfaced. Code:

Count Occurrences Of Random Entries
I need to loop the recordset and count the occurrences of each entry. The entries will always be numbers.

If entry = 1 then count(1)=count(1)+1
If entry = 2 then count(2)=count(2)+1
...
If entry = 100 then count(100)=count(100)+1

The problem is that there could be 1-100 (or more) different answers stored in the field so coding 100 IFs will work (as long as noone needs to enter 101) but seems silly. How do I create the array above to look something like:

While...
<%
strField = (Recordset1.Fields.Item("Field").Value)
CntNumInField(strField)=CntNumInField(strField)+1
%>
WEND

The above code returns a "type mismatch"

Returning NULL Entries From Access
I have a ASP page that returns and manipulates information from an access table. The information it returns is the figures for each month for certain products.
Basically the page adds up the results returned from each month and then gives a total for the year so far for each product. So we can view the figues for every year back to 2000 to see how the product did. The problem is that when we choose 2006 it returns no values, and I can't see why. The only difference is that for the months that havnt been completed yet - May onwards, there are no entries, not even a '0'. Would this be a problem when adding using the asp page, adding a number to a returned object that contains nothing?

Duplicating Dbase Entries In Seperate Dbases
I have a dbase containing login details for 21,000 members. I also have a
forum that I am about to implement.

When the user gets to the main site, he has to login (this is done by
checking his credentials against DB1) When he is logged in, all his details
are stored in session variables. Clicking on the forum link will take him to
the forum where he has to log-in or register. Currently, the forum checks
cookies to see if there is a valid name and password and then checks these
against it's own DB (herein called DB2) or requires the user to
login/register

I plan to modify the forum so that the login is bypassed and the forum
accepts the current session name and password as the login. (This is so that
all names on the site main site, chat, forum etc are uniform, i.e Dave47 in
a chat room, is Dave47 in the forum, is Dave47 in the members area etc)

so...what I need to do (if you're still with me) is.

When a new user registers on the main site, his details are put into DB1
*and* DB2. , can I have two data sources open at once?

The reason I need two DBs is that the information in DB1 is a lot less than
is needed by the forum in DB2.

Also how can I copy selected fields from DB1 (name, password for existing
users) into DB2? like I said..there's 21,000 and to do it manually would
take forever.

How To Handle Invalid Entries In Form Submission
Does anybody have a nice method of forcing a user to enter a value into a
form using asp?

I think the best is to have a popup when they hit submit that will stay on
the same page and then just alert the user to enter something in so and so
text box.

Deleting Entries From A Database; Send E-Card Later; Other Scripts
I have a database that is for E-Cards. I want it to delete all of the entries that are more than a month old. I have the date stored in a field called "dags" (without the quotes). Please help me on this!

*******************************************
Also, I would also like to have an option for "Send the E-Card Later" and then have the options possible dates. What script(s) could I use to do the actual sending on a later date?
********************************************

SQL Server - Update/Insert Multiple Cols Into Multiple Tables
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.

Searching Multiple Memo Fields In Multiple Tables In Access
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?

How To Update Multiple Records With Different Multiple Value
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.

Checkbox Value?
is there a way of having a dropdownlist and a text field with a checkbox so that you can check a box and have the vaule assigned from a option selct list or check another box and have the value assigned from a textfield?

Asp And Checkbox
I would like to make an interaction with a database using ADO and SQL. I would like to display some parts of the database using checkboxes to choose the different parts. But I don't know how to build the SQL command in fuction of which checkbox is checked.

Checkbox
I am new born kid of this block and want some help from my seniours.
I am populating the few fields values from one of the table. I put series of checkbox having same name but have a different value ( value of checkbox is small int, an autoincrement field of table).
I have to take action against the selection of checkboxes. If the user check one of the checkboxes and select "Approved the things " then the USER will move to some else page and the selection will Approve.
On the contrary, if the user opt delete the things then user move to other page and record will be delete from the table.
Now my problems is...
1) how can I know which checkbox user selected ?
2) Are there someway to get the value of checkbox without making form ?

Checkbox
i have a update page the pulles date form a database. and two the these
fields have Y or N in them and if the RS("Value") = Y the i want the
checkbox to be checked how do i do this??

Checkbox
I know this is gonna sound silly but when I submit a form with a checkbox
html control "mychk", how can I see if that is checked or not ?

I have tried :

if request.form("mychk") = true then
' code
else
' code
end if

But it always executes the code in the else statement meaning it is never
true despite the fact I have given the checkbox a value of true.

Checkbox Value
how to write sql to give value true in db?

If Else Using Checkbox Value
I have a checkbox which is used to determine whether or not the user wants to display a map of their business with their listing the value of which is being written into a database.

When I am outputting the listings I am just trying to use a simple if else statement

i.e. If(ShowMap = true)Then
Response.Write("<td>Show Map</td>")
Else
Response.Write("<td>No Map</td>")
End If

Problem is I know the database contains different values for ShowMap i.e. some true, some false. Yet when I use this code, No Map is output for all records.

Checkbox
I populate my checkboxes in a table written in asp. Each checkbox has the same value but a different name. I want to say for checkbox in the asp table, call a procedure that will do the changes. Code:

Using A Checkbox
I have a profile search where people can search through our dating profiles. I want to add a checkbox which when checked filters out those records where the recordfield pictures is empty.

I have problems figuring out what the checked value of the checkbox should be and how to use the information from the checkbox in the searchresults page to build the record set. For understanding, if a user does not have a picture the picture field is empty.

Value In Checkbox
I am trying to display the value of a true/false value in my table through the use of the following:

<input type=checkbox name=FieldLabCheck value=" &
objRecordset("FieldLaborSuper") & "></input>

it doesn't work though.... what am I doing wrong.

Value Of Checkbox
I have a checkbox in a form from which I want to collect the value.
<input type="checkbox" name="Question11a" value="a">

In the asp page that is called on submit of the form, I declare a variable, iQuestion11a, and request the value of this checkbox:
iQuestion11a = Request("Question11a")

When I print out the value to an html page <% response.write(iQuestion11a) %> it is empty.

Checkbox Set To OFF
When using checkboxes on a form, if you uncheck them, the unchecked name/value pair in the Request.Form collection doesn't show up. It only shows when the checkbox is set to ON. Is this correct? What's the workaround if it is?

Checkbox With Textbox
anyone have any idea how to do checkbox with textbox beside.

Checkbox Disable
if i want to display many records from database with each record has one checkbox.. if the record do not meet the constraints.. e.g. if supplier name has no email address.. then that checkbox will be disabled....the rest will appear.. i tried the disabled/// but no result.

How To Update Checkbox !!
I have problem in updating checkbox (true-false) using SQL statement.

Checkbox And Javascript
I have a JavaScript function that gets a boolean value and checks or unchecks a checkbox based on the boolean value.

function initialize_p(thevalue) {
if (thevalue) {
document.form.cbx1.checked=true;

}
else {
document.form.cbx1.checked=false;

}

In the example, I want form.cbx1 to be checked if 'thevalue' is true and unchecked if 'thevalue' is false. However, it's not working as desired. I used the alert stmt to see what it does:

- When 'thevalue' is true, it goes to the 1st part of the if stmt and checks the checkbox.
- When 'thevalue' is false, it still goes to the 1st part of the if stmt and checks the checkbox

It looks it never goes to the else!! I used alert stmts to see where it goes if the 'thevalue' is false (used alert to show me the value of 'thevalue' and where it is in the if stmt). I don't understand what's going on. Can anybody see what is wrong with the function?

Checkbox And Two Variables
I need to assciate two varaibles dyanmically in value of the checkbox.
How can I do that? For ex., I have the following:

<td><input type='checkbox' name='chk<%=i%>' value='<%=rs("Field1")%>'>

Above, I need to add second fields value from database in value
property of the checkbox.

Checkbox Vs Text Box
I have a form with multiple records.

My intention is to have the user click a checkbox for each product he wants.
Then submit the form placing multiple items in his cart.

If I use a text box like the following and enter a 1 for each product,
submit, no problem.

The user gets the products he wants.
<input name="qty" type="text" value="0">

However, if I use the following checkbox code, and assuming the user checks
4 products half way down the page, he will get the first 4 products in the
recordset. If he clicks 1 checkbox, he will always get the first product,
not the product he chose. <input name="qty" type="checkbox" value="1">

What I have found is when I submit the form to a blank test page using
checkoxes or text boxes, there's a considerable difference. The text boxes
deliver a comma delimination for each occurance. The checkboxes only offer
comma delimination for each checkbox that is selected. At this point, I'm
assuming that's the difference between the two and it cannot be changed
through HTML.

Checkbox Question
I have a sql database with bit datatypes and I am trying to create a asp
webform which will display and update the data from checkboxes.

Dynamic Checkbox
I have a table in ASP page which displays records and it has a checkbox whose name is ChkBox<%= intRecID %>

<%= intRecID %> is the ID of that record. Now how should I chck whether check box is not checked.

Checkbox Values
im not that good at asp, infact im using dreamweaver to make my pages up! what i would like to do is show a list of items and price in a table, with a checkbox next to them, the form is submitted and then on the next page i would like to display the the items that have been checked.
I think i have the first page sorted, i have linked the checkbox to the product ID value in the database, so i can pass that value to the next page. the problem is the second page, i can get it to show the values of the checkbox (eg items 1, 4 ,26...) but only the numbers.How do i go about using this value (number) to pull the rest of the data from the table (stored in a mdb)?

im using this in the first page form to pass the checkbox value
<input type="checkbox" name="checkbox" value="<%=(rs_stock.Fields.Item("ID").Value)%>">

on the second page i get the values get shown with
<%= Request.Form("checkbox") %>
im at a loss on how to do this