Re: Some database questions

2004-10-08 Thread Marcus Whitworth
Hi Chris, 1.It depends what dbms you're using. If you're using an enterprise system like SQL Server, then you'd be talking billions. If you're using something like Access on the other hand... who really knows with that. Better to estimate on the smaller end of the scale though. I have one SQL

Re: CPU Utilization on CF5

2004-10-08 Thread Michael Traher
disable the CFERROR tags so that errors are handled in default manner and then have a very close look at your error templates. On Thu, 7 Oct 2004 15:24:55 -0600, Scott Brady [EMAIL PROTECTED] wrote: On Thu, 7 Oct 2004 22:15:53 +0100, Michael Traherwrote: Something that has caught us from time

Re: XML Loop problem.

2004-10-08 Thread Britta Bennett
Thanks James! This example gave me the info I needed to get up and running.. Very useful, I really appreciate it! http://www.macromedia.com/devnet/mx/coldfusion/articles/xmlxslt.pdf [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and

Re: XML Loop problem.

2004-10-08 Thread Britta Bennett
I got it solved with all your help!Thanks again, you've saved my life.. I'm now actually going to have a weekend! Cheers, Britta [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: exception handling, kindly help

2004-10-08 Thread cf coder
Thank you guys for replying to my thread. Ewok I tried your code, but still don't get back a empty error structure cftry cfcatch type=any cfdump var=#error# !--- I want to see what is returned in this structure --- cfabort cf_caughtIt catchMessage=#cfcatch.message# /cfcatch /cftry

Errors on pushFile code block with search engine bots.

2004-10-08 Thread Nando
I've been using this code block for a long time to push downloadables to users: cfset filename=chr(34) attributes.file chr(34) cfprocessingdirective suppresswhitespace=Yescfheader name='content-disposition' value=attachment; filename=#filename#cfcontent type=application/unknown

IIS 6.0 HTTP/1.1 - 1.0 Problem!!

2004-10-08 Thread rob.stokes
Morning all, A group of users are accessing one of our sites behind a firewall, and the said site has recently been moved to a cfmx server on IIS 6. They access through a 'SRP' server which sends all requests with a HTTP/1.0 header, but our new server does not seem to like this and responds with

Re: exception handling, kindly help

2004-10-08 Thread cf coder
I'm sorry I made a typo mistake in my last post. What I meant was that the error structure is empty when I try to dump it [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

RE: exception handling, kindly help

2004-10-08 Thread Pascal Peters
AFAIK the error scope only exists in an error template, not in a try/catch block. There is a cfcatch scope for try/catch (but I think you can't dump it anymore with the latest CFMX updater) Pascal -Original Message- From: cf coder [mailto:[EMAIL PROTECTED] Sent: 08 October 2004 11:10

RE: Need FAST XML to CF Tag

2004-10-08 Thread Craig Dudley
This should give you enoguh to go on... cfhttp method=GET url=""> 1mxrw=50/cfhttp cfset myXMLDocument=XmlParse(cfhttp.filecontent) cfdump var=#myXMLDocument.ResidentialProperty# hr cfloop from=#myXMLDocument.ResidentialProperty.QueryStatistics.startRow.xmlTex t#

Urgent:coldfusion report

2004-10-08 Thread vishnu prasad
Hi All i have a prblme in a displaying a report Table username username dep_code -- testuser Sal,Pur testuser1 sal,Acc testuser3 acc,pur TAble department dpet_id Name --- Sal Sales Department Pur Purchace Department ACC Accounts Department in

Re: Some database questions

2004-10-08 Thread Jochem van Dieten
Chris Johnston wrote: 1. When does a database get too big When its size hinders your ability to manage and use it efficiently. 2. Are there any rules out there for splitting a database? There are rules, or guidelines really, for how to organize java programs into packages and rules for

RE: Urgent:coldfusion report

2004-10-08 Thread Pascal Peters
You shouldn't have a list in the username table, but you should create a related table: Table User (user_id,username) Table UserDpt (user_id,dpt_id) Table Dpt (dpt_id,dptname) With the appropriate PK, FK and relational integrity set up. Then SELECT u.username, d.dptname FROM User u, UserDpt

Re: CFMX 61 - J2EE Configuration

2004-10-08 Thread Greg Stewart
Here's a little snippet that I used to determine the version of drivers: cfscript jdbcDriver = CreateObject(java, macromedia.jdbc.sqlserver.SQLServerDriver); writeoutput(jdbcDriver.getMajorVersion() . jdbcDriver.getMinorVersion()); /cfscript Cheers G On Thu, 7 Oct 2004 15:43:27 -0400, Dave

cfexecute cmd.exe

2004-10-08 Thread Robertson-Ravo, Neil (RX)
Anyone managed to successfully run a DIR or any command from cmd.exe via cfexecute on MX?I can run the page but it just returns a blank page and /or file depending if I choose a variable or output to file. Any help mucho appreciato. N This e-mail is from Reed Exhibitions (Oriel House, 26 The

Re: Urgent:coldfusion report

2004-10-08 Thread vishnu prasad
Hi i cannot change the DB design ,i have to do with the current DB Structure noproblem if the query take time ,without using cfqueryparam i am using 4.5 so i cannot use cfqueryparam regards Vishnu Prasad You shouldn't have a list in the username table, but you should create a related table:

RE: Urgent:coldfusion report

2004-10-08 Thread Pascal Peters
Why can't u use cfqueryparam. I still have a server running 4.5 and cfqueryparam works just fine. Something like this: cfquery datasource=#request.dsn# name=qUsers SELECT username, dep_code FROM username WHERE ',' + dep_code + ',' LIKE cfqueryparam cfsqltype=cf_sql_varchar

RE: Urgent:coldfusion report

2004-10-08 Thread Pascal Peters
If you want to know what tags ( attributes) or functions you can use in the different versions of CF (starting from CF4): http://www.macromedia.com/support/coldfusion/ts/documents/cfmlhistory.ht m Pascal -Original Message- From: vishnu prasad [mailto:[EMAIL PROTECTED] Sent: 08

Re: cfexecute cmd.exe

2004-10-08 Thread Jochem van Dieten
Robertson-Ravo, Neil (RX) wrote: Anyone managed to successfully run a DIR or any command from cmd.exe via cfexecute on MX? Yes, no problem: cfexecute name=c:\winnt\system32\cmd.exe arguments=/C netstat -n timeout=5 /cfexecute Jochem [Todays Threads] [This Message] [Subscription]

RE: Errors on pushFile code block with search engine bots.

2004-10-08 Thread Dave Watts
Anyone have a take on this? An intelligent solution? Should i be filtering the download process to exclude the search engines? You should use robots.txt to specify which URLs to exclude. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays

RE: cfexecute cmd.exe

2004-10-08 Thread Dave Watts
Anyone managed to successfully run a DIR or any command from cmd.exe via cfexecute on MX?I can run the page but it just returns a blank page and /or file depending if I choose a variable or output to file. I've done that successfully. However, oddly enough, yesterday one of our clients had

RE: IIS 6.0 HTTP/1.1 - 1.0 Problem!!

2004-10-08 Thread Dave Watts
A group of users are accessing one of our sites behind a firewall, and the said site has recently been moved to a cfmx server on IIS 6. They access through a 'SRP' server which sends all requests with a HTTP/1.0 header, but our new server does not seem to like this and responds with a

Re: Urgent:coldfusion report

2004-10-08 Thread vishnu prasad
Hi i need an SQL Query cos i am building report in Crystal report so i cant have structure and cfqueryparam it would be niceif i canit in SQL query regards vishnu If you want to know what tags ( attributes) or functions you can use in the different versions of CF (starting from CF4):

RE: Urgent:coldfusion report

2004-10-08 Thread Pascal Peters
With that DB design, I don't think you can. If you need sql only, change the db structure. -Original Message- From: vishnu prasad [mailto:[EMAIL PROTECTED] Sent: 08 October 2004 14:40 To: CF-Talk Subject: Re: Urgent:coldfusion report Hi i need an SQL Query cos i am building

RE: Urgent:coldfusion report

2004-10-08 Thread Mark A Kruger
Vishnu, You can simply remove the cfqueryparam in the query that has been suggested to you and use single quotes (for character data). It's not really relevant to your problem (although it is good practice when using CF).However, if you are looking for a report query for Crystal - then it is

RE: CFCONTENT and GetPageContext()

2004-10-08 Thread Hugo Ahlenius
Alex, Have you checked the headers? Could it be that the pdf-file is displayed as a text/html resource (use cfheader to set the correct header) -- Hugo Ahlenius - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8

RE: cfexecute cmd.exe

2004-10-08 Thread Robertson-Ravo, Neil (RX)
Nothing seems to workeither this: cfexecute name=C:\Windows\System32\cmd.exe arguments=DIR c:\ variable=foo cfdump var=#foo# /cfexecute Or cfexecute name=C:\Windows\System32\cmd.exe arguments=DIR c:\ outputfile=c:\foo.txt cfdump var=#foo# /cfexecute Yields any results..? _

Re: exchange server

2004-10-08 Thread Richard Meredith-Hardy
Mail back on after 16 hours... As it happens I found that Forta's book covers ES for all it's LDAP examples so I am much clearer about what I am trying to achieve now. Thanks everyone! James Holmes wrote: I agree here - Exchange 2003 uses AD info as its GAL, so the best way to get the

Re: Some database questions

2004-10-08 Thread Chris Johnston
On Fri, 08 Oct 2004 13:08:24 +0200, Jochem van Dieten [EMAIL PROTECTED] wrote: 2. Are there any rules out there for splitting a database? There are rules, or guidelines really, for how to organize java programs into packages and rules for normalizing a database, but are there any rules

Re: Where Art Thou, Error-Handling CFC?

2004-10-08 Thread Steve Bryant
By coincidence, I was just working on something similar to this. It is pretty simple, but maybe it will help you or someone else. http://www.bryantwebconsulting.com/cftags/ErrorCFC.htm I would love any suggestions anyone has to improve it as well. Steve I'm looking for an error-handling cfc.I

Re: cfexecute cmd.exe

2004-10-08 Thread Jochem van Dieten
Robertson-Ravo, Neil (RX) wrote: Nothing seems to workeither this: cfexecute name=C:\Windows\System32\cmd.exe arguments=DIR c:\ variable=foo cfdump var=#foo# /cfexecute You need /C as the first argument to cmd.exe, it tells cmd to close after running: cfexecute

RE: cfexecute cmd.exe

2004-10-08 Thread Mark A Kruger
Put it in a .bat file and run the .bat. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Friday, October 08, 2004 8:34 AM To: CF-Talk Subject: RE: cfexecute cmd.exe Nothing seems to workeither this: cfexecute name=C:\Windows\System32\cmd.exe

Re: Some database questions

2004-10-08 Thread Jochem van Dieten
Chris Johnston wrote: On Fri, 08 Oct 2004 13:08:24 +0200, Jochem van Dieten wrote: Split your databases in schemas based on a logical grouping of the data. Group financial information in one schema, group employee information in another schema, product information in another one etc.

Re: Urgent:coldfusion report

2004-10-08 Thread Don
To rephrase Pascal Peters's words, the username table does not even pass 1NF to begin with, re-design the db, imho. Hi All i have a prblme in a displaying a report Table username username dep_code -- testuser Sal,Pur testuser1 sal,Acc testuser3

Re: CPU Utilization on CF5

2004-10-08 Thread Scott Brady
On Fri, 8 Oct 2004 08:56:29 +0100, Michael Traherwrote: disable the CFERROR tags so that errors are handled in default manner and then have a very close look at your error templates. Actually, when I'm looking for away to fix it I specifically mean to stop CFserver from utilizing 99% CPU on the

Re: CPU Utilization on CF5

2004-10-08 Thread Dave Francis
We've had something similar when trying to run SQL Server and CF5 on the same box. - Original Message - From: Scott Brady To: CF-Talk Sent: Friday, October 08, 2004 11:40 AM Subject: Re: CPU Utilization on CF5 On Fri, 8 Oct 2004 08:56:29 +0100, Michael Traherwrote: disable the CFERROR

Re: CPU Utilization on CF5

2004-10-08 Thread Scott Brady
On Fri, 8 Oct 2004 11:46:27 -0400, Dave Franciswrote: We've had something similar when trying to run SQL Server and CF5 on the same box. Good idea. But, ours is on a different box. It's unfortunate our current host is so clueless about CF, because they're really no help at all. Scott --

CFCONTENT and PDFs (Re: CFCONTENT and GetPageContext())

2004-10-08 Thread Adrian Moreno
Greetings. Anyone run into problems with using GetPageContext().Include()and CFCONTENT to serve, say a PDF file, on the same page. I'm having a similar problem. I'm almost positive it's a security fix in MSIE. The main function of the application I'm building is to create and present PDF

MS SQL Server next rowID

2004-10-08 Thread Russ
Is there a way to get the ID of the next record that will be inserted into the database?And I don't mean max(tableID)+1, because some records could get deleted and the next row is not necessarily going ot be max(tableID) + 1. Russ [Todays Threads] [This Message] [Subscription] [Fast

RE: CPU Utilization on CF5

2004-10-08 Thread Mark A Kruger
Scott, I have a batch file you can run periodically - as well as a few tips on how to solve that bug.Mostly you want make sure that there is no code that can throw an error INSIDE the cfmail tag. cfmail--- don't put code that can throw errors here/cfmail- especially when looping or using a

CFMX and XML

2004-10-08 Thread John Stanley
Can anyone point me to a good resource on XML and CFML, specifically on setting up to receive an outside XML transmission? Conceptually I'm a bit confused as to how to go about doing this. I am familiar with sending XML, and parsing the cfhttp.filecontent, and am setting up a page that will parse

cftree cftreeitem CF5 vs CFMX61

2004-10-08 Thread Francine Kalonji
We have just upgradred CF5 to CFMX61. One of our applications is using cftree and cftreeitem. The code did not change; in CF5 the tree displays properly but in CFMX61, some leaf-nodes are added at the end of the tree. I read the documenation and some of the comments of the forums but I have not

Re: Some database questions

2004-10-08 Thread Chris Johnston
On Fri, 08 Oct 2004 15:50:52 +0200, Jochem van Dieten [EMAIL PROTECTED] wrote: Okay, this makes sense. A follow up question though; can you create foreign key relationships across schemas in either Oracle and/or PostgreSQL? Yes, in both. Cool, thanks. A quick follow up question

Re: exception handling, kindly help

2004-10-08 Thread cf coder
Hi there, sorry for not getting back sooner. I've been banging my head trying to find a solution ALL day. I would really appreciate your help. I have added the custom error message in the error handler file. cfcatch type=any cf_caughtIt catchMessage=#cfcatch.message# /cfcatch I modified

Urgent : problem with Client Variables.

2004-10-08 Thread David Manriquez
Hi there : please anyone solved this issue? I have clients variables that i want to delete but usign the deleteclientvariable or using a query to delete direct from the database( where my clients vars are stored ) but the f... variable is still there.. variables likeclient.foo are

Re: Urgent : problem with Client Variables.

2004-10-08 Thread Dave Carabetta
On Fri, 8 Oct 2004 13:41:59 -0400, David Manriquez [EMAIL PROTECTED] wrote: Hi there : please anyone solved this issue? I have clients variables that i want to delete but usign the deleteclientvariable or using a query to delete direct from the database( where my clients vars are stored )

RE: exception handling, kindly help

2004-10-08 Thread Mark A Kruger
Nope... if the cfcatch tag is on your error handling template then it will never catch anything. The code you have below would throw an error without the cftry tags.There is no error thrown on the error handler.Instead the error thrown on the previous request is posted to the error page as the

Re: exception handling, kindly help

2004-10-08 Thread cf coder
thanks Mark, the cfcatch tags are wrapped inside a cftry block, I didn't post it because I thought it wasn't necessary. And secondly the cfcatch tag is not in the error handler page, its on a file where the error has occurred. cfdump var=#error# throws an error and that's because as Pascal

RE: Urgent : problem with Client Variables.

2004-10-08 Thread David Manriquez
Sure this is my code , to try 1.-, get all client variables from the CDATA 2.-then look for that variableslikeclient.foo1.foo2 3.- delete client variables from the CDATA nad put it again without the client.foo1.foo2 variables looks like. cfquery name=sel_client datasource=cfvariables select *

Re: exception handling, kindly help

2004-10-08 Thread cf coder
do you know as to why it would throw a COM object error? If so do you know if there is a fix? I have seen instances where this variable is empty.I believe it was related to a COM object error.I could be wrong about the exact variable that didn't exist, but I remember that a cfcatch variable was

scheduling pages

2004-10-08 Thread Coleman, Brian
I have a page that needs scheduling and may take something like 2 ½ to 3 hours to complete. I could break this same page down into 11-12 smaller pages and schedule them individually; it would probably take similar time for the entire process. Does anyone know if it's better to have shorter jobs

RE: scheduling pages

2004-10-08 Thread Burns, John D
Why does it take that long? Perhaps CF is not the best choice for this type of a process.Make sure you're using the right tool for the job.Just because you have a hammer and know how to use a hammer doesn't make the hammer the best for putting a screw in.It might be worth taking the time to learn

SQL stored procedure question

2004-10-08 Thread Pratte, Jeff
OK, after hearing everybody say don't use Access and an converting my Check Request System to MS SQL Server. And I am trying to use Stored Procedures. However, I am finding it more difficult then I anticipated. For instance, I used to have a query like this: cfquery Name=qrySignoffRequest

RE: Urgent : problem with Client Variables.

2004-10-08 Thread Dave Watts
I have clients variables that i want to delete but usign the deleteclientvariable or using a query to delete direct from the database( where my clients vars are stored ) but the f... variable is still there.. variables likeclient.foo are deleted , but variables like client.contract.id

RE: scheduling pages

2004-10-08 Thread Coleman, Brian
It's going through user directories and deleting a certain folder + files + subfolders. I could do it with VBscript I think, but I haven't learned it :-( I'm not really sure on how long it will take but my test was on about 45 users and it took around 3 minutes. In the long run I'm probably

RE: Urgent : problem with Client Variables.

2004-10-08 Thread David Manriquez
Yeah i know CFMX cant create complex variables in client Scope. but this variables are created without any warning or error throw by coldfusion Compiler. cfset client.contract.id = foo is a valid client variable This behaviorcreate this kind of variables and then you cannot delete is not

RE: Some database questions

2004-10-08 Thread Dawson, Michael
You can perform queries across schemas regardless of having foreign keys.They have nothing to do with each other. From: Chris Johnston [mailto:[EMAIL PROTECTED] Sent: Friday, October 08, 2004 12:29 PM To: CF-Talk Subject: Re: Some database questions On

RE: exception handling, kindly help

2004-10-08 Thread Dawson, Michael
There are numerous reasons why a COM error would be thrown: 1. COM object is not registered on the server. 2. COM object is spelled differently than what is in your code. 3. You called a method that didn't exist. 4. You called a method w/o the correct arguments.

RE: scheduling pages

2004-10-08 Thread Dawson, Michael
This sounds like a better job for the File System Object (fso) and a Windows Scripting Host (wsh) script using VBScript. From: Coleman, Brian [mailto:[EMAIL PROTECTED] Sent: Friday, October 08, 2004 1:13 PM To: CF-Talk Subject: RE: scheduling pages It's

Re: CPU Utilization on CF5

2004-10-08 Thread Scott Brady
On Fri, 8 Oct 2004 12:24:35 -0500, Mark A Krugerwrote: Scott, I have a batch file you can run periodically - as well as a few tips on how to solve that bug.Mostly you want make sure that there is no code that can throw an error INSIDE the cfmail tag. cfmail--- don't put code that can throw

RE: exception handling, kindly help

2004-10-08 Thread Mark A Kruger
ok... I'll run off and chase someone else's red herring now (ha). -mark -Original Message- From: cf coder [mailto:[EMAIL PROTECTED] Sent: Friday, October 08, 2004 12:55 PM To: CF-Talk Subject: Re: exception handling, kindly help thanks Mark, the cfcatch tags are wrapped inside a cftry

Re: Urgent : problem with Client Variables.

2004-10-08 Thread Dave Carabetta
On Fri, 8 Oct 2004 14:19:20 -0400, David Manriquez [EMAIL PROTECTED] wrote: Yeah i know CFMX cant create complex variables in client Scope. but this variables are created without any warning or error throw by coldfusion Compiler. cfset client.contract.id = foo is a valid client variable

Re: CPU Utilization on CF5

2004-10-08 Thread Bob Haroche
I'm late to the thread, but I used to have 100% cpu problems with CF 5 on my workstation. Traced it to a javaNT.exe (I believe) taking up all the resources. (check task manager to see what's running). That led me to discover a documented bug with CF 5 log files IIRC. Macromedia posted a fix for

RE: scheduling pages

2004-10-08 Thread Burns, John D
Could you use a batch script to do the deleting (if you think that's the time consuming portion) and then just have CF fire off and make the batch script run. Maybe that would help with the time.A 2+ hour web script just doesn't sound like a good idea. John -Original Message- From:

RE: SQL stored procedure question

2004-10-08 Thread Mark A Kruger
Jeff, Not every query or block of code is a good choice for a stored procedure. Stored procedures are only ONE reason to move off of access. The first query is not working because of a datatype mismatch but it's not obvious where it resides from just looking at the query (which looks fine). As

RE: Urgent : problem with Client Variables.

2004-10-08 Thread Burns, John D
I think what Dave Watts was saying was that when you do client.contract.id, CF actually creates a structure named client.Thus, that variable is not really a client variable, just a variable within a structure called client.Maybe you can use structDelete() to get rid of it. John -Original

RE: CPU Utilization on CF5

2004-10-08 Thread Mark A Kruger
Bob, Are you talking about the CFAM service?Java repository loggin? -Mark -Original Message- From: Bob Haroche [mailto:[EMAIL PROTECTED] Sent: Friday, October 08, 2004 1:50 PM To: CF-Talk Subject: Re: CPU Utilization on CF5 I'm late to the thread, but I used to have 100% cpu problems

RE: CFMX and XML

2004-10-08 Thread John Stanley
Doh! I had never used GetHttpRequestData beforeso.problem solved -Original Message- From: John Stanley Sent: Friday, October 08, 2004 1:25 PM To: '[EMAIL PROTECTED]' Subject: CFMX and XML Can anyone point me to a good resource on XML and CFML, specifically on setting up

Re: CPU Utilization on CF5

2004-10-08 Thread Bob Haroche
Are you talking about the CFAM service?Java repository loggin? I think so. I no longer use CF 5 and I dumped my notes on the problem, but I found this tech note which sounds familiar: http://www.macromedia.com/support/coldfusion/ts/documents/tn18000.htm - Regards, Bob Haroche O n P

RE: Urgent : problem with Client Variables.

2004-10-08 Thread David Manriquez
yeah could be , but i have enabled the Debuggingin the Coldfusion Administrator and see in the client variables sections my vars.. and i use it like any other clients vars... pasting from a page in my site.. ( this is a part of debugging information ). Client Variables: apellido_cliente=SARANITI

Re: CPU Utilization on CF5

2004-10-08 Thread Scott Brady
On Fri, 8 Oct 2004 11:49:53 -0700, Bob Harochewrote: Scott, do you know what according to task manager is hogging resources? It's CFserver.exe. Scott -- - Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast

RE: Urgent : problem with Client Variables.

2004-10-08 Thread Dave Watts
Yeah i know CFMX cant create complex variables in client Scope. but this variables are created without any warning or error throw by coldfusion Compiler. cfset client.contract.id = foo is a valid client variable Just because the compiler lets you do something, doesn't mean that it's valid

RE: Urgent : problem with Client Variables.

2004-10-08 Thread Burns, John D
Interesting.Though, it may display that way, but that still doesn't mean that the underlying structure is storing it as a client.I'm no expert on this, but Dave Watts is usually right on the in-depth workings of CF.It could just be the way that the debugging tag is written.Anyway, I'd go with the

RE: SQL stored procedure question

2004-10-08 Thread Gaulin, Mark
Stored procedures don't work the way you are expecting them to work, and you are discovering. When you're using cfquery you can use cf variables and cf logic to build a sql statement, and when the statement is all built it goes to the sql server (or access, or whatever) and then it's run.That

OT: Qforms help

2004-10-08 Thread Jim Louis
I know this is OT but I am in a little bit of a jam. I am tring to create a dependency to a field that contains a number and it does not do anything. Here is the qform code: objForm.Nam_CCtype.createDependencyTo(Nam_total, 60); objForm.Nam_CCNumber.createDependencyTo(Nam_total, 60);

SOT: How to suppress the Header and Footer info when printing fr om a browser

2004-10-08 Thread Ciliotta, Mario
Hi, I was wondering if anyone knows how to suppress the header and footer information that is printed out when you try to print a page from the browser. I would like to shut off the page title and the 1 of 3 on the header and also the URL on the footer. Can this be done with a stylesheet?

RE: How to suppress the Header and Footer info when printing fr om a browser

2004-10-08 Thread Burns, John D
I've tried that and it's a very in depth process.Your best bet would be to convert to PDF and then print. Forcing the browser to behave a certain way is more trouble than it's worth. John -Original Message- From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] Sent: Friday, October 08, 2004

OT: Friday Goodies - ASP.NET Webcast and a chance to Win Visual Studio

2004-10-08 Thread Qasim Rasheed
From October 18 - 29, Microsoft will offer a series of 40 live ASP.NET developer training Webcasts. The Webcasts are free and anyone who attends three or more can sign up to receive a free copy of Visual Studio .NET 2003 Standard Edition and a book on ASP.NET development. Details here

Re: SOT: How to suppress the Header and Footer info when printing fr om a browser

2004-10-08 Thread Damien McKenna
The best way is to do your page layouts using CSS, then have a print-media CSS file that reformats your content as needed.This is what I'll be doing next-week on our main site as right now it doesn't print well on IE (its fine on Firefox though :) ).Basically, duplicate your main CSS file and

Re: SOT: How to suppress the Header and Footer info when printing fr om a browser

2004-10-08 Thread Dave Carabetta
On Fri, 08 Oct 2004 17:02:49 -0400, Damien McKenna [EMAIL PROTECTED] wrote: The best way is to do your page layouts using CSS, then have a print-media CSS file that reformats your content as needed.This is what I'll be doing next-week on our main site as right now it doesn't print well on IE

Re: How to suppress the Header and Footer info when printing fr om a browser

2004-10-08 Thread Donna French
Is this something you want to turn off to print for yourself - or you want to disable for users in general? On Fri, 8 Oct 2004 16:53:33 -0400, Burns, John D [EMAIL PROTECTED] wrote: I've tried that and it's a very in depth process.Your best bet would be to convert to PDF and then print. Forcing

Re: SOT: How to suppress the Header and Footer info when printing fr om a browser

2004-10-08 Thread Damien McKenna
Dave Carabetta wrote: That's not what he's trying to accomplish though. What you've noted above only deals with suppressing elements in your HTML. He wants to turn off the header/footer information that a browser automatically adds to a printout (URL, page numbers, etc.), which you can't do.

Re: OT: Friday Goodies - ASP.NET Webcast and a chance to Win Visual Studio

2004-10-08 Thread Donna French
...signed up yesterday but didn't know if anyone on the CF list would be interested or not... I wish I could find a ASP or VB .NET email list half as good as this one! ~ Donna On Fri, 8 Oct 2004 16:58:55 -0400, Qasim Rasheed [EMAIL PROTECTED] wrote: From October 18 - 29, Microsoft will offer a

RE: How to suppress the Header and Footer info when printing fr o m a browser

2004-10-08 Thread Ciliotta, Mario
For all my users. Mario -Original Message- From: Donna French [mailto:[EMAIL PROTECTED] Sent: Friday, October 08, 2004 5:09 PM To: CF-Talk Subject: Re: How to suppress the Header and Footer info when printing fr om a browser Is this something you want to turn off to print for yourself

RE: scheduling pages

2004-10-08 Thread Ryan Duckworth
I would probably re-evaluate the process overall, but this may help. One idea is to have the process run more efficiently but using code similar to this: if(fileExists(locFilePath)){ createObject('java','java.io.File').init(locFilePath).delete(); } Ryan Duckworth Macromedia ColdFusion

extraneous Chars after select from Database Coldfusion 4.5

2004-10-08 Thread David Manriquez
Hi again :-) This is for people who works o worked with CF 4.5 The Box : Linux Redhat Database : SQL SERVER 2000 i have problem with showing data from a SQL SERVER with spanish native chars like the result page display an extraneous char instead of char.. i tried to use in the META

Re: Some database questions

2004-10-08 Thread Jochem van Dieten
Chris Johnston wrote: On Fri, 08 Oct 2004 15:50:52 +0200, Jochem van Dieten wrote: Yes, in both. Cool, thanks. A quick follow up question though. Can I assume that since you can have foreign key constraints across schemas you can also perform sql queries across schemas as well? Pretty

RE: scheduling pages

2004-10-08 Thread Coleman, Brian
Yeah, I was going about it wrong. I redid the code to create a batch file with rmdir.exe /s /q and run the batch file through cfexecute to delete the folders It takes about 7 seconds for my test now. Thanks for kick starting my thought process -Original Message- From: Burns, John D

RE: Urgent : problem with Client Variables.

2004-10-08 Thread Dave Watts
I think what Dave Watts was saying was that when you do client.contract.id, CF actually creates a structure named client. Not exactly - CF already has a structure called Client. However, when creating or referencing the variable contract.id, CF will assume that contract is a structure, and

Re: CPU Utilization on CF5

2004-10-08 Thread Scott Brady
Well, we solved the immediate problem. It was indeed the dreaded CFMAIL issue.However, apparently HomeSite+ RDS listed those e-mails as being 1KB in size, when I later checked them via Explorer in PC Anywhere, they were 0 KB.So, that's why I wasn't sure if this was the issue.So, stopping the

Re: cftree cftreeitem CF5 vs CFMX61

2004-10-08 Thread Charles Heizer
I had the same problem. I found it's a bug in CFMX 6.1. If the value of cftreeitem contains a comma it will parse the value twice placing it at the root and in the tree. Macromedia confirmed this as a issue and have told me that it's been fixed in Blackstone. What I've had to do is upgrade to

Mirroring CFMX Configurations...

2004-10-08 Thread Charles Heizer
Hello, I was wondering if someone could help me out on this. I have been running coldfusion in a standalone mode since I've started using it. But now I have purchased a BigIP from F5 and I have multiple Apache Web Servers each with a copy of CFMX installed on them. What I want to do is mirror

Re: OT: Friday Goodies - ASP.NET Webcast and a chance to Win Visual Studio

2004-10-08 Thread Jochem van Dieten
Qasim Rasheed wrote: From October 18 - 29, Microsoft will offer a series of 40 live ASP.NET developer training Webcasts. The Webcasts are free and anyone who attends three or more can sign up to receive a free copy of Visual Studio .NET 2003 Standard Edition and a book on ASP.NET development.

Re: cf pop

2004-10-08 Thread Jochem van Dieten
Al Everett wrote: What's wrong with: cfpop server=mailserv action="" name=qHeaders cfset UIDlist=ValueList(qHeaders.UID) That works, but it introduces overhead. cfpopo getheadersonly LISTs all the messages in a mailbox and then does a TOP for each message. If you could get cfpop to just

Re: How to suppress the Header and Footer info when printing fr o m a browser

2004-10-08 Thread Jochem van Dieten
Ciliotta, Mario wrote: For all my users. Can't do it. My browser - my Header and Footer Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: Urgent : problem with Client Variables.

2004-10-08 Thread Jochem van Dieten
David Manriquez wrote: Sure this is my code , to try 1.-, get all client variables from the CDATA 2.-then look for that variableslikeclient.foo1.foo2 3.- delete client variables from the CDATA nad put it again without the client.foo1.foo2 variables looks like. cfquery name=sel_client

Re: OT: Friday Goodies - ASP.NET Webcast and a chance to Win Visual Studio

2004-10-08 Thread dave
and if ur REALLY attentive smile real big and promise not to sue good ole billy boy, they will even through in a free copy of FRONTPAGE! WHOO HOO!! this is where M$ needs to go back and start with :) http://www.jamwerx.com/OS.JPG [Todays Threads] [This Message] [Subscription] [Fast

RE: Mirroring CFMX Configurations...

2004-10-08 Thread Dave Watts
But now I have purchased a BigIP from F5 and I have multiple Apache Web Servers each with a copy of CFMX installed on them. What I want to do is mirror the CFMX Configuration to the other CFMX installations to keep everything in sync. Does anyone have any solutions for this, I'm running

RE: MS SQL Server next rowID

2004-10-08 Thread Dave Watts
Is there a way to get the ID of the next record that will be inserted into the database?And I don't mean max(tableID)+1, because some records could get deleted and the next row is not necessarily going ot be max(tableID) + 1. Microsoft SQL Server doesn't use sequences like Oracle does, so

Re: Mirroring CFMX Configurations...

2004-10-08 Thread Josh
Linux!awesome...we run a small farm of linux servers ourselves. Just copy the appropriate xml files and you should be good to go: some of the jrun settings are in here: /opt/coldfusionmx/runtime/servers/default/SERVER-INF/ DSNs: /opt/coldfusionmx/lib/neo-query.xml Mappings:

  1   2   >