Recent content by seanybravo

I am opening a recoreset with this join query: strSQL = "SELECT tblData.*, tblTitle.*, tblCustomCategory.* FROM ((((( tblData LEFT JOIN (SELECT * FROM tblTitle IN '" & adminPath & "') AS tblTitle ON tblData.fldContactTitle = tblTitle.fldTitleID) LEFT JOIN (SELECT * FROM tblCategoryList IN '" &...

I have a website that uses a pick list to select what categories you wish to include a database. The problem that I have come accross is that if the user selects too many categories the SQL query becomes too complex. I know that I will have to rethink my query but have no idea on how I can...

I am trying to send some category information using a querystring unfortunateley some categories have a & in. I have managed to sort the spaces our but I am still having trouble with the andpersand. strSend.replace(/ /g, "+") strSend.replace(/&/gi, "%26") Can anyone please explain why this...

Ok I am nearly at a solution I am trying just to extract the From aspect of the employee information and then using that as my sort key, however I am having problems with getting just the first part out. Here is my code: function sortEmployee(list){ var listLength = list.options.length var...

Thanks

Why cant I assign my list text to the strCat Varable? I keep getting "frm.elements.SelectedCategories.options[i] has no properties" error function customTotals(){ //alert("Custom Totals HE HE") frm = document.forms['CustomerDetails'] var numberCat =...

I have Employee banding in a Select list that is part of a pick list i.e. 1-10, 11-25 etc. But I am having a nightmare on sorting it. I initially load the select list in order but when things are moved about in the select list the order gets changed. Here is the code I have been working on. I...

Thanks for your help. My lists work fine. I am just having problems with If statement syntax when I check what form list is passed. The onclick is being called from a button as i am creatin a pick list. Thanks Sean

I want to check what form element (listboxes) is being passed to this function and I have a list of numbers that have to be dealt with differently in a sort, but I am having trouble with the If statement because I seam to be passing an object. I think that it is because I am using the this...

Great now works like a charm. Is there any reference for urlencoding I have been looking at this problems for most of the day. Many thansk for your help. Sean

Thank you for your feedback, however I still have had no joy. Here is an example of my code. function GetXmlHttpObject(url, handler, id, strSend) { var objXmlHttp=null alert(strSend) try {objXmlHttp = new XMLHttpRequest(); } catch(e){ try{objXmlHttp = new...

XMLhttpObject.send I have been working on using this object to create AJAX style webpages what I have found is that when I send commands using POST all of the spaces get removed. Has anyone come across this problem before and got a work around? I have tried to replace the spaces with...

Solved it It was to do with the call from the in click event using " insted of '

Thanks for you reply. The problem seams to be with the GetXmlHttpObject function. I have checked the {} and still cant solve the error. Any other suggestions would be great.

Could someone please help me find the syntax error in this cod I have been looking tat it for the last 4 hours and am unable to work it out: var xmlHttp function stateChanged2(obj,id){ document.getElementById(id).innerHTML=obj.responseText } function GetXmlHttpObject(URL, handler, id...