RE: Fusebox and URL protection

2002-05-05 Thread BORKMAN Lee
An interesting approach is to pass a completely encrypted URL string. Have a look at Tim Heald's URL encryption functions here: http://loathe.mine.nu/ The problem with adding a simple checksum is that a dedicated hacker only needs to figure out the checksum algorithm. Encrypting the entire URL

RE: CFSETTING "HTML Strings" *URGENT*

2001-04-04 Thread BORKMAN Lee
Any drawbacks? Well, obviously all these solutions suck except for mine ;-) leeb. ps, I can't remember whihc one was mine actually -Original Message- From: bfalloon [mailto:[EMAIL PROTECTED]] WOW! Thanks everyone! So many solutions! Which should I use?? Are there any drawbacks with an

RE: CFSETTING "HTML Strings" *URGENT*

2001-04-04 Thread BORKMAN Lee
This looks like overkill to me. What about this?: That should work fine. If you want to include double-quotes, then use single-quotes as your delimiter, and vice-versa. If you want to include BOTH in the string, then you have to get more tricky, have fun, Lee (Bjork) Borkman http://bjork.net

RE: Date Conversion - SORRY

2001-03-22 Thread BORKMAN Lee
Sorry, that should (of course) be: -Original Message- From: BORKMAN Lee Hey, Regular Expressions are much more fun!!: Enjoy!! Lee (Bjork) Borkman http://bjork.net ColdFusion Tags by Bjork IMPORTANT NOTICE: This e-mail and any attachment to it is intended only to be read or used

RE: Date Conversion

2001-03-22 Thread BORKMAN Lee
Hey, Regular Expressions are much more fun!!: Enjoy!! Lee (Bjork) Borkman http://bjork.net ColdFusion Tags by Bjork -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] IMPORTANT NOTICE: This e-mail and any attachment to it is intended only to be read or u

RE: One record query output

2001-03-19 Thread BORKMAN Lee
You can use the MAXROWS attribute on CFQUERY and/or on CFOUTPUT. That should do it, Lee. -Original Message- From: Michael Gribbin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 20 March 2001 14:10 To: CF-Talk Subject: One record query output Hi, I'm trying to find out if it's possible to

RE: newbie wants to access by rows and columns

2001-03-19 Thread BORKMAN Lee
Well, there are several ways you could go: - Run the query to grab the entire table. Then reference the query as though it's a CF-structure; or - Run the query using STARTROW=2 and MAXROWS=1 to stop at row 2, then use queryname.columnlist, listgetat(), and evaluate() to fetch the data from column

RE: Thanks everyone but one last question

2001-03-19 Thread BORKMAN Lee
Do you really want to see what's in row 2, column 2, or do you want to see what ID(3)'s First Name is? That seems much more useful. To do that you just use SELECT FirstName from TableName WHERE ID = 3 #test.firstname# If you really want to access fields by row and column nu

RE: A newbiw question to the masters

2001-03-19 Thread BORKMAN Lee
Sorry, that query should not include Password in the fields SELECTed: SELECT ID FROM Table2 WHERE (ID = '#id1#') AND (PASSWORD = '#password1#') Bye now, Lee. -Original Message----- From: BORKMAN Lee [mailto:[EMAIL PROTECTED]] SELECT ID,PASSWORD FROM Table2 WHER

RE: A newbiw question to the masters

2001-03-19 Thread BORKMAN Lee
Hi Greg, It's probably better to put your conditional in the SQL query, especially for a password database. Some database won't actually return you the password field (eg., LDAP), but they will let you do this: SELECT ID,PASSWORD FROM Table2 WHERE (ID = '#id1#') AND (PASSWORD = '#password1#')

RE: White space

2001-03-15 Thread BORKMAN Lee
Yeah, although I wrote it, I don't use CF_LessWhiteSpace much anymore, because of the processing overhead. I try to manage with CFSETTINGS, which is pretty easy to arrange when using FuseBox, but a pain if you're not. As I live in Australia, my two cents's worth is now worth $0.01 ;-( Lee (Bjo

RE: Project Mgmt for CF development?

2001-03-12 Thread BORKMAN Lee
Yeah, we did that here, and next month we are rolling out an application that lets people send electronic letters to each other. You should see it! Very impressive considering our core business is building roads. All in all, I'd recommend your philosophy as a great approach to problem solving;-)

