Search results for query: *

Or does anyone know of any other way I could display (on a form) the records from an external table?

Thanks BJ, I had read about the display error thing, but on my first few test forms the menu would not drop down to select it...... I just threw together another test and I was able to display error this time. The one thing I neglected to mention is that I was going after an external table...

simple example to get you started hopefully. UPDATE mytable SET mytable_clob = EMPTY_CLOB() where mytable_id = id_in; commit; --now lock the row so we can write the CLOB begin select mytable_clob into mytable_clob from mytable where mytable_id = id_in...

Can you write a simple query form to pull/display data, 1 row at a time, from a table that does not have a unique primary key? I seem to have no trouble doing simple forms for other tables which have keys, and in my simple testing, can display records 1 at a time using the 'execute query' then...

if your grouping your emails by recipient and cp_id, then why not just group by those 2 fields...and drop the keytype and message from the groupby statement? if I were writing this, I would probably use hashes like Trojan said but that would require much more explanation here. So from simple...

Ok....so let us know if you can get a Group By query to work, if not, then Trojan's idea will work better for you.

P.S. are you using DBI:DBD to do your database stuff in perl? (i'm assuming you are at this point)

Well a sample group by would look something like this: Select EMAIL, KEYTYPE, MESSAGE, CP_ID from mytable where <criteria> group by cp_id (or would you want to group by email addy?) (from your example either way would work) Your Database should support Group By, I think its standard stuff for...

Or just add a "group by" to your query, then as you loop through records, store the cp_id in a hold_cp_id and if cp = hold then concat. the build the msg bodies and send when cp_id changes.

Hi All, I have searched and read all the old posts on this module. However I'm still having this problem, seemingly regardless of the host/client OS. Below is my debug output, it seems to hang on some kind of key exchange, and I've went as far as to turn most of the ssh options off, with the...