There are many ways to go about this- here are a couple:
Our company uses Postgresql,JDBC and Tomcat to accomplish this sort of task.
It's an industrial-strength approach that scales up and maintains well, but
involves a lot of learning for a simple application. I'd recommend it if it
seems like the boss will want to expand the web offering.
For a quicker approach, PHP might be a pretty good solution for a simple
application. I've not used PHP much, but it appears to be more suited to
rapid development and I think you'll find good support for it in the
Postgresql community. We only chose not to use it because we didn't think it
would scale up well. (But I'm sure that making this assertion will elicit
many opinions to the contrary.)
What platform does it need to run on?
-Nick
--------------------------------------------------------------------------
Nick Fankhauser nickf@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko & Co. Software Consulting Services http://www.ontko.com/
> -----Original Message-----
> From: pgsql-sql-owner@postgresql.org
> [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Melisa
> Sent: Friday, December 07, 2001 1:05 AM
> To: pgsql-sql@postgresql.org
> Subject: [SQL] anyone can help?
>
>
> Hi:
> I just graduated from univ. and got my first job. then I was just
> asked to do something I really don't know how to do it. anyone can
> help?
>
> my boos wanted me to build an interface to put ou the web page to
> serve our customers. it's simple, the database is already there,
> there's products' detail,manufacturers' detail and price plus
> products' picture. my boss just want me to create a window (maybe
> java? or can I write a VB program?), use three combo-boxes to let
> customers chose from product model, manufactures and price range. then
> clike a button and the picture and the detail will show in a textarea.
> but I don't know how to write the SQL, anyone can help?
>
> p.s: for example, when customers first choose product, the price and
> manufactures list box will show only math records. vice versa.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
