Re: cflocking.. -- ATTENTION -- MY CASE STUDY
I totally agree with you Al. The final judgement should be on our shoulders. Give us the extra option and we will know which will be the best strategy for our unique situations. Even though I love speed, I would take stability any day. I don't mind a few a few milliseconds here and there but I do mind coming in to the server room on a weekend because the coldfusion service has stopped responding again. =) Adding cflocks aren't that bad at all but I would still like the option. I think allaire should concentrate on stability a little more to be honest. Xing From: "Al Musella, DPM" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Sat, 16 Sep 2000 20:57:26 -0400 To: [EMAIL PROTECTED] Subject: RE: cflocking.. -- ATTENTION -- MY CASE STUDY I read that paper, and still would like to have an option for automatic locking. Maybe add an attribute to the cfapplication tag: automatic locking: on |off The development time saved on it will more than offset the cost of a faster processor needed for the 2 or 3 microseconds added to each template that will be wasted:) And if you have a transaction problem or a performance problem, you can do it manually. The best of both worlds. I think this one issue is what made Turbobasic and quickbasic such a hit in the 80s and early 90s and VB now. You didn't have to worry about nit picky little things that could crash your program, but which would be easily automated. Developers were free to just worry about the logic. Do you agree with Allaire's reasoning? (By the way - I am a big fan of CF from way back in the 2.0 years.. Al Musella a1webs.com Yes, they explained why. See Allaire's recent paper, "ColdFusion Locking Best Practices" http://www.allaire.com/handlers/index.cfm?ID=17318Method=Full best, paul At 11:56 AM 9/16/00 -0400, you wrote: Why can't cold fusion just automatically lock them? Has Allaire ever responded on this issue? - - -- 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: ORDER BY in a UNION Query
Here's why:
Joe Celko writes in "SQL For Smarties" (2nd Ed., p230) that refering to a
column by its positional number is a deprecated feature in SQL-92,
meaning that it will be unavailable in the next SQL standard.
-David
On Wed, 19 Jul 2000 16:48:13 +0200 Paul Wakefield [EMAIL PROTECTED]
writes:
I was working in Oracle 7.3 - but I can't see why they'd disabled
that
facility on a later version.
--
Paul Wakefield
-Original Message-
From: Olive, Christopher M Mr USACHPPM
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 19, 2000 4:46 PM
To: '[EMAIL PROTECTED]'
Subject: RE: ORDER BY in a UNION Query
odd. last time i ported from informix (where i used the
column position) to
Oracle 8i, it barfed. strange. i'll have to try it again.
Chris Olive,
DOEHRS Website Administrator
-Original Message-
From: Paul Wakefield [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 19, 2000 10:14 AM
To: '[EMAIL PROTECTED]'
Subject: RE: ORDER BY in a UNION Query
Um, I've written many union queries on Oracle, and that's how
I've always
handled the Order By. It also seems to work on SQL Server.
Dunno about the
rest of the DB world.
--
Paul Wakefield
-Original Message-
From: Olive, Christopher M Mr USACHPPM
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 19, 2000 4:10 PM
To: '[EMAIL PROTECTED]'
Subject: RE: ORDER BY in a UNION Query
as a side note, this will not work in all DBs (eg, oracle)
Chris Olive,
DOEHRS Website Administrator
-Original Message-
From: Paul Wakefield [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 19, 2000 8:40 AM
To: '[EMAIL PROTECTED]'
Subject: RE: ORDER BY in a UNION Query
Try using column positions, rather than names, eg.
(You'll need to substitute appropriate column positions)
CFIF IsDefined('ordervalue')
CFIF ordervalue EQ "Name"
ORDER BY 2
CFELSEIF ordervalue EQ "Absence"
ORDER BY 4
/CFIF
/CFIF
--
Paul Wakefield
-Original Message-
From: Angél Stewart [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 19, 2000 2:30 PM
To: [EMAIL PROTECTED]
Subject: SQL: ORDER BY in a UNION Query
Hey folks :)
I'm trying to write a simple UNION query, between two
dynamically created
select queries.
Based on the feilds that the user entered in the previous
form, the SQL
statement's WHERE clauses are created.
Basically, I want to pull data from the current Employee Info
table, and the
Employee History table, for a report.
However, the user has the option of Ordering the report
either by name, or
by Absence Type.
When I stick the Order By statement at the end of the second
Select clause,
Oracle returns the error:
"[Microsoft][ODBC driver for Oracle][Oracle]ORA-00904:
invalid column name "
The column names Name and Reason *are* present in both
tables. I tried to
qualify these columns by using empinfo.name and
empinfo.reason, but this has
not helped.
Do any of you have a sample SQL statement that includes UNION
and an ORDER
BY clause?
:-)
CFIF IsDefined('ordervalue')
CFIF ordervalue EQ "Name"
ORDER BY empinfo.Name
CFELSEIF ordervalue EQ "Absence"
ORDER BY empinfo.Reason
/CFIF
/CFIF
(If order value is not selected, then the resulting recordset
will be sorted
according to Employee ID.)
-Gel
YOU'RE PAYING TOO MUCH FOR THE INTERNET!
Juno now offers FREE Internet Access!
Try it today - there's no risk! For your FREE software, visit:
http://dl.www.juno.com/get/tagj.
--
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.
Dreaded Location: 25 error
I know this has been touched on before but I forgot what the general agreement was on this topic. Can someone refresh me on this? Thanks in advance. For me, this error is directly attributed to volume. After a few days of heavy heavy volume, the servers goes cold with Location: 25. This is pretty "normal" for me and I would love to get rid of this. I have had this problem since 4.0 and on both NT and W2K (4.5.1 on W2K). Xing -- 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: Upload and retrieval of stories?
Chris; This problem is exactly what we have built a solution for in publishing Spank! Youth Culture Online (http://www.spankmag.com). We are also beginning to market the engine as a product called Lopedia. There are several fields for each entry - but importantly, we strip out all HTML and ASCII for submitted material (security reasons) and replace with a pseudo-code that we parse back with each story (submit a response to a thread - there's a link that shows all the pseudo-code). This way, we can change the parser to modify the look and feel of the text. This is also how we have the first word of each paragraph in the Spankopedia section (not the forums) Bold and +1 size. We are slowly moving over 350 old, full length features into the database from raw HTML files. Let's just say - If I had these in a database to begin with (OK - we started back in 1995), I would be a much happier boy. One thing though - I don't use fusebox and don't like the methodology all that well (OK - let the flames begin - you people do seem a little religious about dissenting voices), but it's a matter of personal choice. Do though DB it all. Right now. From the beginning. Stephen R. Cassady Publisher Cofounder, Spank! Youth Culture Online wb. http://www.spankmag.com em. [EMAIL PROTECTED] About Spankmag.com! - Launched 01 November 1995, Spank! Youth Culture Online is a flagship quality youth online-lifestyle magazine (http://www.spankmag.com), and the very first-ever of it's kind. Spank!s online services offer users cool reviews, informative features, opinions, contests, cartoons and areas to express their own thoughts and ideas. At the heart of Spank!s services is original, fresh, content built by a team of editors from North America and around the world. True to it's nature, Spank! leverages this talent into a peer to peer meeting of youth (14 - 26) from around the world. Free of censorship, open to ideas, Spank! weeds out the parental guidance side found in most youth journals designed by adults. Spank! is the playground and stepping stone for youth. For more information please contact us directly @ Stephen Cassady, [EMAIL PROTECTED] Date: Sat, 16 Sep 2000 12:08:23 -0800 From: "Chris Lott" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Upload and retrieval of stories? Message-ID: 024e01c02019$de0a92c0$6401a8c0@S003817 -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 My new site is related to this thread, so I would like to hear suggestions about the following issues. The site is largely dedicated to serving out a selection of poems, essays, stories, etc. I am trying to bridge the gap between relatively easy contributions and adequate performance when serving the file (aren't we all?). 1) Should I store the text with HTML formatting? Most of the items will have formatting needs (bold, italic, explicit line breaks, and of course paragraph breaks) and short of some kind of custom shorthand, HTML seems like the best way. 2) How should I deal with the input and splitting of longer stories: should the user submit the html/text file and then I will have CF split the file into different database entries using some algorithm for a word count and then split at the nearest sentence or paragraph break or ?? 3) Could someone explain how I might create tables to handle the split text? Should I just have a single table with title, partnum, text and then when displaying check if there is more than one partnum, or should I have a couple of tables? I'm starting to wonder if I should do this with a db-driven site at all :) But I've already been tied to doing a CF site with Fusebox, though the methodology is largely irrelevant. c -- 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: converting Word docs or PDF's to HTML
From: "Kevin Queen" [EMAIL PROTECTED] Easier way: open word choose File -- Save as Web Page (word 2k) -or- open word choose File -- Save As -- Change file type to *.htm (word 97) Makes messy code but if you are using word to edit the docs and not editing the html than this works like a charm ;} Warning though - if you ever have to write code that has to read in the html file and do something with the page - say a CFHTML, etc. - you are going to probably want to use software to clean up the HTML significantly first... -- Never apply a Star Trek solution to a Babylon 5 problem. Larry W. Virden mailto:[EMAIL PROTECTED] URL: http://www.purl.org/NET/lvirden/ Even if explicitly stated to the contrary, nothing in this posting should be construed as representing my employer's opinions. -- -- 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: Regular expressions . . . a good tutorial somewhere?
From: "Steve Bernard" [EMAIL PROTECTED] etc.. Also, be prepared to be frustrated because you'll find some great RegEx features that CF doesn't support because it has a half-ass, third-party RegEx library bundled into it. So what would it take to wrap code around Henry Spenser's regular expression library and turn it into a proper ColdFusion set of tags? -- Never apply a Star Trek solution to a Babylon 5 problem. Larry W. Virden mailto:[EMAIL PROTECTED] URL: http://www.purl.org/NET/lvirden/ Even if explicitly stated to the contrary, nothing in this posting should be construed as representing my employer's opinions. -- -- 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: My brain is fried, can someone give me some regular expression help please...
now you would think that would work, but it doesn't. when running the code below, you see that there are 51 tabs in the string. If you use listlen, you only get the tabs that have data between them which amounts to 34. - Original Message - From: "Jeff Beer" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, September 16, 2000 9:27 PM Subject: RE: My brain is fried, can someone give me some regular expression help please... How about: cfset nNumTabs = ListLen(sOrderFile, "#chr(9)#" -Original Message- From: Sean Renet [mailto:[EMAIL PROTECTED]] Sent: Saturday, September 16, 2000 10:38 PM To: [EMAIL PROTECTED] Subject: My brain is fried, can someone give me some regular expression help please... I have a character string, which is basically a tab delimited list. I need a regular expression that will count the tabs in the string and verify they are all there. Essentially, I would like a regular expression that does this: cfset sOrderFile = "123 75 w1234567890 GRD 8/17/00 Sean Renet Broadcast Dynamics 1230 MyStreet St. Los Angeles CA 90026 323-555-1212 [EMAIL PROTECTED] Amy Jones 1630 Your St. Apt. 2 Silverlake CA 90026 323-666-2137 323-555-4567 [EMAIL PROTECTED] Driver's liscence C13546545 1234 I387409-0983 2 A Bit of the Bubbly Hi Sean, Here is your champagne Hope you enjoy it! Amy Dane" cfset nLength = #Len(sOrderFile)# cfset nPosition = 0 !--- Position of tab in string --- cfset nNewPosition = 0 !--- Next position to start with after finding a tab --- cfset nNumTabs = 0 !--- Number of tabs. Return this variable --- cfset sTab = #Chr(9)# !--- Tab character --- !--- Go through the string --- cfloop condition="(#nNewPosition# LT #nLength#)" cfset nNewPosition = nPosition + 1 cfset nPosition = #Find(sTab,sOrderFile,nNewPosition)# cfif nPosition EQ 0 !--- No more tabs, done --- cfbreak /cfif cfset nNumTabs = nNumTabs + 1 !--- Start looking for new tab 1 position after last one --- /cfloop !--- Return nNumTabs here --- cfoutput#nNumTabs#/cfoutput -- -- -- 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.
Re: My brain is fried, can someone give me some regularexpression help please...
cfset intNumberOfTabs = Len(REReplace(sOrderFile, "[^::#chr(9)#::]", "", "ALL")) That did the trick, thanks. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, September 16, 2000 9:15 PM Subject: Re: My brain is fried, can someone give me some regularexpression help please... How about an RegEx that removes all characters that aren't tabs and then count the remainder. If CF's RegEx engine supported \t it would be really easy. You'll have to substitute something legit for "::TAB::". I tried something like, REReplace(strOrderFile, #Chr(9)#, "", "ALL") in the past and I seem to remember that it blew up. Let me know if you find something that works. - Set strOrderFile = " ... " - Set intNumberOfTabs = Len(REReplace (strOrderFile, "[^::TAB::]", "", "ALL")) or, with Array conversion -- 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: My brain is fried, can someone give me some regular expression help please...
now you would think that would work, but it doesn't. when running the code below, you see that there are 51 tabs in the string. If you use listlen, you only get the tabs that have data between them which amounts to 34. Hey Allaire, are you reading this? How about ListLen(List, 38, "allownulls") (see the other thread on "Null values within lists") -- Aidan Whitehall [EMAIL PROTECTED] The Net Profits Internet Services ColdFusion website development, domain names, hosting and tuition Tel: +44 (0) 1695 50050 (North West England) -- 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.
outputting from a stored query
How do you output a particular value from a query? I have stored a query as application.companynames This query currently contains 3 columns: id, name, description If I know the particular id of the company I am looking for, and application.companynames contains every company in the database, how do I output the company's name? I know this is easy to do with lists (listgetat) but how do I do it from a query that can contain multiple columns? Cheers Seth This message has been checked for all known viruses, by Star Internet, delivered through the MessageLabs Virus Control Centre. For further information visit: http://www.star.net.uk/stats.asp -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF hosting needed
I, too, am in need of CF hosting for testing purposes, so I am benefiting from the original question. But I do have one to add . . . can I expect that CF hosts will utilize such allow CFDirectory and CFRegistry. And should I expect that they have sandboxes enabled? I'm using sitehosting.net right now, and they have disallowed all of the above. Thank you . . . BJS Barbara J Smith Consulting http://www.bjsconsulting.com [EMAIL PROTECTED] 651.365.0822 -- 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: My brain is fried, can someone give me some regular expression help please...
Ahh - I misunderstood your original questions. I thought you were counting the pieces of data, and verifying that the data was present, not the total number of tabs. I'll read more carefully next time :) -Original Message- From: Sean Renet [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 17, 2000 4:25 AM To: [EMAIL PROTECTED] Subject: Re: My brain is fried, can someone give me some regular expression help please... now you would think that would work, but it doesn't. when running the code below, you see that there are 51 tabs in the string. If you use listlen, you only get the tabs that have data between them which amounts to 34. - Original Message - From: "Jeff Beer" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, September 16, 2000 9:27 PM Subject: RE: My brain is fried, can someone give me some regular expression help please... How about: cfset nNumTabs = ListLen(sOrderFile, "#chr(9)#" -Original Message- From: Sean Renet [mailto:[EMAIL PROTECTED]] Sent: Saturday, September 16, 2000 10:38 PM To: [EMAIL PROTECTED] Subject: My brain is fried, can someone give me some regular expression help please... I have a character string, which is basically a tab delimited list. I need a regular expression that will count the tabs in the string and verify they are all there. Essentially, I would like a regular expression that does this: cfset sOrderFile = "123 75 w1234567890 GRD 8/17/00 Sean Renet Broadcast Dynamics 1230 MyStreet St. Los Angeles CA 90026 323-555-1212 [EMAIL PROTECTED] Amy Jones 1630 Your St. Apt. 2 Silverlake CA 90026 323-666-2137 323-555-4567 [EMAIL PROTECTED] Driver's liscence C13546545 1234 I387409-0983 2 A Bit of the Bubbly Hi Sean, Here is your champagne Hope you enjoy it! Amy Dane" cfset nLength = #Len(sOrderFile)# cfset nPosition = 0 !--- Position of tab in string --- cfset nNewPosition = 0 !--- Next position to start with after finding a tab --- cfset nNumTabs = 0 !--- Number of tabs. Return this variable --- cfset sTab = #Chr(9)# !--- Tab character --- !--- Go through the string --- cfloop condition="(#nNewPosition# LT #nLength#)" cfset nNewPosition = nPosition + 1 cfset nPosition = #Find(sTab,sOrderFile,nNewPosition)# cfif nPosition EQ 0 !--- No more tabs, done --- cfbreak /cfif cfset nNumTabs = nNumTabs + 1 !--- Start looking for new tab 1 position after last one --- /cfloop !--- Return nNumTabs here --- cfoutput#nNumTabs#/cfoutput -- -- -- 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. -- 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: Upload and retrieval of stories?
Where? I couldn't find it. best, paul At 01:45 AM 9/17/00 -0600, you wrote: (submit a response to a thread - there's a link that shows all the pseudo-code). -- 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.
Regular expressions
This regular expression CFSET variables.TextFile = REReplace(variables.TextFile, ",,", ", ,", "all") turns this valuevalue into value, ,, ,value when I want it to be turned into value, , , ,value Can anyone alter it so that it works as needed? Thanks if you can :-) -- Aidan Whitehall [EMAIL PROTECTED] The Net Profits Internet Services ColdFusion website development, domain names, hosting and tuition Tel: +44 (0) 1695 50050 (North West England) -- 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: CF hosting needed
The reason many of those features are turned off is because of security concerns. You have to balance shared hosting with good security while providing good service. Hosting companies that just open up the entire server are likely to be very unreliable. Sandboxing is also only available under CF Enterprise which costs something like $5,000 per server. So many hosting companies use Pro ($1,500) which doesn't have sand boxing. If you need every feature turned on in CF, then your best solution is to go with a dedicated or collocated server that you have full control over and more importantly, no one else does. - Steve -Original Message- From: Barbara J. Smith [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 17, 2000 9:04 AM To: [EMAIL PROTECTED] Subject: Re: CF hosting needed I, too, am in need of CF hosting for testing purposes, so I am benefiting from the original question. But I do have one to add . . . can I expect that CF hosts will utilize such allow CFDirectory and CFRegistry. And should I expect that they have sandboxes enabled? I'm using sitehosting.net right now, and they have disallowed all of the above. Thank you . . . BJS Barbara J Smith Consulting http://www.bjsconsulting.com [EMAIL PROTECTED] 651.365.0822 -- 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: CF hosting needed
Anyone have any comments on the CFFILE replacements in Allaire's tag gallery, CFX_File CFX_Secure_Functions? It appears to me they introduce password protection, but not other functions that would be nice such as directory restriction by password, no *.EXE, etc, that would bring functionality up to FTP capability. Any other tags around? best, paul At 12:38 PM 9/17/00 -0400, Steve Pierce wrote: The reason many of those features are turned off is because of security concerns. You have to balance shared hosting with good security while providing good service. Hosting companies that just open up the entire server are likely to be very unreliable. -- 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.
Two Selects Related - Problem
Has anyone had a problem with the two selects related tag where it gets hung up and eats up all of the CPU. If you have, can you please tell me how you fixed it. I am using CF Enterprise server 4.5.1 TIA DDINC -- 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.
Query problem
Hi, I'm probably being stupid here but can someone please help me on my query? It's displaying the correct results - but more than once: cfquery name="cats" datasource="localads" SELECT ID, cat_name, sub_name, sub_id, catid FROM categories, sub_categories WHERE sub_categories.catid = #url.cid# /cfquery Cfoutput#cats.cat_name# - Sub Cats:/cfoutput Cfoutput query="cats"#sub_name#br/cfoutput Any help appreciated. Will -- 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.
Help
Sorry to bother the list with newbie stuff but I have the following simple piece of code that strips off the ending pound sign. Simple syntax error for sure. Help please. table border ="0" width="50%" align="center" trtda href="selpn.cfm?userid=#userid#"Request Another Inventory Item/a/tdtda href="default.cfm"Enter Another User ID/a/td/tr /table -- 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: Query problem
You're missing a relationship between the categories and subcategories tables Guessing : WHERE ( categories.catid = sub_categories.catid) AND (sub_categories.catid = #url.cid#) Jeff Craig - Original Message - From: "W Luke" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, September 17, 2000 2:28 PM Subject: Query problem Hi, I'm probably being stupid here but can someone please help me on my query? It's displaying the correct results - but more than once: cfquery name="cats" datasource="localads" SELECT ID, cat_name, sub_name, sub_id, catid FROM categories, sub_categories WHERE sub_categories.catid = #url.cid# /cfquery Cfoutput#cats.cat_name# - Sub Cats:/cfoutput Cfoutput query="cats"#sub_name#br/cfoutput Any help appreciated. Will -- 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: Help
CF variables need to be within a cf statement or within certain CF tags, to be evaluated, e.g.: cfoutput./cfoutput cfquery../cfquery so, use: trtda href="selpn.cfm?userid=cfoutput#userid#/cfoutput"Request Another Inventory or cfoutput table border ="0" width="50%" align="center" trtda href="selpn.cfm?userid=#userid#"Request Another Inventory Item/a/tdtda href="default.cfm"Enter Another User ID/a/td/tr /table /cfoutput Before you ask, #myVar# is evaluated as the value of myVar ## is recognized as a single # within these tags - ##anchor = #anchor Dick At 3:28 PM -0400 9/17/00, Alan Wolf wrote: Sorry to bother the list with newbie stuff but I have the following simple piece of code that strips off the ending pound sign. Simple syntax error for sure. Help please. table border ="0" width="50%" align="center" trtda href="selpn.cfm?userid=#userid#"Request Another Inventory Item/a/tdtda href="default.cfm"Enter Another User ID/a/td/tr /table -- 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: Query problem
On 9/17/00, W Luke penned: Hi, I'm probably being stupid here but can someone please help me on my query? It's displaying the correct results - but more than once: cfquery name="cats" datasource="localads" SELECT ID, cat_name, sub_name, sub_id, catid FROM categories, sub_categories WHERE sub_categories.catid = #url.cid# /cfquery Yeah Luke. Jeff's right. Any time you query for results from more than one table, you have to do some sort of join on all the tables involved. WHERE categories.catid = sub_categories.catid and sub_categories.catid = #url.cid# If you have 3 tables, same thing. FROM table1, table2, table3 WHERE table1.id = table2.id and table2.id = table3.id and table3.id = #form.id# -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- 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: Regular expressions
Did you try using it twice? CFSET variables.TextFile = REReplace(variables.TextFile, ",,", ", ,","all") CFSET variables.TextFile = REReplace(variables.TextFile, ",,", ", ,","all") or even CFSET variables.TextFile = REReplace(REReplace(variables.TextFile, ",,", ", ,","all"), ",,", ", ,","all") to make it really confusing tom - Original Message - From: "Aidan Whitehall" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, September 17, 2000 10:35 AM Subject: Regular expressions This regular expression CFSET variables.TextFile = REReplace(variables.TextFile, ",,", ", ,", "all") turns this valuevalue into value, ,, ,value when I want it to be turned into value, , , ,value Can anyone alter it so that it works as needed? Thanks if you can :-) -- Aidan Whitehall [EMAIL PROTECTED] The Net Profits Internet Services ColdFusion website development, domain names, hosting and tuition Tel: +44 (0) 1695 50050 (North West England) -- 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: CF hosting needed
Paul, I encountered this problem when I used a CF hosting service with these tags disabled. For me the solution was simple. Since most CF hosts will be using Windows NT, you can most certainly expect them to support ASP. All you'll have to do is to write an ASP template using FileSystemObject object to open a file, and then use CFHTTP to access that ASP template and to return the file as cfhttp.content, which you can then manipulate as a string. I have a partially written custom tag for this, and I can send this to you. THat is, if I can find it... Hope this helps. Leong At 10:17 AM 9/17/2000 -0700, you wrote: Anyone have any comments on the CFFILE replacements in Allaire's tag gallery, CFX_File CFX_Secure_Functions? It appears to me they introduce password protection, but not other functions that would be nice such as directory restriction by password, no *.EXE, etc, that would bring functionality up to FTP capability. Any other tags around? best, paul At 12:38 PM 9/17/00 -0400, Steve Pierce wrote: The reason many of those features are turned off is because of security concerns. You have to balance shared hosting with good security while providing good service. Hosting companies that just open up the entire server are likely to be very unreliable. -- 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: Extranet's
Rif, I'm not certain how you're using the term, "extranet." If you mean access by a limited number of people outside your firewall (not the whole world), then it's basically similar to your intranet with some extra security considerations. How much access you give the extranet users should probably depend on their relationship to your organization. What do you want them to know? What do you want them to be able to do? I'd recommend putting your extranet users in the same table with your employees. An extra column could differentiate between the two. Since they're coming in from outside, you might also want to provide logins for them. HTH, --John Allred Rif Kiamil wrote: Dear All, I am current designing our 2nd Intranet and we know it about a years time where are going to have Extranet users. I just want to know. Would u develop a total separate system for Extranet users or give then access to only parts of the Intranet? Any ideas about Security and database design e.g. We have a User Table and Employees table. Users are employees that have access to the intranet. Where would u put the extranet users in the users table and employees table or create there an extranet user table. Rif Rif Kiamil Head of Network Admin / Project Coordinator of Intranet Web Based Applications JJ Fast Food Distribution LTD Tele 020 8885 9218 / Fax 020 8885 9213 -- 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. -- John Allred / Jackson, Mississippi Accessibility Resources: HWG's AWARE site - http://aware.hwg.org/ W3C's WAI site - http://www.w3.org/WAI/ Campaign for a Non-Browser-Specific WWW - http://www.anybrowser.org/campaign/ -- 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: cflocking.. -- ATTENTION -- MY CASE STUDY
html font size=3I agree. The article claims they don't automate locking for (1) performance issues. Well, if I do all the same locks by hand the performance will be WORSE, and (2) to give the developer the option to do less granular locks. How about giving me the option to set a manual lock but otherwise automatically locking it?br br This issue is going to become a major problem as scores of unsophisticated Cold Fusion developers create sites that crash. Cold Fusion will get a reputation for being unstable NO MATTER that it is the developer's fault.br br At 08:57 PM 9/16/00 -0400, Al Musella, DPM wrote:br br blockquote type=cite citenbsp;nbsp;nbsp; I read that paper, and still would like to have an option for automatic br locking. Maybe add an attribute to the cfapplication tag:nbsp; automatic br locking: on |offbr nbsp;nbsp;nbsp; The development time saved on it will more than offset the cost of a br faster processor needed for the 2 or 3 microseconds added to each template br that will be wasted:)nbsp; And if you have a transaction problem or a br performance problem, you can do it manually. The best of both worlds.br nbsp;nbsp;nbsp;nbsp; I think this one issue is what madenbsp; Turbobasic and quickbasic such a br hit in the 80s and early 90s and VB now. You didn't have to worry about nit br picky little things that could crash your program, but which would be br easily automated.nbsp; Developers were free to just worry about the logic.br br Do you agree with Allaire's reasoning?br nbsp;nbsp; (By the way - I am a big fan of CF from way back in the 2.0 years..br br Al Musellabr a1webs.combr br br Yes, they explained why.nbsp; See Allaire's recent paper,br gt;quot;ColdFusion Locking Best Practicesquot;br gt;a href="http://www.allaire.com/handlers/index.cfm?ID=17318amp;Method=Full" eudora="autourl"http://www.allaire.com/handlers/index.cfm?ID=17318amp;Method=Full/abr gt;br gt;best,nbsp; paulbr gt;br gt;At 11:56 AM 9/16/00 -0400, you wrote:br gt; gt;Why can't cold fusion just automatically lockbr gt; gt;them? Has Allaire ever responded on this issue?br gt;br gt;--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;body=lists/cf_talk" eudora="autourl"http://www.houseoffusion.com/index.cfm?sidebar=listsamp;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.
RE: MS SQL 7 Varchar
I believe this happens when you upsize from Access and the original Access field is Text (255). -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Friday, September 15, 2000 10:19 AM To: [EMAIL PROTECTED] Subject: MS SQL 7 Varchar I've got a MS SQL 7 table with some fields defined as Varchar(510). When I retrieve them in CF Pro 4.01 via ODBC, they get truncated to 255 characters. Is there a reason for this? How about a workaround? Jim -- 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.
RE: CF hosting needed
I encountered this problem when I used a CF hosting service with these tags disabled. For me the solution was simple. Since most CF hosts will be using Windows NT, you can most certainly expect them to support ASP. All you'll have to do is to write an ASP template using FileSystemObject object to open a file, and then use CFHTTP to access that ASP template and to return the file as cfhttp.content, which you can then manipulate as a string. Just as a word of warning, providers of ASP shared hosting who are concerned about security will disable this object for obvious reasons. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- 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: MS SQL 7 Varchar
Thanks for the help. That may be the case when upsizing, but this database wasn't. Actually, I found the answer elsewhere - it's because I was using older ODBC drivers that aren't MS SQL 7 aware. In SQL 6.5 varchar fields have a limit of 255 characters, while in SQL 7 the limit is 8000. Jim -Original Message- From: stas [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Sunday, September 17, 2000 6:06 PM Subject: RE: MS SQL 7 Varchar I believe this happens when you upsize from Access and the original Access field is Text (255). -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Friday, September 15, 2000 10:19 AM To: [EMAIL PROTECTED] Subject: MS SQL 7 Varchar I've got a MS SQL 7 table with some fields defined as Varchar(510). When I retrieve them in CF Pro 4.01 via ODBC, they get truncated to 255 characters. Is there a reason for this? How about a workaround? Jim --- - -- 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. -- 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: CF hosting needed
Well, I'm on the hosting end of the equation. My issue is a way to enable CFFILE-like function for my customers without enabling any more security problems than I already have with FTP. You've just given me one more reason I'll never enable ASP on my servers (apart from the fact I don't have the time or patience to deal with more than one CF-like product). best, paul At 08:44 AM 9/18/00 +0930, you wrote: Paul, I encountered this problem when I used a CF hosting service with these tags disabled. For me the solution was simple. Since most CF hosts will be using Windows NT, you can most certainly expect them to support ASP. All you'll have to do is to write an ASP template using FileSystemObject object to open a file, and then use CFHTTP to access that ASP template and to return the file as cfhttp.content, which you can then manipulate as a string. -- 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.
Sandboxing Info
I'm running CF Enterprise but cannot figure out how to implement the sandboxing security. Does anyone know where I can find some reference material which is a little less cryptic than the CF manual. --Bill -- 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: WHOIS queries
From: "seth ward" [EMAIL PROTECTED] What's the most efficient way of running a WHOIS for a domain name searching website using Coldfusion? I know I can use CFHTTP to plug into the registrar's facility, but can I not use a command-line facility or something else to get faster results? www.geektools.com You can get their whois proxy sourcecode - it's the best tool as it is written to automatically do the lookups in the proper registry -- 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: My brain is fried, can someone give me some regular expression help please...
This has been discussed with Allaire many times in the both the Allaire public and beta forums, they claim that there would not be any reason to allow for null counting. Yet I haven't found a reason why we shouldn't, or even any occasion we would not need to count nulls:-) regards Andrew Scott ANZ eCommerce Centre * Ph 9273 0693 * [EMAIL PROTECTED] -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: 17 September 2000 20:05 To: [EMAIL PROTECTED] Subject: Re: My brain is fried, can someone give me some regular expression help please... now you would think that would work, but it doesn't. when running the code below, you see that there are 51 tabs in the string. If you use listlen, you only get the tabs that have data between them which amounts to 34. Hey Allaire, are you reading this? How about ListLen(List, 38, "allownulls") (see the other thread on "Null values within lists") -- Aidan Whitehall [EMAIL PROTECTED] The Net Profits Internet Services ColdFusion website development, domain names, hosting and tuition Tel: +44 (0) 1695 50050 (North West England) -- 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: WHOIS queries
What's the most efficient way of running a WHOIS for a domain name searching website using Coldfusion? I know I can use CFHTTP to plug into the registrar's facility, but can I not use a command-line facility or something else to get faster results? If you want to talk DIRECTLY to a whois (or offically a "nicname") server you can use tcp or udp. It's a simple process. You open a tcp connection, send it the keyword you wish to look up, it sends you back the results, connection closes. That's that. You can use my CFX_TCPClient to roll your own, or use my already built CFX_Nicname. CFX_Nicname uses tcp. You could convert to UDP to save the maximum amount of bandwidth, but as udp doesn't have error correction, that's generally a bit of a hassle. This is as fast and tight as you can go. --min -- 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: WHOIS queries
You can try CFX_NicName from http://www.intrafoundation.com/freeware.html or cfx_odswhois from http://www.coolfusion.com/cfx_odswhois.cfm. Both are freeware and the first one comes with source... It's not pretty source code, but... hey. -fat albert -- 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.
CFPOP's MessageNumber
If I do a CFPOP with ACTION="GetAll" and then later do an ACTION="Delete", how does CF keep track of which message I'm referring to? What if in the meantime another process had deleted one or more of the messages returned in the original call to CFPOP - will message #10 still be the message I thought it was? I suspect it will simply be the 10th message returned by the mail server whenever the delete action is run and the wrong one message would be deleted from the server. A variation on this, which is what I'm trying to do: I'd like to have a CF program, using CFPOP, retrieve messages from a mailbox, _not_ delete the messages, then in subsequent runs, retrieve only new messages (similar to the way an email client might operate)? I understand the STARTROW attribute, but once again, it doesn't seem to address starting at a specific message, simply at the Nth message. What if messages had been deleted since the last program execution - won't that throw this STARTROW point off? Is there any other way of identifying a specific message and saying "retrieve every message after this one"? Thanks, Jim -- 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: My brain is fried, can someone give me some regular expression help please...
It would definitely be nice if there was a parameter that told it to act like a real list, not a tokeniser. You know, for those uncommon tasks like... reading a tab-delimited file. ;) There's already a tokeniser in there anyway (GetToken). Dave "Scott, Andrew" wrote: This has been discussed with Allaire many times in the both the Allaire public and beta forums, they claim that there would not be any reason to allow for null counting. Yet I haven't found a reason why we shouldn't, or even any occasion we would not need to count nulls:-) regards Andrew Scott ANZ eCommerce Centre * Ph 9273 0693 * [EMAIL PROTECTED] -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: 17 September 2000 20:05 To: [EMAIL PROTECTED] Subject: Re: My brain is fried, can someone give me some regular expression help please... now you would think that would work, but it doesn't. when running the code below, you see that there are 51 tabs in the string. If you use listlen, you only get the tabs that have data between them which amounts to 34. Hey Allaire, are you reading this? How about ListLen(List, 38, "allownulls") (see the other thread on "Null values within lists") -- Aidan Whitehall [EMAIL PROTECTED] The Net Profits Internet Services ColdFusion website development, domain names, hosting and tuition Tel: +44 (0) 1695 50050 (North West England) -- 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.
Re: cflocking.. -- ATTENTION -- MY CASE STUDY
say, there is a cool regex example in Ben's "Advanced Cold Fusion (Green)" book dealing with ParamaterExists() Anyone want to build one for Locking? -- 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: Upload and retrieval of stories?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 One thing though - I don't use fusebox and don't like the methodology all that well (OK - let the flames begin - you people do seem a little religious about dissenting voices), but it's a matter of personal choice. Do though DB it all. Right now. From the beginning. Thanks for the advice. I am working on a completely db driven solution as we speak. I'm not wedded to Fusebox, though I have found that it has helped me in many ways (being the disorganized kind of illiterate programmer that I am, having a method of any kind has been a boon!), it has also slowed me down in others, primarily because I think good beginner documentation is sparse, or at least good beginner documentation of the kind *I* need! c - -- Chris Lott -BEGIN PGP SIGNATURE- Version: PGP 6.5.8 for message encryption and authentication: USE PGP! Comment: PGP KeyID: 0x51046CFD iQA/AwUBOcWqjtaLYehRBGz9EQIX1ACdEUsxiMIZDeO42AdM2sZRkIvSfgAAoMWX LaPRkp/T+qsh1o//vLVPI2Po =rC5Q -END PGP SIGNATURE- -- 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: cfapplet problem
-Original Message- From: Deva Ramesh [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 13, 2000 6:01 PM To: '[EMAIL PROTECTED]' Subject: cfapplet problem Hi all Actually i am trying to place one java applet on my browser. so that i down loaded one applet from the net and saved that class file in /cfide/classes/allaire/controls path. after that i registred that class file in coldfusion administrator applet page also. And i have written following to code in cold fusion.. CFFORM ACTION="snow.cfm" CFAPPLET appletsource="snow" NAME="snow" /CFFORM when i am executing the progrom, i could n't see picture. but when i click on applet then it is going to site from where i down loaded. has any body faced this type of problem? Thanx in advance. ramesh -- 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.
