ASP :: Adding From SELECT List

Adding A Drop Down List
I have an asp page that creates a table from a Ingres II database. The headers at the top of the columns are hyperlinks that ad a order by to my list. This was all working fine until I added more choices with a drop down list view_type .

Now I am getting this error:
ADODB.Recordset error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. I am thinking it has to do with when my list is reordered it does not know which view type and is not going through the count. Code:

Adding Recordset In List Box
I have 2 list boxes added in the asp page.

First list box contains :Industry (Items added from Industry Table)

Second List box should contain items from Area table.

Industry Table:={id, Industryname}
Area table-{id, industryid(from industry table), areaname}

I want to add Items of the same industry id selected in first combo box
The items should be changed as the inustry selected in first list box changes.

Adding Elements To Dropdown List From Popup Window
I am designing a website to records details of people who visit our company. When entering a visitors details I wish to record the company that they work for, to save the user time a dropdown list of companies is populated dynamically from the backend (Oracle) database. In the event of a company not existing in the database the user would have to go to the page to add a new company and then come back to the form meaning that they would lose anything they have already entered.

What I am trying to do is to enable the user to click on a link which will bring up a pop up window into which they may enter the new company, on closing down this popup the new company will be added to the dropdown list.

So far I have got the popup to display and to accept the user input and I have inserted this new company name into the database with a unique reference number generated by a sequence and before_update trigger. The following code is for the popup window and accepts user input, writes it to the database and closes the window: Code:

Adding A New Entry To A List Menu Based On A Database
Let's say I have a dynamic list/menu, which gets its values from a
database table, for example a list of contact people where the value is
an ID number and the label is the name. However, if the value the user
wants is not in the list I would like to place a hyperlink which
will...

(1) open a small window, with an ASP form to allow the user to add a
new entry

(2) save the entry to the database

(3) add that value to the list/menu in the parent window and make it
the selected option

(4) close the small window and return to the original window.

I can handle the code for 1,2 and 4, but 3 is what I'm not sure about.
I don't like the idea of forcing the user to leave the current screen,
go to some other form, add the entry they need to the lookup table,
then come back; this seems like a logical approach, but just wondering
how to make it work.

This seems like a common enough situation; anyone have any code samples
or suggestions about how to do this?

Select List
I have a select list which get populated from com but i option value ALL is hard coded on the pageWhen any value is selcted from the list box and form is submitted pages refreshes with the value as selected in the drop down but if All is selected the page ref but All doesnot get selected.

<LABEL for="MyList"></LABEL>

<SELECT id="MyList" name="MyList">

<%For icount=0 To intmyCount%>
<OPTION
<%if Trim(arrmyType(icount,0)) =strmytype Then%>
SELECTED
<%end if%>
VALUE="<%=Trim(arrmyType(icount,0))%>"><%=Trim(arrmyType(intCtr,1))%>
<%Next%>

List Select Transfer
What i would like to be able to do is have two listboxes side by side, one will have all of the main categories and the second will have all of the sub categories in it.
I populate the first list by using this code:

<option value= "<% = rs("cat_id") %>"><% = rs("cat_name") %></option>

Now what i would like to do is when the user double clicks say the second item on the list, the listbox next to it will display all of the items that are under the main category they just double clicked on

Select List Box From Array
I have a string that was populated from a listbox. Now I want to bring up the record again for edit and want the listbox to have those records selected ONLY. I am close I think. Currently, it selects all records.

<%
HearingIssues = RS3(0)
HI = Split(HearingIssues, ",", -1, 1)

For i = 0 to ubound(HI,1)
sString = Instr(HearingIssues,HI(I))
if sString = 0 then
%>
<option value="<%= HI(I)%>"><%=HI(I) %></option>
<% else %>
<option value="<%= HI(I)%>" selected><%= HI(I) %></option>
<% end if
next

Select (dropdown) List
I have an old application ( pre-VB5) that I need to add a select/option list to. This is an edit program so the values for the form will be retrieved from a database. How do I set the value of the dropdown with the value from the database. The value in the database is either new, trial, maint., employee, beta, or null. I need to set the dropdrown to one of these values. An example of the select;

