Description of work:
1. Write a Coldfusion query using multiple tables, change tables if/or as required, re-do my current RSS feed to query all tables.
2. Have the capability to edit information in the tables using a Web form
3. Have the ability to delete an entire record using a Web Form
I am writing an article about changing a static website into a Coldfusion dynamic site. I need to wrap it up and my schedule is just too jammed. I interviewed eBay a few years back and when IBM came in with WebSphere, the guy used the phrase, ”We wanted to learn to fish, not have IBM do the fishing.” So, I will require a brief instruction on how to do it, so that I can repeat the steps in my article. In return, I will include you in the piece.
In regards to #1 above, I have 2 databases currently, Articles and Round1. I need 2 additional tables in my current plan.
I thought that it would be more efficient to break my content into several tables. I have a "lead story position" on my front page and I'd like all content to appear there first. I need to query a headline, 1 photo, lead paragraph, caption, articleID, and type (of story). Several columns are the same, but not all.
Here is a list of the common columns and the additional ones that I need to be able to get the info.
Table 1 - Table2
ArticleID = RoundID
Image1 = Image1
Lead Para = Quote
Type = (can be added)
Head = (can be added)
Caption = FName + LName + Title + Company
Additionally, I would be better served breaking out "Caption" (in Article) to "FName + LName + Title + Company" (in Round1) as a standard. In other words I will need to alter my existing tables.
As far as the forms are concerned, #2 and #3, I can provide you with my insert forms but I would prefer you use Dreamweaver’s wizard to generate the code.
8 freelancers are bidding on average $246 for this job
We are Web development,Search Engine Optimisation and BPO company from India . Kindly go through our url http://www.infiniteoutsourcing.com/ . We are interested in your project. Thanks. Regards, Anshu