Cloud Print
I am wondering if anyone has successfully used Google Cloud Print for remote application printing. I am starting to explore this and would love to know if it works reliably. Even better - if anyone knows of a custom tag or sample code that would be really helpful too. I want to be able to trigger a remote printer to print labels as needed. Thank you! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347554 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cftextarea onChange bug
I am having two issues using CFTextarea (richtext) that I wonder about: 1) when richtext is enabled the onchange attribute doesn't seem to work. 2) I can't seem to get the value of the text in the textarea when richtext is on. I want to access the value of the field with javascript. Thank you. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298999 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Saving a CFINPUT field
I am trying to work out the best way to have some form fields auto-save without having to press a SAVE button--like the way they do when you use a CFC with onChange in a CFGRID. For instance, suppose I had a CFINPUT field. I was hoping you could just do CFINPUT ... onchange=cfc:act_do_something.saveMyData() and when you clicked off the field it would send data into the CFC that could be stored. I am pretty sure this functionality isn't there, so I need some help going in the right direction for this. Aside from one CFINPUT, one of the fields I want to autosave is a richtext CFTEXTAREA and there are also two selects. Any ideas much appreciated. Thank you. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298919 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OCR Solutions
Does anyone know of any ocr solutions that can be made to work with ColdFusion? What I'd like to do is have documents scanned and emailed to a coldFusion server and then OCR'ed to find a person's name or account number. The number will be used to match the document to a database record so the document can be attached to their account. Thank you for any ideas ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294231 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Creating an Audit Trail
I have a multiuser CSR application that has some audit functionality to track certain changes to customer records (for instance change of first name or last name, who changed it and what was it before?). It already logs these changes, but I think it could be more efficient. I was wondering if anyone could comment on how they would go about doing this. Right now, it is strictly code-based. The database is SQL Server 2000 and the server is ColdFusion 8. Thank you ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292397 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Creating an Audit Trail
Thanks everyone for your comments so far. The current app doesn't have any standard framework, eventually it will probably be rewritten with one. For now I just am taking care of the existing code. Currently when the page loads, the values from the database are put into a variable and then when the page is saved a new list is created and then compared to the first list for changes. Changes are logged in a table with the user's id. It is klunky. I think I will see if we can arrange for the database/trigger route instead. If you're using anything like the ColdSpring framework then you can apply this stuff using AOP. I've only recently started working with this concept but it really is a fantastic one. Failing that then I would defiantly recommend building a LoggingService CFC which handles all the logging for the application, it allows you to keep the logging methods consistent across the application. The logging class I've been working on is based on the concept of being able to log to both file and database, with different log levels, such as info, warning, error, critical, debug etc. Without knowing a little about how your current solution is built its hard to advise really, how does the current one work? Do you perhaps have a code sample? Hope that helps, Rob I have a multiuser CSR application that has some audit functionality to track certain changes to customer records (for instance change of first name or last name, who changed it and what was it before?). It already logs these changes, but I think it could be more efficient. I was wondering if anyone could comment on how they would go about doing this. Right now, it is strictly code-based. The database is SQL Server 2000 and the server is ColdFusion 8. Thank you ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292408 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Best Instant Messanger to Use With CF 8
Can anyone recommend the best free instant messenger server to use with ColdFusion's Instant Messaging Event Gateway? Thank you ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290199 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFIMAGE Resize Slow
I wondering if anyone has any advice about ColdFusion 8's CFIMAGE being slow when resizing images. Its REALLY slow. I have even brought my server down trying to resize a hundred or so images. Is this something that Adobe will eventually fix? I have another solution right now, but I am unhappy with the quality of the thumbnails that it is creating. I have read this thread from August regarding the same complaint, but I want to know if anything has changed: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:53049#286647 Thank you ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290064 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFIMAGE Resize Slow
Thanks for these suggestions Tom and Andy. I don't really know what about what I was doing brought down the server--but I am pretty sure it was due to my experimentation with images. My code basically is setup to take a directory tree and then loop through it to create thumbnails and watermarked images. I needed to use an image for my watermarking, so I was using a custom tag CFX_WATERMARK to do the watermarking. I am wondering if either there was a thread safe issue with this tag (or the CFIMAGE tag), because I didn't think to use CFLOCK around these. As far as my initial image sizes, they are on average 1600x1200, but some are bigger and some are smaller...and I am resizing them down to 800x? and 100x?. I am trying out image.CFC now to see how that does. I haven't tried ColdFusion's image functions. Thanks again. On Wednesday 03 Oct 2007, [EMAIL PROTECTED] wrote: I wondering if anyone has any advice about ColdFusion 8's CFIMAGE being slow when resizing images. Its REALLY slow. I have even brought my server down trying to resize a hundred or so images. If one slow page can crash your server, that's a bigger problem. Depending on your use case, could you fire the resize of into a CFTHREAD and then get on with showing the user the next step ? Have you tried the quality parameter to CFIMAGE, or maybe using ImageSetAntialiasing() or even ImageResize()'s interpolation and blurFactor ? -- ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290076 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFGrid does not appear...
I am using ColdFusion 8 and I am running into an odd issue that I can't figure
out. I have an HTML cfgrid on an HTML CFFORM that is supposed to appear in an
IFRAME. The thing is that the CFGRID doesn't appear as anything but a gray
line until I refresh the IFRAME's contents. Then it is fine. I don't think
there is anything at all unusual about my cfgrid (except that it is inside an
iframe). The same problem happens in Firefox and Internet Explorer. Here is
the code for the IFRAME's contents:
cfgrid
name = AGrid
format=html
font=Tahoma
fontsize=12
selectmode=edit
striperows=yes
striperowcolor=##e0e0e0
bind=cfc:act_getCustomer.getCustomerCallLog({cfgridpage},
{cfgridpagesize},
{cfgridsortcolumn},
{cfgridsortdirection})
onchange=cfc:act_getCustomer.updateCallLog({cfgridaction},
{cfgridrow},
{cfgridchanged})
!--- cfgridcolumn tags arrange the table and control the display. ---
!--- Hide the primary key, required for update ---
cfgridcolumn name = ID display = No
cfgridcolumn name = CLIENTID display = No
cfgridcolumn name = date__happened header = Date
Select=No
width=140 textcolor=Black bold=Yes
cfgridcolumn name = type_of_call header = Status
Select=No
width=96
cfgridcolumn name = Comments header = Comments
Select=Yes
width=275 textcolor=black bold=no
dataalign=left
cfgridcolumn name = contact_Name header = Contact
Select=No
width=65
cfgridcolumn name = contact_made_by header = By Select=No
width=65
cfgridcolumn name = category header = Category Select=No
width=65
/cfgrid
Thank you for any ideas
~|
ColdFusion is delivering applications solutions at at top companies
around the world in government. Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288628
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFGrid does not appear...
Unfortunately, my issue is that the grid doesn't appear at all. Just a gray line. In doing more troubleshooting, I have found that it doesn't matter if it is in an i-frame or not, just making it part of the page on my site where the iframe was still shows the same issue. If I just refresh the page, it appears just fine. The grid would get populated from an Ajax call. Make sure the JavaScript in the Web page is correctly calling the CFC on the server. The ?cfdebug URL parameter helps identify what is going on. If the Ajax call fails, the result is an empty grid. Make sure you can access your CFC by entering the URL into the Web browser and that the CFC is set up to allow for remote access. -Mike Chabot ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288665 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8 HTML CFGRID with checkbox possible with binding?
Ok, I solved my error issue--I just needed to remove the semicolon from the end of onClick=form.submit();--So now I have checkboxes that submit the form when checked inside of an HTML grid on CF8. I am working on the same thing right now. I have success getting the checkbox to show up. That much is no problem. The way I am doing it is by using QueryNew/QuerySetCell to create a query that I send back to the CFGRID via binding to a CFC. Here is how I am creating my checkbox: CFSET QuerySetCell(searchResults, test,Complete: input type=checkbox name=install_complete_date value=#dateformat(now(), mm/dd/)# onClick=form.submit();) I want to set it up so that when the checkbox is checked, the form is submitted automatically. Unfortunately, when the checkbox is checked, the form does submit, but I am getting a mysterious Error: The submitted cfgrid form field is corrupt (name: __CFGRID__CFFORM_1__FIRSTGRID value: __CFGRID__COLUMN__=ROW; __CFGRID__DATA__=5; ... I have no idea what this is about or why its happening. Anyone have any guesses? I think I have alot to learn about CFGRID. Thank you. I did get the checkbox to showup, however, it initally shows a true or false in the column rather than a checkbox. Upon clicking the cell three times, a checkbox finally appears, and can then be changed using ajax/cfc. I ended up doing a flash grid...i think this may be a bug with HTML bound grids. Chris Martin Shy Boy wrote: ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287947 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8 HTML CFGRID with checkbox possible with binding? +Error Message
I am working on the same thing right now. I have success getting the checkbox to show up. That much is no problem. The way I am doing it is by using QueryNew/QuerySetCell to create a query that I send back to the CFGRID via binding to a CFC. Here is how I am creating my checkbox: CFSET QuerySetCell(searchResults, test,Complete: input type=checkbox name=install_complete_date value=#dateformat(now(),mm/dd/)# onClick=form.submit();) I want to set it up so that when the checkbox is checked, the form is submitted automatically. Unfortunately, when the checkbox is checked, the form does submit, but I am getting a mysterious Error: The submitted cfgrid form field is corrupt (name: __CFGRID__CFFORM_1__FIRSTGRID value: __CFGRID__COLUMN__=ROW; __CFGRID__DATA__=5; ... I have no idea what this is about or why its happening. Anyone have any guesses? I think I have alot to learn about CFGRID. Thank you. I did get the checkbox to showup, however, it initally shows a true or false in the column rather than a checkbox. Upon clicking the cell three times, a checkbox finally appears, and can then be changed using ajax/cfc. I ended up doing a flash grid...i think this may be a bug with HTML bound grids. Chris Martin Shy Boy wrote: ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287907 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFGrid Ajax Results
Thank you for the answers. I will look into this. Complicated for me would be defined not-so-easy. So this might be beyond me. -Original Message- From: Brian Kotek [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 04, 2007 7:40 PM To: CF-Talk Subject: Re: CFGrid Ajax Results However you define complicated, it's far more complicated than just using what is built in to cfgrid. Furthermore, the custom renderer examples are just changing the format of the displayed grid, and don't even touch on the issue of building up your own data (based on a ColdFusion structure) in JavaScript or XML and feeding that to the grid, which is an entirely separate issue. On 9/4/07, Andrew Scott [EMAIL PROTECTED] wrote: Actually it is not complicated. Ray has an example of rendering on his blog that will do the job nicely. ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287908 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8 HTML CFGRID with checkbox possible with binding?
I am working on the same thing right now. I have success getting the checkbox to show up. That much is no problem. The way I am doing it is by using QueryNew/QuerySetCell to create a query that I send back to the CFGRID via binding to a CFC. Here is how I am creating my checkbox: CFSET QuerySetCell(searchResults, test,Complete: input type=checkbox name=install_complete_date value=#dateformat(now(),mm/dd/)# onClick=form.submit();) I want to set it up so that when the checkbox is checked, the form is submitted automatically. Unfortunately, when the checkbox is checked, the form does submit, but I am getting a mysterious Error: The submitted cfgrid form field is corrupt (name: __CFGRID__CFFORM_1__FIRSTGRID value: __CFGRID__COLUMN__=ROW; __CFGRID__DATA__=5; ... I have no idea what this is about or why its happening. Anyone have any guesses? I think I have alot to learn about CFGRID. Thank you. I did get the checkbox to showup, however, it initally shows a true or false in the column rather than a checkbox. Upon clicking the cell three times, a checkbox finally appears, and can then be changed using ajax/cfc. I ended up doing a flash grid...i think this may be a bug with HTML bound grids. Chris Martin Shy Boy wrote: ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287911 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF8 HTML CFGRID with checkbox possible with binding?
I am working on the same thing right now. I have success getting the checkbox to show up. That much is no problem. The way I am doing it is by using QueryNew/QuerySetCell to create a query that I send back to the CFGRID via binding to a CFC. Here is how I am creating my checkbox: CFSET QuerySetCell(searchResults, test,Complete: input type=checkbox name=install_complete_date value=#dateformat(now(),mm/dd/)# onClick=form.submit();) I want to set it up so that when the checkbox is checked, the form is submitted automatically. Unfortunately, when the checkbox is checked, the form does submit, but I am getting a mysterious Error: The submitted cfgrid form field is corrupt (name: __CFGRID__CFFORM_1__FIRSTGRID value: __CFGRID__COLUMN__=ROW; __CFGRID__DATA__=5; ... I have no idea what this is about or why its happening. Anyone have any guesses? I think I have alot to learn about CFGRID. Thank you. I did get the checkbox to showup, however, it initally shows a true or false in the column rather than a checkbox. Upon clicking the cell three times, a checkbox finally appears, and can then be changed using ajax/cfc. I ended up doing a flash grid...i think this may be a bug with HTML bound grids. Chris Martin Shy Boy wrote: ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287912 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: question marks and spiders, e-marketers...
Hi Folks, I think eventually I'll be writing an article on this topic. I definitely think that Search Engine Safe URLS work. First, the good news is that some of the search engines are starting to come around and allow for indexing of standard dynamic URLs. Most notable is google, which definitely has no problem indexing the content that is only exposed by accessing the stuff after the question mark. Apparently many search engine creators were afraid that someone would write code to trap their spider in a site by generating infinite new links for the spider to follow. Now as dynamic sites are becoming the norm, the engines are starting to come around to the idea that they can't disallow dynamic content. They exclude too much information by doing so. Do search engine safe URLs work. My verdict is yeahpretty much they do. Search engines have no idea whether or not they are dealing with a real URL with directories or a search engine safe one. I usually even add a fake something.HTM on the end of the URL, for instance: http://www.mysite.com/index.cfm/state/33/mode/2/something.HTM. Some things to note are that you may find you need to write some code to pass and reset the Client tokens. And any time you do a CFLOCATION, you must set ADD TOKEN to no or youll wind up with something like: http://www.mysite.com/index.cfm/state/33/mode/2/something.HTM?CFID=1CFTOKEN=22332. Those of us who are using IIS can very easily switch over to Search Engine Safe URLs. If you are using Apache, its possible, but not as easy to set up. If you are using fusebox, youre in especially good shape if you use the FORM2URLVARIABLES custom tag. Its been setup to do all the work that you might need in using these URLs for you. The only problem I havent really overcome yet is generating Webtrends reports from Search Engine Safe or dynamic URLs. I should say that I have an old version of Webtrends and I have heard this isnt a problem with the newer ones. While we're on the topic, I point out that its important to keep in mind that all the search engine spiders have their own personalities. Things like meta tags are ignored by some, but required by others. Some spiders give special weight to the first x number of words on a page, while others do not. I find that a very high percentage of otherwise in-the-know ColdFusion developers know very little about search engine optimization. If you are interested in learning a lot about search engines, I suggest joining the I-Search mailing list: http://www.adventive.com/lists/isearch/summary.html. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Image resizing question
Hi Folks, I am looking for ideas on how to handle a problem: The site I am working on allows customers to upload their company logos for display on a public page. I'd like the logos to be 100x100 pixels but I have a feeling I can't really require that because alot of the clients won't have a clue what I am talking about and I don't want to chase anyone away. I tried using CFX_Image to resize the images after they come in, but they wind up a bit screwed up. First problem is that CFX_image only lets you resize X or Y and then scales the other in proportion. That means to get to 100x100 I would potentially have to scale one way and then scale the other which would result in a smaller image the other direction. Second problem is alot of the images look bad after the resizing. I guess I could also just set the image height and width when I display them, but I also don't like that solution. I am mainly concerned that someone will upload a really tall or really wide image that will take over my whole page. Does anyone have any comments or ideas about what to do here? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: SQL Server 2000
Art, You can just use MS Access 2000's interface to hit SQL Server 2000. You may need to download a patch from Microsoft because there were some changes going from SQL Server 7.0 to 2000. (URL below). It is definitely the best way for folks who are used to MS Access to work with a SQL Server. The interface is very similar, but there are extra features such as a tab for stored proceedures, and instead of QUERIES its called VIEWS. There are times you will still need the enterprise manager, but for most stuff MS Access works fine. To get started open MS Access 2000 and choose FILENEW PROJECTExisting Database and point it at your SQL Server. Eron The URL: http://officeupdate.microsoft.com/2000/downloaddetails/accsql.htm?FinishURL=%2Fdownloads%2Frelease%2Easp%3FReleaseID%3D26675%26redirect%3Dno -Original Message- From: Art Broussard [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 2:51 PM To: CF-Talk Subject: OT: SQL Server 2000 I have a web site that has SQL Server 2000 on it. I have never even thought of touching this database until now. I want to go in and create some tables. I was told I can install some application on my computer that will allow me to connect to the SQL Sever. Then use this program to create the tables I need. Does anyone know what I'm talking about because I sure don't : ] TIA Art Never put your finger where you wouldn't put your nose. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Bad Regular Expression Error
Why does this cause a Bad Regular Expression error? CFSET VARIABLES.this_body=rereplacenocase(this_body,script[^]*(.*)\/script[^]*,X,ALL) The error I get is: Information/H4PPAn error occurred while evaluating the expression: VARIABLES.this_body=rereplacenocase(this_body,script[^]*(.*)\/script[^]*,X,ALL) Bad regular expression If I remove the (.*) in the middle of the two script/script tags, no error occurs (but of course I don't find what I am looking for. Can anyone suggest a better way to get rid of script tags (and what's between them? I don't want to use a custom tag.) Thanks, Eron ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFHTTP - loop problem
Joseph, This might not help solve your problem, but I would use CFLocks around your CFHTTP tag. Eron -Original Message- From: Hamid Hossain [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 20, 2001 9:43 AM To: CF-Talk Subject: CFHTTP - loop problem Hi folks, I tried to make a loop of cfhttp requests to a url and save every CFHTTP.FileContent in a separated text file. The problem that I failed to run my code through a loop while it is running good when make one cfhttp request. the code that caused the problem: = index.cfm = 01 cfquery datasource=Datasource name=IDs 02 SELECT CatID FROM Cats 03 /cfquery 04 05 htmlbody 06 07 cfloop query=IDs 08 cfhttp method=GET url=http://www.xyz.com/Cat.cfm?id=#IDs.CatID#; resolveurl=Yes/cfhttp 09 cffile action=WRITE file=D:\myWebRoot\ARCHIVES\#IDs.CatID#.cfm output=#cfhttp.FileContent# 10 /cfloop 11 p I am Finished! 12 /body/html = Lines 01-03: Reading from a database to get all IDs. Line 07: Starting a loop on IDs collected from the query. Line 08: CFHTTP request to a website with id of loop. Line 09: CFFILE save the cfhttp.FileContent into cfm file inside ARCHIVES directory. if you deleted the loop in the previous code, it will work successfully. I need it with a loop!!! any suggestion will be appreciated. Hamid Hossain ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: Access 97 and SQL 2000
Hi David, Are you sure you're talking about Access '97 and not Access 2000? I didn't know you could link to SQL Server tables with Access 97. Just in case you mean Access 2000 you should be aware that anyone using MS Access 2000 to gain access to SQL Server 2000 needs to apply an update from Microsoft: http://officeupdate.microsoft.com/2000/downloaddetails/accsql.htm?FinishURL=%2Fdownloads%2Frelease%2Easp%3FReleaseID%3D26675%26redirect%3Dno Without the update, things get weird to say the least when trying to working with SQL Server 2000. Kind Regards, Eron -Original Message- From: David Cummins [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 02, 2001 11:16 PM To: CF-Talk Subject: OT: Access 97 and SQL 2000 Hi all, We have a client who wrote a pair of Access apps that share data over a LAN. Now they want to move them to having a backend of SQL 2000 so they can run it over the net (plus have online access to the data contained in the system). The problem is, that when Access links to SQL tables, it does not seem to recognise any text field over 255 characters as being equivalent to a Memo field. It instead shows up in Access as a text field with 255 characters. In fact, the Access help shows how ANSI SQL types map to Access types, and it seems that nothing maps to a Memo field at all! Does anybody have any idea how we can get around this? Tricking Access? Workarounds? Newer version of Access or ODBC drivers? Help! David Cummins ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFContent file download problem
I use CFcontent all the time and haven't had any problems for a long time. Recently I have been attempting to institute it as part of a fusebox site with frames to download some hidden files. When a user clicks the link that triggers the CFCONTENT download, for some reason, two files must be downloaded first, before the one that I am intending for them to download. One of them is the name of the file that creates the frames for the site and the other is a UUID that's part of the calling URL. The fuseaction that calls the file that contains CFcontent goes through the usual app_globals and index.cfm before it gets to the one that contains the code in question: CFHEADER NAME="content-disposition" VALUE="attachment; filename=#get_this_private_file.file_filename#" CFCONTENT TYPE="unknown/unknown" FILE="D:\inetpub\client_private_files\7E3AB8B1-C972-11D4-89E80080C8355E94\#get_this_private_file.file_filename#" deletefile="NO" I am on ColdFusion 4.5.1 Enterprise, Windows 2000. Thanks, Eron ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Parsing Street Address
Hi Everyone, I am wondering if anyone has any code or any ideas about the most efficient way to handle this: I need to parse the street address from people's accounts such that I can parse out the Street Name and Street Number separately (and disregard things like suite and apartment number) and assign each to a variable. In other words, say I was given an address like: 4853 Flower Blossom Avenue Or 4853 Flower Blossom Avenue Apartment 1222 I need to get the street number (4853) and then just the street name (Flower Blossom Avenue) and pop them into a variable. Would this best be done with Regular Expressions? Does anyone have any example code? I could force people to enter their street addresses in a strict manner to make this easy, but I'd rather not do that. Thanks, Eron ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Questions on returning verity results
Chris, When you do your CFINDEX, you can use the CUSTOM1="" field to put the extra information about where the data is coming from. On the search side, when you do a cfsearch, the CUSTOM1 and CUSTOM2 fields will be available for you to use to point to the correct datasource. Eron -Original Message- From: Chris Martin [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 25, 2001 11:30 AM To: CF-Talk Subject: Questions on returning verity results A question regarding verity: If I do a verity search that looks in multiple collections, and they each have a unique key, will there be a problem when I return the results of that search, using the search.KEY variable? I need to be able to return individual keys, even if the user is searching multiple tables. Is this possible Thanks, Chris Martin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Anybody know anything about Intershipper?
Hi, There are a few of us with the same problem. The actual issue is to do with specifying FEDEX as a shipper. If you remove FEDEX then it should start working again. You might want to contact the kind Gent at Desert Raven that wrote the tag. He said he would look into the problem. Regards, Eron -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 11:36 AM To: CF-Talk Subject: Anybody know anything about Intershipper? It appears that since Jan, 30, the Intershipper interface on one of my sites has not been working. Anybody else having a problem? Is Intershipper the problem or should I be looking at our end? Dave ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: studio 4.5.2
Don't you mean Malaria (Macromedia + Allaire=Malaria)? I am also seeing lots of weird stuff with RDS and FTP. My main problems with RDS center around renaming and deleting files via their file management interface. FTP gives me messages all the time about timeouts... Having said that: in spite of any problems I have, I really do love CF Studio. And furthermore, when it works, RDS is simply amazing--what a BIG timesaver. And the improvements in CFS 4.52 where you RIGHT click on a tag and get "select tag" (unless you're right clicking on a style sheet in which case you get a short-cut to Top Style) are really great... Eron -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 12:15 PM To: CF-Talk Subject: RE: studio 4.5.2 I just wish Allaire had taken the same attention to detail and the same urgency with fixing problems with Studio that they have with the server products. Lets home Macrollaire will do something about that ! :likes to thing they'll merge Studio into DreamWeaver as an alternative 'HTML' source editor :-) Thomas Chiverton Office: 01565 757 909 Recovered from laptop crash ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Disappearing Client Variables
I have a problem that is difficult to explain which
has to do with "disappearing" client variables. I
have a site that makes use of virtual hostnames. I
have a wildcard in my DNS entries so that *.mysite.com
all go to the same server and then ColdFusion takes
that host name from the URL and acts accordingly. In
other words, someone could go to WWW.mysite.com OR to
XYZ.mysite.com and both would actually go to the same
server and would run the same code. I harvest the
first part of the URL and display the right data for
that site. (with me so far?) I have frame with a
navigation menu which lets people "jump" from "site to
site" Its a pulldown menu that targets the other
frame and causes it to load the date for a different
virtual host. When a navigation item is chosen BOTH
frames load using the new virtual host.
Does anyone think there should be any problems keeping
client variables alive going between virtual hosts? (I
am having one :-) ) I do seem to be maintaining the
client tokens even when the problem is occuring. I
pass the CFID/CFTOKEN around in the URLs like so:
cfapplication name="mysite" sessionmanagement="yes"
SESSIONTIMEOUT="#CreateTimeSpan(0, 3, 0, 0)#"
clientmanagement="YES" setclientcookies="NO"
CFIF ISDEFINED("ATTRIBUTES.SETTOKEN")
CFIF ISDEFINED("attributes.CFID")
CFSET url.cfid="#attributes.cfid#"
CFSET url.cftoken="#attributes.cftoken#"
CFSET url.mnky="#attributes.cftoken#"
/CFIF
CFSET
session.session_id="deliveru_#url.cfid#_#url.cftoken#"
cfcookie Name="CFID" value="#URL.CFID#"
cfcookie Name="CFToken" value="#URL.CFToken#"
/CFIF
I know its a long shot, but thanks for any ideas,
Eron
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Disappearing Client Variables
Thanks Bud and Shawnea for your help. Shawnea's
comment about cookies and domains prompted me to add
domain=".mydomain.com" to the CFCOOKIE statement.
That seems to have solved my problem...I hope I don't
speak too soon.
Weird, but makes sense.
-Original Message-
From: Shawnea Carter [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 02, 2001 5:08 PM
To: CF-Talk
Subject: Re: Disappearing Client Variables
My recollection - and someone jump in here if I am off
base - is that client
variables DO utilize cookies to some extent - and
cookies can only set and
read by the same domain. The browser doesn't "know"
that the domains are
'virtual'.
So what is happening is the client variables aren't
disappearing when you go
to xyz.mysite.com if you set them on www.mysite.com.
They were never there
to begin with.
HTH
Shawnea Carter
- Original Message -----
From: "Eron Cohen" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, February 02, 2001 4:34 PM
Subject: Disappearing Client Variables
I have a problem that is difficult to explain which
has to do with "disappearing" client variables. I
have a site that makes use of virtual hostnames. I
have a wildcard in my DNS entries so that
*.mysite.com
all go to the same server and then ColdFusion takes
that host name from the URL and acts accordingly.
In
other words, someone could go to WWW.mysite.com OR
to
XYZ.mysite.com and both would actually go to the
same
server and would run the same code. I harvest the
first part of the URL and display the right data for
that site. (with me so far?) I have frame with a
navigation menu which lets people "jump" from "site
to
site" Its a pulldown menu that targets the other
frame and causes it to load the date for a different
virtual host. When a navigation item is chosen BOTH
frames load using the new virtual host.
Does anyone think there should be any problems
keeping
client variables alive going between virtual hosts?
(I
am having one :-) ) I do seem to be maintaining the
client tokens even when the problem is occuring. I
pass the CFID/CFTOKEN around in the URLs like so:
cfapplication name="mysite" sessionmanagement="yes"
SESSIONTIMEOUT="#CreateTimeSpan(0, 3, 0, 0)#"
clientmanagement="YES" setclientcookies="NO"
CFIF ISDEFINED("ATTRIBUTES.SETTOKEN")
CFIF ISDEFINED("attributes.CFID")
CFSET url.cfid="#attributes.cfid#"
CFSET url.cftoken="#attributes.cftoken#"
CFSET url.mnky="#attributes.cftoken#"
/CFIF
CFSET
session.session_id="deliveru_#url.cfid#_#url.cftoken#"
cfcookie Name="CFID" value="#URL.CFID#"
cfcookie Name="CFToken" value="#URL.CFToken#"
/CFIF
I know its a long shot, but thanks for any ideas,
Eron
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Netscape Browser Frames Problem
I am wondering if anyone has any ideas of what causes this FRAMES problem with Netscape 4.x browsers. I have two frames. Frame 1 has a form with its action targeted to frame 2. The first time the form is submitted, it correctly targets frame 2, but the next time you submit the form in frame 1 it opens a new window instead of targeting frame two. The code in frame 1 hasn't changed at all, it just seems to only correctly target frame 2 once...and then from then on, it opens a new window. Is this a bug in Netscape Communicator 4.7? Does anyone know of any ways around this problem. Thanks, Eron ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFCONTENT and COOKIES
Does anyone know of a way to set cookies on a page that uses CFCONTENT? Is this impossible to do? Thanks, Eron ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Visual DBase
Hi Folks, I am wondering if anyone has any experience using a Visual DBase datasource with ColdFusion. Do you need a special ODBC driver to get this to work? Any other gotchas? Thanks, Eron ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Can anyone explain this?
Sebastian, Since you have cookies disabled, each time you load page, ColdFusion assigns a new CFID/CFTOKEN. If it was able to store those values in a cookie, when you loaded the next page, CF would see that you've already got a set of tokens assigned to you, and just use those. The high and low of it is that you'll have to pass the CFID and CFTOKEN around in the URL and set them for each page, else you'll be doomed to no session management through ColdFusion. Hope This Helps, Eron -Original Message- From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] Sent: Friday, January 26, 2001 10:31 PM To: CF-Talk Subject: Can anyone explain this? Can anyone explain this? I have cookies disabled. I have session management and setclientcookies set to yes in application.cfm. I am using CF 4.0 On each page I put the following code: cfoutput#cookie.cfid#br#cookie.cftoken#/cfoutput There are no cookies listed in the Parameters CGI variables of each page. And yet for each page I get a different value for cfid which increments by one and a different value for cftoken. Sebastian ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF STUDIO 4.5.2
Edward, I have EXACTLY the same problem and it is happens when I access a few different servers with ColdFusion Studio 4.5.2's new FTP underpinnings. Its definitely annoying. I wish Allaire could give us more information about it, like how to adjust the timeout period or what might cause this. I don't know about you, but for me the timeout is an awefully short period of time. Eron -Original Message- From: Edward Chanter [mailto:[EMAIL PROTECTED]] Sent: Friday, January 12, 2001 5:26 AM To: CF-Talk Subject: RE: CF STUDIO 4.5.2 The FTP has been driving me absolutely NUTZ!!! I like WS FTP I use the registered version myself, but the number of time-outs and "blocking call canceled" messages I was getting started to become a real pain. Nothing I could do to the settings made any difference :-( Anyone else have simillar problems If anyone if the CF Stu development team is listening, the product itself is the best version yet The built in FTP could do with being a bit more flexible and reliable ;o) my ten cents worth -= Ed -Original Message- From: Sean Renet [mailto:[EMAIL PROTECTED]] Sent: Friday, January 12, 2001 10:09 AM To: CF-Talk Subject: CF STUDIO 4.5.2 Is it just me or does this new version of 4.5 actually work? Anyone find any bugs yet? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFX_POP
If you're talking about CFX_IIpop3, don't bother. The old version worked okay, but had a memory leak. The new one is rediculous, and even Patric Steil the "cheif technology officer" from intranet came to my x-company's office and couldn't make it work properly. It was buggy, didn't work as advertised and was difficult to set up.The end result of the experience is that I would not buy plugins from Infranet. -Original Message- From: David Cummins [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 11, 2001 2:52 PM To: CF-Talk Subject: Re: CFX_POP Is it any better? If so, where is it, and what's wrong with it? All I need is to be able to search for a piece of text in the body. Its for removing persistently bounced email addresses from our database... unless anybody has a better idea how to do it??? David Cummins Dylan Bromby wrote: it will not fix all your POP woes. trust me. ;) -Original Message- From: David Cummins [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 10, 2001 12:18 PM To: CF-Talk Subject: CFX_POP Hi fellow CFers, I've heard a lot about a CFX_POP tag that will fix all your mail fetching woes... does anybody know where it is? I can't find it in the Allaire tag gallery or through Google, only mentions of it being used. Help! David Cummins ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF_Activedit alternatives??
Hi Folks, EWebeditpro is definitely the most feature rich of the one's I have used so far, but its not without its down side. The pricing model is definitely the biggest detractor. These guys have done quite a bit of work on adding features to their editor and I have to say it is very nice -- it even works in Netscape. The best price/feature ratio probably comes from Iautomated's HTMLarea. They have a free version that has been very useful. It basically just lets you copy and paste from MS Word, do links and fonts. The pricing structure for their paid products is very liberal. They charge like $70 for unlimited (even public) use on a single server or $400 for a much broader license. Its not as mature as EWebeditpro, but if it meets your needs, it is probably the way to go if you're on a budget. HTH, Eron PS- What IS activeedit's pricing structure? -Original Message- From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 3:04 PM To: CF-Talk Subject: RE: CF_Activedit alternatives?? That may be true but considering that there are few number of people that will actually be doing the editing and they only have to download the plug-in once, its not that bad. When you edit a second time it's blazing fast. The benefits far outweigh the time to download. It just requires instilling some confidence and security to the client on your part. Usually what I do is sit down at the client's computer and show them what happens while explaining this is only done once. After it's loaded I let the client sit down and let them start playing with it and their 'wonderment' and excitement quickly replace any fears of the initial download. -Sold- Give it a try with them and see if that helps. Some developers work in environments and with companies that are far too large and distributed to sit down and coddle all of the clients/employees. For me, the biggest issue with eWebEdit is the pricing model or lack there of. We inquired with them several times about purchasing many licenses but their fees were fairly exorbitant and, though they informed us they were undergoing a pricing change, we never received that information. In the mean time, several cheaper (free) alternatives have shown up. eWebEdit still has an advantage as far as the Spectra integration goes, but then the new Spectra has fixed the problems and functionality of it's own WYSIWYG HTML editor. What does eWebEdit offer that the ActiveEdit doesn't? Of course, we've actually decided to go with ezEdit because all we really cared about (besides the HTML Editor) was the custom tag and source code availability. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 Sincerely, Rob Sherman Allaire Certified Developer Instructor CFDude, Inc. http://www.cfdude.com CF_Office (310) 543-1622 CF_Fax (310) 543-0512 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: External Datasource help??
To further Mark's suggestion, you could use a tag like CF_AutoAddMDB or CF_datasource to simply add the datasource on the fly. It might not be exactly what you wanted, but I don't know of any other way to do this. I am pretty sure you always have to "register" your datasources first. Maybe someone else will correct me here. HTH, Eron -Original Message- From: Warrick, Mark [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 11:06 AM To: CF-Talk Subject: RE: External Datasource help?? Set it up as an ODBC datasource on the server from which you are making requests and run a query against it. -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 27, 2000 8:05 AM To: CF-Talk Subject: External Datasource help?? How can I query an external datasource? I have the full root path and the datasource name, is this even possible? Thanks, Rich ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: iiframework
I have not used iiframework but have had some experience with CFX_iipop recently. There were quite a few problems with this tag. It was buggy and difficult to get going (and still didn't work properly once it did). We had been using the previous version of CFX_iipop without too many problems, but according to my boss it was causing us lots of problems because the old tag had memory leaks. I since left the company that was using it. After I left one of the employees of the infranet came to the office and he couldn't even make CFX_iipop3 work properly. The company I left is now also looking into iiframework but from what I heard from my collegues there, they aren't very impressed and probably won't use it. Eron -Original Message- From: stas [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 26, 2000 10:54 AM To: CF-Talk Subject: iiframework Hello, Has anybody used the framework, if so, I'd like to hearn an unbiased review. Thanks! ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Studio list and Studio 4.5.2 rele
Yes, I have the same problem too. I am also experiencing lots of "timeout problems and winsock errors" with the new FTP engine. I mentioned this on the BETA site but never figured out any ways to prevent the problems. With the final release I am getting lots of "hanging" where studio will just sit there, I assume its also related to FTP. Am I the only one seeing these problems? Anyone have any ideas? I am also wondering, does anyone know if Allaire actually released this version of the software to "Real" users before they made it a final release? There was release candidate 1 on their website and then a few weeks later they released the version that's out now. I know they probably have good internal testers and use some testing software, but there's no substitute for putting software in the hands of "real" testers. Based on the fact that I am having new problems, I'd say there seems to be some new code over the release candidate 1. Anyone have any comments about this? -Original Message- From: Max Paperno [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 23, 2000 3:52 PM To: CF-Talk Subject: Re: Studio list and Studio 4.5.2 released Gary is right, same thing here. The install also wiped out my custom toolbar commands and modified default toolbars (never gave the option to migrate my existing ones to the updated setup). Arrrgh, what crap. -Max At 12/23/2000 07:52 AM -0800, you wrote: Warning! The first thing that I needed to do after installing the ColdFusion Studio 4.5.2 Update was to look up a WDDX question under "Exchanging Data via XML in Help References. To my amazement, the help screen came up blank. After further research, I found that most of the "HTM" help files are zero bytes. Hopefully, this problem will be addressed in 4.5.3. Gary Groomer ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Remote Printing
Hi Everyone, I am trying to figure out an alternative to faxing, and I am wondering if anyone has any ideas. I am basically looking for some kind of technology where I can send orders from a ColdFusion e-commerce site to various stores and shops. It would have to be relatively inexpensive and durable...and the "simpler" the better. Something ideal would be along the lines of a credit card printer that is somehow able to "Answer the phone" so that it could get and print incoming orders. I have considered a text pager, but they're too expensive and are rather difficult to read long orders from. Also, the device has to be reliable and idiot proof. Does anyone have any ideas? Thank you, Eron Cohen ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ODBC errors with MS Access after MDAC 2.6
Drew, See the following ColdCut I wrote in the Teratech ColdCut database. It tells you how to deal with misbehaved MDAC installs. Hope it helps you! Eron http://www.teratech.com/coldcuts/cutdetail.cfm?cutid=89 -Original Message- From: Steve Pierce [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 12:04 PM To: CF-Talk Subject: RE: ODBC errors with MS Access after MDAC 2.5 The update was to MDAC 2.5, not 2.6. My fault for getting the numbers mixed up. But the CF code broke after upgrading to MDAC 2.5. Also for more background the server is running NT4 SP6a, Website 2.5.8 and CF Enterprise 4.0.2. The CF code worked fine with MDAC 2.4, it was after upgrading to MDAC 2.5 that this one CF template started throwing a PCode error. - Steve -Original Message- From: Dru Whitledge [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 07, 2000 10:13 PM To: CF-Talk Subject: ODBC errors with MS Access after MDAC 2.6 After upgrading to MDAC 2.6 (contains ODBC) at my ISP I am now experiencing memory errors for MS Access queries that once ran without a problem (and still do on my MDAC 2.1 server). The CF server provides the following error message -- (and of course stops execution) CMemoryException: unknown cause PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag Has anyone else had this problem? Anyone aware of any fixes? As I started into this I had assumed that the new MDAC 2.6 upgrade simply tightened up some requirment for correct SQL syntax -- now I'm not so sure. One query I'm rebuilding seems to fail on a adding a simple concatenation to create an alias field -- (field1) (field2) AS Field3 while (field1) AS Field3 works fine. That's hard to workaround. Thanks, Dru ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: verity newbie
Hi Vaughan, Thesaurus is an undocumented feature. You can put thesaurusbefore a word in your search and verity will automatically look for synonyms for that word. By the way, if you are a CFAdvisor.com member, you can read the article I cowrote with Michael Smith this month entitled "The Truth About Verity" which is geared towards giving a beginner insight into how to index and search databases wtih verity. You should also have a look at the Teratech knowledgebase: http://www.teratech.com/knowledgebase. HTH, Eron -Original Message- From: Vaughan Evans [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 06, 2000 1:51 AM To: CF-Talk Subject: verity newbie hi all, I am told that the verity search engine has a thesaurus. Is this available in the verity engine that comes with cold fusion? if so how can I take advantage of this in my applications? Excuse my ignorance if this a basic question, I've never had to use verity before. thanks for any help, vaughan. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: UPDATE on a MS Access Database
Chad, you probably just need single quotes around '#InSol.Name#' Single quotes let the database know that you are inserting a string, for instance into a TEXT field. They're easy to forget by mistake. (and you may also be missing a /CFOUTPUT (but that's not likely the cause of your problem here)) Eron -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 30, 2000 11:52 AM To: CF-Talk Subject: UPDATE on a MS Access Database Im trying a UPDATE on a Access database, and im getting an error cfquery name="addtoCJM" datasource="CJM.mdb" dbtype="ODBC" UPDATE JobInfoUpload SET CheckedOut='Yes', cfoutputCheckedOutBy=#InSol.Name# Where '#URL.FileID#' = JobInfoUpload.FileID/cfoutput /cfquery Everything is spelled correct, but i get an error below. I have a feeling it has something to do with my Yes/No Column in the database. ODBC Error Code = 07001 (Wrong number of parameters) [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 = "UPDATE JobInfoUpload SET CheckedOut='Yes', CheckedOutBy=chad Where '48' = JobInfoUpload.FileID" Data Source = "CJM.mdb" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (25:1) to (25:60) in the template file D:\Web\Capitol1interface\chad\checkout.cfm. Date/Time: 11/30/00 11:51:07 Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows 98) Query String: JobId=11LoginID=1FileID=48 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Do You Yahoo!? Yahoo! Shopping - Thousands of Stores. Millions of Products. http://shopping.yahoo.com/ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Intershipper
FYI: From: "Michael Sheldon" [EMAIL PROTECTED] | Block address To: "Eron Cohen" [EMAIL PROTECTED] Subject: RE: Intershipper Date: Mon, 27 Nov 2000 22:50:16 -0700 Add Addresses Please feel free to forward this to the list: I ran a couple of tests against both the PHP and CF versions of my Intershipper modules. While I got results from both, I noticed that it was taking quite some time to get them back. This can cause timeouts which will produce no results. Further, I noted that there were no results at all from FedEx Express. When I removed FedEx from the request, the results came back a little quicker. (Result times always depend on the slowest query) I'm not sure what's up with the FedEx results, since they do show on InterShipper's site. (Though it took a long time there, too.) I have sent a request to InterShipper for some comment on why this is occuring. Michael J. Sheldon http://www.desertraven.com/ Make a fast friend, adopt a greyhound! -Original Message----- From: Eron Cohen [mailto:[EMAIL PROTECTED]] Sent: Monday, November 27, 2000 22:05 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: OT: Intershipper For what its worth, I am having the same problem. Intershipper just isn't returning any results. I am cc:ing this to the webmaster of Desert Raven who may be able to shed some light on this. Eron -Original Message- From: David Hannum [mailto:[EMAIL PROTECTED]] Sent: Monday, November 27, 2000 9:18 PM To: CF-Talk Subject: OT: Intershipper Has anybody else been having any trouble with Intershipper the past couple of days? I've been getting no return with the CF_Intershipper tag the last couple of days. Thoughts? Dave ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Do You Yahoo!? Yahoo! Shopping - Thousands of Stores. Millions of Products. http://shopping.yahoo.com/ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: SQL Server Distinct Date Question
I am working with a VIEW inside of SQL Server. I want to SELECT DISTINCT just the date from a date/time field. (MM/DD/). And then I want to be able to use BETWEEN to requery the resulting data from that view. So to get rid of the time, I am using the Convert function: SELECT DISTINCT Order_id, CONVERT(char(10), Customer_Order_table.date_order_placed, 101) AS order_date From MyTable The trouble is that when I go to requery the data from a second query, my between statement doesn't seem to work properly and I don't get any records returned. It's almost like the resulting data isn't being considered a date or something like that. Does anyone have any suggestions on this? Thanks, Eron __ Do You Yahoo!? Yahoo! Shopping - Thousands of Stores. Millions of Products. http://shopping.yahoo.com/ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Intershipper
For what its worth, I am having the same problem. Intershipper just isn't returning any results. I am cc:ing this to the webmaster of Desert Raven who may be able to shed some light on this. Eron -Original Message- From: David Hannum [mailto:[EMAIL PROTECTED]] Sent: Monday, November 27, 2000 9:18 PM To: CF-Talk Subject: OT: Intershipper Has anybody else been having any trouble with Intershipper the past couple of days? I've been getting no return with the CF_Intershipper tag the last couple of days. Thoughts? Dave ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Do You Yahoo!? Yahoo! Shopping - Thousands of Stores. Millions of Products. http://shopping.yahoo.com/ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Trying to understand deployment wizard
Mike,
I don't use the deployment wizard, but I wonder if you
have tested the soon-to-be-released version of
ColdFusion Studio that is currently at Release
Candidate level? I am using it and have definitely
found some improvements, especially in the way of
their FTP engine (they have apparently replaced it
altogether with another ftp engine).
It is available for download in the beta section of
Allaire's website: beta.allaire.com.
Eron
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On
Behalf Of Michael Kear
Sent: Wednesday, November 22, 2000 6:47 PM
To: CF-Talk
Subject: Re: Trying to understand deployment wizard
G'day Howard,
Not sure if this is a help to you or not, but I gave
up on the deployment
wizard in Studio4.5.1 because it only works if all
your folders are
already created on the host, AND if you are uploading
the entire project.
It's a bug in the software, and as far as I know
nothing's on the slate
for a new version yet.
It's a pity because I used to use the deployment all
the time in
Studio4.0.1 and found it one of the most useful
features. Nowadays I
build a local version and use my reliable CuteFTP to
upload it. And
CuteFTP doesn't cost nearly A$1000 either.
I think it's an outrage, and possibly even an
infringement of the Sale Of
Goods act to claim Studio v4.5.1 works on Windows95/98
and that it will
automatically deploy your project. I've had a few
sympathetic calls, and
one particularly helpful individual at Allaire in the
USA call me over
several days to try to fix my Studio problems, but
they steadfastly
refused to go away, hundreds of other people have the
same problems, yet
Allaire haven't made any sign they're about to release
another version any
time soon.
I'll continue to attack them until they do. If I
built web sites the way
they build Studio, I'd be sued out of business by my
clients.
Cheers,
Mike Kear
AFP Web Development
Windsor, NSW, Australia
On Wed, 22 Nov 2000, Owens, Howard wrote:
This isn't work and I don't understand the error
message. Any help would be
appreciated:
Using the deployment wizard, I created the following
script
//
===
// Project Name: BreakingFolder
// Date/Time Generated:11/22/2000 11:10
//
//
===
// Server List:
//
// ftp://wwwMySite
//
===
function Main()
{
var app = Application;
app.DeploymentManager.OpenProject("F:\\site\\www\\breaking\\BreakingFolder.a
pf");
//
===
// Set Deployment Flags...
//
===
app.DeploymentManager.CreateFolder = true;
app.DeploymentManager.UploadOnlyIfNewer = true;
app.DeploymentManager.EncryptCFML = false;
app.DeploymentManager.ForceLowerCase = false;
//
===
// Server ftp://wwwMySite Deployment
//
===
// Folder: BreakingFolder\breaking
app.DeploymentManager.UploadFile("F:\\site\\www\\breaking\\breaking.shtml","
ftp://www.mysite.com:21/www/breaking/breaking.shtml");
app.DeploymentManager.CloseProject();
}
The error is:
"No Deployment Folder Path for folder: breaking"
and
"No Deployment Folder Path for folder: images"
=
Howard Owens
Web Producer
InsideVC.com
mailto:[EMAIL PROTECTED]
=
~~
Structure your ColdFusion code with Fusebox. Get the
official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives:
http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe:
http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Structure your ColdFusion code with Fusebox. Get the
official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives:
http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
__
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
http://shopping.yahoo.com/
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF editing software - vote
Hi Will, I use CF Studio, and its features are terrific. They have a new patch version coming out soon which will improve quite a few areas of that software. From a ColdFusion user's standpoint, I'd have to say the next most likely software I'd use would be Eversoft's 1st Page. It is remarkably similar to ColdFusion Studio, but it is F R E E. (I still haven't figured out what their business model is supposed to be--comments about this anyone?) Its got quite a few ColdFusion centric features. It is aware of ColdFusion tags, and actually has a few features I wish they'd get into studio. One thing it doesn't have that I would miss if I switched is RDS. As flakey as RDS has been in the past, I couldn't do without it. If you wish to try 1st Page, you can download it from their website. To get to the download, follow the link below: http://www.evrsoft.com/download Its about a 5meg download. -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 09, 2000 7:57 AM To: CF-Talk Subject: CF editing software - vote Hi, I thought it would be interesting to see who's using what to develop their CF apps. I'm using HomeSite 4.5 happily here. Anyone? Cheers Will Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] __ Do You Yahoo!? Thousands of Stores. Millions of Products. All in one Place. http://shopping.yahoo.com/ Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Load/Stress Testing
Evan, There's an excellent small company that concentrates exclusively on load testing sites. Its called DownRight software. http://www.downright.com/ In general, when it comes to something like load testing, the software tools are expensive and its hard to find good experienced people. I think you have the right idea in outsourcing. You might be better off going with a consulting company like the one above so you get the experienced staff and the tools in one go. -Original Message- From: Evan Lavidor [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 07, 2000 12:41 PM To: CF-Talk Subject: Load/Stress Testing Does anyone have any good suggestions for companies that do load/stress testing on sites? I'm not looking for programs a la Microsoft's tools, WebLoad, etc.; I'm actually looking for a company we can outsource to. Thanks for the advice. Evan -- -=-=-=-=-=-=-=-=-=- Evan Lavidor Circle.com Boston Tel: 617-585-3107 Fax: 617-585-3091 -=-=-=-=-=-=-=-=-=- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] __ Do You Yahoo!? Thousands of Stores. Millions of Products. All in one Place. http://shopping.yahoo.com/ Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: It doesn't look like it is the machine..III
Just a thought--Do you use CFLOCK? Eron -Original Message- From: jonathan hamner [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 09, 2000 4:06 PM To: CF-Talk Subject: It doesn't look like it is the machine..III OS version is : NT Service 4.0 Service Pack 6, Build No 1381. Server Information Server Product : ColdFusion Server Version : 4, 5, 0, 0 Edition : Professional Operating System : Windows NT OS Version : 4.0, Service Pack 6 OS Build Number : 1381 Please help. Thank You. --- Nick McClure [EMAIL PROTECTED] wrote: What about the software? What OS version? What Service Pack? What CF Version? What Service Pack? What about the Database, what are you using there? At 04:47 PM 11/8/2000 -0800, you wrote: Hi All, There is a problem with our web site. I have to restart the CF Server twice and somtimes more than that daily because the web site becomes "non-responsive". Sometimes I get Dr' Watson's error when I try to stop the service. The "% of cpu usage" is in the 6-8% range with spikes to 30%+ every so often. Memory usage is below what is physically installed so I don't think the machine itself is having a problem. Could this be a problem with settings in cfadmin? or is it something else. Help!! Thanks __ Do You Yahoo!? Thousands of Stores. Millions of Products. All in one Place. http://shopping.yahoo.com/ Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] __ Do You Yahoo!? Thousands of Stores. Millions of Products. All in one Place. http://shopping.yahoo.com/ Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
No Subject
Hi Guy, You can do table alteration via SQL. I refer you to the following resource which describes "Jet SQL" and amoung other things how to create/alter tables via SQL: http://www.citilink.com/~jgarrick/vbasic/database/jetsql.html#ddl I do have a few other suggestions for you. 1) Get them to use SQL Server (you can access a SQL Server database remotely, and make changes to it, and it will not even take down the site while you're making changes). This is going to be difficult with your $0 budget though. 2) Sometimes you can "break the lock" that's on the SQL database by doing a query with a non-existant field name in it. This will cause ColdFusion/ODBC to throw an error and for some reason break the lock on the database. This would let you upload a new database (but you still have the synchronization problems to contend with) 3) Move to a hosting provider like EDGEWEBHOSTING.COM that gives you utilities to start and stop coldFusion yourself AND to add Datasources yourself (I don't think this company charges for that at all and they have very competitive rates) Hope something here helps you out. Eron Cohen -Original Message- From: Guy J. McDowell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 08, 2000 11:15 AM To: CF-Talk Subject: Remote DB Alteration Hello CF'ers Situation: Database and sites hosted externally, site created internally. Currently if any changes to the datasource's structure are made they are made locally and then uploaded to the host, who has to shut off the CFServer and restart it. This requires scheduling a time and is unacceptable. Also, the uploaded datasource may corrupt/overwrite the data as it is not up to date. Employer will not spring for extra datasources to be hosted. ( multiple applications and domains, one datasource, yay! ;) ) Goal: To be able to add tables to the datasource without scheduling a shutdown and uploading entire datasource. Resources: MS Access 97 CF 4.5 CuteFTP Budget =$0 Is this possible? Please direct me to resources that will show me how. Also, anyone know what the 20 or so CFML tags supported by CFExpress are? Yours In Conservation, Guy J. McDowell, Webmaster The Ontario Federation of Anglers Hunters E-mail: [EMAIL PROTECTED] Phone: (705) 748-6324 ext. 262 P.S. You may want to check out the fresh new look of www.OFAH.org Launched 1st November 2000. Don't forget our other great sites: www.AuctionForWildlife.com - Your chance to make your bid for conservation. www.EcoEd.org - an online adventure for kids in grades 1 through 8. www.HuntingDog.org - Celebrating our Hunting Dog Heritage. www.AHTV.com - Your online companion to the Angler and Hunter Television show. www.OHEP.net - Where to find out and learn about the Ontario Hunter Education Program. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] __ Do You Yahoo!? Thousands of Stores. Millions of Products. All in one Place. http://shopping.yahoo.com/ Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: Decrypt()
Hi Billy,
I have found that encrypt can create some values that
the database will choke on. You may need to enlist
the help of base64 encoding. You're going to need to
use the functions tostring(),tobinary(), and
tobase64() for your encryption/decryption process.
For instance, to encrypt a customer's "secret word"
you'd do SOMETHING LIKE (this is probably close, but
might not quite work right off the bat):
CFSET
secret_word_encrypted=#ToBase64(encrypt("#customer_secret_word#","#customer_last_name#1234"))#
Then to decrypt:
cfset
thevalue="#tostring(tobinary("#secret_word_encrypted"))#"
CFOUTPUT#decrypt("#thevalue#","#customer_last_name#1234")#/CFOUTPUT
HTH,
Eron
-Original Message-
From: Billy Cravens [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 03, 2000 2:58 PM
To: CF-Talk
Subject: Decrypt()
I'm trying to run a routine to decrypt a record in a
table. All records
were encrypted using Encrypt(), with a routine
encryption key:
cfset EncryptedText = Encrypt(String,EncryptionKey)
However, some of the encrypted passwords cause this
error to appear:
---BEGIN ERROR---
An unexpected system error was detected. (Error code
is 20)
This type of error will most likely occur when the
server running
ColdFusion is low on memory and/or system resources.
---END ERROR---
The code I'm using is below:
cfquery name="GetEncryptionKey" datasource="dsn"
dbtype="ODBC"
select encryptionKey, encryptedText
from table
/cfquery
cfoutput query="GetEncryptionKey"
cfset DecryptedSting =
Decrypt(encryptedText,encryptionKey)
/cfoutput
I've checked the resources on the server; they're OK.
I prefer to use cfusion_encrypt and cfusion_decrypt;
however, that's not
an option here, as I do not have any control over the
encryption
process.
Ideas?
--
Billy Cravens
[EMAIL PROTECTED]
Archives:
http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe:
http://www.houseoffusion.com/index.cfm?sidebar=lists
or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
__
Do You Yahoo!?
From homework help to love advice, Yahoo! Experts has your answer.
http://experts.yahoo.com/
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: access query crashing server...
Deanna, I've just been having a similar problem. The funny thing in my case is that on my local development machine, the queries work fine. When I transfered the database and CFML templates up to my webserver, they would crash CF Server when the queries were run. The way I wound up resolving it was to change from SELECT * to SELECT with specific field names. -Original Message- From: Deanna L. Schneider [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 01, 2000 3:26 PM To: CF-Talk Subject: access query crashing server... Hi Folks, We have multiple developers running multiple applications on our server. We've been having problems, and yes, we've read all the allaire docs on performance tuning. One of our problems is that we have a number of large-ish access applications. (Ugh, I know.) I may have found a clue today. I found one query that seemed to be crashing the server consistently. The only thing different about this query is that it concantenated two columns into one variable - ie - Select (can_fname ' ' can_lname) AS canname When I took this out, and banged on the app again, I had no problems. Has anyone else ever seen this happen or is this merely a fluke? cf_graspingatstraws todaysstraw="concantenation" -d Deanna Schneider Interactive Media Developer UWEX Cooperative Extension Electronic Publishing Group 103 Extension Bldg 432 N. Lake Street Madison, WI 53706 (608) 265-7923 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] __ Do You Yahoo!? From homework help to love advice, Yahoo! Experts has your answer. http://experts.yahoo.com/ Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
2 Slightly Off Topic Questions
Hi Folks, Does anyone know how you go about updating your email address with Allaire. I figured out how to change my physical address, but I can't seem to figure out how to change my email address. Also, does anyone have any recommendations for Visio-like products. I am looking for some alternatives to that product. Thanks, Eron __ Do You Yahoo!? From homework help to love advice, Yahoo! Experts has your answer. http://experts.yahoo.com/ Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: SQL Server and Win 98
Claude, I know you can install and use the MSDE on Windows 98. As you probably know, MSDE is something like a "lite" version of SQL Server that comes free with MS Access 2000 and can be used as an alternative to the Jet engine. Because its basically identical to SQL Server's underpinnings, "upsizing" is pretty much a no-brainer. So perhaps you can use the MSDE instead of SQL Server to get the job done. Eron -Original Message- From: AustralianAccommodation.com Pty. Ltd. [mailto:[EMAIL PROTECTED]] Sent: Sunday, October 29, 2000 9:34 AM To: CF-Talk Subject: SQL Server and Win 98 Apart from using enterprise manager which works fine on win 98 and allows uploading/ conversion to sql databases can we run full sql on win 98 I want to be able to run the sql database locally and edit it locally rather than have to edit it off the live server. Can this be achieved in a 98 environment or do I have to upgrade the operating system to win 2000 I look forward to your comments Kind Regards Claude Raiola (Director) AustralianAccommodation.com Pty. Ltd. Website: www.AustralianAccommodation.com Email: [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Messenger - Talk while you surf! It's FREE. http://im.yahoo.com/ Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: HTML problem still here...
Hi Rich, Why not have a textarea that has the HTML code in it display on the result page. Then people can just copy and paste it right out of the textarea. I am not sure how you're backend code is working right now, but in order for this to work, you may need to write the resulting page to a file (or write it into a variable or something like that) and then read it into a variable and then put that variable between your TEXTAREA#THERESULT#/TEXTAREA tags. Hope this helps. Eron -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Saturday, October 28, 2000 11:23 AM To: CF-Talk Subject: HTML problem still here... Ok, I created this little form page that helps people generate a professional ebay auction page. As you can see the only way they can get the html code right now is to use the internet explorer source button. I have asked this same question a couple of day ago and still haven't figured it out. Is there a way I can get the html code that is generated to display in the browser instead of using the source button? Here is the link: http://www.cfm-resources.com/h/happytoad/ Some people have suggested the htmleditformat fuction, but I don't understand how that works. P.S. you don't have to fill in any info to test it just click the submit button. Thanks, Rich Thanks, Rich Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Messenger - Talk while you surf! It's FREE. http://im.yahoo.com/ Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
RE: RDS ColdFusion Studio Problem
That happened to me too Simon. I feel your pain. I finally gave up after the second time I lost work. But that's the way it goes when you use beta. I was really anxious to give it a whirl because of all the things they've improved (like the new FTP engine) but it looks like they have to do some more work before this one's going to be ready to go. Anyone wishing to try it, or see success or bug reports can go to beta.allaire.com and look at the release notes and the forum discussions. I depend on RDS to work from home and I really hope that Allaire gets some of the kinks worked out. Its already amazing that they have something like this at all. And although, even previous versions of CF Studio RDS has some foibles, it does work for the most part. I'd be grateful if they could get this together. -Original Message- From: Simon Horwith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 25, 2000 11:06 AM To: CF-Talk Subject: RE: RDS ColdFusion Studio Problem I recently had studio (4.5.2 beta 2) completely erase all the contents of a file the result of 3 days of work. No fun losing 3 days like that, but what can you do. If you're using a beta product and are concerned about the potential for these sort of occasional mishaps, stop using a beta version. I know some people who rolled their studios back to 4.0.1, because it was a very stable version compared to recent builds. Anyway, I figure studio's features have still saved me more time than they've cost me, all in all. ~Simon -Original Message- From: Loryn C Williams [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 25, 2000 10:41 AM To: CF-Talk Subject: Re: RDS ColdFusion Studio Problem This is a multi-part message in MIME format. --8C2F3608CA33766A4AB8F17A Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi Jeff, I have that same problem and in fact have reported it to Allaire. They were unable to come up with a solution and after a few weeks put the call into a "bug report". I have not heard anything from them since. I do not have IE running at as as we are not an IE shop. Sorry that I can't offer any bright rays of hope for a solution. I am currently using Samba to map a drive to my Unix server since FTPRDS doesn't work. "Stone, Jeff" wrote: I am having a problem with the RDS and Save As functions in ColdFusion Studio 4.5.1 on one of my developer's machines. After I have created the first few lines of a document, and I attempt to save it to one of my offsite development servers, the "Allaire FTP RDS" option does not show up in the folder (or "Look-in") drop-down list at the top of the Save As dialog window. I have two developers and myself, and we are all running the same OS (Windows NT 4.0), Service Pack (6A) and version of Studio (4.5.1). On my machine and my other developer's machine, we can save to the servers using RDS from within Studio without a problem. However, my other developer has to use a third-party FTP program to FTP her local files up to the server. I have been told that RDS uses Internet Explorer to carry out it's work. So, we tried installing a 4.0 and the 5.5 version of IE without any success. We have tried uninstalling Studio and reinstalling it. Nothing seems to be working. I thought maybe someone else has run into this problem before and may have possibly found a solution. Hoping for some guidance, Jeff Stone Senior Web Developer (512) 912-3349 - Phone (512) 912-3977 - Fax - Cirrus Logic, http://www.cirrus.com Where Analog Meets Digital - Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] --8C2F3608CA33766A4AB8F17A Content-Type: text/x-vcard; charset=us-ascii; name="loryn.williams.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Loryn C Williams Content-Disposition: attachment; filename="loryn.williams.vcf" begin:vcard n:Williams;Loryn tel;work:609-252-5955 x-mozilla-html:FALSE adr:;; version:2.1 email;internet:[EMAIL PROTECTED] fn:Loryn C. Williamsimg src="http://www.pri.bms.com/informatics/sir/logos/weblogo266x40.gif" end:vcard --8C2F3608CA33766A4AB8F17A-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] Archives:
CF_MENSCH
I nominate Michael Smith from Teratech. He goes to extremes giving his time and resources to the ColdFusion Community. He's arranged a few free conferences, runs one of the Maryland ColdFusion User's Groups, writes articles and is generally proactive in making programming with ColdFusion a better experience. (Not to mention he's always good for a free beer!) - Original Message - From: "Adam Phillip Churvis" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, October 17, 2000 6:44 PM Subject: CF_MENSCH Awards FusionFolks, I would like to propose an annual award for the most helpful people in the CF community. The name I picked for this award is CF_MENSCH, because a "Mensch" is a really caring person who treats others with respect, who performs acts of kindness, and who tries to make the community a better place. The people I would like to nominate are: Michael Dinowitz Dave Watts Cameron Childress I see some really outstanding advice and help coming from these folks (any many others, to be sure), so I think we ought to "brand" them accordingly! There are so many who help, and my list contains only those who stick out in my mind most prominently, so I hope others will add their nominations, too. What do you think, folks? Respectfully, Adam Phillip Churvis President Productivity Enhancement, Inc. * PRODUCTIVITY ENHANCEMENT, INC. * * * *Publishers of the CommerceBlocks line of modular development tools* * for ColdFusion * * * * Website: http://www.commerceblocks.com E-mail: [EMAIL PROTECTED] * * Phone: 770-446-8866Fax: 770-242-0410* * * Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Messenger - Talk while you surf! It's FREE. http://im.yahoo.com/ Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
How Feasable Is This?
Hi Everyone, I want to set up a site so that anyone can create their own custom site URL in the form of MY_CUSTOM_NAME.ourdomain.com. In other words, I want to be able to take any incoming URL that ends with ourdomain.com and send it to a template that looks at the machine name portion of the URL and redirects it to the appropriate place depending on the first part of the URL. The idea is to allow people make a website for their company without me having to go into Internet Information Server for each new account and create a virtual directory for that account. So the questions are: 1) Is it a matter of a DNS entry to make it so that ANYTHING.ourdomain.com will always be directed to the same template? If not, how can this be done? 2) Are there any problems I should be aware of with doing it this way? I plan to write a small ColdFusion script that will then parse the URL and handle the rest from there. Thanks, __ Do You Yahoo!? Yahoo! Messenger - Talk while you surf! It's FREE. http://im.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: How Feasable Is This?
Peter and Dave, Thanks for your help. I still have a question though, so pardon me if I am being dense: Since I plan to use ColdFusion to parse the hostname (and not IIS) and since everything will be parsed by code on a machine that is at a single IP address, why can't I setup a wildcard DNS entry (The way Peter described) and just handle all the traffic to that IP address with a ColdFusion template that will build the appropriate pages for that host on the fly? Will I have to do anything at all in IIS? In other words, if there is a wildcard DNS entry in our DNS server which points ANYHOST.ourdomain.com to the same IP Address, since ColdFusion will be parsing and handing it from there, does it really matter what happens from there on the DNS or IIS sides of things? It seems to me that I can just use #CGI.SERVER_NAME# to figure out what host is being called and just go dynamically from there. Thanks for the advice, Eron Peter Wrote: You can set up a wildcard DNS entry for *.mydomain.com = IP address. Do this just once ahead of time. I don't know specifically what the DNS file looks like for this, I just ask my ISP (Verio) to set it up and they do... Then on your web server you set up a name-based virtual server for each name you want to catch (and you should have a "default" virtual server for everything else you haven't specified). To do this do what Dave says below... At 09:43 PM 10/14/00 -0400, Dave Watts wrote: I want to set up a site so that anyone can create their own custom site URL in the form of MY_CUSTOM_NAME.ourdomain.com. In other words, I want to be able to take any incoming URL that ends with ourdomain.com and send it to a template that looks at the machine name portion of the URL and redirects it to the appropriate place depending on the first part of the URL. The idea is to allow people make a website for their company without me having to go into Internet Information Server for each new account and create a virtual directory for that account. So the questions are: 1) Is it a matter of a DNS entry to make it so that ANYTHING.ourdomain.com will always be directed to the same template? If not, how can this be done? 2) Are there any problems I should be aware of with doing it this way? I plan to write a small ColdFusion script that will then parse the URL and handle the rest from there. The MY_CUSTOM_NAME portion of your URL is called the host name. You'll need a DNS entry for each host name, and that entry will have to point to a specific IP address (an A record, in DNS parlance), or to an alias that itself points to an IP address (a CNAME record). If you point multiple host names to the same location, your web server will require the browser to send the host header name to point to a specific directory, or you could have the script you mention redirect the user to the appropriate location. In either case, setting up additional virtual servers in IIS won't be the hard part, given the number of utilities that exist for just that purpose, such as Lewis Sellers' set of CFX tags. Changing the DNS entries, on the other hand, might be more difficult, depending on what DNS server you're using, how it's set up, and whether you can access it from your web server. Most DNS servers use text files to store DNS entries, and most will probably require that you edit the text files to add the changes you want; they may also require a restart if they provide their own interface for managing DNS records. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 x204 Fax 1.212.545.0938 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. __ Do You Yahoo!? Yahoo! Messenger - Talk while you surf! It's FREE. http://im.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Error attempting to write location redirection to web server
I am asking this again. Someone out there MUST know what this error is about and what to do about/how to trap it: Does anyone know what this error is referring to? Its not in the Allaire KB and others on the forums.allaire.com have asked, but nobody seems to know what exactly it means. "ERROR","TID=492","09/19/00","18:48:13","Error attempting to write location redirection to web server (Windows NT error number 16389 occurred)" I really wish there was a good resource that has a list of all the various errors you could get in your ColdFusion logs and what they mean. Thank You, Eron Cohen -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Error attempting to write location redirection to web server
Hi Lon, Thanks so much for your help. I don't think this article is related to the question at hand. If you read it carefully, it just mentions some other kind of error that happens to have #16389. Its strange that nobody seems to know what this about. Eron -Original Message- From: Lon Lentz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 26, 2000 5:22 PM To: CF-Talk Subject: RE: Error attempting to write location redirection to web server I did a search of the MS knowledgebase using "Windows NT error number 16389 occurred" and got this: Q172101 - PRB: "Data Type Conversion Error" When Using a Data Control Here's a link to the knowledgebase. Just use the Q number above. http://search.support.microsoft.com/kb/c.asp Lon Lentz Applications Developer CyberEntomologist - Alvion Technologies DataWarehousing and List Sales - Market Your Lists on the Net! [EMAIL PROTECTED] 941-574-8600 Ext. 210 -Original Message----- From: Eron Cohen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 26, 2000 2:41 PM To: CF-Talk Subject: Error attempting to write location redirection to web server Does anyone know what this error is referring to? Its not in the Allaire KB and others on the forums.allaire.com have asked, but nobody seems to know what exactly it means. "ERROR","TID=492","09/19/00","18:48:13","Error attempting to write location redirection to web server (Windows NT error number 16389 occurred)" I really wish there was a good resource that has a list of all the various errors you could get in your ColdFusion logs and what they mean. Thank You, Eron Cohen -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Error attempting to write location redirection to web server
Does anyone know what this error is referring to? Its not in the Allaire KB and others on the forums.allaire.com have asked, but nobody seems to know what exactly it means. "ERROR","TID=492","09/19/00","18:48:13","Error attempting to write location redirection to web server (Windows NT error number 16389 occurred)" I really wish there was a good resource that has a list of all the various errors you could get in your ColdFusion logs and what they mean. Thank You, Eron Cohen -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: [CF-Talk] Problem with Verity (CF 4.0)
Hi Richard, This is definitely extreme. Do you have any idea how large (in megabytes) is your Verity collection getting? There's a bug about collection size in the Allaire KB. Does "repairing" the index from the ColdFusion administrator do you any good when this issue comes up? Eron -Original Message- From: Richard Colman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 19, 2000 1:41 PM To: Cf-Talk Subject: [CF-Talk] Problem with Verity (CF 4.0) I am currently running a verity full-text search through an ACCESS database under CF 4.0 on a production site. Every once in a while, the full-text search just stops returning any results. Then, I have to delete the collection, reboot the server, delete the lck file, delete the collection folder. Add a new collection, re-index it, and then it works again. Is this a known bug in 4.0? Is there a patch. Do I need to upgrade to 4.5 for 4.5.1 or Any comments appreciated. Richard Colman -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: [CF-Talk] CF app on CD
BTW, there is also a "runtime" version of MS Access...I have no idea how the licensing works or how expensive it is. Eron -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 19, 2000 2:47 PM To: '[EMAIL PROTECTED]' Subject: RE: [CF-Talk] CF app on CD I don't know if this would meet your needs ... or if there are better options out there to do the same thing. But if you need a database app on a CD, it might be worthwhile to look into FileMaker's Developers Edition. It allows you to create run-time apps. It's a great way to give a user database functionality without requiring them to install any extra software. H. = Howard Owens Web Producer InsideVC.com mailto:[EMAIL PROTECTED] = -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: [CF-Talk] checkboxes -- processing multiple boxes
Hi Melissa,
Checkboxes can be a little bit tricky. First off, I'd recommend NOT using
CFINSERT or CFUPDATE. Especially with checkboxes, it can be
counterproductive...at best you loose control. As you probably already
know, when a checkbox is turned off, it does not send ANYTHING to the action
page. It just won't be defined at all. So, take advantage of CFPARAM tag.
It will allow you to make the default value 0 for any checkbox field that is
"not defined" because it wasn't checked.
In other words, if you have a checkbox called "my_checkbox" on the form,
than you'll want to have a cfparam on the action page that looks something
like:
CFPARAM name="form.my_checkbox" default="0"
Then in your INSERT or update query, you can always reference
#form.my_checkbox# and it will be 1 if the box was checked or 0 if its not
defined.
If you have multiple checkboxes, just use multiple CFPARAMs.
Another method would be to do an "isdefined()" function for each checkbox.
In your insert query, you'd need a CFIF statement for each checkbox that
would look something like:
CFIF isdefined("form.my_checkbox")
1,
CFELSE
0,
/CFIF
Finally, if you really want to use CFINSERT or CFUPDATE, I think you need to
put a hidden field by the name of each checkbox in your form with a value of
0. This way, if the checkbox is not checked the form will still send a
value of 0 for that field (and if it is checked, the value will be 1,0 which
CFINSERT/CFUPDATE seem to be able to deal with)
HTH,
Eron
-Original Message-
From: Melissa Fraher [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 19, 2000 6:55 PM
To: [EMAIL PROTECTED]
Subject: [CF-Talk] checkboxes -- processing multiple boxes
How would you process multiple check boxes that are submitted on a
form? I can't seem to get it working.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
[CF-Talk] RE: listing tables in Access?
Once upon a time there was a tag in the Allaire Tag Gallery that did this for MS Access. Unfortunately, it quit working when we we upgraded to Access 2000 or something like that (I forget exactly what went wrong). Just in case it will work for you, it was called CFX_TABLEFIELDS. HTH, Eron -Original Message- From: Jamie Keane [mailto:[EMAIL PROTECTED]] Sent: Monday, September 18, 2000 1:38 PM To: CFTalk Subject: OT: listing tables in Access? Hello everyone, I was wondering if Access has some mechanism in place to list all tables in a database. Thanks. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Alternatives to Access?
Hi, While our ISP (edgewebhosting.com in Maryland) does not allow us to use the enterprise manager, we are able to use the MS Access 2000 front end for SQL Server to access our data and to change tables...its a fantastic improvement over using an MS Access .mdb database. For instance, because we no longer have to fool around with downloading and replacing the database everytime we want to change a table structure (obviously we could use "Alter table" but that is a pain too.) We are also able to use the Query Analyzer (although curiously not the "perform index analysis feature). If you need any help getting set up using the MS Access 2000 interface to access your SQL Server database, just drop me an email. Eron __ Do You Yahoo!? Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Strange Warning in Application.Log
Hi Folks, I am getting a strange error in my Application.Log file that I am wondering if anyone could decode. The error itself is cryptic to me, but weirder still is that the problem is with a shopping cart that I am fairly certain isn't being used by anyone at all...so why is this tag being looked at: "Warning","TID=238","09/06/00","10:58:08","In a CF_TagName construct custom tag file 'C:\CFUSION\CustomTags\Ship\intershipper.cfm' will occlude custom tag file 'C:\inetpub\wwwroot\shopping_cart\constructors\intershipper.cfm'." Thanks, Eron -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Datevalue/timevalue functions
I am in the process of upsizing an old website to SQL Server from MS Access. I've run into a problem where the old site uses an MS Access-native function that SQL Server does not seem to have: SELECT TimeValue([answered_message_date]) AS Time_of_problem, DateValue([answered_message_date]) AS date_of_problem FROM messages Does anyone know of a way I could get the equivelent values using a SQL Server function? The field "answered_message_date" is a datetime field, for example: 7/11/00 3:59:02 PM . . . I really just ned to seperate the date from the time (but I DO need to do so in the query itself, I can't do it after the fact because this data is being UNIONed with another table that DOES have these fields seperate.) Thanks for any ideas. Eron -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: MS Access V.S. SQL
Chad, IMHO, MS Access will handle your 10,000 records without any database problems. Access can actually handle much bigger databases than that. Having said that, if your site has a high-level of traffic, you'll likely experience stability problems with ColdFusion as a result of using Access. These are mostly to do with the ODBC drivers and because of the fact that MS Access isn't a client/server database. Ben Forta recently wrote an article called "Access Denied" You should have a look at it: http://www.sys-con.com/coldfusion/archives/0206/forta/ There is even an article in Allaire's knowledgebase as to why you shouldn't use Access. HTH, Eron -Original Message- From: Chad [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 30, 2000 1:05 PM To: [EMAIL PROTECTED] Subject: MS Access V.S. SQL How many records can MS Access handle safely? Im looking at a project that may be around 10,000 Records. Are there other specific database needs that demand making the leap to a SQL server? Thanks Chad -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: what part of cfm don't you understand?
I think that EdgeWebHosting in Maryland is excellent. Not only do they give very good service, but they know/use ColdFusion and they offer you the ability to add your own MS Access datasources. Their prices are also very competitive. www.edgewebhosting.com -Original Message- From: Gavin Myers [mailto:[EMAIL PROTECTED]] Sent: Monday, August 28, 2000 9:28 AM To: '[EMAIL PROTECTED]' Subject: ot: what part of cfm don't you understand? hey, i know that we just had this conversation not too long ago, and I was the one that was downing interland so here it goes: I have a customer that is going to be needing a low traffic site built, the site needs to support cold fusion, and have sql server. Is there an ISP that has both of those for a relatively low price? Nother thing, This customer has another 5 businesses so if this all goes well then I get to do all of those also... so I don't want to hook him up with an unreliable place suggestions? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: html editor
Phil, Since its 100% free, I'd say download it and try it out yourself. Its a very cool interface, and packed with useful stuff...its surprisingly similar to ColdFusion Studio. BTW, for some reason, the URL is a little bit tricky. To download this software go to: http://www.evrsoft.com/download/ Eron - Original Message - From: "Phil Labonte" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, August 19, 2000 10:32 PM Subject: html editor Does anyone use the following editor instead of studio? Evrsoft 1st Page 2000 Do you like using this editor? It was recommended by a friend of mine but I wanted to see what all you thought about it. Thanks -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFMAIL Refusing to Send Attachments
I have. Would your attachments happen to be a Rich Text File? That seems to be a common thread with the people I've run into with this trouble. Eron - Original Message - From: "Kevin Plexico" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, August 18, 2000 11:02 AM Subject: CFMAIL Refusing to Send Attachments Anyone run into this? We are trying to have CFMail send an attachment to a group of users (through a query). When we process the page with the CFMAIL we get the following message: Error Diagnostic Information Unable to write mail message to disk. An unexpected error occurred while attempting to save the mail message. I can send the message with the attachment to one person, but it seems to choke on the group (which is only about 100 people). We are using CF4.5.1 and there is plenty of disk space on the drive. Thanks Kevin -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Open Source (and free?) web content editor?
Hi Cameron, Personally, I really like the features of the Ektron EWebEditPro. Having said that, here's a FREE java based editor with far fewer features...in limited tests, it did seem to work: http://javaboutique.internet.com/HTMLEdit/ HTH, Eron - Original Message - From: "Cameron Childress" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 17, 2000 11:08 AM Subject: Open Source (and free?) web content editor? I know this has been discussed before, but after looking through my email archives I don't see a direct answer to my question, so here it is: I'm scouring the web for word processor-ish content editor to embed into a content management system. I've found Activedit (www.cfdev.com) and eWebEditPro (www.ektron.com) so far. The two products look very similar with a few differences. You can get Activedit as open source, and I like that. What I'd really love to find though, is a nice *free* and full featured editor. I don't know that's going to happen, but I gotta try. I'm thinking that one may exist in PHP-land or something. In the event that there was a PHP (or ASP) version out there, all I really need is the client editor part. It should be trivial to change the small amount of code which exchanges the content with the DB. Anyone seen anything like this anywhere out there? -Cameron Cameron Childress McRae Communications p. 770-460-7277 x.232 f. 770-460-0963 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT: MS Access 2000 SQL Server Project Question
Thought I'd see if anyone here knows the answer to this: I am using MS Access 2000 as a front end to access a remote SQL Server database. Every now and then when I go to update data in a table from MS Access I get an error saying that the "recordset cannot be updated" Does anyone know what causes this and how to get around it? I'd understand more if it were a multitable query involved, but I am just opening ordinary single tables and when I get that message. Eron -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF configuration quesiton
Hi Oriole, One idea is that it may be running out of memory. Try this: Close ColdFusion Studio and open your Windows Explorer (Windows Key-E or choose Choose MY COMPUTERALLAIRE FTP/RDS) See what happens if you try to add an RDS Server from there (Just right click on ALLAIRE FTP/RDS and choose ADD RDS SERVER). Baring that, what OS and Service Pack are you on? Best Regards, Eron -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 15, 2000 4:02 PM To: [EMAIL PROTECTED] Subject: CF configuration quesiton I want to use view my databases through CF. But when I go to the database tab it is empty and when I try to select MarksportRDS or add a new RDS I get an error that says, "Error loading type library/DLL." I did install the cfrdsservice patch. Any clues what to try next so I can use my databases? Thanks! :-) Oriole Saah MarkSport.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Help - writeEmergencyMessage Error !
Hi Jonathan, I have also gotten this error message in ColdFusion 4.51 on Windows NT. And it mysteriously came and went, I have only seen it twice and never saw it again. I found another person who's experienced this issue too on forums.allaire.com. He believes that its related to the numberformat() and dollarformat() functions. Just out of curiousity, are you using either one of these on the page in question? I don't know of anything official from Allaire about this. Eron - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, August 13, 2000 11:40 AM Subject: Help - writeEmergencyMessage Error ! Hi guys, one of the servers I'm working with gave me the following error message for a few minutes straight : Error occurred while processing request Error Diagnostic Information unknown exception condition CFMLInterpreterImp::writeEmergencyMessage It returned to normal afterwards, but now I'm wondering if there's something serious gone wrong! Has anyone encountered this before? Any ideas on what might be happening? Thanks in advance, J - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Remote SQL server as datasource
Hi Folks, I am trying to set a remote MS SQL server (via the internet) as an ODBC datasource in ColdFusion 4.x. I can get the connection going fine in the ODBC control panel. But in the ColdFusion administrator the datasource verification fails. Does anyone have any ideas of what could be wrong? Thanks, Eron -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Remote SQL server as datasource
Thanks for your help, unfortuantely, I have done that, but still no-go...It still comes back with a "FAILED" status for the connection in the ColdFusion Admin ODBC settings. Eron - Original Message - From: "[EMAIL PROTECTED]" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 11, 2000 5:35 PM Subject: Re: Remote SQL server as datasource Make sure that you that you have input your SQL Server username and Password in the ColdFusion Login section under CF Settings. Unless you do this, ColdFusion does not know how to log into the server and you will have to pass the username and password as part of the attributes of CFQUERY. - Original Message - From: "Eron Cohen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 11, 2000 5:12 PM Subject: Remote SQL server as datasource Hi Folks, I am trying to set a remote MS SQL server (via the internet) as an ODBC datasource in ColdFusion 4.x. I can get the connection going fine in the ODBC control panel. But in the ColdFusion administrator the datasource verification fails. Does anyone have any ideas of what could be wrong? Thanks, Eron -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Remote SQL server as datasource
Hi Frank, That was also already done, still no go (although from ODBC control panel the source tests out fine--its just ColdFusion that can't seem to get to this SQL Server datasource...weird.) Thanks for your help... Eron - Original Message - From: "Frank Priest" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 11, 2000 8:01 PM Subject: Re: Remote SQL server as datasource Go into the Windows NT "Control Panel", "ODBC" Select your data source, click configure, click "Nex", "Client Configuration" Make sure that you have TCPIP selected under Client Libraries. Hopefully that will do the job :-) At 06:05 PM 8/11/2000 -0400, you wrote: Thanks for your help, unfortuantely, I have done that, but still no-go...It still comes back with a "FAILED" status for the connection in the ColdFusion Admin ODBC settings. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: OT eWebeditPro CFML
Hi Dan, I don't think you're going to be able to do this directly. Unfortunately, ColdFusion won't evaluate cold fusion code that's CFOUTPUT from a database query. The only way around this that I know of is to write the output to a file and then execute the file (I believe you could do this by CFINCLUDING it.) I think there may have been a custom tag in the ColdFusion library that may also help deal with this, but I think its just a variation on what I am saying here. Best Regards, Eron - Original Message - From: "Dan O'Keefe" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, August 07, 2000 8:02 PM Subject: OT eWebeditPro CFML Anybody on the list using eWebEditPro and figured out a way to embed CFML within the eWebEditPro editor, save it, and then display the results. I am trying to do something like: In a eWebEditPro editing session: formatted static text.. cfoutput#phonenum#/cfoutput Some more formatted static text Then eWebEditPro saves all of this and I store it in a table in SQL. Later, query the table, and display the contents of that field, but I want CF to interpret the CFML. If I try wrapping an evaluate function around the var, it errors out on the first '' that it comes across. Thanks -- Dan O'Keefe TriPoint Technologies [EMAIL PROTECTED] 954.501.3113 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Weird CFCONTENT problem with WinProxy
Hi Folks, Does anyone know of any issues with using CFCONTENT to display images for clients browsing through WINproxy? I am using CFCONTENT to display .gif files (banner ads). It works fine when I am not behind a WinProxy server, but when I am the images just don't display. I have even tried using the same machine with and without WinProxy...it always works fine when WinProxy is not involved. We've tried clearing caches, etc...but haven't had any success. Thanks for any ideas, Eron Here is the CFCONTENT statement (in a file called banner_get_for_display.cfm): CFCONTENT TYPE="image/gif" FILE="#actual_location#\#IMAGE_TO_DISPLAY#" Here is how I call it when I am displaying a banner: IMG SRC="http://www.myserver.com/banner_get_for_display.cfm?campaign_id=3" -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Mysterious Crashing Problem
Hi Folks, I've been experiencing a problem lately with a ColdFusion 4.5 appliction running on a hosted/shared server. Every now and then (every couple of days) when I go to open a particular page ColdFusion bogs down and eventually hangs altogether. The page in question is a javascript popup window. It does a query with 5 tables joined together to retrieve a pricelist and then displays the list using CFOUTPUT with the GROUP parameter. The only other thing that's "unusual" is that it uses the dollarformat function. I am requesting the logs from our hosting provider and I have asked them to update from MDAC 2.1 to MDAC 2.5. Can anyone think of anything else to try here? Thanks, Eron -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Strange Error: CFMLInterpreterImp::writeEmergencyMessage
Hi Folks, I ran across a strange error that's also been noted on forums.allaire.com: CFMLInterpreterImp::writeEmergencyMessage Another guy who's experienced the message says its a problem related to numberformat/dollarformat functions (which I do happen to be using on the page in question). Anyone have any ideas on what exactly this is? The weird thing is that its intermittent. Eron -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Good Datasource Gone Bad?
Hi Folks, I've been having a problem lately, and I wanted to run it past this list to see if anyone has any ideas. I've been doing some work that involves a remote site using a small MS Access database. Every now and then I get a problem where specific ColdFusion templates that used to load fine suddenly just hang the server, and it always seems to coincide with times when I have recently changed and reuploaded the database using FTP Explorer. When the problem occurs I can usually narrow it down to one query that doesn't work. Most recently it was a relatively big query, but nothing that should hang the server and furthermore, the same thing doesn't seem to be happening on my local version of the site. The site is not launched yet, only 2 or 3 people access it at the moment. Also, I am not the administrator of the server (its a site hosting company) so I don't have any control over the configuration or easy access to the logs. Thanks for any ideas. Eron -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Studio tips
Color coding your tags in Cold Fusion can be pretty cool. For instance, on my machine, any comments have a light grey background with black type. In OptionsSettingsColor Coding. Double click on the type of file (for instance HTML/CFM) that you want to color code tags for. Pretty cool. - Original Message - From: "Phil Labonte" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 02, 2000 9:29 PM Subject: Studio tips I am looking for any ColdFusion Studio 4.5 tips and tricks. We are giving a small presentation at the Ottawa ColdFusion User Group Meeting this Tuesday and I am looking for anything you can send. Things like keyboard shortcuts, things people do to make coding a little easier. Some tricks that people who use Studio to code every once in a while might not know. Any help would be greatly appreciated. Thanks! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: RE: Problem Handling Sessions
Joeug, Thank you! The idea about manually setting the cookies worked. Eron - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 01, 2000 8:49 AM Subject: RE: RE: Problem Handling Sessions You are refreshing the page by submitting the form, which means you can loose your session. Work around. You have to manually set the cookie CFID AND CFTOKEN or change your settings in Admin to point your CFID And CFTOKEN to a database, rather than the registry. Which also is needed for clustering. cfcookie Name="CFID" value="#CFID#" cftoken Name="CFToken" value="#CFToken#" or use a Session variable cfparam Name="Session.Sid" default="#Session.CFID##Session.CFTOKEN#" Test: If you just have one page to see what your CFID and CFTOKENS are and hit the refresh button of IE or the Reload button of Netscape, you will see the CFID and CFTOKENS change. -- I have two questions about sessions. 1) I have an application that opens a pop-up javascript window with a form. This on the javascript window submits itself back to the template that opened it. It seemed to be working fine, but suddenly I am loosing my session when the form is submitted. (Its changing to a new CFID and CFTOKEN). The question is what could be causing me to loose the session in this way and how do I fix this? Do I have to start passing URLTOKEN around? --- Original Message --- "Steve Martin" [EMAIL PROTECTED] Wrote on Tue, 1 Aug 2000 09:54:08 +0100 -- I have two questions about sessions. 1) I have an application that opens a pop-up javascript window with a form. This on the javascript window submits itself back to the template that opened it. It seemed to be working fine, but suddenly I am loosing my session when the form is submitted. (Its changing to a new CFID and CFTOKEN). The question is what could be causing me to loose the session in this way and how do I fix this? Do I have to start passing URLTOKEN around? Have you also suddenly turned off cookies? If you haven't been passing URLToken around previously then you must have been relying on cookies to perpetuate the session. Or, has the domain portion of the popup box changed i.e. is your main site www.a.com and the popup box in www.b.com - this would cause cookie loss and hence session loss. 2) What methods can I use to prolong the length of a session? I can't change the timeout value because I am using an ISP. Eron, just because you're using an ISP it doesn't mean that you can't change the timeout values. Sure, you can't change the default timout values as set in the administrator but you can override these with your own settings in your CFAPPLICATION tag (e.g. sessiontimeout="#CreateTimeSpan(0,0,30,0)#"). Thanks, Eron NP Steve -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Problem Handling Sessions
Hi Sean, Thanks for the help. My problem with prolonging sessions is that I don't have access to the server admin. They have the max timeout set to twenty minutes, so I don't think it matters what value I set the sessiontimeout to be, it will not be longer than 20 minutes. I am hoping there might be some other way. Eron -Original Message- From: Sean Renet [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 01, 2000 12:08 AM To: [EMAIL PROTECTED] Subject: Re: Problem Handling Sessions yes you need to pass session.urltoken around between frames. From the docs SESSIONTIMEOUT Optional. Enter the CreateTimeSpan function and the values you want in days, hours, minutes, and seconds, separated by commas to specify the lifespan of any session variables that are set. The default value is specified in the Variables page of the ColdFusion Administrator. This means that only the default timeout is set up in the CF administrator - Original Message - From: "Eron Cohen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 31, 2000 8:58 PM Subject: Problem Handling Sessions Hi Folks, I have two questions about sessions. 1) I have an application that opens a pop-up javascript window with a form. This on the javascript window submits itself back to the template that opened it. It seemed to be working fine, but suddenly I am loosing my session when the form is submitted. (Its changing to a new CFID and CFTOKEN). The question is what could be causing me to loose the session in this way and how do I fix this? Do I have to start passing URLTOKEN around? 2) What methods can I use to prolong the length of a session? I can't change the timeout value because I am using an ISP. Thanks, Eron -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFMAIL problem
Anyone have any ideas what this CFMAIL error is about? Error Diagnostic Information Unable to write mail message to disk. An unexpected error occurred while attempting to save the mail message. I've never seen it until recently. My harddrives have plenty of space. I am using CF 4.51/IIS 4.0/NT 4.0 SP 6a. Here's my code: CFMAIL to="#this_line#" from="#form.mail_from#" subject="#form.mail_subject# (Invoice: #inovoice_number#)" type="HTML" CFMAILPARAM FILE="d:\online-documents\readme_files\SoftwareLicenseAgreement.rtf" CFMAILPARAM FILE="d:\online-documents\readme_files\readme.wri" #Mail_message# br Authorization cfif #form.number_of_codes# is "1"CodecfelseCodes/cfif: #temp_codes#br /cfmail Thanks in advance, Eron -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Studio: Quickkey for Show Open Docs
Hi Folks, Does anyone know if there is a quickkey for "show open docs" list in Cold Fusion studio? I would love to be able to trigger this with a key combination rather than having to use the mouse to click that little button. Thanks, Eron -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Is there a CF certification?
If you want to take a free, web based certification go to www.brainbench.com or www.ecertifications.com. I recommend brainbench. They have a better interface and they send you actual certificates. Eron -Original Message- From: jonathan hamner [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 26, 2000 5:44 PM To: [EMAIL PROTECTED] Subject: Is there a CF certification? Is there a CF certification? If so, can someone please let me know how to get it. Thanks A Bunch. __ Do You Yahoo!? Get Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: cfmail problems
Hi Michael, Thanks for the advice. Interestingly enough, I found another guy on Allaire forums who was describing the exact same problem and he was also attaching a rich-text file. Unfortuantely, forums have been down most of today so I haven't been able to post there about it. I'll bet you're right though, it must be something in that attachment. Eron (about to start another CFMAIL thread) - Original Message - From: "Michael Smith" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 26, 2000 6:21 PM Subject: Re: CFMAIL problem --6A8DF45E9A5D90D670826DEE Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit could be a bad character in the email - I once had our email server die with some bad characters in the email. Do this happen on all email or just one? if one check the text you are sending. - Michael Smith, TeraTech, Inc http://www.teratech.com/ Eron Cohen wrote: Anyone have any ideas what this CFMAIL error is about? Error Diagnostic Information Unable to write mail message to disk. An unexpected error occurred while attempting to save the mail message. I've never seen it until recently. My harddrives have plenty of space. I am using CF 4.51/IIS 4.0/NT 4.0 SP 6a. Here's my code: CFMAIL to="#this_line#" from="#form.mail_from#" subject="#form.mail_subject# (Invoice: #inovoice_number#)" type="HTML" CFMAILPARAM FILE="d:\online-documents\readme_files\SoftwareLicenseAgreement.rtf" CFMAILPARAM FILE="d:\online-documents\readme_files\readme.wri" #Mail_message# br Authorization cfif #form.number_of_codes# is "1"CodecfelseCodes/cfif: #temp_codes#br /cfmail Thanks in advance, Eron -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Michael Smith, TeraTech Inc - Tools for Programmers(tm) VB, CF/ASP Web, Telephony, Math, Access programming tools consulting 100 Park Ave Ste 360, Rockville MD 20850 USA Voice: +1-301-424-3903, 800-447-9120 x500 Fax:301-762-8185 BBS:301-762-8184 Web: http://www.teratech.com/sig/ Email: mailto:[EMAIL PROTECTED] --6A8DF45E9A5D90D670826DEE Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit !doctype html public "-//w3c//dtd html 4.0 transitional//en" html could be a bad character in the email - I once had our email server die with some bad characters in the email. Do this happen on all email or just one? if one check the text you are sending. br- Michael Smith, TeraTech, Inc A HREF="http://www.teratech.com/"http://www.teratech.com//A pEron Cohen wrote: blockquote TYPE=CITEAnyone have any ideas what this CFMAIL error is about? pError Diagnostic Information brUnable to write mail message to disk. brAn unexpected error occurred while attempting to save the mail message. pI've never seen it until recently.nbsp; My harddrives have plenty of space.nbsp; I bram using CF 4.51/IIS 4.0/NT 4.0 SP 6a. pHere's my code: plt;CFMAIL to="#this_line#" from="#form.mail_from#" brsubject="#form.mail_subject# (Invoice: #inovoice_number#)" type="HTML" brlt;CFMAILPARAM brFILE="d:\online-documents\readme_files\SoftwareLicenseAgreement.rtf" brlt;CFMAILPARAM FILE="d:\online-documents\readme_files\readme.wri" br#Mail_message# brlt;br brAuthorization lt;cfif #form.number_of_codes# is "1"Codelt;cfelseCodeslt;/cfif: br#temp_codes#lt;br brlt;/cfmail pThanks in advance, pEron p- - brArchives: a href="http://www.mail-archive.com/cf-talk@houseoffusion.com/"http://www.mai [EMAIL PROTECTED]//a brTo Unsubscribe visit a href="http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_tal k"http://www.houseoffusion.com/index.cfm?sidebar=listsamp;body=lists/cf_ta lk/a or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body./blockquote p-- brMichael Smith, TeraTech Inc - Tools for Programmers(tm) brVB, CF/ASP Web, Telephony, Math, Access programming tools amp; consulting br100 Park Ave Ste 360, Rockville MD 20850 USA brVoice: +1-301-424-3903, 800-447-9120 x500nbsp; Fax:301-762-8185nbsp; BBS:301-762-8184 brWeb: A HREF="http://www.teratech.com/sig/"http://www.teratech.com/sig//A brEmail:nbsp; A HREF="mailto:[EMAIL PROTECTED]"mailto:[EMAIL PROTECTED]/A brnbsp;/html --6A8DF45E9A5D90D670826DEE-- -- Archives: http://
CFMAIL and authentication
Hi All, I am wondering if anyone knows of a way to send mail to servers that require authentication with ColdFusion. Apparently, you can't do it with CFMAIL, so perhaps someone knows of a tag that does support this. Thanks, Eron __ Do You Yahoo!? Get Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Parsing URLs on IIS 4
Hi Gene, Here is one idea...its a long-shot, but: You probably already know that if you're using the fusebox.org customer tag "CF_formurl2attributes" slash-delimited query strings are handled automatically. Having said that, perhaps if you are using that tag, someone replaced your version with an older version of the tag that did NOT handle slash-delimited query strings. (Or maybe you kept yours in the custom tags directory on the server and someone slipped in a local copy that's being used instead of the newest one). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 25, 2000 7:18 AM To: [EMAIL PROTECTED] Subject: Parsing URLs on IIS 4 Can anyone suggest what settings in IIS 4 / SP5 could cause problems with slash-delimited query strings? We use a well-known CF web hosting service for a client site. To improve visibility on search engines, we use slash-delimited query strings rather than the standard name=value pairs, and use the cgi.path_info variable to translate. Late last week, the server began coughing on the slash-delimited query strings. It appears that the server believes the slashes indicate folders, and it gives 404 errors whenever a slash-delimited URL query string is accessed. We figured they had just installed SP6 or 6A, since members of this list had variously suggested one or the other may cause such problems. The host, however, says the server is still using SP5. The query strings causing problems look like this: www.greenthumbsup.com/index.cfm/fuseaction/ShowPage/PageID/6 Strangely, once the server throws a 404 on a URL like this, it continues to throw the same error even if you manually strip the URL back to the default top page (which runs fine if you access it before going to a page using a slash-delimited query string): www.greenthumbsup.com/index.cfm Any ideas greatly appreciated! Gene Kraybill -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Looking for a CF Host site
Thank You Paige, BTW, one of the things I like most about Edge Web is that they allow you to create your own mappings and add and delete datasources through a custom interface. Other companies I've worked with on shared servers don't let you do anything like that...its always the old "email [EMAIL PROTECTED] and wait wait wait..." Eron (no I don't work for them) - Original Message - From: "Paige Chandler" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 24, 2000 10:38 PM Subject: Re: Looking for a CF Host site Hi Eron, Thanks. By the way I've enjoyed your demos at CFUG-MD. Regards, Paige - Original Message - From: "Eron Cohen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 24, 2000 5:30 PM Subject: RE: Looking for a CF Host site Edge Web Hosting in Baltimore has been very good to us: -They are responsive -They know their Cold Fusion -They offer competitive rates. http://www.edgewebhosting.com -Original Message- From: Paige Chandler [mailto:[EMAIL PROTECTED]] Sent: Monday, July 24, 2000 4:56 PM To: [EMAIL PROTECTED] Subject: Looking for a CF Host site This is a multi-part message in MIME format. --=_NextPart_000_0019_01BFF590.14497F40 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi All, I'm not satisfied with my current CF host. Can anyone recommend a = reliable CF host site preferably in the Washington Metro area? TIA. Regards, Paige --=_NextPart_000_0019_01BFF590.14497F40 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1" META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2Hi All,/FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2I'm not satisfied with my current CF = host. Can=20 anyone recommend a reliable CF host site preferably in the Washington = Metro=20 area?nbsp; TIA./FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2Regards,/FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2Paige/FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV/BODY/HTML --=_NextPart_000_0019_01BFF590.14497F40-- -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Linux Version of Cold Fusion
Hi Everyone, I am wondering if anyone can comment on the Linux version of ColdFusion. I am particularly wondering about the stability of ColdFusion on that platform. I'd especially like to hear from anyone who's moved away from Windows NT running CF or is running both versions. I have been told by one person that CF is LESS stable at the moment on Linux, and I want to see if that's true before we switch over to that platform. Eron -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFPop alternative
Hi Michael, I have alot to say about this. I too am using Post.Office 3.5x (isn't that what you use?) and have run into this same problem. I have a mailing list that I keep an archive for. I used a Post.Office account to just "collect" the messages just like you. By the time I got around to downloading and databasing them, the account had thousands of messages in it. The main problem that I found absolutely no way of getting around (programmatically) was that NEITHER Cold Fusion CF_POP or CFX_iiPOP3 could seem to DELETE a message from the server once it was read--this is a BIG problem :-). What I actually wound up doing was setting up a temporary account on Post.Office, then I just went to the server and manually transfered about 600 messages at a time by copying deleting the individual mail files from their original location to the IN folder for the new account. Next I "processed those files" with a Cold Fusion template that would download and database from the temporary account. Finally, I would delete the 600 messages from the temporary account and then start over. Needless to say, this did not make me happy. Six hundered messages seemed to be optimum. I discovered this by trying to grab between 100 and 1000 messages at a time until I came up with a number that seemed to work best. Once I got the number of waiting messages down to something reasonable, I just set up a scheduled task that frequently checked this account. The only time I really have problems is when there are more than 100 messages waiting, so I just don't let that happen now. I should note that the mail server machine I'm using is only a Pentium 100, so this could be partly responsible for my troubles. Hope this helps, Eron -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Friday, July 14, 2000 11:41 AM To: [EMAIL PROTECTED] Subject: CFPop alternative I've been saving all the lists at House of Fusion over to an archive account on the mail server. The idea was to read out the mail into a DB and provide it online. Problem is, the account has over 45,000 emails in it (way over). CFPOP really doesn't like dealing with this and always returns errors, even when asking for a single message. Does anyone have a CFPOP alternative? Something that could possibly allow me to grab these messages. We're talking a years worth of list data. Alternatively, if anyone has a complete mail archive of CFTALK, I'd be quite happy to convert that. One of the goals is to get a CD archive that people can have. We missed the deadline for the CFUN2K conference, but the hope is to get the Allaire conference. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF Crash on Shutdown
Hi Steve, For the times that I "decide" to shut down the service, I have a batch file that first shuts down the IIS service, and then shuts down the various Cold Fusion services (using NET STOP at the command prompt). Even then, the server still does crash. But that only accounts for the times I have "decided" to shut down. Under certain circumstances, Cold Fusion will cycle itself (because of some of the settings in the Cold Fusion administrator that have to do with unresponsive threads). Does anyone know what Allaire is saying about this? I find nothing in the Knowledgebase. Eron -Original Message- From: Steve Martin [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 13, 2000 4:55 AM To: [EMAIL PROTECTED] Subject: RE: CF Crash on Shutdown Under heavy load CF has been known to crash when trying to shut down the service. Try shutting down your web server first and wait a few moments for all CF threads to end then try stopping CF. HTH Steve -Original Message- From: vince [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 13, 2000 06:47 To: [EMAIL PROTECTED] Subject: Re: CF Crash on Shutdown ah! Good you brought this up ... cause I always thought that I was the only one facing these problems !! My system is a PII 233, 128 MB of RAM, NT 4.0 SP 6a, IIS 4.0. Cold Fusion 4.51. regards, Vin At 05:15 PM 7/12/00 -0400, you wrote: Hi Everyone, I am wondering if anyone knows how to solve this. Whenever Cold Fusion shuts down on one of our servers, it crashes with the following error: An Application Error has occurred and an application error log is being generated CFSERVER.EXE Exception: (0xe06d7363), Address 0x77f1d479 The system is a PII 233, 1 gig of RAM, NT 4.0 SP 6a, IIS 4.0. Cold Fusion 4.51. Thanks for any ideas! Eron - - Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/c f_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Export to Access
Miriam, Excel/Lotus 123 is easy. Here's a very simple solution that works great for creating CSV files and opening them up into Excel or Lotus (or whatever is handling comma seperated files on the client machine). The gist of this is that CFCONTENT will cause the browser to put up an "Open File or Save" dialog box. If they push OPEN, Excel will open up and display the info that CF outputs: CFSETTING enablecfoutputonly="Yes" CFQUERY name="search_results" Select * from something /CFQUERY CFCONTENT TYPE="text/x-excel-csv" CFHEADER NAME="content-disposition" VALUE="filename=contacts.csv" Report For Someone: CFLOOP QUERY="search_results" cfoutput"#first_name#","#last_name#","#COMPANY_name#","#state#","#country# ","#company_address1#","#company_city#","#state#","#company_postal_code#","# contact_phone_number#","#contact_email_address#" /cfoutput /CFLOOP There are also custom tags that you can get in Allaire's tag gallery that are more specifically tied to Excel, but excel would need to be installed on the server. HTH, Eron -Original Message- From: Miriam Hirschman [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 13, 2000 1:10 PM To: CF Forum Subject: Export to Access A client of mine wants to know if there is a way that I can export a CF page to access or excel?? I would appreciate any info Thanks, ---miriam -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
