Blue dragon installation issues

2003-06-17 Thread Ryan Mitchell
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

OT: SQL problem

2003-06-17 Thread Hugo Ahlenius
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

Re: OT: SQL problem

2003-06-17 Thread S . Isaac Dealey
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

RE: SQL problem

2003-06-17 Thread Tyagi, Badal
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

RE: OT: SQL problem

2003-06-17 Thread Hugo Ahlenius
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

Re: OT: SQL problem

2003-06-17 Thread Jochem van Dieten
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,

RE: OT: SQL problem

2003-06-17 Thread Gunther Ahamer
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

RE: OT: SQL problem

2003-06-17 Thread Hugo Ahlenius
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... ?

RE: OT: SQL problem

2003-06-17 Thread Gunther Ahamer
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

RE: OT: SQL problem

2003-06-17 Thread S . Isaac Dealey
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

Re: OT: SQL problem

2003-06-17 Thread S . Isaac Dealey
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

Re: OT: SQL problem

2003-06-17 Thread Jochem van Dieten
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

Re: OT: SQL problem

2003-06-17 Thread Jochem van Dieten
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

Re: MS AD

2003-06-17 Thread Michael T. Tangorre
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:

Re: MS AD

2003-06-17 Thread Michael T. Tangorre
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

RE: MS AD

2003-06-17 Thread Robertson-Ravo, Neil (RX)
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:

Custom Tag for tif files.

2003-06-17 Thread Michael T. Tangorre
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:

RE: Blue dragon installation issues

2003-06-17 Thread Yves Arsenault
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

How many tables per datasource?

2003-06-17 Thread Blood Python
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

RE: How many tables per datasource?

2003-06-17 Thread Robertson-Ravo, Neil (RX)
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

Test for me

2003-06-17 Thread Matthew Small
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 ~|

