RE: Stripping CRs and LFs

> What is the best way to strip CRs and LFs from a string? Should do the trick. - Sean ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-

RE: HTTPS setup

> The key's all set up properly, but it just finds nothing if you > browse to it... > we've set the SSL port to be 443 in IIS, so it should know it > exists. We've also > set the IP and headers with that port. > > We're definitely using the URL the key was registered for. > > Any ideas? You aren'

RE: Multiple Servers - Cluster Cats

> Does anyone have any experience setting up Cluster Cats or any other solid > backup/failover server system? ClusterCats is a software based web server load balancing service. It will do you absolutely no good if your DB server dumps it's motherboard again. For true fault tolerance you would ne

RE: LARGE QUERY RETURNS

> Ok I have found that when i return alot of returns to a page, > 5000+ it adds > quite a bit of time to the processing on the CF side with displaying the > information as opposed to it being database bottleneck. My guess is that it's less of a CF issue and more of a bandwidth issue. Like, how la

RE: CF-Studio 4.52

> Actually I was think of writing a little VB app that would allow > you to save > all studios settings as wddx ,would many people be interested in this? Ooh. That would be a beautiful thing. Having to recustomize every time I reinstall the OS or switch machines is tedious. I would love to be abl

RE: CF-Studio 4.52

OK, so I really want to update to 4.5.2, particularly for the "remembering that your in an RDS session". However, I have customized the crap out 4.5.1 and I am scared off by these mails that say the 4.5.2 installer kills your snippet and hotkey settings. Is there any way to back these up? Or have

RE: SQL Dropdown List

Remember, you don't HAVE to use the sortby for each row (you were already onto that with your grouping idea. Just set the field default to like 99 and then only specify a sortby value for rows you want at the top. You can order by more than one column too, so order by "sortby" first, then "countr

RE: SQL Dropdown List

I usually add a "sortby" field to all my lookup tables. Make it a smallint and then populate it with 1,2,3,4,5 depending on the way you want the Dropdown sorted. Then just do one query and order by "sortby". This gives youthe most flexibility. If you want Boston at the top for some reason, you can

RE: Another debate

> The need to deliberate the issue further is a mute point." Ouch. Does he/she mean "moot" point perhaps? I feel for you. - Sean ~~~~~~~~ Sean Daniels Manager, Engineering Marketplace Technologies (t) 207.439.6030

RE: ??

om the IP address of your CF machine? If not, that's why your mail fails. Good luck. - Sean ~~~~~~ Sean Daniels Manager, Engineering Marketplace Technologies (T): 207.363.7374 (C): 207.332.6340 ~~ http://www.dealforce.com http://www.mer

RE: SQL 7.0 Question

The statement should be: DELETE from auction_records where auction_id='#id#' and userid='#userid#' - Sean ~~~~~~~~ Sean Daniels Manager, Engineering Marketplace Technologies (t) 207.439.6030 (c) 207.332.6340 ~~

RE: ? -> /

The custom tag does almost exactly that. You can get it at www.fusebox.org. - Sean ~~ Sean Daniels Manager, Engineering Marketplace Technologies (T): 207.363.7374 (C): 207.332.6340 ~~ http://www.dealforce.com http

RE: CFMAIL Fails to Send

blem before too, but I was positive they were running 4.5.1. Now I check and see they are running 4.5.0. Must have reinstalled for some reason. Thanks! - Sean ~~~~~~~~~~ Sean Daniels Manager, Engineering Marketplace Technologies (T): 207.363.73

CFMAIL Fails to Send

the IT guy at the company the SMTP service is working. - Sean ~~ Sean Daniels Manager, Engineering Marketplace Technologies (T): 207.363.7374 (C): 207.332.6340 ~~ http://www.dealforce.com http://www.mergernetwork.com

RE: Studio - left panel missing

anyone advise? Press F9 ? - Sean ~~~~~~~~ Sean Daniels Manager, Engineering Marketplace Technologies (t) 207.439.6030 (c) 207.332.6340 http://www.dealforce.com http://www.dealstream.com htt

cfmail headers

IMS is out. I can only use coldfusion custom tags that can be called with cfmodule. TIA. - Sean Sean Daniels Manager, Engineering Marketplace Technologies (t) 207.439.6030 (c) 207.332.6340 http://www.dealforce.com http

RE: Input type = arrrrh!

ape = true; } // form field params fieldsize.text = iif(netscrape,20,40); fieldsize.textarea = iif(netscrape,30,60); I only do this for Netscape vs. IE, but the concept could be expanded to account for the Mac versions as well, methinks. - Sean ~~~

