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: *

  • Users: akelabanda
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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")...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. akelabanda

    Automate ftp

    Hi Folks Wondering if you can help me with my script. I'm trying to run an unattended FTP session from within a shell script. The FTP uses servername, username and password from a text file. I'm getting an error: syntax error at line 34: `end of file' unexpected The file has only 33 lines. I...
  11. akelabanda

    Remove unwanted characters from string

    Hi Guys I have to remove any characters that do not match a SPACE, a-z, A-Z, 0-9 from a line of record that resembles the one below. Here, I have to remove the double quote and retain the rest of the text in the third comma separated field. 255,95017,D0 Ayu"Gila,255 But, I'm...
  12. akelabanda

    Read a record split across 2 lines

    Hi Guys How can I read a record from input file which is split across 2 lines. A sample record is shown below STLVGB0Q1_TMC121245.TLG;1 17549/17745 28-JUN-2006 09:28:00 [DECSS7] (RWED,RWED,RE,) STLVGB0Q1_TMC121245.TLG;1 is on one line, the rest on the...
  13. akelabanda

    Amend values of a field in a record

    Hi I would like to read a file, one line at a time, change a specific column value and write the output back to a file. How can I do this ? Example Input 1,Rajeev,33,Reading,UK Want to change 33 to 34 and write back as 1,Rajeev,34,Reading,UK The actual file has some 45 columns. Can this be...
  14. akelabanda

    using ms-access db

    Hi Friends I'm new to PHP. To make my website dynamic, I'm planning to store a list of URLS and other info on MS-access db. Can you tell me if PHP can open and read this file independently. What I mean is - 1. Create the ms-access db on my desktop 2. ftp it over to my linux hosting service 3...
  15. akelabanda

    Tracking clicks on a webpage

    Hi Everyone I have a few hyperlinks on my webpage, which I like to track everytime someone clicks on it. I would also like to write an entry to a text file on the server which I can later use to build some stats. Can this be done using Javascript ? Does anyone have a working script ? Thanks...
  16. akelabanda

    How can I schedule a script to run every 10 minutes

    Hi All Is there a way to run a script every 10 minutes on a solaris box. I'm afraid I will not be able to use crontab. Can I use the "at command" for the same ? I tried running by scripts as - at now "+ 10 minutes" >sh <script.sh> ><EOT> But it just runs once. Any help would be...
  17. akelabanda

    Need sample Windows outputs using WMI

    Hi Folks I need some sample outputs for Windows captions using Win32_OperatingSystem - Caption attribute. For example, a windows 2000 box will show &quot;Microsoft Windows 2000 Professional&quot; Similarly, I need samples for - Windows XP Home Windows XP Professional Windows XP Tablet PC...
  18. akelabanda

    User last logon date/time

    Hi How do I get the last logon info for a user ? I checked out a few forums, which say that I have to write a trigger to get that info. But my requirement is to get old info. A user might have left the organization, but still having an account. I need to check the last time he logged in and...
  19. akelabanda

    Does Perl Win32::OLE work on Win NT at all ?

    Does the Win32::OLE that uses the windows WMI features work on Win NT ? Or does it work only on XP/98/2000. Raj
  20. akelabanda

    Can someone help with Win32/Perl

    Hi I'm using one of the samples from Dave Roth's site for making use of Win32 module for perl. I'm getting the following error when I run the script. ************************************************ Can't call method &quot;InstancesOf&quot; on an undefined value at memory.pl line 54...

Part and Inventory Search

Back
Top