Re: How do I parse strings?

2001-05-31 Thread Ken Beard
make a condition loop that goes through your string and trims off line by line into an carriage return delimited list, and maintains a variable called RemainingContent, which is everything that hasn't been trimmed yet. cr=chr(13)chr(10); space_reversePos=find(

RE: Upgrade problems

2001-05-31 Thread Cameron Childress
I have seen this when a query name starts with a numerical value. Works in 4.0, but not in 4.5. Strange but true. Change: CFQUERY datasource=visionquake name=#CurrentRow# to CFQUERY datasource=visionquake name=X#CurrentRow# -Cameron Cameron Childress elliptIQ Inc.

RE: Unstable MySQL on Windows 2000

2001-05-31 Thread John Lucas
We have seen no problems under WIN2K Advanced Server, CF 4.5.2, and MySQL. We've also run it on a WIN2K Server box. We used the compiled installer package from AbriaSoft. Not sure that makes a difference. http://www.abriasoft.com/ John Lucas [EMAIL PROTECTED] http://www.fastestisp.com

highlighting search terms

2001-05-31 Thread sebastian palmigiani
I want to develop a highlight function of search terms. The following works well except that it changes the case of the keyword in the output. For example, 'Cold' in the original becomes 'cold' in the output. What can I include in the code to keep the original case of the String? If I use

Re: [RE: [RE: Advices on dynamic SQL, please]]

2001-05-31 Thread Julia Phu
That's a good plan. I had thought to break the table into two. Thank you for the brain exercise. Julia Mark Warrick [EMAIL PROTECTED] wrote: Setup a table to store the flavor of the month (the category name). Query that table for the value. Then query the original table in the same manner

Re: [Protect Code]

2001-05-31 Thread Alex
uname hostname Mike [EMAIL PROTECTED] wrote: Is there a way to get some information about a computer that a program is run on? i.e. (computer name, processor ID, anything unique) We will have access during install and we are trying insure that or code will not be run on new machine with out or

Re: How do you to set allow zero length in access 2000 for memo field using sql

2001-05-31 Thread Jamie Jackson
Don't think you can. I found this reply to an identical question on the Web: I've been looking through the ANSI SQL documentation, and I can't find any syntax to do that. The allow zero length is an MS-Access quirk, anyway -- most databases (e.g. SQL Servers) just allow it -- and it certainly

Re: retrive content from db with cfoutput tag in the content

2001-05-31 Thread Jamie Jackson
When last I checked, there was no way to directly evaluate CF tags from a DB. I think people have been getting around this by creating (using cffile) a temp.cfm file with DB field's contents, and then including the created file. Good luck. Jamie On Wed, 30 May 2001 13:11:05 -0400, in cf-talk

Re: how do i send an attachment?

2001-05-31 Thread net_man
or mimeattach= - Original Message - From: JB [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 2:03 PM Subject: RE: how do i send an attachment? cfmail TO= CC= FROM= SUBJECT= cfmailparam file=c:/mydocuments/images/mypic.jpeg /cfmail

RE: how do i send an attachment?

2001-05-31 Thread Ryan Sabir
If the user browses the file locally, then the Cold Fusion server will not be able to see it. You will have to first use CFFILE action=Upload blah blah to save it from the client's browser to the server hard drive, then use the MIMEATTACH attribute to link it to CFMAIL using its path on the

RE: COOKIE expiration :((

2001-05-31 Thread Kevin Miller
I'm curious, will the new CFFLUSH tag resolve this problem? Kevin [EMAIL PROTECTED] 05/30/01 08:36AM You can consider setting up the cookie in a process page and redirect with javascript instead of cflocation that will allow the cookie to be set. M. --- Dylan Bromby [EMAIL PROTECTED] wrote:

RE: Newbie-CF trying to process Hex numbers :-)

2001-05-31 Thread John Lucas
You can't have single # within a cfoutput statement. Eliminate the # or use a ## instead. John Lucas -Original Message- From: Gina K. Anderson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 30, 2001 2:20 PM To: CF-Talk Subject: Newbie-CF trying to process Hex numbers :-) Hi all,

RE: Newbie-CF trying to process Hex numbers :-)

2001-05-31 Thread John Lucas
Sorry, I guess I should have been more clear #something# is ok. #FF is not ok. ##FF is ok FFF is ok -Original Message- From: Gina K. Anderson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 30, 2001 2:20 PM To: CF-Talk Subject: Newbie-CF trying to process Hex numbers

Re: isDate() regular expression

2001-05-31 Thread Jim McAtee
If you also want to validate the date (no Jun 31, for instance), it's going to be tough or impossible to do in a regex. You can use one or more regexes plus some code to parse and check the date, however. Do you want to do this in CF, or in JavaScript on the client side? In CF, can't you just

RE: Writing Custom Functions

2001-05-31 Thread Robert Everland III
What would be the scope of a UDF then? say udf.foo or function.foo? Bob Everland -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 30, 2001 3:05 PM To: CF-Talk Subject: RE: Writing Custom Functions Maybe I'm reading this wrong, but I have to

active edits

2001-05-31 Thread Janine Jakim
I have a form to show information for each quarter of the year (in a table). I need for users to only be able to update the current quarter- the past quarters should show but be display only. I have a table that lists the dates for the beginning/end of each quarter. My table has the fields:

RE: Newbie-CF trying to process Hex numbers :-)

