Create Recordset, Loop, Update Second Table
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
ADVERTISEMENT
Here's what my code looks like...
View Replies
View Related
I have created a forum, in which I have 3 tables:
1: Table_Forum
2: Threads
3: Replies
I have it at the moment that on the main default.asp there is a recordset that will
display all records within that table, these are a list of forums that will be available.
I have a table that will show the forum name, and the description. This table is then looped using Do while not, now what i need to do is show how many records in the Treads table are related to each forum using asp. Code:
View Replies
View Related
I am trying to display the content of a Table called
'Order Detail' directly from the database (e.g., Northwind.mdb). I have the following commands:
Set tableSet = Server.CreateObject("ADODB.Recordset")
tableSet.Open table_name, DB_name, adOpenForwardOnly, _
adLockOptimistic, adCmdTable
where, table_name = ''Order Detail" Or
table_name = 'Order Detail' Or different variations.
I always get error on the second command with the following message:
Syntax error in query. Incomplete query clause
which I believe because of space in the Table Name. How can I resolve this issue? (working with file or table name with space)?
View Replies
View Related
whats up with this chuck of code its just not updating.
For x=1 To Request.Form("itemid").Count
SQL = "UPDATE PopItem SET qtyord = "&Request.Form("txtqty")(x)&" WHERE orderno=" & popno & " AND itemID=" & Request.Form("itemid")(x)
rstSimple2.Open SQL, cnnSimple, 3, 3
View Replies
View Related
Is it possible to loop through recordsets using javascript? If possible, can show me an example.
View Replies
View Related
Given a page with 12 thumbnails numbered one through 12 I am trying to figure out how I can let a user click on any of the twelve thumbnails and be taken to page that has a forward and backward arrow so they can go through the other images in order.
So if someone clicks on the 7th image the next page shows that image enlarged with a foward arrow taking them to image 8 or a reverse arrow taking them to image 6. When the controls get to image 1 (or image 12) the navigation adjusts to just keep going through the images.
View Replies
View Related
I have a recordset and an array which i get from a form submission. I want to loop through all recordsets and compare one by one with the values I get from the array. Is it possible to give me the general construction because I am stuck?
View Replies
View Related
I currently use Do while loop, but I'd rather use a For Loop though I have never gotten the hang of them. Would some one please be so kind as to show me how to loop through a
recordset.
View Replies
View Related
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:
View Replies
View Related
Is it common practice to create a recordset object inside of a loop? Does it create multiple connections to the database?
View Replies
View Related
I've got this code that loops through a recordset and prints the whole thing out in an html table. Sometimes it takes 30 seconds to a minute to display a little over 2000 records (like 25 columns). My boss feels that it needs to be faster even though another internal reporting system that works similarly takes far longer than mine.
I've ruled out the database execution. I have code that prints out after it finishes going to the database. It shows up almost immediately.
I set up a javascript timer that says the entire execution, including the database, is taking around 1.5 seconds every time.e.
View Replies
View Related
I need to send an .ASP page as an email template using VBScript. I'd like to do so using CDONTS or CDOSYS. the script needs to loop through a recordset and send emails using data from SQL 2000.
when i try to send using a script i built the asp page pulls in without rendering the asp. how can i pull the rendered asp into my vb for emailing?
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 using odbc and Classic ASP and I want to read the sql content of a query in an access database. ANyone have any clues?
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 using MS Access.
My DB name is: interse.mdb
Table name: Home
The field name: overview1
I want to use Textarea to Display and Update the "overview1" field.
How can I do it.
View Replies
View Related
how to update two table in the same time?
View Replies
View Related
I am New in ASP and really need some help. My database has one table (300 rows) with two columns. One colume is the customer name, the second coloum is blank (let users write down the information). How to create a form and let users update the table?
View Replies
View Related
I want to create a disconnected recordset and want to store the values in a txt file at client site and then want to use for some validation.
View Replies
View Related
I am trying to find distinct hostname. And my code is:
sql="select distinct a.Hostname, b.Productname from TableInventory as a, TableProduct as b, TableModel as c WHERE a.ModelId=c.Model AND c.ProductId=b.ProductId"
rs.open sql, cnn
After which im suppose to get the indivual hostname's productname, qty and cost.
i tried to split up the rs into array values Code:
View Replies
View Related
I figured out the code to insert into my table but I need to add data to a specific recordset. This is the asp page the data comes from: Code:
View Replies
View Related