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 "login name", and use that to populate a PDF form field. I know I...
I have a simple dynamically populated drop-down on a form page...Code:
<form method="POST" action="search_process.cfm">
<p>State: <input type="text" name="State" size="20">
<p>Focus Area:<select size="1" Name="ls_focus_ID"...
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, "", acFormatTXT, Email, , , "Subject Text", "Body Text", True
End Sub
O.K., here's my code:
Private Sub Command100_Click()
DoCmd.SendObject acSendNoObject, "", acFormatTXT, "Email", , , "My Subject text", "My body text", True
End Sub
"Email" is the name of the field that holds the email addresses. All this code...
I tried that but got an error "Unknown message recipient(s); the message was not sent."
Do I have to put the field name in a certain format(it's name is "Email")?
Thanks.
Hello,
I want to send an email from an Access 2000 form to the recipient in the "email" field of the active record. I know how to use the SendObject action from a command button, but how do I populate the "To:" 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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.