Javascript Function
Hi, Could anyone inform me of any javascript function that takes the total of numbers entered into a textbox and displays them in another? eg form name=form1 Item a = 2 (number in text box) Item b = 3 Item c = 4 Total = 9 (this total is generated by adding the items in the textboxes above) /form Any help will much apreciated Jerry Staple ~~ 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: pay rates
Hi, We are a company based in Belfast which specialise in Coldfusion development and also Coldfusion hosting.We have developed similar applications to the one that you have explained,if you would like any advice or costs etc send me an email. Regards Jerry Staple Web Applications Developer BizNet Solutions 133 - 137 Lisburn Rd Belfast BT9 7AG Tel: +44 (0)28 9022 3224 Fax: +44 (0)28 9022 3223 www.biznet-solutions.com -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: 11 July 2001 16:39 To: CF-Talk Subject: pay rates Hi Everyone, I need some advice on the going pay rates for a person working on a Cold Fusion project. I'm going to have a meeting today with some people who want a website that will advertise themselves but will allow their clients to login and view the work in progress on the various projects they've been working on. So, for example, if I am one of these people's clients I can go online and view the look of the brochure they have designed or the copywrite material they have wrote and comment on it right there. Anyway, the application would have a SQL Server backend probably be about 20 pages. I am also going to do the graphic design. I am also going to research a cold fusion ISP for them. Which ones out there are the best in terms of stability and support? So I guess I can divide it into 3 parts: hourly rate for CF developer: hourly rate for Database Developer (or is this included in the CF developer area): hourly rate for an HTML programmer: Hourly rate for a designer: maybe I'm going about it wrong. I don't know I need some guidance so I don't get ripped off. Thank yo so much Sal ~~ 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
JavaScript
Hi, Could anyone inform me of any javascript function that takes the total of numbers entered into a textbox and displays them in another? eg form name=form1 Item a = 2 (number in text box) Item b = 3 Item c = 4 Total = 9 (this total is generated by adding the items in the textboxes above) /form Any help will much apreciated Jerry Staple Jerry Staple Web Applications Developer BizNet Solutions 133 - 137 Lisburn Rd Belfast BT9 7AG Tel: +44 (0)28 9022 3224 Fax: +44 (0)28 9022 3223 www.biznet-solutions.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: JavaScript
Jerry Something like document.forms[0].total.value = parseInt(document.forms[0].a.value) + parseInt(document.forms[0].b.value) + parseInt(document.forms[0].c.value); Nick -Original Message- From: Jerry Staple [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 9:33 AM To: CF-Talk Subject: JavaScript Hi, Could anyone inform me of any javascript function that takes the total of numbers entered into a textbox and displays them in another? eg form name=form1 Item a = 2 (number in text box) Item b = 3 Item c = 4 Total = 9 (this total is generated by adding the items in the textboxes above) /form Any help will much apreciated Jerry Staple Jerry Staple Web Applications Developer BizNet Solutions 133 - 137 Lisburn Rd Belfast BT9 7AG Tel: +44 (0)28 9022 3224 Fax: +44 (0)28 9022 3223 www.biznet-solutions.com ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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: Dead ?
Still getting 3 to 5 emails of many postings -- but my delete key still works... - Original Message - From: Michael Dinowitz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, July 12, 2001 5:44 PM Subject: Re: Dead ? If it is then we've got a lot of mediums here. :) Is the list dead again ? Uwe SD Solutions Fon: +49 8122 903791 Fax: +49 8122 903792 Mail: [EMAIL PROTECTED] Web: www.sdsolutions.de ~~ 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: loops learning difficulties
Thanks heaps - it certainly is a mental block with me. And thanks for the great, informative reply - I'm already looking forward to the next installment Many thanks Seamus At 12:45 pm 13/07/01 , you wrote: Seamus Some people take to the concepts of loops naturally... for others it is a mental block. Not to worry! The classic programming problem which illustrates the need for loops is the Native American Problem: The Dutch purchased Manhattan Island from the Native Americans for $18.00 in er, ah... lets say 1624. If the money were invested at 4%, compounded annually, what would it be worth today. To solve you could write out: Year: 1624 Value: $18.00 Year: 1625 Value: $18.00 * 1.04 Year: 1626 Value: $18.00 * 1.04 * 1.04 . . . so we would do the 375 steps to get to 2001 Now if we look closely, we notice a certain consistency in the operations performed in each step: the year is incremented by 1 the amount is incremented by 4 ( Amount * 1.04 ) Regardless of which step (year) the calculations are always the same... the 2 operations are repeated over and over. To write this out abstractly we could say: Start with an amount of $18,00 Start at a year of 1624 Repeat Add 1 to the year Multiply the amount by 1.04 until the year is equal to 2001 What controls the number of times we repeat, is the year (incremented) Now, we take this and rewrite this in CF cfset amount=18.00 cfloop index=theYear from=1624 to=2001 step=1 cfset amount = amount * 1.04 cfloop Now if you compare the two, you see that the cfloop tag combines the operations of: setting the starting and ending values for year setting the increment for year testing for the end value of year. So all we have to do is compute the amount and indicate the end of the loop. Now, if you change the problem slightly: The Dutch purchased Manhattan Island from the Native Americans for $18.00 in er, ah... lets say 1624. If the money were invested at 4%, compounded annually, when would the value exceed $200,000? we'll cover that in the next installment, HTH Dick At 11:17 AM +1000 7/13/01, Seamus Campbell wrote: Many thanks again. Slightly OT - I have learnt CF without any background in programming - I have a huge problem getting loops and lists to work - I can understand the general principles but just can't seem to be able to learn to implement specific code. For instance I can see what you are doing in the code below and I can adapt code that other people have done (often by trial and error rather than logic) BUT i have huge problems coding loops and lists on my own. Is this normal - or am I just slow??? Any ways to learn how to roll my own ??? Many thanks Seamus ~~ 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
Iif, short circuit evaluation and DE
Is there any way to use Iif with (for example) a date time variable retrieved from a database so that if it's defined, it extracts the Day portion of the date, but if the date is null, uses Day(Now()) instead? If(NOT Len(AccountExpires), DE(Day(Now())), DE(Day(AccountExpires))) When AccountExpires is null, Day(AccountExpires) throws this error Parameter 1 of function Day which is now must be a date/time value even though it's in the second part of the Iif. I would have thought the evaluation wouldn't have got that far... ? And as this is within a CFMODULE attribute, I want to use Iif if possible, as opposed to having CFIF CFELSE /CFIF and two calls to the custom tag. BTW, are there times when you don't need to use DE within and immediate if? I'm not 100% certain so always put it there. Thanks -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental +44 (0)1695 51775 ~~ 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: Javascript Function
Here's something that I recently did:
script language=Javascript
function AddMe()
{
var total;
total = 0;
num1 = parseInt(form1.number1.value);
if (isNaN(num1) == 0) {
total = total + num1;
}
num2 = parseInt(form1.number2.value);
if (isNaN(num2) == 0) {
total = total + num2;
}
num3 = parseInt(form1.number3.value);
if (isNaN(num3) == 0) {
total = total + num3;
}
form1.total.value = total;
}
/script
form name=form1 method=post
Number 1 input type=text name=number1 onblur=javascript:AddMe()br
Number 2 input type=text name=number2 onblur=javascript:AddMe()br
Number 3 input type=text name=number3 onblur=javascript:AddMe()br
Your total : input type=text name=total
/form
- Original Message -
From: Jerry Staple [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, July 13, 2001 4:10 AM
Subject: Javascript Function
Hi,
Could anyone inform me of any javascript function that takes the total
of numbers entered into a textbox and displays them in another? eg
form name=form1
Item a = 2 (number in text box)
Item b = 3
Item c = 4
Total = 9 (this total is generated by adding the items in the textboxes
above)
/form
Any help will much apreciated
Jerry Staple
~~
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: loops learning difficulties (was Re: looping insert) (was re: looping problem)
Seamus To review, our solution to the classic Native American problem was: cfset amount=18.00 cfloop index=theYear from=1624 to=2001 step=1 cfset amount = amount * 1.04 cfloop The heading lifting is being done in the cfloop tag: setting the starting and ending values for year setting the increment for year testing for the end value of year. We used this style of loop because we have a predetermined number of steps, 377 (2001 - 1624). Even if we change the problem to specify biannual interest, we still have a fixed number of steps... we just change the step value to 2. Then I redefined the problem to: The Dutch purchased Manhattan Island from the Native Americans for $18.00 in er, ah... lets say 1624. If the money were invested at 4%, compounded annually, when would the value exceed $200,000? Now, we can't determine in advance how many steps are necessary, because that depends on the calculation within the loop. if we write this out abstractly, we have: Start with an amount of $18,00 Start at a year of 1624 Repeat Multiply the amount by 1.04 Add 1 to the year until the Amount is Greater Than 2000 To translate this into CF we have: cfset amount=18.00 cfset year=1624 cfloop condition=#amount# LTE 20 cfset amount = amount * 1.04 cfset year = year + 1 cfloop In the above, the cfloop tag does a lot less work than our prior example... it only tests if the loop should continue (while the condition is still true). As before, the body of the loop computes a new amount... this is used in the condition that controlls the loop In addition, we increment the year within the body of the loop, because it is the answer we seek (and it is no longer being computed in the cfloop tag If we want to compute biannual interest, we merely change the year increment within the loop body: cfset year = year + 2 So, we have covered the two basic types of loops: a FOR loop (predetermined number of steps) A WHILE loop (while a condition is true - unknown number of steps) CF, in its benevolence, provides us with some specialized loops so we can easily iterate over complex structures: lists, queries and collections. These are, in fact, just a more-convenient format of a FOR loop. Next time. HTH Dick ~~ 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: Iif, short circuit evaluation and DE
My piece sent prior to this would probably work better if made as part of Your query statement to the database. Conrad -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 12:55 PM To: CF-Talk Subject: Iif, short circuit evaluation and DE Is there any way to use Iif with (for example) a date time variable retrieved from a database so that if it's defined, it extracts the Day portion of the date, but if the date is null, uses Day(Now()) instead? If(NOT Len(AccountExpires), DE(Day(Now())), DE(Day(AccountExpires))) When AccountExpires is null, Day(AccountExpires) throws this error Parameter 1 of function Day which is now must be a date/time value even though it's in the second part of the Iif. I would have thought the evaluation wouldn't have got that far... ? And as this is within a CFMODULE attribute, I want to use Iif if possible, as opposed to having CFIF CFELSE /CFIF and two calls to the custom tag. BTW, are there times when you don't need to use DE within and immediate if? I'm not 100% certain so always put it there. Thanks -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental +44 (0)1695 51775 ~~ 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: Iif, short circuit evaluation and DE
Rather use: IIf(IsNull([AccountExpires], Day(Now()), Day([AccountExpires])) In most cases, it is a safe bet to use the expression like this for most fields. The one that will not work is the Yes/No Type, where you have to evaluate it to Being either 0 (not selected) or otherwise (-1). Conrad -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 12:55 PM To: CF-Talk Subject: Iif, short circuit evaluation and DE Is there any way to use Iif with (for example) a date time variable retrieved from a database so that if it's defined, it extracts the Day portion of the date, but if the date is null, uses Day(Now()) instead? If(NOT Len(AccountExpires), DE(Day(Now())), DE(Day(AccountExpires))) When AccountExpires is null, Day(AccountExpires) throws this error Parameter 1 of function Day which is now must be a date/time value even though it's in the second part of the Iif. I would have thought the evaluation wouldn't have got that far... ? And as this is within a CFMODULE attribute, I want to use Iif if possible, as opposed to having CFIF CFELSE /CFIF and two calls to the custom tag. BTW, are there times when you don't need to use DE within and immediate if? I'm not 100% certain so always put it there. Thanks -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental +44 (0)1695 51775 ~~ 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: Which OS to use? Win98 or WinME?
I've found this very interesting. Many reviews i've heard about window's ME have been negative like this one. However, it has been a God-send on my home PC. Faster boots, fewer, as in almost none, reboots. With windows 98, I was rebooting every couple of days. It was also one of the cleanest and easiest upgrades I've been subjected too while in microsoft land. After about 6 months of use, I'm YET to find a single bug. I wonder what some of the subtle differences and nuances are in these systems that can cause such drastically different results with this OS??? Perhaps it's as simple as some people test the limits of an OS more so than othersI admit my home PC use is not nearly as intensive as work. Brian - Original Message - From: Russel Madere [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, July 12, 2001 3:38 PM Subject: RE: Which OS to use? Win98 or WinME? DON'T INSTALL Windows ME!! Sorry to scream, but we have it on a test box here and it is really buggy. Tell your friend to stick with Windows 98, especially if he wants to keep his techie friends. I have almost lost my religion troubleshooting Windows ME. Russel -Original Message- From: Pooh Bear [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 12, 2001 3:27 PM To: CF-Talk Subject: OT: Which OS to use? Win98 or WinME? hey guys, i have a friend who is doing small development stuff on his win 98 box. He wants to upgrade to the latest consumer version of windows (WinME), but wants to know if WinMe was more buggy than win98! thanx! ~~ 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
Refresh Banner Rotator
Hi folks, I'm doing a simple banner rotator using CF and Flash 4. What I would like it to do is change the banners dynamically without refreshing the entire page via meta refresh. I've seen a few custom tags that do that nicely, but my ISP doesn't allow custom tags. I could cfmodule it in but then I'd have it in a bazillion directories and I'd rather not do that. Any ideas? Is JavaScript the answer here? Also, I'd like to be able to pass the variables into the Flash, but the only tutorial I found on this uses Flash5 not 4 so I can't read it. Code follows for selecting the banners and tracking them. Code modified from TeraTech ColdCuts. !--- Determine number of banners --- cfquery name=CountBanners datasource=MyDatasource SELECT Sum(1) AS rnum FROM Banners /cfquery cfset R1 = RandRange(1,CountBanners.rnum) !--- Retrieve a banner and assocated link --- cfquery name=PickBanner datasource=MyDatasource SELECT RecID, BNRFile, BNRViews, BNRLink FROM Banners WHERE (((RecID)=#R1#)) /cfquery cfset NewBNRViews = PickBanner.BNRViews + 1 !--- Update the number of views --- cfquery name=UpdateView datasource=MyDatasource UPDATE Banners SET BNRViews = #NewBNRViews# WHERE (((RecID)=#R1#)) /cfquery OBJECT classid=clsid:D27CDB6E-AE6D-11cf-96B8-44455354 codebase=http://active.macromedia.com/flash2/cabs/swflash.cab#version=4,0,0,0; ID=OFAHBannerAds WIDTH=450 HEIGHT=75 cfoutput query=PickBanner PARAM NAME=movie VALUE=#BNRFile# PARAM NAME=quality VALUE=high PARAM NAME=bgcolor VALUE=##FF EMBED src=#BNRFile# quality=high bgcolor=##FF WIDTH=450 HEIGHT=75 TYPE=application/x-shockwave-flash PLUGINSPAGE=http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash; /EMBED /cfoutput /OBJECT _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFCONTENT
I just read a post on the alt.comp.lang.coldfusion that suggests that use of CFCONTENT is disastrous in a shared environment. Why not send an e-mail to the original poster asking them to justify their remarks? -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental +44 (0)1695 51775 ~~ 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
Place holder
I have a display page that shows select boxes/input boxes. Depending on the subject will depend on if they should fill the box. I have set it so they don't see a box if the field should not be filled in. Problem: On submit an update query is run. My query doesn't like blanks (loop list update query) and fills in the blanks with the field value of the next field. So this: A ___Becomes: A 12 B 12 B 19 C 19 C 3 D 3 D I fixed the problem by adding a select box with no options and puts a . in the database as a placeholder. But that is ugly and the user must tab to/from the field even if the field is useless to them. Any suggestions. I think the answer is easy, but it's one of those days that I left my brain at home with my gourmet coffee Thanks for all/any help j ~~ 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: Which OS to use? Win98 or WinME?
We got a Compac Presario system for our QA Engineer on which to test our product. Right out of the box, the OS had to be reinstalled. It has also consistantly been a problem OS. Even out Windows 95 test boxes have been less troublesome. I also installed it on my wife's computer after purchasing an upgrade. After 2 days she demanded I reload Windows 98. I guess you have a good system for ME. 1Apparently it does not like the systems I have deal with. Russel -Original Message- From: G [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 7:29 AM To: CF-Talk Subject: Re: Which OS to use? Win98 or WinME? I've found this very interesting. Many reviews i've heard about window's ME have been negative like this one. However, it has been a God-send on my home PC. Faster boots, fewer, as in almost none, reboots. With windows 98, I was rebooting every couple of days. It was also one of the cleanest and easiest upgrades I've been subjected too while in microsoft land. After about 6 months of use, I'm YET to find a single bug. I wonder what some of the subtle differences and nuances are in these systems that can cause such drastically different results with this OS??? Perhaps it's as simple as some people test the limits of an OS more so than othersI admit my home PC use is not nearly as intensive as work. Brian - Original Message - From: Russel Madere [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, July 12, 2001 3:38 PM Subject: RE: Which OS to use? Win98 or WinME? DON'T INSTALL Windows ME!! Sorry to scream, but we have it on a test box here and it is really buggy. Tell your friend to stick with Windows 98, especially if he wants to keep his techie friends. I have almost lost my religion troubleshooting Windows ME. Russel -Original Message- From: Pooh Bear [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 12, 2001 3:27 PM To: CF-Talk Subject: OT: Which OS to use? Win98 or WinME? hey guys, i have a friend who is doing small development stuff on his win 98 box. He wants to upgrade to the latest consumer version of windows (WinME), but wants to know if WinMe was more buggy than win98! thanx! ~~ 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: CFAnyWhere or CF on CD
I certainly could use this kind of Application. Toss a demo on a CD and give it to a sales man! At 06:45 PM 7/12/2001 -0700, you wrote: The company that made CFAnywhere and JRun was purchased a few years ago, by allaire. AFAIK they killed CFAnywhere. I, too, was intriqued with the possibilities of a single-user desktop version of CF on any platform. HTH Dick At 9:25 PM -0400 7/12/01, Duane Boudreau wrote: All, What ever happened to CFAnyWhere? I need that tool or something similar for a CD project. Duane ~~ 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
migration from CF4.5 to CF5
I am looking at CF5 to see if it makes sense to upgrade. I was wondering if anybody who already has upgraded have any problems with applications built with/for CF4.5. Any minor glitches that had to be fixed? Thanks, ~~ 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: CFAnyWhere or CF on CD
Isn't this what Neo is supposed to be? From my understanding it's going to allow for CF to be made compilable and distributable. I certainly could use this kind of Application. Toss a demo on a CD and give it to a sales man! ~~ 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: Place holder
On your update template, use CFPARAM for any field that may in some cases be missing... Or, on the original display page, you could use hidden fields for the boxes you don't want to show... Gene Kraybill On 13 Jul 2001, at 8:43, Janine Jakim wrote: I have a display page that shows select boxes/input boxes. Depending on the subject will depend on if they should fill the box. I have set it so they don't see a box if the field should not be filled in. Problem: On submit an update query is run. My query doesn't like blanks (loop list update query) and fills in the blanks with the field value of the next field. So this: A ___Becomes: A 12 B 12 B 19 C 19 C 3 D 3 D I fixed the problem by adding a select box with no options and puts a . in the database as a placeholder. But that is ugly and the user must tab to/from the field even if the field is useless to them. Any suggestions. I think the answer is easy, but it's one of those days that I left my brain at home with my gourmet coffee Thanks for all/any help j ~~ 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: Dead ?
Really don't want to complain, because I found out how painful it was when the list was down, but, just to share my experience: some messages come as they should - some come with 3-5 copies (easily deleted) - and somewhere around noon most days, messages stop coming at all - only to dump into my email as a group several hours later hm D -Original Message- From: Russel Madere [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 12, 2001 5:48 PM To: CF-Talk Subject: RE: Dead ? Or a bunch of ghosts ;) Sorry, I couldn't resist. -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 12, 2001 4:44 PM To: CF-Talk Subject: Re: Dead ? If it is then we've got a lot of mediums here. :) Is the list dead again ? Uwe SD Solutions Fon: +49 8122 903791 Fax: +49 8122 903792 Mail: [EMAIL PROTECTED] Web: www.sdsolutions.de ~~ 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: CFAnyWhere or CF on CD
What is Neo? It would be nice to have an Access DB hooked up and on the CD also. Maybe this is asking to much? At 09:29 AM 7/13/2001 -0400, you wrote: Isn't this what Neo is supposed to be? From my understanding it's going to allow for CF to be made compilable and distributable. I certainly could use this kind of Application. Toss a demo on a CD and give it to a sales man! ~~ 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: CFAnyWhere or CF on CD
Isn't this what Neo is supposed to be? From my understanding it's going to allow for CF to be made compilable and distributable. You'll still need to run your CF applications through a web server, and they'll have to connect to a database through ODBC or something similar, so Neo isn't going to allow you to put a demo on a CD that people can run without installing anything. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ 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: Which OS to use? Win98 or WinME?
Dell sent me a laptop with NT4 preinstalled, on a FAT32 formatted drive, making it blatantly obvious that manufacturers don't necessarily even boot a computer before they ship it, so I'm not sure if I'd point the finger at Compaq for the botched ME install on your Presario. I recently bought a new home computer, and copies of 98se and 2000 with the intention tossing the ME cd and create a dual boot system. After 2 attempts of installing and configuring 98, I ended up reinstalling ME. Apache and CF server work like a charm. Granted, I haven't benchmarked the setup, it's temporary, till a side project I'm working on is done. Then I'll spend a Saturday doing it right, 98 and/or 2000. my .02 ~bgl -Original Message- From: Russel Madere [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 9:10 AM To: CF-Talk Subject: RE: Which OS to use? Win98 or WinME? We got a Compac Presario system for our QA Engineer on which to test our product. Right out of the box, the OS had to be reinstalled. It has also consistantly been a problem OS. Even out Windows 95 test boxes have been less troublesome. I also installed it on my wife's computer after purchasing an upgrade. After 2 days she demanded I reload Windows 98. I guess you have a good system for ME. 1Apparently it does not like the systems I have deal with. Russel -Original Message- From: G [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 7:29 AM To: CF-Talk Subject: Re: Which OS to use? Win98 or WinME? I've found this very interesting. Many reviews i've heard about window's ME have been negative like this one. However, it has been a God-send on my home PC. Faster boots, fewer, as in almost none, reboots. With windows 98, I was rebooting every couple of days. It was also one of the cleanest and easiest upgrades I've been subjected too while in microsoft land. After about 6 months of use, I'm YET to find a single bug. I wonder what some of the subtle differences and nuances are in these systems that can cause such drastically different results with this OS??? Perhaps it's as simple as some people test the limits of an OS more so than othersI admit my home PC use is not nearly as intensive as work. Brian - Original Message - From: Russel Madere [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, July 12, 2001 3:38 PM Subject: RE: Which OS to use? Win98 or WinME? DON'T INSTALL Windows ME!! Sorry to scream, but we have it on a test box here and it is really buggy. Tell your friend to stick with Windows 98, especially if he wants to keep his techie friends. I have almost lost my religion troubleshooting Windows ME. Russel -Original Message- From: Pooh Bear [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 12, 2001 3:27 PM To: CF-Talk Subject: OT: Which OS to use? Win98 or WinME? hey guys, i have a friend who is doing small development stuff on his win 98 box. He wants to upgrade to the latest consumer version of windows (WinME), but wants to know if WinMe was more buggy than win98! thanx! ~~ 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
Neo (was Re: CFAnyWhere or CF on CD)
But they could run a demo locally if they had, say, PWS (or some other web server) installed and then register the demo's database with the ODBC manager? Out of curiosity, am I correct in thinking that main reason for the upcoming Neo release is to move CF to a J2EE platfrom? You'll still need to run your CF applications through a web server, and they'll have to connect to a database through ODBC or something similar, so Neo isn't going to allow you to put a demo on a CD that people can run without installing anything. ~~ 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
DevCon
My company will be exhibiting iMS at the upcoming Macromedia DevCon 2001 October 22-24. Since we thought it was a good idea to set up a community of both attendees and sponsors we created a DevCon Community site. This site allows you to register and get the word out that you will be attending the conference. You can make plans to meet other people that you know from ColdFusion lists and also plan to attend third-party events that are not listed in the official Macromedia information. There is also a page of links to conference information including links to the Swan and Dolphin hotel sites. If you want to, you can also commune with other attendees on the DevCon 2001 email list. the email list is open to any DevCon related mail. Plan ahead and make the most of your visit to DevCon 2001! You can join the DevCon community from: http://www.coolfusion.com/devcon I look forward to meeting many of you personally in October! Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server ~~ 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: Place holder
Janine, I use this to loop over the form collection. I just had to deal with this situation. you can take advantage of the fact that radio buttons and check boxes do not exist in the form collection when the form is submitted. This script will build the SQL statement (great for debugging before activating the insert or update statment...) One caveat though is to make sure that your fields allow nulls since you cannot know what is going to be passed. I allow nulls and set the default value to null. CFSET sqlstmt = INSERT INTO MYTABLEHERE ( CFLOOP collection=#form# item=variable cfif #variable# DOES NOT CONTAIN FIELDNAMES AND #variable# DOES NOT CONTAIN submit CFIF i LT ((structcount(form)) - 1) CFSET sqlstmt = sqlstmtvariable , CFELSE CFSET sqlstmt = sqlstmtvariable /CFIF /cfif cfset i = i + 1 /CFLOOP CFSET sqlstmt = sqlstmt ) Chr(13) Chr(10) VALUES ( CFSET i = 1 CFLOOP collection=#form# item=variable cfif #variable# DOES NOT CONTAIN FIELDNAMES AND #variable# DOES NOT CONTAIN submit CFIF i LT ((structcount(form)) - 1) CFSET sqlstmt = sqlstmtstructfind(form, variable) , CFELSE CFSET sqlstmt = sqlstmtstructfind(form, variable) /CFIF /cfif cfset i = i + 1 /CFLOOP CFSET sqlstmt = sqlstmt ) CFOUTPUT#sqlstmt#/CFOUTPUT !--- Remove these remarks to activate the insert or update query --- CFQUERY name=qry_updatestudent datasource=lsps #sqlstmt# /CFQUERY --- HTH, Jeff Garza Webmaster, Spectrum Astro, Inc. [EMAIL PROTECTED] -Original Message- From: Janine Jakim To: CF-Talk Sent: 7/13/01 5:43 AM Subject: Place holder I have a display page that shows select boxes/input boxes. Depending on the subject will depend on if they should fill the box. I have set it so they don't see a box if the field should not be filled in. Problem: On submit an update query is run. My query doesn't like blanks (loop list update query) and fills in the blanks with the field value of the next field. So this: A ___Becomes: A 12 B 12 B 19 C 19 C 3 D 3 D I fixed the problem by adding a select box with no options and puts a . in the database as a placeholder. But that is ugly and the user must tab to/from the field even if the field is useless to them. Any suggestions. I think the answer is easy, but it's one of those days that I left my brain at home with my gourmet coffee Thanks for all/any help j ~~ 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
Rochester NY User Group
This is a notice to all who wish to attend that the next meeting of the Rochester, NY Cold Fusion User Group will be on Thursday 7/19. Topics that will be covered will be XML and CF. For more info and directions please go to http://www.roch-cfug.org or contact me directly. Thanks, Rich ~~ 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: migration from CF4.5 to CF5
the only issue we had was the syntax of CFOBJECT, but i think that was it. -Original Message- From: river [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 6:32 AM To: CF-Talk Subject: migration from CF4.5 to CF5 I am looking at CF5 to see if it makes sense to upgrade. I was wondering if anybody who already has upgraded have any problems with applications built with/for CF4.5. Any minor glitches that had to be fixed? Thanks, ~~ 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: CFAnyWhere or CF on CD
neo is supposed to be the next major version of CF (v6.0). it will allegedly have a complete java codebase. the biggest promise of neo is it will let you develop in CFML but transpose that code into Java. that's all i've heard, maybe others can correct/confirm/elaborate. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 6:43 AM To: CF-Talk Subject: RE: CFAnyWhere or CF on CD What is Neo? It would be nice to have an Access DB hooked up and on the CD also. Maybe this is asking to much? At 09:29 AM 7/13/2001 -0400, you wrote: Isn't this what Neo is supposed to be? From my understanding it's going to allow for CF to be made compilable and distributable. I certainly could use this kind of Application. Toss a demo on a CD and give it to a sales man! ~~ 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: Dead ?
Same duplicate problem here. Multiple copies of exactly the same message, headers and all. So far the largest number of dupes was 5 for one of Mike Dinowitz's posts. Still much better than not getting messages g. Stephen some messages come as they should - some come with 3-5 copies (easily deleted) - and somewhere around noon most days, messages stop coming at all - only to dump into my email as a group several hours later hm ~~ 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: Which OS to use? Win98 or WinME?
I use Windows 2k for everything now, staying away from ME and XP. I've found this very interesting. Many reviews i've heard about window's ME have been negative like this one. However, it has been a God-send on my home PC. Faster boots, fewer, as in almost none, reboots. With windows 98, I was rebooting every couple of days. It was also one of the cleanest and easiest upgrades I've been subjected too while in microsoft land. After about 6 months of use, I'm YET to find a single bug. I wonder what some of the subtle differences and nuances are in these systems that can cause such drastically different results with this OS??? Perhaps it's as simple as some people test the limits of an OS more so than othersI admit my home PC use is not nearly as intensive as work. Brian - Original Message - From: Russel Madere [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, July 12, 2001 3:38 PM Subject: RE: Which OS to use? Win98 or WinME? DON'T INSTALL Windows ME!! Sorry to scream, but we have it on a test box here and it is really buggy. Tell your friend to stick with Windows 98, especially if he wants to keep his techie friends. I have almost lost my religion troubleshooting Windows ME. Russel -Original Message- From: Pooh Bear [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 12, 2001 3:27 PM To: CF-Talk Subject: OT: Which OS to use? Win98 or WinME? hey guys, i have a friend who is doing small development stuff on his win 98 box. He wants to upgrade to the latest consumer version of windows (WinME), but wants to know if WinMe was more buggy than win98! thanx! ~~ 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: Dead ?
I have been watching all of the issues coming and going and I must say here and now that since Michael has gotten the new box up, I have had virtually problem free results from this list. My posts post rather quickly now, and very rarely do I receive duplicate posts. The dups on my end seem to be when people for some reason feel they have to include three or four addresses in the to field of their post. I do not know if Michael has caught this himself, but recently their have been several who seem to have the need to send every one of their posts to js-jive, cf-talk, cf-server, all in one post and then I get multiples. just my 2 cents worth KEEP UP THE GREAT WORK MICHAEL... Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] -Original Message- From: Stephen Hait [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 10:26 AM To: CF-Talk Subject: RE: Dead ? Same duplicate problem here. Multiple copies of exactly the same message, headers and all. So far the largest number of dupes was 5 for one of Mike Dinowitz's posts. Still much better than not getting messages g. Stephen some messages come as they should - some come with 3-5 copies (easily deleted) - and somewhere around noon most days, messages stop coming at all - only to dump into my email as a group several hours later hm ~~ 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: Which OS to use? Win98 or WinME?
Hi, NT4.0 cannot be installed on a FAT32 partition as NT cannot natively undertstand FAT32 partitions. NT can only run on a FAT16 or an NTFS partition. WIN2k can however run on FAT32 and NTFS. If you are running NT4 or Win2k then NTFS would make sense as it has far superior inherent security features. I personally would use win2k as my development platform - windoze 9*/ME just don't cut the mustard! BSODs are very rare sights when one uses Win2k. ME/9* are not designed to be robust development OSs - they are for playing games! Stephen -Original Message- From: Ledwith, Brian [mailto:[EMAIL PROTECTED]] Sent: 13 July 2001 15:10 To: CF-Talk Subject: RE: Which OS to use? Win98 or WinME? Dell sent me a laptop with NT4 preinstalled, on a FAT32 formatted drive, making it blatantly obvious that manufacturers don't necessarily even boot a computer before they ship it, so I'm not sure if I'd point the finger at Compaq for the botched ME install on your Presario. I recently bought a new home computer, and copies of 98se and 2000 with the intention tossing the ME cd and create a dual boot system. After 2 attempts of installing and configuring 98, I ended up reinstalling ME. Apache and CF server work like a charm. Granted, I haven't benchmarked the setup, it's temporary, till a side project I'm working on is done. Then I'll spend a Saturday doing it right, 98 and/or 2000. my .02 ~bgl -Original Message- From: Russel Madere [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 9:10 AM To: CF-Talk Subject: RE: Which OS to use? Win98 or WinME? We got a Compac Presario system for our QA Engineer on which to test our product. Right out of the box, the OS had to be reinstalled. It has also consistantly been a problem OS. Even out Windows 95 test boxes have been less troublesome. I also installed it on my wife's computer after purchasing an upgrade. After 2 days she demanded I reload Windows 98. I guess you have a good system for ME. 1Apparently it does not like the systems I have deal with. Russel -Original Message- From: G [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 7:29 AM To: CF-Talk Subject: Re: Which OS to use? Win98 or WinME? I've found this very interesting. Many reviews i've heard about window's ME have been negative like this one. However, it has been a God-send on my home PC. Faster boots, fewer, as in almost none, reboots. With windows 98, I was rebooting every couple of days. It was also one of the cleanest and easiest upgrades I've been subjected too while in microsoft land. After about 6 months of use, I'm YET to find a single bug. I wonder what some of the subtle differences and nuances are in these systems that can cause such drastically different results with this OS??? Perhaps it's as simple as some people test the limits of an OS more so than othersI admit my home PC use is not nearly as intensive as work. Brian - Original Message - From: Russel Madere [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, July 12, 2001 3:38 PM Subject: RE: Which OS to use? Win98 or WinME? DON'T INSTALL Windows ME!! Sorry to scream, but we have it on a test box here and it is really buggy. Tell your friend to stick with Windows 98, especially if he wants to keep his techie friends. I have almost lost my religion troubleshooting Windows ME. Russel -Original Message- From: Pooh Bear [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 12, 2001 3:27 PM To: CF-Talk Subject: OT: Which OS to use? Win98 or WinME? hey guys, i have a friend who is doing small development stuff on his win 98 box. He wants to upgrade to the latest consumer version of windows (WinME), but wants to know if WinMe was more buggy than win98! thanx! ~~ 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: CFAnyWhere or CF on CD
Neo is the code name for CF6, which will have a java base, hence the cross platform -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: 13 July 2001 14:43 To: CF-Talk Subject: RE: CFAnyWhere or CF on CD What is Neo? It would be nice to have an Access DB hooked up and on the CD also. Maybe this is asking to much? At 09:29 AM 7/13/2001 -0400, you wrote: Isn't this what Neo is supposed to be? From my understanding it's going to allow for CF to be made compilable and distributable. I certainly could use this kind of Application. Toss a demo on a CD and give it to a sales man! ~~ 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: Dead ?
On my account, the biggest number of duplicates I got was from a messgae I posted. I'm beginning to think this is a problem with my ISP, BellSouth. Plus I enjoy busting the chops of thier NOC guys anyway. -Original Message- From: Stephen Hait [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 10:26 AM To: CF-Talk Subject: RE: Dead ? Same duplicate problem here. Multiple copies of exactly the same message, headers and all. So far the largest number of dupes was 5 for one of Mike Dinowitz's posts. Still much better than not getting messages g. Stephen some messages come as they should - some come with 3-5 copies (easily deleted) - and somewhere around noon most days, messages stop coming at all - only to dump into my email as a group several hours later hm ~~ 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: Which OS to use? Win98 or WinME?
-Original Message- From: Ledwith, Brian [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 9:10 AM To: CF-Talk Subject: RE: Which OS to use? Win98 or WinME? Dell sent me a laptop with NT4 preinstalled, on a FAT32 formatted drive, making it blatantly obvious that manufacturers don't necessarily even boot a computer before they ship it, so I'm not sure if I'd point the finger at Compaq for the botched ME install on your Presario. I'm not blaming Compac, I'm blaming Microsoft. Even after our technician reinstalled Windows ME, it still was one of the worst OSs we have run under any sort of load. On a comparable machine, the Windows 95 and 98 installs were much more stable under similar loads. I recently bought a new home computer, and copies of 98se and 2000 with the intention tossing the ME cd and create a dual boot system. After 2 attempts of installing and configuring 98, I ended up reinstalling ME. Apache and CF server work like a charm. Granted, I haven't benchmarked the setup, it's temporary, till a side project I'm working on is done. Then I'll spend a Saturday doing it right, 98 and/or 2000. Since the ME machine is both a test and production machine, we are seriously considering changing the OS. my .02 ~bgl -Original Message- From: Russel Madere [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 9:10 AM To: CF-Talk Subject: RE: Which OS to use? Win98 or WinME? We got a Compac Presario system for our QA Engineer on which to test our product. Right out of the box, the OS had to be reinstalled. It has also consistantly been a problem OS. Even out Windows 95 test boxes have been less troublesome. I also installed it on my wife's computer after purchasing an upgrade. After 2 days she demanded I reload Windows 98. I guess you have a good system for ME. 1Apparently it does not like the systems I have deal with. Russel -Original Message- From: G [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 7:29 AM To: CF-Talk Subject: Re: Which OS to use? Win98 or WinME? I've found this very interesting. Many reviews i've heard about window's ME have been negative like this one. However, it has been a God-send on my home PC. Faster boots, fewer, as in almost none, reboots. With windows 98, I was rebooting every couple of days. It was also one of the cleanest and easiest upgrades I've been subjected too while in microsoft land. After about 6 months of use, I'm YET to find a single bug. I wonder what some of the subtle differences and nuances are in these systems that can cause such drastically different results with this OS??? Perhaps it's as simple as some people test the limits of an OS more so than othersI admit my home PC use is not nearly as intensive as work. Brian - Original Message - From: Russel Madere [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, July 12, 2001 3:38 PM Subject: RE: Which OS to use? Win98 or WinME? DON'T INSTALL Windows ME!! Sorry to scream, but we have it on a test box here and it is really buggy. Tell your friend to stick with Windows 98, especially if he wants to keep his techie friends. I have almost lost my religion troubleshooting Windows ME. Russel -Original Message- From: Pooh Bear [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 12, 2001 3:27 PM To: CF-Talk Subject: OT: Which OS to use? Win98 or WinME? hey guys, i have a friend who is doing small development stuff on his win 98 box. He wants to upgrade to the latest consumer version of windows (WinME), but wants to know if WinMe was more buggy than win98! thanx! ~~ 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: Neo (was Re: CFAnyWhere or CF on CD)
But they could run a demo locally if they had, say, PWS (or some other web server) installed and then register the demo's database with the ODBC manager? You'd need to have a web server and a Java application server locally installed already. Then, you'd have to configure the web and application servers to point to the directory on the CD, and you'd have to configure the datasource. You can do that now with CF. Out of curiosity, am I correct in thinking that main reason for the upcoming Neo release is to move CF to a J2EE platfrom? Yes, I suppose so. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ 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
Sybase to MS SQL server and system tables
Currently I am migrating a web app from a Sybase database to a MS SQL server database. I have a admin section that allows administrators to print reports on table structures, stored procedures, triggers, functions, indexes and foreign keys. My problem is that I can't find any information on where in the system tables Microsoft stores their function, trigger, and procedure definitions. How are they stored within SQL Server? What system tables and fields is this information located in: the table the trigger resides in, the name of the trigger, and its definition (source code)? Thanks, Nicholas W. Watson Assistant Web Developer Concurrent Technologies Corporation Email: [EMAIL PROTECTED] Phone:(814) 269 - 2653 ~~ 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: CFAnyWhere or CF on CD
There's also tagservlet(.com) which I've just discovered (on exploring new options) is now available as a free developer download. There was a big thread on this a few months ago when it was mostly marketing speak. Has anyone tried it? I intend to try and get around to testing it sometime, we have an embedded application we're thinking of so it doesn't make sense to deploy a full-blown CFAS on each box. -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 10:38 AM To: CF-Talk Subject: RE: CFAnyWhere or CF on CD Neo is the code name for CF6, which will have a java base, hence the cross platform -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: 13 July 2001 14:43 To: CF-Talk Subject: RE: CFAnyWhere or CF on CD What is Neo? It would be nice to have an Access DB hooked up and on the CD also. Maybe this is asking to much? At 09:29 AM 7/13/2001 -0400, you wrote: Isn't this what Neo is supposed to be? From my understanding it's going to allow for CF to be made compilable and distributable. I certainly could use this kind of Application. Toss a demo on a CD and give it to a sales man! ~~ 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: Which OS to use? Win98 or WinME?
Thats exactly my point, that Dell installed an OS on a improperly formatted harddrive. -Original Message- From: Stephen Galligan [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 10:27 AM To: CF-Talk Subject: RE: Which OS to use? Win98 or WinME? Hi, NT4.0 cannot be installed on a FAT32 partition as NT cannot natively undertstand FAT32 partitions. NT can only run on a FAT16 or an NTFS partition. WIN2k can however run on FAT32 and NTFS. If you are running NT4 or Win2k then NTFS would make sense as it has far superior inherent security features. I personally would use win2k as my development platform - windoze 9*/ME just don't cut the mustard! BSODs are very rare sights when one uses Win2k. ME/9* are not designed to be robust development OSs - they are for playing games! Stephen -Original Message- From: Ledwith, Brian [mailto:[EMAIL PROTECTED]] Sent: 13 July 2001 15:10 To: CF-Talk Subject: RE: Which OS to use? Win98 or WinME? Dell sent me a laptop with NT4 preinstalled, on a FAT32 formatted drive, making it blatantly obvious that manufacturers don't necessarily even boot a computer before they ship it, so I'm not sure if I'd point the finger at Compaq for the botched ME install on your Presario. I recently bought a new home computer, and copies of 98se and 2000 with the intention tossing the ME cd and create a dual boot system. After 2 attempts of installing and configuring 98, I ended up reinstalling ME. Apache and CF server work like a charm. Granted, I haven't benchmarked the setup, it's temporary, till a side project I'm working on is done. Then I'll spend a Saturday doing it right, 98 and/or 2000. my .02 ~bgl -Original Message- From: Russel Madere [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 9:10 AM To: CF-Talk Subject: RE: Which OS to use? Win98 or WinME? We got a Compac Presario system for our QA Engineer on which to test our product. Right out of the box, the OS had to be reinstalled. It has also consistantly been a problem OS. Even out Windows 95 test boxes have been less troublesome. I also installed it on my wife's computer after purchasing an upgrade. After 2 days she demanded I reload Windows 98. I guess you have a good system for ME. 1Apparently it does not like the systems I have deal with. Russel -Original Message- From: G [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 7:29 AM To: CF-Talk Subject: Re: Which OS to use? Win98 or WinME? I've found this very interesting. Many reviews i've heard about window's ME have been negative like this one. However, it has been a God-send on my home PC. Faster boots, fewer, as in almost none, reboots. With windows 98, I was rebooting every couple of days. It was also one of the cleanest and easiest upgrades I've been subjected too while in microsoft land. After about 6 months of use, I'm YET to find a single bug. I wonder what some of the subtle differences and nuances are in these systems that can cause such drastically different results with this OS??? Perhaps it's as simple as some people test the limits of an OS more so than othersI admit my home PC use is not nearly as intensive as work. Brian - Original Message - From: Russel Madere [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, July 12, 2001 3:38 PM Subject: RE: Which OS to use? Win98 or WinME? DON'T INSTALL Windows ME!! Sorry to scream, but we have it on a test box here and it is really buggy. Tell your friend to stick with Windows 98, especially if he wants to keep his techie friends. I have almost lost my religion troubleshooting Windows ME. Russel -Original Message- From: Pooh Bear [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 12, 2001 3:27 PM To: CF-Talk Subject: OT: Which OS to use? Win98 or WinME? hey guys, i have a friend who is doing small development stuff on his win 98 box. He wants to upgrade to the latest consumer version of windows (WinME), but wants to know if WinMe was more buggy than win98! thanx! ~~ 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: Which OS to use? Win98 or WinME? (correction)
Sorry, Russel, I wrote it backwards... I meant to say ...I'm not sure if I'd point the finger at _Microsoft_ for the botched ME install... But hell, I certainly agree not to run ME on a production machine. I wouldnt even want to run it on our staging server. Come to think of it, I wouldnt want it on any development machine or server in my office. I feel it's a home product, and thats where it belongs. -Original Message- From: Russel Madere [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 10:38 AM To: CF-Talk Subject: RE: Which OS to use? Win98 or WinME? -Original Message- From: Ledwith, Brian [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 9:10 AM To: CF-Talk Subject: RE: Which OS to use? Win98 or WinME? Dell sent me a laptop with NT4 preinstalled, on a FAT32 formatted drive, making it blatantly obvious that manufacturers don't necessarily even boot a computer before they ship it, so I'm not sure if I'd point the finger at Compaq for the botched ME install on your Presario. I'm not blaming Compac, I'm blaming Microsoft. Even after our technician reinstalled Windows ME, it still was one of the worst OSs we have run under any sort of load. On a comparable machine, the Windows 95 and 98 installs were much more stable under similar loads. I recently bought a new home computer, and copies of 98se and 2000 with the intention tossing the ME cd and create a dual boot system. After 2 attempts of installing and configuring 98, I ended up reinstalling ME. Apache and CF server work like a charm. Granted, I haven't benchmarked the setup, it's temporary, till a side project I'm working on is done. Then I'll spend a Saturday doing it right, 98 and/or 2000. Since the ME machine is both a test and production machine, we are seriously considering changing the OS. my .02 ~bgl -Original Message- From: Russel Madere [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 9:10 AM To: CF-Talk Subject: RE: Which OS to use? Win98 or WinME? We got a Compac Presario system for our QA Engineer on which to test our product. Right out of the box, the OS had to be reinstalled. It has also consistantly been a problem OS. Even out Windows 95 test boxes have been less troublesome. I also installed it on my wife's computer after purchasing an upgrade. After 2 days she demanded I reload Windows 98. I guess you have a good system for ME. 1Apparently it does not like the systems I have deal with. Russel -Original Message- From: G [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 7:29 AM To: CF-Talk Subject: Re: Which OS to use? Win98 or WinME? I've found this very interesting. Many reviews i've heard about window's ME have been negative like this one. However, it has been a God-send on my home PC. Faster boots, fewer, as in almost none, reboots. With windows 98, I was rebooting every couple of days. It was also one of the cleanest and easiest upgrades I've been subjected too while in microsoft land. After about 6 months of use, I'm YET to find a single bug. I wonder what some of the subtle differences and nuances are in these systems that can cause such drastically different results with this OS??? Perhaps it's as simple as some people test the limits of an OS more so than othersI admit my home PC use is not nearly as intensive as work. Brian - Original Message - From: Russel Madere [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, July 12, 2001 3:38 PM Subject: RE: Which OS to use? Win98 or WinME? DON'T INSTALL Windows ME!! Sorry to scream, but we have it on a test box here and it is really buggy. Tell your friend to stick with Windows 98, especially if he wants to keep his techie friends. I have almost lost my religion troubleshooting Windows ME. Russel -Original Message- From: Pooh Bear [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 12, 2001 3:27 PM To: CF-Talk Subject: OT: Which OS to use? Win98 or WinME? hey guys, i have a friend who is doing small development stuff on his win 98 box. He wants to upgrade to the latest consumer version of windows (WinME), but wants to know if WinMe was more buggy than win98! thanx! ~~ 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
FREE HTML Editor
Hi, We have a client who wishes to edit content in an updater which is then published on web. The client needs to be able to highlight text and make it bold, or make it a HEADING etc. This is an ASP site (boo hiss) but does anyone know of any free software that can be easily customisable to my needs. Regards, Nick Betts. ~~ 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:Sybase to MS SQL server and system tables
Nicholas, you need to look at the following tables. sysdatabases - has all the databases defined in your system syscolumns - has all the columns defined in every table and view in your system syscomments- this has all info on each rule, constraint, default, trigger and stored procedure on your system including source sysdepends - this has all the relationships between all the objects in the system. sysobjects - this has all the objects defined in the system. sysindexes - it's name says it all sysforeignkeys - same I may have overlooked a few but these are the main tables you need to look at. Regards, Jim Currently I am migrating a web app from a Sybase database to a MS SQL server database. I have a admin section that allows administrators to print reports on table structures, stored procedures, triggers, functions, indexes and foreign keys. My problem is that I can't find any information on where in the system tables Microsoft stores their function, trigger, and procedure definitions. How are they stored within SQL Server? What system tables and fields is this information located in: the table the trigger resides in, the name of the trigger, and its definition (source code)? Thanks, Nicholas W. Watson Assistant Web Developer Concurrent Technologies Corporation Email: [EMAIL PROTECTED] Phone:(814) 269 - 2653 B L A Z E i n t e r . N E T 103 Pleasant Ave #2| Jim Finucane - ST Upper Saddle River, NJ 07458| jim(at)blaze(dot)net 201-825-1313 Fax-825-4949| http://www.blaze.net ~~ 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
IIS Degradation with CF
We have two servers which are running IIS and CF 4.5.2. The servers were working great, but after about a month, IIS performance degraded badly. Any ASP pages on these servers especially suffer. The CF pages perform fine, but we are seeing an abnormal delay in returning the page. Rebooting the server does not resolve the problem, so it is not a memory leak issue. CPU Utilization and such remain at normal levels during this situation. Performance monitor was used, but did not find anything alarming. The boxes in question serve both ASP and CF pages. Has anyone else seen this? Is there a solution? Thanks for any suggestions. Shawn Grover ~~ 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: FREE HTML Editor
There are a couple out there with free versions. Check the Developer's Exchange at Allaire. I think EZ Edit_lite is free. At least I hope so ^_^ http://www.carigamer.com/default.cfm?page=news/submitnews.cfm -Gel -Original Message- From: Nick Betts [mailto:[EMAIL PROTECTED]] Hi, We have a client who wishes to edit content in an updater which is then published on web. The client needs to be able to highlight text and make it bold, or make it a HEADING etc. This is an ASP site (boo hiss) but does anyone know of any free software that can be easily customisable to my needs. ~~ 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: Refresh Banner Rotator
Your IP does not allow Custom Tags? Why not just put the tag in the same folder as calling template? It does not HAVE to go in Custom Tags folder on server (although it is preferable). -Original Message- From: Guy McDowell [mailto:[EMAIL PROTECTED]] Sent: 13 July 2001 13:35 To: CF-Talk Subject: Refresh Banner Rotator Hi folks, I'm doing a simple banner rotator using CF and Flash 4. What I would like it to do is change the banners dynamically without refreshing the entire page via meta refresh. I've seen a few custom tags that do that nicely, but my ISP doesn't allow custom tags. I could cfmodule it in but then I'd have it in a bazillion directories and I'd rather not do that. Any ideas? Is JavaScript the answer here? Also, I'd like to be able to pass the variables into the Flash, but the only tutorial I found on this uses Flash5 not 4 so I can't read it. Code follows for selecting the banners and tracking them. Code modified from TeraTech ColdCuts. !--- Determine number of banners --- cfquery name=CountBanners datasource=MyDatasource SELECT Sum(1) AS rnum FROM Banners /cfquery cfset R1 = RandRange(1,CountBanners.rnum) !--- Retrieve a banner and assocated link --- cfquery name=PickBanner datasource=MyDatasource SELECT RecID, BNRFile, BNRViews, BNRLink FROM Banners WHERE (((RecID)=#R1#)) /cfquery cfset NewBNRViews = PickBanner.BNRViews + 1 !--- Update the number of views --- cfquery name=UpdateView datasource=MyDatasource UPDATE Banners SET BNRViews = #NewBNRViews# WHERE (((RecID)=#R1#)) /cfquery OBJECT classid=clsid:D27CDB6E-AE6D-11cf-96B8-44455354 codebase=http://active.macromedia.com/flash2/cabs/swflash.cab#version=4 ,0,0,0 ID=OFAHBannerAds WIDTH=450 HEIGHT=75 cfoutput query=PickBanner PARAM NAME=movie VALUE=#BNRFile# PARAM NAME=quality VALUE=high PARAM NAME=bgcolor VALUE=##FF EMBED src=#BNRFile# quality=high bgcolor=##FF WIDTH=450 HEIGHT=75 TYPE=application/x-shockwave-flash PLUGINSPAGE=http://www.macromedia.com/shockwave/download/index.cgi?P1_P rod_Version=ShockwaveFlash /EMBED /cfoutput /OBJECT ~~ 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
Extracting Text from PDF Documents with CF
Hi, I am wondering if anyone has a method of extracting the raw (unformatted) text from a PDF file using CF? I have a project were we need to index PDF files AND associated information in a database. We are currently using Verity for searching the database with great success but now we need to index the PDF files that are associated with the data records in the database. When a user uploads a new PDF I would like to extract the text from it and add it to the database with the other information. Then I can use Verity to search all the data fields AND the PDF text data field. A CFX or a COM object would be nice so that I can call it from CF. I would be very appreciative if anyone can steer me to a tag or object that can accomplish this task. Best Regards, Dennis Powers UXB Internet (203) 879-2844 http://www.uxbinfo.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: FREE HTML Editor
I like ezEdit personally. Has a cold fusion custom tag... -Original Message- From: Nick Betts [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 7:23 AM To: CF-Talk Subject: FREE HTML Editor Hi, We have a client who wishes to edit content in an updater which is then published on web. The client needs to be able to highlight text and make it bold, or make it a HEADING etc. This is an ASP site (boo hiss) but does anyone know of any free software that can be easily customisable to my needs. Regards, Nick Betts. ~~ 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: FREE HTML Editor
ASP HTML Editor? Try looking on the Macromedia Exchange for Ultradev there is one by Public Domain. ~~ 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
Inserting ' and into SQL
I have a query blowing up when I try to insert a ' or into a text field. What is the trick for handling this? A replace list? or this there something better? Justin Hansen - [EMAIL PROTECTED] Web Application Developer Interactive Business Solutions, Inc 816-221-5200 ext. 1305 ~~ 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: FREE HTML Editor
Site Objects so_editor (2.0b2) is available in an ASP version as well as CF. www.siteobjects.com will William H. Bowen Webmaster ALSTOM Energy Management and Markets Business [EMAIL PROTECTED] http://www.esca.com/ 425.739.3629 Voice 425.739.3690 FAX CONFIDENTIALITY: This e-mail and any attachments are confidential and may be privileged. If you are not a named recipient, please notify the sender immediately and do not disclose the contents to another person, use it for any purpose or store or copy the information in any medium. - Original Message - From: Nick Betts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 13, 2001 7:22 AM Subject: FREE HTML Editor Hi, We have a client who wishes to edit content in an updater which is then published on web. The client needs to be able to highlight text and make it bold, or make it a HEADING etc. This is an ASP site (boo hiss) but does anyone know of any free software that can be easily customisable to my needs. Regards, Nick Betts. ~~ 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
Out of Space?
I have a client who is getting an Disk Space error when trying to add or update the database. They have a couple GIG of empty space on this disk. I'm off site right now and can't do any troubleshooting on the machine. Any suggestions? What's going on? Thanks! Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 [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
RE: Out of Space?
Erika, Have seen problems where the db is on a D: drive, but temp directory is on C: and the C: drive is almost full. If something needs space in a temp file and can't get it, the whole operation can fail. HTH. Ben -Original Message- From: Erika Foster [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 5:16 AM To: CF-Talk Subject: Out of Space? I have a client who is getting an Disk Space error when trying to add or update the database. They have a couple GIG of empty space on this disk. I'm off site right now and can't do any troubleshooting on the machine. Any suggestions? What's going on? Thanks! Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 [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
RE: Out of Space?
What kind of database is it? -Original Message- From: Erika Foster [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 8:16 AM To: CF-Talk Subject: Out of Space? I have a client who is getting an Disk Space error when trying to add or update the database. They have a couple GIG of empty space on this disk. I'm off site right now and can't do any troubleshooting on the machine. Any suggestions? What's going on? Thanks! Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 [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
RE: Out of Space?
What database software? Some light weight software packages have size limits. For example, there is a 2 GB file size limitation on Access databases not using linked tables. -Original Message- From: Erika Foster [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 5:16 AM To: CF-Talk Subject: Out of Space? I have a client who is getting an Disk Space error when trying to add or update the database. They have a couple GIG of empty space on this disk. I'm off site right now and can't do any troubleshooting on the machine. Any suggestions? What's going on? Thanks! Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 [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
Re: FREE HTML Editor
Try Edit Plus, its free for 30 days then very cheap ($30) to register. Checkout editplus.com Checkout the user files link to get some syntax files for whatever language you would like color coded. [EMAIL PROTECTED] 07/13/01 10:22AM Hi, We have a client who wishes to edit content in an updater which is then published on web. The client needs to be able to highlight text and make it bold, or make it a HEADING etc. This is an ASP site (boo hiss) but does anyone know of any free software that can be easily customisable to my needs. Regards, Nick Betts. ~~ 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: Inserting ' and into SQL
The CF magic trick is to use the preservesinglequotes() function around your data in your SQL statement. -Original Message- From: Justin Hansen [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 9:20 AM To: CF-Talk Subject: Inserting ' and into SQL I have a query blowing up when I try to insert a ' or into a text field. What is the trick for handling this? A replace list? or this there something better? Justin Hansen - [EMAIL PROTECTED] Web Application Developer Interactive Business Solutions, Inc 816-221-5200 ext. 1305 ~~ 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: Extracting Text from PDF Documents with CF
I thought Verity could index the text in PDFs automatically! It did with previous versions of Acrobat. You can create a Verity index that indexes your database AND other files (pdfs) that you want. Try it and see. -Original Message- From: Dennis Powers [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 9:00 AM To: CF-Talk Subject: Extracting Text from PDF Documents with CF Hi, I am wondering if anyone has a method of extracting the raw (unformatted) text from a PDF file using CF? I have a project were we need to index PDF files AND associated information in a database. We are currently using Verity for searching the database with great success but now we need to index the PDF files that are associated with the data records in the database. When a user uploads a new PDF I would like to extract the text from it and add it to the database with the other information. Then I can use Verity to search all the data fields AND the PDF text data field. A CFX or a COM object would be nice so that I can call it from CF. I would be very appreciative if anyone can steer me to a tag or object that can accomplish this task. Best Regards, Dennis Powers UXB Internet (203) 879-2844 http://www.uxbinfo.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: [Inserting ' and into SQL]
show some code. what database too? Justin Hansen [EMAIL PROTECTED] wrote: I have a query blowing up when I try to insert a ' or into a text field. What is the trick for handling this? A replace list? or this there something better? Justin Hansen - [EMAIL PROTECTED] Web Application Developer Interactive Business Solutions, Inc 816-221-5200 ext. 1305 ~~ 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: Out of Space?
Its an Access Database and its about 6mb in size. Ben, I'll check out the .ldb possibility. Thanks! Erika - Original Message - From: Kevin Gilchrist [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 13, 2001 11:04 AM Subject: RE: Out of Space? : What kind of database is it? : : -Original Message- : From: Erika Foster [mailto:[EMAIL PROTECTED]] : Sent: Friday, July 13, 2001 8:16 AM : To: CF-Talk : Subject: Out of Space? : : : I have a client who is getting an Disk Space error when trying to add or : update the database. They have a couple GIG of empty space on this disk. : I'm off site right now and can't do any troubleshooting on the machine. : : Any suggestions? What's going on? : : Thanks! : : Erika Foster : engineering-environmental Management : Applications Developer : (505) 866-1654 : [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
cfgrid references
Just looking for some reference material on cfgrid, outside of the Forta books. Thanks, Steve ~~ 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
Print CF Tree
How come when I try to print my cf-tree all i get is a grayed out box? Joshua Tipton ~~ 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: Print CF Tree
Because that's what most Browsers do when you try to print a Java applet. Sorry -- that's just the way it is. -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 10:34 AM To: CF-Talk Subject: Print CF Tree How come when I try to print my cf-tree all i get is a grayed out box? Joshua Tipton ~~ 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: Extracting Text from PDF Documents with CF
Jann, Unfortunately the client uses Version 4 and now 5 to create his PDF files and Verity will only index Version 3 and below. However, the actual problem is not only searching the PDF's but also the database records at the same time. We ultimately want to get them to the database record with its associated PDF documents and not to the actual PDF document alone. Even if we could index them with Verity (We are using CF 4.01) we would need to perform a second verity search on the database records as well, which would dilute the relevance of the search since the database records hold crucial information required for the search. Putting the text of the PDF into the database would then only require one search and return much more relevant results. Best Regards, Dennis Powers UXB Internet (203) 879-2844 http://www.uxbinfo.com/ -Original Message- From: Jann VanOver [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 12:24 PM To: CF-Talk Subject: RE: Extracting Text from PDF Documents with CF I thought Verity could index the text in PDFs automatically! It did with previous versions of Acrobat. You can create a Verity index that indexes your database AND other files (pdfs) that you want. Try it and see. -Original Message- From: Dennis Powers [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 9:00 AM To: CF-Talk Subject: Extracting Text from PDF Documents with CF Hi, I am wondering if anyone has a method of extracting the raw (unformatted) text from a PDF file using CF? I have a project were we need to index PDF files AND associated information in a database. We are currently using Verity for searching the database with great success but now we need to index the PDF files that are associated with the data records in the database. When a user uploads a new PDF I would like to extract the text from it and add it to the database with the other information. Then I can use Verity to search all the data fields AND the PDF text data field. A CFX or a COM object would be nice so that I can call it from CF. I would be very appreciative if anyone can steer me to a tag or object that can accomplish this task. Best Regards, Dennis Powers UXB Internet (203) 879-2844 http://www.uxbinfo.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: Inserting ' and into SQL
This is the code I use to do it, hasn't failed me yet. I have no idea who originally wrote it, and I'd love to give them credit for it. It's helped me a lot. Anyway... put this above your query somewhere !--- initialize the variable - bad_chars --- cfparam name=bad_chars default= !--- initialize the variable - good_chars --- cfparam name=good_chars default= !--- loop through the range of high-ascii --- cfloop index=i from=127 to=255 !--- append each high-ascii character to a list contained in the variable bad_chars --- cfset bad_chars = ListAppend(bad_chars, Chr(i)) !--- append each numeric character entity representation of the high-ascii character to a list contained in the variable good_chars --- cfset good_chars = ListAppend(good_chars, ## NumberFormat(i, '') ;) /cfloop And then in your query, use this line... '#Trim(ReplaceList(variable, bad_chars, good_chars))#' And change variable with what ever your variable name is. This will replace any bad characters with it's ascii equivalent... making ' and into characters that the db will agree with. Stuart Duncan MaracasMedia Inc. At 11:19 AM 7/13/01 -0500, you wrote: I have a query blowing up when I try to insert a ' or into a text field. What is the trick for handling this? A replace list? or this there something better? Justin Hansen - [EMAIL PROTECTED] Web Application Developer Interactive Business Solutions, Inc 816-221-5200 ext. 1305 ~~ 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: Extracting Text from PDF Documents with CF
Verity requires a filter for the indexing of PDF documents. This filter is provided with CF in most cases. The version of Verity that is included in ColdFusion 4.5.1 for Linux and HP-UX does not include a filter for PDF files. Regards, Rob --- Jann VanOver [EMAIL PROTECTED] wrote: I thought Verity could index the text in PDFs automatically! It did with previous versions of Acrobat. You can create a Verity index that indexes your database AND other files (pdfs) that you want. Try it and see. -Original Message- From: Dennis Powers [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 9:00 AM To: CF-Talk Subject: Extracting Text from PDF Documents with CF Hi, I am wondering if anyone has a method of extracting the raw (unformatted) text from a PDF file using CF? I have a project were we need to index PDF files AND associated information in a database. We are currently using Verity for searching the database with great success but now we need to index the PDF files that are associated with the data records in the database. When a user uploads a new PDF I would like to extract the text from it and add it to the database with the other information. Then I can use Verity to search all the data fields AND the PDF text data field. A CFX or a COM object would be nice so that I can call it from CF. I would be very appreciative if anyone can steer me to a tag or object that can accomplish this task. Best Regards, Dennis Powers UXB Internet (203) 879-2844 http://www.uxbinfo.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: Print CF Tree
Most plug-ins, including java applets, are not printable. The browser doesn't really know what's going on in the box, it just allows the plug-in to draw whatever it wants on the screen. Therefore, when the browser goes to print something, it puts a box just to fill the space. Norman Quoting Joshua Tipton [EMAIL PROTECTED]: How come when I try to print my cf-tree all i get is a grayed out box? Joshua Tipton ~~ 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: Print CF Tree
Check to be certain you have a virtual folder in your IIS that points to C:\CFUSION\CFIDE Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 12:34 PM To: CF-Talk Subject: Print CF Tree How come when I try to print my cf-tree all i get is a grayed out box? Joshua Tipton ~~ 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: php info
Anyone have a good place to go to get information on learning php? THanks ~~ 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: Extracting Text from PDF Documents with CF
For this project we are using CF 4.01 (client's server) and we are using verity to index the database, with excellent results. Using verity to index the PDF files is not an option in this case. What we are looking for is either a CFX or a COM object that can be called from CF to extract the raw unformatted ASCII text from the PDF files. Anyone know of such an animal? Best Regards, Dennis Powers UXB Internet (203) 879-2844 http://www.uxbinfo.com/ -Original Message- From: Robert Rusher [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 1:41 PM To: CF-Talk Subject: RE: Extracting Text from PDF Documents with CF Verity requires a filter for the indexing of PDF documents. This filter is provided with CF in most cases. The version of Verity that is included in ColdFusion 4.5.1 for Linux and HP-UX does not include a filter for PDF files. Regards, Rob --- Jann VanOver [EMAIL PROTECTED] wrote: I thought Verity could index the text in PDFs automatically! It did with previous versions of Acrobat. You can create a Verity index that indexes your database AND other files (pdfs) that you want. Try it and see. -Original Message- From: Dennis Powers [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 9:00 AM To: CF-Talk Subject: Extracting Text from PDF Documents with CF Hi, I am wondering if anyone has a method of extracting the raw (unformatted) text from a PDF file using CF? I have a project were we need to index PDF files AND associated information in a database. We are currently using Verity for searching the database with great success but now we need to index the PDF files that are associated with the data records in the database. When a user uploads a new PDF I would like to extract the text from it and add it to the database with the other information. Then I can use Verity to search all the data fields AND the PDF text data field. A CFX or a COM object would be nice so that I can call it from CF. I would be very appreciative if anyone can steer me to a tag or object that can accomplish this task. Best Regards, Dennis Powers UXB Internet (203) 879-2844 http://www.uxbinfo.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: Out of Space? - More Info
Okay, troubleshooting this from 1000 miles away over the phone bites. 1. Its an Access 2000 DB 2. The DB is only 1.5 MB 3. It will insert records into all tables but one. 4. This particular table has 4762 records 5. They are able to update records in that table. 6. The .mdb and the .ldb files are on the same drive, in the same directory. 7. The drive its on has many GIG of free space. 8. We've stopped CF services and restarted, and we've rebooted. Under the gun here because they need to teach a class on this app tomorrow morning! Any ideas? THANK YOU! Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 [EMAIL PROTECTED] - Original Message - From: Erika Foster [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 13, 2001 6:46 AM Subject: Re: Out of Space? : Its an Access Database and its about 6mb in size. : : Ben, I'll check out the .ldb possibility. : : Thanks! : : Erika : : - Original Message - : From: Kevin Gilchrist [EMAIL PROTECTED] : To: CF-Talk [EMAIL PROTECTED] : Sent: Friday, July 13, 2001 11:04 AM : Subject: RE: Out of Space? : : : : What kind of database is it? : : : : -Original Message- : : From: Erika Foster [mailto:[EMAIL PROTECTED]] : : Sent: Friday, July 13, 2001 8:16 AM : : To: CF-Talk : : Subject: Out of Space? : : : : : : I have a client who is getting an Disk Space error when trying to add or : : update the database. They have a couple GIG of empty space on this disk. : : I'm off site right now and can't do any troubleshooting on the machine. : : : : Any suggestions? What's going on? : : : : Thanks! : : : : Erika Foster : : engineering-environmental Management : : Applications Developer : : (505) 866-1654 : : [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
RE: Inserting ' and into SQL
Very cool! I made the char list creation a custom tag (for easy reuse) and the replace list works great! Thanks a lot! Justin Hansen - [EMAIL PROTECTED] Web Application Developer Interactive Business Solutions, Inc 816-221-5200 ext. 1305 -Original Message- From: Stuart Duncan [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 12:46 PM To: CF-Talk Subject: Re: Inserting ' and into SQL This is the code I use to do it, hasn't failed me yet. I have no idea who originally wrote it, and I'd love to give them credit for it. It's helped me a lot. Anyway... put this above your query somewhere !--- initialize the variable - bad_chars --- cfparam name=bad_chars default= !--- initialize the variable - good_chars --- cfparam name=good_chars default= !--- loop through the range of high-ascii --- cfloop index=i from=127 to=255 !--- append each high-ascii character to a list contained in the variable bad_chars --- cfset bad_chars = ListAppend(bad_chars, Chr(i)) !--- append each numeric character entity representation of the high-ascii character to a list contained in the variable good_chars --- cfset good_chars = ListAppend(good_chars, ## NumberFormat(i, '') ;) /cfloop And then in your query, use this line... '#Trim(ReplaceList(variable, bad_chars, good_chars))#' And change variable with what ever your variable name is. This will replace any bad characters with it's ascii equivalent... making ' and into characters that the db will agree with. Stuart Duncan MaracasMedia Inc. At 11:19 AM 7/13/01 -0500, you wrote: I have a query blowing up when I try to insert a ' or into a text field. What is the trick for handling this? A replace list? or this there something better? Justin Hansen - [EMAIL PROTECTED] Web Application Developer Interactive Business Solutions, Inc 816-221-5200 ext. 1305 ~~ 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: php info
www.phpbuilder.com is a good one. HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server Join the DevCon community at www.coolfusion.com/devcon - Original Message - From: Bruce, Rodney [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 13, 2001 2:21 PM Subject: OT: php info Anyone have a good place to go to get information on learning php? THanks ~~ 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: php info
http://www.php.net - Original Message - From: Bruce, Rodney [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 13, 2001 2:21 PM Subject: OT: php info Anyone have a good place to go to get information on learning php? THanks ~~ 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: php info
http://www.php.net is the best place to start At 11:21 AM 7/13/2001 -0700, you wrote: Anyone have a good place to go to get information on learning php? THanks ~~ 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: Imposing an ad hoc sort order on a SQL query
If this is SQL server should be able to accomplish it something like this...
CREATE PROCEDURE adhocorder
@position1 as varchar(25),
@position2 as varchar(25),
@position3 as varchar(25),
@position4 as varchar(25)
AS
SELECT AdHocOrder = CASE bp.Description
WHEN @position1 THEN 1
WHEN @position2 THEN 2
WHEN @position3 THEN 3
WHEN @position4 THEN 4
ELSE 5
END,
bp.description,
m.membername
FROMmembers m,
boardposition bp,
board b
WHERE m.memberid = b.memberid
AND bp.boardpositionid = b.boardpositionid
ORDER BY adhocorder
Somthing like this should allow yuo to pass in varchars for positions 1-4
indicating which should appear where.
Justin
-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 09, 2001 5:06 PM
To: CF-Talk
Subject: Re: Imposing an ad hoc sort order on a SQL query
Thanks, but that's what I was trying avoid - storing the sort order within
the table. Even though it's flexible enough to be updated, I might have
another page and query (perhaps pulling just a subset of the board members)
where I want to use a different ordering.
But now that I think about it, doing this so-called ad hoc sort in the way I
was proposing may not be the smartest idea, since it's not data driven. It
would require me to hardcode the board position descriptions into the
template's SQL code. I guess I'll do it the way you've described and then
add additional sort order fields as needed by the project.
Jim
- Original Message -
From: Paris Lundis [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, July 09, 2001 2:27 PM
Subject: Re: Imposing an ad hoc sort order on a SQL query
I have had to do this in the past... I just added a USERSORT field and
put numeric fields in it for display order (ie: PRESIDENT= 1
VICEPRESIDENT=2, etc.)
then I just create a forms based interface that lets you mod the
numbers as need be...
so you do a SORT BY USERSORT ASC in my example...
-paris
[finding the future in the past, passing the future in the present]
[connecting people, places and things]
-Original Message-
From: Jim McAtee [EMAIL PROTECTED]
Date: Mon, 09 Jul 2001 11:39:25 -0600
Subject: Imposing an ad hoc sort order on a SQL query
Say I've got three tables for the members of an organization and its
Board
of Directors. Let's say there are approximately ten board positions.
I
want to be able to do a query and have an ad hoc ordering of the
positions
for display on a page. For example:
1. President - John Doe
2. Vice President - Jane Jones
3. Secretary - Bob Smith
4. Treasurer - Neil Jones
etc.
Tables:
Members
MemberID
Name
BoardPositions
-
BoardPositionID
Description
Board
-
BoardID
MemberID
BoardPositionID
I could add a 'sortorder' field to the Board table, but I don't think
this
should be in the data. Rather, I'd like to be able to specify the
order
when I do the query in my CF template. Is there any means in SQL to
do
something like:
SELECT Members.Name, BoardPositions.Description
FROM Board b, BoardPositions p, Members m
WHERE b.MemberID = m.MemberID
AND b.BoardPositionsID = p.BoardPositionsID
ORDER BY ('President','Vice President', ...)
Thanks,
Jim
~~
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: php info
http://www.php3.net http://www.phpbuilder.com http://www.mysql.com http://www.php-nuke.org Joshua Miller Web Development::Programming Eagle Technologies Group, Inc. www.eagletgi.com [EMAIL PROTECTED] -Original Message- From: Bruce, Rodney [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 2:22 PM To: CF-Talk Subject: OT: php info Anyone have a good place to go to get information on learning php? THanks ~~ 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: php info
http://www.php.net/ tom Bruce, Rodney [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Anyone have a good place to go to get information on learning php? THanks ~~ 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: php info
http://hotwired.lycos.com/webmonkey/programming/php/tutorials/tutorial4.html http://www.php.net/tut.php Cheers, Erika (with a *K*) Love gives us in a moment what we can hardly attain by effort after years of toil. - Goethe -- -Original Message- From: Bruce, Rodney [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 2:22 PM To: CF-Talk Subject: OT: php info Anyone have a good place to go to get information on learning php? THanks ~~ 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: php info
www.phpbuilder.com www.builder.com Phpbuilder is one of the best, it has info for both Unix and Windows. HTH -- Original Message -- From: Bruce, Rodney [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Fri, 13 Jul 2001 11:21:56 -0700 Anyone have a good place to go to get information on learning php? THanks ~~ 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: php info
www.php.net www.amazon.com -Original Message- From: Bruce, Rodney [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 11:22 AM To: CF-Talk Subject: OT: php info Anyone have a good place to go to get information on learning php? THanks ~~ 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: Out of Space? - More Info
1.It may actually be something with the table itself and not the disk space. What type of fields are being used? Is is a local table or does it have a different database backend? I have seen weird things happen depending on what datatypes are being used. (In access I stay strictly with text/number). For example regular checkboxes on Access upsized to SQL become bit datatype. And bit couldn't have a null so suddenly lots of error/no data entry allowed. 2. Has anyone changed any field sizes? Make sure those all match up between tables and between tables and forms. (again because the integrity isn't there simple things like field size matters) 3. Are they trying to update/insert through the table or through a form? If it's through a form it may actually be the query that is causing the problem. I don't know how many fields are included in your table but one thing you can do is make a new table and dump the data into it. I really doubt it has anything to do with the amount of records you have in the database. I've seen bigger tables run smoothly. Don't know if this is any help, good luck! -Original Message- From: Erika Foster [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 9:58 AM To: CF-Talk Subject: Re: Out of Space? - More Info Okay, troubleshooting this from 1000 miles away over the phone bites. 1. Its an Access 2000 DB 2. The DB is only 1.5 MB 3. It will insert records into all tables but one. 4. This particular table has 4762 records 5. They are able to update records in that table. 6. The .mdb and the .ldb files are on the same drive, in the same directory. 7. The drive its on has many GIG of free space. 8. We've stopped CF services and restarted, and we've rebooted. Under the gun here because they need to teach a class on this app tomorrow morning! Any ideas? THANK YOU! Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 [EMAIL PROTECTED] - Original Message - From: Erika Foster [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 13, 2001 6:46 AM Subject: Re: Out of Space? : Its an Access Database and its about 6mb in size. : : Ben, I'll check out the .ldb possibility. : : Thanks! : : Erika : : - Original Message - : From: Kevin Gilchrist [EMAIL PROTECTED] : To: CF-Talk [EMAIL PROTECTED] : Sent: Friday, July 13, 2001 11:04 AM : Subject: RE: Out of Space? : : : : What kind of database is it? : : : : -Original Message- : : From: Erika Foster [mailto:[EMAIL PROTECTED]] : : Sent: Friday, July 13, 2001 8:16 AM : : To: CF-Talk : : Subject: Out of Space? : : : : : : I have a client who is getting an Disk Space error when trying to add or : : update the database. They have a couple GIG of empty space on this disk. : : I'm off site right now and can't do any troubleshooting on the machine. : : : : Any suggestions? What's going on? : : : : Thanks! : : : : Erika Foster : : engineering-environmental Management : : Applications Developer : : (505) 866-1654 : : [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
RE: php info
www.phpbuilder.com is a great resource. i even send people who want to know about general web / database development there, it has a great articles section. -alex -Original Message- From: Bruce, Rodney [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 2:22 PM To: CF-Talk Subject: OT: php info Anyone have a good place to go to get information on learning php? THanks ~~ 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: Out of Space? - More Info
are there any other drive dependencies? for logs? for file writes? -Original Message- From: Erika Foster [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 6:58 AM To: CF-Talk Subject: Re: Out of Space? - More Info Okay, troubleshooting this from 1000 miles away over the phone bites. 1. Its an Access 2000 DB 2. The DB is only 1.5 MB 3. It will insert records into all tables but one. 4. This particular table has 4762 records 5. They are able to update records in that table. 6. The .mdb and the .ldb files are on the same drive, in the same directory. 7. The drive its on has many GIG of free space. 8. We've stopped CF services and restarted, and we've rebooted. Under the gun here because they need to teach a class on this app tomorrow morning! Any ideas? THANK YOU! Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 [EMAIL PROTECTED] - Original Message - From: Erika Foster [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 13, 2001 6:46 AM Subject: Re: Out of Space? : Its an Access Database and its about 6mb in size. : : Ben, I'll check out the .ldb possibility. : : Thanks! : : Erika : : - Original Message - : From: Kevin Gilchrist [EMAIL PROTECTED] : To: CF-Talk [EMAIL PROTECTED] : Sent: Friday, July 13, 2001 11:04 AM : Subject: RE: Out of Space? : : : : What kind of database is it? : : : : -Original Message- : : From: Erika Foster [mailto:[EMAIL PROTECTED]] : : Sent: Friday, July 13, 2001 8:16 AM : : To: CF-Talk : : Subject: Out of Space? : : : : : : I have a client who is getting an Disk Space error when trying to add or : : update the database. They have a couple GIG of empty space on this disk. : : I'm off site right now and can't do any troubleshooting on the machine. : : : : Any suggestions? What's going on? : : : : Thanks! : : : : Erika Foster : : engineering-environmental Management : : Applications Developer : : (505) 866-1654 : : [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
Re: Out of Space? - More Info
Do you have the exact error message? Maybe try this: http://support.microsoft.com/support/kb/articles/Q209/9/40.ASP?LN=EN-USSD=g nFR=0qry=disk%20spacernk=4src=DHCS_MSPSS_gn_SRCHSPR=ACC2000 Todd Ashworth -- Certified ColdFusion Developer Network Administrator Saber Corporation 314 Oakland Ave. Rock Hill, SC 29730 (803) 327-0137 [111] - Original Message - From: Erika Foster [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 13, 2001 9:58 AM Subject: Re: Out of Space? - More Info | Okay, troubleshooting this from 1000 miles away over the phone bites. | | 1. Its an Access 2000 DB | 2. The DB is only 1.5 MB | 3. It will insert records into all tables but one. | 4. This particular table has 4762 records | 5. They are able to update records in that table. | 6. The .mdb and the .ldb files are on the same drive, in the same directory. | 7. The drive its on has many GIG of free space. | 8. We've stopped CF services and restarted, and we've rebooted. | | Under the gun here because they need to teach a class on this app tomorrow | morning! | | Any ideas? | | THANK YOU! | Erika Foster | engineering-environmental Management | Applications Developer | (505) 866-1654 | [EMAIL PROTECTED] | - Original Message - | From: Erika Foster [EMAIL PROTECTED] | To: CF-Talk [EMAIL PROTECTED] | Sent: Friday, July 13, 2001 6:46 AM | Subject: Re: Out of Space? | | | : Its an Access Database and its about 6mb in size. | : | : Ben, I'll check out the .ldb possibility. | : | : Thanks! | : | : Erika | : | : - Original Message - | : From: Kevin Gilchrist [EMAIL PROTECTED] | : To: CF-Talk [EMAIL PROTECTED] | : Sent: Friday, July 13, 2001 11:04 AM | : Subject: RE: Out of Space? | : | : | : : What kind of database is it? | : : | : : -Original Message- | : : From: Erika Foster [mailto:[EMAIL PROTECTED]] | : : Sent: Friday, July 13, 2001 8:16 AM | : : To: CF-Talk | : : Subject: Out of Space? | : : | : : | : : I have a client who is getting an Disk Space error when trying to add or | : : update the database. They have a couple GIG of empty space on this | disk. | : : I'm off site right now and can't do any troubleshooting on the machine. | : : | : : Any suggestions? What's going on? | : : | : : Thanks! | : : | : : Erika Foster | : : engineering-environmental Management | : : Applications Developer | : : (505) 866-1654 | : : [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
Re: Out of Space? - More Info
What about the boot drive of the PC? Access creates temp files there... Howie - Original Message - From: Erika Foster [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 13, 2001 9:58 AM Subject: Re: Out of Space? - More Info Okay, troubleshooting this from 1000 miles away over the phone bites. 1. Its an Access 2000 DB 2. The DB is only 1.5 MB 3. It will insert records into all tables but one. 4. This particular table has 4762 records 5. They are able to update records in that table. 6. The .mdb and the .ldb files are on the same drive, in the same directory. 7. The drive its on has many GIG of free space. 8. We've stopped CF services and restarted, and we've rebooted. Under the gun here because they need to teach a class on this app tomorrow morning! Any ideas? THANK YOU! Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 [EMAIL PROTECTED] - Original Message - From: Erika Foster [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 13, 2001 6:46 AM Subject: Re: Out of Space? ~~ 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
CF 5 and cflock (Oh no, here we go again)
Hopefully this will be short and sweet and the answer will be a resounding NO!. Are there any differences in cflock between versions 4.5 and 5? -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ 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: Out of Space? - More Info
Shot in the dark, but can you try this: Open CF Administrator Open ODBC Open the datasource in question Open CFSettings Remove the check for Maintain Database Connections Check the box for Disable Database Connection Update. You should(?) get a verification failed. Reopen the Datasource Uncheck Disable Recheck Maintain It should now work. Maybe. Just ran into something similar, and this worked for me. Marwan -Original Message- From: Erika Foster [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 9:58 AM To: CF-Talk Subject: Re: Out of Space? - More Info Okay, troubleshooting this from 1000 miles away over the phone bites. 1. Its an Access 2000 DB 2. The DB is only 1.5 MB 3. It will insert records into all tables but one. 4. This particular table has 4762 records 5. They are able to update records in that table. 6. The .mdb and the .ldb files are on the same drive, in the same directory. 7. The drive its on has many GIG of free space. 8. We've stopped CF services and restarted, and we've rebooted. Under the gun here because they need to teach a class on this app tomorrow morning! Any ideas? ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** ~~ 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: Extracting Text from PDF Documents with CF
Dennis, You might take a look at using a combination of pstotext ( http://www.research.compaq.com/SRC/virtualpaper/pstotext.html ) and Ghostscript ( http://www.ghostscript.com/ ) I currently use this arrangement to do pretty much what you are requesting. HTH, Kevin At 02:36 PM 7/13/01 -0400, you wrote: For this project we are using CF 4.01 (client's server) and we are using verity to index the database, with excellent results. Using verity to index the PDF files is not an option in this case. What we are looking for is either a CFX or a COM object that can be called from CF to extract the raw unformatted ASCII text from the PDF files. Anyone know of such an animal? Best Regards, Dennis Powers UXB Internet (203) 879-2844 http://www.uxbinfo.com/ -Original Message- From: Robert Rusher [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 1:41 PM To: CF-Talk Subject: RE: Extracting Text from PDF Documents with CF Verity requires a filter for the indexing of PDF documents. This filter is provided with CF in most cases. The version of Verity that is included in ColdFusion 4.5.1 for Linux and HP-UX does not include a filter for PDF files. Regards, Rob --- Jann VanOver [EMAIL PROTECTED] wrote: I thought Verity could index the text in PDFs automatically! It did with previous versions of Acrobat. You can create a Verity index that indexes your database AND other files (pdfs) that you want. Try it and see. -Original Message- From: Dennis Powers [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 9:00 AM To: CF-Talk Subject: Extracting Text from PDF Documents with CF Hi, I am wondering if anyone has a method of extracting the raw (unformatted) text from a PDF file using CF? I have a project were we need to index PDF files AND associated information in a database. We are currently using Verity for searching the database with great success but now we need to index the PDF files that are associated with the data records in the database. When a user uploads a new PDF I would like to extract the text from it and add it to the database with the other information. Then I can use Verity to search all the data fields AND the PDF text data field. A CFX or a COM object would be nice so that I can call it from CF. I would be very appreciative if anyone can steer me to a tag or object that can accomplish this task. Best Regards, Dennis Powers UXB Internet (203) 879-2844 http://www.uxbinfo.com/ - Kevin Ward Web Developer Lattice Semiconductor Corporation NE Moore Court Hillsboro, OR 97124-6421 Ph: 503.268.8656 Fx: 503.268.8693 [EMAIL PROTECTED] http://www.latticesemi.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: Out of Space? - More Info
Thanks, Janine Upon further troubleshooting, we've figured out that we can delete a record, and then add it back in. But, we cannot add anymore than the one we deleted. If we delete 10 records, we can add 10 more. So, this leads me to believe it has everything to do with the size of the table - am I correct in assuming this?? So we just edited the maxfilelock property in the regedit.exe file according to the MS article that Todd sent (thanks Todd!). Waiting on a return call to see if that fixes the problem. Erika - Original Message - From: Janine Jakim [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 13, 2001 1:54 PM Subject: RE: Out of Space? - More Info : 1.It may actually be something with the table itself and not the disk space. : What type of fields are being used? Is is a local table or does it have a : different database backend? I have seen weird things happen depending on : what datatypes are being used. (In access I stay strictly with text/number). : For example regular checkboxes on Access upsized to SQL become bit datatype. : And bit couldn't have a null so suddenly lots of error/no data entry : allowed. : 2. Has anyone changed any field sizes? Make sure those all match up between : tables and between tables and forms. (again because the integrity isn't : there simple things like field size matters) : 3. Are they trying to update/insert through the table or through a form? : If it's through a form it may actually be the query that is causing the : problem. : : I don't know how many fields are included in your table but one thing you : can do is make a new table and dump the data into it. : : I really doubt it has anything to do with the amount of records you have in : the database. I've seen bigger tables run smoothly. Don't know if this is : any help, good luck! : : : -Original Message- : From: Erika Foster [mailto:[EMAIL PROTECTED]] : Sent: Friday, July 13, 2001 9:58 AM : To: CF-Talk : Subject: Re: Out of Space? - More Info : : : Okay, troubleshooting this from 1000 miles away over the phone bites. : : 1. Its an Access 2000 DB : 2. The DB is only 1.5 MB : 3. It will insert records into all tables but one. : 4. This particular table has 4762 records : 5. They are able to update records in that table. : 6. The .mdb and the .ldb files are on the same drive, in the same directory. : 7. The drive its on has many GIG of free space. : 8. We've stopped CF services and restarted, and we've rebooted. : : Under the gun here because they need to teach a class on this app tomorrow : morning! : : Any ideas? : : THANK YOU! : Erika Foster : engineering-environmental Management : Applications Developer : (505) 866-1654 : [EMAIL PROTECTED] : - Original Message - : From: Erika Foster [EMAIL PROTECTED] : To: CF-Talk [EMAIL PROTECTED] : Sent: Friday, July 13, 2001 6:46 AM : Subject: Re: Out of Space? : : : : Its an Access Database and its about 6mb in size. : : : : Ben, I'll check out the .ldb possibility. : : : : Thanks! : : : : Erika : : : : - Original Message - : : From: Kevin Gilchrist [EMAIL PROTECTED] : : To: CF-Talk [EMAIL PROTECTED] : : Sent: Friday, July 13, 2001 11:04 AM : : Subject: RE: Out of Space? : : : : : : : What kind of database is it? : : : : : : -Original Message- : : : From: Erika Foster [mailto:[EMAIL PROTECTED]] : : : Sent: Friday, July 13, 2001 8:16 AM : : : To: CF-Talk : : : Subject: Out of Space? : : : : : : : : : I have a client who is getting an Disk Space error when trying to add or : : : update the database. They have a couple GIG of empty space on this : disk. : : : I'm off site right now and can't do any troubleshooting on the machine. : : : : : : Any suggestions? What's going on? : : : : : : Thanks! : : : : : : Erika Foster : : : engineering-environmental Management : : : Applications Developer : : : (505) 866-1654 : : : [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
RE: Out of Space? - More Info
If it's just one table, check this: You can set the AllowAdditions property under the Data tab of the form's property sheet. The default setting is Yes (True or -1), and this setting allows the user to add new records. If you set this property to No (False or 0), the user cannot add new records. The No setting disables the New Record indicator on the toolbar and the Data Entry command on the Records menu. (Article ID: Q208586) -Ben -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 12:28 PM To: CF-Talk Subject: Re: Out of Space? - More Info What about the boot drive of the PC? Access creates temp files there... Howie - Original Message - From: Erika Foster [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 13, 2001 9:58 AM Subject: Re: Out of Space? - More Info Okay, troubleshooting this from 1000 miles away over the phone bites. 1. Its an Access 2000 DB 2. The DB is only 1.5 MB 3. It will insert records into all tables but one. 4. This particular table has 4762 records 5. They are able to update records in that table. 6. The .mdb and the .ldb files are on the same drive, in the same directory. 7. The drive its on has many GIG of free space. 8. We've stopped CF services and restarted, and we've rebooted. Under the gun here because they need to teach a class on this app tomorrow morning! Any ideas? THANK YOU! Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 [EMAIL PROTECTED] - Original Message - From: Erika Foster [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 13, 2001 6:46 AM Subject: Re: Out of Space? ~~ 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: Out of Space? - More Info
Have you looked at the Windows Swap file? On an NT server, sometimes it can grow to be too large, and eat up all the space on the drive it's located on. Reboot should have fixed it though. Try this - use a CFABORT on the page that throws the error. Start at the top, try the page. After each successful try, move the abort down past the next logical block of code (i.e. CFSET shouldn't throw this error, so you might be able to skip a bunch of lines at once.) Keep doing this until you hit the error. When the error occurs, you've just identified the line (or area) that is throwing the error. At this point, you can look into that command some more. See if there is anything odd with it. Dump any variables that you may be using in that command, are the values being passed likely to cause errors? I'm sure you have already done this, but we need to start someplace. Next, if you are on an NT server, look at the event log. See if anything helpful can be found there. Try a scandisk, see if any problems are present on the drive. That's about all I can think about off the top of my head. Good luck in your search. Shawn -Original Message- From: Erika Foster [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 7:58 AM To: CF-Talk Subject: Re: Out of Space? - More Info Okay, troubleshooting this from 1000 miles away over the phone bites. 1. Its an Access 2000 DB 2. The DB is only 1.5 MB 3. It will insert records into all tables but one. 4. This particular table has 4762 records 5. They are able to update records in that table. 6. The .mdb and the .ldb files are on the same drive, in the same directory. 7. The drive its on has many GIG of free space. 8. We've stopped CF services and restarted, and we've rebooted. Under the gun here because they need to teach a class on this app tomorrow morning! Any ideas? THANK YOU! Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 [EMAIL PROTECTED] - Original Message - From: Erika Foster [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 13, 2001 6:46 AM Subject: Re: Out of Space? : Its an Access Database and its about 6mb in size. : : Ben, I'll check out the .ldb possibility. : : Thanks! : : Erika : : - Original Message - : From: Kevin Gilchrist [EMAIL PROTECTED] : To: CF-Talk [EMAIL PROTECTED] : Sent: Friday, July 13, 2001 11:04 AM : Subject: RE: Out of Space? : : : : What kind of database is it? : : : : -Original Message- : : From: Erika Foster [mailto:[EMAIL PROTECTED]] : : Sent: Friday, July 13, 2001 8:16 AM : : To: CF-Talk : : Subject: Out of Space? : : : : : : I have a client who is getting an Disk Space error when trying to add or : : update the database. They have a couple GIG of empty space on this disk. : : I'm off site right now and can't do any troubleshooting on the machine. : : : : Any suggestions? What's going on? : : : : Thanks! : : : : Erika Foster : : engineering-environmental Management : : Applications Developer : : (505) 866-1654 : : [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
CF 5.0 Docs online?
Anybody know a site where one can view the CF 5.0 docs online? I have a quick question about cfobject and don't want to go through a download and install to get an answer. Dick ~~ 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: Out of Space? - I think we have a winner
We changed the setting in the regedit file for maxfilelock and it seems to have taken care of the problem hopefully. Thanks to all for the help on this! Erika - Original Message - From: Todd Ashworth [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, July 14, 2001 2:21 AM Subject: Re: Out of Space? - More Info : Do you have the exact error message? Maybe try this: : : http://support.microsoft.com/support/kb/articles/Q209/9/40.ASP?LN=EN-USSD=g : nFR=0qry=disk%20spacernk=4src=DHCS_MSPSS_gn_SRCHSPR=ACC2000 : : Todd Ashworth -- : Certified ColdFusion Developer : Network Administrator : : Saber Corporation : 314 Oakland Ave. : Rock Hill, SC 29730 : (803) 327-0137 [111] : - Original Message - : From: Erika Foster [EMAIL PROTECTED] : To: CF-Talk [EMAIL PROTECTED] : Sent: Friday, July 13, 2001 9:58 AM : Subject: Re: Out of Space? - More Info : : : | Okay, troubleshooting this from 1000 miles away over the phone bites. : | : | 1. Its an Access 2000 DB : | 2. The DB is only 1.5 MB : | 3. It will insert records into all tables but one. : | 4. This particular table has 4762 records : | 5. They are able to update records in that table. : | 6. The .mdb and the .ldb files are on the same drive, in the same : directory. : | 7. The drive its on has many GIG of free space. : | 8. We've stopped CF services and restarted, and we've rebooted. : | : | Under the gun here because they need to teach a class on this app tomorrow : | morning! : | : | Any ideas? : | : | THANK YOU! : | Erika Foster : | engineering-environmental Management : | Applications Developer : | (505) 866-1654 : | [EMAIL PROTECTED] : | - Original Message - : | From: Erika Foster [EMAIL PROTECTED] : | To: CF-Talk [EMAIL PROTECTED] : | Sent: Friday, July 13, 2001 6:46 AM : | Subject: Re: Out of Space? : | : | : | : Its an Access Database and its about 6mb in size. : | : : | : Ben, I'll check out the .ldb possibility. : | : : | : Thanks! : | : : | : Erika : | : : | : - Original Message - : | : From: Kevin Gilchrist [EMAIL PROTECTED] : | : To: CF-Talk [EMAIL PROTECTED] : | : Sent: Friday, July 13, 2001 11:04 AM : | : Subject: RE: Out of Space? : | : : | : : | : : What kind of database is it? : | : : : | : : -Original Message- : | : : From: Erika Foster [mailto:[EMAIL PROTECTED]] : | : : Sent: Friday, July 13, 2001 8:16 AM : | : : To: CF-Talk : | : : Subject: Out of Space? : | : : : | : : : | : : I have a client who is getting an Disk Space error when trying to add : or : | : : update the database. They have a couple GIG of empty space on this : | disk. : | : : I'm off site right now and can't do any troubleshooting on the : machine. : | : : : | : : Any suggestions? What's going on? : | : : : | : : Thanks! : | : : : | : : Erika Foster : | : : engineering-environmental Management : | : : Applications Developer : | : : (505) 866-1654 : | : : [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
Access 2000 and SQL 2000 Query Question
Question about SQL 2000 and Access 2000. Is it possible to have an application that will run using either Access 2000 or SQL 2000 DB? I am having trouble with datatypes when it comes to money. For example I have an update query that updates a money SQL datatype and a currency Access datatype. I have to use the single quotes '#whatever#' for Access and no single quotes #whatever# for SQL 2000. So is it possible to have an app run on both databases without any code changes or is the way I am doing it now the only way possible. Thanks, Rich ~~ 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
sharing a structure with the calling template
What's the best way to share a structure that is created in a custom tag with the calling template. Apparently it's not permitted to use cfset caller.mystructure = #mystructure# Thanks, Chris ~~ 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
connectstring and server hangs
We are using connectstring to connect to an ODBC database. It works fine unless the connectstring that gets passed has incorrect data in it. If that happens, the connection just hangs and doesn't time out .. at least not for a long time. Once we get 5 of these in a row, it's bye-bye CF server until the service is restarted. This is driving me crazy. I can't figure out why this is happening. Does anyone know exactly how CF and the connectstring and the database interract? Is there a way to force either CF or the database to throw an error instead of just locking a process and sitting there forever? Here's what I get in my log file: 2001-07-13 15:40:54 Information 538 The ColdFusion Application Server started. 2001-07-13 15:40:48 Error 438 ExprParser: CFuncIsDefined::DoIt: unknown 2001-07-13 15:40:48 Fatal 438 Unknown error threshold reached. Restarting service. 2001-07-13 15:40:28 Error 479 !! CFTrace::logThread(113) has no entry for thread 113 2001-07-13 15:40:28 Warning 479 A request exceeded the timeout. The unresponsive thread count is up to 1. [C:\Inetpub\wwwroot\gymtime_2\index.cfm] 2001-07-13 15:40:18 Error 438 Unable to write reply -- client browser stopped waiting for request. 2001-07-13 15:40:18 Error 438 Windows NT error number 109 occurred. 2001-07-13 15:40:18 Error 438 Error number 232 occurred attempting to close connection to web server. 2001-07-13 15:40:18 Warning 438 Template: C:\Inetpub\wwwroot\index.cfm, Ran: 19 seconds. 2001-07-13 15:40:18 Error 438 Windows NT error number 232 occurred. 2001-07-13 15:37:29 Warning 113 Template: C:\Inetpub\wwwroot\index.cfm, Ran: 24 seconds. 2001-07-13 15:37:08 Error 245 Unable to write reply -- client browser stopped waiting for request. 2001-07-13 15:37:08 Error 245 Windows NT error number 109 occurred. 2001-07-13 15:37:08 Error 245 Error number 232 occurred attempting to close connection to web server. 2001-07-13 15:37:08 Warning 245 Template: C:\Inetpub\wwwroot\index.cfm, Ran: 27 seconds. 2001-07-13 15:37:08 Error 245 Windows NT error number 232 occurred. 2001-07-13 15:33:27 Information 443 The ColdFusion Application Server started. Based on that, I can't really tell which service is causing the problem, the database or CF. The database engine doesn't seem to be affected by any of this, so I'm thinking it's something to do with CF. I'm running CF 5 on NT 4.0 Service pack 6 with IIS 4 The database is Sybase ASA 7.03 running on Win2k Pro Service pack 2 The 2 machines communicate over NetBIOS My connectstring looks like this uid=username;pwd=password;dbf=e:\path\to\database\databasefile.db;eng=dbeng inename;links=netbios;astop=true;astart=false; The connectstring works fine as long as there is nothing wrong with it. But, even if something as simple as the username or password is wrong, it causes a thread to hang. Help? Todd ~~ 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 5 and cflock (Oh no, here we go again)
Hopefully this will be short and sweet and the answer will be a resounding NO!. Are there any differences in cflock between versions 4.5 and 5? No, to the best of my knowledge. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ 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: Access 2000 and SQL 2000 Query Question
I think so, but you have to be very careful to use ODBC for anything special in the SQL. If your dates are in ODBC Date Format, they should work for both. I haven't done this for a long long time so I don't remember the syntax, but I'm mostly positive that it CAN be done. -Original Message- From: Rich Tretola [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 1:43 PM To: CF-Talk Subject: Access 2000 and SQL 2000 Query Question Question about SQL 2000 and Access 2000. Is it possible to have an application that will run using either Access 2000 or SQL 2000 DB? I am having trouble with datatypes when it comes to money. For example I have an update query that updates a money SQL datatype and a currency Access datatype. I have to use the single quotes '#whatever#' for Access and no single quotes #whatever# for SQL 2000. So is it possible to have an app run on both databases without any code changes or is the way I am doing it now the only way possible. Thanks, Rich ~~ 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
