Re: Rev CGI Post

2007-08-06 Thread Bridger Maxwell
Hey, Never mind, problem solved! By looking at the PHP script, I was able to throw together a script to write the POST and receive a response from PayPal by reading and writing to sockets. I am still curious to know if I can use in libURL functions in a Rev CGI though. TTFN Bridger

Re: Rev CGI Post

2007-08-06 Thread Dave Cragg
On 6 Aug 2007, at 06:21, Bridger Maxwell wrote: My CGI is receiving the data, and I try to send a POST back, but no data is in the it variable or the result. How do I get the data? Is the POST command available in a CGI? Should I just do this with my own custom sockets? My CGI

Re: Valentina for Revolution Upgraded to 3.2; Valentina Studio Gains Diagramming

2007-08-06 Thread Ruslan Zasukhin
On 6/8/07 8:17 AM, Andre Garzia [EMAIL PROTECTED] wrote: Lynn, can we use Valentina Server Community Edition with Rev? No Andre, It is made to work only with VPHP and VRUBY. For WEB sites development. -- Best regards, Ruslan Zasukhin VP Engineering and New Technology Paradigma Software,

Latest Engine for Darwin

2007-08-06 Thread Sivakatirswami
I'm testing some cgi's locally on OSX and getting errors, Apache is throwing Internal Server Errors for simple function calls... Meanwhile the same cgi's and stacks are working fine on Linux on our remote web serve in San Francisco (using the 2.6.1 linux engine with stacks save in legacy format)

RE: Rev CGI Post

2007-08-06 Thread Robert Mann
I am having a similar problem with paypal, trying to use the script that Thomas McCarthy put together myPDT.cgi which was a great help to get me going. on startup --StartCGI --read info put $QUERY_STRING into theBuffer put theBuffer into theTermsArray --keep the original info. put

Re: Valentina for Revolution Upgraded to 3.2; Valentina Studio Gains Diagramming

2007-08-06 Thread Andre Garzia
Thanks Ruslan, I thought maybe I could use the Valentina External to talk to it and use it from Revolution based CGIs. Best andre On 8/6/07, Ruslan Zasukhin [EMAIL PROTECTED] wrote: On 6/8/07 8:17 AM, Andre Garzia [EMAIL PROTECTED] wrote: Lynn, can we use Valentina Server Community

Re: Rev CGI Post

2007-08-06 Thread Andre Garzia
Friends, If you guys are using CGIs for that, usually you can use shell() to call cURL or wget. I think it's a nice way to talk with PayPal IPN Cheers andre On 8/6/07, Robert Mann [EMAIL PROTECTED] wrote: I am having a similar problem with paypal, trying to use the script that Thomas

Re: Re: Reading Dos text (Cp850, Cp437, Cp1252)

2007-08-06 Thread Malte Brill
Thanks Mark (and sorry for the late reply), that´s what I was afraid of. *sigh* All the best, Malte One way would be to simply (and rather painstakingly!) build arrays (storable as customPropertySets) as look-ups for each code page, such that you could then do: repeat for each char c in

sqlite and update

2007-08-06 Thread haribo
hi, now, i spend 3 days for update problem, i can insert, delete, no problem, then i want update one person, its terrible, first i have this code on mouseUp global gConId put field Name into tName put field Vorname into tVorname put field Strasse into tStrasse put field Hausnr

Re: XCMD/XFCN on Rev 2.6.1 Classic

2007-08-06 Thread Brian Yennie
Hopefully I'm not just confusing the issue, but weren't Type 2 externals simply ones that used the special callbacks added in HC 2.0 (for example the external window interface)? Otherwise they were identical IIRC, it's just a matter of which callbacks you could use. If this were the

Re: Revcon Las Vegas

2007-08-06 Thread Bob Sneidar
I used to know a Jim Sims in Orange County California. This would not be that same Jim would it? Bob Sneidar IT Manager Logos Management Calvary Chapel CM On Apr 3, 2007, at 8:09 PM, Jim Sims wrote: On Apr 4, 2007, at 4:31 AM, Stephen Barncard wrote: It would be great to have lodging and

Re: sqlite and update

2007-08-06 Thread Christian Langers
Hello, The SQL syntax for Update is : UPDATE table_name SET column_name = new_value WHERE column_name = some_value Here is a good reference : http://w3schools.com/sql/sql_update.asp e.g. put UPDATE Schueler SET Name= tName, Vorname=tVorname, Strasse=tStrasse, Hausnr= tHausnr, PLZ=

Re: sqlite and update

2007-08-06 Thread Henk van der Velden
Hi Ralle, Next to Christian's reply, consider using an array. Your input should read like this: put fld name into data[1] put fld vorname into data[2] That way you don't need the long list of variables at the end of your query. And there's a typo you may have missed: ::16 Regards, Henk On

Re: sqlite and update

2007-08-06 Thread Jan Schenkel
--- haribo [EMAIL PROTECTED] wrote: hi, now, i spend 3 days for update problem, i can insert, delete, no problem, then i want update one person, its terrible, first i have this code [snip] dont work need help Ralle Hi Ralle, I replied to your question on the runrev.com forum -

Re: Inserting images as BLOBs - any way to avoid using base64encode?

2007-08-06 Thread Andre Garzia
Terry, why not keeping the images as external files and putting a field in the database with the file path? this would lead to databases with less chunk in it since to use the images you'd have to output them to files anyway. something like this: Hard Drive Image ID

Getting table and field names

2007-08-06 Thread Mikey
I'm looking all over but I can't find SQL commands to use with ODBC to extract the table names for a database, and once I have those to extract the column names for a table. My SQL is pretty darn rusty, in case you couldn't figure that out already. TIA.

Re: Inserting images as BLOBs - any way to avoid using base64encode?

2007-08-06 Thread Jan Schenkel
--- Terry Judd [EMAIL PROTECTED] wrote: Hi - I'm about to use SQLite to store all the resources for a large ed application I'm about to start building and was wondering whether there was any way to get images into and out of the database without having to base64encode/decode them. It looks

Re: SQL Too many client tasks

2007-08-06 Thread Jan Schenkel
--- Peter Bower, M.D. [EMAIL PROTECTED] wrote: I am reading and writing to an access database using revolution. All seems to go well, then after 10 transactions I get a (ODBC Microsoft Access Driver) too many client tasks error. After each open command to read or write to the database I

Re: Getting table and field names

2007-08-06 Thread Jan Schenkel
--- Mikey [EMAIL PROTECTED] wrote: I'm looking all over but I can't find SQL commands to use with ODBC to extract the table names for a database, and once I have those to extract the column names for a table. My SQL is pretty darn rusty, in case you couldn't figure that out already.

More: Getting table and field names

2007-08-06 Thread Jan Schenkel
--- Mikey [EMAIL PROTECTED] wrote: I'm looking all over but I can't find SQL commands to use with ODBC to extract the table names for a database, and once I have those to extract the column names for a table. My SQL is pretty darn rusty, in case you couldn't figure that out already.

Re: Getting table and field names

2007-08-06 Thread Mikey
Jan, Then how does RR's query builder build the list of tables in the second tab? ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences:

Re: Rev CGI Post

2007-08-06 Thread Bridger Maxwell
Hey, The way you are reading info is for an HTTP GET, I am not sure if that is how PDT sends the data, but with IPN, the data is sent in an HTTP POST. You can check to see how the data is being sent by looking at the $REQUEST_METHOD global. Here is my script to read from the POST data: put

Re: Getting table and field names

2007-08-06 Thread Jan Schenkel
--- Mikey [EMAIL PROTECTED] wrote: Jan, Then how does RR's query builder build the list of tables in the second tab? Hi Mikey, It basically uses two approaches: if it's a database type for which Revolution has a native driver, then it uses the undocumented function 'revdb_tablenames' to get

Re: Getting table and field names

2007-08-06 Thread Mikey
OK, so to save me from poking all over the place, I'm assuming that revdb_tablenames is a command not handled somewhere else, right? ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and

TTS-follow-up

2007-08-06 Thread jgrubb75
Mark, Thanks for the response. I read somewhere that GB2312 is a subset of unicode, or vice versa. So the conversion is probably fairly simple. There's gotta be some algorithm out there for the conversion. If so, it seems like I could have a function that would convert the unicode to GB just

Re: Getting table and field names

2007-08-06 Thread Jan Schenkel
--- Mikey [EMAIL PROTECTED] wrote: OK, so to save me from poking all over the place, I'm assuming that revdb_tablenames is a command not handled somewhere else, right? The function 'revdb_tablenames' is implemented in the Revolution database library, a set of external commands and functions

SQL Access with Rev CGI

2007-08-06 Thread Bridger Maxwell
Hey, I have just got a Rev CGI set up on my Dreamhost server, and I would like it to access my SQL database. I have been searching around the list archive, and it seems like it is possible, but I can't figure it out. Is there a driver I need to download? Where can I get that driver?

Re: Getting table and field names

2007-08-06 Thread Mark Wieder
Mikey- I'm looking all over but I can't find SQL commands to use with ODBC to extract the table names for a database, and once I have those to extract the column names for a table. My SQL is pretty darn rusty, in case you couldn't figure that out already. Jan has already given you most of

Windows Exe Crashes

2007-08-06 Thread Tracy Riegle
Hi All, I'm new to this list, so please forgive me if I ask a question that has already been answered (although I searched the archive and couldn't find an answer). I'm using Rev 2.8.1 build 472. I have a stack with about two dozen cards, with each card having a large image on it, and several

Re: Windows Exe Crashes

2007-08-06 Thread Derek Bump
Hello Tracy, You should consider using a Loading stack. This would mean that you would have 2 stacks. The first one loads the second one. And the first one could be built into any format, ensuring that the second one stays the same. So in other words. |---|

Re: Windows Exe Crashes

2007-08-06 Thread Tracy Riegle
Actually, I tried that and it worked. But here are my questions to that approach. Does the main stack NOT get compiled? Will my main stack now be available in its source format (I don't want the source to be available to the public)? Thanks for the help. -Tracy On Aug 6, 2007, at Monday,

Re: Windows Exe Crashes

2007-08-06 Thread Bridger Maxwell
Actually, even the stack that gets compiled into a .exe still has its source available. If you drag the executable to a text editor and scroll through all of the garbage, you can find all of your scripts in plain text. Compiling a stack is essentially attaching the Revolution engine to a stack.

RE: Rev CGI Post

2007-08-06 Thread Robert Mann
Any info on how this is done? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andre Garzia Sent: Monday, August 06, 2007 10:38 AM To: How to use Revolution Subject: Re: Rev CGI Post Friends, If you guys are using CGIs for that, usually you can use

Re: Rev CGI Post

2007-08-06 Thread Mark Smith
An example of POSTing with curl: function curlPost pData, pURL put the tempName into tFile put urlEncode(pData) into URL (binfile: tFile) put curl -s --data-binary @ tFile pURL into tCurlString put shell(tCurlString) into tResponse delete file tFile return tResponse end curlPost

Re: Inserting images as BLOBs - any way to avoid using base64encode?

2007-08-06 Thread Terry Judd
Thanks Andre - I've used that sort of approach in the past but the guys providing the content on this project are very protective of their stuff (images) and a 'real' database seems the best option. Regards, Terry... Terry, why not keeping the images as external files and putting a field in

Re: Inserting images as BLOBs - any way to avoid using base64encode?

2007-08-06 Thread Terry Judd
Hi Jan - I'm already doing something along these lines except with the base64encode/decode routines thrown in. Getting the image into the database without encoding seems? to work ok but when I pull it out I can only get hold of the first few characters, typically something like 'âPNG' and a couple

Re: Inserting images as BLOBs - any way to avoid using base64encode?

2007-08-06 Thread Devin Asay
On Aug 6, 2007, at 5:38 PM, Terry Judd wrote: Hi Jan - I'm already doing something along these lines except with the base64encode/decode routines thrown in. Getting the image into the database without encoding seems? to work ok but when I pull it out I can only get hold of the first few

Unicode filenames

2007-08-06 Thread Mark Smith
Has anyone found any kind of workaround for using unicode in filenames (bug 2646)? Applescript, shell, cross-platform? Anything at all? Best, Mark ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe,

Re: Inserting images as BLOBs - any way to avoid using base64encode?

2007-08-06 Thread Mark Wieder
Devin- the variable you're loading it into *must* be accessed later in another statement, otherwise the download fails. It's almost like the variable doesn't become a valid variable unless it's accessed later. ...and if you (ahem) declare your local variables you'll find that it

Re: SQL Access with Rev CGI

2007-08-06 Thread Bridger Maxwell
Hey, Again, somehow asking the question allows me to see the answer. Funny how that happens. I thought I would share what works, in case someone else runs into the same problem. First of all, my Linux CGI engine is version 2.6.6, which I got off of the runrev ftp site. The mysql driver I am

Re: Inserting images as BLOBs - any way to avoid using base64encode?

2007-08-06 Thread Terry Judd
Another good case for declaring local variables I guess. It all works 'as advertised' now. Thanks Devin, Mark, Jan (and various contributors to the list archives). Cheers, Terry... Devin- the variable you're loading it into *must* be accessed later in another statement, otherwise the

Re: Inserting images as BLOBs - any way to avoid using base64encode?

2007-08-06 Thread Ruslan Zasukhin
On 6/8/07 8:46 PM, Andre Garzia [EMAIL PROTECTED] wrote: Hi Andre, Hi Terry, 1) If DBMS is REALLY fine to work with BLOBs then no need use any encodings. The fact you need use encoding (i.e. Convert it into TEXT form), says that DB cannot keep true BLOBs. I believe that e.g.

Re: Inserting images as BLOBs - any way to avoid using base64encode?

2007-08-06 Thread Ruslan Zasukhin
On 7/8/07 2:32 AM, Terry Judd [EMAIL PROTECTED] wrote: Hi Terry, Thanks Andre - I've used that sort of approach in the past but the guys providing the content on this project are very protective of their stuff (images) and a 'real' database seems the best option. Aha, so this is exactly the

Re: Rev CGI Post

2007-08-06 Thread Brent Anderson
The basic command would be built somewhat like... get shell(wget http://mysite.com/cgi-bin/somescript? param1=Fooparam2=Bar) Look up the documentation for wget or cURL for the myriad of options. Thanks, Brent Anderson Fiery Ferret www.fieryferret.com