Re: MC front end to PostgreSQL - lesson 4

| Perhaps if Pierre agrees I will post the actual stack on his ftp server, | similar to what he has put there. I will take a slightly different | tact in describing things for the list, although the applications are | very similar. And now, lesson 4. I hope I numbered the other ones rig

Re: MC front end to PostgreSQL - lesson 1

| However, one key to successful applications is data base design, so | it is suggested you would put in some effort getting that right before | building too much code for any real world application. Here we go for lesson 3. Data base back end design, and creation. I'd like to em

Re: MC front end to PostgreSQL - lesson 2

| Greetings all, | | Building on the work of Pierre, I would like to share with you another That is Pierre Shores, master MC craftsman, whose native language seems to be French. Mine's English so I'm writing docs. | , the middle piece is a CGI program that | connects the

Re: MC front end to PostgreSQL - lesson 1

Greetings all, Building on the work of Pierre, I would like to share with you another simple MC - web enabled - data base application. This is another example to show how it's done. Kindly pardon any over verbosity or belaboring the obious. It's hard to know who the audience might be, especia

Re: MC front end to PostgreSQL, help!

| Allo Sadhu, | | Did you try in using the "clone this card" command instead of the | "create card" one ? | -- | Cordialement, Pierre Sahores Problem solved. Thank you Pierre! ___ metacard mailing list [EMAIL PROTECTED] http://lists.runrev.co

Re: MC front end to PostgreSQL, help!

On 1/27/03 8:47 AM, Sadhunathan Nadesan wrote: I probably need something changed on the "create card" command or something like that?? If I just put 'go to next card' without the create I end up with only one card. But if I put 'create card' I get a new card but without any of the fields, yet,

Re: MC front end to PostgreSQL, help!

Sadhunathan Nadesan a écrit : > > Help! > > Summary: next card not working for multiple sql data records > > Context; > > I'm building an application using the approach demonstrated by Pierre - > MC front end sends post request to web cgi back end which communicates > with PostgreSQL. > > In

Re: MC front end to PostgreSQL, help!

Help! Summary: next card not working for multiple sql data records Context; I'm building an application using the approach demonstrated by Pierre - MC front end sends post request to web cgi back end which communicates with PostgreSQL. In my case I want something that is similar to the old Win

Re: MC front end to PostgreSQL

| > though it is an html file it is being executed as a cgi script. | > (Perhaps Pierre will explain that little twist to us). | | Simple : each time i watch to the logs of the production servers, i can | see that stupid and negative peoples are trying to hack them, day after | day and without su

Re: MC front end to PostgreSQL

Sadhunathan Nadesan wrote: > > | Subject: Re: MC front end to PostgreSQL > | Reply-To: [EMAIL PROTECTED] > | > | | > | | Allo List, > | | > | | A "build 3" issue of the MCSQL Address Book example app is available for > | | download at : > > In an earlie

Re: MC front end to PostgreSQL

| Subject: Re: MC front end to PostgreSQL | Reply-To: [EMAIL PROTECTED] | | | | | Allo List, | | | | A "build 3" issue of the MCSQL Address Book example app is available for | | download at : In an earlier post today I said I thought I should have posted to this list a few gotchas w

Re: MC front end to PostgreSQL

| Allo Sadhu, | | It's exactly the right way to use : i will update the install docs to | avoid possibles confusions ;) | -- Allo, Pierre, You have made a major contribution in figuring this out, IMHO. Thank you Pierre. Aloha, Sadhu ___ metacard ma

Re: MC front end to PostgreSQL

| | I didn't have time to play with Pierre's thing yet but I kept wondering | what's the benefit of padding each name with ___ to keep a fixed number of | chars in the column names? | | Regards, Andu Novac | Ah, hi I guess I should have posted one mail of 'gotchas' I found t

Re: MC front end to PostgreSQL

