Search results for query: *

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!

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

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

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

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

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