Обсуждение: Help
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/
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
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.
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
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