Recent content by SimonA

Try this: SELECT a.Col1, a.Col2 FROM a WHERE a.Col1 NOT IN ( SELECT Col1 FROM b)

What error are you getting? What database are you using? Help us out here!

Try #replace(QueryName.Description,&quot;#chr(10)#&quot;,&quot;<br>&quot;,&quot;all&quot;)# SimonA

Remember that the destination directory (c:\tmp\IFMS-HelpDesk\) is on the server, not your machine - unless of course you're running the ColdFusion server off your machine.

Just a question here (from a newbie ASP'er) - where does ActiveX come from? Is it a component of ASP, IIS or just a seperate MS application? And what does ActiveX have to do with opening up a Database connection through ASP? Many thanks.

OK, I'm getting this error now. Code is as follows: ---------------------------------- Dim objConn, oPackage set objConn = Server.CreateObject(&quot;ADODB.Connection&quot;) objConn.ConnectionString = &quot;Driver=SQL Server; Server=xxx;Database=xxx;UID=xxx;Password=xxx&quot...

Query -> Current Connection Options Select the 'Advanced' tab Un-tick 'Print Headers' Simon.

I use CFSTOREDPROC to call my Oracle procedures. I've never tried it with functions though... <CFSTOREDPROC procedure=&quot;proc_name&quot; datasource=#DataSource# dbtype=&quot;ODBC&quot; username=#ODBC_Username# password=#ODBC_Password#> <CFPROCPARAM type=&quot;IN&quot; dbvarname=val...

Fantastic ! Thanks Tempoman and Calbearroo for your responses. I've seen a lot of responses on this forum with people saying you can't do a cfoutput within cfouput. This is a great solution, and completely solved my problems ! Thanks again guys.

What database are you using ? If Oracle, you can do something like: SELECT message FROM message_table WHERE addition_date >= (SYSDATE - 7); Simon.