Lantica User Forum - UserID Woes

(UTC)

Lantica User Forum › Lantica Discussions › Lantica Discussion › UserID Woes

(Moderator: Forum Admin)

‹ Previous Topic | Next Topic ›

Page Index Toggle

Pages: 1

Send Topic

Print

Normal Topic

UserID Woes (Read 1361 times)

BWETTLAUFER Full Member Offline Posts: 216 Location: Cambridge, Ontario Joined: Apr 9^th, 2010	UserID Woes Jun 16^th, 2011 at 10:06pm	Print Post
	Hi All, I've run into a small snag. �I have a "Todays Files" button that pulls a saved retrieve spec. � Each staff member logs in to a client version of sesame with their own User ID and password. They then click on "Todays Files" to get their work for the day. � This pulls up a saved retrieve spec of Date being "=;<{@date};{@date}", which works fine. It also pulls up in a staff field "{@userid}". The @UserID works in standalone mode, but not in client mode. �Any idea why, and how I can fix it? Thanks all! Blair


	WWW Twitter IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: UserID Woes Reply #1 - Jun 17^th, 2011 at 2:24pm	Print Post
	Retrieve Spec programming compiles server-side. @UserID only exists client-side. Use the pre-evaluated pipe syntax instead of curly braces: Code \|@UserID\|

	- Hammer The plural of anecdote is not data.
	WWW IP Logged

Ray the Reaper Global Moderator Members Lantica Support Offline The One & The Only Posts: 2482 Joined: Aug 20^th, 2003	Re: UserID Woes Reply #2 - Jun 17^th, 2011 at 2:47pm	Print Post
	Hello Blair, You can also speed up the other retrieve by changing it from Quote: =;<{@date};{@date} to Code =;<=\|@date\| -Ray

	Raymond Yoxall Consulting ray.yoxall@gmail.com ryoxall@lantica.com Sesame Applications, Design and Support
	WWW IP Logged

BWETTLAUFER Full Member Offline Posts: 216 Location: Cambridge, Ontario Joined: Apr 9^th, 2010	Re: UserID Woes Reply #3 - Jun 17^th, 2011 at 2:52pm	Print Post
	Well, I tried changing the Staff ID saved retrieve spec to \|@UserID\|, and now it's retrieving everything in the database, regardless of staff... Any other ideas?


	WWW Twitter IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: UserID Woes Reply #4 - Jun 17^th, 2011 at 3:04pm	Print Post
	BWETTLAUFER wrote on Jun 17^th, 2011 at 2:52pm: Well, I tried changing the Staff ID saved retrieve spec to \|@UserID\|, and now it's retrieving everything in the database, regardless of staff... Any other ideas? It worked for me. What is the User ID?

	- Hammer The plural of anecdote is not data.
	WWW IP Logged

BWETTLAUFER Full Member Offline Posts: 216 Location: Cambridge, Ontario Joined: Apr 9^th, 2010	Re: UserID Woes Reply #5 - Jun 17^th, 2011 at 3:20pm	Print Post
	Well, when I log in, I log in as "BWR". I tried to do a quick WriteLn(\|@UserID\|) in Mass Update, but Sesame didn't like that syntax. When I tried again WriteLn(@UserID) it returned "BWR".


	WWW Twitter IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: UserID Woes Reply #6 - Jun 17^th, 2011 at 4:23pm	Print Post
	BWETTLAUFER wrote on Jun 17^th, 2011 at 3:20pm: Well, when I log in, I log in as "BWR". I tried to do a quick WriteLn(\|@UserID\|) in Mass Update, but Sesame didn't like that syntax. When I tried again WriteLn(@UserID) it returned "BWR". The pipe syntax only works in Retrieve Spec programming. It won't work (and is not needed) in a Mass Update. Also, it only exists in Version 2. Are you still using Version 1?

	- Hammer The plural of anecdote is not data.
	WWW IP Logged

BWETTLAUFER Full Member Offline Posts: 216 Location: Cambridge, Ontario Joined: Apr 9^th, 2010	Re: UserID Woes Reply #7 - Jun 20^th, 2011 at 1:16pm	Print Post
	Sadly, yes ... 1.1.2. Is there another way to pull up local UserID and form fill the user field? I'm open to ways not involving a saved retrieve spec ... Blair


	WWW Twitter IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: UserID Woes Reply #8 - Jun 20^th, 2011 at 2:58pm	Print Post
	BWETTLAUFER wrote on Jun 20^th, 2011 at 1:16pm: Sadly, yes ... 1.1.2. Is there another way to pull up local UserID and form fill the user field? �I'm open to ways not involving a saved retrieve spec ... Blair You can set it On Retrieve Spec Open.

	- Hammer The plural of anecdote is not data.
	WWW IP Logged

Page Index Toggle

Pages: 1

Send Topic

Print

‹ Previous Topic | Next Topic ›

« Board Index ‹ Board Top

Top

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid XHTML

Valid CSS

Powered by Perl

Source Forge