Re: restricting cfoutput character length

2005-09-29 Thread Scott Weikert
Saturday (Stuart Kidd) wrote: Hi, I'm trying to do something which i can imagine is very simple but can't find the function. When i display a title cfoutput#myTitle#/cfoutput i'd like to just display the first 15 characters and if more then put three dots (periods). I know the LEN

RE: Idea for better hosting

2005-09-29 Thread Joel Nath
Hi, can you run CFMX on Windows Server 2003, Web Edition i was told you cant, that it doesnt support it ? -Original Message- From: Emmet McGovern [mailto:[EMAIL PROTECTED] Sent: Thursday, 29 September 2005 12:08 PM To: CF-Talk Subject: RE: Idea for better hosting The original post is

RE: Idea for better hosting

2005-09-29 Thread Snake
Yes you can. The Web Edition is a web server, thus the name. So it wont let you run certain other MS products such as SQL Server which require Windows 2003 Server std. But it cannot stop installing any 3rd party product. Russ -Original Message- From: Joel Nath [mailto:[EMAIL PROTECTED]

RE: SQL row select?

2005-09-29 Thread Kerry
orig. post bounced with body too long, sending again, will probably duplicate Im not a query analyzer expert, and this wasnt a very scientific experiment, but I thought people might find these server trace results interesting. Test1: approx 10,000 row table Testing: Single Sub Select with

Re: Can CF interact with mainframe?

2005-09-29 Thread Rick Root
Maloy wrote: I have a basic question: Is there any way to run Cold Fusion on mainframe like MVS or OS/390 operating system. if not, is there a way in which these can interact even when Coldfusion runs on a Windows or Unix server? I don't know what kind of interaction you're talking about, but

Re: ot: checksum?

2005-09-29 Thread Thomas Chiverton
On Wednesday 28 September 2005 19:47, Ryan Guill wrote: what about on win xp? use md5sum. You'll need to install it from Cygwin, of course. -- Tom Chiverton Advanced ColdFusion Programmer ~| Find out how CFTicket can

INNER JOIN

2005-09-29 Thread Saturday (Stuart Kidd)
Hi, I've been having trouble with JOINS. My query below works but when i try outputting my results I am getting duplicate authors (authorID). cfquery name=GetAuthors datasource=user020 SELECT tbl_020authorDetails.authorID, tbl_020authorDetails.authorFirstName,

RE: ot: checksum?

2005-09-29 Thread Kerry
I use the microsoft one - fciv.exe http://support.microsoft.com/?kbid=841290 -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: 29 September 2005 10:31 To: CF-Talk Subject: Re: ot: checksum? On Wednesday 28 September 2005 19:47, Ryan Guill wrote: what about on

RE: INNER JOIN

2005-09-29 Thread Adrian Lynch
A quick suggestion, write a test page with the minimum of code in. It'll make it easier for you to debug and easier for us to help. Ade -Original Message- From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED] Sent: 29 September 2005 10:50 To: CF-Talk Subject: INNER JOIN Hi, I've been

Re: INNER JOIN

2005-09-29 Thread Saturday (Stuart Kidd)
Hi, I've simplified it a bit: cfquery name=GetAuthors datasource=user020 SELECT tbl_020authorDetails.authorID, tbl_020authorDetails.authorFirstName, tbl_020authorDetails.authorSurname, tbl_020authorDetails.authorPhotograph, tbl_020authorDetails.authorAboutMe,

Weird Flash Remoting Problem and Solution

2005-09-29 Thread Gavin Brook
All, I experienced a strange issue with Flash MX 2004 Pro and CFMX7. When calling functions through the gateway with flash, it appeared that the gateway was being cached. This meant that function names could not change and new functions added would not be available to Flash. A Service Invocation

RE: INNER JOIN

2005-09-29 Thread Ian Tait
You need to use something like ORDER BY authorID if you're grouping on it. Ian -Original Message- From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED] Sent: 29 September 2005 12:37 To: CF-Talk Subject: Re: INNER JOIN Hi, I've simplified it a bit: cfquery name=GetAuthors

Scripting Window User Additions/Permissions on directories

2005-09-29 Thread Ryan Mitchell
Hello I'm running windows 2003 server and CFMX 7. Has anybody come across a way of adding users (Active Directory - CFLDAP?), and setting directory permissions under this configuration. Basically, i'm wanting to script addition of FTP users, and set up permissions on the necessary directories

RE: ot: checksum?

2005-09-29 Thread Dave Watts
use md5sum. You'll need to install it from Cygwin, of course. There are plenty of native Windows implementations of md5sum that don't require Cygwin. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our

Re: INNER JOIN

2005-09-29 Thread Saturday (Stuart Kidd)
Thanks Ian... i think i had fried my brain during the time it took me to create that query from a few days ago until now... :) It works now! Stu On 29 Sep 2005, at 12:42, Ian Tait wrote: You need to use something like ORDER BY authorID if you're grouping on it. Ian -Original

Re: applications in applications

2005-09-29 Thread daniel kessler
You could do it the way you suggested, but I have a feeling that will lead to problems down the line. Maybe something like this - http://shibboleth.internet2.edu/ - along with an application management framework (even for applications around your university) is what you need. But it might be

Re: ot: checksum?

2005-09-29 Thread Thomas Chiverton
On Thursday 29 September 2005 13:00, Dave Watts wrote: There are plenty of native Windows implementations of md5sum that don't require Cygwin. Yeah, I'm just on a mission this week to convince people that GNU software runs on Windows :-) -- Tom Chiverton Advanced ColdFusion Programmer