andu wrote: > > --On Thursday, January 23, 2003 18:12:32 -0800 Sadhunathan Nadesan > <[EMAIL PROTECTED]> wrote: > > > create table abook ( > > name text primary key, > > company_ text, > > street__ text, > > city text, > > state___ text, > > zipcode_ text, > > telepho1 text

Re: MC front end to PostgreSQL

Sadhunathan Nadesan wrote: > > | > | See the "installabook.txt" for more, including explainations about the > | need of a "primary key" to index the column "name" and the needed > | add of a new "serial-typed" column to the "abook" pg table, used to add > | to each row an unicity control key..

Re: MC front end to PostgreSQL

Sadhunathan Nadesan wrote: > > | > | See the "installabook.txt" for more, including explainations about the > | need of a "primary key" to index the column "name" and the needed > | add of a new "serial-typed" column to the "abook" pg table, used to add > | to each row an unicity control key..

Re: MC front end to PostgreSQL

--On Thursday, January 23, 2003 18:12:32 -0800 Sadhunathan Nadesan <[EMAIL PROTECTED]> wrote: create table abook ( name text primary key, company_ text, street__ text, city text, state___ text, zipcode_ text, telepho1 text, telepho2 text, mail text, web_ te

Re: MC front end to PostgreSQL

| | See the "installabook.txt" for more, including explainations about the | need of a "primary key" to index the column "name" and the needed | add of a new "serial-typed" column to the "abook" pg table, used to add | to each row an unicity control key... | FYI, Pierre, this is what worked

Re: MC front end to PostgreSQL

| | Allo List, | | A "build 3" issue of the MCSQL Address Book example app is available for | download at : | | | Merci, Pierre, I'm out of town on a business trip but will install and test as soon as I get a chance. Good show!

Re: MC front end to PostgreSQL

Allo List, A "build 3" issue of the MCSQL Address Book example app is available for download at : This issue provide new versions of the stacks "addressbook.mc" and "abookcgi.mc", including more clean "update" and "delete" sql statements. Be carefull about

Re: MC front end to PostgreSQL

| | An updated issue of the MCSQL Address Book example app is available for | download at : | | | | This issue provide a replacement version of the stack "addressbook.mc", | including a new "delete card" handler, previously bugged. Greetings, all, I wou

Re: MC front end to PostgreSQL

As usual, Pierre comes through. Merci. The last greater than sign got into the URL by mistake. Try this: ftp://crdp.intereduc.net/MCSQLABOOK/ --- Pierre Sahores <[EMAIL PROTECTED]> wrote: > An updated issue of the MCSQL Address Book example > app is available for > download at : > >

Re: MC front end to PostgreSQL

An updated issue of the MCSQL Address Book example app is available for download at : This issue provide a replacement version of the stack "addressbook.mc", including a new "delete card" handler, previously bugged. -- Cordialement, Pierre Sahores Inspect

Re: MC front end to PostgreSQL

Sadhunathan Nadesan a écrit : > > | > | The best, in my mind, would be to build a general purpose example app, > | directly descibed and shared on the Metacard list, to let evryone become > | able to understand how the purposed technology works and how to reuse it > | to build, from scratch, > | o

Re: MC front end to PostgreSQL

Allo Sadhu, > | > | The best, in my mind, would be to build a general purpose example app, > | directly descibed and shared on the Metacard list, to let evryone become > | able to understand how the purposed technology works and how to reuse it > | to build, from scratch, > | other kinds of dedica

Re: MC front end to PostgreSQL

| | The best, in my mind, would be to build a general purpose example app, | directly descibed and shared on the Metacard list, to let evryone become | able to understand how the purposed technology works and how to reuse it | to build, from scratch, | other kinds of dedicated apps. Agree

Re: MC front end to PostgreSQL

Allo Sadhu and a happy new year to you and yours, Sadhunathan Nadesan a écrit : > > | Yes ! I'm building such Metacard based client apps and, with a back-end > | database server available (PostgreSQL, for me), you can do same in using > | (in addition to the server-side code we spoken about some

Re: MC front end to PostgreSQL

| | I'm working on such a stack right now for a client. It "posts" queries to a | http server + mc cgi which in turn passes them to the database using | shell(), then replies the results back to the client. I can't make it | publicly available though, just a confirmation that it can be done wit

Re: MC front end to PostgreSQL

| Yes ! I'm building such Metacard based client apps and, with a back-end | database server available (PostgreSQL, for me), you can do same in using | (in addition to the server-side code we spoken about some weeks ago in | this thread) such kind of code to do this client speak with the back-end |

Re: MC front end to PostgreSQL

--On Tuesday, January 07, 2003 15:01:23 -0800 Sadhunathan Nadesan <[EMAIL PROTECTED]> wrote: In other words, something where the front end is running on the client (an MC app) and the back end is a data base across the web on the server. Something with rich a interactive nature, the kind of ap

Re: MC front end to PostgreSQL

Sadhunathan Nadesan a écrit : > > | Just as you say, Alain and we, all, are going to open "l'avenue des > | Champs-Elysees" to the web-dedicated metacard developments. > | "Because they did'nt know it was impossible,..." ;-) > | > | > > Do you mean you will distribute MC > | > > stacks and the use

Re: MC front end to PostgreSQL

| Just as you say, Alain and we, all, are going to open "l'avenue des | Champs-Elysees" to the web-dedicated metacard developments. | "Because they did'nt know it was impossible,..." ;-) | | > > Do you mean you will distribute MC | > > stacks and the user won't go through a browser? | > | > You

