locale settings on w2k

Hi all, This has happened to me a couple of times, and I'm sure it is due to the locale settings in w2k server, but my host is telling me that the locales are set correctly to the uk. When I use LSCurrencyFormat it is decimal formatting numbers but adding a $ dollar sign, not a £ pound sign.

Re: locale settings on w2k

When I use LSCurrencyFormat it is decimal formatting numbers but adding a $ dollar sign, not a £ pound sign. you control cf's locale via the SetLocale function. unfortunately, what you're seeing looks like a bug. there appears to be several in cf's international functions

Test - 0 messages

Is this list working? Scott Mulholland Systems Programmer Exario Networks http://www.exario.net http://www.exario.net/ http://www.exario.net/ 888.2.EXARIO [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ~~ Structure your ColdFusion code with

quick count

How can I do a quick count within a certain column of a certain text that it contains? For instance I have a column called AST which may either be empty or contain text such as AST. I would like to get a count of the occurrences of the AST text and display a number of the occurrences. I tried

ArraySort()

I am having problems with ArraySort() function. Has a 2 dimensional array with one column having text and the other having integers. Here is what I am doing: cfscript ArraySort(PartnerArray, text); /cfscript And it gives me this error: The expression has requested a variable or an

RE: quick count

You probably would need to do a query as such: CFQUERY NAME=getASTCount DATASOURCE=#DSN# SELECT * FROM tableName WHERE AST CONTAINS AST /CFQUERY CFOUTPUT #getASTCount.RecordCount# /CFOUTPUT -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED]] Sent:

RE: quick count

If you are doing this exactally as you've coded, then you should use getcount.recordcount to display the number of records returned. Alternately, you could do it within your database by running cfquery name=getcount datasource=wweb SELECT COUNT(AST) AS AST_Count FROM wweb Where AST = 'AST'

Test

I haven't gotten anything since Friday. Russel ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe:

help using sql sum function

Hello cf-talk, Why the heck is this throwing an error? Expression result cannot be converted to a string cfquery name=exlunch datasource=#application.dsn# dbtype=ODBC SELECT SUM(racedaylunch) FROM thelist /cfquery cfoutput#exlunch#/cfoutput Best regards, Jeff Fongemie

test ignore

test Chris -- Chris Lomvardias [EMAIL PROTECTED] Syscom, Inc. 400 E. Pratt Street, Suite 300 Baltimore, MD 21202 (410)539-3737 x1722 voice (410)539-7302 fax [EMAIL PROTECTED] (pager via email) http://www.syscom.com/

Re: test ignore

What's the difference between a test ignore and a real ignore??? 8-) Dave - Original Message - From: Lomvardias, Christopher [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 25, 2001 12:03 PM Subject: test ignore test Chris

Re: help using sql sum function

You need to alias the result of the aggregate function. cfquery name=exlunch datasource=#application.dsn# dbtype=ODBC SELECT SUM(racedaylunch) as LunchSum FROM thelist /cfquery cfoutput#LunchSum#/cfoutput - Original Message - From: Jeff Fongemie [EMAIL PROTECTED] To:

Testing: Is this thing on

Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives:

Re: Testing: Is this thing on

yes, but if others want to 'shout out', I've got no problems. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire ~~ Structure your ColdFusion code with Fusebox. Get the official book at

Chat Room

Can anyone recommend an inexpensive chat room to run on IIS and CF 4.5? It is for a non-profit site that we are doing as a donation. If you have an application you wrote and would like to donate it let me know. I will ensure you get recognition for it. Steven A. del Sol NETPACQ Systems,

Is this list screwed up again?

I haven´t received but about 150 msgs in the last 10 days, versus 100+ msgs per day up to 15 June. A couple of other CF Talk members have contacted me directly, saying they weren´t getting msgs either. What´s up? 10 days? Len ~~ Structure

Re: Is this list screwed up again?

1. the old box had dead drives so we had to move over 2. bad DNS on the new box (it should be 207.31.122.190) 3. a 'feature' of post.office that says that a message can not be sent to someone who has mail in the deferred directory. As there are over 2k people of this sort with hundreds of

Dropping Null fields from a Query

I am populating a drop down menu with a query from a database: select name=Color1 option value= cfoutput query=select option value=#select.Color1# #select.Color1# /cfoutput /select Inside of the database there are NULL or blank entries. So when i get the drop