Now more query problems... boo hoo

2005-09-29 Thread Saturday (Stuart Kidd)
Jumping from one query problem to another... just when it was safe to to run a query another problem leapt out of the dungeons. I would like to only pull the top 8 authors who have the most articles (articleID) I have specified only to get the 8 maxrows but the problem i'm having is when i

clear session variables for testing

2005-09-29 Thread Mark Fuqua
Good Morning, Is there an easy way to clear all session variables? It would help me test for behaviors after session variables have timed out. Thanks, Mark ~| Find out how CFTicket can increase your company's customer

RE: Now more query problems... boo hoo

2005-09-29 Thread Adrian Lynch
You can't use COUNT in the ORDER BY clause. (Please someone back me up here else I'm off to spend some time with Book Online!). Ade -Original Message- From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED] Sent: 29 September 2005 13:20 To: CF-Talk Subject: Now more query problems... boo

RE: clear session variables for testing

2005-09-29 Thread Adrian Lynch
StructClear(SESSION) Ade -Original Message- From: Mark Fuqua [mailto:[EMAIL PROTECTED] Sent: 29 September 2005 13:23 To: CF-Talk Subject: clear session variables for testing Good Morning, Is there an easy way to clear all session variables? It would help me test for behaviors after

RE: clear session variables for testing

2005-09-29 Thread Taco Fleur
structClear() actually deletes other info that you might wish to keep, like cfid stuff. Your better of always setting your session variables in another structure, i.e. Session.user.username = blah; Session.user.firstname = blah; That way when you only want to expire the user details of the

Re: Now more query problems... boo hoo

2005-09-29 Thread Saturday (Stuart Kidd)
I did try to use COUNT(tbl_020articleDetails.articleID) AS totalArticles but came up with the error: [Macromedia][SQLServer JDBC Driver][SQLServer]Column 'tbl_020authorDetails.authorID' is invalid in the select list because it is not contained in an aggregate function and there is no GROUP

RE: Now more query problems... boo hoo

2005-09-29 Thread Taco Fleur
You can use it in the order by clause, he just needs to group all the columns in his query with GROUP BY. Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development -Original Message- From: Adrian

RE: clear session variables for testing

2005-09-29 Thread Emmet McGovern
This should kill everything and start you off with a clean plate. CFSET STRUCTCLEAR(APPLICATION) CFSET STRUCTCLEAR(SESSION) CFLOOP INDEX=X LIST=#GetClientVariablesList()# CFSET DELETED = DELETECLIENTVARIABLE(#X#) /CFLOOP CFCOOKIE NAME=cfid EXPIRES=NOW CFCOOKIE NAME=cftoken EXPIRES=NOW

RE: Now more query problems... boo hoo

2005-09-29 Thread Adrian Lynch
Now where did I put my BOL?! :OS -Original Message- From: Taco Fleur [mailto:[EMAIL PROTECTED] Sent: 29 September 2005 13:38 To: CF-Talk Subject: RE: Now more query problems... boo hoo You can use it in the order by clause, he just needs to group all the columns in his query with GROUP

Re: applications in applications

2005-09-29 Thread Douglas Knudsen
if you want this done on a single server, its not hard. I have it setup in my company like this. Basicaly each application uses two cfapplication tags, one with name MAIN first and second with the name of the app. After the first one I do a check to see if the user is logged in to MAIN, if not

Re: query problem

2005-09-29 Thread daniel kessler
[empty string] is CF's way of saying NULL, since ColdFusion has not native NULL value. Thus your where clause should be WHERE Publication_Type IS NOT NULL didn't work, but this did. Interestingly, != NULL didn't work. It had to be IS NOT NULL I never would have gotten this. I was thinking

query question

2005-09-29 Thread Mark Fuqua
Morning, When I use joins with a select statement, and one of the columns in the query is blank, that record is not part of the record set. I would like to include the records with missing columns and have those columns just be blank. Is that a possibility? Thanks, Mark

RE: query question

2005-09-29 Thread Adrian Lynch
Yup. Look at left and right outer joins. http://www.w3schools.com/sql/sql_join.asp What DB are you using? Ade -Original Message- From: Mark Fuqua [mailto:[EMAIL PROTECTED] Sent: 29 September 2005 13:45 To: CF-Talk Subject: query question Morning, When I use joins with a select

problem using a text list variable in a query statement

2005-09-29 Thread Joy Holman
I create a list from form variables that I want to use in a query. This is where it fails to delete the records (though the query produces no error: cfset qualDelPhotoList = ListQualify(delPhotoList,',,,all) / cfquery name=qdelPhoto datasource=#request.optomDS# Delete from optomSitePhotos

RE: Scripting Window User Additions/Permissions on directories

2005-09-29 Thread Matt Osbun
I've never done it myself, but I ran across this blog about adding users to AD and bookmarked it just in case. Hope it helps. http://www.sargeway.com/blog/index.cfm?mode=entryentry=35 Matt Osbun Applications Manager Health Systems, International -Original Message- From: Ryan Mitchell

RE: problem using a text list variable in a query statement

2005-09-29 Thread Adrian Lynch
A nice way to debug dynamically built queries is like this: cfset qualDelPhotoList = ListQualify(delPhotoList,',,,all) / cfoutputpre !--- cfquery name=qdelPhoto datasource=#request.optomDS# --- Delete from optomSitePhotos WHERE photoLocation IN ('#qualDelPhotoList#') !---

RE: problem using a text list variable in a query statement

2005-09-29 Thread Ian Tait
Doesn't IN just work with integers, or am I remembering wrongly? Ian -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 29 September 2005 14:03 To: CF-Talk Subject: RE: problem using a text list variable in a query statement A nice way to debug dynamically

RE: problem using a text list variable in a query statement

2005-09-29 Thread Matt Osbun
Delete from optomSitePhotos WHERE photoLocation IN (cfqueryparam value=#qualDelPhotoList#) Ought to do the trick. Matt Osbun Applications Manager Health Systems, International -Original Message- From: Joy Holman [mailto:[EMAIL PROTECTED] Sent: Thursday, September 29, 2005 7:55 AM To:

Re: problem using a text list variable in a query statement

2005-09-29 Thread Claude Schneegans
Use this: cfset qualDelPhotoList = ListQualify(delPhotoList,',,,all) / cfquery name=qdelPhoto datasource=#request.optomDS# Delete from optomSitePhotos WHERE photoLocation IN (#preserveSingleQuotes(qualDelPhotoList)#) -- ___ REUSE CODE! Use custom tags; See

RE: Every once in a while, I feel smart. A story of displaying a single random image.

2005-09-29 Thread Andy Matthews
If you're using mySQL then you can do this: SELECT * FROM images ORDER BY RAND() LIMIT 1 Random every time. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Jim Davis

RE: query question

2005-09-29 Thread Mark Fuqua
This database is MS Access. I don't know if it supports right joins. Is the structure of the join the same, just exchange right for left? Mark -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Thursday, September 29, 2005 8:55 AM To: CF-Talk Subject: RE: query

RE: INNER JOIN

2005-09-29 Thread Andy Matthews
Stuart... Just FYI...it'll REALLY help with readability, both for you and for us, if you alias your tables. Like so: You simply use the AS keyword after the table name in your FROM and INNER JOIN statements. FROM tablename AS alias Or you can do it the easy way and leave off the AS keyword.

RE: query question

2005-09-29 Thread Andy Matthews
Use an OUTER JOIN. SELECT * FROM table01 one INNER JOIN table02 two ON one.id = two.fk_id This will only return rows from table01 that also have matching values in table02. SELECT * FROM table01 one LEFT JOIN table02 two ON one.id = two.fk_id This, however, will return ALL rows

RE: query question

2005-09-29 Thread Andy Matthews
Right Mark... The join will return similar information, it just arranges it differently using a left or a right join. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Mark Fuqua

CFAjax function locaiton

2005-09-29 Thread Ken Ferguson
This will be a double post for any of you on the Yahoo! discussion list for CFAjax, so I apologize for that. I'm using CFAjax on a project right now. It's really pretty cool, but I do have one big question for those of you who have already been using it. I have a bunch of functions which have

RE: Can CF interact with mainframe?

2005-09-29 Thread Dawson, Michael
However, we avoid accessing it directly whenever possible. About 4 gigs of data is unloaded into flat delimited files and ftped to our SQL Server box, where it is loaded into SQL Server on a nightly basis. We do a similar process with our AS400. Although some of my CF pages do interact directly

Re: Now more query problems... boo hoo

2005-09-29 Thread Saturday (Stuart Kidd)
I'm managed to do the GROUP BY stuff and it's not throwing any errors but when I add the COUNT() in the order it isn't doing anything: cfquery name=GetAuthors datasource=user020 SELECT tbl_020authorDetails.authorID, tbl_020authorDetails.authorFirstName,

Re: Now more query problems... boo hoo

2005-09-29 Thread Webmaster at FastTrack On Line
Hi Stuart, I'm not the world best at SQL and it helps me to build my queries in MS SQL. I keep queries running in ms sql where I can and only do it from a cfm file when absolutely necessary. Even if it needs to be done from the cfm file, I still create it in ms sql first, then copy across the

RE: query question

2005-09-29 Thread Mark Fuqua
Yes, just replace inner or left with right in you join statement (at least it worked in this case). MSAccess supports left right and inner join statements. Mark -Original Message- From: Mark Fuqua [mailto:[EMAIL PROTECTED] Sent: Thursday, September 29, 2005 9:16 AM To: CF-Talk Subject:

Re: problem using a text list variable in a query statement

2005-09-29 Thread Charlie Griefer
On 9/29/05, Ian Tait [EMAIL PROTECTED] wrote: Doesn't IN just work with integers, or am I remembering wrongly? you're remembering wrongly :) -- Charlie Griefer ...All the world shall be your enemy, Prince with a Thousand Enemies, and whenever

Re: problem using a text list variable in a query statement

2005-09-29 Thread Charlie Griefer
On 9/29/05, Matt Osbun [EMAIL PROTECTED] wrote: Delete from optomSitePhotos WHERE photoLocation IN (cfqueryparam value=#qualDelPhotoList#) Ought to do the trick. It will, if you add the list=yes attribute to the cfqueryparam tag. -- Charlie Griefer

RE: Scripting Window User Additions/Permissions on directories

2005-09-29 Thread Dawson, Michael
Adding users is pretty easy, however, to set the password, you need an SSL connection for the CFLDAP tag. The attribute for the password is unicodePwd, I believe. I ran across this problem and then decided to create the user using a VB COM object instead. It ties me to the Windows platform, but

Re: Can CF interact with mainframe?

2005-09-29 Thread Rick Root
Dawson, Michael wrote: We do a similar process with our AS400. Although some of my CF pages do interact directly with the AS400, most of my data is pulled down to SQL every night. I do this because: Many of the same reasons we do it. ODBC access to our mainframe (located elsewhere on

RE: Can CF interact with mainframe?

2005-09-29 Thread Ian Skinner
We use a 3rd party product called ScreenSurfer by Inventu to do interact with our HP3000 system. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message

RE: problem using a text list variable in a query statement

2005-09-29 Thread Matt Osbun
Serves me right for not double checking the docs before posting. Matt Osbun Applications Manager Health Systems, International -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Thursday, September 29, 2005 8:43 AM To: CF-Talk Subject: Re: problem using a text

RE: Every once in a while, I feel smart. A story of displaying a single random image.

2005-09-29 Thread Mark A Kruger
Taco, Ok ... this works, but I want to know how it works. For example, if I have a table of 5000 rows, does SQL: --- SELECT TOP 1 * FROM yourTable ORDER BY NEWID() - select all the rows assign guids (newid()) order all the

Re: Now more query problems... boo hoo

2005-09-29 Thread Stuart Kidd
Thanks Jenny, I'd never thought of that idea - i'll give it a go and see what i come up with. On 29 Sep 2005, at 14:41, Webmaster at FastTrack On Line wrote: Hi Stuart, I'm not the world best at SQL and it helps me to build my queries in MS SQL. I keep queries running in ms sql

RE: Help with cfselect

2005-09-29 Thread Mike Nimer
You can't use the selected attribute unless you are also using the query attribute in cfselect. Since you are looping over the query and outputting the option tags directly you'll need to add a cfif check. Like this cfselect name=ceilingPaint#i# option value=Select One/option

Re: Now more query problems... boo hoo

2005-09-29 Thread Webmaster at FastTrack On Line
Correct Ade :-) The way around it I use is to run a second query against the first query. Jenny - Original Message - From: Adrian Lynch [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, September 29, 2005 1:30 PM Subject: RE: Now more query problems... boo hoo

Re: query question

2005-09-29 Thread Webmaster at FastTrack On Line
if you are using ms sql to build the query, right click the joining line in the query builder and select to return all rows in the relevant table, this does the appropriate join for you. Jenny - Original Message - From: Adrian Lynch [EMAIL PROTECTED] To: CF-Talk

Re: Idea for better hosting

2005-09-29 Thread DRE
Damn your insulting Emmett, Did you read my initial post? It would be a nice dreamworld if people read carefully. Have a nice day. DRE On 9/29/05, Snake [EMAIL PROTECTED] wrote: Yes you can. The Web Edition is a web server, thus the name. So it wont let you run certain other MS products such

RE: Help with cfselect

2005-09-29 Thread Mike Nimer
You can't use the selected attribute unless you are also using the query attribute in cfselect. Since you are looping over the query and outputting the option tags directly you'll need to add a cfif check. Like this cfselect name=ceilingPaint#i# option value=Select One/option

Query with multiple criteria

2005-09-29 Thread Les Mizzell
Here's a problem that I run into a lot and have never come up with a good answer for... When building a search form that allows to search multiple criteria in a table(s) - lets say lname, category, and color for this example - the user can fill in any one of these, or all of them. So, when

RE: Query with multiple criteria

2005-09-29 Thread Kerry
cfquery name=myQuery Select * From Table Where 1=1 cfif IsDefined(form.lname) and lname like '%#form.lname#%' /cfif cfif IsDefined(form.category) and lname like '%#form.category#%' /cfif cfif IsDefined(form.color) and lname like '%#form.color#%' /cfif /cfquery -Original

RE: Query with multiple criteria

2005-09-29 Thread Adrian Lynch
Try WHERE 1 = 1 Ade -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: 29 September 2005 15:42 To: CF-Talk Subject: Query with multiple criteria Here's a problem that I run into a lot and have never come up with a good answer for... When building a search form that

Re: Idea for better hosting

2005-09-29 Thread DRE
In my dreamworld, I suddenly realized that perhaps someone has already thought of this. So I searched for load balanced hosting and found 588000 results. Oops emmett, this bizzare dreamworld seems to occur in your world. .. . DRE On 9/29/05, DRE [EMAIL PROTECTED] wrote: Damn your insulting

query using - and + to designate MUST HAVE

2005-09-29 Thread Daniel Kessler
I have an Oracle query that I'm trying to get it to work like a google search. I have a list of words that it can contain (search_ar) and a list of words that it must contain (search_must) designated by a +. It will also have a MUST NOT CONTAIN, which will be designated by a -. So when I do

ways to cache a query other than 'cachedwithin'

2005-09-29 Thread Ray Champagne
I've got a simple query that will grab all my navigational menu items. pretty simple. Now, I've added Mike D's cf_maketree script to modify the query by adding another field, called maketreesortlevel, that stores the tree level so that I can output the menu items in the correct order and

Re: ways to cache a query other than 'cachedwithin'

2005-09-29 Thread Michael Dinowitz
Make a persisted CFC and put the query in it at a variables scope variable. As long as the CFC is persisted, the query is persisted. MUCH cleaner than cachedwithin/cachedafter. I have an article on it waiting to go which I can send you off list (it's pre-edit) I've got a simple query that

RE: ways to cache a query other than 'cachedwithin'

2005-09-29 Thread FROEHLING, ROBERT \(AIT\)
Ray, You could store the query in the application scope. Robert -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, September 29, 2005 10:27 AM To: CF-Talk Subject: ways to cache a query other than 'cachedwithin' I've got a simple query that will grab all

Re: ways to cache a query other than 'cachedwithin'

2005-09-29 Thread Ray Champagne
Hey, thanks Mike, I'd love to see the unedited version. CFC's are new to me, but I've been looking for an excuse to jump in with both feet! You can send it to this address. Ray Michael Dinowitz wrote: Make a persisted CFC and put the query in it at a variables scope variable. As long as

RE: ways to cache a query other than 'cachedwithin'

2005-09-29 Thread Jim Davis
-Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, September 29, 2005 11:27 AM To: CF-Talk Subject: ways to cache a query other than 'cachedwithin' I've got a simple query that will grab all my navigational menu items. pretty simple. Now, I've added

CFComplie, problems, or gotcha, or just me?

2005-09-29 Thread jonese
OK so I'm playing around with CFCompile because a customer wants root level access to his site and we don't want him to see proprietary code for our CMS. I compiled our CFC directory as a test and replaced the uncompiled files with the compiled files. Everything seems to work fine. Then on a

RE: ways to cache a query other than 'cachedwithin'

2005-09-29 Thread Jim Davis
-Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Thursday, September 29, 2005 12:05 PM To: CF-Talk Subject: RE: ways to cache a query other than 'cachedwithin' I think there might be some confusion here... you're cfif statement isn't doing what I think you think

Multiple CFGRIDs

2005-09-29 Thread Snake
I'm having a play with flash forms today, and using the new Flash CFGRID. Is it not possible to have multiple CFGRIDS on a page, cozz I am getting very strange results. Every instance of the cfgrid is repeating the columns again. So in instance 1 I get 2 columns fields,data, in instance 2 I get 4

RE: Idea for better hosting

2005-09-29 Thread Emmet McGovern
I wasn't trying to insult you. Sorry if that I did. It was a lighthearted explanation of why that will never happen, at least not in the shared environment. We have several clustered CF enterprise setups. They add a whole new level of difficulty to management and maintenance. The additional

Re: ways to cache a query other than 'cachedwithin'

2005-09-29 Thread Ray Champagne
Thanks Jim. This is some good insight. I am trying out some tests right now, I'll let you know what the results are in a little bit. Jim Davis wrote: -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Thursday, September 29, 2005 12:05 PM To: CF-Talk Subject: RE: ways

RE: restricting cfoutput character length

2005-09-29 Thread Emmet McGovern
There are also a lot of great UDF's available for problems like this at http://www.cflib.org -e -Original Message- From: Scott Weikert [mailto:[EMAIL PROTECTED] Sent: Thursday, September 29, 2005 2:11 AM To: CF-Talk Subject: Re: restricting cfoutput character length Saturday (Stuart

cache query error -- cf server crashes

2005-09-29 Thread owen knapp
Here's an interesting one for anyone bored or obviously more 'in-the-know' than i. Background: We have site that gets a fair amount of activity (700,000 - 1.5 mil page views a day). It's a data providing website for subscribers of the service. About 4 months ago, we started caching a query on

RE: ways to cache a query other than 'cachedwithin'

2005-09-29 Thread Jim Davis
-Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Thursday, September 29, 2005 12:12 PM To: CF-Talk Subject: RE: ways to cache a query other than 'cachedwithin' Now I'm not so sure about that... but I think I'm still right. The queryname is definitely used as

CF Tips... was CF smart

2005-09-29 Thread Emmet McGovern
We need a Wiki or something to start compiling all the nifty solutions here. Is anyone on the Evolt.org list? They have a nice self building tips library by posters who just surround things with tip/tip. It would be interesting to build a cflist parser that throws something like this into an rss

Re: Every once in a while, I feel smart. A story of displaying a single random image.

2005-09-29 Thread Barney Boisvert
If you don't need perfectly randomized results (and you usually don't), there are much more efficient ways to do this. Probably the easiest is to assign each row a sequential number, index the column, and then do this: SET @offset = round(rand() * (SELECT COUNT(*) FROM myTable)); SELECT TOP 1 *

RE: Every once in a while, I feel smart. A story of displaying a single random image.

2005-09-29 Thread Matt Osbun
Really close to something I use for a Random Quote Of The Day sort of thing. DECLARE @RowId as int SET @RowId = round(rand() * (SELECT COUNT(*) FROM Results),0); SELECT TOP 1 author, quote FROM Results WHERE Quoteid = @RowId You need the second parameter in the Round() function to determin

Re: CF Tips... was CF smart

2005-09-29 Thread Michael Dinowitz
So you just want a text parser to look for a start and end 'tip' tag and treat whatever is in it as a tip to be loaded into a tip DB? I can do that. Let me see how easy it is. If your on the test list, you'll start seeing the code in place there. We need a Wiki or something to start compiling

Re: Every once in a while, I feel smart. A story of displaying a single random image.

2005-09-29 Thread Barney Boisvert
Assuming quoteid is the primary key, that will cause issues if you ever delete a quote (or have non-contiguous values for some other reason). Doing a = won't affect randomness if that scenario doesn't exist, but if it does, it'll prevent zero-row results. This is the main reason for using a

RE: CF Tips... was CF smart

2005-09-29 Thread Emmet McGovern
That would be awesome. What's the test list subscription address? I think this is one of the coolest features on the Evolt list. I don't think there's rss accessible though. Keep us updated. Emmet -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Thursday,

RE: Every once in a while, I feel smart. A story of displaying a single random image.

2005-09-29 Thread Matt Osbun
Hrmmm... Hadn't thought of that. Wondered about that = in your version. As you guessed, quoteid is an Int Identity Seed Primary Key, autoincrementing, sequential and all that. The conditions you mentioned aren't an issue *in this case*, as the table is pretty static, but you're right- the =

Re: ways to cache a query other than 'cachedwithin'

2005-09-29 Thread Ray Champagne
Okay, JIm, using this and your last suggestion, I have made a test case that I think points to the same issue that I was having in the beginning. Of course, the code that I have will run correctly. I agree that just testing for the qry_get_topcats var wasn't the right way to go... Running

Re: CF Tips... was CF smart

2005-09-29 Thread Claude Schneegans
They have a nice self building tips library by posters who just surround things with tip/tip. It would be interesting to build a cflist parser that throws something like this into an rss feed. Check CF_REextract that can do this pretty easily:

RE: Every once in a while, I feel smart. A story of displaying a single random image.

2005-09-29 Thread Jim Davis
-Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Thursday, September 29, 2005 12:36 PM To: CF-Talk Subject: Re: Every once in a while, I feel smart. A story of displaying a single random image. If you don't need perfectly randomized results (and you usually

RE: 7.0.1 Updater

2005-09-29 Thread Steve Brownlee
Yes I got the correct one. What I ended up doing was updating my backup JRun installation and when I did that I noticed that the installer created a directory named 'updater_backup'. From that listing, I copied the needed files from the JRun directory over to the one I wanted updated.

RE: 7.0.1 Updater

2005-09-29 Thread Steve Brownlee
That's awesome, Jaye. I'm glad you OSX folks finally have a ColdFusion package. As an addition to my original posting, while I was trying to get the updater to install for me, I decided to apply the latest Cumulative Hotfix to my system. However, when I restart the service, I see this message

Re: CF Tips... was CF smart

2005-09-29 Thread Michael Dinowitz
http://www.houseoffusion.com/cf_lists/threads.cfm/1 The code is set to only take a tip from that list and email the results to me. There is a single tip allowed per post and a tip is any content within the tip and /tip tags. If this works out properly, then I'll add it to the full list

Re: Every once in a while, I feel smart. A story of displaying a single random image.

2005-09-29 Thread Barney Boisvert
It works a lot better if you have a specific sort column, at least in a lot of scenarios. Say you have id's 1-10, and then you deleted 2, 3, and 4. If you use the id column, suddenly id 5 has a 4:10 chance of being selected, while 1 and 6-10 still only have 1:10 chance. By having a separate

Re: CF Tips... was CF smart

2005-09-29 Thread Michael Dinowitz
I used: CFSET sTip=REFindNoCase('tip(.+?)/tip', body, 1, 1) CFIF ArrayLen(sTip.pos) GT 1 CFSET Tip=mid(body, sTip.pos[2], sTip.Len[2]) /CFIF They have a nice self building tips library by posters who just surround things with tip/tip. It would be interesting to build a cflist parser that

CF_Underground topics, early bird ends Friday 9/30

2005-09-29 Thread Michael Smith
The CF_Underground early bird price ends tomorrow days on 9/30/05. Join us prior to Macromedia's MAX conference in Anaheim, California for CF_Underground VII - the must attend pre-show event. Enjoy lunch and a beer on us! Have a great time with our speakers including Hal Helms, Michael Smith,

AOL and session variables?

2005-09-29 Thread Andy Matthews
A client of mine who uses AOL is having problems logging into the CMS which I built for her. I believe I've narrowed it down to a session variable thing. The website either doesn't see the var or it thinks that the var is false when it should be true. Here's the line from my app.cfm file:

RE: CF Tips... was CF smart

2005-09-29 Thread Emmet McGovern
Nice job. Now will this eventually be moved into its own feed? Emmet -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Thursday, September 29, 2005 1:57 PM To: CF-Talk Subject: Re: CF Tips... was CF smart I used: CFSET sTip=REFindNoCase('tip(.+?)/tip', body,

RE: AOL and session variables?

2005-09-29 Thread Russ
Yea, tell her to stop using aol... Even if you're using aol for dialup, you can still use an external browser. Teach her how to start up an external internet explorer, or better yet firefox. Russ -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Thursday,

CF 7 on OS X: JVM 1.5?

2005-09-29 Thread Ken Dunnington
I just installed the Server version of 7.0.1 on my OS X 10.4 system (switching from 7 on JRun4) and was wondering if it's possible to specify the 1.5 JVM as the one CF uses? I know it isn't officially supported, but has anyone tried it? You can set the JVM in the Server Settings/Java and JVM panel

Re: CF Tips... was CF smart

2005-09-29 Thread Michael Dinowitz
OK, the code works well and will seperate a single tip from a message. I'm still playing to deal with a quoted tip, but that should not be much of a problem either. ~| Logware (www.logware.us): a new and convenient web-based

RE: AOL and session variables?

2005-09-29 Thread Andy Matthews
Yeah... I did get her to use IE, which works. But I'd rather know what's going on. I use this same codebase for almost all of my CMS and I wonder how many users might be having problems logging in and never telling us. !//-- andy matthews web developer ICGLink, Inc. [EMAIL

RE: AOL and session variables?

2005-09-29 Thread Russ
Aol is probably blocking cookies or something weird like that... just hop on aol yourself and test it out... -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Thursday, September 29, 2005 2:20 PM To: CF-Talk Subject: RE: AOL and session variables? Yeah... I did

  1   2   >