Re: MC front end to PostgreSQL

| Alain Farmer | xCard fanatic | | PS: I should probably mention that in addition to all | of the above, the Java version of FreeCard will be | able to be embedded into web-pages in the same manner | that Java applets are. No separate program or plugin; | the stack in a portion of the web-page. Or

RE: MC front end to PostgreSQL

Ray, > 17. Accidentally delete your complete web page ~ 1 second. Just way *too* funny Now...how many steps does it take to build your first "hello world" C DLL (I'm still counting) -Chipp ___ metacard mailing list [EMAIL PROTECTED] http://lists.

Re: MC front end to PostgreSQL

> Did you try Opera 5 (Andu said, previously, that Opera 6 linux is > bugged) or, else Mozilla, whoses works fine there on both Linux and > Jaguar ? I tried Opera, but was not satisfied with a thing that seemed to me as a crude unfinished port ;-> Really -- I am pleased with the functionalities o

Re: MC front end to PostgreSQL

t: Thursday, December 19, 2002 5:08 PM Subject: Re: MC front end to PostgreSQL > Yo troops, > With all this talk about the pleasures of working with HTML, I just > couldn't resist sending this along... > > -- > HOW TO BUILD A WEB PAGE IN 25 STEPS > 1. Do

Re: MC front end to PostgreSQL

andu wrote: > > --On Thursday, December 19, 2002 10:42:11 -0800 Scott Rossi > <[EMAIL PROTECTED]> wrote: > > > IMO, HTML has evolved; look at all the spinoffs: DHTML, XML, SMIL, etc. > > The bigger problem is (lack of) standards. > > You just mentioned a few, the even bigger problem seems to be

Re: MC front end to PostgreSQL

Yo troops, With all this talk about the pleasures of working with HTML, I just couldn't resist sending this along... -- HOW TO BUILD A WEB PAGE IN 25 STEPS 1. Download a piece of Web authoring software ~ 20 minutes. 2. Think about what you want to write on your Web page ~ 6 wee

Re: MC front end to PostgreSQL

--On Thursday, December 19, 2002 22:36:42 + jbv <[EMAIL PROTECTED]> wrote: Pierre & Andu , andu a écrit : > > When it comes to browsers they should be considered bugged when they > work... I'd like to understand why people use javascript when they can > do with plain html. Allo Andu,

Re: MC front end to PostgreSQL

Pierre & Andu , > andu a écrit : > > > > > When it comes to browsers they should be considered bugged when they work... > > I'd like to understand why people use javascript when they can do with > > plain html. > > Allo Andu, > > I agree with you. Most browser-side problems are happening in pars

Re: MC front end to PostgreSQL

--On Thursday, December 19, 2002 10:42:11 -0800 Scott Rossi <[EMAIL PROTECTED]> wrote: IMO, HTML has evolved; look at all the spinoffs: DHTML, XML, SMIL, etc. The bigger problem is (lack of) standards. You just mentioned a few, the even bigger problem seems to be sticking to just one ;-).

Re: MC front end to PostgreSQL

Recently, "andu" wrote: > If we talk about public web sites the goal should be "absolute > accessibility everywhere". This is of course a worthy goal, but it's pretty daunting when you run up against lack of standards and inconsistent feature support in browsers. I can't even begin to imagine th

Re: MC front end to PostgreSQL

--On Thursday, December 19, 2002 08:54:59 -0800 Scott Rossi <[EMAIL PROTECTED]> wrote: Recently, andu wrote: I'd like to understand why people use javascript when they can do with plain html. Speaking for myself, Javascript allows me to script interactivity that is not possible with straigh

Re: MC front end to PostgreSQL

--On Thursday, December 19, 2002 16:49:34 +0100 Pierre Sahores <[EMAIL PROTECTED]> wrote: andu a écrit : --On Thursday, December 19, 2002 15:00:53 +0100 Pierre Sahores <[EMAIL PROTECTED]> wrote: > Did you try Opera 5 (Andu said, previously, that Opera 6 linux is > bugged) or, else Mozilla, w

