Search Results

Search found 7240 results on 290 pages for 'natural join'.

Page 154/290 | < Previous Page | 150 151 152 153 154 155 156 157 158 159 160 161  | Next Page >

• Sales by Category in Magento?

  - by Tegan Snyder

  We have a category called "Clearance" on our Magento website. Ideally it would be nice to be able to get a report of all orders sold in that category. Is there anyway I can join the orders collection with the products collection and filter by category id? Here is a similar thread: http://www.magentocommerce.com/boards/viewthread/44296/ Any…

  Read the article

• how to translate this hpricot code to nokogiri ?

  - by wefwgeweg

  Hpricot(html).inner_text.gsub("\r"," ").gsub("\n"," ").split(" ").join(" ") hpricot = Hpricot(html) hpricot.search("script").remove hpricot.search("link").remove hpricot.search("meta").remove hpricot.search("style").remove found it on http://www.savedmyday.com/2008/04/25/how-to-extract-text-from-html-using-rubyhpricot/

  Read the article

• SQL Select - adding field to Select is changing the results

  - by nycdan

  I'm stumped by this SQL problem that I suspect will be easy pickings for someone out there. I have a table that contains rows representing several daily lists of ranked items. The relevent fields are as follows: ID, ListID, ItemID, ItemName, ItemRank, Date. I have a query that returns the items that were on a list yesterday but not today…

  Read the article

• How to convert an 8-bit integer into a binary string in xquery?

  - by philcolbourn

  At work today, we threw together this attempt: xquery version "1.0"; declare option saxon:output "omit-xml-declaration=yes"; declare variable $x := 99; string-join( for $b in (128,64,32,16,8,4,2,1) let $xm := $x mod ($b*2) return if ( $xm >= $b ) then "1" else "0" , "") Do you have a better way?

  Read the article

• mysql select top users problem

  - by moustafa

  i have users table and i have posts table i want select from users the top users that have the big amount of posts from posts table and order them by numbers of posts i can make it by array_count_values() by i cant order it now i think if i make it by one mysql query by left and join will be more better table structure posts id |…

  Read the article

• Compare 2 database

  - by shantanuo

  I have 2 identical databases. abc15 and abc18. But one of the database has one extra table and I need to find that. I thought the following query should return it, but is it not showing the record that I expect. select * from information_schema.tables as a left join information_schema.tables as b on…

  Read the article

• python getelementbyid from string

  - by matthewgall

  Hey, I have the following program, that is trying to upload a file (or files) to an image upload site, however I am struggling to find out how to parse the returned HTML to grab the direct link (contained in a ). I have the code below: #!/usr/bin/python # -*- coding: utf-8 -*- import pycurl import urllib…

  Read the article

• python unittest howto

  - by zubin71

  I`d like to know how I could unit-test the following module. def download_distribution(url, tempdir): """ Method which downloads the distribution from PyPI """ print "Attempting to download from %s" % (url,) try: url_handler = urllib2.urlopen(url) distribution_contents =…

  Read the article

• regular expression to extract @name symbols from tweet

  - by Joey

  Hello All, I would like to use regular expression to extract only @patrick @michelle from the following sentence: @patrick @michelle we having diner @home tonight do you want to join? Note: @home should not be include in the result because, it is not at beginning of the sentence nor is followed…

  Read the article

• LockMode With Subclasses

  - by Lester

  I'm using Fluent Nhibernate with the following query on DerivedClass which extends BaseClass: var query = Session.CreateCriteria<DerivedClass>().SetLockMode(LockMode.Upgrade) What I want is the lock hints (updlock, rowlock) to be applied to both DerivedClass and BaseClass, but the generated…

  Read the article

• How about the "Certified Secure Software Lifecycle Professional"?

  - by Ekkapop

  I have invited to join Certified Secure Software Lifecycle Professional training course, however I have no idea about this course. Course's details give me only an overview of information, for example, this course is about how to gathering requirement about security, how to doing something in more…

  Read the article

• wget not behaving via IPC::Open3 vs bash

  - by Ryley

  I'm trying to stream a file from a remote website to a local command and am running into some problems when trying to detect errors. The code looks something like this: use IPC::Open3; my @cmd = ('wget','-O','-','http://10.10.1.72/index.php');#any website will do here my…

  Read the article

• Setting SQL Relationships For LINQ Queries

  - by Soo

  I have two tables that I'm trying to create a relationship between so I can write nice LINQ queries that don't require join. Widgets WidgetId WidgetDescription Orders OrderId WidgetId OrderDate What I want to be able to do is create a LINQ query that does something…

  Read the article

• How to use OUTPUT statement inside a SQL trigger?

  - by Jeff Meatball Yang

  From MSDN: If a statement that includes an OUTPUT clause is used inside the body of a trigger, table aliases must be used to reference the trigger inserted and deleted tables to avoid duplicating column references with the INSERTED and DELETED tables…

  Read the article

• how to get latest entry from a table for an item and do arithmatic operation on it?

  - by I Like PHP

  i have below tables tbl_rcv_items st_id | item_id |stock_opening_qnty |stock_received_qnty |stock_rcvd_date 14 1 0 70 2010-05-18 15 16 0 100 2010-05-06 …

  Read the article

• Dynamically Forming a JSON object traversion without using eval.

  - by Matt Willhite

  Given I have the following: (which is dynamically generated and varies in length) associations = ["employer", "address"]; Trying to traverse the JSON object, and wanting to form something like the following: data.employer.address or …

  Read the article

• How ton put give alias name inside a Query string.?

  - by Vibin Jith

  Please look that alias name. I hope to set the value into a string var. How to put single coats inside a string which is in single coats. SET @SQLString = N'SELECT purDetQty as 'detQty',stkBatchCode as 'batchCode',purDetProductId as…

  Read the article

• comparing data via a function

  - by tigermain

  I have two sets of data (locations) in seperate tables and I need to compare if they match or not. I have a UDF which performs a calculation based upon 5 values from each table. How do I perform a select with a join using this udf? my…

  Read the article

• app engine jpa N-way joins ?

  - by cometta

  may i know is the latest version of jgae support N-way joins? or still limit to 2-way join? reference:…

  Read the article

• Python Script to backup a directory

  - by rgolwalkar

  Filename:backup_ver1 import os import time 1 Using list to specify the files and directory to be…

  Read the article

• How do you encrypt parts of a file separately using pgp?

  - by Collin Anderson

  I would like to encrypt credit card numbers on a web server as they come in using PGP. I would…

  Read the article

• XSLT - make xsl:analyze-string return string instead of sequence of strings?

  - by tohuwawohu

  Is it possible to make xsl:analyze-string return one string instead of a sequence of strings? …

  Read the article

• I can't load the css files

  - by mfalcon

  I want to load some .css files to my Django project but I don't know why they aren't loaded.…

  Read the article

• What are .git/info/grafts for?

  - by Big 40wt Svetlyak

  I am trying to figure out what is the 'grafts' in the Git. For example, in one of the…

  Read the article

• Whats for to use GO

  - by Incognito

  I am interested in new language from Google, GO. I have checked the materials in the…

  Read the article

< Previous Page | 150 151 152 153 154 155 156 157 158 159 160 161  | Next Page >