İptal Edildi

Data Shaping, Horizontal Loop and SQL statement

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.

Beceriler: ASP

Daha fazlasını gör: data shaping sql, horizontal loop sql, sql statement horizontal, vertical screen, statement problem, statement of a problem, sql price, problem statement, problem categories, it problem statement, how to make a statement of the problem, how to make a problem statement, data 0, asp button price, a problem statement, sql horizontal loop, how to pull data from a website, website sql, stay, sql data, repeat, pull data, moment, make loop, data

İşveren Hakkında:
( 521 değerlendirme ) Colchester, United Kingdom

Proje NO: #25953

11 freelancers are bidding on average $74 for this job


hi, we can do this in good manner. regard sri

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(74 Değerlendirme)

Please See PMB.

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)

We offer an outstanding technological value, while at the same time providing a high degree of quality industry-specific design services at very competitive prices. We have peak level expertise for each technology. We Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(4 Değerlendirme)

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(8 Değerlendirme)

Greetings, we are pleased to place our budget which is most reasonable and accurate one. Pls. visit our portfolio site : [url removed, login to view] Microsectec.

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(4 Değerlendirme)

We are one of the leading web development company based in Toronto, ON. We understand what you need. We are experts in ASP and can fix it professionally. What you need is professional help and I am sure that we are one Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(12 Değerlendirme)

I have 7 Years Experience in Web Development and Software Development and i am ready for this project. and iam having Experience in .Net , Asp ,Javascript,Data Processing and C/C++.

in %bids___i_period_sub_35% gün içinde95%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)

I am afraid, will u wait till the project closing date for such a small thing? If u want let me help u with the right SQL statements u need and even more, sitting across with u on msn or ymsn right away. I m doing sql Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(2 Değerlendirme)

We will doing all that you want (and more... :-))). Quickly, Professional, Quality - our answer you and your organization. We work more than 10 years.. There are questions?

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

i am working software programmer i know asp,asp.net,sql server,oracle etc...

in %bids___i_period_sub_35% gün içinde75%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

I myself am a MICROSOFT CERTIFIED PROFESSIONAL and am running a software company in New Delhi for the past 5 years. We can provide you with the solution just as per your requirement. We can assure you of the best of se Daha Fazla

in %bids___i_period_sub_35% gün içinde55%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)