Using Recordset Repeat Region to display muitiple records(solution for displaying 1 data only)

I found out a technique to resolve a mistake that i got before, was to display one data record only rather than multiple records.



I used REPEAT REGION to work out.

On server Behavior, I click plus button to choose Repeat Region.


Small dialog called Repeat Region appeared afterward.

as Recordset1 as the name of recordset should be used, I already created.
Show how many number of records a time I want to display, I choose number 2



Firstly, I click on Dynamic Text (Recordset1.proID) then move mouse point to (+) button in server behavior panel.

extra codes would be generated after "ok" button of REPEAT REGION was clicked.


Applying the same method with the rest :
Dynamic Text (Recordset1.price)
Dynamic Text (Recordset1.image)




Finally, I can see 2 records shown on the web browser but another problem occurs.

All data were put in the same cell of table, I wanted to separate them, each records should be in different cells of table.



so I already posted my question again on the forum.

working with RECORDSET => displaying database by dreamweaver for displaying one product only rather than a lot of products)

After connect to DSN scuccessfully, I want to display my data records on product table.

Open the Bindings panel, if it isn't already open, by doing one of the following.

• Select Window > Bindings.
• Click the Application panel group's expander arrow and then select the Bindings panel.

Choosing Recordset (Query)
















Recordset came up.
give a name for this recordset, connect to database connection.
After connecting scuccessfull, a list of table in database connection will appear.

I chose product table to display its entities such as proID, proName, price, image.






From binding panel, I drag each entity of product table and drop them into each chosen place as picture shown.














I preview a result within FireFox and see one product shown only.

I have got 2 mistakes and been searching for solutions

1. image is not shown on the web
2. there is one record shown only, I need to show more
   

For my error consideration, I post it in ecommerce forum.

Using Dreamweaver features and database connection to display product infor

Choosing binding tab on the right hand side of Dreamweaver, I am able to create RECORDSET and display product information


















connecting my site to data source which means I have made it possible for dreamweaver to write code for me that retrieves data from my database.















- I name a test recordset as Recordset1, choose connection as connection.
- Clicking on test buttn to try database connection.












when the Test SQL Statement window appears, it means my connection is successful.














To display category information. I drag catID and catName from binding panel and drop them into Design mode of Dreamweaver.













product.asp successfully show category information on IE Browser.



However, as picture shown, i can only display one image only on web browser, I want to show at least 2 records on the web. I have been searching a solution for this error.

working with Dreamweaver and Database Source Name (DSN)

After creating "product.asp" directly on testing server, in the path "vhp0003/coursework1".
my aim is to try connecting to database file called "vhp0003cw1.mdb" on testing server by dreamweaver.

On database tab on right side of Dreamweaver, there is + button to create DSN.



After selecting DSN. I would get DSN dialog:

working with Dreamweaver and hosting (part 1 continure)

I have found out an error that causes me can not connect to "coursework1".
My problem solving is to put " coursework1" in textfield of "what folder on the testing server do you want to store in ?"



then try "Test Connection" button



this means a connection between dreamweaver and testing server is fine now.





Finally, I am able to view all files on my testing server by Remote View.

Searching Model Design for my website template

There are many website with different design layout on the internet, but it is difficult to choose the good quality design.
I have searched on Google for 5 formal design layouts from different 5 e-commerce websites such as ASDA, EBAY, TESCO, AMAZON and LAURA ASLEY







Among the websites, LAURA ASHLEY is well design with tidy layout, consistency, attractive icons and the main point is the website give to customers a background what the company is selling on the internet.

working with dreamweaver and hosting (part 2)

It is a bit annoying when everytime I coded in dreamweaver then use Filezilla to drag all my my files into right place as coursework1. after playing dreamweaver for ages, I find out 1 easy way to connect direclty to university hosting, it directs every data values I coded toward to testing server, besides, I can create new folder or new web page in the hosting server without help from Filezilla. everthing gonna be easy with Dreamweaver.

Here I use FTP method to connect directly to testing server. To start with, Go on Site tab => choose Manage Sites.


A dialog box appeared and I clicked on New button, it showed me 2 options, choose FTP&RDS Server


Another dialog appeared afterward with many textfields, I fill in the name, FTP host, host directory, login and password, then click on Test button to test connection. If a box show web browser is connected scuccessfully. that is fine. but if it say FTP connection fail, a problem may be wrong login or password or wrong FTP host.



Connection is fine then on right hand side, we will see on File tab, an option button with a name of my current connected site then Option button called Local View . To see all files we have on testing server, I drop down down Local View, then select Remote View. A folder called "coursework1" that I want to work with, list all files inside.


On the final stage, my purpose is satysfied.