Archive

Posts Tagged ‘Query’

Ms Access – Rank Subset Of Data In Query

July 10th, 2012 Comments off

I have a dataset, which is attached.

I would like to rank the prices by a Date (subset). My current approach is close, but the rank isn’t always consistent. here are the changes needed…

1. Rank 1 is the highest price
Rank 2 is the second highest price
etc…

2. If the Price is blank in the subset, then I want that rank to be the highest

3. In a separate field, i want to identify by an “X” if two records in a subset is tied. i.e.

Example:

Checkin Hotel Price R…

Url To Control Iframe On Submit Of Form Asp.net Code

July 8th, 2012 Comments off

My website has an iframe that is controlled with a query string. However I have a problem.

My website texasrealtypros.com does not change url when submitted just the iframe url changes.

What I need is a script that

1. on submit of form parameters are added to a query string of domain url (texasrealtypros.com)
2. refresh page
3. iframe looks for parameters
4. if iframe finds parameters it uses them to build iframe query string.

the goal is to allow users to be able to share …

Categories: Form, iframe, URL Tags: , , , , , ,

Url To Control Iframe On Submit Of Form

July 6th, 2012 Comments off

My website has an iframe that is controlled with a query string. However I have a problem.

My website texasrealtypros.com does not change url when submitted just the iframe url changes.

What I need is a script that

1. on submit of form parameters are added to a query string of domain url (texasrealtypros.com)
2. refresh page
3. iframe looks for parameters
4. if iframe finds parameters it uses them to build iframe query string.

the goal is to allow users to be able to share …

Categories: Form, iframe, URL Tags: , , , , , ,

Soap Client Query Test Page

June 28th, 2012 Comments off

I have a local LAMP server – I need to be able to select an XML page from a dropdown, and enter an XML SOAP query.

Then on submit have the SOAP query run, produce the result, the query, the date/time and the time elapsed to receive the response. Nothing more, nothing less. No css formatting, etc. Just a basic script.

Categories: Query, Testing, XML Tags: , , , , , ,

Build Custom Search Query For WordPress Search

June 22nd, 2012 Comments off

Hi,

I need to have WordPress search be able to search a custom field (sku).

You could build a query to search skus: http://codex.wordpress.org/Template_Tags/get_posts#Custom_Field_Parameters

I’m open to have a separate field for this sku search or integrate it within search.

Let me know if you can do this in a smooth and seamless way.

Thanks!

Volusion Custom Sql Query

May 28th, 2012 Comments off

I need to export a report in order to calculate VAT for our returns. This involves a breakdown of each order on volusion showing the product details and the country where the customer made the purchase.

We need to export a report as csv with the following item in each row:

Order ID, Order Date, Ship Date, Payment type, Payment Received Customer Name, Customer Country, Ship Country, Product ID, Product Price

The slight complication is that if a customer orders multiple items in one or…

Make A Form To Manipulate This Query 2

May 21st, 2012 Comments off

You can use the example from this site houstonproperties.com

Im concerned with only fields = listing price min & max, leasing price min and max, bedrooms, bathrooms, square feet max and min, subdivision, zipcode, yearbuilt, and sort by.

http://search.har.com/idx/doSearch.cfm?cid=549644& sitetype=AWS& allmls=Y& stype=0& location=&
for_sale=1&
listing_price_min=&
listing_price_max=&
lease_price_min=&
lease_price_max=&
bedroom_num=&
full_bath_num=&
garage_num=&
garage_desc=&
stories=&

Categories: Form, Query Tags: , , , , , ,

WordPress Homepage With Animation (poss. Query)

May 8th, 2012 Comments off

Need someone to take a layered photoshop file and turn it into an animated menu for the home page of a wordpress site. Then edit it into the wordpress template’s homepage. The drum pads (seen in the attached image) need to flash multiple times when rolled over, then be the home page menu to the rest of the site.

Creating Query And Report In Access 2007

May 3rd, 2012 Comments off

Hello,
am attaching sample database.
open it and you will find a tbl1.
I am working with [Type],[Qty], and [Ship Date].

If you look at query [ qryAllTypeCount2]- this is my attempt at finding solution.

**********
I want to group by type names and have total qty’s – per month [Ship Date] for each type.
**********
If you look at my rpt1 – I am not able to group – because the date field is no longer a date field.
I also need the list name to be in ascending order.

I have attached a …

Make A Form To Manipulate This Query

April 29th, 2012 Comments off

