excel dsn woes (file used by another process)

2003-04-01 Thread Boldacious
Hi I have a situation where I get 6 different excel spreadsheets uploaded to a website - then have to import them into one database (I do not have any control over this). The spreadsheets have the same fields. I have an excel DSN called update So I upload the 6 files, loop over each

CF based blogging software

2003-04-01 Thread Michael Dinowitz
Has there been any movement on this front? I found Fuseblog but can't see any way to download it. I'd rather use a CF based blogging system than not and if I wait to write my own it'll take almost forever. I need to convince a company to let me write a blogger for them for a fee. :) Michael

Re: CF based blogging software

2003-04-01 Thread Jochem van Dieten
Michael Dinowitz wrote: Has there been any movement on this front? I found Fuseblog but can't see any way to download it. I'd rather use a CF based blogging system than not and if I wait to write my own it'll take almost forever. BlogMX, http://www.benorama.com/ Jochem

Re: CF based blogging software

2003-04-01 Thread Michael Dinowitz
Thanks. I'll try it out but for some reason it 'feels' overly complicated. Michael Dinowitz wrote: Has there been any movement on this front? I found Fuseblog but can't see any way to download it. I'd rather use a CF based blogging system than not and if I wait to

activePDF webgrabber

2003-04-01 Thread Adam Reynolds
Has anybody had issues with this product and ColdFusion MX cfchart? Although I can successfully web grab any screen with graphics, the moment I attempt to web grab a report containing 15 cfchart graphs, it doesn't even get passed the 1st graph. Slightly doing my head in. Adam

RE: CF based blogging software

2003-04-01 Thread Benoit Hediard
Hi everyone, BlogMX on benorama.com is just a very basic example application, and is definitely not a complete blogging system (and as you rightly said, it is overly complicated for what it does, because it is just a sample application showing a methodology aimed to build more complex

Oracle CF5

2003-04-01 Thread Simon Whittaker
Hi all, I have a bit of a problem I wouldn't mind some help with - We are using CF5 and Oracle 8i(8.1.7.0.0) (using Native drivers) and our application is running REALLY slowly. We have tuned the queries as much as we see possible and cached wherever possible although the neature of the

RE: activePDF webgrabber

2003-04-01 Thread Adam Reynolds
Just to udate. You must have WebGrabber.EngineToUse = 1 set to make it work. -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED] Sent: 01 April 2003 09:54 To: CF-Talk Subject: activePDF webgrabber Has anybody had issues with this product and

CF is creating a new session after each page refresh!

2003-04-01 Thread Oliver Cookson
Hi, I have just developed an application in CF 5 which is using session variables and I am coming across some strange behavior by CF. On each page load CF is assigning a new session to each page visit, I know this as CFID increments by one after I use CFDUMP VAR =”#session#” at the

SQL: Deleting items older than 7 days from today

2003-04-01 Thread Angel Stewart
Hey all, I'm trying to do this with a single SQL statement. Delete all records from the table tblEvents that are older than 7 days. :) This is the code I tried using: CFQUERY name=DE Datasource=#DSN# Select * FROM tblEvents WHERE Now() - estarttime = 7 /CFQUERY

RE: Deleting items older than 7 days from today

2003-04-01 Thread Scott Wilhelm
Try this: WHERE DATEDIFF(d, estarttime, NOW()) = 7 HTH! Scott -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 9:12 AM To: CF-Talk Subject: SQL: Deleting items older than 7 days from today Hey all, I'm trying to do this with a

loopy loop!

2003-04-01 Thread Chris Edwards
I have this loop that runs ~22,000 iterations. It brings the server to its knees. The RAM usage skyrockets above 800 Megs cutting into major virtual memory. But when I just write the output instead of storing it to a variable, it runs fine. I'm trying to retrieve a list of email addresses and

RE: cf forum suggestions

2003-04-01 Thread Douglas.Knudsen
we use http://forum.snitz.com/ lately...its free...an ASP app, so you need a winblows server for it. Works well enough. Doug -Original Message- From: Jas Panesar [mailto:[EMAIL PROTECTED] Sent: Monday, March 31, 2003 11:56 PM To: CF-Talk Subject: cf forum suggestions Apologize for

