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 Rhinorhino 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: *

  • Users: mrasad
  • Content: Threads
  • Order by date
  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?

    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...
  5. 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...
  6. 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
  7. 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...
  8. 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...
  9. mrasad

    double book should not be allowed - trigger problem

    Hi I wanted to create a trigger to fire on insert or update, when a room had already been booked. The reserved_For,reserved_Until are both Date fields and have the following format (to_date('21-11-2003 09:00','DD-MM-YYYY HH24:MI'),to_date('21-11-2003 11:00','DD-MM-YYYY HH24:MI'). I've create...
  10. mrasad

    Update values of two tables with use of trigger?

    Can you create a trigger that when an item on one table in updated, then values in another table are also updated. For example, in a table called loans where I have a field called due date and return date. In another table called member, I have a 2 fields called late and bared. When the loan...
  11. mrasad

    Calculating cost of room with a function

    I currently have a table (reserved room) in my database, I have a number of columns. I have a room reserved ID, a date_for and date_to, and member id (foreign key) . Example; 'RR001' to_date('21-11-2003 09:00','DD-MM-YYYY HH24:MI'), to_date('21-11-2003 11:00','DD-MM-YYYY HH24:MI'), 1 ...
  12. mrasad

    Create Trigger with max amount of days

    Is it possible to create a trigger that will not allow for an Insert or Update if the due date is greater then 2 weeks from the current date? I have a loans table; create table loan (LoanID varchar2(6) PRIMARY KEY, Issue_Date date not null, Due_Date date not null, ...... The issue_date will...
  13. mrasad

    How to calculate dates?

    In my database I have a table called loans, within that I have the following attributes; create table loan (LoanID varchar2(6) PRIMARY KEY, Issue_Date date not null, Due_Date date not null, Return_Date date not null, Fine_Total number(3,2 .....)); I want the ability to run a view (called...
  14. mrasad

    I'm having a problem try to create

    I'm having a problem try to create for keys in my oracle table. Example; create table loan (LoanID varchar2(6) PRIMARY KEY, Issue_Date date not null, Due_Date date not null, Return_Date date not null, Fine_total number(3,2), FOREIGN KEY (Item_ID) REFERENCES AV_Item, FOREIGN KEY (BookNo)...
  15. mrasad

    How to create a time field in Oracle

    Hi I want to create a field for 'start time'. I have written Time_start date not null .... but when I try to enter a time in the table, it say incorrect use (of something). Is it possible to have a time field without the :SS, so its just HH:MM? Asad
  16. mrasad

    Download of Oracle 9i for home computer?>

    Is their a FREE download of either oracle 8 or 9i, that will work with windows 2000? Will this require a username/password/hoststring? where will i get this information? thanks
  17. mrasad

    How to Create/Use a Trigger

    Hi Guys, I need some help with creating a simple trigger. I will try to explain the problem i'm having. I created a table called MEMBER; SQL> CREATE TABLE MEMBER 2 (MemberID number(7) not null primary key, 3 Surname varchar2(15) not null, 4 Forename varchar2(15) not null, 5 DOB...
  18. mrasad

    Suggestions for any helful pl/sql websites

    Hi guys, Do you know of any decent websites/tutorial type sites that could help me with pl/sql. I know very little (almost nothing) about it, but i need to create stuff like triggers, stored functions, procedures, anonym’s blocks etc. Thanks
  19. mrasad

    Display Computer Name

    Hi, I working on a online fault logging system that is attached to a database thingy. I have a problem, in order for a user to log a problem he/she needs to enter there computer name. Suggesting they "right click on my computer, properties, network id" to find computer name is not...

Part and Inventory Search

Back
Top