Archive

Archive for the ‘Query’ Category

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…

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!

Student Ranking Website

June 14th, 2012 Comments off

Hello all,

I work in education, and I need a tool for ranking our students for their courses and also across various subjects. This is partly research, partly motivational/monitoring tool for students.

The students complete a number of courses over the years; for each course they get points for exams, assignments and so forth. Say that students have Y points in a course, and a rank for that specific course; then, they have Z points in another course, and a ranking for that specific course….

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.

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******

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: , , , , , ,

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.

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.

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…

Gamer Stats Php Sqlite Simple Project

January 19th, 2012 Comments off

Hello Programmers

I have currently have a sqlite database that contains player information (gamers) I also have a simple php page that will displays the database contents in a nice graphical form. Look here to view it http://www.dylanknisley.com/stats

As you can see from the link we have 3 servers thus 3 databases. They includes the following information : playername, level, class, score, kills, deaths, class, time played. times connected. Now please keep in mind each server contains its o…

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…

Javascript Song Database

December 15th, 2011 Comments off

This is a very small Javascript project but is needed urgently.

I need a simple program which will be used to store information about tracks played by a radio station. Every track will be assigned an index, this can be based on the existing Javascript array indexes. Each track will need the following data:

Track name
Track artist
URL

I need for it to be stored in an array of some sort and the program must be able to perform the following operations:

Insertion: of new tracks to the …

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…

Google Query Tool

December 4th, 2011 Comments off

Develop two tools that will allow for the user to input a keyword. Based on the keyword, the two tools will do the following:

1. Competitive tool – Do a google search for the keyword and scrape the top X number results(URL, Title, description, and rank). This data will be available via export at the end. Once the scrape is complete, it will take the URLs that it found and get link data from the Majestic SEO API. For each URL, it will query Majestic seo and pull that URL’s backlink data and ad…

Gamer Stats Php Sqlite Simple Project

December 4th, 2011 Comments off

Hello Programmers

I have currently have a sqlite database that contains player information (gamers) I would like someone to make the following html / php stats page by using the included database.

Look at this example, I would like it to show the following stats http://hlstats.bob.fi/index.php?mode=players& game=cstrike

My database includes the following information, playername, level, class, score, kills, deaths . I would like for the query / stats page to also include a rank based on …

Database Query Xml / Api

December 1st, 2011 Comments off

Looking to match a catalog/database against a XML database. The database is from Discogs.com.

Data:
http://www.discogs.com/data/

API
http://www.discogs.com/help/api

I’m listing my entire catalog in their marketplace. I have several thousand releases from my own website database in xls/csv. They have a bulk upload which requires their unique release ID. Would like to setup a solution so I could do regular queries and create my own upload database to correspond with Discogs.

Htaccess Query String Rewrite Redirect – Need Today

November 15th, 2011 Comments off

DO NOT BID UNLESS YOU CAN DO THIS TODAY, RIGHT NOW.

I need to rewrite a group of strings
Here is what it is

http://www.domain.com/something1& Category_Code=something2.html

to go to (redirect 301)

http://www.domain.com/something1.html

it needs to drop anything after the & ampersand, up to the .html
But this file has many many other things going on in it so you need to really know your stuff.

Query Google Shopping Api Produce Html Table And Csv File

November 10th, 2011 Comments off

Hi All,

I hoping one of you will be able to help me, I’m a bit out of my depth when it comes to javascript and API’s so I need some assistance.
I would like to query google shopping API, producing a webpage containing the result in a table format (say the first 1000 on screen). This webpage needs to offer both:-
1) an option to download ALL results into csv file.
2) sort the results via any of the attributes.
3) search with in the results
I’ll also need any javascript files etc. that are required for it to all work.

Some of the querys I wish to run produce 150,000+ results, hence the need to be able to download all the results to a single csv file.

I already know that if i query google shopping API it limits my results to 1000, so you’ll need to possibly run the query x number of times until you have all the info required. I am aware this may take a while to download, thats OK.

PS I have omitted my specific key to the sample query in the text field

I have included the files I can think that you might need
Example of webpage I want and an simple example of the csv file it will need to produce. I am unable to upload the json result from google shopping API this form will not allow it.

I hope they help any questions please contact me.
Thanks Paul

Phplist Database Query Script

October 31st, 2011 Comments off

I am using the open source script Phplist. I need a small query script (called qscript from now on) to identify email addresses that meet my criteria, within a database used by my installation of phpscript.

The qscript must be written in php and will be hosted on the same server where my PHPLIST is installed. When launched, qscript will

1) ask for my db details (user, password and database name)
2) ask for a starting and ending date
3) ask for a maximum number of mailing lists

The script will then go through the database and extract all the email addresses that were entered between the starting and ending date and that are subscribed to more than the maximum number of mailing lists.

The resulting email addresses will be presented in a download link to a csv file containing all the email addresses that were extracted.

If you are familiar with PHPscript, this should be very easy.

Database Query And Graphing Website

October 23rd, 2011 Comments off

We need to make a website that does the following:

1. On the home page, you make a query, it searches a database
2. Finds all the results matching that ID/query
3. Then on the results page provides a graph of quantity over time for that ID, a text field that states the date of the first entry, along with some of the information from the most recent/newest entry in the database of that item.

No styling required, just functionality. Must use a mySQL database.

Get Stock Prices In Excel For Mac

October 20th, 2011 Comments off

I use Excel for mac 2011.

I currently download share price data/information into my spreadsheet via the standard query “MSN Moneycentral stock quotes”.

However there have been problems with the quality of the data recently.

I would like a query that pulls stock data off Yahoo Finance (my preference) or Google Finance. I need data only for the US & Canada.

The query must download the data into a workbook where I have already entered the stock codes. The stock prices do not need to be real-time. The standard 15 min delay data that is freely provided is sufficient.

See attachment for sample spreadsheet.

Sql Query

October 15th, 2011 Comments off

I just need a query in SQL for the following: Create a heading of REPORTING STATEMENTS as a comment at the bottom of your script file

Categories: Query, SQL Tags: , , ,