RE: Deleting items older than 7 days from today

2003-04-01 Thread Angel Stewart
'#DateDiff('d',Now(),estarttime)# Error near line 17, column 9. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4

RE: CF based blogging software

2003-04-01 Thread Mike Brunt
Michael, I have a copy of Fuseblog if you would like me to send it to you off-line. We used it as the basis for our blog. I also tried out Benoit's CFC based blog after we had already set up Fuseblog and that is very interesting conceptually with its use of CFC's, XML etc. Kind Regards - Mike

RE: Deleting items older than 7 days from today

2003-04-01 Thread Scott Wilhelm
Don't use CF for it, let the SQL do the work for you... Just setup your SQL statement like this: Select * FROM tblEvents WHERE DateDiff(d, GETDATE(), estarttime) = 7 (Sorry, I referenced NOW() last time...it should be GETDATE()) HTH, Scott -Original Message- From: Angel Stewart

Re: loopy loop!

2003-04-01 Thread Marlon Moyer
How about replacing it with: Warning - Not tested ! cfscript emails = replace(valuelist(list.email,|),|,chr(13)chr(10),ALL); /cfscript Marlon Chris Edwards wrote: I have this loop that runs ~22,000 iterations. It brings the server to its knees. The RAM usage skyrockets above 800 Megs

RE: Dynamic anchors on CF Page

2003-04-01 Thread Clark, Aimee
Well, based on what you're suggesting Issac, my page isn't having the problem described below. For instance, presently I have 6 different hyperlinks to bookmarks on my page. When I click the last hyperlink, it takes me down about halfway into the page which is about the 3rd headline(bookmark).

Re: loopy loop!

2003-04-01 Thread Dave Carabetta
I have this loop that runs ~22,000 iterations. It brings the server to its knees. The RAM usage skyrockets above 800 Megs cutting into major virtual memory. But when I just write the output instead of storing it to a variable, it runs fine. I'm trying to retrieve a list of email addresses and

how to make it go faster?

2003-04-01 Thread Chris Edwards
I have this: cfset emailtowrite = cfloop query=list cfset emailtowrite = list.email chr(13) chr(10) cffile action=append file=#ExpandPath(users.lst)# output=#emailtowrite# /cfloop It still takes forever. Is there a faster method? -- Chris Edwards Web Application

RE: Deleting items older than 7 days from today

2003-04-01 Thread Angel Stewart
Ehmm...now I get the error that GetDate can't resolve. I'm using your exact syntax for the datediff statement. I saw that I used dd Instead of 'd' at first..so I changed that. But it still doesn't help. It seems that within the SQL statement it can't resolve the SQL field if I use a CF Function.

RE: CF based blogging software

2003-04-01 Thread Raymond Camden
You can also download my blog code for free. (Link is below.) === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email

Re: how to make it go faster?

2003-04-01 Thread Dave Carabetta
I have this: cfset emailtowrite = cfloop query=list cfset emailtowrite = list.email chr(13) chr(10) cffile action=append file=#ExpandPath(users.lst)# output=#emailtowrite# /cfloop It still takes forever. Is there a faster method? Chris, any time you use cffile

RE: how to make it go faster?

