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

  1. shaunieb

    Selecting information from 3 or more tables with a common id.

    thanks tony! working like a charm
  2. shaunieb

    Selecting information from 3 or more tables with a common id.

    Hi I have 3 or more tables i need to get info from. They are all related by unit_id, but im not sure how to do it. Can anyone give me some ideas? The tables are displayed below. Thank you in advance. BOND unit_id bank accountno banktel contactname contacttel...
  3. shaunieb

    Removing duplicates from an arraylist

    Thanks for your help. What is Dim delEntries As ArrayList for?
  4. shaunieb

    Removing duplicates from an arraylist

    I'm pulling my hair out here :) , i know im dong something really small wrong. What is the recommended way to remove duplicate items in a arraylist? Im so tired, ive spent hours trying to figure this out :( Please any help would be greatly appreciated.
  5. shaunieb

    Why is my dataadapter empty?

    Hi everyone. When i run my application i get the following error on the highlighted line :: Additional information: Value cannot be null. Dim connStr As String connStr = String.Format("server={0};user id={1}; password={2}; database=prodev; pooling=false", "main", "root", "root")...
  6. shaunieb

    culculating and creating column total

    Syntax error (missing operator) in query expression 'products.cost+14+25 total_cost'.
  7. shaunieb

    culculating and creating column total

    ok, ive done it slightly differently since i didnt tell you guys that the 2 tables dont join in an way, I just wanted the 2 values from percentages to use in the calculations for the product totals. heres my try, it doesnt work! markup and vat are integer variables in my app. it complains...
  8. shaunieb

    culculating and creating column total

    No, there is percent.vat, percent.markup & percent.id; the other table has products.id, products.name, products.description, products.cost. So i need a total column with a value calculated from products.cost + percent.vat + percent.markup Sorry I got my table/column order mixed up. Hope this...
  9. shaunieb

    culculating and creating column total

    Hi, i've been trying to do this for about 3 hrs and am really killing my self here. Here are my 2 tables : vat.percent,markup.percent cost.product,productname.product What i want to do is select the data and then create a total column with a value calculated from...
  10. shaunieb

    System.Data.datarowview error when populating listbox. Pls help me..;(

    i got it, just looping through the dataset and populating row by row. thnks everyone
  11. shaunieb

    System.Data.datarowview error when populating listbox. Pls help me..;(

    Whats break mode??
  12. shaunieb

    System.Data.datarowview error when populating listbox. Pls help me..;(

    HI, thanks 4 the the help! still doesnt work...
  13. shaunieb

    how do i populate a listbox with a dataset

    hI, I'm mailny a asp.net guy and its pretty straight forward to do this with dropdownboxes etc is asp.net but for the life of me i'm striggling in vs to populate my listbox. I get System.Data.Datarowview instead of the values from my request. Please help. I've tried to do this for about 4 hrs...
  14. shaunieb

    System.Data.datarowview error when populating listbox. Pls help me..;(

    hI, I'm mailny a asp.net guy and its pretty straight forward to do this with dropdownboxes etc is asp.net but for the life of me i'm striggling in vs to populate my listbox. I get System.Data.Datarowview instead of the values from my request. Please help. I've tried to do this for about 4 hrs...
  15. shaunieb

    removing duplicate colum records, hmm

    I do have a table for color variants. Heres all the tables in question. colorcombo ID color1 color2 1 1 28 2 2 28 3 4 28 4 14 28 5 17 28 6 18 28 7 20 28 8 22 28 9 16 28 10 9 28 12 3 28 13 27 28 14 23 28 15 11 28 16 11 28 17 6 28 18 13 28 19 10 28 20 8 28 21 1 10 22 14 10 23 1 11 24 2 10 25 18...
  16. shaunieb

    removing duplicate colum records, hmm

    Thanks for the help The reason it doesnt matter is because I want to display the avaliable single colors of a product ie pcol1 first and then after a user clicks on that particular color image it will then display the variant colors avaliable pcol2 for pcol1. Does that make sense? Regards Shaun
  17. shaunieb

    removing duplicate colum records, hmm

    1 more thing. How do I run a query off the results above? Thanks Shaun :)
  18. shaunieb

    removing duplicate colum records, hmm

    Hi vongrunt, It doesnt matter in this case but if it did how would i do it? Thanks Shaun
  19. shaunieb

    removing duplicate colum records, hmm

    Hi everyone, What Im trying to do is not display duplicate color records in the pcol1 column, heres my sql string and the results are shown below that. The pcol1 column contains the 2 b/green 3 red and 2 navy records. Thanks In advance :) Shaun select pc1.id, pc1.colorid, pcolid = (select...
  20. shaunieb

    Using nested joins ?? (I think) :)

    Thank you very much gradley, you are a genius! :)

Part and Inventory Search

Back
Top