In Progress

Coldfusion Multi Table Query

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

Current Conditions

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.

Skills: Cold Fusion

See more: you and ibm, writing wizard, write fishing articles, type of story writing, type of paragraph writing, steps to write a story, steps on how to write an article, steps in writing a story, steps in writing articles, steps in writing article, re write my paragraph, quote lead, plan to write an article, n query, learn web code, learn to write content writing, learn story writing, learn page, lead generate web site, how we can write content in my website

About the Employer:
( 0 reviews ) Fairfiled, United States

Project ID: #15848

Awarded to:

pccwebcoder

I would be able to knock this out in a day with rapid communication between both of us. What version of CF would you use? I have my Dreamweaver set at CF 7 but could code in CFMX or CF 5 if need be. I would comment More

$150 USD in 1 day
(2 Reviews)
3.5

8 freelancers are bidding on average $246 for this job

ablime

Hi, I can do this for you. PM sent with more details.

$200 USD in 3 days
(9 Reviews)
4.7
nveri

I'm your man. I am a recent graduate, but I have been taking contracts for various companies in order to enhance my expertise. I am focusing on Coldfusion currently, and am employed with creating an MS SQL server-dri More

$250 USD in 4 days
(0 Reviews)
0.0
rapidits

Hi, i have gone through the specification and got a clear idea on how to do your project. I have a vast experience in coldfusion and worked as a lead for a coldfusion team for 6 years. I can do this with best quali More

$300 USD in 5 days
(0 Reviews)
0.0
energycola

pls check PMB

$300 USD in 1 day
(0 Reviews)
2.0
anshumesh

We are Web development,Search Engine Optimisation and BPO company from India . Kindly go through our url [login to view URL] . We are interested in your project. Thanks. Regards, Anshu

$300 USD in 15 days
(0 Reviews)
0.0
BobtheWebGuy

Can provide all tasks including documentation. Macromedia/Allaire certified CF developer since ver 4 and thru Blackstone.

$200 USD in 2 days
(0 Reviews)
0.0
niftysoft

Hi there, Niftysoft Solution is a leading IT services company providing solutions across the globe. A large team of extremely professionals staffs Niftysoft Solution with a strong background in IT field and having More

$265 USD in 20 days
(0 Reviews)
0.0