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!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. bowline

    Strange string of characters after signature

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

    Strange string of characters after signature

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

    Cannot serve non-html pages

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

    Cannot get an OCX to load in IE

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

    Receiving error on nested Stored Proc with OUTPUT

    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!
  6. bowline

    Receiving error on nested Stored Proc with OUTPUT

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

    Joins - best practices?

    Excellent - thank you very much for the explanation.
  8. bowline

    Joins - best practices?

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

    Joins - best practices?

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

    ALTER TABLE ADD

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

    Question about Data Truncation

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

    Wrapping of auto-generated URLs

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

    Floating footer

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

    PowerTools Tags

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

    Dynamic Multiple Queries

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

    Dynamic Multiple Queries

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

    Will RequestTimeout flow through to included files?

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

    stored procedure batch ?

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

    Columnar Report?

    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)...
  20. bowline

    Columnar Report?

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

Part and Inventory Search

Back
Top