[Open][Multiple Table]
Can i open a second table while another table is open within one database? I did attempt but i get this error. Code:
Error Type:
Microsoft JET Database Engine (0x80004005)
Could not use ''; file already in use.
Can i open a second table while another table is open within one database? I did attempt but i get this error. Code:
Error Type:
Microsoft JET Database Engine (0x80004005)
Could not use ''; file already in use.
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)?
I have 2 .ascx files and one .htm file. One of the .ascx files is basically just a table with four rows. One of the rows has table for the other .ascx file, which is the menu, and the .htm file, which is the body content. Code:
View Replies View RelatedI want to do is search through a database based on what was selected on a form.It will be based on state, county, and category.Out of the search I just want one field out of the database, the email field. Now, at first I had one table to mess with so I was using this:
strSQL = "SELECT DISTINCT EMail FROM Info WHERE Category='" & category &"' AND State='" & state &"' AND County='" & county &"'"
the way the database is going to be set up now what I need to do is search through one table that will have all the states, counties, category, and UserID fields.Then it has the other table that will have a UserID field and an email field.So I guess it needs to go through the first table and depending on what state, cat, county were selected it will take that UserID and match it to the UserID in the email table and then pull the emails that match UserID.UserID? Would this use JOIN? UNION? How would this be done, to take the form info and search the one table and then depending on what userid matches the state, county, and category in that table it matches that userid to the userid in the email table and pulls the emails from the email field.
Basically I have the following SQL statement:
Quote: sqlConnect = "SELECT Users.User_ID, Users.Password, Users.Username, Event.Event_ID FROM Users LEFT JOIN Event ON Users.User_ID = Event.Admin_ID where Username = '" & Username & "'"
set rs= Server.CreateObject ("ADODB.Recordset")
rs.open sqlconnect, objconn, 3, 3
where username is an ASP variable of the username.
When I run this and I try to access a field from event I get an error i.e.
Quote: if rs("Event.Event_ID")<>")" then
session("admin")= rs("Event.Event_ID")
end if
Does anyone know what is wrong?!?!?! It doesn't seem to be able to pick up the fields from the event table?
I'm trying to do a multiple count on different tables in my database, but it's not working. At the moment I have this SQL query, Code:
SELECT COUNT(*) AS articlecount, COUNT(*) AS faqcount
FROM article, faq;
This doesn't work though. If there are 2 articles, and 3 FAQs, it will still say 2 FAQs
Can anyone give me the proper SQL query, if possible?
I've got quite 20 identical MDB files running on an IIS5 server. From time to time I need to go into various tables and add a field or two. It would be great if there were an application out there that could either: sync all MDB designs (and/or data) esignated to match one I've added some fields/tables to OR go into all designated MDBs and create new field(s) or table(s).
I've began writing something like this that right now just does part of (b) but I'd rather find something that is much more slick and complete.
I am using a db to hold student data records. I currently display them in a roster based on their affiliation with a certain class. To edit a record I need to click the name of an individual, it opens an edit page, I make the changes, hit submit and return to the roster.
This is pretty standard stuff. What I would like to do is change one field of every record without opening each record individually. The idea comes from my Fantasy Fball league roster:
McNabb, Donovan QB PHI ActiveReserve
Droughns, Reuben RB DEN ActiveReserve
Johnson, Rudi RB CIN PIT ActiveReserve
...etc...
Where the example above says "ActiveReserve" is a pull down menu that lets me change who is playing week to week. I can then change each record, hit submit one time, and update the db. So how do they do it?
Does anyone know how to insert multiple records in the same table at the same time. This is what I have. I have a form with 6 fields and they are name prod1 through to prod 6. The table is called related products.
Basically this table is related to the main table called prod_parent. tried looking on google and couldn't find anything.
I already have this piece of code that inserts multiple rows of data into a single table at once. Code:
View Replies View RelatedI can trigger these events successfully if table only has one row:
Sub InputField_OnChange()
......
End Sub
But, these events cannot be fired if table has more than one row, why?
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 ....
Just as the title says I am trying to do something impossible with a single SQL statement. I am doing an ASP webpage for internal use at the company I work for.
I want to know if there is a way to insert/update data into multiple tables in 1 SQL statement.
If it requires functions | views or anything else that is fine but I don't want to have 3-4 different SQL statements to update 2-3 different columns in different tables.
I have a search option on my website, which should perform a search on 4 fields, as follows:
tblNews
headline
content
tblDatabank
filename
description
It only needs to return matches which are an exact match of their search criteria. For instance, searching for "I am here" would return a record which contained "I am here", but not just "I" or "I am" etc.
I need to return all these records as part of one recordset preferably, as I want to be able to order them etc., though I imagine you may suggest I use an array somehow to merge two recordets etc., then reorder them?
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:
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:
View Replies View RelatedHave 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.
I have a table produced with names across the top and services down the left hand side with boxes for numbers for people who recieve services then the info is written into a table in an access db. That works fine and here is that code:
View Replies View RelatedI have two tables. Table A has 20,000 records, Table B has 2,000 records. Table A is what needs to be updated from the data in Table B. Only some fields will be updated and of course, only some records - both tables have the same field as a ClientID so matching up records should be easy.
Anyways, been a while since I have used ASP to work on things like this but would like to work through this one. I understand the process I believe, it is just how to make it go on to the next record once it has finished updating the first.
Basically, I was thinking of having it set up to reaad the top record from Table B, update applicable data in Table A. Delete that record in Table B. Move on to the next.
i hav problem with updating the data. In the asp page i hav displayed records based on search criteria. in display mode im displaying the to be updated field in combo box for each similar contract_no. each contract_no will hav different no of rows and to be updated combo box.
based on the selected value in the combo boxes of different contract_nos i hav to update the combo value with old value. user select multiple combo values at a time I need anybody's help with detailed programming logic.
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:
I'm required to write ASP code to open some .OFT (Outlook template) files from within a web app. Does anyone know how to accomplish this ?
View Replies View RelatedI devolop a webpage using ASP.NET. i want to redirect my page to certiain links stored in the database. the links can be either URL or Word documents sored in the server. here is my problem. when i redirect my page, if it is a document, it opens the MS.Word appilication.
instead, is there any possibility to open those documents in IE itself with out any confirmation ?
I have an application that generates PDF documents (from an ASP page). In some cases, I need to generate a PDF then provide a link to that PDF from the web page - this I can do fine. In other cases, I want to generate the PDF, but then immediately open the PDF in the browser; in this case, once I have generated the PDF, I am simply using 'Response.Write MyPDFPath' to open the document.
However, for some people this doesn't work, but for some it does. And I can't figure out why results are different. In both cases, the browser address changes to match the URL for the PDF document, but in some cases, all you can see is a blank screen. If you click on the Refresh/Reload button, the PDF displays perfectly - so it's not a show-stopper, but it is a bit of an inconvenience.
Has anyone got any ideas why this may be happening? Is there a better way of opening the PDF? I thought of streaming directly to the client, but that would present the user with an Open/Save/Cancel dialog, which although is more intuitive, it's hardly any easier than clicking on Refresh.
I'm dynamically creating a PDF file using a 3rd-Party component. I've got this much working...
However, once the PDF has been created, I want to open it in the browser. This is where I am struggling...
I can create a page with a link to the PDF, but I dont know how to open the PDF in the browser directly.
How can I open an .exe File from ASP without getting any message?
View Replies View RelatedI want MS Access 2000 database column of table 1 = column of table 2. This is what I was doing: Code:
View Replies View RelatedWhen I try to open an Excel file from ASP thro' HREF it works fine. But i give the same file in Response.Redirect it says "page cannot be displayed" even when the file exists. Is this related to server configuration?
View Replies View Relatedi have a radio button when a user clicks it i want to open up a excel sheet
and want to display the records from the table
i want to only display specific fields from the table not all fields
Can someone tell me how it can be done in asp 3.0
I would like to open a new window (Function is called NewWindow and is writtent in VBscript) when a user submits a form. All the samples I found on the web indicate something like the following: Code:
View Replies View Relatedhow can i open a new window with a if statment but still getting variables values?
tit=Request("title")
if x=1 then
something
else
Response.Redirect("<A href="http://www.test.com/lookup?q="&tit">http://www.test.com/lookup?q="&tit")
end if
I donīt mind using java, but i donīt know how
I am working on a website and have a couple links that open up a new window. My webpage is .ASP as well as the windows I am opening. Currently the link open into a new window. However, I would like to be able to set the the size of the window that is opened.
This is the code I am currently using:
<p><a href="Search/search_owner1_form.asp" target="reportWindow" class="style2">OWNER 1</a></p>
I have problem i want created simple site
This site should epitomize table about organizer free or busy room in month
the rooms is 6 but people should mark