Recordsetmunkák

Objective is to examine a Microsoft access 2002 table named "Contacts" for all birthdays and cause a reminder form to open displaying the data in the table that meet the birthday criteria of x days prior to the current system clock date. Using Visual Basic in Microsoft access 2002, create a recordset and loop through the recordset for dates appearing in a field named "birthday" in a table named "Contacts". Compare the Month and Day parts of the dates that appear in the field "birthday" in a table named "Contacts" to the parsed Month and day part of the current system clock date. If a date is x days prior to the current system clock date, then open an access form named "fmUpcomingBirthdays" and display on that form...

...and a parent ID). - I need a script that will order such a query by the parent ID recursively and return the reordered query - The script should also add a NestLevel column to the new query with a 1 for top level records, a 2 for their children, a 3 for their childrens children and so on. - The script must work with any query/column names - The script must be efficient (not going through the recordset too many times). Sample query: PageID ParentID PageTitle 1 0 Home 2 0 About Us 3 0 Products 4 0 Contact Us 5 2 History 6 3 Product 1 7 3 Product 2 8 5 Recent history Should return: PageID ParentID PageTitle Nest Level 1 0 Home 1 2 0 About Us 1 5 2 History 2 8 5 Recent history 3 3 0 Products 1 6 3 Product 1 2 7 3 Product 2 2 4 0 Contact Us 1 Sample Call: Solution Requirements: Create...

I am so lost with this. I use the same exact RTE as they use here on Rentacoder. And what I need to do is populate it with data via a drop-down that is generated from a SQL table (both will contain the same recordset) ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distri...

...Features needed. 1. Ability to logged in with their user name and password. (The password that was created when they sigend up on website). 2. Website using mssql or ms access database so we have to give some connection preferences to connect to database. 3. Multi Thread Downloading like other download manager have. 4. When full mp3 is downloaded it should have ability to update the recordset as downloaded. So that user can not download it again or redistribute the same mp3 to other. What we needed ==================== We need to develop this prefebly in Visual Basic but if in any other language you can develop then no problem. We need full source codes so that whenever the connection string or connection details changed we can change it in source code and re-...

A small code (about 20 lines) from VB6 to Visual Web Dev 2005 Express. 1. accesses a MDB through Recordset be converted to access MDB through ADO. The Recordset must be in a function witch must be accesable from every Page in de Website. 2. same as above but connection to a MDF

I have an existing access 2000 database that I need some very quick modifications made to. 1) Add the ability to add records to 'Main Entry Form'. Add a button to the form and logic to support adding records. 2) Add a 'search records' button and a textbox to allow searching on the main fields on the 'Main Entry Form' and return a recordset list of these values. I will send the DB after I decide who to hire.

I have an existing access 2000 database that I need some very quick modifications made to. 1) Add the ability to add records to 'Main Entry Form'. Add a button to the form and logic to support adding records. 2) Add a 'search records' button and a textbox to allow searching on the main fields on the 'Main Entry Form' and return a recordset list of these values. I will send the DB after I decide who to hire.

Need small piece of code to read a stored procedure from a SQL Server 2000 database. The stored procedure will then return a recordset which needs to be converted into an XML Document. This XML document will then need to be validated against an XML schema. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop softw...

We need an application that will take a basic PDF invoice template and merge it with data provided via an ADODB recordset. This is under an ASP/IIS Windows 2003 server environment and we have no special server side software at present to build PDF's. We expect you to provide a basic invoice template with our logo to be provided and some mechanism for us to make minor edits to it over time. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverabl...

Need help customizing application. Recordset and access db mainly.

I need a coder to code in vba/excel, creating pivot tables on the fly, based on an existing recordset...if you have experience with this, please submit and I will send you further information. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation ...

i m writing project and checking in it the query for date in VB 6.0 i m not able to find hoe to get that query done via recordset also can i do month wise summation of the those fields and disply them one by one ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribut...

This is a Ruby on Rails project. I have a simple business list...my application. The controller will use internal and external APIs to run searches, and modification of internal APIs may be necessary. You'll also need to use ferret/acts_as_ferret for searching the model, and a method callable by script/runner is needed to reindex all records. Lastly, you'll build an import method, also callable by script/runner, that uses a field map to convert an exported recordset (CSV format) and load it into the listings table. You'll be working with at least the following: Ferret, acts_as_ferret, MySQL, CSV, script/runner, RJS, Yahoo Search APIs. You must have your own development environment and the knowledge/ability to deliver a fully-functional, standalone Rails app that runs...

