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

  • Users: mthompo
  • Order by date
  1. mthompo

    center prob...

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

    center prob...

    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">...
  3. mthompo

    center prob...

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

    rs.eof prob...

    forgot to give a star *
  5. mthompo

    rs.eof prob...

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

    rs.eof prob...

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

    rs.eof prob...

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

    available booking time query

    quite right - thanks to all
  9. mthompo

    available booking time query

    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 <=...
  10. mthompo

    available booking time query

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

    asp date &gt; mysql date format

    many thanks
  12. mthompo

    write cus name if between dates

    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 "_ &...
  13. mthompo

    asp date &gt; mysql date format

    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" &...
  14. mthompo

    asp date &gt; mysql date format

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

    are nested tables the answer?

    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')...
  16. mthompo

    are nested tables the answer?

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

    write cus name if between dates

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

    write cus name if between dates

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

    are nested tables the answer?

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

    write cus name if between dates

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

Part and Inventory Search

Back
Top