Re: Yet another db manager

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 55572
interpreted = N
texte = >Palle, > >I've uploaded a self-extracting archive of my code. Some people >have reported that the .zip won't unzip - probably because I use >WinRAR for creating those. > >http://www.garykrockover.com/dbquickview/ > >What I'll be adding next is a "common-language" query builder for >non-webDNA programmers. In otherwords, it will first scan the .hdr >file or 1st row of the database and then present you with a simple >form that will look something like: > > IS less/equal than, greater/equal than etc....> [inputbox: VALUE >(etc..)] >etc.... I already have this capability built into one of my db editors, I'll post the code here then you guys can mess around with it if you like. I think this code requires a "sku" field in order to work properly, but I always put a SKU field in my db's so it's never been an issue for me. I think it also requires that the db's being accessed are stored in a "data" subfolder because that's another of my standards. Not only does this code have the ability to perform most kinds of standard webdna searches, I started to write an option for doing group searches, but I did not finish that option -- so that's another thing you guys can work on if you really want to make this tool useful. This tool also lets you edit any field in any record in any db. Just put it in the folder that's one level above your "data" folder and it also lists every available db in the data folder so you can just click on a db name to begin: [text secure=f]task=[/text] [text]thispage=adminData.html[/text] [showif [group]=search]normal field search[/showif][showif [group]!search]group field search[/showif]:   [listfiles data/] [showif [filename]^.db] <[hideif [db]=[filename]]![/hideif]font color=[red]>[filename]   [/showif] [/listfiles]
[!] *************************************************************** [/!] [showif [task]=] add a new record

delete this record
[search db=data/[db]&eqskudatarq=[sku]&max=1] [founditems] [listfields db=data/[db]] [hideif [fieldname]=sku] [fieldname]


[/hideif] [/listfields] [/founditems] [/search]
delete this record
[/showif] [!] *************************************************************** [/!] [showif [task]=append] [append db=data/[db]]sku=[cart][/append] [redirect [thispage]?db=[db]&sku=[cart]] [/showif] [!] *************************************************************** [/!] [showif [task]=replace] [replace db=data/[db]&eqskudatarq=[sku]][formvariables][name]=[url][value][/url]&[/formvariables][/replace] the record has been updated, confirm the update

[/showif] [!] *************************************************************** [/!] [showif [task]=delete] [delete db=data/[db]&eqskudatarq=[sku]] The selected record in the [db] database has been deleted. [/showif] [!] *************************************************************** [/!] [showif [task]=search]
[loop start=1&end=3]
[/loop]
[showif [group]=search]
group field search doesn't work yet ...
[loop start=1&end=3]
[/loop]
[loop start=1&end=3]
[/loop]
[/showif]
[/showif] [!] *************************************************************** [/!] [showif [task]=results] [!] use only the fields selected in the form [/!] [text]parameters=[!] [/!][formvariables name=fieldname&exact=f][!] [/!][showif [url][value][/url]!][!] [/!][text]idx=[getchars start=1&end=1&from=end][name][/getchars][/text][!] [/!][interpret]&[comparison[idx]][fieldname[idx]]data[required[idx]]=[value[idx]]&[fieldname[idx]]type=[fieldtype[idx]][/interpret][!] [/!][/showif][!] [/!][/formvariables][!] [/!][/text]
[search db=data/[db][parameters]] [!][parameters]     [/!]numfound=[numfound]
[founditems] edit

[listfields db=data/[db]] [fieldname]:[grep search=%0B&replace=*][interpret][[fieldname]][/interpret][/grep]
[/listfields]
delete
[/founditems] [/search]
[/showif] -- Kenneth Grome ------------------------------------------------------------- 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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Yet another db manager ( Terry Wilson 2004)
  2. Re: Yet another db manager ( "Nitai @ ComputerOil" 2004)
  3. Re: Yet another db manager ( Gary Krockover 2004)
  4. Re: Yet another db manager ( Kenneth Grome 2004)
  5. Re: Yet another db manager ( Kenneth Grome 2004)
  6. Re: Yet another db manager ( Gary Krockover 2004)
  7. Re: Yet another db manager ( devaulw@onebox.com 2004)
  8. Re: Yet another db manager ( Gary Krockover 2004)
  9. Re: Yet another db manager ( devaulw@onebox.com 2004)
  10. Re: Yet another db manager ( Palle Bo Nielsen 2004)
  11. Re: Yet another db manager ( devaulw@onebox.com 2004)
  12. Re: Yet another db manager ( Gary Krockover 2004)
  13. Re: Yet another db manager ( Palle Bo Nielsen 2004)
  14. Re: Yet another db manager ( Gary Krockover 2004)
  15. Re: Yet another db manager ( Matthew A Perosi 2004)
  16. Re: Yet another db manager ( Palle Bo Nielsen 2004)
  17. Re: Yet another db manager ( Palle Bo Nielsen 2004)
  18. Re: Yet another db manager ( Palle Bo Nielsen 2004)
  19. Re: Yet another db manager ( devaulw@onebox.com 2004)
  20. Re: Yet another db manager ( Gary Krockover 2004)
  21. Re: Yet another db manager ( Palle Bo Nielsen 2004)
  22. Re: Yet another db manager ( Gary Krockover 2004)
  23. Re: Yet another db manager ( Palle Bo Nielsen 2004)
  24. Re: Yet another db manager ( Gary Krockover 2004)
  25. Re: Yet another db manager ( Palle Bo Nielsen 2004)
  26. Re: Yet another db manager ( "Dan Strong" 2004)
  27. Re: Yet another db manager ( Palle Bo Nielsen 2004)
  28. Re: Yet another db manager ( "Dan Strong" 2004)
  29. Re: Yet another db manager ( Palle Bo Nielsen 2004)
  30. Re: Yet another db manager ( Gary Krockover 2003)
  31. Yet another db manager ( Gary Krockover 2003)
>Palle, > >I've uploaded a self-extracting archive of my code. Some people >have reported that the .zip won't unzip - probably because I use >WinRAR for creating those. > >http://www.garykrockover.com/dbquickview/ > >What I'll be adding next is a "common-language" query builder for >non-webDNA programmers. In otherwords, it will first scan the .hdr >file or 1st row of the database and then present you with a simple >form that will look something like: > > IS less/equal than, greater/equal than etc....> [inputbox: VALUE >(etc..)] >etc.... I already have this capability built into one of my db editors, I'll post the code here then you guys can mess around with it if you like. I think this code requires a "sku" field in order to work properly, but I always put a SKU field in my db's so it's never been an issue for me. I think it also requires that the db's being accessed are stored in a "data" subfolder because that's another of my standards. Not only does this code have the ability to perform most kinds of standard webdna searches, I started to write an option for doing group searches, but I did not finish that option -- so that's another thing you guys can work on if you really want to make this tool useful. This tool also lets you edit any field in any record in any db. Just put it in the folder that's one level above your "data" folder and it also lists every available db in the data folder so you can just click on a db name to begin: [text secure=f]task=[/text] [text]thispage=adminData.html[/text] [showif [group]=search]normal field search[/showif][showif [group]!search]group field search[/showif]:   [listfiles data/] [showif [filename]^.db] <[hideif [db]=[filename]]![/hideif]font color=[red]>[filename]   [/showif] [/listfiles]
[!] *************************************************************** [/!] [showif [task]=] add a new record

delete this record
[search db=data/[db]&eqskudatarq=[sku]&max=1] [founditems] [listfields db=data/[db]] [hideif [fieldname]=sku] [fieldname]


[/hideif] [/listfields] [/founditems] [/search]
delete this record
[/showif] [!] *************************************************************** [/!] [showif [task]=append] [append db=data/[db]]sku=[cart][/append] [redirect [thispage]?db=[db]&sku=[cart]] [/showif] [!] *************************************************************** [/!] [showif [task]=replace] [replace db=data/[db]&eqskudatarq=[sku]][formvariables][name]=[url][value][/url]&[/formvariables][/replace] the record has been updated, confirm the update

[/showif] [!] *************************************************************** [/!] [showif [task]=delete] [delete db=data/[db]&eqskudatarq=[sku]] The selected record in the [db] database has been deleted. [/showif] [!] *************************************************************** [/!] [showif [task]=search]
[loop start=1&end=3]
[/loop]
[showif [group]=search]
group field search doesn't work yet ...
[loop start=1&end=3]
[/loop]
[loop start=1&end=3]
[/loop]
[/showif]
[/showif] [!] *************************************************************** [/!] [showif [task]=results] [!] use only the fields selected in the form [/!] [text]parameters=[!] [/!][formvariables name=fieldname&exact=f][!] [/!][showif [url][value][/url]!][!] [/!][text]idx=[getchars start=1&end=1&from=end][name][/getchars][/text][!] [/!][interpret]&[comparison[idx]][fieldname[idx]]data[required[idx]]=[value[idx]]&[fieldname[idx]]type=[fieldtype[idx]][/interpret][!] [/!][/showif][!] [/!][/formvariables][!] [/!][/text]
[search db=data/[db][parameters]] [!][parameters]     [/!]numfound=[numfound]
[founditems] edit

[listfields db=data/[db]] [fieldname]:[grep search=%0B&replace=*][interpret][[fieldname]][/interpret][/grep]
[/listfields]
delete
[/founditems] [/search]
[/showif] -- Kenneth Grome ------------------------------------------------------------- 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://webdna.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:

Re:Variable Math (1998) Talk List Suggestions (1997) script to autmaticaly update Filemaker DB (2000) Adding a donation amount (2000) RE: [WebDNA] anyone know why webdna kicking out incorrect dates? (2008) WebCatalog2 for NT Beta Request (1997) HELP WITH DATES (1997) Trouble with [Math] (1998) Show shoppingcart after remove last item (1997) Help! WebCat2 bug (Ben's input) (1997) Where is f2? (1997) StoreBuilder Shopping Cart (2000) No subject was specified. (2001) [exclusivelock] (was:several people...) (2001) AOL and webcat (1998) RedHat dropping 7.x 8.x and 9.x - What linux for WebDNA? (2003) cron script for housekeeping and running WebCatalog? (1999) Summing a field full of numbers ... (1997) WebCatalog Hosting (1996) Getting Emailer to send mail (1997)