RE: Jsstringformat

('#id#','#jsstringformat(recordname)#') Thanks for the help, Courtney. - Sean ~~ Sean Daniels Manager, Engineering (T): 207.439.6030 (C): 978.764.0799 ~~ http://www.dealforce.com http://www.mergernetwork.com

RE: Jsstringformat

> > > (escape single quotes by replacing them with \') But are single quotes the only evil things I need to watch out for? If so, woo hoo! But I kind of doubt it? - Sean ~~~~~~ Sean Daniels Manager, Engineering (T): 207.439.6030 (C)

Jsstringformat

I've gotten in the habit of using jsstringformat in several of my apps. Now I've got one that I have to deploy in a CF 4.01 environment. Anyone out there have a custom tag or regex expression that will accomplish the same thing? TIA - Sean ~~~~~~ Sean Daniels

HTML Email Tracking

t run though. All it does by the way is increment a counter in a db table. TIA - Sean ~~~~~~ Sean Daniels Manager, Engineering (T): 207.439.6030 (C): 978.764.0799 ~~ http://www.dealforce.com htt

RE: Time Zone Select

Thank you very much, this will work beautifully. By the way, I liked the map suggestion too, but not practical for the GUI implementation. Thanks. - Sean ~~ Sean Daniels Manager, Engineering (T): 207.439.6030 (C): 978.764.0799 ~~ http

Time Zone Select

Anyone out there have a custom tag or data table that would allow me to easily include a select box for choosing time zone? TIA - Sean ~~ Sean Daniels Manager, Engineering (T): 207.439.6030 (C): 978.764.0799 ~~ http://www.dealforce.com

RE: conditional where statement

r for any of those statements. Try: select * from tbl where 1=1 or id = #id# or name = #name# or 1=1 - Sean ~~~ Sean Daniels Manager, Engineering Marketplace Technologies (T) 207.439.6030 (C) 978.764.0799 ~~~

RE: Web servers

ou need to install IIS 5 from the Windows 2000 CD. Just stick the CD in and click "Add Components" or something like that. IIS should be the one selected by default. By the way, if you are running Win2k Pro, as opposed to Server, you will only be able to host one site with IIS. - Sean

CF Groupware

I am looking for a groupware solution written in CF, preferably open source. Anyone have any recommendations? Primarily I need calendar, task management, discussion functionality. TIA. - Sean Sean Daniels Manager, Engineering Marketplace Technologies [EMAIL

RE: file name

t I cannot find it .. onrequestend.cfm - Sean ~~~~~~~~ Sean Daniels Manager, Engineering Marketplace Technologies [EMAIL PROTECTED] tel: 207.439.6030 cel: 978.764.0779 http://www.dealforce.com http://www.dealstream.com http://www

RE: accessing SQL Stored Procedures?

cs for the tags. - Sean ~~~~~~~~ Sean Daniels Manager, Engineering Marketplace Technologies [EMAIL PROTECTED] tel: 207.439.6030 cel: 978.764.0799 http://www.dealstream.com http://www.mergernetwork.co

RE: SQL Question

ean ~~~~ Sean Daniels Manager, Engineering Marketplace Technologies [EMAIL PROTECTED] tel: 207.439.6030 cel: 978.764.0799 http://www.dealstream.com http://www.mergernetwork.com http://www.dealforce.

RE: appropriate SQL 7 licensing for CF website

ersion which retails for > something like $30K ... is there something cheaper than that -- what do > most people do for their web sites?? I have purchased the internet connector license for each SQL 7 server I run. - Sean ~~~~~~~~ Sean Daniels Manager, Engineering

RE: Custom Tag for Date and Time

> why not just insert > > '#DateFormat(Now())# #TimeFormat(Now())#' Or, you can use the RDMS native function. I'm not sure how widely supported this is, but for example in MS-SQL you can use: insert into table (datefieldname) values (getdate()) - Sean ~

RE: SQL and apostrophes

uery: last_name = '#lname#' ... - Sean Sean Daniels Manager, Engineering Marketplace Technologies [EMAIL PROTECTED] tel: 207.439.6030 cel: 978.764.0799 http://www.dealstrea

RE: Results from several like tables

le are the same you can "UNION" them I think. - Sean ~~~~~~~~ Sean Daniels Manager, Engineering Marketplace Technologies [EMAIL PROTECTED] tel: 207.439.6030 cel: 978.764.0779 http://www.dealforce.com http://www.dealstream.com http://www.m

RE: Picture Cache

ent that contains the images to preload. - Sean ~~~~ Sean Daniels Manager, Engineering Marketplace Technologies [EMAIL PROTECTED] http://www.dealstream.com http://www.mergernetwork.com tel: 207.439.6

RE: CF Won't allow access to CFM files

ous account IIS uses has script permission (RX) on the directory. Also, make sure that the web service --> Properties --> Home Directory --> Script Source Access is checked. (?) Not sure about that second one. Hope this helps. - Sean ~~~~ Sean Daniels

RE: My solution:Variable IN a list? How to check?

the problem? > :-) This is what I would have suggested. One way to make it slightly more elegant (eloquent, whatever) would be to stuff that code into a custom tag. Then whenever you need to authorize, just call the custom tag: - Sean Sean Daniels M

RE: A join table question

gn key in the history table. That makes a lot of sense. Thanks to everyone for the feedback. - Sean ~~~~ Sean Daniels Manager, Engineering Marketplace Technologies [EMAIL PROTECTED] http://www.dealstream.com http://www.mergernetwork.com te

OT: A join table question

anks in advance for any advice. - Sean ~~~~ Sean Daniels Manager, Engineering Marketplace Technologies [EMAIL PROTECTED] http://www.dealstream.com http://www.mergernetwork.com

RE: Dymanic Menu

tter in IE 5 than Netscrape, but, what are you gonna do? - Sean ~~~~ Sean Daniels Manager, Engineering Marketplace Technologies [EMAIL PROTECTED] http://www.dealstream.com http://www.mergernetwork.com tel: 207.439.6030

RE: Form.Fieldnames Missing

Are you using the method="post" attribute in the form tag? Another suggestion would be to scrutinize how the form and /form tags are nested. Anything weird there? Otherwise, try posting the code here, maybe that would reveal something. - Sean ~~~~ Sean Danie

RE: Textarea

some of the articles are rather long for a normal > text field. Textarea doesnot have a value attribute. Use the following: #body# It is also useful to apply the trim() function to the body variable, to prevent any addition whitespace. - Sean Sean Daniels Manag

RE: Selecting a value in a dropdown.

op? One way to do this: #i# week/year or, less complicated looking: #i# week/year #i# week/year Hope this helps. - Sean ~~~~ Sean Daniels Manager, Engineering Marketplace Technologies [EMAIL PROTECTED] http://www.dealstre

RE: CFMAIL running only once an hour

. There were a number of cfmail related problems in 4.5.0. If you already have 4.5.1, go to the admin page, click Mail under Miscelleneous, and change the "Spool Interval" to 15. It will then send spooled mail every 15 seconds. - Sean ~~~~ Sean Daniel

RE: OT: IIS sharing on IP address

, so if you are using SSL, you need a distinct IP address for each site. - Sean ~~~~ Sean Daniels Manager, Engineering Marketplace Technologies [EMAIL PROTECTED] tel: 207.439.6030 cel: 978.764.0779 http://www.dealforce.com http:

CFMAIL Alternatives

Sean Daniels Manager, Engineering Marketplace Technologies [EMAIL PROTECTED] http://www.dealstream.com http://www.mergernetwork.com tel: 207.439.6030 cel: 978.764.0779 -- Archives

RE: Replacing line breaks and paragraph breaks with HTML equivelents

> ReplaceNoCase(strClean, "", Chr(13),"ALL") > > What am I missing. Try this: ") Or, even easier: HTH - Sean ~~~~ Sean Daniels Manager, Engineering Marketplace Technologies [EMAIL PROTECTED] http://www.dealstrea

RE: Parsing text in memo field to recognize web addresses

o that string to > make the link 'clickable' within the text. > > Is this too far out there? Curt, I have a custom tag that will do this. Contact me off list if you are interested. - Sean Sean Daniels Manager, Engineering Marketplace Technologi

RE: Allaire's strategy re CF???

ect me if I'm wrong, but it sounds like a great leap forward to me. And I currently know very fundamental Java (although I want to learn and use it more). - Sean ~~~~~~~~ Sean Daniels Manager, Engineering Marketplace Technologies [EMAIL PROTECTED] http://www.deals

RE: hex values

nd ASCII to hex conversions? I have a Java book with conversions in the appendix and you are correct. 0x1C is ASCII 28. - Sean ~~~~~~~~ Sean Daniels Manager, Engineering DealStream.com [EMAIL PROTECTED] http://www.dealstream.com tel: 207.439.6030 ce

RE: Add single quotes to each element on a list

> Code are passed as > selState = 'AL,AK,AS,AZ,AR,CA,CO,CT,DC,DE,FL,GA' > > I wonder if there is a way to make the list like > selState = 'AL','AK','AS','AZ','AR','CA','CO','CT','DC

RE: Proper Case?

o Titlecase and works like a champ. - Sean ~~~~ Sean Daniels Manager, Engineering DealStream.com [EMAIL PROTECTED] http://www.dealstream.com tel: 207.439.6030 cel: 978.764.0779 --

WOT: IIS Bizarreness

documented problem? TIA. - Sean ~~~~ Sean Daniels Manager, Engineering DealStream.com [EMAIL PROTECTED] http://www.dealstream.com tel: 207.439.6030 cel: 978.764.0779 -

RE: weird CF error or not weird but i have never seen it.

I saw this once. It happened when the name of the first query was the same as the variable name. Is the name of your first query "project" by any chance? If so, you are overwriting the variable with the query structure. - Sean ~~~~ Sean Daniels Manager, E

RE: Blue arrow on CF Studio project folders

e properties. There are two toggles for auto-including all files and all sub-folders. The subfolders take on the properties of the parent unless told otherwise. - Sean ~~~~~~~~ Sean Daniels Manager, Engineering DealStream.com [EMAIL PROTECTED] http:/

RE: Question from a Studio 4.01 user

d find / replace dialog is to search through an entire project. My guess is that this would be painfully slow in a remote situation. - Sean ~~~~~~~~ Sean Daniels Manager, Engineering DealStream.com [EMAIL PROTECTED] http://www.dealstream.com tel:

RE: HTML Form Submit button troubles

27;ll end up having to do anyway. Good luck. - Sean ~~~~ Sean Daniels Manager, Engineering DealStream.com [EMAIL PROTECTED] http://www.dealstream.com tel: 207.439.6030 cel: 978.764.0779 --

RE: DISPLAY QUESTION

d be aware of it. > > ...just thought it was interesting -emily That is interesting indeed. Thanks for the research! - Sean ~~~~~~~~ Sean Daniels Manager, Engineering DealStream.com [EMAIL PROTECTED] http://www.dealstream.com tel: 207.439

RE: DISPLAY QUESTION

> I have a varchar field size 255 in sql. I want to display only > the first 6 > words in this field. How do I go about doing that? Treat the string as a list - delimited by spaces: #newWords# - Sean ~~~~ Sean Daniels Manager, Engineering DealS

RE: Format Output

> Can info be formatted someway when called like this? Tim, You can use the function: htmleditformat(myVariable) Good luck and welcome aboard. - Sean ~~~~ Sean Daniels Manager, Engineering DealStream.com [EMAIL PROTECTED] http://www.dealstream.

RE: CFLOOP list="Query.Value" ??

ink all he's missing are the #'s. - Sean Sean Daniels Manager, Engineering DealStream.com [EMAIL PROTECTED] http://www.dealstream.com tel: 207.439.6030 cel: 978.764.0779 -- Archives

RE: nesting queries??

do this? > Thanks inadvance You can use loops instead: - Sean Sean Daniels Manager, Engineering DealStream.com [EMAIL PROTECTED] http://www.dealstream.com tel: 207.439.6030 cel: 978.764.0779 -

RE: CFLOOP list="Query.Value" ??

te. Like: Also, WOW! That's a long index name! Don't you get fairly sick of typing that? - Sean Sean Daniels Manager, Engineering DealStream.com [EMAIL PROTECTED] http://www.dealstream

RE: Any known stability issues with CF Server 4.5 on NT?

> Is there a handy URL for getting the 4.5.1 update? I poked around > Allaire's site and came up empty. http://beta.allaire.com - Sean ~~~~ Sean Daniels Manager, Engineering DealStream.com [EMAIL PROTECTED] http://www.dealstream.com ~

RE: Are 4.5 mail spooler woes fixed in 4.5.1?

tever the latest release candidate is. (knock on wood). However, I've heard others on this list say 4.5.1 didn't fix their mail issues. I'd bet it's worth a try on a non-production box though. I think the only other sure fix is to roll back to 4.0.1. - Sean ~~

RE: CF Quiz

aphic I don't understand why it's taking that > long. I had the same experience. It was a great quiz, well thought out and a nice interface, but damn, that two minute wait between questions was painful. - Sean Sean Daniels Manager, Eng

RE: PROBLEM with SingleQuote in SQL evaluate Insert

> INSERT INTO test_tbl > string = '#evaluate("formstring#stringTypeID#")#' How about: INSERT INTO test_tbl string = '#preservesinglequotes(evaluate("formstring" & stringtypeid))#' - Sean Sean Daniels Manager,

RE: grrr... cookies~

Are you using in the same script that you set the cookie? If so, this is your problem. will not work when followed by . Yu should use a javascript redirect or meta refresh instead. > -Original Message- > From: Jason Egan [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 06, 2000 3:12

RE: CFLOCATION/IE4

> Can anyone tell me why it takes IE4 forever to bring up this > dynamic path. IE5 and NS4 flys to it with no problem. The > DataChunks.DCNAME variable is generated by a query. > > url="../datachunks/#Trim(DataChunks.DCNAME)#/index.cfm" addtoken="No"> The last time a had a problem like this was

RE: Style Sheets and Netscape 4.x

CSS is true, however, it's interpretation of the spec is weak. I've found that a ton of IE stuff doesn't come out right in Netscape. Oh well. - Sean ~~~~~~~~~ Sean Daniels Manager of Engineering DealStream, Inc. [EMAIL PROTECTED]

RE: same form-based page for edit and display?

"good thing" as Martha Stewart would say. - Sean ~~~~~ Sean Daniels Manager of Engineering DealStream, Inc. [EMAIL PROTECTED] ~ tel: 207.439.6030 cel: 978.764.0799 Fax: 240.269.6319 > -Original Message- > From: [

Re-ordering rows in a table

to reinvent the wheel. Thanks, - Sean ~~~~~ Sean Daniels Manager of Engineering DealStream, Inc. [EMAIL PROTECTED] ~ tel: 207.439.6030 cel: 978.764.0799 Fax: 240.269.6319 -- Archives: http://www

RE: RDS share violation

ality is hardly trivial. - Sean ~~~~~ Sean Daniels Manager of Engineering DealStream, Inc. [EMAIL PROTECTED] ~ tel: 207.439.6030 cel: 978.764.0799 Fax: 240.269.6319 -- Archives: http:

RE: RDS share violation

submitted bugs to the beta forum, but haven't gotten much response. I wish I could believe that all this is due to the fact that I'm using a beta, but I just don't have the confidence that all these issues will be fixed. Oh well, it's still a superior tool. It's nice to ve

RE: Duplicate Values in a query

is helps. - Sean ~~~~~ Sean Daniels Manager of Engineering DealStream, Inc. [EMAIL PROTECTED] ~ tel: 207.439.6030 cel: 978.764.0799 Fax: 240.269.6319 -- Archives: http://www.eGroups.c

RE: Automated Error pages

pplication Construction Kit. - Sean ~ Sean Daniels Manager of Engineering DealStream, Inc. [EMAIL PROTECTED] ~ tel: 207.439.6030 cel: 978.764.0799 Fax: 240.269.6319 -- Archives: h

RE: Navbar icons

. All you need to do is put the icon you want to use in the root of your web site directory and name it "favicon.ico". IE 5 takes care of the rest. - Sean ~ Sean Daniels Manager of Engineering DealStream, Inc. [EMAIL PROTECTED] ~ tel

RE: querying date in a date-time field.

e(varDate) :-) SELECT * FROM myTable WHERE myDateTime >= #createodbcdate(varDate)# and myDateTime < #createodbcdate(dateadd("d",1,varDate))# Have fun. - Sean ~ Sean Daniels Manager of Engineering DealStream, Inc. [EMAIL PROTECTED]

RE: CFID/CFTOKEN as a Unique DB Identifier

s creates a "Universally-Unique" id value with a mask of ---. It's a handy thing, but make sure you are running at least CF 4.01. CreateUUID() was introduced in that version. - Sean ~~~~~ Sean Daniels Manager of Engineeri

RE: sql list syntax

nd your form field was 'bolts', the record would match. Is that what your are trying to do? - Sean ~~~~~ Sean Daniels Manager of Engineering DealStream, Inc. [EMAIL PROTECTED] ~ tel: 207.439.6

RE: Server_Name

. Then the rest of the site is built around those variables. - Sean ~ Sean Daniels Manager of Engineering DealStream, Inc. [EMAIL PROTECTED] ~ tel: 207.439.603

RE: CFMail issues

tuation, I feel your pain. - Sean ~~~~~ Sean Daniels Manager of Engineering DealStream, Inc. [EMAIL PROTECTED] ~ tel: 207.439.6030 cel: 978.764.0799 Fax: 240.269.6319 -- Archiv

RE: Uploading and IE 5

> Maybe you noticed, but the submit button in this code is all > wrong, it should > say: > > :> > > That may sort it out.. > > :> -Original Message- > :> ENCTYPE="multipart/form-data"> > :> http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion

<    1   2