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?
View Replies
ADVERTISEMENT
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 Replies
View Related
Here's what my code looks like...
View Replies
View Related
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?
View Replies
View Related
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?
View Replies
View Related
does anyone know of a free utility that allows you to alter/create tables through the web for access 2000. I'm talking about the table/db structure, not creating records.
View Replies
View Related
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?
View Replies
View Related
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?
View Replies
View Related
how to tell access to allow a zero length and put a default value now() in the date/time field in SQL?
View Replies
View Related
how to create new table which the table's name is variable. for example: i want to create table with the name is come from user's input in the form input.
create table <table's name variable> ( ...
View Replies
View Related
Can you create a table in an access database using create_table?
View Replies
View Related
Code:
<%
Dim conn
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.MapPath("mydb.mdb"))
'conn.Open "DSN=Survey"
Dim strSQL
' Creates a table called survey3
strSQL = "CREATE TABLE survey3 (Q1 text(20),Q2 text(20));"
conn.Execute strSQL
%>
This code works..But before I create the table I need to check if it exists and only if it doesn't i want to create it...How can i do it?
View Replies
View Related
I need to create a new table in an Access Db for a Db driven Classic ASP website. My concern is that if I alter my local copy of the Db and then simply upload it, data might be lost if any of the users are logged in and posting stats.
Is there a way for me to write and execute some code to add to the Db? In PHP I usually use sql statements with the PHP MyAdmin interface, but I don't know of such a thing for ASP-does it exist?
View Replies
View Related
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
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:
View Replies
View Related
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
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
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>
View Replies
View Related
I have MS SQL Server as database. i want to create a new table in the DATABASE, through asp script, naming table's name and naming the fields with their data types.
Can i do this through an asp script, like it can be done through Database tools like Enterprise Manager??
View Replies
View Related
I'm trying to dynamicly create a table in an existing ACCESS database. Code:
View Replies
View Related
My Database is set up like this:
AssemblyName-NumberOfPartA-NumberOfPartB ect...
I am trying to get the other data from the table but i can't seem to do it. I have a search set up with a query string, I can get the assembly name, but i can't get the NumberOfPartA, NumberOfPartB ect... that is associated with that AssemblyName... Here is my code:
View Replies
View Related
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?
View Replies
View Related
I am in the process of rewriting my table formats for an Access Project that was created. I now need to get the data from 1 table and transfer to a second table.
I created a page that creates the record set, I then loop through that record set and need to run an update statement to a second table, however, I get the following message:
Microsoft JET Database Engine (0x80004005)
Could not use ''; file already in use.
/BusPlanTest/updBusPlan.asp, line 17
Below is the code I am using: Code:
View Replies
View Related
i have really only been exposed to getting data from aSQL database and displaying it.I want to include a page in my application (like a form in Access i guess)with various text boxes and drop-downs + tick boxes.Then i want to click a submit button that inserts the data (providing is valid) into a SQL Server table.
I have had a search in google but nothing seems to explain this in its most
basic terms (errorchecking and inserting).Could anyone give me an example of this or some background about this functionality.
View Replies
View Related
how to export sql database values to excel sheet using asp. so that user can save that work sheet to their harddisk.
View Replies
View Related
I want to UPDATE a table with fields, Id, Home and Away with the values from another table. The other table has only 2 fields, ID and winner, i want to update the first table with the values from the other like so:
Home Away
Winner(1) Winner(2)
Winner(3) Winner(4)
the numbers in the brackets represent the row in the second table. Does anyone know how this is possible?
View Replies
View Related
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.
View Replies
View Related
I have certain Keywords stored in a table of the Database.All i need is when ever i find the Keyword in the webpage i need to have a link which opens up as a seperate page and give me the detail information from the database for the seleted keyword.
View Replies
View Related
FORECAST
Month 1 :
Month 2 :
Month 3 :
Month 4 :
Month 5 :
Month 6 :
Thereafter :
[IMG]forecast.jpg[/IMG]
There is a forecast table which needs to be filled in for each client as shown above, all the info is then saved in the DB and from this data I will need to generate a FORECAST REPORT (shown below). It forecasts the prospective amount of records we will receive for processing.
[IMG]forescast1.jpg[/IMG]
The columns are shown below… june, july, august, September, October, November are dynamically generated on form load, using the current month and working 6 months ahead. Thereafter represents any month after November (6 months from june).
I am having huge issues populating the correct columns shown below with the correct values from the db, so if the forecast for july is 1000, how will I display it in the 6th column in my report? Code:
View Replies
View Related
I have created a table that I want to fill with calculated values. I have given ID's to each cell. This must NOT be the way since I can't address these ID's. How do I store values in table cells from my PostBack?
View Replies
View Related
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
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 ....
View Replies
View Related
