Cgi and Database (stick to standards)
ShieldsOnTour at gmail.com
Thu Feb 7 12:18:29 EST 2008
What platform are you running on? Also, which version of revolution?
There was some DB/CGI related problems with the earlier 2.9 Beta -
although I think we've fixed them in the latest Beta.
On 7 Feb, 16:13, Hershel Fisch <her... at rgllc.us> wrote:
> On 2/7/08 10:00 AM, "Richard Miller" <w... 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-revolut... at lists.runrev.com
> >> Please visit this url to subscribe, unsubscribe and manage your
> >> subscription preferences:
> > _______________________________________________
> > use-revolution mailing list
> > use-revolut... at lists.runrev.com
> > Please visit this url to subscribe, unsubscribe and manage your subscription
> > preferences:
> use-revolution mailing list
> use-revolut... 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