RE: HELP!! sql wierdness ERROR message
Not to argue with Ben, but I don't think that PreserveSingleQuotes() is the answer... That function prevents CF from automatically esacping single quotes (in this case you WANT CF to escape them for you). I think you're confused a little with what CF terms as escaping the single quotes It converts all single quote types to their real single quote versions for SQL (used in WHERE and such), normally it won't always put the apostrophies in for the INSERT and UPDATE, it's almost a hit-and-miss thing This is why my wife suggested using Replace() combines with PreserveSingleQuotes() as it's the only guaranteed way of getting it working Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~| 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.
Re: HELP!! sql wierdness ERROR message
Philip Arnold - ASP wrote: I think you're confused a little with what CF terms as escaping the single quotes It converts all single quote types to their real single quote versions for SQL (used in WHERE and such), normally it won't always put the apostrophies in for the INSERT and UPDATE, it's almost a hit-and-miss thing There is no difference between what is used for a WHERE and an INSERT or UPDATE. Just imagine: how would nested WHERE's in an INSERT or UPDATE statement work? This is why my wife suggested using Replace() combines with PreserveSingleQuotes() as it's the only guaranteed way of getting it working It is not the only way, and it isn't a guaranteed way unless you rewrite your replace statements for each RDBMS. Each RDBMS uses different escape characters/sequences and delimiters. Use cfqueryparam. 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
Re: Speed of Duplicate
How are you getting your speeds? Have you done load testing? Or are you just loading a single page and using GetTickCount? At 12:04 AM 11/4/2002 -0500, you wrote: I have three different computers which are exhibiting drastically different speeds executing the Duplicate function. All computers are running CF5. The function is copying a large structure from the application scope to the request scope. Computer 1: remote webserver, dual processor, raid 5, Win 2000 Server, 640 MB ram --- Speed 1500 ms Computer 2: local desktop, single processor, Win 2000 Pro, 512 MB ram --- Speed 100 ms Computer 3: remote webserver, single processor, Win NT 4.5, 512 MB ram --- Speed 150 ms I would think #1 would be faster, certainly not 15 times slower. I am at a loss to explain the difference and am seeking ideas of where the problem could be. Most other tasks are about the same speed on all computers. Besides this duplicate, I have noticed that calling modules are also much slower on computer 1. Thanks in advance for any ideas. Chris Christopher P. Maher, FCAS, MAAA Modotech, Inc. [EMAIL PROTECTED] http://www.modotech.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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: HELP!! sql wierdness ERROR message
It is not the only way, and it isn't a guaranteed way unless you rewrite your replace statements for each RDBMS. Each RDBMS uses different escape characters/sequences and delimiters. Use cfqueryparam. This is of course impossible if you're building your SQL in a string first and then running one TSQL query Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~| 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
Converting ASCII characters
Hi. I have a page which enters details via an array into a DB. At the moment, some of the items in the array contain ASCII characters which I need to convert to their proper symbols. For example: James#39; fear of spiders I presume this should read James' fear of spiders. I'd like to convert the string before entering into the DB, but would also like to fix the current table (contains about 20,000 of which about half have these ASCII characters). How can I do this? Many thanks Will ~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Converting ASCII characters
chr(number) should give you the appropriate character. -Original Message- From: W Luke [mailto:will;lukrative.com] Sent: 04 November 2002 12:18 To: CF-Talk Subject: Converting ASCII characters Hi. I have a page which enters details via an array into a DB. At the moment, some of the items in the array contain ASCII characters which I need to convert to their proper symbols. For example: James#39; fear of spiders I presume this should read James' fear of spiders. I'd like to convert the string before entering into the DB, but would also like to fix the current table (contains about 20,000 of which about half have these ASCII characters). How can I do this? Many thanks Will ~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: HELP!! sql wierdness ERROR message
Philip Arnold - ASP wrote: It is not the only way, and it isn't a guaranteed way unless you rewrite your replace statements for each RDBMS. Each RDBMS uses different escape characters/sequences and delimiters. Use cfqueryparam. This is of course impossible if you're building your SQL in a string first and then running one TSQL query Not being able to use cfqueryparam (or cfprocparam, which is also a typed variable) is a very good reason not to do that. Apart from that, using TSQL already confines you to using one specific RDBMS, so the exception I mentioned applies. Although I still doubt that somebody not being a full-time DBA would know all the intricacies of the escape characters/sequences and delimiters. 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.
RE: HELP!! sql wierdness ERROR message
Not being able to use cfqueryparam (or cfprocparam, which is also a typed variable) is a very good reason not to do that. Apart from that, using TSQL already confines you to using one specific RDBMS, so the exception I mentioned applies. Although I still doubt that somebody not being a full-time DBA would know all the intricacies of the escape characters/sequences and delimiters. Saying that, if you're building your systems to work on your hardware, I'd expect you to know the oddities of the RDMS If you're using MS SQL Server, then you'd know all about it's escapes and the TSQL limitations (as well as the accelerators), if you're using Oracle, then you should know those If you want true 100% compaitibility, then sure, use CFQueryParam, but if you want to do 50 small inserts in a row, sending those requests as separate CFQuery tags is pretty much insane - building one big TSQL statement with one hit to the database server is a much better solution Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~| 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
Re: HELP!! sql wierdness ERROR message
Philip Arnold - ASP wrote: Saying that, if you're building your systems to work on your hardware, I'd expect you to know the oddities of the RDMS I would expect that too. But experience tells me not many people know how their RDBMS handles the not everyday functionality. If you want true 100% compaitibility, then sure, use CFQueryParam Again, compatibility was exactly the point I was making. but if you want to do 50 small inserts in a row, in a row? Do you mean updates of one row of a table or subsequent inserts into a table? sending those requests as separate CFQuery tags is pretty much insane - building one big TSQL statement with one hit to the database server is a much better solution Why would that be insane? 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.
RE: HELP!! sql wierdness ERROR message
your table really should not be 50 fields in size I think a normalisation could be implemented.. before you reach the SQL Server limit on row size. -Original Message- From: Jochem van Dieten [mailto:jochemd;oli.tudelft.nl] Sent: 04 November 2002 12:59 To: CF-Talk Subject: Re: HELP!! sql wierdness ERROR message Philip Arnold - ASP wrote: Saying that, if you're building your systems to work on your hardware, I'd expect you to know the oddities of the RDMS I would expect that too. But experience tells me not many people know how their RDBMS handles the not everyday functionality. If you want true 100% compaitibility, then sure, use CFQueryParam Again, compatibility was exactly the point I was making. but if you want to do 50 small inserts in a row, in a row? Do you mean updates of one row of a table or subsequent inserts into a table? sending those requests as separate CFQuery tags is pretty much insane - building one big TSQL statement with one hit to the database server is a much better solution Why would that be insane? 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Check Boxes - another NUG question
Worked! Thanks for the advice. What is a bit daunting about CF for newbies
is the various valid approaches to accomplish the same task.
Rick
-Original Message-
From: Kreig Zimmerman [mailto:kkz;foureyes.com]
Sent: Friday, 01 November, 2002 10:54
To: CF-Talk
Subject: Re: Check Boxes - another NUG question
Oh yeah, I may have slightly misunderstood the last question, so to add:
The way to do this on the form page is this:
input type=checkbox name=thisBox value=1#iif(Query.thisBox, DE('
checked'),DE(''))#
.since it is a boolean we are using as a value, in the IIF, 1
evaluates to true, and 0 to false. Thus only 1s make the checkbox
be checked.
Randell B Adkins wrote:
In the database field you can set the value to anything you want,
however you will need to test for the value to properly
set the checkboxes on the form to be checked or unchecked.
Example:
CheckBoxField: Value could be AGREE or DISAGREE
on the Form:
input type=checkbox name=abc value=Agree CFIF
qMyQuery.CheckBoxField EQ 'AGREE'checked/cfif
[EMAIL PROTECTED] 11/01/02 10:29AM
When querying a db where some original input fields were check boxes
and
were inserted into the db as a binary (yes/no, 1/0, on/off), is the
only way
to display a check box on the query page, either checked or unchecked,
to
create a form and add an insert field? If so, I'm having trouble with
the
conditional logic. Is there an approach I'm overlooking.
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
Get the mailserver that powers this list at http://www.coolfusion.com
Re: HELP!! sql wierdness ERROR message
I would expect that too. But experience tells me not many people know how their RDBMS handles the not everyday functionality. ~sigh~ This is the kind of thing it seems we have to put up with these days... Too many web designers trying to become web developers and making a right hash of it! If you want true 100% compaitibility, then sure, use CFQueryParam Again, compatibility was exactly the point I was making. BTW : If you have single quotes in a variable, generally, they automatically get escaped. I wonder whether, because a complex variable is being used CF isn't escaping them. In which case (without using CFQUERYPARAM, you would need to use a replace() on the single quote with double single quotes, to do the escaping on behalf of CF. No preservesinglequotes is required. but if you want to do 50 small inserts in a row, in a row? Do you mean updates of one row of a table or subsequent inserts into a table? 50 inserts one after another, so that 50 rows are inserted. sending those requests as separate CFQuery tags is pretty much insane - building one big TSQL statement with one hit to the database server is a much better solution Why would that be insane? Because that's 50 connect/deconnect to the database via your DB driver, as opposed to one connect/disconnect and letting your DB do the job it was designed to do. Stephen ~| 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
RE: HELP!! sql wierdness ERROR message
but if you want to do 50 small inserts in a row, in a row? Do you mean updates of one row of a table or subsequent inserts into a table? I mean inserting 50 rows into a table or multiple tables in the same database sending those requests as separate CFQuery tags is pretty much insane - building one big TSQL statement with one hit to the database server is a much better solution Why would that be insane? Basically as you're blitzing the connector, whether it's ODBC or OLE-DB - doing 50 queries immediately after each other is a major resource drain Say you've got an installation process for a new system or site, you have to insert some standard copy (e.g. 50 rows), then it'd be a LOT easier to have one CFQuery and insert all of the data in one go, if the data is dynamic compared to some options, then you either run it in a series of CFQuery's or you build it in a string (within CFScript) and then have 1 CFQuery The second option is preferable as you're only hitting the connector once, waiting for one response and then carrying on while the database server does the work In it's way, it's rather like using INSERT INTO () SELECT FROM instead of looping over a query and inserting the rows one at a time - it saves on server access, resources and thus keeps your server running at speed Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~| 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
Re: HELP!! sql wierdness ERROR message
Stephen Moretti wrote: sending those requests as separate CFQuery tags is pretty much insane - building one big TSQL statement with one hit to the database server is a much better solution Why would that be insane? Because that's 50 connect/deconnect to the database via your DB driver Connection pooling? as opposed to one connect/disconnect and letting your DB do the job it was designed to do. A database is designed to perform SQL queries. 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
Re: HELP!! sql wierdness ERROR message
Robertson-Ravo, Neil (REC) wrote: your table really should not be 50 fields in size I think a normalisation could be implemented.. before you reach the SQL Server limit on row size. We are doing an exercise of the mind on a fictitious database schema here (right Philip?). As such, it is quite easy to come up with something that has 50 fields and is perfectly normalized. 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: HELP!! sql wierdness ERROR message
your table really should not be 50 fields in size I think a normalisation could be implemented.. before you reach the SQL Server limit on row size. I'm not talking about 50 fields, but 50 rows Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~| 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
RE: HELP!! sql wierdness ERROR message
:-) yep, I noticed after your last few posts! :-) -Original Message- From: Philip Arnold - ASP [mailto:pra;aspmedia.co.uk] Sent: 04 November 2002 13:23 To: CF-Talk Subject: RE: HELP!! sql wierdness ERROR message your table really should not be 50 fields in size I think a normalisation could be implemented.. before you reach the SQL Server limit on row size. I'm not talking about 50 fields, but 50 rows Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~| 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
RE: HELP!! sql wierdness ERROR message
shove this code at the top of your SP: SET QUOTED_IDENTIFIER OFF What happens? -Original Message- From: Jochem van Dieten [mailto:jochemd;oli.tudelft.nl] Sent: 04 November 2002 13:23 To: CF-Talk Subject: Re: HELP!! sql wierdness ERROR message Robertson-Ravo, Neil (REC) wrote: your table really should not be 50 fields in size I think a normalisation could be implemented.. before you reach the SQL Server limit on row size. We are doing an exercise of the mind on a fictitious database schema here (right Philip?). As such, it is quite easy to come up with something that has 50 fields and is perfectly normalized. 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
RE: HELP!! sql wierdness ERROR message
A database is designed to perform SQL queries. Yes, true but I can see what Phil is saying; if you are constantly looping and reconnecting to the DB Server to perform what essentially could be completed with say an SP or a SQL Block then let the SQL Server perform what it is good at SQL. I would say that you would not find that much difference in peformace on basic Select, Insert, Update or Deletes (the standard CF/SQL Combos) but for more complex Joins etc you may find certain degredation in peformance.. N -Original Message- From: Jochem van Dieten [mailto:jochemd;oli.tudelft.nl] Sent: 04 November 2002 13:20 To: CF-Talk Subject: Re: HELP!! sql wierdness ERROR message Stephen Moretti wrote: sending those requests as separate CFQuery tags is pretty much insane - building one big TSQL statement with one hit to the database server is a much better solution Why would that be insane? Because that's 50 connect/deconnect to the database via your DB driver Connection pooling? as opposed to one connect/disconnect and letting your DB do the job it was designed to do. A database is designed to perform SQL queries. 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
RE: Speed of Duplicate
If both duplicate and modules are slow on that computer your issue will probably boil down to memory and swapping. What else is running on that first server? An RDBMS perhaps? -mk -Original Message- From: Christopher P. Maher [mailto:lists;modotech.com] Sent: Sunday, November 03, 2002 11:05 PM To: CF-Talk Subject: Speed of Duplicate I have three different computers which are exhibiting drastically different speeds executing the Duplicate function. All computers are running CF5. The function is copying a large structure from the application scope to the request scope. Computer 1: remote webserver, dual processor, raid 5, Win 2000 Server, 640 MB ram --- Speed 1500 ms Computer 2: local desktop, single processor, Win 2000 Pro, 512 MB ram --- Speed 100 ms Computer 3: remote webserver, single processor, Win NT 4.5, 512 MB ram --- Speed 150 ms I would think #1 would be faster, certainly not 15 times slower. I am at a loss to explain the difference and am seeking ideas of where the problem could be. Most other tasks are about the same speed on all computers. Besides this duplicate, I have noticed that calling modules are also much slower on computer 1. Thanks in advance for any ideas. Chris Christopher P. Maher, FCAS, MAAA Modotech, Inc. [EMAIL PROTECTED] http://www.modotech.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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: HELP!! sql wierdness ERROR message
I agree with Phil too - let the DB do the work As far as connection pooling goes - I think there is a misunderstanding as to what it does. The most lengthy process (relatively) in going to a db and getting data is creating the connection itself. Connection pooling just holds on to connections for reuse - you still have to go back to the database and get the data and bring it back to the client via that connection. -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:Neil.Robertson-Ravo;csd.reedexpo.com] Sent: 04 November 2002 13:25 To: CF-Talk Subject: RE: HELP!! sql wierdness ERROR message A database is designed to perform SQL queries. Yes, true but I can see what Phil is saying; if you are constantly looping and reconnecting to the DB Server to perform what essentially could be completed with say an SP or a SQL Block then let the SQL Server perform what it is good at SQL. I would say that you would not find that much difference in peformace on basic Select, Insert, Update or Deletes (the standard CF/SQL Combos) but for more complex Joins etc you may find certain degredation in peformance.. N -Original Message- From: Jochem van Dieten [mailto:jochemd;oli.tudelft.nl] Sent: 04 November 2002 13:20 To: CF-Talk Subject: Re: HELP!! sql wierdness ERROR message Stephen Moretti wrote: sending those requests as separate CFQuery tags is pretty much insane - building one big TSQL statement with one hit to the database server is a much better solution Why would that be insane? Because that's 50 connect/deconnect to the database via your DB driver Connection pooling? as opposed to one connect/disconnect and letting your DB do the job it was designed to do. A database is designed to perform SQL queries. 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
Re: HELP!! sql wierdness ERROR message
Because that's 50 connect/deconnect to the database via your DB driver Connection pooling? Doesn't make any difference As Phil says, you're blitzing your DB connection with 50 queries in a very short period. as opposed to one connect/disconnect and letting your DB do the job it was designed to do. A database is designed to perform SQL queries. Yes, but by making CF generate and send 50 queries to the DB, your DB really isn't doing anything to take the load for the work that is being done. Stephen ~| 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
Re: HELP!! sql wierdness ERROR message
Philip Arnold - ASP wrote: sending those requests as separate CFQuery tags is pretty much insane - building one big TSQL statement with one hit to the database server is a much better solution Why would that be insane? Basically as you're blitzing the connector, whether it's ODBC or OLE-DB - doing 50 queries immediately after each other is a major resource drain Connection pooling? In it's way, it's rather like using INSERT INTO () SELECT FROM instead of looping over a query and inserting the rows one at a time - it saves on server access, resources and thus keeps your server running at speed I would agree most of the time it is preferable. But that does not necessarily mean doing the separate cfqueries is insane. And besides, I would still implement it without depending on TSQL: cfquery datasource=test cfloop from=1 to=3 index=i INSERT INTO test (testID) VALUEs (cfqueryparam cfsqltype=cf_sql_integer value=#i#); /cfloop /cfquery One database connection, not database dependent. Best of both worlds :) 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.
Re: HELP!! sql wierdness ERROR message
Andy Ewings wrote: As far as connection pooling goes - I think there is a misunderstanding as to what it does. The most lengthy process (relatively) in going to a db and getting data is creating the connection itself. Connection pooling just holds on to connections for reuse - you still have to go back to the database and get the data and bring it back to the client via that connection. What takes most time would be very database dependent. 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
Re: HELP!! sql wierdness ERROR message
Robertson-Ravo, Neil (REC) wrote: I would say that you would not find that much difference in peformace on basic Select, Insert, Update or Deletes (the standard CF/SQL Combos) but for more complex Joins etc you may find certain degredation in peformance.. Exactly. However, we are talking about small inserts: quote if you want to do 50 small inserts in a row /quote 001b01c283ff$98e6d900$c32f20d4fizzypop 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: HELP!! sql wierdness ERROR message
I'm not sure I follow this response? What I was saying/implying is that yes connection pooling would prevent you from having to reconnect from scratch each time but you would still be having to execute multiple SQL queries against the database which, if you got the DB to do it in one hit, would undoubtedly save you time -Original Message- From: Jochem van Dieten [mailto:jochemd;oli.tudelft.nl] Sent: 04 November 2002 13:41 To: CF-Talk Subject: Re: HELP!! sql wierdness ERROR message Andy Ewings wrote: As far as connection pooling goes - I think there is a misunderstanding as to what it does. The most lengthy process (relatively) in going to a db and getting data is creating the connection itself. Connection pooling just holds on to connections for reuse - you still have to go back to the database and get the data and bring it back to the client via that connection. What takes most time would be very database dependent. 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
RE: HELP!! sql wierdness ERROR message
then... its one of those things you have to decide on the move... if there is no real degredation then stick with a loop.. all things being equal, the SQL Server and the CF Server should be 100% optimised to handle load... :-p -Original Message- From: Jochem van Dieten [mailto:jochemd;oli.tudelft.nl] Sent: 04 November 2002 13:42 To: CF-Talk Subject: Re: HELP!! sql wierdness ERROR message Robertson-Ravo, Neil (REC) wrote: I would say that you would not find that much difference in peformace on basic Select, Insert, Update or Deletes (the standard CF/SQL Combos) but for more complex Joins etc you may find certain degredation in peformance.. Exactly. However, we are talking about small inserts: quote if you want to do 50 small inserts in a row /quote 001b01c283ff$98e6d900$c32f20d4fizzypop 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.
RE: Speed of Duplicate
How are you getting your speeds? Have you done load testing? Or are you just loading a single page and using GetTickCount? CF debug option to Show Detailed Processing Time Breakdown. ~| 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.
RE: last day of month
DaysInMonth(Now()) -Original Message- From: Tony Weeg [mailto:tony;navtrak.net] Sent: Monday, November 04, 2002 12:56 AM To: CF-Talk Subject: last day of month is there an easy way to generate a lastDayofMonth kinda number, knowing the month/year? want to give the user the ability to click a checkbox that will autopopulate two date fields, with the first day and last day of month based on the month that Now() will give me. ive got it all down, i can globally put 1 in for beginningDayofMonth, however i cant seem to figger out an easy way to make it dynamic for the lastDayofTheMonth make sense? ...tony tony weeg [EMAIL PROTECTED] www.revolutionwebdesign.com rEvOlUtIoN wEb DeSiGn 410.334.6331 ~| 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
RE: Speed of Duplicate
If both duplicate and modules are slow on that computer your issue will probably boil down to memory and swapping. What else is running on that first server? An RDBMS perhaps? The other two computers are running SQL Server but the first is just running IIS, CF5 and pcAnywhere plus whatever other processes go along with a default W2K Server install. I did notice that if I stop and start CF that for the first dozen or so page views the speed is comparable to the other two computers. Then it suddenly slows down. Christopher P. Maher, FCAS, MAAA Modotech, Inc. [EMAIL PROTECTED] http://www.modotech.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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Converting ASCII characters
Robertson-Ravo, Neil (REC) [EMAIL PROTECTED] wrote in message news:AFDBA0DE939BD41195290008C7A448A954D62B@RECCSDEXC2... chr(number) should give you the appropriate character. Hi Neil. That's what I had planned on using, but I'm not sure how I can loop round a string to detect *any* ASCII chr (there are loads of different types in my DB), grab the number, and replace it. Any ideas? Will ~| 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
Re: HELP!! sql wierdness ERROR message
- Original Message - From: Jochem van Dieten [EMAIL PROTECTED] --snip-- And besides, I would still implement it without depending on TSQL: cfquery datasource=test cfloop from=1 to=3 index=i INSERT INTO test (testID) VALUEs (cfqueryparam cfsqltype=cf_sql_integer value=#i#); /cfloop /cfquery One database connection, not database dependent. Best of both worlds :) --snip-- --- Isn't it impossible to do this when you're using Access? I know you shouldn't be using Access, etc., but I've never been able to get multiple SQL statements to work in Access. Is there a trick I'm missing, or is this just something else to live with and remind me I shouldn't be using Access? ;-) Gyrus [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net PGP key available ~| 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
Re: last day of month
in the days of lotus 123 I used to subtract one day from the first day of the next month e From: Howie Hamlin [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: last day of month Date: Mon, 4 Nov 2002 01:02:54 -0500 Try this: http://www.cflib.org/library.cfm?ID=13 HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, November 04, 2002 12:55 AM Subject: last day of month is there an easy way to generate a lastDayofMonth kinda number, knowing the month/year? want to give the user the ability to click a checkbox that will autopopulate two date fields, with the first day and last day of month based on the month that Now() will give me. ive got it all down, i can globally put 1 in for beginningDayofMonth, however i cant seem to figger out an easy way to make it dynamic for the lastDayofTheMonth make sense? ...tony tony weeg [EMAIL PROTECTED] www.revolutionwebdesign.com rEvOlUtIoN wEb DeSiGn 410.334.6331 ~| 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
Re: HELP!! sql wierdness ERROR message
Andy Ewings wrote: I'm not sure I follow this response? I was taking a wild stab because I had the same with your message :) What I was saying/implying is that yes connection pooling would prevent you from having to reconnect from scratch each time but you would still be having to execute multiple SQL queries against the database which, if you got the DB to do it in one hit, would undoubtedly save you time It would save time. But would that be a significant amount of time? I don't think I would want to give up code portability to get some response time down 100 ms (reusing a connection takes little under 2 ms for my setup, so that is 100 ms for the 50 queries). 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Server Error
Hi My server stopped responding our company's Intranet. I restarted IIS and CFMX services to make it working and it worked. Once restarted then from EVENT VIEWER I found following WARNING The data buffer created for the ColdFusion MX Application Server service in the C:\WINNT\system32\cfperfmon_mx.dll library is not aligned on an 8-byte boundary. This may cause problems for applications that are trying to read the performance data buffer. Contact the manufacturer of this library or service to have this problem corrected or to get a newer version of this library. and following ERROR Unable to query the W3SVC (HTTP) service performance data. The error code returned by the service is data DWORD 0. For additional information specific to this message please visit the Microsoft Online Support site located at: http://www.microsoft.com/contentredirect.asp. Any idea whats happening with the server Shahzad ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: HELP!! sql wierdness ERROR message
Gyrus wrote: Isn't it impossible to do this when you're using Access? I don't know. But Access was not really what I had in mind. It would probably have been better to say that it works with any database that adheres to standard X, Y, and Z. Or that it is less database dependent. 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
RE: Cfqueryparam and IN
Yes this is very neat, thanks to all who posted, that fixed the issue. Very nice. Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com -Original Message- From: Dave Watts [mailto:dwatts;figleaf.com] Sent: Friday, November 01, 2002 5:39 PM To: CF-Talk Subject: RE: Cfqueryparam and IN No, you can use CFQUERYPARAM cfset myList=203,197 cfquery name=myQuery datasource=#DSN# select * from myTable where salesPersonID IN (cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#myList# list=Yes separator=,) /cfquery Wow, that's neat! I wasn't aware you could do that. I'll have to try that out! 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: HELP!! sql wierdness ERROR message
Hold on a second guys, all Jason said was -This is representative some of the data being inserted. This was a NASTY 550 page file maker pro data base that I'm converting. Some fields are empty some are huge like this one. So I assume with these looped queries all he is trying to achieve is some sort of one shot data transfer / conversion operation (which is failing for some reason). Nothing to do with production, so speed is more or less irrelavent. I have occasionally done thousands of looped inserts like this with some sort of quick dirty coding to achieve some sort of one-off data conversion and never had to resort to adjusting connection pooling or any of the other special solutions being suggested here. My solution? 1) try setting the variable as a simple value before the query so CF has every opportunity to do its built-in escaping of special characters in the query, as I suggested before: CFSET st = bookArray[43] cfquery name=newAuthorBio datasource=#application.dsn# INSERT into authorBio (authorBio_authorId,authorBioDetail) VALUES (#session.authorPkey#, '#st#') /cfquery if still no worky: 2) Put the query in a CFTRY CFCATCH block set up to abort the loop on the first failure and display the raw uadulterated string causing the failure. Let's have a look at that string -- Regards; Richard Meredith-Hardy ~| 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
RE: lists in cfcase
Specify your list delimiter in the CFCASE, as below... cfoutput cfset variables.Foo=3 cfswitch expression=#variables.Foo# cfcase value=2,4 delimiters=, Do this... /cfcase cfcase value=1,3,5,7,8,10,12 delimiters=, Do that... /cfcase cfcase value=6,9,11 delimiters=, Do the other... /cfcase /cfswitch /cfoutput -- -Original Message- -- From: Tony Weeg [mailto:tony;navtrak.net] -- Sent: Sunday, November 03, 2002 10:13 PM -- To: CF-Talk -- Subject: lists in cfcase -- -- cfcase value=1,3,5,7,8,10,12 -- -- doesnt jive? meaning, it wont do the stuff -- in the case, if there is a match from the list -- -- if i know the list, and its not dynamic, and i want to loop over the -- values, -- shouldnt a list be allowed? -- -- thanks. -- -- ...tony -- -- tony weeg -- [EMAIL PROTECTED] -- www.revolutionwebdesign.com -- rEvOlUtIoN wEb DeSiGn -- 410.334.6331 -- -- ~| 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
Re: Converting ASCII characters
Will, I have a page which enters details via an array into a DB. At the moment, some of the items in the array contain ASCII characters which I need to convert to their proper symbols. For example: James#39; fear of spiders I presume this should read James' fear of spiders. I'd like to convert the string before entering into the DB, but would also like to fix the current table (contains about 20,000 of which about half have these ASCII characters). If you're only displaying the text on a web page, you needn't go to the trouble of hacking the HTML escape codes out. Otherwise, you need to look at regex to find and replace #xx; with CHR(xx) if thats really what you want to do. Stephen ~| 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
RE: HELP!! sql wierdness ERROR message
This is one solution. The problem here is not that the SQL is being built dynamically -- somehow the thread got off track with that assumption. The real problem is, at least in CF 5.0 (which is the version Jason Kufner is using), single quotes are not escape in a complex variable for whatever reason (at least in arrays, I haven't tested it otherwise). Instead of setting a variable equal to the array member for each pass, you can do what Jochem has been saying: use cfqueryparam (it works, I tested it on dummy data; loopnum identifies the current array position): cfquery name=newAuthorBio datasource=#application.dsn# INSERT into authorBio (authorBio_authorId,authorBioDetail) VALUES ( cfqueryparam cfsqltype=CF_SQL_INTEGER value=#session.authorPkey#, cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#bookArray[loopnum]# ) /cfquery You might have to use a cfsqltype of CF_SQL_LONGVARCHAR depending on what datatype your field is set to. -Original Message- From: Richard Meredith-Hardy [mailto:rmh;flymicro.com] Sent: Monday, November 04, 2002 9:32 AM To: CF-Talk Subject: Re: HELP!! sql wierdness ERROR message Hold on a second guys, all Jason said was -This is representative some of the data being inserted. This was a NASTY 550 page file maker pro data base that I'm converting. Some fields are empty some are huge like this one. So I assume with these looped queries all he is trying to achieve is some sort of one shot data transfer / conversion operation (which is failing for some reason). Nothing to do with production, so speed is more or less irrelavent. I have occasionally done thousands of looped inserts like this with some sort of quick dirty coding to achieve some sort of one-off data conversion and never had to resort to adjusting connection pooling or any of the other special solutions being suggested here. My solution? 1) try setting the variable as a simple value before the query so CF has every opportunity to do its built-in escaping of special characters in the query, as I suggested before: CFSET st = bookArray[43] cfquery name=newAuthorBio datasource=#application.dsn# INSERT into authorBio (authorBio_authorId,authorBioDetail) VALUES (#session.authorPkey#, '#st#') /cfquery if still no worky: 2) Put the query in a CFTRY CFCATCH block set up to abort the loop on the first failure and display the raw uadulterated string causing the failure. Let's have a look at that string ~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Words
Erk -- there wasn't supposed to be an 're' on that -- just a find(). *sigh* This is what I get for posting after my bedtime. --Ben Doom Programmer General Lackey Moonbow Software : -Original Message- : From: S. Isaac Dealey [mailto:info;turnkey.to] : Sent: Sunday, November 03, 2002 11:23 PM : To: CF-Talk : Subject: RE: Words : : : refind(key, '/archivedocs/'); : : The slashes prevent it from returning true if it finds : 'archivedocsearch' : and similar mismatches. : :--Ben Doom : Programmer General Lackey : Moonbow Software : : You and the regular expressions. ;P I think he's probably looking for : something like ListFindNoCase(path,archivedocs,/) or for that matter : FindNoCase(/archivedocs/,path) ... although Matthew Walker beat : me to the : answer. :P : : Isaac : Certified Advanced ColdFusion 5 Developer : : www.turnkey.to : 954-776-0046 : : ~| 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
Re: Converting ASCII characters
W Luke wrote:
I have a page which enters details via an array into a DB. At the
moment, some of the items in the array contain ASCII characters which
I need to convert to their proper symbols. For example:
James' fear of spiders
I presume this should read James' fear of spiders. I'd like to
convert the string before entering into the DB, but would also like to
fix the current table (contains about 20,000 of which about half have
these ASCII characters).
If string is the string you want fixed:
#Evaluate('REReplaceNoCase(string,##([0-9]+);,'##Chr(\1)##',All)')#
But I am sure Ray will now join and tell us that Evaluate() is evil :)
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
RE: HELP!! sql wierdness ERROR message
-Original Message- From: Philip Arnold - ASP [mailto:pra;aspmedia.co.uk] Sent: Monday, November 04, 2002 5:46 AM To: CF-Talk Subject: RE: HELP!! sql wierdness ERROR message Not to argue with Ben, but I don't think that PreserveSingleQuotes() is the answer... That function prevents CF from automatically esacping single quotes (in this case you WANT CF to escape them for you). I think you're confused a little with what CF terms as escaping the single quotes It converts all single quote types to their real single quote versions for SQL (used in WHERE and such), normally it won't always put the apostrophies in for the INSERT and UPDATE, it's almost a hit-and-miss thing This is why my wife suggested using Replace() combines with PreserveSingleQuotes() as it's the only guaranteed way of getting it working Honestly I'm still a little confused here... I still don't think that PerserveSingleQuotes() does what you suggest. As far as I understand it (which may turn out to be not at all) CF will automatically escape single quotes in variables placed inside a cfquery. So something like this is legal: cfset foo = How're you doing today cfquery SELECT * FROM Table WHERE Value = '#foo#' /cfquery CF will automatically escape the single quote in the variable and statement will pass. However using PreserveSingleQuotes() will (I think) cause the statement to fail as the single quote in the variable will be exposed to SQL and seen, erroneously, as the end of the content. The point is that in some cases you need CF not to escape automatically as in: cfset foo='hi','hello','howdy' cfquery SELECT * FROM Table WHERE Value IN (#PreserveSingleQuotes(aList)#) /cfquery In the above statement CF, without the function, would have escaped the quotes and invalidated the list. So you need to explicitly tell it to preserve them. Am I wrong in this? Are we actually saying the same thing? Of course a lot of this is academic anyway. Jochem is correct of course that much (perhaps all of this) of this is now handled (better) with CFQUERYPARAM. The PreserveSingleQuotes() function was one of the original functions (I believe all the way back to version 1.0). It made sense when it was created but it really only makes sense now if you can't, for some reason, use CFQUERYPARAM. Jim Davis ~| 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
UPS US Address Validation
In case anyone is interested, here is a web service that I created for UPS' Address Validation. It simply returns a Boolean, yes or no. (See attached) Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL ~| 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
Passing anchor results to a template
Hi, How can I pass the results of the anchor based on which one is clicked on to another template? Do I need to use JS? a name=test1 id=test1 href=template.cfmtest1/a a name=test2 id=test2 href=template.cfmtest2/a a name=test3 id=test3 href=template.cfmtest3/a --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| 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
Re: UPS US Address Validation
:) no attachments allowed to the list - Original Message - From: Bryan F. Hogan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, November 04, 2002 10:37 AM Subject: UPS US Address Validation In case anyone is interested, here is a web service that I created for UPS' Address Validation. It simply returns a Boolean, yes or no. (See attached) Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL ~| 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
RE: UPS US Address Validation
Since attachments are not allowed, see http://www.digitalbay.net/verifyaddress.zip Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: Bryan F. Hogan [mailto:bryan.hogan;digitalbay.net] Sent: Monday, November 04, 2002 10:38 AM To: CF-Talk Subject: UPS US Address Validation In case anyone is interested, here is a web service that I created for UPS' Address Validation. It simply returns a Boolean, yes or no. (See attached) Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL ~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
what tag captures data from a web page?
If you would, please direct me to what tag or tags (or function) I should look at in order to capture data from an existing internet web page. TIA Ed Gordon
RE: UPS US Address Validation
I would like to know more about this, but you can't send attachments to the list. -Original Message- From: Bryan F. Hogan [mailto:bryan.hogan;digitalbay.net] Sent: Monday, November 04, 2002 10:38 AM To: CF-Talk Subject: UPS US Address Validation In case anyone is interested, here is a web service that I created for UPS' Address Validation. It simply returns a Boolean, yes or no. (See attached) Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL ~| 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
RE: UPS US Address Validation
There is nothing attached. -Original Message- From: Bryan F. Hogan [mailto:bryan.hogan;digitalbay.net] Sent: Monday, November 04, 2002 10:38 AM To: CF-Talk Subject: UPS US Address Validation In case anyone is interested, here is a web service that I created for UPS' Address Validation. It simply returns a Boolean, yes or no. (See attached) Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL ~| 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
Re: UPS US Address Validation
Did you intend to send along a link? This address is filtered through the open relay database at http://www.ordb.org and is virus scanned by ANTIVIR http://www.dwhite.ws mailto:doug;dwhite.ws - Original Message - From: Bryan F. Hogan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, November 04, 2002 9:37 AM Subject: UPS US Address Validation | In case anyone is interested, here is a web service that I created for UPS' | Address Validation. It simply returns a Boolean, yes or no. (See attached) | | | Bryan F. Hogan | Director of Internet Development | Macromedia Certified ColdFusion MX Developer | Digital Bay Media, Inc. | 1-877-72DIGITAL | ~| 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.
RE: Passing anchor results to a template
What do you mean by results of the anchor? The name, the href or the text rapped in the tag? -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: 04 November 2002 15:43 To: CF-Talk Subject: Passing anchor results to a template Hi, How can I pass the results of the anchor based on which one is clicked on to another template? Do I need to use JS? a name=test1 id=test1 href=template.cfmtest1/a a name=test2 id=test2 href=template.cfmtest2/a a name=test3 id=test3 href=template.cfmtest3/a --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| 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
RE: what tag captures data from a web page?
cfhttp Ade -Original Message- From: Ed Gordon [mailto:NetDr;callptc.com] Sent: 04 November 2002 15:49 To: CF-Talk Subject: what tag captures data from a web page? If you would, please direct me to what tag or tags (or function) I should look at in order to capture data from an existing internet web page. TIA Ed Gordon ~| 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
cfqueryparam and preservesinglequotes() was RE: HELP!! sql wierdness ERROR message
Of course a lot of this is academic anyway. Jochem is correct of course that much (perhaps all of this) of this is now handled (better) with CFQUERYPARAM. The PreserveSingleQuotes() function was one of the original functions (I believe all the way back to version 1.0). It made sense when it was created but it really only makes sense now if you can't, for some reason, use CFQUERYPARAM. erm... I think you got that a little backwards. The purpose of PreserveSingleQuotes() is to allow you to pass a sql statement or portion of a sql statement as a variable into a query, i.e. cfset mywhereclause = mycolumn='something' cfquery ... SELECT * FROM mytable WHERE #preservesinglequotes(mywhereclause)# /cfquery cfqueryparam can't perform this function, because a sql variable can't be used as a portion of this query -- without first trapping it in something within the db like sp_executesql mystatement or exec(mystatement) ... So queryparam doesn't change the purpose or frequency with which you would use preservesinglequotes() at all... That being said, I rarely find any need to use preservesinglequotes(); and you're right the answer to the original question this thread started with probably lies with cfqueryparam and not preservesinglequotes. As an asside -- I remember that prior to my becoming involved with cf, the syntax for cfquery was cfquery datasource=blah sql=sql statement here So because it was an attribute and not an inner-text between an open and close tag, the tendancy was to do what ASP developers do and create the entire sql statement as a string and pass the string to the attribute, i.e.: cfquery sql=#mysqlstatement# in which case the only way to make the statement work if the #mysqlstatement# variable contained something like mycolumn='something' would be to use #preservesinglequotes(mysqlstatement)#. Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ~| 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
deleteclientvariable on mx not working?
I'm downloading the mx cfml reference now, but I figured I would fire this off in case anyone knows the answer. I'm sure it is something obvious, but I can't find it. I'm trying to delete a client variable, but it doesn't seem to be working. It works fine on my local box, which is cf5. But when I upload the same app to our MX development server, the client variable is not deleted when it is supposed to be, which is(obviously) causing problems. Does anyone have an idea where it is going wrong? cfif isDefined(client.wddxFormBuffer) cfwddx action=WDDX2CFML input=#client.wddxFormBuffer# output=attributes cfset DeleteClientVariable(wddxFormBuffer) /cfif I have also tried the following: cfset tmp = DeleteClientVariable(wddxFormBuffer) cfset tmp = DeleteClientVariable(client.wddxFormBuffer) Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [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 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
RE: what tag captures data from a web page?
cfhttp --Ben Doom Programmer General Lackey Moonbow Software : -Original Message- : From: Ed Gordon [mailto:NetDr;callptc.com] : Sent: Monday, November 04, 2002 10:49 AM : To: CF-Talk : Subject: what tag captures data from a web page? : : : If you would, please direct me to what tag or tags (or function) I should : look at in order to capture data from an existing internet web page. : : TIA : : Ed Gordon : : ~| 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
RE: Passing anchor results to a template
How about passing it as a url variable? -Kevin -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: Monday, November 04, 2002 9:43 AM To: CF-Talk Subject: Passing anchor results to a template Hi, How can I pass the results of the anchor based on which one is clicked on to another template? Do I need to use JS? a name=test1 id=test1 href=template.cfmtest1/a a name=test2 id=test2 href=template.cfmtest2/a a name=test3 id=test3 href=template.cfmtest3/a --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Passing anchor results to a template
Hi,
How can I pass the results of the anchor based on which
one is clicked on to another template? Do I need to use
JS?
a name=test1 id=test1 href=template.cfmtest1/a
a name=test2 id=test2 href=template.cfmtest2/a
a name=test3 id=test3 href=template.cfmtest3/a
If you're using url variables, you'll have to use JS because anchors and
query strings are mutually exlusive -- trying to use them both forces the
browser to interpret whichever is last as a part of the first.
cfparam name=hash type=string default=
cfif len(trim(url.hash))
script language=javascript
function goToHash() {
location.hash = '#jsstringformat(url.hash)#';
} window.onload = goToHash;
/script/cfif
Isaac
Certified Advanced ColdFusion 5 Developer
www.turnkey.to
954-776-0046
~|
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.
RE: what tag captures data from a web page?
CFHTTP allows you to retrieve the contents of a webpage. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Ed Gordon [mailto:NetDr;callptc.com] Sent: Monday, November 04, 2002 10:49 AM To: CF-Talk Subject: what tag captures data from a web page? If you would, please direct me to what tag or tags (or function) I should look at in order to capture data from an existing internet web page. TIA Ed Gordon ~| 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.
RE: what tag captures data from a web page?
cfhttp... and then work with the resulting variable, cfhttp.filecontent. Gene Kraybill -Original Message- From: Ed Gordon [mailto:NetDr;callptc.com] Sent: Monday, November 04, 2002 10:49 AM To: CF-Talk Subject: what tag captures data from a web page? If you would, please direct me to what tag or tags (or function) I should look at in order to capture data from an existing internet web page. TIA Ed Gordon ~| 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
RE: Passing anchor results to a template
The name On Mon, 4 Nov 2002 15:50:45 -, Adrian Lynch wrote: What do you mean by results of the anchor? The name, the href or the text rapped in the tag? -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: 04 November 2002 15:43 To: CF-Talk Subject: Passing anchor results to a template Hi, How can I pass the results of the anchor based on which one is clicked on to another template? Do I need to use JS? a name=test1 id=test1 href=template.cfmtest1/a a name=test2 id=test2 href=template.cfmtest2/a a name=test3 id=test3 href=template.cfmtest3/a --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| 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.
RE: what tag captures data from a web page?
cfhttp -Original Message- From: Ed Gordon [mailto:NetDr;callptc.com] Sent: maandag 4 november 2002 16:49 To: CF-Talk Subject: what tag captures data from a web page? If you would, please direct me to what tag or tags (or function) I should look at in order to capture data from an existing internet web page. TIA Ed Gordon ~| 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
Re: what tag captures data from a web page?
are talking about a page from another website? You could use CFHTTP which acts like a web browser and returns all the HTML. Craig - Original Message - From: Ed Gordon [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, November 04, 2002 9:48 AM Subject: what tag captures data from a web page? If you would, please direct me to what tag or tags (or function) I should look at in order to capture data from an existing internet web page. TIA Ed Gordon ~| 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.
Re: Passing anchor results to a template
Do this a name=test1 id=test1 href=template.cfm?varAnchor=test1test1/a a name=test2 id=test2 href=template.cfm?varAnchor=test2test2/a a name=test3 id=test3 href=template.cfm?varAnchor=test3test3/a then test for which varAnchor was clicked.. would that work it really depends on what you need to do after - Original Message - From: FlashGuy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, November 04, 2002 9:42 AM Subject: Passing anchor results to a template Hi, How can I pass the results of the anchor based on which one is clicked on to another template? Do I need to use JS? a name=test1 id=test1 href=template.cfmtest1/a a name=test2 id=test2 href=template.cfmtest2/a a name=test3 id=test3 href=template.cfmtest3/a --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| 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
Re: UPS US Address Validation
no attachment... i dont think you can post an attachment ... copy past code into msg.. this would be interesting - Original Message - From: Bryan F. Hogan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, November 04, 2002 9:37 AM Subject: UPS US Address Validation In case anyone is interested, here is a web service that I created for UPS' Address Validation. It simply returns a Boolean, yes or no. (See attached) Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL ~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
CFXML newbie needs help
Just trying to do a simple CFXML outputbut the webpage just hangs and doesn't error out or anything.. like its running in a never ending loop..The code below is based on an example from the CFMX New Riders book.. Here is my xsd: ?xml version=1.0 encoding=UTF-8? !-- edited with XMLSPY v5 rel. 2 U (http://www.xmlspy.com) by SMR (SMR) -- xs:schema xmlns:xs=http://www.w3.org/2001/XMLSchema; elementFormDefault=qualified targetNamespace=http://127.0.0.1:8500/; xmlns=http://127.0.0.1:8500/; xs:element name=document xs:complexType xs:sequence xs:element name=doc_file_name type=xs:string/ xs:element name=doc_description type=xs:string/ xs:element name=doc_filesize type=xs:string/ /xs:sequence /xs:complexType /xs:element /xs:schema Here is my cfm: cfquery name=getdoc datasource=ncw dbtype=ODBC select doc_file_name, doc_filesize, doc_description from document /cfquery Query Done... cfsavecontent variable=tempxml?xml version=1.0 encoding=UTF-8? doc-list xmlns:xsi=http://127.0.0.1:8500/; xsi: noNamespaceSchemaLocation=C:\CfusionMX\wwwroot\doc.xsd cfoutput query=getdoc document doc_file_name#Trim(XMLFormat(doc_file_name))#/doc_file_name doc_description#Trim(XMLFormat(doc_description))#/doc_description doc_filesize#Trim(XMLFormat(doc_filesize))#/doc_filesize /document /cfoutput /doc-list /cfsavecontent Save content done... cfset myXMLDocument=XmlParse(tempxml) This is my xml document cfdump var=#myXMLDocument# cffile action=write file=#ExpandPath(.)#/document.xml output=#ToString(tempxml)# ~| 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.
RE: UPS US Address Validation
Here it is http://www.digitalbay.net/verifyaddress.zip Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: Doug [mailto:doug;dwhite.ws] Sent: Monday, November 04, 2002 10:51 AM To: CF-Talk Subject: Re: UPS US Address Validation Did you intend to send along a link? This address is filtered through the open relay database at http://www.ordb.org and is virus scanned by ANTIVIR http://www.dwhite.ws mailto:doug;dwhite.ws - Original Message - From: Bryan F. Hogan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, November 04, 2002 9:37 AM Subject: UPS US Address Validation | In case anyone is interested, here is a web service that I created for UPS' | Address Validation. It simply returns a Boolean, yes or no. (See attached) | | | Bryan F. Hogan | Director of Internet Development | Macromedia Certified ColdFusion MX Developer | Digital Bay Media, Inc. | 1-877-72DIGITAL | ~| 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.
RE: deleteclientvariable on mx not working?
I use DeleteClientVariable() alot and it works ok. Try out putting the var after you delete it. cfif isDefined(client.wddxFormBuffer) cfwddx action=WDDX2CFML input=#client.wddxFormBuffer# output=attributes cfset DeleteClientVariable(wddxFormBuffer) cfoutput#CLIENT.wddxFormBuffer#/cfoutput cfabort /cfif That way you can be sure if it's being deleted or not, chances are it's just being created elsewhere. Ade -Original Message- From: Smith, Matthew P -CONT(DYN) [mailto:Matthew.P.Smith;cnet.navy.mil] Sent: 04 November 2002 15:55 To: CF-Talk Subject: deleteclientvariable on mx not working? I'm downloading the mx cfml reference now, but I figured I would fire this off in case anyone knows the answer. I'm sure it is something obvious, but I can't find it. I'm trying to delete a client variable, but it doesn't seem to be working. It works fine on my local box, which is cf5. But when I upload the same app to our MX development server, the client variable is not deleted when it is supposed to be, which is(obviously) causing problems. Does anyone have an idea where it is going wrong? cfif isDefined(client.wddxFormBuffer) cfwddx action=WDDX2CFML input=#client.wddxFormBuffer# output=attributes cfset DeleteClientVariable(wddxFormBuffer) /cfif I have also tried the following: cfset tmp = DeleteClientVariable(wddxFormBuffer) cfset tmp = DeleteClientVariable(client.wddxFormBuffer) Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [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 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
Re: cfqueryparam and preservesinglequotes() was RE: HELP!! sql wierdness ERROR message
S. Isaac Dealey wrote: cfqueryparam can't perform this function, because a sql variable can't be used as a portion of this query -- without first trapping it in something within the db like sp_executesql mystatement or exec(mystatement) ... So queryparam doesn't change the purpose or frequency with which you would use preservesinglequotes() at all... That being said, I rarely find any need to use preservesinglequotes(); and you're right the answer to the original question this thread started with probably lies with cfqueryparam and not preservesinglequotes. cfquery exec(cfqueryparam cfsqltype= value=) /cfquery Would that be possible? ;-) 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
Query works fine in Access, Fails in CF
I get the following error on the query, but when cut and past the select into Access, it works fine. The problem appears to be with my Format statements. When I change the 3 instances to Month() it works fine. However, I need 2-digit months for sorting purposes. Any ideas what might be wrong? [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. Hint: The cause of this error is usually that your query contains a reference to a field which does not exist. You should verify that the fields included in your query exist and that you have specified their names correctly. SQL = SELECT Sum([tabShippedItems].[intShippedItemsQty]) AS intQty, Year([tabInvoice].[datInvoiceDate]) AS strYear, Format([tabInvoice].[datInvoiceDate], mm) AS intMonth FROM tabItemGroups INNER JOIN (tabInvoice INNER JOIN ((tabItems INNER JOIN tabShippedItems ON [tabItems].[strItemID]=[tabShippedItems].[strShippedItemsItemID]) INNER JOIN tabGroupedItems ON [tabItems].[intItem_PK]=[tabGroupedItems].[intItem_PK]) ON [tabInvoice].[intInvoice_PK]=[tabShippedItems].[intInvoice_PK]) ON [tabItemGroups].[intItemGroup_PK]=[tabGroupedItems].[intItemGroup_PK] WHERE ((([tabItemGroups].[intItemGroup_PK])=44) And (([tabShippedItems].[bolShippedItemsDeleted])=False)) GROUP BY Year([datInvoiceDate]), Format([tabInvoice].[datInvoiceDate], mm) ORDER BY Format([tabInvoice].[datInvoiceDate], mm), Year([datInvoiceDate]) DESC; Data Source = OMGSECUREV1 ~| 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.
Replace in string
Hi, I need to output the results as a comma-delimited string. An example of the output from the below code would be like: dir1 dir2 dir3 dir4 dir5 I would like to have: dir1,dir2,dir3,dir4,dir5 Whats wrong with my below syntax? cfdirectory action=LIST directory=d:\books name=DirList sort=name ASC cfoutput query=DirList cfif left(DirList.name,1) neq . #ListGetAt(Replace(DirList.name, ,,,ALL),1,',')# /cfif /cfoutput --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| 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
RE: Passing anchor results to a template
I don't think you need to have the name in there, make it a url variable. Or do you have something else in mind? Ade -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: 04 November 2002 16:04 To: CF-Talk Subject: RE: Passing anchor results to a template The name On Mon, 4 Nov 2002 15:50:45 -, Adrian Lynch wrote: What do you mean by results of the anchor? The name, the href or the text rapped in the tag? -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: 04 November 2002 15:43 To: CF-Talk Subject: Passing anchor results to a template Hi, How can I pass the results of the anchor based on which one is clicked on to another template? Do I need to use JS? a name=test1 id=test1 href=template.cfmtest1/a a name=test2 id=test2 href=template.cfmtest2/a a name=test3 id=test3 href=template.cfmtest3/a --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Passing anchor results to a template
What doth thou mean by 'results'. You can use JavaScript for passing anything you want to another script. Doug -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: Monday, November 04, 2002 10:43 AM To: CF-Talk Subject: Passing anchor results to a template Hi, How can I pass the results of the anchor based on which one is clicked on to another template? Do I need to use JS? a name=test1 id=test1 href=template.cfmtest1/a a name=test2 id=test2 href=template.cfmtest2/a a name=test3 id=test3 href=template.cfmtest3/a --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| 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
Re: what tag captures data from a web page?
Take a look at the CFHTTP tag. -Novak - Original Message - From: Pascal Peters [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, November 04, 2002 8:05 AM Subject: RE: what tag captures data from a web page? cfhttp -Original Message- From: Ed Gordon [mailto:NetDr;callptc.com] Sent: maandag 4 november 2002 16:49 To: CF-Talk Subject: what tag captures data from a web page? If you would, please direct me to what tag or tags (or function) I should look at in order to capture data from an existing internet web page. TIA Ed Gordon ~| 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
RE: Passing anchor results to a template
ah, so you could do something like this...and this maybe off a little in
synatx
script
function sendDaData(obj)
{
document.sendform.name.value = obj.name;
document.sendform.submit();
}
/script
form name=sendform action=foo.cfm method=post
input type=hidden name=name
/form
a name=test1 id=test1 href=template.cfm
onclick=sendDaData(this)'test1/a
Doug
-Original Message-
From: FlashGuy [mailto:flashmx;rogers.com]
Sent: Monday, November 04, 2002 11:04 AM
To: CF-Talk
Subject: RE: Passing anchor results to a template
The name
On Mon, 4 Nov 2002 15:50:45 -, Adrian Lynch wrote:
What do you mean by results of the anchor? The name, the
href or the text
rapped in the tag?
-Original Message-
From: FlashGuy [mailto:flashmx;rogers.com]
Sent: 04 November 2002 15:43
To: CF-Talk
Subject: Passing anchor results to a template
Hi,
How can I pass the results of the anchor based on which one
is clicked on to
another template? Do I need to use JS?
a name=test1 id=test1 href=template.cfmtest1/a
a name=test2 id=test2 href=template.cfmtest2/a
a name=test3 id=test3 href=template.cfmtest3/a
---
Colonel Nathan R. Jessop
Commanding Officer
Marine Ground Forces
Guatanamo Bay, Cuba
---
~|
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
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
RE: CFXML newbie needs help
Looks like you have an extra space, change this line xsi: noNamespaceSchemaLocation=C:\CfusionMX\wwwroot\doc.xsd to xsi:noNamespaceSchemaLocation=C:\CfusionMX\wwwroot\doc.xsd Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: SMR [mailto:info;smrenterprises.com] Sent: Monday, November 04, 2002 11:11 AM To: CF-Talk Subject: CFXML newbie needs help Just trying to do a simple CFXML outputbut the webpage just hangs and doesn't error out or anything.. like its running in a never ending loop..The code below is based on an example from the CFMX New Riders book.. Here is my xsd: ?xml version=1.0 encoding=UTF-8? !-- edited with XMLSPY v5 rel. 2 U (http://www.xmlspy.com) by SMR (SMR) -- xs:schema xmlns:xs=http://www.w3.org/2001/XMLSchema; elementFormDefault=qualified targetNamespace=http://127.0.0.1:8500/; xmlns=http://127.0.0.1:8500/; xs:element name=document xs:complexType xs:sequence xs:element name=doc_file_name type=xs:string/ xs:element name=doc_description type=xs:string/ xs:element name=doc_filesize type=xs:string/ /xs:sequence /xs:complexType /xs:element /xs:schema Here is my cfm: cfquery name=getdoc datasource=ncw dbtype=ODBC select doc_file_name, doc_filesize, doc_description from document /cfquery Query Done... cfsavecontent variable=tempxml?xml version=1.0 encoding=UTF-8? doc-list xmlns:xsi=http://127.0.0.1:8500/; xsi: noNamespaceSchemaLocation=C:\CfusionMX\wwwroot\doc.xsd cfoutput query=getdoc document doc_file_name#Trim(XMLFormat(doc_file_name))#/doc_file_name doc_description#Trim(XMLFormat(doc_description))#/doc_description doc_filesize#Trim(XMLFormat(doc_filesize))#/doc_filesize /document /cfoutput /doc-list /cfsavecontent Save content done... cfset myXMLDocument=XmlParse(tempxml) This is my xml document cfdump var=#myXMLDocument# cffile action=write file=#ExpandPath(.)#/document.xml output=#ToString(tempxml)# ~| 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
OT: Bind 8.1 (on Windows) Gurus?
Have a question (that probably will take all of 3 mins) about Bind 8.1 that I can't seem to resolve. Any gurus around that can contact me off-list? TTAIA Lee ~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
OT: Autonomy/CF/Clearance
Hi, Do you know something about Autonomy, ColdFusion and are you a current holder of a Secret or above clearance. If so please mail me off list. Thanks, Tim ~| 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
RE: Replace in string
You are making it too complicated, just use the ListChangeDelims() function. CFSET l=dir1 dir2 dir3 dir4 dir5 CFOUTPUT #ListChangeDelims(l, ,, )# /CFOUTPUT -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: Monday, November 04, 2002 11:24 AM To: CF-Talk Subject: Replace in string Hi, I need to output the results as a comma-delimited string. An example of the output from the below code would be like: dir1 dir2 dir3 dir4 dir5 I would like to have: dir1,dir2,dir3,dir4,dir5 Whats wrong with my below syntax? cfdirectory action=LIST directory=d:\books name=DirList sort=name ASC cfoutput query=DirList cfif left(DirList.name,1) neq . #ListGetAt(Replace(DirList.name, ,,,ALL),1,',')# /cfif /cfoutput --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: permission Issue
Bobby thanks you. At 12:57 AM 04/11/02 -0500, you wrote: I think the problem might be that Bobby doesn't have permission to read files in the directory above the protected one. And since Bobby is not IUSER, he doesn't have access to the directory above the protected one. ColdFusion is probably trying to read some file in that directory (like application.cfm), and is failing. So the solution is to give Bobby read access to the whole site. Russ -Original Message- From: brook [mailto:brook;maracasmedia.com] Sent: Sunday, November 03, 2002 11:24 PM To: CF-Talk Subject: permission Issue This sounds like the same problem Lee was having. I have a website which allows anonymous connections. The cfm file's are served up properly here. The folder has read/readexecute permissions for the IUSER. Then there is Virtual Directory inside of this website which restricts access using windows authentication. This folder has read/readexecute permissions for a user, lets call him Bobby. Bobby can log into this directory when prompted but when he attempts to access a cfm file, he gets the password prompt. Bobby has permissions on the files in the directory and also read/readexecute on the wsconfig\1\jrun.dll. Bobby can access html files just fine. If access to this virtual directory is set back to allow anonymous access, there is no password prompt when the cfm files are requested. So, Bobby does not have permission to execute cfm files. Where did I go wrong on the settings, what am I missing? Brook ~| 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.
RE: cfqueryparam and preservesinglequotes() was RE: HELP!! sql wierdness ERROR message
Of course a lot of this is academic anyway. Jochem is correct of course that much (perhaps all of this) of this is now handled (better) with CFQUERYPARAM. The PreserveSingleQuotes() function was one of the original functions (I believe all the way back to version 1.0). It made sense when it was created but it really only makes sense now if you can't, for some reason, use CFQUERYPARAM. erm... I think you got that a little backwards. The purpose of PreserveSingleQuotes() is to allow you to pass a sql statement or portion of a sql statement as a variable into a query, i.e. cfset mywhereclause = mycolumn='something' cfquery ... SELECT * FROM mytable WHERE #preservesinglequotes(mywhereclause)# /cfquery That would be a case where, for some reason, you can't use CFQUERYPARAM. ;^) But if the statement was: cfset mywhereclause = something cfquery ... SELECT * FROM mytable WHERE mycolumn = #preservesinglequotes(mywhereclause)# /cfquery (Not a good example, I know) Then you could use: cfset mywhereclause = something cfquery ... SELECT * FROM mytable WHERE mycolumn = CFQUERYPARAM... /cfquery As an asside -- I remember that prior to my becoming involved with cf, the syntax for cfquery was cfquery datasource=blah sql=sql statement here Yup - that was true (and best forgotten). What a PITA. ;^) cfquery sql=#mysqlstatement# in which case the only way to make the statement work if the #mysqlstatement# variable contained something like mycolumn='something' would be to use #preservesinglequotes(mysqlstatement)#. Exactly - I agree totally. My point was really that PerserveSingleQuotes used to be needed in all cases like that. Really all over the place. Now, if at all possible (which is isn't in your example), you should use CFQUERYPARAM and reserve PreserveSingleQuotes for examples like yours. Honestly I'm not really sure of there are other classes of examples that make sense... Of course I don't know SQL as well as you so I may be missing a lot, but this one seems to be the big one if not the only one. Jim Davis ~| 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
RE: Replace in string
Try valueList(dirList.name) Tim -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: Monday, November 04, 2002 11:24 AM To: CF-Talk Subject: Replace in string Hi, I need to output the results as a comma-delimited string. An example of the output from the below code would be like: dir1 dir2 dir3 dir4 dir5 I would like to have: dir1,dir2,dir3,dir4,dir5 Whats wrong with my below syntax? cfdirectory action=LIST directory=d:\books name=DirList sort=name ASC cfoutput query=DirList cfif left(DirList.name,1) neq . #ListGetAt(Replace(DirList.name, ,,,ALL),1,',')# /cfif /cfoutput --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| 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
HTML E-mails with CFMAIL
I'm trying to create an HTML e-mail that is readable in Eudora. I created an HTML page that works in a browser, but Eudora drops all the formatting. Is there a way to make an HTML e-mail that is readable in Eudora, or can I create the page as a file that I can attach with CFMAIL? Thanks, T ~| 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.
Persistent CFC's in the client scope
Can any one explain how you would use client variables and persistence with a CFC? Raymond Camden said it was possible, but I'm not sure how it would work. Interestingly, I could not find any mention of using the client scope with CFC's from macromedia. Does this mean it is not supported? Is the client variable method of maintaining state being replaced by J2EE sessions? Is J2EE sessions even the right term for this new way of storing session state? Brook ~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Replace in string
Try this
CFPARAM NAME=VARIABLES.DIRECTORYLIST DEFAULT=
CFDIRECTORY ACTION=LIST DIRECTORY=D:\BOOKS NAME=DirList SORT=name
ASC
CFLOOP QUERY=DirList
CFIF TYPE IS DIR AND FINDNOCASE('.',NAME) IS 0
CFSET VARIABLES.DIRECTORYLIST=VARIABLES.DIRECTORYLIST','NAME
/CFIF
/CFLOOP
CFSET
VARIABLES.DIRECTORYLIST=RIGHT(VARIABLES.DIRECTORYLIST,LEN(DIRECTORYLIST)-1)
CFOUTPUT#DIRECTORYLIST#/CFOUTPUT
Bryan F. Hogan
Director of Internet Development
Macromedia Certified ColdFusion MX Developer
Digital Bay Media, Inc.
1-877-72DIGITAL
-Original Message-
From: FlashGuy [mailto:flashmx;rogers.com]
Sent: Monday, November 04, 2002 11:24 AM
To: CF-Talk
Subject: Replace in string
Hi,
I need to output the results as a comma-delimited string. An example of the
output from the below code would be like:
dir1 dir2 dir3 dir4 dir5
I would like to have:
dir1,dir2,dir3,dir4,dir5
Whats wrong with my below syntax?
cfdirectory action=LIST directory=d:\books name=DirList sort=name
ASC
cfoutput query=DirList
cfif left(DirList.name,1) neq .
#ListGetAt(Replace(DirList.name, ,,,ALL),1,',')#
/cfif
/cfoutput
---
Colonel Nathan R. Jessop
Commanding Officer
Marine Ground Forces
Guatanamo Bay, Cuba
---
~|
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
RE: deleteclientvariable on mx not working?
That's what gets me: If I try to output it immediately afterwards in that section of code, it throws an undefined error, as it should. But on the recursive call, even though the delete was run on the client variable, it is defined. Here's some more code so you can get an idea what I'm trying to do. Remember, it works perfectly on CF5. cfif notLoggedIn and not fusebox.isCustomTag !--- preserve their formfields if they just submitted a form --- cfif isDefined(form.fieldNames) cfwddx action=CFML2WDDX input=#attributes# output=client.wddxFormBuffer /cfif cfset client.authenticationReturnFuseAction = #attributes.fuseaction# cflocation addtoken=No url=#self#/fuseaction/authentication.go/index.cfm /cfif cfif isDefined(client.wddxFormBuffer) cfoutputI am still defined/cfoutput cfwddx action=WDDX2CFML input=#client.wddxFormBuffer# output=attributes cfset DeleteClientVariable(wddxFormBuffer) !--- throws error if uncommented --- !--- #client.wddxFormBuffer# --- /cfif -Original Message- From: Adrian Lynch [mailto:adrian.l;thoughtbubble.net] Sent: Monday, November 04, 2002 10:18 AM To: CF-Talk Subject: RE: deleteclientvariable on mx not working? I use DeleteClientVariable() alot and it works ok. Try out putting the var after you delete it. cfif isDefined(client.wddxFormBuffer) cfwddx action=WDDX2CFML input=#client.wddxFormBuffer# output=attributes cfset DeleteClientVariable(wddxFormBuffer) cfoutput#CLIENT.wddxFormBuffer#/cfoutput cfabort /cfif That way you can be sure if it's being deleted or not, chances are it's just being created elsewhere. Ade -Original Message- From: Smith, Matthew P -CONT(DYN) [mailto:Matthew.P.Smith;cnet.navy.mil] Sent: 04 November 2002 15:55 To: CF-Talk Subject: deleteclientvariable on mx not working? I'm downloading the mx cfml reference now, but I figured I would fire this off in case anyone knows the answer. I'm sure it is something obvious, but I can't find it. I'm trying to delete a client variable, but it doesn't seem to be working. It works fine on my local box, which is cf5. But when I upload the same app to our MX development server, the client variable is not deleted when it is supposed to be, which is(obviously) causing problems. Does anyone have an idea where it is going wrong? cfif isDefined(client.wddxFormBuffer) cfwddx action=WDDX2CFML input=#client.wddxFormBuffer# output=attributes cfset DeleteClientVariable(wddxFormBuffer) /cfif I have also tried the following: cfset tmp = DeleteClientVariable(wddxFormBuffer) cfset tmp = DeleteClientVariable(client.wddxFormBuffer) Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
strange error
Hi, Apologies for the double posting firstly. A client has moved over to a new hosting company, and has started getting this error on a fairly standard page that never threw an error before: Corrupt form data: no leading boundary: != -7d21a0e60332 Any ideas what might be causing this. I can post the code if needed but to be honest its just a standard page with a couple of simple queries. Cheers Will ~| 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
RE: Autonomy/CF/Clearance
I know a secret :OD -Original Message- From: Timothy Heald [mailto:healdt;dsmail.state.gov] Sent: 04 November 2002 16:45 To: CF-Talk Subject: OT: Autonomy/CF/Clearance Hi, Do you know something about Autonomy, ColdFusion and are you a current holder of a Secret or above clearance. If so please mail me off list. Thanks, Tim ~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Server Error-Urgent
Mark, Generally I'd agree with you about queries needing to do the work/calculations...However, this is just basic selects. And so each student has 60+ per quarter. I don't see how to get it to print out one student per page if there are 60+ entries per student. Putting it all in one query makes it come out at 25 x 60. I don't see how to get around this- especially will all of the data I need to gather from the different tables. Unless I'm missing something?? I used to work with Access extensively and when it got to that type of grouping it was in the presentation layer(reports) and not in the actual query --you did it by subqueries/subreports/group by functions in the report. -Original Message- From: Mark A. Kruger - CFG [mailto:mkruger;cfwebtools.com] Sent: Sunday, November 03, 2002 3:50 PM To: CF-Talk Subject: RE: Server Error-Urgent Janine, The trick is to get the calculation to happen on the DB platform and returned as a part of the query. Perhaps the stored proc would be the best place to do this. Grouping requries some practic - trial and error, but it really is the best way to accomplish what you are trying to do here. -mk -Original Message- From: Janine Jakim [mailto:jjakim;albemarle.org] Sent: Saturday, November 02, 2002 10:41 AM To: CF-Talk Subject: RE: Server Error-Urgent Right but I'm not sure how grouping would work for this. I originally tried grouping but couldn't get it to output correctly. The master stored procedure pulls information from all the tables that have a one to one relationship with a student. (school/attendance/teacher/studentinfo) So the master includes 4 tables The nested stored procedure holds all the data for each quarter (each quarter a student is graded on at least 60+ skills) + each quarter there are comments for each student. The nested queries will run for each student and there may be 25 students pulled up at one time. So there's a total of 6 tables involved. Two of which have the multiple records Like I mentioned the queries themself run very quickly- it's when I add the loops for the output that they slow down. How can I re-arrange this? Thanks again -Original Message- From: Mark A. Kruger - CFG [mailto:mkruger;cfwebtools.com] Sent: Friday, November 01, 2002 3:40 PM To: CF-Talk Subject: RE: Server Error-Urgent Janine, Yes - IMO this is pretty inneficient. If I'm looking at this correctly, You are using a master query (studentinformation) followed by one or more sub-queries - one for each row in the master query. This can probably be boiled down to a single query with a group by statement. This would eliminate the need for a nested loop (a cfoutput followed by query looping code). It would be usefule to see how many iterations (total) the inner loop create, then multiply it times the outer cfoutput recordcount. -mk -Original Message- From: Janine Jakim [mailto:jjakim;albemarle.org] Sent: Friday, November 01, 2002 1:22 PM To: CF-Talk Subject: RE: Server Error-Urgent Activepdf is a good product- I agree. But the info it needs to spit out is pretty large- the stored procedures grab all the demographic data than all of the grades for each quarter. I have set up a CFSET X = GetTickCount() on the page in question. This particular section (and there are 4 of them- one for each quarter)is what seems to do it: !---Output student info/teacher name/grade of student--- CFOUTPUT QUERY=StudentInformation blah/blah !---This is the bottleneck. Check to see if any grades are recorded for the quarter- if set the grade for activepdf (Tlkt)and if not set to --- CFIF GradesQuarter3.RecordCount GTE 1 CFLOOP INDEX=X FROM=1 TO=#GradesQuarter3.RecordCount# CFSET I= ToString(x) CFSET Grade#I#Quarter3=Tlkt.SetFormFieldData(Grade#I#Quarter3, #GradesQuarter3.GradeForSubject[I]#, 0) /CFLOOP CFELSE CFSET GRADE#I#Quarter3=Tlkt.SetFormFieldData(GRADE#I#Quarter3, , 0) /CFIF !---Repeat the same code above for each quarter...--- /CFOUTPUT Is this code inefficient? Is there a betterway for me to do the same thing? -Original Message- From: Mark A. Kruger - CFG [mailto:mkruger;cfwebtools.com] Sent: Friday, November 01, 2002 12:08 PM To: CF-Talk Subject: RE: Server Error-Urgent Janine, Active PDF is a COM and reputedly a good one - but it still introduces an external process into your page request. I'd start there. Why don't you post the code (or the cfoutput/looping part of it). -mk -Original Message- From: Janine Jakim [mailto:jjakim;albemarle.org] Sent: Friday, November 01, 2002 10:42 AM To: CF-Talk Subject: RE: Server Error-Urgent I have a page that the queries run really quickly but when I set them to cfoutput loop/cfset to set for activepdf they slow to a crawl. I've been trying to figure out how to speed up this page. -Original Message- From: [EMAIL PROTECTED]
Re: CFXML newbie needs help
Didn't solve the problem. - Original Message - From: Bryan F. Hogan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, November 04, 2002 11:38 AM Subject: RE: CFXML newbie needs help Looks like you have an extra space, change this line xsi: noNamespaceSchemaLocation=C:\CfusionMX\wwwroot\doc.xsd to xsi:noNamespaceSchemaLocation=C:\CfusionMX\wwwroot\doc.xsd Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: SMR [mailto:info;smrenterprises.com] Sent: Monday, November 04, 2002 11:11 AM To: CF-Talk Subject: CFXML newbie needs help Just trying to do a simple CFXML outputbut the webpage just hangs and doesn't error out or anything.. like its running in a never ending loop..The code below is based on an example from the CFMX New Riders book.. Here is my xsd: ?xml version=1.0 encoding=UTF-8? !-- edited with XMLSPY v5 rel. 2 U (http://www.xmlspy.com) by SMR (SMR) -- xs:schema xmlns:xs=http://www.w3.org/2001/XMLSchema; elementFormDefault=qualified targetNamespace=http://127.0.0.1:8500/; xmlns=http://127.0.0.1:8500/; xs:element name=document xs:complexType xs:sequence xs:element name=doc_file_name type=xs:string/ xs:element name=doc_description type=xs:string/ xs:element name=doc_filesize type=xs:string/ /xs:sequence /xs:complexType /xs:element /xs:schema Here is my cfm: cfquery name=getdoc datasource=ncw dbtype=ODBC select doc_file_name, doc_filesize, doc_description from document /cfquery Query Done... cfsavecontent variable=tempxml?xml version=1.0 encoding=UTF-8? doc-list xmlns:xsi=http://127.0.0.1:8500/; xsi: noNamespaceSchemaLocation=C:\CfusionMX\wwwroot\doc.xsd cfoutput query=getdoc document doc_file_name#Trim(XMLFormat(doc_file_name))#/doc_file_name doc_description#Trim(XMLFormat(doc_description))#/doc_description doc_filesize#Trim(XMLFormat(doc_filesize))#/doc_filesize /document /cfoutput /doc-list /cfsavecontent Save content done... cfset myXMLDocument=XmlParse(tempxml) This is my xml document cfdump var=#myXMLDocument# cffile action=write file=#ExpandPath(.)#/document.xml output=#ToString(tempxml)# ~| 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
RE: Persistent CFC's in the client scope
Interestingly, I could not find any mention of using the client scope with CFC's from macromedia. Does this mean it is not supported? Is the client variable method of maintaining state being replaced by J2EE sessions? Is J2EE sessions even the right term for this new way of storing session state? Errr...Client variables are simple values only. No Arrays, Structures, Queries or...Objects. ~| 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.
CFMX architecutre question
Ok, so in CFMX when a cfm is called up, a Java Class file is created and blah...blah.blah. What happens to those class files? Are they deleted at some point? When I build out a box, I put CF on the C drive which sits pretty on its own SMALL partition. I don't want to run out of disk space due to these class files. Can the location of these files be changed? Cheers! -- Douglas Knudsen Alltel Corporate CIS Group 678-351-6063 Spoon feeding in the long run teaches us nothing but the shape of the spoon. - E.M. Forster ~| 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
Re: Persistent CFC's in the client scope
Can any one explain how you would use client variables and persistence with a CFC? Raymond Camden said it was possible, but I'm not sure how it would work. Interestingly, I could not find any mention of using the client scope with CFC's from macromedia. Does this mean it is not supported? Is the client variable method of maintaining state being replaced by J2EE sessions? Is J2EE sessions even the right term for this new way of storing session state? I would imagine that you would serialize all the properties of the CFC into a wddx packet and then store that wddx packet as a client variable, which can then be deserialized and used to instantiate the CFC. You probably wouldn't want to store or retrieve the packet on each page request, but this would allow you to store the CFC's properties for the client machine for a longer period of time than session variables. I have no idea re: J2EE sessions. S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ~| 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
Re: Persistent CFC's in the client scope
Or you could just store the CFC's properties each in individual client variables and use them to instantiate the component. No wddx overhead -- doable on each page request if desireable. S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 Can any one explain how you would use client variables and persistence with a CFC? Raymond Camden said it was possible, but I'm not sure how it would work. Interestingly, I could not find any mention of using the client scope with CFC's from macromedia. Does this mean it is not supported? Is the client variable method of maintaining state being replaced by J2EE sessions? Is J2EE sessions even the right term for this new way of storing session state? ~| 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
RE: deleteclientvariable on mx not working?
I guess the think to do is step through your code with cfoutput#CLIENT.wddxFormBuffer#/cfoutputcfabort and trace down the offending bit of code. I doubt it will be a cfmx bug, but then again. :OP Ade -Original Message- From: Smith, Matthew P -CONT(DYN) [mailto:Matthew.P.Smith;cnet.navy.mil] Sent: 04 November 2002 17:05 To: CF-Talk Subject: RE: deleteclientvariable on mx not working? That's what gets me: If I try to output it immediately afterwards in that section of code, it throws an undefined error, as it should. But on the recursive call, even though the delete was run on the client variable, it is defined. Here's some more code so you can get an idea what I'm trying to do. Remember, it works perfectly on CF5. cfif notLoggedIn and not fusebox.isCustomTag !--- preserve their formfields if they just submitted a form --- cfif isDefined(form.fieldNames) cfwddx action=CFML2WDDX input=#attributes# output=client.wddxFormBuffer /cfif cfset client.authenticationReturnFuseAction = #attributes.fuseaction# cflocation addtoken=No url=#self#/fuseaction/authentication.go/index.cfm /cfif cfif isDefined(client.wddxFormBuffer) cfoutputI am still defined/cfoutput cfwddx action=WDDX2CFML input=#client.wddxFormBuffer# output=attributes cfset DeleteClientVariable(wddxFormBuffer) !--- throws error if uncommented --- !--- #client.wddxFormBuffer# --- /cfif -Original Message- From: Adrian Lynch [mailto:adrian.l;thoughtbubble.net] Sent: Monday, November 04, 2002 10:18 AM To: CF-Talk Subject: RE: deleteclientvariable on mx not working? I use DeleteClientVariable() alot and it works ok. Try out putting the var after you delete it. cfif isDefined(client.wddxFormBuffer) cfwddx action=WDDX2CFML input=#client.wddxFormBuffer# output=attributes cfset DeleteClientVariable(wddxFormBuffer) cfoutput#CLIENT.wddxFormBuffer#/cfoutput cfabort /cfif That way you can be sure if it's being deleted or not, chances are it's just being created elsewhere. Ade -Original Message- From: Smith, Matthew P -CONT(DYN) [mailto:Matthew.P.Smith;cnet.navy.mil] Sent: 04 November 2002 15:55 To: CF-Talk Subject: deleteclientvariable on mx not working? I'm downloading the mx cfml reference now, but I figured I would fire this off in case anyone knows the answer. I'm sure it is something obvious, but I can't find it. I'm trying to delete a client variable, but it doesn't seem to be working. It works fine on my local box, which is cf5. But when I upload the same app to our MX development server, the client variable is not deleted when it is supposed to be, which is(obviously) causing problems. Does anyone have an idea where it is going wrong? cfif isDefined(client.wddxFormBuffer) cfwddx action=WDDX2CFML input=#client.wddxFormBuffer# output=attributes cfset DeleteClientVariable(wddxFormBuffer) /cfif I have also tried the following: cfset tmp = DeleteClientVariable(wddxFormBuffer) cfset tmp = DeleteClientVariable(client.wddxFormBuffer) Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [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 Get the mailserver that powers this list at http://www.coolfusion.com
RE: CFXML newbie needs help
Ok then, sorry I could not help :) Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: SMR [mailto:info;smrenterprises.com] Sent: Monday, November 04, 2002 12:15 PM To: CF-Talk Subject: Re: CFXML newbie needs help Didn't solve the problem. - Original Message - From: Bryan F. Hogan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, November 04, 2002 11:38 AM Subject: RE: CFXML newbie needs help Looks like you have an extra space, change this line xsi: noNamespaceSchemaLocation=C:\CfusionMX\wwwroot\doc.xsd to xsi:noNamespaceSchemaLocation=C:\CfusionMX\wwwroot\doc.xsd Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: SMR [mailto:info;smrenterprises.com] Sent: Monday, November 04, 2002 11:11 AM To: CF-Talk Subject: CFXML newbie needs help Just trying to do a simple CFXML outputbut the webpage just hangs and doesn't error out or anything.. like its running in a never ending loop..The code below is based on an example from the CFMX New Riders book.. Here is my xsd: ?xml version=1.0 encoding=UTF-8? !-- edited with XMLSPY v5 rel. 2 U (http://www.xmlspy.com) by SMR (SMR) -- xs:schema xmlns:xs=http://www.w3.org/2001/XMLSchema; elementFormDefault=qualified targetNamespace=http://127.0.0.1:8500/; xmlns=http://127.0.0.1:8500/; xs:element name=document xs:complexType xs:sequence xs:element name=doc_file_name type=xs:string/ xs:element name=doc_description type=xs:string/ xs:element name=doc_filesize type=xs:string/ /xs:sequence /xs:complexType /xs:element /xs:schema Here is my cfm: cfquery name=getdoc datasource=ncw dbtype=ODBC select doc_file_name, doc_filesize, doc_description from document /cfquery Query Done... cfsavecontent variable=tempxml?xml version=1.0 encoding=UTF-8? doc-list xmlns:xsi=http://127.0.0.1:8500/; xsi: noNamespaceSchemaLocation=C:\CfusionMX\wwwroot\doc.xsd cfoutput query=getdoc document doc_file_name#Trim(XMLFormat(doc_file_name))#/doc_file_name doc_description#Trim(XMLFormat(doc_description))#/doc_description doc_filesize#Trim(XMLFormat(doc_filesize))#/doc_filesize /document /cfoutput /doc-list /cfsavecontent Save content done... cfset myXMLDocument=XmlParse(tempxml) This is my xml document cfdump var=#myXMLDocument# cffile action=write file=#ExpandPath(.)#/document.xml output=#ToString(tempxml)# ~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: CFMX architecutre question
I think you have to edit the web.xml file in wwwroot\WEB-INF\web.xml I just opened it up and it looks like this bit context-param param-namecoldfusion.compiler.outputDir/param-name param-value/WEB-INF/cfclasses/param-value descriptionThis is the directory where we will place compiled pages. It must be relative to the webapp root./description /context-param But don't just take my word for it. Ade -Original Message- From: [EMAIL PROTECTED] [mailto:Douglas.Knudsen;alltel.com] Sent: 04 November 2002 17:35 To: CF-Talk Subject: CFMX architecutre question Ok, so in CFMX when a cfm is called up, a Java Class file is created and blah...blah.blah. What happens to those class files? Are they deleted at some point? When I build out a box, I put CF on the C drive which sits pretty on its own SMALL partition. I don't want to run out of disk space due to these class files. Can the location of these files be changed? Cheers! -- Douglas Knudsen Alltel Corporate CIS Group 678-351-6063 Spoon feeding in the long run teaches us nothing but the shape of the spoon. - E.M. Forster ~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: HTML E-mails with CFMAIL
I'm trying to create an HTML e-mail that is readable in Eudora. I created an HTML page that works in a browser, but Eudora drops all the formatting. Is there a way to make an HTML e-mail that is readable in Eudora, or can I create the page as a file that I can attach with CFMAIL? Thanks, You can use type=html in the cfmail tag, although the mail client I use ( not Eudora ) doesn't recognize this as a properly formatted html email. If you're going to send these emails to anyone other than yourself you might want to look into using a multi-part email with a text format followed by an html format -- somewhere I've got a custom tag i built for myself that pushes an email this way and allows me to toggle between text and html in the email client I use. Let me know if you'd like to see the source and I'll forward it on. S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ~| 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.
RE: Replace in string
Hi, I need to output the results as a comma-delimited string. An example of the output from the below code would be like: dir1 dir2 dir3 dir4 dir5 I would like to have: dir1,dir2,dir3,dir4,dir5 Whats wrong with my below syntax? cfdirectory action=LIST directory=d:\books name=DirList sort=name ASC cfoutput query=DirList cfif left(DirList.name,1) neq . #ListGetAt(Replace(DirList.name, ,,,ALL),1,',')# /cfif /cfoutput If the dir1 dir2... and so on come from the query (the one returned by CFDIRECTORY) you can easily turn the values into a list using the ValueList() function. This will return a single column of data (from a query) as a list. Hope this helps, Jim Davis ~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
