Search results for query: *

I haven't used Access in quite a while and am trying to join 3 tables. I'm getting syntax errors. I have tried doing the query with no table aliases, adding parens where I think they need to go. MS says to do all the INNER JOIN clauses first, still no go. Here is the query: SELECT * FROM...

Hi! I'm not sure how to do this. I have a web site and I would like to be able to display "top 10 new items" or something like that. I can now count how many times users click on certain links, but this is just a "one-up" number. I can display the most popular item in a certain time period...

Hello! I have 1 table in my database with a column called NewsType. This column can take on one of two values: Workforce or UI. I want to pull data from the column based on this column and display it on the web page in a tabular format. The first column of the table must contain only data...

Hi all: My program reads a MS SQL server table and uses CFFILE to make it into an excel spreadsheet so users can download it. Works fine, except for one small problem. The users want dollar amounts with no decimal points for fields which are dollar fields. Again, no problem. But for fields...

Hi! I'm not sure where to post this so I'm sorry if this is in the wrong place. I am interested to find out what others pay for the following services to an outside company. Here's what the outside company would be expected to do: 1. Maintain existing web site written in Coldfusion MX, with a...

Hi! I have a client who is using Contribute to manage part of their web site. They have a bulleted list on a page and are having difficulty changing the color of the bullet from black to white. They can change the text color o.k. to white. Does anyone know how to do this? I've fooled...

Hi! I am using cfform format="flash". Is there any way to do what is done in the following link? When my form is validated, I would like the "background", i.e. the rest of the page, to go dark and then the box with the error would appear. Click on the submit button "THis one is done in mxml"...

Hi everyone: Is it possible to have a CFMAIL tag with an attachment which will send the attachment only to those in the TO field and NOT in the CC field. The CC field would only get the email and NOT the attachment. My gut tells me that the answer is 'no'. Hope this makes sense, thanks, and...

Hi! I'm sure this isn't too difficult, but I'm having a problem with it. Maybe I've looked at it too much. Here is my data: Staff Table: staff_id (key), staff_name Group Table: group_id (key), group_name Staff_Group: group_id, staff_id Links staff people to their group. People can belong...

Hi! I really need some help! I just started using Dreamweaver 8 and I have a question about the putting of dependent files. I edit ONE file on the server and then attempt to save it. Dreamweaver saves ALL the dependent files as well. I went to Preference --> Site and unchecked the dependent...

Hi! I do a database retrieval and load variables with the values like this: <cfoutput query="get_data"> <cfset "Oversight_#x#_#y#" = #Oversight#> <cfset "Program_#x#_#y#" = #Program_Operation#> </cfoutput> Variables x and y are columns in the database table. I have a form with this...

Hi! I have a coldfusion form. When the user hits submit, I expire the original FORM page so the back button won't work. In IE this works as I wish. A message is displayed that the page has expired. In Firefox, it does not work, the page is loaded. How can you expire a page for Firefox...

Hi! Has anyone ever seen this? Data is entered to the database using an HTML form. There's a textarea in the form. One user has entered comments which are bracketed with "<" and ">". In one textarea they literally typed: <title is not correct .... This is stored o.k. in the database. When...

Hi! Not sure how many of you have used CFCHART. I am trying to, but I have a problem. I would like every bar labeled in my HORIZONTAL bar graph. In order to do this, I must make the graph height larger than I would like. Here is my code: <cfchart showborder="yes" show3D = "no"...

Hi! I can't seem to figure this out. I have five tables that contain a dateUpdated field. I need to find the maximum value of this field for all five tables. I want to execute a query which returns one value, the maximum date of all the dateUpdated fields. I've tried things like this...

Hi! I have a problem which is something I can't quite figure out. I have a two part form. The user enters a number on the first form and hits SUBMIT. Based on that number, an input table is generated on the second form. If we assume the user enters 7 for the number of items, the input...

Hi! I have an exhibitor database for an conference. I want to display all exhibitors currently signed up to exhibit for 2006. But if they signed up in 2005, and not in 2006 yet, I want to display these in the same list. SELECT * FROM Exhibitor WHERE exhibit_year = '2006' is what I had until...

Hi! I am running ColdFusion MX 7 and have a question about cfmail. I'm not sure I can do this. I want to be able to send an email using cfmail and somehow not allow the recipient to forward that email to anyone else. Is this possible? I once received some kind of "e-vite", which was an...

HI! We recently switched to CF MX7 and I have a question. I have a mail script which allows users to select a distribution list for an email. They can also attach up to 3 files to the email. For MX7, when I run this, it works o.k. as long as I don't delete the files after I upload them...

HI! I have a javascript function which executes when the page loads. It displays logos on my page. It re-executes using setTimeOut every 3 seconds and changes the logo. Seems to work fine except sometimes a logo will remain on the page what seems to be longer than 3 seconds perhaps 5-7...