Re: MC front end to PostgreSQL

Recently, andu wrote: > I'd like to understand why people use javascript when they can do with > plain html. Speaking for myself, Javascript allows me to script interactivity that is not possible with straight HTML: functions, variables, image management, etc. The biggest issue to deal with is c

Re: MC front end to PostgreSQL

andu a écrit : > > --On Thursday, December 19, 2002 15:00:53 +0100 Pierre Sahores > <[EMAIL PROTECTED]> wrote: > > > Did you try Opera 5 (Andu said, previously, that Opera 6 linux is > > bugged) or, else Mozilla, whoses works fine there on both Linux and > > Jaguar ? > > When it comes to browser

Re: MC front end to PostgreSQL

--On Thursday, December 19, 2002 15:00:53 +0100 Pierre Sahores <[EMAIL PROTECTED]> wrote: Did you try Opera 5 (Andu said, previously, that Opera 6 linux is bugged) or, else Mozilla, whoses works fine there on both Linux and Jaguar ? When it comes to browsers they should be considered bugged w

Re: MC front end to PostgreSQL

Dominique a écrit : > > > Are you speaking from the "indexes page" form submit javascript ? It works > > ok under Netscape 4.7, different issues of Explorer, Mozilla 1.3 and Opera > > 5 under Linux, Jaguar, Win98 and Win2K. It's a javascript 1.5 specs code. > > In the iCab prefs ("inScript") all

Re: MC front end to PostgreSQL

> Are you speaking from the "indexes page" form submit javascript ? It works > ok under Netscape 4.7, different issues of Explorer, Mozilla 1.3 and Opera > 5 under Linux, Jaguar, Win98 and Win2K. It's a javascript 1.5 specs code. In the iCab prefs ("inScript") all the specs are checked, from 1.0 t

Re: MC front end to PostgreSQL

Alain Farmer a écrit : > > Hello, > > Excuse me for budding in but ... YEAH! > > > How can MC replace an HTML Web form? > > Use MetaCard's widgets instead of the poor unreliable > ones that we have to use when using HTML to create the > form and JavaScript to make it interactive. Instead of > t

Re: MC front end to PostgreSQL

Sannyasin Sivakatirswami a écrit : > > mmm interesting > > "replace the standard web forms in most of the next production apps" > > how can MC replace an HTML Web form? do you mean you will distribute MC > stacks and the user won't go through a browser? Exactly ! In using MC 2.4.3/libURL 1.0.

Re: MC front end to PostgreSQL

Hello, Excuse me for budding in but ... YEAH! > How can MC replace an HTML Web form? Use MetaCard's widgets instead of the poor unreliable ones that we have to use when using HTML to create the form and JavaScript to make it interactive. Instead of the "submit" button, your script then POSTs the

Re: MC front end to PostgreSQL

mmm interesting "replace the standard web forms in most of the next production apps" how can MC replace an HTML Web form? do you mean you will distribute MC stacks and the user won't go through a browser? Sivakatirswami On Wednesday, December 18, 2002, at 10:38 AM, Pierre Sahores wrote: In

Re: MC front end to PostgreSQL

Dominique a écrit : > > > Just have an eye at in using > > Mon iCab plante (erreur 2) sur le javascript ;-< > My iCab copy chokes (error 2) on the javascript used in your page ;-< > > Maybe not your fault, but iCab's... > ;-) > > -- > Regards, > (-8 Domi

Re: MC front end to PostgreSQL

> Just have an eye at in using Mon iCab plante (erreur 2) sur le javascript ;-< My iCab copy chokes (error 2) on the javascript used in your page ;-< Maybe not your fault, but iCab's... ;-) -- Regards, (-8 Dominique __

Re: MC front end to PostgreSQL

Sadhunathan Nadesan a écrit : > > Fantastic, Pierre! > > Simple is beautiful. > > Do you happen to have any working examples, meaning, a front end to > an existing site? > > Merci! > > Sadhu > > | > | Allo Friends, > | > | For the ones using Oracle or PostgreSQL backend databases (unix hosted

Re: MC front end to PostgreSQL

Fantastic, Pierre! Simple is beautiful. Do you happen to have any working examples, meaning, a front end to an existing site? Merci! Sadhu | | Allo Friends, | | For the ones using Oracle or PostgreSQL backend databases (unix hosted) | and wants to drive them from within mc apps, without t