Search results for query: *

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...

*Blub* *blub* it's soooo pretty... SOOOO pretty. I promised myself I wouldn't cry.. Thanks a thousand times Ties, Mark.

Hi Ties, Well that is perfect Ties. Thanks a million!! Would you know of anywhere were I could get a list and a few samples of similar functions? I was attempting it with a subselect and the ROW_NUMBER() function to no avail. Thanks again, Mark.

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...

Thanks Tim, That makes sense. Think I've managed a work around but it's just not so pretty. Thanks, Mark.

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...

Hey PHV, Thanks a million for that website. That's exactly what I was looking for. It nailed all the conceptual problems I had with joins. Thanks again for taking the time to post it on to me. Cheers, Mark.

Thanks again for your help James I'll try and keep that in mind with a few examples. Cheers, Mark.

Hi James, Thank you very much James. I find it hard to get my head around joins. Would you have any easy way for remembering the semantics? Thanks, Mark.

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...

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...

Cheers NullTerminator I got it down. Thanks again for your help. Mark.

Nullterminator, That's the very tool I was looking for!! Thank you so much. Do you know if the source is available for this tool? Thanks, Mark.

Some application that stands between the Client and the server. It's like a server itself that intercepts requests and then forwards them to the server. If I remember correctly it's port number was around 5050 or something like it. I'm looking to intercept the requests and build up a...

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...

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=...

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...

THanks Marc, Could I ask you maybe to have a quick look at this problem if you have the chance? I'm trying to call a RUNSTATS command from within a stored procedure. Do you konw if it's possible? The command works fine from the command editor but not so good from the stored procedure. SET...

Hey Marc, Thanks for getting back to me. I got it to work by putting two single quotes back to back within the original string hence SET cardSQL ='SELECT CARD FROM syscat.tables where tabname=''' || vTableName || '''' ; gives my back SELECT CARD FROM syscat.tables where...

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 ' ||...