Blue dragon installation issues
Hello After all the talk of BD in recent days I downloaded the free J2EE version and installed in on my mac, as a web app in Jrun4. Things seemed ok, the test cfml and jsp pages ran fine, but I cant access the admin panel. All attempts to access it return a white page.. Occasionally (after lots of refresh pressing) I get an alert saying Developers License for BlueDragon... Seems a bit strange that cfml pages process but the admin doesn¹t... Incidentally I can't find the admin.cfm page, but its not returning an error not found either... TIA, Ryan ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: SQL problem
Hi, Anyone with some time for a little SQL question? I want to have a SELECT that gives me the highest values in a table The table looks like this: CountryName, Value, Year And the data something like: Sweden, 80, 1970 Sweden, 20, 1999 Denmark, 10, 1962 Denmark, 15, 1992 (etc) What I want to get from the query is the rows: Sweden, 20, 1999 Denmark, 15, 1992 Anyone? - Hugo Ahlenius E-Mail: [EMAIL PROTECTED] Project OfficerPhone:+46 8 230460 UNEP GRID-Arendal Fax: +46 8 230441 Stockholm Office Mobile: +46 733 467111 WWW: http://www.grida.no - ### This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange. For more information, connect to http://www.F-Secure.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: SQL problem
Typically it would be something like this: SELECT countryname, max(value), year FROM mytable GROUP BY countryname, year ORDER BY countryname, year hth Hi, Anyone with some time for a little SQL question? I want to have a SELECT that gives me the highest values in a table The table looks like this: CountryName, Value, Year And the data something like: Sweden, 80, 1970 Sweden, 20, 1999 Denmark, 10, 1962 Denmark, 15, 1992 (etc) What I want to get from the query is the rows: Sweden, 20, 1999 Denmark, 15, 1992 Anyone? -- --- Hugo Ahlenius E-Mail: [EMAIL PROTECTED] Project OfficerPhone:+46 8 230460 UNEP GRID-Arendal Fax: +46 8 230441 Stockholm Office Mobile: +46 733 467111 WWW: http://www.grida.no -- --- ### This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange. For more information, connect to http://www.F-Secure.com/ ~~ ~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index. cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/uns ubscribe.cfm?user=633.558.4 s. isaac dealey972-490-6624 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL problem
cfquery name=myQuery SELECT * FROM TABLE ORDER BY year DESC /cfquery cfoutput query=myQuery #CountryName#, #Value#, #Year#br /cfoutput regards badal Tyagi HCL Perot Systems Noida, India -Original Message- From: Hugo Ahlenius [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 2:19 PM To: CF-Talk Subject: OT: SQL problem Hi, Anyone with some time for a little SQL question? I want to have a SELECT that gives me the highest values in a table The table looks like this: CountryName, Value, Year And the data something like: Sweden, 80, 1970 Sweden, 20, 1999 Denmark, 10, 1962 Denmark, 15, 1992 (etc) What I want to get from the query is the rows: Sweden, 20, 1999 Denmark, 15, 1992 Anyone? - Hugo Ahlenius E-Mail: [EMAIL PROTECTED] Project OfficerPhone:+46 8 230460 UNEP GRID-Arendal Fax: +46 8 230441 Stockholm Office Mobile: +46 733 467111 WWW: http://www.grida.no - ### This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange. For more information, connect to http://www.F-Secure.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: SQL problem
Thanks, But it was actually the latest values I was interested in. I solved it on my own, with doing a subquery locating the latest years for each countries, and then joining that to the main table. Something like: SELECT * FROM myTable INNER JOIN ( SELECT countryName, Max(Year) as MaxYear FROM mytable) joinTable ON myTable.countryName=joinTable.countryName AND myTable.Year=joinTable.MaxYear From that query, I would only get the latest available values for each country. - Hugo Ahlenius E-Mail: [EMAIL PROTECTED] Project OfficerPhone:+46 8 230460 UNEP GRID-Arendal Fax: +46 8 230441 Stockholm Office Mobile: +46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] | Sent: Tuesday, June 17, 2003 10:54 | To: CF-Talk | Subject: Re: OT: SQL problem | | | Typically it would be something like this: | | SELECT countryname, max(value), year | FROM mytable | GROUP BY countryname, year | ORDER BY countryname, year | | hth | | Hi, | | Anyone with some time for a little SQL question? | | I want to have a SELECT that gives me the highest values | in a table | | The table looks like this: | CountryName, Value, Year | | And the data something like: | Sweden, 80, 1970 | Sweden, 20, 1999 | Denmark, 10, 1962 | Denmark, 15, 1992 | | (etc) | | What I want to get from the query is the rows: | Sweden, 20, 1999 | Denmark, 15, 1992 | | Anyone? | | -- | --- | Hugo Ahlenius E-Mail: | [EMAIL PROTECTED] | Project OfficerPhone:+46 8 | 230460 | UNEP GRID-Arendal Fax: +46 8 | 230441 | Stockholm Office Mobile: +46 733 | 467111 | WWW: | http://www.grida.no | -- | --- | | | | | ### | | This message has been scanned by F-Secure Anti-Virus for | Microsoft | Exchange. | For more information, connect to http://www.F-Secure.com/ | | ~~ | ~~~| | Archives: | http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 | Subscription: http://www.houseoffusion.com/cf_lists/index. | cfm?method=subscribeforumid=4 | FAQ: http://www.thenetprofits.co.uk/coldfusion/faq | | Get the mailserver that powers this list at | http://www.coolfusion.com | | Unsubscribe: http://www.houseoffusion.com/cf_lists/uns ubscribe.cfm?user=633.558.4 s. isaac dealey972-490-6624 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: SQL problem
Hugo Ahlenius wrote: I want to have a SELECT that gives me the highest values in a table The table looks like this: CountryName, Value, Year Aren't value and year reserved words in SQL? And the data something like: Sweden, 80, 1970 Sweden, 20, 1999 Denmark, 10, 1962 Denmark, 15, 1992 (etc) What I want to get from the query is the rows: Sweden, 20, 1999 Denmark, 15, 1992 SELECT CountryName, Value, Year FROMtable WHERE (CountryName, Year) IN ( SELECT CountryName, MAX(Year) FROM table GROUP BY CountryName ) Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: SQL problem
Yes year is a function - you can escape them using [value] and [year] -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Tuesday, 17 June 2003 7:04 PM To: CF-Talk Subject: Re: OT: SQL problem Hugo Ahlenius wrote: I want to have a SELECT that gives me the highest values in a table The table looks like this: CountryName, Value, Year Aren't value and year reserved words in SQL? And the data something like: Sweden, 80, 1970 Sweden, 20, 1999 Denmark, 10, 1962 Denmark, 15, 1992 (etc) What I want to get from the query is the rows: Sweden, 20, 1999 Denmark, 15, 1992 SELECT CountryName, Value, Year FROMtable WHERE (CountryName, Year) IN ( SELECT CountryName, MAX(Year) FROM table GROUP BY CountryName ) Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: SQL problem
The columns are (of course) named something else. Perhaps I should have used something else? Jochem, your suggestion looks cleaner than mine, but SQL Server 2k chokes on your (CountryName, Year) in the WHERE clause. I am actually not sure what that does... ? - Hugo Ahlenius E-Mail: [EMAIL PROTECTED] Project OfficerPhone:+46 8 230460 UNEP GRID-Arendal Fax: +46 8 230441 Stockholm Office Mobile: +46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: Jochem van Dieten [mailto:[EMAIL PROTECTED] | Sent: Tuesday, June 17, 2003 11:04 | To: CF-Talk | Subject: Re: OT: SQL problem | | | Hugo Ahlenius wrote: | | I want to have a SELECT that gives me the highest values in a table | | The table looks like this: | CountryName, Value, Year | | Aren't value and year reserved words in SQL? | | | And the data something like: | Sweden, 80, 1970 | Sweden, 20, 1999 | Denmark, 10, 1962 | Denmark, 15, 1992 | | (etc) | | What I want to get from the query is the rows: | Sweden, 20, 1999 | Denmark, 15, 1992 | | SELECTCountryName, Value, Year | FROM table | WHERE | (CountryName, Year) IN ( | SELECT CountryName, MAX(Year) | FROM table | GROUP BY CountryName | ) | | Jochem | | | ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: SQL problem
gotta use the As clause | SELECTCountryName, Value, Year | FROM table | WHERE | (CountryName, Year) IN ( | SELECT CountryName, MAX(Year) As Year | FROM table | GROUP BY CountryName | ) -Original Message- From: Hugo Ahlenius [mailto:[EMAIL PROTECTED] Sent: Tuesday, 17 June 2003 7:11 PM To: CF-Talk Subject: RE: OT: SQL problem The columns are (of course) named something else. Perhaps I should have used something else? Jochem, your suggestion looks cleaner than mine, but SQL Server 2k chokes on your (CountryName, Year) in the WHERE clause. I am actually not sure what that does... ? - Hugo Ahlenius E-Mail: [EMAIL PROTECTED] Project OfficerPhone:+46 8 230460 UNEP GRID-Arendal Fax: +46 8 230441 Stockholm Office Mobile: +46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: Jochem van Dieten [mailto:[EMAIL PROTECTED] | Sent: Tuesday, June 17, 2003 11:04 | To: CF-Talk | Subject: Re: OT: SQL problem | | | Hugo Ahlenius wrote: | | I want to have a SELECT that gives me the highest values in a table | | The table looks like this: | CountryName, Value, Year | | Aren't value and year reserved words in SQL? | | | And the data something like: | Sweden, 80, 1970 | Sweden, 20, 1999 | Denmark, 10, 1962 | Denmark, 15, 1992 | | (etc) | | What I want to get from the query is the rows: | Sweden, 20, 1999 | Denmark, 15, 1992 | | SELECTCountryName, Value, Year | FROM table | WHERE | (CountryName, Year) IN ( | SELECT CountryName, MAX(Year) | FROM table | GROUP BY CountryName | ) | | Jochem | | | ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: SQL problem
Ahh... you didn't say you only wanted the latest year in your first message, so that's what prompted the answer. Thanks, But it was actually the latest values I was interested in. I solved it on my own, with doing a subquery locating the latest years for each countries, and then joining that to the main table. Something like: SELECT * FROM myTable INNER JOIN ( SELECT countryName, Max(Year) as MaxYear FROM mytable) joinTable ON myTable.countryName=joinTable.countryName AND myTable.Year=joinTable.MaxYear From that query, I would only get the latest available values for each country. -- --- Hugo Ahlenius E-Mail: [EMAIL PROTECTED] Project OfficerPhone:+46 8 230460 UNEP GRID-Arendal Fax: +46 8 230441 Stockholm Office Mobile: +46 733 467111 WWW: http://www.grida.no -- --- | -Original Message- | From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] | Sent: Tuesday, June 17, 2003 10:54 | To: CF-Talk | Subject: Re: OT: SQL problem | | | Typically it would be something like this: | | SELECT countryname, max(value), year | FROM mytable | GROUP BY countryname, year | ORDER BY countryname, year | | hth | | Hi, | | Anyone with some time for a little SQL question? | | I want to have a SELECT that gives me the highest values | in a table | | The table looks like this: | CountryName, Value, Year | | And the data something like: | Sweden, 80, 1970 | Sweden, 20, 1999 | Denmark, 10, 1962 | Denmark, 15, 1992 | | (etc) | | What I want to get from the query is the rows: | Sweden, 20, 1999 | Denmark, 15, 1992 | | Anyone? | | -- | --- | Hugo Ahlenius E-Mail: | [EMAIL PROTECTED] | Project OfficerPhone:+46 8 | 230460 | UNEP GRID-Arendal Fax: +46 8 | 230441 | Stockholm Office Mobile: +46 733 | 467111 | WWW: | http://www.grida.no | -- | --- | | | | | ### | | This message has been scanned by F-Secure Anti-Virus for | Microsoft | Exchange. | For more information, connect to http://www.F-Secure.com/ | | ~~ | ~~~| | Archives: | http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 | Subscription: http://www.houseoffusion.com/cf_lists/index. | cfm?method=subscribeforumid=4 | FAQ: http://www.thenetprofits.co.uk/coldfusion/faq | | Get the mailserver that powers this list at | http://www.coolfusion.com | |Unsubscribe: http://www.houseoffusion.com/cf_lists/uns ubscribe.cfm?user=633.558.4 s. isaac dealey972-490-6624 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~~ ~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index. cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/uns ubscribe.cfm?user=633.558.4 s. isaac dealey972-490-6624 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: SQL problem
Hugo Ahlenius wrote: I want to have a SELECT that gives me the highest values in a table The table looks like this: CountryName, Value, Year Aren't value and year reserved words in SQL? I think they're supposed to be. And the data something like: Sweden, 80, 1970 Sweden, 20, 1999 Denmark, 10, 1962 Denmark, 15, 1992 (etc) What I want to get from the query is the rows: Sweden, 20, 1999 Denmark, 15, 1992 SELECTCountryName, Value, Year FROM table WHERE (CountryName, Year) IN ( SELECT CountryName, MAX(Year) FROM table GROUP BY CountryName ) Is that a sql92 standard IN clause?... s. isaac dealey972-490-6624 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: SQL problem
Hugo Ahlenius wrote: The columns are (of course) named something else. Perhaps I should have used something else? Jochem, your suggestion looks cleaner than mine, but SQL Server 2k chokes on your (CountryName, Year) in the WHERE clause. I am actually not sure what that does... ? It is just a normal IN, but with multiple values on each side. If you expand a normal IN predicate, it looks something like: SELECT CountryName, Value, Year FROMtable WHERE (PKey) IN ( (17), (12), (32) ) With multiple values on each side, it looks like: SELECT CountryName, Value, Year FROMtable WHERE (CountryName, Year) IN ( (Sweden, 1999), (Denmark, 1992), (Norway, 1995) ) Maybe you should ask Microsoft to implement this feature (it is part of the SQL standard), but for now just use your own solution. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: SQL problem
S. Isaac Dealey wrote:
SELECTCountryName, Value, Year
FROM table
WHERE
(CountryName, Year) IN (
SELECT CountryName, MAX(Year)
FROM table
GROUP BY CountryName
)
Is that a sql92 standard IN clause?...
I guess I had that comming :-)
I don't know. It is however a SQL:1999 standard IN predicate:
quote
8.4 in predicate
Function
Specify a quantified comparison.
Format
in predicate ::=
row value expression
[ NOT ] IN in predicate value
in predicate value ::=
table subquery
| left paren in value list right paren
in value list ::=
row value expression { comma row value expression }...
/quote ISO-9075-2:1999
Jochem
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MS AD
it stands for Distinguished Name. - Original Message - From: Frank Mamone [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 16, 2003 3:18 PM Subject: Re: MS AD Just for reference, what is DC? - Original Message - From: Shahzad.Butt [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 16, 2003 12:48 PM Subject: RE: MS AD Got it working. Dc was missing thx -Original Message- From: Shahzad.Butt Sent: 16 June 2003 17:25 To: CF-Talk Subject: RE: MS AD Same error man, using port 389 -Original Message- From: Allan Clarke [mailto:[EMAIL PROTECTED] Sent: 16 June 2003 17:17 To: CF-Talk Subject: RE: MS AD the 'port' attribute is missing. Adding this will fix your problem --- Marlon Moyer [EMAIL PROTECTED] wrote: Have you tried giving it a username and password? -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Monday, June 16, 2003 10:54 AM To: CF-Talk Subject: MS AD How can I query MS Active Directory and get a list of all emails for users in AD?? My impression was that something like cfldap server = TestServer action = query name = results start = cn = shaz,c = US filter = (cn = shaz) attributes = cn,o,l,st,c,mail,telephonenumber sort = cn ASC should work but its giving following error An error has occured while trying to execute query operation on the LDAP Server. One or more of the required attributes may be missing/incorrect or you do not have permissions to execute this operation on the server Thanks Shaz ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MS AD
Correction. I have no clue what it stands for. I thought you asked DN. :-) - Original Message - From: Michael T. Tangorre [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 7:04 AM Subject: Re: MS AD it stands for Distinguished Name. - Original Message - From: Frank Mamone [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 16, 2003 3:18 PM Subject: Re: MS AD Just for reference, what is DC? - Original Message - From: Shahzad.Butt [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 16, 2003 12:48 PM Subject: RE: MS AD Got it working. Dc was missing thx -Original Message- From: Shahzad.Butt Sent: 16 June 2003 17:25 To: CF-Talk Subject: RE: MS AD Same error man, using port 389 -Original Message- From: Allan Clarke [mailto:[EMAIL PROTECTED] Sent: 16 June 2003 17:17 To: CF-Talk Subject: RE: MS AD the 'port' attribute is missing. Adding this will fix your problem --- Marlon Moyer [EMAIL PROTECTED] wrote: Have you tried giving it a username and password? -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Monday, June 16, 2003 10:54 AM To: CF-Talk Subject: MS AD How can I query MS Active Directory and get a list of all emails for users in AD?? My impression was that something like cfldap server = TestServer action = query name = results start = cn = shaz,c = US filter = (cn = shaz) attributes = cn,o,l,st,c,mail,telephonenumber sort = cn ASC should work but its giving following error An error has occured while trying to execute query operation on the LDAP Server. One or more of the required attributes may be missing/incorrect or you do not have permissions to execute this operation on the server Thanks Shaz ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MS AD
I would assume it stands for Data Connection -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 12:07 To: CF-Talk Subject: Re: MS AD Correction. I have no clue what it stands for. I thought you asked DN. :-) - Original Message - From: Michael T. Tangorre [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 7:04 AM Subject: Re: MS AD it stands for Distinguished Name. - Original Message - From: Frank Mamone [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 16, 2003 3:18 PM Subject: Re: MS AD Just for reference, what is DC? - Original Message - From: Shahzad.Butt [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 16, 2003 12:48 PM Subject: RE: MS AD Got it working. Dc was missing thx -Original Message- From: Shahzad.Butt Sent: 16 June 2003 17:25 To: CF-Talk Subject: RE: MS AD Same error man, using port 389 -Original Message- From: Allan Clarke [mailto:[EMAIL PROTECTED] Sent: 16 June 2003 17:17 To: CF-Talk Subject: RE: MS AD the 'port' attribute is missing. Adding this will fix your problem --- Marlon Moyer [EMAIL PROTECTED] wrote: Have you tried giving it a username and password? -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Monday, June 16, 2003 10:54 AM To: CF-Talk Subject: MS AD How can I query MS Active Directory and get a list of all emails for users in AD?? My impression was that something like cfldap server = TestServer action = query name = results start = cn = shaz,c = US filter = (cn = shaz) attributes = cn,o,l,st,c,mail,telephonenumber sort = cn ASC should work but its giving following error An error has occured while trying to execute query operation on the LDAP Server. One or more of the required attributes may be missing/incorrect or you do not have permissions to execute this operation on the server Thanks Shaz ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Custom Tag for tif files.
Anyone know of a custom tag that can convert a word doc or text document to a tif? Thanks! Mike ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Blue dragon installation issues
There is a BlueDragon list on the NewAtlanta site that may be of help to you... http://www.newatlanta.com/products/bluedragon/self_help/archive_search/index .cfm Hope this helps, Yves Arsenault Carrefour Infotech 5, Acadian Dr. Charlottetown, PEI C1C 1M2 [EMAIL PROTECTED] (902)368-1895 ext.242 ICQ #117650823 -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: June 17, 2003 5:46 AM To: CF-Talk Subject: Blue dragon installation issues Hello After all the talk of BD in recent days I downloaded the free J2EE version and installed in on my mac, as a web app in Jrun4. Things seemed ok, the test cfml and jsp pages ran fine, but I cant access the admin panel. All attempts to access it return a white page.. Occasionally (after lots of refresh pressing) I get an alert saying Developers License for BlueDragon... Seems a bit strange that cfml pages process but the admin doesn¹t... Incidentally I can't find the admin.cfm page, but its not returning an error not found either... TIA, Ryan ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
How many tables per datasource?
Hi, how's everyone doing? :) I never thought about it until today, when i was asked about it while explaing a bit if mysql for a friend. Is there a rule or best pratice to know when it's time to create another datasource? Maybe spliting 1 datasource with many tables on 2 or 3 increases performance... Regards. BP. _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How many tables per datasource?
there is not real answer to that...as # of tables is really based on your database design..for instance we have a database here which is near 500 tables - what would be the point in creating another datasource, imagine all the variables we would have to change! Also, performance is again down to your db design. -Original Message- From: Blood Python [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 13:44 To: CF-Talk Subject: How many tables per datasource? Hi, how's everyone doing? :) I never thought about it until today, when i was asked about it while explaing a bit if mysql for a friend. Is there a rule or best pratice to know when it's time to create another datasource? Maybe spliting 1 datasource with many tables on 2 or 3 increases performance... Regards. BP. _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Test for me
Please ignore. I'm testing the list to see if I will receive this email. I had a big DNS problem yesterday. Thank you, Matthew Small IT Director Showstopper American Dance Championships [EMAIL PROTECTED] 843-357-1847 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMX Server Errors :(
oi CF-Talk,!! I had a box running cfmxthat all of a sudden just stopped serving up .cfm's I do not know if this is due to applying windows updates (as had another box)... but i have uninstalled/ deleted directories/ rebooted/ reinstalled/ and even when i call the admin page. I get a Internal Server 500 Error. any suggestions? Crit --- [This E-mail scanned for viruses by Declude Virus] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How many tables per datasource?
This is a very interesting question. I don't think there would be any performance benefits, although you could setup different datasources for security purposes or for reporting/tracking. Multiple datasources that access the same db, but use different logins for varied access rights. Assign a different datasource to each application and you could track db activity by application. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 8:44 AM To: CF-Talk Subject: RE: How many tables per datasource? there is not real answer to that...as # of tables is really based on your database design..for instance we have a database here which is near 500 tables - what would be the point in creating another datasource, imagine all the variables we would have to change! Also, performance is again down to your db design. -Original Message- From: Blood Python [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 13:44 To: CF-Talk Subject: How many tables per datasource? Hi, how's everyone doing? :) I never thought about it until today, when i was asked about it while explaing a bit if mysql for a friend. Is there a rule or best pratice to know when it's time to create another datasource? Maybe spliting 1 datasource with many tables on 2 or 3 increases performance... Regards. BP. _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX Server Errors :(
oi Critz!! I just tried to remove_all_connectors then reattach the iis one. I got an error when I did remove all... and when i tried to attach the IIS one it said: os.name: Windows 2000 os.version: 5.0 os.arch: x86 platform: intel-win web server: IIS File C:\CFusionMX\runtime\lib\wsconfig\jrunwin32.dll newer than JAR file C:\CFus ionMX\runtime\lib\wsconfig.jar so not extracted findServers(): attempting connect to port 2901 on host 127.0.0.1 Could not connect to any JRun servers on host localhost. Confirm that the JRun server is started. Press any key to continue . . . i've just installed it... so i have no clue why it isn't finding it? :( ~~| /index.cfm?forumid=4 ists/index.cfm?method=subscrib faq ted by CFHosting.com. The plac tp://www.houseoffusion.com/cf_ us] --- [This E-mail scanned for viruses by Declude Virus] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MS AD
Domain Controller (in AD) -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 12:04 To: CF-Talk Subject: RE: MS AD I would assume it stands for Data Connection -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 12:07 To: CF-Talk Subject: Re: MS AD Correction. I have no clue what it stands for. I thought you asked DN. :-) - Original Message - From: Michael T. Tangorre [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 7:04 AM Subject: Re: MS AD it stands for Distinguished Name. - Original Message - From: Frank Mamone [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 16, 2003 3:18 PM Subject: Re: MS AD Just for reference, what is DC? - Original Message - From: Shahzad.Butt [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 16, 2003 12:48 PM Subject: RE: MS AD Got it working. Dc was missing thx -Original Message- From: Shahzad.Butt Sent: 16 June 2003 17:25 To: CF-Talk Subject: RE: MS AD Same error man, using port 389 -Original Message- From: Allan Clarke [mailto:[EMAIL PROTECTED] Sent: 16 June 2003 17:17 To: CF-Talk Subject: RE: MS AD the 'port' attribute is missing. Adding this will fix your problem --- Marlon Moyer [EMAIL PROTECTED] wrote: Have you tried giving it a username and password? -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Monday, June 16, 2003 10:54 AM To: CF-Talk Subject: MS AD How can I query MS Active Directory and get a list of all emails for users in AD?? My impression was that something like cfldap server = TestServer action = query name = results start = cn = shaz,c = US filter = (cn = shaz) attributes = cn,o,l,st,c,mail,telephonenumber sort = cn ASC should work but its giving following error An error has occured while trying to execute query operation on the LDAP Server. One or more of the required attributes may be missing/incorrect or you do not have permissions to execute this operation on the server Thanks Shaz ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOT: ASP equivalent to CF server variables?
Well, I'm beating my brains out trying to find this on MSDN, but I'll bet this group knows... I need an ASP equivalent to CF's built-in server variables, like OS, OS Version, HTTP server, etc. How can I get that in ASP classic? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ASP equivalent to CF server variables?
Give this a try. Might be more than you need, but I'm sure it won't hurt :) [EMAIL PROTECTED]VBScript% htmlbodytest % On Error Resume Next Response.Write All Variables : Now() HR dim Header, Footer header = table border=1 align=center width=400 footer = /table Response.Write(cookies header) for each item in Request.Cookies Response.Write(trtd item /tdtd Request.Cookies(item) /td) next Response.Write(footer server vars header) for each item in request.servervariables Response.Write(trtd item /tdtd -- Request.ServerVariables(item) /td/tr) next Response.write(footer session contents header) for each item in session.contents Response.Write(trtd item /tdtd session(item) /td/tr) next Response.write(footer application contents header) for each item in application.contents Response.Write(trtd item /td/tr) next % table border=0 trtdbScript engine : /td td%= scriptengine() %/td td%= scriptenginemajorversion() %:/td td%=scriptengineminorversion() %/td td%= scriptenginebuildversion() %/td/tr/table /body/html -Original Message- From: Lofback, Chris [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 9:35 AM To: CF-Talk Subject: SOT: ASP equivalent to CF server variables? Well, I'm beating my brains out trying to find this on MSDN, but I'll bet this group knows... I need an ASP equivalent to CF's built-in server variables, like OS, OS Version, HTTP server, etc. How can I get that in ASP classic? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Blue dragon installation issues
Hi Ryan, Can you forward an email describing your problem to [EMAIL PROTECTED] and attach the bluedragon.log file? You can find the log file in the following directory within your webapp: /WEB-INF/bluedragon/work/bluedragon.log I'll make sure someone takes a look at it today. And, no, we don't need your credit card number. ;-) BTW, the reason you can't find admin.cfm is because it's delivered within an encrypted BlueDragon Archive (BDA) file, which is located in: /WEB-INF/bluedragon/admin.bda One of the features of BlueDragon is that you can build your own BDA files and deploy them instead of your CFML source code. Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 4:46 AM To: CF-Talk Subject: Blue dragon installation issues Hello After all the talk of BD in recent days I downloaded the free J2EE version and installed in on my mac, as a web app in Jrun4. Things seemed ok, the test cfml and jsp pages ran fine, but I cant access the admin panel. All attempts to access it return a white page.. Occasionally (after lots of refresh pressing) I get an alert saying Developers License for BlueDragon... Seems a bit strange that cfml pages process but the admin doesn¹t... Incidentally I can't find the admin.cfm page, but its not returning an error not found either... TIA, Ryan ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ASP equivalent to CF server variables?
Thanks! That gets most of what I needed. Is there any way to get the server OS and OS version? Chris -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 9:39 AM To: CF-Talk Subject: RE: ASP equivalent to CF server variables? Give this a try. Might be more than you need, but I'm sure it won't hurt :) [EMAIL PROTECTED]VBScript% htmlbodytest % On Error Resume Next Response.Write All Variables : Now() HR dim Header, Footer header = table border=1 align=center width=400 footer = /table Response.Write(cookies header) for each item in Request.Cookies Response.Write(trtd item /tdtd Request.Cookies(item) /td) next Response.Write(footer server vars header) for each item in request.servervariables Response.Write(trtd item /tdtd -- Request.ServerVariables(item) /td/tr) next Response.write(footer session contents header) for each item in session.contents Response.Write(trtd item /tdtd session(item) /td/tr) next Response.write(footer application contents header) for each item in application.contents Response.Write(trtd item /td/tr) next % table border=0 trtdbScript engine : /td td%= scriptengine() %/td td%= scriptenginemajorversion() %:/td td%=scriptengineminorversion() %/td td%= scriptenginebuildversion() %/td/tr/table /body/html -Original Message- From: Lofback, Chris [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 9:35 AM To: CF-Talk Subject: SOT: ASP equivalent to CF server variables? Well, I'm beating my brains out trying to find this on MSDN, but I'll bet this group knows... I need an ASP equivalent to CF's built-in server variables, like OS, OS Version, HTTP server, etc. How can I get that in ASP classic? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX Server Errors :(
Jrun has to be running, ie: check in your services and make sure CF Application Server is started. Then run the connector command again ~~ Stephenie Hamilton Macromedia Certified ColdFusion Professional CFXHosting -Original Message- From: Critz [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 9:01 AM To: CF-Talk Subject: Re: CFMX Server Errors :( oi Critz!! I just tried to remove_all_connectors then reattach the iis one. I got an error when I did remove all... and when i tried to attach the IIS one it said: os.name: Windows 2000 os.version: 5.0 os.arch: x86 platform: intel-win web server: IIS File C:\CFusionMX\runtime\lib\wsconfig\jrunwin32.dll newer than JAR file C:\CFus ionMX\runtime\lib\wsconfig.jar so not extracted findServers(): attempting connect to port 2901 on host 127.0.0.1 Could not connect to any JRun servers on host localhost. Confirm that the JRun server is started. Press any key to continue . . . i've just installed it... so i have no clue why it isn't finding it? :( ~~| /index.cfm?forumid=4 ists/index.cfm?method=subscrib faq ted by CFHosting.com. The plac tp://www.houseoffusion.com/cf_ us] --- [This E-mail scanned for viruses by Declude Virus] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: printer friendly page break?
Jochem, How about a short example? -mk -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Monday, June 16, 2003 2:22 PM To: CF-Talk Subject: Re: OT: printer friendly page break? Janine Jakim wrote: Is there an easy way to force a page break at certain sections? Use the CSS page-break-before and page-break-after options. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SQL float format
Hi, I have values stored as float in an MSSQL2k table. If i store 55.5 as a value in this column, I sometimes get back 55.5000 (a lot of decimals). And sometimes 55 returns 55.0. (returns = cfquery) Any hints tips, references for some RTFM? /H. - Hugo Ahlenius E-Mail: [EMAIL PROTECTED] Project OfficerPhone:+46 8 230460 UNEP GRID-Arendal Fax: +46 8 230441 Stockholm Office Mobile: +46 733 467111 WWW: http://www.grida.no - ### This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange. For more information, connect to http://www.F-Secure.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: printer friendly page break?
Check out this link for implementation options. http://www.blooberry.com/indexdot/css/properties/print/pbbefore.htm -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 10:08 AM To: CF-Talk Subject: RE: OT: printer friendly page break? Jochem, How about a short example? -mk -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Monday, June 16, 2003 2:22 PM To: CF-Talk Subject: Re: OT: printer friendly page break? Janine Jakim wrote: Is there an easy way to force a page break at certain sections? Use the CSS page-break-before and page-break-after options. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: printer friendly page break?
http://www.javascriptkit.com/dhtmltutors/pagebreak.shtml I was just doing somethign similar a few minutes ago... Mike - Original Message - From: Mark A. Kruger - CFG [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 10:07 AM Subject: RE: OT: printer friendly page break? Jochem, How about a short example? -mk -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Monday, June 16, 2003 2:22 PM To: CF-Talk Subject: Re: OT: printer friendly page break? Janine Jakim wrote: Is there an easy way to force a page break at certain sections? Use the CSS page-break-before and page-break-after options. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX Server Errors :(
Critz wrote: os.name: Windows 2000 os.version: 5.0 os.arch: x86 platform: intel-win web server: IIS File C:\CFusionMX\runtime\lib\wsconfig\jrunwin32.dll newer than JAR file C:\CFus ionMX\runtime\lib\wsconfig.jar so not extracted findServers(): attempting connect to port 2901 on host 127.0.0.1 Could not connect to any JRun servers on host localhost. Confirm that the JRun server is started. Press any key to continue . . . i've just installed it... so i have no clue why it isn't finding it? :( Could it be you are using TCP/IP filtering? If so, the connector can't connect to JRun because it requires some TCP/IP connections to do so. Documentation says you will have to open port 2901 and 51010, but my experience is that it requires TCP/IP to be completely disabled (which requires a reboot, and another one to re-enable it). You should be ready to deal with many problems with the ODBC Service too (I am not aware of any documentation on which ports it uses). Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How many tables per datasource?
Blood Python wrote: I never thought about it until today, when i was asked about it while explaing a bit if mysql for a friend. Is there a rule or best pratice to know when it's time to create another datasource? Maybe spliting 1 datasource with many tables on 2 or 3 increases performance... It can increase performance and it can decrease performance. From a CF point of view, it will most likely decrease performance marginally to split a datasource, even if it is just because of a less efficient connection pool. On the database side, anything can happen if you split a database. Performance might increase because of less lock contention, or decrease because the occasional much slower cross database query or just because more execution plans must be cached (not talking about datasources anymore, but databases). I would let the rules of normalization determine the number of tables, not some arbitrary performance number that undoubtedly changes with the next release anyway. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: printer friendly page break?
Mark A. Kruger - CFG wrote: How about a short example? http://www.google.com/search?q=page-break-before%20example :-) Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Accessing fragment ID from URL?
Hi, Maybe I'm just missing it, but how do I access the value of a url's fragment id? That is, given a url of http://somehost.com/pagename.cfm?param1=foo#bar; how do I find bar? It's not in the CGI or URL scopes as far as I can see with CFDUMP. I was coding this in Javascript, I'd use location.hash. Thanks. -- Howard Fore, [EMAIL PROTECTED] Trust but verify: Yeah, I backed up the hard drive. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Accessing fragment ID from URL?
ListLast(http://somehost.com/pagename.cfm?param1=foo#bar;, ##) Not sure if there's a CGI var for this. Ade -Original Message- From: Howard Fore [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 15:40 To: CF-Talk Subject: Accessing fragment ID from URL? Hi, Maybe I'm just missing it, but how do I access the value of a url's fragment id? That is, given a url of http://somehost.com/pagename.cfm?param1=foo#bar; how do I find bar? It's not in the CGI or URL scopes as far as I can see with CFDUMP. I was coding this in Javascript, I'd use location.hash. Thanks. -- Howard Fore, [EMAIL PROTECTED] Trust but verify: Yeah, I backed up the hard drive. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Accessing fragment ID from URL?
On Tuesday, Jun 17, 2003, at 10:50 US/Eastern, Adrian Lynch wrote: ListLast(http://somehost.com/pagename.cfm?param1=foo#bar;, ##) Not sure if there's a CGI var for this. Sorry, I should have been more clear. I'd like to be able to detect the fragment ID within the requested page. The page receiving the request is acting as a dispatcher and I need to be able to read the fragment ID from the incoming URL as it were and then pass it along to the eventual CFLOCATION call. -- Howard Fore, [EMAIL PROTECTED] Trust but verify: Yeah, I backed up the hard drive. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: SQL Question - Could CF make this easier?
You can do it easier with SQL by using NOT IN
... WHERE Description NOT IN ('ANISE', 'APPLES',.)
HTH
Dick
On Wednesday, June 11, 2003, at 11:37 AM, Jillian Carroll wrote:
I am creating a drop-down list of items, but I want to keep several
items
from appearing in the drop-down.
Is there a more efficient way to accomplish this (there will be
several more
exclusions):
cfquery name=qCrop datasource=common_as
SELECT DISTINCT
Description
FROM VCT
ORDER BY
Description
WHERE description != 'ANISE'
AND description != 'APPLES'
AND description != 'ASPARAGUS'
AND description != 'BEETS'
AND description != 'BROCCOLI'
/cfquery
--
Jillian
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics.
http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX Server Errors :(
oi Jochem!! yeah, i am using tcp/ip filtering. unfortunately, i cannot disable it to re-enable it... as I cannot get to that machine for a while :( weird though... like i said.it was all working fine at one time.then just died... Tuesday, June 17, 2003, 10:10:36 AM, you wrote: JvD Could it be you are using TCP/IP filtering? If so, the connector can't JvD connect to JRun because it requires some TCP/IP connections to do so. JvD Documentation says you will have to open port 2901 and 51010, but my JvD experience is that it requires TCP/IP to be completely disabled (which JvD requires a reboot, and another one to re-enable it). JvD You should be ready to deal with many problems with the ODBC Service too JvD (I am not aware of any documentation on which ports it uses). JvD Jochem JvD ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Log files in MX
Hi, I was wondering if anyone knows of either a custom tag or might have some code that will allow me to read the log file from a CF-MX server. My company has decided that as programmers we have no access to the CF admin and they will mot turn on the Sandbox Security so that I can view them. I know that this can be done with a RDS connection thru Studio and view the logs directly but this is also not allowed in the production environment here. If anyone has any ideas of how this can be done of if something exist that I can use to view the logs that would be great. Thanks Mario This message is for the named person's use only. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. CREDIT SUISSE GROUP and each legal entity in the CREDIT SUISSE FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT SUISSE FIRST BOSTON reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal written confirmation. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Accessing fragment ID from URL?
On Tuesday, Jun 17, 2003, at 10:50 US/Eastern, Adrian Lynch wrote: ListLast(http://somehost.com/pagename.cfm?param1=foo#bar;, ##) Not sure if there's a CGI var for this. Sorry, I should have been more clear. I'd like to be able to detect the fragment ID within the requested page. The page receiving the request is acting as a dispatcher and I need to be able to read the fragment ID from the incoming URL as it were and then pass it along to the eventual CFLOCATION call. (for your example) ListLast(#cgi.http_referer#, ##) (if you want the full query string) ListLast(#cgi.http_referer#, ?) HTH, Dave ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How many tables per datasource?
- Original Message - From: Blood Python [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 8:43 AM Subject: How many tables per datasource? Hi, how's everyone doing? :) I never thought about it until today, when i was asked about it while explaing a bit if mysql for a friend. Is there a rule or best pratice to know when it's time to create another datasource? Maybe spliting 1 datasource with many tables on 2 or 3 increases performance... I'd say there's a really simple rule -- you need a new datasource when you need to change one of the datasource connection properties that live in the datasource configuration. You can split a *dataBASE* for performance -- usually across different filesystems -- but the *dataSOURCE* is basically a configuration for accessing the database. You can think of crazy counterexamples -- tuning the number of simultaneous users and such in the datasource settings, but that is a really strange situation. And it fits into the simple rule I propose above -- new datasource when you need a new configuration for the connection to the database. I've seen situations where one datasource has only stored proc permissions (a MSSQL datasource) for the web user to use, while the admin app had SELECT/INSERT/UPDATE/DELETE as well -- but the database permissions and the username/password fields in CFQUERY could have handled that as well. Now if you're thinking about tuning the database to avoid hotspots and other performance issues, that's all about the database, not the datasource. And a very different discussion :) Regards, John Paul Ashenfelter CTO/TransitionPoint ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Log files in MX
Try LogMagic http://www.macromedia.com/cfusion/exchange/index.cfm?view=sn130#loc=en_u sview=sn105viewName=Exchange%20Search (watch for url wrap) Or use http://makeashorterlink.com/?F2B9534F4 ~~ Stephenie Hamilton Macromedia Certified ColdFusion Professional CFXHosting -Original Message- From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 11:19 AM To: CF-Talk Subject: Log files in MX Hi, I was wondering if anyone knows of either a custom tag or might have some code that will allow me to read the log file from a CF-MX server. My company has decided that as programmers we have no access to the CF admin and they will mot turn on the Sandbox Security so that I can view them. I know that this can be done with a RDS connection thru Studio and view the logs directly but this is also not allowed in the production environment here. If anyone has any ideas of how this can be done of if something exist that I can use to view the logs that would be great. Thanks Mario This message is for the named person's use only. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. CREDIT SUISSE GROUP and each legal entity in the CREDIT SUISSE FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT SUISSE FIRST BOSTON reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal written confirmation. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL float format
You can use CAST or CONVERT on the MS-SQL side, or better yet, use one of the ColdFusion formatting functions (NumberFormat, DecimalFormat, etc) to produce the exact output you're after. Regards, John Paul Ashenfelter CTO/TransitionPoint - Original Message - From: Hugo Ahlenius [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 10:08 AM Subject: SQL float format Hi, I have values stored as float in an MSSQL2k table. If i store 55.5 as a value in this column, I sometimes get back 55.5000 (a lot of decimals). And sometimes 55 returns 55.0. (returns = cfquery) Any hints tips, references for some RTFM? /H. - Hugo Ahlenius E-Mail: [EMAIL PROTECTED] Project OfficerPhone:+46 8 230460 UNEP GRID-Arendal Fax: +46 8 230441 Stockholm Office Mobile: +46 733 467111 WWW: http://www.grida.no - ### This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange. For more information, connect to http://www.F-Secure.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL float format
I'm not sure what you're looking to do, but have you tried setting the precision at all? float and real Approximate number data types for use with floating point numeric data. Floating point data is approximate; not all values in the data type range can be precisely represented. Syntax float [ ( n ) ] Is a floating point number data from - 1.79E + 308 through 1.79E + 308. n is the number of bits used to store the mantissa of the float number in scientific notation and thus dictates the precision and storage size. n must be a value from 1 through 53. n is Precision Storage size 1-24 7 digits 4 bytes 25-53 15 digits 8 bytes The Microsoft® SQL ServerT float[(n)] data type conforms to the SQL-92 standard for all values of n from 1 to 53. The synonym for double precision is float(53). - Original Message - From: Hugo Ahlenius [EMAIL PROTECTED] Hi, I have values stored as float in an MSSQL2k table. If i store 55.5 as a value in this column, I sometimes get back 55.5000 (a lot of decimals). And sometimes 55 returns 55.0. (returns = cfquery) Any hints tips, references for some RTFM? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Accessing fragment ID from URL?
Hmm. Isn't HTTP_REFERER actually the request for the previous page? If page A is requested with http://somehost.com/pageA.cfm?param1=foo#barA and has a link to http://somehost.com/pageB.cfm?param1=foo#barB when pageB.cfm executes, won't the HTTP_REFERER be http://somehost.com/pageA.cfm?param1=foo#barA as pageA.cfm's URL produced the HTML with the link to pageB? For some reason unknown to me, IE and Mozilla are reading the fragment ID on the original link and applying it to the page they are redirected to via cflocation. Safari and Opera don't exhibit this behavior however. Any more ideas? On Tuesday, Jun 17, 2003, at 11:18 US/Eastern, Dave Wilson wrote: On Tuesday, Jun 17, 2003, at 10:50 US/Eastern, Adrian Lynch wrote: ListLast(http://somehost.com/pagename.cfm?param1=foo#bar;, ##) Not sure if there's a CGI var for this. Sorry, I should have been more clear. I'd like to be able to detect the fragment ID within the requested page. The page receiving the request is acting as a dispatcher and I need to be able to read the fragment ID from the incoming URL as it were and then pass it along to the eventual CFLOCATION call. (for your example) ListLast(#cgi.http_referer#, ##) (if you want the full query string) ListLast(#cgi.http_referer#, ?) HTH, Dave ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: SQL problem
I like a simple solution.
-- DDL, create table
create table #tbl(CountryName varchar(24), [Value] int, [Year] char(4));
-- DML, populate data
insert into #tbl(countryName,[Value],[Year])
values ('Sweden', 80, '1970');
insert into #tbl(countryName,[Value],[Year])
values('Sweden', 20, '1999');
insert into #tbl(countryName,[Value],[Year])
values ('Denmark', 10, '1962');
insert into #tbl(countryName,[Value],[Year])
values('Denmark', 15, '1992');
-- DML, get sucker
select top 2 *
from #tbl
order by [Year] desc;
Li, Chunshen (Don)
[EMAIL PROTECTED]
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Host with the leader in ColdFusion hosting.
Voted #1 ColdFusion host by CF Developers.
Offering shared and dedicated hosting options.
www.cfxhosting.com/default.cfm?redirect=10481
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Accessing fragment ID from URL?
Hi, I just did a quick test and notice the anchor parameter isn't available to CF at all, which suggests to me that it is clientside. How about using a document.location call with javascript instead of cflocation? This should let you use location.hash (sorry my javascript is terrible). HTH, Dave -Original Message- From: Howard Fore [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 17:03 To: CF-Talk Subject: Re: Accessing fragment ID from URL? Hmm. Isn't HTTP_REFERER actually the request for the previous page? If page A is requested with http://somehost.com/pageA.cfm?param1=foo#barA and has a link to http://somehost.com/pageB.cfm?param1=foo#barB when pageB.cfm executes, won't the HTTP_REFERER be http://somehost.com/pageA.cfm?param1=foo#barA as pageA.cfm's URL produced the HTML with the link to pageB? For some reason unknown to me, IE and Mozilla are reading the fragment ID on the original link and applying it to the page they are redirected to via cflocation. Safari and Opera don't exhibit this behavior however. Any more ideas? On Tuesday, Jun 17, 2003, at 11:18 US/Eastern, Dave Wilson wrote: On Tuesday, Jun 17, 2003, at 10:50 US/Eastern, Adrian Lynch wrote: ListLast(http://somehost.com/pagename.cfm?param1=foo#bar;, ##) Not sure if there's a CGI var for this. Sorry, I should have been more clear. I'd like to be able to detect the fragment ID within the requested page. The page receiving the request is acting as a dispatcher and I need to be able to read the fragment ID from the incoming URL as it were and then pass it along to the eventual CFLOCATION call. (for your example) ListLast(#cgi.http_referer#, ##) (if you want the full query string) ListLast(#cgi.http_referer#, ?) HTH, Dave ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: SQL problem
Ahh, cool, thanks. :)
S. Isaac Dealey wrote:
SELECT CountryName, Value, Year
FROM table
WHERE
(CountryName, Year) IN (
SELECT CountryName, MAX(Year)
FROM table
GROUP BY CountryName
)
Is that a sql92 standard IN clause?...
I guess I had that comming :-)
I don't know. It is however a SQL:1999 standard IN
predicate:
quote
8.4 in predicate
Function
Specify a quantified comparison.
Format
in predicate ::=
row value expression
[ NOT ] IN in predicate value
in predicate value ::=
table subquery
| left paren in value list right paren
in value list ::=
row value expression { comma row value
expression }...
/quote ISO-9075-2:1999
Jochem
~~
~~~|
Archives:
http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/cf_lists/index.
cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by
CFHosting.com. The place for dependable ColdFusion
Hosting.
http://www.cfhosting.com
Unsubscribe: http://www.houseoffusion.com/cf_lists/uns
ubscribe.cfm?user=633.558.4
s. isaac dealey972-490-6624
new epoch http://www.turnkey.to
lead architect, tapestry cms http://products.turnkey.to
tapestry api is opensource http://www.turnkey.to/tapi
certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Host with the leader in ColdFusion hosting.
Voted #1 ColdFusion host by CF Developers.
Offering shared and dedicated hosting options.
www.cfxhosting.com/default.cfm?redirect=10481
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: JXP Files
I have been talking with a client about moving his hosting over to my service. I just found out that he has jxp files. Is that some form of JSP? What do I need to run them on a Win2k server that already has CF5, PHP and PERL? Rick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dreamweaver MX -- grayed out component tab
Yes, it's testCFC.cfc Thanks, Jamie On Fri, 13 Jun 2003 16:13:20 -0500, in cf-talk you wrote: Have you saved the file as something.cfc yet, or is it still untitled? -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 4:11 PM To: CF-Talk Subject: Re: Dreamweaver MX -- grayed out component tab Nope, that's not it. I've got files open from the site tab... any other ideas? Thanks, Jamie On Fri, 13 Jun 2003 16:59:03 -0400, in cf-talk you wrote: Most of those tabs are grayed out when you dont have file opened in the site you are currently working on. So make sure you have a file opened in the edit area. -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 4:37 PM To: CF-Talk Subject: Dreamweaver MX -- grayed out component tab I'm trying to go through Macromedia's CFC tutorial (this step: http://www.macromedia.com/devnet/mx/coldfusion/articles/creating_cfcs.html# u sing), but I can't follow, because my component tab's contents are grayed out. I suspect there might be a problem with the site setup, but don't know. Any insights? Thanks, Jamie ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Accessing fragment ID from URL?
If you just want to track clicks on a page with many inline anchors you can use the technique I've detailed here (it does require JavaScript be enabled): http://ww.depressedpress.com/DepressedPress/Content/ColdFusion/Essays/GI FAsPipe/Index.cfm Otherwise you may need to repeat your client-side anchor in the URL scope if it's not coming through. Something like page?Anchor=Section#Section Jim Davis President, http://www.depressedpress.com Webmaster, http://www.firstnight.org Webmaster, http://www.cfAdvocacy.org Senior Consultant, http://www.metlife.com -Original Message- From: Dave Wilson [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 12:12 PM To: CF-Talk Subject: RE: Accessing fragment ID from URL? Hi, I just did a quick test and notice the anchor parameter isn't available to CF at all, which suggests to me that it is clientside. How about using a document.location call with javascript instead of cflocation? This should let you use location.hash (sorry my javascript is terrible). HTH, Dave -Original Message- From: Howard Fore [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 17:03 To: CF-Talk Subject: Re: Accessing fragment ID from URL? Hmm. Isn't HTTP_REFERER actually the request for the previous page? If page A is requested with http://somehost.com/pageA.cfm?param1=foo#barA and has a link to http://somehost.com/pageB.cfm?param1=foo#barB when pageB.cfm executes, won't the HTTP_REFERER be http://somehost.com/pageA.cfm?param1=foo#barA as pageA.cfm's URL produced the HTML with the link to pageB? For some reason unknown to me, IE and Mozilla are reading the fragment ID on the original link and applying it to the page they are redirected to via cflocation. Safari and Opera don't exhibit this behavior however. Any more ideas? On Tuesday, Jun 17, 2003, at 11:18 US/Eastern, Dave Wilson wrote: On Tuesday, Jun 17, 2003, at 10:50 US/Eastern, Adrian Lynch wrote: ListLast(http://somehost.com/pagename.cfm?param1=foo#bar;, ##) Not sure if there's a CGI var for this. Sorry, I should have been more clear. I'd like to be able to detect the fragment ID within the requested page. The page receiving the request is acting as a dispatcher and I need to be able to read the fragment ID from the incoming URL as it were and then pass it along to the eventual CFLOCATION call. (for your example) ListLast(#cgi.http_referer#, ##) (if you want the full query string) ListLast(#cgi.http_referer#, ?) HTH, Dave ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Blue dragon installation issues
I'll make sure someone takes a look at it today. And, no, we don't need your credit card number. ;-) No credit card required from Macromedia either, for installation issues. For anyone experiencing CF product installation issues, the mechanism to use for installation issues (as defined on the page link) is via email here: http://www.macromedia.com/support/email/isupport/ BTW, you might want to check out the ColdFusion Red Sky Release Preview: a) Check out CF Red Sky Release preview info here: http://www.macromedia.com/software/coldfusion/presentation/redsky b) Apply for the CF Red Sky Beta program here: http://www.macromedia.com/go/cfmxbeta Subject: Blue dragon installation issues From: Vince Bonfanti [EMAIL PROTECTED] Date: Tue, 17 Jun 2003 09:41:09 -0400 Thread: http://www.houseoffusion.com/cf_lists/index.cfm?method=messagesthreadid=24870forumid=4#125107 Hi Ryan, Can you forward an email describing your problem to [EMAIL PROTECTED] and attach the bluedragon.log file? You can find the log file in the following directory within your webapp: /WEB-INF/bluedragon/work/bluedragon.log I'll make sure someone takes a look at it today. And, no, we don't need your credit card number. ;-) BTW, the reason you can't find admin.cfm is because it's delivered within an encrypted BlueDragon Archive (BDA) file, which is located in: /WEB-INF/bluedragon/admin.bda One of the features of BlueDragon is that you can build your own BDA files and deploy them instead of your CFML source code. Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dreamweaver MX -- grayed out component tab
On Fri, 13 Jun 2003 22:12:11 -0400, in cf-talk you wrote: And is that a CF site? Yes That's important, and you have to have set up the site correctly (configured a testing server pointing to a CF server). As far as I know, this is set up. However, from the beginning, I've suspected that it's a site config problem. Another issue is that DWMX is sensitive to the type of the template that you've opened. It has to be a CF page to allow access to the CF components tab (and the database tab, etc.) Is the page that you've opened either an already saved cfm page, or if new, did you use FileNewDynamic PageColdFusion? Yes, it's a page called test.cfm It's possible that when DWMX opens it's opening with a default type of static HTML. One way to know what type of file you have (especially in an unsaved file), is to look at the toolbars at the top right. If they include CFML Basic, CFML Flow, and CFML Advanced (at the end of the list starting with common, layout, text), then DWMX thinks you're working on a CF template. If not, it doesn't, and some of the things you're trying to use may not work as expected. Ahhh, brilliant. I followed a Forta tip (to increase DWMX speed), without fully realizing the consequences. I just removed cfm and cfc from the open in code view list, and voila, my stuff's there. I'm not sure I've got everything solved yet, but I should be able to figure it out from here. Thanks to everyone who replied :) Jamie ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Web-based telnet client?
Has anyone here implemented or heard of a telnet client written in CF (v5 or earlier)? I've got some telnet controlled devices that I'd like to create a web-based interface for. I'm thinking of perhaps emulating a telnet client, with text screen output and throw in a few buttons and controls for commonly executed commands. Could be very handy for the sysadmin that can't remember obscure telnet commands. Thanks, Jim ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Web-based telnet client?
I think you're looking at the wrong technology imho... You can probably just find an ActiveX control or an Applet that'll do that... Probably don't need to use ColdFusion... Maybe some javascript with the applet or some vbscript with the activex control... A quick search on google gets you this one: http://javassh.org/ Here's more info on it: http://javassh.org/wiki-view?oid=408180808080808080808080808084neotis -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 10:04 AM To: CF-Talk Subject: Web-based telnet client? Has anyone here implemented or heard of a telnet client written in CF (v5 or earlier)? I've got some telnet controlled devices that I'd like to create a web-based interface for. I'm thinking of perhaps emulating a telnet client, with text screen output and throw in a few buttons and controls for commonly executed commands. Could be very handy for the sysadmin that can't remember obscure telnet commands. Thanks, Jim ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Web-based telnet client?
What about using cfexecute? Just an idea... not sure how you can pipe input and output inti it. - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 1:03 PM Subject: Web-based telnet client? Has anyone here implemented or heard of a telnet client written in CF (v5 or earlier)? I've got some telnet controlled devices that I'd like to create a web-based interface for. I'm thinking of perhaps emulating a telnet client, with text screen output and throw in a few buttons and controls for commonly executed commands. Could be very handy for the sysadmin that can't remember obscure telnet commands. Thanks, Jim ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Data getting truncated on select
Last time something like that happened to me I realized that in the stored proc I put in the wrong number of characters id: @MacroName VARCHAR(50) instead of @MacroName VARCHAR(500) -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 1:51 PM To: CF-Talk Subject: Data getting truncated on select Greetings, I am querying a row in a table bringing back a large about of html data from a column named RawData, data type TEXT, When outputting a lot of data is not getting output, this is really strange, But I went into query analyzer and updated the field with a really large text string, data data etc... end on outputting the data it was prove somehow on select its being truncated as end did not get output. My stored proc looks like this, CREATE PROCEDURE leo4_getScheduledData ( @customerID INT, @MacroName VARCHAR(50), @ContainerID INT ) AS SELECT * FROMSchedulesContainer WHERE [EMAIL PROTECTED] AND [EMAIL PROTECTED] AND [EMAIL PROTECTED] any ideas would be appreciated. J ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Web-based telnet client?
TSt10 is a script for telnet that is very easy to use. Just create the script commands with CF and use CFEXECUTE. You can download it from me http://www.kchost.net/tst10.zip Rick Eidson -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 12:04 PM To: CF-Talk Subject: Web-based telnet client? Has anyone here implemented or heard of a telnet client written in CF (v5 or earlier)? I've got some telnet controlled devices that I'd like to create a web-based interface for. I'm thinking of perhaps emulating a telnet client, with text screen output and throw in a few buttons and controls for commonly executed commands. Could be very handy for the sysadmin that can't remember obscure telnet commands. Thanks, Jim ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Changing a session timeout based on login
Hello, Searched through the archives but couldn't find the answer. Is there a way to dynamically change a SESSION's timeout property in Application.cfm based on a user's login? For example, a general user has a 20 minute timeout, while an admin user has a 3 hour timeout. Thanks, James ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Accessing fragment ID from URL?
On Tuesday, Jun 17, 2003, at 12:12 US/Eastern, Dave Wilson wrote: I just did a quick test and notice the anchor parameter isn't available to CF at all, which suggests to me that it is clientside. It may not be available from CF, but it's certainly available in the call to the webserver, before the request is passed to CF. Perhaps someone at Allaire decided that not everything was that useful. How about using a document.location call with javascript instead of cflocation? This should let you use location.hash (sorry my javascript is terrible). Unfortunately this would make my current MVC setup way too complicated. I have another way to approach it that I was hoping to avoid. Programatic access to the fragment ID would have been far more elegant and less tightly coupled. Thanks anyway. -- Howard Fore, [EMAIL PROTECTED] Trust but verify: Yeah, I backed up the hard drive. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Odd CFFTP file/dir path issues
I've got two servers that, when deleting a folder and its contents from one, I want to be able to delete that same folder/contents on the other. At any given point, I know which server the code is running on, and can connect to the other server fine via CFFTP. I can also do a directory listing on the target directory fine, spitting out the contents of the recordset to see what's what. But immediately *after* doing a LISTDIR action on the target folder - the connection seems to lose its place, so to speak. If I do the LISTDIR call, and then the same LISTDIR call again, the second one returns an empty recordset, and the error The system cannot find the path specified. The code for both calls is identical. This is what's killing me as far as looping over the contents of that folder and removing all the files within before removing the folder itself. I've been using passive=yes, but swapping that to no doesn't seem to make a difference. Any thoughts? --Scott ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Accessing fragment ID from URL?
I just did a quick test and notice the anchor parameter isn't available to CF at all, which suggests to me that it is clientside. It may not be available from CF, but it's certainly available in the call to the webserver, before the request is passed to CF. Perhaps someone at Allaire decided that not everything was that useful. No, I don't think this is correct. According to my trusty sniffer, when I enter the following URL in IE 6: http://www.foobar.com/test.html#urlfrag the browser sends this request: GET /test.html HTTP/1.1 Accept: image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-powerpoint, application/vnd.ms-excel, application/msword, application/x-shockwave-flash, */* Accept-Language: en-us Accept-Encoding: gzip, deflate User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.0.3705; .NET CLR 1.1.4322) Host: www.foobar.com Connection: Keep-Alive Mozilla 1.3.1 does the same thing. Trust but verify: Yeah, I backed up the hard drive. You need to take this to heart. Especially the verify part. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
xpath sum
I've get an xml packet that returns qty available per warehouse, and I want to add up all of the qty's and return a total, but I am getting a crash when I try and use the sum in the xpath statement. The xml looks like this. LineInfo WhseInfo IDCodeMIAMI, FL/IDCode Qty9642/Qty /WhseInfo WhseInfo IDCodeNORCROSS, GA/IDCode Qty7475/Qty /WhseInfo WhseInfo IDCodePAULSBORO, NJ/IDCode Qty-4/Qty /WhseInfo /LineInfo Here is the code I have currently. cfset lineInfo = xmlSearch(xmlObj, /XML_Availability_Response/Detail/LineInfo) cfloop from=1 to=#arrayLen(lineinfo)# index=i cfset whseQty = xmlSearch(lineinfo[i], sum(WhseInfo/Qty)) /cfloop To be honest, I've never seen the sum function used this way, only in full blown style sheets...but from what I understand it should work. Anyone know what I'm doing wrong? This is the error I get. Can not convert #NUMBER to a NodeList! on this line: cfset whse = xmlSearch(lineinfo[i], sum(WhseInfo/Qty)) Trace starts with this. coldfusion.xml.XmlProcessException: Can not convert #NUMBER to a NodeList! -- jon mailto:[EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Data getting truncated on select
Are you using CFMX? I've had that problem using WDDX packets in client vars that are stored in the DB because the Java type that CFMX uses is/was (fixed yet? dunno) not large enough to handle the string. Perhaps you are having the same issue. +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 10:51 AM To: CF-Talk Subject: Data getting truncated on select Greetings, I am querying a row in a table bringing back a large about of html data from a column named RawData, data type TEXT, When outputting a lot of data is not getting output, this is really strange, But I went into query analyzer and updated the field with a really large text string, data data etc... end on outputting the data it was prove somehow on select its being truncated as end did not get output. My stored proc looks like this, CREATE PROCEDURE leo4_getScheduledData ( @customerID INT, @MacroName VARCHAR(50), @ContainerID INT ) AS SELECT * FROMSchedulesContainer WHERE [EMAIL PROTECTED] AND [EMAIL PROTECTED] AND [EMAIL PROTECTED] any ideas would be appreciated. J ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Web-based telnet client?
Back in the 4.5 days I thought about using CFFILE to run telnet commands. Is this still a possibility? E - Original Message - From: Jim McAtee [EMAIL PROTECTED] Has anyone here implemented or heard of a telnet client written in CF (v5 or earlier)? I've got some telnet controlled devices that I'd like to create a web-based interface for. I'm thinking of perhaps emulating a telnet client, with text screen output and throw in a few buttons and controls for commonly executed commands. Could be very handy for the sysadmin that can't remember obscure telnet commands. Thanks, Jim ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Data getting truncated on select
John, I have had this problem more than once. Which DBMS are you using? -- Jillian -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED] Sent: June 17, 2003 12:33 PM To: CF-Talk Subject: RE: Data getting truncated on select Yea I understand the problem you had, but I im not using VARCHAR, but TEXT which is fixed at 16 and has max characters of 2,147,483,647 characters. -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 19:23 To: CF-Talk Subject: RE: Data getting truncated on select Last time something like that happened to me I realized that in the stored proc I put in the wrong number of characters id: @MacroName VARCHAR(50) instead of @MacroName VARCHAR(500) -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 1:51 PM To: CF-Talk Subject: Data getting truncated on select Greetings, I am querying a row in a table bringing back a large about of html data from a column named RawData, data type TEXT, When outputting a lot of data is not getting output, this is really strange, But I went into query analyzer and updated the field with a really large text string, data data etc... end on outputting the data it was prove somehow on select its being truncated as end did not get output. My stored proc looks like this, CREATE PROCEDURE leo4_getScheduledData ( @customerID INT, @MacroName VARCHAR(50), @ContainerID INT ) AS SELECT* FROM SchedulesContainer WHERE [EMAIL PROTECTED] AND [EMAIL PROTECTED] AND [EMAIL PROTECTED] any ideas would be appreciated. J ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: xpath sum
jon hall [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] This is the error I get. Can not convert #NUMBER to a NodeList! Unfortunately xmlSearch() only accept XPath expressions that return a NodeList, it throws an error in case the expression returns a string or a number. It's not your fault -- Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: xpath sum
jon hall [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] This is the error I get. Can not convert #NUMBER to a NodeList! Unfortunately xmlSearch() only accept XPath expressions that return a NodeList, it throws an error in case the expression returns a string or a number. It's not your fault -- Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Data getting truncated on select
Using sql server 7. -Original Message- From: Jillian Carroll [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 20:14 To: CF-Talk Subject: RE: Data getting truncated on select John, I have had this problem more than once. Which DBMS are you using? -- Jillian -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED] Sent: June 17, 2003 12:33 PM To: CF-Talk Subject: RE: Data getting truncated on select Yea I understand the problem you had, but I im not using VARCHAR, but TEXT which is fixed at 16 and has max characters of 2,147,483,647 characters. -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 19:23 To: CF-Talk Subject: RE: Data getting truncated on select Last time something like that happened to me I realized that in the stored proc I put in the wrong number of characters id: @MacroName VARCHAR(50) instead of @MacroName VARCHAR(500) -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 1:51 PM To: CF-Talk Subject: Data getting truncated on select Greetings, I am querying a row in a table bringing back a large about of html data from a column named RawData, data type TEXT, When outputting a lot of data is not getting output, this is really strange, But I went into query analyzer and updated the field with a really large text string, data data etc... end on outputting the data it was prove somehow on select its being truncated as end did not get output. My stored proc looks like this, CREATE PROCEDURE leo4_getScheduledData ( @customerID INT, @MacroName VARCHAR(50), @ContainerID INT ) AS SELECT* FROM SchedulesContainer WHERE [EMAIL PROTECTED] AND [EMAIL PROTECTED] AND [EMAIL PROTECTED] any ideas would be appreciated. J ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Data getting truncated on select
File is averaging 264 k in size, Using CFMX and ODBC. -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 19:31 To: CF-Talk Subject: RE: Data getting truncated on select How big is this text object that is getting truncated? is it near 32K or 64K in size? What version of CF? What connectiontype are you using for that data source (ODBC or Native drivers)? Jerry Johnson [EMAIL PROTECTED] 06/17/03 02:22PM Last time something like that happened to me I realized that in the stored proc I put in the wrong number of characters id: @MacroName VARCHAR(50) instead of @MacroName VARCHAR(500) -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 1:51 PM To: CF-Talk Subject: Data getting truncated on select Greetings, I am querying a row in a table bringing back a large about of html data from a column named RawData, data type TEXT, When outputting a lot of data is not getting output, this is really strange, But I went into query analyzer and updated the field with a really large text string, data data etc... end on outputting the data it was prove somehow on select its being truncated as end did not get output. My stored proc looks like this, CREATE PROCEDURE leo4_getScheduledData ( @customerID INT, @MacroName VARCHAR(50), @ContainerID INT ) AS SELECT * FROMSchedulesContainer WHERE [EMAIL PROTECTED] AND [EMAIL PROTECTED] AND [EMAIL PROTECTED] any ideas would be appreciated. J ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Data getting truncated on select
How big is this text object that is getting truncated? is it near 32K or 64K in size? What version of CF? What connectiontype are you using for that data source (ODBC or Native drivers)? Jerry Johnson [EMAIL PROTECTED] 06/17/03 02:22PM Last time something like that happened to me I realized that in the stored proc I put in the wrong number of characters id: @MacroName VARCHAR(50) instead of @MacroName VARCHAR(500) -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 1:51 PM To: CF-Talk Subject: Data getting truncated on select Greetings, I am querying a row in a table bringing back a large about of html data from a column named RawData, data type TEXT, When outputting a lot of data is not getting output, this is really strange, But I went into query analyzer and updated the field with a really large text string, data data etc... end on outputting the data it was prove somehow on select its being truncated as end did not get output. My stored proc looks like this, CREATE PROCEDURE leo4_getScheduledData ( @customerID INT, @MacroName VARCHAR(50), @ContainerID INT ) AS SELECT * FROMSchedulesContainer WHERE [EMAIL PROTECTED] AND [EMAIL PROTECTED] AND [EMAIL PROTECTED] any ideas would be appreciated. J ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Data getting truncated on select
Yea I understand the problem you had, but I im not using VARCHAR, but TEXT which is fixed at 16 and has max characters of 2,147,483,647 characters. -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 19:23 To: CF-Talk Subject: RE: Data getting truncated on select Last time something like that happened to me I realized that in the stored proc I put in the wrong number of characters id: @MacroName VARCHAR(50) instead of @MacroName VARCHAR(500) -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 1:51 PM To: CF-Talk Subject: Data getting truncated on select Greetings, I am querying a row in a table bringing back a large about of html data from a column named RawData, data type TEXT, When outputting a lot of data is not getting output, this is really strange, But I went into query analyzer and updated the field with a really large text string, data data etc... end on outputting the data it was prove somehow on select its being truncated as end did not get output. My stored proc looks like this, CREATE PROCEDURE leo4_getScheduledData ( @customerID INT, @MacroName VARCHAR(50), @ContainerID INT ) AS SELECT * FROMSchedulesContainer WHERE [EMAIL PROTECTED] AND [EMAIL PROTECTED] AND [EMAIL PROTECTED] any ideas would be appreciated. J ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Data getting truncated on select
Yep using CFMX, the text strings are very big, pure html. Perhaps you are having the same issue. How did you get round this Bryan? -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 19:56 To: CF-Talk Subject: RE: Data getting truncated on select Are you using CFMX? I've had that problem using WDDX packets in client vars that are stored in the DB because the Java type that CFMX uses is/was (fixed yet? dunno) not large enough to handle the string. Perhaps you are having the same issue. +---+ Bryan Love Database Analyst Macromedia Certified Professional Internet Application Developer TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 10:51 AM To: CF-Talk Subject: Data getting truncated on select Greetings, I am querying a row in a table bringing back a large about of html data from a column named RawData, data type TEXT, When outputting a lot of data is not getting output, this is really strange, But I went into query analyzer and updated the field with a really large text string, data data etc... end on outputting the data it was prove somehow on select its being truncated as end did not get output. My stored proc looks like this, CREATE PROCEDURE leo4_getScheduledData ( @customerID INT, @MacroName VARCHAR(50), @ContainerID INT ) AS SELECT * FROMSchedulesContainer WHERE [EMAIL PROTECTED] AND [EMAIL PROTECTED] AND [EMAIL PROTECTED] any ideas would be appreciated. J ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Web-based telnet client?
Now that I think about it, you're probably right. For interactive sessions, anyway. The devices are remote power/reboot controllers for colocated servers. I'm also writing a monitoring application and may incorporate the ability to automate a power cycling for servers and equipment that won't respond to any other type of reset. In that case a non-interactive telnet session from my CF app would be necessary. I did a long search through my CF list archive and came up with a couple of tags, including cfx_telnet and cfx_tcpclient that may prove useful. Jim - Original Message - From: Costas Piliotis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 11:13 AM Subject: RE: Web-based telnet client? I think you're looking at the wrong technology imho... You can probably just find an ActiveX control or an Applet that'll do that... Probably don't need to use ColdFusion... Maybe some javascript with the applet or some vbscript with the activex control... A quick search on google gets you this one: http://javassh.org/ Here's more info on it: http://javassh.org/wiki-view?oid=408180808080808080808080808084neotis -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 10:04 AM To: CF-Talk Subject: Web-based telnet client? Has anyone here implemented or heard of a telnet client written in CF (v5 or earlier)? I've got some telnet controlled devices that I'd like to create a web-based interface for. I'm thinking of perhaps emulating a telnet client, with text screen output and throw in a few buttons and controls for commonly executed commands. Could be very handy for the sysadmin that can't remember obscure telnet commands. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Move ColdFusion 5 to new server
I need to move all my web sites and ColdFusion 5 to a new server. Is there an easy way to copy all the settings in IIS, datasources, and ColdFusion or will I need to set everything up from scratch? The current server and the new one are both Win2k.I don't have a lot of time to make the move so I am looking for anything that will speed up the process. Thanks Phillip B. www.LoungeRoyale.com www.FillWorks.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Application Security in MX
I'm reviewing the articles on-line regarding CFMX's new security model and it appears the cflogin tag is application specific. We need to have a single login be shared by many applications. What would be the best way to set this up in MX? TIA, Rob _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Move ColdFusion 5 to new server
Make an image of the exisiting server (Ghost) and you can have the new one up and running in a heartbeat Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Phillip B [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 12:37 PM Subject: Move ColdFusion 5 to new server I need to move all my web sites and ColdFusion 5 to a new server. Is there an easy way to copy all the settings in IIS, datasources, and ColdFusion or will I need to set everything up from scratch? The current server and the new one are both Win2k.I don't have a lot of time to make the move so I am looking for anything that will speed up the process. Thanks Phillip B. www.LoungeRoyale.com www.FillWorks.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Data getting truncated on select
I see that you may have an answer to your problem from another fellow, but a few suggestions (my problems were with PostgreSQL and MySQL): - Have you double checked that in the administrator you have long text return enabled? Without that checked of course, it will only return 64,000 characters / whatever value is specified in the text box below. - Have you checked your driver? Are you using the native driver for SQL Server 7 that ships with CF? -- Jillian -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED] Sent: June 17, 2003 1:28 PM To: CF-Talk Subject: RE: Data getting truncated on select Using sql server 7. -Original Message- From: Jillian Carroll [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 20:14 To: CF-Talk Subject: RE: Data getting truncated on select John, I have had this problem more than once. Which DBMS are you using? -- Jillian -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED] Sent: June 17, 2003 12:33 PM To: CF-Talk Subject: RE: Data getting truncated on select Yea I understand the problem you had, but I im not using VARCHAR, but TEXT which is fixed at 16 and has max characters of 2,147,483,647 characters. -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 19:23 To: CF-Talk Subject: RE: Data getting truncated on select Last time something like that happened to me I realized that in the stored proc I put in the wrong number of characters id: @MacroName VARCHAR(50) instead of @MacroName VARCHAR(500) -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 1:51 PM To: CF-Talk Subject: Data getting truncated on select Greetings, I am querying a row in a table bringing back a large about of html data from a column named RawData, data type TEXT, When outputting a lot of data is not getting output, this is really strange, But I went into query analyzer and updated the field with a really large text string, data data etc... end on outputting the data it was prove somehow on select its being truncated as end did not get output. My stored proc looks like this, CREATE PROCEDURE leo4_getScheduledData ( @customerID INT, @MacroName VARCHAR(50), @ContainerID INT ) AS SELECT * FROMSchedulesContainer WHERE [EMAIL PROTECTED] AND [EMAIL PROTECTED] AND [EMAIL PROTECTED] any ideas would be appreciated. J ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Move ColdFusion 5 to new server
I'm not sure about IIS, but its fairly easy to backup your CF settings You can backup the datasources pretty easily, see my blog post: http://cfm.blogspot.com/2003_03_01_cfm_archive.html#90935000 You can also backup all the ColdFusion settings by just backing up this registry key: HKEY_LOCAL_MACHINE\SOFTWARE\Allaire\ColdFusion\CurrentVersion\ You might also look into using the Archive and Deploy feature, and create a CAR file. ___ Pete Freitag http://www.cfdev.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
App Migration CF5 - CFMX
I have inherited an application that was designed using CF5 and I have to migrate it to CFMX. The application uses URLs like http://domain/view.cfm/U1 From what I can tell, CF5 stopped at the view.cfm page call and processed that part of the URL. The view.cfm file then knew how to parse the rest of the URL string as parameters being passed into the app. However, when I run this under CFMX, I am getting the standard 'page cannot be displayed' message that looks like it is attempting to find a default page under a folder called U1 which does not exist. How can I make MX run the view.cfm file in the URL string? Thanks -- Jeff ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
how to share servlet's session with Cold Fusion MX template?
Andre and Sean, thanks for your prompt reply and help. Both examples/pointers are very helpful! I tried both, however, it has not worked yet. Andre, I followed your code example, In your JSP/Servlet (Map) session.getAttribute(yourCFApplicationName).put(foo,bar); And then you can access it in a .cfm like this: #session.foo# and, I would get an UndefinedElementException, when accessing the var foo defined in the session. and, I also tried accessing application variables, application.setAttribute(yourCFApplicationName.foo,bar); In you .cfm you access it like this: #application.foo# and, I would get the very same exception. (I used my own variables but following the exact syntax you outlined.) just wondering, do you have the code working in CFMX and WebLogic7.0 environment? I contacted Macromedia and they said that this is a bug specific to sharing session between CFMX and WEbLogic7.0, and that I am the first one reporting this bug. Somehow, I just find it amazing that I am the first person reporting this bug. Has anyone else seen this? Sean, The article on IBM's website is a very good one! I further simplied IBM's example to only 3 classes, which runs on CFMX and WEbSphere. However, the code would fail on CFMX and WebLogic (obviously, for the same reason). Be happy to provide stackTrace if you are interested. Again, any comments/suggestions about sharing session between CFMX and WebLogic7.0 will be greatly appreciated! thx, Steven ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Application Security in MX
Use the ApplicationToken attribute for CFLOGIN. This allows you to share them. === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Robert Shaw [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 1:17 PM To: CF-Talk Subject: Application Security in MX I'm reviewing the articles on-line regarding CFMX's new security model and it appears the cflogin tag is application specific. We need to have a single login be shared by many applications. What would be the best way to set this up in MX? TIA, Rob _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Data getting truncated on select
- Have you double checked that in the administrator you have long text return enabled? Without that checked of course, it will only return 64,000 characters / whatever value is specified in the text box below. Adminstrative settings in MSSQL or CFMX? -Original Message- From: Jillian Carroll [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 20:42 To: CF-Talk Subject: RE: Data getting truncated on select I see that you may have an answer to your problem from another fellow, but a few suggestions (my problems were with PostgreSQL and MySQL): - Have you double checked that in the administrator you have long text return enabled? Without that checked of course, it will only return 64,000 characters / whatever value is specified in the text box below. - Have you checked your driver? Are you using the native driver for SQL Server 7 that ships with CF? -- Jillian -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED] Sent: June 17, 2003 1:28 PM To: CF-Talk Subject: RE: Data getting truncated on select Using sql server 7. -Original Message- From: Jillian Carroll [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 20:14 To: CF-Talk Subject: RE: Data getting truncated on select John, I have had this problem more than once. Which DBMS are you using? -- Jillian -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED] Sent: June 17, 2003 12:33 PM To: CF-Talk Subject: RE: Data getting truncated on select Yea I understand the problem you had, but I im not using VARCHAR, but TEXT which is fixed at 16 and has max characters of 2,147,483,647 characters. -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 19:23 To: CF-Talk Subject: RE: Data getting truncated on select Last time something like that happened to me I realized that in the stored proc I put in the wrong number of characters id: @MacroName VARCHAR(50) instead of @MacroName VARCHAR(500) -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 1:51 PM To: CF-Talk Subject: Data getting truncated on select Greetings, I am querying a row in a table bringing back a large about of html data from a column named RawData, data type TEXT, When outputting a lot of data is not getting output, this is really strange, But I went into query analyzer and updated the field with a really large text string, data data etc... end on outputting the data it was prove somehow on select its being truncated as end did not get output. My stored proc looks like this, CREATE PROCEDURE leo4_getScheduledData ( @customerID INT, @MacroName VARCHAR(50), @ContainerID INT ) AS SELECT * FROMSchedulesContainer WHERE [EMAIL PROTECTED] AND [EMAIL PROTECTED] AND [EMAIL PROTECTED] any ideas would be appreciated. J ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Move ColdFusion 5 to new server
I should have mentioned that I don't have physical access to the servers unfortunately. They are about 300 miles from my desk. Phillip B. www.LoungeRoyale.com www.FillWorks.com - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 2:42 PM Subject: Re: Move ColdFusion 5 to new server Make an image of the exisiting server (Ghost) and you can have the new one up and running in a heartbeat Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Phillip B [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 12:37 PM Subject: Move ColdFusion 5 to new server I need to move all my web sites and ColdFusion 5 to a new server. Is there an easy way to copy all the settings in IIS, datasources, and ColdFusion or will I need to set everything up from scratch? The current server and the new one are both Win2k.I don't have a lot of time to make the move so I am looking for anything that will speed up the process. Thanks Phillip B. www.LoungeRoyale.com www.FillWorks.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: printer friendly page break?
Is there an easy way to force a page break at certain sections? Use the CSS page-break-before and page-break-after options. Just remember that this is only applicable to the newer browsers, it's a CSS implementation that isn't completely there for any of the early versions of IE or NS that attempt CSS ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Move ColdFusion 5 to new server
Run Forest RUN! ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Phillip B [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 1:06 PM Subject: Re: Move ColdFusion 5 to new server I should have mentioned that I don't have physical access to the servers unfortunately. They are about 300 miles from my desk. Phillip B. www.LoungeRoyale.com www.FillWorks.com - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 2:42 PM Subject: Re: Move ColdFusion 5 to new server Make an image of the exisiting server (Ghost) and you can have the new one up and running in a heartbeat Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Phillip B [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 12:37 PM Subject: Move ColdFusion 5 to new server I need to move all my web sites and ColdFusion 5 to a new server. Is there an easy way to copy all the settings in IIS, datasources, and ColdFusion or will I need to set everything up from scratch? The current server and the new one are both Win2k.I don't have a lot of time to make the move so I am looking for anything that will speed up the process. Thanks Phillip B. www.LoungeRoyale.com www.FillWorks.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: printer friendly page break?
Thanks guys -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 9:10 AM To: CF-Talk Subject: Re: OT: printer friendly page break? http://www.javascriptkit.com/dhtmltutors/pagebreak.shtml I was just doing somethign similar a few minutes ago... Mike - Original Message - From: Mark A. Kruger - CFG [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 10:07 AM Subject: RE: OT: printer friendly page break? Jochem, How about a short example? -mk -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Monday, June 16, 2003 2:22 PM To: CF-Talk Subject: Re: OT: printer friendly page break? Janine Jakim wrote: Is there an easy way to force a page break at certain sections? Use the CSS page-break-before and page-break-after options. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
The washup (long): (was: Update on the Installer Freeze Failure to Auto-Start on W indows Issues...)
Regular listers will no doubt recall the 'discussion' (to use the mildest word I can find) not so long ago about my hosting company who was having difficulty installing Updater3 on the CFMX server that houses many of my own sites and client sites. (For those that don't, a quick recap - read the archives if you need more details: UD3 wasn't being installed, and one of my clients was being affected by one of the bugs in the non-updated CFMX. He wanted it updated and it's a good practice to keep everything up to date anyway. My host Sysadmin was taking his time doing it, and hadn't pushed the right buttons at Macromedia to get the right level of help there. I had written to Macromedia in the US to ask them to help and obviously hadn't written to the right person or picked a day when other things were going on or whatever, because I had no reply after a few hours. But with a Friday running out of afternoon in the US, and the prospect of an angry client by Monday, I needed to stir up activity quickly, so I posted here on the list. Macromedia were extremely rapid to react (more below) and my post provoked many on this list to accuse me of, or imply, many shortcomings on my part or that of my hosting company. The flaming got more and more strident as the hours wore on till finally I said I was not going to post on the subject until it was all over. Now read on ... ) THE HOSTING COMPANY: My only issue with my hosting company is that they hadn't put enough urgency on the fix as I'd needed. I don't know what else they had on their plate at the time, and it doesn't matter to me really. My client and I both needed them to act quicker on it than they were and after my posting here, I lifted my issue on their radar screen. For those who thought I must have a clueless Sysadmin, or a hosting company who cut too many corners, let me say it took Macromedia's people several days to identify this problem and set up to reproduce it. I think while I have a right to expect my Sysadmin to have a working knowledge of all the software installed on the systems he looks after, it is asking a lot to expect him to know what it took Macromedia's specialists several days to identify. MACROMEDIA'S SUPPORT: I am MOST IMPRESSED with Damon Cooper of this list and the TEAM of people he summoned to deal with the issue. They might have been either unaware of the issue or relaxed about the degree of urgency, but once I raised the interest of Damon Cooper, the reaction was both faster and more comprehensive than I could have hoped. They got stuck into the problem, and worked at it like terriers till it was fixed. Many support people in other outfits I've dealt with tend to work like terriers on an issue until the client calms down then slow down or go work on the next panic issue, leaving the basic problem still on the spike waiting to be fixed. Not these guys. They stayed with it till it was solved. All weekend as far as I can see. I assume the results of their efforts will be found in the next release of CFMX.Both my hosting company and I got regular progress updates, including a few we're still working on it, nothing new to report just now reports. And as I understand it, Macromedia's picked up the tab for the whole thing, since it was an installation issue. THE ISSUE: Despite some listers' attempt to convince me otherwise, this was indeed a genuine issue. It was NOT that we had a clueless Sysadmin. It was NOT that I had tried to save too much money and found a hosting company that cut too many corners. It was NOTHING to do with my own installations at home/office/dev servers. It was NOT to do with poor planning on anyone's part. Damon has explained the issue here on the list and it appears to have been a couple of problems working simultaneously. First of all, the servers had 16 colours set, the default for Win2K and had been fine for installations of every CF prior to this update. UD3 requires 256 colours set. (I note that the system requirements now state you have to have 256 colours) Furthermore, this issue has highlighted another problem that had been elusive. As Damon said the other day it was to do with the timeout for JRUN.EXE to start. He said, On machines with a lot going on during startup, or complex services dependencies, or slow machines, the 'jrun.exe' executable can exceed the 20 second timeout in successfully starting. When this timeout is exceeded, the Service wrapper executable gives up, returns a failure code and CFMX is not started. That is why so many people hadn't experienced the problem - if their systems started JRUN.EXE faster than 20 seconds for whatever reason they didn't see the problem. It was a pity that so many people thought because they hadn't had the problem it must be MY fault somehow. In fact they were lucky that they hadn't had the problem emerge on their systems. Anyway, the end result is (a) AFP Webworks now runs its budget hosting
RE: Data getting truncated on select
In CFMX. -- Jillian -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED] Sent: June 17, 2003 1:53 PM To: CF-Talk Subject: RE: Data getting truncated on select - Have you double checked that in the administrator you have long text return enabled? Without that checked of course, it will only return 64,000 characters / whatever value is specified in the text box below. Adminstrative settings in MSSQL or CFMX? -Original Message- From: Jillian Carroll [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 20:42 To: CF-Talk Subject: RE: Data getting truncated on select I see that you may have an answer to your problem from another fellow, but a few suggestions (my problems were with PostgreSQL and MySQL): - Have you double checked that in the administrator you have long text return enabled? Without that checked of course, it will only return 64,000 characters / whatever value is specified in the text box below. - Have you checked your driver? Are you using the native driver for SQL Server 7 that ships with CF? -- Jillian -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED] Sent: June 17, 2003 1:28 PM To: CF-Talk Subject: RE: Data getting truncated on select Using sql server 7. -Original Message- From: Jillian Carroll [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 20:14 To: CF-Talk Subject: RE: Data getting truncated on select John, I have had this problem more than once. Which DBMS are you using? -- Jillian -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED] Sent: June 17, 2003 12:33 PM To: CF-Talk Subject: RE: Data getting truncated on select Yea I understand the problem you had, but I im not using VARCHAR, but TEXT which is fixed at 16 and has max characters of 2,147,483,647 characters. -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 19:23 To: CF-Talk Subject: RE: Data getting truncated on select Last time something like that happened to me I realized that in the stored proc I put in the wrong number of characters id: @MacroName VARCHAR(50) instead of @MacroName VARCHAR(500) -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 1:51 PM To: CF-Talk Subject: Data getting truncated on select Greetings, I am querying a row in a table bringing back a large about of html data from a column named RawData, data type TEXT, When outputting a lot of data is not getting output, this is really strange, But I went into query analyzer and updated the field with a really large text string, data data etc... end on outputting the data it was prove somehow on select its being truncated as end did not get output. My stored proc looks like this, CREATE PROCEDURE leo4_getScheduledData ( @customerID INT, @MacroName VARCHAR(50), @ContainerID INT ) AS SELECT* FROM SchedulesContainer WHERE [EMAIL PROTECTED] AND [EMAIL PROTECTED] AND [EMAIL PROTECTED] any ideas would be appreciated. J ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Application Security in MX
No, imagine you have N applications, but there are all part of uberapp. You would use uberapp as your applicationtoken. As for examples, I _believe_ I have a presentation you can download. Check my blog then my main web site. === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Robert Shaw [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 2:01 PM To: CF-Talk Subject: RE: Application Security in MX Thanks! Do you have an example? I don't see one in the documentation. Is it as simple as applicationtoken=app1,app2? Thanks again, Rob -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 3:54 PM To: CF-Talk Subject: RE: Application Security in MX Use the ApplicationToken attribute for CFLOGIN. This allows you to share them. == == === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Robert Shaw [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 1:17 PM To: CF-Talk Subject: Application Security in MX I'm reviewing the articles on-line regarding CFMX's new security model and it appears the cflogin tag is application specific. We need to have a single login be shared by many applications. What would be the best way to set this up in MX? TIA, Rob _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Data getting truncated on select
Jillian Your a god damn star!! Thank you. Problem is solved. -Original Message- From: Jillian Carroll [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 21:22 To: CF-Talk Subject: RE: Data getting truncated on select In CFMX. -- Jillian -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED] Sent: June 17, 2003 1:53 PM To: CF-Talk Subject: RE: Data getting truncated on select - Have you double checked that in the administrator you have long text return enabled? Without that checked of course, it will only return 64,000 characters / whatever value is specified in the text box below. Adminstrative settings in MSSQL or CFMX? -Original Message- From: Jillian Carroll [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 20:42 To: CF-Talk Subject: RE: Data getting truncated on select I see that you may have an answer to your problem from another fellow, but a few suggestions (my problems were with PostgreSQL and MySQL): - Have you double checked that in the administrator you have long text return enabled? Without that checked of course, it will only return 64,000 characters / whatever value is specified in the text box below. - Have you checked your driver? Are you using the native driver for SQL Server 7 that ships with CF? -- Jillian -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED] Sent: June 17, 2003 1:28 PM To: CF-Talk Subject: RE: Data getting truncated on select Using sql server 7. -Original Message- From: Jillian Carroll [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 20:14 To: CF-Talk Subject: RE: Data getting truncated on select John, I have had this problem more than once. Which DBMS are you using? -- Jillian -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED] Sent: June 17, 2003 12:33 PM To: CF-Talk Subject: RE: Data getting truncated on select Yea I understand the problem you had, but I im not using VARCHAR, but TEXT which is fixed at 16 and has max characters of 2,147,483,647 characters. -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 19:23 To: CF-Talk Subject: RE: Data getting truncated on select Last time something like that happened to me I realized that in the stored proc I put in the wrong number of characters id: @MacroName VARCHAR(50) instead of @MacroName VARCHAR(500) -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 1:51 PM To: CF-Talk Subject: Data getting truncated on select Greetings, I am querying a row in a table bringing back a large about of html data from a column named RawData, data type TEXT, When outputting a lot of data is not getting output, this is really strange, But I went into query analyzer and updated the field with a really large text string, data data etc... end on outputting the data it was prove somehow on select its being truncated as end did not get output. My stored proc looks like this, CREATE PROCEDURE leo4_getScheduledData ( @customerID INT, @MacroName VARCHAR(50), @ContainerID INT ) AS SELECT* FROM SchedulesContainer WHERE [EMAIL PROTECTED] AND [EMAIL PROTECTED] AND [EMAIL PROTECTED] any ideas would be appreciated. J ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
People, I need your opinion!
Hello all, I have a little toy that I designed and developed within last few days (on and off, so, it's hours). I had some assumptions. Mainly data entry and data update types of data manipulation functions is essential to many businesses. So, if my assumption has some validity, some CF shops could save hell lots of time by using this toy for part of their project(s). Please take a look at it at URL, http://68.32.61.40/Test/admin_main.cfm URL parameter of demoDS would provide switch from one datasource to another, e.g. http://68.32.61.40/Test/admin_main.cfm?demoDS=publisherXYZ would switch the application (toy) to the classical publisher database albeit its design sucks. Notes: 1. navigation assistance could be improved; 2. usage documentation could be improved Thanks. Li, Chunshen (Don) your fellow CF developer living in hell for now! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: xpath sum
Tuesday, June 17, 2003, 3:21:00 PM, you wrote: MF jon hall [EMAIL PROTECTED] wrote in message MF news:[EMAIL PROTECTED] This is the error I get. Can not convert #NUMBER to a NodeList! MF Unfortunately xmlSearch() only accept XPath expressions that return a MF NodeList, it throws an error in case the expression returns a string or a MF number. It's not your fault Thanks, that's quite annoying...I really dislike the hack working around this will require. -- jon mailto:[EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
How to share J2EE session with CF MX template? - Continued
Andre and Sean, thank you very much for your prompt reply and helpful pointers. Both examples are very helpful. However, it has not worked yet. Andre, I followed your example, In your JSP/Servlet (Map) session.getAttribute(yourCFApplicationName).put(foo,bar); And then you can access it in a .cfm like this: #session.foo# but, when I try to access attribute in my CFM page, I would get UndefinedElementExceptoin. and I also tried accessing application variable to see if at least that would work. application.setAttribute(yourCFApplicationNam.foo,bar); In you .cfm you access it like this: #application.foo# I would get the same exception when tyring to access it. I used my own variables during the test but followed the exact syntax you outlined. May I ask do you have this working on CFMX and WebLogic 7.0? I contacted Macromedia, and they said that sharing session between JSP/Servlet on WebLogic7.0 with CFMX has a bug, that it is not an issue with WebSphere, that I was the first person to have reported this issue. I find it amazing that I am the only one who has encountered this issue so far, Has anyone else seen this? Sean, The IBM article is very good! I further simplied the example to only 3 classes. but, I am unable to access the attribute in CFM which was set in my JSP either. (obviously, for the same reason). Be happy to provide stackTrace if you are interested. Again, any comments/info on sharing J2EE session in WebLogic 7.0 with CFMX will be greatly appreciated!! While we are on this subject, I am trying to use CFMX and WebLogic 7.0 together to build our web app. Architecture would be CFMs constitute the View tier, Servlets being the Controller, and EJBs being the Model. (if only I could get the CFMs to share session with Servlets). If anyone has experience in building an app using CFMX and WebLogic in a hybrid fashion, could you drop me a line or two letting me know if you liked the experience? thx! Steven Date: 06/05/2003 10:36 AM Author: Andre Mohamed Short Link: http://www.houseoffusion.com/lists.cfm?link=m:4:24562:123485 Unfortunately its not quite as simple as being able to see each others session or application variables in the same way. Request variables can be seen as you would expect. To put a variable into a ColdFusion session you have to do something like this: In your JSP/Servlet (Map) session.getAttribute(yourCFApplicationName).put(foo,bar); And then you can access it in a .cfm like this: #session.foo# Application variables are easier: application.setAttribute(yourCFApplicationNam.foo,bar); In you .cfm you access it like this: #application.foo# The key to remember is that it is all oriented around the application name you defined for your ColdFusion app using cfapplication I believe there is more comprehensive coverage in the cfdocs. Regards, André -Original Message- From: Steve [mailto:[EMAIL PROTECTED] Sent: 05 June 2003 15:07 To: CF-Talk Subject: how to share servlet's session with Cold Fusion MX template? Hello everyone, I deployed ColdFusion MX as a web application to WebLogic7.0. I have a J2EE servlet that invokes a CFM page. This works. However, if I try to set an attribute in the servlet's session, and try to pass that session along to the CFM Page, in the CFM Page, it will NOT understand that attribute. In the CFM page, i have // test forwarding to cfm page. String userArr[] = new String[1]; userArr[0] = Wednesday; HttpSession session = request.getSession(true); session.setAttribute(sess, userArr); getServletConfig().getServletContext().getRequestDispatcher (/test/UserResultForm.cfm).forward(request, response); And in the invoked CFM page, I cfdump the session info with this line, cfdump var=#session# I don't see sess as a valid attribute! in fact, when I try to access it with !--- cfoutput debug : #session.sess#/cfoutput --- ColdFusion would throw an error saying sess is NOT defined. In the Cold fusion Adminstrator, i have certainly turned on Enable Session Variables and Use J2EE session variables flags and restarted the server. and in my application.cfm, I already have the following attributes set, as follows, cfapplication name=form175 SESSIONMANAGEMENT=YES SESSIONTIMEOUT=#CREATETIMESPAN(0,0,30,0)# Thx a lot in advance for any suggestions/examples! Steven - Do you Yahoo!? Free online calendar with sync to Outlook(TM). [Top] [Parent] [Reply] Date: 06/05/2003 12:48 PM Author: Sean A Corfield Short Link: http://www.houseoffusion.com/lists.cfm?link=m:4:24562:123518 On Thursday, Jun 5, 2003, at 07:07 US/Pacific, Steve wrote: I deployed ColdFusion MX as a web application to WebLogic7.0. I have a J2EE servlet that invokes a CFM page. This works. However, if I try to set an attribute in the servlet's session, and try to pass that session along to the CFM Page, in the CFM Page,
Abort long running requests
Hello! For a quite long period of time, coldfusion MX (+Updater three) has been using a lot of CPU resources on our server - the top command shows the following data: CPU: 50.4% running: 702:32 task name: cfusion The whole server is working properly (also coldfusion is serving pages as expected, although slower than normal). In the coldfusion administrator, the option to end processes after 240 seconds is enabled. The server.log does not show any very, very long running templates. My questions: - Is there a tool to show which templates are currently processed by the coldfusion mx server in order to find out which call takes such a long time? - Can I abort a single thread (f.e. using kill plus the PID of this task) so that I do not need to restart the whole coldfusion server? (loose of sessions ...) - Are there any known bugs that the abort requests after taking xxx seconds feature does not work as expected? Best regards, Peter ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re:_Recurring_Billing_Systems
Hello! Worldpay offers something that might fullfill your needs: http://www.worldpay.com/usa/products_services/billing.shtml Best regards, Peter Originale Nachricht Von: Duane Boudreau Betreff: Recurring Billing Systems Datum/Zeit: Dienstag, 17. Juni 2003 20:29:07 Hi All, We are doing an ecom site for a company that needs to support: 1) subscription based (open ended) 2) one time price 3) payments spread over several payment periods Can anyone give me some suggestions for reputable payment gateways that can handle all of the above? Of course the gateway must have a CF interface and a Virt Terminal. TIA, Duane ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
