I'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 RepliesI like how you can use the Fields collection to create tables but is there a way to dynamically produce a table and filter out certain fields without having to write the entire table out manually? For example, I don't need the record's ID field in the table.
View Replies View RelatedHow can I retrieve the values one by one from a variable
like this: chgID=48, 51, 52, 53, 54, 56, 57, 59, 58, 46, 61, 60
Actually I am getting this, from a form and I want to update records
in database filtering with these IDs one at a time. I guess 'For Each'
loop can do this work done, but How??
I'm trying to retrieve information from a field in a database, which contains data, some of which are the same. ex:
let's say the table is called "Person_info" and there are 5 rows of info with a different person's info.
let's say i want to display the info in the fields called "City" but there are duplicates ex:
Toronto
Vancouver
Toronto
New York
Atlanta
I'd like it to display all the cities in there on a web page, but, I don't want it to display the same city twice:
so it'll display this:
Toronto
Vancouver
New York
Atlanta
I just can't get it to work? it keeps displaying duplicates.
I am currently working on a document management system for my company's Marketing department. They wish to be able to upload files to the server.
Rather than deal with the many permissions issues we have had in the past with saving and deleting these files to the server's file system, this time we are trying to use SQL server BLOB fields to store the files.
The premise is simple -- a user clicks on the link and the file is then shown in the browser. The documents are mostly word, Quark, and Adobe Illustrator documents. I was thinking the code would go something like this: Code:
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.
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 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 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'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 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 have an INSERT statement with information being pulled(upload.form) from the form. Example, text field named SubmitIssue1 will populate field SubmitIssue field in the database. SubmitDate1 will populate field SubmitDate1, and so on. However, what I am trying to accomplish is to expand the form to allow the user the ability to add another instance of an issue where they will use the SubmitIssue2 text area.
I want to pull their name and email address from the top of the form and use it as well as this new information in the SubmitIssue2 textbox to create a new record. The information from SubmitIssue2 will populate the SubmitIssue field. HOW CAN THIS BE DONE? Please help with some examples of how this would look. Code:
I've got a really strange problem I can't explain - when I add new values into my database (Access) ir multiplies them by 100 - for example id I enter the values:
10.50
7.50
5.50
They go into the database as:
1050
750
550
The field in Access is a Double type, nullable, and set to default to 0.
My code to add it is: (the response.writes are what product the numbered output above - so I know what the form is posting, and subsequently what the database has in
its fields) Code:
[Number of query values and destination fields are not the same.]
This file has worked with another project of mine but can't understand why it doesn't work with my current project.
I've look at the fields being queried and the fields being inserted and they are exactly the same. I basically made a copy of the main table and called it an archive table. So this is just taking out of the main table and inserting into an archive table. 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.
does anyone know how to define own Collection objets in ASP (not
ASP.NET!) and VBScript? Is it better to use the Collections or the
"Scripting.Dictionary" object?
I am doing a project and I have a form in which I am putting information inside cookies then I am to display the information in the cookies on another page. So when they click submit they goto this page and this is my code:
View Replies View RelatedHow to pass a collection from a VB Component to an ASP page? I have no clue
the syntax of all. Code:
I found this piece of code to collect info from a form and then display the information.
I created seperate programs - one with the form and the other with the asp part to display the collected information.
How can I collect information in one program using "post" method and display it and get an okay from my users before I update the database? Code:
I am processing a form and I want to double check that a field is defined so that no error occurs. How do I check if a key exists in a collection (the Request.Form collection)?I do not want to process all of the fields in the form, so I do not want to use "For Each x In Request.Form". I process a certain list of fields and just in case the field was left out, I want to prevent an error from occurring from trying to use a key that does not exist.
Code:
For Each x In arrayFields 'arrayFields contains certain field names
'verify that field actually defined
If [field is a key in the Request.Form collection] Then
stringTemp = Request.Form(x)
'do stuff
End If
Next
How is it possible to instantiate an new collection in asp serverside?
View Replies View RelatedI'm looking for a template "add / delete" collection box... where one could browse to a file ... click add and that file gets added to the collection
the same operation can be done to delete from the list... i guess similar to the basic functionality to a shopping cart..
I'm working on an ASP/Javascript page with frames, and I need to access the properties of an image in the "top" frame from a script launched by the "middle" frame.
When changing the properties in the current frame, I use
document.images.image3.src = picArray[randomNumber]
Of course, that only works if image3 is in the current frame. Is there a Frames collection that I can use to access stuff in another frame?
I would like to tap in to all the brilliant minds out there through the means of this question. Is it possible to have a function in asp that returns a collection of items?
If so could you please direct me to some code that may provide some insight to how its done. I've tried using my limited coding capacity but no success.
I want to expire a cookie collection in my asp page and I gave it like this;
Response.Cookies("whereq").Expires = Now()
and this "whereq" collection has 50 keys. The problem is my cookie didn't expire from the above code. I hope there should be a way to do so without writing 50 expire lines.
I am trying to create a string that is cencatenated from values in a form. The form pulls in the values in a reocordset and displays each record in a row with a checkbox.
I want to cencatenate the values of the ProjectName field if the checkbox (isChecked) has been checked when the form is submitted. Here is the code that i am using:
<%
If (Request.Form("Submit") <> "") Then
Dim Criteria
Criteria = ""
For Each Item in Request.Form("ProjectName")
If Request.Form("IsChecked") Then
Criteria = Criteria & Request.Form("Projectname")
Else
Next
Response.write Criteria
End If
%>
If I get rid of the If then else statement with in the For Each statement, then all of the items will cencatenate. I am just trying to grab the rows where the user has checked in the box for the row.
can anyone tell me why it is that when i do (see the code>)
1 the value of the submit button doent match?
2 the collection returns the collection string as line one?
3. how do i jump these 2 for error check and trim replace?
Code:
Is there a way to manipulate (ie change) the items in the forms
collection. I simply want to get rid of the infamous apostrophe in input
from a form, replace ' with ''. I had hoped to be able just to make the
change and then put it back into the Form.item. Is there a way to do
this?
If not, would the best way to save the result be to build an array,
which is then used instead of the forms collection? Code:
I have several hundreeds of DVDs, and friends often call
me to borrow some.
I'd like to be able to have my entire collection on my
web page (i have everything in a database already) and
let them browse for the title they want, then "check" the ones
they need and see if they're "available" or not.
Then this would send me an email with the titles and the name
of the person requesting them.
Is there any ready to use solution or should I just jump into
developing it myself?
If there is something, any link to a product like that?
Something simple: title, cover picture, available or not.
I have an asp page in which i have a combo,in change of selected index of combo i am putting the combo value to a hidden variable then submitting the form like this
form.hid.value=1
form.target;
form.submit
and again while loading the form i am checking for the value like this .request.form("hid") but i am not getting the value .what could be the problem.the method of my form is post only.
I have an asp application that I install on quite a few different servers. omally this works fine and I have never had a serious issue with it untill today.I installed the site in the normall way and was able to browse to it. But as soon as I submitted one of the forms in a page, nothing gets passed through the forms collection.
I found this strange and immedatly placed in code to iterate through the collection and display all of the values, but the collection is empty and no variables have been passed at all.
has anybody experinced this issue before and know how to fix it, I have been looking through setting in IE as I though a security update may have changed something, I'm not too sure if this is a browser issue or an IIS issue.