RE: Custom tags

2001-03-06 Thread BORKMAN Lee
Hi Kevin, for CustomTags called like , the apps server first looks in the local directory, then in the CustomTag directory or directories defined in the Registry. If you want greater flexibility in calling Custom Tags (eg if you are being hosted on a server where you don't have access to the Cus

RE: How to make recursion in CF

2001-03-06 Thread BORKMAN Lee
Hi George, You make recursive functions in CF just as you would in any language. Well, of course, CF doesn't yet have user-definable functions, but you can certainly make recursive Custom Tags. It may not always be the most efficient method, but it can be very effective when speed is not a vita

RE: Determine if a variable has a value

2001-03-05 Thread BORKMAN Lee
Hi Michael, I know you have tried it, but isDefined("variablename") is the basic method. The quotes are a common trap. COuld that be your problem? Good luck, Lee (Bjork) Borkman http://bjork.net ColdFusion Tags by Bjork -Original Message- From: Michael S. Kimmett [mailto:[EMAIL PROTECT

RE: Fast Track to ColdFusion Training - Who to use?

2001-03-05 Thread BORKMAN Lee
Hey, for my part, I'd recommend the amazing Hal Helm's courses, which teach you how to do it the smart way: www.coldfusiontraining.com/index.cfm?ref=bjork Best of luck, Lee "Ron Eberhard" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I have a friend who i

RE: reading lists over and over

2001-02-28 Thread BORKMAN Lee
Hi Jason, You can parse the file once and build your own query in RAM, or use a set of CF arrays or CF structures. More if you need it... have fun, Lee (Bjork) Borkman http://bjork.net ColdFusion Tags by Bjork -Original Message- From: Jason Egan [mailto:[EMAIL PROTECTED]] what I

RE: error - evaluate function in CF 4.0

2001-02-28 Thread BORKMAN Lee
Hi, I'm not sure how you are limited here. The evaluate() bits look fine to me. I do most of my work on CF4.01, and use evaluate like this all the time. Can you be more specific? Thanks, LBB. -Original Message- From: Gil Barden [mailto:[EMAIL PROTECTED]] I am trying to use the "eval

RE: Any RegEx wizards about??

2001-02-27 Thread BORKMAN Lee
An even simpler solution... Replace(form.EmailText,'"','','all') Magic. Good Luck, Lee (Bjork) Borkman http://bjork.net ColdFusion Tags by Bjork -Original Message- From: Edward Chanter [mailto:[EMAIL PROTECTED]] > > Replace(form.EmailText,,"","all") will work just fine > >

RE: Threaded Discussion App with Tree view...??

2001-02-22 Thread BORKMAN Lee
Thanks Jeff, thanks everyone. This is the one I was thinking of. I'll look closer at SimpleMessageBoard as well. Thanks for all your help, people, LeeBB. -Original Message- From: Jeff Sarsoun [mailto:[EMAIL PROTECTED]] Try this one. http://www.coldfusiontags.com/message_board/index.c

Threaded Discussion App with Tree view...??

2001-02-21 Thread BORKMAN Lee
Hi all, A year or so back, I ran across a CF app for building multiple threaded discussions. I seem to recall that you couldn't download a demo, and you couldn't buy it with credit card over the net (around $US100, I think). However, it looked fantastic, showed full tree views of threads, includ

RE: A new replacement for CFPARAM tag, huzzah!!!!

2001-02-21 Thread BORKMAN Lee
Yes, somewhat ;-) But that will depend upon your teams procedures and standards. I would suggest that you should always pass parameters explicitly, but if you don't (silly you!) then this tag can go looking for relevant "global" variables, and make some semi-intelligent guesses. In essence, thi

A new replacement for CFPARAM tag, huzzah!!!!

2001-02-20 Thread BORKMAN Lee
Hi all, I've built a new CF_Param custom tag to be used in the place of CFPARAM. It does exactly the same thing, except you get to provide a "search list" of variable names. If one these variables exists, then its value will be used instaed of the default. Take a look on http://Bjork.net/tagga

RE: Changing form names

