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

    ...display:block; background:url("images/tabright2.gif") no-repeat right top; padding:2px 10px 2px 6px; color:#84776B; } /* Commented Backslash Hack hides rule from IE5-Mac \*/ #tabs2 a span {float:none;} /* End IE5-Mac hack */ #tabs2 a:hover span {...
  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

    ...table CB contents create database if not exists `servbook`; USE `servbook`; SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO'; /*Table structure for table `courtcarbook` */ DROP TABLE IF EXISTS `courtcarbook`; CREATE TABLE `courtcarbook` ( `courtcarbookid` int(11) NOT NULL...
  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