close ad
WARNING PC USERS: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Changing Database

Thread began 7/27/2009 10:09 pm by tirzahm338096 | Last modified 7/29/2009 11:01 am by Ray Borduin | 821 views | 1 replies |

tirzahm338096

Changing Database

I would like to change some of the product fields within the database and I'm wondering if its as simple as adding and renaming the fields and then making sure i update and add them within the content pages.
I am looking to customize for a bookstore and would like to add a author field and also change ProductSKU to ProductISBN. I also have 4 different languages of books and would like to create a language category as well. How much will i be upsetting the apple cart so to speak with these changes or are they fairly minor? I am a rookie rookie and wondering if I'm being to bold to attempt this. Any help or heads-up would be appreciated.

Sign in to reply to this post

Ray BorduinWebAssist

It isn't terribly bold. It is what the tools are designed to do. Anyone doing something for the first time might run into a learning curve, but really it should be relatively simple.

Sign in to reply to this post

tim299030

Where are the fields added in the pages?

I am also doing a new site for a book publisher and I need to add fields for Subtitle and Author.

I added both of these to the ps4_products table with no problem but when I added them to the "details.php" file (under <span id="WADAPageTitle"><?php echo str_replace("|","<br />",$row_WADAProducts["ProductName"]); ?></span>) it didn't work.

I'm assuming it didn't work because I didn't add those fields to the recordset or SELECT statement, but I can't figure out where the SELECT statement is that I need to add those two new fields to.

Shouldn't I be able to add those fields to the SELECT statement and then insert the fields in the details.php file?

Sign in to reply to this post

Ray BorduinWebAssist

Yes, that should be all it would take. You should be able to double-click on the Recordset in the server behaviors window to edit the select statement. Did you look in the database and confirm that the fields are getting values?

Sign in to reply to this post

tim299030

Thanks, Ray. It works now. I always forget about the server behaviors panel and try to add it in the code view -- but I didn't see the recordset in the code. The server behavior window did the trick for me.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...