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 Chriss Miller 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. ibwebn65

    Stage/Test Server

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

    cfmx_bootstrap

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

    Highest date in multiple columns.

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

    Highest date in multiple columns.

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

    Highest date in multiple columns.

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

    Date Diff and Leap Year

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

    Date Diff and Leap Year

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

    How to add IDENTITY to an existing table.

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

    How to add IDENTITY to an existing table.

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

    nvarchar Storage

    Thank you for your responses. They were extreamly helpful.
  11. ibwebn65

    nvarchar Storage

    ...a length of 4000, and someone puts data in the column field containing only one character, then the storage size will be two bytes? (1 character * 2 = number of bytes) Question 2 If I create an nvarchar column with a length of 4, and someone puts data in the column field containing only one...
  12. ibwebn65

    Client Variables on a CFMX Clustered Server

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

    Resend Emails

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

    Resend Emails

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

    Database menu item

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

    Database menu item

    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?
  17. ibwebn65

    Automaticly Passing Form Fields

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

    Automaticly Passing Form Fields

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

    Automaticly Execute a Query When a Form is Opened

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

    Automaticly Execute a Query When a Form is Opened

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

Part and Inventory Search

Back
Top