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!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
cfldap filter problem
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"... -
Filter content of dymanic drop-down list
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... -
Filter content of dymanic drop-down list
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 =... -
Problem with cfoutput
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... -
Problem with cfoutput
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... -
SQL question
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?? -
SQL question
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... -
access javascript variable
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...- Biglop
- Thread
- Replies: 1
- Forum: Adobe: Acrobat
-
pdf Verity Collections
I'm having the same problem...anybody have an idea what's going on? --Steve -
Using mulitple selections from drop-down
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"... -
populating Outlook calendar via url
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??- Biglop
- Thread
- Replies: 0
- Forum: VBA Visual Basic for Applications (Microsoft)
-
check checkbox on click of button
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.- Biglop
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
-
email to contents of "email" field
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- Biglop
- Post #8
- Forum: Microsoft: Access Modules (VBA Coding)
-
email to contents of "email" field
It still doesn't work...same error.- Biglop
- Post #7
- Forum: Microsoft: Access Modules (VBA Coding)
-
email to contents of "email" field
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...- Biglop
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
email to contents of "email" field
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.- Biglop
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
email to contents of "email" field
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- Biglop
- Thread
- Replies: 7
- Forum: Microsoft: Access Modules (VBA Coding)
-
Problem filtering list against another DB
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 -
Problem filtering list against another DB
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... -
Query of Queries problem
I don';t get an error message, it just hangs and eventually depletes server memory.
