Re: Aggregate query help please

2009-07-17 Thread Seamus Campbell
Hi Barney Your answer was cut - would you mind resending please ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive:

Re: Aggregate query help please

2009-07-17 Thread Barney Boisvert
I have no idea what that was. My sent mail has the same blank message, but I didn't reply. WITH ROLLUP is the clause you want though, if your DB supports it. cheers, barneyb -- Barney Boisvert bboisv...@gmail.com http://www.barneyb.com/ On Jul 17, 2009, at 4:09 PM, Seamus Campbell

Re: Aggregate query help please

2009-07-17 Thread denstar
I've got some code that uses the JExcelAPI for converting queries to Excel spreadsheets. It's got some support for formulas, so theoretically you could wow the people you need to send it to by not only having the sums there, but having them update if they change the numbers in the various

Aggregate query help please

2009-07-16 Thread Seamus Campbell
I have a database (access at the moment) for members of an organisation. The members are scattered throughout (mostly in one state) Australia (with a couple in the US) They all are one of three language groups. I need to export an excel spreadsheet with a count of members from each language

Re: Aggregate query help please

2009-07-16 Thread Barney Boisvert
On Thu, Jul 16, 2009 at 4:57 AM, Seamus Campbellcoldfus...@boldacious.com wrote: I have a database (access at the moment) for members of an organisation. The members are scattered throughout (mostly in one state) Australia (with a couple in the US) They all are one of three language groups.

Recursion to retrieve blog thread - help please

2008-11-05 Thread Christophe Maso
this is typically done in a CFC function, or if I'm best off with returntype query, or returntype array, or if maybe this can be done in a single SQL query. But I've a strong feeling that it's done with recursion. Help please? Thanks, Christophe

Re: Recursion to retrieve blog thread - help please

2008-11-05 Thread Jason Fisher
Original call would look something like this, where entryID is all you need to start with: cfset myReplyTreeQry = getChildren(url.entryID, request.datasource) This would create a query result called myReplyTreeQry with the following columns: entryID replyID (of each reply)

Re: Recursion to retrieve blog thread - help please

2008-11-05 Thread Christophe Maso
Thank you very much - this works beautifully! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive:

Align cfformgroup using hdividedbox, help please...

2008-08-10 Thread Tom Jones
Hello, I'm starting to play with the cfformgroup tag and I'm hitting a snag. I would like to have two hdividedbox(s) side-by-side but I can not seem to get it to work. Can someone please tell me what I'm doing wrong. Thanks, tom Here is my test code... cfform format=flash width=800

Re: Align cfformgroup using hdividedbox, help please...

2008-08-10 Thread Tom Jones
I figured it out i was not using the hbox and vbox properly. tom On Aug 10, 2008, at 10:11 AM, Tom Jones wrote: Hello, I'm starting to play with the cfformgroup tag and I'm hitting a snag. I would like to have two hdividedbox(s) side-by-side but I can not seem to get it to work. Can someone

Re: Query Help Please

