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?
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Inserting Into Multiple Tables From ASP Page.
I've been building an ASP app that sits on top of a relational database (MS Access). The problem is that the data from some web forms need to be stored in different tables. Currently I am using multiple SQL Insert statements. The problem with this approach is that it is possible that several inserts would succeed and then one would fail. This would ruin my database. Is there some way to synchronize the Insert commands or to "flush" the commands at the same time? I need the Insert statements to either all succeed or all fail.
Updating 2 Diff. SQL Tables From One ASP Page
I have one ASP page that has two separate FORMS, each that will update a separate SQL table. These tables are in the same DB with the same connection string for both. The SQL statement seems to be writing correctly (when I test them) but neither of the tables updates when I try to update both of them. IF I try to update just ONE of the tables it does work correctly. Code:
SQL/VBscript - Modifying Design Of Tables From Within ASP Page
i'm wondering if it's possible to modify the design of an sql database from within a script. I don't have MS SQL installed on my machine but i need to add a few fields to some of the tables. I know it's possible to create and drop tables so that is one option. ie: drop the existing one and create it again with the extra fields. the problem with that way is I'll lose all the data. so long story short. how do i modify the design of a table from within a vbscript?
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:
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.
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>
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:
Comparing Tables?
I have this page with a drop down box which loads the itemnumbers dynamically. However, I want it to NOT load the numbers that already exist in the weborderlist. What can I do to my SQL statement to make this work? Code: SELECT (SELECT img_inv.item_num from img_inv, weborderlist WHERE img_inv.item_num <> weborderlist.item_num and weborderlist.orderid= '1') as test
Multiple Tables?
Okay, I have a db that contains 1 table. it has some house info and stuff in it, but I want the updates and news and stuff on my site to be dynamic. So should I make a new table inside my DB and use that alongside the house info table? What would be the best way to accomplish this, and if possible, do u have to set a recordset up for EACH table?
Multi Tables
How can I update/delete a record which is linked to another table with a unique field. I know the select inner join, but no update/delete.
Could Not Delete From Specified Tables.
I am trying to delete records from a MS-Access DB table using the following query: strSQL=DELETE FROM MyTable WHERE [id]=CInt(Request.QueryString("delete")) con.Execute strSQL When I run the app on my local IIS 5.1 server (on WinXP SP2), records get deleted without any problems but when I upload the same file (which has the above DELETE query) to the actual remote server, then ASP generates the following error: Could not delete from specified tables. I have gone through numerous posts & articles to resolve the issue but unfortunately the error still persists. The only apprehension that comes to my mind is could permissions to the directory which houses the MS-Access DB table be the cause of this error. Actually in the remote server, the Access DB table resides in a directory named "db" (without the quotes). When I view the permissions that IUSR_MachineName has for this "db" directory (through the web browser - the hosting service has given this option), then I find that IUSR_MachineName has only the Read permission but when I try to set this directory's Write & Modify permissions for IUSR_MachineName, then I am not being allowed to do so. So could this be the cause of the error?
How To Inner Join Tables
I have a MSAccess 2000 mdb where 2 tables must be connected with a fieldname "book_spoke". This is what I have so far. Is it right? The purpose is to find within the search result all the book_spoke s and link with the proper url for each book_spoke. Code:
ASP + League Tables
if there was any site with a public domain example of how league tables (such as football/soccer tables) could be maintained using ASP and Access databases.
2 Tables In One Recordset
I have been trying to create a set of horse race results.The result of the race is one table and the breeding and owner details in the other table.I am using the horse name as the comon value in each table.the tables look something like this table: result pos1; horse name pos2; horse name etc. table: names horse name; horsename, sire; sire, dam; dam horse name; horsename, sire; sire, dam; dam Currently I am using a new record set for EVERY field position sorted by the horse name to bring up the related breeding for every positoin in the race field. This mean for some races I am calling 16 seperate record sets.
Insert Into 2 Tables
i have ASP form and 2 tables in access database, table1 has 4 fields st_id,st_name,email,tel) st_id is a primary key table2 has 4 fields (id,car_no,car_mod, st_id) id is a primary key.it relates by st_id i want to add a new record and it should save into 2 tables.how to insert into the tables by submiting from the same ASP form.
Drop Tables
I'd like to know if there exists a query to erase/drop tables from an access table (on a asp script) older than X creation date.
Copy Tables, Etc.
How do I copy a mysql DB table in ASP?How about renaming a table?Is there a way to retrieve the names of all the tables in a mysql DB?
Deleting Tables From URL
What functions are possible to delete rows, tables, entire database from the URL when displaying records from a database. I want to be able to stop all of these possibilities from happening.
Comparing Two Tables
How do I compare the contents of two tables, to see what doesn't exist in the one table? Something like "select company.name, company_scores.company_name from company, company_scores where company.name not in company_scores.company_name" ?
Access Tables
Is there anyway to get the names of the tables in an .mdb using asp? Our DB lives on the server(duh), but I do my thing on a diffrent PC that doesn't have access. I hate running back and forth to see the names of the tables and all that, and would like to make a dummy page that lists the tables and the fields in those tables.
Dealing With 2 Db Tables
i got 2 tables...on the table "times" i only null the records column "dtime" (if it is not null) and save this records column "username"... straight after that i need to select on the second table "useringo" the record with the same username that its time was nulled and to null its column "msginfo" i realy need your suggestion to how to do this...i do not want to run on all this tables every time...i want it be most minimal and smart.
Strings And Tables
I am currently developing a registration application for the Boy Scouts. We have paper forms for those who choose not to use a computer to register. The paper forms have a box for each letter so that it is legible. how can i re-create the paper forms with ASP. For those who go online and register they need to print out the youths registration forms and I want them to look like the paper forms. Now there are a few fields that are mutliple words so it would have to support spaces as well. Is there even a way to do this. I know it is going to be a pain for the good look it is going to be critical. I was thinking of using strings to simply seperate each letter and tell the script to simply repeat until. Is the right way?
Moving SQL Tables
I need to move some SQL tables from one unresponsive ISP to our new mo bettah one. Naturally the current host is not being quick about getting a cd of our tables to us. I was going to write code to move them from one place to another but it is not so easy. If it runs on the old server it can't access the SQL on the new server and vice versa. The alternative that I see, is to download them into text files and rebuild them on the new server but that is a lot of work. Any quicker fixes out there that anyone knows about?
Joining Tables In Asp
When I do a join in asp to retreive data from two tables, should I have create two recordset, or just one is enough. I tried: Code: Set RS = Server.CreateObject("ADODB.Recordset") RS.Open "Table1", "Table2", Conn Set RS = Conn.Execute(SQL) I am getting an error Type Mismatch in line no. And the line no is the Recordset line.
Joining Three Tables
i have an sql query that needs to join 3 tables to get the desired answer(couldnt think of a better way ) i did this: code: SELECT * FROM Sold INNER JOIN Serial INNER JOIN TempSerial ON Serial.SerialNo=TempSerial.SerialNo ON Sold.SoldID=Serial.SoldID WHERE Sold.CustomerCode='"&customer&"';"
Includes And Tables
Is there a way to include a large list (.html page) in a table and force a scrollbar instead of resizing the cell to fit the entire list? I'm wondering because I have a navbar on the left that links to different parts of the list (months), and I would like it to stay on the screen, even when scrolling down near the bottom.
Joining Tables
I need to insert simple SQL Queries (joins) in an ASP page. Select Count (*) from Fileindexqueue Q, Domains D, Files F Where D.ID = Q.DOMAINID and Q.FILEID = F.ID and D.NAME = 'GAINS_GTN' My ASP code where queries can be inserted looks somewhat like this: strSQL = "SELECT COUNT(*) AS COUNTOF FROM FILEINDEXQUEUE where (SERVERFLAG = 'Failed')" objRec.Open strSQL, objConn, adOpenForwardOnly, adLockReadOnly, adCmdText Response.Write "<P Class=""clsMono"">Files Failed   : <b>" & objRec("COUNTOF") & "</b>" objRec.Close ...
Diff Btw Two Tables
anyone know of ways to show the dif btw two tables? if using left join . The LEFT JOIN returns all the rows from the first table even if there are no matches in the second table If there are rows in first table that do not have matches in second table , those rows also will be listed . this is not i want. i WANT to show ONLY the dif btw the two table. or can the sql statement be modified to suit my request ?
Moving Through Tables
I have an asp page that has 12 tables, 3 tables per row, . Im trying to get my query to fill each table with 6 records and then move to the next table with 6 records...etc then after the 3rd table start a new row. I know I have seen an example of this before, can someone point me in the right direction?
Joining Tables
I'm trying to pull a value onto my web page from a joining table and all I keep getting is the id instead of the actual value. table_status has has sid and status. for some reason I'm getting the id number instead of the value of the status. this is my error message when I try to join tables. Code:
Joining Tables
I have a mailing list table where people can enter their details and choose to have information on a variety of subjects sent to them. The details are kept in one table, the subjects are kept in another. On our database maintenance page, I'd like to be able to print out how many records are associated with each subject. Code: SQL = "SELECT D.subject,Count(D.ID) AS cntID FROM details D, subject S WHERE D.subject = S.subjID GROUP BY D.subject" There are: <b><% = rs("cntID") %></b> records in the <% = rs("subject") %> mailing list. This gives me nearly what I want, but instead of printing the table's name, it prints its corresponding numerical ID. I tried including the subject name in the query, but it's not part of the aggregate function, so it won't have it.
Select From 2 Tables
i need to select data from 2 tables, but this is not working. i've made it 3 different ways. SQL = "SELECT * FROM pedidos2 INNER JOIN pedidos ON pedidos2.pe2_pedido = pedidos.pe_id WHERE pedidos2.pe2_pedido='" & request("service") & "'" or SQL = "SELECT * FROM pedidos as a, pedidos2 as b WHERE a.pe_id=" & request("servico") & " AND b.pe2_pedido=a.pe_id" the third one is the same as the first but instead of using * i used pedidos.fieldname, etc.
Linked Tables?
im trying to link to a Access db which uses linked tables via a odbc connection... is there anything different about the connection string / driver? adoConnection.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("Resources/peterjohntest.mdb") but this error comes up Code:
ASP Using Access Tables
I have a site that is working well after first build. All the tables in the Access database are standalone, if you like, but I wanted to try and incorporate lookup columns within the database to try and reduce possible input mistakes. The only problem now is one of these columns is is used as a URL parameter on the site and It's not bringing in the relevant info that corresponds to that entry, if that makes any sense whatsoever. If I change it back to not having looup columns it works fine, but I want to crack this as it will mean less trouble in the future I suspect. The column in question refers to a list of counties so I want the user to pick that entry from a list, which of course refers to another table.
|
TRACKER
