Re: Rev cgi search question

2008-01-15 Thread Richard Miller
Thanks. A few other questions about using Rev in the cgi-bin. Can a Rev cgi script use the launch command to run a small Rev app from inside cgi-bin? Do I understand correctly that several instances of the Rev cgi application can be running concurrently? In other words, the server could

Re: Rev cgi search question

2008-01-15 Thread Andre Garzia
Richard, using 'launch' is not advisable. Not only every instance of your cgi will start it's own program but there's a big chance that your cgi is running as 'nobody' or 'apacheuser' or some other very limited user on your server (this is a good thing, it's security wise to put the cgi user on a

Re: Rev cgi search question

2008-01-15 Thread Richard Miller
Thanks, Andre, for the extensive reply. I'll study it and get back to you if I have any questions. Richard On Jan 15, 2008, at 10:47 AM, Andre Garzia wrote: Richard, using 'launch' is not advisable. Not only every instance of your cgi will start it's own program but there's a big chance

Rev cgi search question

2008-01-14 Thread Richard Miller
I'm looking for suggestions on how to accomplish the following. 1. User starts a search of my text-based database (via browser and Rev cgi). 2. My app finds the results (which are a series of line numbers... possibly as many as 1000) 3. I now want to store those results so that when the user

Re: Rev cgi search question

2008-01-14 Thread Len Morgan
If I understand what you're trying to do, I've done something similar (but not with Rev) and it worked quite well. What I had returned to the user was a table of dates of commissary sales data. Only the dates and the total sales for the day were shown. I created a simple HTML table where

Re: Rev cgi search question

2008-01-14 Thread Richard Miller
Len, I understand your solution, and to an extent, I've already implemented it. But my situation is different than yours (if I understand what you are saying). In your case, it seems that the date links were able to retrieve sales data that was either already available or easy to

Re: Rev cgi search question

2008-01-14 Thread Kee Nethery
We do stuff like this all the time. caching data locally. The deal is we store last datetime changed for each row in each table in our database. Every time the row gets changed the datetime gets updated. The various systems that use the data search the local data cache, not the external