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: thompom
  • Content: Threads
  • Order by date
  1. thompom

    drag and drop one div to many divs

    I would like to drg n drop a div with width 60px (ccarcellbook) onto 3 divs with width 20px (ccarcell). Have got basic d n d function so that the big div replaces one of small divs, but dont know how to replace 3 small divs $('.ccarcellbook').draggable({ helper:"clone", cursor: "move"...
  2. thompom

    help with slow query

    Hi, can anyone help me speed up this query? at present it returns 192 rows but takes 4 secs. I notice it is looking at 240000 response records - think this is where issue may be, but don't know how to resolve SELECT response2.actionid, response2.typeid, response2.notes...
  3. thompom

    slow data load after restore from sqldump

    Hi, When I restore a backup from live server onto my dev machine The asp pages load very slowly until I delete indexes from MySQL db. Can anyone explain why this happens? thanks MG
  4. thompom

    session timeout

    Hi, Have just split asp front and mysql back onto different servers. Now users are redirected to login page every 20 mins at the same time. The asp is on the same server as before and has no session.timeouts in the code and the session state timeout is set to 1440 mins. Also as all users are...
  5. thompom

    speed up query

    Hi - the following takes 7 secs to run (78 rows are returned) - any ideas how to speed it up? SELECT action.userid FROM `action` LEFT JOIN (SELECT COUNT( CASE WHEN UCASE(response.reasonid) LIKE '%APPOINTMENT%' THEN 1 END...
  6. thompom

    cant SELECT after large import

    Hi, Yesterday night I imported 20K records into mysql DB. Today when i try to select new records added - they dont show Anything I can do? cheers MG
  7. thompom

    uploadify 3 pass formdata issue

    Hi - anyone useing uloadify v3? am trying to pass values to my server script using the following, however fiddler tells me that the value of actionid is always 'notset' the alert shows 47185 how can i get the onstart to change formdata? $('.file_upload').uploadify({ 'formData' ...
  8. thompom

    CS1518: Expected class, delegate, enum, interface, or struct

    Hi - am a classic asp coder trying .net for first time As a starting project am creating a web service from instruction http://carvingcode.blogspot.co.uk/2010/04/creating-wcf-web-service-with-vs2010.html have copied example exactly but get following error: Compiler Error Message: CS1518...
  9. thompom

    count records when another ecord exists

    Hi - am struggling making this work Have a list of users and a count when a record action.typeid = 1 and a response.reasonid LIKE appointment IF a record with action.typeid = 2 exists with actiondate between two dates the two action records are linked by table Event all dealcount show as...
  10. thompom

    secure IUSR account

    Hi, Just upgraded from 2003 to 2008 (iis6 to 7) and have given some folders write permission for the IUSR account. I have some asp apps that write using ADODB.Stream. How secure is this? can anyone write files to these folders now? Are there any steps I can take to improve security? I ask...
  11. thompom

    jquery set .html with array data

    Hi - am moving my ajax funcs to jquery and want to set innerhtml with array data - but the following doesnt work, just get blank div and no errors If i replace update[0] with "text" it works but doesnt seem to like array data (which does have values) $.get(loadUrl, function(data){ var update...
  12. thompom

    100% height inner div with sticky footer

    Hi, My layout consists of a sticky header/footer with content that has a scrollbar - the problem is the content is being hidden behind the header and footer. Have tried adding margin to sort issue which pushes content down from top but still cant see bottom. CSS #header { position:absolute...
  13. thompom

    row copy from 1 db to another

    Hi, Want to copy a row from one database to another on different servers - have googled this and sql now looks like INSERT INTO server1.db.table (field1, field2) SELECT * FROM server2.db.table where id = '1' unfortunatley i get error Error Code : 1064 You have an error in your SQL...
  14. thompom

    merge multidimensional array func

    Hi, Does anyone have a func that merges multidimensional arrays. They have the same amount of columns and I just want to append one to the other. It would be nice to sort them aswell. There is tons of PHP code out there but not much ASP - i wonder why? MG
  15. thompom

    security essentials free for business?

    Hi, Does anyone use SE in a small business environment? If so is it legal to do so? - there seem to be conflicting answers all over the place. YES http://social.answers.microsoft.com/Forums/en-US/msestart/thread/1c9f9d92-2d0e-4fed-9810-2692d47f1c5d NO...
  16. thompom

    100% height menu filler

    hi, have a left side menu and would like a filler at the bottom to fill the space if content is taller than the menu. should be easy but cannot get to work in IE7 - please advise thankyou css { padding: 0; margin: 0; border: 0; } body, html { color: #000000; font-family:Arial...
  17. thompom

    another slow query

    Hi, This a follow on from thread http://www.tek-tips.com/viewthread.cfm?qid=1585242 Have a query that takes >30secs. The response table has 50K records, event 8K and action has 11K SELECT count(response.responseid) AS responsecount, event.userid FROM event INNER JOIN action ON...
  18. thompom

    query shows values once

    Hi, the following query counts the number of response and groups by this figure. it then groups this figure depending on the amount between 1 and 15 (persistancestage.stage is a table with values from 1 to 15) the result should be totals for each user of this figure. the following query...
  19. thompom

    pro 3060 ack syn block

    Hi - my sonicwall pro 3060 had a s/ware upgrade to ver 4.2.1.0 on Friday and now blocks LAN > LAN packets to webserver, below is the message from the log: 1 08/08/2010 17:44:56.688 Debug Network TCP packet received on non-existent/closed connection; TCP packet dropped 10.48.180.136, 80, X0...
  20. thompom

    network issue with web server

    Hi - my users are having probs accessing a web server over an intranet that runs asp pages. The users see "page cannot be displayed" The following works fine over the intranet -other database apps -printers -VNC local webserver users are fine and use IP ADDRESS to access server so not DNS...

Part and Inventory Search

Back
Top