<td>
<select name="ordReason">
<option></option>
<option value="New">New</option>
<option value="Maint.">Maint.</option>
<option value="Trial">Trial</option>
<option value="Employee">Employee</option>
<option value="Beta">Beta</option>
</select>
</td>

Select One Of The List Boxes
I have two list boxes . User can select multiple values from the lists. Is there a way I can force that the user can select from only one of the list boxes? Can I associate the radio button with the list so that as soon as user selects the radio button the other list box turns grey(not letting the user to select anything from that list).?

Multiple Select In Dropdown List Box
How to make multiple select in dropdown list box using asp and access.

Complete An Access Table Through A Select List
I would like to know if it is possible to fill in an access table through a select list inside an APS 3 web page. If yes, how ?

Populate A Select List From A Comma Delimited Txt File
I would like to use ASP to populate a select list from a comma delimited txt file.....

How Can I List All The Email Address From Hotmal Contact List?
How can i list out all the email address into my website from the hotmail caontact list? i am successful log in into the yahoo contact list by using serverxmlhttp and list out all the email address from the page source, but i could not access to hotmail by using the serverxmlhttp. Is any other methos can list out the email address from hotmail contact list?

Error Using <select></select>
I have written some code which should dynamically build a table which is then populated with questionas and possible answers. The format of the answers will vary ie they may be in the form of a radio button which will be rated from 1-5, checkbox or a selectbox.

The first problem I have is if I do not comment out <select></select> I get an error message saying the page can not be found. when I do take it out I get asp timeout. Code:

Adding Bcc
I have a form on my asp page that sends data to an emailing script. I am working with other peoples code which is causing a lot of hassle. Is there any way of sending a Bcc address command from the form rather than the emailing script?

Adding
I wanted to know how I should go about doing this. I have this query:

SQLmax="SELECT Max(OrderNumber) AS intTotal FROM Status"

Which gives the Max(OrderNumber).Say in this case it is giving out put as 37.

Now i want the output to be displayed 38,which can be done by adding 1 to Max(OrderNumber).

Should i get this by doing this way?

var=RS(intTotal)
var=var+1
Response.WRite var

Is this right?

Adding Second Value
Im using this code to pass a value to a variable:

<a href="Artists.asp?cat=<%=Server.URLEncode( rsuser( "art_Artist" ) )%>"> <%=rsuser( "art_Artist" )%></a>

How do I add another value to this link with the variable name catArt so that I can add:

?catArt=<%=Server.URLEncode( rsuser( "art_Artist" ) )%>

Adding New Row
what do you think is the best way to implement an "add new row to table" functionalilty?
am using asp(obviously )im currently using document.createElement with javascript, but im having a hard time retrieving the data.am also thinking if this is really the best way to do this.or if this would work with all other browsers other than IE...

Adding Pwd
how to add a password to using this connection string

<%
set conn = server.createobject ("ADODB.connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("dat48372.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
SQL = "SELECT Price FROM DABRadios WHERE (ID LIKE 6)"
rs.Open SQL, conn
showall=true
%>

Adding In Asp 3.0
i have a id1 field which has data like this 002,003,004 and i have to increment it by one when i add a new customer so this is what i do

Set rs1 = Server.CreateObject("ADODB.Recordset")
sql1="Select Max(id1) from table2"
rs1.Open sql1, Conn ,2,2

maxid=rs1(0)

so i get the maxid for example as 003. the next record will be added and it should be 004 and i do it in this way maxid= maxid+1

but when the record is added the id1 field has a value of 4 instead of 004

Adding Different Fields
Say I have to different recordsets that have the fields:
rsA.Fields.Item("A").Value ,rsB.Fields.Item("B").Value

How would I add those to fields? It may be my inexperience but when I
tried something like

rsA.Fields.Item("A").Value + rsB.Fields.Item("B").Value

didnt work because one of the fields was a empty value. I have about
6 fields i need to add together if a value exists in any of them.

Suggestions?

Adding Data On Its Own!
I want to fix this problem, i dont no how. Bassicly there is blank data appearing in my database, for no apparant reason! Code:

Adding New User
How can I add a new user on my server using ASP?
User example: myserver/user1

Adding Pictures
I'm new to ASP and a few querys

I have created my database in Access with the following fields

StockCode (Text Box, Primary Key)
Item (Memo)
Price (currency)
Picture (memo)
OnOffer (Yes/No)

and I know that access table cannot have a picture in it, only a access
form using OLE, but how do I get my asp page to display a picture for
every record? The picture would be a picture of the product with the
Stockcode as the filename - m001110.jpg?

Adding Form
I have an ASP page with a table that fills with records from a loop. Every
row gets a link to another ASP page with data from the row. The link is
written as <a href=newpage.asp?value1=xx&value2=yy .... and so on.
Now I try to let the user specify a number that should be sent to the other
page. But I do not want to clutter up every row with each an input field,
so I thought instead I would place it above all the data rows. When the user
clicks on the link, I want to include the input field to the querysting. The
problem here is that I cannot figure out how to refer to the name of the
input field.

Adding Size
I have just finished building my first shopping cart in asp and MS Access. Originally the shopping cart was to be built for products with no size and colour, however as usual the goal posts have moved and I now need to incorporate a size and colour option for each product. Could anyone explain to me how I can go about doing this i.e. adding the different sizes and colours in the admin website and then linking them to a specific product when it is displayed on the products page? I know they both need to be in a dynamic drop down box when displayed on the products page within the shopping cart, but I am just wondering how to read the correct values out from the table depending on which product is being displayed. I have a normal products table at the moment with general fields i.e ID, name, description etc.

Adding Header
I have a web page hosted by server1. I need to add a link to a web page hosted by server2. This part is simple. However, I also need to give the linked web page the user id for the user that was validated in server1 (it's in a session variable).

At first, I thought the following would work:
mywebpageonserver1.asp:
Response.AddHeader "MYUSERID", "whatever"
Response.Redirect "http://server2/mywebpageonserver2.asp"

On server2, mywebpageonserver2.asp:

Adding Up Values
i have a page that enters numbers stored in different values e.g monday tuesday wednesday thursday friday into a database. is it possible in asp to add those values up and store the added up value in a seperate field in the database
bascially
total =monday+tuesday+wednesday+thursday+friday
How would i do that in asp.

Adding Recordset
I am using Dreamweaver MX to create ASP and MS SQL Server for database.
I got a few fields like Value1 - Value5.

So i have create the recordset of the 5 fields and i am extracting the total count of each field. Now i got 5 recordsets showing the total of each field.

So is it possible to add the value of the 5 recordset together into one value?

And is it possible to use the value of the recordset to do some simple math addition, subtraction, multiplication and division?

Adding Picture
I need to add a ppicture to my Database.. The table is accessed through ASP Recordset but having troubles trying to insert an individual picture to each record?

Adding Records
I have a table with 2 fields, name and value

I need to be able to add multiple records quickly, for example I need to add

name value
abc 1
abc 2
abc 3
abc 4
abc 5
abc 6

etc etc, does each record have to be added separately, or is there a way I
can add a chosen number of records, lets say 10, and have the value field
increase by one each time?

sometimes I might have 30+ simple records that need adding quickly, and each
time the first records value will be one, and each record after will
increase by one, is there a way to solve this problem or does each record
have to be added separately?

ASP Looping Adding
i have a variable in a database that is looping that outputs numbers like:

1. 45
2. 34
3. 94
4. 34

But are all in the same variable:

DoDateTime((rsBoxEdit.Fields.Item("").Value), 3, 2057)

How can i make it so that it loops that variable and adds the numbers up and outputs 1 variable called total or something?

Adding Records
I have a drop down which has numbers from 1 to 25

When a user selects 3 he will see 3 first name textboxes and 3 last name textboxes

the user fills them out and hits the submit button

three records are added to the table

i have a for loop for adding records

Here is my code:

Adding All Numbers
regarding adding or getting sum all of the numbers in the database fields
example of the Fields:

Totay_Payment
10.00
20.00
30.00
40.00

My problem is i cant display the exact SUM of all numbers and it goes like this 10.0020.0030.0040.00 and i want the exact sum like this 100.00

heres the example of my script :

inTotalPayment = rsSumNumber("Total_Payment")
Do While Not rsSumNumber.EOF
intSum = intSum + intTotalPayment
rsSumNumber.MoveNext
Loop
Response.Write(intsum)

Adding & Subtracting
Basically I want to take the field from the db (1 record) and add it to form input.

I've searched the forums--maybe I'm not using the right terminology, I can't come up with anything.

Do I need to specify that the value from the form is numeric? How?

Adding Values Together
i am trying to add to values togher but each time i try it dont work.

for example

when i try to add 7 and 3 i get 73 and not i want what is 10

i am using the below code

money=RS2("bank")
RS2("bank")=money + pay
response.Write("money="&rs2("bank"))

The DB code is fine as it is recording and pulling the data of te Database but i cant add them up only togher.

Adding Commas
4 months into the land of ASP and I still have newb questions.I have a simple string.

centertype = Type1 & Type2 & Type3 & Type4 & Type5

How do I add a comma to seperate this string? Keep in mind that some of the values may be blank.
i.e. Type1 = ""
or Type4 = ""

Adding To A DB From A Form
I want a user to select ADD from a dropdown menu and then the asp brings up a form allowing the user to add fields into the DB .....

Adding Record
after i add record from this page, when it link to the next page.. everything is blank, but the record has be added. how can i display the newest record with the old one after i click the add button?

code ...

Stopped Adding
I have been operating a win 2000 server with IIS5. I had to re-build the server recently. I installed SP4 and the lockdown utility. My asp code works on the website, I can access all data driven sites via the web. But I cannot add to the database from the website. It was fine before the re-build. The code has not been changed neither the connection. I have not installed microsoft acess on the server could this be the problem ?. The database is microsoft access file. I have ensured I have given the same information in the System DSN. The driver is version 4.00.6200.00 I have checked the database properties and it is not set to read only.what could be wrong?

Adding Alerts
The code below checks a form field for words that are in a database.How do i add the facility of if the words are found then adding an alert when submitted

<%
call connection
dim uninsuredcontents
uninsuredcontents = Request.Form("contents")
Set connDB = Server.CreateObject("ADODB.Connection")
connDB.ConnectionString = "Provider=sqloledb;Data Source=*******;DATABASE=*****;UID=****;PASSWORD=** **"
connDB.open
dim pcSQL

temp = split(uninsuredcontents," ")
Dim strCrit
pcSQL = "SELECT PAC_WORD AS word, SERVICEID AS tag FROM tblPackage_Alert_1_Content WHERE (PAC_WORD in ("

for i = o to ubound(temp)
if strCrit = "" then
strCrit = strCrit& "'%" & temp(i) & "%'"
else
strCrit = strCrit& ", '%" & temp(i) & "%'"
end if
next

pcSQL = strCrit & ")) AND (SERVICEID = '" & serviceid & "')"
%>

Adding Attributes
I want to add alittle background color attribute to the function below, so I can specify the background color of quoted text.

function replaceQuote(strString)
Dim strTemp

strTemp = replace(strString," Quote: ","<font face=""Arial Black"" size=2><i><bgcolor=""#799999""><center>")
replaceQuote = replace(strTemp," ","</center></i></font>")
end function....

Adding & Multiplying
can any on tell me the code for adding 2 or more items up and the code for multiplying from a user input box and a set number?

Adding Photos
I want to add photos into a database, with out inserting them. Id like ti have a field that when u enter the location it then displays it on the form, can this be done?

Adding Data
I have discovered that in my website,when a user tries to add data to the Access DB via a form,there is an error if the data contains an apostrophe,For e.g.If the user were to add the user Martin O'Neill to the DB,this would cause an error OR if the user were to add a book called User's Guide,this would also cause an error.

Does anyone know of a generic way to resolve this problem,preferably within the SQL statements which add the data to the DB?

Adding Feature
I am very new to ASP and I am trying to add an existing script.I have an open source shopping cart and I want to add real time shipping rates from USPS.

I have a username and password for the USPS server,but I am having trouble figuring out where to place it. Also if someone as a script to send and recieve data from the USPS server that would be great.

Adding Recordset
i am having trouble adding a recordset into the access database, the code seems to be working fine it passs and parses through all variables just fine without showing any errors and also when i access the recordset it displays the results, what the real issue is that the entry is not made into the database even though i use the Update command and i have also tried the BeginTrans and CommitTrans nothign seems to work and i am unable to figure out wats wrong with this code.