Re: Yet another db manager
This WebDNA talk-list message is from 2004
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 >(empty, number, date, whatever user enters)] > 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]add a new record delete this record delete this record confirm the update . 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: IS less/equal than, greater/equal than etc....> [inputbox: VALUE >(empty, number, date, whatever user enters)] > 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 delete this record [!] *************************************************************** [/!] [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 [task]=delete] [delete db=data/[db]&eqskudatarq=[sku]] The selected record in the [db] database has been deleted. [/showif] [!] *************************************************************** [/!] [showif [task]=search] [/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] [/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:
Email (1998) [isfile] ? (1997) WebCatalog sales (1997) ShowNext (1997) It just Does't add up!!! (1997) WebMerchant problem (1998) Extended [ConvertChars] (1997) emailer (1997) The word TYPE in search contexts and fields (1998) [TaxableTotal] - not working with AOL and IE (1997) Resetting a Formvariable (2000) WebCat2b12 Mac.acgi--[searchstring] bug (1997) RE: is sku a REQUIRED field on NT (1997) Some Questions (1997) Summing fields (1997) Why do extra quotation marks sometimes appear in my databases? (1998) HomePage Caution (1997) Execute Applescript (1997) Extracting URL (2007) Is Web Merchant Necessary? (2000)