Search results for query: *

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

Each time I try to define a new site in dreamweaver, I get the message: Server Busy This action cannot be completed because the other program is busy. Choose 'Switch To' to activate the busy program and correct the problem. I'm not running any other program and I've tried rebooting with no...

I'm using javascript and css to write a function that displays hidden html. The function works for most situations, but in the following code, the div tag doesn't pass on the style i.e. the code inside it remains visible. <table> <tr> <td>text always visible</td> </tr> <div...

I'm using SQL server 2000 connected to CFMX 6.1. SQL 2000 can use table variables, so I wondered if it is possible for cold fusion to pass or receive a table variable with a stored procedure. If anyone knows if this is possible (and how to do it), please let me know. Thanks

My clients have an odd request. They are running CF4.5 on one machine which acts as the web-server for a site. They want users to be able to upload files, but instead of storing them on the same machine, they are to be stored on a different machine on the network. I've tried setting the cffile...

What would be the easiest way to export a sql 2000 database to run on a SQL 7 server? I run sql 2000 myself, but my client only has an sql 7 machine that they want to run a database off. The other problem is that I won't have access to their server over a network connection, so need to find...