Recent content by fenneraj

Cheers Tazuk, It did lead to the solution, but wasn't quite it. I use the classic start menu, as i am not a fan of all this green and blue and silver stuff. When i switched to the XP style start menu, i could indeed reinstate the My Computer Icon using the method you described. But when i...

Hi all.... Quite a simple but nonetheless irritating problem... in my infinite wisdom i have accidentally deleted the my computer icon (i didn't even know this was possible) whilst trying to remove some other junk from my desktop. I am trying to retrieve it and not use a shortcut that i have...

Hi All! I have had this prob for a while and probably comes my poor design, but I am now in a fix and need some help. I have a site that has main content on the left and navigation and progress reporting on the right. Up until now the navigation button (<CANCEL>, <BACK>, <NEXT> <-- All nested...

Cheers TruthInSatire, That works a treat.

Hi All, I have been using CFFILE to loop through a CSV file. The problem I am having is that if the value of the cell (as if displayed in a spreadsheet) is blank, then an error is thrown... What I want to be able to do is to replace any NULL sting value with non-breaking space or ignore them...

Cheers micha123, Works a treat

Hi all, Having real trouble with this one.... I have a table with a record ID (adID), advert text (ad), Submit date (sub_d) and update date (up_d). What I want to output is the ID, the ad text and ONE date. This date must be the 'newest' of the submit date and update date. This date then...

Hi all! I am having probs with my SP's and was wondering if you guys can help..... I have a set of tables (CERD, LMCD, TOF_CL_DETAILS) that has a two fields TOF_ID (INT) and UPDATE_DONE (BIT). There are 8 tables with this arrangement, and this is where the prob comes in. The output i am...

James, That works great as a trigger, but i need to be able to create the historic record on certain updates only. Is there anyway i can add a condition to the trigger that will only cause it to copy to the historic table if the condition is true. Also i need to be able to timestamp the new...

Hi All, I have a problem whereby i need to copy a row of data from one table to another, but i need to do this across a large amount of tables... For example, I have a client details table (CL_DETAILS) and a historic client Details table (CL_DETAILS_HISTORY). What i need to do is establish an...

Hi, I have created a View (MAX_LIST) that shows an output like below. FB_SN | MAX_CALLS 1 3 2 7 3 6 I am trying to write an SQL query that will output the the max from max calls and its corresponding FB_SN. Using the MAX in the select just presents me with the MAX...

Cheers guys, I had a fiddle with google tool bar, but couldn't orignally find an acceptance list, i will look again. AF

Hi, I have recently built a web system that opens a pop up window for data entry. Unfortunately my manager has Google toolbar that has a very basic pop up blocker incorporated into it. As it is not customisable, he cannot view these pages without turning the whole tool bar off. My question is...

Hi all, I have a query in Access that takes all the information from one table and displays it, there is one field that i need to query and display the results of the query in the output. I currently have a last_update field which shows the last update date and time (19/02/2004 19:56:34). I need...

Sorry Guys, Neither of those worked. I am using an MS Access DB with a Cold Fusion frontend.