Select data from 2 tables at the same time but there is no relationship between them. This is what i want but i dont know how to join them.Here is what i was trying.Code:
sqlstr = "SELECT * FROM persinfo,positions WHERE personid.personid = '"& session("personid") &"'"
rs.Open sqlstr,conn,0,2
sqlstr1 = "SELECT * FROM positions WHERE jobidid = '"& session("jobid") &"'"
rs.Open sqlstr1,conn,0,2
i have a drop down box that selects tables on my asp page, but using the hidden attribute, they have fixed positions on the screen. this a search engine and i need it so that if they only search two options that them two options will be at the top of the screen?
View Replies View Relatedi am designing a search engine, you select the search options from five choices in a drop down box, each option reveals a table, but the tables have fixed positions on the html page.
i need it so that if only one option is picked to search and it is the last option on the drop down list, that it will appear at the top of the page? i dont have a clue what type of function to write to do this or what techniques will be involved!
I am Trying to use the SQL SELECT Statment to open records from multiple tables into one recordset.
I know the basic syntax of the Select statment but I wanted to know if its possible to recive the table name from the feild or the record that I am readinf from the recordset in any given moment.
To make things more clear, my example:
-Open a connection
SQL = "SELECT * FROM TABLE1,TABLE2 WHERE TABLE1.UserID=" & uid & " And TABLE2.UserID=" & uid
rs.open sql,conn,3,3
while not rs.EOF
-read from record
rs.movenext
wend
rs.close
conn.close
now, in the part that I read from the record, is their any way I can know if that record is from table1 or table2?
I have a line of code in my script that looks like this:
Set User = objDBCon.Execute("SELECT * FROM tblsUsers WHERE ID = '" & request.form("user") & "'")
This gives me an error of data type not the same. Anyone know what the problem might be?
are you able to open two Access tables at the same time or is this bad coding practice?
View Replies View RelatedIs 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.
View Replies View RelatedI 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.
I have a two tables in my database with a username column in both of them, i am trying to build an SQL query to return only the usernames that are not listed in both of the tables.
Any ideas?
i want to add columns dynamically from asp......say for eg. i have a drop down and from that if a user selects 10 as the value it creates 10 textboxes and then when saved it should generate that much columns in access table for saving............hope u guyz got what i am saying... i want to create fields dynamically in access database.
View Replies View RelatedI have a login feature but i want to be able to let users from different tables to log in. The data base is Access and the code is from DreamWeaver MX.
The computer recognises that there are two tables. However i get the message:
Microsoft JET Database Engine error '80004005'
The specified field 'userID' could refer to more than one table listed in the FROM clause of your SQL statement.
/members/loginform.asp, line 21
This is the code:
how do you search all the tables in an access db with different field names? i would like to place a textfield and a dropdown of the different tables of the db. i cant figure it out. im using asp and dreamweaver.
View Replies View Relatedhow do i join tables in access and how do i get asp to output information from two separate tables that have the same primary key?
View Replies View Relatedif its possible to create a database from an asp script? My task is to make user surveys where a user selects elements such as text boxes,drop down menues etc from a form, I then have to to make the corresponding table in Microsoft Access.
View Replies View RelatedI have an query that gets value from two tables lets say tb1 and tb2. First i m tryin to insert values into tb1 and based on those values i have to update some already existing values in tb2. it gives me following error:
Provider for ODBC Drivers error '80004005'
Cannot update. Database or object is read-only
i know my cursur types are correct as i can update without any error with a single table. This leads me to wonder if updating multiple tables in access is possible?
I was just wondering if there is anyway to link tables from another Access database using ASP. Just like the function in Access where we can go File->Get External Data->Link Tables.
I have implemented some e-modules and they all have individual database as a backend. But, my boss would like to allow all these e-modules to share data. Therefore I am thinking of linking all the tables in those databases through a 'gateway' database (gateway.mdb). This 'gateway' database would have link tables from all other databases.
I have the following connection string:
"DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("../_database/MOO_ACCESS.mdb") & ";"
Which tests successfully.
When I try to view the tables within Dreamweaver of the access database though, it shows none. There are definitely 2 tables built in the database.
anyone have any ideas?
I have 3 tables (MS Access) and I would like to display the content of all three tables alphabetically on a .asp page I have no problem displaying a list from each of the individual tables, but I am stumped when I try to display a combined listing..
View Replies View RelatedI have two tables Property & Landlord. I have a form and when it is filled in and submitted the information should be sent to the two tables, but i cant seem to get my head around this problem.
View Replies View Relateddoes 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 Relatedhow to export ms-access tables information to excel sheet using ASP....
View Replies View RelatedI was trying to integrate a forum software to an existing site. The site is having a different database file already. What i want to do is, copy the forum tables from forum database file to the existing site database. How can I copy the tables from FileA to FileB using ASP?
View Replies View RelatedIs it actually possible for a local access 2000 database to link to a remote database online via linked tables. I just wanted to know how feasible a LINKED TABLE scenario would be.
If this was possible it would solve so many administration problems and save development time when it comes to building asp-admin pages to manage the backend.
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:
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 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 RelatedI've got a WYSIWYG editor, that runs off a template page (i.e. template.htm) that gets opened in an iFrame for editing.
How can I get it setup so I cange the template at the click of a button? I've tried doing a form with radio buttons, but can't get it to work.
For example, the iframe source has been set to "strTemplate". My form processing was along the lines of:
<%
If request.form "template" = "template1" then
strTemplate = "template1.htm"
Else
strTemplate = "template.htm"
If request.form "template" = "template2" then
strTemplate = "template2.htm"
Else
strTemplate = "template.htm"
End If
End If
%>
I have a list box which has the following values:
Car
bike and Boat
If I select "car" it is fine but when I select "bike and boat" it just takes bike
as the selection. It is taking the space as the end of the string. Is there a way I can
rectify this?
My boss wanted me to add a dropdown to this form. I was able to add in the dropdown and it inserts into my database (Access) just fine. However, I have an edit page also and this is where my trouble comes in.
On the edit page, the dropdown does not "know" which specific option was selected. I tried to write an If statement but I think there is something wrong in my syntax. Code:
I have undertaken a website revision project after not programming for about 6 years. I am beginning to set up a work environment on my pc, and have questions about the software being used verses what could be the ideal software.
I am familiar with classic asp pages, not asp.net. I am also familiar MS Interdev (but am unable to locate my copy and cannot find a torrent file - is this an archaic program now?). The last thing that I'll mentioned is that I prefer to have a debugging capabilities.So the current website uses Dreamweaver 8.0, IIS 6.0, and MSSQL 2000. Question.Given my background, what software would you use to set up a work station?
i need to display results that do not match those in the database.I have an excel file and i upload it,inserting the records in a temp table. han i compare the values in the original table and the temp table.All i want is the values that do not match
sql = "SELECT TempSerial.SerialNo "&_
"FROM TempSerial, Serial WHERE TempSerial.SerialNo <> Serial.SerialNo "&_
"OrderBY TempSerial.SerialNo;"
Set RS = objConn.Execute(sql)
i displayed the records with <%=RS("SerialNo")%> but i get all the records in the temp table displyed.
i need to extract some data from a table called accountantsBids. I want to select the last entry for every accountant based on the date descending.
Table:
entryid = Autonumber
Accountantid = FK
DatePosted
I've tried TOP 1 but that doesn't do it - it only gives one recordset. What would be the best way to get this working.
I have a database with date of gigs in it and am trying to select * from the database the next gig basically, and am compariung against todays date and saying select * more than todays date. Is this right, cause it's not doing it? Code:
dateN = Date()
set conn = Server.CreateObject("ADODB.Connection")
conn.Open "************"
set recsetS= server.createobject("ADODB.Recordset")
sql = "select * from admin where dated > "& dateN &" order by relevance DESC "
recsetS.open sql,conn,3,3