Universal db access template ...

This WebDNA talk-list message is from

2002

It keeps the original formatting. numero = 45037
interpreted = N
texte = [!]HAS_WEBDNA_TAGS[/!][grep search=%0D&replace=][!]This is a universal database access template (or at least that's what it's supposed to be).I created this template so I could browse/sort and edit/delete any record in any db file I create -- without having to build a custom template each time. Just copy and paste everything you see here into a blank text file, then read these instructions BEFORE you use it ...The first rule for success with this file is to name it the same as the db you want to access -- except with the .tpl suffix instead of the .db suffix -- then place it into the same folder as the database file. The second rule is that the FIRST FIELD in the db must be the unique record identifier field. If you have a db that does not use the first field as its unique record identifier, this file won't work for you.The third rule is that you should change the text variables for YourUsername and YourPassword to your own values.Please note, there is a problem when displaying encrypted values from a db file. Sometimes the field following the encrypted value will include the data from (what appears to be) the next record in the search results. Until this problem is fixed, you'll probably screw up your data if you're not careful to check every field in the update form before you click the update button. This might not be a problem if you have double-URLed your encrypted values before appending or replacing them in the db, but I'm not sure about this theory, and I haven't had time to debug the problem, so if anyone knows the proper solution please post it on the talk list ... along with any other problems you find in this code.Thanks![/!][text]fileUser=YourUsername[/text][text]filePass=YourPassword[/text][listwords words=[thisurl]&delimiters=/][text secure=T]thisPage=[word][/text][/listwords][text]thisDB=[middle endbefore=.][thispage][/middle].db[/text][text]skuField=[listfields db=[thisDB]][showif [index]=1][fieldname][/showif][/listfields][/text][text secure=f]sortBy=[skuField][/text][text secure=f]task=[/text][showif [fileUser]![username]][authenticate Access to [thisDB]][/showif][showif [filePass]![password]][authenticate Access to [thisDB]][/showif][showif [task]=update][replace db=[thisDB]&eq[skuField]datarq=[url][skuValueOld][/url]][listfields db=[thisDB]][fieldname]=[url][interpret][[fieldname]][/interpret][/url]&[/listfields][/replace][redirect [thispage]?sortby=[sortBy]&howMany=[howMany]&startat=[startat]][/showif][showif [task]=delete][delete db=[thisDB]&eq[skuField]datarq=[url][skuValue][/url]][redirect [thispage]?sortby=[sortBy]&howMany=[howMany]&startat=[startat]][/showif][showif [task]=][text secure=f]howMany=20[/text][search db=[thisDB]&ne[skuField]datarq=[blank]&as[sortBy]sort=1&max=[howMany]&startat=[startat]]
[numfound] records found.   (Show[showif [howMany]=20] 20 [/showif][hideif [howMany]=20] 20 [/hideif][showif [howMany]=50] 50 [/showif][hideif [howMany]=50] 50 [/hideif][showif [howMany]=100] 100 [/showif][hideif [howMany]=100] 100 [/hideif][showif [howMany]=200] 200 [/showif][hideif [howMany]=200] 200 [/hideif][showif [howMany]=500] 500 [/showif][hideif [howMany]=500] 500 [/hideif][showif [howMany]=5000] all [/showif][hideif [howMany]=5000] all [/hideif] per page)


[listfields db=[thisDB]][/listfields][founditems][listfields db=[thisDB]][showif [index]=1][/showif][showif [index]!1][/showif][text]numFields=[index][/text][/listfields][/founditems][showif [numfound]>[howMany]][/showif]

#	[fieldname]
[index]	edit	[interpret][[fieldname]][/interpret]
Show Page:   [shownext position=begin][math]ceil([end]/[howMany])[/math] [/shownext][shownext position=middle][math]ceil([end]/[howMany])[/math] [/shownext][shownext position=end][math]ceil([end]/[howMany])[/math] [/shownext]

[/search][/showif][showif [task]=edit][search db=[thisDB]&eq[skuField]datarq=[interpret][[skuField]][/interpret]&max=1][founditems]

[listfields db=[thisDB]][!][/!][input][interpret][[fieldname]][/interpret][/input][fieldname]
[/listfields]
[/founditems][/search][/showif][/grep]-------------------------------------------------------------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:

