For Every Record Is Table A, Create 1 In Tables B,C, And D
I need to do a simple but complex thing...
For every record is my users table, I need it to creating a record in 3 tables, with one value (all the same)...
So, in detail:
1 users table
Need to create a record in 3 other tables with the userid from the record it added...
e.g.
From record 1 in Table A, create a record in Table B, C, and D with the value of field 'userid' the value of the 'userid' field from Table A...
Get it?
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Create Tables From Values In Another Table
How can I loop through the values of one MSACCESS table to display the related records from another table? I have one table with two single field records. The values are 4 and 9. These fields are related to another table which contains records that belong to either 4 or 9. I want my web page to display a table for all records belonging to 4 and then another table of all records that belong to 9. I could specify either 4 or 9 in different record collections but the 4 and 9 could one day be 1 and 5 and I don't want someone to have to get into my code to change the 4 and 9 to 1 and 5 in my sql queries. Any advice?
Hot To Create Tables In A Database With ASP?
I've made a website for a little athletics club in HTML. I want to transform the records page into an ASP page that has an admin page so i can go to the admin page and easily add in the records without having to create all the tables and doing it all the manual way. I know how to create the admin page and the database, but in my case, i want to be able to create a new table in the database for each week of records (as seen in the link below), and each of these tables will have the same fields (age, gender, event, athlete name etc.) I know how to make it so that asp can add, edit and delete a field in a table, but how would i get it to add a new table for each week of records?
Create A Recordset With Multiple Tables?
My database has customers, orders, and orderDetails tables. I'm trying to create a page that we can access to lookup all details about our orders. That page will need information from all of these tables. How do I create a recordset that can handle the relationships and bring in all data?
Record Check In Different Tables
I have a database with two tables: Table 1: Human Table 2: Exempt I have created the following code for creating a record, which works fine. But what I would like to do is to check if I add a record on the "Human" table to verify if the record number already exists on the "Exempt" table. I have already created an error handler for it to check if it exists within the same table which works fine. But I can get to do the rest. I created a separate file where I created two functions, but I don't think I did it right. Code:
Record Lines Without Tables
I regularly code in standard asp with MySQL. I have a page which displays records with the background colour of each record table row in a different colour. There are 2 table rows per record. The problem is that at the end of each field in a row, the background colour stops and then continues in the next field, i.e. the rows look like a brick wall design. Is there anyway I can adjust my designs so that no matter how many fields or rows I have, the background colour is seamless and the visitor cannot see the start and end sections of each field ?
Create Table
I know I can Create Tables In a database with the CREATE TABLE sql statment, but I don't exactly know the syntax of the statment. I want to add a table with a sertin feild that has a default value, is that possible? The syntax I know is: sql = "CREATE TABLE tablename(feildname FEILDTYPE,feildname FEILDTYPE...)" Are there any other parameters that I can add to the statment?
CREATE TABLE
I'm writing an ASP app to create a table in an MS Access database. I use: Code: sql = "CREATE TABLE success(name text (50), company text (75), article memo (), img text (50))" and get a syntax error. When I remove the "article" field and param, it works. Even when I add a max char param inside the parenthesis Code: article memo (255), I get the same error. Doesn't the "memo" data type allow unlimited charactors? If so, is there a param that I need to add to the memo () call?
Create Table SQL
how to tell access to allow a zero length and put a default value now() in the date/time field in SQL?
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:
Create Duplicate Record
I have an MS SQL database, I want to be able to create a new record based on a prevoius record, the SQL statement I have is this: strSQL = "INSERT INTO tableX " & _ "SELECT * FROM tableX WHERE " & _ "id='1'" The problem I have is that the primary Key (id) is set to Identity and so won't allow duplicates, I need this SQL to work but give the id value a new unique value.
ASP + SQL Create Table For SQL Server
I am having a problem using the SQL statement "CREATE TABLE" for an SQL Server database. The code works right in Access but when it did not work in SQL Server 7, I changed some of the datatypes to match an SQL Server 7 generated script. The problem is, it still does not work! Now the first comments will probably be something like, "make sure your SQL user has permission," or, "make sure your connection string is correct." I have already tested that - the connection string works and I used the DBO (sa) user. Code:
Asp Create Table Problem
I am trying to use asp to create a new table in an existing database and I keep getting this error: Microsoft JET Database Engine error '80040e14' Syntax error in CREATE TABLE statement. /install.asp, line 75 What would cause this? Here is the code I am using: Code: cnn.Execute("CREATE TABLE crosssale (prodID "&txtcl&"(50) NOT NULL,related "&txtcl&"(50) NOT NULL, PRIMARY KEY(prodID,related)") By the way txtcl equals: txtcl = "TEXT" 'access or txtcl = "NVARCHAR" 'sql
Create Table Query
In the same way that you can create and alter permanent tables in Access 2000 using SQL in ASP ( CREATE TABLE <tablename> col_1(col_1 datatype), col_2(col_2 datatype....Col_n(col_n datatype)) is there any way to do this for Queries?
CREATE TABLE IN ACCESS
how do you create a table in MS Access from with an asp script? I will be creating the table name from Request.querystring("name"), also needs fields of branchname and branchcode. guess something like CREATE TABLE & Request.querystring("name") branchname. branchcode.
Create Html Table From Rs
how do i create a td for each field in my rs, with out labeling them. this is what i have, not sure if i'm heading in the right direction or not. Code: <table> <tr> <%Do while not rs.eof%> <td> <%= rs ('insert rs name'<<<<???)%> </td> <%rs.movenext loop%> </tr> </table>
Record Set For Id From Table 1 To Table 2
Hello I have a page for registering users. I am reciveing this error: The following errors occured: - An error occured. -2147217904 : No value given for one or more required parameters. there are students and teachers. therefore I have 3 tables one for logins and one for staff and on for students. I have a form designed to capeture the need information. in the code I am runing an if and elseif statmetn to determin the tables. I then insert the userid and password into the login table. then i enter the remaining information into ither the staff or student table. what i am trying to do is select the perimary number that is generated as the userid and passeword are enterd. and add this to the second table. Code:
Add/update A Record In First Table And 2nd
i can add the record in first table but cant get it to do with the second one one of the field in the first table the "mktid" which is the primary and is a forgeiner key in the second table how can i have it insert or update in the second one Code:
Add/update A Record In First Table And 2nd
add/update a record in first table and 2nd i can add the record in first table but cant get it to do with the second one one of the field in the first table the "mktid" which is the primary and is a forgeiner key in the second table how can i have it insert or update in the second one addnew.html Code:
Can't Grab A Record From A .mdb Table
There's only 15 rows in the table 'FiscalYr', but I can't grab the row I need. Here's 3 typical rows: ..Year...Start..........End...... Column names = 'year', 'start', 'end' 2003 12/29/2002 12/27/2003 2004 12/28/2003 12/25/2004 2005 12/26/2004 12/24/2005 For example, if the value of 'today' is #07/10/2004", I want the record where the key is 2004. In fact, any value for 'today' between 12/28/2003 and 12/25/2004 should pull up the '2004' row. Here's my non-functioning code: SQL = "SELECT * FROM FiscalYr WHERE Start >= #" & today & "# AND End <= #" & today & "#" Set rs = DBConn.Execute(SQL) The resultSet obviously should have only one record because the Start and End dates are unique and don't overlap from row-to-row. but when I: if rs.recordcount >= 0 Then response.write. "There are " & rs.recordcount & "rows that match your search." else response.write "While attempting to tally a RecCount there is an Error with recordset. <br />" end if I keep getting the Error msg. What am I doing wrong?
Complete Function To Create Table And Columns
I have been looking everywhere, and can't find a complete function to create tables and columns in access .mdb from ASP, while adding columns that are missing in tables that already exist, can anyone post a link or the code to such function?
Create Table With Username And Write To It With Results From Form
I have an asp page that gives results for a search from a previous page from streetguide.streets in MySql. The page displays the UserName of the person logged in. I have the results of this query displayed inside a form with hidden variables. When the user clicks "save to my folder" I want it to create a table in the mysql db with the same name as the user name, and then write to this table. I have it working if I created the table beforehand, but I want the table to be created dynamically upon form submission with the table name to match the persons user name.
Display Textbox For Each Record Retieved From Db From Same Table.
When a selection is made from a list (lstpos) - single selection allowed, (for example a user selecting engineer), it retrieves all the duties (it may b a duty i.e. 1 record OR many duties i.e. more than 1 record) an engineer performs (each one on a different line) from a table and automatically displays text boxes next to each duty so that the user can input "scores" for each duty (rate the engineer). How to do this? Next this data needs to be input in a table when the user clicks a button (ADD or OK) in the format : user duty score user1 duty1 score1 user1 duty2 score2 user1 duty3 score3 etc... Anyone has an idea how to do this?
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.
How To Transfer Records From One Table Of A Database To Another Table In Another Data
I have aproblem to transfer a data from table x to table y based on id. Its mean when 2 table have same id all data table x must move to table y. I don't know which command need to use is it insert into or update? <% Dim conn Dim rs Dim MYSQL,MYSQL2 Set conn = Server.CreateObject("ADODB.Connection") Set rs = Server.CreateObject("ADODB.Recordset") Set cmd = Server.CreateObject("ADODB.Recordset") conn.ConnectionString = "DSN=prmm;UID=administrator;pwd=sa" conn.Open startdate=request("tarikh1") enddate=request("tarikh2") MYSQL = "SELECT * FROM table_x where paymentdate between '" & tarikh1 & "' and '" & tarikh2 & "'" rs.open MYSQL,conn ....
Insert Record Goto Last Record
I have an insert record form that posts fine to a db which automatically creates an ID how could I get the next page to do a preview using the ID just created by the DB to go to the right record?
Record Numbers Against Record Problem...
I have a .asp page which lists a date, then a bunch of record lines for data that falls within that date, then the next date and it's bunch of data record lines. e.g. Ship Date: 04/06/04 Data xxxxxxxxxxxxxxxxxxxxx Data xxxxxxxxxxxxxxxxxxxxx Data xxxxxxxxxxxxxxxxxxxxx Data xxxxxxxxxxxxxxxxxxxxx Ship Date: 11/07/04 Data xxxxxxxxxxxxxxxxxxxxx Data xxxxxxxxxxxxxxxxxxxxx Data xxxxxxxxxxxxxxxxxxxxx What I want is: Ship Date: 04/06/04 1: Data xxxxxxxxxxxxxxxxxxxxx 2: Data xxxxxxxxxxxxxxxxxxxxx 3: Data xxxxxxxxxxxxxxxxxxxxx 4: Data xxxxxxxxxxxxxxxxxxxxx Ship Date: 11/07/04 1: Data xxxxxxxxxxxxxxxxxxxxx 2: Data xxxxxxxxxxxxxxxxxxxxx 3: Data xxxxxxxxxxxxxxxxxxxxx How can I get these numbers printed againsts the records ?
Table Inside A Table Update To DB
I have a table with many txt boxes which i have inside a form with a submit button to an update page which adds all the details to a db. The problem is i have a another table inside the first e.g. table 2. i want to be able to update table2 by clicking a second submit button that would update it. Is it possible to have a form within a form or how can i do it?? Also i need to update the entire table in one go. For exampple if i have 3 records in table2 i want to be able to update them all by clicking the one update button. Code:
Copying From Table 1 Inserting In Table 2
I have the following code but this is inserting manually. I want to make a query from table 1 and automatically enter the records into table 2. What needs to be modified? Code:
Bookmarking A Position In A Table <table>
Have an app which dynamically creates table rows depending on records, these can be several hundred (don't ask). Hence a very long page at time. Each row includes a hyper link to a new page, and a link back to the original page. Is there any method (maybe via js) where on leaving the second page l can redirect the browser to the table row the end user clicked on? Hence the bookmarking. Can do this via Visual Basic on the desktop app, but can't work it out on the web app.
Add Sql Tables
I want to be able to send two sql tables to access db at the same time
Linked Tables
I have a database that has 2 tables linked into it from another database. I am having problems trying to pull in values from those 2 linked databases. One of the tables is tblClient. Code:
SQL Statement Using Two Tables
I need some help with a SQL statement. I currently have which works: strSQL = "SELECT * FROM mstJobs WHERE JobStatus = True" I need to query against a second table but I am not sure of the correct syntax of the statement for adding another table.. somthing like this i would imagine... ???? strSQL = "SELECT * FROM mstJobs.pmdata WHERE JobStatus = True AND WHERE WeekEnding IN tblSuperInput.pmdata = strThursday"
Get Tables Names
Does anyone have some sample code on how to get all tables names in a MS Access database?
HTML Tables In ASP
I have a form in my HTML page and I require a number of checkboxes. These are to be dynamically generated from an Access database. The code below will work but it will only create a single row. How can I include the <TR> tag inside the loop - I'd probably want 4 cells per row <table> <tr> <% Do until rstCategories.EOF = True Response.Write "<TD width=200>"_ & rstCategories("strCategory")_ & "<input name=chkCategory type=checkbox value=" &rstCategories("lngID")>"_ & "</TD>" rstCategories.Movenext Loop %> </tr></table>
3 Tables, 1 Page
I am trying to list data from the DB from three different tables. The first table is creditors, the second is statements and the third is payments. I don't know much about inner joins and I'm not even sure that's what I need to do. The first section on the page is detailed information about the creditor. Below that is a section for a summary of all statements from that creditor. Below the statements section is a section for listing payments from that creditor. The 'creditors' table has a field of "credID" as well as the tables "statements" and "payments". The "statements" table has a "StatementID" field and the "payments" table has a field of payID. What is the best way to list the statements and payments from a particular creditor?
Linked Tables
Ithe goalposts have been moved (yet again!) and the database that was one, may have to become many, being used on subdomains of the same server sharing some information but not all from a 'global' database.The solution I initially found was to used linked tables and developing it on pws - this was perfect. I linked local databases to the external table data in the 'global' database hey presto the application ran smoothly. There was only 1 connection to each local database and I could retrieve all the information I needed from the global one. However on uploading I have no idea how to set this via asp or sql as online the path of the linked tables is what was on my local machine and I have found no way of being able to edit this or indeed know if this is possible.
SQL JOIN 3 Tables
I've got three tables: tblEvent -------- Id (PK) | Event_Name tblDelegate -------- Id (PK) | Delegate_Name tblBooking -------- Id (PK) | Event_Id (FK) | Delegate_Id (FK) I need to retrieve a recordset with the following information: Booking Id | Event_Name | Delegate_Name Can anyone see how to do a SELECT statement to do this?
Dynamic Tables
I dont even know if ASP is the right language to be doing this, but what I am basically trying to complete is a way for a dropdown box to come, and depending on what they select data will go into a table. For instance, the dropdown will what type of taxpayer they are and if they select individual, the offered services will appear in the table.
How Can I Compare The SQL Of 2 Tables In ASP ?
I have an application that creates online quizzes, each quiz has a results table generated by ASP on MS SQL Sever. What I want to do is compare the SQL structure / code of the table I am about to create with the SQL structure / code of an existing table (previously created in ASP) to see if they are the same. So how can I get the SQL structure of a table that already exists in my database into an ASP page?
Querying 2 Tables
I have a database with 2 tables in it. Each table contains the fields: ID(autonumber),Title, Artist, Description, DiscNo, and TrackNo. The second of the two contains an additional field: Price. How would I make an asp page in which a person enters DiscNo and Price into a form and the code would read all the fields of that record from table1 and then add those and the Price into table2?
BackUp Tables
I am looking for code that will go through all tables in MYSQL db and transfer records into text or excel files.
How Do I Inner Join 3 Tables?
strSQL = "SELECT x.CountryId, x.CountryName, y.SiteId, y.SiteName, z.LocationId, z.Level FROM TableCountry AS x" strSQL = strSQL & " INNER JOIN TableSite AS y ON (x.CountryId = y.CountryId)" strSQL = strSQL & " INNER JOIN TableLocation AS z ON (y.SiteId = z.SiteId)" Error Type: Microsoft JET Database Engine (0x80040E14) Syntax error (missing operator) in query expression '(x.CountryId = y.CountryId) INNER JOIN TableLocation AS z ON (y.SiteId = z.SiteId)'. /system1.asp, line 21
Joining 3 Tables
i have an sql query that needs to join 3 tables to get the desired answercouldnt think of a better way ) Code: SELECT * FROM Sold INNER JOIN Serial INNER JOIN TempSerial ON Serial.SerialNo=TempSerial.SerialNo ON Sold.SoldID=Serial.SoldID WHERE Sold.CustomerCode='"&customer&"';"
2 Access Tables
are you able to open two Access tables at the same time or is this bad coding practice?
Three Databases Tables
How do you go about searching three tables at the same time? I'm using Dreamweaver MX, but I can also hand code it in if know one knows the dreamweaver method
Aligning Tables
I've a (classic) ASP web page that has several tables on it that have identical columns (headings). When these tables are displayed they of course have different widths, based upon the amount of text within each column. I have been asked to make all tables have identical column widths. What I thought I would do would be to have some sort of column-width counter that counted the maximum number of characters in column A in all tables, and another for column B in all tables. From this I would have to come up with some algorithm (not yet done) to turn the number of characters into a column width (based upon font family and font size chosen). This value would then be put into a programmatically generated style sheet. However, a quick prototype shows that the style sheet appears to be ignored if it's at the end of the document (even if in a <head/> tag) and the aforementioned algorithm would appear to be rather complicated.... Code:
|
TRACKER
