Adding Records To Tables Via Dropdown Boxes

I have a form that uses Code:

<select name=player_id multiple>
<option player_id="<%=player_id%>"><%=FName%> <%=LName%></option>
</select>

To create a drop down selection list. What I want to send to a table is FName and LName instead of the ID. Any hints on how to do this.

View Replies


ADVERTISEMENT

Adding Records To Multiple Tables

i have an instance where I need to add records to 2 different tables. i know how to do it basically, but the problem is, one table is generating a key number and i need this number for the second table records.

how do i put the appropriate records into the first table, grab the id number and insert the records into the second number? the information is coming from a form. i'm developing in an access db but will be moving this to an ms sql db before it goes live.is there a stored procedure that might make this easier? i know nothing about stored procedures.

View Replies View Related

Dropdown Boxes

When I write code to populate a dropdown box with all fields from a column in a table, it populates all but the first record. And then automatically sets this missing record as the record to be sent, no matter which record I select. Has anyone seen this issue before.

View Replies View Related

Create As Much As U Want Of Dropdown And Tect Boxes

i want to create a textbox and when i enter a number on it ,for example 3 ,and send submit , i will have 3 dropdownlist(all of them is the same) , and choose different things from these 3 dropdownlist , so ican sumit 3 stuff everyone is separte than the other , and to the same userid

so how this could be?!? cause i dont knowe how it will be send to the same table , and they have also the same Name.

View Replies View Related

Need Script/Code For Dropdown Boxes

I wrote this code for the website with a query to a postgreSQL database. The queries works fine and are able to get data into my dropdown boxes. However I want to populate my second dropdown box according to the selection the user made in the first dropdown and so on with the rest of the dropdowns. Code:

View Replies View Related

Parent-Child Dropdown Boxes

I have two dropdown boxes, one is a state dropdown (statedrpdwn) and the other is a city dropdown (citydrpdwn). I want the values in the citydrpdwn to be dependent on what is selected in the statedrpdwn.

So when the user selects a state, I want the city drpdwn to only display the cities in that state. How can I do that? I also need to save this information to a database and retrieve it back correctly from the database. How can I do that?

View Replies View Related

Code To Make Dynamic Dropdown Boxes

I've been farting around with trying to make some dropdown boxes populate based on the value selected from the first drop down box..

I have 3 DropDowns..

1)PumpType
2)PumpMfg
3)PumpModel

the first one takes all the pump types from a database table called pumptypes and populates it

the second dropdown gets its values from an sql query to a second database table called pumpdata that puts all the manufacturers that have that have a pump that matches the type selected in the first dropdown.

the third box does essentially the same thing but looks for all the models based on the values of the first 2 dropdowns..

whats happening is when I select the pump type it goes to the next page without allowing me to select the other 2 boxes.

heres the code I have .....

View Replies View Related

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:

View Replies View Related

Adding Fields Or Tables

is it possible to dynamically add a field into a table? or add a table? Lets just say that I have a DB with 10,000 entries and about 5MB in size. I want to add a new feature and for this i need to add an extra field to the table. I don't want to d/l the DB, make the changes locally and then u/l again, so can I do it via script?

View Replies View Related

Adding Data To 2 Tables At The Same Time

i have 2 tables;

table01:
fields are
field01,field02,field03,field04,field05

and another table

table02:
fields are
field01,field02

when someone submits the form, i want to add the infos supplied by the user to be added to these 2 tables.

field01 & field02 shall be added to tables 1 & 2;

&

field03,field04 & field05 to table01 only

i tried using this code:

myquery = "INSERT INTO table01 (field01,field02,field03,field04,field05) VALUES ('" & f1 & "','" & f2 & "','" & f3 & "','" & f4 & "','" & f5 & "')"

myquery2 = "INSERT INTO table02 (field01,field02) VALUES ('" & f1 & "','" & f2 & "')"

adocon.execute myquery,myquery2

but this one only adds to the first table.

can someone tell me how to fix the problem?

View Replies View Related

Adding To Tables Together And Displaying The Results

