mikelopez

select distinct
sum(FilteredOrders.Total * FilteredOrders.Quantity),
FilteredOrders.Date,
FilteredOrders.ItemID,
FilteredOrders.Name,
FilteredOrders.Quantity,
FilteredOrders.Total
from
(select cast(OrderDate as date) as Date,
OrderItems.ItemID,

mikelopez

select distinct 
Orders.Name,
Orders.id as fid,
Orders.Date as filtereddate,

(
	select sum(FilteredOrders.Total * FilteredOrders.Quantity)
	WHERE id = fid
)

mikelopez

select distinct 
Orders.Name,
Orders.id as fid,
Orders.Date as filtereddate,

(
	select sum(Orders.Total * Orders.Quantity)
	WHERE id = fid
)

mikelopez

/* developed by Marcos Lopez 2011
 * www.priceswagger.com
 * dev@scidentify.info
 */

package com.priceswagger.apps.pricecompare;
import android.util.Log;
import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStream;

mikelopez

#include <iostream>
#include <string>
#include <cstdlib>

using namespace std;

int main() {
  int totals;
  double total_array[6];
  int grand_total = 0;

mikelopez

[
    {
        'merchant': u'Buy.com',
        'category': u'Electronics',
        'actual_name': u'CanonPowerShotELPH320HS16.1MegapixelDigitalCamera,
        Red',
        'description': u'CanonPowerShotELPH320HS16.1MegapixelDigitalCamera,
        Red',
        'format_price': u'$379.99',
        'url': u'/p/CanonPowerShotELPH320HS16.1MegapixelDigitalCamera,

mikelopez

import sys,os, logging, re
#sys.path.append('/home/harrysax/sciweb/coolstuffman/')

os.environ['DJANGO_SETTINGS_MODULE'] ='appname.settings'

from django.core.management import setup_environ
from appname import settings
setup_environ(settings)

#

mikelopez

def do_signature(self, secret_key):

    keys = sorted(self.params.keys())
    args = '&'.join('%s=%s' % (key, quote(unicode(self.params[key]).encode('utf-8'),safe='~')) for key in keys)

    msg = 'GET'
    msg += '\necs.amazonaws.com'
    msg += '\n/onca/xml'
    msg += '\n' + args

mikelopez

try:
    from django.template.loaders.filesystem import load_template_source as todel
    del(todel)
    TEMPLATE_LOADERS = (
        'django.template.loaders.filesystem.load_template_source',
        'django.template.loaders.app_directories.load_template_source',
    #     'django.template.loaders.eggs.load_template_source',
    )
except ImportError:
    TEMPLATE_LOADERS = (

mikelopez

function SceneVideoPlayerFull(options){
    this.options = options;
	this.video_random_id = null;

	// These item URL should be modified to contents URL to play.
	this.playList = null;

}

SceneVideoPlayerFull.prototype.initialize = function(){