CFMX Server Errors :(

2003-06-17 Thread Critz
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

RE: How many tables per datasource?

2003-06-17 Thread Adam Wayne Lehman
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

Re: CFMX Server Errors :(

2003-06-17 Thread Critz
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

RE: MS AD

2003-06-17 Thread Shahzad.Butt
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]

SOT: ASP equivalent to CF server variables?

2003-06-17 Thread Lofback, Chris
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?

RE: ASP equivalent to CF server variables?

2003-06-17 Thread Scott Wilhelm
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

RE: Blue dragon installation issues

2003-06-17 Thread Vince Bonfanti
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

RE: ASP equivalent to CF server variables?

2003-06-17 Thread Lofback, Chris
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

RE: CFMX Server Errors :(

2003-06-17 Thread Stephenie Hamilton
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:

RE: OT: printer friendly page break?

2003-06-17 Thread Mark A. Kruger - CFG
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

SQL float format

2003-06-17 Thread Hugo Ahlenius
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.

RE: OT: printer friendly page break?

2003-06-17 Thread Bryan F. Hogan
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?

Re: OT: printer friendly page break?

2003-06-17 Thread Michael T. Tangorre
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

Re: CFMX Server Errors :(

2003-06-17 Thread Jochem van Dieten
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

Re: How many tables per datasource?

2003-06-17 Thread Jochem van Dieten
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

Re: OT: printer friendly page break?

2003-06-17 Thread Jochem van Dieten
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:

Accessing fragment ID from URL?

2003-06-17 Thread Howard Fore
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

RE: Accessing fragment ID from URL?

2003-06-17 Thread Adrian Lynch
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

Re: Accessing fragment ID from URL?

2003-06-17 Thread Howard Fore
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

Re: SOT: SQL Question - Could CF make this easier?

2003-06-17 Thread [EMAIL PROTECTED]
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

Re: CFMX Server Errors :(

2003-06-17 Thread Critz
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...

Log files in MX

2003-06-17 Thread Ciliotta, Mario
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.

RE: Accessing fragment ID from URL?

2003-06-17 Thread Dave Wilson
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.

Re: How many tables per datasource?

2003-06-17 Thread John Paul Ashenfelter
- 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

RE: Log files in MX

2003-06-17 Thread Stephenie Hamilton
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

Re: SQL float format

2003-06-17 Thread John Paul Ashenfelter
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

Re: SQL float format

2003-06-17 Thread CF Dude
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 [

Re: Accessing fragment ID from URL?

2003-06-17 Thread Howard Fore
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

OT: SQL problem

2003-06-17 Thread Don Li
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');

RE: Accessing fragment ID from URL?

2003-06-17 Thread Dave Wilson
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,

Re: OT: SQL problem

2003-06-17 Thread S . Isaac Dealey
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

OT: JXP Files

2003-06-17 Thread cfhelp
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

Re: Dreamweaver MX -- grayed out component tab

2003-06-17 Thread Jamie Jackson
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: Accessing fragment ID from URL?

2003-06-17 Thread Jim Davis
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

Blue dragon installation issues

2003-06-17 Thread Damon Cooper
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

Re: Dreamweaver MX -- grayed out component tab

2003-06-17 Thread Jamie Jackson
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

Web-based telnet client?

2003-06-17 Thread Jim McAtee
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

RE: Web-based telnet client?

2003-06-17 Thread Costas Piliotis
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

Re: Web-based telnet client?

2003-06-17 Thread Michael T. Tangorre
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

RE: Data getting truncated on select

2003-06-17 Thread Janine Jakim
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:

RE: Web-based telnet client?

2003-06-17 Thread cfhelp
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

Changing a session timeout based on login

2003-06-17 Thread James Johnson
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

Re: Accessing fragment ID from URL?

2003-06-17 Thread Howard Fore
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,

Odd CFFTP file/dir path issues

2003-06-17 Thread Scott Weikert
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

RE: Accessing fragment ID from URL?

2003-06-17 Thread Dave Watts
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

xpath sum

2003-06-17 Thread jon hall
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

RE: Data getting truncated on select

2003-06-17 Thread Bryan Love
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. +---+

Re: Web-based telnet client?

2003-06-17 Thread CF Dude
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

RE: Data getting truncated on select

2003-06-17 Thread Jillian Carroll
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,

Re: xpath sum

2003-06-17 Thread Massimo Foti
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

Re: xpath sum

2003-06-17 Thread Massimo, Tiziana e Federica
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

RE: Data getting truncated on select

2003-06-17 Thread John McCosker
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-

RE: Data getting truncated on select

2003-06-17 Thread John McCosker
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?

RE: Data getting truncated on select

2003-06-17 Thread Jerry Johnson
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

RE: Data getting truncated on select

2003-06-17 Thread John McCosker
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

RE: Data getting truncated on select

2003-06-17 Thread John McCosker
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

Re: Web-based telnet client?

2003-06-17 Thread Jim McAtee
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

Move ColdFusion 5 to new server

2003-06-17 Thread Phillip B
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

Application Security in MX

2003-06-17 Thread Robert Shaw
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

Re: Move ColdFusion 5 to new server

2003-06-17 Thread Bryan Stevenson
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] -

RE: Data getting truncated on select

2003-06-17 Thread Jillian Carroll
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

RE: Move ColdFusion 5 to new server

2003-06-17 Thread Pete Freitag
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:

App Migration CF5 - CFMX

2003-06-17 Thread Jeff Chastain
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

how to share servlet's session with Cold Fusion MX template?

2003-06-17 Thread Steven Xu
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

RE: Application Security in MX

2003-06-17 Thread Raymond Camden
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

RE: Data getting truncated on select

2003-06-17 Thread John McCosker
- 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

Re: Move ColdFusion 5 to new server

2003-06-17 Thread Phillip B
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

RE: OT: printer friendly page break?

2003-06-17 Thread Philip Arnold
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

Re: Move ColdFusion 5 to new server

2003-06-17 Thread Bryan Stevenson
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

RE: OT: printer friendly page break?

2003-06-17 Thread Mark A. Kruger - CFG
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

The washup (long): (was: Update on the Installer Freeze Failure to Auto-Start on W indows Issues...)

2003-06-17 Thread Mike Kear
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

RE: Data getting truncated on select

2003-06-17 Thread Jillian Carroll
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

RE: Application Security in MX

2003-06-17 Thread Raymond Camden
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.

RE: Data getting truncated on select

2003-06-17 Thread John McCosker
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

People, I need your opinion!

2003-06-17 Thread LI, Chunshen \(Don\)
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

Re: xpath sum

2003-06-17 Thread jon hall
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

How to share J2EE session with CF MX template? - Continued

2003-06-17 Thread Steve
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

Abort long running requests

2003-06-17 Thread Peter Mayer
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

Re:_Recurring_Billing_Systems

2003-06-17 Thread Peter Mayer
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

  1   2   >