Search results for query: *

Yea, that's better. But now I get "invalid use of null". Is that because it doesn't find a record in one of the join tables?

Thanks. I've downloaded the database and am able to use MS Access 7 to open and display the data. I've tried to use the Query building options, but that's not really what I need. I just need someway to run this query as I have it written using their interface. Is this a pass-thru query? I...

Thanks for your reply. I am coding this myself and not using the query grid (not sure what that is). I inherited a bunch of ASP code and am making some changes. Would the query grid help identify the error?

...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 Groups INNER JOIN (Member_Group ON Member_Group.groupID = groups.ID) INNER JOIN (Members ON members.ID = member_Group.membershipID) WHERE...

Thanks so much. And you're right collecting just the running total doesn't tell you quite enough. I like your option 2 and this seems to be something I could do in the future when I have more time. For the time being, until I have time to implement something more rigorous, I've just decided to...

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

Thank you so much for your help. I was able to get it to work. I thought maybe a query or an array possibly would be the answer, but needed a little help visualizing it.

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

Thanks for your reply. When I dump the variable it is a zero. That's what's so frustrating. I don't know why both results appear, like the <cfif> is missing or something. When I take off the Cffile and just look at the value in an HTML table, it's correct, and is evaluated correctly. Maybe...

...they are blank (NULL), they want an n/a on the spreadsheet. The following code does NOT work. <cfquery name="getData" datasource="ddd" > select * from myFile </cfquery> <!---Write out column headers:---> <cffile action="write" file="C:\Websites\files\myfile2.xls" output= '<table...

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

Yes, that's what I'm doing...sending two different e-mails. Thanks!!!

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

Thanks to everyone who replied. You guys are great! I was really perplexed by this and under a time crunch, too. Thank you for the advice, too.

...the parent Staff record (staff_id = 292) when the staff person belongs to TWO groups, say group_id 4 and 12 This query does not work: SELECT * FROM dbo.Staff_Group, Staff where staff_group.staff_id = Staff.staff_id and staff_group.group_id = 4 and staff_group.group_id = 12 OR...

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