Recent content by gareth7

Thanks for the reply. I'm actually looking for something a bit more detailed cfcatch.nativeErrorCode is the variable I want to test, but I don't know how I set this with the RAISERROR statement in the stored procedure

I have a table with a large text field which I use verity to index. This is fine to search on it's own, but the table also contains other columns that I'd like to filter by where this is usually done with a database query. How can I combine them both? Are there best practices? The table would...

I'm using stored procedures in mssql server to do my database updates. The stored procedures run various checks and use the RAISERROR statement if something fails I want CF to be able to tell which error was thrown by the database, so it can act accordingly. Does anyone know how this would be...

Thanks for getting back to me. I'm moving on to CF7 soon and I hear that Verity has been given a major overhaul. Hopefully this will be one of the new features

I've got a similar problem with a large transaction log - but my database is just a test development server. There's no point backing this up as the data is of no use. I just want to reclaim disk space. I tried deleting the log file in enterprise manager, but it said I couldn't delete the...

I tried adding spaces and get the following error message: A [Transformer] object cannot be created that satisfies the configuration requested. This could be due to a failure in compiling the [XSL] text. javax.xml.transform.TransformerConfigurationException...

I've a problem with trying to output special characters with cold fusion and xsl. All the xsl forums I've seen say to use the following code to output the "<" character: <xsl:text disable-output-escaping="yes">&lt;</xsl:text> But cold fusion is giving me the following...

I'm doing an online booking system for B&B accomdation. Originally they just had a start date and end date for which days of the year they are open. They now want to incorporate extra dates they may be open or closed - i.e. multiple open and close dates. Could someone give me ideas on how to...

I am indexing a database query and would like to adjust the score given for certain fields. Does anyone know if this is possible? An example would be indexing the columns report_title and report_contents. I would like words found in report_title to score higher than words found in the...

I ended up using the <cfschedule> tag to write a short script. Hope this helps

I'm a bit stuck. A cfx tag I bought required the JDK to be updated to 1.4. I installed this from sun and changed the Java Virtual machine path in CF administrator. Unfortunately, I think I put the path in wrong as the CF server won't restart. I can't change it because the CF administrator...

I'm building an intranet reporting tool that creates reports and saves them as word documents. It does this by pasting chunks of html into an empty word document. The problem is that the html loses it's formatting in word as there is no longer a stylesheet to reference. Is there any way of...

I'm trying to set up scheduled tasks using the cold fusion administrator, but I keep get the message: &quot;You need to enter a valid Start Date in order to proceed.&quot; I've tried all date formats but it's not accepting any of them. It won't even accept the default value it gives itself...

Thanks for the suggestions. I'm not quite sure how the pop-up/frames method is meant to work. Do you mean to send the form submission to a new frame/window while the original frame is redirected to a separate page? Is there some way to hide the new frame so that the user doesn't think things...

I am building an application where the user submits a form. The next page will make several lengthy database calls and run scripts using cfexecute. As there can be a large amount of work for these scripts to complete, I would prefer if the user is immediately redirected to another page while...