Search results for query: *

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.

Hi, I am using Cold Fusion to connect to an access DB. I am trying to get the SQL to filter out dates that are less than my threshold date (18/02/2004). The dates in the DB are listed as dd/mm/yyyy hh:mm:ss with the data type set to General Date. When i pull in results using this query: SELECT...

Hi, I have a table with about 4000 records in it, i need to pull out some specific data but i am struggling. Here are the fields: Client_Number (Primary Key) No_Of_Items DONE TSM (this is a name of a person) I have this query so far..... SELECT * FROM tbl_Xtra_MED INNER JOIN tbl_Inst_Posn ON...

Hi, I would like to be able to calculate averages for the last 50 records in my database only. Using the statement: SELECT AVG(qu1Radio) AS qu1AVG.......... This takes an average of all 1100 records. Could it be done by providing arguments directly to the AVG clause or by using WHERE...

Hi! I need to be able to build an email using the URL MailTo function. I can attach the subject line and Body, the problem i have is that i can not get the body text to do a new line. This is what i have so far: <a href=&quot;mailto:#email_address#?Subject=MyAgent User Name and...

I have a image based nav bar that i require a select box on. I realise it could be done very easily using the table background and having the select box on top. This cannot be done as the image has a map defining 'Hot Spots'. If anyone can tell me how i can get the select box to appear on the...