Re: Cold Fusion Buster
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 14133
interpreted = N
texte = >>We have a site that will be either Webcat(if we can) or Cold Fusion. It >>will have no Credit Card Authentication. We need to access a DB2 Database >>on an AS400 webserver. Honestly I don't know anything about cold fusion >>except that it is a webcat like cgi that accesses databases like >>Microsoft Access, DB2, Oracle, etc. Additionally they provide a driver >>that accesses the AS400/DB2 file. But since we know Webcat we would >>rather use it. Would you, could you, entertain writing special code to >>access the AS/400 DB2 Files, for a profit of course? > >We always look forward to a consulting challenge! The pertinent technical >questions are: does the AS400 data have to be 'live', or can it be >exported? What exactly is the interface to this driver? What are you >planning on doing with the data once you get it?If understand the above correctly..(but maybe not) :)I think you can do a write file from the as400 in which it creates a tab-delm file and with a perl script you can move the whole mess to the mac via ftp. We looked at this breifly this last spring to try to figure out away to move our part num (sku's) and quantity on hand, etc from a similar box to our mac webserver so trade customers could check stock and place orders over the web. It's on our to do list but it keeps sliding to the bottom :) When Grant asks if you can export, then it is not real time. The data is only as good as the last export (nightly, hourly, etc.)=============================================== Gary Richter PanaVise Products, Inc. 7540 Colbert Dr. Reno, Nevada 89511 Ph: 702.850.2900 Fx: 702.850.2929 Email: grichter@panavise.com http://www.panavise.com ===============================================
Associated Messages, from the most recent to the oldest:
>>We have a site that will be either Webcat(if we can) or Cold Fusion. It >>will have no Credit Card Authentication. We need to access a DB2 Database >>on an AS400 webserver. Honestly I don't know anything about cold fusion >>except that it is a webcat like cgi that accesses databases like >>Microsoft Access, DB2, Oracle, etc. Additionally they provide a driver >>that accesses the AS400/DB2 file. But since we know Webcat we would >>rather use it. Would you, could you, entertain writing special code to >>access the AS/400 DB2 Files, for a profit of course? > >We always look forward to a consulting challenge! The pertinent technical >questions are: does the AS400 data have to be 'live', or can it be >exported? What exactly is the interface to this driver? What are you >planning on doing with the data once you get it?If understand the above correctly..(but maybe not) :)I think you can do a write file from the as400 in which it creates a tab-delm file and with a perl script you can move the whole mess to the mac via ftp. We looked at this breifly this last spring to try to figure out away to move our part num (sku's) and quantity on hand, etc from a similar box to our mac webserver so trade customers could check stock and place orders over the web. It's on our to do list but it keeps sliding to the bottom :) When Grant asks if you can export, then it is not real time. The data is only as good as the last export (nightly, hourly, etc.)=============================================== Gary Richter PanaVise Products, Inc. 7540 Colbert Dr. Reno, Nevada 89511 Ph: 702.850.2900 Fx: 702.850.2929 Email: grichter@panavise.com http://www.panavise.com ===============================================
grichter@panavise.com (Gary Richter)
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:
Shopping Cart - prices? (1997)
value in forms (2000)
More on the email templates (1997)
Almost a there but..bye bye NetCloak (1997)
IP address & domain name problem (2003)
Allow-Deny: Solved with [Getchars] (1998)
Database multiple selections (1998)
Summing fields (1997)
Req for code: upload and append to DB (2002)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
color and size options (1997)
[OT]Co-Location of a Server (2002)
WebMerchant when CC network is down (1998)
HTML Editors (1997)
Template transformed itself into a database? (1998)
suffix mapping for NT? (1997)
[quantity] within formulas (1997)
Universal db access template ... (2002)
pop up menu's (1998)
Emailer problems solved (1997)