Im concerned with only fields = listing price min & max, leasing price min and max, bedrooms, bathrooms, square feet max and min, subdivision, zipcode, yearbuilt, and sort by.

http://search.har.com/idx/doSearch.cfm?cid=549644& sitetype=AWS& allmls=Y& stype=0& location=&
for_sale=1&
listing_price_min=&
listing_price_max=&
lease_price_min=&
lease_price_max=&
bedroom_num=&
full_bath_num=&
garage_num=&
garage_desc=&
stories=&
squre_feet_min=&
squre_feet_max=&
subdivision=&
subdivision2=…

Categories: Form, Query Tags: , , , , , ,

Dvd Website – Sql Query Problem – Add-amend-delete

April 23rd, 2012 Comments off

SQL Query Problem – Add, Amend, Delete.

On the Administration page of my website, an Administrator should be able to add, edit, delete entries in the Products and categories, which is a database built in MS Access. They should be able to alter entries in the tables.

I think the Insert, Update, Delete statements need to be tweaked.

Determine Ajax Query To Scrape A Website

April 21st, 2012 Comments off

I need to scrape some data from completed auctions at quibids.com. That data presented on the page I need to scrape, is presented to you in the browser using AJAX. That means that what I need scraped can’t be seen in the HTML source code. I need to replicate the AJAX query that presents the data I need scraped. I have already found the AJAX query to do this, but I can’t figure out how to replicate the required “tokens” in the URL which are calculated using JavaScript.

Here is the URL of a com…

Need Help With Drupal – Database Query

April 21st, 2012 Comments off

HI folks,
I need drupal expert who can help me add some php code to my drupal website that will query a database. I have an informational website that will allow folks to look up their products and return some fields. I know how to do this in straight php, but not wihin drupal.

I have drupal 7.12

I am hoping drupal has some easy way to integrate this. I want to you to step me through doing this.

Would be nice to use jquery/ajax perhaps to return the results?

Thanks

Need Query Slider For Joomgallery Corrected To Work On Ipad

April 14th, 2012 Comments off

Http://indiezyneinc.com/keitric/index.php

Need Query slider for Joomgallery corrected to work on Ipad

Must have your own ipad to test to ensure functionality.

JQUERY EXPERTS ONLY******

Screen Scrape Website And Save/update Info In Database

April 5th, 2012 Comments off

I have a website I’m looking to scrape into a SQL database, connecting through ODBC.

I will provide all of the SQL Queries for you, but the program will do the following
1) Run query A before the program runs
2) Then go through the categories from the website, pull a number from the site, and run Query B using the number found, then run Query C using the number found. (2 different queries, making changes in 2 different tables)

