RE: Storing URL's

2004-01-21 Thread Pascal Peters
This is what I use. You can modify the regexp if you also want to allow another protocol like ftp. (^(https?|ftp)://) function checkurl(input){ if(NOT REFindNoCase(^https?://,input)) input = http:// input; return input; } Form.myURL = checkurl(Form.myURL); Do that before inserting in the

Re:strange cfc recursion issue...

2004-01-21 Thread Isaac Dealey
Not that it helps much, but I took your same code and had no issues when I cfdumped the result of getMetaData on an instance of it. You running MX 6.1? Yeah, I'm running Red Sky ... Turned out Sean was right, I had accidentally horqued up the meta data prior and needed to restart the cf server to

Re:CFC problems - portability workaround

2004-01-21 Thread Isaac Dealey
You're right, it'd be nice to have a native function and/or tag attribute, like a cache=session.user attribute in the cfobject tag. I did create a persistObject() function for the onTap framework... today or yesterday ... I can't remember, the days are running together. :) Anyway, it's obviously

Re: CFMX 'bug'? Easy to crash CFMAIL.

2004-01-21 Thread Thomas Chiverton
On Tuesday 20 Jan 2004 18:13 pm, Matt Robertson wrote: Can't.Politics. Bah :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749

Re:txt file which lines don't have the same length

2004-01-21 Thread Nicolas CHALLEL
Hello and thanks for your help. I manage to proceed with a file counting 6 fix entries for each row, separated by comma (;). But I can't proceed with variable entries... !--- I use cffile tag to read my txt file and declare an array to put each entry --- cffile action=""

Web Application Archive

2004-01-21 Thread Shahzad.Butt
Hi When you install coldfusion MX (6.0 or 6.1 standard not on J2EE) where does it deploy the Web Application Archive?? Shaz [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Image hot spots

2004-01-21 Thread Jim Watkins
I have a student schedule that lists the usual classes, times, building, room, etc.This all comes from an Oracle database and called by the Student ID.Printed on the bottom of the schedule is a map of the campus with buildings identified with hotspots.I need some help on writing a query that will

RE: Image hot spots

2004-01-21 Thread Tangorre, Michael
I would take the image, identify ALL hotspots on it and name them the same as the course ID youget from the DB. Then you can loop over the course from your query and build your hotspots. Mike -Original Message- From: Jim Watkins [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21,

RE: Image hot spots

2004-01-21 Thread Greg Luce
I would be willing to bet there could be multiple courses being held in each building though. I'm interested in hearing a solution. :-) Greg -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 7:53 AM To: CF-Talk Subject: RE: Image

3rd party db connectivity drivers vs. vendor db connectivity driv ers

2004-01-21 Thread Earl, George
Here's a pretty interesting whitepaper from DataDirect about the advantages of using third party database connectivity drivers over vendor supplied drivers (click on Download White Paper when you get there): http://nct.digitalriver.com/fulfill/0028.138/download/2004-cd0e403c7de02a927

RE: CFMail and some people email client seeing it as spam

2004-01-21 Thread Robert Redpath
If you are using MX you can use cfmail part to easily send both the text html versions of the same email.I am guessing that your HTML email is not being read properly by all the email clients you are sending it to, therefore it shows blank.By sending the mime/mulitpart alernative format the

Client Variables

2004-01-21 Thread Stuart Kidd
Hi guys, I've just switched from the cfaussie mailing list to this one as i'm no longer in Australia but in the UK.Is this the UK mailing list? Anyhow, i've got an app in which i'm using Client variables.The only thing i'm not happy with is that they don't time out.Is there a way to make them

RE: Client Variables

2004-01-21 Thread Mike Townend
If you dont want to use sessions then you could use the timestamping thats included in client variables Client.LastVisit Client.TimeCreated And then in Application.cfm if Client.LastVisit is greater than say Now() - 10 minutes then run some code to log them out. HTH -Original

RE: Client Variables

2004-01-21 Thread Simon Horwith
The big list in the UK (also used by many other EU nationals) can be found at http://lists.cfdeveloper.co.uk You can also find out about the London CF Community at http://www.ukcfug.org - the London CFUG site. In answer to your question, you use the deleteClientVariable() function to manually

RE: Client Variables

2004-01-21 Thread Stuart Kidd
of Thanks Mike and Simon, between the two of you i have both my questions answered. :) -- Original Message -- From: Simon Horwith [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Wed, 21 Jan 2004 14:27:37 - The big list in the UK (also used by many

MySQL query

2004-01-21 Thread Yves Arsenault
Hello, I just wanted to check... Is this a valid query in MySQL 3.xx ? cfquery name=There datasource=ipe SELECT * FROM events WHERE day(theDate) = '#dayVal#' and month(theDate) = '#querymonth#' and year(theDate) = '#session.year#' /cfquery A client is using a calendar app on a site he is

Re: MySQL query

2004-01-21 Thread Jochem van Dieten
Yves Arsenault wrote: Is this a valid query in MySQL 3.xx ? No. http://www.mysql.com/doc/en/Date_and_time_functions.html says rather explicitly that Day() was added in 4.1.1 Use Extract(). Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This

RE: MySQL query

2004-01-21 Thread Ben Forta
The *right* way to do this is to use DATEDIFF(), but alas that too was added in 4.1.1. --- Ben -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 9:54 AM To: CF-Talk Subject: Re: MySQL query Yves Arsenault wrote: Is this a valid

RE: MySQL query

2004-01-21 Thread C. Hatton Humphrey
Is this a valid query in MySQL 3.xx ? cfquery name=There datasource=ipe SELECT * FROM events WHERE day(theDate) = '#dayVal#' and month(theDate) = '#querymonth#' and year(theDate) = '#session.year#' /cfquery Day() can not be used in MySQL WHERE clause Use To_Days() to convert both

Re: MySQL query

2004-01-21 Thread Stephen Moretti
Yves, You need to use DayofMonth() instead of Day() - Day() is available in 4.11 and is a synonym of DayofMonth() I'm sure that mySQL will ignore the single quotes around dayVal, querymonth and session.year, but the functions that you are comparing against do generate numeric values, so you

Re: MySQL query

2004-01-21 Thread Jochem van Dieten
Ben Forta wrote: The *right* way to do this is to use DATEDIFF(), but alas that too was added in 4.1.1. The SQL standard does not know DateDiff(). The SQL standard does know Extract(). So I disagree with your right way. Jochem -- I don't get it immigrants don't work and steal our jobs -

Re: MySQL query

2004-01-21 Thread Stephen Moretti
And I disagree with both of you as it is a straight forward date comparison! Of course all you're doing is comparing two dates, so you can do the following instead: Depending on whether you are using an ODBC connector or not : WHERE theDate = #CreateODBCDate(CreateDate(session.year,

RE: CFPOP and bounced mail

2004-01-21 Thread Tyler Clendenin
I too have had this problem with cfpop as a result I have been forced to return to cfx_pop3.Perhaps Macromedia should learn something from the developer of this tag perhaps hire him to reform their current tag. I have one main question though.Why is there no feature in either the cfpop or

RE: CFMX 'bug'? Easy to crash CFMAIL.

2004-01-21 Thread Tyler Clendenin
Some things I feel I must point out. 1. Data Integrity is always an issue but why should I waste my precious cpu time checking first what the tag is already checking.If this was truly intentional I would think that the devs at Macromedia would have built in a little more reverse

RE: Web Application Archive

2004-01-21 Thread Dave Watts
When you install coldfusion MX (6.0 or 6.1 standard not on J2EE) where does it deploy the Web Application Archive?? It doesn't, really. When you install CFMX as a standalone server, the stuff that would be in the archive file gets put inthe \CFusionMX directory. The bits of JRun necessary for

RE: CFMX 'bug'? Easy to crash CFMAIL.

2004-01-21 Thread Gaulin, Mark
Re #1: Doesn't putting a try/catch around the cfmail do the trick?That way you don't have to validate the email yourself... just let cfmail fail if it wants to. If you put the try/catch around the entire cfloop (or cfoutput) of a query then Yes, it will abort the whole job. But if you put the

Also Having this problem

2004-01-21 Thread Daryl Walsh
Spam filters are catching messages sent via CFMail. Send the same message, subject and text, from someone's outlook and the spam score is 10 to 50 out of 100. Sent via CFMail and the spam score goes up to 90 out of 100. I think it's something to do with the message-id that gets auto assigned by

Re: MySQL query

2004-01-21 Thread Jochem van Dieten
Stephen Moretti wrote: And I disagree with both of you as it is a straight forward date comparison! Of course all you're doing is comparing two dates, so you can do the following instead: Depending on whether you are using an ODBC connector or not : WHERE theDate =

RE: CFMX 'bug'? Easy to crash CFMAIL.

2004-01-21 Thread Dave Watts
1. Data Integrity is always an issue but why should I waste my precious cpu time checking first what the tag is already checking. If this was truly intentional I would think that the devs at Macromedia would have built in a little more reverse compatibility, Maybe some sort of attributes

RE: CFMX 'bug'? Easy to crash CFMAIL.

2004-01-21 Thread Katz, Dov B (IT)
Warning:Doing all the try-catches is once again relying on CF behavior which we all witnessed changing without notice (rightfully so). The proper way to do this is to perform the syntax check yourself, and only call CFMAIL if necessary.If anything, CFMX should be kind enough to add a new

RE: CFMX 'bug'? Easy to crash CFMAIL.

2004-01-21 Thread Dave Watts
Re #1: Doesn't putting a try/catch around the cfmail do the trick? That way you don't have to validate the email yourself... just let cfmail fail if it wants to. If you put the try/catch around the entire cfloop (or cfoutput) of a query then Yes, it will abort the whole job. But if you

RE: CFMX 'bug'? Easy to crash CFMAIL.

2004-01-21 Thread Katz, Dov B (IT)
Tyler, 2) so why don't you CFLOOP query=, and cfmail inside the loop to solve this? -Dov _ From: Tyler Clendenin [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 10:18 AM To: CF-Talk Subject: RE: CFMX 'bug'? Easy to crash CFMAIL. Some things I feel I must point out.

Re: CFMX 'bug'? Easy to crash CFMAIL.

2004-01-21 Thread Nick de Voil
The proper way to do this is to perform the syntax check yourself, and only call CFMAIL if necessary.If anything, CFMX should be kind enough to add a new function isValidEmail() since most webapps do it pretty often. Does cflib count? http://www.cflib.org/udf.cfm?ID=216 Nick [Todays

-OT- Crystaltech and Excel WebQueries

2004-01-21 Thread Thane Sherrington
CrystalTech has switched to 2K3 Server for their hosting and now Excel Web Queries don't work.Anyone know a workaround for this? T Tired of your bookmarks/favourites being limited to one computer?Move them to the Net! www.stuffbythane.com/webfavourites makes it easy to keep all your

string problem

2004-01-21 Thread CHALLEL Nicolas PREF54
Hello, I would like to split the following string called myLine in several string recorded in an array called myTab. Coldfusion crash with my conditional loop ... what should I use instead ? I tried with cfif #CountCar# neq #char(59)# but it returns an error message Would you please have a

RE: CFMX 'bug'? Easy to crash CFMAIL.

2004-01-21 Thread Dave Watts
Warning:Doing all the try-catches is once again relying on CF behavior which we all witnessed changing without notice (rightfully so). The proper way to do this is to perform the syntax check yourself, and only call CFMAIL if necessary. If anything, CFMX should be kind enough to add a

string to array problem

2004-01-21 Thread Nicolas CHALLEL
Hello, I would like to split the following string called myLine in several string recorded in an array called myTab. Coldfusion crash with my conditional loop ... what should I use instead ? I tried with cfif #CountCar# neq #char(59)# but it returns an error message Would you please have a good

string to array problem

2004-01-21 Thread Nicolas CHALLEL
Hello, I would like to split the following string called myLine in several string recorded in an array called myTab. Coldfusion crash with my conditional loop ... what should I use instead ? I tried with cfif #CountCar# neq #char(59)# but it returns an error message Would you please have a good

Re: Also Having this problem

2004-01-21 Thread Thomas Chiverton
On Wednesday 21 Jan 2004 14:32 pm, Daryl Walsh wrote: via CFMail. Send the same message, subject and text, from someone's outlook and the spam score is 10 to 50 out of 100. I dunno what spam filter you're using, but it's broke :-) Mail I get sent from our CFMX6.1 install goes through

RE: string to array problem

2004-01-21 Thread Tony Weeg
try the listToArray() function, built in to cf using the ; as your delimiter. tw -Original Message- From: Nicolas CHALLEL [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 9:45 AM To: CF-Talk Subject: string to array problem Hello, I would like to split the following

RE: string to array problem

2004-01-21 Thread Dave Watts
I would like to split the following string called myLine in several string recorded in an array called myTab. Coldfusion crash with my conditional loop ... what should I use instead ? I tried with cfif #CountCar# neq #char(59)# but it returns an error message Would you please have a

RE: CFMX 'bug'? Easy to crash CFMAIL.

2004-01-21 Thread Katz, Dov B (IT)
Obviously. I was directing this comment it to the user who might just type cfcatch and think his problems were over. -dov _ From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 10:53 AM To: CF-Talk Subject: RE: CFMX 'bug'? Easy to crash CFMAIL.

No More Data To Read error again- SQL Server

2004-01-21 Thread Smith, Don , CTR , WHS/PSD
Has there been any movement on the JDBC No More Data to Read error?I need to demo an application today and when I moved it from the testing server to the production server everything worked for the first few screens and then blammo, I got the No More Data To Read error from then on in. NOTHING was

Re: No More Data To Read error again- SQL Server

2004-01-21 Thread Thomas Chiverton
On Wednesday 21 Jan 2004 16:00 pm, Smith, Don , CTR , WHS/PSD wrote: Has there been any movement on the JDBC No More Data to Read error? Not that has been posted on the thread in the MM forums :-( -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED]

RE: CFMX 'bug'? Easy to crash CFMAIL.

2004-01-21 Thread Matt Robertson
Dave Watts wrote: ...snip...when you're using a query with your CFMAIL tag itself...snip... if any record within that recordset has an invalid address, the whole thing will fail at that point. Exactly my situation.An external database with cfmail running with query=. Two choices: 1)do a pre-mail

Re: MAC CFDirectory /Cffile failure

2004-01-21 Thread Lola Lee
At 5:08 PM -0500 1/20/04, Jim Gurfein wrote: We're having issues uploading files to a server from MACs only. The system doesn't seem to read the directory information correctly and attempts to create a new directory but fails. Error says that the filename, directory name or volume label syntax is

RE: txt file which lines don't have the same length

2004-01-21 Thread Bruce, Rodney S HQISEC/Veridian IT Services
This is only one way of doing it, may not be the most efficient, but should work, !pseudo code-- cffile action="" file=#expandPath('.')#\T128.TXT variable=message ! I would use an array of

Re: Also Having this problem

2004-01-21 Thread Howie Hamlin
Some SPAM filters look at the X-Mailer header and if the ColdFusion value is in there then the mail is tagged as SPAM.Try setting the X-Mailer header to something else (using cfmailparam). HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com inFusion

RE: CFMX 'bug'? Easy to crash CFMAIL.

2004-01-21 Thread Dave Watts
Obviously. I was directing this comment it to the user who might just type cfcatch and think his problems were over. That would never be an appropriate way to use CFCATCH; rather than suggesting that people not use it, I would rather it be used correctly. Dave Watts, CTO, Fig Leaf Software

Null pointers error on CFMX 6.1

2004-01-21 Thread Kola Oyedeji
Hi We are using CFMX 6.1 (an upgrade from 6) and the following code: cfif isdefined(form.test) CFQUERY NAME=q_insert DATASOURCE=#Request.datasource# insert into table1 (thetest) values ('#form.thetest#') /CFQUERY /cfif CFQUERY NAME=q_get_all DATASOURCE=#Request.datasource# select thetest

adding code into links

2004-01-21 Thread Wurst, Keith D.
hey everyone. i have a chunk of code that i would like to attach in the url string of a series of links. i dont want to have to replicate the code each time for each link. i would like to write the code once, set it equal to the variable, and then call the variable inside of the href to utlize the

RE: CFPOP and bounced mail

2004-01-21 Thread Paul Vernon
There is in CFX_POP3 just set action to 'STAT' to give you the number of messages If you don't have the version that does it, its at http://www.web-architect.co.uk/downloads.cfm Paul [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Problems with Text in Access

2004-01-21 Thread Mickael
Hello, I have a problem with an Access database.I cannot switch to another database.The problem is that there were numerical values being stored as text.I am getting errors with I try to use Dollarformat() so I modified the database column to be numeric, imported the database tables in to a new

RE: Null pointers error on CFMX 6.1

2004-01-21 Thread Adrian Lynch
I'd guess it might be that request.datasource (or form.thetest) contains something other than what it should. Is the code below exactly as you have it in your page? Ade -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED] Sent: 21 January 2004 16:27 To: CF-Talk Subject: Null

RE: Problems with Text in Access

2004-01-21 Thread Tony Weeg
have you cfdump 'ed the data to ensure its format? a number is a number is a number when it gets to cf.make sure access is spitting a NUMBER out, not something odd tw -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 11:34 AM To: CF-Talk

RE: CFMX 'bug'? Easy to crash CFMAIL.

2004-01-21 Thread Tyler Clendenin
I would assume that that would be more intensive then using the query attribute within cfmail.I am not talking about just a few e-mails here, I do have to worry about processing time.Running a loop essentially kills the server. You are essentially saying the tag doesn't work right and i agree.

RE: CFPOP and bounced mail

2004-01-21 Thread Tyler Clendenin
Oh wow thank you very much. This will be a big help. Tyler Clendenin GSL Solutions _ From: Paul Vernon [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 11:34 AM To: CF-Talk Subject: RE: CFPOP and bounced mail There is in CFX_POP3 just set action to 'STAT' to give you the

RE: CFPOP and bounced mail

2004-01-21 Thread Burns, John
Does the cfx_pop3 tag work on linux? John Burns -Original Message- From: Paul Vernon [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 11:34 AM To: CF-Talk Subject: RE: CFPOP and bounced mail There is in CFX_POP3 just set action to 'STAT' to give you the number of

Re: adding code into links

2004-01-21 Thread Pete Ruckelshaus
Can I be the first person to point out that this sounds like a very dangerous thing to do?At the very least you should encrypt() and decrypt() before these strings are sent via URL. You also might want to look at simply saving those code chunks using cfsavecontent and setting them as request

OT - StudioMX2004 w/ Flash Std upgrade to StudioMX2004 w/Flash Pr o.

2004-01-21 Thread DURETTE, STEVEN J (AIT)
Hi all, I was just wondering.When we bought StudioMX04, it came with Flash Standard and that was the only option. Now I'm looking to upgrade the Flash to Pro and I can't find an upgrade track for this.Does anyone know what track to use? Steve -- COST SAVINGS SUGGESTION* For

RE: Null pointers error on CFMX 6.1

2004-01-21 Thread Kola Oyedeji
By the way form.thetest was a typo in my email, even with this corrected to form.test the error still occurs! Kola -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED] Sent: 21 January 2004 16:27 To: CF-Talk Subject: Null pointers error on CFMX 6.1 Hi We are using CFMX 6.1

RE: Null pointers error on CFMX 6.1

2004-01-21 Thread Gaulin, Mark
In the first if block I see an isdefined() test for form.test but a usage of the variable form.thetest. Is this intentional? -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 11:27 AM To: CF-Talk Subject: Null pointers error on CFMX 6.1 Hi

Re: Problems with Text in Access

2004-01-21 Thread Ubqtous
Mickael, On 1/21/2004 at 11:34, you wrote: M Parameter 1 of function DollarFormat which is now must be a number M I would like to fix the access issue.But if not is there a way to M take a string that is a number and convert it to a number then M display it properly as a dollarformat? I'd

Re: CFMX 'bug'? Easy to crash CFMAIL.

2004-01-21 Thread Deanna Schneider
I've handled this by looping over my query, doing the validation, and re-building the query for the cfmail tag, minus the bad records. Total hassle, but better than crashing. -d - Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday,

Re: Problems with Text in Access

2004-01-21 Thread Mickael
Hi Tony After my CFDUMP is do see a number here is what I see I just changed anything important to 1234 CLT_MASTER_ID CLT_REF_NO CUR_BAL LIST_DATE NAME1 ORIG_AMT PMT_AMT 1 12341234007/31/20031234897923.9800 - Original Message - From: Tony Weeg To: CF-Talk Sent: Wednesday, January

Re: Problems with Text in Access

2004-01-21 Thread Deanna Schneider
It's failing on a null. If you want no value to show up as $0.00, then you can do something like so: cfif len(trim(yourdollarfield)) #dollarformat(yourdollarfield)# cfelse #dollarformat(0)# /cfif - Original Message - From: Mickael [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent:

RE: Null pointers error on CFMX 6.1

2004-01-21 Thread Michael Traher
To expand a bit more.. Both SQL statements work correctly. A new row is inserted and all rows are selected. The SELECT is fine but the INSERT causes the Null pointer error. This has started happening after switching to a new JDBC driver (for reasons too numerous to mention here.) The driver

RE: Problems with Text in Access

2004-01-21 Thread Pascal Peters
Looking at the error message, I suspect you have NULL values in that column. You have to take care of that before using dollarformat. It is most likely not an Access issue. cfif IsNumeric(val) #DollarFormat(val)# cfelse #val# /cfif -Original Message- From: Mickael [mailto:[EMAIL

RE: Null pointers error on CFMX 6.1

2004-01-21 Thread Kola Oyedeji
Nope, typo. Error still occurs with corrected code Kola -Original Message- From: Gaulin, Mark [mailto:[EMAIL PROTECTED] Sent: 21 January 2004 16:51 To: CF-Talk Subject: RE: Null pointers error on CFMX 6.1 In the first if block I see an isdefined() test for form.test but a usage

RE: CFPOP and bounced mail

2004-01-21 Thread Tyler Clendenin
No it does not, but in the documentation they say that although there are no current plans because it was programmed in delphi it could be ported.but it is not open source. Tyler Clendenin GSL Solutions _ From: Burns, John [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 11:43

RE: CFMX 'bug'? Easy to crash CFMAIL.

2004-01-21 Thread Tyler Clendenin
Well overall better then crashing is spending more money on something like cfx_activmail that just works.That is my major gripe, why can't these things just work.Even still with this new version of CFMX I have a problem after i get more then 2000 e-mails in my spool.If anyone wants the link

RE: Client Variables

2004-01-21 Thread Dave Watts
Anyhow, i've got an app in which i'm using Client variables. The only thing i'm not happy with is that they don't time out.Is there a way to make them timeout say like after 20 mins of no activity (and/or when the browser is closed)? Or do i have to turn to Sessions? You can control the

RE: txt file which lines don't have the same length

2004-01-21 Thread CHALLEL Nicolas PREF54
Thanks for your precious help. I just don't really know how to display my datas... I tried something like that cfoutput cfloop index=i from=2 to=#x#x being value of my first loop (to count records) cfloop index=j from=1 to=#y#y being value of my second loop (to count person on each row)

RE: 3rd party db connectivity drivers vs. vendor db connectivity driv ers

2004-01-21 Thread Dave Watts
I'm curious if others agree with DataDirect's position and if you feel they make valid points or if you feel they are just blowing their own horn. We are having a heck of a time getting CFMX 6.1 (Enterprise, standalone, Windows 2000 Adv Server) to work with IBM's JDBC Type 4 DB2 drivers

RE: CFPOP and bounced mail

2004-01-21 Thread Paul Vernon
I do now have an install of Linux, Kylix (Delphi for Linux) and have put CFMX6.1 on it... (was my W2k3 test server but I got a bigger box for that) so there is scope to port all my CFX tags to linux... I just need a few weeks to actually spend looking at the whole proposition... not sure where to

RE: txt file which lines don't have the same length

2004-01-21 Thread Bruce, Rodney S HQISEC/Veridian IT Services
You will have to get the array length for each Personnel because the are different Something like: cfoutput cfloop index=i from=2 to=#ArrayLen(file_array)#x being value of my first loop (to count records) cfloop index=j from=1 to=#ArrayLen(file_array[i].Personnel)#y being value of my second

Re: Null pointers error on CFMX 6.1

2004-01-21 Thread Rob Rohan
Did you try deleting the corresponding class file for this page? Sometimes cf gets confused it seems. On Wed, 2004-01-21 at 08:27, Kola Oyedeji wrote: Hi We are using CFMX 6.1 (an upgrade from 6) and the following code: cfif isdefined(form.test) CFQUERY NAME=q_insert

RE: txt file which lines don't have the same length

2004-01-21 Thread Bruce, Rodney S HQISEC/Veridian IT Services
added remarks, X should be good, will contain the length of the array from when its created. But Y will contain the length of the last file_array[x].Personnel array, not the length for each of them. -Original Message- From: CHALLEL Nicolas PREF54 [mailto:[EMAIL PROTECTED] Sent:

RE: Null pointers error on CFMX 6.1

2004-01-21 Thread Kola Oyedeji
No I removed extraneous code , request.datasource is set correctly - as a test I have hardcoded it. However we have tried an updated (for CFMX 6.1) driver from Caribou Lake which has solved the problem. Thanks anyway Kola -Original Message- From: Adrian Lynch [mailto:[EMAIL

RE: CFMX 'bug'? Easy to crash CFMAIL.

2004-01-21 Thread Gaulin, Mark
The cfmail-with-a-query behavior does suck, doesn't it... If the exception included the bogus email address then it could be possible to sort the original query by email address, and then you can assume that any email address prior to the bogus one worked.Then you just have to requery starting

Re: OT - StudioMX2004 w/ Flash Std upgrade to StudioMX2004 w/Flash Pr o.

2004-01-21 Thread Scott Fegette
Hey, Steve- The Studio upgrade pricing matrix is here, FYI: http://www.macromedia.com/software/studio/productinfo/upgrade/ HTH! -Scott From: DURETTE, STEVEN J (AIT) [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Wed, 21 Jan 2004 11:49:42 -0500 To: CF-Talk [EMAIL PROTECTED] Subject: OT -

Re: OT - StudioMX2004 w/ Flash Std upgrade to StudioMX2004 w/Flash Pr o.

2004-01-21 Thread Kevin Graeme
Hi all, I was just wondering.When we bought StudioMX04, it came with Flash Standard and that was the only option. Now I'm looking to upgrade the Flash to Pro and I can't find an upgrade track for this.Does anyone know what track to use? It's $299 for the US retail. To find the upgrade on

OT radio button validation

2004-01-21 Thread Robert Orlini
Anyone have a quick _javascript_ code top check if a certain radio button is selected then a input field must have content? The buttons are grouped as paymentmethod. One is credit card and one is purchase order. The input field ponumber must have content if purchase order radio button is

RE: OT radio button validation

2004-01-21 Thread Douglas.Knudsen
webmonkey is a good place to start some JS knowledge aquirementhttp://hotwired.lycos.com/webmonkey/programming/_javascript_/tutorials/jstutorial_index.htmlLOL! Also, there are many scripts at _javascript_.internet.com for examples. Here is the basic logic outline though function checkme() {

Re: Problems with Text in Access

2004-01-21 Thread Mickael
Hi Deanna Should there be some sort of argument in the cfif ?Like =0? - Original Message - From: Deanna Schneider To: CF-Talk Sent: Wednesday, January 21, 2004 12:03 PM Subject: Re: Problems with Text in Access It's failing on a null. If you want no value to show up as $0.00, then

Re: Problems with Text in Access

2004-01-21 Thread Mickael
Thanks Pascal, That did it. - Original Message - From: Pascal Peters To: CF-Talk Sent: Wednesday, January 21, 2004 12:03 PM Subject: RE: Problems with Text in Access Looking at the error message, I suspect you have NULL values in that column. You have to take care of that before using

Re: -OT- Crystaltech and Excel WebQueries - resolved

2004-01-21 Thread Thane Sherrington
At 11:49 AM 1/21/04 -0400, Thane Sherrington wrote: CrystalTech has switched to 2K3 Server for their hosting and now Excel Web Queries don't work.Anyone know a workaround for this? Looks like an issue with having a compact privacy policy on the page.Excel 2K appears not to be able to handle it.

Re: Problems with Text in Access

2004-01-21 Thread Ubqtous
Mickael, On 1/21/2004 at 13:33, you wrote: M Should there be some sort of argument in the cfif ?Like =0? The result of len() can be treated like a boolean, so if the length of the string is 0: len(string) equates to 'false' Or if there is a length to the string: len(string) equates to 'true'

Finding JavaMail version

2004-01-21 Thread Michael Wolfe
Hi All, How do I determine what version of JavaMail CFMX is running? Also, how can I update it to a newer version (if one is available)? Thanks, Mike Wolfe [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: OT radio button validation

2004-01-21 Thread Jeff
Anyone have a quick _javascript_ code top check if a certain radio button is selected then a input field must have content? Are you using Dreamweaver? If so, just go to the Dev Center and download the Yaromat validation Xtra for Dreamweaver. It's really easy, fast, and it'll do exactly what you

Re: OT radio button validation

2004-01-21 Thread Christian Cantrell
On Wednesday, January 21, 2004, at 01:04PM, Robert Orlini wrote: Anyone have a quick _javascript_ code top check if a certain radio button is selected then a input field must have content? Here's a two minute solution: html head script language=_javascript_ function checkForm() { var f =

RE: 3rd party db connectivity drivers vs. vendor db

2004-01-21 Thread Earl, George
We are having a heck of a time getting CFMX 6.1 (Enterprise, standalone, Windows 2000 Adv Server) to work with IBM's JDBC Type 4 DB2 drivers for OS/390. We have the DataDirect DB2 drivers working but our systems people want us to use the IBM drivers . . . ... snipped ... George Well,

RE: CFMX 'bug'? Easy to crash CFMAIL.

2004-01-21 Thread Tom Jordahl
That is my major gripe, why can't these things just work. Because what to you is 'just working' is to a bunch of other people 'hiding an import error'. If you have CFMX 6.1 mail spooling problems, I would look to your mail server.I would also report a problem through technical support and maybe

Re: Finding JavaMail version

2004-01-21 Thread Christian Cantrell
On Wednesday, January 21, 2004, at 02:00PM, Michael Wolfe wrote: How do I determine what version of JavaMail CFMX is running? Also, how can I update it to a newer version (if one is available)? Here is the top of the MANIFEST.MF file from mail.jar: Manifest-Version: 1.0 SCCS-ID:

RE: CFMX 'bug'? Easy to crash CFMAIL.

2004-01-21 Thread Katz, Dov B (IT)
Why not make a nwe query object during cfmail called CFMAIL.FAILEDand make that query have rows from the original one which failed? Then users can cfloop/cfoutput over that query if the recordcount is nonzero. -Dov _ From: Tom Jordahl [mailto:[EMAIL PROTECTED] Sent: Wednesday,

Re: CFMX 'bug'? Easy to crash CFMAIL.

2004-01-21 Thread Christian Cantrell
On Wednesday, January 21, 2004, at 10:18AM, Tyler Clendenin wrote: My main problem with this is that if you send to a query and it throws an error it stops mid e-mail and does not rollback or anything it only sends out the first percentage of the e-mail before the bad e-mail address. Do

Date Conversion

2004-01-21 Thread Craig Hadley
Hello, Anybody have an idea of how I could convert a text field like Tue, 18 Feb 2003 14:43:07 -0800 to a format that could be stored as a date field in an Access 2000 database table formatted like 5/15/2003 5:50:00 PM? Thanks, Craig Hadley Madison WI [Todays Threads] [This Message]

RE: CFMX 'bug'? Easy to crash CFMAIL.

2004-01-21 Thread Tyler Clendenin
so you see no forseeable performance issue with looping over using the query?also does the validator follow all rfc822 standards such as quoted identifiers.and in clarification, this behavoir is a new improvement and not a bug? Tyler Clendenin GSL Solutions _ From: Tom Jordahl

Re: Date Conversion

2004-01-21 Thread Cutter (CF-Talk)
Doesn't the date field in Access take a standard odbc date time? (If I'm wrong let me know, been a long time since I stepped down to Access) #createodbcdatetime(variables.date)# Cutter Craig Hadley wrote: Hello, Anybody have an idea of how I could convert a text field like Tue, 18 Feb

(CFMX RFE) RE: CFMX 'bug'? Easy to crash CFMAIL.

2004-01-21 Thread Katz, Dov B (IT)
Here's my informal CFMX RFE based on this discussion: 1) add a new string function to the cf function library. public String isValidEmail(String s){ try{ new javax.mail.internet.InternetAddress(s); return true; } catch (javax.mail.internet.AddressException e){ return false; } } 2) Add to

  1   2   >