Recent content by yim11

Hello, I am working on a view in Notes [4.6a] and am having trouble with a formula. The formula I have now is: SELECT Form="Sample Login"&deliver!="China"&(DateReceived>=[07/01/2002]) Which works well, but the manager wants a little more added to it... Specifically, I...

Hello, I have been given the task to try and figure out why an application we have at work will not work on 1 users workstation. The workstation is Windows 98SE. The application was written in VB, and the version of Oracle is 8. The error is when trying to logon to the database, after the...

Thanks for your response. I think I maybe in over my head on this one. Lotus has no documentation on Define Globals at Event Initialize, so I may have to outsource or scrap this one. Thanks again!! -jim

Hello, I am working on a field that I need to start and increment a count. More specifically: I have a field called 'Evaledby' where a persons initials are entered when they are assigned to an evaluation. What I'm trying to do is add a day count next to that field...so that when a persons...

Hello, I have the following script (posted below) that works for the most part, but fails when searching for the Business Name, Contact Name, or Contact Phone fields. Searches using the Type or Center fields work as expected. For example - the database has a text field called...

Hello, I have a script I need to use that utilizes the flock funtion. I understand that the activestate perl install on windows does not use the flock command, my question is does anyone know a way to get around this or to allow the use of flock on a windows machine? The section of code that...

Hello, If my perl scripts are on 1 server, and the SQL database I need to talk to is on a different server, is there a way via DBI to connect to that database? Something like: my $DSN='dbname'; my $user = "loginname"; my $pass = "password"; my $DBD='ODBC'; my...

Thanks very much! Everything is good to go!

Thanks for the reply, I added the my $scan = shift; at the beginning of the subroutine, and took the parens off the return $output, but still no luck getting it running. : ( Thanks for responding so quickly! -jim

Hello, I have the following script shown below that ~should~ convert a string of text. The conversion subroutine works fine, I just cannot figure out how to pass the $scan variable into the subroutine and get the sub to return the converted string ($output). The $scan variable comes from a...

Hello, I have the following guestbook, that works great - except new entries in the book are added to the bottom of the page, and I would like to change the script so that new entries are displayed at the top of the page. Any and all help with this is greatly appreciated! TIA! -Jim ---Begin...

Hello! I have Perl script that talks with the Northwinds example database in MS Access using an ODBC DSN of Northwind. My problem is that the script only returns the first 4 values from the database table when run. My question is how can I fix the script to display all the results? Many...

Thank You Very Tom!!! I _really_ appreciate all your help (again)!! I'm working on doing translation code with $scan as the input now. Hope to be good to go soon! Again, THANK YOU very much! Jim

I apologize, its monday. I have a script, called catscan.pl, that runs from command line. When run it waits for a barcode swipe from a Cuecat barcode reader. The untranslated scan looks like ".C3nZC3nZC3n3C3vZENv2CNnX.fHmc.CNnWDhj1C3nZC3bW." The translated scan would be...

Thank you very much for your reply! I was thinking faster than I was typing when I posted :) I was told that using a subroutine for the cuecat translation section would be my best bet, but wasnt sure how to do that. It all seemed so simple when I started... I had a small script that when ran...