Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by JohnandSwifty

  1. JohnandSwifty

    Header CSS in AJAX content

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

    QofQ CASE Statement

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

    QofQ CASE Statement

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

    QofQ CASE Statement

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

    QofQ CASE Statement

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

    QofQ CASE Statement

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

    QofQ CASE Statement

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

    Incorrect syntax near 1 !!

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

    Incorrect syntax near 1 !!

    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?
  10. JohnandSwifty

    Incorrect syntax near 1 !!

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

    Incorrect syntax near 1 !!

    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)...
  12. JohnandSwifty

    Incorrect syntax near 1 !!

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

    Active directory

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

    Active directory

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

    JS/ CSS cursor change for &lt;a&gt;

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

Part and Inventory Search

Back
Top