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

    migrate to pg

    im looking for an sql script that will help migrate from ora to pg. tables, triggers, keys, and data... I call on the great santa mufasa (it is that time of year ;))
  2. jjpetrucelli

    control length of select box

    I want to query the db and output the results into the options of a select box. Now the values are going to be quite long and will cause horizontal scrolling, which is not desireable. What is the best way to account for this? I am thinking that while outputting the results i should look for a...
  3. jjpetrucelli

    sql output

    I am attempting to output for a mysqlimport, what i am trying to do is concat all fields into a long string. the results either by saving the output or spooling to a file, is that i get breaks in the output. when i try to import this creates many problems. The breaks do not appear to be...
  4. jjpetrucelli

    grub on sata master, ide slave

    im attempting to setup gentoo linux on a sata master and ide slave. I am also using grub. What should the settings be for device.map, the grub.conf and the commands for the grub command prompt (to install to the mbr)? I am specifically looking for what to specify for root and kernel...
  5. jjpetrucelli

    CGI vs Module

    Im not finding any information that can lead me to the difference between installing PHP as CGI or a Module. I have info, it just hasnt been enough for me to understand. I am not familiar with the effects of the differences. I am transforming a site from CF to PHP and I know that within the...
  6. jjpetrucelli

    view / update on one page

    i have a system now that is viewable to the public but you can also login, for simplicity lets say the public (non login) can view info and if you login you can update. the system currently has the pages coded twice, once for view and once for update. This can cause problems if you were to...
  7. jjpetrucelli

    migrate from oracle

    i have an oracle db and i would like to recrete and modify the db in mysql and then transfer the data from oracle to mysql. What is the best way to do this? i know there are programs out there but i hear that they dont do a 100%? suggestions?
  8. jjpetrucelli

    training and config

    2 q's can anyone recommend a good apache boot camp or refrence book? I need to learn apache quick Also I know it is recommended that components are seperated but i'm looking at apache, mysql, and php. Could any of these be combined in a professional setting? Of course they can but if I were...
  9. jjpetrucelli

    zend certification

    you heard of zend certification, they claim to standardize the certification for php. Im looking for reivews, and havent run across any. They seam REAL cheap for a cert. Any opinions? Although its cheap I would hate to waste time / money...
  10. jjpetrucelli

    AS install / GUIDE

    the object here is to work with portal, so i need to set everything up. It appears that i need to setup AS infrastructure, BI and forms and DS. I have installed the infrastructure declared a home, instance and login. I then logged into OEM via a browser (http://<hostname>:1810/) with the...
  11. jjpetrucelli

    errors = installation?

    I am attempting to follow the oracle by examle docs for 9iAS. On a clean, standalone computer I have; added to the primary dns suffix of the computer, added the ip and host name to the hosts file, installed the Ora9i AS infrastructure - name = Ora9ias_home - path = d:\ora9ias - instance name =...
  12. jjpetrucelli

    data dictionary

    what script can i use to provide a complete data dictionary? I am running Oracle 9i
  13. jjpetrucelli

    data dictionary

    what script can i use to provide a complete data dictionary?
  14. jjpetrucelli

    simple and & or

    i have a query that goes a little something like this; SELECT t.id, t.name, ts.id1, ts.id2, ts.test_name, e.id3 FROM table t, table b, table ts, table e WHERE t.id = b.id AND b.id1 = ts.id1 AND b.id = e.id AND b.id1 = e.id1 so thats ok but i need to add onto the end of it something that says...
  15. jjpetrucelli

    General Ora AS - DS ?

    We have a web based Ora DB, all the web pages are written in coldfusion. We are now told that the coldfusion has to go and everything needs to be done with the oracle tools. I didnt get any specifics but im assuming the Ora AS enterprise (portal and such) is what they were referring to. Am I...
  16. jjpetrucelli

    outer joins & and / or

    I want to follow a users progress. I want to find all of the tables where he is listed in the 'created_by' or 'updated_by' fields. To accurately analyze this data I will also need to know some key things about some of the tables. I am looking at something like this; SELECT t.name, s.name...
  17. jjpetrucelli

    ouput of dd cols

    I have comments in the oracle dd and i want to ouput the dd column comments on a webpage in a specific order and some column comments i may or may not want to include (based on a cfif tag). So how could i order those comments so in theory select col_com from user tab_columns ouput #col_com...
  18. jjpetrucelli

    get 2 progs to use one com port

    I have a gps and i want to use two mapping programs to use the gps at once. I have heard talk of virtal port redirectors and what not but I cant find anything cheap enough! So the problem arises exactly when i start ms streets and trips and rand mcnally, i can connect only one of the programs...
  19. jjpetrucelli

    track usage

    i have CF with an oracle back end. I want to track who logs in and how long they are logged in. I dont specifically want to know how long they are logged in because that could be misleading. Being that theres a timeout on the login they could login, walk away and then get timed out, but...
  20. jjpetrucelli

    su and regular users

    when i login as root i cant reach the internet, my wireless isnt even lit up. When i login as the regular user i can see / use my wireless. I can start some programs as regular user but then when im root i get errors such as 'no protocol specified'. I often switch between user and su so that...

Part and Inventory Search

Back
Top