Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

Re: MS Access entry index key values

by Rich36 (Chaplain)
on Jul 09, 2002 at 16:22 UTC ( #180531=note: print w/replies, xml ) Need Help??


in reply to MS Access entry index key values

Your SQL looks fine (although I think the words SELECT, FROM, and WHERE should be capitalized). The problem is that you need to execute the SQL statement, then assign the returned information to a data structure.

The code below will push the data that gets returned into a hash for each row, which you can then use to get a number. In this case, it looks like you would only have one row returned but the code below allows for multiple instances of the value.

my @rows; die qq(SQL failed: ), $db->Error(), qq(\n) if ($db->Sql("SELECT srv_id + FROM server_tbl WHERE srv_name='$srv'")); while ($db->FetchRow()) { my %data = $db->DataHash(); print qq(Index key is $data{"srv_id"}\n); #srv_id value # If you want to store information from multiple rows push @rows, {%data}; }

You should also check to make sure that your first SQL statement happened correctly. Check out Web Deployment Schemes for some examples on how to work with Win32::ODBC.

«Rich36»

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://180531]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (3)
As of 2021-04-13 06:48 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?