Recent content by JohnandSwifty

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

cfSearching: Thanks for your comment, on reflection, as with the get Data functions we use, we do something similar for inserts and updates. We realised that it would just be so much easier if we keep the sequenceGroup in the table (so write it when inserting and updating). The benefit of having...

Ok, but how does that help me with a Query Var rather than a query from DB? Im not looking to get a set of results by the sequence group, just return the sequence group against the record - most common use is grouping on recordsets. So the data returned would be: ID REF SEQUENCE...

I dont think I have been clear enough about the use of the query functions. All parts of the application use one function to query each record type from either source (sort of a query builder/ single point of interrogation). So the get function needs the ability to return everything, every time...

For example - We have a getDB component function and a getVAR component function. At the moment regardless of whether we are getting data from a query in a var or from the DB, we can get the same fields, same data in the same format from either. In one of our functions however we create groups...

We use the same page for output, but have either a DB or a QofQ source - so the query needs to return the same results. At the moment we create the query, then break it up to create groupings the re-create the query which is a bit sloppy. It seems that CASE is not supported in QofQ so I was...

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

Found out in the end that its actually a CF bug thats been around for ages - ended up using the original query but had to preserve single quotes on the SQL (seems obvious now, but god knows why it trashes single quotes anyway). Thanks for your help.

The query is run through Coldfusion 8 - it always 'optimises' the query and inturn replaces single quotes with double quotes - you think it is this that is causing the problem?

Here it is... SELECT orderProduct.recordID, orderProduct.sequence, CASE WHEN orderProduct.sequence > 0 AND orderProduct.sequence <= 5 THEN ''1-5'' WHEN orderProduct.sequence > 5 AND orderProduct.sequence <= 10 THEN ''6-10'' WHEN orderProduct.sequence > 10 AND orderProduct.sequence <= 15...

We tried this and as you say there is no error. But removing the statement fixes the query, putting it back in causes the error again. There is nothing else that could be causing it - could it be something to do with there being a field with a value of 1(which is not represented by your test)...

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

Well thats what i said! - thank god, i thought i'd missed something there. I think i may factor in some time for translation on this job. Thanks.

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

Thanks for your input. This is not where i have the problem though. The problem i have is that if i use JS to change the cursor (say in a OnClick event), if the mouse is over an <a> tag, the cursor does not change. This only happens when the cursor is over an <a> tag, but i need to use an <a>...