Looking for a quick way to use a "text" object to store a log – do it in one query using the following … 

UPDATE [TABLE] SET [TXT_COL] = CONCAT(IF([TXT_COL] IS NULL, "", [TXT_COL]), "[DATA]") WHERE ....

If you get something along the lines of -

fatal: unable to rename temporary pack file: Permission denied
Auto packing the repository for optimum performance.
error: failed to run repack
Pushing to ….

When making a push you may have a courrupt pack file within your git repo…

Using the shell you can rebuild the "pack" files by running -

git repack -a -f

Ok – so this didnt fix the problem….

Running git push from the command line gives much more detail than "Git Gui"…

will update this post when we get to the bottom of it…

Ok – problem is with 64bit version of Msysgit – the current beta is broken (1.7.0.2),  We have reverted to Git-1.6.5.1 which doesn't exhibit the problem!

Which Payment Gateway? 30 October 2009

paypalgoogle_checkout_logo

Due to the number of features available, we would normally recommend PayPal Express Checkout or Google Checkout.

There are different levels of integration you can carry out on a website, while there are many variations, broadly speaking your looking at three basic setups:

  1. Blind integration – your website has some simple forms and NO database backend. In this situation, you just use your payment gateway to take a payment and manage who has paid for what. This is a simple to understand option and means that the shop operator can manage there orders entirely with the gateway provider, only needing to update the website when their prices change.
  2. Callback integration – your website has a database and manages order data. The payment gateway makes a callback (hence the name!) into your system to keep the order status up to date. This option is more complex but is useful if the shop operator needs the ability to manage the order data on the website. Why would you want to do this? Hosting order data in your website enables you to provide a more services to your customer such as order status, history and enables you to perform statistical analysis for other business functions such as accounting or marketing.
  3. Full integration – your website takes credit card details and performs the payment with the gateway directly. Your server must be PCI compliant and undergo regular security audits. This option requires a lot more work as it means the whole card verification procedure must be handled on the web server.

PayPal offer all three options whereas Google Checkout only offer the first two.

Both gateway systems are good however Google checkout will – being Google give you better quality marketing data with its tie ins to Google Analytics and also, you can advertise you’re a Google Checkout seller on any PPC advertising you do using their AdWords programme. Google have offered £10 of checkout fee suspension against every £1 spent on Adwords but this promotion ended at the end of 2008.

PayPal I believe will give you better financial tie ins as they are more money oriented – I may substantiate this further at a later date.

I would suggest for business start-ups or newcomers to payment gateways that; due to the quality of marketing data available – Google Checkout may be a better option; you could always switch to PayPal or offer it as an alternative at a later date.

These payment gateways at the time of writing have the following charges:

Google Checkout AND PayPal

Monthly Sales Through Google Checkout/PayPal Fees Per Transaction
Less than £15003.4% + £0.20
£1500 – £5999.992.9% + £0.20
£6000 – £14999.992.4% + £0.20
£15000 – £54999.991.9% + £0.20
£55000 or more1.4% + £0.20

There are to no charges made by these gateway providers to transfer money into your own accounts. There are transfer limits however; these limits can be modified and the frequency of transfers can be managed. Transfer limits are as far as I can tell an anti-fraud “feature”.


September 2010
S M T W T F S
 1234
567891011
12131415161718
19202122232425
2627282930  
August 2010
S M T W T F S
1234567
891011121314
15161718192021
22232425262728
293031  
July 2010
S M T W T F S
 123
45678910
11121314151617
18192021222324
25262728293031
June 2010
S M T W T F S
 12345
6789101112
13141516171819
20212223242526
27282930  
powered by
wordpress
theme and icons by
web-engineer

©2008 web-engineer™
all rights reserved