database query

Is there a way to pass a global variable to a mysql query? here is what I would like to do display a query in a list (which I can do this) select from the list (store it in a variable) then pass that selection to a new query any thoughts on how to do this? Robert Mann President GP Racing LLC

database connect/query id's

revQueryDatabase revDatabaseCursors Thanks for the help Robert Mann ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman

RE: database connect/query id's

Thanks I figured there was something out there Robert Mann President GP Racing LLC -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Josh Mellicker Sent: Friday, June 09, 2006 8:30 PM To: How to use Revolution Subject: Re: database connect/query id's I

result set database query

I get the result set from a query (id and name) these are put into a menu (only name showing) now when you select a name I want to pass the id that goes with the name to a new query any ideas how to do this? 1 bill 2 john 3 rob select rob would like to pass 3 to new query Thanks Robert Mann

RE: result set database query

it works fine Robert Mann -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Sarah Reichelt Sent: Saturday, June 10, 2006 7:40 PM To: How to use Revolution Subject: Re: result set database query I get the result set from a query (id and name) these are put

RE: result set database query

I see thanks works now Robert Mann President GP Racing LLC -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Peter T Evensen Sent: Saturday, June 10, 2006 10:47 PM To: How to use Revolution Subject: Re: result set database query Don't you need something

RE: database connect/query id's

not able to open it? I am able to open the one above Robert Mann President GP Racing LLC -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of mfstuart Sent: Sunday, June 11, 2006 12:20 AM To: use-revolution@lists.runrev.com Subject: Re: database connect/query

worked in 2.5.1 not in 2.7.2

into tfr_mx_additive put tfr_mx_multiplier * fld weight + tfr_mx_additive into fld fr_mx_rate end mouseUp Robert Mann ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription

RE: worked in 2.5.1 not in 2.7.2

forget it I shut the program down re-opened and it now works? Robert Mann -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Robert Mann Sent: Wednesday, June 14, 2006 12:12 PM To: How to use Revolution Subject: worked in 2.5.1 not in 2.7.2 I just upgraded

RE: worked in 2.5.1 not in 2.7.2

This turned out to be a text entry box not set up right how do you set the text entry box to only up to 3 numbers and no CR? Robert Mann ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe

display correct data mySQL statement

into the wrong cell there after so if 32 has no data it will put 33 into the spot where 32 should go and so on so is there a way to select the data from the fld by tabs, if so how? If I look at the data in the fld it shows the empty spaces(tabs) Thanks Robert Mann

video tutorials not working

I am not able to view the video tutorials, I get a message saying QuickTime is missing software required to perform this operation, I have updated my QuickTime to the latest version, is there something else that I need? I can hear the sound but no video. Robert Mann President GP Racing LLC

saving problem

and closed rev, reopen stack changes not there, what could be going on? Robert Mann President GP Racing LLC ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription

RE: saving problem

