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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: Klotzki
- Order by date
-
DSL, router & network switch connectivity prob
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...- Klotzki
- Post #7
- Forum: Data Transmission general discussion
-
COLD FUSION MAILING LIST SETUP
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 -
Writing for optimal speed
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... -
Output queried data inside a JavaScript
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 -
Output Images (jpeg's)
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="List" DIRECTORY="c:\jpeglocation"... -
Pass Values from Query when selected
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="Hidden" NAME="myformfield" VALUE="#URL.UNV_ID#"> </CFOUTPUT> Klotzki -
Outputting Info Selectively
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... -
Executing a CF tag inside a string possible?
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 -
ouput certain rows of query
Try inserting the MAXROWS and STARTROW attributes onto your CFQUERY and set up your Prev & Next hyperlink with the start row values. --------------- <CFOUTPUT QUERY="MyQuery" MAXROWS="25" STARTROW="#URL.CurStartRow#"> #MyQueryVar1#, #MyQueryVar2# </CFOUTPUT>... -
Automatic logout after a specified idle period
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="MyApp"... -
Results from CFQUERY in table with checkbox
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 -
Create a new data field out of three other data fields
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="MyDSN"> INSERT INTO tblMyTable(MyField)... -
INSERT INTO w/ Multiple Tables
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="LastTeamMemberRecord"> SELECT Last(MemberID) AS LastMemberID FROM... -
Tricky Form Queueing Question
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... -
CF LOOP Problems!?
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... -
Form Submit Error Message
I had a similar problem before. I encountered this problem early morning. I went to bed and got up and it was working fine. =) I don't think it was my nap that solved it. Our Cold Fusion admininstrator restarts the web server every morning and that could have been it. Try this and hope it... -
How can i do a session clearing when the browser is closed ?
Hi everyone, No, by default session variables aren't expired when browsers' are closed. Here a piece of code I found that would do the trick. PUt this in your application.cfm together with CFAPPLICATION tag and your desired attribute settings. <CFCOOKIE NAME="CFID"... -
CFFILE upload prevention if not file exisits...
I wasn't sure how files to be uploaded were specified, since i can't see <INPUT TYPE="FILE"....>. But I'm assuming this is what your users will be using to upload. (1) Make sure that you specified the attributes NAME="licensephoto" and VALUE="" in the INPUT tag... -
Can't get rid of this error.. tried everything :/ Err&Code included,
It seems that your WHERE clause's expression value is not enclosed with CFOUTPUT tags. Try changing to WHERE clause to... WHERE AddedBy='<CFOUTPUT>#Form.AddedBy#</CFOUTPUT>' Hope this works. Klotzki -
same field, multiple entries
I don't think so. I was trying to do the same thing but I think inserting multiple records with no reiteration / loop is possible with MS Jet SQL (Ms Access's database engine) What I did was just to loop through the records I want and do the CFQUERY w/ INSERT SQL command for each record. Klotzki
