(Advanced Search)
for
Home : Products : DBMan : Customization :

Products: DBMan: Customization: Re: [knue] Displaying data from one DB on the same pg as data from another DB.: Edit Log

Here is the list of edits for this post
Aug 14, 2016, 8:42 AM
delicia
Enthusiast (661 posts)
Aug 14, 2016, 8:42 AM
Views: 17187
Re: [knue] Displaying data from one DB on the same pg as data from another DB.
Code:

$cols2 = 'Lock,ID,Date,Time,Userid,Quick_notes,Company,Contact,Callback,Notes';
@db2_cols = split /,/,$cols2;

$db2_file_name = $db_script_path . "/../db/notes.db";
$db2_key_pos = 5;


are the fieldnames correct above? they must be in same order they appear in your cfg file. Company is 6, not 5 in that list.
in case contact is blank, change:
Code:
if ($rec2{'Contact'}) { print qq|, $rec2{'Notes'}|; } # I did not notice this was and if statment.
to

Code:
print qq|, $rec2{'Notes'}|; # I did not notice this was and if statment.
you probably don't need the sort by and sort type statements either, or your sort by would be by date?
going to play golf now!

Last edited by:

delicia: Aug 14, 2016, 8:46 AM

Edit Log: