• Member Avatar for pclfw
    pclfw

    Began Watching Why Is My New Laptop So Slow And CPU So High?

    Hello Daniweb Community, I've finally gotten around to doing it but can someone for the love of god please help me and give me help with fixing my slow ass …
  • Member Avatar for pclfw
    pclfw

    Replied To a Post in Why Is My New Laptop So Slow And CPU So High?

    My daughter had the same problem with her laptop. Windows 8.1 was installed and the whole thing was very, very slow. CPU running at 98% with nothing loaded. The cause …
  • Member Avatar for pclfw
    pclfw

    Began Watching SQL Insert India 'State'

    SQL Insert India 'State'
  • Member Avatar for pclfw
    pclfw

    Replied To a Post in SQL Insert India 'State'

    Wow, the Country list begins with ths USA and Canada, the rest of us have to be in alphabetical order. Who'd thunk it?
  • Member Avatar for pclfw
    pclfw

    Began Watching Trim down query

    Hi, I originally created this query to get a result from a single select statement Its funny that it became a very long query having sets of joined table Its …
  • Member Avatar for pclfw
    pclfw

    Replied To a Post in Trim down query

    Perhaps it would be easier to split this select into a number of smaller SELECTs each satisfying a seperate case (received, etc.) Then use the UNION operator to join the …
  • Member Avatar for pclfw
    pclfw

    Stopped Watching View for when there's no relationship between the tables

    I have the following view: ALTER VIEW [dbo].[vw_RelInclusaoGeralCivil] AS SELECT DISTINCT m.Nome AS MunicipioNome, au.Nome UsuarioNome, s.TipoId AS SolicitacaoTipoId FROM Solicitacao s INNER JOIN Unidade u ON s.UnidadeEntregaId = u.Id …
  • Member Avatar for pclfw
    pclfw

    Began Watching View for when there's no relationship between the tables

    I have the following view: ALTER VIEW [dbo].[vw_RelInclusaoGeralCivil] AS SELECT DISTINCT m.Nome AS MunicipioNome, au.Nome UsuarioNome, s.TipoId AS SolicitacaoTipoId FROM Solicitacao s INNER JOIN Unidade u ON s.UnidadeEntregaId = u.Id …
  • Member Avatar for pclfw
    pclfw

    Began Watching how to apply like on bigint columns

    Hi i have a table called hospitails. the table structure is as below **Hospitals:-** Hospital_id Bigint name varchar(45) city_id bigint district_id bigint state_id bigint now i need to search hospitals …
  • Member Avatar for pclfw
    pclfw

    Replied To a Post in how to apply like on bigint columns

    Just use `SELECT * FROM Hospitals WHERE city_id = $input ` This will return all of thew rows where the CITY_ID is the same as the input value.
  • Member Avatar for pclfw
    pclfw

    Began Watching windows 7 iso file

    can you help me find windows 7 iso file. I would like to use it as USB Bootalble Windows 7 Installer. Thanks a lot!!!
  • Member Avatar for pclfw
    pclfw

    Replied To a Post in windows 7 iso file

    Try Google. I found the whole set in about 5 seconds.
  • Member Avatar for pclfw
    pclfw

    Gave Reputation to naeem.u.qureshi in ERD Entity Relationship Model

    **Question two: [25 Marks]** Each technician may provide several repairs for several cars, but does not have to participate in any repair at all. Each repair specified is for one …
  • Member Avatar for pclfw
    pclfw

    Began Watching ERD Entity Relationship Model

    **Question two: [25 Marks]** Each technician may provide several repairs for several cars, but does not have to participate in any repair at all. Each repair specified is for one …
  • Member Avatar for pclfw
    pclfw

    Replied To a Post in ERD Entity Relationship Model

    And your question is...?
  • Member Avatar for pclfw
    pclfw

    Began Watching View records on mysql table using php

    Hi! I am currently working on my thesis and I don't have any idea on how can I view the records stored in 3 mysql tables. Can someone please give …
  • Member Avatar for pclfw
    pclfw

    Replied To a Post in View records on mysql table using php

    You really should go to www.php.net and look at the function definitions. The PHP site is one of the best available for learning the language. Even on a cursary look …
  • Member Avatar for pclfw
    pclfw

    Began Watching Join 3 MySQL Tables

    Good day! I have 3 tables name property, personal and spouse, they have all the same id. I want to join the 3 of them, I had already join property …
  • Member Avatar for pclfw
    pclfw

    Replied To a Post in Join 3 MySQL Tables

    SELECT * FROM property, personal, spouse WHERE property.id=personal.id AND property.id=spouse.id
  • Member Avatar for pclfw
    pclfw

    Began Watching combobox is not working in php

    hello, can anyone please help me with this piece of code, is not showing combobox value, why ??? its urgnt <tr><td>TERM</td><td><select name="term" ><option value="t_1">FIRST TERM</option><option value="t_2">SECOND TERM</option><option value="t_3">THIRD TERM</option><option value="t_4">FOURTH …
  • Member Avatar for pclfw
    pclfw

    Replied To a Post in combobox is not working in php

    Have a look at https://developer.mozilla.org/en-US/docs/Web/HTML/Element/option
  • Member Avatar for pclfw
    pclfw

    Began Watching Motherboards

    How to make Motherboard ?
  • Member Avatar for pclfw
    pclfw

    Replied To a Post in Motherboards

    "MAKE" a motherboard??????
  • Member Avatar for pclfw
    pclfw

    Began Watching Full table scan even after adding index

    Hi, i have two tables both one is partitioned and another is having a 3GB of data. I've added a composite index on both the tables based on the where …
  • Member Avatar for pclfw
    pclfw

    Replied To a Post in Full table scan even after adding index

    I am not an Oricle DBA, but in MS SQL the WHERE clause needs to be very specific before it actually fetches directly via the index. I see no reason …
  • Member Avatar for pclfw
    pclfw

    Began Watching weekly sales of one month

    I have a requirement to make a sales report from 1-aug-2014 to 24-aug-2014 like this: Product Name First Week Second Week Third Week a 12 6 2 b 0 0 …
  • Member Avatar for pclfw
    pclfw

    Replied To a Post in weekly sales of one month

    The MySQL documentation has your answer (I've just been reading it.)
  • Member Avatar for pclfw
    pclfw

    Began Watching Database Normalization (help Please)

    Can someone help me group the below attributes to 1NF,2NF and 3NF donor_session (date, session, pack_number, location_name, location_address, attendant_in_charge, technician, nurse) The meaning of the attributes are: date the date …
  • Member Avatar for pclfw
    pclfw

    Replied To a Post in Database Normalization (help Please)

    have a look at http://en.wikipedia.org/wiki/Database_normalization
  • Member Avatar for pclfw
    pclfw

    Began Watching Stored procedure Returning unexpected value while implementing AND Oprator

    I'm implement if else in stored procedure with and oprator . If both Conditions are true the if statement should return 1 else -1. here username and email should not …
  • Member Avatar for pclfw
    pclfw

    Replied To a Post in Stored procedure Returning unexpected value while implementing AND Oprator

    Ever thought about using the DB itself? Set the username and emailaddress as a concatonated unique index and try the insert. If you have a duplicate the insert will fail. …
  • Member Avatar for pclfw
    pclfw

    Began Watching How to Take sum of Individual Rows

    Hi All, I want the query to take the sum of individual rows. It can in MSSQL Query or Mysql Query. Please help.. Thanks in Advance.
  • Member Avatar for pclfw
    pclfw

    Replied To a Post in How to Take sum of Individual Rows

    So, have you had a look at the manual yet?

The End.