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 strongm 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: *

  • Users: mickeyj2
  • Content: Threads
  • Order by date
  1. mickeyj2

    Strip Quotes from Flat File in SSIS

    Hi, Ok, here’s my situation. I have a CSV flat file. When you look at it in a text editor, the format is like: "Contact Name","Customer","Adr1","Adr2","Adr3","City","State","Zip","Ctry","Phone","Slsm","Email" In other words, quotes surround all of my data. In SSIS, I have built a package...
  2. mickeyj2

    BULK INSERT Intro

    Hi All, Can someone clue me in on BULK INSERT? I've used it to create a table of one column, and everything worked fine, but now I have a TXT file of about 11 fields. I've tried importing the data by using this as a comma-delimited CSV file, and I've tried the import by using it as a...
  3. mickeyj2

    Flash Movie Won't Load

    Hi, Ok. I'm very, very new to Flash, though I've been developing for years. But I need to get a movie up and loaded on my website. I created a slideshow in Powerpoint, and then converted it to a .SWF file, which I loaded onto my site. Now in my Coldfusion file, I say the following: <EMBED...
  4. mickeyj2

    Resolving My Search Results

    Hi, I'm creating a search application. I have a file my srchform.cfm and it works fine. It returns results in the template srchresults.cfm. Here's some of the contents of my srchresults.cfm file: <CFSEARCH NAME="search_card" COLLECTION="card"...
  5. mickeyj2

    Viewing Plain Text Emails

    Hi, I'm in the process of creating some automated emails. I want to do it in HTML. In my company, the majority of my colleagues can accept an HTML format, but there's a handful that accept Plain Text only. I want to see how my HTML email will look in Plain Text. I tried using telnet to view...
  6. mickeyj2

    FTP Upload Question - Spending Way Too Much Time

    Hi, Its been a while since I've done straight FTP batch. I'm VERY embarassed to have to ask this question. I'm writing a batch file. The first part of the batch pulls some files down to my local machine. That part works great. Now, I'm trying to add (to the latter half of my batch...
  7. mickeyj2

    Can you popup an image by mousing over an image?

    Hi, I'm not sure if there's an easy way to do this, but here's what I want. I have a standard image defined as: <img name = 'ProductImage1' src='\images\image1.jpg'> Can I have a mouseover or CSS that allows me to "inform" the user about something? Like a tooltip. I know that I can use the...
  8. mickeyj2

    How Do I Connect to Remote Machine with SQL Server on it?

    Hi, I have SQL Server 2005 installed on my local machine. I already have a server instance (local) setup. However, my Production machine is offsite. This machine is both a webserver and is my database server. My webhost has basically given me the IP address and username and password for...
  9. mickeyj2

    Formatting within &lt;TITLE&gt;

    Hi, Does HTML allow you to do formatting within the <TITLE> tags? How come if I have something like <i> within the <TITLE>, I don't get my formatting, but instead keep seeing <i>? Is there a workaround for this? Perhaps with CSS? Thanks, Meeka
  10. mickeyj2

    CSS Help - How to Lower the Underline

    Hi, I have the following CSS style .SuperText { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 8px; color: #000000; font-weight: normal; position:relative; top:-4px; text-decoration: none; } What this does is take text and superscript it - for example "TM" as in...
  11. mickeyj2

    How Does Switching Web Hosts Affect My Email Server?

    Hi, In the next week or so, I will be switching my web host. Here's my scenario. I have my domain name registered at a REGISTRAR COMPANY, but my pages are currently hosted by COMPANY A. I am switching my hosting to COMPANY B. My registrar warned me that switching name servers could...
  12. mickeyj2

    Can you have a Dynamic CFGRID?

    Hi, Check it out. I'm creating an application that allows my users to select the tables they would like to browse. There selections are sent over in a very simple form element (a list). I loop through that list performing a basic 'SELECT' statement for each table. I'd like to show each...
  13. mickeyj2

    Error While Running My StoredProc

    Hi, Can somebody help me out and tell me what I'm doing wrong here? I have an in-line query that I'm converting into a stored procedure that takes one parameter. The in-line query worked just fine in my application. Here it is: SELECT b.*, pc.categoryname, psc.subcategoryname, ff.* FROM...
  14. mickeyj2

    Best Practice for Setting Up Multiple Associated Websites

    Hi, I need to setup (7) websites. They all look alike, but one will be my "main" website with my company's branding, and the others will be "sub-domain" sites that drill down further into my various product lines. For example, Website 1 - abcbakery.com Website 2 - donuts.abcbakery.com...
  15. mickeyj2

    Best Practice: Setting Up Multiple Domains

    Hi, I need to setup (7) websites. They all look alike, but one will be my "main" website with my company's branding, and the others will be "sub-domain" sites that drill down further into my various product lines. For example, Website 1 - abcbakery.com Website 2 - donuts.abcbakery.com...
  16. mickeyj2

    How Can I Give Access to My Server?

    Hi, I'm running CF MX Developer on my desktop and utilizing SQL Server setup on another machine. Everything is working out fine. I'm able to develop and access my SQL Server. However, as I'm coding, I'd like to share my progress with my supervisor. Right now, he has to come to my desktop to...
  17. mickeyj2

    How To Truncate Precision if = 0

    Hi, I have a couple of fields in my table that are defined as DECIMAL(18,2). I am storing width/height size like 6.00 or 8.75. I need to keep these values as decimal, however, if the precision is .00 (e.g., 6.00), I'd like to truncate that in my SQL. How can I do that in my SQL statement...
  18. mickeyj2

    Can't See My EXEC Results

    Hi, I have the following which works fine, but I can't see the result set. I've been reading some of the posts and it appears that to see the result set requires a tiny miracle. I'm running this in Query Analyzer for now. Is there an easy way to see my result set, as I'm in the middle of...
  19. mickeyj2

    Best Query to Divide Data - Use Self-Join v. UNION?

    Hi, I’m a little rusty on my join logic, and was wondering if someone could help me with the following. I think I need to use either a Self-Join or a Union for this but I’m not sure. I have a mapping table that currently houses three main products. There are cables associated with those...
  20. mickeyj2

    Best Practices for ColdFusion Installation and IIS - Where to Code?

    Hi, I am a web developer who’s been using ColdFusion and IIS6 for a while. When I first began developing, I would always install IIS first, then my ColdFusion software. During setup and installation, I was trained to always look for the standard C:\inetpub\wwwroot directory, and develop from...

Part and Inventory Search

Back
Top