OT? - CF contract work in Chicago Region?
Hello, This may be off topic (?), but does anyone know who/what might be a resource for contract work on Cold Fusion in the greater Chicago region? Anything from a headhunter's name to an executive at a company known to be using CF would be appreciated. Probably a good idea to reply privately to my email address, [EMAIL PROTECTED] TIA - Ed Gordon Application Designer/ Developer PTC International (630) 789-1234 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Foxpro databases: does CF use indexes?
Management here has seen time-to-production decimated since I introduced Cold Fusion. Yet, doubt remains about it's efficiency reading the legacy Foxpro databases. If I have CF read some Foxpro database files (.dbf), will it use the database index files (.cdx) automatically? How could I tell? How could I *prove to management* that it indeed is using them? If not, can I explicitly use them? How? Thanks in advance for your help... Ed Gordon --- Old so Soon, Smart so Late, When I'm Learning, ... Life is Great! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Crystal Reports - use CFHTTP/CFLOCATION now for CFREPORT ? How?
Can you please explain how to use CFHTTP (and I guess it's with CFLOCATION?) to actually replace the CFREPORT tag that no longer works with newer versions of Crystal Reports? Any examples would be greatly appreciated... Thanks In Advance, Ed Gordon CF'er ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: war Againest Loneliness
What is this about attachments? I got no attachment. All the attached garbage was visible as text, in two parts. Am I missing out on attachments from this group? (even though it was a good thing this time) UH-Oh... wait 'til you hear THIS... I uninstalled NAV 2002 and forgot to install the NAV 2003 - meanwhile, THIS comes in! Good thing it had no effect on this end... which makes me wonder if others on the CF list got it with an attachment? Kinda reminds me of the Salk vs. the Sabin polio vaccines - one dead, the other capable of inflicting the disease to a few unlucky ones! HAPPY HOLIDAYS EVERYONE ! ! ! - gotta run to look for the CD ! - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 30, 2002 2:44 PM Subject: Re: war Againest Loneliness Rafael Alan Bleiweiss wrote: That post is exactly why everyone should run Norton Antivirus Corporate edition real-time including email sweeps... and have it update automatically How about not double clicking on attachments and making sure your email client doesn't execute them for you? I'm saving this one for the collection, my first Yaha.K :-) Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: commas in numeric fields...
Rick, Do you have any examples of using onsubmit() that I could see? Is this Java script? I haven't done much Javascript and want to keep this as simple as possible. As for right now, I parse the field myself and pull out non-numerics (dollar sign and commas) but this leaves the user with a fatal error if they enter letter OH or any other non-numeric that I did not search for. tia Ed - Original Message - From: Rick Root [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 12, 2002 8:33 PM Subject: Re: commas in numeric fields... Ed, If there are dollar signs and commas in the value, CF's built in javascript validation functions will not work. Programmatically speaking, it's not a number if it contains non-numeric characters. You could write your own validationg and access it through the onsubmit() of the form. - Rick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: OT? SQL type 'decimal' = what in MS Access?
Matt, thank you very much. In SQL my fields are 'decimal' and say 'scale' of 2. In Access, I assume that would be a scale of 2 and 'Decimal Places' set to Auto ? On the same topic, I wonder how many people out there like to use MS Access for commercial development. Have you read the recent article in CFDJ on using MS Access? They included a way to use linked tables in your local Access database which would allow you to manipulate an SQL database (if designed with the same tables as the Access database) using the standard MS Access forms - you could look right at the SQL data and edit it just like you could any Access table. (That's why I need to know the equivalent of SQL 'decimal' in Access!) I tried it, and it was not only easy, but very helpful. TIA once again, and feel free to ask about my experiences with the use of linked tables as described in the article. Ed Gordon - Original Message - From: Matthew Walker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 12, 2002 8:10 PM Subject: RE: OT? SQL type 'decimal' = what in MS Access? You can choose Number then Field type decimal Matthew Walker http://www.matthewwalker.net.nz/ -Original Message- From: Ed Gordon [mailto:NetDr;callptc.com] Sent: Wednesday, 13 November 2002 3:03 p.m. To: CF-Talk Subject: OT? SQL type 'decimal' = what in MS Access? What data type would I use in MS Access to match a field in an MS SQL database of type decimal? TIA Ed Gordon ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
OT? SQL type 'decimal' = what in MS Access?
What data type would I use in MS Access to match a field in an MS SQL database of type decimal? TIA Ed Gordon
commas in numeric fields...
What do you do to display commas in numeric CFINPUT (editable) fields with values over 999? For one client, I tried to validate numeric to avoid crashing the MS Access database by using CFINPUTs with... validate=integer or validate=float but when I used #DecimalFormat(oldvalue.table)# or #DecimalFormat(oldvalue.table)# to display it in the value= clause of the field, the program would crash the minute they tried to update with the commas still in the numeric fields. So, removed any field validation, and simply scanned for leading dollar sign and embedded commas which I removed. Elegant, but now the user is not stopped by the edit built into CFINPUT to check for numeric - therefore, if they slip and put in a character (say, an OH for a ZERO), SQL bombs . What do you do for numerics over 999? - TIA Ed Gordon
SQL UPDATE - identifying a record?
How does one CFQUERY UPDATE a particular record on an SQL database? That is the general question... It may sound simple, but if you were to read a record using SELECT, if more than one record matched the criteria in a WHERE clause, how could you UPDATE just one of them? I have been using UUID on EVERY record in every table in order to alleviate this. It gives me a unique value for each record (row) and therefore I can say WHERE uuid='#the-uuid-I-read#' But without this technique - is there a record-number accessible or anything like that? Ed G.
what tag captures data from a web page?
If you would, please direct me to what tag or tags (or function) I should look at in order to capture data from an existing internet web page. TIA Ed Gordon
Re: columns of user-editable text: Link to Excel sheet?
Even simpler answer came up at the client site today - Excel lets the user Save as web page - so I directed the user to save the phonelist to the right spot, where I pointed a CFINCLUDE template=phonelist.htm embedded in a typical-looking web page for their intranet and VOILA - it came up working like a charm, and they are able to replace it at will. - Original Message - From: Sim Graves [EMAIL PROTECTED] To: Ed Gordon [EMAIL PROTECTED] Sent: Wednesday, October 30, 2002 10:33 AM Subject: Re: columns of user-editable text: Link to Excel sheet? Dear Ed, You can make an ODBC connection to an Excel file just like it is a database. I have an application where the client changes the data in an application just by uploading a new Excel file to the server. The Excel file always has the same name. ColdFusion accesses the file like it is a database table. You need to set some definitions in the Excel file so that ColdFusion knows that the first row is the field names, etc. Look online for the exact procedure, I can't remember all of the details off hand. Hope this helps. Sincerely, Sim Graves Ed Gordon wrote: Hi ! Thank you very much for writing... Sort of like the first choice... ...want the user to upload an Excel spreadsheet that's displayed on a Web page? only it's an admin-level user who has access to the server itself. They already perform the function using data in a table with a CFGRID - but when they do, the secretary a whole division over has already maintained the office phone list electronically - only it's in an Excel spreadsheet. They just don't want to have to re-type everything into the grid. I figger I'll just tell them to export the text to a file, which I then CFINCLUDE on a typical (but blank) page on their (intranet) site - and in order to retain the line breaks, I put it between PRE ... /PRE ... or some other variation - can't think of how I would keep the data in columns though... Thanks, Ed - Original Message - From: Sim Graves [EMAIL PROTECTED] To: Ed Gordon [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 10:49 PM Subject: columns of user-editable text: Link to Excel sheet? Dear Ed, I'm not sure what you are trying to accomplish here. Do you want the user to upload an Excel spreadsheet that's displayed on a Web page? Do you want the user to download a Web page that's an Excel spreadsheet? Or, is this something else that I'm not understanding? CFGRID will update like a spreadsheet, but that's not what you want . . or is it? Tell me more and I'll try to help. Sincerely, Sim Graves
columns of user-editable text: Link to Excel sheet?
Someone wants to have a page that's mainly an Excel spreadsheet... anyone know how to do that? Does it change when they change the spreadsheet? Or, I was thinking the user could export to a text file, which I could cfinclude between PRE /PRE tags... but there are columns of data - how would I get them to line up? This is the user phone list - name, dept, phone, employee no... tabular data. They HAVE an actual cfgrid of data for it now, and I knew they would eventually NOT want to keep it up (in duplicate with whatever the secretary is using to distribute the real phone list!). Suggestions? Sample code? TIA Ed Gordon
Re: columns of user-editable text: Link to Excel sheet?
Hi ! Thank you very much for writing... Sort of like the first choice... ...want the user to upload an Excel spreadsheet that's displayed on a Web page? ... only it's an admin-level user who has access to the server itself. They already perform the function using data in a table with a CFGRID - but when they do, the secretary a whole division over has already maintained the office phone list electronically - only it's in an Excel spreadsheet. They just don't want to have to re-type everything into the grid. I figger I'll just tell them to export the text to a file, which I then CFINCLUDE on a typical (but blank) page on their (intranet) site - and in order to retain the line breaks, I put it between PRE ... /PRE .. or some other variation - can't think of how I would keep the data in columns though... Thanks, Ed - Original Message - From: Sim Graves [EMAIL PROTECTED] To: Ed Gordon [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 10:49 PM Subject: columns of user-editable text: Link to Excel sheet? Dear Ed, I'm not sure what you are trying to accomplish here. Do you want the user to upload an Excel spreadsheet that's displayed on a Web page? Do you want the user to download a Web page that's an Excel spreadsheet? Or, is this something else that I'm not understanding? CFGRID will update like a spreadsheet, but that's not what you want . . or is it? Tell me more and I'll try to help. Sincerely, Sim Graves
user - attachments ?
What is used to allow users to upload attachments, and what other considerations might there be to this scenario... I have a system whereas users enter headlines that are then posted to the HOME page of the site, along with an expiration date (after which the home page CFM ignores them). They often wish to refer to a JPG or something - have any code like this I can adapt for this purpose? It would be much appreciated. TIA, Ed Gordon
OT? Easy data entry util for SQL?
We have been using Access for so long now I got used to being able to enter/edit data with a few mouse clicks, just opened up the table and started typing or making corrections (to users, parameters files, or erroneous transactions during development). Now that development has been ported to SQL, I dread the command-line data entry of ISQL 6.5. Is there an easier way to do what I got used to doing with Access? A recent article, I believe it was in CFDJ, talked about interfacing the Access front-end to an SQL database thru ODBC. Have you actually tried it? Any tips/tricks? Thanks In Advance Ed Gordon
SQL error - Arithmetic overflow...?
This ran just fine using Microsoft Access. Now I get an overflow?
Can you spot what's wrong? The values in the fields aren't very big - the
largest is like 1952 to which I'm adding 20 or 30 or so...
=
ODBC Error Code = 22003 (Numeric value out of range)
[Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error
converting numeric to data type numeric.
SQL = Update MEMBERS Set status='Gold', current_point_ratio=1.25,
total_purchases=total_purchases+22,
purchases_this_year=purchases_this_year+22,
purchases_quarter_1=purchases_quarter_1+22,
total_points_earned=total_points_earned+27.5,
points_earned_this_year=points_earned_this_year+27.5,
points_earned_quarter_1=points_earned_quarter_1+27.5,
point_balance=point_balance+27.5, last_tran_posted_on={d '2002-10-02'},
last_tran_posted_at={t '21:16:33'} Where
uuid='23A99597-9F04-11D6-AEAA00A0CC617FCD'
I guess it's too much to ask that they tell me WHAT value is out of range -
or, since I am now using a real SQL database instead of MS Access, do I
have to do all the calculations outside of the Update?
Thanks in Advance,
Ed Gordon
=
HERE'S THE CF CODE
=
CFQUERY datasource=#application.ds#
Update MEMBERS
Set status='#STATUSCHANGE#',
current_point_ratio=#RATIOCHANGE#,
total_purchases=total_purchases+#numAmount#,
purchases_this_year=purchases_this_year+#numAmount#,
purchases_quarter_1=purchases_quarter_1+#numAmount#,
total_points_earned=total_points_earned+#numPoints#,
points_earned_this_year=points_earned_this_year+#numPoints#,
points_earned_quarter_1=points_earned_quarter_1+#numPoints#,
point_balance=point_balance+#numPoints#,
last_tran_posted_on=#CREATEODBCDATE(tdazedate)#,
last_tran_posted_at=#CREATEODBCTIME(theodbctime)#
Where uuid='#getmember.uuid#'
/CFQUERY
=
HELP?
TIA
OT? SQL visual editor?
I once saw someone manipulate an SQL database (MS SQL) with a much more visual editor than ISQL, which is strictly text command-line level. Do you know if there is anything out there like that? Enterprise Manager is what I've been told, but I've yet to try it... TIA === Aerial photo of Ground Zero located at: http://jmvella.home.attbi.com/GroundZero.jpg FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
How can we right-justify dollar INPUT/VALUE=fields?
How can I make dollar-and-cent fields appear on the RIGHT of an INPUT field (when set with a VALUE=)??? __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
simple right-justify dollar fields in tables?
I'm putting in TD ALIGN=RIGHT but the darn things are left-justified. Any clue how to (easily) get decimal places in a column to line up nice? TIA Ed FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
META refresh not working ! ?
The reference says this should work. Can you see anything wrong here? It just does not load the page. head titleLeads Management Database - Lead Assignment/title META HTTP-EQUIV=refresh content=1; URL=http://nnn.nn.nn.nn/mydir/module.cfm; /head It just sits there ! Help ! Thanks In Advance Ed Gordon PTC International - HeLp! i'M A pRiSoNeR cHaInEd To a DeVeLoPmEnT pC In a cAvE ! ! ! ( please send pizza ) FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: META refresh not working ! ?
oi ! such a klutz this boy can BE ! and here I thought it was the answer to the IP shortage ! oi ! - Original Message - From: Critz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 11, 2002 10:04 AM Subject: Re: META refresh not working ! ? oi Ed!! maybe it can't find that weird domain: http://nnn.nn.nn.nn :) -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion - Thursday, April 11, 2002, 10:55:26 AM, you wrote: EG The reference says this should work. Can you see anything wrong here? It EG just does not load the page. EG head EG titleLeads Management Database - Lead Assignment/title EG META HTTP-EQUIV=refresh EG content=1; URL=http://nnn.nn.nn.nn/mydir/module.cfm; EG /head EG It just sits there ! EGHelp ! EG Thanks In Advance EG Ed Gordon EG PTC International EG - EG HeLp! i'M A pRiSoNeR cHaInEd To a EG DeVeLoPmEnT pC In a cAvE ! ! ! EG ( please send pizza ) EG FAQ: http://www.thenetprofits.co.uk/coldfusion/faq EG Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ EG Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
META refresh truly not working ! ?
Have you ever had a META refresh that's supposed to load another page that JUST WOULDN'T GO? The reference says this should work. Can you see anything wrong here? It just does not load the page. I've used it before in CF and it worked...? ! ? ! ? head titleLeads Management/title META HTTP-EQUIV=refresh content=1; URL=http://215.34.12.77/prod/gomodule.cfm; /head It just sits there ! Help ! Thanks In Advance Ed Gordon PTC International __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFCONTENT - donwloads only a .cfm file?
Can you explain the parameters in your example please? - Original Message - From: Pascal Peters [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 05, 2002 5:35 AM Subject: RE: CFCONTENT - donwloads only a .cfm file? here is an example: cfset path = variables.exportfolder lcase(url.file) cfheader name=Content-Disposition value=inline; filename=#lcase(url.file)# cfcontent type=application/unknown file=#path# deletefile=No -Original Message- From: Ed Gordon [mailto:[EMAIL PROTECTED]] Sent: vrijdag 5 april 2002 12:27 To: CF-Talk Subject: CFCONTENT - donwloads only a .cfm file? The CFCONTENT is wow very nice that it allows us, with a simple tag, to give the user the ability to download a file. However, when the user goes to SAVE it, it gives them only one choice - download.cfm - as the name of the file - and their browser seems to want to treat it as a Cold Fusion Module too; if I do it on the development machine, it understands a CF module. But I had some strange result trying to save it on the users' machine. Is there any way to NAME the file that is going to be downloaded, and in particular, something other than dot cfm ? TIA and have a great weekend! Ed Gordon FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
An IMG instead of a form SUBMIT button ?
How can I have the user click on a image of my own design to effect the 'action' page on a form rather than the standard INPUT TYPE=SUBMIT VALUE=button text ? Simpler is better and, if given the choice, I'd rather avoid Java Thanks for your help! Ed Gordon PTC International - HeLp! i'M A pRiSoNeR cHaInEd To a DeVeLoPmEnT pC In a cAvE ! ! ! ( no 'rescues' please, just send pizza ) FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFCONTENT - donwloads only a .cfm file?
The CFCONTENT is wow very nice that it allows us, with a simple tag, to give the user the ability to download a file. However, when the user goes to SAVE it, it gives them only one choice - download.cfm - as the name of the file - and their browser seems to want to treat it as a Cold Fusion Module too; if I do it on the development machine, it understands a CF module. But I had some strange result trying to save it on the users' machine. Is there any way to NAME the file that is going to be downloaded, and in particular, something other than dot cfm ? TIA and have a great weekend! Ed Gordon FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFFILE reads whole file into 1 var?
CFFILE READs whole file into 1 var? Is there a limit on the size of the contents of that file? Is there an alternative way to read and process one record at a time in the traditional fashion? I had to parse thru the file looking for CR's and CFLOOP thru the logic. Seems strange, but if that's the way we must do it, when in Poughkeepsie, do as the... nevermind... how do YOU process each record in a flat file? Thanks In Advance Ed Gordon Weekdays: Software Developer Weekends: Fighting Crime as Chicken Man FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: web server for XP home?
So, uhhh... Someone said categorically that I need XP Pro to run any web server. Is that true or not? The thread seemed to drift, all well and good except the blur in OS and recommend software... Will Apache run on XP Home? One person says no. Others say Apache is the way to go... Apache will do the trick... I've been using Apache no problem... but the discussion drifted away from XP Home. Will SOME web server run on XP Home, or is it really lacking some kernel functionality? Whoever said Samba - the laptop is out for a drive right now, but when I get to use it again, should I bother installing Samba? Or was that another recommendation for XP Pro? * sigh * thanks to all - Ed G __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
web server for XP home?
I just bought a laptop and we are discussing development (like at the park/beach/pool ;-) ) but I read somewhere that Personal Web Server won't run under XP. I don't really want to upgrade it to XP Pro to use IIS, and I tried two free web servers - when I click on the CF Administrator, analog X web server software somehow goes into a file download dialogue of 127.0.0.1; Savant 3.0 just serves up a screen full of trash... Do you know of a fix to either of these problems, or a decent web server to try? Preferably one with a trial period, I would like to buy before I try... TIA Ed Gordon CF Developer FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
two SUBMIT buttons on a form?
Is there a simple way to have two buttons on the bottom of a form, one which goes to one .cfm and one to another, and yet have both process the entered form data on the way? I would of course label them differently, such as NEW and COPY, or for similar functions. TIA Ed Gordon FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
simple test on text field for numeric only ?
I think I know there is no way but to write my own routine, but if I do, maybe someone has done it before... How can I check to see if a text form field contains anything other than numbers? CFINPUT/VALIDATE won't do, here's why: This system deals with a lot of big dollar amounts - $3,500,000.00 - etc - So to improve readability on editing them, I put them in the VALUE=#dollarFormat(var)# of the CFINPUT, but whether they change them or not, when they process the CFFORM, it would cause an error if the field was type=float or integer... So, I made them type=text and parse out the $ and/or commas in a loop myself. But if they oops and put $3,5T0,000 or OH instead of zero or whatever, they would get the ODBC ERROR tombstone error page. Is there a simple test to see if a text field will go into the database in a numeric field, so I can loop back with a message to the user (as I already do for other purposes)? FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFFILE - on server only?
Does the Cold Fusion server only create / write to files on the server itself? Is there any way to get Cold Fusion to create / write to a file on the client side rather than on the server? Is there a way to get a file dialogue box up so that the user can choose the name / location of a file to create / write to? TIA - Ed FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
interface with Active Directory?
Have you any resources, or better yet CF code, to interface with Active Directory? FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
MS-Access: nulls in numerics?
I believe I am getting 'syntax error in SQL statement' type of error messages because some of the rows in a numeric column in an Access database have zero and others are blank, leading me to believe they are NULL. Is there a way to test for a null value in a numeric field? Thanks In Advance, Ed Gordon FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Help - MS Word outputfrom CF?
After the users put in parameters to generate a quote and the customer says 'yes', I need to generate a whole big document, including standard paragraphs, and other sections of text inserted based on various aspects of the sale. This is now all done by hand in MS Word. I can get all the parts (text paragraphs), but how do I then have CF spit out a nicely-formatted text document? In general, what DO people do about printed reports???!?!?! I have so far only put a printer-friendly web page out and the user prints it in his browser. This is supposed to be a nicely formatted printed document, an actual legal contract for the customer to sign. Anyone do this type of thing before? Thanks! Ed Gordon CF Developer [EMAIL PROTECTED] __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
