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 like: put "SELECT * FROM workers WHERE workers.ID='" & gnameid & "'" into theSQL if gnameid is a Revolution variable, it won't automatically be substituted in a string. You have to build the string. On Jun 10, 2006, at 8:56 PM, Robert Mann wrote: > Thanks got that working > now having trouble getting the variable to work in the new query > > global gnameid > put gnameid into fld "gnameid" --I know it is passing the id it > puts it > in this fld > > put "SELECT * FROM workers WHERE workers.ID='gnameid'" into theSQL > > if I put the number in the 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 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 > > In your example, the ID number is the line number. If this is always > the case then you can use: > the menuHistory of me > which gives the selected line number for a menu button. > > If this is not the case, then you need to store the complet list > somewhere and refer back to it. > > get the complete list > sort it the way you want > put it into a custom property > extract the names and put them into the menu > > When a menu item is selected: > > get the menuHistory of the menu button > find the line number of the custom property > get word 1 of that line to find the ID > > HTH, > Sarah > _______________________________________________ > use-revolution mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your > subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > > > _______________________________________________ > use-revolution mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > > Peter T. Evensen 314-629-5248 or 888-682-4588 (toll free) http://www.PetersRoadtoHealth.com Get on the road to better health with Juice Plus+ 17 fruits, vegetables and grains in capsules, chewables, or gummies 24-hour pre-recorded information line: 1-800-942-1260 _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
