Adrian,
On 22/01/07, Adrian Wagner [EMAIL PROTECTED] wrote:
The only real 'negative' we found/find is that the updates seem to be a
bit, ahm, let's say undisciplined. We currently use FarCry 3.02 - and
while there are still a few open issues that Deamon could work on...they
already work on
While the session ends for the user, the variables persist in memory
until the end of the session timeout. How is the server to know when
the user closed the browser? Sessions are maintained via cookies -
what that sentence in the manual means is that instead of writing a
cookie that lives when
I'd say that an authentication scheme that relies solely on the
browser to provide authorization info is badly broken.
On 1/27/07, Bruce Sorge [EMAIL PROTECTED] wrote:
Good point. It ain't broke so I am not going to try and fix it, just improve
on it a little.
--
CFAJAX docs and other useful
Thank you James: Agree, but the sessions are scheduled to expire after one
hour
cfapplication name=#prefix#_blog_#blogname#
clientManagement = no
setClientCookies = no
setDomainCookies = no
loginStorage = session
sessionManagement = yes
sessionTimeout = #CreateTimeSpan(0,1,0,0)#
Hi,
I'm looking for an open source webmail app written in CF that I can
integrate into my existing contact management system that I have already
written in CF. I know about inFusion Mail Server, but right now, I'm
looking just for a webmail app that works with ANY POP account.
Suggestions?
One thing I didn't clarify - I would like to have something current
preferably, that takes advantage of CFC's and maybe even some OO principles.
Also, it must be open source, but does NOT have to be free.
Dave
-Original Message-
From: Dave Phillips [mailto:[EMAIL PROTECTED]
Sent:
Novice question here.
I need to write a query to find a single integer in a field of delimited
integers, say 23,25,27,29. How is this done in Cold Fusion? FindOneOf?
FindNoCase? Can anyone advise?
Thanks in advance for any help,
Les
Les Irvin wrote:
Novice question here.
I need to write a query to find a single integer in a field of delimited
integers, say 23,25,27,29. How is this done in Cold Fusion? FindOneOf?
FindNoCase? Can anyone advise?
In CF, you would probably use ListFind...but are you trying to find this
Les,
Are you writing a query to find this in a database? If so, what db are you
using?
Or, are you just trying to use CF code to find it in text?
Dave
-Original Message-
From: Les Irvin [mailto:[EMAIL PROTECTED]
Sent: Saturday, January 27, 2007 12:11 PM
To: CF-Talk
Subject: Querying
I'm trying to find it using sql within a cfquery tag, that's why I'm
stumped.
On 1/27/07, Jim Wright [EMAIL PROTECTED] wrote:
Les Irvin wrote:
Novice question here.
I need to write a query to find a single integer in a field of delimited
integers, say 23,25,27,29. How is this done in
Yes, querying an Access DB to find it.
This is my current (lousy and failing) code for attempting it:
CFQUERY NAME=names DATASOURCE=#DB_redwood#
SELECT distinct lname, fname, artist_id
FROM photos, photographers
WHERE #find(themes.id,[photos.theme_id])# 0
and
Once you run your query, then just do a
cfset myInt = listFind(yourQuery.column, value, delimeter)
Doug B.
- Original Message -
From: Les Irvin [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Saturday, January 27, 2007 11:22 AM
Subject: Re: Querying a delimited text field
CFQUERY NAME=names DATASOURCE=#DB_redwood#
SELECT distinct lname, fname, artist_id
FROM photos, photographers
WHERE listfind(themes.id, photos.theme_id) 0
and photographers.id = photos.artist_id
order by lname
/CFQUERY
Doug B.
-
Les,
There are probably a number of ways you could go about this. One way would
be to use a 'LIKE' operator (which does slow down performance - FYI).
Something like this:
SELECT columnlist FROM tablename
WHERE mycolumn LIKE '%,23,%' OR mycolumn LIKE '23,%' OR mycolumn LIKE '%,23'
Again, this
Doug,
I don't think that will work unless listFind is an access function, and I do
not believe it is.
Dave
-Original Message-
From: Doug Brown [mailto:[EMAIL PROTECTED]
Sent: Saturday, January 27, 2007 12:31 PM
To: CF-Talk
Subject: Re: Querying a delimited text field
CFQUERY
Dave,
I'm pretty sure what you're looking for doesn't exist. I have been
interested in doing this for a while, but I'm not really interested in
starting it. I have heard other people mention starting such a
project, and if anyone ever does, I'll gladly contribute. But I hope
I'm wrong and
Les,
Try this:
CFQUERY NAME=names DATASOURCE=#DB_redwood#
SELECT distinct lname, fname, artist_id
FROM photos, photographers
WHERE photographers.id = photos.artist_id
AND photos.theme_id LIKE '%,#themes.id#,%'
OR photos.theme_id LIKE
I'm pretty sure what you're looking for doesn't exist. I have been
interested in doing this for a while, but I'm not really interested in
starting it. I have heard other people mention starting such a
project, and if anyone ever does, I'll gladly contribute. But I hope
I'm wrong and there
Ok, well maybe an IN statement. I may be way off base though.
IE:
CFQUERY NAME=names DATASOURCE=#DB_redwood#
SELECT distinct lname, fname, artist_id
FROM photos, photographers
WHERE photos.theme_id IN (SELECT themes.id FROM photos)
and photographers.id =
I think that his 'themes_id' is a coldfusion variable. Les, can you please
confirm this or not? It makes a big difference in how things might work.
Dave
-Original Message-
From: Doug Brown [mailto:[EMAIL PROTECTED]
Sent: Saturday, January 27, 2007 12:46 PM
To: CF-Talk
Subject: Re:
With one small tweak it works perfect. (I failed to mention that sometimes
there is just a single integer in the field).
SELECT distinct lname, fname, artist_id
FROM photos, photographers
WHERE photos.theme_id = '#themes.id#'
OR photos.theme_id LIKE
Les,
Great! Yep, didn't think of the situation where the list could be only one
item.
Hey, you should also add parenthesis around the OR clauses for clarity sake.
Here:
SELECT distinct lname, fname, artist_id
FROM photos, photographers
WHERE (photos.theme_id =
Hello all,
These 2 DOM properties
..LastDateModified .RecordCount
can be quite helpful for playing files stored in your server. Unfortunately I
couldnât
find a way yet to dynamically update the names of the files I want.
More detailed:
even though myfile.LastDateModified and
Yes, Themes.id is actually a variable - a result of an earlier query.
On 1/27/07, Dave Phillips [EMAIL PROTECTED] wrote:
I think that his 'themes_id' is a coldfusion variable. Les, can you
please
confirm this or not? It makes a big difference in how things might work.
Dave
-Original
Ioannis,
I'm not perfectly clear on what you are trying, but have you tried this:
cfset myfile = myfile
#evaluate(myfile .LastDateModified)#
And
#evaluate(myfile .RecordCount)#
???
Dave
-Original Message-
From: Ioannis Papanikolaou [mailto:[EMAIL PROTECTED]
Sent: Saturday,
Les, if that variable is the result of another query, then you can
accomplish what you want MUCH MUCH faster using an in clause. Can you post
this whole section of code and we can optimize it for you. We need to see
the query that is getting you the values for theme_id variable, plus any
other
I have post 4 threads the past 3 months in this forum and every single time I
had a
solution.
This is a greate forum an amazing Coldfusion Knowledge base, if not the BEST.
Dave that was the solution to my problem. Thanx a lot.
Regards
Ioannis
OK, have at it! I'll be confirming my novice status by revealing this
code, but at least you won't be able to see me blush.
I am first listing info on a database of photos by theme, then allowing the
user to pick the specific photographer he/she wants to see. This is the
tough page for me:
Les,
This is completely untested, but give it a try. If it works it will shorten
your code and your execution time considerably. If there is any problems,
just scream real loud!!
CFQUERY NAME=themes DATASOURCE=#DB_redwood#
SELECT *
FROM themes
ORDER BY theme
/CFQUERY
CFQUERY NAME=names
P.S.
To shorten the other query, this should work
CFQUERY NAME=names DATASOURCE=#DB_redwood#
SELECT distinct lname, fname, artist_id
FROM photos, photographers
WHERE #themes.id # IN (SELECT photos.theme_id from photos)
and photographers.id = photos.artist_id
order by lname
/CFQUERY
I just installed Eclipse 3.2.1, CFEclipse 1.3 and I downloaded the most
recent version of the Flex Builder trial (2.0.1). I ran the extraction
for the trial and but didn't run the installer. I did get the ColdFusion
Extensions folder with the CF_FB_Extensions.zip file in it. Eclipse
seemed
Les Irvin wrote:
http://redwood.jmdl.com/themes.cfm
http://redwood.jmdl.com/themes_code.cfm (code)
I'd say this is a perfect example of why you don't want to have
repeating data in a field, and why you would want to move that theme
data out into a separate table that relates photos to
I would also agree that what you are looking for does not exist. If
you happen to find one that is decent, I would be curious to know what
it is. I believe the only free Web mail solutions that are any good
are written using PHP.
-Mike Chabot
On 1/27/07, Jacob Munson [EMAIL PROTECTED] wrote:
I just cannot get this to work. Sending plain text email, want to force a
line break. I've tried chr(10), chr(13), chr(13) chr(10), with and
without pound signs, restarted CFMX7. The arguments are outputting
correctly. What's the trick to this?
cfset carr = chr(13) chr(10)
I'm open to anything, even not OPEN SOURCE projects, but webmail systems
that are written and offered for sale even, as long as the source code can
be modified to fit my 'system'.
Dave
-Original Message-
From: Mike Chabot [mailto:[EMAIL PROTECTED]
Sent: Saturday, January 27, 2007 4:00
Remove your 'supresswhitespace' tag. That supresses carriage returns if I
remember correctly.
Dave
-Original Message-
From: Mark Leder [mailto:[EMAIL PROTECTED]
Sent: Saturday, January 27, 2007 4:10 PM
To: CF-Talk
Subject: Line Breaks in Plain Text CFMail - GRRR!
I just cannot get
So how do I get rid of the extra lines where CFIF statements are bypassed in
the code? The savecontent var that I'm building has about 35 cfif
statements.
-Original Message-
From: Dave Phillips [mailto:[EMAIL PROTECTED]
Sent: Saturday, January 27, 2007 5:15 PM
To: CF-Talk
Subject: RE:
Are you viewing this in an email or outputting it to a web template?
savecontent should generate the line feeds for you and save the content the
way it was originally. If you are outputting to a template then you need to
wrap whatever in a pre tag.
Doug B.
- Original Message -
Viewing in MS Outlook as an email message.
-Original Message-
From: Doug Brown [mailto:[EMAIL PROTECTED]
Sent: Saturday, January 27, 2007 5:24 PM
To: CF-Talk
Subject: Re: Line Breaks in Plain Text CFMail - GRRR!
Are you viewing this in an email or outputting it to a web template?
Well, you could do a little hack...
cfoutput
Attendee Name Badge:cfif Len(ARGUMENTS.rsvpUserBadgeName)
#ARGUMENTS.rsvpUserBadgeName##carr#cfelseN/A/cfif
Guest Name:cfif Len(ARGUMENTS.rsvpGuest01Name)
#ARGUMENTS.rsvpGuest01Name##carr#cfelseN/A/cfif
Guest Name Badge:cfif
Well, one option would be to put them all on one line. :) But that would be
a nightmare to support coding wisesohere's another hack you could do
without modifying how your e-mail will look in Outlook:
cfset carr = createUUID() !--- (supply a unique character string here,
just using
Good call, I've been thinking along this line. Let me test out and I'll let
you know.
-Original Message-
From: Dave Phillips [mailto:[EMAIL PROTECTED]
Sent: Saturday, January 27, 2007 5:55 PM
To: CF-Talk
Subject: RE: Line Breaks in Plain Text CFMail - GRRR!
Well, one option would be
So an hour and a bit after the last access by any person, a given
session is still showing in the tracker?
On 1/28/07, Walter Conti [EMAIL PROTECTED] wrote:
Thank you James: Agree, but the sessions are scheduled to expire after one
hour
cfapplication name=#prefix#_blog_#blogname#
if i have grasped this thread, do you want the session to end when the user
closes the browser?
if so then if you go to the cf administrator, go to the memory variables
section under server settings, and turn on the 'Use J2EE Session Variables'.
If you use J2EE session management, ColdFusion MX ends
the session and deletes all
Session scope variables when the user closes the browser.
How do you do this?
if you go to the cf administrator, go to the memory variables section under
server settings, and turn on the 'Use J2EE Session
Les,
Without changing your table structure significantly, you will probably have
to leave it as is. Jim Wright had the right idea (no pun intended) :) It
would be a better design if you have a 'relation' table that all it has is
'photoid' column and 'themeid' column. Then that table would have
Yep! It looks like my ISP resets between 1am and 6am. Until 1pm keep
accumulating. In the morning the values look normal again. Does this make
sense?
Thanks for the help everybody.
On Monday I will ask ISP if they have J2EE on. If they don't, could there be
any reason they would refuse?
Have a
I have been slowly developing my own webMail to use check mail via POP
And I am considering adding a whitelist and filters. Might not compete
With any of the ones from SmartMail or anything. It will be in CF and
Open-source. Not sure if I will implement CFC or AJAX yet.
But it may be about 1/2
I thought that Rick Root was working on something like this:
http://www.opensourcecf.com/CFOpenMail/demo
If I remember, he was making it for IMAP but one could easily make changes.
We need to start something like squirrelmail but written in Coldfusion.
Didn't work.
-Original Message-
From: Mark Leder [mailto:[EMAIL PROTECTED]
Sent: Saturday, January 27, 2007 6:03 PM
To: CF-Talk
Subject: RE: Line Breaks in Plain Text CFMail - GRRR!
Good call, I've been thinking along this line. Let me test out and I'll let
you know.
-Original
Wow guys, thanks for all the help. I've definately got a valuable lesson in
both Cold Fusion and DB design today.
Many thanks to all!
On 1/27/07, Dave Phillips [EMAIL PROTECTED] wrote:
Les,
Without changing your table structure significantly, you will probably
have
to leave it as is. Jim
hi bobby, this is so far working great. it outputs the random numbers, lower,
and upper at a length that we set. i so far have had no reported errors.
thanks for this as this has really allowed me to understand the code to
manipulate strings
thanks again
I have a standard minimum for House of Fusion as it stands now. 10 million,
cash. No stock, no promises, not 1 single penny less than 10.
Anyone who is willing to pay that much now really is dedicated to the
ColdFusion community. Of course, that number will rise as the site rises and at
some
On 1/27/07, Michael Dinowitz [EMAIL PROTECTED] wrote:
I have a standard minimum for House of Fusion as it stands now. 10 million,
cash. No stock, no promises, not 1 single penny less than 10.
Anyone who is willing to pay that much now really is dedicated to the
ColdFusion community. Of course,
Hi, i have a cfm page that uses a javascript function to append a variable to a
url. I then use the coldfusion url variable set to collect the variable in the
receiving cfm page.
however, the variable data is being displayed in the address bar in the
browser. is there anyway to hide the
What didn't work?
-Original Message-
From: Mark Leder [mailto:[EMAIL PROTECTED]
Sent: Saturday, January 27, 2007 6:10 PM
To: CF-Talk
Subject: RE: Line Breaks in Plain Text CFMail - GRRR!
Didn't work.
-Original Message-
From: Mark Leder [mailto:[EMAIL PROTECTED]
Sent:
Fixing the line break problem, tried your code a number of ways. Moved the
cfprocessingdirective inside the cfsavecontent, outside the cfsavecontent.
Made sure the replace function was after the closing cfprocessingdirective
and cfsavecontent tags. The uuid is placed correctly and shows up, but
I do not have a real answer to the question but...maybe disguise it.
set it
cfset myUrlVar = createUUID() 1
get it
cfset myUrlVar = right(myUrlVar,1)
Doug B.
- Original Message -
From: Richard White [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Saturday, January
Or simply Encrypt and Decrypt using ColdFusion builtin functions.
HTH
On 1/27/07, Doug Brown [EMAIL PROTECTED] wrote:
I do not have a real answer to the question but...maybe disguise it.
set it
cfset myUrlVar = createUUID() 1
get it
cfset myUrlVar = right(myUrlVar,1)
Doug B.
Off the top of my head, you have two options.
1) A form post. This pushes the information in the request header
instead of the URL.
2) A redirect. Use cflocation or similar to move from your receiving
page to the display page.
HTH.
--Ben
Richard White wrote:
Hi, i have a cfm page that
How about instead of appending the variable and using a
hidden field.
Terry
-Original Message-
From: Richard White [mailto:[EMAIL PROTECTED]
Sent: Saturday, January 27, 2007 3:44 PM
To: CF-Talk
Subject: hiding url variables
Hi, i have a cfm page that uses a javascript function to
61 matches
Mail list logo