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!
-
cfobject to load a dll - asp vs cfm
Thanks for that information, thedrider. I didn't know about the ReleaseCOMObject() function (it's documented here). Even if you don't use that function, the JVM will release the object during garbage collection, but on a heavily-loaded server, freeing up the memory earlier could be a real... -
cfobject to load a dll - asp vs cfm
This is a lengthy topic, so I posted the answer off-forum on my own blog. Here's a synopsis: Search the HKEY_CLASSES_ROOT\CLSID key in the registry for a key containing a key named InProcServer32 whose default value is a path to the DLL in question. Take the name of that key (the CLSID of the... -
Blanking Dates and Text Truncation
I'm not sure if this is a factor in your first issue, but keep in mind that if you delete everything from a text form field, the field will not be submitted with the form and will not show up in the form scope on the handler page. If you check for the existence of the field in the form scope... -
Can I use CACHEWITHIN attribute in my stored procedure??
The documentation says that "cachedwithin" is only valid for the <CFQUERY> tag. However, you could roll your own caching mechanism by executing the procedure once, then copying the result set into a persistent memory store like the session, application, or server scopes. If you also... -
Top1 record for each employee
I think what you want is this: SELECT a1.SocSec, a1.BeginAbsenceDate, a1.AbsenceCode FROM tblAttendance AS a1 WHERE a1.BeginAbsenceDate = ( SELECT MAX(a2.BeginAbsenceDate) FROM a2.tblAttendance WHERE a2.SocSec = a1.SocSec ) ORDER BY SocSec The columns of... -
Using the Replace Function to replace " and ,
So, what I think you're saying is that you'd like to take the file name from the uploaded file and remove any comma, apostrophe, and quote characters. Try this: <cffile action="RENAME" source="#CFFILE.ServerFile#"... -
Easy Question on Session Timeouts
Just a clarification -- the session variables persist as long as the session is alive. The session counter is reset any time a page is requested in that session. So, it's not necessary to read or write to a session variable in each page just to keep it "alive" -- as long as the user... -
Problems querying Active Directory in SQL 2000
...SELECT sAMAccountName, sn, givenName, LOWER(mail) AS mail FROM openquery(ADSI,'<LDAP://cha-llp.com:389/DC=cha-llp,DC=com>;(sAMAccountName=*);sAMAccountName,sn,givenName,mail;subtree') where sn is not null order by sAMAccountName [code] But I get this error: [code] Server: Msg 7399, Level 16...- pcorreia
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Programming
-
Sending a ColdFusion e-mail in both plain text and html
Falcao and moonriver, you should have just received the custom tag via e-mail. Let me know if you have any problems... pcorreia -
CFMX Updater 3 Released
Macromedia has released the ColdFusion MX Updater, version 3. The updater is Macromedia's version of a service pack for CFMX. General Information http://www.macromedia.com/software/coldfusion/special/updater/faq/ Release Notes (including list of fixes)... -
Executing an application on client side
Righto, Carl. Clearly, my solution is only viable if you are developing an internal application where you know the audience only uses a single browser on a limited set of OSes, and that single browser is IE and those OSes are Windows 2000 and above. A lot of ifs, I know. But, that begs the... -
Executing an application on client side
Using the WScript.Shell ActiveXObject, you could execute a command-line application on the client using JScript in your web page. Limitations are:The client must be running Windows and have the Windows Scripting Host installed (comes with Windows 2000 and later, I think)Depending on the... -
web page title
...<cfset files = ArrayNew(1)> <cfdirectory action="list" directory="#thisDir#" name="qryFileList" filter="*.cfml"> <cfloop query="qryFileList"> <cfif NOT ListFind(".,..",qryFileList.Name)> <cffile action="read"... -
encrypt password before submit
If your purpose is to protect the password during transmission from the client to the server, that means you need to encode it on the client, but in a manner that you can reproduce on the server. ColdFusion's Hash() function encrypts a string with the MD5 algorithm, and a JavaScript library to... -
print @<variable> problem
Admittedly, I know very little about ODBC. What I meant was, when I put SQL Server-specific syntax in a <CFQUERY>, it is executed properly on the SQL Server even though it is going through ODBC, so clearly you can use SQL commands that are not part of the ANSI spec. I think DBAssam should... -
print @<variable> problem
I believe ODBC is just a connection syntax, and should "pass through" any SQL regardless of whether it is vendor-specific. The problem is that <CFQUERY> isn't a full-fledged SQL development environment. It expects a single result set, and doesn't support any debugging output (which... -
get record from time selected
How about this? SELECT * FROM roomHotel WHERE #FORM.from_time# BETWEEN from_time AND to_time OR #FORM.to_time# BETWEEN from_time AND to_time -pcorreia Hope this was a Helpful post! -
problems with ssl (https) on IE 5.0
Have you verified that the problem is with the SSL? If you disable the SSL and try it with IE5.0, does the problem go away? -pcorreia -
Check Box - Only One Selected In table
This will have to happen when the page is submitted, but if the "name" attribute of your radio buttons is "key", you can assign the "value" of the radio button selected to a session variable like this: <cflock scope="SESSION" type="EXCLUSIVE"... -
help w/ regular expressions
I can definitely help you with this, but I'm a little unclear on what exactly you want to know. Are you looking for information on how to search the whole document for multiple matches on your RegExp pattern? Or are you looking to retrieve the value of a subpattern within the match? -pcorreia