Re: Universal db access template ... (Kenneth Grome 2002) Re: Universal db access template ... (Kenneth Grome 2002) Re: Universal db access template ... (Kenneth Grome 2002) Re: Universal db access template ... (Alain Russell 2002) Re: Universal db access template ... (Alain Russell 2002) Re: Universal db access template ... (Gary Krockover 2002) Re: Universal db access template ... (Joe D'Andrea 2002) Re: Universal db access template ... (Gary Krockover 2002) Re: Universal db access template ... (Kenneth Grome 2002) Re: Universal db access template ... (Gary Krockover 2002) Re: Universal db access template ... (Kenneth Grome 2002) Universal db access template ... (Kenneth Grome 2002)

[!]HAS_WEBDNA_TAGS[/!][grep search=%0D&replace=][!]This is a universal database access template (or at least that's what it's supposed to be).I created this template so I could browse/sort and edit/delete any record in any db file I create -- without having to build a custom template each time. Just copy and paste everything you see here into a blank text file, then read these instructions BEFORE you use it ...The first rule for success with this file is to name it the same as the db you want to access -- except with the .tpl suffix instead of the .db suffix -- then place it into the same folder as the database file. The second rule is that the FIRST FIELD in the db must be the unique record identifier field. If you have a db that does not use the first field as its unique record identifier, this file won't work for you.The third rule is that you should change the text variables for YourUsername and YourPassword to your own values.Please note, there is a problem when displaying encrypted values from a db file. Sometimes the field following the encrypted value will include the data from (what appears to be) the next record in the search results. Until this problem is fixed, you'll probably screw up your data if you're not careful to check every field in the update form before you click the update button. This might not be a problem if you have double-URLed your encrypted values before appending or replacing them in the db, but I'm not sure about this theory, and I haven't had time to debug the problem, so if anyone knows the proper solution please post it on the Talk List ... along with any other problems you find in this code.Thanks![/!][text]fileUser=YourUsername[/text][text]filePass=YourPassword[/text][listwords words=[thisurl]&delimiters=/][text secure=T]thisPage=[word][/text][/listwords][text]thisDB=[middle endbefore=.][thispage][/middle].db[/text][text]skuField=[listfields db=[thisDB]][showif [index]=1][fieldname][/showif][/listfields][/text][text secure=f]sortBy=[skuField][/text][text secure=f]task=[/text][showif [fileUser]![username]][authenticate Access to [thisDB]][/showif][showif [filePass]![password]][authenticate Access to [thisDB]][/showif][showif [task]=update][replace db=[thisDB]&eq[skuField]datarq=[url][skuValueOld][/url]][listfields db=[thisDB]][fieldname]=[url][interpret][[fieldname]][/interpret][/url]&[/listfields][/replace][redirect [thispage]?sortby=[sortBy]&howMany=[howMany]&startat=[startat]][/showif][showif [task]=delete][delete db=[thisDB]&eq[skuField]datarq=[url][skuValue][/url]][redirect [thispage]?sortby=[sortBy]&howMany=[howMany]&startat=[startat]][/showif][showif [task]=][text secure=f]howMany=20[/text][search db=[thisDB]&ne[skuField]datarq=[blank]&as[sortBy]sort=1&max=[howMany]&startat=[startat]]
[numfound] records found.   (Show[showif [howMany]=20] 20 [/showif][hideif [howMany]=20] 20 [/hideif][showif [howMany]=50] 50 [/showif][hideif [howMany]=50] 50 [/hideif][showif [howMany]=100] 100 [/showif][hideif [howMany]=100] 100 [/hideif][showif [howMany]=200] 200 [/showif][hideif [howMany]=200] 200 [/hideif][showif [howMany]=500] 500 [/showif][hideif [howMany]=500] 500 [/hideif][showif [howMany]=5000] all [/showif][hideif [howMany]=5000] all [/hideif] per page)


[listfields db=[thisDB]][/listfields][founditems][listfields db=[thisDB]][showif [index]=1][/showif][showif [index]!1][/showif][text]numFields=[index][/text][/listfields][/founditems][showif [numfound]>[howMany]][/showif]

#	[fieldname]
[index]	[interpret][[fieldname]][/interpret]&sortBy=[sortBy]&howMany=[howMany]&startat=[startat]>edit	[interpret][[fieldname]][/interpret]
[math][numFields]+1[/math]> Show Page:   [shownext position=begin][math]ceil([end]/[howMany])[/math] [/shownext][shownext position=middle][math]ceil([end]/[howMany])[/math] [/shownext][shownext position=end][math]ceil([end]/[howMany])[/math] [/shownext]

[/search][/showif][showif [task]=edit][search db=[thisDB]&eq[skuField]datarq=[interpret][[skuField]][/interpret]&max=1][founditems]

[interpret][[skuField]][/interpret]>[listfields db=[thisDB]][!][input][interpret][[fieldname]][/interpret][/input]>[/!]<a target="_parent" href="page.dna?numero=182">[input]</a><a target="_parent" href="page.dna?numero=260">[interpret]</a>[[fieldname]][/interpret][/input][fieldname]
[/listfields][interpret][[skuField]][/interpret]>
[/founditems][/search][/showif][/grep]-------------------------------------------------------------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/ Kenneth Grome

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:

Nested tags count question (1997) WebCat2 several catalogs? (1997) users.db (1999) WebCatalog and WebMerchant reviewed by InfoWorld (1997) Associative lookup style? (1997) Help! WebCat install problems... (2000) problems with 2 tags shakur (1997) Itools, WEBCAT OSX (2003) newbie question about zip code search (2003) [WebDNA] Where's that developer list? (2012) more on prefs not being written (2000) Likelihood of a duplicate (2005) Shipping costs again (1998) WebMerchant & Online CC Auths (1999) [WriteFile] problems (1997) Generating Report Totals (1997) Micro-managing External Links (2006) Speed/performance issues using .hdr (1997) Suffix Mapping (1997) & in Lookups (1997)