Flagging updated database entries

Hi,

I have a series of searchable genealogical databases for births, marriages
and deaths and I wondered if there was a way of flagging updated entries so
that a user could see that the information had been changed. That's not a
problem with new entries, as I can filter by RECNO() in the database,
and I'm thinking there must be a simple solution that's eluding me to mark
existing entries that have been changed. Ideas?

Thanks

John Brebner

<A HREF ="http://www.brebner.com">http://www.brebner.com</A>

Flagging updated database entries



A timestamp-column?

Markus



-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf
Of John Brebner
Sent: Saturday, October 16, 2004 10:24 PM
To: [email protected]
Subject: [meu] Flagging updated database entries

Hi,

I have a series of searchable genealogical databases for births, marriages
and deaths and I wondered if there was a way of flagging updated entries so
that a user could see that the information had been changed. That's not a
problem with new entries, as I can filter by RECNO() in the database, and
I'm thinking there must be a simple solution that's eluding me to mark
existing entries that have been changed. Ideas?

Thanks

John Brebner

<A HREF ="http://www.brebner.com">http://www.brebner.com</A>

Flagging updated database entries



Add a boolean field to your database called something like "updated" and
make an index based on it. Change that field to "on" every time the
record is updated. Then open the database with the "updated" index and
display the records that have the update flag checked. Then make a way
to manually reset the records.

Another way is to have an "updated" field that gets updated with the
current date when the record is edited. Then to display the records
that have been changed, you sort by certain date and display all records
that have the "updated" field later than the date you selected.

Scot
<A HREF ="http://www.scotsscripts.com">http://www.scotsscripts.com</A>

John Brebner wrote:
> Hi,
>
> I have a series of searchable genealogical databases for births,
> marriages and deaths and I wondered if there was a way of flagging
> updated entries so that a user could see that the information had been
> changed. That's not a problem with new entries, as I can filter by
> RECNO() in the database, and I'm thinking there must be a simple
> solution that's eluding me to mark existing entries that have been
> changed. Ideas?
>
> Thanks
>
> John Brebner
>
> <A HREF ="http://www.brebner.com">http://www.brebner.com</A>
>
>

OT- question about embeded plugin html



Hi Folks,

In the "src=" part of embedding some media or other kind of browser
plugin file, I noticed a site doing something like this:

<embed src="get_file.pl">
various parameters...
</embed>

They are able to hide their source file and somehow use a perl script to
get the plugin to know what the source file is.

I tried to do something similar with miva script but it is not working
and I wonder if there is some kind of header I need to push through to
get a plugin to recognize a source file in this manner...

Am I making any sense? Any ideas?

Thanks-

Scot

Flagging updated database entries



On Sat, 16 Oct 2004 16:23:56 -0400, John Brebner
<[email protected]> gave utterance to the following:

> Hi,
>
> I have a series of searchable genealogical databases for births,
> marriages and deaths and I wondered if there was a way of flagging
> updated entries so that a user could see that the information had been
> changed. That's not a problem with new entries, as I can filter by
> RECNO() in the database, and I'm thinking there must be a simple
> solution that's eluding me to mark existing entries that have been
> changed. Ideas?
>
Add a field to the database )type CHAR(10) and populate it with s.time_t
each time you write to the record.
You could then build a filtered view which shows records changed since a
given date.
--
Richard Grevers
Between two evils always pick the one you haven't tried

OT- question about embeded plugin html



On Sat, 16 Oct 2004 14:37:47 -0700, Scot Ranney <[email protected]>
gave utterance to the following:

> Hi Folks,
>
> In the "src=" part of embedding some media or other kind of browser
> plugin file, I noticed a site doing something like this:
>
> <embed src="get_file.pl">
> various parameters...
> </embed>
>
> They are able to hide their source file and somehow use a perl script to
> get the plugin to know what the source file is.
>
> I tried to do something similar with miva script but it is not working
> and I wonder if there is some kind of header I need to push through to
> get a plugin to recognize a source file in this manner...
>
> Am I making any sense? Any ideas?
>
Their perl script will have to write a set of headers which would match
what would be sent if the image were called directly - in particular
content-type and content-length. Only Empresa 4.0 + can do this - 3.x
always outputs text/html.
--
Richard Grevers
Between two evils always pick the one you haven't tried

