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

  1. danielrc15

    How do I share files between vhosts?

    Hi, I have a vhosts set up, of several domains each in their own vhost. What I need to do is share my php scripts across the vhosts, as I don't want to have to create copies of the files and store them in each vhost. I want to share my db config and php function scripts across vhosts. So...
  2. danielrc15

    SQL Question - maybe requiring lead and rank

    Hi, I have a problem, I have the following 2 rows: Start Date End Date Item Used 10/05/04 10/06/04 A 10/05/04 10/10/04 B As you can see the usage of items A and B overlap, both items A and B are used at the same time for a while, but the usage of A stops after a while and...
  3. danielrc15

    Courrupt SPFILE & no backup - what next?

    Hi, Thanks for all your help. I ended up solving my problem by using another XP machine, installing 10G again with exactly the same folders and set up as my problem machine, I then copied over the SPFILE to the problem machine and it started working again. Daniel
  4. danielrc15

    Courrupt SPFILE & no backup - what next?

    Thanks for the reply. The only problem is I keep getting: ORA-12560: TNS:protocol adapter error When performing the: SQL> startup nomount pfile='init.ora' Could screwing up the spfile and then rebooting really start me getting TNS adaptor errors? Daniel
  5. danielrc15

    Courrupt SPFILE & no backup - what next?

    Hi, I am running 10G on Windows XP, I edited my SPFILE by mistake, and now I believe it is corrupt. The DB will not startup, all I can do is SQLPLUS /NOLOG. How can I start my DB back up? Thanks Daniel
  6. danielrc15

    How do I write this sub query in MySQL???

    HI, I have this subquery written in Oracle SQL, can anyone tell me how to write it in MySQL v3 syntax? Thanks Daniel select count(a.id), (a.vl) from rqf_16_4_40_tce_test a where a.vl < 40000 and a.id IN (select id from rqf_16_4_40_tce_test_mut b where b.region_name = 'PR' and mutation='49Y')...

Part and Inventory Search

Back
Top