Em Andamento

Looking for programmer in Coldfusion.

Our website is already running, using cfwebstore scripts. (Coldfusion)

we are using dedicated server running coldfusion 5.0, with microsoft SQL database (sql 2000)

We are looking for a freelancer who can help us for long term.

Since our website is already running... Our job is small but many and continue

mostly is for "add on" scripts... and modifications or improvement.

We are planning to build an Intranet website (using coldfusion)

and next month... we need a freelancer who can do this job :

- make scripts... so that our local server can synchronize the data with remote server. (manually or automatically)

our local server is in Japan... and our remote server is in US.

- Not all column need to be synchronized... (for example stock qty, or temporary field NO need to import)

- Local server is using SQL 2005, but remote server is using SQL 2000.

We need a freelancer... who NOT only can do the job.. but also able to explain to me (some sort of teaching me)

because I like to know how things work.

so... this candidate should be able to explain in simple and easy to understand.

To test... wether we feel comfortable working with you....

please bid on this "sample project" for explaining to me how to combine query from 2 different datasource.

We have 2 tables in two databases (two different datasource, in the same server)

database 1 -->table products (contains : Product_ID, price, vendor)

database 2 -->table bookings (contains : Product_ID, quantity)

Now... I need to display a list of all products... from certain vendor (from database 1),

together with sum of quantity (from database 2)

I don't know... how I can join these 2 querries from 2 different datasource.

So.. you can bid on this small job... if we feel comfortable by the way you explaining to me.

we will give you the bigger project.

We are serious about looking for this freelancer... so.. please only serious freelancer only.

Good luck.

because some freelancer asking more details... I attached the explanation of the case..

Please remember... my intention is NOT to get free solutions to this case... but... I want to know how CLEARLY you can explain to me.
And remember...when bidding...keep in mind that the goal is for the bigger project (to make a script synchronizing between remote and local server)

Habilidades: Cold Fusion

Ver mais: website programmer in need, website programmer freelancer, website freelancer in us, website for programmer, vendor freelancer, t sql freelancer, the freelancer programmer, temporary job, synchronize table, sql server price list, sql freelancer remote, sql database programmer, simple programmer website, remote programmer freelancer, remote freelancer job, programmer sql, programmer need a job, programmer looking for work, programmer looking for job, programmer c c++ freelancer, price programmer website, need programmer job, need for programmer, microsoft sql server price, microsoft sql freelancer

Acerca do Empregador:
( 3 comentários ) Yokohama, Japan

ID do Projeto: #126729

Premiar a:

saroj09

Please see my PM.

$70 USD em 2 dias
(0 Avaliações)
0.0

8 freelancers estão ofertando em média $57 para este trabalho

marr

Look at PM.

$40 USD in 2 dias
(81 Comentários)
6.5
cfedge

Please See PM

$50 USD em 1 dia
(1 Comentário)
2.0
Reaver

Look PMB please!

$100 USD em 1 dia
(0 Comentários)
0.0
tprscott

The solution to your problem is fairly straight forward. Using the coldfusion admin section you could create mappings to the two databases. To join the results I would simply run two queries to get both of the result Mais

$65 USD in 2 dias
(0 Comentários)
0.0
ravichandana

I will done in time

$49 USD in 2 dias
(0 Comentários)
0.0
cfengineers

1. Execute the two queries first 2. Create a New Query from scratch cfset myNewQuery = QueryNew("FirstName, LastName, Email, Your fields etc...") 3. Create rows for the query cfset newRow = QueryAddRow(MyNewQuery, Mais

$50 USD em 1 dia
(0 Comentários)
0.0
dhanyatm

I will contact you by email

$30 USD in 3 dias
(0 Comentários)
0.0