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:
Setting up shop (1997)
Great product and great job ! (1997)
Wierd webdna problem and terminal message (2005)
Queertrons? (1997)
Authenticate (1997)
Catalog Design (1999)
[QuantityPrice] Not working in WebCatNT 2.0.1??? (1997)
form population (1998)
return two fields w/ [lookup] (1998)
Not really WebCat (1997)
Dates (1996)
Review comparison by PC Magazine: Open for On-line Business (1997)
[redirect..] (2006)
Emailer setup (1997)
What am I missing (1997)
Smart caching problems with 2.1b3? (1997)
multi-paragraph fields (1997)
[WebDNA] v7 Stress Test and Strange Behaviour (2012)
Generating unique SKU from [cart] (1997)
Random (2000)