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


ADVERTISEMENT

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 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

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

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 View Related

Adding Time Fields

I have 2 time fields like this:

time1="00:20:23.36"
time2="00:22:20.20"

and the result when added shud be

total time:"00:42:43.56"

I want to add these 2 TIMES.I retreive this information from a form.Any kind of information about adding these 2 date fields will be too helpful.I'm storing this in an Access DataBase.

View Replies View Related

Can ASP Get A List Of Databases And Tables Of SQL Server At Run Time?

When we want to get data access, we need to specify the datasource name and
table name in ASP page. I want to know if we can get the list of databases
and tables of SQL Server at run time? i.e. The user can choose the database
or table to open, and get the records of the table?

View Replies View Related

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:

View Replies View Related

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?

View Replies View Related

Adding Data To A Table

Is it better to use the Recordset methods or make an SQL query string and use conn.Execute() if I want to add to a table? I figure the first might be safer, but it seems weird to someone who learnt on PHP... I'm using SQL Server if that matters.

View Replies View Related

Adding Data To Drop Down

I have an drop down box.I want a button next to it which says ADD.Once i click that button I get text box where i type my data and after submiting it,it gets added to the drop down box on the page and now i can select that data from the drop down box and proceed ahead with my order.

View Replies View Related

Pass Data Between Tables

I develop a .asp app that reads its data from an Access DB "A", and I have a desktop app with a FoxPro DB "B".

How can I insert data from a table in DB "A" to a table in DB "B". Im new to asp and I really know only the basic's, so who can guide me to a tutorial or where can I dowload an example...

View Replies View Related

Displaying All Data From 2 Tables

im currently working on a login system, and its the first time i have had to use an inner join. basically i have 2 tables, an attendance table and a member table. the attendance table contains the following: Code:

View Replies View Related

Comparing Data Between Two Tables

I have two tables. Table1 contains the names of training classes being offered and Table2 has the names of the people who are going to attend. The code below lists the classes being offered and a links to add, remove, and view other employees that are attending that class.

I only want the remove button to appear if you have already signed up for the class. I also only want the remove button to appear if the username cookie equals the username of the person that is signed up for the class which means the employee that wants to be removed from the class has to do it. My insert code (not shown) puts the username in the cookie into the Table2.

I tried using this code to accomplish what I wanted above but it does not display the remove button if the person is signed up and trying to remove themself. Code:

View Replies View Related

Listing Data From 2 Tables

if i wanna list data from 2 tables at the same time, is that possible. i have 2 tables: itemsorderd and orders, which both have OrderID.

now i want to list the 2 fields from itemsorder which are Quantity and ProductID, as well as all the fields from orders, which contains the shipping details. how can i do that in a single SQL statement ? also if i wanna delete all these datas associated with the OrderID, how can i do that ?

View Replies View Related

Retrieving Data From Other Tables

if there is two tables. for example

Table 1: IC No, Name
Table 2: IC, No, Address

IC No are primary keys

There will be only one user maintaining the Table 1 then another user maintaining address only in table 2. So the second user need to retrieve the data from table 1 on the IC No. how should i do it? is it using session?

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 Reg Form Data To MS Access DB

I am trying to test a form at home which is for registration purposes. I dont have a server connection yet. Im wondering if it is possible to check whether the form is working offline or whether my code just isnt working! ?

I should also say that my html files, asp files and database are in the same folder. Code:

View Replies View Related

Retreiving Data From Multiple Tables

I have 3 tables, product, industry and plist. product has productID and product, industry has industryID and industry, plist has productID foreign key with productID on product table and industryID foreign key with industryID on industry table.

In the plist table I am storing the productID and the industryID's that relate to that productID..

industryID productID
1 4
1 7
1 9
1 10
etc.

What I want in my ASP page is to return the actual products that each industry serves. So for the above example my script should return the products in the product table that relate to the productID's 4, 7, 9, 10, when I search it by industryID 1. I hope this is making sense. Code:

View Replies View Related

Creating Tables And Copying Data From One DB To Another?

I want to create another Database using ASP, this I can do. However, what is the easiest way to copy tables from one DB to this new DB?

I dont really want to have to write the SQL to create each table and then to use a 'select into' code for table, especially as I have around 15 tables to do!

View Replies View Related

Display Data From 3 Tables (MS Access)

I have 3 tables (MS Access) and I would like to display the content of all three tables alphabetically on a .asp page I have no problem displaying a list from each of the individual tables, but I am stumped when I try to display a combined listing..

View Replies View Related

Adding Data From A HTML Form To Database

Basically i have a form on a HTML page which someone fills out with a few IDs, then i have a .asp file which is meant to add the info to a database.

However it just wont work, the field names in the database are correct. - i hope the if statement is correct too. Code:

View Replies View Related

Inserting Data Using A Form Into Two Access Tables

I have two tables Property & Landlord. I have a form and when it is filled in and submitted the information should be sent to the two tables, but i cant seem to get my head around this problem.

View Replies View Related

Problems When Adding,deleting,editing Data In The Database

actually, I have a problem while i want to add, delete, or edit a record to a database through a asp page, I can read well but when i want to submit changes using rds object , the data does not change on the source database,

I tried hard to get a solution but i think that the actual problem is only on one figure which is the server value of the data control when i use my own iis server, I do not know this value and microsoft is saying use an empty value but it does not work either.

View Replies View Related

Send Data Into DB Same Time

When more than one user send data into Database same time using following code, do you think the code is correct? I concern if 2 users send data into DB same time, it is one user is ok and another is failed, or both ok, or both failed? If this happened, how to make that work? I remember syncnization/parallel thread can be used to solve this issue, but don't know how. Any suggestion and sample code? Code:

View Replies View Related

Inserting Data/time To An Access Db

i have an access db with a "date/time" data type with a format of "Long format";
i want to add the date/time automatically in DB when a user submit a form.

i tried using the
xdate = formatdatetime("var",1)

and putting that var in the DB, but i get an error

can someone show me how to do it right?

View Replies View Related

Date/Time Data Type

Im having trouble in storing blank or space value on a variable wich data type is Date/Time, if i make a statement like this

Field Data Type
CPARCAVEDate Date/Time

strCPARCAVEDate = rstFEVV.fields("CPARCAVEDate").value

if strCPARCAVEDate = "" then
counter = counter + 1
end if

The value doesnt increment. Do you guys have an idea how to recognize a no value.

View Replies View Related

Inserting Data To SQL Database And Sending Email At The Same Time?

I’m attempting to insert some basic information (name, address, details) to the sql database and send a notification email (at the same time).

Right now, I can insert the information to the DB after I click submit, but how can I also receive an email? Please give some ideas how to do it.

View Replies View Related

"Back" Button Issue On ASP Generated Data Tables

Imagine an asp-script that retrieves data from a database and returns an HTML with table of the retrieved data, allowing user to edit some values and delete rows. The issue occurred after deleting a row. Lets say the initial table was: Code:

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

Continue "DATA-TABLES"

Now I did the following and got this error massage:

Microsoft VBScript compilation error '800a0401'
Expected end of statement
/New Folder/1form.asp, line 305
Response.Write "<td><input class="formpagetablefield" type="text" name="tradeid" size="6" Value="& trim(rsTable("tradeid"))%"></td>

I dont't know if the code below will work. Can someone tell me if it is correct in principle: Code:

View Replies View Related

Time Calculation :: Difference Between Login And Current Time

I would like to display the difference between the logging time
[Session("start"] and the current time [now]. In hours minutes and seconds,
I have tried a couple of things but all I see is gobbledy gook.

View Replies View Related







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