I just received a database schema from our dba and was given the task of doing a look up of several fields & then doing several specific tasks, depending on the information. I know how to do a lookup and an if statement for 1 table, but how do I handle a lookup in multiple tables and also do an if statement based on multiple tables?
For example, there would be a customerid, which is in the customer table; support is in the support table; and customertype in the type table.
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?
Okay, I have a db that contains 1 table. it has some house info and stuff in it, but I want the updates and news and stuff on my site to be dynamic.
So should I make a new table inside my DB and use that alongside the house info table? What would be the best way to accomplish this, and if possible, do u have to set a recordset up for EACH table?
I want to query multiple tables (all with exactly the same field names) and then display the records returned in date order.
I've written the SQL to query all the tables (they start with the same name, but end with sequential numbers), but it's returning no records when I know there should be some. Any ideas? Code:
i have a simple search page which i want to search mutiple tables with different layouts so i can return the search results in one recordset. how owuld i do this?
I have 3 tables Employees, nationalities, Companies.
I can easily use a join to retrieve all the data I need from all three tables.Now my problem is updating those tables.I want to be able to update all three tables in one swoop. That is, how do I update all three tables with one update statement? Is this even possible?
I am trying to create a datalist that pulls from table A. When the user clicks on one of the rows in table A I want it to expand under that row and show the data from table B (one to many relationship).
Im not sure what is the best way to accomplish this. Is there a way to use the selecteditemindex to insert a new datalist ?
anyone in here got an idea on how to open multiple tables on a single asp page? what i did was put 2 record sets but the problem is only the first table was looping.
I havecracking my head to solve this problem. I am doing a project on Online form. But because the there is too much field for a table, i have to split it up into 3 tables. I need to know how to update the 3 tables simultaneously, when i submit the form.
I am currently using this sql code to delete information about a league but how could I delete records from other tables and incorporate it into this sql code?
sql_insert = "DELETE FROM Leagues WHERE LeagueID=" & lid
I have 3 tables, product, industry and plist. product has productID and product, industry has industryID and industry, plist has productID foreign key with productID on product table and industryID foreign key with industryID on industry table.
In the plist table I am storing the productID and the industryID's that relate to that productID..
industryID productID 1 4 1 7 1 9 1 10 etc.
What I want in my ASP page is to return the actual products that each industry serves. So for the above example my script should return the products in the product table that relate to the productID's 4, 7, 9, 10, when I search it by industryID 1. I hope this is making sense. Code:
I 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?
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?
I've been building an ASP app that sits on top of a relational database (MS Access). The problem is that the data from some web forms need to be stored in different tables. Currently I am using multiple SQL Insert statements.
The problem with this approach is that it is possible that several inserts would succeed and then one would fail. This would ruin my database. Is there some way to synchronize the Insert commands or to "flush" the commands at the same time? I need the Insert statements to either all succeed or all fail.
I have 4 tables first table category (category_id and category name in it) second table artist (artist_id, category_id, artistname in it) third table album (id, artist_id, album_title in it) forth table song (id, album_id, title in it)
I'm selecting category in first page I'm selecting artist in second page I'm selecting album in third page
I'm requesting, collecting and posting all id's to the next page.
this is the question!!
How can I read from database
1- category name when I was selected in first page 2- artist name when I was selected in second page 3- album name when I was selected in third page
i have an instance where I need to add records to 2 different tables. i know how to do it basically, but the problem is, one table is generating a key number and i need this number for the second table records.
how do i put the appropriate records into the first table, grab the id number and insert the records into the second number? the information is coming from a form. i'm developing in an access db but will be moving this to an ms sql db before it goes live.is there a stored procedure that might make this easier? i know nothing about stored procedures.
how do you do this. 2 tables. one called "Bookings" one called "Rooms"
what kinda query would i use to make it LIST the contents of the ROOM column in the BOOKINGS table, then get remove identical matches in the ROOM column in the ROOMS table?
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 would like to dulicate a selected record. Sounds easy enough like performing another INSERT operation. However, that solution only works if the datasource is only one table.
I have 4 different tables all linked to the main table through a unique primary key (auto number). When a user clicks a button to clone a record, all related records from the other tables must also be duplicated using the newly assigned ID that matches the one from the main table.
Hopefully I didn't confuse you. Consider it like a multi-step process of filling out different web-based forms but using the same unique id.
I don't know the first place to start on creating duplicate entries based on existing records. If you can start me with the code, I could probably follow the logic. THe difficult part for me to conceptualize is how to carry this new ID to all the other tables.
I have a web page that queries a database returning a recordset containing a whole series of URLs (host headers).
I want to display these in a table with one of the columns holding the current I.P. address for each URL. I know how to get a list of these IP addresses from the cmd prompt using "nslookup" but I'm absolutely clueless how to get hold of these values in my ASP page. I'm limited to the fact that this must be only ASP (VBScript, not .NET), i.e. I can't call install any components.
Looking for a source for data and/or algorithm that would allow me to enter a zipcode and find - in our case - every car dealership that sells, say, Chevy's in that zipcode - if not there, then what about adjacent zipcodes..? - in an ever expanding circle outward, and return a list of those zipcodes. In my database, I've already got the car dealers and available makes. What I need is the zipcode "map" reference.
I need help with a simple (well not so simple for me) password lookup script that will email a user their pw when they put their email in an input box. I have the db set up and the connection enabled but need some help w/ figuring out how to set it up to mail these out.
On the top of my page i want to check what page the user has come from, as if they havent come from two pages i wanted them to, i need to redirect them. Alot of people are bookmarking my site with a page that causes errors. Any ideas?
DNS Lookup Error.This error resulted in the web browser that my user was using and this is details:"The URL you requested could not be retrieved because the named server is not registered in the domain name services. Please check the URL and try again." I've checked with the user and find no fault with the URL address. What could possibly be wrong?
Is there a way that we can search a remote web page for a specific line of text?We can check if a specific URL exist using the "MSXML2.ServerXMLHTTP" object witch works just fine, but is there anyway we can search the page for text using this same object.
Does anyone know of a pure ASP way of doing this?I am displaying the results of a large recordset and at the moment it looks like the page is not doing anything.I have a solution using an image and some javascript, f there was a way of doing it in ASP, perhaps using the response buffer?
I have a form on a webpage that someone enters a number (SponsorID). After then enter that SponsorID into the form, I need to somehow query my SQL database and find the record that has the same ID as the SponsorID entered into the form and return the SponsorName (and write it out on the page using a <div> tag or something of the like) WITHOUT reloading the entire page (because I will loose the other information already input on this page).
Now, I don't necessarly have to query the database, I *could* create an Array when the page loads, using ASP, that will contain the SponsorIDs and the SponsorNames and then compare the SponsorIDs within that array with the number that was entered on the form.
I need to look up what user name was used to login to a protected directory using ASP.
I don't want to create a login page, etc. It shouldn't be necessary. Only employees who already have user accounts need to log in to the webapp and the protected directory login box is all the security I need. I just need to be able to access the username that they used in my application. Code:
I'm trying to get a users free/busy status from exchange from within a website and using the code below, but when I run this a login page from MS Outlook Web Access is retrieved from the server rather than a XML file containing the users free/busy status for the specified time period.
I've spent all day looking for solutions to this but I'm stumped. I have been looking for an Exchange newsgroup but there doesn't seam to be one, does anyone know if i can post this some where else to get a response from an Exchange expert.
