RE: Complex SQL involving 10 checkboxes

2003-06-21 Thread Michael Scott
It comes down to detecting if the value you are adding to your list is a continuation of the list or the first item. You need to set a variable or even a counter at the start of processing then you can use the value of that variable to determine if you are processing the first list item or not. l

RE: Impossible query??

2003-06-15 Thread Michael Scott
I don't think that solves the problem. There are multiple test chains with Id's less than 7. ie 7->6->4->3->2 5 1 and your query looking for history on testId=7 SELECT * FROM tests WHERE testID<=7 AND connect>0; could return testId's 5 and 1 as well if they were part of longer cha

tables locked during connection failure & processes not auto killed after timeout

2003-06-12 Thread Michael Scott
Am I missing a configuration setting somewhere? I have been working on a MySQL Max (3.23.52-max-nt) database running on W2K Server. I am using a MySQL client remotely over a VPN but unfortunately the client's internet connection is severely overloaded and the connection dies on occasion. When th