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!

Search results for query: *

  1. cfSearching

    Problem with cfquery

    Performance is a good case for denormalization. Though, typically you are better off storing the years in rows rather than columns ie yrXXXX. It is easier to optimize, and you do not have to alter the table structure every time the year changes. Just insert a new row, and you can have as many or...
  2. cfSearching

    Problem with cfquery

    Yeah, I saw your mention that it was a simplified version, but ... the fact that you are using LIKE suggested the select queries might return multiple rows. If they only ever return a single row, then it is not an issue. However, if they return more than one row, your UPDATE's would be wrong...
  3. cfSearching

    Problem with cfquery

    Nothing to do with your error, but is the your real UPDATE? Because there could be problems if the SELECT queries ie get_2008, get_2009, .. return multiple records.
  4. cfSearching

    SQL Query Help

    Note, you might need to use SELECT DISTINCT to suppress duplicates. Depending on your tables, another possibility is using an EXISTS clause. I do not know your table structure, but say you have: Client / Columns: ClientID, ClientName, .... (Unique clients) NewsLetter / Columns...
  5. cfSearching

    SQL Query Help

    Then all you need is an IN clause. No loop. Just pass in the list of newsletter id's <cfquery name="getclients" datasource="#db#"> SELECT clientemail FROM VIEW_SendNotification WHERE newsletterid IN ( <cfqueryparam value="#uniqueListOfNewsLetterIDs#" cfsqltype="cf_sql_integer"...
  6. cfSearching

    SQL Query Help

    ...If you mean you only want clients that subscribed to all eight (8) newsletters, use a HAVING clause instead of looping. SELECT clientemail, COUNT(*) AS TotalNewsLetters FROM VIEW_SendNotification WHERE newsletterid IN ( 15395,15399,15400,15404,15408,15409,15425,15423 ) GROUP BY...
  7. cfSearching

    Office 2007 cfheader cfcontent Word docx problem

    No, it opens fine with a real docx file (with the ":" corrected to ";"). Are your downloads true MS Word documents, or psuedo-MS Word documents ie html? ---------------------------------- http://cfsearching.blogspot.com/
  8. cfSearching

    Office 2007 cfheader cfcontent Word docx problem

    Why do you say that? I have never read that extension is optional. ---------------------------------- http://cfsearching.blogspot.com/
  9. cfSearching

    Why do these two strings equal each other?

    Yeah, evaluate() converts those strings to numbers, ie +9 and -9, rather than dates. Cute, huh? ---------------------------------- http://cfsearching.blogspot.com/
  10. cfSearching

    Office 2007 cfheader cfcontent Word docx problem

    Not sure if it is a typo, but it looks like you are missing the file extension .docx . Also, the value separator is a semi-colon, rather than a colon. ie <cfheader name="Content-Disposition" value="attachment; filename=myfile.docx"> OR <cfheader name="Content-Disposition"...
  11. cfSearching

    Why do these two strings equal each other?

    From what I can tell, the strings are being converted to dates. Both are interpreted as September 18 2013, which is why the comparison resolves to true. If you want to ensure a string comparison, use compare() or compareNoCase() instead. ----------------------------------...
  12. cfSearching

    Grouping Table Problem

    Not quite sure I understand the problem either. However, why not just use a CASE to establish the header/subheader groups, like I mentioned in your other thread? Then sort by those values and use a nested cfoutput group. Assuming "comm_cd" is the subheader value: <cfquery name="yourQuery"...
  13. cfSearching

    List Function Confusion

    It is not clear why you need to use list functions. Typically if you wanted to group several values under one heading, you would use a CASE statement within your original database query. ie SELECT vendor , loc_code , CASE WHEN loc_code IN ('LO','AU','S')...
  14. cfSearching

    Summing Dynamic Variables

    There is rarely a reason to need evaluate(). When you declare a variable without a scope, it is placed in the VARIABLES scope. Most CF scopes are structures. You can access the keys dynamically with associative array notation ie structName["keyName"]. Instead of evaluate(), just use the...
  15. cfSearching

    Equivalent to SQL IN operator in CF

    The closest equivalent would be listFind/listFindNoCase: <!--- note, no pound signs ie # needed ---> <cfif listFindNoCase("LO,AU,SL", variables.location)> ---------------------------------- http://cfsearching.blogspot.com/
  16. cfSearching

    Rendering Recordset in HTML Using Cfdocument

    One way is to use cfoutput's "group" feature. First order your query results by the "group X" column: SELECT Col FROM Table ORDER BY TheGroup1ColumnName, ... Then add the "group" attribute to your output: <cfoutput query="yourQuery" group="TheGroup1ColumnName"> #TheGroup1ColumnName# <br...
  17. cfSearching

    cfscript and javascript

    Typically, a rich text editor's value is accessed differently. I do not know what version you are using, but this might help: http://cksource.com/forums/viewtopic.php?f=6&t=10135&p=26722 ---------------------------------- http://cfsearching.blogspot.com/
  18. cfSearching

    Import Excel to SQLServer - last posted in 2006

    Sorry, that should have read "you may want to investigate other options". ---------------------------------- http://cfsearching.blogspot.com/
  19. cfSearching

    Import Excel to SQLServer - last posted in 2006

    Sorry, that should have read "you may want to investigate other options". ---------------------------------- http://cfsearching.blogspot.com/
  20. cfSearching

    Import Excel to SQLServer - last posted in 2006

    ...familiar with DTS, but I believe is deprecated anyway. So you want to investigate other options. For example, using OPENROWSET or OPENQUERY. **Note, I am not sure if you need different/additional drivers to read Excel 2010 files. http://msdn.microsoft.com/en-us/library/ms190312.aspx...

Part and Inventory Search

Back
Top