Käynnissä

Data Shaping

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 to repeat the products in the ProductsMain table.

I have used data shaping to successfully pull all the products from the ProductsMain table and all the sizes for each product under each product. So I have a loop within a loop.

My problem is I am not sure how to add the Where clause into this to only select from a certain category from the category table.

Also I am not sure how to make the repeat region become a horizontal/vertical repeat region at the moment it is just a vertical repeat region and repeats all the way down the screen. I would like it to go 4 accross and then onto the next row.

So in short I need my data shape loop made horizontal and my where clause to filter from the cateogry table.

Taidot: ASP

Näytä lisää: vertical screen, problem categories, data 0, data shaping, recordset filter shaping, repeat, pull data, moment, make loop, data tables, data n, data building, data an, c data, recordset, sure problem, loop table, vertical website, data product, website data add, select name, records screen, filter category, cart filter size, screen short

About the Employer:
( 520 reviews ) Chelmsford, United Kingdom

Projektin tunnus: #26028

Myönnetty käyttäjälle:

cchatter

Hello Hello, I am a software engineer from Cincinnati, Ohio, US with 6+ years of experience in ASP/MSSQL/PHP. I read your problem and will be able to take care of it in couple of hours. Thanks

65 $ USD 1 päivässä
(8 arvostelua)
4.7

3 freelanceria on tarjonnut keskimäärin 68 $ tähän työhön

default

Hi, My name is Igor, I have a large IT deveplopment expirience. Here is my online resume: http://www.4bossy.com/Racyborynsky-Resume.doc It's nice tool and I can make it fast and comfortable for you. Greetings, I Lisää

40 $ USD 2 päivässä
(1 arvostelu)
4.3
viaden

Dear Friend. Thank you for your project. We got your idea and are ready to cooparate with you. We are an IT-company with more than 10 years of experience in the sphere. Please, contact us via PMB to discuss the deta Lisää

100 $ USD 10 päivässä
(1 arvostelu)
3.6