eskimoghosty

Hi all, I am currently with Tsohost on the Linux standard option. I have no problems with them, haven't experienced any down time, support always replies fast and price is good too. However I want to do some projects using Ruby on Rails and Pylons (python based web framework). Was wandering if anyone knows any good shared hosting providers that support these? Thanks, Sid

Hi All, I am looking for an ecommerce solution. I have an account with Kashflow (an online accounting software). I would like the ecommerce solution to automatically update my Kashflow account when a sale is made. Kashflow provide API access to their software so I could use this to update my Kashflow account from the ecommerce system. I have come across Easy Web Store (http://www.easywebstore.net) and they have already developed a functionality to update Kashflow accounts. I'm fairly proficient in HTML, CSS, PHP and Ruby so am interested in Easy Web Store's DIY option which requires the user only to design the system. However I want to find out people's experience of using Easy Web Store's DIY option? Or can anyone recommend an alternative ecommerce solution? Sincerely appreciate the help. Sid.

Hi All, I just figured it out, so silly of me. The syntax is correct but there are no records in the table matching the criteria I specified...

Hi All, I'm having problems with specifying a SQL query. The code: $myusername = $_SESSION[myusername]; echo $myusername; $imageQuery = "SELECT login.username, userdetails.gender FROM login INNER JOIN userdetails ON login.accountId = userdetails.accountId WHERE login.username = '$myusername'"; $imageResult=mysql_query($imageQuery); $num=mysql_numrows($imageResult); echo $num; It keeps returning zero. I know it is to do with the WHERE clause because when this is removed it finds records.. Appreciate any help. Many Thanks, Saeed.

Hi, I am trying to query a table in a PostGreSQL database. I have a table with three columns, the first column is not required in the query. A value is provided by the user (which also exists in the table), this value is then used to look up another value in the record and display it to the user. Here is my code; <?php $q = "SELECT * FROM lookuptable WHERE value_code='$code'"; $result= pg_query($q); $line = pg_fetch_array($result, null, PGSQL_ASSOC); $valueb = $line['valueb']; echo $value b; ?> Would be grateful if someone could help me out. Many Thanks, Saeed.

Hi Lev, Thanks for your reply, I found a different solution; AND EXTRACT(HOUR FROM scrapetimestamp) = 14 AND EXTRACT(MINUTE FROM scrapetimestamp) >= 30 AND EXTRACT(MINUTE FROM scrapetimestamp) <= 59 Saeed. ps I'm using PostGreSQL.

Hi All, I am working on a query which specifies a 'BETWEEN' clause for a column that has timestamp values; SELECT * FROM Persons WHERE scrapetime BETWEEN 14:30 AND 15:00 'scrapetime' is timestamp format, I'm not sure how to specify the the time only... Any help is greatly appreciated. Saeed

Hi All, I am looking for an API management service, I have found a few but they're all based in USA (Apigee). Was wandering if anyone knows of any UK based companies that offer API management services? Thanks, Saeed.

Hi, How do I uninstall Apache based on a Linux Ubuntu platform? Many Thanks, Saeed

Hi All, I'm looking around for dedicated server / cloud/clustered hosting solution. Just came across Rackspace (http://www.rackspace.co.uk/). Is anyone with them or been with them? Thanks, Saeed.

Hi All, We have optimised the python script so that it is run for a set period of time instead of it being run every minute. We are still looking at server options, judging from what we have done so far we will require a plan that offers a lot of hard disk space, ideally around a couple 100 GBs. Saeed.

Thanks Darren, that is useful information.

Do you have Python installed on your VPS or would it be installed on request? If so, which version? Saeed.

Hi Wesh, Thanks for replying. The project is for a company I am working for. I feel that the details are potentially commercially sensitive information therefore it does not seem appropriate to disclose details on a public forum. The pages from where the data is scraped from is updated every minute with new information hence scraping is done so frequently.

Hi All, I am currently working on a project which involves 'scraping' data from a website and storing the data in a PostGreSQL database. The 'scraping' is done via a Python script. I have set this up locally on my Ubuntu machine using an Apache server and installed some modules to facilitate the Python script. What I require now is the Python script to be run every minute and then store the data in a PostGreSQL database. I am interested in hosts who can provide this and would like to know how much it would cost roughly. Many Thanks, Saeed.