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

  1. Double02

    ASP and SQL and auto update datefield

    As this is one block of code, don't terminate it early! <% If x_gesperrt = True Then %> <x_sperrdatum = myNewDateTime strSql='"UPDATE data SET x_sperrdatum= '" & x_sperrdatum & "' WHERE WHERE [ID]=" & tkey conn.execute(strSQL) %>
  2. Double02

    load photos from a database

    Sorry, sloppy formatting: response.write "<a href='images\" & rst.fields("bigpic") & ".jpg'>" & _ "<img src='images\" & rst.fields("thumbnail") & ".jpg'>" & _ "</a>"
  3. Double02

    load photos from a database

    You have two references in the table, one for the thumbnail and one for the full size image. Then when you write the page, put the large pic ref into the anchor: response.write "<a href='images\" & rst.fields("bigpic") & ".jpg'>" <img src='images\" & rst.fields("thumbnail") & ".jpg'>" </a>...
  4. Double02

    Disable submit button after click... why isn't this easy?

    It needs to happen client-side, because that's where the user is pressing the button, so the code to disable the button would need to go in the onClick procedure. There isn't a visible property, but there is a disabled one: btnSubmit.disabled = true Without seeing the thisPage._fireEvent...
  5. Double02

    Difference between a Session and Application variable

    So you don't need either a Session or an Application variable, then. You just need (as bastienk described) a standard variable, which either has page scope (declared outside a sub or function and visible to all) or local (declared inside a sub or function and only visible there). I haven't...
  6. Double02

    ASP only works sometimes. What did I do wrong?

    Additionally, the more usual response is experienced with the second page - the server can't process it and offers it for downloading.
  7. Double02

    ASP only works sometimes. What did I do wrong?

    Well, FP extensions does not mean it can run ASP unfortunately. Your site is running on a Unix box which doesn't appear to have one of the ASP clones running, so you won't be able to run ASP pages. If you View | Souce in IE you can see your asp code, which means the page has not been processed.
  8. Double02

    Chat Application

    No probs, Tarwn :) Not done with DW either, as far as I can tell!
  9. Double02

    ODBC error is making me go mad: ODBC Drivers error '80004005'

    This is usually caused by incorrect or absent data when the connection object tries to open the connection. Has the connection string been properly defined? Has it been correctly assigned to the object? Is the string in the current page or global.asa? If so, is the global.asa unique within the...
  10. Double02

    Chat Application

    For a working free ASP chat with source code see http://www.theill.com/asp/conquerchat.asp This uses objects, collections and some clever JavaScript for the DHTML refreshes. Reverse engineering this one is not for the faint-hearted though :)
  11. Double02

    page restrictrd to one user @ a given time

    application("users")=0 Your count won't be 1 until someone is using the data entry page. To set the count to 1 in the data entry page: If Application("NumUsers") = 0 Then Application("NumUsers") = 1 Else server.transfer "pageislocked.htm" End if To set it back to 0, provide a method...
  12. Double02

    asp sendmail script - small & simple

    Is the CDONTS object available? Try switching off "friendly" error messages in your browser and you may get a little more information. Tools | Inernet Options | Advanced tab - clear check box for Show friendly HTTP messages
  13. Double02

    HTML page expiration

    Probably just being cached too "enthusiastically" by the ISP. Control+F5 refreshes your local copy from the server, but if that's giving you an old page you're no further forward! (As a test, rename or delete the page on the server and see how many requests it takes before you get a 404) Try...
  14. Double02

    Help to connect to a Access DataBase

    If your connection didn't work, you wouldn't get the Recordset error, you'd get a different one :) Well, again, that's one of the advantages from creating and using the view - it works like a single table and is also much easier to test. Specifying all those individual fields is very...
  15. Double02

    Order 1,2,3,4,5,6,7,8,9,10,11 looks like 1,10,11,2,3,4,5,6,7,8,9

    What data type is the field? It seems to be returning a text value rather than a numeric value, as they are listing in alphabetic order.
  16. Double02

    Error message -Data type mismatch

    Surely the best option is to provide the current Date - isn't the upDate the date it was updated?
  17. Double02

    Help to connect to a Access DataBase

    The PC Name is: <%= x_rs.FIELDS("SampleCompany.Ram")%>
  18. Double02

    Error message -Data type mismatch

    logicalunatic, although Access uses # natively for dates, ADO uses standard SQL, so you use single quotes (and, similarly, SQL wildcards)
  19. Double02

    Error message -Data type mismatch

    Well, you response.write it, copy the output and paste into a post here so we can see what the full SQLStmt output looks like.

Part and Inventory Search

Back
Top