and as Charleton Heston might say:
For the love of God, man... always use a WHERE clause
Really... get in the habit of using WHERE in ALL your SELECT INSERT UPDATE DELETE's... or you will be get burned sooner or later, it is easier to fix one record than the whole DB :-)
Load the results of you query into a perl variable, massage them and THEN open a new connection... and you will do yourself a big favor by just doing some simple error checking:
my $db= new Win32::ODBC("MyDSN") or die "DSN failure, is MyDSN defined
+? Error: ?!";
#Get me everything in the world
$db->Sql("SELECT * from table") or die "SQL Error: $!";
...

[download]
I wonder why you would be given a task that requires you to update if you can't test it on something however... this is really the odd part... Good luck :)

In reply to Re: Query twice by JamesNC
in thread Query twice by abhishes

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.