Recent content by ljevans

Yes, in going back, I am seeing the same thing.

But, I get the results I expect when I run the view.

It is a SQL server database, but the code that I used seems to work.

When this view is run, all of the discrepancies written the previous month are displayed. I've got the last day of the previous month, but I can't get the first day. Any help would be appreciated. A criteria example: Between 10/1/2006 and 10/31/2006 So far I have: Between 10/1/2006 and...

I have a select box that is populated using 2 queries, each from different tables. They both pass pkey for value. Based on which table's value is selected, determines another setting when an update takes place. I may have a pkey value of 8 for a department and a pkey value of 8 for an...

There is no relationship between Table1 and Table2 other than a possible reference of Table2's airport code within Table1's description field.

I am using Access 2003 SP1. Table1 has a description field. Table2 is a lookup table that has airport codes. I want to loop through Table1's description field looking for any reference to each airport code. Can I do this with an Access query?

Does anyone know where I can find a list of reserved words for ColdFusion MX?

There are only 2 of us that work with ColdFusion and I am the only one working with this code. I thought that I had heard that there was an auto-correct setting somewhere. I thought maybe this was enabled and that is why this was happening. Does this sound familar to anyone?

I do check the file in and the changes are reflected when I refresh the page.

The problem is that I am saving the code after an edit. The change is reflected when I refresh the page. It is when I go back and open the code itself that it has reverted back to its original revision. Example: I am trying to fix these line of code <!--- FROM: <A...

I already have SourceSafe installed and have used it with ColdFusion for 6 years. This is something that has started happening since I have installed ColdFusion MX. There is a Code Rewriting setting under Files/Preferences, but none of the boxes are checked.

I am using ColdFusion MX. I edit code and save. Refresh page everything is fine. The next time I go back in to the same code, the changeds I made have reverted back to the original version. If I make an edit unrelated to the first edit and save, I lose the first edit. I am using SourceSafe...

I am creating the package manually. I know how to adjust the size if I am exporting to a text or csv file, but I can't see how to do it if I am exporting to Excel. I may give up and just export to csv.

I am using DTS to export data from SQL to Excel. I have a large text field that is being truncated at 255 characters. When I look at the Destination field size for the package, I see that the Data Type for all the fields is VarChar and the size is 255. How can I change this so the text is not...