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 derfloh 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: *

  • Users: aliashippysmom
  • Order by date
  1. aliashippysmom

    Inner join problem - 3 tables

    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?
  2. aliashippysmom

    Inner join problem - 3 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...
  3. aliashippysmom

    Inner join problem - 3 tables

    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?
  4. aliashippysmom

    Inner join problem - 3 tables

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

    Count "top 10 articles" on a web site

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

    Count "top 10 articles" on a web site

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

    Merging 2 queries interleaving results

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

    Merging 2 queries interleaving results

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

    CFFILE append and null values

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

    CFFILE append and null values

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

    Pricing of web programming and services

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

    Change color of bullet

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

    flash form validation question

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

    CFMAIL - attachment to TO field only and not CC field

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

    CFMAIL - attachment to TO field only and not CC field

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

    Multiple table query

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

    Multiple table query

    Thanks for your reply. I'm still having a problem. Here is an example. Here are 4 records from the Staff_Group table showing the groups for one person: staff_id group_id 292 1 292 4 292 7 292 12 I want to write a query to retrieve this record and the parent...
  18. aliashippysmom

    Multiple table query

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

    Getting and putting dependent files

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

    Dynamic form value

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

Part and Inventory Search

Back
Top