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

    array delete help

    Hi GUJUm0deL, It's because you are doing a cfloop, with the FROM criteria being the Length of the Array.... it's successfully deleting the array where you want it to, but then erroring when it tries to keep looping around. If you try hardcoding it in without the loop, you'll find it works...
  2. junkjones

    Replace a string with a pound sign in it

    Hi everyone, I am pulling some HTML from a site and using the Replace() function to format it. However, anything with a hex value in it confuses CF. Here is what I want to do: <CFSET MyChart = #Replace(Mychart, '<TD bgcolor=#FFFFFF>', '<TD bgcolor=#000000>', 'ALL')#> However, the replace...
  3. junkjones

    Dates From Last Week?

    I have a query where I need to find out information from the past week. It looks something like this: lastmonday = &quot;08-04-2003&quot; lastsunday = &quot;08-10-2003&quot; SQL = &quot;select * from table where (dateran BETWEEN lastmonday and lastsunday)&quot; This part works, but I'm...
  4. junkjones

    select a predefined value - is this possible?

    sure! select MAX(o.order_ID) as order_ID, n.nom_ref as nom_ref, MIN(n.eff_date) as eff_date, MAX(n.end_date) as end_date, SUM(e.energy) as energy, SUM(e.energy) as total, '#DateFormat(CountDate, &quot;YYYY-MM-DD&quot;)#' as dateis from [ORDER_] as o, nomination as n, nom_estimate as e where...
  5. junkjones

    select a predefined value - is this possible?

    The records currently contain date ranges. I want to pull out a record for each date. I've got it doing this, but I want to group by the dates (there are multiple records for each date that need to be SUM()ed. It says I cannot group by the date variable because it is an invalid column name.
  6. junkjones

    select a predefined value - is this possible?

    Sorry - I should have posted the error I'm getting: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'variable'. Thanks!
  7. junkjones

    select a predefined value - is this possible?

    thanks! that worked.... it is a date field. Is there a way I can use it now in the group by statement? It doesn't seem to like that either...
  8. junkjones

    select a predefined value - is this possible?

    What is the proper way to do this? select column1, column2, &quot;2003/3/11&quot; as variable from table The 'variable' is a predefined value that i would like to include in the return of my query. It seems to work when I run it in access, but through my web server (coldfusion) it doesn't...
  9. junkjones

    postgres and MS SQL

    I have 2 MS SQL datasources connected in the ColdFusion Administrator, no problem. Today, I went to go add a new Postgres datasource. I had to use 'other' as the type, and I had to install the postgres .jar file onto the server, and point to it (/opt/coldfusionmx/lib/) on the Java and JVM page...
  10. junkjones

    Space in table name

    BINGO! That's exactly what I was doing wrong - thanks!!!
  11. junkjones

    Space in table name

    I need to query a table that has a space name in it. (I know I know - it wasn't me that named it). I've tried these three versions: select * from [Price Index] select * from &quot;Price Index&quot; select * from 'Price Index' And I always get the error: Invalid object name 'Price Index'...
  12. junkjones

    excel and apache

    Thanks for the code... I've been trying variants of this all morning, but yours is the most clear. It still doesn't work, but based on what you said about Netscape, I decided to download it and test it on Netscape. And voila! It works! Which tells me something is wrong with my IE browser...
  13. junkjones

    excel and apache

    The answer is a).... I just want them to be able to view the data as an excel sheet. The custom tag(s) I normally use on NT are not working here - the page is just displaying as an HTML table instead of an xls form. So could this be a problem on my computer instead of the server?? I do have...
  14. junkjones

    excel and apache

    Sorry - an update... the server is a Linux server, so it's running OpenOffice, not MS Office.
  15. junkjones

    excel and apache

    Dumb question: do I have to have MS Office installed on the Apache server? Does it need Excel to create the file, or does the user just need excel to open the file? I'm sure my NT box (that it works fine on) doesn't have excel installed on it, but that could be because NT knows what excel is...
  16. junkjones

    excel and apache

    No error - it's just outputting it as a regular page with a regular table for my information.
  17. junkjones

    excel and apache

    I am trying to turn a query into an excel sheet. I've done this a zillion times on an NT server, but today I'm doing it on an apache server for the first time. Is that why it's not working? Is there something I have to do on the server to make it work?
  18. junkjones

    pass query to new page?

    I'm having a brain freeze here.... I think I once ran a query, moved it into a structure, and then passed the whole structure in the URL query string to a new page. Is this possible? I can't seem to do it today... Can I save an entire structure as a session variable?
  19. junkjones

    Calculated Fields Question

    I have a query that is driving me bananas! The table (which was designed poorly) has multiple records for transactions, with different months in each record: DATE TRANSACTION VOLUME ----------------------------- March 1 62 April 1 23 May 1...
  20. junkjones

    invalid character in column name

    I have an MS SQL database with a column called 'Long/Short'. When I try to pull up the column: select temp_ID, MAX(Long/Short) as longshort from table group by temp_ID I get an error (of course) of &quot;Invalid column name 'long'.&quot; So my question is, is there another way to pull up...

Part and Inventory Search

Back
Top