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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by compudude86

  1. compudude86

    dealing with duplicates in database

    ok, ive modified it to this and gotten it to work: <code> delete P from Products as P inner join ( select Description , NetBtl , min(Date) as min_date from Products group by Description , NetBtl having count(*) > 1...
  2. compudude86

    dealing with duplicates in database

    thank you very much, it worked, it took out some 634 duplicate records.
  3. compudude86

    dealing with duplicates in database

    ok, so i have a table of products, called "products" located in a database called "Book". my problem is when i update products, using a csv file through phpmyadmin, it will add another row, all the same info (price, description, etc) but different dates, and different primary keys...
  4. compudude86

    looking for a copy of irix 6.5.8+

    looking to buy a copy of irix from someone, anyone?
  5. compudude86

    ordering in phpmyadmin export

    i am using phpmyadmin to create reports from my database. i export them to a PDF file, and it arranges them by another field, i would like it to arrange a-z by the tables "description" field. how would i do this?
  6. compudude86

    order a view

    ok. how would i go about doing this in phpmyadmin export to pdf?
  7. compudude86

    order a view

    i have a view that i need ordered by ascending when i access it. right now it sorts by ID i believe. here is my code to create the view: DROP VIEW IF EXISTS `Book`.`book`; CREATE ALGORITHM=UNDEFINED DEFINER=`server`@`` SQL SECURITY DEFINER VIEW `Book`.`book` AS select `view`.`Description` AS...
  8. compudude86

    mySQL view and mathematical formulas

    ahh, that worked perfectly. thank you very much!!
  9. compudude86

    mySQL view and mathematical formulas

    i am using something called dataface as my frontend, and i run the query in mysql query browser to create "view" which the frontend gets its information from
  10. compudude86

    mySQL view and mathematical formulas

    i have only a very basic knowledge of mysql, so i would not know how to do that. i have set the field in the table that the view gets its data from as 19,2 but its not making a difference
  11. compudude86

    mySQL view and mathematical formulas

    ok, i used that query, but now my NetBtl field has a number like 12.000000000 in it, instead of the 12.00 field it was before. how do i fix this?
  12. compudude86

    mySQL view and mathematical formulas

    ok, i have a mysql query, (CREATE VIEW `Book`.`view` AS SELECT ID, Description, Size, Pack, List, Net, Discount, NetBtl, SRP, Vendor, Date, CONCAT(ROUND((srp-netbtl)*100/srp),'%') as GPM FROM Products;) and i need to add in the formulas (List-Discount=Net)and (Net/Pack=NetBtl) along with it...
  13. compudude86

    form with odbc mysql database

    ok, i have a form in access, so that i can edit and apply mathematical formulas to a local access table, but my linked table doesnt get changed. so i made a view of the table, and i only get one line of the table, not the whole table. how do i fix this?
  14. compudude86

    sendmail smart host config

    hello, i have smartmail, "Sendmail version 8.13.5.20060308, config V10/Berkeley". when i installed it, and went to the sendmail.mc file, and theres nothing for smart_host. i am setting this up on sbc yahoo dsl. help!!
  15. compudude86

    reporting mysql view using php

    i want to make a report, that would print to 8x11 landscape, in a standard html table, using mysql as the source. how would i do this?
See more

Part and Inventory Search

Back
Top