Search results for query: *

I just started a new job where they only have a development (DEV) server and a production (PROD) server. Every place I have worked before has always had a third server in-between DEV and PROD. Some places called the in-between server Stage, and some called it Test. I'm not sure if a Stage and...

I'm running CF8 on IIS6. I am attempting to run the "Cumulative Hot Fix 4 for ColdFusion 8.0.1" found on http://kb2.adobe.com/cps/529/cpsid_52915.html . I did the part about installing the chf8010004.jar file with no problem. When I tried to do the cfmx_bootstrap.jar upgrade I received 500...

Thanks for your help!!! The UNION worked perfectly.

druer, Your code looks interesting, but, unfortunately empty date fields are NULL.

I've been asked to create a report from an existing database. The user wants to know when was the last time someone worked on a project. Normally, this would not be a problem, because there would be a table for the project and a separate table logging each time someone did work on the project...

druer, That looks like it will give me what I need. Thanks!!!

This is probably a simple question. I have been asked to get a list of accounts that have closed within five years of the account being open. I have a table called ACCOUNTS that contains the following columns: ACCOUNT_ID, DATE_OPENED, DATE_CLOSED I'm probably on the wrong track...

Thanks NoCoolHandle. That helps. I was able to create a new column with the primary key and identity properties. Then I was able to add the data from the orginal ID column by surrounding the insert code with the IDENTITY_INSERT command. Example: ======== set IDENTITY_INSERT MYTABLE ON -- code...

Does anyone know how to write script to not only make a pre-existing and in use table column a primary key but also set the identity values? I have inherited a database. It has a table being used, which is already populated with data. The table has an ID (int)(Not Null) field being used as a...

Thank you for your responses. They were extreamly helpful.

This is probably going to be an elementary question, but I just want to see if I understand the storage of nvarchar correctly. The Microsoft web site has the following to say about nvarchar. "Variable-length Unicode character data of n characters. n must be a value from 1 through 4,000...

Does anyone know of any problems with client variables on a clustered CFMX server? The client variables seem to dissapear on the web sites in which we are migrating from CF5 to CFMX. We are hoping we do not have to convert all the client variables to session variables.

Thank you for your responses. Ecobb - I looked for a custom tag that would do this, but all I found were custom tags for POP servers. I don't think they would work with my corporate exchange server. cannedRadio - From the link you provided, it looks like the easiest thing to do is replace the...

Now to the problem. I am reviewing the report from the code compatibility analyzer (cca) in order to migrate a site to CFMX. One of the items marked as an error by the cca report was the use of cfregistry. The code identified is being used to resend emails. The cca error message indicates...

I figured out the answer to the problem. Apparently, the version of Visio on my old computer was the Enterprise edition, and the version of Visio the IT department put on my new computer is the Standard edition. The Standard edition does not have the same database options.

My IT department recently replaced my computer. My old computer had Visio 2000. My new computer has Visio 2003. I've noticed the Visio on my new computer does not have the "Database" item in the menu bar. How do I get the "Database" option to display?

Albion - The final page can only receive form variables. Even with the updated code you presented, it still would be sending URL variables to a template that only receives form variables. Your code: var1=<cfoutput>#FORM.something#</CFOUTPUT> Concerning you second response about removing the...

I want to send simple data variables to a template. The template will do some processing. When the template is done processing, it needs to be able to automatically (without user intervention) send the data to another template as form variables along with the user. So, basically, the user will...

ChrisPanet and PHV, ChrisPanet, you suggestion looks like it would work, but the database I'm working in has a lot of forms that I did not create. Someone else may want the pop-ups on their form. So, even though your suggestion looks like it will work, I'm trying PHV's suggestion. PHV, your...

Lewds, I tried entering the code: Private Sub Form_Load() DoCmd.OpenQuery ("qryMoveData") End Sub This would be great, but when I execute the form, I get two pop-up windows. Do you know if I can get rid of the pop-up windows? Pop-up window one says: "You are about to run an append query...