Hi,
I am using Oracle 9i and have written the following trigger. How do I obtain one of the values that has been inserted into the table so that I can use the value in the trigger.
The statement below is an example of the data that is inserted into the table. The value that I want to get...
Hi,
I am trying to find out which users are members of a particular group and have called ListMembers to do this. However the following error is produced. I am using Java. If anyone has a Java example or knows how to get round the error that would be appreciated...
Hi,
I am using LAPI and Java and need to revoke a users login privilege. How do I do this?
I know how to set them but not how to revoke a specific privilege. I presume that you use the UpdateUserInfo method and set attributes.add("UserPrivileges", WHATEVER GOES HERE);
What I am trying to...
Hi,
I am using LAPI and Java to call createUser() to create a new Livelink user. The API documentation says that createUser() returns the unqiue user ID that Livelink allocates to the new user.
How do I get the user ID?
The code snippet I am using to call createUser is detailed below. Status...
Thanks for that.
Do you have any example Java code for doing things with users and groups or can you point me to a resource as I can't seem to find much on the web?
e.g. Create a new user, update user attributes, disable a user, create a new group, add users to a group, remove users from a...
Syntergy,
I think the issue was that LAPI doesn't validate your login until you try and do something. I have tried accessing the Enterprise workspace and got the following error, so I guess I am communicating to the server then.
Please can you be a bit more specific on how I enable logging on...
Hi,
I am using the Livelink API's to connect to Livelink via Java. I have written a simple class that calls the LLSession method. It doesn't look like my call is even getting to the Livelink server.
I have installed the Livelink API program on the server and have added the bin directory to the...
I can't alter the database as it is a third party product so I might just have to update the table directly.
I'm glad thats what you said, because thats what I was thinking.
Thanks
VIEW_USR is a view. The VIEW_USR view is used by a third party integration piece of software that imposes the restriction that only one record can exist in the view for one user.
The way the data is stored there is a main user table with one record per user and there is another table that...
Hi,
I am trying to update a column with a view using the SQL statement below, but get the following error.
UPDATE TEST.VIEW_USR SET STRKNOWNAS = 'joe.bloggs@asasa.com WHERE PK_LNGPERSONIDCNT = 12993;
ORA-01779: cannot modify a column which maps to a non key-preserved table
Any advise would...
Hi,
I am using JavaMail and IMAP to get an Excel file that is attached to an email and save the file to the file system. Using simple Excel files this works fine. I have a more complex Excel file with Marcos in it, when you try and open the file in Excel it says the file is corrupt and can not...
Hi,
I have an input field that a date can be entered into. When the form is submitted I need to validate that the date is in the following format, dd/mm/yyyy, e.g. 01/08/1980. If the user has entered something like 1/8/1980 I need the javascript to format using the above format and change the...
Hi,
I need to call a web service from an ASP page. I don't mean ASP.net, just ASP. It seems possible using the SOAP toolkit, but I can't get it working at the momment.
Anyone know of any good articles on the web?
Cheers
Thanks for that.
That was going to be my next change.
Would you say that my my.cnf config file is configured correctly for my environment?
Thanks for your help
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.