fixed my bad lost power the other and my server was reset not to allow changes to files, but I never got a error from rev telling me that it could not save but instead kept saying save completed? Robert Mann President GP Racing LLC -Original Message- From: [EMAIL PROTECTED] [mailto

how to implement a activation code?

Is there a sample of how to implement a activation code and or a limited number of trial days with a standalone build? Robert Mann ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe

RE: how to implement a activation code?

I was thinking along the line of how revolution does it, just not sure how that is done? Robert Mann -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bill Marriott Sent: Sunday, July 02, 2006 7:37 PM To: use-revolution@lists.runrev.com Subject: Re: how

print card landscape

Thanks Robert Mann President GP Racing LLC ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use

u3 rev application with mysql/apache

then all I need to send the use is a flash drive, any thoughts as to is this will be possible to run apache/mysql/rev application all within a u3 flash drive? Robert Mann President GP Racing LLC ___ use-revolution mailing list use-revolution@lists.runrev.com

u3 rev application with mysql/apache

then all I need to send the use is a flash drive, any thoughts as to is this will be possible to run apache/mysql/rev application all within a u3 flash drive? Robert Mann President GP Racing LLC ___ use-revolution mailing list use-revolution@lists.runrev.com

RE: u3 rev application with mysql/apache

and upload the new info they have put into the database as they need. Thanks for the suggestions I have started to test them out. Robert Mann President GP Racing LLC -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Sean Shao Sent: Monday, July 31, 2006 3:13 PM

RE: u3 rev application with mysql/apache

\command=/SNmain/Windows/SNmain.exe action=xampp_start.exe open=/xampp/xampp_start.exe shellexecute=/xampp/xampp_start.exe shell\Auto=xampp_start.exe shell\Auto\command=/xampp/xampp_start.exe Icon=sn.ico shell=Auto label=Suspension Network Robert Mann President GP Racing LLC -Original

RE: u3 rev application with mysql/apache

Not sure how to code the call to start the mysql is there a sample out there somewhere? Thanks Robert Mann President GP Racing LLC -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Viktoras Didziulis Sent: Wednesday, August 02, 2006 2:39 AM To: How to use

RE: u3 rev application with mysql/apache

=kristupukas shutdown into theCommand set the hideConsoleWindows to true get shell(theCommand) end startup Robert Mann President GP Racing LLC -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Viktoras Didziulis Sent: Wednesday, August 02, 2006 10:28 AM To: How

RE: u3 rev application with mysql/apache

thanks for the help Robert Mann President GP Racing LLC -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Robert Sneidar Sent: Thursday, August 03, 2006 7:13 PM To: use-revolution@lists.runrev.com Subject: RE: u3 rev application with mysql/apache May I

RE: u3 rev application with mysql/apache

\mysqladmin - -password= shutdown into theCommand set the hideConsoleWindows to false get shell(theCommand) end mouseUp Thanks Robert Mann President GP Racing LLC -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Viktoras Didziulis Sent: Wednesday, August

sql update statement

the above list format but it does not like the returns after each comma, what can I do to correct this? Robert Mann ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your

RE: sql update statement

it into updateColValListOf123Pairs put UPDATE rider SETupdateColValListOf123Pairs WHERE record_id = ' fld record_id ' into tSQL revExecuteSQL dbID2,tSQL Robert Mann -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jim Ault Sent: Sunday

RE: sql update statement

Jim, thanks works great Robert Mann -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jim Ault Sent: Sunday, October 01, 2006 10:43 AM To: How to use Revolution Subject: Re: sql update statement put ' into p -- don't forget this get 2srd3 = p fld

tab though cells

, is there an easier way than recreating the cells in the order I want the tabs to work? Robert Mann ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http

msql insert new record

= ' fld fctgmod ' put it into updateColValListOf123Pairs put INSERT INTO rider updateColValListOf123Pairs into tSQL the above does not seem to work? any help would be greatly appreciated Thanks Robert Mann ___ use-revolution mailing list use-revolution

RE: msql insert new record

get it ,fld userid get it ,fld freb put it into colvalues put INSERT INTO rider colnames VALUES colvalues into tSQL Thanks Robert Mann -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jim Ault Sent: Sunday, October 15, 2006 8:16 PM To: How to use

RE: msql insert new record

Mann -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jim Ault Sent: Sunday, October 15, 2006 8:16 PM To: How to use Revolution Subject: Re: msql insert new record On 10/15/06 4:14 PM, Robert Mann [EMAIL PROTECTED] wrote: have a update code that works great

RE: video tutorials not working

I got a new laptop and I am not able to get the videos to play even after downloading ensharpen codec any ideas what to do next? Thanks Robert Mann -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of J. Landman Gay Sent: Thursday, June 29, 2006 10:47 AM

formatting data

Robert Mann President GP Racing LLC ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution

RE: formatting data

Thanks John how do I now get this info into new fld in this format 6 25 4 26 3 22 Robert Mann President GP Racing LLC -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of John Craig Sent: Wednesday, November 01, 2006 5:42 PM To: How to use Revolution Subject

RE: formatting data

would have 22 in it so if you were looking at the fields you would see 6 25 empty flds empty flds 4 26 3 22 what I would like to be able to do is put the data into a new fld reformatted like this without the empty flds 6 25 4 26 3 22 Thanks Robert Mann President GP Racing LLC

RE: formatting data

30.5 16.2 is there a way to get the 29.1 to line up under the 30.1 if there is no data in first field? Robert Mann President GP Racing LLC -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jim Ault Sent: Wednesday, November 01, 2006 10:19 PM To: How to use

RE: formatting data

of combinedValues put cc rr cr after msg end if end repeat end repeat filter combinedValues without empty replace , within combinedValues put combinedValues after msg put combinedValues into fld combinedOutput Robert Mann President GP Racing LLC

popup?

Is there a way to have a button open a popup box so the user can enter text? Here is what I would like to do, have a button labeled add comment, when the user clicks the button a popup opens so they can enter the comment then they click submit and it gets added to the database Thanks Robert Mann

RE: popup?

Robert Mann -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Robert Mann Sent: Sunday, November 05, 2006 9:55 AM To: Use-Revolution Subject: popup? Is there a way to have a button open a popup box so the user can enter text? Here is what I would like to do

RE: popup?

ask field Prompt titled Enter your Comment! put it into tcomment this seems to work? Robert Mann ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences

RE: popup?

Thanks, I will do this from now on. Robert Mann -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Martin Baxter Sent: Sunday, November 05, 2006 11:15 AM To: How to use Revolution Subject: Re: popup? Robert Mann wrote: ask field Prompt titled Enter your

getting info from a fld

is there a way to get info in a fld using the layer# or number on the size position tab in the property inspector? Robert Mann President GP Racing LLC ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe

adding info to fld

I have a fld that has text in it, would like to be able to add text to that fld but one line below what is already in fld. how should I do this? Robert Mann ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url

RE: adding info to fld

forgot I tried this put fld tnewcommentshock after fld shockcomment but it puts the text right after the last letter of text already in the fld Robert Mann -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Robert Mann Sent: Sunday, November 12, 2006 12:15

standalone build problem?

I am using 2.4.7 studio and trying to build a windows standalone but rev never seems to finish. the stack is 3360k I am using mysql, and selecting u3 compatible is there a why to find out where rev is hanging up? also is there any documentation on building standalones? Robert Mann

RE: standalone build problem?

It took about 25 minutes for rev to build the standalone is this normal? Robert Mann -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Robert Mann Sent: Wednesday, November 22, 2006 11:37 AM To: Use-Revolution Subject: standalone build problem? I am using

RE: standalone build problem?

Jacqueline, I seen this recommendation that you gave on a early post and did change the settings but it still took 25 minutes? Thanks Robert Mann -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of J. Landman Gay Sent: Wednesday, November 22, 2006 2:26 PM

standalone/mysql/database files

in the standalone build what is the best way to include these files so that a user can not just remove the database file and open from phpadmin? this is all on a u3 drive and works fine, just looking to secure database files Thanks Robert Mann ___ use-revolution mailing

revQueryDatabase

as a number then when the revDatabaseColumnNamed(curID,fr_mx_multiplier) into fld frmxm1 executes it puts ”revdberr,invalid column number” in the fld and then rev shuts down Not sure where I have gone wrong? Thanks Robert Mann ___ use-revolution

Bug with revQueryDatabase 2.7.4 build 291

test a sql statement that they know should return on non-number to the revQueryDatabase and see what you get Thanks Robert Mann ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage

download file from server

Trying to use the libURLDownloadToFile but it does not download the whole file I only get 1K of the file, it is 15033K also it never tells me downloadcomplete Is there more to using this? libURLDownloadToFile http://www.suspensionnetwork.com/downloads/Suspension Network.exe, C:\Program

RE: download file from server

Eric Thanks I did not know you had these available, lots of great info Rob ___ 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

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: Rev CGI Post

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: cgi error - with stacks

Make sure the first line of the cgi is #!Linux If your engine is named Linux Then make that you have all cgi files you call with the right case, they are case sensitive -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of chris livermore Sent: Thursday,

RE: Rev CGI Post

PDT is sent in the GET format but I get a fail at the end put $QUERY_STRING into theBuffer put theBuffer into theTermsArray --keep the original info. put myLibUrl.rev into theStack start using stack theStack put the result into tresult split theTermsArray by and = put

testing CGI help?

How do I find out if in the following theBuffer is empty? #!Linux --| PayPal PDT CGI --| (c)Thomas McCarthy --| speakup at mac --| March 1, 2006 --| Used to present a web page to customers on startup --StartCGI --read info put $QUERY_STRING into theBuffer put theBuffer

RE: testing CGI help?

heeft Robert Mann het volgende geschreven: How do I find out if in the following theBuffer is empty? #!Linux --| PayPal PDT CGI --| (c)Thomas McCarthy --| speakup at mac --| March 1, 2006 --| Used to present a web page to customers on startup --StartCGI --read info

RE: testing CGI help? paypal

It took me a week but I figured out my problem. After some consulting with paypal support they told me to try the live site not sandbox, it did not work at first but then I went through and completely set up the business paypal account and it started to work. So not sure what part of the paypal

revExecuteSQL?

When you run revExecuteSQL dbID, tSQL how do you check to make sure it completed successfully? Thanks Rob ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your

trouble with standalone valentina

My application works fine in development mode but when I build the standalone and test that database does not seem to get updated? When the user opens the app it checks to see that they have registered if they have it opens if not they have to click a register button, when they do it sends then

RE: trouble with standalone valentina

Subject: Re: trouble with standalone valentina Hi Rob, Le 29 août 07 à 01:03, Robert Mann a écrit : My application works fine in development mode but when I build the standalone and test that database does not seem to get updated? Databases are not my field but reading your script I saw: set

RE: trouble with standalone valentina

saved. Chances are if you're acessing it right but there's no value that the save routine is wrong. HTH andre On 8/29/07, Eric Chatonet [EMAIL PROTECTED] wrote: Hi Rob, Le 29 août 07 à 01:03, Robert Mann a écrit : My application works fine in development mode but when I build

connecting to 3.2 valventina database with rev

Valentina 3.2 I am getting the following error on the converting valentina connection id to revdb connection id revdberr,invalid database type with the follow script put 20 * 1024 * 1024 into theCacheSize put empty into theMacSerialNumber put fld serial into

RE: connecting to 3.2 valventina database with rev

I tried valentina3 did not work Tracing my steps back I was running valentina 2.5.6 reloaded this works fine -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Mann Sent: Wednesday, August 29, 2007 3:34 PM To: [EMAIL PROTECTED]; use-revolution

RE: connecting to 3.2 valventina database with rev

Well I spent the whole day trying to figure out why data was not being saved in the valentine database with a standalone I guess you have to make sure you do the following when you close the app or data is not saved, this works with valentina 2.5.6 now I will try and change all to 3.2 and see if

RE: copy/paste still buggy?

I am not able to copy/paste multiple objects at once either, only one at a time Winxp, rev studio 2.8.1 build 470 Rob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Swindell Sent: Wednesday, September 05, 2007 10:09 AM To: How to use Revolution

valentina 2.5 for rev

I downloaded the file but I keep getting error messages (error in function handler)(get valentina_init) when I click on the valentina intit btn in the example files, could this because I have not purchased or is there a trial. thanks Robert Mann

valentina sql ?

The opencard script works fine but then when I run the on mouseUp I get nothing unless I have the same sql statement as in the databaseopen SELECT * FROM wt_brands ON openCard get valentina_Init( 100 * 1024 * 1024 ) Databaseopen END openCard ON closeCard DatabaseClose get

mysql to valentina using libdatabase

? put mysql into tDbA[Type] put localhost into tDbA[Host] put recipes into tDbA[Name] put root into tDbA[Username] put into tDbA[Password] libDatabase_RegisterDatabase myrecipesdb, tDbA libDatabase_Connect myrecipesdb libDatabase_GetDBConnectionID(myrecipesdb) Robert Mann

RE: mysql to valentina using libdatabase

I only need to get my current mysql database converted to valentina so I can continue to test if all goes well I will then change over to valentina, but it would be nice to learn how to do this just in case I need to do this in the future Robert Mann -Original Message- From: [EMAIL

RE: mysql to valentina using libdatabase

I was following the getting started I see the changes now, am I correct that to use liDatabase you input this through the message box? Robert Mann -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Trevor DeVore Sent: Friday, December 29, 2006 11:02 AM

RE: mysql to valentina using libdatabase

this working, I tried the below from Trevor I do not get any errors but now how do I know that it connected? thanks Robert Mann -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Trevor DeVore Sent: Friday, December 29, 2006 11:02 AM To: How to use Revolution Subject: Re

RE: mysql to valentina using libdatabase

ok so what is the best way to use libDatabase? Robert Mann -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Stephen Barncard Sent: Friday, December 29, 2006 11:59 AM To: How to use Revolution Subject: RE: mysql to valentina using libdatabase you might

RE: mysql to valentina using libdatabase

was trying to get libDatabase working to help me do the conversion. I tried to use valentina studio but have had problems getting it to do the conversion. So more specifically how are people using libDatabase to do a conversion of a mysql database to valentina? Thanks Robert Mann -Original

RE: mysql to valentina using libdatabase

Trevor, thanks ok I see the libdb_export in the stack script now I am lost how do I go about running it or any of the handlers? Robert Mann -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Trevor DeVore Sent: Friday, December 29, 2006 1:38 PM To: How

RE: mysql to valentina using libdatabase

I have been in contact with Ruslan he has been very helpful and there seems to be a bug in valentina studio so it won't do the conversion, Robert Mann -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Stephen Barncard Sent: Friday, December 29, 2006 1:39 PM

RE: mysql to valentina using libdatabase

fieldmysqlid // checking to make sure connected to database END RegisterDatabaseA ON DoMysqlDump libdb_getSQLDump (SuspensionDB,empty ,empty , true, true,empty , mysqldump.sql)//tried this with and without the () no difference still get error END DoMysqlDump Thanks Robert Mann

RE: mysql to valentina using libdatabase

into theInfoA[pDrop] put true into theInfoA[pCreate] put true into theInfoA[pInsert] put empty into theInfoA[pVersion] put mysqldump.sql into theInfoA[pOutFile] libdb_getSQLDump SuspensionDB,theInfoA END DoMysqlDump Robert Mann -Original Message

RE: mysql to valentina using libdatabase

I tried both of these and I get application error handler running low on memory, script aborted put libdb_getSQLDump (RecipesDB,empty ,empty , true,true,empty, mysqldump.sql) into mysqldump get libdb_getSQLDump (RecipesDB,empty ,empty , true,true,empty mysqldump.sql) Robert Mann

Normalizing a MYQL database

I have several large tables in this MSQL database and with the help from Ruslan I understand why I need to normalize these tables, Is there a tool to help me do the normalization? One of the tables has 580 or so fields and some 300 records Thanks Robert Mann

finding data in field

I have a field of names separated by tabs Label tab fcdqty Label tab fcd1qty Label tab fcd3qty What I am trying to do is find the second item then once I find it select the first item in that line, below is what I have tried but does not work find word tcolname in fld fieldmatch - -this

RE: finding data in field

This is the complete handler with some changes, still not working put SELECT gfields FROM gtable ; into theSQL put revQueryDatabase(gdbresult, theSQL) into FirstcurID put revNumberOfRecords(FirstcurID) into numrecord put revDatabaseColumnCount(FirstcurID) into colNum put

RE: finding data in field

Sent: Saturday, January 06, 2007 3:28 PM To: How to use Revolution Subject: Re: finding data in field Rob, I assume you have declared ALL of the globals in the handler? On Jan 6, 2007, at 12:15 PM, Robert Mann wrote: This is the complete handler with some changes, still not working put SELECT

(no subject)

I know there is a way to get the column type using revDatabaseColumnTypes(firstcurID) is there also a way to get all the other information about the column such as PK, and the column type value int(10) Thanks Rob ___ use-revolution

RE: (no subject)

Thanks Trevor, I got this working but is there a way to do this for selected columns Something like gfields is a list of fields separated by comma put SHOW gfields COLUMNS FROM ` gtable ` into theSQL this does not work get revdberr,You have an error in your SQL syntax; check the manual

RE: (no subject)

To: How to use Revolution Subject: Re: (no subject) On Jan 20, 2007, at 11:34 AM, Robert Mann wrote: Thanks Trevor, I got this working but is there a way to do this for selected columns Something like gfields is a list of fields separated by comma put SHOW gfields COLUMNS FROM ` gtable

matchText

I was using the following to match text matchText(tword1,tword) but I just relized that it is also selecting any strings that have that pattern, is there a way to only select exact matches? example tword1= record_id tword = record_id matchtext returns record_id orig_record_id only

RE: matchText

To: How to use Revolution Subject: Re: matchText On Jan 21, 2007, at 09:23, Robert Mann wrote: but I just relized that it is also selecting any strings that have that pattern, is there a way to only select exact matches? Robert you just need to add a bit to the regular expression part to tell

last char

I have a list that is separated by commas and need to check to make sure that the last char is not a comma I tried this but does not remove the comma, it does however see that the last char is a comma, just not sure how to remove it? IF last char of colnames is comma THEN replace last

Rev scripting preferences

When I started with rev I was putting all the scripts right where I was using them such as in the button, the problem I was having is keeping track of all the globals I was generating so I started to then call a handler which I then put in the card script, but now my stack seems to be slower, so

RE: Rev scripting preferences

Newer version of rev build 291 version 2.7.4 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Richard Gaskin Sent: Thursday, February 08, 2007 6:11 PM To: How to use Revolution Subject: Re: Rev scripting preferences Robert Mann wrote: When I started

RE: Rev scripting preferences

I was using 2.6 The stack is integrated with mysql database, the revdatabase lib seem to operate at speed the slowness that I am seeing is in Open card It seems to take along time for it to open the card? When I first open the stack I do not notice this but as I work in the stack and move from

error when rev starts

I am getting this error when rev starts Home:revolution.exe-unable to locate component This application has failed to start because Kernel_Win32_Release.dll was not found. Re-installing the application may fix this problem I reinstalled rev but still get this error? Any idea what I need to do?

INNER JOIN help

Trying to write an INNER Join SQL statement for 10 tables that only returns one record base on PK record_id select * from table1 INNER JOIN table2 where table2.record_id is record_id; the above works for 2 tables looking for help as to how I would add the other 8 tables to the sql statement?

RE: INNER JOIN help

Or is there a better why to combine info from 10 tables into one using SQL? Thanks Rob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ruslan Zasukhin Sent: Friday, February 16, 2007 2:43 AM To: use-revolution Subject: Re: INNER JOIN help On 16/2/07 1:32 AM, Robert Mann

revOpenDatabase valentina

I have created a stack that works good with mysql, moving to valentina trying to change the revOpenDatabase just not sure why this is not working put revOpenDatabase(Valentina,,C:\Program Files\Paradigma Software\VServer_Office\Databases\val_norm.vdb, , , , , fld serial) into dbID Thanks

sample stacks

Are there any other sample rev stacks out there using a Valentina server database besides the two that are in valentina documentation? Thanks Rob ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe,

steps to bundle rev app with valentina

Is there a tutorial on how to from start to finish bundle a rev app with all needed files and valentina embedded server? Thanks Rob ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and

  1   2   3   >