Search results for query: *

My LDAP "or" query isn't working; it only returns members from the last group (cn=Teller). Must be a filter syntax problem but I'm stumped. Help? <cfldap action="QUERY" name="members" Attributes = "cn, Member, MemberOf, displayName" Start ="cn=Users, dc=bank, dc=com" Scope = "subtree"...

Sorry, I should have been more clear...how do I populate the drop-down list, so it only shows the seminars with <13 participants? You gave me a clue though, so now I have a query with all of seminars i don't want to display: QUERY 2: SELECT Seminars.seminar_id, Count(Enrollments.Seminar) AS...

O.K., I've got two tables, seminars and enrollments. I've got a dynamic select list, populated by a simple query on the seminars table: <CFQUERY DATASOURCE="Seminars" NAME="dates_1"> SELECT seminar_id, session_number, seminar_date, seminar_time, seminar_site FROM seminars WHERE session_number =...

It works now... the problem was that even though the cfoutput was referencing the correct query, "<cfoutput query="pb_bp_time_diff">", the actual field names were in the format "table.fieldname". In my case that was, for instance, "pb_bp_mod_time.mod_ID". It seems that even though the correct...

I have a query of queries, which works fine and when I dump the results all looks good. When I try a cfoutput, however, I only get results for one row, repeating. It's probably something basic, but I'm stumped...Ideas anyone?? Query: <cfquery name="pb_bp_time_diff" dbtype="query"> SELECT...

Thanks. I used the first option and it sorts fine. The second option (include date in query) doesn't work because it no longer groups on the converted date. Just curious...why doesn't mm-dd-yyyy(110) sort correctly??

I'm trying to make a query for a cfchart... here's my code SELECT convert(varchar(10),Date,101) AS enroll_date, COUNT(user_type) AS user_count FROM IBS_apps WHERE user_type = 'new user' GROUP BY convert(varchar(10),Date,101) ORDER BY convert(varchar(10),Date,101) DB is SQL Server. What...

I have a Cold Fusion page that accesses my Active Directory(cfldap)and returns client login info allowing me to personalize pages. I now have a PDF form that in which I'd like to use javascript to access a variable, say &quot;login name&quot;, and use that to populate a PDF form field. I know I...

I'm having the same problem...anybody have an idea what's going on? --Steve

I have a simple dynamically populated drop-down on a form page...Code: <form method=&quot;POST&quot; action=&quot;search_process.cfm&quot;> <p>State: <input type=&quot;text&quot; name=&quot;State&quot; size=&quot;20&quot;> <p>Focus Area:<select size=&quot;1&quot; Name=&quot;ls_focus_ID&quot...

I'd like to be able to have a customer click a link in an html email or Web page and have it automatically populate their outlook calendar with the a specific appointment. I've seen this before but have no idea how it was done. Any ideas??

I'm sure this is simple but... I have a form where I need to have a checkbox automatically checked when the user clicks on a command button. The command button actually does something else too, and I want the checkbox to be checked to show that the action was completed. thanks.

I played around a bit more and it worked! I'm not sure what made the difference. Thanks. Here's the code that worked: Private Sub Command100_Click() DoCmd.SendObject acSendNoObject, &quot;&quot;, acFormatTXT, Email, , , &quot;Subject Text&quot;, &quot;Body Text&quot;, True End Sub

It still doesn't work...same error.

O.K., here's my code: Private Sub Command100_Click() DoCmd.SendObject acSendNoObject, &quot;&quot;, acFormatTXT, &quot;Email&quot;, , , &quot;My Subject text&quot;, &quot;My body text&quot;, True End Sub &quot;Email&quot; is the name of the field that holds the email addresses. All this code...

I tried that but got an error &quot;Unknown message recipient(s); the message was not sent.&quot; Do I have to put the field name in a certain format(it's name is &quot;Email&quot;)? Thanks.

Hello, I want to send an email from an Access 2000 form to the recipient in the &quot;email&quot; field of the active record. I know how to use the SendObject action from a command button, but how do I populate the &quot;To:&quot; argument with the address from my database record? Thanks. --Steve

Thanks, it worked! I hadn't used the QuotedValueList function before. I was trying to use the CF5 queary of queries feature, but wasn't getting anywhere. Could I have don it using that method? --Steve

I have a list of email address in my main database. I also have a list of addresses in another enrollment database. I want to find and send a marketing email to all of the addresses in DB #1 that are not already present in DB #2. It seems like a simple problem but I'm stumped. Can anybody help...

I don';t get an error message, it just hangs and eventually depletes server memory.