Search Results

Search found 4444 results on 178 pages for 'james price'.

Page 126/178 | < Previous Page | 122 123 124 125 126 127 128 129 130 131 132 133  | Next Page >

• column aliases in postges for calculated values

  - by dubreakkk

  I tried to uses aliases in postgres for this query, but postgres stops and complains that ERROR: column "subtotal" does not exist SELECT SUM(price) AS subtotal, subtotal * 3.0 AS fees, (subtotal + fees) AS total FROM cart You cannot use aliases as part of your next column?

  Read the article

• Migrating from OS Commerce to...?

  - by Tevi

  I am looking to move on from OS Commerce. 1,500 products and many years, it's time. I would prefer to migrate to BV Commerce. Is that possible? Is there a similarly reliable store as BV that can import from OSCommerce? I'd like customer info, products, price, etc.

  Read the article

• Grails: Help with HQL query.

  - by Olexandr

  I'm not very good in SQL and HQL... I have two domains: class Hotel { String name } class Room { Hotel hotel float price } How many hotels have at least one room ?

  Read the article

• How to create PDF for product description in Magento

  - by Nishant

  Hello, I was searching the different Magento forums and extensions for this but i didn’t find anything. What i want is to let my visitors to create a PDF file with image and description for the products they are interested. With this will have the ability to save the product on its computer or print it. This will be some kind of a printout offer. The PDF must include the title, default image, description and price. Thanks in advance!

  Read the article

• Calculated group-by fields in MongoDB

  - by Navin Viswanath

  For this example from the MongoDB documentation, how do I write the query using MongoTemplate? db.sales.aggregate( [ { $group : { _id : { month: { $month: "$date" }, day: { $dayOfMonth: "$date" }, year: { $year: "$date" } }, totalPrice: { $sum: { $multiply: [ "$price", "$quantity" ] } }, averageQuantity: { $avg: "$quantity" }, count: { $sum: 1 } } } ] ) Or in general, how do I group by a calculated field?

  Read the article

