Re: Updating files from the web

I have to respectfully choose to disagree with you. 

Comments like yours give SQL a bad name :-)

If you write diligent code in Java, .Net, PHP, ASP, RPG or whatever, SQL 
is a fine way to insert data into a database from a web application.  You 
just want to make sure that you build your SQL statements into a business 
layer so that the web pages themselves don't have to contain a lot of SQL 
building logic. 

This logic holds true whether writing iSeries or PC/Linux web 
applications. 

Just my two cents :-)

Regards,
Richard Schoen
RJS Software Systems Inc. 
"Providing Your....iNFORMATION NOW!"
Email: richard@xxxxxxxxxxxxxxx
Web Site: http://www.rjssoftware.com
Tel: (952) 898-3038
Fax: (952) 898-1781
Toll Free: (888) RJSSOFT
------------------------------

message: 5
date: Fri, 24 Nov 2006 16:03:40 -0800 (PST)
from: eduard@xxxxxxxxxxxxxxxxxxxxxxx
subject: Re: Updating files from the web

Better not to use anything like SQL for this kind of things.
Better not ever allow SQL like updates from the Web.
Better not ever allow any type of scripting access to your data directly 
from the Web.
Better to stay at the save site and have full control over what is 
entereing how into your system.
Other way's might seems easier but are not at all sufficient save for 
serious bussiness, leave them for the toy things.
Just use CGI and receive the data with Post (not Get) and just let your 
program diligently get it in the file.
Then you have full control over what you receive (from whom) and what does 
enter your datebase.

P.s And choose your place of work better.... Amsterdam...(almost worse 
then NewYork, Chigaco or London).

Kind regards,
Eduard.