Re: Integration with SQL

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 12561
interpreted = N
texte = >Is there any way >to grab the student's personal/financial info from SQL and send it to >WebCatalog when that student goes to purchase an item from the bookstore >(Webcatalog)? This would prevent the student from having to enter this >information twice - once when enrolling for courses and once when buying >from the bookstore.If you can export the information from SQL to a tab-delimited database, WebCatalog should have no problem with it. ClubMac regularly exports from their mainframe to keep prices up-to-date.>One other factor. We have an arrangement with a book distributor to sell >their books via the bookstore. The current inventory is approximately >500,000 titles updated monthly from CD rom. What are the ramifications >of this many records in WebCatalog?That can add up to a lot of RAM, but there are no inherent limits. If you have lots of text associated with each book, it may make sense to store that in HTML files that are referenced by SKU. A database of 500,000 records with a small amount of information per record will take typically 38M RAM.Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors ===== Pacific Coast Software | WebCatalog Pro, WebCommerce Solution 11770 Bernardo Plaza Court | SiteEdit Pro, SiteCheck, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com Associated Messages, from the most recent to the oldest:

    
  1. Re: Integration with SQL (Grant Hulbert 1997)
  2. Integration with SQL (Andy Meng 1997)
>Is there any way >to grab the student's personal/financial info from SQL and send it to >WebCatalog when that student goes to purchase an item from the bookstore >(Webcatalog)? This would prevent the student from having to enter this >information twice - once when enrolling for courses and once when buying >from the bookstore.If you can export the information from SQL to a tab-delimited database, WebCatalog should have no problem with it. ClubMac regularly exports from their mainframe to keep prices up-to-date.>One other factor. We have an arrangement with a book distributor to sell >their books via the bookstore. The current inventory is approximately >500,000 titles updated monthly from CD rom. What are the ramifications >of this many records in WebCatalog?That can add up to a lot of RAM, but there are no inherent limits. If you have lots of text associated with each book, it may make sense to store that in HTML files that are referenced by SKU. A database of 500,000 records with a small amount of information per record will take typically 38M RAM.Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors ===== Pacific Coast Software | WebCatalog Pro, WebCommerce Solution 11770 Bernardo Plaza Court | SiteEdit Pro, SiteCheck, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com Grant Hulbert

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:

Looking up two prices in Formulas.db (1997) WebMerchant when CC network is down (1998) [sendmail] line breaks? (2000) Weird Math and SV Bad News (1997) [BULK] [WebDNA] test (2011) customer info (2001) two unique banners on one page (1997) WebCat2b13MacPlugIn - [shownext method=post] ??? (1997) creating a ShipCosts database (1997) Help formatting search results w/ table (1997) Date and Time Math (1997) ShowNext (1997) passing user info on each page (2000) emailer settings and control questions (1997) OT: need help with web address (2003) What would be sweet is (2003) no global [username] or [password] displayed ... (1997) encryption madness (2004) WebDelivery: One step closer !! (1997) Error Log.db --however (1997)