Recent content by Klotzki

Our office with about 50+ workstations is considering getting a DSL connection for internet connectivity of workstations and servers. Our potential DSL provider is providing us with 5 static IP addresses, 4 for our servers and 1 as the gateway for our workstations. I'm not quite sure what kind...

Hi, Cold Fusion has a tag called CFMAIL that can send e-mails through SMTP. It can take a Cold Fusion query, allowing you to have dynamic content in the e-mail itself. Check out the docs. Ben Forta's Cold Fusion book does a good job of explaining the use of this tag. hope this helps. Klotzki

Hi there, Check out www.cftipsplus.com and www.forta.com. Off the top of my head, I use a combo of CFSCRIPT, short-circuit eval, and plain simple logic I picked up over the years. (1) Use CFSCRIPTs when you can. (2) Take advantage of short-circuit evaluation when evaluating two or more...

You getting JavaScript errors? I don't really know what your code does but try outputting it anyways and post the question in the JavaScript. They're pretty helpful there. Klotzki

There's a CF tag called CFDIRECTORY which allows you to perform directory-related actions. Try this which will create a query result called JpegFiles with columns (Name, Size, DateLastModified and others). <CFDIRECTORY ACTION=&quot;List&quot; DIRECTORY=&quot;c:\jpeglocation&quot...

What does installit.cfm look like? Is it a form with a hidden form field to store the passed #UNV_ID# through the hyperlink? If so, try this. <CFOUTPUT> <INPUT TYPE=&quot;Hidden&quot; NAME=&quot;myformfield&quot; VALUE=&quot;#URL.UNV_ID#&quot;> </CFOUTPUT> Klotzki

Hehe. I remember figuring this one myself not long ago. The trick is to do a little bit of programming. Make your code something like this. Hope this helps. Klotzki -------------------------------------------- <!--- Set Column Counter ---> <CFSET ColCount = 0> <TR> <CFOUTPUT> <CFSET...

Does anyone know of a custom tag that would sort a query result or 2-d array based on 2 or more columns? I could only find single column sorting tags. Thanks. Klotzki

Try inserting the MAXROWS and STARTROW attributes onto your CFQUERY and set up your Prev & Next hyperlink with the start row values. --------------- <CFOUTPUT QUERY=&quot;MyQuery&quot; MAXROWS=&quot;25&quot; STARTROW=&quot;#URL.CurStartRow#&quot;> #MyQueryVar1#, #MyQueryVar2# </CFOUTPUT>...

I'm guessing you would like to set it up so that users can not surf around your site after the 5 min expiration. You have to insert a CFAPPLICATION tag on your application.cfm and specify session timeout. <CFAPPLICATION NAME=&quot;MyApp&quot...

Are you trying to approve/deny everything the query returns or selected rows? What happens when you post the form? Take note that variable names of unchecked checkboxes do not get passed onto the next page, when posted. Klotzki

I'm not quite sure what you mean by 'create a new field'. Does this new field already exist in your database? If so, then what you can do is to output the 3 form fields in the SQL statement like this. <CFQUERY DATASOURCE=&quot;MyDSN&quot;> INSERT INTO tblMyTable(MyField)...

I think you might have to do the 2nd insertion manually. After a record is inserted in TeamMember table, do a Last function SQL query to get the last record in the table. Something like this, <CFQUERY NAME=&quot;LastTeamMemberRecord&quot;> SELECT Last(MemberID) AS LastMemberID FROM...

You set session variables, containing the total number of forms needed to be filled and a counter. The most simple way is to do this... eg. When the first form (one that decides how many forms to be filled) is submitted, do something like... <CFSET Session.NumToBeFilled = 5> Before the...

The problem you might be having is probably due to your NumberFormat syntax in your sample code, unless of course this is a typo. Also, although I noticed that there's '/' and '-' in your OPTION VALUE, i'm assuming you're not doing some math calculation here but to have the two characters in the...