Postgres Pro
Downloads
Home   >   mailing lists

Thread: Help

Help

From
Mohamed ebrahim
Date:
Hi,
   I am a user of postgresql. I want to know that it
is possible to call a jsp file in postgre
command.Please help me to know how to call a jsp file.

Thank you

Ebrahim

__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/

Re: Help

From
Roberto Mello
Date:
On Sat, Mar 24, 2001 at 10:50:31PM -0800, Mohamed ebrahim wrote:
> Hi,
> 
>     I am a user of postgresql. I want to know that it
> is possible to call a jsp file in postgre
> command.Please help me to know how to call a jsp file.
You need a Servlet container to process jsp files and PostgreSQL does
not have a Java virtual machine. But you can use PostgreSQL from your Java
program by using JDBC.Look for Jakarta/Tomcat for an open source servlet container.
-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, Web Developer

Re: Help

From
"Brett W. McCoy"
Date:
On Sat, 24 Mar 2001, Mohamed ebrahim wrote:

>     I am a user of postgresql. I want to know that it
> is possible to call a jsp file in postgre
> command.Please help me to know how to call a jsp file.

What do you mean 'call a JSP file'?  A JSP file is parsed and compiled by
something like Jasper or JServ and and is served through a web server like
Tomcat or Tomcat with Apache.

Now, you CAN use jdbc in JSP files and access PostgreSQL databases that
way.  For that, you need to take a look at the jdbc documentation.

-- Brett               http://www.chapelperilous.net/btfwk/
------------------------------------------------------------------------
There is no fear in love; but perfect love casteth out fear.

SQL Date help

From
"waheed_rahuman"
Date:

Hi,

I am a newbie to SQL and postgresql too.
please guide me in the following...


1.How i can create date while i am inserting into the table ,in which the
field is date data type.(date should not be a current date and its should be
created
as in java date(int,int,int)

2. How i can compare the date field.
For example ,
how i can get the all the records between to two dates

please help in this regards

i thank you
regards
waheed




_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

Re: SQL Date help

From
Karel Zak
Date:
On Mon, Mar 26, 2001 at 12:24:07PM +0400, waheed_rahuman wrote:
> 
> 
> Hi,
> 
> I am a newbie to SQL and postgresql too.
> please guide me in the following...
Any problem with documentation?

> 1.How i can create date while i am inserting into the table ,in which the
> field is date data type.(date should not be a current date and its should be
> created
> as in java date(int,int,int)
INSERT INTO xxx VALUES (now());INSERT INTO xxx VALUES ('2000-01-01');

> 2. How i can compare the date field.

via standard operators, en example '<' '>' '=' 'between' ..etc. 

> For example ,
> how i can get the all the records between to two dates
 SELECT .... WHERE col BETWEEN '2000-01-01' AND '2001-01-01';Please(!), see

http://www.postgresql.org/users-lounge/docs/7.0/user/datatype.htm
http://www.postgresql.org/users-lounge/docs/7.0/user/operators.htm
http://www.postgresql.org/users-lounge/docs/7.0/user/operators2373.htm  
    Karel

-- Karel Zak  <zakkr@zf.jcu.cz>http://home.zf.jcu.cz/~zakkr/C, PostgreSQL, PHP, WWW, http://docs.linux.cz,
http://mape.jcu.cz