Re: Spreadsheet Interface.

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 16573
interpreted = N
texte = >Date: 16 Mar 1998 13:08:48 -0800 >From: Nelson Chen >Subject: spreadsheet interface > >I am interested in using a Java Spreadsheet applet as a means to edit >database.db files. Would this be possible? It seems like a good idea. >Have all the columns and rows of the database table in front of you and >make changes. > >Do I need an ORB? Would I be able to pack the text of the database >file and communicate between WebCat and the Applet? I guess what I am >asking is - is there any kind of interface besides HTTP that I can use >to modify the database. I suppose I could FTP or PUT the file and then >$flushcache. I am just not sure if such solution would be robust >enough.Why not just write a WebDNA page that you can pull up the whole database, 25 entries at a time, or allow yourself to search on a range of records you want to edit. Edit the info in a text field, then hit a update button. We designed something like this to allow multiple people access to different parts of the same database. Its a Realms, password protected with Webstar's builtin realms, then the WebDNA checks the current userid/password when they actually call the index.tmpl on the other side of the Realm security. Only allowing them to edit their own records, or only the records their department needs access to. it works in all types of setups, Sales/Shipping Department database for an intranet, to a database of products for an group of online stores.Probably alot easier and abit more robust then writing a Java applet and all of that. If you need to do massive updates to a database, instead of single entries (obviously hand updating anything more then a few dozen things at a time can get to be a pain.) You should probably just edit the text file and re FTP the database file itself.Just my thoughts. -- Nevin Lyne - Owner - BeSites Internet Solutions -- -- Visit Us At http://www.besites.com/ -- -- Web Hosting - LAN/WAN Consulting - Server Co-Location -- -- MacOS Internet/Intranet Server Consulting & Service -- -- Meeting Today's Needs and Tomorrow's Demands -- Associated Messages, from the most recent to the oldest:

    
  1. Re: Spreadsheet Interface. (N. Lyne 1998)
>Date: 16 Mar 1998 13:08:48 -0800 >From: Nelson Chen >Subject: spreadsheet interface > >I am interested in using a Java Spreadsheet applet as a means to edit >database.db files. Would this be possible? It seems like a good idea. >Have all the columns and rows of the database table in front of you and >make changes. > >Do I need an ORB? Would I be able to pack the text of the database >file and communicate between WebCat and the Applet? I guess what I am >asking is - is there any kind of interface besides HTTP that I can use >to modify the database. I suppose I could FTP or PUT the file and then >$flushcache. I am just not sure if such solution would be robust >enough.Why not just write a WebDNA page that you can pull up the whole database, 25 entries at a time, or allow yourself to search on a range of records you want to edit. Edit the info in a text field, then hit a update button. We designed something like this to allow multiple people access to different parts of the same database. Its a Realms, password protected with Webstar's builtin realms, then the WebDNA checks the current userid/password when they actually call the index.tmpl on the other side of the Realm security. Only allowing them to edit their own records, or only the records their department needs access to. it works in all types of setups, Sales/Shipping Department database for an intranet, to a database of products for an group of online stores.Probably alot easier and abit more robust then writing a Java applet and all of that. If you need to do massive updates to a database, instead of single entries (obviously hand updating anything more then a few dozen things at a time can get to be a pain.) You should probably just edit the text file and re FTP the database file itself.Just my thoughts. -- Nevin Lyne - Owner - BeSites Internet Solutions -- -- Visit Us At http://www.besites.com/ -- -- Web Hosting - LAN/WAN Consulting - Server Co-Location -- -- MacOS Internet/Intranet Server Consulting & Service -- -- Meeting Today's Needs and Tomorrow's Demands -- N. Lyne

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:

unitshipcost vs shipcosts (1997) Problems passing [SKU] with $Replace in 2.0 (1997) RE: formula.db, adding option prices (1997) FoundItems Question (1998) Follow-up to listfiles bug report ... (2003) Extended [ConvertChars] (1997) Security (2002) Separate SSL Server (1997) default value from Lookup (was Grant, please help me) (1997) Date Calulation (1997) [Listfiles] vs Netfinder (1997) Databases inside [SHOWIF] (1998) I give up!! (1997) Donovans Theorem (2003) WebCat2 several catalogs? (1997) [removehtml]? (2000) Showing unopened cart (1997) Configuring E-mail (1997) ftp access on Macos X (2000) [WebDNA] Non-numbers entered into a field that asks for a number (2008)