RE: Dropping Null fields from a Query

select name=Color1 option value= cfoutput query=select cfif select.color NEQ option value=#select.Color1# #select.Color1# CFELSE /CFIF /cfoutput /select HTH, Jeff Garza Lead Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL

RE: Dropping Null fields from a Query

Oh.. duh... i need more coffee. Thanks for the help At 10:07 AM 6/25/2001 -0700, you wrote: select name=Color1 option value= cfoutput query=select cfif select.color NEQ option value=#select.Color1# #select.Color1# CFELSE /CFIF

SQL2000 Move data

I need to move an entire data base from one SQL Server to anouther with ftp or zipdisk/cdrom. How is this done Thanks Mike ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm

Re: Dropping Null fields from a Query

You can ignore the rows with NULL or blank values from your query recordset. . WHERE Color1 IS NOT NULL AND Color1 '' If you need the records with NULL or blank values for some other purposes on the same page, you could use the SQL function ISNULL to substitues NULLs with other values,

Re: test ignore

No one can hear you with a real one. :) What's the difference between a test ignore and a real ignore??? 8-) Dave - Original Message - From: Lomvardias, Christopher [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 25, 2001 12:03 PM Subject: test ignore test

Re: CF-Talk-list V1 #38

This is the one of the few CF-Talks that I have seen lately. I suspect that MD has some serious DNS problems. I know my mailservers have been up all of the time, yet I am not received (for the most part) any cf-talk messages. Steve At 08:55 AM 6/22/2001 +1200, Cameron wrote: Hmmm, is something

running RDS service as non-system account (forgot to say...)

I'm running CF Pro, not Enterprise so don't have the Advanced Security options in the administrator, though I've just seen a comparison matrix at: http://www.macromedia.com/software/coldfusion/productinfo/matrix/cf5_matrix.pdf which lists cf4.5 pro as having the advanced security options -

Fusebox list

Could anybody pleas post the information on where the Fusebox list moved. House of Fusion still lists it as [EMAIL PROTECTED], but it's been dead for a while. Thank you. ~~ Structure your ColdFusion code with Fusebox. Get the official book at

RE: DHTML - HierMenus

Hi, Has anyone incorporated the DHTML HeirMenus on their site but as a horizontal menu and sub-menus from the main? All the examples I see are like: [Menu 1] - [Sub-heading 1] [Sub-heading 2] [Sub-heading 3]

RE: DHTML - HierMenus

Take a look at http://www.get1used.com and see if that is what you mean. If it is, then Yes, I have. Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, June

RE: SQL2000 Move data

The simplest way would be to use the import or export features of SQL server to connect the two servers together and transfer the database. Although, if that's not an option, you could also try backing up the SQL database and restoring it on the other server or you can export the SQL database to

what's going on?

Is it just me or something is wrong with this list? I haven't received posts for several days. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives:

RE: Fusebox list

[EMAIL PROTECTED] -Original Message- From: stas [mailto:[EMAIL PROTECTED]] Sent: Monday, June 25, 2001 2:41 PM To: CF-Talk Subject: Fusebox list Could anybody pleas post the information on where the Fusebox list moved. House of Fusion still lists it as [EMAIL PROTECTED], but

RE: Detecting if Browser has Cookies Enabled

I put this in the Application.cfm page: !--- Determine if Cookies are enabled --- cfif IsDefined(Cookie.cookieenabled) cfset TokenOn=No cfelse cfcookie name=cookieenabled value=test expires=30 cfset TokenOn=Yes /cfif !--- Now set a global urltoken to use throughout the

RE: URL Hacks

It is good to bring this subject up every now and then especially since we get too focused on making the application work, we often forget to check out ways make it break. Allaire has some knowledgebase articles about this that may be helpful:

test

Test message Michael Wilson - CTO/Secretary http://www.xionmedia.com Xion Media, Inc. Web Development P: 704-398-2454 F: 704-398-2063 In the middle of

CF Query to XML

Is there a custom tag that will take the result set of a query and write it to an XML file? thanks Jay ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives:

RE: CF Query to XML

Converting it to a string using CFWDDX and then writing it to a text file will achieve basically that... Or were you after something more sophisticated? -Original Message- From: Jay E Wigginton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 26 June 2001 3:27 PM To: CF-Talk Subject: CF Query