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 strongm 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: andycape
  • Order by date
  1. andycape

    code instead of manual changes

    I have the following piece of code that needs the last month added manually each month when it is run. I'm sure there must be a way to do this automatically ? Insert into Migration Select h.PersonNo, 'May99' = '', 'Jun99' = '', 'Jul99' = '', 'Aug99' = '', 'Sep99' = ''...
  2. andycape

    padding in CSS

    I do have that in my external css sheet, maybe I'll try using it in the page itself ? thanx.
  3. andycape

    position:absolute;

    <body bgcolor="#EEEDC8" topmargin="0" leftmargin="0"> <table cellspacing="0" cellpadding="0" border="0"> <tr> <td valign="top"><img src="/Images/Untitled2.jpg" WIDTH=180 HEIGHT=690 alt=""></td> <td> <br> <h2><strong>Contact Us</strong></h2> <table cellspacing="0" cellpadding="0"...
  4. andycape

    position:absolute;

    I have the following scenario : <table> <tr> <td> Picture here </td> <td> writing here </td> </tr> </table> The pictue is leaving a tiny space to the left, I was looking for a way to get it to leave no spaces (Padding 0; Margin 0; in body tags isnt working) Going through the FAQ's I...
  5. andycape

    padding in CSS

    I am using padding 0; in my style sheet for body but I have a picture in the top right corner that is going all the way to the top but is leaving a 2-3 mm gap on the left no matter what I do. Is there a way to force the left padding to be 0 ? (I even put a leftmargin=0 tag in the body tag...
  6. andycape

    redirect a webpage

    Anyone aware of the javascript you would use to make a redirect page? ie : Redirect the user to a different page and maybe have one of this messages "You will be redirected to XXX in 5 seconds, or else click on this link" Obviously this is just an html file , and I guess you would include the...
  7. andycape

    update statement with aggregates ?

    Is it possible to include aggregates in an update statement? I want to do the following that is not being allowed : Update dbo.TmpMaster30_1 set t.FirstProm = min(h.Prom) from dbo.TmpMaster30_1 t, dbo.FACT_OF_PROM_ARCHIVE h, where t.PersonNo = h.PersonNo
  8. andycape

    update statement with aggregates

    Is it possible to include aggregates in an update statement? I want to do the following that is not being allowed : Update dbo.TmpMaster30_1 set t.FirstProm = min(h.Prom) from dbo.TmpMaster30_1 t, dbo.FACT_OF_PROM_ARCHIVE h, where t.PersonNo = h.PersonNo
  9. andycape

    a few simple questions from a novice

    I'm very new to photoshop as you will tell from my questions, I was wondering if someone could let me know the steps to achieving the following 3 things : 1. Placing one picture ontop of another 2. Cutting a picture out (ie : cutting part of a pic away from its background). 3. Changing the...
  10. andycape

    Printing - hide items using javascript

    I changed it to "sel" and I'm still getting nothing. i cant understand why it works with just the select box,but not when i add the text box's. am i refrensing them correctly ? ie : document.getElementById("Dear").innerHTML= document.form.Dear.value
  11. andycape

    Printing - hide items using javascript

    No I'm not, you are probably looking at the address text box, sorry I typed that wrong I dont have an ID, just a name. The only ID's i have are the three divs - "select", "address" & "dear", where I want the information to be printed.
  12. andycape

    Printing - hide items using javascript

    I get my user to choose a value from a drop down and then when Iprint the form, the value, not the select box appears. To do this I use : <span class="noPrint"><select style="width:150px;" name="Company"> //// My select box is here </select></span><div id="select"></div> <script>...
  13. andycape

    and's and or's in SQL queries

    ...have tried using all and's, and all or's - dosnt work either) can anyone see where my and's / or's are not working correctly :-) Thanx. Select * from Vehicles_Trips left join Vehicles on Vehicles.VID = Vehicles_Trips.VID where Vehicles_Trips.VID= 3 or Vehicles_Trips.VID= 5 or UserID = 964...
  14. andycape

    if statement

    I want to write an if statement to say if a certain value is over 0 then i need to check if two other values exist, and if they do not i need to prompt the user. It sounds easy but I'm quite new to this :-) somewhere along the lines of : function checkForm(form) { if (form.Min.value > 0)...
  15. andycape

    calculating diff between two times

    thanx alot yes that helps, I also saw it was returning a 0.
  16. andycape

    calculating diff between two times

    thanx alot that gets the right answer most of the time (if the difference between the two times is small, but if i use say 0900 and 1550 then its incorrect. I will try play with it and sort it out. thanx.
  17. andycape

    calculating diff between two times

    Its not quite working, but I will carry on trying. The times will always be on the same day, and hopefully in 24hr clock (although i need to cover the possibility that the user will not enter 24hr). The logic of the method i was thinking is correct (it works in asp) but the left() and right()...
  18. andycape

    calculating diff between two times

    ...{ vala = left(document.myform.End.value,2); valb = right(document.myform.End.value,2); valc = left(document.myform.Start.value,2); vald = right(document.myform.Start.value,2); document.getElementById("Time").innerHTML = (parseInt(vala) - parseFloat(valc))*60 +(parseInt(valb) -...
  19. andycape

    do frames work on a linux server

    thanx mate I just found the problem, the server dosn't like capital letters in the file names (dont know if this is a linux thing ?)
  20. andycape

    do frames work on a linux server

    I tried to use frames on a linux server and its not working, is it the server or something else ? thanx

Part and Inventory Search

Back
Top