2001-05-31 Thread Craig Fisher
#'s tell CF to evaluate something inside a CFOUTPUT. Because the line: body bgcolor=#FF text=#00 occurs after the line: cfoutput query=Contacts and before the line: /cfoutput CF thinks those # signs at the beginning of the color indicate a variable, function, or

Re: Protect Code

2001-05-31 Thread Bill Davidson
There are several third party system ID'ing code for license purposes. A popular one is Rainbow Technologies. http://www.rainbow.com -Bill www.brainbox.tv - Original Message - From: Mike [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 1:28 PM Subject:

Re: Newbie-CF trying to process Hex numbers :-)

2001-05-31 Thread Bill Davidson
It's because you have a pound sign inside of a cfoutput block. This is a special character for coldfusion to reference a variable. Either escape the # by doubling it up - ##, or just leave it out. It will work fine without #'s for representing hex values. -Bill www.brainbox.tv - Original

RE: Newbie-CF trying to process Hex numbers :-)

2001-05-31 Thread Sandy Clark
cfoutput query=Contacts html head titleAdd Contat/title meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 link rel=stylesheet href=style.css type=text/css /head body bgcolor=#FF text=#00 Double up your

Re: Newbie-CF trying to process Hex numbers :-)

2001-05-31 Thread Bill Davidson
Couple things I forgot to mention: 1) Yeah, books are boring, but Ben's book is outstanding and you can learn a lot from it. It is laid out very well, and covers things you really need to know (like this.) 2) You're including the header inside of cfoutput that is query driven - this will

RE: cffile DOES NOT WORK!!!

2001-05-31 Thread Ryan Sabir
This should be straightforward as I've done similar things before... are you able to post your code to the list, both the Upload page and the CFFILE page... just stick it in the body of the email and let us look over it. -Original Message- From: S R [mailto:[EMAIL PROTECTED]]

Re: Upgrade problems

2001-05-31 Thread Christine Kelley
Thanks!! Worked like a charm :) Christine - Original Message - From: Cameron Childress [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 4:57 PM Subject: RE: Upgrade problems I have seen this when a query name starts with a

Re: Newbie-CF trying to process Hex numbers :-)

2001-05-31 Thread Tony Schreiber
You need to escape pound signs by double-pounding them. If you hex codes are within CFOUTPUT or being process from a query, they need to look like this: ##FF ##99, etc... Have been learning CF, and going through the book ColdFusion 4.0 Web Application Construction Kit. Short story is

cfx uncode

2001-05-31 Thread Paul Hastings
attention cfx gurus: is anyone using cfx (c++ or cfx_j) tags in a unicode enviroment? if not can anyone tell me if there's anything in the c++ API to prevent someone from using unicode? thanks. Paul Hastings [EMAIL PROTECTED]

Re: Writing Custom Functions

