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 Wanet Telecoms Ltd 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: lazytrucker
  • Order by date
  1. lazytrucker

    OnUnload Event problems

    Hi all, I am using a script not unlike this below to open a new page when the client closes the browser: <body onLoad="closing=true" onUnload="if (closing) window.open('thanksForVisiting.html');"> The below code has been added to links to ensure the window does not open when navigating. <a...
  2. lazytrucker

    Simulteaneous request issue??

    Hi all, I am getting an error when users execute the exact request at the exact same time: Run-time error -2147024864 The process cannot access the file because it is being used by another process. The function being used in the dll makes, saves, sends, recieves and then saves an xml object...
  3. lazytrucker

    Run Time ERROR -2147024864

    Hi all, I have a site that heavily processes XML in conjunction with a DLL which in turn comunicates with an external server. Process: The .asp web page builds an xml, sends it to the DLL function which then runs through a connection process and building of several xmls (all xmls are created in...
  4. lazytrucker

    IIS Load Issues

    Hi all, I am running a test server on xp pro with iis 5.1 and MYSQL Server, and have come across several issues. 1.)When logging in with 8 users simulteanously not all are granted acces. Is this due to lack of proxy, Or a load issue, or something else? 2.)The server runs a dll which...
  5. lazytrucker

    RoundUp to 5

    ...statement. Function RoundUpTo5(NumIn) If NumIn = 0.01 then NumIn = 5 else NumIn = round(NumIn + 0.49) If NumIn Mod 5 > 0 Then NumIn = 5 * (Int(NumIn / 5) + 1) end if end if RoundUpTo5 = NumIn End Function Cheers LazyTrucker
  6. lazytrucker

    RoundUp to 5

    Thanks for all the replies but none of these soloutins work with decimal places. It is £'s and pence Im working with here so no negatives and always two decimal places. I am trying to alter genimuse's script but maths was never my strong point. Any suggestions very welcome. Cheers lazytrucker.
  7. lazytrucker

    RoundUp to 5

    + 234.00 rounds to 240 and 189.00 rounds to 195
  8. lazytrucker

    RoundUp to 5

    That looks fair enough but if the number is is 3.00 then it rounds to 10 I have a string manip func that works but it is messy. :: a = 435.00 b = 433.00 a= cstr(formatnumber(a)) b= cstr(formatnumber(b)) function roundUp(cost) if formatnumber(right(cost, 4)) <> 0 then...
  9. lazytrucker

    RoundUp to 5

    Hi all just wondering if anyone has a script which will round up a number to the nearest 5 eg: 123.15 >> 125.00 128.72 >> 130.00 Any suggestions will be appreciated Cheers Lazytrucker
  10. lazytrucker

    Dynamic Locks

    ...supports them (I think) although when running a test query it has struggled with adLockOptimistic but is fine with the other two. rs1.open "select * from table where col_id='" & var & "' and col_1='" & var1 & "'", con, adOpenDynamic, adLockOptimistic rs1!col_2 = stat rs1.Update rs1.Close...
  11. lazytrucker

    MULTIPLE INSERTS

    Is it possible to simultaneously insert a row into different tables using different column names in each table and different/similar values. EG: INSERT INTO table1 (col1, col2, col3) values (val1,val2,val3) INSERT INTO table2 (col5, col6, col7 ,col8) value(val1,val2,val6,val8) (BOTH above...
  12. lazytrucker

    GOOD TABLE STRUCTURE?

    I have looked at primary and foreign keys, and it is NOT an option, normalization is not possible for my application. I have heard MYSQL can handle (Supposedly) over 1,000 columns and over 1,000,000 rows of data what I need to know is what is the performance issues related to having more columns...
  13. lazytrucker

    GOOD TABLE STRUCTURE?

    Quick question to see if any one can point me to some articles or something. I am redesigning some of the larger tables in my "mysql" database, I want to create a new table with somewhere between 25-30 columns and 1000's of rows. This will be getting queryed alot and query caching is not an...
  14. lazytrucker

    CONVERT STRING TO OBJECT

    Hi all, is there a stored procedure or method for converting a string to an object?? The context in which I am trying to do this is as follows: For i = 1 To 3 "UserForm1.TextBox" & i & ".Visible" = False Next UserForm1.Show This obviously doesnt work but is...
  15. lazytrucker

    DYNAMICALLY CREATE FORM

    Hi Tony I see what your getting at here, and thanks for not telling me it simply wasnt possible, but when I try to run the sub I get an error: Run-Time Error'1004: Programmatic access to visual basic project is not trusted. This occurs on the first line of code: Set frm =...
  16. lazytrucker

    DYNAMICALLY CREATE FORM

    I have done some research on this subject and have had no luck. Basically depending on the previous results in my script I want to create a form for user input, simply if txtCount = 4 I want to create a form with 4 i/p fields if txtCount = 5, then 5 i/p fields are created etc. Does any one...
  17. lazytrucker

    For Loop A-Z

    Cheers for the posts using Ascii run loop from 65 to 90.
  18. lazytrucker

    For Loop A-Z

    Just wondering if it is possible to carry out a loop from a-z in asp like you can in delphi. Currently I use a script like this: For iCol = 1 To 26 If iCol = 1 Then sCol = "A" ElseIf iCol = 2 Then sCol = "B" ElseIf iCol = 3 Then sCol...
  19. lazytrucker

    Multiple-Step ERROR (Dynamic Cursor??)

    ...which processes using xml (hence the strange reply) However I think the problem arrises when using dynamic cursors in statements like this: select * from table where colum='" & var & "' and colum2='" & var2 & "'", con, adOpenDynamic, adLockOptimistic I have enabled dynamic cursors through...
  20. lazytrucker

    using vars to address form elements

    Thanks for the replys I thought you were on the right track with the id's so I messed about a bit and got there in the end: Function: function func(val) { var call call=document.getElementById("a"+val); document.fexp.depapt.value=call.value; } Where the hidden field looks like...

Part and Inventory Search

Back
Top