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!

Register Log in
  • Congratulations derfloh 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. TStriker

    Selecting a partial set

    Quick question: I've been tasked with exporting about 140K records in batches of 50K. SELECT ... where ROWNUM <= 50000 seems to work fine but SELECT ... WHERE ROWNUM > 50000 doesn't return any rows. Any ideas how to break the set up into chunks of 50,000 rows? -Striker
  2. TStriker

    Tab Control tab positioning leaves something to be desired

    If I understand what you're asking I think you just highlight the text and then align right or left or whatever. There's nothing special although I can't remember using anything other than centered myself. -Striker
  3. TStriker

    Move from Filemaker server to Network or other option...

    You will find FM to be in a whole different world from other SQL based databases. Version 5 is pretty old right now. It's so old that there is only 1 table per file although the tables (files) can be related to each other. Ever consider just exporting everything to Excel and cracking open the...
  4. TStriker

    Replacing Characters in Long Data Type

    I'm afraid that it would be like asking for a fresh coat of wax to be put on an automobile that is bound for the salvage yard. The software is dead, they aren't even trying to sell it anymore. Their hope is to sell us on a different package that they offer. -Striker
  5. TStriker

    Replacing Characters in Long Data Type

    Mufasa, The database is part of a shrink-wrapped ERP system and was designed many years ago by others; I assume back in the days before CLOB. The ERP software is comatose as there is no new development but it still is supported by the vendor. I'm sure that if I made structural changes to the...
  6. TStriker

    Replacing Characters in Long Data Type

    Rookie Oracle guy here. I want to replace a set of characters in an Oracle 10g long data type field with another set of characters. In plain english, it's like changing the word DARKNESS to SUNSHINE everywhere DARNKESS appears. This would be easy in a Varchar field but sadly for me it's in a...
  7. TStriker

    Need help with SQL

    The query is intended to place a vendor's main phone number onto a purchase order. The vendor can have many numbers; VOICE, FAX, MOBILE, etcetera and each vendor can have more than one of each type. This means that the query will return zero or more VOICE numbers. I only have room for one...
  8. TStriker

    Need help with SQL

    Nevermind, this seems to work: SELECT * FROM ( SELECT AREA_CD, PHONE_NO FROM VEND_COMMCN WHERE COMMCN_TYPE_CD = 'VOICE' and VEND_NO = (SELECT VEND_NO FROM PURCH_ORD WHERE USER_ORD_NO = '78092') ORDER BY updt_dt_time DESC ) WHERE ROWNUM = 1; -Striker
  9. TStriker

    Need help with SQL

    I have a rather simple query: SELECT ven.area_cd, ven.phone_no, ven.updt_dt_time FROM vend_commcn ven WHERE ( (ven.commcn_type_cd = 'VOICE') AND (ven.vend_no = (SELECT vend_no FROM purch_ord WHERE user_ord_no = '78092'))...
  10. TStriker

    Sorting with PHP

    SUCCESS! Thanks for the help guys. It's embarrassing just how little I know about PHP and especially arrays. I'm going to have to study your work and see if I can figure out how and why it happens. Thanks again. -Striker
  11. TStriker

    Sorting with PHP

    Okay, obviously I'm in over my head on the PHP stuff because now it is returning results but it's not sorted. Here's what I have: $connect = ldap_connect( $ldap_host, $ldap_port) or exit("<p>ERROR: Could not connect to LDAP server</p>"); ldap_set_option($connect...
  12. TStriker

    Sorting with PHP

    Now the word "Array" appears in each cell. -Striker
  13. TStriker

    Sorting with PHP

    I tried jpadie's last suggestion and no errors but all it produces is a big set of empty opening and closing TD tags -- no content. I'm not enough of a PHP guy to figure out what the problem is. -Striker
  14. TStriker

    Sorting with PHP

    feherke, Didn't work for me. I'm getting a parse error. I strongly suspect that the problem is that you're thinking I know more than I really do. Is there any way to simplify the answer? -Striker
  15. TStriker

    Sorting with PHP

    Hi all, I'm a real rookie at PHP. I've done an LDAP query on Active Directory but cannot figure out how to sort the results. Here's what I have so far: // ====== P R O C E S S ====== $connect = ldap_connect( $ldap_host, $ldap_port) or exit("<p>ERROR: Could not connect to LDAP server</p>")...
  16. TStriker

    Wanna see some odd behaviour

    My solution was to uninstall Acrobat and make a paper form. I just didn't have the time to fool around with it and I don't usually have much need for Acrobat anyway so it was easier to just plain old do without. -Striker
  17. TStriker

    Wanna see some odd behaviour

    I using LiveCycle Designer on the 30 day evaluation so I'm a complete rookie but I've got to think this is odd: http://www.screencast.com/users/DougLarsen/folders/Jing/media/644d9b90-0500-4a99-86c5-4867c02c9b16 -Striker
  18. TStriker

    Reasonable Training Expectations

    I agree with melmitts on the training videos. These are relatively cheap and take you from beginning to end in a pretty straight line. I would guess that your guy should be fairly competent by the end of the series. I think Filemaker may come more quickly and with less pain to someone with no...
  19. TStriker

    FileMaker Server 9 on VMWare

    A month or so back FileMaker Inc held a webinar on this very subject. I believe it was open to the general public and I believe it is available for viewing on their website. http://www.filemaker.com/support/webinars/seminars.html#advanced_users The bottom line is that it is a good practice if...
  20. TStriker

    Making a Calendar

    When I make all the cells the same height using this method: <td style="height: 20px;"> The cells are all 20px high which is good but if they contain more content than can be squeezed into 20px then that particular row grows in height but the other rows don't. I was looking for a way to make...

Part and Inventory Search

Back
Top