2008-04-29 Thread C S
select *, exists ( select * from orders where date between #date1# and #date2# ) as hasOrdered from customers order by name, id Use CFQUERYPARAM, of course. Another variation is a left join. Ditto on using cfqueryparam. SELECT c.ID, c.Name, c.Email, SUM(CASE WHEN o.Date IS NULL THEN 0

Re: Query Help Please

2008-04-29 Thread Brian Sheridan
I dont believe this is working with Access DB SUM(CASE WHEN o.Date IS NULL THEN 0 ELSE 1 END) ordersFound C S [EMAIL PROTECTED] wrote: select *, exists ( select * from orders where date between #date1# and #date2# ) as hasOrdered from customers order by name, id Use CFQUERYPARAM, of

Re: Query Help Please

2008-04-29 Thread C S
I dont believe this is working with Access DB SUM(CASE WHEN o.Date IS NULL THEN 0 ELSE 1 END) ordersFound I think Access's version of CASE is IIF(..). Try using IIF instead and also try the query Barney suggested. One of them should work.

Query Help Please

2008-04-28 Thread Brian Sheridan
I will try to make this as simple as possible. Any help would be greatly appreciated. I have 2 tables like below. tblCustomers === ID | Name | Email | 1, John, [EMAIL PROTECTED] 2, Bob, [EMAIL PROTECTED] 3, Steve, [EMAIL PROTECTED]

Re: Query Help Please

2008-04-28 Thread Barney Boisvert
select *, exists ( select * from orders where date between #date1# and #date2# ) as hasOrdered from customers order by name, id Use CFQUERYPARAM, of course. cheers, barneyb On Mon, Apr 28, 2008 at 8:57 PM, Brian Sheridan [EMAIL PROTECTED] wrote: I will try to make this as simple as possible.

Re: Some JS help please

2008-04-17 Thread morgan l
Yep, I think this is the problem as well. If you take the code posted @ http://www.nomorepasting.com/getpaste.php?pasteid=14631 and move the entire script section to the bottom, the error goes away. On Wed, Apr 16, 2008 at 4:55 PM, Matt Williams [EMAIL PROTECTED] wrote: On Wed, Apr 16, 2008

Re: Some JS help please Solved

2008-04-17 Thread Bruce Sorge
OK, so I figured this out this morning. Nothing like getting a good nights sleep. What I did was this: Moved the function to the top, gave it a name, changed the document.getElementByID to document.FormName.FieldName, added the onChange event on the select list and it is working fine Thanks

Some JS help please

2008-04-16 Thread Bruce Sorge
I am using this script: cfoutput script type=text/javascript var SiteContact = {}; var SitePhone = {}; !--- Populate Site Contact Information --- cfloop query=qSelectAllSites SiteContact[#qSelectAllSites.SiteID#] = '#qSelectAllSites.SiteContact#';

Re: Some JS help please

2008-04-16 Thread Charlie Griefer
Hi Bruce: Haven't looked over all the code, but it's document.getElementById() ('Id', not 'ID'). hopefully that'll do it. On Wed, Apr 16, 2008 at 1:58 PM, Bruce Sorge [EMAIL PROTECTED] wrote: I am using this script: cfoutput script type=text/javascript var SiteContact = {}; var

Re: Some JS help please

2008-04-16 Thread Bruce Sorge
Thanks for seeing that Charlie. But the issue still exists. It is the first document.getElementById., the Site_ID one. Bruce Charlie Griefer wrote: Hi Bruce: Haven't looked over all the code, but it's document.getElementById() ('Id', not 'ID'). hopefully that'll do it

Re: Some JS help please

2008-04-16 Thread Charlie Griefer
do you need for this to be cfform? i haven't touched cfform in years because i used to find that the JS it generated conflicted with my own home-grown JS. curious if something similar might be happening here. can you try it with a regular form and select and whatnot, just to see if maybe that's

Re: Some JS help please

2008-04-16 Thread Bruce Sorge
Yeah, I will give that a shot. Bruce On Wed, Apr 16, 2008 at 2:15 PM, Charlie Griefer [EMAIL PROTECTED] wrote: do you need for this to be cfform? i haven't touched cfform in years because i used to find that the JS it generated conflicted with my own home-grown JS. curious if something

Re: Some JS help please

2008-04-16 Thread Josh Nathanson
Message - From: Bruce Sorge [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, April 16, 2008 1:58 PM Subject: Some JS help please I am using this script: cfoutput script type=text/javascript var SiteContact = {}; var SitePhone = {}; !--- Populate Site Contact

Re: Some JS help please

2008-04-16 Thread Bruce Sorge
I changed everything to regular select and regular form. Still the same issue. Just downloaded Firebug and I will work with that to see if I can spot the problem. Bruce Josh Nathanson wrote: Does using cfselect rather than a regular select change the id value somehow? The error you're

Re: Some JS help please

2008-04-16 Thread Charlie Griefer
Bruce - can you view the source and paste it to a www.nomorepasting.com type site? hard to debug JS when it's not all been generated yet :) (but definitely use Firebug for your own testing/debugging. Firebug rocks) On Wed, Apr 16, 2008 at 2:47 PM, Bruce Sorge [EMAIL PROTECTED] wrote: I

Re: Some JS help please

2008-04-16 Thread Matt Williams
On Wed, Apr 16, 2008 at 2:47 PM, Bruce Sorge [EMAIL PROTECTED] wrote: I changed everything to regular select and regular form. Still the same issue. Just downloaded Firebug and I will work with that to see if I can spot the problem. Bruce It may be as simple as the fact that

Re: Some JS help please

2008-04-16 Thread Bruce Sorge
Sure, Here it is: http://www.nomorepasting.com/getpaste.php?pasteid=14631 It is not the entire form though. Just the result of the JS and down to the select, incase anyone notices and says Hey, you forgot to close your form. And I am finding FireBug interesting. Bruce Charlie Griefer wrote:

Re: Some JS help please

2008-04-16 Thread Josh Nathanson
- From: Bruce Sorge [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, April 16, 2008 2:57 PM Subject: Re: Some JS help please Sure, Here it is: http://www.nomorepasting.com/getpaste.php?pasteid=14631 It is not the entire form though. Just the result of the JS

Re: Some JS help please

2008-04-16 Thread Cutter (CFRelated)
Two votes for Firebug. Never work without it. Pegs down my js fat finger problems, helps me know when external resources aren't available (usually by fat fingering resource paths), let's me see what headers are going out and being returned, see full server responses, and view the exact form

cf_breadcrumb help please

2008-04-07 Thread Nisher
hello, I am attempting to create a breadcrumb trail for this site i am working on. I downloaded the extension cf_breadcrumb from the adobe coldfusion downloads. but there are a few things i would like to customize in the file but am not sure how to do so. One of the issues i am running

Help please - a 500 null error

2007-11-16 Thread Peter Tilbrook
I am getting a 500 null error (and that is all it says) under MX7. The code works great under CF8 (and in fact is modified from a site I wrote previously that works perfectly still). It is not using any CF8 features as my host does not yet support it. Tried local MX7 (500 Null) and CF8 (works

RE: Help please - a 500 null error

2007-11-16 Thread Ben Nadel
. .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Peter Tilbrook [mailto:[EMAIL PROTECTED] Sent: Friday, November 16, 2007 12:52 AM To: CF-Talk Subject: Help please

RE: Help please - a 500 null error

2007-11-16 Thread Brad Wood
[mailto:[EMAIL PROTECTED] Sent: Thursday, November 15, 2007 11:52 PM To: CF-Talk Subject: Help please - a 500 null error I am getting a 500 null error (and that is all it says) under MX7. The code works great under CF8 (and in fact is modified from a site I wrote previously that works perfectly

RE: cfquery error, help please.

2007-08-01 Thread Chad Gray
, 2007 1:17 PM To: CF-Talk Subject: cfquery error, help please. What's wrong with my SQL statement? cfquery dbtype=query name=calander SELECT LEFT(filename,3) as mnth, filename FROM dir_data where filename like '%calendar%' /cfquery This the LEFT is causing an error. Anyone know what might

cfquery error, help please.

2007-08-01 Thread Dae
What's wrong with my SQL statement? cfquery dbtype=query name=calander SELECT LEFT(filename,3) as mnth, filename FROM dir_data where filename like '%calendar%' /cfquery This the LEFT is causing an error. Anyone know what might be the fix or problem? The error itself is: *Query Of Queries

Re: cfquery error, help please.

2007-08-01 Thread Dae
you output your data. -Original Message- From: Dae [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 01, 2007 1:17 PM To: CF-Talk Subject: cfquery error, help please. What's wrong with my SQL statement? cfquery dbtype=query name=calander SELECT LEFT(filename,3) as mnth, filename

RE: cfquery error, help please.

2007-08-01 Thread Brad Wood
, 2007 12:17 PM To: CF-Talk Subject: cfquery error, help please. What's wrong with my SQL statement? cfquery dbtype=query name=calander SELECT LEFT(filename,3) as mnth, filename FROM dir_data where filename like '%calendar%' /cfquery This the LEFT is causing an error. Anyone know what might

Re: cfquery error, help please.

2007-08-01 Thread Charlie Griefer
and use mid() ~Brad -Original Message- From: Dae [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 01, 2007 12:17 PM To: CF-Talk Subject: cfquery error, help please. What's wrong with my SQL statement? cfquery dbtype=query name=calander SELECT LEFT(filename,3) as mnth, filename

HELP Please - Using Coldfusion to Import delimited txt files.

2007-07-19 Thread Dae
Someone help me... I need a way, other then using DTS to insert data into a SQL table. I was able to find some code on easyCFM.com, and it works, but only with comma delimited files. What I need to know is how I might be able to correct this so I can use files with other delimiters. Below is

RE: HELP Please - Using Coldfusion to Import delimited txt files.

2007-07-19 Thread Brad Wood
It would appear that not all the lines of your input file have four values. Keep in mind current versions of CF ignore empty list elements. Ex: item1,item2,,item4 The above comma delimited list only has 3 items, even though it would appear to have 4. (Word is, CF8 fixed that) ~Brad

RE: HELP Please - Using Coldfusion to Import delimited txt files.

2007-07-19 Thread Brad Wood
Wait, I just noticed the fourth listgetat doesn't specify a delimiter-- which means it is defaulting to a comma. That would cause problems when using a | or ~ delimiter. (or technically, anything OTHER than a comma) If you change the fourth line to '#listgetAt('#index#',4,'|')#' that should

Re: HELP Please - Using Coldfusion to Import delimited txt files.

2007-07-19 Thread Christopher Jordan
Dae, I have questions: cfloop index=index list=#txtfile# delimiters=#chr(10)##chr(13)# cfquery name=importtxt datasource=sqlconnect INSERT INTO testload (date_add,name,phone,zip) VALUES ('#listgetAt('#index#',1, '|')#',

Re: HELP Please - Using Coldfusion to Import delimited txt files.

2007-07-19 Thread Charlie Griefer
On 7/19/07, Dae [EMAIL PROTECTED] wrote: Invalid list index 4. In function ListGetAt(list, index [, delimiters]), the value of index, 4, is not a valid as the first argument (this list has 1 elements). Valid indexes are in the range 1 through the number of elements in the list.The error

Re: HELP Please - Using Coldfusion to Import delimited txt files.

2007-07-19 Thread Dae
Thank you Charlie!! I didn't think it needed one because after the 4th field, it's a CR/LR. Regardless, changing to: '#listgetAt('#index#',4, '|')#', WORKED!!! THANK YOU!!! - Dae === On 7/19/07, Charlie Griefer [EMAIL PROTECTED] wrote: On 7/19/07, Dae [EMAIL PROTECTED]

Re: HELP Please - Using Coldfusion to Import delimited txt files.

2007-07-19 Thread Janet MacKay
Someone help!! How do I fix it to work with other delimiters? I get the below error if I can the comma to say a pipeline '|'. I made sure to change the test.txt file to match. *15 :'#listgetAt('#index#',4)#'* Also, you forgot the pipe delimiter on the last line

Re: HELP Please - Using Coldfusion to Import delimited txt files.

2007-07-19 Thread Jake Pilgrim
The performance of cffile action=read and cfloop list=file, delim=end of line chars is terribly poor... Furthermore (as you have found out), there's usually a lot of trial and error getting this to work. Assuming you have a well-formatted delimited text file, the best approach is to use

Re: HELP Please - Using Coldfusion to Import delimited txt files.

2007-07-19 Thread Dominic Watson
Also again, It isn't necessary to have all those pound signs in your listgetat statements. The following will work: cfquery name=importtxt datasource=sqlconnect INSERT INTO testload (date_add,name,phone,zip) VALUES ('#listgetAt('index',1, '|')#',

RE: HELP Please - Using Coldfusion to Import delimited txt files.

2007-07-19 Thread Dave Francis
You don't have the delimiter specified on the last item in the INSERT statement, but you need it. Otherwise listGetAt() (or any list function) assumes a comma delimiter. -Original Message- From: Dae [mailto:[EMAIL PROTECTED] Sent: Thursday, July 19, 2007 12:35 PM To: CF-Talk Subject: HELP

Re: HELP Please - Using Coldfusion to Import delimited txt files.

2007-07-19 Thread Christopher Jordan
Dominic's right. I missed the quotes around the index variable. oops! :o) Chris On 7/19/07, Dominic Watson [EMAIL PROTECTED] wrote: Also again, It isn't necessary to have all those pound signs in your listgetat statements. The following will work: cfquery name=importtxt

RE: HELP Please - Using Coldfusion to Import delimited txt files.

2007-07-19 Thread Brad Wood
-Original Message- From: Dae [mailto:[EMAIL PROTECTED] Sent: Thursday, July 19, 2007 1:22 PM To: CF-Talk Subject: Re: HELP Please - Using Coldfusion to Import delimited txt files. Thank you Charlie!! I didn't think it needed one because after the 4th field, it's a CR/LR. Regardless, changing

Re: HELP Please - Using Coldfusion to Import delimited txt files.

2007-07-19 Thread Kris Jones
Ben Nadel wrote a nice function for parsing csv-type files that works very well: http://www.bennadel.com/index.cfm?dax=blog:498.view Cheers, Kris ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7

Re: HELP Please - Using Coldfusion to Import delimited txt files.

2007-07-19 Thread Christopher Jordan
Nice Tip Jake! Chris On 7/19/07, Jake Pilgrim [EMAIL PROTECTED] wrote: The performance of cffile action=read and cfloop list=file, delim=end of line chars is terribly poor... Furthermore (as you have found out), there's usually a lot of trial and error getting this to work. Assuming you

SQL Help, please ...

2007-06-27 Thread tjones
Hello, It's been a wile since I have had to do much in the way of SQL queries and I need some help. I have a table called installs that looks like this HostName, iDate, Package client1, 2007-06-01, Update1 client1, 2007-06-01, Update2 client1, 2007-06-01, Update3 client1, 2007-06-02, Update5

RE: SQL Help, please ...

2007-06-27 Thread Brad Wood
only. (syntax depends on your DB). ~Brad -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 26, 2007 10:16 PM To: CF-Talk Subject: SQL Help, please ... Hello, It's been a wile since I have had to do much in the way of SQL queries and I need some

Re: SQL Help, please ...

2007-06-27 Thread Jochem van Dieten
[EMAIL PROTECTED] wrote: HostName, iDate, Package client1, 2007-06-01, Update1 client1, 2007-06-01, Update2 client1, 2007-06-01, Update3 client1, 2007-06-02, Update5 client1, 2007-06-02, NewApp client2, 2007-06-01, Update1 client2, 2007-06-01, Update2 client2, 2007-06-01, Update3

Re: Fusebox 5 install problem - help, please

2007-05-20 Thread Stephen Hait
On 5/18/07, Sandra Clark [EMAIL PROTECTED] wrote: Make sure your Fusebox_application_path in index.cfm points to the skeleton path. cfset FUSEBOX_APPLICATION_PATH = skeleton/ If I am reading your email message correctly. Thanks, Sandra I think the problem, which I didn't probably provide

OT: Fusebox 5 install problem - help, please

2007-05-18 Thread Stephen Hait
Sorry if this is off-topic. I wanted to install and try Fusebox 5. On my development system I've got a virtual directory configured named cf2 using IE6 running CFMX. I downloaded the FB 5.1 core files, extracted them from the archive and copied the fusebox5 directory to the root of the cf2

RE: Fusebox 5 install problem - help, please

2007-05-18 Thread Sandra Clark
-Original Message- From: Stephen Hait [mailto:[EMAIL PROTECTED] Sent: Friday, May 18, 2007 5:07 PM To: CF-Talk Subject: OT: Fusebox 5 install problem - help, please Sorry if this is off-topic. I wanted to install and try Fusebox 5. On my development system I've got a virtual directory configured

Urgent Help Please!

2007-04-16 Thread Peterson, Chris
I have a fairly high volume site running on IIS 6 / 2003 R2 server, CF 7 Enterprise My site is running as a CF cluster with 2 members in round robin, and sticky sessions The only error in my event log I have is an IIS one, showing: A worker process with process id of '2012' serving application

RE: Urgent Help Please!

2007-04-16 Thread Peterson, Chris
Is there a guide out there for configuring IIS to handle upwards of 200 connection requests / second with Coldfusion 7 Ent? Chris -Original Message- From: Peterson, Chris [mailto:[EMAIL PROTECTED] Sent: Monday, April 16, 2007 9:43 AM To: CF-Talk Subject: Urgent Help Please! I have

RE: Urgent Help Please!

2007-04-16 Thread Peterson, Chris
Here is a snip that I don't understand from my instance1-out.log: 04/16 09:26:29 info Clusterable service JNDIContextManager discovered ClusterManager on 172.16.100.51:4160, cluster domain: CFCluster (Lookup Service's JINI-ID: 283dcde8-3d52-4ab6-b3e5-e13136da381a) 04/16 09:27:19 info Clusterable

Re: Urgent Help Please!

2007-04-16 Thread C. Hatton Humphrey
Any idea's would help, I am getting screamed at!!! A mallet? Hatton ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs

Re: Urgent Help Please!

2007-04-16 Thread Jochem van Dieten
Peterson, Chris wrote: I have a fairly high volume site running on IIS 6 / 2003 R2 server, CF 7 Enterprise Which hotfixes have you applied? Do you log long running requests? Do you have a requesttimeout? How long are your requests running? My site is running as a CF cluster with 2 members

RE: Urgent Help Please!

2007-04-16 Thread Peterson, Chris
java.net.SocketException: Connection reset by peer: socket write error I am not finding those on google anywhere, has anyone else seen these? Chris -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Monday, April 16, 2007 10:55 AM To: CF-Talk Subject: Re: Urgent Help Please! Peterson

Re: Urgent Help Please!

2007-04-16 Thread Tom Chiverton
On Monday 16 Apr 2007, Peterson, Chris wrote: java.net.SocketException: Connection reset by peer: socket write error The user closed their web browser, iirc. You can ignore them if so. -- Tom Chiverton Helping to assertively compete back-end portals on: http://thefalken.livejournal.com

Re: Urgent Help Please!

2007-04-16 Thread Jochem van Dieten
Peterson, Chris wrote: I have not changed the default page configuration, and nothing un-expected is showing in the long page log ( I am parsing the server.log using Ray Camden's findslow.cfm template) Digging deeper on my instance err.log, I am seeing a lot of these errors during the time

RE: Urgent Help Please!

2007-04-16 Thread Peterson, Chris
Nope, debugging is not enabled on either cluster-member instance. Check this one out, now I am finding this in my err.log file: java.lang.OutOfMemoryError: unable to create new native thread It looks like its hitting some type of native OS memory limit for creating threads? I found this

Re: Urgent Help Please!

2007-04-16 Thread Jochem van Dieten
Peterson, Chris wrote: Nope, debugging is not enabled on either cluster-member instance. Check this one out, now I am finding this in my err.log file: java.lang.OutOfMemoryError: unable to create new native thread It looks like its hitting some type of native OS memory limit for creating

Re: Urgent Help Please!

2007-04-16 Thread Jon Clausen
Chris, First of all, I defer to any of the suggestions that Jochem gives you, since he's way better in the server configuration arena than I am (or many of us, for that matter). Windows defaults out of the box to about 7200 concurrent threads (src - http://gregluck.com/blog/

RE: Urgent Help Please!

2007-04-16 Thread Peterson, Chris
, April 16, 2007 1:25 PM To: CF-Talk Subject: Re: Urgent Help Please! Chris, First of all, I defer to any of the suggestions that Jochem gives you, since he's way better in the server configuration arena than I am (or many of us, for that matter). Windows defaults out of the box to about 7200

Re: Urgent Help Please!

2007-04-16 Thread Jon Clausen
- From: Jon Clausen [mailto:[EMAIL PROTECTED] Sent: Monday, April 16, 2007 1:25 PM To: CF-Talk Subject: Re: Urgent Help Please! Chris, First of all, I defer to any of the suggestions that Jochem gives you, since he's way better in the server configuration arena than I am (or many of us

RE: Urgent Help Please!

2007-04-16 Thread Peterson, Chris
about the momentary panic =) Chris -Original Message- From: Jon Clausen [mailto:[EMAIL PROTECTED] Sent: Monday, April 16, 2007 2:42 PM To: CF-Talk Subject: Re: Urgent Help Please! Chris, I've been there and feel your pain (some from my own doing, though, so I can't throw too many stones

need insert help please

2007-03-10 Thread Bob Imperial
First off...shouldn't you all be out doing something other than working? ;-) Since you're not out somewhere having way too much fun, I could use some enlightenment here. I have a form passing multiple values via some checkboxes, I think I've got the insert down ok for that with the following: I'm

RE: need insert help please

2007-03-10 Thread Coldfusion
you need with this ID and song_title --- /cfif -Original Message- From: Bob Imperial [mailto:[EMAIL PROTECTED] Sent: Saturday, March 10, 2007 6:00 PM To: CF-Talk Subject: need insert help please First off...shouldn't you all be out doing something other than working? ;-) Since you're

RE: need insert help please

2007-03-10 Thread Dave Watts
First off...shouldn't you all be out doing something other than working? ;-) Since you're not out somewhere having way too much fun, I could use some enlightenment here. I have a form passing multiple values via some checkboxes, I think I've got the insert down ok for that with the

RE: need insert help please

2007-03-10 Thread Bob Imperial
Dave...sorry for the lack of information, after read what I posted I thought I should have given a little more information. My form looks like this: form action=#self#?fuseaction=admin.selectSongs name=songSelect method=post input type=text name=week_of size=25 maxlength=50 value= / This is

RE: need insert help please

2007-03-10 Thread Dave Watts
Dave...sorry for the lack of information, after read what I posted I thought I should have given a little more information. My form looks like this: form action=#self#?fuseaction=admin.selectSongs name=songSelect method=post input type=text name=week_of size=25 maxlength=50 value= /

RE: need insert help please

2007-03-10 Thread Bob Imperial
This was copied from a separate display page I setup for band members to download their songs from, just hadn't pulled out the link refs yet. This isn't for the public, actually it's for members of a worship band from church...to make It a little easier for folks to get to their material for the

RE: need insert help please

2007-03-10 Thread Dave Watts
I am passing this to: cfloop list=#Form.songTitle# index=item cfquery name=current_week datasource=#dsdata# username=myname password=mypwd INSERT INTO current_week (song_title) VALUES ('#item#') /cfquery /cfloop I'm not seeing where to shoe-horn the week_of value into the

RE: need insert help please

2007-03-10 Thread Bob Imperial
[mailto:[EMAIL PROTECTED] Sent: Saturday, March 10, 2007 8:03 PM To: CF-Talk Subject: RE: need insert help please I am passing this to: cfloop list=#Form.songTitle# index=item cfquery name=current_week datasource=#dsdata# username=myname password=mypwd INSERT INTO current_week (song_title

Re: Need mac users help please

2007-02-10 Thread Mark Drew
- From: Tom McNeer [mailto:[EMAIL PROTECTED] Sent: Friday, February 09, 2007 3:27 PM To: CF-Talk Subject: Re: Need mac users help please Hi Bob, If someone out there on a Mac would be so kind as to check these issues for me, I would actually take the weekend off ;-) No problems

Need mac users help please

2007-02-09 Thread Bob Imperial
I have some mp3 files and word docs setup and displayed using cfdirectory list, everything displays fine and the whole right-click thing works well on PC, although, I got the following message from a friend who is on a Mac. If someone out there on a Mac would be so kind as to check these issues

Re: Need mac users help please

2007-02-09 Thread Tom McNeer
Hi Bob, If someone out there on a Mac would be so kind as to check these issues for me, I would actually take the weekend off ;-) No problems for me, in either Firefox or Safari. I don't have IE for the Mac, so I don't know what would happen there. There's no reason to right-click anything.

RE: Need mac users help please

2007-02-09 Thread Bob Imperial
Thanks Tom ;-) I am now not going to work late tonight -Original Message- From: Tom McNeer [mailto:[EMAIL PROTECTED] Sent: Friday, February 09, 2007 3:27 PM To: CF-Talk Subject: Re: Need mac users help please Hi Bob, If someone out there on a Mac would be so kind as to check

Cookie list help please

2007-01-22 Thread Doug Brown
Please check out the below code, I would like to show users a previous search history and everything seems to work ok except that on the first time through it appends the seach phrase twice. I understand why it is happening, (due to the 2nd conditional statement) but cannot figure out a better

Solved Maybe (Cookie list help please)

2007-01-22 Thread Doug Brown
: Monday, January 22, 2007 6:45 AM Subject: Cookie list help please Please check out the below code, I would like to show users a previous search history and everything seems to work ok except that on the first time through it appends the seach phrase twice. I understand why it is happening, (due

RE: Cookie list help please

2007-01-22 Thread Dave Watts
Please check out the below code, I would like to show users a previous search history and everything seems to work ok except that on the first time through it appends the seach phrase twice. I understand why it is happening, (due to the 2nd conditional statement) but cannot figure out a

OT: .NET Help Please

2006-11-05 Thread So Kenfused
^%^$%$%$*( Now that I got that out of the way I feel a little better. I realize there is a .NET forum, but it's not used much and I am hoping for immediate help. Big database change at work this morning. I went in and changed all the dsn settings in the CFADMIN. All CF applications

RE: .NET Help Please

2006-11-05 Thread Dave Watts
The report works from the programmers desktop. However, when loaded onto the server it fails. With the following error. All permissions on the file, folder, and IIS are the same. I have actually gone in and opened up the permissions on the file to FULL for EVERYONE, USERS, and all other

Re: .NET Help Please

2006-11-05 Thread So Kenfused
The report works from the programmers desktop. However, when My guess is that the file is locked by something. You can probably fix this by simply rebooting the server, or if you don't want to reboot you can identify and remove the lock if possible. Google windows remove file lock for more

Re: .NET Help Please

2006-11-05 Thread So Kenfused
I've tried rebooting the server to no avail. The report works from the programmers desktop. However, when My guess is that the file is locked by something. You can probably fix this by simply rebooting the server, or if you don't want to reboot you can identify and remove the lock if

Re: .NET Help Please

2006-11-05 Thread Robertson-Ravo, Neil (RX)
- From: Dave Watts To: CF-Talk Sent: Sun Nov 05 18:58:36 2006 Subject: RE: .NET Help Please The report works from the programmers desktop. However, when loaded onto the server it fails. With the following error. All permissions on the file, folder, and IIS are the same. I have actually gone

Re: ugh... CFLOGIN Help please

2006-09-15 Thread Brent Nicholas
James - So if I understand you correctly 1) the act_Login page stores the login information to the session. 2) to get at that information you neeed to fire off the cflogin tag to pull the information into the page for use. I'll give it a shot. Thanks for your time. BN On index.cfm,

Re: ugh... CFLOGIN Help please

2006-09-15 Thread Brent Nicholas
This worked perfectly. It's an odd way of doing things, but it worked. Thank you, BN ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to

ugh... CFLOGIN Help please

2006-09-14 Thread Brent Nicholas
Ok, so I've searched and read the posts on this list about CFLOGIN, I've read Brandon Purcell's power point and read over all the Macromedia documentation. I'm actually using most of their code, though I've rearranged it to make more sense in what I'm doing to prove the concept. In short it

Re: ugh... CFLOGIN Help please

2006-09-14 Thread Brent Nicholas
This may make it easier to address this issue. It's all the files in a folder ready to test. http://www.cflhd.gov/TeleconfDocs/LoginTestingbak.zip Thanks again - BN Ok, so I've searched and read the posts on this list about CFLOGIN, I've read Brandon Purcell's power point and read over

Re: ugh... CFLOGIN Help please

2006-09-14 Thread James Holmes
On index.cfm, you need to run a cflogin tag before the getAuthUser() function will work. This is true in any page that you intend to protect with CFLOGIN authentication. On 9/15/06, Brent Nicholas [EMAIL PROTECTED] wrote: This may make it easier to address this issue. It's all the files in a

Help please

2006-08-04 Thread Doug Brown
Have not used CF in a long time...cannot see user tables in RDS in CF Studio 5. I am using SQL 2000 and CF 5 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by

RE: Help please

2006-08-04 Thread Loathe
To: CF-Talk Subject: Help please Have not used CF in a long time...cannot see user tables in RDS in CF Studio 5. I am using SQL 2000 and CF 5 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up

Re: Help please

2006-08-04 Thread Doug
, 2006 6:35 PM To: CF-Talk Subject: Help please Have not used CF in a long time...cannot see user tables in RDS in CF Studio 5. I am using SQL 2000 and CF 5 ~| Introducing the Fusion Authority Quarterly Update. 80

  1   2   3   4   5   >