Posts Tagged query

Transform SQL Query To An Updating Stored Procedure

I have a SQL query that returns 2 columns whice are IDs from 2 tables on a one to one relationship.
I need this to update two table in a MS SQL database using a stored procedure, looping through each row of the query. The query currently matches 1:1 even if there is a dupe and it is important that it only updates 1 matching entry in each table even if there are dupes.

Please see attached sample query and notes.

Tags: , , , , , , , , , , , , , , , ,

Darwin Streaming Server Mod

I have a server running DSS/QTSS. I need a couple modules to be programmed to do the following:

1. Run a mysql query based on the IP address and the full URL to see if the user has access. The query is already written, and the database and logging in will be handled with a PHP script. The authorization module is partially written, all you need to do is use c++ to connect to the database and execute the query.

2. As it stands, the DSS/QTSS is only set up to have one user provide a stream. I need to have multiple users log in with their own stream. I also need a PHP script that will interrupt the stream so that it has to re authenticate with the script above.

I will need the source code for everything you do at the end of the project.

Tags: , , , , , , , , , , , , , , , ,

1.Query By Humming (QBH) And 2. Web Based Clearance Systems

Dear Colleagues,

My name is Samson ,

I am a student of computer science University undergraduate in
Nigeria,I have two project works to development using html,css,flash,
php and mySql :

The project one is (a) University Graduates Web Based Clearance System
and project (b) is Music retrieval Using query by Humming [QBH].

I am programmer too, but my hands are full with
alot of academics activities because am about to finish my degree.
Kindly let me know whether you have handled such projects before and
send me your quotation.But I will require a demo for the two project work.

This type of work is based on trust,speed and web research.

Kindly let me hear from you ASAP. I will send the flow chart for the
two projects work if your quotations are friendly.

Yours,

Samson.

Tags: , , , , , ,

Modify Google Base Feed (SQL Query) In Volusion

We are currently exporting our Google Base product data manually in Volusion. I would like to create a Saved Export with all the required columns and fields as required by Google.
Volusions Google Product Query only pulls the basic product info, i want to add all our already formatted columns to this query plus strip out all the uneccesary info from this query for $60

I would prefer a provider with some Volusion backend experience.

Tags: , , , , , ,

MySQL Database & Query Optimisation – Reposted

We have an OScommerce based store with a very large number of products (4 million plus) that requires some database and query optimisation.

Some work has been done but the project now requires someone with a skill set that is able to analyse the queries, indexes and tables to optimise as necessary.

This project has been reposted as it could not be completed due to illness

Tags: , , , , , ,

ColdFusion + ICal Needed

I need a UDF or cfc that works something like this http://cflib.org/udf/iCalUS HOWEVER I need this to be a full feed whereas the calendar will contain any number of events. So the page would query the events, then using cfcontent, call the cfc and output all the events that were returned by the originating query.

Not sure how to best word it for you – I need my outlook or google calendar etc. to use the page as its live calendar feed.

So when I enter in the feed address it would read something like this – http://www.mystite.com/calendar.cfm

I really dont know any better way to explain it to you so please ask questions before posting your desire to do this.

Tags: , , , , , ,

Facebook Calendar App And Web Page

Please bid for developing an app which shows a calendar in FB and on a webpage

1. the user registers.
2. user selects membership level: trial or paid membership (payal, CC, etc).
3. user enters query details.
4. the app shows query results on a calendar.
5. the app sends summarised info to the users email and their sms using clickatell.

The calendar will operate in a current joomla website, and on facebook.
Usual facebook app functionality (user info, invite friends, etc) is required.
Functionality includes subscription pricing, user profile, front end calendar and admin screens.
Based on previous projects and GAF comparisons, the project has been estimated at us$400-450.
Fee can increase based on your (1) quality, (2) ideas or corrections, and (3) time to deliver.
We do a number of sites per year, please show your work quality and previous FB apps.
Good communication is required daily, usually 5 minutes but can be an hour, in English.
We want to see the work as it is being done, and have development phases. This keeps the development on track and keeps a good working relationship.
A Requirements Specification, including the query code will be sent to the winning bidder.

Tags: , , , , , ,

Mysql Query To MongoDB

I need to rewrite php/mysql scripts to php/mongoDB (from mysql queries to mongoDB)

I will send php/mysql script files on request!

Tags: , , ,

J Query Expert Needed

Looking for J Query expert to fix 2 complex forms for validation.
Also looking on board for other projects in future.

NO FEEDBACK DO NOT BID

Tags: , , ,

VTiger WebService Module For Creating Sales Orders

Need to expand the functionality of vTigers WebService by adding a new PHP module that via REST, can create a new Sales Order, including item Details.

Item Details can be a product and/or a service. Multiple item details per Sales Orders is required.
Project also requires the following vTiger functions:

