Search results for query: *

Dear Tek-Tips, I'm in the process of creating an access database, but I have a problem. My friend who wants to use the database wants to enter a description into a field, maybe a memo box. The description will include words that the user of the system would like to search for, possibly, three...

Hi guys, I''m having a problem. I have created a very simple test database (one table, four fields), problem is i can't get php to write stuff to the database when completing details in a browser. Below is my code. Code - a user would need to complete when registering with a school...

1. Benefits of having the creatures (network optimisation programs). Assuming there are no creatures what will be the implications? 2. Factors that are likely to cause route congestion? 3. Assuming there are 100 million clients requesting the same job on the network. What strategy would you...

what would a select statement look like to gain infomation above?

Hello, I've create a very simple database which records payments made for a course. The students can pay in five instalments (payment 1, payment 2, payment 3, payment 4, and payment 5). There is total payment field, and an outstanding balance. I have currently got the fields in my form...

Hello ... Sorry if this is not the right place to ask. I have a question. I want to develop an online fault logging system, using MySql, Apache and PHP. My first question is can I do this on a Windows Platform? Can this software be downloaded for free? if so, where from? My second question is...

Is it possible to connect an access database (backend) to an html website (front end)? I’m not considering doing this, but it would be nice to know. Is it easy to do? Disadvantages of access database online? Asad

Window Updates Run?

Hi Guys & Girls, We have a problem at work where when we print screen dumps from VB (in MS Word), the colours when printed do not come out as they should. The default grey background comes out blue, the yellow is very light, and the green is also very light. I have tried it on 2 HP4600N...

Have you run all the windows updates for your machine?

When I run the function select F_CALC_TOTAL (to_date ('21-11-2003 21:00','DD-MM-YYYY HH24:MI'), to_date ('21-11-2003 14:00','DD-MM-YYYY HH24:MI'), 10) total_amount from dual; I don't get the result I want. I get; TOTAL_AMOUNT ------------ 14.583333 Which does not mean very much. If for...

Thank you. I am getting better thanks to guy like you. I knew I had to put some sort code linkage to memberID, but I was not sure where. Thanks again. Asad

Hi I'm just trying to develope a very simple stored procedeure, but its not working correctly. Code; CREATE OR REPLACE PROCEDURE test_member (memberID IN Number) IS CURSOR member_cur is SELECT no_of_late FROM member; late_number number(3); BEGIN open member_cur; loop fetch...

If I want to create a trigger that updates a field in anoother table, how do I ref that? eg. my two tables are below; create table loan (LoanID varchar2(6) PRIMARY KEY, Issue_Date date not null, Due_Date date not null, Return_Date date, Item_ID REFERENCES AV_Item, Bookno REFERENCES Book...

Thanks alot Bj, that helps alot. I will need to change bits of the code. Silly Question Time Once a function has been created, how to I find out/execute to see if that function is working correcly. Thank for the tip about the google search Asad

Hi, point taken. I'm very new to pl/sql and I am still in the process of learning. I need to create similar triggers to the one above, and if I can get one functioning correctly I can work on other triggers. I have tried, but have had no luck so far. I do value the work you guys do on this...

Thanks for the suggestion, Bj and Dave. A simply sql statement is working. I'm still trying to work on producing a simply function, but as let have not sloved it.

hi Its a fixed rate of £50 per hour. This amount has not been stored anywhere in the database. Will it help if I added this field to a table? When I was creating the database, I thought because it was a fixed rate, i would not have to include it, but if you think its a good idea, then I will.

Hi There are 10 rooms that can be booked by members. Their should never be that case that a room i.e 001 which has been booked between 14:00 & 15:00 to be booked again. If a member wanted however to book from 15:01 to 17:30, then this should be allowed. A room can be booked for a minimal of one...

My ex boss was a female and she was very good. It was a male dominated IT department, and it was nice to have a female around the place. Is it harder for females to get into IT? is their a perception that IT is a guy thing?