Search results for query: *

Thanks for the quick reply, I was testing your suggestions out and while outlook was starting the email - I noticed the "starting word as your email editor" message, so I checked the normal.dot - sure enough, that string was in there... Go figure - I recreated it and am not having the problems...

Hi all - I am running Outlook 2003 sp1 on XP Pro, and tonight something really strange started happening. If I start up a new email, this string is showing up after my signature: axcvzxvzxcvzxvc If I reply to an existing email, it shows up right before the text of the old email (below the...

I am running WinXP Pro sp2 with IIS 5.1 and ColdFusionMX. It is a development environment (obviously) and I am trying to set up some file downloads of PDF's and Word Docs...security is wide open on the entire site. When I try to download either type of file, I get errors. If it is a PDF, I...

I am dealing with a 3rd party app that allows you to create new "modules" within it. The application will start up an instance of IE within itself, and you can build different pages to do your bidding. To keep the look and feel of the app, I ended up going with a user control. It works like a...

Thanks guys. John, I actually did have things set up correctly with the params. Sorry, guess I should have said something about being able to run ProcB by itself without a problem... SQLSister - that did the trick. I did not realize that you could set defaults for output params. Muchas gracias!

I am trying to create a stored procedure (sp_ProcA) that calls another stored procedure (sp_ProcB). sp_ProcB has several input params as well as one output parameter. For this purpose, I don't need that return variable, so I have just created a container variable within sp_ProcA to hold that...

Excellent - thank you very much for the explanation.

Thanks - he suggests using the base table for the joins. And he mentions that you can put the "where clause" into the "on" part of the join - but not really why on either one. I was not sure if anyone could point me into the direction of those "why's". He did confirm that I was doing it the...

I have two quick questions on the best practices with joins. First question - When joining multiple tables for a query (all with one field in common): 1. Do you join all of the tables through one central table? I usually follow this route, using the one that will result in the biggest set of...

Well, Enterprise Manager is not really inserting that column for you - it is recreating the table. When you save your changes, it will: - Create a tmp_XXX table with your new table structure - Copy any data from the existing table over to the tmp_XXX table - Drop the existing table - Rename the...

Their suggestions to use substring are definitely ideal, but if you just want a quick fix, run this before your script: set ansi_warnings off Then this afterwards: set ansi_warnings on These warnings include a lot more than just data truncation, so you would want to check them out in the BOL...

I am in the same boat and have never found a solution. The only thing that works for me is to add spaces after the slashes in the URL to break it up. So Alinna, you would build two strings, one for the href and one to display...

If you are using tables, just set the height of the main table to 100%. In the td tag for your footer, set valign="bottom". You will probably need to set the other valign's to "top" to account for the pages that don't fill up the entire page. If you want to go the CSS route...

I have not used those tags before, but it sounds like you are asking for something similar to this thread (just replied to it)... Dynamic Multiple Queries http://www.tek-tips.com/viewthread.cfm?SQID=837738&SPID=232&page=1

Ah - for that, just use "evaluate". I am doing something similar on one of my sites. Here is how it works: 1. Setup the name of the variable that you are going to want to evaluate <cfset variables.ResultTextId = "form.q#i#WriteInText"> 2. Then evaluate it to get the value contained in that...

What about doing the loop, but using the loop to build the SQL script, then executing the script once the loop has completed? Just a thought...seems like you are handling it the right way, just need to narrow it down to one script first.

We have a client with a hosted ColdFusion site and they are receiving a number of Timeout errors on a certain process. This site is a product made by another company, but I have the ability to change the pages as long as I ask them first. The error they are receiving is: Request timed out The...

You can use DTS for this without too much work. The interface is graphical and pretty easy to understand... - Connect to your SQL Server through Enterprise Manager, you will see a folder for "Data Transformation Services" (DTS). Go to "Local Packages" under here. - Create a new DTS package...

One more thing, I needed to ignore the first field in the array every time - hence stepping over that first record in the loop (for i:= 2)...

Well, I could not get your formula to work - not sure what I was doing wrong...and the cross tab would not work either - it would not wrap around the page and the fields would not grow. But I came up with a pretty good solution. Thought I would share: - Create a @ResetAll formula. This one...