2001-05-31 Thread Michael Dinowitz
No scope unless it was directly loaded into something like the request or server scopes. What would be the scope of a UDF then? say udf.foo or function.foo? Bob Everland -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 30, 2001 3:05 PM To:

Detecting File Upload

2001-05-31 Thread David Hannum
If I have a form that has one of the fields offering the option of uploading a file, what's the best way to detect if they actually did upload a file? The reason being, that I am doing an Insert or Update in a database file, and I want to flag if they did provide a file to upload. Thanks, Dave

Re: Newbie-CF trying to process Hex numbers :-)

2001-05-31 Thread Howie Hamlin
In a cfoutput block you need to escape the hash signs by doubling them up like: body bgcolor=##FF text=##00 HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server -

Re: New CF Studio?

2001-05-31 Thread Kay Smoljak
On Wed, 30 May 2001 13:03:43 -0700, Matt Brown [EMAIL PROTECTED] wrote: No. 4.5.2 is NOT the last Studio. We are working on a new version now and it will be released although I can't say when. For now there is a set of extensions that will be on the CF5 CD that you can add to Studio 4.5 to get

RE: Excluding Time in Date/Time db Query

2001-05-31 Thread David Shadovitz
Look into Access' FORMAT function. For operating on dates, it is similar to DatePart, but you can use a mask such as mmm d to grab the entire date part of a date/time field. SELECT Format(myDateTimeField, mmm d ) AS myDate ... -David On Monday, May 28, 2001 11:13 PM, Mark Leder

Re: Securing user created sub-directories

2001-05-31 Thread Bryan LaPlante
If the only file types in those directories are cfm pages you can put some code in the application.cfm file to check for a login otherwise if there are images and htm pages in the directory any user could view those files with out cf knowing about it. Bryan - Original Message - From:

RE: Newbie-CF trying to process Hex numbers :-)

2001-05-31 Thread Jerry Staple
Try this Take the hash out of all the hex numbers ie #ccff00 change to either ccff00 or place another hash in front ##ccff00. Hope this helps Jerry Staple -Original Message- From: Gina K. Anderson [mailto:[EMAIL PROTECTED]] Sent: 30 May 2001 20:20 To: CF-Talk Subject: Newbie-CF

RE: how do i send an attachment?

2001-05-31 Thread Teng-Yan Loke
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Suppose I want to attach some HTML code that was obtained either from a database or using CFHTTP, how do I attach it to CFMAIL without having to save it to a local file first? Can I pass CFHTTP's CFHTTP.FileContent as the MIMEATTACH parameter value

