I have a difficult technical challenge I'm facing. I need to retrieve multiple values for the very bottom item in the list, 'Federated' (ignore the rest).
The database will query based off the option 'value', however, in this special case I want to perform a retrieval based off of multiple of values. I want to try to use the existing code without reinventing the wheel. Code:
I'm having problems retrieving all the values from a multiple selection field using the freeaspupload component.
I'm creating an online email app that uses the freeaspupload to add attachement functionality, which means the form encoding type is multipart/form-data. I've done something similar with the persits aspupload component, and had no problems with that, but the freeaspupload version seems to handle <select> fields slightly differently. Code:
I have about 26 checkboxes that place all of my contacts into categories so in my database for contacts i have a field called categories that contains all of the categeories that each contact belongs to seperated by a ",". 1,5,17 etc.
I need help getting these values out of the database so that when I user select category 17 they get all of the contacts that containg the 17 in their respective categories field.
I am creating an application in ASP (old school ASP not .NET) and VBSCRIPT connecting to a SQL Server 2000 back end. There is a form on my webpage that has a select box in which <option> tags allow users choose a document type.
Once the document type is determined it is sent off as a parameter in a stored procedure on the databse. The recordset returned holds the values that are required to go in another set of options boxes.
(the next set of option box values depend on the query results). I know it sounds easy...I mean I know how to do it if it where on 2 seperate pages (thats easy) where it passes on the info...but this is for ONE asp page.
I have a form where the user selects their EmployeeID from a DB populated dropdown list. Then they fill out some other information and submit the form. I would like to make it possible that when the user selects their EID, other DB information tied to that EID is displayed on that page (Name, Phone #, etc), so that when the EID is selected, the employee can see their name and info, before the form is submitted.
Is it possible for JS/DHTML to show which value is selected (without posting the form) and then use that variable to call the additional information from my DB using SQL? I would probably then show that value using <div> or something.
Sorry, I am familiar with ASP/VBScript & SQL, but I don't know a ton about Javascript. And I don't think what I want to do is possible with only ASP, unless I post my form to another page, and then that page post the final submission for the form... I'd rather keep everything on one page, then submit the form.
I have one table which has 3 fields within a SQL Database, the first is ID numbers, the second is Country and the third is City (within that Country)Eg: I have 1; United Kingdom; London
What I am trying to do is have an “optgroup” dropdown box with the Countries as the optGroup label and the cities related to each country under that optGroup. I want to populate the dropdown box with this data, preferably in alphabetical order of city. Is there a way to do this in ASP?
i want some help in how to retrieve values from multiple selection listbox. i want the values retrived to be used in the search which i perform from the database. i m doing a search feature which u all often see in job search sites. so someone selects multiple cities to search in i want that to include that in my search query.
View Replies View RelatedI have a form that send values to a second page. i m trying to compare the values received from the form with other values retrieved from a database. so if a value already exists then an error message is displayed. in order to compare the values i need to print them on the second page but I m bit stuck with this. i used request.form("category") in order to retrieve the values from the form but it doesn t work.
Reading through the CDO email articles on ASPFAQ. I see .textBody and .htmlBody as properties, was wondering if you can add BOTH to an email so that if a user has HTML enabled (lets say in Outlook) they get the HTML version, and if they dont, then it'll use the plain text version?
If this is the case please let me know as I need to finish this code this evening if possible and it would save me some testing.
I have written an article program, which has a collection of articles that people can click on and read. It's like a forum but without the reply function...
I want to write a counter for each article, but it cannot be done without cookies...my question is: how do you use a single cookies to determine which threads have been read and which haven't.
I am having a form and I want to retrieve the values of the form fields. (using ASP & VBScript)I could retrieve the value of text box, etc, but having a problem when i try to retriee the selected value in a combo box. My code:
View Replies View RelatedI have a form search page with many field options but this one field I would like to select multiple options.
I have this on the search screen for my multiple field where I pull the list of options from my database: Code:
I am using a db to hold student data records. I currently display them in a roster based on their affiliation with a certain class. To edit a record I need to click the name of an individual, it opens an edit page, I make the changes, hit submit and return to the roster.
This is pretty standard stuff. What I would like to do is change one field of every record without opening each record individually. The idea comes from my Fantasy Fball league roster:
McNabb, Donovan QB PHI ActiveReserve
Droughns, Reuben RB DEN ActiveReserve
Johnson, Rudi RB CIN PIT ActiveReserve
...etc...
Where the example above says "ActiveReserve" is a pull down menu that lets me change who is playing week to week. I can then change each record, hit submit one time, and update the db. So how do they do it?
How Can I extract multiple tiff images into single images through asp
programming?
Is there any free dll's that I can use in ASP to split multiple tiffs into
single tiffs?
I'm building a page to display a series of records but wanted to filter the results by location and display the resulting records under their own sub-heading.
All the records are in the one db table and there'll be a total of 5 queries.
I'm unsure whether I need to open and close the connection for each query, or whether it's better to open one connection, run all the queries and then close the connection at the end, if so, the resulting code would look like: Code:
I'm trying to create a single form to update multiple records in a database (Access). Similar to an update qty's in a shopping basket, whereby, on submit/update it passes and updates each record, without using the ONCHANGE feature (otherwise this would become an extremely laborious task in this application)
I've tried passing and updating an array but to no avail (maybe I'm doing something wrong)
Also, I can't seem to grab the contents of the form text field, even though I'm dynamically assigning names to each text field.
Should I be using Javascript to handle the change in values, if so, anyone got any sample code/helpful links?
I already have this piece of code that inserts multiple rows of data into a single table at once. Code:
View Replies View RelatedThis is a simple question, but is been a while since I program in ASP and I forgot.
I have a variable like this: 01-00005-03
I need to have 3 variables from that single one... Something like this, from that variable, let for example that is called fullvariable, split it and get the following variable values from it.
variable1 = 01
variable2 = 00005
variable3 = 03
I am having a slight problem. I have an asp page called custfeedback.asp. This page contains fields where the customer fills in name, email address comments etc. The form gets submitted to feedback_complete.asp, where a message is displayed thanking the user.
My problem is that the variables in custfeedback.asp are not "retaining" their values when the user is redirected to the feedback_complete.asp page. I know the asp is working, because I have the following line in that displays correctly:
<% Response.Write (now()) %>
I have no idea why the variables aren't retaining their values. Does any one perhaps have any idea how or why this is happening, and how to resolve this problem?
i am creating an website using asp. In one page i am using dropdown combo box having multiple property true, so that user can select more than one values from dropdown box. when i am submitting form in querystring it gives dropdown box & the value of selected option. Code:
View Replies View RelatedI'm trying to retrieve 2 values from a table (product stocknumber & description) that match a form result (product ID number) to send with the "form results email". Not quite sure how to do this. Code:
View Replies View RelatedIn my Access database I have multiple images for some of the records. What is the best way to retrieve and display the multiple images. I am storing the images in a folder and only the path in the DB.
Some of them have just 1 image, some 2, some 3 and so on. I have the record ID # and the image name same, for eg. if the record id is R01 then the image name would be R01.jpg if there is only 1 image otherwise R01a.jpg, R01b.jpg, R01c.jpg etc. Is there any way I can open the folder and check for the name and list the image file names as a link to display the images if the ID name and image name matches.
I am working with IIS 5.0 and would like use the property CentralBinaryLoggingEnabled which if set true will create one single binary log file in place of a separate log file for multiple websites.
This property is available in IIS 6.0. I would like to know if there is a patch available for IIS 5.0 which will create this property in IIS 5.0.
I am currently validating a form using javascript. This checks empty fields and that email is correct. Do I also need to do these checks server side? Does anyone have a good link to info on server side validation ie. empty fields, data type, email a valid email etc?
View Replies View RelatedI've got multiple pages on the same server that all have the same drop down
boxes in them. It is a list of all our facilities. Every time there is a
change, I have to change it on every page. They are in the format below. Is
there an easy way to store all that data in a text file so I only have to
update it one place?
<option value="fac 1">fac 1</option>
<option value="fac 2">fac 2</option>
<option value="fac 3">fac 3</option>
I have a database with many tables. I have many objects on my form, textboxes, checkboxes etc... I need to populate a second drop down box after selecting the first drop down box with out the user clicking a button, Yes Master I know how to do the JavaScript onchange but every thin I have looked at uses hard coded data in their example. Can you give me a form example using you tutorial DB of multiple DD Boxes.
View Replies View RelatedI 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:
I have an interesting situation that needs to be addressed ASAP.
I am running a standard SQL Query in ASP to retrieve some rows/columns from a table that's on a SQL Server 2000 database. I put the results of that query into a RecordSet, and then use the GetRows function to push the results that are in the recordset into an array variable. In the query that I am running, 39 columns and 2 rows are returned.
The GetRows function appears to be working - the array variable is being created with the proper dimensions. However, the values of the different "cells" of the array are not showing up correctly. The first and the last column values for each row are correct, yet everything else in between is blank, empty, NULL, or whatever.
In other words: ArrayVariable(0,0) shows up correctly, ArrayVariable(38,0) shows up correctly, but everything in between is null.
I did a test on the RecordSet and discovered that it was the culprit - it wasn't being filled in properly. This is strange, though, because the select query that I run in the ASP code to create the recordset returns perfect results when I run it on the SQL Server 2K database.
How do I pass in more that one variable in the form tag below
code:
<%
Dim CmdPopulatelist
Set Conn= Server.CreateObject ("ADODB.Connection")
Set CmdPopulatelist = Server.CreateObject("ADODB.Recordset")
%>
.
.
<% sql_select= "select * from Patch_Feedback where Patch_name= '"& view_name &" ' and Name_of_user = '" &Name_of_user &"' " %>
<%
Conn.Open "DSN=Patch;uid=cmadmin;pwd=dci01;database=cm_db"
Conn.execute(sql_select)
CmdPopulatelist.Open sql_select, Conn
%>
.
.
.
<form method ="post" action="updateresponseA1.asp?update_ID=<%Response.Write(""& CmdPopulatelist ("Patch_ID") )%> ">
I have code that is looking at the userlogin name and then assigns them to a certain value, thereby allowing them to see certain groups of reports on a website. If I want them to have multiple values, how would I code this? This is what I have so far:
if strUser="jdoe" or strUser="jsmith" then
how can I compare a values to multiple string values. i.e.
If Request.ServerVariables("REMOTE_ADDR") = "213.123.214.33" Then
WriteLine "A problem has occured, please email for help<BR>"
end if
Would it be to do multiple if the elses, case or can you put all the possible values on the one line? i.e. "123.123.123.23" or "345.234.234.234" etc.
I've a multiple checkboxes and would like to insert those values into the db. How can we insert all those checkboxes’ values into 1 field (DB), we use a stored procedure. This is urgent
View Replies View Relatedhow do i insert multiple values into one database fields using ASP.
View Replies View Related