Search results for query: *

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

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

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

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

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

I have come across this piece of code: try { // Moz supports XMLHttpRequest. IE uses ActiveX. // browser detction is bad. object detection works for any browser xmlhttp = window.XMLHttpRequest?new XMLHttpRequest(): new ActiveXObject("Microsoft.XMLHTTP"); } catch (e) {...

I was wondering if anyone could help. I am getting into using AJAX techniques with my asp pages and I need to check what version of ASP I am using to see if this will cause me any problems. Its defenately not ASP.net. Also if there are anyone who has any AJAX experience I am having problems...

Sorry for anoter SQL query post I though that I was getting the hang of this: SELECT tblData.*, tblTitle.*, tblCategoryList.* FROM ((tblData LEFT JOIN (SELECT * FROM tblTitle IN 'E:\Websites\ebusinessdirectories\Database\Admin.mdb') AS tblTitle ON tblData.fldContactTitle = tblTitle.fldTitleID)...

Could someone please tell me why this query is returning all of my records? SELECT tblData.*, tblTitle.*, tblCustomCategory.* FROM (((((tblData LEFT JOIN (SELECT * FROM tblTitle IN 'E:\Websites\ebusinessdirectories\Database\Admin.mdb') AS tblTitle ON tblData.fldContactTitle =...

I have to create a function to put escape characters in to make an SQL query to work for example Sean[0] has to be preseted Sean[[]0[]] to work. I am having problems getting my string convert funtion to work with Replace does anyone have any ideas on how to do this. I just cant seam to get my...

I am using this SQL statement on my ASP VB pages linking to an access database Jet 4.0. The query works fine until I put a OR statement on the where clause. I am sure its a bracketing problem but cant for the life of me sort it out. I have tried recreating the query in access and looking at...

Hello I was wondering if someone could help me why this SQL Statement is giving me a syntax error? I have one that is simualr that works fine. The only difference I can see between the on that works is that I am not using the SELECT * statement could this make a difference? Thanks SQL--...

Hi All Could someone please shed some light in why I am getting the error below? I am tryinig to set up a include file that connects to a database when a pathname is passed to it. The code worked before I put it into a sub. It does not seam to like the passed path as I had to a s Cstr function...

I am training myself to use css in my web pages and everytime I think that I am getting an understanding of it something does not work as expected. Could someone please tell me why there is a gap between the header and the Navigation Divs? My knowledge of css tells me that there should not. I...

Could someone please tell me what is causing this page to mafunction? On a mac in safari the content seams to jump out of the enclosing div and on a PC it seams to ignore the with constraints. Sorry about the length of the post but I am complete loss of what may be casing this. I have included...

Hello I was wondering if some css guru would be able to offer me an explanation. I have two divs one nested inside the other. The width to both divs are set to 100%. But when I put padding on the internal one it becomes longer that the enclosing div and comes out of the right side. Why is...

Please could someone help. I am completely stuck I have some javascript code that runs great on a PC but when I test it on a Mac it does not work. The code automatically generates dropdown boxes depending on the amount of categories and creates a parent child relationship. Multiple categories...