>Practically "NO", because Spectra-customtags use HARDCODED
>COLUMN-/TABLE-names ;-(
Argh! Spectra strikes again! Thanks for your thorough follow up.
Anybody have any ideas how to get around this without modifying the spectra
source? What about the possibility of writing some wrappers for the spectra
handlers? Painful? Impossible?
Ed
-----Original Message-----
From: Trumpp Peter [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 2:01 PM
To: Spectra-Talk
Subject: AW: External User directories
Hi!
<<Can I get Spectra to use an external database as a user directory where
<<table names and field names are different from the Spectra defined field
<<names?
Theoretically "YES", because you can specify the way NETEGRITY looks at your
data via
-> C:\CFUSION\BIN\SmDsQuery.ini
.....
[UserDirectory]
Query_Enumerate=select UserName as Name, 'User' as Class from Users Union
select GroupName as Name, 'Group' as Class from Groups order by Class
Query_InitUser=select UserName as Name from Users where UserName = '%s'
Query_AuthenticateUser=select UserName as Name from Users where UserName =
'%s' and Password = '%s'
Query_GetGroups=select Groups.GroupName as Name from Groups, Users_Groups
where Users_Groups.UserName = '%s' and Groups.GroupName =
Users_Groups.GroupName
Query_GetUserProp=select %s from Users where UserName = '%s'
Query_SetUserProp=update Users set %s = %s where UserName = '%s'
Query_GetObjInfo=select UserName as Name, 'User' from Users where UserName =
'%s' Union select GroupName as Name, 'Group' from Groups where GroupName =
'%s'
Query_GetUserProps=UserName, Description
Query_IsGroupMember=select GroupName from Users_Groups where UserName = '%s'
and GroupName = '%s'
.....
Practically "NO", because Spectra-customtags use HARDCODED
COLUMN-/TABLE-names ;-(
If you're able/authorized to create a VIEW in your external database, you
could establish a VIEW called "USERS" with two "columns" "USERNAME" /
"PASSWORD".
Regards,
Peter Trumpp
conceptware ag
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
