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

    Allowing text to be typed into either of two text boxes

    Hi all, I have a form with three text boxes. The first is a bound text box to a field SALE_SUBTOTAL in a table where I ultimately store the form contents as a new record. Under this text box, I have two other text boxes, one which contains the expression =[SALE_SUBTOTAL]*0.2, which displays...
  2. scottyjohn

    Remote control with audio?

    Hi all, I have a problem where I need to remotely access a desktop and have the audio / microphone audio passed from the far end machine to my desktop. I thought that perhaps PC Anywhere would have that functionality but it appears not. Does anyone have an idea of software which can do this...
  3. scottyjohn

    Export outlook calendar as graphic or gannt

    Hi all, As per the title, Im looking for a way to print off an outlook calendar graphically to display a timeline if you like. Similar to the way the scheduling tab looks when you are scheduling a meeting. Is there any way, or using an additional tool to do this? John [smile]
  4. scottyjohn

    Clicking on a form record to open another query

    Hi all, I have QueryA which returns three fields in a List box on a report. I have added the behaviour to open a new query QueryB which runs using a value from column 1 in QueryA, but I cant get this run correctly. How do you tell the new query QueryB to get its criteria for the query from the...
  5. scottyjohn

    Querying values from different records to show as one record?

    Hi all, I have the following Data.... ID START(UTC) END(UTC) DURATION STATE TRANSACTION_ID ------------------------------------------------------ 1 1251384001 1251384102 101 INBOUND 31808563970 2 1251384102 1251384202 100 HOLD 31808563970 3 1251384202 1251384302 100 INBOUND...
  6. scottyjohn

    Concat a text string gives space between??

    Hi all, I am running the following sql to convert a decimal string to hex and its fine but I then need to compare that value to a different data source which already has the value in hex.  Trouble is the second source appears to have two have two zeros at the start of each hex string, so I...
  7. scottyjohn

    Concat a text string gives space between??

    Hi all, I am running the following sql to convert a decimal string to hex and its fine but I then need to compare that value to a different data source which already has the value in hex.  Trouble is the second source appears to have two have two zeros at the start of each hex string, so I...
  8. scottyjohn

    Cant run local .htm presentation

    Hi all, Im running IE8 on windows xp and have to view some presentations from a vendor which launch via a play.htm file, which then seems to jump to another page. I believe this is trying to run some javascript, and it runs fine on an old xp machine with ie6. Ive done a clean build of xp, ie8...
  9. scottyjohn

    Rollback after Merge?

    Hi all, I have a situation where I have a table TABLE1 and a backup table BACKUPTABLE1 which is an exact copy of the main table, populated by running a query before a bulk merge to the TABLE1 table. I am looking for the best way to handle some kind of rollback, and I have looked at rollback...
  10. scottyjohn

    ORA home help

    Hi all, I have an issue which is driving me bananas! I have written a script on windows machine which calls an sqlplus -s script. Yesterday I tested it and it worked no problem, but today I get the error SP2-0734 saying it cannot recognise the command. I have ors81 and ora92 homes, and have...
  11. scottyjohn

    Grep output including filename but from cat input?

    Hi all, I am currently using the following command to cat a bunch of .gz files, gunzip -c them, and then grep for a text string which sends to output file cat *.gz |gunzip -c |grep "person_dbid = 10353" >Skillchange8.txt What I need is to have the filename of the original file where the text...
  12. scottyjohn

    Outlook 2003 selected Message format

    Hi, I run with a preview pane, and if I click out of the main inbox window and into the preview pane, I can hardly tell which message is actually selected in my list of messages in inbox. Is there any way to alter this, so that even when I click in the preview pane, the selected message is...
  13. scottyjohn

    Finding Domain on a Solaris box

    Hi, Real Newbie question, but Im installing an appa on a solaris box and its asking fro the Domain of the box? How do I find this on Solaris? John [smile]
  14. scottyjohn

    Hows to get descriptions of tables out of Oracle

    Hi there, Im looking for a way to get an export of the fields which are in the tables of our Database and I have very basic SQL knowledge and read only access. Is there a simple SQL command to get this info or a utility? John [smile]
  15. scottyjohn

    ID two records and subtract time fields

    Hi all, I have an oracle viewas per below.... CREATE OR REPLACE VIEW v_login ( employee_id, place, event_desc, eventdate, "TIME" ) AS SELECT P.EMPLOYEE_ID, L.NAME, CASE STATUS WHEN 0 THEN 'LOGOUT' WHEN 1 THEN 'LOGIN' ELSE...
  16. scottyjohn

    Querying a time range

    Hi all, I have a view which has the following columns, STARTTIME ENDTIME The data is in the format hh:mm:ss but I think it is actually in text format rather than time as such. The underlying table has this column in UTC, and a conversion is done in the structure of the view to give us the...
  17. scottyjohn

    Small Form Factor Graphics Upgrade

    Hi all, I have a desktop HP DC7100 SFF PC which uses integrated graphics and I want to upgrade the graphics to something decent. Trouble is I cant find many half height card options? If this will be a problem, I was thinking of moving its guts to a tower I had sitting but Ive noticed that the...
  18. scottyjohn

    Inserting a whole html page into a frame

    Hi all, I have generated a bunch of flash galleries (photoshop elements)which seem to me to be rather complex in the way they are structured so I have put each one which has its page, the swf files, and all the resources under a seperate folder for each in my site. My plan was to make a master...
  19. scottyjohn

    TO_CHAR query help?

    Hi all, I am trying to get some training material on the whole TO_CHAR and TO_DATE functions of Oracle DBMS but in the mean time I need help with the following query? I have a view which has a date field defined as TO_CHAR(TO_DATE(STARTLOCALTIME,'DD/MM/RRRR HH24:MI:SS'),'DD/MM/RRRR') as...
  20. scottyjohn

    TO_CHAR query help?

    Hi all, I am trying to get some training material on the whole TO_CHAR and TO_DATE functions of Oracle DBMS but in the mean time I need help with the following query? I have a view which has a date field defined as TO_CHAR(TO_DATE(STARTLOCALTIME,'DD/MM/RRRR HH24:MI:SS'),'DD/MM/RRRR') as...

Part and Inventory Search

Back
Top