Search results for query: *

Hi, We have an offsite client who wants to access one of our databases via Enterprise Manager, I have set up a user for them with access only to their one database, however, when testing this, logging in as this user, they can only access their database, however they can view the rest of the...

I have a hyperlink on one of my https jsp pages for the user to download the data on the screen to a .csv. Previous to adding SSL to the site the download worked fine, now when trying to download I get the following message: Internet Explorer cannot download reports.csv from <server_name> The...

Hi, I am working on a website previously created by someone else, he has the staff photos on the website with blurred edges, I have to add a new photo and I don't know how he has blurred the edges, the background of the web page is white and so the blurring is white, the photo is a rectangle...

Our network consists of a NT 4.0 Server, NT 4.0 workstations, and my newly upgraded Windows 2000 workstation. After installing Windows 2000 I logged in with my usual username, password, and domain. When I log in I get the following error: &quot;Windows cannot load the users profile but has...

Hi, This is a kind of stupid question, but I have to ask as I am getting quite fustrated. I'm using version 5.5 and I am trying at the moment to create a simple image with a maroon background and white text on top. My problem is that once the text has been written it gets placed on the image...

Hi, I desparately need some help with this procedure, I haven't worked with Oracle in while, and I'm all in a fluster about how to do this. I need to get the client_ref (the id) from the client table check that it does not exist in the client_activities table, if it does not exist then I want...

Hi I have a query that is selecting records from various tables. My problem is that I am getting too many rows returned. There are 8 rows returned, but they are just double ups QUERY: select cl.first_name ||' '|| cl.surname as name, cl.phone_home, cl.phone_other, ah.street_no ||' '||...

Hi, I'm having real problems with this. A user enters a permit number and clicks ok, the next page has a form with all the values pulled out from the permit table, the user needs to be able to add a key number, key issued by, date key issued, date key due. If the permit already contains a key...

We have a system has a SQL Server 2000 back-end with an Access 2000 front-end. We would like to have a button on screen to email a report as an attachment that cannot be modified. We also have Outlook 2000. Do you have any suggestions as to how to go about this? Thank you.

Hi, I'm new to using posgres, I've mainly used Oracle in the past. I have a system I am designing where I have a View that joins two tables, as I am inserting into 1 table and updating another. I have written a rule to handle the insert and the update. My problem being that I have deleted and...

Hi, I have 2 pages. The first page has a link to the second page, which is fine, but when the user clicks on the link I need the second page to open with a .htm also loading in the main frame of the second page. Your help would be greatly appreciated.

Hi, I have 2 pages. The first page has a link to the second page, which is fine, but when the user clicks on the link I need the second page to open with a .htm also loading in the main frame of the second page. Your help would be greatly appreciated.

I am getting data from a ResultSet and putting it into a Hashtable. My problem is that some of the fields I am getting back are null, but I still need them. I would like to change them to an empty String, currently I am doing this but I would like to create a method to test if there is a null...

I need to write a Class to do the following: Get a date from a sybase stored procedure via a resultset Change that date to a java.sql.Date Collect the rest of the data Send the date back via another sybase stored procedure as a sybase datetime datatype I may also need to use methods from the...

I have the following query: select sum(installment) as Total from loan where nextpaymntdate >= [Please Enter Start Date] and nextpaymntdate <= [Please Enter End Date] and balance > 0; It should work fine, but it is not returning anything, when I know it should as I have run the query (in...

Hi, I am very short on time and I need to write the following query in Access: I have a table called Loan, I need to total the number of installments owing for a particular month or year where the balance is greater than zero, my problem being I don't know how to use the date functionality in...

Hi, I need to know more about creating an Access 2000 Runtime. I have to convert an Access 97 database to Access 2000, fix the problems it has and then package and deploy it as an Access 2000 runtime version as the clients do not own Access 2000, only 97. I have Access 2000 which I have...

Hi, I have recently installed Oracle 9i Application Server onto a server running Redhat 6.2 and Oracle 8.1.6. The system crashed at the end of the Application Server install, but it looked as though everything was there. However there are no control files for 9i Application Server. Because...

Hi, I have Exceed on my NT PC, linking to my Linux server, but I don't have a background window coming up, I have my directory windows and the taskbar at the bottom, but no background, I've fiddled around with the settings but can't figure it out. Any suggestions?!

Hi, I'm using Oracle for NT on my PC at work just to study for Oracle cert, and I get this message when I try to create a table (the default tables of emp, dept etc are not there) SQL> create table dept 2 (deptno NUMBER(2), 3 dname VARCHAR2(14), 4 loc VARCHAR2(13)); create table dept *...