Recent content by jkuhns

Try: $sql = "select something1, something2 from [some-file]"; While I think this will work for you, it introduces another question. What's the proper SQL format for a field name with a dash which is also an array? I'm neck deep in hibernate mappings and have not yet run into this situation, but...

I am using Tomcat 6, Progress 10.1C. Here is the realm setup from my server.xml file, edited for readability, the connection is made, the query fails: <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99" driverName="com.ddtek.jdbc.openedge.OpenEdgeDriver"...

Wouldn't this be an excellent situation for SQL92? Alternatively, write code to create a batch file calling your .P using session parameters for your inputs. Have it write out the results to a text file (or HTML content) and then use type in the batch file to throw the results back to PHP via...

I just wrote a lot of code for dynamic browses, so I know the frustration. If you're going to work with more than one on a window, I'd suggest using temp tables to keep track of the handles and names. This will come in particularly handy if you want to use ROW-DISPLAY logic. For the task at...

I really appreciate the insights so far, I hope I'm not pushing it with this post. I'm on to working with the developer events. I've got one browse that I want to toggle a field in all the rows if: the chosen column is a logical the chosen column is editable the click is on the column header...

Thank you both for your suggestions. I just discovered that the developer events (U1-U10) can be applied in my code, so I'll be using them for what I need. Another interesting note, and this is a little weirder. Since I was digging/playing with this, I tried defining a trigger for ROW-DISPLAY...

The idea was to make some reusable code in an include. Throw a frame on a form and call a proc to create the browse dynamically. All works just fine, but I'd like to establish an easy mechanism to get notified of most or all events from the browse back to the window, preferably through applying...

10.1C Windows. I've created a dynamic browse thus: CREATE BROWSE hBrowse ASSIGN FRAME = hFrame FONT = 8 ROW-MARKERS = FALSE MULTIPLE = TRUE QUERY = hQuery NAME = ttName TITLE = IF cTitle = "" OR cTitle = ? THEN ? ELSE...

Both examples work in 10.1C.

Found this problem as well. Here's my workaround: DEF VAR batFile AS CHAR NO-UNDO. batFile = OS-GETENV("TEMP") + "\" + someVar + ".bat". OUTPUT TO VALUE(batFile). PUT UNFORMATTED commandLineVar. OUTPUT CLOSE...

That does it, thank you very much.

The information in this thread has proven very helpful, but I'm left with one question in regard to this piece of advice: My question is not how to schedule a task or add a cron job, but what command line to use for the task? I've tried 'echo 2 | dbtool <dbname>' and it does correct any...

I'm having a little problem with dump_df in 10.1C. No matter what I try, it always ends with a "Press spacebar to continue." I need this to run totally unattended, what am I doing wrong?