2003-04-01 Thread Simon Horwith
how about not looping at all: cfset emailtowrite = valueList(list.email,#chr(13)##chr(10)#) cffile action=append file=#ExpandPath(users.lst)# output=#emailtowrite# ~Simon Simon Horwith Macromedia Certified Instructor Certified Advanced ColdFusion MX Developer Certified Flash

HTML Prob

2003-04-01 Thread Shahzad.Butt
How can I display text with in value of input tag Input type=text name=test value=this is test with inverted commas What I am getting is text between first two inverted commas I mean Result: this is test with but I want complete results Required Result: this is test with inverted

RE: how to make it go faster?

2003-04-01 Thread Scott Wilhelm
Chris: What is your final intent with the document you're outputting to? Scott -Original Message- From: Chris Edwards [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 9:56 AM To: CF-Talk Subject: how to make it go faster? I have this: cfset emailtowrite =

Re: how to make it go faster?

2003-04-01 Thread Chris Edwards
forever is : 182713 milliseconds-- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com - Original Message - From: Dave Carabetta [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, April 01, 2003

Re: Deleting items older than 7 days from today

2003-04-01 Thread David Fafard
Try this. delete from tblEvents where DATEDIFF(dd,estarttime , getdate()) 7 Dave - Original Message - From: Angel Stewart [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 9:12 AM Subject: SQL: Deleting items older than 7 days from today Hey all, I'm

RE: HTML Prob

2003-04-01 Thread Tangorre, Michael
input type=Text name=testBox value=ldquo; this is in quotes rdquo; -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 10:03 AM To: CF-Talk Subject: HTML Prob How can I display text with in value of input tag Input type=text name=test

HTML Prob

2003-04-01 Thread Shahzad.Butt
How can I display text with in value of input tag Input type=text name=test value=this is test with inverted commas What I am getting is text between first two inverted commas I mean Result: this is test with but I want complete results Required Result: this is test with inverted commas

Re: loopy loop!

2003-04-01 Thread Chris Edwards
cfscript emails = replace(valuelist(list.email,|),|,chr(13)chr(10),ALL); /cfscript before 182713 milliseconds-- After 77502 milliseconds Thats better. Can I make it go faster? This is on a windows box( p3 1ghtz, 512ram ) CF5. -- Chris Edwards Web Application Developer Outer Banks

RE: HTML Prob

2003-04-01 Thread Ryan Kime
How about using quot; ??? -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 9:10 AM To: CF-Talk Subject: HTML Prob How can I display text with in value of input tag Input type=text name=test value=this is test with inverted commas What I

RE: Deleting items older than 7 days from today

2003-04-01 Thread Angel Stewart
That didn't work either. Error Diagnostic Information An error occurred while evaluating the expression: #DATEDIFF('dd',estarttime , Now())# Error near line 17, column 9. ~| Archives:

RE: Deleting items older than 7 days from today

2003-04-01 Thread Scott Wilhelm
Ok, I think I've found it in my BOL docs...Try this: SELECT * FROM tblEvents WHERE DATEDIFF(d, estatetime, #DATEFORMAT(NOW())#) HTH -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 9:53 AM To: CF-Talk Subject: RE: Deleting items older

RE: Deleting items older than 7 days from today

2003-04-01 Thread Matthew Small
Try what you had before: Select * FROM tblEvents WHERE DateDiff(d, GETDATE(), estarttime) = 7 There is no CF in this query, therefore no need for pound signs. This should work for SQL2K. Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC

RE: Deleting items older than 7 days from today

2003-04-01 Thread Angel Stewart
Nope..that didn't work either. Still error resolving estarttime. -Gel -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED] Ok, I think I've found it in my BOL docs...Try this: SELECT * FROM tblEvents WHERE DATEDIFF(d, estatetime, #DATEFORMAT(NOW())#) HTH

Re: loopy loop!

2003-04-01 Thread Tony Schreiber
I prepare inventory files to upload to Half.com and Amazon marketplace. Some 150k records or so. I used to run the script so that I appended each row to a variable, then when done, wrote this variable to a file - thinking that the variable would take less time that writing to a file 150k times.

RE: HTML Prob

2003-04-01 Thread Shahzad.Butt
That's fine it works, thanks. However I wonder if you help me here as well. Basically what I am doing is Value=#myVar# And my var is coming from DB with value I am text with inverted commas. Now if I would be able to make a list with delimiter of then I can loop and just stick quote;

RE: loopy loop!

2003-04-01 Thread Simon Horwith
file I/O operations are very fast - their speed tends to be under-estimated by developers. One thing you should watch out for are concurrency issues... I recommend using named locks whenever accessing the local file system. ~Simon Simon Horwith Macromedia Certified Instructor Certified

Re: Oracle CF5

2003-04-01 Thread Chris Norloff
I don't have any great ideas, but one thing I'd do is put the connectstring into the CFQUERY itself to see what happens. If things go faster then the problem is in accessing the tnsnames.ora file. We had some problems during load testing CF4.5,SP2 and Oracle 8.1.7 where the problem was

Generic XML App

2003-04-01 Thread Daniel Napolitano
Hi We are looking into XML at the moment for a project, however we have come across an idea and was wondering if anyone else had seen such a tool or if the idea was totally mad. The idea is to take a XML Scheme document, and put it into a parser. It in turn would create a ColdFusion

Re: Generic XML App

2003-04-01 Thread Dave Carabetta
We are looking into XML at the moment for a project, however we have come across an idea and was wondering if anyone else had seen such a tool or if the idea was totally mad. The idea is to take a XML Scheme document, and put it into a parser. It in turn would create a ColdFusion application

RE: HTML Prob

2003-04-01 Thread Philip Arnold
If the value is coming from a CF Variable, then you could try; input type=text name=test value=#HTMLeditFormat(form.test)# That naturally converts into quot; (as well as a few others) -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 4:03

RE: how to make it go faster?

2003-04-01 Thread Philip Arnold
I have this: cfset emailtowrite = cfloop query=list cfset emailtowrite = list.email chr(13) chr(10) cffile action=append file=#ExpandPath(users.lst)# output=#emailtowrite# /cfloop It still takes forever. Is there a faster method? Which database engine is it?

Re: HTML Prob

2003-04-01 Thread Kwang Suh
Use the function htmlEditFormat e.g. input type=text value=#htmlEditFormat(myVar)# - Original Message - From: Shahzad.Butt [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 8:41 AM Subject: RE: HTML Prob That's fine it works, thanks. However I wonder if

RE: HTML Prob

2003-04-01 Thread Shahzad.Butt
Thanks -Original Message- From: Kwang Suh [mailto:[EMAIL PROTECTED] Sent: 01 April 2003 16:52 To: CF-Talk Subject: Re: HTML Prob Use the function htmlEditFormat e.g. input type=text value=#htmlEditFormat(myVar)# - Original Message - From: Shahzad.Butt [EMAIL PROTECTED] To:

-OT- Javascript and combo boxes

2003-04-01 Thread Thane Sherrington
Is it possible to use Javascript to select a choice in a combo box? For instance, if I have a form with people listed, and beside each, a combo box with all the departments in the company, can I select a department in the first combobox, and have the other combo boxes automatically switch to

Re: how to make it go faster?

2003-04-01 Thread Chris Edwards
I'm using MySQL. I have this now: cfscript email_list = replace(valuelist(list.email,|),|,chr(13)chr(10),ALL); /cfscript cffile action=write file=#ExpandPath(users.lst)# output=#email_list# It takes about 70 seconds to run. Which is ok by me for right now. I'm going to try and

RE: Dynamic anchors on CF Page

2003-04-01 Thread S . Isaac Dealey
That sucks... I'm about tapped for ideas at this point... Wish I had any other suggestions to offer... Have you tested it on multiple machines / browsers to make sure it's not just a problem with your particular setup? Well, based on what you're suggesting Issac, my page isn't having the

RE: Dynamic anchors on CF Page

2003-04-01 Thread Clark, Aimee
Ok, well it turns out that for some reason I was using 2 different queries. The bookmarks were for one and the content for the other. (You must understand, I am being taught ASP in which this is a somewhat necessary demon). At any rate, I consolidated the queries down to 1, then I had to output it

RE: Dynamic anchors on CF Page

2003-04-01 Thread Russ
Sorry I missed this one--I had to arm-wrestle with it a couple months back. Here's a snippet: tr td !--- Naming my anchor --- p align=lefta name=Comment#qCommentDisplay.commentID#/aa href=profileView.cfm?profileID=#profileID# class=commentNameu#profileLogin#/u/au span class=blinkCopy -

Re: -OT- Javascript and combo boxes

2003-04-01 Thread Chris Montgomery
Howdy Thane, Tuesday, April 1, 2003, 10:03:33 AM, Thane Sherrington wrote: Is it possible to use Javascript to select a choice in a combo box? For instance, if I have a form with people listed, and beside each, a combo box with all the departments in the company, can I select a department

RE: loopy loop!

2003-04-01 Thread Jim Davis
-Original Message- From: Simon Horwith [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 10:47 AM To: CF-Talk Subject: RE: loopy loop! file I/O operations are very fast - their speed tends to be under-estimated by developers. One thing you should watch out for are

Loopy Loop Fast SOLVED

2003-04-01 Thread Chris Edwards
Thanks for all the help. Takes ~ 14 seconds. Down from the original ~180 !--- get email list --- cfquery name=list datasource=#Request.App.Db# SELECT DISTINCT CONCAT(email,'\r\n') AS email FROM `mail_subscriptions` #optlist# /cfquery cffile action=write file=#ExpandPath(users.lst)#

truncated log data

2003-04-01 Thread Robert Orlini
I'm using SQL via CF to try to read my CF application.log file and display the data on screen. I stripped out some characters on some of the rows, unfortunately on some rows all the data does not display. For example, one row has this info:

ChartFX and CFMX?

2003-04-01 Thread erica . lomax
Does anyone have any experience with ChartFX and CFMX? I was wondering if there were any COM compatibility issues with this product that anyone has encountered. We've currently got a copy on our CF4.5 server, and want to move to CFMX. Erica Lomax Corporate Engineering Division Abbott

ColdFusion Focus Group Invitation

2003-04-01 Thread Tim Buntel
Hello!?xml:namespace prefix = o ns = urn:schemas-microsoft-com:office:office / The ColdFusion product team is seeking participants for a live Internet focus group to discuss some details concerning future versions of ColdFusion. The meeting will be held early in the week beginning April 7th

RE: ColdFusion Focus Group Invitation

2003-04-01 Thread Kris Pilles
Kris Pilles Website Manager Western Suffolk BOCES 507 deer park Rd, dix hills, ny 11746 5, MX Pro Enterprise Over 3 years (personally) agency over 2 -Original Message- From: Tim Buntel [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 12:06 PM To: CF-Talk Subject: ColdFusion

RE: CF based blogging software

2003-04-01 Thread Bryan F. Hogan
Michael, as some may know I have been working on one for the last few months. It is fully plug and playable, platform independent and driven by XML, it produces rss feeds in versions 0.92 and 1. I'm working on stuffing the functionality into cfc's now. I have full add/edit/delete entry

RE: ColdFusion Focus Group Invitation

2003-04-01 Thread Kris Pilles
I HATE THAT! -Original Message- From: Tim Buntel [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 12:06 PM To: CF-Talk Subject: ColdFusion Focus Group Invitation Hello!?xml:namespace prefix = o ns = urn:schemas-microsoft-com:office:office / The ColdFusion product team is

RE: ColdFusion Focus Group Invitation

2003-04-01 Thread Angel Stewart
Die frontpage die ^_^ *chuckle* -Gel -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED] I HATE THAT! -Original Message- From: Tim Buntel [mailto:[EMAIL PROTECTED] Hello!?xml:namespace prefix = o ns = urn:schemas-microsoft-com:office:office /

Re: truncated log data

2003-04-01 Thread ksuh
Use htmlEditFormat... use htmlEditFormat Garrkkk... My last word on this planet will be htmlEditFormat - Original Message - From: Robert Orlini [EMAIL PROTECTED] Date: Tuesday, April 1, 2003 9:54 am Subject: truncated log data I'm using SQL via CF to try to read my CF

OT - Recommend a good, free web tracking software

2003-04-01 Thread ecreese
Anyone have any good recommendations as well as links? Get your own free email account from http://www.popmail.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4

RE: Dynamic anchors on CF Page

2003-04-01 Thread S . Isaac Dealey
Ahh... Well, glad to know you were able to get it all working. :) I've worked in ASP myself -- about 3-4 years ago now I was a crack ASP programmer -- unfortunately for my boss I already knew ColdFusion. I'm lead to believe that I was pretty good at it but god those tools were hideous. ASP 3 or

RE: OT - Recommend a good, free web tracking software

2003-04-01 Thread Cantrell, Adam
Web tracking or raw log analyzer? If log analyzer: http://awstats.sourceforge.net/ Adam. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 11:32 AM To: CF-Talk Subject: OT - Recommend a good, free web tracking software Anyone

RE: Dynamic anchors on CF Page

2003-04-01 Thread Clark, Aimee
It's not too bad. I haven't migrated to .NET, not sure I want to just yet, but I do find it annoying that I have to code so many loops in ASP. I really liked how CF does that for you. However, on the flipside, it is easier to control what the loop is doing in ASP than in CF. -Original

Re: Generic XML App

2003-04-01 Thread S . Isaac Dealey
Considering that an XML Schema is written in XML I'd say it's definitely possible, as a matter of fact, it's what the XML authority really hoped would happen once XML Schema became the standard as opposed to the older DTD's. I'm not aware of any CF apps that do it currently -- I suspect it'd be a

Re: SQL: Deleting items older than 7 days from today

2003-04-01 Thread Cary Gordon
If you are going to be doing this regularly, you should consider using a stored procedure, assuming your database supports them. Cary Gordon The Cherry Hill Company At 10:12 AM 4/1/2003 -0400, you wrote: Hey all, I'm trying to do this with a single SQL statement. Delete all records from the

RE: OT - Recommend a good, free web tracking software

2003-04-01 Thread Shawn Grover
Webalizer is pretty good. www.webalizer.com Free (i.e. open source), cross platform, and easy to setup - if you don't mind working with config files Shawn -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 10:32 AM To: CF-Talk

RE: OT - Recommend a good, free web tracking software

2003-04-01 Thread Tony Schreiber
Vote two for webalizer. (I worked with the guy who wrote it. ;) ) Webalizer is pretty good. www.webalizer.com Free (i.e. open source), cross platform, and easy to setup - if you don't mind working with config files Shawn -Original Message- From: [EMAIL PROTECTED]

Re: -OT- Javascript and combo boxes

2003-04-01 Thread Thane Sherrington
At 10:39 AM 4/1/03 -0600, Chris Montgomery wrote: Howdy Thane, Tuesday, April 1, 2003, 10:03:33 AM, Thane Sherrington wrote: Is it possible to use Javascript to select a choice in a combo box? For instance, if I have a form with people listed, and beside each, a combo box with all the

Re: -OT- Javascript and combo boxes

2003-04-01 Thread charlie griefer
the general rule for selecting an option in a combo box is: document.formName.selectBoxName.selectedIndex = n where n is your number (remember, the first option is 0) In your case, i'd guess you want to store the names of your 30 combo boxes in an array, and add a function for onchange into

RE: -OT- Javascript and combo boxes

2003-04-01 Thread Bruce, Rodney S HQISEC/Veridian IT Services
Thane You might want to look into Fusionscript at www.fusionscript.com With this you can do calls back to the database without refreshing your page. This is an example of a FS function: !start of FS function cf_fs_function name=MyFunction !---Calls the server page with

RE: -OT- Javascript and combo boxes

2003-04-01 Thread Jerry Johnson
I think what he really wants is a script that will receive a select object and value (probably an onChange event) And then find all the select boxes with the same naming convention but larger sequence numbers, and set them all to the new value. Thane, is this closer? Jerry Johnson [EMAIL

RE: -OT- Javascript and combo boxes

2003-04-01 Thread Thane Sherrington
At 02:12 PM 4/1/03 -0500, Jerry Johnson wrote: I think what he really wants is a script that will receive a select object and value (probably an onChange event) And then find all the select boxes with the same naming convention but larger sequence numbers, and set them all to the new value.

RE: truncated log data

2003-04-01 Thread Robert Orlini
Thanks Ksuh. This helped by displaying more log info than before. One problem persists though, somewhere after displaying a good number of records, it craps out and displays html code right to the end. Any help would be appreciated. Robert O. HWW Here's my code: cfquery name=getsomedata

Re: -OT- Javascript and combo boxes

2003-04-01 Thread Thane Sherrington
At 11:53 AM 4/1/03 -0700, charlie griefer wrote: the general rule for selecting an option in a combo box is: document.formName.selectBoxName.selectedIndex = n where n is your number (remember, the first option is 0) Excellent. I think I can muddle through from here. :) T

RE: -OT- Javascript and combo boxes

2003-04-01 Thread Thane Sherrington
At 12:06 PM 4/1/03 -0700, Bruce, Rodney S HQISEC/Veridian IT Services wrote: Thane You might want to look into Fusionscript at www.fusionscript.com With this you can do calls back to the database without refreshing your page. Hmmm...this might be a bit of overkill for what I'm doing but it is

RE: -OT- Javascript and combo boxes

2003-04-01 Thread Jason Egan
Thank you! -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 12:07 PM To: CF-Talk Subject: RE: -OT- Javascript and combo boxes Thane You might want to look into Fusionscript at www.fusionscript.com With this

RE: -OT- Javascript and combo boxes

2003-04-01 Thread Bruce, Rodney S HQISEC/Veridian IT Services
oops, maybe I read your post wrong. If you are looking at setting all the selects to the same option try something like this: Don't know how you have your selects named now but if they are in order like: MySelect1 OnChange=resetlists(1) MySelect2 OnChange=resetlists(2) MySelect3

RE: Dynamic anchors on CF Page

2003-04-01 Thread S . Isaac Dealey
Does ASP 3 have a method of using variables when specifying an included template (like cfinclude)? When I was working with it we only had SSI includes, which all get processed prior to the ASP engine, so you couldn't use variables in them. And all the ASP developers I knew were using switch-case

RE: -OT- Javascript and combo boxes

2003-04-01 Thread Thane Sherrington
At 12:27 PM 4/1/03 -0700, Bruce, Rodney S HQISEC/Veridian IT Services wrote: oops, maybe I read your post wrong. If you are looking at setting all the selects to the same option try something like this: I appreciate it. Thanks. T

Updating to CFMX Updater 3 causes client ASP functions to stop working?

2003-04-01 Thread Charles Nahm
Is this a known issue or is it likely that something else is at fault here? The ASP was working fine before the update, no changes were made and now not working after the CFMX update. Does this sound plausible? CFMX w/ IIS 5, everything patched to current. Charles --- Outgoing mail is

CF Scheduler?

2003-04-01 Thread Randell B Adkins
Any idea why in the log file for scheduler, I see that my Scheduled Task has been initiated and completed but nothing happens. When I run the tasks from the browser (on the server) it runs without a problem and processes the messages as designed? BTW: CF 5 is the server and IE is the browser.

RE: Deleting items older than 7 days from today

2003-04-01 Thread Angel Stewart
You know..if I use just plain SQL..how does it know if I mean 7 Days..7 Weeks..or 7 months?? -Gel -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED] Nope..that didn't work either. Still error resolving estarttime. -Gel -Original Message- From: Scott Wilhelm

RE: Deleting items older than 7 days from today

2003-04-01 Thread Matthew Small
What does your query look like right now? Also the 'd' in the datediff function lets the query know to use days. Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com -Original

Searching (Verity?)

2003-04-01 Thread charlie griefer
Hey All: I've been given about 30 HTML docs. They comprise a manual that mgmt wants to put online. These are very long pages (there's a table of contents with close to a hundred links...pointing to anchors within pages). A request has come in to make it searchable. I built a Verity

RE: Searching (Verity?)

2003-04-01 Thread Tim Laureska
How about a pdf? -Original Message- From: charlie griefer [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 2:52 PM To: CF-Talk Subject: Searching (Verity?) Hey All: I've been given about 30 HTML docs. They comprise a manual that mgmt wants to put online. These are very long

Re: Searching (Verity?)

2003-04-01 Thread charlie griefer
Tim: I'd still have 30-ish PDFs, which, when searched, would go to the top of each PDF. Looking for some way to point not only to a document that contains the search term, but to point to the spot within the document that contains the search term. There is actually a desktop version of

RE: Searching (Verity?)

2003-04-01 Thread Tim Laureska
Are these docs too large to incorporate into 1 PDF ?... if you do that, then there is that type of search capability ... just a thought -Original Message- From: charlie griefer [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 3:02 PM To: CF-Talk Subject: Re: Searching (Verity?)

Re: Searching (Verity?)

2003-04-01 Thread charlie griefer
hmm..i didn't realize that type of searching was available in PDFs. Is it thru Verity? Unfortunately tho, it would also mean having to re-do all of the table of contents. but at least it's an option i can present for consideration. thx, charlie Tim Laureska writes: Are these docs too

Re: Searching (Verity?)

2003-04-01 Thread Jerry Johnson
I'm sure money is an issue (it always is) but these product rocks. You can probably get the site up and searchable this week. And it jumps to specific items within a PDF too. http://www.dtsearch.com/dtweb.html Jerry Johnson [EMAIL PROTECTED] 04/01/03 03:02PM Tim: I'd still have 30-ish

Re: CF Scheduler?

2003-04-01 Thread S . Isaac Dealey
Any idea why in the log file for scheduler, I see that my Scheduled Task has been initiated and completed but nothing happens. When I run the tasks from the browser (on the server) it runs without a problem and processes the messages as designed? BTW: CF 5 is the server and IE is the

OT:Oraclequery-quick question on an insert

2003-04-01 Thread Janine Jakim
I have an insert query that I can't get to work... when I remove the top line and run it as a select statement it's fine. when I add the insert statement I get the error 'invalid number' job_ID is actually a varchar2 field- not a number field. here's the query INSERT INTO HR_DEPARTMENTS

Display Excel Data

2003-04-01 Thread Michael Pool
I am trying to deliver spreadsheets in my browser using CF and BlueDragon. I can't get it to display correct. Anyone know what the problem could be?? Here is the code I am using CFSETTING ENABLECFOUTPUTONLY=yes CFQUERY name=PrimaryUserNames datasource=DeploymentDB SELECT * FROM

Re: Display Excel Data

2003-04-01 Thread Jerry Johnson
You need to tell the browser that you are trying to deliver a different MIME type than the usual HTML. The CFCONTENT tag should get you there, I think. Jerry Johnson [EMAIL PROTECTED] 04/01/03 07:43PM I am trying to deliver spreadsheets in my browser using CF and BlueDragon. I can't get it

RE: Display Excel Data

2003-04-01 Thread Douglas.Knudsen
try CFHEADER NAME=Content-Disposition VALUE=Inline;filename=foo.xls cfcontent type=application/vnd.ms-excel Doug -Original Message- From: Michael Pool [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 7:44 PM To: CF-Talk Subject: Display Excel Data I am trying to deliver

RE: Searching (Verity?)

2003-04-01 Thread Mark Leder
See if dtSearch will work - www.dtsearch.com - just an idea :-) Thanks, Mark -Original Message- From: charlie griefer [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 3:02 PM To: CF-Talk Subject: Re: Searching (Verity?) Tim: I'd still have 30-ish PDFs, which, when searched,

Is there a trick...

2003-04-01 Thread Che Vilnonis
Is there a trick...to getting Request variables to work with pages that have frames? Something like this works in pages without frames. What gives? cflock SCOPE=Application THROWONTIMEOUT=NO TIMEOUT=10 TYPE=Exclusive cfscript Application.BGColor=FF;

RE: Is there a trick...

2003-04-01 Thread John Quarto-vonTivadar
Think of frames as individual pages. Including not only the page that creates the frame, but each frame's SRC attribute. Therefore each has its own set of request variables that have to be handled in the same way that individual pages have to handle them. Once you get this, then dealing with

  1   2   >