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!

Recent content by jjpetrucelli

  1. jjpetrucelli

    migrate to pg

    wow, i really dont know what to say. please dont go through too much trouble for me, when and what ever you can back to me is more than fine. i surely do appreciate your help
  2. jjpetrucelli

    migrate to pg

    how can i account for line breaks and quote/double quotes in the value? I believe i somehow need to escape them but im not sure how...?
  3. jjpetrucelli

    migrate to pg

    can you elaborate on 'sql-writing-sql scripts'? are you saying to just manually create the queries and concat 'insert into' in the appropriate places? or something else? I have attempted to do the manual way and ran into some difficulties dealing with line breaks and quotes in the values ...
  4. jjpetrucelli

    migrate to pg

    oh i apologize, its postgresql, and its quite similar to oracle. sorry for the lack of clarity. to further explain i am looking at an sql statement rather than a program or perl script due to connection barriers to the ora db.
  5. 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 ;))
  6. jjpetrucelli

    control length of select box

    well css isnt looking like the right way to go so i am concentrating on the php solution. for simplicity lets consider the following; 1 $results=mysql_query($query) 2 or die(mysql_error()); 3 while ($rows=mysql_fetch_assoc($results)) { 4 foreach($rows as $val1) { 5 echo...
  7. 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...
  8. 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...
  9. 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...
  10. jjpetrucelli

    CGI vs Module

    i like this quote from the linked page; "If you aren't familiar with managing setuid root programs and the security issues they present, we highly recommend that you not consider using suEXEC." I think that was written specifically for me, so it sounds like I want php as a module?
  11. jjpetrucelli

    CGI vs Module

    ericbrunson or anyone ~ the pro's of both mod and cgi sound interesting, of course both speed and security are of major interest. Can you give me an example of a scenario of when the php script can run under different user permissions than the web server? Im trying to figure out if i can go...
  12. jjpetrucelli

    view / update on one page

    we have sensitive data, our audience spans from coast to coast and deals with many 'different type of people' with various infrastructures and knowledge - from almost non existent to top shelf. public can view table x col1, users with privilege x can view table x and y cols1-4, privelage y can...
  13. jjpetrucelli

    view / update on one page

    yeah vpn is not an option, and of course with any case the best security is to unplug the server and bury it in concrete. Its all about defining the risks, and evaluating what is acceptable ;) Sounds like the IP tracking can cause problems if used with a wide audiance - routers, dynamic ip...
  14. jjpetrucelli

    view / update on one page

    hey, never mind got that link ~ it was me
  15. jjpetrucelli

    view / update on one page

    that link doesnt seem to be working although I am attempting to check out the articles from shiflett, thanx for the refrence. Im not sure exactly what to do here, i inherited a system. Now lets say that i wanted to keep as much as possible away from the client, for user friendly purposes...

Part and Inventory Search

Back
Top