Recent content by winston1984

Sorry the website is down, here is a link for the sample: Sample Here

I have a report which takes from my db details about products, a picture image name and header and price. It does this by having a subreport with the product info in 3 columns and then that is put in another report with its group heading. I puts these all on a page and sort and group by their...

it doesn't limit the results in any way, it still brings back the 0.0's.

Unfortunately that is not possible, as I am getting other products as well, here is my query. I need to filter to products > 0.0 in BlowOutNett without touching the WHERE clause: SELECT LEAST(SterlingTradeGross , CASE WHEN BlowOutNett <= 0.0 THEN 9999999 ELSE BlowOutNett END...

Thats great, Least is what I was after. However, there's a BUT... Some of the values in the BlowutNett field are 0.0 (float), I want to ignore these, any ideas?

I need to find out how to find the minimum value usig a query over three columns: SterlingTradeGross BlowOutNett SterlingTradeQGross These are the three columns, I need a query which calculates the minimum value from all of these, how do I do it?

In Javascript I have a menu which on hover or a table cell a layer appears and fills with data from a db. I want it so that if this column is more that 20 items another column appears next to it and fills that with data. Can anyone point me in the directions of a tutorial or a way to do this?

I only have one instance of a Product in the database. Each part has a partNumber, etc, and a ProdGroup ( a 4 digit numerical number corresponding to a Grouping, e.g. Handlebars ), then two more fields are DuplicateGroup1 and DuplicateGroup2. These are 4 digit numerics as well. For example, a...

I only have one instance of a Product in the database. Each part has a partNumber, etc, and a ProdGroup ( a 4 digit numerical number corresponding to a Grouping, e.g. Handlebars ), then two more fields are DuplicateGroup1 and DuplicateGroup2. These are 4 digit numerics as well. For example, a...

I have a piece fo code (below) which lists all the brands from a mySQL database. However, one of the brands has a space it it, it is '4 STAR', it only returns the '4', not the 'STAR', why is this? It is stored as varchar in the database. <? if ($currGroup != '') { $query = "SELECT DISTINCT...

I have a DTS package that connect to the database, uses a select command to get the required data and puts it in a Rowset global variable. Then I have a connection to a MYSQL database, where I take the value of the rowset and delete the values from the table in the mysql database. If I use the...

I have the following code creating a form for user login. there is a gap below the buttons that causes the table to be larger than I want. how can I remove it? <td class="redborder"><form action="login.php" method="get" name="loginform"><p class="menutext">Username<br> <input...

I have the code below, now if I sent the sub email to lewis@lharvey.com, it works fine, but sending to anything@ison-distribution.com it doesn't. Norton won't even scan it on the way out. The only difference in addresses is that the ison ones are forwarded and not email accounts, any ideas...

Why is this repeating the values, they should be differently listed, but after a point it just repeats them. I have tried putting a strRecord = "" in after the first loop and it just prints nothing. '********************************************************************** ' Visual Basic ActiveX...

I have the following query. i want to check that the two prices are either the same or with two pence of each other either side, any ideas? SELECT Ison7.SystemLC, Stock.TotalLandedCost, Ison7.IDPartNumber, Stock.IDPartNumber AS Expr1 FROM Ison7 INNER JOIN Stock...