mmmmmmmmm..... I don't know that either way is going to work. Apart from the fact that we're trying to avoid the use of function calls within transformers, I just don't think username and password is designed to be obtained from a feature.
I'd think that there's more chance of it working using an FMEFunctionCaller transformer using the @SQL function. That way use of @Value within that should be OK. I don't know - it's a tricky one. To get what you are trying I think the FMEFunctionCaller has the best chance of working. However, if you just need to be able to set the login/password at runtime then locate the settings in the navigation pane, right-click and choose publish. Then if you use File > Prompt + Run you'll be prompted to enter new values every time you run the workspace. Hope this is useful Mark Mark Ireland, Senior Product Specialist Safe Software Inc. Surrey, BC, CANADA [EMAIL PROTECTED] http://www.safe.com Solutions for Spatial Data Translation, Distribution and Access --- In [email protected], "Jeff Konnen" <[EMAIL PROTECTED]> wrote: > > Hi Daniel, > > try @Value(querry) etc ... this should do what you are looking for ... > > Greetings, > Jeff > > On 2/1/07, begwebgroup <[EMAIL PROTECTED]> wrote: > > > > I have an object with the following 4 attributes... > > > > querry: a sql querry; > > Instance: The DB instance; > > Usr: the username; > > Pwd: the password; > > > > I'd like to use the attributes values to specify in wich database > > (instance,username and password) I wish to make the querry. I've tried > > using &AttributeValue to fill the proper field but it didn't work. > > > > I'm using a workbench. Someone has an idea? > > > > Thanks > > Daniel > > > > > > > For insights into what's up at Safe Software and what's on the development horizon, visit Safe's blog at spatial-etl.blogspot.com. Safe Software has also made slides available that outline enhancements planned for FME 2007. The slides are from the "Road Ahead" presentation given on Day 2 of the FME Worldwide Users Conference. To view these slides, visit www.safe.com/2006uc. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/fme/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/fme/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
