Re: Multilingual site?
And no, UTF-8 is NOT Unicode : UTF8 is an 8 bit encodeing system andUnicode is a 16 bit code. UTF-8 suports Unicode (or any other 16 bitsystem), just as base64 is NOT ASCII, it suports ASCII (or any 8 bitssystem), and ASCII is NOT English (or any other language).Unicode Transformation Format. i rather doubt anyone would have created UTFsw/out unicode. do they somehow predate unicode? are the UTF ever used withanything besides unicode? what character sequence codes do they use? international ms office comes with arial unicode ms, As I told you, it was 2 years ago.it was in international ms office two years ago. Just try a page in Unicode with Netscape 4.7 and you will see ;-(why bring up that pile of dead code?you personally don't want to use unicode, fine. you personally don't needthe euro symbol, fine. however, this discussion was about m11n(multilingual) sites. unicode is by far the best choice for these sorts ofapplications. it offers developers the widest range of languages with theleast cost/resistance in cf. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SQL question
When I use this sql statementselect sum(UNIQUE_VISITs) As sys_sum, to_char(unique_date,'MON') AS MONTH from unique_sessionsWHERE SITE = '#client#'GROUP BY TO_CHAR(unique_date,'MON')It returns the results sorted by alpha like this, but I would like to get date order..APR580 AUG765 FEB69 JUL664 JUN441 MAR354 MAY552 SEP774I tried thisselect unique_date, sum(UNIQUE_VISITs) As sys_sum, to_char(unique_date,'MON') AS MONTH from unique_sessionsWHERE SITE = '#client#'GROUP BY TO_CHAR(unique_date,'MON'), unique_dateand it returned all the possible records.Is there a simple solution some thing I am missing?System is Nt 4 running CF 5 and oracle 8.05Thank you for your time.michael [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL question
MichaelHow about something likeSELECT sum(UNIQUE_VISITs) AS sys_sum, to_char(unique_date,'MM') AS monthno, to_char(unique_date,'MON') AS monthnameFROM unique_sessionsWHERE SITE = '#client#'GROUP BY monthno, monthNick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: DWMX 2004 file save problem?
Just so you know, it is very likely that it is saving, it's just that DWMX 2004 isn't telling you that it is saving. You can check this by making a change, and open the file in notepad to see if the change is there.- Calvin- Original Message - From: Aunger, Mitch To: CF-Talk Sent: Thursday, September 25, 2003 4:25 PMSubject: DWMX 2004 file save problem?Hi again all...I've been using the demo of DWMX 2004 for about 2 weeks and it seemed to work ok before (at least I didn't notice this problem when I first started).When I do a file save, nothing happens - the file isn't saved. Cntl-s doesn't work either. If I try to 'put' the file to my remote folder, DWMX 2004 tells me the file hasn't been saved and would I like it to do it for me... Well THAT works.Is there a place on the MM site where I can see reported/known bugs?I'm suspecting that it may have to do with running both versions on my box (even tho MM support said it would be ok).. But that is just a guess.Oh, I'm running Windows 2000. I've stopped dwmx2004, rebooted, all the usual windows fixes and nada.Thanks!MitchShameless plug for my wife's candle business:http://www.mygccandle.com/showmescents [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Multilingual site?
Claude Schneegans wrote: And no, UTF-8 is NOT Unicode : UTF8 is an 8 bit encodeing system and Unicode is a 16 bit code.Unicode is 16 bit? So how come there are more than 65536 characters?thats hardly a reason not to use unicode. Well, the problem is not of having a reason not using Unicode, but one of having a reason for using it when it is not necessary.You mean that you don't consider RFC's, W3C standards and IETF BCP's reasons?Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: Get the beta of MM Central
On Thursday 25 Sep 2003 19:45 pm, Mike Chambers wrote: http://www.macromedia.com/support/central/ts/documents/issues_central_beta.htmI am not on Windows (linux/RH9/Flash6/Firebird), and the error is not intermitant.-- Tom Chiverton (sorry 'bout sig.)Advanced ColdFusion ProgrammerTel: +44(0)1749 834997email: [EMAIL PROTECTED]BlueFinger LimitedUnderwood Business ParkWookey Hole Road, WELLS. BA5 1AFTel: +44 (0)1749 834900Fax: +44 (0)1749 834901web: www.bluefinger.comCompany Reg No: 4209395 Registered Office: 2 Temple Back East, TempleQuay, BRISTOL. BS1 6EG.*** This E-mail contains confidential information for the addresseeonly. If you are not the intended recipient, please notify usimmediately. You should not use, disclose, distribute or copy thiscommunication if received in error. No binding contract will result fromthis e-mail until such time as a written document is signed on behalf ofthe company. BlueFinger Limited cannot accept responsibility for thecompleteness or accuracy of this message as it has been transmitted overpublic networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: IIS Settings from one server to another
Hello Eric,Friday, September 26, 2003, 3:54:38 AM, you wrote: Is there a quick way to transfer IIS settings from one server to another? (transferring all websites from one box to another.)Did you try the IIS Migration Wizard Tool?http://www.microsoft.com/windows2000/techinfo/reskit/tools/existing/iis_migration_wizard-o.asp-- Giampaolo Bellavite, Milano (Italy)[EMAIL PROTECTED]Team Macromedia Volunteer for ColdFusion* http://www.macromedia.com/support/forums/team_macromedia/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
DWMX 2004 Freehand?
I am trying to remember if the presentation on MX2004 said there was goingto be a 2004 version of freehand.Can anyone else remember? If sodoes anyone know when it'll be available?The MX2004 I downloadedthe other day from the Macromedia site had the new versions of Dreamweaver,Fireworks and Flash, but only Freehand MX and ever since I've been trying toremember if there was to be a new version to go with the others. Cheers,Michael KearWindsor, NSW, AustraliaAFP Webworks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: DWMX 2004 Freehand?
There is a Freehand MXa version which ships with Studio MX 2004-Original Message-From: Mike Kear [mailto:[EMAIL PROTECTED]Sent: 26 September 2003 12:59To: CF-TalkSubject: DWMX 2004 Freehand?I am trying to remember if the presentation on MX2004 said there was goingto be a 2004 version of freehand.Can anyone else remember?If sodoes anyone know when it'll be available?The MX2004 I downloadedthe other day from the Macromedia site had the new versions of Dreamweaver,Fireworks and Flash, but only Freehand MX and ever since I've been trying toremember if there was to be a new version to go with the others.Cheers,Michael KearWindsor, NSW, AustraliaAFP Webworks._[ Todays Threads [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX and SQL Server database connection problems
Hi all, We've just upgraded a couple of our development servers from CF5 to CFMX(6.1) and we're having problems getting CFMX to connect to MS SQL2Kdatabases on another server. When we were using CF5 (behind firewall) wecould connect fine to databases on 2 different servers (one behind thefirewall and one in the DMZ), but now we're on MX I can;t get connected tothe databases in the DMZ. Whilst on CF5 we had network control create a route through the firewall onport 1433 so we could connect to SQL, but this doesn;t seem to do the trickanymore. I'm trying to use the built in MS SQL driver, but if I create anODBC socket connection I can connect - what's going on??! to use the builtin MS SQL driver, should we get a different port opened? Any help would be very much appreciated, Thanks,Alex [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: DWMX 2004 Freehand?
There is a new version of Freehand but it's Freehand 11.1, not MX 2004.It's a minor update.Best regards,Sam--Blog:http://www.rewindlife.comChart: http://www.blinex.com/products/charting---Original Message-From: Mike Kear [mailto:[EMAIL PROTECTED]Sent: Friday, September 26, 2003 7:59 AMTo: CF-TalkSubject: DWMX 2004 Freehand?I am trying to remember if the presentation on MX2004 said there was goingto be a 2004 version of freehand.Can anyone else remember?If sodoes anyone know when it'll be available?The MX2004 I downloadedthe other day from the Macromedia site had the new versions of Dreamweaver,Fireworks and Flash, but only Freehand MX and ever since I've been trying toremember if there was to be a new version to go with the others.Cheers,Michael Kear [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: DWMX 2004 file save problem?
You are right. It is saved. Only DWMX2004 thinks it isn't (asterick is still there). Thanks for the suggestion. MitchShameless plug for my wife's business:http://www.mygccandle.com/showmescents-Original Message-From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: Friday, September 26, 2003 3:28 AMTo: CF-TalkSubject: Re: DWMX 2004 file save problem?Just so you know, it is very likely that it is saving, it's just that DWMX 2004 isn't telling you that it is saving. You can check this by making a change, and open the file in notepad to see if the change is there.- Calvin- Original Message - From: Aunger, Mitch To: CF-Talk Sent: Thursday, September 25, 2003 4:25 PMSubject: DWMX 2004 file save problem?Hi again all...I've been using the demo of DWMX 2004 for about 2 weeks and it seemed to work ok before (at least I didn't notice this problem when I first started).When I do a file save, nothing happens - the file isn't saved. Cntl-s doesn't work either. If I try to 'put' the file to my remote folder, DWMX 2004 tells me the file hasn't been saved and would I like it to do it for me... Well THAT works.Is there a place on the MM site w! he! re I can see reported/known bugs?I'm suspecting that it may have to do with running both versions on my box (even tho MM support said it would be ok).. But that is just a guess.Oh, I'm running Windows 2000. I've stopped dwmx2004, rebooted, all the usual windows fixes and nada.Thanks!MitchShameless plug for my wife's candle business:http://www.mygccandle.com/showmescents_ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: DWMX 2004 file save problem?
Just wanted to chime in and say that this is definitely a bug. It happened to me a couple of days ago, although in my case, a reboot of my machine cleared it up. I know that someone posted the DW wishlist url, but is there a bug-specific place to report for DW?-Original Message-From: Aunger, Mitch [mailto:[EMAIL PROTECTED]Sent: Friday, September 26, 2003 7:21 AMTo: CF-TalkSubject: RE: DWMX 2004 file save problem?You are right. It is saved. Only DWMX2004 thinks it isn't (asterick is still there). Thanks for the suggestion.MitchShameless plug for my wife's business:http://www.mygccandle.com/showmescents-Original Message-From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: Friday, September 26, 2003 3:28 AMTo: CF-TalkSubject: Re: DWMX 2004 file save problem?Just so you know, it is very likely that it is saving, it's just that DWMX 2004 isn't telling you that it is saving. You can check this by making a change, and open the file in notepad to see if the change is there.- Calvin- Original Message - From: Aunger, Mitch To: CF-Talk Sent: Thursday, September 25, 2003 4:25 PMSubject: DWMX 2004 file save problem?Hi again all...I've been using the demo of DWMX 2004 for about 2 weeks and it seemed to work ok before (at least I didn't notice this problem when I first started).When I do a file save, nothing happens - the file isn't saved. Cntl-s doesn't work either. If I try to 'put' the file to my remote folder, DWMX 2004 tells me the file hasn't been saved and would I like it to do it for me... Well THAT works.Is there a place on the MM site w! he! re I can see reported/known bugs?I'm suspecting that it may have to do with running both versions on my box (even tho MM support said it would be ok).. But that is just a guess.Oh, I'm running Windows 2000. I've stopped dwmx2004, rebooted, all the usual windows fixes and nada.Thanks!MitchShameless plug for my wife's candle business:http://www.mygccandle.com/showmescents__[ Todays Threads [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Passing XML to CF via HTTP Post
I found out what my issue was. Curl is expecting the content to beurlencoded, so it is stripping out double quotes from XML attributes. Istill don't have a solution, but at least I know CF isn't part of theproblem.- Original Message -From: stas [EMAIL PROTECTED]To: [EMAIL PROTECTED]Sent: Thursday, September 25, 2003 11:42 AMSubject: Passing XML to CF via HTTP Post I first attempted this with Automate, but Automate's HTTP Post moduleisn't working for me. Now I am doing this with curl, and I am seeing errors in CF's application log: Expecting quoted value for attribute value version... I launch curl like this - curl -d id=?xml version=1.0 encoding=UTF-8?RECORDSR CODE=80492301 NUMB=1 TYPE=0//records localhost/index.cfm CF is 6.1 Standard However, if I pass just the file name containing the XML to CF and do XmlParse based on the variable created with CFFILE reading file name, everything is fine. I do need to get it working via the POST methodthough. Thanks for any tips! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMX and SQL Server database connection problems
A.Little wrote: We've just upgraded a couple of our development servers from CF5 to CFMX (6.1) and we're having problems getting CFMX to connect to MS SQL2K databases on another server. When we were using CF5 (behind firewall) we could connect fine to databases on 2 different servers (one behind the firewall and one in the DMZ), but now we're on MX I can;t get connected to the databases in the DMZ. Whilst on CF5 we had network control create a route through the firewall on port 1433 so we could connect to SQL, but this doesn;t seem to do the trick anymore. I'm trying to use the built in MS SQL driver, but if I create an ODBC socket connection I can connect - what's going on??! to use the built in MS SQL driver, should we get a different port opened?Check your password settings and ake sure you use mixed mode authentication.Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: Flash Chat
Does anyone know of a site with chat on Flash development? I've seen a hundred forums, and sites with Flash based chat clients, but not any chats on Flash dev...Cutter [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: convert string of numbers to numeric?
can you send the whole bit of code? its got to work, there is a way!!!:) tony -Original Message-From: Sam Fisher [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 5:21 PMTo: CF-TalkSubject: Re: convert string of numbers to numeric?Thanks, Tony.Unfortunately it did not work.The error I continue to getis:The value cannot be converted to a number.I have also tried:cfset var1= Val(form.var1 * 1)with no success.Any thoughts?--S- Original Message -From: Tony Weeg [EMAIL PROTECTED]To: CF-Talk [EMAIL PROTECTED]Sent: Thursday, September 25, 2003 3:33 PMSubject: RE: convert string of numbers to numeric? simply stripping out the .'s maybe? or is there something Im not getting? tony cfset newNumber = replace(form.var1,'.',all) would do I presume? -Original Message- From: Sam Fisher [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 3:30 PM To: CF-Talk Subject: convert string of numbers to numeric? Hi Everyone, I have a problem.I am trying to convert a string of numbers to a realdata type, unfortunately without success.I read a CF-Talk board discussion about it, but was unable to get it to work.Can anyone help me.Icreated an input field: cfinput type=text name=var1 validate=float value=#query.var1# range=0.00,7.00 required=No size=4 maxlength=4 Now I need to convert var1 to a number before sending it through theINSERT (SQL) query on my action page.What am I missing? Thanks --S [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX and SQL Server database connection problems
Yes, we've got SQL server running in mixed mode (we did this when weupgraded on of our other servers to MX) and I;ve checked the passwords a fewtimes ;-) I'm not sure that its a password problem because cf admin usuallytells you it's a login failure, but we're getting timeout errors AlexCheck your password settings and ake sure you use mixed mode authentication.Jochem_[Todays [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: convert string of numbers to numeric?
Is form.var1 a valid string?i.e. is it empty? if it is the its not a validstring!From: Tony Weeg [mailto:[EMAIL PROTECTED]Sent: 26 September 2003 13:40To: CF-TalkSubject: RE: convert string of numbers to numeric?can you send the whole bit of code? its got to work, there is a way!!!:) tony -Original Message-From: Sam Fisher [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 5:21 PMTo: CF-TalkSubject: Re: convert string of numbers to numeric?Thanks, Tony.Unfortunately it did not work.The error I continue to getis:The value cannot be converted to a number.I have also tried:cfset var1= Val(form.var1 * 1)with no success.Any thoughts?--S- Original Message -From: Tony Weeg [EMAIL PROTECTED]To: CF-Talk [EMAIL PROTECTED]Sent: Thursday, September 25, 2003 3:33 PMSubject: RE: convert string of numbers to numeric? simply stripping out the .'s maybe? or is there something Im not getting? tony cfset newNumber = replace(form.var1,'.',all) would do I presume? -Original Message- From: Sam Fisher [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 3:30 PM To: CF-Talk Subject: convert string of numbers to numeric? Hi Everyone, I have a problem.I am trying to convert a string of numbers to a realdata type, unfortunately without success.I read a CF-Talk board discussion about it, but was unable to get it to work.Can anyone help me.Icreated an input field: cfinput type=text name=var1 validate=float value=#query.var1# range=0.00,7.00 required=No size=4 maxlength=4 Now I need to convert var1 to a number before sending it through theINSERT (SQL) query on my action page.What am I missing? Thanks --S _[ Todays Threads [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF 6.1 vtm files
The tag updaters on the macromedia site do not contain vtms for the newand updated tags in 6.0/6.1 (cffunction etc)Does anyone have any vtm files for CF6.1? I can't be bothered wiring myown ;-)Craig DudleySenior DeveloperNetstep Corporate Communications LtdDirect Line: +44(0) 1422 319712Phone: +44(0) 1422 200308Fax: +44(0) 1422 200306e-mail: [EMAIL PROTECTED]MS Messenger: [EMAIL PROTECTED]www: www.netstep.co.uk [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: SQL Table pains
This is off topic somewhat, but I needed to move a SQL table to another SQL server. At first it seems the table did not import. So I deleted the one on the new server and then imported the table I wanted (same name). Now the CF cart I created reads the records twice even though the table has on record. Did I miss a step? Is there some kind of reindexing I have to do?Thx.Robert OrliniHW Wilson718-588-8400 x2656¿ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: convert string of numbers to numeric?
val(form.var1) * 1 ?- Calvin- Original Message - From: Tony Weeg To: CF-Talk Sent: Friday, September 26, 2003 8:40 AMSubject: RE: convert string of numbers to numeric?can you send the whole bit of code? its got to work, there is a way!!!:) tony -Original Message-From: Sam Fisher [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 5:21 PMTo: CF-TalkSubject: Re: convert string of numbers to numeric?Thanks, Tony.Unfortunately it did not work.The error I continue to getis:The value cannot be converted to a number.I have also tried:cfset var1= Val(form.var1 * 1)with no success.Any thoughts?--S- Original Message -From: Tony Weeg [EMAIL PROTECTED]To: CF-Talk [EMAIL PROTECTED]Sent: Thursday, September 25, 2003 3:33 PMSubject: RE: convert string of numbers to numeric? simply stripping out the .'s maybe? or is there something Im not getting? ! tony cfset newNumber = replace(form.var1,'.',all) would do I presume? -Original Message- From: Sam Fisher [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 3:30 PM To: CF-Talk Subject: convert string of numbers to numeric? Hi Everyone, I have a problem.I am trying to convert a string of numbers to a realdata type, unfortunately without success.I read a CF-Talk board discussion about it, but was unable to get it to work.Can anyone help me.Icreated an input field: cfinput type=text name=var1 validate=float value=#query.var1# range=0.00,7.00 required=No size=4 maxlength=4 Now I need to convert var1 t! o a number before sending it through theINSERT! ; (SQL) query on my action page.What am I missing? Thanks --S [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX and SQL Server database connection problems
We had a similar problem when we got locked down because of Blaster. Turns out that we had to create an odbc connection on the cf server thatpointed to the sql server and we had to make sure that the dynamic port wasunchecked. After that was done, we didn't use the odbc, but it worked properly.Itjust had to be there. Hope this helps.(of course the cf server is on a windows machine, I don'tknow how you would do it on other os'). Steve -Original Message-From: A.Little [mailto:[EMAIL PROTECTED]Sent: Friday, September 26, 2003 8:44 AMTo: CF-TalkSubject: RE: CFMX and SQL Server database connection problemsYes, we've got SQL server running in mixed mode (we did this when weupgraded on of our other servers to MX) and I;ve checked the passwords a fewtimes ;-) I'm not sure that its a password problem because cf admin usuallytells you it's a login failure, but we're getting timeout errors AlexCheck your password settings and ake sure you use mixed mode authentication.Jochem_[Todays_[ Todays [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX and SQL Server database connection problems
Thanks Steve, I'll give that a go, btw we are on win2K server IIS5Alex-Original Message-From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Sent: 26 September 2003 13:55To: CF-TalkSubject: RE: CFMX and SQL Server database connection problemsWe had a similar problem when we got locked down because of Blaster.Turns out that we had to create an odbc connection on the cf server thatpointed to the sql server and we had to make sure that the dynamic port wasunchecked.After that was done, we didn't use the odbc, but it worked properly.Itjust had to be there.Hope this helps.(of course the cf server is on a windows machine, I don'tknow how you would do it on other os').Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Flash Chat
there's a #flash channel on IRC on DALnet, although I don't know how busy itis.you can check out some of the other IRC nets (like Undernet or EFnet)to see if they have a #flash room.I know all 3 have #coldfusion chans.-Original Message-From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED]Sent: Friday, September 26, 2003 5:38 AMTo: CF-TalkSubject: OT: Flash ChatDoes anyone know of a site with chat on Flash development? I've seen ahundred forums, and sites with Flash based chat clients, but not anychats on Flash dev...Cutter [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL question
Try this:select sum(UNIQUE_VISITs) As sys_sum, to_char(unique_date,'MON') AS MONTH from unique_sessionsWHERE SITE = '#client#'GROUP BY TO_CHAR(unique_date,'MON')ORDER BY TO_DATE(TO_CHAR(unique_date, 'MON'), 'MON') select sum(UNIQUE_VISITs) As sys_sum, to_char(unique_date,'MON') AS MONTH from unique_sessions WHERE SITE = '#client#' GROUP BY TO_CHAR(unique_date,'MON') It returns the results sorted by alpha like this, but I would like to get date order.. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT : SQL List Comparison
Anyone know if and how you can compare two lists in SQL?real world examples could beList 1 : 1,54,36,98,32,67List 2 : 54,98,67Which obviously means 1,36,32 have been removedand indeed this could also be possible : List 1 : 1,54,36,98,32,67List 2 : 54,98,67,36,100,12Which obvioulsy means that 1 32 have been removed and 100 12 have beenaddedits a puzzler...it must be able to be be done...? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Bluedragon Licensing et al.
I am drafting the specs for a volunteer project and considering usingBlueDragon Server on RedHat. I want to make sure I am not misreadinganything: BlueDragon server, with the PostGres drivers, costs nothing interms of a license. Can anyone (maybe from New Atlanta) confirm this isaccurate? Also, does anyone have any information about the performance of theserver version on Linux? The site will need to be able to handle anaverage of 250 concurrent users and will be running on a dual processorserver (at least a Compaq Proliant 370 with dual 800 Mhz processors,which I think we already have donated). M [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Bluedragon Licensing et al.
The free version of BD server is free to use. In development orproduction/deployment.I have a copy of it (3.0.2) running on a Linux Mandrake server for acommunity project that we're building.So far I'm still in development. haven't really had much traffic. I'musing MySQL, seems to work very well.As for the dual processor, I don't think that the free version supportsmultiple CPUs... but I'm not sure about that.Some of the NewAtlanta people should probably answer that.Just a couple of cents worthYves-Original Message-From: Haggerty, Mike [mailto:[EMAIL PROTECTED]Sent: September 26, 2003 10:20 AMTo: CF-TalkSubject: Bluedragon Licensing et al.I am drafting the specs for a volunteer project and considering usingBlueDragon Server on RedHat. I want to make sure I am not misreadinganything: BlueDragon server, with the PostGres drivers, costs nothing interms of a license. Can anyone (maybe from New Atlanta) confirm this isaccurate?Also, does anyone have any information about the performance of theserver version on Linux? The site will need to be able to handle anaverage of 250 concurrent users and will be running on a dual processorserver (at least a Compaq Proliant 370 with dual 800 Mhz processors,which I think we already have donated).M [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT : SQL List Comparison
SQL doesn;t really cope with lists very well, there are some articles here(http://www.sqlteam.com/SearchResults.asp?SearchTerms=csvhttp://www.sqlteam.com/SearchResults.asp?SearchTerms=csv ) about passingcsv strings to stored procs in SQL to then process, but as you'll see itstarts to get a little messy.I guess you're processing the results from a load of checkboxes and tryingto remove and add the ones the user has unticked/ticked. I would stick tousing CF to do the list processing - I'm sure someone will correct me if I;mway off! Just do one delete statement to remove all the existing references (for theparticular user or whatever), then loop through the list in CF and add allthe references from the new list.HTHAlex-Original Message-From: Robertson-Ravo, Neil (RX)[mailto:[EMAIL PROTECTED] Sent: 26 September 2003 14:14To: CF-TalkSubject: OT : SQL List ComparisonAnyone know if and how you can compare two lists in SQL?real world examples could beList 1 : 1,54,36,98,32,67List 2 : 54,98,67Which obviously means 1,36,32 have been removedand indeed this could also be possible : List 1 : 1,54,36,98,32,67List 2 : 54,98,67,36,100,12Which obvioulsy means that 1 32 have been removed and 100 12 have beenaddedits a puzzler...it must be able to be be done...? _[Todays [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Table pains
Robert This is off topic somewhat, but I needed to move a SQL table to anotherSQL server. At first it seems the table did not import. So I deleted the oneon the new server and then imported the table I wanted (same name). Now theCF cart I created reads the records twice even though the table has onrecord. Did I miss a step? Is there some kind of reindexing I have to do?No, there is no re-indexing to do. It sounds like you inadvertently importedthe data twice. Unless your cart is doing some application-level caching orsomething like that.Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: XML String Formatting
Thanks Sam!Appreciate that.- Glen-Original Message-From: Samuel Neff [mailto:[EMAIL PROTECTED]Sent: Thursday, September 25, 2003 7:52 PMTo: CF-TalkSubject: RE: XML String FormattingIt's from a CFDJ article, Transforming XML, Part 3 by David Grassner inCFDJ Volume 4 Issue 8.!--- Listing 1: XMLIndent() requires one argument of type XML returns the resulting XML as text ---cffunction name=XMLIndent returntype=stringcfargument name=xml type=string required=Yescfset xsl='?xml version=1.0? xsl:stylesheet version=1.0xmlns:xsl=http://www.w3.org/1999/XSL/Transformxmlns:xalan=http://xml.apache.org/xsltxsl:output indent=yes xalan:indent-amount=2/xsl:template match=/ xsl:copy-of select=.//xsl:template /xsl:stylesheet'cfset output=xmltransform(arguments.xml, xsl)cfreturn output/cffunctionSYS-CON sells a CF resource cd that has all of their old articles and codesamples.It's well worth the money, even if you have all the magazines.http://www.jdjstore.com/colrescd.htmlHTH,Sam--Blog:http://www.rewindlife.comChart: http://www.blinex.com/products/charting-- -Original Message- From: Glen Salisbury [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 2:45 PM To: CF-Talk Subject: XML String Formatting Some where in the million sites I look at each day. (maybe not quite that many sites but somewhere). Someone wrote a niffty little function to format XML with proper indentation for the proposed of easy readablity. Anyone happen to know who/where I'd find that function. Thanks, Glen Salisbury [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL List Comparison
Neil Anyone know if and how you can compare two lists in SQL?imo the answer to all questions about lists in SQL is... don't store yourdata as lists!Nota very helpful statement I know. But you could read the lists intoanother table with a normalised structure and all of a sudden the querywould be easy.Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF Restart Proplems
We are currently in the process of developing a new interface between CFMX and an IBM AS/400.We have had several instances where CF has needed to be restarted.The problem is once restarted, Apache seems to lose it's connection and all subsequent calls to .cfm pages fail to be processed and display the cfml in all its gory glory. We are running CFMX 6.0, Apache 1.3.26, running on redhat Linux 7.3.The only sure cure we have found is to reboot the Linux (not an optimal solution).Any ideas and or suggestions greatly appreciated. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Bluedragon Licensing et al.
I am drafting the specs for a volunteer project andconsidering usingBlueDragon Server on RedHat. I want to make sure I am notmisreadinganything: BlueDragon server, with the PostGres drivers,costs nothing interms of a license. Can anyone (maybe from New Atlanta)confirm this isaccurate?Correct.The entry-level version of BlueDragon Server is free fordevelopmentand deployment, with restrictions only on redistribution.From the New Atlanta BlueDragon Software License Agreement(SLA):BlueDragon Server (Non-Fee Based). Subject to this SLA, NAC grants you a limited,non-exclusive, non-transferable, non-assignable, non-sub-licensablelicense to download, install and use BlueDragon Server on asingle Server machine for development, testing and deploymentpurposes. BlueDragon Server may not be bundled or distributedwith yours or any third party application(s) unless a separate andunique VAR/OEM agreement is in place with NAC thatexplicitly grants these rights.Regards,DanDaniel GanterNew Atlanta Communicationswww.newatlanta.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Parsing XML in ColdFusion - Help!!
As long as you know where the logo element is supposed to be you can check for it's existence with xmlnamecfif root.subelement1.subelement2.xmlName IS logo [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Flash Chat
http://www.pipey.com/chat/default.asphttp://www.pipey.com/chat/default.asp Rick -Original Message-From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] Sent: Friday, September 26, 2003 7:38 AMTo: CF-TalkSubject: OT: Flash Chat Does anyone know of a site with chat on Flash development? I've seen a hundred forums, and sites with Flash based chat clients, but not any chats on Flash dev...Cutter_ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Bluedragon Licensing et al.
Yves - Any idea where I could get more information about the restriction onmultiple processors? I poured over NA's Web site last night and found nodocumentation about this. M -Original Message- From: Yves Arsenault [mailto:[EMAIL PROTECTED] Sent: Friday, September 26, 2003 9:23 AM To: CF-Talk Subject: RE: Bluedragon Licensing et al. The free version of BD server is free to use. In development or production/deployment. I have a copy of it (3.0.2) running on a Linux Mandrake serverfor a community project that we're building. So far I'm still in development. haven't really had muchtraffic. I'm using MySQL, seems to work very well. As for the dual processor, I don't think that the free versionsupports multiple CPUs... but I'm not sure about that. Some of the NewAtlanta people should probably answer that. Just a couple of cents worth Yves-Original Message- From: Haggerty, Mike [mailto:[EMAIL PROTECTED] Sent: September 26, 2003 10:20 AM To: CF-Talk Subject: Bluedragon Licensing et al. I am drafting the specs for a volunteer project andconsidering using BlueDragon Server on RedHat. I want to make sure I am notmisreading anything: BlueDragon server, with the PostGres drivers, costsnothing in terms of a license. Can anyone (maybe from New Atlanta)confirm this is accurate? Also, does anyone have any information about the performanceof the server version on Linux? The site will need to be able tohandle an average of 250 concurrent users and will be running on a dualprocessor server (at least a Compaq Proliant 370 with dual 800 Mhzprocessors, which I think we already have donated). M _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF Restart Proplems
On Friday 26 Sep 2003 14:38 pm, Greg Hassler wrote: restarted.The problem is once restarted, Apache seems to lose it's 1.3.26, running on redhat Linux 7.3.The only sure cure we have found is to reboot the Linux (not an optimal solution).You're right, shouldn't be needed !Does stop/starting Apache not help ? Do all Apache process die of when Apache is stopped ?-- Tom Chiverton (sorry 'bout sig.)Advanced ColdFusion ProgrammerTel: +44(0)1749 834997email: [EMAIL PROTECTED]BlueFinger LimitedUnderwood Business ParkWookey Hole Road, WELLS. BA5 1AFTel: +44 (0)1749 834900Fax: +44 (0)1749 834901web: www.bluefinger.comCompany Reg No: 4209395 Registered Office: 2 Temple Back East, TempleQuay, BRISTOL. BS1 6EG.*** This E-mail contains confidential information for the addresseeonly. If you are not the intended recipient, please notify usimmediately. You should not use, disclose, distribute or copy thiscommunication if received in error. No binding contract will result fromthis e-mail until such time as a written document is signed on behalf ofthe company. BlueFinger Limited cannot accept responsibility for thecompleteness or accuracy of this message as it has been transmitted overpublic networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT : SQL List Comparison
Yep, I think I will have to do things in CF, though unfortunately forlogging purposes I need to know a little more about what they haveselected/removed before the deletion / insertion occurs.-Original Message-From: A.Little [mailto:[EMAIL PROTECTED]Sent: 26 September 2003 14:31To: CF-TalkSubject: RE: OT : SQL List ComparisonSQL doesn;t really cope with lists very well, there are some articles here( http://www.sqlteam.com/SearchResults.asp?SearchTerms=csvhttp://www.sqlteam.com/SearchResults.asp?SearchTerms=csv http://www.sqlteam.com/SearchResults.asp?SearchTerms=csvhttp://www.sqlteam.com/SearchResults.asp?SearchTerms=csv ) about passingcsv strings to stored procs in SQL to then process, but as you'll see itstarts to get a little messy.I guess you're processing the results from a load of checkboxes and tryingto remove and add the ones the user has unticked/ticked. I would stick tousing CF to do the list processing - I'm sure someone will correct me if I;mway off! Just do one delete statement to remove all the existing references (for theparticular user or whatever), then loop through the list in CF and add allthe references from the new list.HTHAlex-Original Message-From: Robertson-Ravo, Neil (RX)[mailto:[EMAIL PROTECTED] Sent: 26 September 2003 14:14To: CF-TalkSubject: OT : SQL List ComparisonAnyone know if and how you can compare two lists in SQL?real world examples could beList 1 : 1,54,36,98,32,67List 2 : 54,98,67Which obviously means 1,36,32 have been removedand indeed this could also be possible : List 1 : 1,54,36,98,32,67List 2 : 54,98,67,36,100,12Which obvioulsy means that 1 32 have been removed and 100 12 have beenaddedits a puzzler...it must be able to be be done...? _[Todays_[ Todays [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Bluedragon Licensing et al.
I am drafting the specs for a volunteer project and considering usingBlueDragon Server on RedHat. I want to make sure I am not misreadinganything: BlueDragon server, with the PostGres drivers, costs nothing interms of a license. Can anyone (maybe from New Atlanta) confirm this isaccurate?Trying again with non-html text:Correct.The entry-level version of BlueDragon Server is free fordevelopment and deployment, with restrictions only onredistribution.From the New Atlanta BlueDragon Software License Agreement (SLA):BlueDragon Server (Non-Fee Based). Subject to this SLA, NAC grants you a limited, non-exclusive, non-transferable, non-assignable, non-sub-licensable license to download, install and use BlueDragon Server on a single Server.Regards,DanDaniel GanterNew Atlanta Communicationswww.newatlanta.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT : SQL List Comparison
If you need to track what's been inserted/deleted, then you could (beforeyou do any db inserts/deletes) loop through the old list and find whichvalues aren;t in the new list - to find whats been deleted, then loop thoughthe new list and find which values aren;t in the old list to find what'sbeen inserted. Then at least you'll have the history - still need to be CFthough!Alex-Original Message-From: Robertson-Ravo, Neil (RX)[mailto:[EMAIL PROTECTED] Sent: 26 September 2003 14:40To: CF-TalkSubject: RE: OT : SQL List ComparisonYep, I think I will have to do things in CF, though unfortunately forlogging purposes I need to know a little more about what they haveselected/removed before the deletion / insertion occurs. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
debugging - query and includes
At my new job we are not allow access to the CFAdministrator, and Iwant to use debugging, so I got a copy of cf_debug as we are usingfb3 and it works great, except it doesn't list queries or includeslike the cfadmin debugging does. Is there some undocumented tag orsomething that will allow me to dynamically display the query andinclude list? I have searched the archive and without specificallyhard coding the name of the query i cannot find a way to output theresults.tia~~Stephenie Hamilton [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:CF Restart Proplems
No, stopping and starting (or restarting) Apache does not always help.I am sure it must be a sequencing issue (chicken or the egg) but it is driving us crazy.The standard procedure is to stop CF, restart, stop apache, restart.But apache doesnt seem to resynch with the CF.We have tried several different sequences but have yet to find one that is guaranteed to work. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Bluedragon Licensing et al.
Mike,The license is for a server, with norestrictions on the number of cpus.The definitive source for use of BlueDragon Serveris the Software License Agreement (SLA).Regards,DanDaniel GanterNew Atlanta Communicationswww.newatlanta.com-Original Message-From: Haggerty, Mike [mailto:[EMAIL PROTECTED]Sent: Friday, September 26, 2003 9:41 AMTo: CF-TalkSubject: RE: Bluedragon Licensing et al.Yves - Any idea where I could get more information about the restriction onmultiple processors? I poured over NA's Web site last night and found nodocumentation about this.M [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Client vars not being set on first request?
We've got a cluster setup in which we're relying on cluster variablesfor recognizing a user when they're bounced to the second server.(sticky session won't work because the front end web servers areclustered as well)Apparently when the user leaves the first page and gets bounced to thesecond server, the client vars do not exist. (both servers share sameclient storage)Anyone seen this?CFMX61 on JRun4 / SolarisStaceAVIS IMPORTANT:--- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme.WARNING:---The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Bluedragon Licensing et al.
You could try posting on this listhttp://www.newatlanta.com/products/bluedragon/self_help/archive_search/index.cfmI may be wrong, I'm not sure.I also just checked through the site and didn't find any reference tomultiple CPUs for the free version.This is all I found, with reference to multiple CPUs, the J2EE server pricedper CPU.http://www.newatlanta.com/products/bluedragon/product_info/features.cfmYves-Original Message-From: Haggerty, Mike [mailto:[EMAIL PROTECTED]Sent: September 26, 2003 10:41 AMTo: CF-TalkSubject: RE: Bluedragon Licensing et al.Yves -Any idea where I could get more information about the restriction onmultiple processors? I poured over NA's Web site last night and found nodocumentation about this.M-Original Message-From: Yves Arsenault [mailto:[EMAIL PROTECTED]Sent: Friday, September 26, 2003 9:23 AMTo: CF-TalkSubject: RE: Bluedragon Licensing et al.The free version of BD server is free to use. In development orproduction/deployment.I have a copy of it (3.0.2) running on a Linux Mandrake serverfor acommunity project that we're building.So far I'm still in development. haven't really had muchtraffic. I'musing MySQL, seems to work very well.As for the dual processor, I don't think that the free versionsupportsmultiple CPUs... but I'm not sure about that.Some of the NewAtlanta people should probably answer that.Just a couple of cents worthYves -Original Message- From: Haggerty, Mike [mailto:[EMAIL PROTECTED] Sent: September 26, 2003 10:20 AM To: CF-Talk Subject: Bluedragon Licensing et al. I am drafting the specs for a volunteer project andconsidering using BlueDragon Server on RedHat. I want to make sure I am notmisreading anything: BlueDragon server, with the PostGres drivers, costsnothing in terms of a license. Can anyone (maybe from New Atlanta)confirm this is accurate? Also, does anyone have any information about the performanceof the server version on Linux? The site will need to be able tohandle an average of 250 concurrent users and will be running on a dualprocessor server (at least a Compaq Proliant 370 with dual 800 Mhzprocessors, which I think we already have donated). M _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Bluedragon Licensing et al.
Alright, thanks Daniel, I appreciate the help. M -Original Message- From: Daniel Ganter [mailto:[EMAIL PROTECTED] Sent: Friday, September 26, 2003 9:54 AM To: CF-Talk Subject: RE: Bluedragon Licensing et al. Mike, The license is for a server, with no restrictions on the number of cpus. The definitive source for use of BlueDragon Server is the Software License Agreement (SLA). Regards, Dan Daniel Ganter New Atlanta Communications www.newatlanta.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Bluedragon Licensing et al.
Ah there is the answer.:-)Hey, my board supports multiple CPUs. might be an idea for us over hereeventually.- Yves --Original Message-From: Daniel Ganter [mailto:[EMAIL PROTECTED]Sent: September 26, 2003 10:54 AMTo: CF-TalkSubject: RE: Bluedragon Licensing et al.Mike,The license is for a server, with norestrictions on the number of cpus.The definitive source for use of BlueDragon Serveris the Software License Agreement (SLA).Regards,DanDaniel GanterNew Atlanta Communicationswww.newatlanta.com-Original Message-From: Haggerty, Mike [mailto:[EMAIL PROTECTED]Sent: Friday, September 26, 2003 9:41 AMTo: CF-TalkSubject: RE: Bluedragon Licensing et al.Yves -Any idea where I could get more information about the restriction onmultiple processors? I poured over NA's Web site last night and found nodocumentation about this.M [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Flash Chat
Cutter - I am open for IM chat if you need help.AOl - clint1274MSN - [EMAIL PROTECTED]YIM - clinttredwaycfhelp wrote: http://www.pipey.com/chat/default.asp http://www.pipey.com/chat/default.asp http://www.pipey.com/chat/default.asp%3E Rick -Original Message- From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] Sent: Friday, September 26, 2003 7:38 AM To: CF-Talk Subject: OT: Flash Chat Does anyone know of a site with chat on Flash development? I've seen a hundred forums, and sites with Flash based chat clients, but not any chats on Flash dev... Cutter_ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT : SQL List Comparison
Depending on your database and exactly what you wantedto do with the list, You could try something likeupdate yourTable set selected=0where primKey in (select primKey from yourTable where primKey in(#List1#) MINUSselect primKey from yourTable where primKey in(#List2#))Clever combinations of the basic set operations usingUNION, MINUS, and NOT IN will perform set operationson lists.--- Robertson-Ravo, Neil (RX)[EMAIL PROTECTED] wrote: Anyone know if and how you can compare two lists in SQL? real world examples could be List 1 : 1,54,36,98,32,67 List 2 : 54,98,67 Which obviously means 1,36,32 have been removed and indeed this could also be possible : List 1 : 1,54,36,98,32,67 List 2 : 54,98,67,36,100,12 Which obvioulsy means that 1 32 have been removed and 100 12 have been added its a puzzler...it must be able to be be done...? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: convert string of numbers to numeric?
Yes, I set the default value=0.Thanks,-S - Original Message - From: Robertson-Ravo, Neil (RX) To: CF-Talk Sent: Friday, September 26, 2003 8:44 AMSubject: RE: convert string of numbers to numeric?Is form.var1 a valid string?i.e. is it empty? if it is the its not a validstring!From: Tony Weeg [mailto:[EMAIL PROTECTED]Sent: 26 September 2003 13:40To: CF-TalkSubject: RE: convert string of numbers to numeric?can you send the whole bit of code? its got to work, there is a way!!!:) tony -Original Message-From: Sam Fisher [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 5:21 PMTo: CF-TalkSubject: Re: convert string of numbers to numeric?Thanks, Tony.Unfortunately it did not work.The error I continue to getis:The value cannot be converted to a number.I have also tried:cfset var1= Val(form.var1 * 1)with no success.Any thoughts?--S- Original Message -From: Tony Weeg [EMAIL PROTECTED]g! t;To: CF-Talk [EMAIL PROTECTED]Sent: Thursday, September 25, 2003 3:33 PMSubject: RE: convert string of numbers to numeric? simply stripping out the .'s maybe? or is there something Im not getting? tony cfset newNumber = replace(form.var1,'.',all) would do I presume? -Original Message- From: Sam Fisher [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 3:30 PM To: CF-Talk Subject: convert string of numbers to numeric? Hi Everyone, I have a problem.I am trying to convert a string of numbers to a realdata type, unfortunately without success.I read a CF-Talk board discussion about it, but was unable to get it to work.Can anyone help me.Icreated an input field: cfinput type=text name=v! ar1 ; validate=float value=#query.var1# range=0.00,7.00 required=No size=4 maxlength=4 Now I need to convert var1 to a number before sending it through theINSERT (SQL) query on my action page.What am I missing? Thanks --S _[ Todays Threads [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: debugging - query and includes
If I remember sql and cfincludes where two things we could not tie into withcf_debug. That is if your talking about the cf_debug I helped write awhileback along with Scott Van Vliet. We looked into this and I believeScott spoke with Ben Forta about this andI can't fully remember why but the cfinclude collection and query/sqlcollection is not exposed outside away from CFs own debugging. But, someone may have written a com object by now. Shawn Regan-Original Message-From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]Sent: Friday, September 26, 2003 6:50 AMTo: CF-TalkSubject: debugging - query and includesAt my new job we are not allow access to the CFAdministrator, and Iwant to use debugging, so I got a copy of cf_debug as we are usingfb3 and it works great, except it doesn't list queries or includeslike the cfadmin debugging does. Is there some undocumented tag orsomething that will allow me to dynamically display the query andinclude list? I have searched the archive and without specificallyhard coding the name of the query i cannot find a way to output theresults.tia~~Stephenie Hamilton_[ Todays Threads [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:What happened to my digest?
Free resources of this quality are becoming fewer and harder to find...I for one appreciate all the work Mike puts into CF-Talk and gladly accept advertising if that's what it takes to keep it going. It's sad that the people who seem to utilize and enjoy this list the most are attacking it for attempting to break even on some of its expenses!Rachel Maxim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT : SQL List Comparison
Managed it via this SQL : declare @List1 varchar(255), @List2 varchar(255), @sql varchar(255) set @List1 = '1,2,34,12,43,21,5,9,10'set @List2 = '34,12,43,21,23,35,19,5,10' create table #List1 (itemvarchar(10))create table #List2 (itemvarchar(10)) select @sql = 'insert #List1 select ' + replace(@List1,',', ' union select')exec (@sql) select @sql = 'insert #List2 select ' + replace(@List2,',', ' union select')exec (@sql) select 'Removed', * from #List1 where item not in (select item from #List2)select 'Added', * from #List2 where item not in (select item from #List1) drop table #List1drop table #List2 -Original Message-From: A.Little [mailto:[EMAIL PROTECTED]Sent: 26 September 2003 14:49To: CF-TalkSubject: RE: OT : SQL List ComparisonIf you need to track what's been inserted/deleted, then you could (beforeyou do any db inserts/deletes) loop through the old list and find whichvalues aren;t in the new list - to find whats been deleted, then loop thoughthe new list and find which values aren;t in the old list to find what'sbeen inserted. Then at least you'll have the history - still need to be CFthough!Alex-Original Message-From: Robertson-Ravo, Neil (RX)[mailto:[EMAIL PROTECTED] Sent: 26 September 2003 14:40To: CF-TalkSubject: RE: OT : SQL List ComparisonYep, I think I will have to do things in CF, though unfortunately forlogging purposes I need to know a little more about what they haveselected/removed before the deletion / insertion occurs._[ Todays Threads [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Multilingual site?
why bring up that pile of dead code?I didn't brought up I told you it was 2 years ago.this discussion was about m11n(multilingual) sites. unicode is by far the bestThis discution was about English and French only. For French Unicode is NOT necessary,That is all what I said. PERIOD. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF Restart Proplems
The standard procedure is to stop CF, restart, stop apache, restart.Try:Stop apacheRestart CFStart apacheAlso, as you're using a 1.3.xx version of apache, make sure you'verecompiled the connector appropriately:For ColdFusion MX Updater Release 3 or higher, the code and compileinstructions are included in cf_root/runtime/lib/wsconfig.jar in the/connectors/src/ApacheModule.zip file. See ApacheBuildInstructions.txtin the ApacheModule.zip.Tim.---OUR NEW SITE IS NOW LIVEVisit our new website at http://www.rawnet.com/ andrace around the beautiful Bracknell streets athttp://xmas.rawnet.com/---Tim BlairWeb Application Engineer, Rawnet LimitedDirect Phone : +44 (0) 1344 393 441Switchboard : +44 (0) 1344 393 040---This message may contain information which is legallyprivileged and/or confidential.If you are not theintended recipient, you are hereby notified that anyunauthorised disclosure, copying, distribution or useof this information is strictly prohibited. Suchnotification notwithstanding, any comments, opinions,information or conclusions expressed in this messageare those of the originator, not of rawnet limited,unless otherwise explicitly and independently indicatedby an authorised representative of rawnet limited.--- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Parsing hyperlinks and name
Hi All,I have to parse some complex links likea href="" class=link_orange >>g name=lpg2 src="" alt=Link PopularityGauge border=0 width=63/aora href="" class=link_whiteClick here to findout/aI need a CFSCRIPT to do that. I was successfully able to get the link usingbeow patedcfscsipt. But Also I need is if it is a image linkthen itshould say Image Link - No Text else get the text means name of the link.cfscriptfunction GetAnchor(str) { var output = ArrayNew(1); var i=1; var start = 1; var matchStruct =; while(1 eq 1){reFindNoCase([[:space:]]*a[[:space:]]*[^]*href[[:space:]]*=[[:space:]]*([^]*),str,start,1); if(arrayLen(matchStruct.len) lt 2) { return output; } output[i] = Mid(str,matchStruct.pos[2],matchStruct.len[2]); start = matchStruct.pos[2]; i = i + 1; }}/cfscriptAny help is appreciated. Thanks in advance.Ketan PatelG3 Technology Group, LLCGraphics III Advertising, Inc.(410)789-7007 or (800)783-1799It's Not Creative if it doesn't Sell.http://www.g3group.com http://www.g3group.com
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:debugging - query and includes
Yes I am talking about the cf_debug tag you were a part of.well crud. I was hoping someone had the golden kernel of knowledge on how to get that info. thanks anyway.~~StephenieIf I remember sql and cfincludes where two things we could not tie into withcf_debug. That is if your talking about the cf_debug I helped write awhileback along with Scott Van Vliet. We looked into this and I believeScott spoke with Ben Forta about this andI can't fully remember why but the cfinclude collection and query/sqlcollection is not exposed outside away from CFs own debugging. But, someone may have written a com object by now. Shawn Regan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Multilingual site?
why bring up that pile of dead code? I didn't brought up I told you it was 2 years ago.well you did in fact bring it up. ns4.7 was a mess in more than one respectbut i don't recall lousy unicode font rendering was one of them. if that wasanother attempt to cast some doubt on the use of unicode, please don'tbother. this discussion was about m11n (multilingual) sites. unicode is by far the best This discution was about English and French only. For French Unicode isNOT necessary, That is all what I said. PERIOD.sorry but the subject is multilingual site? and unicode is still the bestchoice for that type of cf application. not using it is a bad choice. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT : SQL List Comparison
What SQL server are you using? If it is MSSQL2000, I have created some list functions (I've mentioned themon cf-talk before).One of them takes a list and returns a table with 2columns the item position in the list and the value of that item. If you are interested, I can send them to you. The functions I created are: 1) listAppend 2) listDeleteAt 3) listFirst 4) listGetAt 5) listInsertAt 6) listLast 7) listLen 8) listPrepend 9) listSetAt 10) listToTable I would post them to the internet, but I don't have an ftp server at themoment.I will work on that this weekend. Steve -Original Message-From: Robertson-Ravo, Neil (RX)[mailto:[EMAIL PROTECTED]Sent: Friday, September 26, 2003 10:06 AMTo: CF-TalkSubject: RE: OT : SQL List ComparisonManaged it via this SQL :declare @List1 varchar(255),@List2 varchar(255),@sql varchar(255)set @List1 = '1,2,34,12,43,21,5,9,10'set @List2 = '34,12,43,21,23,35,19,5,10'create table #List1 (itemvarchar(10))create table #List2 (itemvarchar(10))select @sql = 'insert #List1 select ' + replace(@List1,',', ' union select')exec (@sql)select @sql = 'insert #List2 select ' + replace(@List2,',', ' union select')exec (@sql)select 'Removed', * from #List1 where item not in (select item from #List2)select 'Added', * from #List2 where item not in (select item from #List1)drop table #List1drop table #List2-Original Message-From: A.Little [mailto:[EMAIL PROTECTED]Sent: 26 September 2003 14:49To: CF-TalkSubject: RE: OT : SQL List ComparisonIf you need to track what's been inserted/deleted, then! you could (beforeyou do any db inserts/deletes) loop through the old list and find whichvalues aren;t in the new list - to find whats been deleted, then loop thoughthe new list and find which values aren;t in the old list to find what'sbeen inserted. Then at least you'll have the history - still need to be CFthough!Alex-Original Message-From: Robertson-Ravo, Neil (RX)[mailto:[EMAIL PROTECTED] Sent: 26 September 2003 14:40To: CF-TalkSubject: RE: OT : SQL List ComparisonYep, I think I will have to do things in CF, though unfortunately forlogging purposes I need to know a little more about what they haveselected/removed before the deletion / insertion occurs._[ Todays Threads _[ Todays Threads [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Multilingual site?
Erm,just to be anal and incite multiple flames (Ive learnt thistechnique from others on the list) I believe UTF actually stands forUCS transformation format rather than the more popular interpretationof Unicode Transformation Format :-) UCS Stands for Universal Character Set a.k.a Universal Multiple-OctetCoded Character Set which is defined as being a superset of Unicode. So if we are to believe all of that then UTF-8 (UCS transformationformat 8) is not strictly Unicode specific. Now that Ive put you all to sleep with this exciting information, wecan get back to addressing the original question of this thread. Andr -Original Message-From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: 26 September 2003 07:40To: CF-TalkSubject: Re: Multilingual site? And no, UTF-8 is NOT Unicode : UTF8 is an 8 bit encodeing system andUnicode is a 16 bit code. UTF-8 suports Unicode (or any other 16 bitsystem), just as base64 is NOT ASCII, it suports ASCII (or any 8 bitssystem), and ASCII is NOT English (or any other language).Unicode Transformation Format. i rather doubt anyone would have createdUTFsw/out unicode. do they somehow predate unicode? are the UTF ever usedwithanything besides unicode? what character sequence codes do they use? international ms office comes with arial unicode ms, As I told you, it was 2 years ago.it was in international ms office two years ago. Just try a page in Unicode with Netscape 4.7 and you will see ;-(why bring up that pile of dead code?you personally don't want to use unicode, fine. you personally don'tneedthe euro symbol, fine. however, this discussion was about m11n(multilingual) sites. unicode is by far the best choice for these sortsofapplications. it offers developers the widest range of languages withtheleast cost/resistance in cf._[Todays [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: What happened to my digest?
I agree 300% At my last job, I was one of 15 CF developers.They wondered how thehell I was able to figure seemingly difficult things quickly.I kepttelling them to participate in the list, that it is a win-win situationfor all who participate.Long story short, CF-Talk has helped me makedeadlines.CF-talk has helped me make better applications.CF-Talk hashelped my career.I owe Mike and a lot of you all a drink and ahandshake for giving my career a boost! I'm primarily a .NET developer now (I love CF, but that's another thread;-).In all the .net forums, newsgroups, IRC channels, etc. I have yetto find a place that measures up to the level of community I find here.My hat goes off to Mike and all you CF-Talkers!The LEAST I can do ishave some ads come in on the messages. Many thanks! Eric Carlisle -Original Message-From: Rachel Maxim [mailto:[EMAIL PROTECTED] Sent: Friday, September 26, 2003 10:06 AMTo: CF-TalkSubject: Re:What happened to my digest? Free resources of this quality are becoming fewer and harder to find...Ifor one appreciate all the work Mike puts into CF-Talk and gladly acceptadvertising if that's what it takes to keep it going. It's sad that thepeople who seem to utilize and enjoy this list the most are attacking itfor attempting to break even on some of its expenses!Rachel Maxim_ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL question
Thank you that worked.But strangely enough I never got the original message that I posted.thanks againDeanna Schneider wrote: Try this: select sum(UNIQUE_VISITs) As sys_sum, to_char(unique_date,'MON') AS MONTH from unique_sessions WHERE SITE = '#client#' GROUP BY TO_CHAR(unique_date,'MON') ORDER BY TO_DATE(TO_CHAR(unique_date, 'MON'), 'MON') select sum(UNIQUE_VISITs) As sys_sum, to_char(unique_date,'MON') AS MONTH from unique_sessions WHERE SITE = '#client#' GROUP BY TO_CHAR(unique_date,'MON') It returns the results sorted by alpha like this, but I would like to get date order.. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Multilingual site?
Erm,just to be anal and incite multiple flames (I've learnt this technique from others on the list).I believe UTF actually stands for UCS transformation format rather than the more popular interpretation of Unicode Transformation Format :-)no thats not quite correct. its unicode OR ucs. theUTF-8 definitionactually states Unicode (or UCS) Transformation Format, 8-bit encodingform. UTF-8 is the Unicode Transformation Format that serializes a Unicodescalar value (code point) as a sequence of one to four bytes, as specifiedin...http://www.unicode.org/glossary/nice try though. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF Restart Proplems
On Friday 26 Sep 2003 14:55 pm, Greg Hassler wrote: The standard procedure is to stop CF, restart, stop apache, restart.But apache doesnt seem to resynch with the CF.We have tried several different sequences but have yet to find one that is guaranteed to work.I'd stop CF, stop Apache.Check all CF and Apache process have actualy died.Start CF, Start Apache.-- Tom Chiverton (sorry 'bout sig.)Advanced ColdFusion ProgrammerTel: +44(0)1749 834997email: [EMAIL PROTECTED]BlueFinger LimitedUnderwood Business ParkWookey Hole Road, WELLS. BA5 1AFTel: +44 (0)1749 834900Fax: +44 (0)1749 834901web: www.bluefinger.comCompany Reg No: 4209395 Registered Office: 2 Temple Back East, TempleQuay, BRISTOL. BS1 6EG.*** This E-mail contains confidential information for the addresseeonly. If you are not the intended recipient, please notify usimmediately. You should not use, disclose, distribute or copy thiscommunication if received in error. No binding contract will result fromthis e-mail until such time as a written document is signed on behalf ofthe company. BlueFinger Limited cannot accept responsibility for thecompleteness or accuracy of this message as it has been transmitted overpublic networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
MX Standard or Enterprise?
I'musing CF 5 Enterprise right now and want to upgrade to MX. I lookedthrough Macromedia's website, reading the FAQ's, watching the flashpresentations, and looking at comparisons charts. It looks like all I needis the standard edition but I don't want to get it and realize I should havegrabbed the Enterprise version instead.I would like the option to use the java features of Enterprise. I have yetto find a problem with the current cfmail with the exception of zero bytefiles. I don't need load balancing or clustering. I'm not sure what serverlogs are not included with standard but I would like to see what the heck isgoing on. Is the system monitoring just a little nicer then the CF 5version? I only use access and sql 2000 data sources and the occasional textfile. (Dont ask)So, after this long ramble, does the standard version look like the rightversion? I can get the Enterprise but I would hate to spend the money without good reason.Phillip B.www.LoungeRoyale.comwww.FillWorks.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: What happened to my digest?
On Friday 26 Sep 2003 15:06 pm, Rachel Maxim wrote: advertising if that's what it takes to keep it going.Which doesn't seem to be the case.I run mailing lists for several local groups (using MailMan), and don't seem to have to put in as much effort as Mike does shrug-- Tom Chiverton (sorry 'bout sig.)Advanced ColdFusion ProgrammerTel: +44(0)1749 834997email: [EMAIL PROTECTED]BlueFinger LimitedUnderwood Business ParkWookey Hole Road, WELLS. BA5 1AFTel: +44 (0)1749 834900Fax: +44 (0)1749 834901web: www.bluefinger.comCompany Reg No: 4209395 Registered Office: 2 Temple Back East, TempleQuay, BRISTOL. BS1 6EG.*** This E-mail contains confidential information for the addresseeonly. If you are not the intended recipient, please notify usimmediately. You should not use, disclose, distribute or copy thiscommunication if received in error. No binding contract will result fromthis e-mail until such time as a written document is signed on behalf ofthe company. BlueFinger Limited cannot accept responsibility for thecompleteness or accuracy of this message as it has been transmitted overpublic networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Multilingual site?
Doh! Hoping no one would be as anal as me and actually check that out ohwell. I did try (secretly trying to prolong this exciting debate) Interesting how an abbreviation can mean two things, not ambiguous atall. Andr -Original Message-From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: 26 September 2003 16:06To: CF-TalkSubject: Re: Multilingual site? Erm,just to be anal and incite multiple flames (I've learnt this technique from others on the list).I believe UTF actually stands for UCS transformation format rather than the more popularinterpretation of Unicode Transformation Format :-)no thats not quite correct. its unicode OR ucs. theUTF-8 definitionactually states Unicode (or UCS) Transformation Format, 8-bit encodingform. UTF-8 is the Unicode Transformation Format that serializes aUnicodescalar value (code point) as a sequence of one to four bytes, asspecifiedin...http://www.unicode.org/glossary/nice try though._[Todays [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Multilingual site?
So how come there are more than 65536 characters?Since version 3, new planes have been added to the original 16 bits code. At the origin, Unicode was fundmentally a 16 bits code.You mean that you don't consider RFC's, W3C standards and IETFNow look, I'm tired of people arguing just for the pleasure of contradicting others and pretending what I mean.This guy in this thread just asked information can be entered in English or French in my case. Whatdo I need to do so that accents and whatnot are stored and displayed correctly?And my answer was Nothing special.Since 1995 I've been developing pages in French using Access 97 database and CF 1.1, none of them supported Unicode; like everybody else I was using the ISO standard (8859-1) which is the standard default character set used by all browsers anyway and I never had any problem. Just for your information ISO is ALSO an international standard, and it existed far before Unicode.Unicode (or UTF-8 or UTF-64!) is a very powerful tool, if one wants to use it for French or even for English, he is free to do so, but to the question what do I need, I'm sorry, I do not answer You need to go Unicode.If the guy asked what do I need for Chinese I would definitely have said you should go Unicode*, but it was not the case.* I know there are other codes for Chinese, so gimme a break! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MX Standard or Enterprise?
If you're using MSSQL then I'd suggest enterprise, unless you're comfortableinstalling the MSSQL JDBC drivers yourself and setting them up as an Otherdata source.Try downloading the trial and seeing if you can install theJDBC driver and connect using an Other data source.If you can, then you'refine with Standard (as far as this issue goes).If not, go Enterprise.If you have any interest in Java, then I'd strongly suggest enterprise--it'sjust more forward looking.The multiple instances and integrated JRuninstallation is great.My $0.02.Sam--Blog:http://www.rewindlife.comChart: http://www.blinex.com/products/charting---Original Message-From: Phillip B [mailto:[EMAIL PROTECTED]Sent: Friday, September 26, 2003 11:03 AMTo: CF-TalkSubject: MX Standard or Enterprise?I'musing CF 5 Enterprise right now and want to upgrade to MX. I lookedthrough Macromedia's website, reading the FAQ's, watching the flashpresentations, and looking at comparisons charts. It looks like all I needis the standard edition but I don't want to get it and realize I should havegrabbed the Enterprise version instead.I would like the option to use the java features of Enterprise. I have yetto find a problem with the current cfmail with the exception of zero bytefiles. I don't need load balancing or clustering. I'm not sure what serverlogs are not included with standard but I would like to see what the heck isgoing on. Is the system monitoring just a little nicer then the CF 5version? I only use access and sql 2000 data sources and the occasional textfile. (Dont ask)So, after this long ramble, does the standard version look like the rightversion? I can get the Enterprise but I would hate to spend the money without good reason.Phillip B. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: JDBC, Oracle, and CFMX 6.1 J2EE
We are migrating from CF5 to CFMX 6.1 J2EE on Windows 2000 AdvancedServer. We have Oracle 8 data sources. What's everyone's experience with JDBC drivers for Oracle? Go with the ones supplied with CFMX? Use Oracle's?It depends? Warnings, comments, suggestions? Thanks!Not sure if what follows is of any use to you or not as you're usingJ2EE, but fwiwI installed the 6.1 update on a Windows XP development box that wasrunning CF Developer Edition. It queries our Oracle 9.1 database via anODBC socket (I don't use native drivers as the production server is onlyrunning Professional, so wanted the same setup locally as is on theproduction server).Having installed the update, I found that queries that retrieve severalfields, one of which is a long, throw the following error 50% of thetime when they're run:Error Executing Database Query.[Macromedia][SequeLink JDBC Driver]Network problem, session aborted dueto internal error in remote procedure call, connection closed. If you paste the same SQL into another SQL client, it retrieves the datafine. And I'm pretty sure it's not due to wobbly data because the exactsame error is thrown on two different queries on two different tables,both of which contain a long.I thought I'd found a workaround by checking the Force Retrieval ofLongs box in the ODBC settings, but it doesn't seem to work past areboot. The only other workaround I've found is to retrieve the long ina separate query.Oh, and it was working find with 6.0 Updater 3 on the dev box, too,prior to the CFMX6.1 update.Annoying, but, hey-- Aidan Whitehall mailto:[EMAIL PROTECTED]Macromedia ColdFusion DeveloperFairbanks Environmental Ltd+44 (0)1695 51775Queen's Awards Winner 2003 http://www.fairbanks.co.uk/go/awards [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Multilingual site?
Not that I am an expert on any of this, but can you really go to unicode.org an expect any acronym with a U in it not to mean Unicode?Reading rfc2044 at ietf.org, I get..this has led to the development of a few so-called UCS transformation formats (UTF), ..,UTF-8 was originally a project of the X/Open JointInternationalization Group XOJIG with the objective to specify a FileSystem Safe UCS Transformation Format [FSS-UTF] that is compatiblewith UNIX systems...So Andre may still be correct.Jerry Johnson [EMAIL PROTECTED] 09/26/03 11:11AM Doh! Hoping no one would be as anal as me and actually check that out*ohwell. I did try (secretly trying to prolong this exciting debate) Interesting how an abbreviation can mean two things, not ambiguous atall. Andr -Original Message-From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: 26 September 2003 16:06To: CF-TalkSubject: Re: Multilingual site? Erm,just to be anal and incite multiple flames (I've learnt this technique from others on the list).I believe UTF actually stands for UCS transformation format rather than the more popularinterpretation of Unicode Transformation Format :-)no thats not quite correct. its unicode OR ucs. theUTF-8 definitionactually states Unicode (or UCS) Transformation Format, 8-bit encodingform. UTF-8 is the Unicode Transformation Format that serializes aUnicodescalar value (code point) as a sequence of one to four bytes, asspecifiedin...http://www.unicode.org/glossary/ nice try though._[Todays [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Multilingual site?
Claude Schneegans wrote: You mean that you don't consider RFC's, W3C standards and IETF Now look, I'm tired of people arguing just for the pleasure of contradicting others and pretending what I mean.I am not arguing for the pleasure of contradicing. I am just of the opinion that just because LatinX has the required characters too, that doesn't make it the best solution. And the underlying reason for that is that none of the LatinX charsets are future proof.We have seen it with Latin1, in order to add the euro a new charset had to be defined, because Latin1 was full. What happens to LatinX if for some reason it becomes necessary to add another character? What happens to unicode in that scenario?The whole world is converging on Unicode. Unicode support in new internet protocols is a requirement. UTF-8/16 is the default for charsets in XHTML. Unicode should be the default choice for anything, and I haven't seen any specific resons not to use it even if your website currently only caters to French and English visitors.Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How to convert an object to a string (XML)
That doesn't seem to work.It is printing out as either blank ornull.Its because you (i) have enabled Resource or Sandbox security and (ii)you haven't yet installed the 6.1 update.http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=143threadid=461867highlight_key=ykeyword1=tostringThe Crimson-based XmlToString function is a nice workaround (couldn'tget the other one to work).-- Aidan Whitehall mailto:[EMAIL PROTECTED]Macromedia ColdFusion DeveloperFairbanks Environmental Ltd+44 (0)1695 51775Queen's Awards Winner 2003 http://www.fairbanks.co.uk/go/awards [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Multilingual site?
Not that I am an expert on any of this, but can you really go tounicode.org an expect any acronym with a U in it not to mean Unicode?well they actually acknowledge UCS in the OR bit. they also have UCS-2, etcdefined in their glossary and they have synched up to ISO 10646, etc.--sothey aren't that one-sided. but since the unicode consortium is doing mostof the work these days (or did, the commercial driving force behind it looksto be satisified with the encoding as is and may actually peter out) iguess i'll take their definition. Reading rfc2044 at ietf.org, I get...UTF-8, a transformation format of Unicode and ISO 10646 So Andre may still be correct.hard to say. for me its still unicode as the char codes represented in thattransform is unicode. its not used by anything else, etc. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX6.1 admin left menu does not load then CF hangs
Just a week ago I started seeing one of my production servers startacting strange when I went into the cfadmin to change a setting.When Ilogged in the main body frame loaded but the left nav menu did not load.I found that if I hit reload several times CFMX no longer responded andI needed to reset the service. Currently I am logging into the cfadmin on another box and copy - pastethe page I am trying to get to into the URL line. Has anyone seen this?Or know of a fix? Thanks Mark W. Breneman-Cold Fusion Developer-Network AdministratorVivid Media[EMAIL PROTECTED]www.vividmedia.com608.270.9770 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Multilingual site?
but i don't recall lousy unicode font rendering was one of them.See: http://www.contentbox.com/claude/netscapeUnicode.gifThe font is MS Arial Unicode.When you scroll down, the bottom of the window gets garbadge, when you scroll up it the topsorry but the subject is multilingual site? and unicode is still the bestchoice for that typeNot my fault is the subject is more general than the question inside. I answer to the questions, not just the subjects. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Multilingual site?
Hoping no one would be as anal as me and actually check that out.oh well. I did try (secretly trying to prolong this exciting debate)well, unicode is an important issue to me, has been since cf4.5. i won'tnormally let stuff that seems contrary ormis-informed float by. i have allthese bookmarked because my brain is so old i can't recall anything. Interesting how an abbreviation can mean two things, not ambiguous at all.i believe jochem might say thats why we need standards ;-) i would guessthat since this has been around the block a few times, the meaning's changedslightly maybe due to popular use they just wanted to hang a tag on theold stuff. i guess i could ask. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Multilingual site?
Yes, although originally the U in UTF stood for UCS, it seems that overtime there has been some kind of revisionism leaning towards Unicode probably to avoid confusion and more specifically to prevent these kindsof discussions turning up on mailing lists ;) Ive now managed to successfully bore my self to sleep with thisriveting subject matter. Just enough energy left to sign off Andr -Original Message-From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: 26 September 2003 17:07To: CF-TalkSubject: Re: Multilingual site? Not that I am an expert on any of this, but can you really go tounicode.org an expect any acronym with a U in it not to mean Unicode?well they actually acknowledge UCS in the OR bit. they also have UCS-2,etcdefined in their glossary and they have synched up to ISO 10646,etc.--sothey aren't that one-sided. but since the unicode consortium is doingmostof the work these days (or did, the commercial driving force behind itlooksto be satisified with the encoding as is and may actually peter out) iguess i'll take their definition. Reading rfc2044 at ietf.org, I get...UTF-8, a transformation format of Unicode and ISO 10646 So Andre may still be correct.hard to say. for me its still unicode as the char codes represented inthattransform is unicode. its not used by anything else, etc._[Todays [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX6.1 admin left menu does not load then CF hangs
What are the pertinent specs on the box? Also, are you trying to hit the admin through SSL (https://)? I've hadsimilar problems with 6.1 when using a SSL connection. -Original Message-From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Friday, September 26, 2003 10:58 AMTo: CF-TalkSubject: CFMX6.1 admin left menu does not load then CF hangsJust a week ago I started seeing one of my production servers startacting strange when I went into the cfadmin to change a setting.When Ilogged in the main body frame loaded but the left nav menu did not load.I found that if I hit reload several times CFMX no longer responded andI needed to reset the service. Currently I am logging into the cfadmin on another box and copy - pastethe page I am trying to get to into the URL line.Has anyone seen this?Or know of a fix?Thanks Mark W. Breneman-Cold Fusion Developer-Network AdministratorVivid Media[EMAIL PROTECTED]www.vividmedia.com608.270.9770_ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX6.1 admin left menu does not load then CF hangs
If ur accessing under SSL there's a hot fix for CF that addressesthis...there's a static cfhttp call in the menu that uses http. Stace _From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: September 26, 2003 11:58 AMTo: CF-TalkSubject: CFMX6.1 admin left menu does not load then CF hangs Just a week ago I started seeing one of my production servers startacting strange when I went into the cfadmin to change a setting.When Ilogged in the main body frame loaded but the left nav menu did not load.I found that if I hit reload several times CFMX no longer responded andI needed to reset the service. Currently I am logging into the cfadmin on another box and copy - pastethe page I am trying to get to into the URL line.Has anyone seen this?Or know of a fix?Thanks Mark W. Breneman-Cold Fusion Developer-Network AdministratorVivid Media[EMAIL PROTECTED]www.vividmedia.com608.270.9770_ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMX6.1 admin left menu does not load then CF hangs
Mark,On 9/26/2003 at 11:57, you wrote:MWB Just a week ago I started seeing one of my production servers startMWB acting strange when I went into the cfadmin to change a setting.When IMWB logged in the main body frame loaded but the left nav menu did not load.MWB I found that if I hit reload several times CFMX no longer responded andMWB I needed to reset the service.I had this happen, but just after upgrading to 6.1 from 6.0 on Linux(RH 7.3 / Apache 1.3.x). I recall reading that the location ofexisting (pre-upgrade to 6.1) Administrator modules and/or class fileshad something to do with it, but I could not find any solutions downthat path.Rebuilding the server (RH 8 / Apache 2.0.47) made the problem go away!~ Ubqtous ~ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Parsing hyperlinks and name
I had to do this just recently.a href="">\1 will be the href, and \2 will be the text between the tags.This will work across linebreaks, if the regex engine does multiple lines.I have no clue how CF handles backreferences, or multiple linesthough.-- jon mailto:[EMAIL PROTECTED]Friday, September 26, 2003, 10:28:27 AM, you wrote:KP Hi All,KP I have to parse some complex links likeKP a href="" class=link_orange >KP >KP g name=lpg2 src="" alt=Link PopularityKP Gauge border=0 width=63/aKP orKP a href="" class=link_whiteClick here to findKP out/aKP I need a CFSCRIPT to do that. I was successfully able to get the link usingKP beow patedcfscsipt. But Also I need is if it is a image linkthen itKP should say Image Link - No Text else get the text means name of the link.KP cfscriptKP function GetAnchor(str) {KPvar output = ArrayNew(1);KPvar i=1;KPvar start = 1;KPvar matchStruct =;KPwhile(1 eq 1){KP reFindNoCase([[:space:]]*a[[:space:]]*[^]*href[[:space:]]*=[[:space:]]*KP ([^]*),str,start,1);KPif(arrayLen(matchStruct.len) lt 2) { return output; }KPoutput[i] = Mid(str,matchStruct.pos[2],matchStruct.len[2]);KPstart = matchStruct.pos[2];KPi = i + 1;KP}KP }KP /cfscriptKP Any help is appreciated. Thanks in advance.KP Ketan PatelKP G3 Technology Group, LLCKP Graphics III Advertising, Inc.KP (410)789-7007 or (800)783-1799KP It's Not Creative if it doesn't Sell.KP http://www.g3group.com http://www.g3group.comKP
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Multilingual site?
UTF-8 is the Unicode Transformation FormatThis only means that UTF8 is the encoding scheme that is (more or less officially) used for Unicode.But at the origin it was designed to represent UCS and ISO 10646.See UTF-8, a transformation format of ISO 10646 athttp://www.faqs.org/rfcs/rfc2279.htmlUnicode is a layer over ISO 10646 since it also defined algorithms like bidirectional writing, line breaking, etc.Just like ASCII (American Standard Code for Information Interchange) is used to interchange information with non American people ;-)) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Multilingual site?
i have all these bookmarked because my brain is so old i can't recall anything.Just in case you missed this one:http://www.faqs.org/rfcs/rfc2279.html [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Multilingual site?
hard to say.RFC 2279 saysISO/IEC 10646-1 defines a multi-octet character set called theUniversal Character Set (UCS) which encompasses most of the world'swriting systems. Multi-octet characters, however, are not compatiblewith many current applications and protocols, and this has led to thedevelopment of a few so-called UCS transformation formats (UTF),So clearly UCS stands for Universal Character Set and UTF for UCS transformation formats (or probably also Universal transformation formats)The fact that Unicode and ISO/IEC 10646 use the same character codes is making the whole thing a bit fuzzy. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: convert string of numbers to numeric?
val(form.var1) * 1 ?This won't work, the problem is with form.var1 geing an empty string, which val() doesn't take. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: convert string of numbers to numeric?
can you send the whole bit of code?Well, i don't where is the rest of the code, I just answered the problem The value cannot be converted to a number.Adding 0 at the begining of the string will assure that the string is always transformable to a number through the val() function.Then if you are in a query,UPDATE myTable SET whatever = #val (0 form.var1)# [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMX6.1 admin left menu does not load then CF hangs
Just a week ago I started seeing one of my production servers startacting strange when I went into the cfadmin to change a setting.When Ilogged in the main body frame loaded but the left nav menu did not load.I found that if I hit reload several times CFMX no longer responded andI needed to reset the service.Perhaps this is your issue:http://www.macromedia.com/support/coldfusion/ts/documents/navserver_blank.htmRegards,Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Using User Names and Password security with Access Databases
Does anyone out there who uses Access database use User name/PasswordSecurity?I have done this as an extra way to secure the information in thedatabase and this appears to be causing hosting firms difficulties.If itprovides minimal value, I may be better off removing this security.Andy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Blank Message entries in application.log
My application logs are starting to be riddled with missing Message entriesfor severities labeled Information.Below is an example of an applicationlog that I rotate for analysis:Severity,ThreadID,Date,Time,Application,MessageInformation,,09/26/03,11:24:05,,d:\logfiles\application.loginitializedInformation,1508,09/26/03,11:24:05,,Information,1076,09/26/03,11:27:13,,Information,1076,09/26/03,11:43:58,,Information,1736,09/26/03,11:45:24,,Information,2800,09/26/03,11:46:49,,Information,764,09/26/03,11:51:17,,Information,764,09/26/03,11:56:57,,I've been told that this may coincide with a CF restart, but when I checkthe Event Viewer, no such animal can be found.Please advise with anyreferences to previous posts or links where I can read up on this. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Using User Names and Password security with Access Databases
What kind of problems are they having? I've never run into any issues. Acustomer forgetting to tell me the DB is protected is the only troubleI've had with them over the years. Dan Phillipswww.CFXHosting.com1-866-239-4678[EMAIL PROTECTED] -Original Message-From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Friday, September 26, 2003 12:39 PMTo: CF-TalkSubject: Using User Names and Password security with Access DatabasesDoes anyone out there who uses Access database use User name/PasswordSecurity?I have done this as an extra way to secure the information inthedatabase and this appears to be causing hosting firms difficulties.Ifitprovides minimal value, I may be better off removing this security.Andy_ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT : SQL List Comparison
compare two lists in SQLIn SQL... or CFML?There are tags in the tag gallery for list union, intersection etc, but they cannot be used in queries of course. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: convert string of numbers to numeric?
I set the default value=0.In the database?The default valu in a database is returned when the field is null.But as soon as you insert or update a value with something, it's got to be a valid value or spcecifically null.An empty string is not a valid value. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
action pages not passing along info
I'm having a problem with an action page that is notpassing along an id number as part of a URL. Theapplication is supposed to allow a user to add a newrecord to a personnel table and then either stop thereor click a link to go to another page to add a recordinto a vehicle table for the person who was added tothe personnel table.The database is Access 2000. Theadd-a-user part works, but it sends empty spaceinstead of the ID autonumber created for the newpersonnel record to the add-a-vehicle page so thatit can be put into a new vehicle record, see below:http://localhost:8500/InfoCenter/Parking/addpermitv_test.cfm?PersonnelKey=where I am expecting http://localhost:8500/InfoCenter/Parking/addpermitv_test.cfm?PersonnelKey=21486Here is the pertinent code:cfset NewID = cfset PersonnelKey = cfquery name=GetNewID datasource=CMISPersonnelSelect Max(PersonnelKey) as NewID from Personnel/cfquerycfset PersonnelKey eq #GetNewID.NewID#cfoutputp#Form.FirstName# #Form.LastName# has been added tothe personnel database./pClick the Add Permit link to add permit informationfor this person.brOr make another selection from the menu.pahref="">Permit for #Form.FirstName# #Form.LastName#/a/cfoutputThat's problem #1. Problem #2 is a little strange; theerror message claims that a commented-out line iscausing the problem. Originally, I was getting anerror message about a syntax error in my INSERT INTOSQL statement. When I commented out the named field tosee if I could isolate the error, the new errormessage referenced the commented line, as below. [MERANT][SequeLink JDBC Driver][ODBCSocket][Microsoft][ODBC Microsoft Access Driver]Syntax error in INSERT INTO statement.The Error Occurred inD:\CFusionMX\wwwroot\InfoCenter\Parking\addpermitv_action_test.cfm:line 25 23 : !-- Temporarily commentedout '#FORM.CarValidateContentFlag#') --24 : 25 : /cfquery26 : cfoutput27 : The new permit information has been submitted.Please make another selection SQL INSERT INTO Vehicles(PersonnelKey, Year, Make,Model, Color, TagNumber, TagState, DecalNumber,DecalColor, DecalExpiration, InsuranceCompany,PolicyNumber, InsuranceExpirationDate, PermitNumber,IssuedBy, IssueDate, ExpirationDate) VALUES('URL.PersonnelKey', '1982', 'Chrome Wheeled','Fuel Injected', 'Black', '174CZP', 'AL', '47','white', '70303', 'State Farm', '42787', '123004','477', 'ted', '111202', '111204')The first value to be inserted is supposed to be theid number passed along from the previous page -- whichat this point is NOT getting passed along -- whichmakes me wonder if these two issues are connected.Here is the full code for the page giving this errormessage:!-- Initialize variable --CFPARAM NAME=FORM.CarValidateContentFlagDEFAULT=0htmlheadtitleAdd Permit Action Form/titlemeta http-equiv=Content-Type content=text/html;charset=iso-8859-1/headbody bgcolor=#FF pfont face=Arial, Helvetica, sans-serifsize=+2Add Permit Action Form/font /pcfquery name=AddVehicledatasource=CMISPersonnel INSERT INTO Vehicles(PersonnelKey, Year, Make, Model,Color, TagNumber, TagState, DODDecalNumber, DODDecalColor, DODDecalExpiration,InsuranceCompany, PolicyNumber, InsuranceExpirationDate, PermitNumber, IssuedBy,IssueDate, ExpirationDate) !-- temporarily commented outValidateContentFlag) -- VALUES('#PersonnelKey#', '#Trim(FORM.Year)#','#Trim(FORM.Make)#', '#Trim(FORM.Model)#', '#Trim(FORM.Color)#', '#Trim(FORM.TagNumber)#','#Trim(FORM.TagState)#', '#Trim(FORM.DODDecalNumber)#','#Trim(FORM.DODDecalColor)#','#Trim(FORM.DODDecalExpiration)#', '#Trim(FORM.InsuranceCompany)#','#Trim(FORM.PolicyNumber)#','#Trim(FORM.InsuranceExpirationDate)#', '#Trim(FORM.PermitNumber)#','#Trim(FORM.IssuedBy)#', '#Trim(FORM.IssuedDate)#','#Trim(FORM.ExpirationDate)#') !-- Temporarily commented out '#FORM.CarValidateContentFlag#') -- /cfquerycfoutputThe new permit information has been submitted. Pleasemake another selectionfrom the menu to continue. /cfoutput /body/htmlCan anyone help me figure this out? Thanks.LauraLaura SchleeDML Associatescell 703-622-0363ofc202-685-1360 __Do you Yahoo!?The New Yahoo! Shopping - with improved product searchhttp://shopping.yahoo.com
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Using User Names and Password security with Access Databases
I did have to use ODBC socket and not Microsoft Accesswhen setting up a password-protected Access datasourcein CF Administrator. I found this out the hard way. Sothe setup does demand a bit of finesse.LauraLaura SchleeDML Associatescell 703-622-0363ofc202-685-1360--- Andy Ousterhout [EMAIL PROTECTED] wrote: Does anyone out there who uses Access database use User name/Password Security?I have done this as an extra way to secure the information in the database and this appears to be causing hosting firms difficulties.If it provides minimal value, I may be better off removing this security. Andy __Do you Yahoo!?The New Yahoo! Shopping - with improved product searchhttp://shopping.yahoo.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: convert string of numbers to numeric?
in the cfinput tag.- Original Message - From: Claude Schneegans To: CF-Talk Sent: Friday, September 26, 2003 12:45 PMSubject: Re: convert string of numbers to numeric?I set the default value=0.In the database?The default valu in a database is returned when the field is null.But as soon as you insert or update a value with something, it's got to be a valid value or spcecifically null.An empty string is not a valid value. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Passing XML to CF via HTTP Post
Now I am doing this with curl, and I am seeing errors in CF's application log: Expecting quoted value for attribute value version... I launch curl like this - curl -d id=?xml version=1.0 encoding=UTF-8?RECORDSR CODE=80492301 NUMB=1 TYPE=0//records localhost/index.cfm CF is 6.1 Standard However, if I pass just the file name containing the XML to CF and do XmlParse based on the variable created with CFFILE reading file name, everything is fine. I do need to get it working via the POST method though.Aren't you missing the opening bracket?id=?xml... should be id=?xml..., I think.Dave Watts, CTO, Fig Leaf Softwarehttp://www.figleaf.com/voice: (202) 797-5496fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: 6.1 RDS
I solved this issue ... thanks to MM support finally answering my questionin the forum.They asked me for more details, such as whether I had CFMX6.1 installed in standalone mode on port 8500 ...Doh!I changed the properties in my RDS setting for local host to point to port8500 and I'm in.H.~~Howard OwensInternet Operations CoordinatorVentura County Star / E.W. Scripps Co.www.venturacountystar.com[EMAIL PROTECTED]AIM: GoCatGo1956~~ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
