Thursday, March 11, 2010

Update to the Beta finally coming

It's been a busy few months since my last post back in October of last year! I've been busy working on multiple projects on top of handling hosting sign-ups and support requests. I've also been quietly working on fixing bugs and combining all these fixes into an update for the Beta. Once I have it posted the current version will no longer be considered a Beta version but will be the current version.

I am also going to be rolling out a new look to the website I've been working on in what little spare time I have had lately. It should be up (I hope) in the next week.
Posted by at

3 comments:

  1. Thats awesome news, will be looking for it today.

    Great application!

    ReplyDelete

  2. Just started using your shopkart. It's sensational. Lot's of useful features.

    Suggestion for improvement of the site search query:



    SELECT p.*
    FROM products p
    JOIN product_categories pc ON p.itemid = pc.itemid

    WHERE
    (
    LOWER(ProductID) LIKE '%#lcase(SearchQuery)#%'

    OR p.Brand LIKE '%#lcase(SearchQuery)#%'


    OR p.ProductName LIKE '%#lcase(SearchQuery)#%'


    OR p.BriefDescription LIKE '%#lcase(SearchQuery)#%'


    OR SKU LIKE '%#lcase(SearchQuery)#%'


    OR Details LIKE '%#lcase(SearchQuery)#%'

    )

    AND pc.categoryid >

    AND unitsinstock >


    GROUP BY p.itemid
    ORDER BY pc.OrderValue ASC

    ReplyDelete

  3. Flag that last post. My blocks didn't show up. Try this:

    SELECT p.*
    FROM products p
    JOIN product_categories pc ON p.itemid = pc.itemid

    WHERE
    (
    LOWER(ProductID) LIKE '%#lcase(SearchQuery)#%'

    cfif request.searchBrand is 'on'
    OR p.Brand LIKE '%#lcase(SearchQuery)#%'
    /cfif

    cfif request.searchProductName is 'on'
    OR p.ProductName LIKE '%#lcase(SearchQuery)#%'
    /cfif

    cfif request.searchBriefDescription is 'on'
    OR p.BriefDescription LIKE '%#lcase(SearchQuery)#%'
    /cfif

    cfif request.searchSKU is 'on'
    OR SKU LIKE '%#lcase(SearchQuery)#%'
    /cfif

    cfif request.searchDetails is 'on'>
    OR Details LIKE '%#lcase(SearchQuery)#%'
    /cfif

    )

    ReplyDelete

Subscribe to: Post Comments (Atom)