Hello,
I have been unable to find any reference to code examples for doing
Transaction Processing with SQLite DB
I have only found a note from Trevor revExecuteSQL to BEGIN TRANSACTION etc
without an example.
Could someone provide a code example that starts with the BEGIN TRANSACTION
and
This isn't specific example including complete code but the general
flow is:
revExecuteSQL gDBID,BEGIN TRANSACTION
.
revdbExecute your SQL command
if error
revRollBackDatabase gDBID
exit
end if
.
revdbExecute your SQL command
if error
revRollBackDatabase gDBID
amount of data (approx. 0 - 1000 characters of data). What I need to do is
upload the data to either a MySQL database or as text files in a folder on
the server. The update would be done when the user quits the software.
I am looking for any suggestions on the best way to do this as I have some
Le 18 oct. 2010 à 20:41, Andrew Kluthe a écrit :
The client never actually gets the login credentials for the database
because they are stored in our private big client DB. On startup the rev
program fetches the credentials from our database and connects to theirs to
begin working
.
len morgan
On 10/19/2010 2:27 AM, Pierre Sahores wrote:
Le 18 oct. 2010 à 20:41, Andrew Kluthe a écrit :
The client never actually gets the login credentials for the database
because they are stored in our private big client DB. On startup the rev
program fetches the credentials from our
Len Morgan wrote:
I guess I'm going to have to throw away everything I've done
so far and start over with the web based approach that Pierre
suggested. It's going to kill my performance but it's the
only option I've got open to me at this point.
What is the performance difference?
And can
Len Morgan wrote:
I guess I'm going to have to throw away everything I've done
so far and start over with the web based approach that Pierre
suggested. It's going to kill my performance but it's the
only option I've got open to me at this point.
What is the performance difference?
for the database
because they are stored in our private big client DB. On startup the
rev
program fetches the credentials from our database and connects to theirs
to
begin working with it.
Definitively the way to go !
I would hate to have to rewrite my entire suite of programs to center
around
-writing all my apps to use a different transaction method.
--
View this message in context:
http://runtime-revolution.278305.n4.nabble.com/on-rev-remote-database-tp2998969p3002355.html
Sent from the Revolution - User mailing list archive at Nabble.com
Whiskey Tango?
What Len Morgan wrote was:
This is all a moot point now since I have just been informed by
Heather that the only way the on-rev server can be set up to do
this is if you give them all of the IP addresses that people are
going to connect from and they will allow those IP
that Pierre suggested. It's going to kill my performance but
it's the only option I've got open to me at this point.
len morgan
On 10/19/2010 2:27 AM, Pierre Sahores wrote:
Le 18 oct. 2010 à 20:41, Andrew Kluthe a écrit :
The client never actually gets the login credentials for the database
I know they are unlimited, but I need remote access for all ip's. Can you
wildcard for all domains and IP's with on-rev and mySQL?
--
View this message in context:
http://runtime-revolution.278305.n4.nabble.com/on-rev-remote-database-tp2998969p3002656.html
Sent from the Revolution - User
and mySQL?
--
View this message in context:
http://runtime-revolution.278305.n4.nabble.com/on-rev-remote-database-tp2998969p3002656.html
Sent from the Revolution - User mailing list archive at Nabble.com.
___
use-revolution mailing list
use-revolution
and IP's with on-rev and mySQL?
--
View this message in context:
http://runtime-revolution.278305.n4.nabble.com/on-rev-remote-database-tp2998969p3002656.html
Sent from the Revolution - User mailing list archive at Nabble.com.
___
use-revolution mailing
It's not available in cpanel now. I looked. I thought it was in the USERS
and / or MySQL area a while ago.
On 19 October 2010 12:22, Mike Bonner bonnm...@gmail.com wrote:
Pretty sure you can, check the tool in cpanel, I believe I read in there
that % is allowable.
Stephen Barncard
San
Look on cPanel under databases section, theres a link for remote mysql.
This is on Odin.
On Tue, Oct 19, 2010 at 2:09 PM, stephen barncard
stephenrevoluti...@barncard.com wrote:
It's not available in cpanel now. I looked. I thought it was in the USERS
and / or MySQL area a while ago.
On 19
wow. I was wrong. thanks
s
On 19 October 2010 13:24, Mike Bonner bonnm...@gmail.com wrote:
Look on cPanel under databases section, theres a link for remote mysql.
This is on Odin.
On Tue, Oct 19, 2010 at 2:09 PM, stephen barncard
stephenrevoluti...@barncard.com wrote:
It's not
Glad it was there. Never sure if there will be complete parity across server
boundaries!
On Tue, Oct 19, 2010 at 3:28 PM, stephen barncard
stephenrevoluti...@barncard.com wrote:
wow. I was wrong. thanks
s
On 19 October 2010 13:24, Mike Bonner bonnm...@gmail.com wrote:
Look on cPanel
Folks,
You can have remote connections for MySQL databases by setting the remote
mysql option. Even though PostgreSQL is more pure than MySQL, right now,
going thru mySQL might be a good option for your read only database.
:-D
On Tue, Oct 19, 2010 at 7:33 PM, Mike Bonner bonnm...@gmail.com
that are stored in a database with NO remote access.
Seems about as safe as a cgi for manipulating the db.
--
View this message in context:
http://runtime-revolution.278305.n4.nabble.com/on-rev-remote-database-tp2998969p3002871.html
Sent from the Revolution - User mailing list archive at Nabble.com
to connect to the database, if it is so, then it will
answer back with a login/password combination to the client.
2) the client use the login/password combination from step 1 to connect to
the database. If connection breaks or expires, do step 1 again.
This login/pass combination can be generated
I appreciate everyone's concern about about the security of my
database but I assure you that this isn't my first rodeo (small 'r' -
not a plug :-) ) and have been write secure computer systems for prison
management for over 10 years - most of them with remote access.
I should probably
This is not a good idea. I agree with the best practices notion that direct
access to remote SQL servers is in general a bad thing. There are tricks you
can use to harden them. I know our web guy got really really good at this.
Still, you have to know what you are doing, and apart from IP
Morgan a écrit :
Pierre,
I'm trying to write a program that will access data on a public database
(Postgresql) and I don't really want to give pgAdmin to all of my users.
That would be disaster! The localhost only access has never been the case.
I've been using Postgres for more than
Pierre,
It's only a security risk if I let the users WRITE to the database which
I have no intention of doing. The reason I'm trying to avoid and irev
script in the middle is that I don't want to have to connect and
disconnect every time a user asks for data. If you have a sample irev
Ien,
See what i wrote to days ago to Bill... See the requests example jointed below.
Is't the use rev list a cool library ? ;-)
Hello Bill,
I'm not even sure if I'm asking the question correctly.
I've made a simple time tracking database for my colleagues. Dates, fill-ins,
drop downs etc
or quotes. Different
engines subscribe to different syntax and subsets of syntax, so you need to
know the engine you are working with.
Also the kind of encoding your database uses comes into play if you are using
any kind of data that contains non-ASCII characters. I know you could say, I
won't
This is simply untrue. I do it now. You have to enter an IP that you are
allowed to connect from in your IP Filtering list. I forget exactly how at the
moment because I don't have the cPanel open, but this is DEFINITELY DOABLE!
Bob
On Oct 17, 2010, at 5:27 PM, Pierre Sahores wrote:
Ien,
Bob,
True. Sorry for forgotting to precise this along the best practice i prefer to
follow (client - irev - localhost connection to pg) even if in this case,
each client app need to be authenticated (login/pass send as MD5(fp)) to be
seen and accepted as safe and authorised to exchange
database for a client and execute a statement to set up the
database to be used with our client program.
Our client program uses SQL Yoga to connect directly to the client's
database and they can work with the same database from as many computers as
they need.
The client never actually gets
I seem to remember someone having trouble connecting to a database on
their on-rev account remotely a while back. Was this ever resolved?
I'd like to have a database that can be accessed from anywhere but I'd
rather not go through the hoops of making a web service to get at the data
(MySQL for the
earliest ones, and PostgreSQL for all the other and next to come.
HTH,
Pierre
Le 17 oct. 2010 à 13:05, Len Morgan a écrit :
I seem to remember someone having trouble connecting to a database on their
on-rev account remotely a while back. Was this ever resolved? I'd like to
have
Le 17 oct. 2010 à 13:05, Len Morgan a écrit :
I seem to remember someone having trouble connecting to a database on their
on-rev account remotely a while back. Was this ever resolved? I'd like to
have a database that can be accessed from anywhere but I'd rather not go
through the hoops
On Oct 16, 2010, at 12:34 PM, Bill Ziegler wrote:
I'm not even sure if I'm asking the question correctly.
I've made a simple time tracking database for my colleagues. Dates, fill-ins,
drop downs etc. I'm not using any of the sophisticated Rev DB tools or SQL. I
am just saving each
environment and some of my apps use both on a 24/7 basis (MySQL for
the earliest ones, and PostgreSQL for all the other and next to come.
HTH,
Pierre
Le 17 oct. 2010 à 13:05, Len Morgan a écrit :
I seem to remember someone having trouble connecting to a database on their
on-rev
Pierre,
I'm trying to write a program that will access data on a public database
(Postgresql) and I don't really want to give pgAdmin to all of my
users. That would be disaster! The localhost only access has never
been the case. I've been using Postgres for more than 15 years now and
I
I'm not even sure if I'm asking the question correctly.
I've made a simple time tracking database for my colleagues. Dates, fill-ins,
drop downs etc. I'm not using any of the sophisticated Rev DB tools or SQL. I
am just saving each collection of responses in separate fields. I also have
with or without SQL what's my best option to
learn how to do whatever I'll need to do.
http://www.w3schools.com/sql/default.asp
and
http://lessons.runrev.com/spaces/lessons/buckets/784/lessons/7003-Connecting-to-a-MySQL-database
should get you most of the way
Hello Bill,
I'm not even sure if I'm asking the question correctly.
I've made a simple time tracking database for my colleagues. Dates, fill-ins,
drop downs etc. I'm not using any of the sophisticated Rev DB tools or SQL. I
am just saving each collection of responses in separate fields. I
I've spent the weekend refreshing on databases. I'm using LiveCode and also
Trevor's fabulous sqlYoga, and beginning to realise how little I know about
databases! The question I've got is about the database schema design and
optimising it for the speed of adding records.
* Exporting Handlers*
I
Hi David
However if I uses a
surrogate primary key (ie the usual auto-incremented numeric id field), for
each updated record I need to check first whether it is already in the
database before adding it - this is a lot of overhead in terms of finding
the ids based on other fields.
I haven't
| 1
to the database. Using INSERT with the primary key set to the autoincrement
id field, you would get records like this:
*id | name | type | location | hnum*
1 | test_Command| c | stack Test | 1
2 | test_Command| c | stack Test | 1
3 | another_Command | c
HI Monte - hows down-under :)
Getting better all the time ;-)
Only by making the primary key = name,type,location,hnum instead of id
woudl you get a fast normalisation of the data inserted.
You can create an secondary key for those fields and still use your primary key
auto-increment field
OK - not getting very far with that - Google is not my friend :)
Can you give me an idea of what the CREATE statement would look like?
CREATE TABLE 'handler' (
'name' VARCHAR(255) NOT NULL,
'type' VARCHAR(255) NOT NULL,
'location' VARCHAR(255) NOT NULL,
'handler_num' INTEGER
Try:
-- -
-- Table `handler`
-- -
CREATE TABLE IF NOT EXISTS `handler` (
`id` INT NOT NULL AUTO_INCREMENT ,
`name` VARCHAR(255) NOT NULL ,
`type` VARCHAR(255) NOT NULL ,
`location`
Thanks for that Monte,
On 27 September 2010 13:44, Monte Goulding mo...@sweattechnologies.comwrote:
UNIQUE INDEX `mykey` (`name`, `type`, `location`, `handler_num`) );
Or you can use a separate Create Unique Index statement.
OK - will have to read up more on Indexes - I thought they were
warrenk...@gmail.com wrote:
I am developing software that needs to pass information to a centralized
MySQL database. My current host started blocking connections as they said
the MySQL database was for web applications only and had an issue with
updating it with an application. Plus they only
I am developing software that needs to pass information to a centralized
MySQL database. My current host started blocking connections as they said
the MySQL database was for web applications only and had an issue with
updating it with an application. Plus they only allowed a few concurrent
Change hosts or use a cgi interface, not a direct connection.
On 16 September 2010 13:32, Warren Kuhl warrenk...@gmail.com wrote:
I am developing software that needs to pass information to a centralized
MySQL database. My current host started blocking connections as they said
the MySQL
it back to your
encrypted stack at shutdown and delete the hidden file. Anyone that knows it's
a rev stack could open the file in rev, copy out the db file and see your data
though.
Cheers
Monte
On 04/09/2010, at 3:56 PM, Warren Kuhl wrote:
Is there anyway to encrypt a SQLite database that I can
Monte,
I thanks for the advice. $2000 is a little steep. I may loook at
writing an encryption/decrypt module for my data and decrpyt it after
retrieving it from the database.
Thanks!
Warren
On Sat, Sep 4, 2010 at 2:58 AM, Monte Goulding
mo...@sweattechnologies.com wrote:
Not without writing
Valentina offers encryption and for a great deal less than $2000. It's
also a much more robust and faster database with lots more to offer.
The latest Valentina Studio application offers ways to convert SQLite
to Valentina also.
On Sat, Sep 4, 2010 at 12:05 PM, Warren Kuhl warrenk...@gmail.com
Valentina offers encryption and for a great deal less than
$2000. It's also a much more robust and faster database with
lots more to offer.
The latest Valentina Studio application offers ways to
convert SQLite to Valentina also.
Thanks Bill for the recommendation!
Although you can treat
Is there anyway to encrypt a SQLite database that I can use in
Revolution Studio?
Thanks for any suggestions!
Warren
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
-connecting-with-database-or-why-we-should-stick-to-lower-case-tp2308300p2308756.html
Sent from the Revolution - User mailing list archive at Nabble.com.
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe
that
it eludes us. Now onto the second and more important case.
2 - OMG! REV FOR LINUX IS BROKEN, I CAN'T CONNECT TO MY * DATABASE!
The amount of possible problems trying to connect to databases is way bigger
than the one I am detailing here but the one that I am detailing here will
get
This is why I always encourage anyone creating web sites and SQL databases to
keep everything lower case and avoid spaces or special characters in their file
names. This way you cannot have this get you. In sports there is a thing called
economy of motion. You reduce all the extraneous movement
On Jun 13, 2010, at 6:04 AM, JosepM wrote:
I put the option menu data load into the preopenstack, accessing
directly to
the datagrid template xx.
I guess that is correct, isn't?
Since you just need to populate the menu once that will work just fine.
--
Trevor DeVore
Blue Mango Learning
Thanks!
Salut,
Josep
--
View this message in context:
http://runtime-revolution.278305.n4.nabble.com/Datagrid-with-option-menu-filled-from-database-tp2253060p2254394.html
Sent from the Revolution - User mailing list archive at Nabble.com.
___
use
Hi,
I put the option menu data load into the preopenstack, accessing directly to
the datagrid template xx.
I guess that is correct, isn't?
Salut,
Josep
--
View this message in context:
http://runtime-revolution.278305.n4.nabble.com/Datagrid-with-option-menu-filled-from-database
Hi List,
I have a question with the datagrid and the option menu.
How can I assign values to the option menu from a database when the stack is
open?
It's posible or affect the datagrid performance? where is the best place to
put the loading code?
Salut,
Josep
--
View this message in context
This is exactly what I am working on, more for importing a foreign database
that backing up, but it could be used for both. Unfortunately I am in the early
alpha stages, so I don't have much to offer you, except that I have a card
where you enter the connection information for 2 databases
Hi Folks,
I need to create and backup mySQL database from Rev. I have created the
database, so only I need to run the schema, but I have no clear what can be
the best solution for.
Any experience?
Salut,
Josep
--
View this message in context:
http://runtime-revolution.278305.n4.nabble.com
A schema dump is built in to MySQL:
assuming you are connected to the database, use this mysql call
desc tablename;
a data dump would need to be accomplished by scripting.
On 31 May 2010 11:35, JosepM jmye...@mac.com wrote:
Hi Folks,
I need to create and backup mySQL database from Rev. I
Hi,
I try this but no result.
mysqldump --opt myDB backupDB.sql
Sorry but I don't see how to dump the data by scripting.
Salut,
Josep
--
View this message in context:
http://runtime-revolution.278305.n4.nabble.com/Create-mySQL-database-structure-from-Rev-tp2237715p2237895.html
Sent
I try this but no result.
mysqldump --opt myDB backupDB.sql
I have used a shell call to the mysqldump command and that worked fine.
Cheers,
Sarah
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe,
message @
http://runtime-revolution.278305.n4.nabble.com/Create-mySQL-database-structure-from-Rev-tp2237715p2237903.html
To unsubscribe from Re: Create mySQL database structure from Rev,
click here.
--
View this message in context:
http://runtime-revolution.278305.n4.nabble.com/Create-mySQL
mailing list
[hidden email]
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
View message @
http://runtime-revolution.278305.n4.nabble.com/Create-mySQL-database-structure-from-Rev
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
View message @
http://runtime-revolution.278305.n4.nabble.com/Create-mySQL-database-structure-from-Rev-tp2237715p2237903.html
To unsubscribe from Re: Create mySQL database structure from Rev,
click here
If one just needs the schema try this command:
*show create table*
after opening the database
this will return data like this
2004_INV CREATE TABLE `2004_INV` (
`ID` int(11) NOT NULL,
`DATE_CREATE` date NOT NULL,
`DATE_CHANGE` date NOT NULL,
`BRIEF_DESC` varchar(255) NOT NULL
the RevDB api could be improved to
support the kinds of things you are trying to do, but presently Revolution does
not making a direct persistent connection to the SQL database, but rather is
acting as a broker between the two. Otherwise you would be able to create
read/write cursors, modify
On Tue, Apr 27, 2010 at 6:36 PM, Marcello Bertoli mbert...@libero.it wrote:
Hi all,
I have a question about runrev database commands. Is there a way to get the
result of a sql statement that doesn't retrieve data (is not a select)? For
example:
In a postgresql scenario I need to execute
On 28/apr/2010, at 11.12, Sarah Reichelt wrote:
If you check the result after your revExecuteSQL statement, it
should contain the data you need.
Hi Sarah,
thank you for your answer.
the result of revExecuteSql doesn't seem to contains the information the sql
engine answers and I need to
Hi all,
I have a question about runrev database commands. Is there a way to get the
result of a sql statement that doesn't retrieve data (is not a select)? For
example:
In a postgresql scenario I need to execute the statement:
listen foo
and I need to retrieve the result.
It seems
2010/3/15 Devin Asay devin_a...@byu.edu:
On Mar 15, 2010 Andrew Kluthe and...@rjdfarm.com wrote:
I have a need to store image files and document files (reports) to my
mySQL
database. I know it is arguably unconventional to do this, but the need
and
requirement is there. Does anyone have any
I have a need to store image files and document files (reports) to my mySQL
database. I know it is arguably unconventional to do this, but the need and
requirement is there. Does anyone have any experience doing this within rev?
I have seen alot of tutorials documenting this in PHP.
Worst case
On Mar 15, 2010, at 2:24 PM, Andrew Kluthe wrote:
I have a need to store image files and document files (reports) to my mySQL
database. I know it is arguably unconventional to do this, but the need and
requirement is there. Does anyone have any experience doing this within rev?
I have seen
2010/3/15 Andrew Kluthe and...@rjdfarm.com:
I have a need to store image files and document files (reports) to my mySQL
database. I know it is arguably unconventional to do this, but the need and
requirement is there. Does anyone have any experience doing this within rev?
I have seen alot
Perfect. This is the post I was looking to find but couldn't. Bob, Slug,
Thanks!
--
View this message in context:
http://n4.nabble.com/Saving-files-to-database-tp1594051p1594076.html
Sent from the Revolution - User mailing list archive at Nabble.com
On Mar 15, 2010 Andrew Kluthe and...@rjdfarm.com wrote:
I have a need to store image files and document files (reports) to
my mySQL
database. I know it is arguably unconventional to do this, but the
need and
requirement is there. Does anyone have any experience doing this
within rev?
I
The thing that would concern me is if the file had a quote in it, as might be
the case with a word file. If you are talking about image data, there shouldn't
be a problem with that, especially since the format for modern image files are
all internet friendly.
I guess it just depends on the
I don't think BLOBs have any problem with quotes - it's just another binary
byte.
-
Stephen Barncard
currently in Fairhope AL
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe,
: Rick Harrison harri...@all-auctions.com
Subject: Re: Connecting Stack to Remote On-Rev MySQL Database
To: How to use Revolution use-revolution@lists.runrev.com
Date: Monday, February 15, 2010, 11:19 AM
Hi Matthias,
I've already seen http://samples.on-rev.com/database.irev which only
shows
how
localhost databases accesses only
Not true... otherwise it would be impossible to use apps like Navicat or a
Rev MySQL-based project remotely. All you need to do is to open up the
available IPs -- On-Rev MySQL will work with to your fixed IP or a wild card
%. -- Of course that is with less
Good to know. Thanks.
Le 16 févr. 10 à 17:09, stephen barncard a écrit :
localhost databases accesses only
Not true... otherwise it would be impossible to use apps like
Navicat or a
Rev MySQL-based project remotely. All you need to do is to open up the
available IPs -- On-Rev MySQL will
Hi Matthias,
I've already seen http://samples.on-rev.com/database.irev which only shows
how to open a local MySQL database not a remote one.
I am specifically looking for code examples, not the basics.
The information you provided about %.%.%.% as an ip-address was helpful,
and I thank you
Hi Sarah,
So from this I'm assuming you are talking about using
a revbrowser concept to get the information into and
out of the database from within my stack?
Will this approach slow things down?
Thanks,
Rick
On Feb 14, 2010, at 5:38 PM, Sarah Reichelt wrote:
One way of doing
Rick,
Are you using MySQL on the on-rev server?
--- On Mon, 2/15/10, Rick Harrison harri...@all-auctions.com wrote:
From: Rick Harrison harri...@all-auctions.com
Subject: Re: Connecting Stack to Remote On-Rev MySQL Database
To: How to use Revolution use-revolution@lists.runrev.com
Date
Original Message
Subject: Re: Connecting Stack to Remote On-Rev MySQL Database (15-Feb-2010
18:23)
From:Rick Harrison harri...@all-auctions.com
To: runrev260...@m-r-d.de
Hi Matthias,
I've already seen http://samples.on-rev.com/database.irev which only shows
how
...@all-auctions.com wrote:
From: Rick Harrison harri...@all-auctions.com
Subject: Re: Connecting Stack to Remote On-Rev MySQL Database
To: How to use Revolution use-revolution@lists.runrev.com
Date: Monday, February 15, 2010, 11:19 AM
Hi Matthias,
I've already seen http://samples.on-rev.com
Rick Harrison wrote:
Yes, I'm using MySQL on the on-rev server.
I can access it fine from an irev script.
I need to access it remotely from a stack.
Rick,
Look up *post* in the dictionary. A script in your stack posts SQL, data or
both to your irev script. The irev script executes the
of
the database point to your On-Rev site instead of localhost. Set the
permissions as described already and I think it will work as planned.
Cheers,
Sarah
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe
On Tue, Feb 16, 2010 at 3:24 AM, Rick Harrison
harri...@all-auctions.com wrote:
Hi Sarah,
So from this I'm assuming you are talking about using
a revbrowser concept to get the information into and
out of the database from within my stack?
No, I don't use revBrowser, I just do something like
Hi there,
I've been all through the archives, and found
some hints that it is possible to connect to
a remote MySQL database on On-Rev.
Doe anyone have a clear step by step
example of how this is done?
I don't have time to keep struggling with this
problem. I need a solution A.S.A.P.
Any help
Rick,
first of all you have to enable Remote Access for your database. You can do
that in cPanel -Databases-RemoteDatabase Access Hosts. If the computer, which
runs the stack, does not have a static internet ip, then you have to enter
%.%.%.% as ip-adress in Access Hosts.
At http
I've been all through the archives, and found
some hints that it is possible to connect to
a remote MySQL database on On-Rev.
Doe anyone have a clear step by step
example of how this is done?
One way of doing it is to have an irev file actually do the connecting
and querying
Hi there,
Does anyone have a good example of opening a MySQL database on On-Rev
using a Rev stack on a local machine?
I've looked at the documentation thus far, and found it to not be adequate.
I just keep getting the following message, which I believe is telling me
that it just didn't connect
There was an error connecting to the SQL database!
else
if tparam1 is unselect_grid then
put UPDATE definitions_en_cours SET edit_timeout = '0' WHERE
abo_email = ' tparam2 ' AND editable_grid = ' tparam3 '
into sqlStatement
Does anyone have a good example of opening a MySQL database on On-Rev
using a Rev stack on a local machine?
I use the scripts from the Splash21 web site http://splash21.on-rev.com/.
If you sign up, you can download all the files.
Cheers,
Sarah
if myDatabaseID is not a number
then return There was an error connecting to the SQL database!
else
if tparam1 is unselect_grid then
put UPDATE definitions_en_cours SET edit_timeout = '0'
WHERE abo_email = ' tparam2
1 - 100 of 1236 matches
Mail list logo