Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mrasad

    Searching for text in a field

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

    New to php - getting php to work with mysql

    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...
    • mrasad
    • Thread
    • Replies: 2
    • Forum: PHP
  3. mrasad

    Network Optimisation - Questions

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

    MS Access Query - total sum?

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

    MS Access Query - total sum?

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

    Apache on Windows

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

    Acess and the WWW

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

    Microsoft Error Message

    Window Updates Run?
  9. mrasad

    4600N - Problems Printing Screen Dumps from VB6

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

    IE CLose Problem

    Have you run all the windows updates for your machine?
  11. mrasad

    Calculating cost of room with a function

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

    A simple stored procedeure not working

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

    A simple stored procedeure not working

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

    Update values of two tables with use of trigger?

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

    Calculating cost of room with a function

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

    double book should not be allowed - trigger problem

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

    Calculating cost of room with a function

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

    Calculating cost of room with a function

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

    double book should not be allowed - trigger problem

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

    Chicks in IT: Any statistics available?

    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?

Part and Inventory Search

Back
Top