Re: postgreSQL and javascript

I know what you are talking about. Using javascript server side with ASP.
By default, ASP support the use of javascript (or termed by Microsoft as
JScript) or vbscript. In all honesty, I don't know anyone that uses
javascript with ASP on the server side. And then, I'd assume you have to use
ADO to connect to a database.

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
----- Original Message -----
From: "Neil P Davis" <npdavis(at)hotmail(dot)com>
To: "Peter Mount" <petermount(at)maidstone(dot)gov(dot)uk>; "'Andrew Dellinger'"
<aedellin(at)mindspring(dot)com>; <pgsql-interfaces(at)postgresql(dot)org>
Sent: Tuesday, November 28, 2000 10:07 AM
Subject: Re: [INTERFACES] postgreSQL and javascript

Hello,
Actually javascript is quite capable of running server side too. The
capabilities of the implementation depend on platform. While I personally
know nothing about connecting javascript to a database, I have seen examples
of this in MSDN (Microsoft Developer's Network). This may or may not only be
possible on the Microsoft platform with their javascript implementation.
Even then, I think it is a server side thing. Though if you can do it on the
server, you may be able to do it in the client, at least with IE. I recall
seeing something about disconnected recordsets and javascript in a wrox book
somewhere....

Don't give up yet. Search on 'disconnected recordset'... Maybe there is a
way.

I am of the persuasion that the data should be extracted by the time that
javascript is playing with it. Then again, I still have a lot to learn. I
usually build my javascript datastructures as the page is being rendered by
using either ASP or PHP. Granted, this makes for some cumbersome code, but
hey, it is built dynamically and all I need to maintain is the piece of code
that generates the mess, not the mess itself : )

About jdbc... It has absolutely nothing to do with javascript. It is for
java. JavaDataBaseConnectivity. I agree with Peter and Adam in their
assertion that the name for javascript is problematic. People new to
programming would benefit from the distinction of a new name.

Check out devedge.netscape.com for a decent javascript reference. If you are
new to javascript go to javascript.internet.com and start playing with some
working scripts to learn a little about the way the language works. There
are tutorials here too. There may or may not be better sites now. These two
have gotten me out of any pickle that I have ever confronted.

The most important thing is to first grasp what an object model is, then
learn the DOM or Document Object Model (or at least print it out and hang
it in your cube, you will need it!). From there you will really be able to
impress your friends. Using javascript I have approached the functionality
and bells and whistles of thick client Apps (- data access of course!) in a
browser. It is very powerful indeed. When combined with ASP or PHP, it is
even more so. I don't know how I ever got along without it!

Like everything else, javascript works differently in Netscape than it does
in IE. This manifests itself in positioning coordinates (Netscape and IE
count pixels from different spots), event handlers (IE Supports tag events
that Netscape does not). Most likely, both Netscape and Microsoft's CEOs
will go to hell for all the hours of developer torture caused by their
unwillingness to decide on standards and stick by them. They know what the
impact is to millions of developers worldwide, yet they continue. No I don't
have a preference, I hate both companies with equal ferocity. Do yourself a
favor, debug javascript in Netscape. It is the least common denominator.

thx,
Neil
----- Original Message -----
From: Peter Mount
To: 'Andrew Dellinger' ; pgsql-interfaces(at)postgresql(dot)org
Sent: Tuesday, November 28, 2000 3:55 AM
Subject: RE: [INTERFACES] postgreSQL and javascript

No. Javascript is nothing to do with Java (the similar names confuse a lot
of people), and Javascript is a simple scripting language running within the
browser.

Peter
--
Peter Mount
Enterprise Support Officer, Maidstone Borough Council
Email: petermount(at)maidstone(dot)gov(dot)uk
WWW: http://www.maidstone.gov.uk
All views expressed within this email are not the views of Maidstone
Borough Council

-----Original Message-----
From: Andrew Dellinger [mailto:aedellin(at)mindspring(dot)com]
Sent: Tuesday, November 28, 2000 4:17 AM
To: pgsql-interfaces(at)postgresql(dot)org
Subject: [INTERFACES] postgreSQL and javascript

Is it possible to connect to postgreSQL using JavaScript? If so, how? I
have been
reading a lot about JDBC, but it has all java examples.

Thanks,
Andrew Dellinger