Search results for query: *

many thanks - went with chris' solution as works great anyone who reads this dont forget to remove the 140 padding on tabs2 ul thanks again

thanks for your reply added this style #headermenu {margin:0 auto;width:100%;height:100px;float:center;text-align: center;} added to #tabs2 #tabs2 { text-align: left; width:100%; font-size:93%; line-height:normal; border-bottom:1px solid #84776B; } changed html to <div id="headermenu">...

have the following css to put a top bar menu on the page but cant get the menu to center in the page it uses 140px in this line padding:5px 5px 0 140px; ...to start the menu 140pixels from left - but i want the menu to center in the page - have tried float:center all over the place but doesnt...

forgot to give a star *

thanks tarwn - your reply was very helpful and clearly explained the opions available - went number two as this was the simplest! changed the sql order and added this line after the do while loop for both lists [except changed the holtypeid to 2 for the second list!] if holtypeid <> 1 then...

also tried putting in if not (rsside.eof) then rsside.movefirst end if but of course this wont work because after the end of the first list the rs is eof so it never movesfirst

Hi, have the following code which makes two lists a list for holtypeid =1 and a list for holtypeid =2. i dont want two rs, so i goto the first record for the second list using rs.movefirst so the loop starts again - which is fine as long as there are records for holtypeid =1 or 2 , else i get...

quite right - thanks to all

many thanks added () around date clause' SELECT courtcarbook.courtcarbookid, courtcarbook.bookst, courtcarbook.bookend FROM courtcarbook WHERE courtcarbook.carid =14 AND ('20061028' BETWEEN bookst AND bookend AND '20061028' BETWEEN bookst AND bookend OR (courtcarbook.bookst <=...

have the following sql that finds booking spaces that are already booked if the recordset is eof then the space is free i want the query to not include bookings that are the same as the booking being edited SELECT courtcarbook.courtcarbookid, courtcarbook.bookst, courtcarbook.bookend FROM...

many thanks

ok - think it was a date issue in the sql preliminary tests show this works fine :):):):):):):):):):):):):):):):):):):):):):) 'sql sql= "SELECT cus.lname, CC.reg, CBB.bookst, CBB.bookend, CC.carid, CBB.courtcarbookid,tran.trandesc, CC.model "_ & "FROM courtcar AS CC "_ & "LEFT JOIN "_ &...

oops year var was wrong - should read whenstart =date() motdaynumsql = day(whenstart) motmonthsql = month(whenstart) motyearsql = year(whenstart) 'sql start daysql = motdaynumsql if daysql < 10 then daysql = "0" & daysql end if monthsql = motmonthsql if monthsql < 10 then monthsql = "0" &...

ok have written some script that changes standard UK date format dd/mm/yyyy to mysql query format yyyymmdd whenstart =date() motdaynumsql = day(whenstart) motmonthsql = month(whenstart) motyearsql = year(whenstart) 'sql start daysql = motdaynumsql if daysql < 10 then daysql = "0" & daysql...

ok - thanks...sure that worked friday! (SELECT CB.bookst, CB.bookend, CB.carid, CB.courtcarbookid, CB.cusid FROM courtcarbook AS CB WHERE (cb.bookst BETWEEN '20061015' AND '20061021') OR (cb.bookend BETWEEN '20061015' AND '20061021') OR (cb.bookst < '20061015')...

have changed the sql to this SELECT CB.bookst, CB.bookend, CB.carid, CB.courtcarbookid, CB.cusid FROM courtcarbook AS CB WHERE (cb.bookst BETWEEN '15/10/2006' AND '21/10/2006') OR (cb.bookend BETWEEN '15/10/2006' AND '21/10/2006') but still returns records from 2005! any ideas welcome

...one more thing, i think its an asp issue because if i run that query with a week prior to the first booking i only get one row per car

nice bit of sql - but am afraid it still adds a row for each booking in the weeks to the first booking thanks anyways - sql works great thought i would post the asp im using - but should be the same as you originally created <%' courtcar 'sql sql= "SELECT cus.lname, CC.reg, CBB.bookst...

the days of the week are worked out by the asp how can i build conditions that select bookings where the startdate of the week is within cb.bookst and cb.bookend and then end date of the week is between cb.bookst and cb.bookend thought i had it booksql = "SELECT courtcarbook.courtcarbookid...

great advice damber [as usual] thought i had it with this SELECT cus.lname, CC.reg, CBB.bookst, CBB.bookend, CC.carid, CBB.courtcarbookid,tran.trandesc, CC.model FROM courtcar AS CC LEFT JOIN(SELECT CB.bookst, CB.bookend, CB.carid, CB.courtcarbookid, CB.cusid FROM courtcarbook AS CB WHERE...