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.
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)
Bu iş için 8 freelancer ortalamada $57 teklif veriyor
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 Daha Fazla
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, Daha Fazla