1.- Query if a specific Sales Order already exists.
2.- Query if a Specific Product already exits.
3.- Insert a new product
4.- Query if a Specific Service already exists
5.- Insert a new service

The PHP module should be an extension of the current WebService functionality. The new functions should be supported by entering a new entityType value parameter in the URL

Tags: , , , , , ,

MySQL Database & Query Optimisation

We have an OScommerce based store with a very large number of products (4 million plus) that requires some database and query optimisation.

Some work has been done but the project now requires someone with a skill set that is able to analyse the queries, indexes and tables to optimise as necessary.

Tags: , , , , , ,

Rewriting The Equivalent Query Using Materialized Views

You need to write a pgm in JAVA which rewrites the equivalent query using materialized views in SQL… Its a Simple pgm.. It need not work on any schema or Database.. But it needs the knowledge of the concept i.e you should know how to do it manually to write the pgm.. So send me an example for each cases,
~where a view can be used for rewriting ( with rewritten query if it can be used ) and
~where it cant be used ( with reason why it cant be used ) on PMB to prove that you know this concept.. Plz be specific.. Just give me those two examples and ur bid amount that is more than enough !!

Tags: , , , , , ,

MYSQL OPTIMIZATION

PLEASE DO NOT BID IF YOU DONT HAVE ANY FEEDBACK REVIEW.

Description
Project:
I have search engine script that bring result from bing and yahoo. Only keyword suggestion is in mysql when people type a word it will update keyword suggestion db if keyword have query sometimes is update sometimes is query condition mysql (currently 10k user 25k pages)
i don

Tags: , , , , , ,

MYSQL Query Optimization Professional

Requirement:

Don

Tags: , , , , , ,

Writing Postgresql Query

I like to have the following query:

I have two tables (datatype text):

objectid1 with content like CHB01010, CHB01506, CHB01517

objectid2 with content like CHB01010/F, CHB01506/DYYYO, CHB01517/ZYYYO

I like to compare both tables so where object_id1 = object_id2

Can you build this query for me?

03/06/2011 at 14:06 EST:

Im looking for a postgresql specialist, who can help us also with later work.

Tags: , , , , , ,

COS UK Voice Over Query – Male And Female – Lithuanian

Hello,

We are writing from Cosmic Global Limited, a translation and localization company located in India

We have a potential query for Lithuanian Voice over Male and Female.

There are 12 modules averaging 10 screens.

Each modules is approximately 32 pages. Sample file will be sent to you upon your confirmation.

Studio recording is a MUST

If you are interested to undertake this job, kindly send us the below details required.

Kindly send us your voice sample.

Please let us know your rate/finished hour (Audio play time) including studio cost.

Please let us know the number of finished hours(Audio play time) required to complete one module.

Awaiting your response ASAP

Regards,

Vasavi
Resource Dept
Cosmic Global Limited

Note: Please do not outsource the job without our knowledge.

Tags: , , , , , ,

COS UK Voice Over Query – Male And Female – Latvian

Hello,

We are writing from Cosmic Global Limited, a translation and localization company located in India

We have a potential query for Latvian Voice over Male and Female.

There are 12 modules averaging 10 screens.

Each modules is approximately 32 pages. Sample file will be sent to you upon your confirmation.

Studio recording is a MUST

If you are interested to undertake this job, kindly send us the below details required.

Kindly send us your voice sample.

Please let us know your rate/finished hour (Audio play time) including studio cost.

Please let us know the number of finished hours(Audio play time) required to complete one module.

Awaiting your response ASAP

Regards,

Vasavi
Resource Dept
Cosmic Global Limited

Note: Please do not outsource the job without our knowledge.

Tags: , , , , , ,

Asp Recode Query And Page On Web

Changes needed to our asp code for our website/platform

Changes include:
Changing location of secured login to before displaying search results
Add new field (s) for query and query return
Change format of query return text
add checkbox for select all or none to the export of query
feedback button add
add forward and back navigation to the query return for multiple records
Change the export to display the same as the on screen results
add option for more results displayed (ie: 25 by default with the option for 50 or 75, or 100)
Include additional fields on the initial query return list
Alternate shaded lines on the query return list (aesthetic)

More detail on these upon acceptance of the bid/job. All fields required exist in the database, and the field matches will be given at the time of awarding.

Tags: , , , , , ,

PHP W/ Possibly AJAX Mysql Driven Query Listings

PHP + AJAX mysql driven query page.

Database has 14 fields. You will modify existing script to fetch queries, and display them 10 on each page.
On top there will be Sort option by fields.
On clicking an entry, a new page will open that will have all full details of that entry 14 fields.

2 scripts – one for main search result, 2nd for the item listing. htaccess or php to rename the item listing to a .html

if you have template great. else we will provide rough template to place. Looking for a good looking final working script.

