Search results for query: *

thanks tony! working like a charm

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

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

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.

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")...

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

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

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

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

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

Whats break mode??

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

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

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

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

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

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

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

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

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