Recent content by mrasad

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