I have a recordset which queries orders, I need to add the table orderdetails to it as an inner join to orderid See attached file , please adjust the recordset OrdersRS to include orderdetails, then you can delete recordset1 first one who can do this gets it ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including des...

Hello, First, I must say this thi...this XML document is not formed 100% properly. When there is no data value for the tag, instead of the typical XML structure - this file differs. Take a look at the attachment to see. ------ I need the information in this XML file READ into memory and stored as 3 ADO recordset objects. 1. Info 2. Step (All the Steps) 3. Archive **NOTE: You will NOT be able to read directly into a database because of the way the XML file is structured. ----- Lastly, There should be a write subroutine which will take those 3 recordset objects and write them back to the file (or create a new one, it doesn't matter). **NOTE: This job must be done quickly - please give a timeline (only 1-3 days). Write code in VB6, VBA, or vbscript. P...

I have an ASP page that loads a recordset from database table. This is an edit page so I then set the value for each textbox to the appropriate value from the recordset. The problem is I have a couple of option boxes - dropdown - that I have the value that was selected and added to the data table but now I need to change the selected value of the option box to the option that I get from the data table. I need a test file that shows this capability - you don't need to actually get value from data table - I just need the value stated as a variable at the top of the page in the script and then have the html section build the option box and apply the correct option as the selected option. ## Deliverables 1) Complete and fully-functional working program(s) in executab...

I have an excel worksheet and want to supply an sql query in vb 6 ‘’ Select Name 2 from [Sheet1$]?? to return an ado recordset. The problem is that if the field Name used in select clause has a space character in between (eg “Name 2??) I cannot retreive the recordset. If I use ‘’ Select * from [Sheet1$]?? it works just fine. But I want to define in the select clause explicitly the field names ??" select field1, field2…. (Even if they have a space character in it) and return the recordset. Is there anyway I can format the sql statement or do something else to achieve this (without changing the excel document). Have attached sample app. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as w...

...displays an icon if a user or artist is online. I'm not sure the best way to do this since there are two tables beng used. You will probably want to use a new table - the holds the values of 1=user online 0 =user not online. The function can register the user as being online using session variabls on the login page. One login page for artists ad one login page for users. When a recordset of users is displayed like it should show whether the user is online or not. I also want to show i the user is online on the profile page <>[][1] ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables

My client has recently lost their long-term Access programmer who developed for them a database with frontend forms as a GUI over the past few years. The data recordset size has outgrown Access. So we've acquired an MS SQL server and are in the process of pointing the Access interface to replicas of the tables in MS SQL. However, my client seeks a long term relationship with someone who can make changes to the forms, tables, and perform general maintenance on the database. They are looking for a long-term relationship, and would be willing to pay per the hour and likely also pay some sort of a monthly retainer. ## Deliverables Coder will be paid on an hourly basis every month as long as satisfactory progress is demonstrated. ## Platform MS Access, MS SQL Server ...

PHP sub menu based on URL parameter OR based on recordset only if sub menu isn't empty. Sub menu on separate page, will use includes on web pages Database: TABLE menu_mnu id_mnu = Primary ID (Parent) idmnu_mnu = Sub menu (Parent menu ID) order_mnu = Menu order visible_mnu = Show or hide name_mnu = Menu name desc_mnu = Page description title_mnu = page title content_mnu = page content url_mnu = page URL (ex. ) target_mnu = page target (ex. _self) footerColor = footer color headerColor = header color headerImage = header image pageColor = page color pageImage = background image ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition...

Hi, I'm looking for somebody who can help me in adjusting existing code that prints records from a recordset (datagrid). I would like to see that all data in the columns (Except for the first column!) is printed right-aligned; it is now printed left-aligned. Please see attached the zip of the project. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environ...

We have a working website and need some process improvements to our ecommerce ASP code. The code is professionally developed. The tasks are: Adding a new recordset (from existing tables) to a form Adding email CC: function to some email forms Adding pagination to an existing ASP page to break the display across more pages. Links to pages can be provided by PMB.

I have two looping recordsets and one recordset loops within the other recordset. The ASP/ADO code does not seem to work as I get the following error: << error '800a0e79' Operation is not allowed when the object is open. line 34 >> I need someone to examine my code and help me figure out how I can get one recordset to loop within another recordset. Once I get this to work within an ASP page I would eventually create a Stored Procedure to run the SQL. Here is some pseudocode which is an outline for what I am trying to do: << SQL = "SELECT Id FROM Units" SQL While Not SQL2 = "SELECT * FROM Measurements WHERE UnitID = " & rs1("Id") SQL2 While Not (rs2("...

I have a link a dynamic link which is within a recordset loop. I cannot get this link to connect with the other page and push the productid through the url so the product details page can be displayed. All I need is to have this problem fixed. It is written in ASP VB Script and works off an Access database.

Attached is an access db, connection script and a results page. I am just trying to return results based on a form value passed. The recordset in question is products located in it just not giving me the results I want Example if you choose Coated Papers [id=6903] It should return 22 records from table products, since the products.categoryid=6904, which is like ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables

Kérjük, regisztráljon vagy jelentkezzen be a részletek megtekintéséhez!

I am looking for a set of routines written in VB.NET in Visual Basic that emulate the old data base calls for recordsets in VB. I have lots of code written in VB6 and I do not want to convert it throughout. I want to make calls to a function for each recordset command instead so I do not have to change the code Below are some examples of using the recordset to access the data base - I want a full set of functions so I do not have to change this code - I only want to change it in one place. I have highlighted the types of commands I am looking for BookDB = **(0).OpenDatabase**(Fname) s = "Select * from [Book Information]" BookRS = BookDB.**OpenRecordse**t(s) BookRS = BookDB.**OpenRecordset**(s) IfNot (**** And ) ThenBName = **BookRS

I need somebody to solve an error message I recieve when trying to incorporate two parameters into an SQL command that loads a recordset to be used in a Datagrid. Please see the attached files. I would like to see two parameters: 1. Value of the DTPicker control (= bdatum) 2. Value of the ComboBox control (=vReknr) The recordset should be the same as in Form Load() and in addition should select where DATBOEKING <= bdatum AND UITGPOMS ,= vReknr I only used one parameter (bdatum) in the code below but I need both! ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the d...

Only 1 task: 1. I am wanting to do a search by keyword. 2. open up , type in some text in the text box [input] 3. It goes to page 4. since the db is large the script keeps timing out and I dont know how to fix it 5. the recordset Products on if possible I need it to do a like condition of "contains" these database fields: , , , , 6. I set up the rs Products to check if the text has changed from "enter keywords", so people wont search for the term "enter keywords" 7. So I guess in if input ="enter keywords" or "" [null] then redirect the user to a page called since the query "enter keywords"

...thumbnail image. The image and address need to be displayed in accordance with the specified layout, and both need to link to a detail page which will open in a new window. (The detail page will be handled by us; the link simply needs to be constructed so as to pass the necessary information to it ??" probably just a property ID.) I’m assuming there will need to be a separate asp page to build the recordset for the flash file, but I’m open to suggestions of better ways to accomplish this. The flash files are already designed, and we will provide them for modification. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, ...

...--------------------- **ALABAMA** organization 1 organization 2 organization 3 **ALASKA** organization 1 organization 2 organization 3 ------------------- I currently know how to generate this output by using over 50 queries within an ASP page, but I also know that this would not be the most efficient way to accomplish this. An example of one of the queries used to generate a recordset for this would is: --------------------------------- SELECT Labid, LABName, LabNumber FROM dbo.tbl_labs WHERE State = 'AL' ORDER BY LABName Asc ------------------------------------ I would instead prefer to use a Stored Procedure to do all of the database querying and not embedding so much code within the ASP or ASPX page. ## Delivera...

...use jdbc) -present a form which captures startdate , enddate, author (from combo) , Report (from combo) -Reports are really the queries to run (stored procedures) -all queries accept the above parameters -parameters are optional (if empty, return all) -different queries can return different fields/columns -when the submit button is clicked, run the query and display the resulting recordset in a grid -allow the results to be exported to a csv file if desired -choose summary or detail (different query) ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web ...

...connection. The data is just one recordset about 35000 rows with 11 columns. The values in the first 3 columns represent a unique key. There are about 65 rows for each unique key. Some values in the first and/or the second columns are null. Each group of 65 rows in the base recordset will become one row in the Excel spreadsheet output with 76 columns. Each row in the base recordset has a column named "attribute" the distinct values in those columns will become the column names for the 65 new columns. Each of the 65 rows in the base recordset has a column named "value" with numeric values and a column named "alpha" with text values. The values in these columns will go into the new columns in the Excel output recordse...

Make a function that returns a recordset of locations within a given distance of a point. The function would look something like this: GetProximate(Lattitude as Double, _ Longitude as Double, _ Connection as ADODBConnection, _ Table as String, _ LatFieldName As String, _ LonFieldName As String, _ Distance as Long) _ as ADODBRecordset Longitude and lattitude are in the following format: Longitude: -111.308 Lattitude: 40.8360 This should be written in VB6. I have provided sample data in the form of an Excel spreadsheet. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the del...

Fix: Contribution database with checkboxes and text entry for service contributions, submitted to database for analysis. Database is set-up but has an error somewhere. ADD: an admin page to view this recordset online, along with the following database: ADD: Events page for client's admin uploads for public viewing. Image uploads are an option, according to fees. I must be able to edit these pages with my computer connection (files are online) and the fees are negotiable, depending on amount of work involved.

I have attached an index file. It is a compressed SQLite database. It only contains a few fields and references to files. These are all on my system. I would like a routine that will read, insert and delete items in this database, preferably using an ADO recordset but anything will do at this point. The driver for SQLite is open source and can be found at: <> The compression routine used is PKWARE's Data Compression Library. Here are references to C code that show how to decompress the file: <> <> <> <http://cvs

...order by price for part number 320. 8. List the part number, part name, average quoted price, minimum quoted price, and maximum quoted price for all parts having a minimum quoted price that is greater than $4.00. You must use the Having clause. Tip: Look at the data in the mdb file and visually determine in advance what data should appear in the result for each query. Then compare this with the recordset obtained when you run your query. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place i...

... The test must encompass questions divided into the following subject areas with the number of questions in brackets:- Outlook VBA - 6 Questions Access VBA - 6 Questions Word VBA - 6 Questions ADO Programming - 7 Questions (please cover recordset types) The basic questions must ask VBA questions from the above areas of the Office 2000 Suite and I would expect to see a rich Office Programming test. All questions would be centered around the , , and ADO (Connection & Recordset) object models. The questions must not be easy, since the answers will be easy to spot. The selected coder would ideally have used Office 2000 strongly and possess the obligatory feedback. Please bear in mind that the Test Taker will have approximately

...how to do select and make table queries, but I'd like to have a great deal of control over the database. 3. I'd like to go through each record and be able to compare and modify record items and store the information to a new table. 4. I;ve tried the queries and some SQL , but I think I would have more control by using Visual Basic with Access, I'm not sure. 5. I've tried ADO with recordset, but I'm unable to get any functional code. 6. I would like to have someone explain with code the proper way to get going with this project. 7. In summary, I'm trying to do the following: Open a Table Go through each record If a date< 9/27/05 change this to 10/12/05 if a value = x change another field Create a new table with th...

I am looking for a set of routines written in VB.NET in Visual Basic that emulate the old data base calls for recordsets in VB. I have lots of code written in VB6 and I do not want to convert it throughout. I want to make calls to a function for each recordset command instead so I do not have to change the code Below are some examples of using the recordset to access the data base - I want a full set of functions so I do not have to change this code - I only want to change it in one place. I have highlighted the types of commands I am looking for BookDB = **(0).OpenDatabase**(Fname) s = "Select * from [Book Information]" BookRS = BookDB.**OpenRecordse**t(s) BookRS = BookDB.**OpenRecordset**(s) IfNot (**** And ) ThenBName = **BookRS

I need to combine records from a MS Access 2002 query into single records grouped by IDENT here is a sample recordset that I need to parase (Query name = Feedback) Ident,Fdback 001,Good 001,Perfect 002,Could do better 002,Excellent product 002,Fast delivery This is the output I require from the NEW query/code (New Query Name = FeedbackCombined) Ident,FeedbackCombined 001,Good<br>Perfect 002,Could do better<br>Excellent product<br>Fast delivery As you can see I would like the combined feedback to be joined with an HTML linebreak between each existing 'feedback' record so feedback for each unique IDENT in the original table needs to be combined to give one record with all the seperate feedbacks for that ...

...bids on a project. I want the last bid (by date posted) they submitted and a total count of all the bids each has submitted Information to display: bid_id co_id company name company address (CONCAT) bid amount and date posted from the last bid they submitted total number of bids they have submitted NOTE: I have included in zip a sample sql statement. Now I could use this statement and loop the recordset. Display the first record for each bidder and then count the rest from the bidder to get the total count. But you may have a way to get total bids by company with a subquery ? max count or what ever You show me ## Deliverables functional sql syntax for MYSQL 4.1 + PHP used through a website not running yet * * *This broadcast message was sent to all bidders on Wednesday Sep...

...max change percent, which means that in some cases the whold set will no be able to reach the percent increase or decrease. A function which accepts an array with the necessary element and overall percentages for the array and the individual elements percentage would seem to be the best, but any approach is acceptable. The source data is available in a recordset to the routine and processing the information from the recordset is also fine. There are approximinately 500K groups of from 1 to 500 elements in the set. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the delive...

I am looking for a php4 mailing script that will send out reminders to my users. I will have it run automatically by the cron on my unix box daily. The script will read a mysql recordset pulling all entries with a date of 15 days, 30 days, 60 days ago (there is a date field). If the date is 15 days ago, one email will be sent (preferrably in html format, but text is okay). If the date is 30 days ago, a different email will be sent. If the date is 60 days ago, a third email will be sent. Code must be well commented. I will send the mysql connection data upon accepting of your bid. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as...

Here's a simple one to be done in VB6 I've got a recordset (RsICDs) that contains data. The recordset contains thousands of items. It was pulled with: iSQL = "SELECT ID, Code, Description, PersonalCode, Common, IsComplete " & "FROM ICD9Codes ORDER BY Code" Now, here is what I need help with. I want to take this recordset (all the data is now in RsICDs) and have it put into a DataGrid (or a ComponentOne TDBgrid). The Code field is always present. The Description, PersonalCode, Common, and IsComplete fields may or may not have data. In other words, they will either have a string, "", or null. Finally, and most importantly. The field IsComplete will contain either a "C" or an "I&quo...

...client/server application that connects to an Oracle 8i database via ODBC and extracts and formats a select recordsets for display to the user. The application was being developed in house but the developer was released for performance reasons and the project is on a very strict deadline. Currently the application is 85% complete. The application still requires some user interface formatting, recordset handling and exporting, and other various requirements listed in the attached specification. This project will require an experienced .Net developer that is very comfortable with datagrids, exporting recordsets, user interfaces, installers, and the .Net versioning framework. This project has a October 1, 2005 deadline for production use, including testing and distribution. ## Del...

I am currently building a website and I need to have a horizontal loop from a Data Shape Recordset which also filter the records from a category table. So I have 3 tables. One is a ProductsMain table which carries the product name, description and the paths for the images. I have another table entitled ProductsSizePrice which holds the size, price and product id. Many of the products come in several sizes so I have put them in a separate table. Also I will aventually have an Add To Cart button for each size of a particular product, so these need to stay in a separate table. The third table is ProductsCategory and this holds the categories which each product falls into. It is in a separate table because some products fall into more than 1 category and I do not want to have t...

Using the sample data provided, create an ms access database then use visual basic 6, ADO coded recordset (no data controls please), MS Excel. Export the tables in a logically formatted fashion to an Excel spreadsheet. The sample data will change frequently, the table and columns will always be the same though. All I need is the sorting (ordertotal) from largest to smallest, another page in the spreadsheet with smallest to largest, export that data to excel, save the file in the same directory (application path). This should be a simple project for a good coder who has worked with Excel objects and Acess tables in VB before. Please include what tools you will use to accomplish this work, your exact timeline, and a solid price in your bid. Incomplete bids or redirection to a ...

I am currently building a website and I need to have a horizontal loop from a Data Shape Recordset which also filter the records from a category table. So I have 3 tables. One is a ProductsMain table which carries the product name, description and the paths for the images. I have another table entitled ProductsSizePrice which holds the size, price and product id. Many of the products come in several sizes so I have put them in a separate table. Also I will aventually have an Add To Cart button for each size of a particular product, so these need to stay in a separate table. The third table is ProductsCategory and this holds the categories which each product falls into. It is in a separate table because some products fall into more than 1 category and I do not want to have t...

...tbl_listings. To see the table go to [ ][1] (login with test/test) It will take you to the page which displays the result set, a copy of the code is attached <> This page is poplulated by a mysql from a table called table is from tbl_listings. The project is to add some filters to this page. The recordset is the records from tbl_listings that do not have a matching record in tbl_interested. If you look at the sql in the .asp page it does this by counting the number of records in tbl_interested that have the same MLS number(key) to tbl_listings and userid(from cookie) to see if there is a record already in tbl_interested. Currently there are two buttons on the page 1. Reviewed