OT- question about embeded plugin html



Is there any way to track what headers are being sent out so I can
duplicate them?

Richard Grevers wrote:
> On Sat, 16 Oct 2004 14:37:47 -0700, Scot Ranney <[email protected]>
> gave utterance to the following:
>
>> Hi Folks,
>>
>> In the "src=" part of embedding some media or other kind of browser
>> plugin file, I noticed a site doing something like this:
>>
>> <embed src="get_file.pl">
>> various parameters...
>> </embed>
>>
>> They are able to hide their source file and somehow use a perl script
>> to get the plugin to know what the source file is.
>>
>> I tried to do something similar with miva script but it is not
>> working and I wonder if there is some kind of header I need to push
>> through to get a plugin to recognize a source file in this manner...
>>
>> Am I making any sense? Any ideas?
>>
> Their perl script will have to write a set of headers which would
> match what would be sent if the image were called directly - in
> particular content-type and content-length. Only Empresa 4.0 + can do
> this - 3.x always outputs text/html.

OT- question about embeded plugin html



Well you could call a script that gives you access to the raw
headers and then dump them to a text file.

Or, you could use a tool that lets you set up sockets and listen
on ports on your local system and then see the raw http
communication.

Example, you go get something like the TCP/IP Builder from
<A HREF ="http://www.drk.com.ar/builder.php, and run it on your local">http://www.drk.com.ar/builder.php, and run it on your local</A>
machine to listen at 127.0.0.1 on port 8001 or something and then
use the following on your html page:

<embed src=3D"http://127.0.0.1:8001/get_file.pl">
various parameters...
</embed>

Then when you submit the page go look in the builder and you will
see the true raw request that would get sent.

But, what is it that you are trying to do for real, what is it at
the core that you want to accomplish by using the embed tag?

If all you are looking for is a way to get the output of a Miva
script on to a plain html page I would think you might want to
consider using Jacussi for that.=20

Basically it uses very simple and widely supported JavaScript,
most critically the almost universally supported document.write,
to display the information on the page.

There is a Miva script specific Jacussi interface and it is
capable of not only letting you do something simple like execute
a Miva script and display output on an html page, but can even
translate Miva script complex aggregates into JavaScript objects.

There is almost no information on the current Jacussi.net website
right now, but there is a simple page devoted to a basic
explanation of how Jacussi with Miva script works. Hopefully we
will free up the resources to get better info, downloads,
examples, etc., on the site as time goes by, for now if you
want/need more info, or want to use the Miva script Jacussi
interface on your site Just let me know.

- Jeff Huber
President 4TheBest eCommerce Solutions
http://4TheBest.com
[email protected]
Office: 760-742-1469
Cell: 760-445-8454
=20


-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Scot Ranney
Sent: Saturday, October 16, 2004 3:01 PM
To: Richard Grevers
Cc: [email protected]
Subject: Re: [meu] OT- question about embeded plugin html


Is there any way to track what headers are being sent out so I
can=20
duplicate them?

Richard Grevers wrote:
> On Sat, 16 Oct 2004 14:37:47 -0700, Scot Ranney
<[email protected]> =20
> gave utterance to the following:
>=20
>> Hi Folks,
>>
>> In the "src=3D" part of embedding some media or other kind of
browser =20
>> plugin file, I noticed a site doing something like this:
>>
>> <embed src=3D"get_file.pl">
>> various parameters...
>> </embed>
>>
>> They are able to hide their source file and somehow use a perl
script=20
>> to get the plugin to know what the source file is.
>>
>> I tried to do something similar with miva script but it is not

>> working and I wonder if there is some kind of header I need
to push=20
>> through to get a plugin to recognize a source file in this
manner...
>>
>> Am I making any sense? Any ideas?
>>
> Their perl script will have to write a set of headers which
would=20
> match what would be sent if the image were called directly -
in=20
> particular content-type and content-length. Only Empresa 4.0 +
can do=20
> this - 3.x always outputs text/html.

OT- question about embeded plugin html



Hi Jeff,

Thanks for the info, I'll play around a bit and see whta I can come up with.

The reason I ask is that I'd like to hide the source file instead of
showing it's location in case someone views the html source of the page
it's on.

Scot

Jeff Huber - Listmail wrote:
> Well you could call a script that gives you access to the raw
> headers and then dump them to a text file.
>
> Or, you could use a tool that lets you set up sockets and listen
> on ports on your local system and then see the raw http
> communication.
>
> Example, you go get something like the TCP/IP Builder from
> <A HREF ="http://www.drk.com.ar/builder.php, and run it on your local">http://www.drk.com.ar/builder.php, and run it on your local</A>
> machine to listen at 127.0.0.1 on port 8001 or something and then
> use the following on your html page:
>
> <embed src="http://127.0.0.1:8001/get_file.pl">
> various parameters...
> </embed>
>
> Then when you submit the page go look in the builder and you will
> see the true raw request that would get sent.
>
> But, what is it that you are trying to do for real, what is it at
> the core that you want to accomplish by using the embed tag?
>
> If all you are looking for is a way to get the output of a Miva
> script on to a plain html page I would think you might want to
> consider using Jacussi for that.
>
> Basically it uses very simple and widely supported JavaScript,
> most critically the almost universally supported document.write,
> to display the information on the page.
>
> There is a Miva script specific Jacussi interface and it is
> capable of not only letting you do something simple like execute
> a Miva script and display output on an html page, but can even
> translate Miva script complex aggregates into JavaScript objects.
>
> There is almost no information on the current Jacussi.net website
> right now, but there is a simple page devoted to a basic
> explanation of how Jacussi with Miva script works. Hopefully we
> will free up the resources to get better info, downloads,
> examples, etc., on the site as time goes by, for now if you
> want/need more info, or want to use the Miva script Jacussi
> interface on your site Just let me know.
>
> - Jeff Huber
> President 4TheBest eCommerce Solutions
> http://4TheBest.com
> [email protected]
> Office: 760-742-1469
> Cell: 760-445-8454
>
>
>
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]] On Behalf Of Scot Ranney
> Sent: Saturday, October 16, 2004 3:01 PM
> To: Richard Grevers
> Cc: [email protected]
> Subject: Re: [meu] OT- question about embeded plugin html
>
>
> Is there any way to track what headers are being sent out so I
> can
> duplicate them?
>
> Richard Grevers wrote:
>
>>On Sat, 16 Oct 2004 14:37:47 -0700, Scot Ranney
>
> <[email protected]>
>
>>gave utterance to the following:
>>
>>
>>>Hi Folks,
>>>
>>>In the "src=" part of embedding some media or other kind of
>
> browser
>
>>>plugin file, I noticed a site doing something like this:
>>>
>>><embed src="get_file.pl">
>>> various parameters...
>>></embed>
>>>
>>>They are able to hide their source file and somehow use a perl
>
> script
>
>>>to get the plugin to know what the source file is.
>>>
>>>I tried to do something similar with miva script but it is not
>
>
>>>working and I wonder if there is some kind of header I need
>
> to push
>
>>>through to get a plugin to recognize a source file in this
>
> manner...
>
>>>Am I making any sense? Any ideas?
>>>
>>
>>Their perl script will have to write a set of headers which
>
> would
>
>>match what would be sent if the image were called directly -
>
> in
>
>>particular content-type and content-length. Only Empresa 4.0 +
>
> can do
>
>>this - 3.x always outputs text/html.
>
>