Recent content by TStriker

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

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

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

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

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

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

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

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

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'))...

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

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

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

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

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

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>")...