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 TouchToneTommy 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. 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

    sorted - had to remove HOUR func from join then create new column for hour and create index the query now runs in 1 sec
  3. 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...
  4. 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
  5. 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...
  6. thompom

    speed up query

    Hi Rudy, thanks for your reply unfortunately not much change As a test, I changed the CASE to WHERE and the runtime is 1 sec LEFT JOIN (SELECT COUNT(1) AS appt, response.actionid FROM response WHERE UCASE(response.reasonid) LIKE...
  7. 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...
  8. thompom

    cant SELECT after large import

    Hi - many apologies, was an issue with datetime format from excel - even though it didnt error on import and looked fine. This also stopped new records added by web app from showing on SELECT Thankyou for all ideas - made me look at CSV again
  9. thompom

    cant SELECT after large import

    Hi - thanks for your replies Towerbase - the import is successful (SQLyog Ultimate) SQLyog Job Agent Version 9.20 Copyright(c) Webyog Softworks Pvt. Ltd. All Rights Reserved. Job started at Tue Oct 02 20:16:22 2012 DBMS Information: TEXT Importing table schema: action... Successful...
  10. thompom

    cant SELECT after large import

    Hi - thanks for your reply Why are you confident that the 20K records were successfully imported into the MySQL DB? SQLyog reported no errors How were they imported? Using the "import external data" tool of SQlyog from a csv file. Note - the import included "actionid" which is an auto inc...
  11. 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
  12. thompom

    uploadify 3 pass formdata issue

    Hi - found issue - was because the settings line was using class instead of id your post got me thinking - thankyou!!! (wasted hours on this)
  13. thompom

    uploadify 3 pass formdata issue

    hi - thanks for reply - tried following but using this causes script to fail $('.file_upload').uploadify({ 'swf' : 'uploadify3/uploadify.swf', 'uploader' : 'uploadify3/upload.asp', 'onUploadStart' : function(file) { var x_key = $('#x_curractionid').val()...
  14. 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' ...
  15. thompom

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

    Hi - fixed, didnt include public int inside compositetype as a 10 year asp user - this aint half weird not knowing whats wrong wish me luck!
  16. 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...
  17. 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...
  18. thompom

    do i need an SMTP server

    Hi, You can use the form tag to email somebody from html This is a very simple method but may get you started (also you should post in html forum for more help) html <FORM METHOD=POST ACTION="mailto:someone@$nailmail.com" ENCTYPE="text/plain"> <INPUT TYPE="text" NAME="username"> : name <BR>...
  19. 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...
  20. thompom

    jquery set .html with array data

    hi - thanks for reply, is something todo with content in update[0] as if i replace content with simple text it works. used to work ok with javascript innerhtml. This is an intranet app with customer data so is not going to be easy to post a live version. Will have a play with output to find...

Part and Inventory Search

Back
Top