Re: Flex is out
FORGET flex! Go Laszlo! I was sick of waiting for flex since the beta list was so small so I've been playing around with Laszlo (LPS) for a while. It rocks! I figured Flex would be priced out of range of us small guys and of course it is. I actually thought it would start at about $5000 per cpu which is way out of range of us small guys but it's even more than I imagined. I had previously noted: But, since MM gives away the Flash player and Sells The IDE, I think anything that provides an alternative to buying the IDE is a competitor, No? Well, yes, if this were really an alternative IDE. Laszlo does not have an IDE that I see. They assume you'll use another IDE to code your Laszlo applications (which is fine by me). Further, from what I read on various mailing lists from the true Flash pros, most of *them* don't even use the Flash IDE for most of their development work (most of which is in ActionScript). See how use Eclipse as a Laszlo IDE at: http://www.laszlosystems.com/developers/community/forums/showthread.php?s=threadid=751 One thing I haven;t been able to determine is what LZ (Hate typing Laszlo) sells -- and how much it costs. They sell the J2EE EAR/WAR file that contains the Laszlo engine. It's akin to how Macromedia (most likely) will be offering the Flex engine when it's done (integration with Blackstone aside, perhaps). As for price, they seem to be like any other vendor who sells a pricey productyou have to work through a sales person to negotiate cost! Macromedia does with with products like Breeze, for example. Laszlo has changed their pricing/version model. For most of it's life they just had the Enterpise Edition which was out of reach of small guys. Just a few weeks ago they were selling the Professional Edition for $995 (or $999) and the Enterprise Edition for $2495 (or $2499). Last week they rebranded the Professional Edition as the Express Edition and changed the price to $1999 and you now have to call the for pricing on the Enterprise edition. They probably had a run on the Pro edition and realized they could get more for it plus they must of had wind of the Flex pricing. In version 2 of the Developer Edition it supported simultaneous connections from up to 2 remote IP addresses per hour.In version DE 2.1 that was released the other day they changed it to support simultaneous connections from up to 5 remote IP addresses per hour. Last week they also released the Non-Commercial Edition which is free for no-commercial use. That should make it a hit with non-profits other non-commercial uses. With the outrageous pricing of Flex and considering most of my clients are non-profits then Laszlo is for me. I'll be deleting the idea Flex from my memory now. PC [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Weigh in on strategies for developing advanced search capabilites(FULLTEXT or NOT or BOTH)
I am working on developing search capability for a site that is sort of an online bookmarking tool. So among other things, users are adding links and notes, etc. to a SQL server db via web site driven by coldfusion. I adding the search functionality -- there are 2 needs that are somewhat contradictory (perhaps!). 1) The more advanced matching capabilities of FULLTEXT (proximity etc.) 2) The need to search for items JUST ADDED -- ie., a bookmark that a user may have added only minutes before. All seems well and good implementing FULLTEXT except that if a user needs to find somethign they just added to the db, it will not appear in the results unless the FULLTEXT index has been updated. Some questions: 1) How do people calculate how often a FT index can be updated w/out having an adverse effect on performance (I know, this is hard to answer generally). 2) Is it common and are there good techniques for combing FULLTEXT and regular SQL select queries to combine the best of both worlds... ? HAs anyone combined the 2 successfully? IS this a common approach? Thanks for weighing in... -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Current Row in SQL as opposed to CF? [CF-Talk]
IS there a way to do get the current row as part of a select statement in a similar fashion as the coldfusion #queryname.currentrow# property functions in a CFOUTPUT context? What I need are results that look like: Category 1 Sports Category 2 Languages Category 3 Reference Category 4 Politics from a query looking something like: SELECT TOP 4 Category + ?currentrow? + Category_title So what property exists, or technique for generating the ?currentrow? part of the statement above Now, I cannot use the indentity field .. I don't want values like Category 2 ... Category 19 ... And ... I cannot use a CFOUTPUT or CFLOOP -- I want to do it all in the SQL statement if possible!! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Current Row in SQL as opposed to CF? [CF-Talk]
I am using SQL Server 7. I can use CFOUTPUT I suppose. What I need to do is set the results to a variable and write that as part of a file. I am a little unclear on how I would even use CFOUTPUT in this fashion -- can I somehow set the output to a variable? CFOUTPUT query="getcategories" "Category" #currentrow# #Category_Title# /cfoutput I need this in a variable that is part of a few variables concatenated and written to a file using CFFILE write Thanks for anymore insight... :) Not in standard SQL. This operation would be at odds with the relational view of data, in which data is intrinsically not ordered. So if there is a way of doing it that would work in a single CFQUERY, it's going to be be DBMS-specific. If you happen to be using PostgreSQL you might be able to to create a user-defined function in 'C' to do it, but that would be crazy. But if you can't use CFOUTPUT, why does it matter what the results look like? What exactly are you trying to do? Nick -Original Message- From: PC [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 20, 2000 2:07 PM To: [EMAIL PROTECTED] Subject: Current Row in SQL as opposed to CF? [CF-Talk] IS there a way to do get the current row as part of a select statement in a similar fashion as the coldfusion #queryname.currentrow# property functions in a CFOUTPUT context? What I need are results that look like: Category 1 Sports Category 2 Languages Category 3 Reference Category 4 Politics from a query looking something like: SELECT TOP 4 Category + ?currentrow? + Category_title So what property exists, or technique for generating the ?currentrow? part of the statement above Now, I cannot use the indentity field .. I don't want values like Category 2 ... Category 19 ... And ... I cannot use a CFOUTPUT or CFLOOP -- I want to do it all in the SQL statement if possible!! -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Current Row in SQL as opposed to CF? [CF-Talk]
If I use CFLOOP -- do I just keep appending to the string I am creating ... Ie., CFLOOP query="getcategory" CFSET myvar = myvar "Category " getcategory.currentrow getcategory.title /CFLOOP ...or is there a more efficient append function to use with the variable? Thanks for the help! Use CFLOOP instead of CFOUTPUT combined with your CFFILE operation. Keep in mind that the currentrow variable will be determined as an incrementing number from 1 to recordcount, and is only indicative of the physical order in which the query was returned to CF based on your SQL statement. DC -Original Message- From: PC [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 20, 2000 14:40 To: [EMAIL PROTECTED] Subject: Re: Current Row in SQL as opposed to CF? [CF-Talk] I am using SQL Server 7. I can use CFOUTPUT I suppose. What I need to do is set the results to a variable and write that as part of a file. I am a little unclear on how I would even use CFOUTPUT in this fashion -- can I somehow set the output to a variable? CFOUTPUT query="getcategories" "Category" #currentrow# #Category_Title# /cfoutput I need this in a variable that is part of a few variables concatenated and written to a file using CFFILE write Thanks for anymore insight... :) Not in standard SQL. This operation would be at odds with the relational view of data, in which data is intrinsically not ordered. So if there is a way of doing it that would work in a single CFQUERY, it's going to be be DBMS-specific. If you happen to be using PostgreSQL you might be able to to create a user-defined function in 'C' to do it, but that would be crazy. But if you can't use CFOUTPUT, why does it matter what the results look like? What exactly are you trying to do? Nick -Original Message- From: PC [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 20, 2000 2:07 PM To: [EMAIL PROTECTED] Subject: Current Row in SQL as opposed to CF? [CF-Talk] IS there a way to do get the current row as part of a select statement in a similar fashion as the coldfusion #queryname.currentrow# property functions in a CFOUTPUT context? What I need are results that look like: Category 1 Sports Category 2 Languages Category 3 Reference Category 4 Politics from a query looking something like: SELECT TOP 4 Category + ?currentrow? + Category_title So what property exists, or technique for generating the ?currentrow? part of the statement above Now, I cannot use the indentity field .. I don't want values like Category 2 ... Category 19 ... And ... I cannot use a CFOUTPUT or CFLOOP -- I want to do it all in the SQL statement if possible!! -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --=_NextPart_000_01B0_01C02310.14845680 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEADTITLERe: Current Row in SQL as opposed to CF? = [CF-Talk]/TITLE META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.3018.900" name=3DGENERATOR/HEAD BODY DIVnbsp;/DIV DIVnbsp;/DIV DIVnbsp;/DIV DIVFONT color=3D#
String Appending [CF-Talk]
I am wondering if there's a better way to build up a string in a CFLOOP than to use a statement such as.. cfloop cfset myvar = myvar stringvar /cfloop My experience with this kind of looping append is that it is inefficient because the variable continues to grow and must be copied in memory each time it grows bigger per loop. I can seem to find an append function in CF... is there one? Or is there a better way to do it? Perhaps using listappend function or somesuch? JUst looking for any comments if anyone understands/knows what I am dealing with here... thx! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
[CF-Talk] OT: SQL current row in select statement
IS there a way to do get the current row as part of a select statement in a similar fashion as the coldfusion #queryname.currentrow# property functions in a CFOUTPUT context? What I need are results that look like: Category 1 Sports Category 2 Languages Category 3 Reference Category 4 Politics from a query looking something like: SELECT TOP 4 Category + ?currentrow? + Category_title So what property exists, or technique for generating the ?currentrow? part of the statement above Now, I cannot use the indentity field .. I don't want values like Category 2 ... Category 19 ... And ... I cannot use a CFOUTPUT or CFLOOP -- I want to do it all in the SQL statement if possible!! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT SQL 7 FULL-TEXT more than one column?
I know you can assign more than one column in setting up a fulltext index on a table -- but it seems like you can't include more than one column in the where CONTAINS statement...if this is indeed true how do you create a query to search thru all of the columns you have included in the fulltext indexing of a given table? An example would be highly appreciated! TIA -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
performance of listlast()
I have been using the listlast() function to get the last element in varchar strings such as: "\1\3\8\12" eg., cfset mykey = listlast("\1\3\8\12", "\") I am wondering if this is the highest performing way of grabbing the last integer in these strings? I can't immediately think of another way -- but this a performance critical process and I want to make sure I am using thew highest performance function to get the result I need. TIA -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Page rendering time-How to monitor?
How and where can I find out how long a particular page in CF is taking to render? What settings do I have to enable and where is this info stored (if at all)...? TIA -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT: Good inexpensive NT Email Solution
I have a CF site/SQL 7 on a dedicated NT server. AM looking for an inexpensive (free?) way to setup POP email -- so that I can have up to 30 or so email addresses that map to the domain of the site. Don't know if anyone has experience that they could share -- suggesting something solid, easy to setup, etc. TIA -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
How to prevent the browser from REPOSTING
Is there a way to prevent the browser from reposting data to a page when the BACK button is hit... I have a page the automatically opens a new window using JS when it is downloaded, but I don't want this to occur if the user leaves the page and goes back to it. The first time the page is hit by the user is always after submission from a form -- so what I'd like is to distinguish between when the user has used the browser back button from when the user has submitted the form to hit the page? TIA -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
IIS/CF unable to download .exe files?
I have collocated server that I cannot seem to get to allow a download of an .exe file. I know the path is correct and I am trying to use the following link on a CF page .. a href=://mypath/myapplicationname.exe"Get Application/a When the link is click -- the browser just waits indefinitely and times out-- other type of files (suffixes) all seem to come through just fine. Is there some sort of permissions setting for types of files/suffixes ... on the server side I should know about -- what am I not doing that I should be? THX -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Version 4.5.1 memory leak fixed?
Thanks for all this great info! It would be very useful to hear back from you when you have any new news on this from your experiences/patches/etc. I am most concerned about Server at this point... Thanks again .. Depends if you are talking about the Server or Studio. When I installed 4.5.1 Studio on Windows 98, it crashed all of the time. Recently I wiped out my drive and installed Win2K Professional, and Studio now runs like a clock. That is probably because Win2K is very good at keeping memory leaks from crashing the OS. If you are using Windows98 on your workstation and you crash a lot, you could do what I did and pay Bill Gates to get Win 2K. It runs great and is very hard to crash. As for the CF 4.5.1 Server, it has given us a lot of problems running it on NT 4.0 SP6.What happens is the NT performance monitor spikes up to 100% usage. And our code is clean. We are not even doing really high zoot CF stuff here yet. At a CFUG conference I just went to in DC they said that CFHTTP can cause memory spikes like this, but we aren't even using that tag on this server (it is a development server). I have heard other CF admins complain about the memory spike too. Allaire JUST released a patch a couple of days ago, and we should have that installed here soon. I will let you know how it works. John McKown, VP of Business Services Delaware.Net, Inc. -Original Message- From: Peter Theobald [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 12, 2000 2:29 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Version 4.5.1 memory leak fixed? html font size=3On the Allaire support forum I think everyone reached a consensus that Windows-NT can handle the resource memory leak better. Cold Fusion Studio 4.5 crashes Windows-98 very quickly.br br At 02:20 PM 8/12/00 -0400, Ken Wilson wrote:br blockquote type=cite citeWorks great for me.br br Ken Wilsonbr br br br - Original Message -br From: PC lt;[EMAIL PROTECTED]gt;br To: lt;[EMAIL PROTECTED]gt;; lt;[EMAIL PROTECTED]gt;br Sent: Saturday, August 12, 2000 1:35 PMbr Subject: Version 4.5.1 memory leak fixed?br br br gt; Is this a stable platform yet?br gt;br gt; -- br br gt; Archives: a href="http://www.mail-archive.com/cf-talk@houseoffusion.com/" eudora="autourl"http://www.mail-archive.com/cf-talk@houseoffusion .com//abr gt; To Unsubscribe visitbr a href="http://www.houseoffusion.com/index.cfm?sidebar=listsamp;bod y=lists/cf_talk" eudora="autourl"http://www.houseoffusion.com/index.cfm?sidebar=li stsamp;body=lists/cf_talk/a orbr send a message to [EMAIL PROTECTED] with 'unsubscribe' inbr the body.br br -- br Archives: a href="http://www.mail-archive.com/cf-talk@houseoffusion.com/" eudora="autourl"http://www.mail-archive.com/cf-talk@houseoffusion .com//abr To Unsubscribe visit a href="http://www.houseoffusion.com/index.cfm?sidebar=listsamp;bod y=lists/cf_talk" eudora="autourl"http://www.houseoffusion.com/index.cfm?sidebar=li stsamp;body=lists/cf_talk/a or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. /font/blockquotebr br -font size=3--- ---br Peter Theobald, Chief Technology Officerbr LiquidStreaming a href="http://www.liquidstreaming.com/" eudora="autourl"http://www.liquidstreaming.com/abr [EMAIL PROTECTED]br Phone 1.212.545.1232 Fax 1.212.679.8032br /font/html -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Version 4.5.1 memory leak fixed?
Is this a stable platform yet? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
ValueList Question ...
I am a little unsure of the way this function works ... does it result in a comma delimited string purely? eg., if I alter a column from a query like cfset emailto = valuelist(#member.email#) Assuming there are say 5 email addresses in this result/email column... could I use #emailto# in the "To:" field of a CFMAIL email as is? Would it look like "[EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], etc.? TIA -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
FULL TEXT vs VERITY OPINIONS
What do you recommend -- what are the relative strengths of each? Appreciate the thoughts!! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Upgrade Issues (4-4.5) Resources??
I know a lot of discussion has occurred over time about problems and issues to be aware of with upgrading from CF 4.0 to CF4.51 ... but I need to consider this move now and wonder if there's any resources compiling this stuff, or if anyone feels they have the time ( :) ) to give a breakdown-overview of the main concerns. But ideally, there exists some excellent *web page*, whitepaper, or somesuch ... Thanks a lot. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Can JS be used in Coldfusion templates that are called by HTTP??
I want to use a javascript to pefrom a function on a CF variable that is being handled in a template that is not displayed in the browser but is called by an HTTP command ... will this work?? IS not JS handled in the browser and therefore this template will not be able to interpret the JS code?? TIA -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Fw: Passing CF variable to Javascript
- Original Message - From: PC [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 08, 2000 12:10 PM Subject: Passing CF variable to Javascript I know this must be on e of the most basic questions .. but hwo does on pass a variable to Javascript from CF and back? I just want to use the Javascript unescape() function to decode an URLencoded string stored in a variable called lKeystring Any tips?? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT: Confusion about URL/FORM encoding ... + vs %20
I am trying to resolve some confusion I have about encoding spaces in URLs -- Can somebody shed light on the difference between %20 and + If one uses a search FORM it appears that the browser translates to "+" any spaces from a text control ... but if one constructs a url with a variable such as ...index.cfm?desc=#description#the spaces in #description# are translated into %20's... If I am constructing a URL programatically to speak to a cgi -- should I encode with +'s or %20's ? TIA!! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
How to limit size of upload files using CFFILE??
Hi all, I was hoping there was an easy way to place a limit on the size of a file that would uploaded using CFFILE. Does one need javascript? or somesuch to look at the file on the client size before allowing the CFFILE? TIA -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
How to get part of string?
I must be missing something obvious -- but I need a function to set a variable to a range of characters within a string. I know the starting and ending indices -- how can I set a variable to the characters within that range? I don't see a function for that... THX -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: URL - UN - ENCODE - does this exist as function??
My question is this then. What do you need to decode it for? Just do .. it's a little complex to explain but has to do with custom software which is logging information that the software itself is encoding... was hoping to find a decode function in CF ... THX -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: How to limit size of upload files using CFFILE??
Thanks -- this is what I thought would be the only way -- don't like it much tho, because a user can attempt to send a massive file -- and it'd be nice to make this impossible .. I'll fish around for some code tho -- I would think Hotmail and Yahoomail and the like have some way of limiting the size of attachments before they're actually sent to the server... No, but you can upload the file to the server, check the filesize there, and delete if it is too large sending an error message back to the user that the file was rejected because it was over the max file size. I can send you code for this if you like. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT: appropriate SQL 7 licensing for CF website
Hi All, I am colocating an NT 4 server running coldfusion and SQL 7 for a web site. I need to know which version of sql 7 I should purchase for unlimited internet connections/not developer connections I seem to recall that it's different than the true UNLIMITED client version which retails for something like $30K ... is there something cheaper than that -- what do most people do for their web sites?? THX! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Verity Problems HELP needed
I am using Verity for the first time to index and search data in a SQL 7 db. I am following the simple setup guidelines etc. in FORTA's book and the problem is --very odd results. I have a table with thousands of names in it and searching for the letter "s" will come up with no results, or the letter "d" will come up with say 2. I should be getting hundreds of hits for these searches. . Is there some obvious setting that people often don't get right -- anyone had similar problems. Everything seems so straightforward to setup -- and I have triple-tested that my query brings back stuff. but not the verity search of the indexed query results... CFQUERY name="getnames" datasource="mydb" select firstname, lastname, id from member /query CFINDEX ACTION="refresh" collection="myVerity" key="id" type="custom" title="lastname" query="getnames" body="firstname,lastname" --- then on the results page ... CFSEARCH collection="myVerity" name="search" criteria="#form.criteria#" type="simple" cfoutput#search.recordcount#/cfoutput cfoutput query="getnames" #title# /cfoutput -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Weird Verity Problems
I am using Verity for the first time to index and search data in a SQL 7 db. I am following the simple setup guidelines etc. in FORTA's book and the problem is --very odd results. I have a table with thousands of names in it and searching for the letter "s" will come up with no results, or the letter "d" will come up with say 2. I should be getting hundreds of hits for these searches. . Is there some obvious setting that people often don't get right -- anyone had similar problems. Everything seems so straightforward to setup -- and I have triple-tested that my query brings back stuff. but not the verity search of the indexed query results... CFQUERY name="getnames" datasource="mydb" select firstname, lastname, id from member /query CFINDEX ACTION="refresh" collection="myVerity" key="id" type="custom" title="lastname" query="getnames" body="firstname,lastname" --- then on the results page ... CFSEARCH collection="myVerity" name="search" criteria="#form.criteria#" type="simple" cfoutput#search.recordcount#/cfoutput cfoutput query="getnames" #title# /cfoutput -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
JUST TEXT FROM HTML
Are there any CF functions or mechanisms for extracting just browser visible text from an HTML code block -- so all the HTML tags and such would be pulled out and just the remaining text would be left in the resultant string? TIA -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT - SQL question
Hey ... How do you do a query where all rows returned except in the case of duplicates, based on a name column, in which only the first is returned. So the query run against the following rows: NameOrderNum Fred21 Beth36 Fred76 Would return : NameOrderNum Fred 21 Beth 36 Much thanks!! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Distinct Help
Doesn't seem to be exactly -- what I want is to return all the rows from the member table, but exclude rows which have the same UserID. I think I was misleading in the example using "UserName" ... a better example would be where a 'comments' column exists and a single user could have made multiple comments ... So a query would return: UserID Comment 1Hello 2Goodbye from: UserID Comment 1Hello 2Goodbye 1I agree 1No way It is the syntax for this query that I can't get right THX How can I return rows without duplicates defined only by a single column? For example, I want to return rows that have no repeats of a certain column. If I use Select DISTINCT UserID from Member it works -- but I want to return more columns ... So when I go Select Distinct UserID, UserName from Member I don't get the filtering of repeat UserIDs that I need. MAke sense? Anyone know the syntax I need?? No it doesn't make sense really. If you have more than one UserName for each UserID, which I assume you do - otherwise the filtering would still be working - then if you want a full list of UserNames you're bound to get repeated UserID's. If you want a list of all UserID's that only have one UserName you could say SELECT UserID, count(UserName) FROM Member GROUP BY UserID HAVING count(UserName) = 0 but I'm not sure that's what you want... is it? Nick de Voil De Voil Consulting [EMAIL PROTECTED] Tel +44 20 8560 4373 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
ColfFusion Bookmark Parsing Code
Anyone know of any CF code for *parsing browser bookmarks* -- I'd like to import HTML bookmarks files using coldfusion import them into a SQL db that has tables for hierarchical organization of links. Any ideas of some custom tags or somesuch?? Much appreciated. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Sharing Violation Problem
I am using RDS and having trouble opening certain files on a shared server. I get a file can't be opened because of "sharing violation" -- but am pretty sure no one else is using these files at the time I try to to open them. Does anyone know what do to about this?? Much Thanks! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Mappings problem
I want to setp a mapping in CF ADMIN but am not clear from docs just how this works. I have the following: LOGICAL PATH: /rootmap/ DIRECTORY PATH: D:\209.344.22.151\mysite\ 3 questions: 1) is this looking right? 2) how do I reference this mapping in a CFINCLUDE? 3) Can I add to the end of this mapping in the CFINCLUDE is it something like? CFINCLUDE template="rootmap/blocks/dsp_myblock.cfm" TIA -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Parsing alg HELP needed
Worked!!! THANKS!!! - Original Message - From: David Gassner [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 05, 2000 11:23 PM Subject: RE: Parsing alg HELP needed I haven't tested this, but how about: cfloop list="x=1y=2" index="thisPair" delimiters="" cfset fieldname=listGetAt(thisPair, 1, "=") cfset fieldvalue=listGetAt(thisPair, 2, "=") cfhttpparam type="FORMFIELD" name="#fieldname#" value="#fieldvalue#" /cfloop -Original Message- From: PC [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 06, 2000 4:06 AM To: [EMAIL PROTECTED] Subject: Re: Parsing alg HELP needed This is helpful... but the one thing that is challenging is that I am not handling a form but instead a name value pair string like "x=1y=2" etc ... so I have to pull the pairs out and then also dynamically create and fill out CFHTTPPARAM tags ...I guess not the simplest thing...:) - Original Message - From: Tim Lieberman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 05, 2000 4:46 AM Subject: Re: Parsing alg HELP needed the keys are produced by the input names, and the values are user supplied data. Why not something like: cfset namelist= "" cfset valuelist="" cfscript ListAppend(namelist,"formfieldname1" ListAppend(valuelist,#form.formfieldname1" ListAppend(namelist,"formfieldname2" ListAppend(valuelist,#form.formfieldname2 ... ListAppend(namelist,"formfieldnameN" ListAppend(valuelist,#form.formfieldnameN /cfscript Of course, you might want to get tricky and make it dynamic. I suspect you can loop over the form scope and dynamically get all the names, etc. Hope this is what you want. At 02:25 AM 00/04/06 -0700, you wrote: I am trying to parse some name/value pairs that are POSTed in queries. I want to be able to recontruct searches basically and therefore need to be able to pull out the names and values in strings like the one below. Can anybody recommend approaches? Like which combination of functions in CF would best get me say two CF lists - one for names and one for values eg: NameList: (qt,qs,qc,ws) ValueList: (monkey,4,jog,0) is parsed from ... "qt=monkeyqs=4qc=jogws=0" THX! Dan - -- --- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. Tim Lieberman Take a break and have a listen, Electric Mind Control Do It NOW: Workshop Funk Bakery http://www.mp3.com/emcw -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- -- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists; body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Parsing alg HELP needed
I am trying to parse some name/value pairs that are POSTed in queries. I want to be able to recontruct searches basically and therefore need to be able to pull out the names and values in strings like the one below. Can anybody recommend approaches? Like which combination of functions in CF would best get me say two CF lists - one for names and one for values eg: NameList: (qt,qs,qc,ws) ValueList: (monkey,4,jog,0) is parsed from ... "qt=monkeyqs=4qc=jogws=0" THX! Dan -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.