2001-02-18 Thread BORKMAN Lee
Hi Les, I'm sure everyone will suggest that you don't use CFUPDATE. It is very restrictive, because it ties the names of your form fields to the names of your database fields (as you know). You really want to break the direct relationship between database and form. In other words, the design o

WireFrames Development Demo OnLine

2001-02-16 Thread BORKMAN Lee
Hi all, I've been doing a bit of work with Hal Helms' very useful WireFrames utility. I've put up a working demo at http://bjork.net/wireframe/index.htm, so you can all see and comment. It's got a few new twists, but the main difference is that there is no database required at the back-end.

WHOOPS!! (RE: loop and # sign as a part of form object)

2001-01-28 Thread BORKMAN Lee
How embarrassing!! That should have read: You do use evaluate() here, but evaluate() takes a string argument: #evaluate("form.qty" & x)# -Original Message- From: BORKMAN Lee [mailto:[EMAIL PROTECTED]] WOW, some wild and whacky answers to this one!! You do use evalua

RE: loop and # sign as a part of form object

2001-01-28 Thread BORKMAN Lee
WOW, some wild and whacky answers to this one!! You do use evaluate() here, but evaluate() takes a string argument: #evaluate(form.qty & x)# Best of luck, Lee (Bjork) Borkman http://bjork.net ColdFusion Tags by Bjork -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECT

RE: Rule of Thumb

2001-01-22 Thread BORKMAN Lee
One sentence? Okay: #s are ONLY needed within a string or a block of text/HTML, to show that the enclosed content needs to be evaluated. Examples of strings include: - double-quoted tag attributes - stuff inside - double-quoted expressions on the left or right of a CFSET's equals-sign NOT inc

RE: Content Management software which works with CF

2001-01-22 Thread BORKMAN Lee
Hi Andrea, I fought my way through the HTML. It looks like you want source control for CF projects? I'd take a good look at ComponentSoftware's RCS. The single-user licence is free, it integrates with CFStudio beautifully, and is a piece of cake for day-to-day use. You can upgrade to a full-f

RE: random record

2001-01-17 Thread BORKMAN Lee
Hi Mark, howzit going? ;-) Actually, I think your method (choosing a random number between 1 and MaxID, then going for the first record >= MaxID) could lead to some very non-random behaviour when you have large gaps in your IDs. The first ID after a large gap will be heavily over-used. I still

RE: random record

2001-01-16 Thread BORKMAN Lee
Hi Jeremy, there are many ways, but this is the easiest I have found: SELECT * FROM testTABLE #data# Cache the query for better performance. Best of luck, Lee (Bjork) Borkman http://bjork.net ColdFusion Tags by Bjork -Original Message- From: Jeremy Bunton [mail

RE: Query with nested hierarchy

2001-01-04 Thread BORKMAN Lee
Have you been following the Nested Trees discussion on the Fusebox list? Look for a Subject like "Re: animated tutorials". Or just go to Secretagents.com/training, and have a look at Steve Nelson's tutorial on storing hierarchies in a database. VERY interesting, have fun, Lee (Bjork) Borkman

RE: How to force CFOUTPUT to display results horizontally

2001-01-04 Thread BORKMAN Lee
Hi Britta, Just remember that EVERYTHING between the CFOUTPUT tags gets repeated for every row in the query. This includes any whitespace, eg new lines. So to get the output on a single line, don't put any new lines between your tags: #img# As long as #img# has no new lines, you'll be right,

RE: Adding items to Shopping cart

2001-01-02 Thread BORKMAN Lee
Well, yeah. The most basic approach is like this: 1) on your form, make a text box for each product, and name the text field quantity_XXX, where XXX is the product ID; 2) on your form-handler, loop through all of the form fields. If fieldName is of the form "quantity_XXX", and the value of the

RE: "Creating" Variables?

2000-12-28 Thread BORKMAN Lee
Hi Richard, I'd go for this: You can use isDefined("variable#v#") to check for the existence of the variable if you don't want to set a default value. Lee (Bjork) Borkman http://bjork.net ColdFusion Tags by Bjork -Original Message- From: Richard Gilbert [mailto:[EMAIL PROTECTED]]

RE: Regular Expression in CF

2000-12-28 Thread BORKMAN Lee
Hi Brandon, BEWARE!!! A RegExp of this kind, .*, will pick up everything from the start of your FIRST , through to the close of your LAST