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...
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>...
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, and it seems fine. Cant really just roll it out to 100 users and hope for the best though so thought I'd see if anyone was going to sound alarm bells. Either way, i think i might try running it on our system and see what happens!
John
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.