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

    Show a button on a page based on query results

    Yeah, I don't see a problem with where your cfif block is. All you are doing is hiding/displaying the submit button based on UserID.Name <td bgcolor="#FFFFFF"> <div align="center"> <cfif UserID.Name is "ABC" OR UserID.Name is "XYZ" OR UserID.Name is "XOXO"> <input name="Submit"...
  2. okiiyama

    How do I split data into multiple tabs for excel 2003?

    Thanks for the reply, I appreciate it. However, I found a program with a free trial that did what I needed to do in a snap: http://www.extendoffice.com/product/kutools-for-excel.html ^^I'm not sure if this is promoting or not, the link to the program, was the answer to my solution.
  3. okiiyama

    How do I split data into multiple tabs for excel 2003?

    I have data in Sheet1, about 4500 rows, and I need to split this data into new sheets based on the data in the 1st column. It would be a bonus to have the tab name be what is in the first column. Splitting the data into multiple tabs will result in about 90 new tabs. Any VBA script that I can...
  4. okiiyama

    Creating a two column pdf

    I've created a pdf that is about 80 pages long. Essentially its a PDF of Drugs and the Drugs' reactions and is sorted alphabetically. If I can create a two column PDF, I can drastically reduce the number of pages, but I want to fill the first column first, and then fill the second column - and...
  5. okiiyama

    Redirect from domainname.com to www.domainname.com

    i solved it myself, as what usually happens 5 minutes after posting a question. In IIS under the home directory tab of the site, I selected URL Redirection.
  6. okiiyama

    Redirect from domainname.com to www.domainname.com

    I have an ssl certifcate for example: www.domainname.com. Its not a wildcard certificate, so when a user types in just domainname.com, a certificate error happens. Can I redirect to www.domainname.com, using IIS or do I need to modify/add a dns record? How would I do this. Thanks
  7. okiiyama

    DNS Redirect

    Is it possible to do a dns redirect? I'm hosting a website that found a new host and has a new site up, but the site has switched owners a couple times and they have lost their registrar account info to update the nameservers. So while they are doing the paperwork to validate site's ownership...
  8. okiiyama

    PDF's file size balloons when printing

    I've been using coldfusion to create and print pdfs. On our current server (win2003 x32), everything works well. Unfortunately we are moving to a new server (win2003 x64), and after some testing, we are seeing the pdf file size go from about 250 KB on disk to 15 MB in the printer queue. It...
  9. okiiyama

    Copying/Moving Databases to a new server

    Thanks for the response. After fiddling around some more, I found that I can recreate the databases using .bak files from the old server.
  10. okiiyama

    Copying/Moving Databases to a new server

    I want to move databases on a local sql 2005 box to a sql 2005 box that is being hosted else where. If it matters, I don't care about moving the database users/logins to the new server. I only care about the tables, views, and stored procedures. Is there a way to 'copy' the databases to the...
  11. okiiyama

    cfprint creating a huge folder of images

    I'm using cfprint to print a batch of pdfs, and I've noticed that in the process of sending the pdfs to the printer, the images in the pdf are being converted to a tiff file and saved in a temp folder. It wouldn't be a problem if the tiffs were deleted after the file was printed or sent to the...
  12. okiiyama

    Can I use cfhttp to login and navigate to a certain page?

    I'm using a payment gateway (authorize.net) to process online CC transactions. Right now, to reconcile the transactions we've recorded against the transaction that the payment gateway has, a person will need to login into the payment gateway, then navigate to a page that lists the transactions...
  13. okiiyama

    sql building, apostrophe escaping, behavior diff from CF6.1 &amp; CF8

    What about using: cfqueryparam? select * from table where field1 = <cfqueryparam cfsqltype="cf_sql_varchar" value="#var#"> I don't think you'll need to worry about apostrophes or double quotes in the variable then.
  14. okiiyama

    Cfdocument PDF cutting off characters

    Yeah. There is a Hotfix that I beleive addresses this issue. http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_17883&sliceId=2 This should fix your character cut-off problems, but CFDocument is still not perfect.
  15. okiiyama

    I don't get it... 'System.Security.SecurityException' occurred...

    Starting Over... I would like to create a c# stored procedure, and if possible I would like to write the code on my local machine, and also test/debug from my local computer. The stored procedure, once completed will be executed within a Job. What the SP needs to do is: 1. Run a query 2...
  16. okiiyama

    I don't get it... 'System.Security.SecurityException' occurred...

    I'm new to C#, Visual Studio, and the whole .NET Framework. I'm trying to create a stored procedure class(?) that will run a query and output the results to a text file located on a shared network drive. So far the class is empty, and when I compile/debug it I'm getting: A first chance...
  17. okiiyama

    SQL Server 2005 - Job that writes query results to a text file

    Yeah, I'm not sure if its the best approach, but I created a view that unions the column names with the records, and then querying the view. That has solved that problem. Thanks for the help.
  18. okiiyama

    SQL Server 2005 - Job that writes query results to a text file

    Sweetness... Ive gotten the BCP Utility to work premliminarily... Is there a way without writing out a query to include the column headers in the text file automatically?
  19. okiiyama

    SQL Server 2005 - Job that writes query results to a text file

    Could I write to a text file from a stored procedure in 2005? More to the point.... How can I write to a text file from a stored procedure. I'm thinking executing an SP from a job would be easy. Thanks again.
  20. okiiyama

    SQL Server 2005 - Job that writes query results to a text file

    How do I create a Job that runs a query and writes the query results to a text file in SQL Server 2005? The query is simple: Select * from .... The text file resides on a different server, but I've mapped the drive on the server that will be executing the job. The text file is overwritten each...

Part and Inventory Search

Back
Top