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!

  • Congratulations bkrike 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
  • Content: Threads
  • 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

    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...
  3. 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...
  4. 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...
  5. 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
  6. 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
  7. 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...
  8. 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>...
  9. andycape

    and's and or's in SQL queries

    I have a sql query that gets generated froman asp page, depending on what a user selects. There could be any amount of : - UserID 's - Vehicles_Trips.VID 's and the trip_diff and Mil_diff will be "<" or ">" a certain amount. When I create the list of UserID's or VID's I use "or", and the...
  10. 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)...
  11. andycape

    calculating diff between two times

    I want to calculate the difference between two given times. The times will be given in the format hhmm (eg : 1030). What would be the best way if I had a start and end time to calculate the difference between the two (answer in minutes)? I thought of something like this but its not right ...
  12. 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
  13. andycape

    is there a round up in ASP

    is there a way to round up a value in ASP? ie : &quot;1.9&quot; or &quot;1.2&quot; will both become &quot;2&quot; thanx
  14. andycape

    pop up : more than 1 line

    I am using the following pop up , is it possible to put the text onto more than one line ? (would do what <br> does in HTML). So i want the two sentances to be on seperate lines, not 1 long line. <script language=VBScript> Function a() If MsgBox(&quot;One of your Pieces exceeds the Max or...
  15. andycape

    open webpage in seperate window

    i want to open a ASP page in a seperate browser window, I use the following : <script language=&quot;javascript&quot;> window.open('../quotes/ViewQuote.asp','X','top=25,left=25,width=880,height=500',true); history.back(); </script> How would i change this if i wanted it to be the size of a...
  16. andycape

    CCS : page-break's

    I have heard 2 diff versions of what page-break-before:auto does, 1. nothing : default printer setting apply. 2. If its before a certain table/object it will force a page break if that table/object dosnt fit on the page. The 2nd one is what many websites say and this is what I want, but its...
  17. andycape

    footer in pdf

    when i create a PDF from my ASP pages i use the following. anyone know how i can enter a footer image (for every page). (i have tried --footer &quot;C:/image.jpg&quot;) i'm using : Set myexec = Server.Createobject(&quot;Dynu.Exec&quot;) Result = myexec.execute(PathToHTMLDOC &...
  18. andycape

    yes / no popup, directs to certain page

    How do i create a popup using vbscript from an ASP page that answers a question and if i click yes the webpage will change to one page, if i click no it will change to a different one. thanx.
  19. andycape

    inserting a table at bottom of PDF pages

    From my ASP webpage I'm using the following code to make a PDF (its working fine): Set myexec = Server.Createobject(&quot;Dynu.Exec&quot;) Result = myexec.execute(PathToHTMLDOC & &quot;htmldocd.exe --webpage --size a4 --top 0.2in --left 1.2cm --right 1.2cm --bottom 0.2in -f...
  20. andycape

    pop up question, sends you to different page

    How do i create a popup using javascript from an ASP page that answers a question and if i click yes the webpage will change to one page, if i click no it will change to a different one. thanx.

Part and Inventory Search

Back
Top