Alright, this is really bending my brain. I have the following code: 
            my $crconn = Win32::OLE->new('ADODB.Connection');
            my $crrs = Win32::OLE->new('ADODB.Recordset');

            $crconn->open("Credentialing");

        my $lastname = $rs->Fields("LastName")->{'Value'};
        $lastname =~ m/^\b([A-Za-z]+)\b(.*)$/gi if ($lastname);
        my $rsID = $rs->Fields("ID")->{'Value'};
        my $sql = "SELECT * FROM [PHYSICIAN TABLE] WHERE ";
                $sql .= "[PHYSICIAN TABLE]\.[LAST NAME] LIKE \'\*$1\*\
+';";
        print SQLLOG $sql, "\n";

        $crrs = $crconn->execute($sql);
        print LOGFILE "Foo!\n Win32::OLE->LastError()\n" if (Win32::OL
+E->LastError());
        
        if ($crrs->eof) {
            # start matching based on the last name
            # now would be a good time to use the misspelling module f
+rom CPAN
            # this will be done at a later time

            $finalmatch{$rsID} = "No Match By Last Name";

        }

[download]
whose sole purpose is to take the last name from the first recordset $rs and grab the first
'wordish' chunk and build a SQL statement around said chunk and query an Access database for any matches.
if it doesn't find a match, then it throws the ID field from $rs into a hash, with the appropriate message.

Now, I have the SQL print out to a file, and when I physically test the queries right in Access, they return values,
here in the program, it doesn't seem to return any values. Is this a problem with my code? Or should I look elsewhere?


Thanks in advance,
Maurice

In reply to SQL Is Not Returning Any Records by buzzcutbuddha

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.