RE: Getting CF to trigger a SQL data export to text file
Create a DTS in MS SQL Execute the DTS from the Command line. Lots of stuff has been posted about running DTS from a command line. -Original Message- From: Scott Weikert [mailto:[EMAIL PROTECTED] Sent: Sunday, November 09, 2003 5:48 PM To: CF-Talk Subject: Getting CF to trigger a SQL data export to text file Hey gang, Been bouncing around the MS SQL books online docs but haven't figured out a way to do what I want. What I'm after is a way to take the contents of a DB view and export those contents into an external text file, much like you can do the opposite with the SQL function BULK INSERT. At the moment I'm doing it the hard way - query, loop on query, build up long string, write string out to file with CFFILE. But it's slow and clunky. I'm looking to offload the work onto the SQL server itself which should be much faster. Any prodding toward the solution would be greatly appreciated. --Scott [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: RSS displayed in CF
http://www.cflib.org/udf.cfm?id=813Check this out TranslateRSSItems -Original Message- From: Wurst, Keith D. [mailto:[EMAIL PROTECTED] Sent: Friday, November 07, 2003 1:31 PM To: CF-Talk Subject: RSS displayed in CF hey everyone. does anyone have a good example of how to display a RSS file on a CF based website (not mx)? thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF5 - Application Log Format ??
Can anyone tell me where I can find the layout of the application.log for CF5 I have searched for it but cannot get a hit Bartee Lamar www.enterpriseenergy.com http://www.enterpriseenergy.com/ MSN mailto:[EMAIL PROTECTED] [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
SSL Certificate usage in Cold Fusion
I have purchased a secure certificate from GeoTrust. I have it installed in IIS under the www.mycustomer.com web site. I can view the certificate in IIS. My question what mean of relocation / redirection do I use in Cold fusion to get page to show using this certificate. I am showing a age to enter credit card numbers. I am using CFLOCATION url= https://www.mycustomer.com/index.cfm?fuseaction=cart.dspcrditcard https://www.mycustomer.com/index.cfm?fuseaction=cart.dspcrditcard token=yes NOTE: there is an S in the https .. Is this the correct way to do this?? I am getting a page unable to display. If I change the same URL to http it will work. Any suggestion and/or idea would greatly be appreciated. I really need to get this to work. Bartee Lamar www.enterpriseenergy.com http://www.enterpriseenergy.com/ MSN mailto:[EMAIL PROTECTED] [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
OT vti_encoding What is VTI ????
I am seeing subdirectories named _vti_cnf In the subdirectory there is a file for each file in the parent directory with the same name. the contents of the file looks like: vti_encoding:SR|utf8-nl vti_timelastmodified:TR|08 Feb 2002 19:44:11 - vti_extenderversion:SR|4.0.2.5526 I do 99% of my editing in CF studio 5. Any one have an Idea what this is? Bartee Lamar www.enterpriseenergy.com http://www.enterpriseenergy.com/ MSN mailto:bartee;enterpriseenery.com [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
Help !! CF 4.5 / cfx_zip Timed out waiting for zip engine
Has anyone seen this problem. This just started occurring on a site that has been running for two years and has not been changed? Any ideas would be greatly appreciated... Bartee Lamar www.enterpriseenergy.com http://www.enterpriseenergy.com/ MSN mailto:bartee;enterpriseenery.com [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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
CF and Pegasus software ImagesASAP
Is any one using the Pegasus ImagesASAP object from CF. Any hints on problems and any gotcha's using from CF and not ASP. FYI This does image manipulation on the server side. Bartee Lamar www.enterpriseenergy.com http://www.enterpriseenergy.com/ MSN mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Does there exist...
http://www.sswug.org/ Bartee Lamar www.enterpriseenergy.com MSN [EMAIL PROTECTED] -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 10:31 AM To: CF-Talk Subject: Re: Does there exist... If I am not mistaken There is a SQL list here at House of Fusion. [EMAIL PROTECTED] 10/07/02 10:19AM Does there exist...a forum like CF-Talk or CFDList with regards to Microsoft SQL Server? I need to brush up on Maintaing SQL Server, DTS, stored procedures and T-SQL. Any all encompassing lists would be great! TIA - ChT ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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
application query cached HOW TO??
I need to cache a query for the entire application. I have a set of application settings in a database table. I want to read that table once and have it in the application scope to be accessed each time a new session is started. ( just like setting request variables in application.cfm ) How do I do that. Bartee Lamar www.enterpriseenergy.com http://www.enterpriseenergy.com/ MSN mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Registry 129 meg ... CF 5.0
Is there any thing in CF that would cause a VERY large registry It does not look like CF is set to use Registry for client variables. Any Knowledge based articles, I cannot find any Where in Registry does CF store stuff... Bartee Lamar www.enterpriseenergy.com http://www.enterpriseenergy.com/ MSN mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: OT Generating a data/Enterprise Manager
Would DTS Work for you. Bartee Lamar www.enterpriseenergy.com MSN [EMAIL PROTECTED] -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 1:16 AM To: CF-Talk Subject: OT Generating a data/Enterprise Manager Hey Folks! I am wanting to export a table and all the data in it into a SQL script that can be ran to import the data into another database. I can script the table creation, and dump the data to a file, but how can I combine the two together so I can run a 'script' and have it create the table and import the values at the same time? Is it possible? Thanks Paul Giesenhagen QuillDesign __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFInput - Reg Expr to validate filename
Does someone have a RE that I can use in the validate function for CFINPUT to check for a valid windows filename xx.yyy A customer on a mac got a line feed character into a field that was used for file name in a CFCOPY function. Bartee Lamar www.enterpriseenergy.com http://www.enterpriseenergy.com/ MSN mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFInput - Reg Expr to validate filename - ANSWER
cfinput message=Invalid File name. Must be a valid Windows Filename.
validate=regular_expression pattern=^\w+\.\w{3}$ name=WebFileName
size=30
Thanks to google regular expression validate filename
Thanks to www.massimocorner.com Dreamweaver / Behaviors RegExp
Validator 1.3
Bartee Lamar
www.enterpriseenergy.com
MSN [EMAIL PROTECTED]
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
eCommerce - shopping carts - Your Opinion.
I have client who wants a site to sell jewelry. This needs to be delivered in January. Based on their budget I cannot write one from scratch. What is your experience? I would expect to have source code, credit card processing and SQL database. I generally write in Fusebox 3 so that would be nice but not necessary. This will be low volume. I have my own web server and SQL If this has already been documented. point me to it. Looking at CF Dev Exchange I see. CartEase $295 eConstruct $599 eCommerce System $5,000 Quick Cart $0.00 JustACart $0.00 InstanteStore $0.00 Others??? Have you used any of these? Have you modified ? Site Examples ? Bartee Lamar www.enterpriseenergy.com http://www.enterpriseenergy.com/ MSN mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: VB and CF
I am also starting doing some work in ASP. Something very interesting. Many hard core VB programmers use Homesite not MS Ide for coding. The MS IDE has some merit since it will expand object constructs good in the early stages. You of course will need an IIS web server to run your stuff. I now usually use CF5 studio ( basically Homesite) for my ASP coding. Here is a site I have found invaluable for ASP/ADO and more.. http://www.devguru.com/ This site has complete indexes and reference on ASP, ADO, VBScript and more Bartee Lamar www.enterpriseenergy.com MSN [EMAIL PROTECTED] -Original Message- From: Kodjo Ackah [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 04, 2002 4:25 AM To: CF-Talk Subject: VB and CF I use CFStudio at the moment, I need to branch into VB for a project. I am not certain but, can I just download VB 6 install it on my PC and work away or is there any specifics with doing this that I need to know? Also, there is no application server(I mean Coldfusion server) installed on my PC. Do I have to uninstall CFStudio before installing VB? Kodjo Ackah Principal Consultant Concrete Media Ltd 32 Great Sutton Street Clerkenwell London, EC1V 0DX Tel:+44 (0)20 7251 8090 Fax: +44 (0)20 7251 8780 Mobile: +44 (0)07748 79 1038 Office Location: http://www.streetmap.co.uk/streetmap.dll?G2M?X=531852Y=182204A=YZ=1 http://www.streetmap.co.uk/streetmap.dll?G2M?X=531852Y=182204A=YZ=1 __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF-related software wish list
While your at it make sure you have budget for a separate development/testing environment both hardware and software. This may include extra copies of server software for web/mail/database. Bartee Lamar www.enterpriseenergy.com MSN [EMAIL PROTECTED] -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 04, 2002 12:48 PM To: CF-Talk Subject: RE: CF-related software wish list Gotta love managers. What we need is a specific list of unknown software that we will need to solve unexpected problems we encounter All joking aside, that is a fairly wide net to cast. But, here is what I use daily on my computer or server. CF studio DWMX Fireworks MX IMS Mail MS Office SQL Server ewebedit Pro Webtrends TopStyle Pro 3 Ultra Edit (for the stuff CF studio won't do) Winamp :-) PC Anywhere IP switch FTP client -Original Message- From: Cornillon, Matthieu [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 04, 2002 11:22 AM To: CF-Talk Subject: OT: CF-related software wish list Hi, everyone. My manager has asked me to put together a list of potential software purchases for the next year. I am a rather new ColdFusion developer, so I don't really know much in terms of CF-related software. So far, I have only come up with Visual SourceSafe and some sort of HTMLEditing CF tag. Are there other pieces of software that I should evaluate? Anything that you all find indispensable, that aids in coding, etc.? Thanks, Matthieu __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: CF-related software wish list
http://www.techsmith.com/ Snag-it A great little screen capture program. If you really want to get a high budget item get ERWin or one of the other ERD database design programs/environments. These get pricy, starting at about $3,000 Bartee Lamar www.enterpriseenergy.com MSN [EMAIL PROTECTED] -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 04, 2002 1:00 PM To: CF-Talk Subject: Re: OT: CF-related software wish list As a standard set of development tools, I always include Winzip, NAV, a binary editor (UltraEdit), a screen capture utility (html2jpg), a graphics package (Fireworks or Photoshop), a flowcharting tool (Visio works fine), a standard office suite, a link checker (Linkbot), an FTP program (FTP Voyager), if I am lucky, a UNIX shell (MKS), pdf tools (Acrobat, Ghostscript). Java compiler and editor (to avoid a religious war, I won;t recommend one :). Lately an XML editor (XML Spy). On top of that, any code you can buy or steal will do you well. As for specifically CF stuff: I've got the SiteObjects HTML editor and love it. The iMS system looks great (although we rolled our own, here). PDF conversion tools can always find a use. Jerry Johnson [EMAIL PROTECTED] 09/04/02 12:21PM Hi, everyone. My manager has asked me to put together a list of potential software purchases for the next year. I am a rather new ColdFusion developer, so I don't really know much in terms of CF-related software. So far, I have only come up with Visual SourceSafe and some sort of HTMLEditing CF tag. Are there other pieces of software that I should evaluate? Anything that you all find indispensable, that aids in coding, etc.? Thanks, Matthieu __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFMail - unix line style problem
I have function where a user uploads an HTML file. This gets saved on server as a .txt file. User then requests this file to be mailed to a mailing list. I do cffile action=READ file=#fileDirectoryAndName variable=FileContents Then I send out the file with cfmail to= mailto:[EMAIL PROTECTED] abc mailto:[EMAIL PROTECTED] @abc.com from= mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] subject=TEST NEWSLETTER server=enterpriseenergy.com type=HTML#FileContents#/cfmail When I receive email the file has lines that are garbled. I tried to open this file in CF5 Studio. It gives me a warning about double spaced Unix Style text lines If I look at this file in hex it has CRLR [space] [space] The file was created in Dreamweaver on a MAC running 9.5 ( my customer's computer ) If I output this file after it is read in cfoutput#FileContents#/cfoutput it works in the browser. Hope someone can help, we are supposed to send out his news letter today. So far he is being patient!!! Thanks.. Bartee Lamar www.enterpriseenergy.com http://www.enterpriseenergy.com/ MSN mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Double spaced UNIX style text lines
I have function where a user uploads an HTML file. This gets saved on server as a .txt file. User then requests this file to be mailed to a mailing list. I do cffile action=READ file=#fileDirectoryAndName variable=FileContents Then I send out the file with cfmail to=abc mailto:[EMAIL PROTECTED] @abc.com mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] subject=TEST NEWSLETTER server=enterpriseenergy.com type=HTML#FileContents#/cfmail When I receive email the file has lines that are garbled. I tried to open this file in CF5 Studio. It gives me a warning about double spaced Unix Style text lines If I look at this file in hex it has CRLR [space] [space] The file was created in Dreamweaver on a MAC running 9.5 ( my customer's computer ) If I output this file after it is read in cfoutput#FileContents#/cfoutput it works in the browser. Hope someone can help, we are supposed to send out his news letter today. So far he is being patient!!! Thanks.. Bartee Lamar www.enterpriseenergy.com http://www.enterpriseenergy.com/ MSN mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Credit Card Processor
I need credit card processor for very small account. I know there are services that will do all the processing and simply mail a check once a month. My client does not have a merchant account and does not want to set one up yet. I know these types of processors get like 6% instead of 2% but they understand that. Any input and/or recommendations would be appreciated Bartee Lamar www.enterpriseenergy.com http://www.enterpriseenergy.com/ MSN mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Permissions server to server mapped drive???
I am in a jam. I told the client I could do this and don't really understand Windows server permissions. CF runs on IIS on server A MS SQL runs on server B. Simple task ( at least I thought so.) CF uploads a CSV file. I need to copy that file from CF/IIS server to a directory on the SQL Server. Created S: mapping to SQL Drive D:/MyDir I get a permission error when I try to copy the file. I think I understand that the share of drive D:/myDir on the SQL server has to give permission. The thing I cannot figure out is who is the user for CF/IIS on server A. Both servers are on same LAN Domain I hope someone has the answer because this was supposed to be working on Friday and their network admin does not know the answer and it's really my problem anyway!!! Bartee Lamar www.enterpriseenergy.com http://www.enterpriseenergy.com/ MSN mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF Scheduler - URL Name
What should the URL name look like in CF Scheduler (CF 4.5.2) Should I use a CF Mapping ? Bartee Lamar www.enterpriseenergy.com http://www.enterpriseenergy.com/ MSN mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL checking query
SELECT f.sub_object, p.title, p.sku
FROM menu_table f, product_table p
WHERE p.id = f.sub_object
OR p.id = f.owner
AND f.type = 'product'
AND f.sub_object NOT IN (select id from product_table)
AND f.owner NOT IN (select id from product_table)
Bartee Lamar
www.enterpriseenergy.com
MSN [EMAIL PROTECTED]
-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 10, 2002 1:02 PM
To: CF-Talk
Subject: OT: SQL checking query
Hello folks,
I have an easy one I am sure...
I am trying to build a query that will show all items that are not
found..
Two tables:
Product Table
id, title
Menu Table
id, owner, sub_object
I want to write a query that will find all product IDs in the product
table, that are not found in either the owner OR the sub_object columns
in the menu table.
(looking for orphan records, that are not found anywhere in the menu
table).
Any suggestions, here is what I have so far!
SELECT f.sub_object, p.title, p.sku
FROM menu_table f, product_table p
WHERE p.id = f.sub_object
OR p.id = f.owner
AND f.type = 'product'
AND f.sub_object NOT IN ('p.id')
AND f.owner NOT IN ('p.id')
Obviously this query doesn't work .. i have completely mangled it trying
to get the products that cannot be found in the menu.
Any help is greatly appreciated!
Paul Giesenhagen
QuillDesign
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Dedicated Hosting
www.crystaltech.com I think their great. The will supply cf based boxed and have nice shared SQL server solution. And... I always get a real person being on the phone. Last month they even spotted some bad hardware log entries and replaced the hard drive in my server. Bartee Lamar www.enterpriseenergy.com MSN [EMAIL PROTECTED] -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 11:07 AM To: CF-Talk Subject: OT: Dedicated Hosting We are looking for some additional Dedicated hosting and curious who else on this list uses dedicated hosting and their experience. Looking for some good prices (go figure). Thank you in advance (you can email off-list if you wish). Paul Giesenhagen QuillDesign __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
QueryAddColumn / QuerySetCell ???
I am having trouble setting a cell in a query Code is below the line - Here are things I have know: 1. There column does get created. I can see it in the cfdump ( I love cfdump :-) 2. cfinclude template=qrySelectjobs.cfm does execute I can see the sql on debug output. 2. The value in #qrySelectJobs.RecordCount# is 62 3. The vaue in #RowNumber# is 1 The PROBLEM is the JobsFound does not get set !! cfquery name=qryJobAgent datasource=#setting.dsn# select * from search_job where jobseeker_id = #client.jobseekerid# /cfquery cfset ColumnValues = arraynew(1) cfset temp = queryaddcolumn(qryJobAgent,JobsFound,columnvalues) cfset RowNumber = 0 cfoutput query=qryJobAgent cfset RowNumber = RowNumber + 1 cfinclude template=qrySelectjobs.cfm --- execute another query to get JobFound count cf temp = QuerySetCell(qryJobAgent,JobsFound,#qrySelectJobs.RecordCount#,RowNu mber) #qrySelectJobs.RecordCount# #RowNumber#br - prove there is something in the count /cfoutput cfdump var=#qryjobagent# Bartee Lamar www.enterpriseenergy.com http://www.enterpriseenergy.com/ MSN mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: QueryAddColumn / QuerySetCell ??? Answer !!
Found the solution, with help from ACFUG Much easier to create column in SQL statement DUH!!! ( on my part ) cfquery name=qryJobAgent datasource=#setting.dsn# select *,JobsFound = 0,JobsRespondedTo = 0 from search_job where jobseeker_id = #client.jobseekerid# /cfquery The query return is really an array! I knew that but did not try the obvious solution which was to simply set the new column value with an array spec. cfset qryJobAgent.jobsfound[RowNumber] = qrySelectJobs.RecordCount Orginal code below... Bartee Lamar www.enterpriseenergy.com MSN [EMAIL PROTECTED] -Original Message- From: Bartee Lamar [mailto:[EMAIL PROTECTED]] Sent: Monday, June 24, 2002 12:10 PM To: CF-Talk Subject: QueryAddColumn / QuerySetCell ??? I am having trouble setting a cell in a query Code is below the line - Here are things I know: 1. There column does get created. I can see it in the cfdump ( I love cfdump :-) 2. cfinclude template=qrySelectjobs.cfm does execute I can see the sql on debug output. 2. The value in #qrySelectJobs.RecordCount# is 62 3. The vaue in #RowNumber# is 1 The PROBLEM is the JobsFound does not get set !! -- cfquery name=qryJobAgent datasource=#setting.dsn# select * from search_job where jobseeker_id = #client.jobseekerid# /cfquery cfset ColumnValues = arraynew(1) cfset temp = queryaddcolumn(qryJobAgent,JobsFound,columnvalues) cfset RowNumber = 0 cfoutput query=qryJobAgent cfset RowNumber = RowNumber + 1 cfinclude template=qrySelectjobs.cfm --- execute another query to get JobFound count cf temp = QuerySetCell(qryJobAgent,JobsFound,#qrySelectJobs.RecordCount#,RowNu mber) #qrySelectJobs.RecordCount# #RowNumber#br - prove there is something in the count /cfoutput cfdump var=#qryjobagent# Bartee Lamar www.enterpriseenergy.com http://www.enterpriseenergy.com/ MSN mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Heavy CF Load
In some testing of CF5 we found it necessary to NOT install the management reporting, graphing and performance tuning services. We found these affected performance. We did not really understand why, so it may have been something else. I may be wrong on the names of the new services in CF5 but it seems like there were three. I do not have them installed in my development environment so I cannot look. Bartee Lamar www.enterpriseenergy.com MSN [EMAIL PROTECTED] -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 10:40 PM To: CF-Talk Subject: Re: Heavy CF Load The developer has told me that the query is cached for an hour and that page uses the cached data. Neil p.s. I told them to make the page HTML since the first page always has the same data!!! - Original Message - From: Richard Fantini [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, June 21, 2002 8:14 PM Subject: Re: Heavy CF Load If I had to take a guess, I would say it may be this page... http://www.patriotdrive.com/mural.cfm Make sure that they are not selecting the entire recordset of names, then using startrow and endrow in a cfloop to output a portion of the results. Instead they should use a stored procedure to return a single page worth of data. -Rich - Original Message - From: Neil H. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, June 21, 2002 6:52 PM Subject: Re: Heavy CF Load Anything specific? I have answered a lot of questions from other people... Neil __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
