Search results for query: *

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

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

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

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

I try to prevent the end-users from seeing and taking my CFML code. How can I encrypt my files? I have checked the &quot;Encrypt CFML&quot; box at Settings/Projects/Deployment. But there's nothing happened to me. Can anyone here help me?

I am using CFX_DynamicImage to create and edit graphics on my website on the fly. One of the great things about it is the ability to type text on the graphic. It uses the CFREGISTRY tag to pull the list of fonts that are on the server. I recently needed to use a new font that is not on the...

Hi Everyone, Is there a way to combine two fields in a query? I have a DATE field, and a TIME field. But in my SQL statement I want to say select * from table where DATE+TIME BETWEEN 'date+time' AND 'date+time' can this be done? I know in other DB's you can just say TIMESTAMP(date, time)...

I have a chart that has values on the x and y axis ... I'm trying to make a line chart. Does anyone know how this would be done? I can post the co-ordinates, but do not know where to go from there. Thanks...

Is there a way to check to see if a function is defined? Sort of like checking to see if a variable is defined? Long story on why I need this, but let's just say that sometimes the function will be there, sometimes it won't. (The call to the function is in a frame that refreshes all the...

Hi all, I am doing some work with videos right now, and I'm having trouble converting the seconds into a time format. For instance: the duration of the video returns a value of 1218.599 (seconds), but I want it to display it as 20:18. Is there a way to do this with javascript? If I just...

I am trying to pull the number of slides from a powerpoint presentation using CFSCRIPT and some code I found on the MSDN website, however I'm getting this error: <CFSCRIPT> objPresentation = objPresentations.Open(&quot;filename&quot;, False, False, False); BDP =...

Hi everyone, I am a beginner at javascript, and I'm having some troubles with a script I'm trying to use. I downloaded a countdown script which works great... however, it's using the user's time on their computer to reference the countdown, but I need everyone's countdown to be the same, even...

Hi Everyone! Please forgive my ignorance - I am a ColdFusion programmer who does not know much about databases and is trying to incorporate MySQL into my programming with not much luck. I have a field in my db that is a list of numbers. (&quot;1,13,9,47&quot; etc.) What I want to do is...

Hi Everyone, I purchased an application which was written for Access, but I am running it on MySQL. I have converted most of the queries, simply by changing the case of variables, but there is one that is a little more complicated than that that is still causing me problems. It works fine...

Hi Everyone, I'm moving a rather large application from Access to MySQL right now, and I'm having nothing but problems with errors now! Here is the first problem I'm having: <cfupdate Datasource=&quot;#session.ds#&quot; tablename=&quot;ForumVariables&quot...