Search results for query: *

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...

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...

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, If I disable a user's AD user account will this automatically disable the user's Exchange account. I am using 2003. Cheers Tom

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, Does anyone know if there is a command to enable VNC on a SUSE Linux server using SSH? Cheers

Hi, Does anyone know of a way to convert an Excel (xls) file to a PDF document using Java? Cheers

Hi, I need to create a servlet that will call a web service via SOAP. Anyone come across any good examples? Cheers

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

Hi, Does anyone know of any free/cheap JDBC drivers that will connect to dbase? Cheers

Hi, I have installed MySQL 4.1 on SUSE 9 for IBM Open Power Server. The server has 4GB memory and 380 GB hard disk space. I am having performance problems with MySQL. I have put posts on several MySQL forums to see hot to optimise MySQL for my environment, but have not rectified the situation...

Hi, I am using MySQL 4.1 on Linux (IBM Open Power Server). The Server has 4GB memory, 380GB hard drive. I have a Java based application that runs in Tomcat in a Windows environment using SQL Server. As part of a customer project I have got the application to work on Tomcat on Linux with...

Hi, I have an XML document similar to the structure below. I need to know how many <FORECASTDETAIL> elements there are in the document. I used COUNT(/FORECAST/ITEM/MONTH/FORECASTDETAIL), but this only returns the number of <FORECASTDETAIL> elements within one <MONTH> element and not the total...

Hi, I have moved an application that we had running on Windows/SQL Server to Linux/MYSQL and I now have problems with some of the code not working as Linux is case sensitive. E.g. SELECT * FROM Report is not the same as SELECT * FROM REPORT Is there anyway I can make Linux case insensitive...

Hi, I have moved an application that we have written from running on Windows with SQL Server to running on Linux with MySQL. Since I have moved the application I am finding issues as MySQL/Linux seems to be case sensitive with how table names are referenced. In SQL Server you can use SET...

I need a HTML page that checks to see if the user has a JVM installed or not. The objective is for this page to check whether the browser has a JVM installed, if it does then it needs to forward the user to another web page. If there is no JVM installed in the browser then the user needs to be...