• How to redirect an application's connection through a Socks5/SSH/HTTPS tunnel? Any recomendations of

  - by Pai Gaudêncio

  I need to tunnel the connections (mostly TCP) made by an application through Socks5, SSH or HTTPS. So far, I've found 3 ways to do this: api hooks, winsock lsp and a driver. I'm looking for advice on the best way to handle this, and any recommendations on SDK's that could abstract this task for me (free/open-source preferred, but commercial ones are welcome as long as the price is not high for a one-man-starting-company to afford). ps. I'm using .Net (C# and-or C++/CLI)

  Read the article

• Using a single xcode proj for iphone and ipad- can I use same push notification certificate ?

  - by Shweta

  Hi I am looking for extending my current iphone app for iPad-specific UI. For the same Apple has mentioned 3 ways, however I am using the method where a Single XCODE proj is used for having 2 targets- iphone & iPad. There are a few queries: two binaries will be created , which I can price differently for selling. Will they need 2 have different certificates from Apple ? My app has Push notifications. So will i require 2 different certificates ?

  Read the article

• Looking for an object database

  - by saille

  I'm looking for an object database for .NET that is open source and free for commercial use. I need something that is available as assemblies and/or source code to embed into a project, i.e. not a stand alone database in its own process. I am aware of db4o, and it would be perfect except for the commercial license coming at a price.

  Read the article

• SQL Count in View as column

  - by alex

  I'm trying to get the result of a COUNT as a column in my view. Please see the below query for a demo of the kind of thing I want (this is just for demo purposes) SELECT ProductID, Name, Description, Price, (SELECT COUNT(*) FROM ord WHERE ord.ProductID = prod.ProductID) AS TotalNumberOfOrders FROM tblProducts prod LEFT JOIN tblOrders ord ON prod.ProductID = ord.ProductID This obviously isn't working... but I was wondering what the correct way of doing this would be?

  Read the article

• Using R to Analyze Balance Sheets and Income Statements

  - by Ramnath

  I am interested in analyzing balance sheets and income statements using R. I have seen that there are R packages that pull information from Yahoo and Google Finance, but all the examples I have seen concern historical stock price information. Is there a way I can pull historical information from balance sheets and income statements using R?

  Read the article

• How would I change this Query builder from Kohana 2.4 to Kohana 3?

  - by Thorpe Obazee

  I have had this website built for a few months and I am just getting on Kohana 3. I'd just like to convert this K2.4 query builder to K3 query builder. return DB::select(array('posts.id', 'posts.created', 'posts.uri', 'posts.price', 'posts.description', 'posts.title', 'image_count' => db::expr('COUNT(images.id)'))) ->from('posts') ->join('images')->on('images.post_id', '=', 'posts.id') ->group_by(array('posts.id')) ->order_by('posts.id', 'DESC') ->limit($limit) ->offset($offset) ->execute();

  Read the article

• Source control system for single developer

  - by kaiz.net

  What's the recommended source control system for a very small team (one developer)? Price does not matter. Customer would pay :-) I'm working on Vista32 with VS 2008 in C++ and later in C# and with WPF. Setting up an extra (physical) server for this seems overkill to me. Any opinions?

  Read the article

• code for searching from file using GUI

  - by maya

  hi everyone, I'm looking for a code that allows me to search from file , for example, in my program which is shoes shop's program . I should design and implement interfaces which have to search data from file TXT. the idea is that when I choose one item like type of shoes the program should display all other times such as color, size and price . Thanks in advance.

  Read the article

• SQL Update to the SUM of its joined values

  - by CL4NCY

  Hi, I'm trying to update a field in the database to the sum of its joined values: UPDATE P SET extrasPrice = SUM(E.price) FROM dbo.BookingPitchExtras AS E INNER JOIN dbo.BookingPitches AS P ON E.pitchID = P.ID AND P.bookingID = 1 WHERE E.[required] = 1 When I run this I get the following error: "An aggregate may not appear in the set list of an UPDATE statement." Any ideas?

  Read the article

• Interpret a rule applying multiple xpath queries on multiple XML documents

  - by Damien

  Hi, I need to build a component which would take a few XML documents in input and check the following kind of rules: XML1:/bookstore/book[price>35.00] != null and (XML2:/city/name = 'Montreal' or XML3://customer[@language] contains 'en') Basically my component should be able to: substitute the XML tokens with the corresponding XML document(before colon) apply xpath query on this XML document check the xpath output against expected result ("=", "!=", "contains") follow the basic syntax ("and", "or" and parentheses) tell if the rule is true or false Do you know any library which could help me? maybe JavaCC? Thanks

  Read the article

• Use of var in linq

  - by mazhar

  What does var really do in the following case? var productInfos = from p in products select new { p.ProductName, p.Category, Price = p.UnitPrice };

  Read the article

• How to return and process an array returned by a php file using ajax?

  - by Holicreature

  Hi I've a php file which processes a query and returns an array. How do i get these and array and parse them and display them using ajax. I call the file using ajax. Its used to display the matching products while typing a text box with the price... responseText doesn't return anything...

  Read the article

• Applications for data scraping from websites and database creation

  - by beginning_steps

  I am looking for application/software that will help me in scraping data from yellow pages, jigsaw and other similar kind of websites. I want to collect info like contact details/ name designation and email address. Please advice some software that will be able to do so, the price i am looking should be affordable or preferably free.

  Read the article

• JavaScript: Rounding to two decimal places. Not less than two

  - by Abs

  Hello all, I have this line of code which rounds my numbers to 2 decimal places. But the thing is I get numbers like this. 10.8, 2.4 etc. These are not my idea of 2 decimal places so how I can improve this: Math.round(price*Math.pow(10,2))/Math.pow(10,2); I want numbers like 10.80, 2.40 etc. Use of JQuery is fine with me. Thanks for any help.

  Read the article

• how to Extract the data from http://www.pse.com.ph/servlet/TickerServletFile save into mysql databas

  - by devzone

  This should be a code igniter based class, The table header should be Price Percent_change Company Name Company Code Volume Please help any one knows? Many thanks!

  Read the article

• treat mysql longtext as integer in query

  - by InnateDev

  I have a set field in my db that is longtext. I have used prices in this field and cannot change the field type to integer. In my query however I need to sort by these fields and assume I should treat them as an integer. is there another way to query these results to sort by price as an integer and not longtext without having to change the field type? at the moment 3900000 is smaller than 4300 in my result set.

  Read the article

• Add a 0 to the end of a decimal number to make sure it's always 2 decimals?

  - by tarnfeld

  I am using the following code to work out an inc and ext VAT price: $('#totalexvat').text(totalprice); var vat = totalprice / 100 * 17.5; vat = roundNumber(vat,2); $('#totalincvat').text(totalprice-vat); Sometimes i get .3 or .9 instead of what I would like to be .30 or .90 because it's money, is there a way to do this?

  Read the article

• True or False: Good design calls for every table to have a primary key, if nothing else, a running i

  - by Velika

  Consider a grocery store scenario (I'm making this up) where you have FACT records that represent a sale transaction, where the columns of the Fact table include SaleItemFact Table ------------------ CustomerID ProductID Price DistributorID DateOfSale Etc Etc Etc Even if there are duplicates in the table when you consider ALL the keys, I would contend that a surrogate running numeric key (i.e. identity column) should be made up, e.g., TransactionNumber of type Integer. I can see someone arguing that a Fact table might not have a unique key (though I'd invent one and waste the 4 bytes, but how about a dimension table?

  Read the article

• Best way to use number format in mysql query

  - by PHP-Prabhu

  can any one please let me know, i need to set the "Total Price" value to be in two decimal point value like "56.35". Now its showing more fraction values like "56.3566666". I need it to be format it by musql "SELECT" query.

  Read the article

• convert following string into array using explode()

  - by Deepali

  HI, I have a string: NEW ALPINESTAR?S SMX PLUS WHITE MOTORCYCLE BOOTS! 44/9.5$349.95 Time Left 1h 2m NEW AGV BLADE FLAT MATTE WHITE LARGE/LG HELMET$75.53Time Left 1h 2m I want result in array like this: Productname Price time NEW ALPINESTAR?S SMX PLUS WHITE MOTORCYCLE BOOTS! 44/9.5 $349.95 Time Left 1h 2m

  Read the article

< Previous Page | 122 123 124 125 126 127 128 129 130 131 132 133  | Next Page >