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 wOOdy-Soft 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: markgargan
  • Content: Threads
  • Order by date
  1. markgargan

    Scroll down with IE using Ruby

    Hi folks, There's a method on the Watir:IE object to maximize the window, however, some of our buttons are still out of view and require the page to be scrolled down to view them. I'd like to be able to demonstrate all the buttons being click in our application deployment that I'm...
  2. markgargan

    Numbering duplicates

    Hi folks, Say I have the following table id | name --------- 1 Michael 2 James 3 John 4 James 5 Michael 6 James Is there any select function I can perform that could print out the values of the id, name column and a number representing the ith time this name appears...
  3. markgargan

    Override ignored for property

    Hi folks, Here's a very simple ant project. <project name="test" default="testPrintPath" basedir="."> <macrodef name="printPath"> <attribute name="path"/> <sequential> <pathconvert targetos="windows" property="pathString" refid="@{path}"/> <echo message="The path...
  4. markgargan

    self-join or subquery

    Hey folks, I have two tables that describe a family First is person create person (id integer, name varchar(20)); Second is relationship create relationship ( relName varchar(16), fromId integer, toId integer); Person id name ----------------- 1 Dad 2 Mom 3...
  5. markgargan

    Retrieve info about form and button at onSubmit

    Hey folks, A page has a number of forms with a different submit button for each. Is there anyway of handling the onSubmit() function so that we retrieve and send to the next page, the name of the form which was submitted and the name of the button. the code might look something along the...
  6. markgargan

    Proxy tool for beginners

    Hi folks, I was learning what I think was apache a couple of years ago. Bundled with the server was a small app that bound itself on a port. It listened for requests and output the requests before forwarding the request to the actual appserver. It was beginners facility for having a...
  7. markgargan

    condition handler ineffective

    Sorry for all the posts folks but it just seems that this is the only forum available for posting questions. I have the following code in my stored procedure DECLARE CONTINUE HANDLER FOR not_found set at_end=1; Drop table changes; set vOldName=...
  8. markgargan

    Say it ain't so. Runstats can't be called from a stored procedure

    Folks, Tell me the docs are lying to me!! I've had a quick look and it seems that the only way to call Runstats from an external application is to use the C apis? Is this true? This makes life kinda difficult for me. Has anyone any way around this? Could I create a task in the Task...
  9. markgargan

    Stored Procedure escape character

    Hey folks, I've created a cursor before for a select statement. However the sql in the select statement never had to have a 'where' clause with it and as such I'm having terrible trouble escaping the single-quote (') character e.g. Before :- SET countSQL ='SELECT Count(*) FROM ' ||...
  10. markgargan

    Command line environment not initialised

    Hey folks, I'm currently trying to write a db2 script. I've got a number of commands back to back like follows db2 attach to db2; db2 connect to sample; db2 -r authors.txt select * from authors; db2 disconnect sample; db2 detach; db2 terminate; However as soon as the script tries...
  11. markgargan

    Select a count of all rows from all tables

    I originally thought this would be an easy select statement to perform. After a few minutes I realised I could only do it with a stored procedure. I recently switched jobs and hence dbs from Oracle to DB2 so if my questions seem basic please grant me the benefit of the doubt. I thought I had...

Part and Inventory Search

Back
Top