Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
raising custom error's with mssql 2k
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 -
combined verity and database search
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... -
raising custom error's with mssql 2k
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... -
verity - can you adjust weighting??
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 -
How to purge large .log files ?
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...- gareth7
- Post #6
- Forum: Microsoft SQL Server: Setup and Administration
-
xslt problem
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... -
xslt problem
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"><</xsl:text> But cold fusion is giving me the following... -
Booking System - Database Design
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...- gareth7
- Thread
- Replies: 2
- Forum: -General database discussion
-
verity - can you adjust weighting??
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... -
administrator won't add scheduled tasks
I ended up using the <cfschedule> tag to write a short script. Hope this helps -
Can't start CF Admin
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... -
html style sheet in word
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...- gareth7
- Thread
- Replies: 0
- Forum: Microsoft: Office
-
administrator won't add scheduled tasks
I'm trying to set up scheduled tasks using the cold fusion administrator, but I keep get the message: "You need to enter a valid Start Date in order to proceed." 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... -
run a subpage in it's own thread
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... -
run a subpage in it's own thread
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... -
server busy error when trying to define new site
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... -
<div> nested in <table> doesn't work
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...- gareth7
- Thread
- Replies: 3
- Forum: HTML, XHTML & CSS
-
pass table variable to stored procedure
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 -
cffile to a different server
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... -
exporting SQL 2000 to SQL7
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...- gareth7
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Data Transformation Services
