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: sevex
  • Order by date
  1. sevex

    Looping through query fields

    I have a query with quite a few fields, and I want to loop through them to do additional queries to get specific values from each. Is there any way to loop through query fields like looping through form fields in a collection? Any help would be greatly appreciated! (anyone else notice that...
    • sevex
    • Thread
    • Replies: 2
    • Forum: Adobe
  2. sevex

    DHTML Drop-down problems

    thanks anyway... I'll just keep hacking away at it.
  3. sevex

    DHTML Drop-down problems

    I'm testing in NS 4.08. Maybe no one even uses that one anymore... The *** drop down text *** appears when I mouseover the image, but when I move down to the text, where links will be eventually, it dissapears, cause the mouse events in the span tag seem to be ignored.
  4. sevex

    DHTML Drop-down problems

    ...height=&quot;21&quot; border=&quot;0&quot;></a> // first drop down <span id=&quot;menu1&quot; style=&quot;visibility:hidden; position:absolute; top:197; left:268; z-index:50&quot; onMouseOver=&quot;show('menu1');&quot; onMouseOut=&quot;hide('menu1');&quot;> ** drop down text ** </span>
  5. sevex

    Dynamic Visibility

    I just noticed that and was coming here to mention it before everyone saw how much of a moron I am... guess I was too late eh? :P
  6. sevex

    Dynamic Visibility

    Alright... I'm completely lost... I don't know what I'm doing. I have a select list, and depending on which option is selected, a different second select list will be &quot;displayed&quot; on the site. Here's what I have so far, and it doesn't do anything. in header: <script...
  7. sevex

    sorting by calculated field

    blah, why didn't I try that.... thanks for the help!
  8. sevex

    sorting by calculated field

    ...field, but it's giving me a &quot;field doesn't exist&quot; error. Is there a special way of doing this? My example (Coldfusion): SELECT *, (#Now()# - target_completion) AS days_left FROM TJob ORDER BY days_left target_completion is a date field. I can output &quot;days_left&quot; and it...
  9. sevex

    FirstDayofMonth giving incorrect value

    heh... well, what's really weird, is I took the code from an example in the manual, and tested it. It also gave an incorrect value... Maybe this function is bugged?
  10. sevex

    FirstDayofMonth giving incorrect value

    yup, it's correct
  11. sevex

    FirstDayofMonth giving incorrect value

    I'm using the FirstDayOfMonth function to help create a calendar, but it doesn't seem to return the correct day. If I use: #DayOfWeek(FirstDayOfMonth(Now()))# to get the day of the week for the current month (may), and it returns 2 (monday) when it should be 4 (wednesday). I must be doing...
    • sevex
    • Thread
    • Replies: 4
    • Forum: Adobe
  12. sevex

    Using ArraySum on a Query Column

    Thanks CFHUb, that worked great. Thanks WWebSpider as well, although I couldn't use that method, because I needed individual counts for each distinct, as well as a total.
  13. sevex

    Using ArraySum on a Query Column

    I'm trying to use arraysum with a query column to get the sum of all the values, but it just sees the first value, instead of an array. Is there some special way to do this? My code: <cfquery name=&quot;get_results1&quot; datasource=&quot;xxx&quot;> SELECT DISTINCT(q1), COUNT(q1) AS q_count...
    • sevex
    • Thread
    • Replies: 3
    • Forum: Adobe
  14. sevex

    select distinct and how many

    oh i just thought of it. distinct(field) as mydistinctfield, count(field) as fieldcount from mytable group by mydistinctfield? I can't test it out yet cause I'm waiting for datasources...
  15. sevex

    select distinct and how many

    Is it possible to do a SELECT DISTINCT, to select all distinct records, but also select how many of each distinct record there are? table data like: 1, cat 2, dog 3, cat 4, dog 5, dog and get a recordset with: cat, 2 dog, 3 thanks in advance for any help.
  16. sevex

    simple e-mail validation

    thanks a bunch! syntax error, how embarrasing.
  17. sevex

    simple e-mail validation

    I'm trying to validate an e-mail address by checking for an @ symbol, but it doesn't seem to be finding it. The following code: <cfoutput>#email# #Find(email, &quot;@&quot;)#</cfoutput> yields the following result: email@email.ca 0 which doesn't make a lot of sense to me. Am I doing...
    • sevex
    • Thread
    • Replies: 2
    • Forum: Adobe
  18. sevex

    Selecting records with no match in second table

    thanks for the help, but I gave up and took an easier path. just selected all of the records, matching and all, then used code to check for the unmatched ones.
  19. sevex

    Selecting records with no match in second table

    I've seen this done so many times, and now I can't remember how it's done. I have two tables, linked with a common field, and I want to select everything from the first table that doesn't have any matching records in the second table. A quick example would be greatly appreciated. Thanks in...
  20. sevex

    Height &amp; Width of Uploaded Image

    ohhh... thanks for the response, but I don't think I have access to the server to install custom tags and such. I'll just see about finding a better way to do this.

Part and Inventory Search

Back
Top