Search results for query: *

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

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

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

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

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.

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

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

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

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

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

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

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

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

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

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

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

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?

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?

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

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