Search results for query: *

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

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.

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

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

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.

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

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

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

Thanks for the response. After fiddling around some more, I found that I can recreate the databases using .bak files from the old 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...

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

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

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.

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.

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

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

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.

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?

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.

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