Search results for query: *

We have a CRM app that we have ported to AJAX and everything is great. The only issue is that loading email content (unpredictable external email from 'x' different clients) contains header CSS styles which [in FF and Chrome] override styles in the app. We have two options at the moment which...

Hi, I need to replicate the CASE statement below in a QofQ. Any ideas? CASE WHEN quotationProduct.sequence > 0 AND quotationProduct.sequence <= 5 THEN '1-5' WHEN quotationProduct.sequence > 5 AND quotationProduct.sequence <= 10 THEN '6-10' WHEN quotationProduct.sequence >...

Hi, I'm returning the error Incorrect syntax near '1' when I run a query with the following case statement. It is possible that the orderProduct.sequence does have a value of 1, but I can't see why this would cause an issue... Any ideas would be great. CASE WHEN orderProduct.sequence...

Hi, I haven't used active directory as a file store before. I have a new client that does and i cant seem to find an article breaking down how it actually stores the files. I understand that there is a main DB but is this storing links to files, or are the files themselves stored in this DB...

Hi, I use <a href etc in column headers to get a reliable hover effect. The only thing is, in my ajax app when you click a column the JS function changes the cursor to 'wait'. This works fine until the mouse is over an <a> tag (at which point it sticks at whatever cursor is set for a tags in...

Hi I have a few ajax apps that are modular (so 5 tabs at top for dif areas of the app). On the last project the client requested that each module remembered where it was when you navigated away and then beack to it. Because it was all ajax i used extensive JS vars to remeber all sorts from page...

Hi, I would like to configure an export routine that will work regardless of fieldname changes in the DB table etc. So i want to query DB with a SELECT * (because i dont know what the fields are, and i want them all). I then want to loop through and output the resulting query (not using...

Hi, I run coldfusion locally for testing. I have a site that works fine on some webspace i have, but when i try and run any files from the site locally, the flash charts dont show. The rest of the app works as usual. Any ideas? Thanks

Hi, I have recently installed coldfusion locally on my computer, i then inserted the SQL server 2005 cd only to find that an app on my computer had already installed and was using SQL server 2005. So i installed the management console alone and logged (NTLM). When i try to creat a DB of a new...

Hi, I have a query that checks the relevant fields for a match of each word in a search phrase. The problem is i need to check to see if the whole phrase matches as well. So what i want is WHERE field01 LIKE #SearchPhrase# OR ( field01 LIKE #SearchPhrase[1]# AND field01 LIKE...

Hi, Could someone put me on the right track when i comes to judging the relevance of records returned in a search (of an SQL DB). I have a search where I split the typed phrase into words and then match the words to records accross several tables. I need to be able to sort those results by...

Hi, I have a list - ,100004,100009,100010 - which i need to use in a query - AND Code IN (<cfqueryparam cfsqltype="cf_sql_numeric" list="yes" separator="," value="#ListQualify(URL.clipboardStr,"'",",")#">) but i keep getting the above error ( Invalid data '100004' for CFSQLTYPE...

Hi, I have read just about every post and article regarding this but for some reason im just not getting it right! arg Can someone help me with the below: I have an objects that store application settings across the modules in my application - for example -...

Hi, I have an application that runs almost everything at the company i work at (accounts, sales, factory process etc). I have a specific issue that its performance degrades over time without any visible changes in taskmgr or perfmon. A month or so ago i swapped the application from our...

Hi, I need to run 3 ajax functions inside one function (see below) - the problem being i cant work out how to make the functions wait for the one before it to finish (see a sample ajax function below) - any ideas? function getModulePage(queryString,method) { var navQueryStr = queryString +...

This is a SQL query really but im sure someone here will know... I have a result set for customers details, there are two fields that relate to groups that the customer belongs to. These fields are codes that i then look up in the groups table to find the group name. Can anyone tell me if/ how...

HELP!- I need my app to fit the window in the same way outlook's online access does (but with divs not frames). I built the whole thing using position absolute which works great in IE7, firefox etc, but not IE6 (and possibly others). Can anyone tell me whats wrong with below?... <!DOCTYPE...

Hi, I want to have a page that displays options in a 'scrollable area' with a fixed block (approx 40px high) at the bottom for ok, proceed cancel etc buttons. Best example of this is the 'Window colour and appearance' area in the control panel of Vista. Any thoughts would be great. Thanks. John

Hi I have a table that uses the elipsis css function in its cells (in divs). Because of this i obviously need to set the table-layout to fixed, whenever i do this, the :hover style for the rows no longer applies the background colour change... anything obvious?... it still works in firefox...

Hi, I have a system that regularly requires that i write extentions for it (be it extra functions or entire new modules). I'm planning to use cfc's for common functions like creating a list of tabs etc. I dont have access to UDF's, is there still a better way than using cfc's? Thanks