i run a classified ads site that allows people to post ads, and stores the results in a ms access database.

2 of the imput fields are: price and quantity

What i am trying to do is the following:

To add all the prices and and quantities together and be able to display the results on my site for example my database has the following:

Price | Quantity
2.00 | 300
1,50 | 1
10.00 | 10
140,00 | 7

and on the website i can display the results like so:

Current ads worth: 1681.50

I need the script to ignore letters as in the quantity field people have also added word such as packs and VE ETC so i need it to ignore letters, however in the price field some people have placed the ( , ) sign in there price so the code must recognize ( , and . )

View Replies View Related

Field Order For Adding To Tables

if the order of the fields in a query matters when querying a table with asp. that is, if the table has columns labeled "RecordID, FirstName, Initial, LastName, etc" in that order, do i have to do my "INSERT INTO" command with the fields in that same order, or could i do "FirstName, RecordID, LastName, Initial, etc" ? i think it doesnt matter. am i right?

View Replies View Related

View Records Per Dropdown Selection

imagen dropdownlist that with every select(no submit onlyselect) will change the output of records... (each selection from the dropdown will show you records from of diffrent table)

View Replies View Related

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?

View Replies View Related

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:

View Replies View Related

Adding Different Records

Just when you think something is working, suddenly something new comes along.this is my situation: I want to add intQuantity of all records that have the same prodID. I have tried all sort of variations but I don't seem to get it. I would imagine that it must be simple, that's why I can't get it.

SELECT SUM ( intQuantity) AS ItemTotal
FROM tblOrders
WHERE prodID = ? no clue