budget is 30 usd. only bid if agree with it.

Tags: , , , , , ,

Java And Php Page To Get Remote Mac Address

I need to add java script to the attached php script to be able to obtain someones router mac address when they come to my webpage.

<?php
$data = ;
$sendmail = true;

$keyword = ;
$destination = ;
$temp = file_get_contents(data/destinations.txt);
$dests = explode("n",$temp);
foreach ($dests as $dest)
{
$parts = explode(|, $dest);
if (count($parts) == 2)
{
//echo Checking .$parts[0]….;
$pos = strpos($_SERVER[REQUEST_URI], $parts[0]);
if ($pos === false)
{
//echo Nope <br />;
}else{
//echo Yep <br />;
$keyword = $parts[0];
$destination = $parts[1];
}
}
}

$emkeyword = ;
$em = ;
$temp = file_get_contents(data/people.txt);
$peeps = explode("n",$temp);
foreach ($peeps as $peep)
{
$parts = explode(|, $peep);
if (count($parts) == 2)
{
//echo Checking .$parts[0]….;
$pos = strpos($_SERVER[REQUEST_URI], $parts[0]);
if ($pos === false)
{
//echo Nope <br />;
}else{
//echo Yep <br />;
$emkeyword = $parts[0];
$em = $parts[1];
}
}
}

if ($sendmail)
{
$data .= "UTC Time:n".gmdate("F j, Y, g:i a",time())."nn";
if (strlen($destination) > 0)
{
$data .= "Keyword Detected:n".$keyword."n";
$data .= "Redirected To:n".$destination."nn";
}
if (strlen($em) > 0)
{
$data .= "Email Identifying Keyword Detected:n".$emkeyword."n";
$data .= "Response is from email sent to:n".$em."nn";
}

$goodvars = UNIQUE_ID HTTP_USER_AGENT HTTP_ACCEPT HTTP_ACCEPT_LANGUAGE HTTP_ACCEPT_ENCODING HTTP_ACCEPT_CHARSET REMOTE_ADDR REMOTE_PORT SERVER_PROTOCOL REQUEST_METHOD QUERY_STRING REQUEST_URI PATH_INFO PHP_SELF HTTP_REFERER;
foreach($_SERVER as $name=>$value)
{
$pos = strpos($goodvars, $name);
if ($pos === false)
{
//echo Nope <br />;
}else{
$data .= $name.":n".$value."nn";
}
}
mail(youremailaddressgoeshere,Tripwire Alert,$data);
}
//echo $_SERVER[QUERY_STRING]."<br/>n";
//if query has fake folder info, discard all fake folders from google search redirect
$query = ;
$elements = explode("/",$_SERVER[REQUEST_URI]);
$elementcount = sizeof($elements);
if ($elementcount > 1)
{
$query = $elements[$elementcount-1];
}

if (strlen($_SERVER[QUERY_STRING]) > 0)
{
$query = $_SERVER[QUERY_STRING];
}

if (strlen($destination) > 0)
{
header(Location: .$destination);
}else{
header(Location: http://3mdusd-stooges.blogspot.com/search?en&q=.$query);
}
exit();
?>

Tags: , , , , , ,

Joomla 1.5.22 – SQL Query For Dropdown, And Table

I need to be able to display International Calling Rates based on users selection of a dropdown Box. Both the dropdown box and the table need mysql queries written to populate each respectively.

An example of the functionality I am looking for can be found here under "rate finder by country": http://www.phonepower.com/services/voip/international.aspx

I am using the Joomla Extension Art Data to display my table. Example here: (http://data.artetics.com/index.php?option=com_content&view=article&id=5&Itemid=6)

I need an SQL query written to populate the dropdown with unique countries. Then I need a query written to correctly populate and format the table using the Art Data Table extension. This table will display the results up to 50 records and the remaining records will be with accessed through pagination appearing horizontally across the bottom of the table.

This is time critical as we have customers coming to the site now. Please do not bid if you cannot complete project within 1-2 days.

Tags: , , , , , ,

PHP Code Debug

I have setup a staging directory with a copy of the code that I am running.

When a user hits the site there is a csv keyword that is in the url, example (http://mortgagerates.youarepreapproved.com/staging/ppcindex.php?csvkeyword=sun-city-mortgage-rates)
this keyword is passed to the ppcindex.php page which querys a mysql table against that csvkeyword.
Once the query is compleated the ppcindex.php page reads the content template page that is specified on line 6 of ppcindex.php and will replace all the varible values in that page with the data it pulled from the mysql table.

My problem is this. if you look at the content page (/var/www/staging/ppcindexcontent.php) i have a colum of junk in the right hand side, I wrote a MSSQL query (/var/www/staging/names.php) that issues a query against a stored precedure that I want to display in that right hand colum. When I drop this code into the content template page (phpcontentindex.php) that is read by the ppcindex.php page it breaks everything.
I have a feeling it is related to the loop in teh MSSQL query and the loop that runs on the ppcindex.php page.

Tags: , , , , , ,

Getting Joomla Userid Into Non-Joomla Php File

I had someone create a component for me on Joomla 1.0. we used Jumi to create an "html" file with this in the top:

<? php
global $my;
if ($my->id) {
echo "<script type=text/javascript>juserid=".$my->id."</script>";
} else { }
?>

This created a parameter that was readable by my php file: Then inside a non-Joomla php file (where we ran a query using the userid to create an XML file), we added this:

global $my;
$userid = $_POST[userid];

In the query we used this:
where g.id=" . $userid.

This isnt working though when I tried to recreate this in J1.6. Whats the new syntax for retrieving the userid and posting it so I can grab it from the other php file and use it in a query? I do not think the $POST method is secure either.

Basically what I need is a way for a php file (that is not part of the Joomla environment but on same server) to be able to retrieve the users Joomla ID so I can use it in a query. This php file is called via a javascript file that Im referencing inside a Jumi component.

Tags: , , , , , ,

Need A Complex MySQL Query Written

This is not a huge job but we are looking for a MySQL Expert to write a 2 complex mysql queries. Entails a query across 5-6 tables which the results will provide our community with personal stats. We will provide sample data and willing to chat via Skype. Payment can be made via paypal.

Tags: , , , , ,

Website Design And Homepage Query

I need 2 things

1st – I am developing a few blogs and I need a query coded that pulls recent pictures and posts and places them in a box on my homepage like at the top of yahoo.com. www.yahoo.com (also see screenshot).

2nd – I will be using a few different scripts and I will need some design done. Most of the design is simple color/backround/font changes.

The most intensive work I will need done is the classifieds section and I need a homepage created. I have a template I want modified into my homepage already so I will be able to give you the files and the changes I need.

I also have a template I want modified or duplicated for the classified section. I will also provide the template code/Css and how I want it set up.

Once the design is done I will just need some links to my homepage added to all the sections, some adserver code inserted and that is it.

All in all this is a fairly simple project and I dont have the time to do it myself. Budget will be minimal since the work is fairly simple.

Tags: , , , , , ,

Form Query Script And Render Xml Return On Joomla Website

To develop a script for use on a Joomla website that will submit a search request to an external server via a form, joining the URL of the destination server with the form query (part number) submitted in the form to search for a part number. The host server

Tags: , , , , , , , , , , , , , , , ,

MS SQL Issue : Multiple Temp Tables In Query

I am getting a message telling me of an error in my query. Id like to do a screen share or send a copy of the query and message to the issue cleared up.

I have multiple declared tables and a query on those tables and some DB tables and views.

error is :
Must declare the scalar variable

MS SQL 2005

Tags: , , , , , , , , , , , , , , , ,

Php And Mysql Coder

I have a mysql query problem in my website, Im using article friendly script, this maybe caused from some php coding, the php needs to be optimized, my hosting providers has suspended my account due to this query problem, I need someone to fix it, its a very easy job for someone expert.
you need to fix it and send me a report of what had been fixed in order to activate my account
Ill pay $20 for this issue
thank you

Tags: , , , , , , , , , , , , , , , ,

Php And Mysql Coder

I have a mysql query problem in my website, Im using article friendly script, this maybe caused from some php coding, the php needs to be optimized, my hosting providers has suspended my account due to this query problem, I need someone to fix it, its a very easy job for someone expert.
you need to fix it and send me a report of what had been fixed in order to activate my account
Ill pay $20 for this issue
thank you

Tags: , , , , , , , , , , , , , , , ,

Oscommerce Category Too Slow(need To Fix)

07:23:20 write(3, &quot;20713select count(p.products_id) as total from ((products_description pd, products p )left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c )left join specials s on p.products_id = s.products_id where p.products_&quot;…, 395) = 395
07:23:20 read(3, &quot;1113323def5totalf?251020153376&quot;440311655376&quot;&quot;, 16384) = 62
07:23:20 poll([{fd=3, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout)
07:23:20 write(3, &quot;24023select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.p&quot;…, 676) = 676

Unfortunately, this query is taking several seconds to complete, causing the slowdown.need someone to reconfiguring the script to utilize less resources, perhaps by limiting the total number of products returned with the query, or implementing some form of query caching.

Only accept applicant with over 50 reviews. Low bid please.

Tags: , , , , , , , , , , , , , , , ,

Mysql Fix Problem

I have a mysql query problem in my website, my hosting providers has suspended my account due to this query problem, I need someone to fix it, its a very easy job for someone expert.
you need to fix it and send me a report of what had been fixed in order to activate my account
Ill pay $20 for this issue
thank you

Tags: , , , , , , , , , , , , , ,