Re: COOKIE expiration :((

2001-05-31 Thread Michael Lugassy
The cookie is still ain't set :((( I'm getting frusrated from that!!! I've cleaned this lllonng message a bit, maybe someone can try to help out? Thanks, Michael Lugassy see if it works by linking to download/vamp.html and then linking to sectionthatneedscookie/index.cfm instead of using

How do I stop users going back after logging out

2001-05-31 Thread Dusty Tinashe Shoko
When A user logs out of my application they can still press the back button to view the pages of my application how can I prevent this? Webmaster Rule Number One: When a potential employer/client asks you if you've ever worked with XYZ software running on platform ABC, say yes quickly and with

Re: syntactically valid variables?

2001-05-31 Thread JAAV
I have the same problem!! what do you mean with Remove the forward slash from the variable name. ? I mean I have the same error but my variables don't have any slash in their names. how about you Nicole? did you fix your problem? thanks in advance for your answers guys, ~Juan - Original

flashSQL

2001-05-31 Thread Thomas Chiverton
Just a heads-up about http://www.markme.com/as/flashsql/ which is a set of ActionScript objects to perform SQL querys by calling an external ColdFusion file. Regards, Thomas Chiverton Intranet Architect and Desktop Analyst 01565 757 909 The end result is nothing except some images on a computer

OT: RE: Newbie-CF trying to process Hex numbers :-)

2001-05-31 Thread Thomas Chiverton
You need to escape pound signs by double-pounding them. need to look like this: ##FF ##99, etc... '#' is a hash sign. '£' is a pound sign. :-) :the Brit. ~~ Structure your ColdFusion code with Fusebox. Get the official book at

Unknown Exception condition ??

2001-05-31 Thread JAIME HOI
Hi has anyone encountered this error before? I have no idea what cause this error. Any help will be appreciated. Thanks Error Diagnostic Information unknown exception condition

Re: Detecting File Upload

2001-05-31 Thread Dick Applebaum
You get control when they submit the form. Test the input type=file field to see if it is non-blank, yes: Issue a cffile command to upload the file for. Set the flag. HTH Dick At 11:46 PM -0400 5/30/01, David Hannum wrote: If I have a form that has one of the fields offering the

Re: cffile DOES NOT WORK!!!

2001-05-31 Thread Michael Lugassy
try this: a. take off the last \ from the directory (i.e - upload to: c:\Inetpub\wwwroot\hnc) b. assignt the right permissions to this directory!! (I bet this is the case) CFFILE is very easy to use, I don't suspect you have a problem with the VERY easy coding. Try giving EVERYONE access to the

RE: How do I stop users going back after logging out

2001-05-31 Thread Jerry Staple
Try This On your log out button or whatever send it to a page which kills the session and then redirects them wherever: Paste this on your linked page cfscript StructClear(session); /cfscript cfscript StructClear(application); /cfscript cflocation url=Wherever.cfm Good Luck Jerry

RE: How do I stop users going back after logging out

2001-05-31 Thread Dusty Tinashe Shoko
I have something like this in my logout file and a redirec CFOUTPUT CFSCRIPT StructDelete(application.UsersLoggedin, #session.UserID#, true); /CFSCRIPT /CFOUTPUT SCRIPT LANGUAGE=JavaScript self.location = 'index.cfm'; /SCRIPT Webmaster Rule Number One: When a potential

RE: how do i send an attachment?

2001-05-31 Thread Steve Martin
You could potentially create the entire mail body dynamically by encoding the dynamic data on the fly and using cfmailparam insert the relevant mail headers along with the encoded data. Your best bet, unless somebody else provides a step by step set of instructions would be to examine an existing

Re:RE: RE: turning off automatic carriage-return insertion i

2001-05-31 Thread Jason Blum
Mark, David, Will, Indeed I suppose I should have mentioned that I am saving to UNIX. Sometimes via FTP but generally via CFStudio's remote FTP. So that is definitely the problem. Thanks for your help! -Jason Reply Separator Subject:RE: RE:

Re: How do I stop users going back after logging out

2001-05-31 Thread Tony Schreiber
I think what you want is content that expires as soon as it's set. This drives me nuts on some sites. As soon as I hit back - This Page Has Expired. Ug! When A user logs out of my application they can still press the back button to view the pages of my application how can I prevent this?

RE: How do I stop users going back after logging out

2001-05-31 Thread Dusty Tinashe Shoko
Exactly know hoa I can achieve that in CF? Webmaster Rule Number One: When a potential employer/client asks you if you've ever worked with XYZ software running on platform ABC, say yes quickly and with great assurance. Then run home, fire up the Net, and figure out what the hell they were

RE: How do I stop users going back after logging out

2001-05-31 Thread Jerry Staple
Try This Paste in the top of the page CFHEADER Name=Expires Value=#Now()# CFHEADER NAME=pragma VALUE=no-cache Good Luck Jerry Staple -Original Message- From: Dusty Tinashe Shoko [mailto:[EMAIL PROTECTED]] Sent: 31 May 2001 13:10 To: CF-Talk Subject: RE: How do I stop users

RE: Cache and CFDHTMLMenu

2001-05-31 Thread Paul Sizemore
I adapted a DHTML menu (like the one used on www.webmonkey.com) to use CF_DirectoryList_Enhanced to read over 50 directories before generating the menu. So I encountered the same problem with performance. What I initially did was schedule the DHTML template to execute and save the output to

Select Boxes limiting drop down :: Brian Lock

2001-05-31 Thread Paul Ihrig
Ok i know this is simple but i have forgot something i want to limit the returned names on a select box to only those who have not signed up! !--- Get the id of golfer EmployeeName [which is an ID] for limiting the drop down --- cfquery name=Get_Golf datasource=golf SELECT GolfID,

RE: Cache and CFDHTMLMenu

2001-05-31 Thread Alii Design
The sites I have the menu on are on shared servers and don't have access to the cf scheduler. Rich -Original Message- From: Paul Sizemore [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 9:02 AM To: CF-Talk Subject: RE: Cache and CFDHTMLMenu I adapted a DHTML menu (like the one

RE: New CF Studio?

2001-05-31 Thread Paul Sizemore
What is this http://www.macromedia.com/software/coldfusion/trial/trial_cf_ud_studio.html ? Is this the new or fused product? It isn't in the store. Will there be a special Studio Edition with other titles packaged? Flash, Ultradev / Studio, Fireworks. -Original Message- From: Raymond

can anyone help?

2001-05-31 Thread sebastian palmigiani
I have win2K professional with personal web server for development. PWS is hanging after any requests, whether with an htm or cfm file request. When choosing any options in PWS I get the following message: Server is busy This action cannot be completed because the other program is busy. Choose

Re: isDate() regular expression

2001-05-31 Thread Ken Beard
client side, javascript. but i need it accept the formats (and only the formats) that isDate() accepts. At 08:03 PM 5/30/01 -0600, you wrote: If you also want to validate the date (no Jun 31, for instance), it's going to be tough or impossible to do in a regex. You can use one or more regexes

RE: How do I stop users going back after logging out

2001-05-31 Thread Semrau, Steven L Mr SRA
Here is the code that I use for something like this: meta http-equiv=Expires content=0 !--- setup our expire times for NN and MSIE --- cfoutput !--- MSIE (Fri, 30 Oct 1998 14:19:41 GMT) --- cfset MSIEtimestamp='#dateformat(now(),DDD)#,#dateformat(now(),DD)#

RE: can anyone help?

2001-05-31 Thread James Maltby
Win2k does not really support PWS it is no longer supported on this OS (legacy issues) - you should be using IIS5 (which will be on the CD) if you are using Professional, if you are using ME then use Apache instead. J -Original Message- From: sebastian palmigiani [mailto:[EMAIL

Re: can anyone help?

2001-05-31 Thread Tony Schreiber
I know this isn't the answer to your question, but ditch PWS and run Apache for Win32. Works great. ;p I think I'm running 1.3.20 on my development machine. Easy install, SMALL footprint... I have win2K professional with personal web server for development. PWS is hanging after any requests,

Please help!!

2001-05-31 Thread Shally
Hello Every one, I am using Cffile in my action page to upload a file in a particular location. This is working fine. But then I have to insert the file name which is being uploaded in my table too. I used Cfinsert aswell as SQL insert statement to insert the file name in the database biut

RE: COOKIE expiration :((

2001-05-31 Thread Dennis Powers
Michael, As a last resort check your browser settings. IE allows you to set a custom security level that will enable session cookies, but not write cookies to a file. Select Internet settings, security and check the cookie settings. Best Regards, Dennis Powers UXB Internet (203) 879-2844

RE: Please help!!

2001-05-31 Thread mike . connolly
Are you attempting to save the FORM.Filename as the filename? What you actually want to store in your database is File.ServerFile, which is a CF variable available after using CFFILE. For more of these variables right-click in CF Studio, select Insert Expression, select variables and CFFILE for

RE: Please help!!

2001-05-31 Thread John Lucas
Try these variables. #file.ServerDirectory# Directory of the file actually saved on the server. #file.ServerFile# Filename of the file actually saved on the server. #file.ServerFileExt# Extension of the uploaded file on the server, without a period, for example, txt not .txt.

RE: can anyone help?

2001-05-31 Thread Cosmera James
Since you have Win2000, why not use IIS that is included? -Original Message- From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 6:29 AM To: CF-Talk Subject: can anyone help? I have win2K professional with personal web server for development. PWS is

RE: Please help!!

2001-05-31 Thread Mark Leder
Try this: CFFILE ACTION=UPLOAD FILEFIELD=form.yourfilefieldname DESTINATION=d:\inetpub\directorylocation\ !---If sending to an outside hosting firm--- NAMECONFLICT=ERROR CFQUERY DATASOURCE=dbname DBTYPE=ODBC INSERT INTO tablename(ObjURL,

RE: can anyone help?

2001-05-31 Thread Saidi; Marwan
Alternatively, you could install IIS. It is an option under Windows Setup for Win2KPro. It is a watered down version, but it is IIS 5.0, much better than PWS. Marwan Saidi Webmaster CED - Concord IS [EMAIL PROTECTED] 407.741.8645 I know this isn't the answer to your question, but ditch PWS

Re: Please help!!

2001-05-31 Thread Christopher Porter
make sure you are using cffile.serverfile as the variable you are inserting into the database. if you use the form variable sent from the webpage, you'll get a temp file name.. which is prollly not what you want :) -chris On Thu, 31 May 2001, Shally wrote: Hello Every one, I am using Cffile

RE: COOKIE expiration :((

2001-05-31 Thread Andrew Tyrone
-Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 30, 2001 9:38 AM To: CF-Talk Subject: RE: COOKIE expiration :(( post the code. otherwise - and you may already know this: remember...if you load a page with CFCOOKIE (or write a cookie

RE: can anyone help?

2001-05-31 Thread Arden Weiss
See Apache installation instructions paper ColdFusion and Apache install tips and tricks by Mark Mathis on Annapolis Cold Fusion Users Group web site (2/22/01 meeting) if you decide to go that route. It will help... www.ancfug.com/meetings ^ / \__ (@\___ / O /

Re: COOKIE expiration :((

2001-05-31 Thread Michael Lugassy
Dennis - IE settings are fine and this problem is recurring on 3 other computers here. Thanks, Michael Lugassy IT/WEB Specialist Interactive Music Ltd. ~~ Structure your ColdFusion code with Fusebox. Get the official book at

Re: COOKIE expiration :((

2001-05-31 Thread Michael Lugassy
Andrew - I'm using javascript reffer, no cflocation. the cookie was set alright (i can see it on every page in the site) but it terminates itself, that's the problem. any idea? Thanks, Michael Lugassy IT/WEB Specialist Interactive Music Ltd. ~~

Web Trends

2001-05-31 Thread John McCosker
Hi all, Web trends seems to be an excellent package, but the price not so excellent. I know there are other solutions like superstats but I would like to data wharehouse visitor stats ourseleves. Does any one know if there are any (really good) custom tags that will do a good proportion of

OT: IIS or Apache? (WAS RE: can anyone help?)

2001-05-31 Thread Erika L. Walker
Well now, since you'all have brought it up, and I never really considered it, (big IIS fan)which is better on a Win2k (advanced server)? IIS or Apache? Pros - Cons? Good for both Development and Production? Would consider shelving IIS for Apache if there was good reason to Erika (with

RE: Thanks!! [Newbie-CF trying to process Hex numbers :-)]

2001-05-31 Thread Gina K. Anderson
Thanks to everyone for the fix on my hex numbers! Taking out the hash worked, as well as doubling up. Now I just have to decide which way to go with it and adopt it as my form. What's the standard? Thanks again! Gina ~~ Structure your ColdFusion

RE: COOKIE expiration :((

2001-05-31 Thread Dylan Bromby
yeah you're right. good grief. i should've checked my own example huh? although i really thought (at least some time ago) that you couldn't access the value of a cookie in the same page you set it. although i just tested my own example and i was able to. that'll save me future embarrassment. ;)

Setting administration email

2001-05-31 Thread Peter Janett
I want to allow each virtual account to have their own email come up at the bottom of CF error pages. I read this in the CF Administrator of CF 4.5 (logging - settings), regarding the administrator email: This address will appear under each error message for

Re: Web Trends

2001-05-31 Thread David Schmidt
At 03:59 PM 5/31/2001 +0100, John McCosker wrote: Web trends seems to be an excellent package, but the price not so excellent. Yeah, I remember when I paid US$99 for a server license of WT. g Does any one know if there are any (really good) custom tags that will do a good proportion of this. I

Is it possible to nest CFQUERY inside CFLOOP?

2001-05-31 Thread Kevin Gilchrist
I get an error when I try to do this: cfloop index=region list=lst_region cfquery name=qry_Full_Week_Downtime_Region#i# datasource=#DSN# dbtype=Oracle80 cachedwithin=#CreateTimeSpan(0,1, 0, 0)# SELECT sum(severity_minutes) as sev_sum,

Double byte datatype

2001-05-31 Thread CT, Loo
Dear all, Please HELP! I am having problem to update/insert record into a database in MS SQL 7.0 using store procedure. Some fields /parameters of the store procedure are of nvarchar, ntext, nchar data type. Is there any CFSQLType or CF functions that supports these datatype? Is there any work

Recall: Is it possible to nest CFQUERY inside CFLOOP?

2001-05-31 Thread Kevin Gilchrist
Kevin Gilchrist would like to recall the message, Is it possible to nest CFQUERY inside CFLOOP?. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives:

RE: Cache and CFDHTMLMenu

2001-05-31 Thread Paul Sizemore
Can you use the Windows scheduler on another machine to make a HHTP request using Internet Explorer to kick off a CF template to CFFile action=write the dhtml menu? Can you put it in an application variable that when it expires it calls the template to populate the variable? Paul

FW: Is it possible to nest CFQUERY inside CFLOOP?

2001-05-31 Thread Kevin Gilchrist
I just noticed the loop index variable is wrong, I changed it to from i to region as it should be and still got the same error message... -Original Message- From: Kevin Gilchrist Sent: Thursday, May 31, 2001 11:32 AM To: CF-Talk (E-mail) Subject: Is it possible to nest CFQUERY inside

RE: Select Boxes limiting drop down :: Please Look

2001-05-31 Thread alistair . davidson
try changing the formulation to something like cfquery SELECT tbl_Employee.EmployeeID, tbl_Employee.Firstname, tbl_Employee.LastName, tbl_Employee.Email, tbl_Employee.EmployeeName FROMtbl_Employee WHERE tbl_Employee.EmployeeID NOT IN (

CFFLUSH alternative in CF4.5

2001-05-31 Thread Michael Lugassy
I would really like to try out the new CFFLUSH component on CF5, but we're not yet ready for the upgrade. Can someone suggest a better CFFLUSH alternative in CF4.5 other then opening 3 invisible frames (each one runs 1 template) to achive this page-load-balancing and incremental output?

Concensus CFLOCK

2001-05-31 Thread Alii Design
What is a standard timeout that is used with CFLOCK? 30 seconds? Rich -Original Message- From: Peter Janett [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 11:15 AM To: CF-Talk Subject: Setting administration email I want to allow each virtual account to have their own email

Re: Web Trends

2001-05-31 Thread Michael Lugassy
Yea, I use that too. great! Thanks, Michael Lugassy IT/WEB Specialist Interactive Music Ltd. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives:

Re: New CF Studio?

2001-05-31 Thread W Luke
We don't preclude doing that, but there hasn't been any announcement. I think that the UD/CFS package is a particularly good match. Thanks for your replies Matt, and the others. Will -- Will Free Advertising-=- www.localbounty.com e: [EMAIL PROTECTED] icq: 31099745

Need a CFX_IMAGE Expert!!

2001-05-31 Thread Michael Lugassy
For you CFX_IMAGE experts: I have a weird jpg (530Kb, 1152x864) that ACTION=copy destroys it and ACTION=resize (with the same OUTPUT= as with copy) works just fine! let me show you the code: ruin the jpg: CFX_IMG ACTION=COPY TYPE=JPEG QUALITY=75 BITCOUNT=16 file=#tempfile#

RE: Select Boxes limiting drop down :: Please Look

2001-05-31 Thread Paul Ihrig
ok this combo hides the first returned duplicate, but not all the duplicate EmployeeName/EmployeeID if you could give me a hint as to what i need to do. i must have forgotten every thing. thanks -paul !--- Get the id of golfer EmployeeName for limiting drop down --- cfquery name=Get_Golf

RE: Recall: Is it possible to nest CFQUERY inside CFLOOP?

2001-05-31 Thread Bryan Love
yes, but you shouldn't. There is almost always a better solution that is being overlooked. Bryan Love ACP Internet Application Developer [EMAIL PROTECTED] -Original Message- From:

RE: Double byte datatype

2001-05-31 Thread Bryan Love
when passing characters to a stored proc (NOT using CFSTOREDPROC) all string types such as varchar, char, nvarchar, etc... should be surrounded by single quotes and all numeric types should not. nvarchar should be treated just like varchar, nchar should be treated just like char, and so on...

RE: Is it possible to nest CFQUERY inside CFLOOP?

2001-05-31 Thread Bryan Love
put pound signs around 1st_region. The string 1st_region is not a list, but #1st_region# probably is. Bryan Love ACP Internet Application Developer [EMAIL PROTECTED] -Original

Is this an Access limitation ?

2001-05-31 Thread Tracy Bost
The code below throws an error whenever I try to run it... What am I doing wrong ? Thanks in Advance... CFQUERY name=getproducts datasource=SQL7DATABASE SELECT partnumber FROM products WHERE manufacturer_id = 4 /CFQUERY CFQUERY name=getstuff datasource=ACCESSDATABASE SELECT item_id

RE: syntactically valid variables?

2001-05-31 Thread Jann VanOver
The field that you are using as part of your variable name contains a / which is not a valid character in a variable name. In the error message you included, your field value was E6_HL_C/CCNOADD THIS is the forward slash you have to get rid of. -Original Message- From: JAAV

RE: Select Boxes limiting drop down :: Brian Lock

2001-05-31 Thread Jann VanOver
So, what's your problem. You said what you'd like to do, you showed your code, what's not working? -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 6:13 AM To: CF-Talk Subject: Select Boxes limiting drop down :: Brian Lock Ok i know this is

RE: Select Boxes limiting drop down :: Please Look

2001-05-31 Thread Paul Ihrig
thanks Alistair. but i just did this, it may be way wrong. it works but if you know it is bad, please let me know !--- Get the id of golfer EmployeeName for limiting drop down --- cfquery name=Get_Golf datasource=#MM_golf_DSN# username=#MM_golf_USERNAME# password=#MM_golf_PASSWORD# SELECT

RE: cffile DOES NOT WORK!!!

2001-05-31 Thread S R
I figured it out. Thanks for your help. After one finally gets some sleep, you start to see what went wrong. Sal From: Ryan Sabir [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: cffile DOES NOT WORK!!! Date: Thu, 31 May 2001 12:41:38 +1000 This

Re: Is it possible to nest CFQUERY inside CFLOOP?

2001-05-31 Thread Dave f
Don't know what your problem is, but it is definitely OK to have cfquery inside cfloop. Do you perchance have improperly closed prior cfquery?? (My usual trick is to dup the cfquery and forget to put the / in ):) - Original Message - From: Kevin Gilchrist [EMAIL PROTECTED] To:

Re: Thanks!! [Newbie-CF trying to process Hex numbers :-)]

2001-05-31 Thread Bill Davidson
I don't think there is a standard, but I would just leave out the #'s, so the code will work inside a cfoutput block or not. Double pounds (or hashes for you Brit's ;) ) in HTML will freak out your browser. -Bill www.brainbox.tv - Original Message - From: Gina K. Anderson [EMAIL

RE: Unstable MySQL on Windows 2000

2001-05-31 Thread robrusher
My original thought was it was low on system resources. It was correct. I am getting much better results now that I moved to a higher powered machine with more of everything. I haven't tried on NT4. Regards, Rob -Original Message- From: Arden Weiss [mailto:[EMAIL PROTECTED]] Sent:

RE: How do you to set allow zero length in access 2000 for memo f ield using sql

2001-05-31 Thread Garza, Jeff
Here are the online docs from Access2000 regarding Alter Table Statements... There doesn't seem to be a way to alter the table and set the columnt to accept zero length strings. The issue at hand is that by default a text or memo column is created with Allow Null = yes and Allow Zero Length =

Re: can anyone help?

2001-05-31 Thread sebastian palmigiani
OK. I have ditched PWS. I have installed Apache and reinstalled ColdFusion and copied the DLL file and changed the httpd.conf file in apache. I cannot get the web server to start. When I click on start apache I get a dos command window that goes so fast I can't even read what it says. I was

  1   2   >