Or can I do that in ASP? doing something like (my example doen't work)
<%= (rsOrders("intQuantity") + rsOrders("intQuantity")) %>

in the mean time I'll be looking around for an answer to my lack of know how.

View Replies View Related

Loop + Adding Records

I have loop displaying certain records depending on an id number in my sql database. What i need to do using asp is total all the numbers in one of the fields and display that as a response.write.

View Replies View Related

Deleting And Then Re-adding Records

I may have made a typo somewhere. I am trying to delete collections from RelProdCollection Table that has a certain record with Product ID number of __ and then readd them based on the user's choices on the edit form. Code:

View Replies View Related

Adding Values From Records

I want to add intQuantity of all records that have the same prodID. I have tried all sort of variations but I don't seem to get it. I would imagine that it must be simple, that's why I can't get it.

SELECT SUM ( intQuantity) AS ItemTotal
FROM tblOrders
WHERE prodID = ? no clue

Or can I do that in ASP? doing something like (my example doen't work)

<%= (rsOrders("intQuantity") + rsOrders("intQuantity")) %>

in the mean time I'll be looking around for an answer to my lack of know how.

View Replies View Related

Putting Records Into Tables

I'm trying to put my data from Access DB into a table, but, where I know how to do it creating one row per record, what I'm wanting to do is essentially extract each record into 1 cell, and then have the next record in the next cell, creating a table 2xn in size.

The data I'm getting for each record is a URL & a file location, to create an image hyperlink for each record, and need the images to appear in a table 2 columns x however many rows required.

View Replies View Related

Adding Records To Data Base?

I have a data base that I wish to add a record to. I have many fields to ender, but I was testing my code with just one and it works just fine : Code:

View Replies View Related

Adding Records With Autonumber Field

I'm writing a database admin page in ASP. I had it adding records correctly. Then I added an autonumber field ("ID") to the table, and it stopped working. The sql I'm using is Code:

View Replies View Related

Adding Multiple Records With Checkboxes

SQL 2000 database with ASP

I've found many things "out there" regarding updating and deleting
multiple records with checkboxes but I can't seem to find anything
about adding them. A user wants to create a price list for their
client and they need to add parts to it in a separate table. I would
like to display the list of parts and the user would select multiple
parts to add to a price list by checking a checkbox and submitting the
form. Code:

View Replies View Related

Problem With Adding Records To A Table

There is something wrong with the adding code. It will add sometimes. It's a large database where I have to add records to multiple tables.

The products table doesn't work correctly. Maybe there's a typo somewhere that I don't notice. Please look at the bolded part of my code and see if you can catch something. Code:

View Replies View Related

Adding, Deleting Records Using Global.asa

Can I do the following things in the global.asa file?

When sessions starts:

Add a record into my database

When session ends:

delete it where rs("sessionid") = Session.SessionID...

?

I'm pretty sure I can, but...I've heard not ALL things can be done in global.asa...

Do I create an object, and a connection? How would I do it? Since I want a database in MY database, not in memory like I've seen...

View Replies View Related

Dropdown Menu/list Issue Pulling Records From Access Db

I am trying set up a page where the user can view records chosen by the year.
I want to use a dropdown menu/list. Having trouble figuring out the sql behind this.

My db table has about 10 fields in it, one of which is the year this record was created. i want the enduser to be able to enter the page, and first step is to select a year to view. Again, i want this to be chosen using a drop down menu. After clicking I would like the page to show a simple table pulling up all the records from that year.

i know this sounds simple enough, but i cannot find this info/tutorial anywhere.. you guys are my only hope.

View Replies View Related

Multiple Tables Identical Records

how do you do this. 2 tables. one called "Bookings" one called "Rooms"

what kinda query would i use to make it LIST the contents of the ROOM column in the BOOKINGS table, then get remove identical matches in the ROOM column in the ROOMS table?

View Replies View Related

Error In Deleting,updating And Adding Records Using Asp!

I got an asp page that supposed to add,delete records from access 2000 mdb file. It loads all the records but when i try to delete or update i get these errrors. Code:

View Replies View Related

Adding Records With Client-side Excel File

With ASP, how can I automatically add records to a database with an excel file residing on the user's machine? Assuming the excel file has the same field names/datatypes/order as my database table's fields.

View Replies View Related

Display Records From MS Access Tables As A Total In A Table In A ASP Page

I'm trying to display records from an MS Access DB (*.mdb) in an ASP page (table).. I don't want to display all the records though, I just want to display the total of these records..i.e in my table I would like to show how many calls someone has closed this year..(number)

Joe Bloggs ---> 100 Closed

Is this possible? I was thinking that I need to write an ADO that includes COUNT but I'm not too sure how to write this.. Here's what I have so far: Code:

View Replies View Related

Making Dropdown Menu Dependent On Another Dropdown

I have a category that I will call "company". in my access DB, there are about 6 or so companies. On another table, I have a list of locations that are related to these companies.

What I want to do, is have a drop down menu that lists all the companies. When you select the company, the second drop down menu will automatically populate with the locations of the company you selected in the first dropdown.

Anyone know any links to some examples of this? My google searches have been pretty fruitless since Im having a bit of a problem trying to explain it concisely (as you probably noticed).

View Replies View Related

Creating Dynamic Tables In Dreamweaver To Display Tables

I know how to create dynamic tables in dreamweaver to display fields and records in a table of a database, but in my case I need to create a dynamic table that lists all the tables in the database, then to click on the one i want 2 edit the data in there.

View Replies View Related

Systematic Updating Of Records Depending On Amount Of Records In Another Table

The problem concerns 2 tables, cart_products and cart_shoppingcart.

Cart_products contains all the product data (eg, prices, product's key name, etc), but most importantly, it contains the quantity of stock (prod_quantity) for each item.

cart_shoppingcart contains all of the user's items in their shoppingcart, including those that are part of an (customer) order; these have the order_number to differentiate from those that aren't in any order (their Order_number is 'no_order', the others have the order number).

Now, what I want to do is this:

For every item in the order (ie, every entry in cart_shoppingcart that matches the username and order number), take the quantity (x) the customer is ordering, then take the quantity of stock remaining (y), then subtract x from y to create the new stock level (z) and update the appropriate record in cart_products with z (all this with SQl preferably).

I was thinking of using a Do while loop, but realised that it wouldn't work as I'd have to use several SQL statements and then I'd run into a problem the minute ASP reads "objrec.movenext".

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved