Re: Securing/hiding database file
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 31864
interpreted = N
texte = You don't say what platform you are running, so I can't be very specific about the solution. In general, you want to map the file extension for your databases (frequently .db) to WebCatalog (duplicate the entries for .tpl). Then, there is no way for the browser to download the file, even by knowing the file name and full path; the web server will transfer the request to WebCatalog, which will in turn not download the database.As for your second question, the random sort has some problems with not actually being random. If you have fewer than 100 records, you can use a combination of record number and [random] to pick out the records.John PeacockRónán wrote: > > Hi all > > Is there a good way to hide a WC database file so that a Web browser can't > download it? I was thinking of putting it in another directory and password > protecting the directory - is this sensible? > > I am working on a search engine where the results are sorted randomly. The > problem with this is that where the results extend over more than one page, the > set of records displayed is in a different sort order - so the same record might > come up multiple times as you browse through the results. Is this a way to > prevent this? I was thinking of adding a field containing a random value to the > database and sorting on this, so that the search results are always in the same > order from page to page. > > Thanks. > > Rónán >------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
You don't say what platform you are running, so I can't be very specific about the solution. In general, you want to map the file extension for your databases (frequently .db) to WebCatalog (duplicate the entries for .tpl). Then, there is no way for the browser to download the file, even by knowing the file name and full path; the web server will transfer the request to WebCatalog, which will in turn not download the database.As for your second question, the random sort has some problems with not actually being random. If you have fewer than 100 records, you can use a combination of record number and [random] to pick out the records.John PeacockRónán wrote: > > Hi all > > Is there a good way to hide a WC database file so that a Web browser can't > download it? I was thinking of putting it in another directory and password > protecting the directory - is this sensible? > > I am working on a search engine where the results are sorted randomly. The > problem with this is that where the results extend over more than one page, the > set of records displayed is in a different sort order - so the same record might > come up multiple times as you browse through the results. Is this a way to > prevent this? I was thinking of adding a field containing a random value to the > database and sorting on this, so that the search results are always in the same > order from page to page. > > Thanks. > > Rónán >------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
John Peacock
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Possible Bug in 2.0b15.acgi (1997)
Not really WebCat (1997)
Feature: TCPconnect via SSL (1999)
how to know the [LineIndex] number webcat generated during a [AddLineItem]? (2000)
Mass Mail (2000)
WebDNA - fun to compare (2005)
using showpage and showcart commands (1996)
Numbers and Numbers and Me (1999)
Not reading code (1997)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
Summing fields (1997)
Title not showing up in ViewOrder template (1998)
[shownext] (1998)
Date problems-more (1997)
Letters as SKU (1998)
WebCommerce: Folder organization ? (1997)
Great product and great job ! (1997)
formvars available in formulas.db? (2000)
Odd [math] behaviour (2003)
Projects & Contractors (1997)