What I would do in this situation is:
1. Set up an admin page (You've done that part)
2. Set up a page that is devoted totally to your computers. You may want to
start by listing these products on your admin-computer parts page. You also
may want to add a search form that will actually find certain parts, etc.
3. List approximately 2 or 3 fields of each computer parts such as
ProductID, Description.
4. Create a dynamic link for ProductID, i.e. <a
href="edit_productID_form.cfm?productID=#productID#">#productID#</a>
5. For that edit_productID_form.cfm, you would want to create a page that
actually retrieves that certain productID's row of information (productID,
categoryID, description, price and weight) by using text boxes. For each text
value, you'd want to type in something like this: #productid#, #categoryid#.
6. Create a edit_productID_action.cfm by using SQL update and using where
clause that will pinpoint the productID in the database.
I hope this helps.
Rob
=================================================
Good day,
I am creating the site for my computer store, where a user will be able to
custom configure a new PC. Currently I am stuck creating an administration
page where I can update the prices in my database. The table has fields
(ProductID, CategoryID (Hard Drive, Motherboard, etc), Description, Price,
Weight). I want on the admin page for there to be all of the products
listed in form text boxes. If I want to edit one, I can change the content
of that text box and then hit the submit button and it edits the database.
The problem I'm running into is that I can't name the form fields the same
thing because then it won't know which to edit... Can anybody explain how I
would do this? I am very new to coldfusion. Thank you for the help.
Sincerely,
Chris Farrugia
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
