pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
anyone can help?
4+ messages / 4 participants
[nested] [flat]

* anyone can help?
@ 2001-12-07 06:05 Melisa <lin_melisa@hotmail.com>
  2001-12-10 18:10 ` Re: anyone can help? Nick Fankhauser <nickf@ontko.com>
  2001-12-10 19:08 ` Re: anyone can help? Roberto Mello <rmello@cc.usu.edu>
  2001-12-10 19:33 ` Re: anyone can help? Jason Earl <jason.earl@simplot.com>
  0 siblings, 3 replies; 4+ messages in thread

From: lin_melisa@hotmail.com @ 2001-12-07 06:05 UTC (permalink / raw)
  To: pgsql-sql

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.



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: anyone can help?
  2001-12-07 06:05 anyone can help? Melisa <lin_melisa@hotmail.com>
@ 2001-12-10 18:10 ` Nick Fankhauser <nickf@ontko.com>
  2 siblings, 0 replies; 4+ messages in thread

From: Nick Fankhauser @ 2001-12-10 18:10 UTC (permalink / raw)
  To: Melisa <lin_melisa@hotmail.com>; pgsql-sql

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)
>




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: anyone can help?
  2001-12-07 06:05 anyone can help? Melisa <lin_melisa@hotmail.com>
@ 2001-12-10 19:08 ` Roberto Mello <rmello@cc.usu.edu>
  2 siblings, 0 replies; 4+ messages in thread

From: Roberto Mello @ 2001-12-10 19:08 UTC (permalink / raw)
  To: Melisa <lin_melisa@hotmail.com>; +Cc: pgsql-sql

On Thu, Dec 06, 2001 at 10:05:03PM -0800, Melisa wrote:
> asked to do something I really don't know how to do it. anyone can
> help?

We can give you pointers.
 
> 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

Java, VB, PHP, Tcl, Python, Perl, etc. depends mostly on the web 
server you are running. I'd stay away from Java since your need is very
simple and doesn't justify the added complexity that Java brings (from
what you've told us).

> 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.

This is pretty simple to do. But everything, from the client language to
the SQL (to some extent) will depend on your server environment. What web
server? what database server? What languages do you have available?

There are several tutorials to do this kind of thing. Stay away from the
MySQL-type tutorials (usually written by idiots) and you should be safe.

-Roberto
-- 
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+
  Roberto Mello - Computer Science, USU - http://www.brasileiro.net 
       http://www.sdl.usu.edu - Space Dynamics Lab, Developer    
WHeRe is ThaT DArN ShIfT keY?



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: anyone can help?
  2001-12-07 06:05 anyone can help? Melisa <lin_melisa@hotmail.com>
@ 2001-12-10 19:33 ` Jason Earl <jason.earl@simplot.com>
  2 siblings, 0 replies; 4+ messages in thread

From: Jason Earl @ 2001-12-10 19:33 UTC (permalink / raw)
  To: lin_melisa@hotmail.com; +Cc: pgsql-sql


If I read this correctly it sounds as if you are asking about which
web development toolset you should use.  Unfortunately for you there
is almost an unlimited set of tools that are compatible with
PostgreSQL.  Chances are good that whatever language you are currently
most comfortable with has a web technology or two that will happily
read data from PostgreSQL.

That being said, if this is your first foray into web development I
would suggest PHP.  I personally do most of my work in Zope nowadays,
but it is hard to beat PHP for simple web applications.  It's easy to
use, it runs everywhere, it has a very supportive user community, and
oustanding documentation.

Jason

lin_melisa@hotmail.com (Melisa) writes:

> 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)



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2001-12-10 19:33 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-12-07 06:05 anyone can help? Melisa <lin_melisa@hotmail.com>
2001-12-10 18:10 ` Nick Fankhauser <nickf@ontko.com>
2001-12-10 19:08 ` Roberto Mello <rmello@cc.usu.edu>
2001-12-10 19:33 ` Jason Earl <jason.earl@simplot.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox