Cgi and Database (stick to standards)

Hershel Fisch hershf at rgllc.us
Thu Feb 7 10:13:04 CST 2008


On 2/7/08 10:00 AM, "Richard Miller" <wow at together.net> wrote:

> Hershel,
Hi, and thanks,
> 
> I'm not sure if this is the answer to your question, but I have found
> problems with using http-based url's from inside the cgi folder. You
> might try removing the "http://localhost/cgi-bin" portion, since it
> appears the database is already inside the cgi-bin directory.
For the cgi, I don't use the "http" because I got to understand (after a lot
of struggle) that that¹s only for the apache server other then that I use
the regular path, e.g. In the same folder I just put "filex.x" for the
document folder I use "/filex.x". Also I tried everything I could think of.
As you could see below in the examples.

> 
> Another option is to use a conventional flat file database (i.e. text
> file). I've been using that with Rev cgi with no problem.
I don¹t think that it will work with a million record plus, db.
> 
> Richard
But what I do see that no way to invest in a non standard item or project
unless you know it in and out other wise you might end up in trouble. I put
in a lot of time and effort in a web site doing the front end and it is very
nice and works good but what does it matter the face if the brain is dead.
(despite the advise not to because its not standard and might end up in hot
water in case I will need help and to use "PHP")
Thanks, Hershel
> 
> 
> 
> On Feb 6, 2008, at 8:37 PM, Hershel Fisch wrote:
> 
>> Hi all I'm in the works of creating a web site rev CGI  which the
>> interface
>> is almost done, And now I'm stuck when it comes to the database
>> part. Have
>> no idea how to work this out tried various different way's and ????
>> E.g.
>> 
>> #!revolution
>> 
>> on startup
>>   put 1 & getTip1() into theData
>>   # write minimal set of HTTP headers to stdout
>>   put "Content-Type: text/html" & cr
>>   put "Content-Length:" && the length of theData & cr & cr
>>   put  theData
>> end startup
>> 
>> function getTip1
>>   get  revGetDatabaseDriverPath()
>>   return it
>> end getTip1
>> 
>> function getTip2
>>   get revOpenDatabase("sqlite","http://localhost/cgi-bin/
>> testdb.db", , , , )
>>   return it
>> end getTip2
>> 
>> function getTip3
>>   get revOpenDatabase("sqlite","testdb.db", , , , )
>>   return it
>> end getTip3
>> "ERROR 500"
>> 
>> Any help would be appreciated.
>> Hershel Fisch
>> 
>> _______________________________________________
>> use-revolution mailing list
>> use-revolution at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-revolution
> 
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution




More information about the use-livecode mailing list