I 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:
I have a website which requires login. The login function works fine, but I want to display this message when someone is logged in: "Welcome, Firstname Lastname". Here is the code for login.asp: Code:
View Replies View Relatedare 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 Relatedhow 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 RelatedSelect 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
if 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'm having a hard time with the Day() function. Basically, it appears
to be picking and choosing which part of a date string it uses to
return the result ... heres some 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've noticed changes to the forum, for instance... the addition of a "time spent on forums" and user-post "bar" thingiemabob
...And on the front-page I'm presented with a link to "View my warnings"
Which is obsolete, considering that I don't have any warnings (oh, I'm such a little angel!)
Any news or admin care to comment on this?
Where do you think I can get just this feature alone in ASP?I just need this feature and not this whole forum. Any other similar product I can use or try?
View Replies View RelatedI am very new to ASP and I am trying to add an existing script.I have an open source shopping cart and I want to add real time shipping rates from USPS.
I have a username and password for the USPS server,but I am having trouble figuring out where to place it. Also if someone as a script to send and recieve data from the USPS server that would be great.
I need to provide the search feature on the companys web site. I have read one of the threads here that this can be accomplished via Google. I can't locate the thread anymore. Is it possible? could you please point me to the right resources?
View Replies View RelatedI 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 want to have this feature implemented on a framed page: a two paged frame with:
frame (a) containing a textbox and submit button
frame (b) dispays the url entered in the textbox
i have no idea how i'll program the textbox to accepts urls and open the link in the target frame.
I would like to insert a calendar into a webpage that shows the current date and really needs no updating, fro mthis calendar i would like to select a date from it and have that date inserted into a text field, in all there will be 22 text fields (but for now its probably best to concentrate on one).
The reason being i would like to give the user of the website access to change dates in a table in access. The dates can be calculated from the first date entered into the first text field like so:
All dates will be 7 days apart. Ie if the firsat date is 1/7/04 then make the second 8/7/04 and the third 15/7/04 etc 22 times.
I'm building my ASP pages using dreamweaver 8 and some code that I learned along the way.
Can anyone tell me how can I sort (or order) the records in a table just by clicking on any of the columns?
i have a text field that the user can input a keyword to search on. i want it to search two fields in my database: productName and productDetails. can someone tell me the sql i would have to use? I know it would be a mixture of using the WHERE and LIKE commands.
View Replies View RelatedI have an email program, that I wrote for my newsletter. When I send my emails, I am getting more and more bad emails. Is there a way to have an auto remore feature that will remore the email from my database?
View Replies View Related