Recent content by thompom

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

sorted - had to remove HOUR func from join then create new column for hour and create index the query now runs in 1 sec

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

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

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

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

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

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

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

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

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

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

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()...

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

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!