Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. akelabanda

    Php, Mysql and Ajax

    Thanks jpadie. I'll start work on this and post questions on the relevant forums. Cheers. Rajeev UK's best mobile deals online http://www.bargainmobileshop.com
  2. akelabanda

    Php, Mysql and Ajax

    Sorry, use this url for the image: http://picasaweb.google.com/rajeev.ja/SiteDesign# UK's best mobile deals online http://www.bargainmobileshop.comhttp://picasaweb.google.com/rajeev.ja/SiteDesign#
  3. akelabanda

    Php, Mysql and Ajax

    Hello folks I'm trying to create a new design for a php website to make it database driven (MySQL). I can play around a bit with php and mysql but not really an expert. I'm seeking advice/tips on how best to achieve my site design (attached) * Fig 1 shows the landing page with initial data...
  4. akelabanda

    Update one column with a substr of another

    Ok. Looked at MySQL reference manual and figured out how to do it. Here it is: update mytable set model_number = substring_index(product_name,' T-Mobile ',1) where network = 'T-Mobile'; This worked beautifully. UK's best mobile deals online http://www.bargainmobileshop.com
  5. akelabanda

    Update one column with a substr of another

    Hello I'm having a problem with an incorrect datafeed received. Following is an example. product_name column has this. W880i Silver T-Mobile FLEXT 35 18 months I now want to extract 'W880i Silver' which appears before T-Mobile and update the model_number column. This string can vary from...
  6. akelabanda

    Querying postgresql db using ruby

    Hi I'm a newbie with ruby. Have an installation of ruby 1.8.4 on windows xp (for some test automation stuff). From here I would like to query some tables on our postgresql DB on a remote linux box. What do I need to do to query the postgresql db on linux using ruby on windows ? Thanks for...
  7. akelabanda

    Handling IE security alert

    Hi folks We are trying to automate some tests for our web application for which we are evaluating a test tool 'watir' which supports ruby. We are able to invoke the browser using the watir library and playback few tests which is fine. Now, when the browser goes to the login screen (using...
  8. akelabanda

    Undefined variable

    That worked. The include was between <? ?> and not <?php ?> Thanks jpadie. UK's best mobile deals online http://www.bargainmobileshop.com
  9. akelabanda

    Undefined variable

    Hi there I've setup a readymade website on my Win XP. It's running Apache 2.2 and PHP5. When I run index.php, there is an error displayed Notice: Undefined variable: auto_filename in F:\wwwroot\ecommerce\index.php on line 154 index.php has the following line <? include("includes/vars.inc")...
  10. akelabanda

    php-mysql test script errors

    Now resolved. I did the following. Downloaded mysql extension (PHP 5.2.0) from http://dev.mysql.com/downloads/connector/php/ Unzipped the dlls into c:\php5 (my php install directory) as by default extension_dir = "./" in php.ini Uncommented extension=php_mysql.dll in php.ini Restarted...
  11. akelabanda

    php-mysql test script errors

    Hi Vacunita The following is set in the php.ini extension_dir = "./" and both php_mysqli.dll and libmysql.dll are present in the C:\php5 directory. Also entered in php.ini extension=php_mysqli.dll extension=libmysql.dll Still complains about the same. Thanks Rajeev UK's best mobile deals...
  12. akelabanda

    php-mysql test script errors

    Hello Guys I'm a newbie with php and mysql. I found a couple of tutorials on the web and got a small test script which confirms that php connects to mysql server correctly. Here's the test script - ------------------- <?php mysql_connect("localhost","root","tester") or die(mysql_error()); echo...
  13. akelabanda

    Change page load status

    Hi There I'm creating a dynamic web page for my company after running a few shell scripts from the main program. What's happenning is - two of these scripts take a while longer to finish and hence the output does not appear on the page. This gives an impression to the user that the page has...
  14. akelabanda

    Capture both sql result and status code in shell script

    Brilliant. Both work perfectly well. Appreciate your helpw ith this. Thanks a lot. Regards Raj UK's best mobile deals online http://www.bargainmobileshop.com
  15. akelabanda

    Capture both sql result and status code in shell script

    Well, some people claim that sqlplus does not return ZERO for SUCCESS always. So, our guys decided they are going to use 99 as our success code. Lot of other stuff depend on the exit status of 99. Secondly, in this case, I would also like to store the result of the query in a shell variable...
  16. akelabanda

    Capture both sql result and status code in shell script

    Hi Dagon Did think about it. But like to avoid running the query twice. Will have that as an option if nothing else works out. Thanks Raj UK's best mobile deals online http://www.bargainmobileshop.com
  17. akelabanda

    Capture both sql result and status code in shell script

    Hi There I'm running an sql query from within a shell script. We use a different exit code to denote SUCCESS (99) rather than 0. The code is something like this (assuming only 1 row is returned) - ------------------------------------- temp_percent="set pages 0 set head off whenever sqlerror...
  18. akelabanda

    Manage gzipped files using script

    Thanks a lot everyone for inputs. Solved by using the file command piped thru grep for compressed. If result 0, gunzip, else, continue. UK's best mobile deals online http://www.bargainmobileshop.com
  19. akelabanda

    Manage gzipped files using script

    Hi Guys Hope you can help me with this. I have to deal with a set of file that come in everyday. Example x1 x2 x3.gz x4.gz x5.gz x6.gz x7.gz x8 x9 x10 In the example above, I have to pick the oldest file from the list and process it (x1, x2, x3, etc). However, to save on space, there is a...
  20. akelabanda

    Automate ftp

    Worked like MAGIC!! Thanks a ton PH.. Is there an explanation for this behaviour ? Raj UK's best mobile deals online http://www.bargainmobileshop.com

Part and Inventory Search

Back
Top