w3systemsDevelopment: openForms/lookup.hpp Source File

00001 /* 
00002   lookup.hpp
00003   
00004   ----------  
00005   One function call to lookup data in a table 
00006   
00007 */
00008 
00009 #ifndef LOOKUP_HPP
00010 #define LOOKUP_HPP 
00011 
00012 #include "read_base.hpp"
00013 /*
00014   Used to lookup a value based on an id in a lookup table
00015 */
00016 string tableLookup ( string sql )
00017 {
00018   string ret;
00019   quickQuery qqry;
00020   openRS & rs = qqry.getData(sql);
00021   if( qqry.opened )
00022   {
00023     ret = rs.getField(0).format();
00024     rs.close();
00025   }  
00026   return ret;
00027 }
00028 #endif
00029