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 Chriss Miller 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. Schoover

    Simple Newbie Forms Q?

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

    Simple Newbie Forms Q?

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

    Two VARCHARs -> One CLOB

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

    Simple Newbie Forms Q?

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

    Array perl issue

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

    Array perl issue

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

    Array perl issue

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

    Array perl issue

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

    Array perl issue

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

    Net::SSH::Perl (yeah...again)...have you seen this?

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

Part and Inventory Search

Back
Top