Search Results

Search found 2 results on 1 pages for 'kalessin'.

Page 1/1 | 1 

• Is there a simple shopping cart I can add to my existing website?

  - by Kalessin

  I created a website for my wife, who knits scarves. The site simply displays the 18 different colours she has created, with a Lightbox-like large photo available when clicked. She would now like to give visitors the option to purchase online and pay with PayPal and possibly Google Checkout. We do not need a full ecommerce solution; I've looked at several and they all seem to be overkill for our requirements. We don't even need categories. "All" I want is something that will add products to a cart, take the customer details and integrate the payment provider. So far, the best solution I have found seems to be this script on Codecanyon and I wanted to find out if anyone knows of any better products before I commit to this route. Thanks for your help!

  Read the article

• How can I exclude LEFT JOINed tables from TOP in SQL Server?

  - by Kalessin

  Let's say I have two tables of books and two tables of their corresponding editions. I have a query as follows: SELECT TOP 10 * FROM (SELECT hbID, hbTitle, hbPublisherID, hbPublishDate, hbedID, hbedDate FROM hardback LEFT JOIN hardbackEdition on hbID = hbedID UNION SELECT pbID, pbTitle, pbPublisher, pbPublishDate, pbedID, pbedDate FROM paperback Left JOIN paperbackEdition on pbID = pbedID ) books WHERE hbPublisherID = 7 ORDER BY hbPublishDate DESC If there are 5 editions of the first two hardback and/or paperback books, this query only returns two books. However, I want the TOP 10 to apply only to the number of actual book records returned. Is there a way I can select 10 actual books, and still get all of their associated edition records? In case it's relevant, I do not have database permissions to CREATE and DROP temporary tables. Thanks for reading! Update To clarify: The paperback table has an associated table of paperback editions. The hardback table has an associated table of hardback editions. The hardback and paperback tables are not related to each other except to the user who will (hopefully!) see them displayed together.

  Read the article

1