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:

ReturnRaw (1999) Add a field to the error log? (1997) Bad cookie (1998) Num Sort Descending (2004) Paths, relative paths, webstar server setup andsecurity WebDNA-Talk@smithmicro.com (1997) Max Record length (1997) Using [Include] Context (1999) updating checkbox in a db (1998) Bug Report, maybe (1997) emailer on Windows Beta 18 (1997) Color (2000) Help with Shipping Costs (1997) Document Contains No Data! (1997) emailer w/F2 (1997) [ShowIf] if the varieable exists (1998) View order not right (1997) WebMerchant (1997) loops (2000) Version f1 status (1997) textarea inputs and returns (1999)