Search results for query: *

Hi - I have query that needs to only include items of post added for the previous complete week. i.e. if I was running it today (Tuesday) it should only list items from Monday of last week to Sunday of last week. Same if I ran it tomorrow. I'm really stuck - any ideas?

I have a table with 1,000's of archive records that has the following fields: uniquekey, reference, datewritten, amount I need to run a report that, based on the 'reference' field extracts the earliest record that was inserted for a given 'reference'. I would appreciate any help. Many thanks.

I have created a small CFC that is designed to accept any SQL query and execute against a data source. It works when the query is hardcoded, but I can't seem to pass the variable correctly: CFC: <cfcomponent> <cffunction name="sendSQL" access="remote" output="true" returntype="query">...

When I save data from a webpage to a TEXT field it loses any carriage return line feeds and writes the data as if there where no CR's or blank lines inserted etc. Can anyone please point me in the right direction please? Many thanks

When using graphs in CF under https some users report 'the page is displaying secure and non-secure' popup. When viewing the source we can see the codebase as http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab etc Does anyone know of a way to edit a file under CFUSION to...

I'm having problems grabbing the right record in a set - any help would be gratefully received. example of records could look something like this: DATE AMOUNT 03/31/03 $120.00 03/04/03 $100.00 02/28/03 $125.00 On the search screen the user would put in a date and I only want to grab...

I have a SQL query that runs perfectly under MS SQL Query Analyzer, but will not run in CF. I normally limit CF to simple select, insert, update queries, but this is quite an important component on a project. The labels coming out should be 1 2 3 etc Can anyone tell me why this isn't...

I can't seem to get the following to work on a very simple names and address database with Name, Addr1, Addr2, Addr3, Town, County etc What I want to do is select one single record and show only the fields that are not null and call the text labels 1,2,3,4 etc Therefore: Name Addr1...

Please could someone point me in the right direction. I am pulling data into graphs from a table and use: SELECT (CASE WHEN count (worktype) > 4 THEN worktype END) as 'worktype', (CASE WHEN count (worktype) > 4 THEN count(*) END) as 'cnt' from table1 group by worktype...

I'm passing data from another app into Word 2000 and autorunning a macro. I keep having to put delays in the macro to ensure that the macro does not run before the clipboard has data. Q: Does anyone know a way in VBA to check to see if any data is present in clipboard? That way I can put a...

I know in MSSQL7 you can use NChar/NVarchar to store foreign language characters, but what can you do in 6.5? There does not appear to be support for these datatypes. Any help will be gratefully received. Is there a way? I have thousands of German/French mailing list addresses to store...