Search results for query: *

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

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

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

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

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

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