Received: from hotmail.com (oe59.law3.hotmail.com [209.185.240.59]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eASF8gt46640 for ; Tue, 28 Nov 2000 10:08:42 -0500 (EST) (envelope-from npdavis@hotmail.com) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Tue, 28 Nov 2000 07:08:45 -0800 X-Originating-IP: [206.197.57.87] From: "Neil P Davis" To: "Peter Mount" , "'Andrew Dellinger'" , References: <1B3D5E532D18D311861A00600865478CF1B5CE@exchange1.nt.maidstone.gov.uk> Subject: Re: postgreSQL and javascript Date: Tue, 28 Nov 2000 10:07:59 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0093_01C05923.15D39890" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 Message-ID: X-OriginalArrivalTime: 28 Nov 2000 15:08:45.0302 (UTC) FILETIME=[1A2F1160:01C0594D] X-Archive-Number: 200011/274 X-Sequence-Number: 311 This is a multi-part message in MIME format. ------=_NextPart_000_0093_01C05923.15D39890 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, Actually javascript is quite capable of running server side too. The capabi= lities of the implementation depend on platform. While I personally know no= thing about connecting javascript to a database, I have seen examples of th= is in MSDN (Microsoft Developer's Network). This may or may not only be pos= sible 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 ser= ver, you may be able to do it in the client, at least with IE. I recall see= ing something about disconnected recordsets and javascript in a wrox book s= omewhere....=20 Don't give up yet. Search on 'disconnected recordset'... Maybe there is a w= ay. I am of the persuasion that the data should be extracted by the time that j= avascript is playing with it. Then again, I still have a lot to learn. I us= ually build my javascript datastructures as the page is being rendered by u= sing either ASP or PHP. Granted, this makes for some cumbersome code, but h= ey, 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 ja= va. JavaDataBaseConnectivity. I agree with Peter and Adam in their assertio= n that the name for javascript is problematic. People new to programming wo= uld benefit from the distinction of a new name. Check out devedge.netscape.com for a decent javascript reference. If you ar= e new to javascript go to javascript.internet.com and start playing with so= me working scripts to learn a little about the way the language works. Ther= e 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 le= arn 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 im= press your friends. Using javascript I have approached the functionality an= d bells and whistles of thick client Apps (- data access of course!) in a b= rowser. It is very powerful indeed. When combined with ASP or PHP, it is ev= en 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 c= ount pixels from different spots), event handlers (IE Supports tag events t= hat Netscape does not). Most likely, both Netscape and Microsoft's CEOs wil= l go to hell for all the hours of developer torture caused by their unwilli= ngness 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 favo= r, debug javascript in Netscape. It is the least common denominator. thx, Neil ----- Original Message -----=20 From: Peter Mount=20 To: 'Andrew Dellinger' ; pgsql-interfaces@postgresql.org=20 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 lo= t of people), and Javascript is a simple scripting language running within = the browser. Peter --=20 Peter Mount=20 Enterprise Support Officer, Maidstone Borough Council=20 Email: petermount@maidstone.gov.uk=20 WWW: http://www.maidstone.gov.uk=20 All views expressed within this email are not the views of Maidstone Boro= ugh Council=20 -----Original Message----- From: Andrew Dellinger [mailto:aedellin@mindspring.com] Sent: Tuesday, November 28, 2000 4:17 AM To: pgsql-interfaces@postgresql.org Subject: [INTERFACES] postgreSQL and javascript Is it possible to connect to postgreSQL using JavaScript? If so, how? I= have been=20 reading a lot about JDBC, but it has all java examples. Thanks, Andrew Dellinger ------=_NextPart_000_0093_01C05923.15D39890 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello,
Actually javascript is quite capable of ru= nning=20 server side too. The capabilities of the implementation depend on platform.= =20 While I personally know nothing about connecting javascript to a database, = I=20 have seen examples of this in MSDN (Microsoft Developer's Network). Th= is=20 may or may not only be possible on the Microsoft platform with their javasc= ript=20 implementation. Even then, I think it is a server side thing. Though if you= can=20 do it on the server, you may be able to do it in the client, at least with = IE. I=20 recall seeing something about disconnected recordsets and javascript in a w= rox=20 book somewhere....
 
Don't give up yet. Search on 'disconnected= =20 recordset'... Maybe there is a way.
 
I am of the persuasion that the data shoul= d be=20 extracted by the time that javascript is playing with it. Then again, I sti= ll=20 have a lot to learn. I usually build my javascript datastructures as the pa= ge is=20 being rendered by using either ASP or PHP. Granted, this makes for some=20 cumbersome code, but hey, it is built dynamically and all I need to maintai= n=20 is the piece of code that generates the mess, not the mess itself :=20 )
 
About jdbc... It has absolutely nothing to= do with=20 javascript. It is for java. JavaDataBaseConnectivity. I agree with Pet= er=20 and Adam in their assertion that the name for javascript is=20 problematic. People new to programming would benefit from the distinction o= f a=20 new name.
 
Check out devedge.netscape.com for a=20 decent javascript reference. If you are new to javascript go to=20 javascript.internet.com and start playing with some working scripts to lear= n a=20 little about the way the language works. There are tutorials here too. = ;=20 There may or may not be better sites now. These two have gotten me out of a= ny=20 pickle that I have ever confronted.
 
The most important thing is to first grasp= what an=20 object model is, then learn the DOM or Document Object Model (or at least&n= bsp;=20 print it out and hang it in your cube, you will need it!). From there you w= ill=20 really be able to impress your friends. Using javascript I have approached = the=20 functionality and bells and whistles of thick client Apps (- data acce= ss of=20 course!) in a browser. It is very powerful indeed. When combined with ASP o= r=20 PHP, it is even more so. I don't know how I ever got along without=20 it!
 
Like everything else, javascript works dif= ferently=20 in Netscape than it does in IE. This manifests itself in positioning coordi= nates=20 (Netscape and IE count pixels from different spots), event handlers (IE Sup= ports=20 tag events that Netscape does not). Most likely, both Netscape and Microsof= t's=20 CEOs will go to hell for all the hours of developer torture caused by = their=20 unwillingness to decide on standards and stick by them. They know what the= =20 impact is to millions of developers worldwide, yet they continue. No I don'= t=20 have a preference, I hate both companies with equal ferocity. Do yourself a= =20 favor, debug javascript in Netscape. It is the least common=20 denominator.
 
thx,
Neil
----- Original Message -----
Fro= m:=20 Peter Mount
To: 'Andrew Dellinger' ; pgsql-interfaces@postgres= ql.org=20
Sent: Tuesday, November 28, 2000 3= :55=20 AM
Subject: RE: [INTERFACES] postgreS= QL and=20 javascript

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

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

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

Is it possible to connect to postgreSQ= L using=20 JavaScript? If so, how? I have been
reading a lot about JDBC, but it has a= ll java=20 examples.
 
Thanks,
Andrew=20 Dellinger
------=_NextPart_000_0093_01C05923.15D39890--