Total items to be scraped is a number, (similar to xxx-x-xxx…

Ms Sql Query From Access Db Table

March 29th, 2012 Comments off

I need an MS SQL database query developed for the table attached.

I need a query that will…
Return all columns from the tbl_Recert_Cycle table which are distinct Cert_CustID the the largest Sequence value.

Please see attached tbl_Recert_Cycle.mdb, tbl_Recert_Cycle.jpg and tbl_Recert_Cycle.rtf

Categories: Access, MS SQL, Query, SQL Tags: , , , , , ,

Sql Queries

March 28th, 2012 Comments off

Need this in a couple hours! Please help!

STEP 1:

Using the BOOKS table, write a query that will list the categories for the books in inventory. List each category only once in your result set.

STEP 2:

Using the BOOKS table, write a query that will list the title and publisher ID for each book in the table. Use the column heading of “Publisher ID” for the pubid field.

STEP 3:

Using the BOOKS table, write a query that will list the book title, retail price, and the…

Categories: SQL, Writing Tags: , , , , , ,

Sql Week 4

March 24th, 2012 Comments off

Using the BOOKS table, write a query that will list the categories for the books in inventory. List each category only once in your result set.

STEP 2:

Using the BOOKS table, write a query that will list the title and publisher ID for each book in the table. Use the column heading of “Publisher ID” for the pubid field.

STEP 3:

Using the BOOKS table, write a query that will list the book title, retail price, and the amount of markup for each book. The amount of markup is the…

Categories: SQL, Writing Tags: , , , , , ,

Need Mysql Query Assistance

March 21st, 2012 Comments off

I need help writing some optimized queries that pull data from three different tables … I want to get data from multiple rows into specific columns and I’d like to do it in a single query if possible.

I can explain more in PMB … looking for a master MySQL query-maker!

Should be about 1-2 hrs work max.

Mysql Help

March 11th, 2012 Comments off

I have a CSV file that I need to load into a MySQL table on a scheduled cron (in a .php or .sh file, I think). I need to remove all quotation marks in the table and am having trouble doing so.

I’ve tried the following:

$query = “UPDATE tbl1 SET variable_1 = REPLACE(variable_1,'”‘,”)”;
$result = mysql_query($query);

But I get a parse error: “syntax error, unexpected T_CONSTANT_ENCAPSED_STRING”

I’ve also tried removing the quotes when I load the file:

use $DBNAME;truncate table…

Categories: Cron, MySQL, PHP Tags: , , , , , ,

How To Avoid Or Bypass Googles 32 Word Search Query Limit

March 11th, 2012 Comments off

Hi,

I am offering “Terms & Condition” sample texts, handwritten by me, to registered members but those texts are also stolen and copied by other people.

I’m using Google to find those illegal users by searching for:

“Sample phrase from my terms& conditions” -membername1 -membername2 -membername3 …

I have over 100 registered members and if I exclude only 28 of them from the search I will only have 4 words left for my specific phrase.

Question 1: Is there any way to avoid / bypass …

Mysql Slow Queries

March 10th, 2012 Comments off

I need my mysql db sloq quires fixed and optimized..
this is a sample from my server company:
the entire log in /var/log/mysqld.slow_queries.log. here is an excerpt of the log file:

# Time: 120309 14:46:33
# UseratHost: yyy[yyy] at [xx.xx.xxx.xxx]
# Query_time: 22 Lock_time: 0 Rows_sent: 1 Rows_examined: 137440
SELECT COUNT(*) AS total FROM d_wholeinf WHERE suspend_admin!=’y’ AND wh_id IN (SELECT who FROM d_favorites WHERE pid=5940 AND authorize=0);

# Time: 120309 14:46:34
# UseratHo…

Categories: Database, MySQL, Query, SQL Tags: , , , , , ,

Mysql Query Needed

March 10th, 2012 Comments off

I need a MySQL query that will pull out the data from a table based on the current date so if today is 10th of March, results equal or later than this will be showed first ascendantly. If current month would be December, then results within December will be showed first, followed by January, February, March, etc …

I am expecting this to be very simple and fast for someone proficient with MySQL. Please bid accordingly and let me know if there are any further questions.

Thanks.

Quick Fix

March 8th, 2012 Comments off

Need help making my PHP / MY SQL out put as US currency.
actual script is below.

$query = “SELECT entity_id, SUM(grand_total) FROM sales_flat_order”;

$result = mysql_query($query) or die(mysql_error());

// Print out result

while($row = mysql_fetch_array($result)){

echo ‘‘.$row[‘SUM(grand_total)’].’‘;

Categories: Fix, MySQL, PHP, Quick, SQL Tags: , , , , , ,

How To Avoid Or Bypass Googles 32 Word Search Query Limit

March 6th, 2012 Comments off

Hi,

I am offering “Terms & Condition” sample texts, handwritten by me, to registered members but those texts are also stolen and copied by other people.

I’m using Google to find those illegal users by searching for:

“Sample phrase from my terms& conditions” -membername1- -membername2 -membername3 …

I have over 100 registered members and if I exclude only 28 of them from the search I will only have 4 words left for my specific phrase.

Question 1: Is there any way to avoid / bypass…

Php Form – Api Call – Output + User Query Limit

February 21st, 2012 Comments off

I’m the member of a site that offers an API to generate articles! I know my way around html and css but php is way over my head. In comes you!

The documentation is really clear but I have no way to script/turn it into something useful. He lists all the variables and even a sample script on his site so I’m sure you can make this work. What I’d like in functionality from the script are the following things:

– Every variable has it’s own input field based on the type of input required (on a w…

Php / Mysql Query 2

February 11th, 2012 Comments off

Hi
MySQL query problem.
Please contact about details.
Budget = 10, I will compensate in the next project

Php / Mysql Query

February 10th, 2012 Comments off

Hi
MySQL query problem.
Please contact about details.
Please note my budget is set to 10 sadly, thanks.

Aws – Secure Rest Query Tool

February 3rd, 2012 Comments off

I need a desktop tool that will take as input my:

AWS Access Key ID
AWS Secret Access Key

…generate a signed query for the GetReviewableHITs operation like the one shown here:

Sample Request

The following example retrieves 100 of the Requester’s reviewable HITs, using the default value for the SortOrder parameter (Ascending).

http://mechanicalturk.amazonaws.com/?Service=AWSMechanicalTurkRequester
& AWSAccessKeyId=[the Requester’s Access Key ID]
& Version=2008-08-02
& Operation=…

Categories: Amazon, API, GUI, Java, XML Tags: , , , , , ,

Database Query For Fun Website Development

January 29th, 2012 Comments off

Need a programmer to create a website that does the following:

Search Query

January 23rd, 2012 Comments off

If you go to:
http://www.modelzone.nl/search/
And choose profiletype (profiieltype) : Model
Then click zoeken (Search)
THE first page Will list models (results: 36)
If you go to page 2 it Will list on page 2 all profile types (results: 76) instead of only models.
I need someone to correct this.

Requirements:
– very good php knowledge
– comment in file what you did
– payment after work done

Simple Gamer Stats Php Query Script

January 22nd, 2012 Comments off

Hello Programmers

I need to setup a php script that run every so many minutes and will do the following

1. connect to a game server via tcp/ip and login via rcon system
2. the script will need to issue the command bf2cc pl
3. the script will then parse each line as a player and store his status in a database (kills, deaths, score, team, etc..)
4. will then use a serverstatus.php to read the server status databause and show

Please view the attached files for more information and wha…

Semrush Api Api Project

January 9th, 2012 Comments off

I need a php script that will allow me to perform bulk query of 1000’s of domain names on the semrush api.

The search should return a table display for all the results with a csv download option.

for each result i would like the following api params:

Organic Keywords report – Ph, Po, Nq, Cp, Ur, Tr, Tc, Co, Nr, Td
Ph – The search query which the site has within the first 20 Google search results
Po – The position of the site for the search query in Google, at the moment of…

Php Sql Query Search Box Security Problem

January 7th, 2012 Comments off

A nice and simple job.. I have just purchased this small script from CodeCanyon..

http://codecanyon.net/item/store-locator/full_screen_preview/409395

When a string is entered like: admin’– ‘ or 1=1–

It brings up database details… Etc

So I need a quick fix.. I have the files to hand..

Sensible Requests Only..

Categories: MySQL, PHP, SQL Tags: , , , , , ,

Ms Access 2003 Query Change

December 30th, 2011 Comments off

Need some work done to troubleshoot a report/query written with Access and using Access DB. Created using 2003 and needs to stay 2003.

This is an existing report generator using drop down and radio button selection along with a date range. It seems the query may not be accurate. I need someone to review the query against what it should do and determine if there is any issue and then edit if necessary.

Thanks

Mysql Query Optimization 2

December 27th, 2011 Comments off

I have a fairly complex mysql query which needs to be optimized.
Please bid on this project if you are a mysql optimization expert.

I’ll need you to advise on which indexes should be created for this specific query.
Also I’ll need advise if and how we need to rewrite the query.

I can send you the query over private message before you bid.

Only mysql optimization experts please.

Mysql Query Optimization

December 27th, 2011 Comments off

I have a fairly complex mysql query which needs to be optimized.
Please bid on this project if you are a mysql optimization expert.

I’ll need you to advise on which indexes should be created for this specific query.
Also I’ll need advise if and how we need to rewrite the query.

I can send you the query over private message before you bid.

Only mysql optimization experts please.

Need Help With Building Sql Server Query

December 20th, 2011 Comments off

Hello, I need some help with a SQL Server Query in Microsoft SQL Server 2008.

I have two tables, one with device information, and the other with device history. The device history is keyed to the device information id column.

In the devicehistory table I have 4 columns: id, compid, startalarmdate, endalarmdate. I have a script in my application that adds an entry when one of my devices goes into alarm, it puts in the id of the device into the compid column. It also writes the current date…

Ms Access 2003 Report And Query Work

December 14th, 2011 Comments off

Need some work done to troubleshoot a report/query written with Access and using Access DB. Created using 2003 and needs to stay 2003.

This is an existing report generator using drop down and radio button selection along with a date range. It seems the query may not be accurate. I need someone to review the query against what it should do and determine if there is any issue and then edit if necessary.

Thanks

Urgen.. Reports Using The Wizard Based On An Sql Query

December 4th, 2011 Comments off

PLEASE, Only serious people respond. I will pay you through the scriptlance account ONLY. If that is not good for you, please do not bid on this project!!! Also, I will pay you your BID price. Do not bid a price, do the work, and then haggle or hassle me for a larger fee. The project is listed IN FULL, so please bid for an acceptable amout for you. This project needs to be done in 20 hours.

Below is the project. Please use the attached database as your data. The deliverable is an Acce…