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

    Oracle Forms and Windows Terminal Server

    Can I launch an Oracle Forms app within a Windows Terminal Server session from my client ??
  2. Leon1977

    Problem starting a Job against Aix 4.3

    Problem starting a Job against Aix 4.3 from OEM 9.2 errror message : VNI-4002 : Unknown gateway exception VxxdCryptoSessionException: SESSION_UNAVAILABLE Any idea
  3. Leon1977

    Problem with Data Guard Manager

    Hi all I am trying to make a standby database using Data Guard Manager, but unsuccessfully. Here is the environment. In the Enterprise Management Console I've discovered both nodes /AIX 4.3/ One of them /primary/ have a database installed /Oracle 9.2/ the other one has no database and no...
  4. Leon1977

    Enterprise Manager Console can not discover a database

    When I run a discover nodes with Enterprise Manager Console it finds the node but it can not find the listener nor the database, but it finds other databases. Both Enterprise Manager Console and Databse are 0racle 9.2.0.1.0 on Windows Any ideas
  5. Leon1977

    Help on SQL statement

    I have a table with this data varchar2(1)| date | date -----------|--------|-------- a 12:10 12:11 a 12:12 12:12 a 12:14 12:15 b 13:10 13:11 b 13:12 13:12 b 13:14 13:15 a 14:10 14:11 a...
  6. Leon1977

    Cimplicated Join Query

    Hi all I can not figure out a query. Any help would be appreciated. So I have two tables Obligations and Payments In Payments we have several or no rows pointing a single row in Obligations they look like this Obligations Payments ----------- -------------- obligation_id...
  7. Leon1977

    How to kill a session variable

    How to kill a session variable
  8. Leon1977

    Sysdate format

    Hi folks I need to get todays date in PL/SQL but sysdate returns date & time so I think I must truncate it somehow. Can you show me the way to do this
  9. Leon1977

    Drawing a CHART using EXCEL COM Object

    Hi I am using Cold Fusion 4.5 and I want to draw a line chart. So i've decided to do this using Excel COM object I tried several aproaches but no result Any help (code) will be more than helpfull Thanx in advance
  10. Leon1977

    Visualisation ideas /charts/???

    Any idea how could I draw a chart from database values within ColdFusion web pages
  11. Leon1977

    Help with Recursive query

    I have a tree table with such columns id, name, fk_id where the "fk_id" column references the "id" column I need a select statement that you get all branches by id for example: id name fk_id --- ----- ----- 1 one 1 2 two 1 3 three 1 4 four 2 5 five 2 6...
  12. Leon1977

    Select Last 10 records

    I have an ID autonumber column in a TABLE, with lets say 100 rows from 1 to 200 (some of the rows ar mising) so I want to display the last 10 records acording to the ID column something like : select * from TABLE where ID > (select max(ID)-10 from TABLE) but this doesn't do becouse it could...
  13. Leon1977

    Foreign key to another schema

    Is there a way I can point a foreign key to point to a column in a table within a different schema I have the SELECT option granted. Do I need some other object priviledge
  14. Leon1977

    MS ACCESS SQL code ??

    I need to write a Create table SQL script for MS ACCESS but I need a autonumber field and a double (fixed 2) How should I define theese datatypes Create table table_name( id int primary key /autonumber/, price float /fixed(2)/ ) something like this
  15. Leon1977

    HELP with Select statement

    I have something like this name phones --------- --------- Bob 5552626 Bob 6668654 Bob 7586666 Select name, phone from names n, phones p where n.name_id=p.fk_name_id and Upper(name)=Upper('Bob') Is there a way with a single query I can get this result name...
  16. Leon1977

    Querieng MS Access Query from Cold Fusion

    Is there a way I could call a saved MS ACCESS query from Cold Fusion. I want to send a parameter to the query and then receive the answer(s)... If yes which version of Cold Fusion it applays on.
  17. Leon1977

    Help on trigger

    I want to make a trigger before delete I have departments and PERSONS with foreign key to departments so before deleteing a row in departments I want to Upadte the the foreign key in PERSONS to point somewhere else.. create or replace trigger Department_Triger BEFORE delete on departments...
  18. Leon1977

    Oracle DBA 9i ebooks

    Does anybody know Where I can download Oracle DBA 9i ebooks from?
  19. Leon1977

    AutoNumber in ACCESS

    I need to write a Create table SQL script for MS ACCESS but I need a autonumber field and a double (fixed 2) How should I define theese datatypes Create table table_name( id int primary key /autonumber/, price float /fixed(2)/ ) something like this
  20. Leon1977

    Parsing a Cold Fusion variable

    Can I parse a Cold Fusion code in an variable?? For example <cfset ivan=&quot;<cfset mitko=10>&quot;> <cfoutput>#ivan#</cfoutput> <cfoutput>#mitko#</cfoutput> but it don't work. Is there another way to do this, with some tag maybe ???

Part and Inventory Search

Back
Top