list problems - empty fields
Hi I'm reading a txt file which has 3 fields to a line eg 14||'Maggin, Elliot S.' 15||'Maine, Charles Eric' 16|1|'McCaffrey, Anne' but often the second field is empty Lists don't believe an empty field exists so I keep getting errors when I try to loop over the list to import to a database How can I make the list a true believer? (in accepting empty fields?) Or is there an alternative way to import the data? (access database and ColdFusion 5) Help please Many thanks in advance seamus ~| 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: list problems - empty fields
Hi Seamus, I'm reading a txt file which has 3 fields to a line eg 14||'Maggin, Elliot S.' 15||'Maine, Charles Eric' 16|1|'McCaffrey, Anne' but often the second field is empty Lists don't believe an empty field exists so I keep getting errors when I try to loop over the list to import to a database How can I make the list a true believer? (in accepting empty fields?) Use the replace() function to change the adjacent delimiters pairs to pairs with something you know is a null for the relevant field. Say change || to |.|. -- Yours, Kym ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: list problems - empty fields
thanks Kym I was trying something like that but had the syntax wrong so assumed I was on the wrong track. Thanks again Seamus At 10:06 PM 23/11/02 , you wrote: Hi Seamus, I'm reading a txt file which has 3 fields to a line eg 14||'Maggin, Elliot S.' 15||'Maine, Charles Eric' 16|1|'McCaffrey, Anne' but often the second field is empty Lists don't believe an empty field exists so I keep getting errors when I try to loop over the list to import to a database How can I make the list a true believer? (in accepting empty fields?) Use the replace() function to change the adjacent delimiters pairs to pairs with something you know is a null for the relevant field. Say change || to |.|. -- Yours, Kym ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: list problems - empty fields
There is a custom tag on DevEx - CSV2Query that will convert a list to a query. It will handle empty fields for you, and you could probably get better functionality for what your doing with a list. -Original Message- From: Seamus Campbell [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 23, 2002 5:38 AM To: CF-Talk Subject: list problems - empty fields Hi I'm reading a txt file which has 3 fields to a line eg 14||'Maggin, Elliot S.' 15||'Maine, Charles Eric' 16|1|'McCaffrey, Anne' but often the second field is empty Lists don't believe an empty field exists so I keep getting errors when I try to loop over the list to import to a database How can I make the list a true believer? (in accepting empty fields?) Or is there an alternative way to import the data? (access database and ColdFusion 5) Help please Many thanks in advance seamus ~| 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: list problems - empty fields
Saturday, November 23, 2002, 5:37:57 AM, you wrote: SC I'm reading a txt file which has 3 fields to a line SC eg SC 14||'Maggin, Elliot S.' SC 15||'Maine, Charles Eric' SC 16|1|'McCaffrey, Anne' SC but often the second field is empty SC Lists don't believe an empty field exists so I keep getting errors when I SC try to loop over the list to import to a database SC How can I make the list a true believer? (in accepting empty fields?) listToArray(list, |) might do the trick. Then each of your fields would be an element in the array, even the null ones. SC Or is there an alternative way to import the data? (access database and SC ColdFusion 5) Set up an ODBC Text Datasource for the file if you have a text driver on the machine. It requires less code, and is magnitudes faster than converting a csv to a query with CF logic. Once the datasource is set up, it's one cfquery to convert the entire csv to a query. cfquery datasource=textDSN name=qry SELECT * FROM [foo.csv] /cfquery I know CF5 Enterprise comes with the Merant text drivers, and the Microsoft text drivers work very nice as well. I'm just not sure if they get installed with Access or just with SQL Server. You could also try bypassing all the insanity directly and using the Link Table function to link the text file directly to the database. No need to do anything then...the text file is already part of the database. -- jon mailto:[EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: [OT] Zip Code Lookup
This only sets a bounding box of zips to consider when doing the actual queries and calcs. If you try to do a brute force match over your entire database, it becomes extremely slow. So, this query draws (selects) a square with sides equal to the desired radius, then passes those values to the queries and calcs that do the real meat of the work. It doesn't return the zips in the desired radius, radii being round and all that. The distance calcs drop the corners, so to speak, later in the tag. It's extremely fast in operation - check out http://www.dbactive.com/tags/radtest.cfm - it output the calc time for each radius lookup. Keep in mind that this demo is running on a very bloated MSAccess DB on a shared hosting server. As an example: 84 Zip Codes within 10 miles of 60601 (CHICAGO, IL): Processed in: 281 MS This includes sort time as well (sorted by the distance in miles in this case). Based on your example of Alaska, here is an example. Using 10 miles as the radius, the system returns: 25 Zip Codes within 10 miles of 99501 (ANCHORAGE, AK): Processed in: 78 MS The highest distance returned from the center zip was 8.73 miles. So, to check and see if the tag is even fairly accurate, I ran a search at 99 miles: 52 Zip Codes within 99 miles of 99501 (ANCHORAGE, AK): Processed in: 141 MS I'll show the three pertinent entries - the aforementioned 8.73 mile zip and the next two: 99516 ANCHORAGE AK ANCHORAGE 907 8.73 99687 WASILLA AK MATANUSKA SUSITNA 907 12.66 99577 EAGLE RIVER AK ANCHORAGE 907 13.65 So, no other zips within the orignal radius of 10 miles. The tag seems fairly accurate. I'm sure it could be better, but for most locator type systems it's definately close enough. It's not doing driving distances, obviously. -- jon roig wrote: If you're using the JCSM database, here's a simple query to pull out all the zips within #radius# number of miles. CFQUERY NAME=findLocal DATASOURCE=Zip_Search SELECT jcszip.Zip, jcszip.LastLineCity, jcszip.State, jcszip.Lat, jcszip.Lon FROM jcszip WHERE (((jcszip.lat)= (#geoCode.Lat# - (#Radius# * 0.0005)) And (jcszip.lat)= (#geoCode.Lat# + (#Radius# * 0.0005)) ) AND ((jcszip.lon)= (#geoCode.Lon# - (#Radius# * 0.0005)) And (jcszip.lon)= (#geoCode.Lon# + (#Radius# * 0.0005)) )) ORDER BY jcszip.Zip /cfquery I don't know what area the JCSM database covers, but from the looks of it I wouldn't count on this code unless it only covers the equator because the distance between meridians differs with the lattitude. And if you think the difference is insignificant: chances are your search area is only 50% of what it should be when doing a search from Anchorage, Alaska. Just think of the difference in distance between meridians on the equator and on the poles. The difference between the 0-meridian and the 1-meridian (either east or west) on the equator is 60 miles (n), and on the poles they actually overlap. My trigo is a bit rusty, but I will give it a shot to get the code correct: distance = acos(cos(latA)cos(latB)cos(lonB-lonA)+sin(latA)sin(latB))/360 * 2 * pi * R R = radius earth in the appropriate units lon from -180 to 180 degrees lat from -90 to 90 degrees If you are dealing with small distances and don't actually overlap one of the poles a reasonable approximation would be to compensate only the longitude by division with cos(#geoCode.Lat#): SELECT * FROM jcszip WHERE (((jcszip.lat)= (#geoCode.Lat# - (#Radius# * 0.0005)) And (jcszip.lat)= (#geoCode.Lat# + (#Radius# * 0.0005)) ) AND ((jcszip.lon)= (#geoCode.Lon# - (#Radius# * 0.0005)/cos(#geoCode.Lat#)) And (jcszip.lon)= (#geoCode.Lon# + (#Radius# * 0.0005)/cos(#geoCode.Lat#)) )) ORDER BY jcszip.Zip (I assume your factor 0.0005 is correct for miles (s).) Naturally you need to apply the full calculation on the resultset to get the actual distance, but this first approximation should reduce its size sufficiently to make that possible. And for the PostgreSQL users: check /contrib/, this functionality is built-in to the database. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Compiling List of Files in specific folders
Jim, Fantastic - it worked great. I had a question though - I am using your tag is a cfmodule - Code pasted at bottom for reference - I get the following error below (pasted below)- If I simply comment that line 115 out - the one that sets the query info for Attributes - it works like a charm. Is this because I am calling it through cdmodule? Or I believe the server is running 4.5 - is it something simply not available in 4.5? I don't need it for this specific application - but would love to test it out on a few others which would require attributes. Thanks! jay miller CF Error --- An error occurred while evaluating the expression: Temp = QuerySetCell(Request.FileFindResults, Attributes, ListGetAt(DisplayOutput, 4, |)) Error near line 115, column 14. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Compiling List of Files in specific folders
Jim, Fantastic - it worked great. I had a question though - I am using your tag is a cfmodule - Code pasted at bottom for reference - I get the following error below (pasted below)- If I simply comment that line 115 out - the one that sets the query info for Attributes - it works like a charm. Is this because I am calling it through cdmodule? Or I believe the server is running 4.5 - is it something simply not available in 4.5? I don't need it for this specific application - but would love to test it out on a few others which would require attributes. Thanks! jay miller I'll have to take a look... The tag was built in 4.5 so it should work... I do have a newer (unpublished) one that has been updated for CFMX. CF Error --- An error occurred while evaluating the expression: Temp = QuerySetCell(Request.FileFindResults, Attributes, ListGetAt(DisplayOutput, 4, |)) Error near line 115, column 14. Oh - one thing - you might want to check the version of CF... I'm sorry I don't take better notes, but I vaguely remember something about one of the 4.5 SP's that might have caused problems... Are you up to SP2? Regardless I'll take a look. I won't be able to until later (we're heading out and I'm already getting the evil you promised to take us out and not sit on the computer eye), but I am very interested in making the thing as stable as possible. Jim Davis ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
temp variable storage?
I have a large form (around 100 text boxes and check boxes etc...). Once the user submits it they still need to navigate about 6 more forms before the data can be written to a database. How do I go about storing the form data temporarily until I can write it to disk? I suspect there are more than one ways that you all are doing this. Thanks for a few clues. Brian ~| 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
Anyone have experience in writing Postscript files from CF?
Any how-to hints would be much appreciated! Stace AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: temp variable storage?
What dictates that the first form can't be written to the DB as soon as they submit it? Ken -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 23, 2002 1:02 PM To: CF-Talk Subject: temp variable storage? I have a large form (around 100 text boxes and check boxes etc...). Once the user submits it they still need to navigate about 6 more forms before the data can be written to a database. How do I go about storing the form data temporarily until I can write it to disk? I suspect there are more than one ways that you all are doing this. Thanks for a few clues. Brian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: temp variable storage?
I would simply have the record created on the first form - then run a sql update query on the other forms. if you store temporarily - someone may give up and you loose all information is someone kills browser - or you have to take extra steps to write cookies or secure your temp info- by writing to db each step you;ll probably save alot of time for yourself jay Ken Wilson wrote: What dictates that the first form can't be written to the DB as soon as they submit it? Ken -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 23, 2002 1:02 PM To: CF-Talk Subject: temp variable storage? I have a large form (around 100 text boxes and check boxes etc...). Once the user submits it they still need to navigate about 6 more forms before the data can be written to a database. How do I go about storing the form data temporarily until I can write it to disk? I suspect there are more than one ways that you all are doing this. Thanks for a few clues. Brian ~| 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: Cfloop equivalent in cfscript?
Steve, If you go into CF5.0 Help and go to Developing CF Applications, Chapter 13. Shows all of the commands. Andy -Original Message- From: Steven Durette [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 21, 2002 11:01 PM To: CF-Talk Subject: Cfloop equivalent in cfscript? Didn't see this hit the list, so I thought that I would try again. Is there an equivalent of to be used with cfscript? I have code similar to this: cfloop query=myQuery cfif myQuery.myColName IS 1 cfset myVar = 1 /cfif /cfloop This loop is surrounded on both sides by cfscript blocks and I would like to make it all one cfscript block. Thanks, Steve ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: temp variable storage?
No, no and no. MUST STORE form.variable data while user navigates 6 other forms... Then the form.variable data has value and can be written to the database tables in the way described by the user when they navigate the next six pages. Until they navigate it is IMPOSSIBLE to write the data. thanks, Brian At 01:52 PM 11/23/02, you wrote: I would simply have the record created on the first form - then run a sql update query on the other forms. if you store temporarily - someone may give up and you loose all information is someone kills browser - or you have to take extra steps to write cookies or secure your temp info- by writing to db each step you;ll probably save alot of time for yourself jay Ken Wilson wrote: What dictates that the first form can't be written to the DB as soon as they submit it? Ken -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 23, 2002 1:02 PM To: CF-Talk Subject: temp variable storage? I have a large form (around 100 text boxes and check boxes etc...). Once the user submits it they still need to navigate about 6 more forms before the data can be written to a database. How do I go about storing the form data temporarily until I can write it to disk? I suspect there are more than one ways that you all are doing this. Thanks for a few clues. Brian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: temp variable storage?
Unless XML/XSLT are options... Then you can write live to the db on a per-field basis...so it's not entirely impossible, just complex. -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 23, 2002 12:58 PM To: CF-Talk Subject: Re: temp variable storage? No, no and no. MUST STORE form.variable data while user navigates 6 other forms... Then the form.variable data has value and can be written to the database tables in the way described by the user when they navigate the next six pages. Until they navigate it is IMPOSSIBLE to write the data. thanks, Brian At 01:52 PM 11/23/02, you wrote: I would simply have the record created on the first form - then run a sql update query on the other forms. if you store temporarily - someone may give up and you loose all information is someone kills browser - or you have to take extra steps to write cookies or secure your temp info- by writing to db each step you;ll probably save alot of time for yourself jay Ken Wilson wrote: What dictates that the first form can't be written to the DB as soon as they submit it? Ken -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 23, 2002 1:02 PM To: CF-Talk Subject: temp variable storage? I have a large form (around 100 text boxes and check boxes etc...). Once the user submits it they still need to navigate about 6 more forms before the data can be written to a database. How do I go about storing the form data temporarily until I can write it to disk? I suspect there are more than one ways that you all are doing this. Thanks for a few clues. Brian ~| 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.
OT: Limiting functionality to individual PC's
I am looking to lock down certain types of access to particular machines. I was thinking about using cookies to tag the approved PC's. How easy is it for a User to copy a cookie from 1 PC to another? Anyone have alternative methods that they've used? Thanks, Andy -Original Message- From: Harkins,Patrick [mailto:[EMAIL PROTECTED]] Sent: Friday, November 22, 2002 11:52 AM To: CF-Community Subject: RE: OT cookie question Tie it in with NT authentication instead -Original Message- From: William H. Bowen [mailto:[EMAIL PROTECTED]] Sent: Friday, November 22, 2002 12:48 PM To: CF-Community Subject: OT cookie question I have a situation developing with an intranet site I'm working on. I need to add password protection to the site. no problem there, I already have a solution built that I should be able to plug in. It works extremely well on our external site and is very easy to implement. Now the problem... the way our firewall system is set up. In a nutshell: My business unit is in a particular subnet and we access the site via a given IP address (111.222.333.444) that is then translated and routed correctly. The other units that access this site are on a different subnet and access the site via DNS name (iww.eai.tde.alstom.com - no worries handing the domain out, you shouldn't be able to access it unless you're on the ALSTOM WAN). In order to make the password protection scheme work I need to set a cookie (well a couple actually) How can I do this given the domain restrictions of cookies? TIA!! will William H. Bowen Webmaster ALSTOM's TD Energy Automation Information Business Your friendly neighborhood Webmaster! [EMAIL PROTECTED] http://www.esca.com/ 425.739.3629 Voice 425.466.7016 Cell 425.739.3690 FAX ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: OT: Limiting functionality to individual PC's
I am looking to lock down certain types of access to particular machines. I was thinking about using cookies to tag the approved PC's. How easy is it for a User to copy a cookie from 1 PC to another? Anyone have alternative methods that they've used? Thanks, Andy I wouldn't expect it to be particularly difficult... If the given machines are on your local network ( intranet application ) and your network uses static IP addresses internally, you can associate the static IP address of any given machine on your network with a desired feature using the #cgi.remote_addr# variable. hth s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| 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: OT: Limiting functionality to individual PC's
What if they're not static and you're using DHCP? -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 23, 2002 2:25 PM To: CF-Talk Subject: Re: OT: Limiting functionality to individual PC's I am looking to lock down certain types of access to particular machines. I was thinking about using cookies to tag the approved PC's. How easy is it for a User to copy a cookie from 1 PC to another? Anyone have alternative methods that they've used? Thanks, Andy I wouldn't expect it to be particularly difficult... If the given machines are on your local network ( intranet application ) and your network uses static IP addresses internally, you can associate the static IP address of any given machine on your network with a desired feature using the #cgi.remote_addr# variable. hth s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: OT: Limiting functionality to individual PC's
Then I have no idea... What if they're not static and you're using DHCP? -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 23, 2002 2:25 PM To: CF-Talk Subject: Re: OT: Limiting functionality to individual PC's I am looking to lock down certain types of access to particular machines. I was thinking about using cookies to tag the approved PC's. How easy is it for a User to copy a cookie from 1 PC to another? Anyone have alternative methods that they've used? Thanks, Andy I wouldn't expect it to be particularly difficult... If the given machines are on your local network ( intranet application ) and your network uses static IP addresses internally, you can associate the static IP address of any given machine on your network with a desired feature using the #cgi.remote_addr# variable. hth s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| 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
ColdFusion MX JDBC MS SQL Server 2000 named instance
Has anyone on the list been able to assign a dsn in the CFMX administrator to a database on a named instance of MS SQL 2000? I have a server here with MS SQL 7 on 127.0.0.1 or TURING ( the server's machine name ) and a SQL Server 2000 named instance at TURING\SOCRATES ... In CF 5 I could simply designate TURING\SOCRATES in the server field in the cf administrator and everything is copasetic at that point, but MX doesn't produce the same behavior. I'm able to connect to the databases on the SQL Server 7 install usuing either TURING or 127.0.0.1 in the server field. I have installed the updater ( which said it had one non-fatal error while trying to process an ANT file ). I tried 127.0.0.1\SOCRATES and 127.0.0.1 by itself after stopping the SQL 7 service. I tried TURING/SOCRATES thinking that maybe that was changed somehow because \ is an escape character in Java literal strings. I tried using TURING\\SOCRATES since \\ is the esape sequence for \ in Java. I tried TURING:SOCRATES just as a stab in the dark ( incidentally this hung the page and prevented me from accessing the CF Administrator until I restarted the service ). So at this point I'm stuck... I'd be really appreciative if anyone else has got this to work if they could give me a pointer. :) Thanks, s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Anyone have experience in writing Postscript files from CF?
Apache FOP can be used to convert XSL-FO into a variety of formats, including both PostScript and PDF. I've played with it a little and had trouble using it directly from CF (even CFMX), but after acquiring a more CF-friendly Java class it was easy to use (well, easy once you get over the XSL-FO learning curve). http://xml.apache.org/fop/ -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 23, 2002 1:16 PM To: CF-Talk Subject: Anyone have experience in writing Postscript files from CF? Any how-to hints would be much appreciated! Stace ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: OT: Limiting functionality to individual PC's
Like the man says, Use NT user and group permissions. = Douglas White group Manager mailto:[EMAIL PROTECTED] http://www.samcfug.org = - Original Message - From: S. Isaac Dealey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, November 23, 2002 2:06 PM Subject: RE: OT: Limiting functionality to individual PC's | Then I have no idea... | | What if they're not static and you're using DHCP? | | -Original Message- | From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] | Sent: Saturday, November 23, 2002 2:25 PM | To: CF-Talk | Subject: Re: OT: Limiting functionality to individual PC's | | I am looking to lock down certain types of access to | particular machines. I | was thinking about using cookies to tag the approved | PC's. | How easy is it | for a User to copy a cookie from 1 PC to another? | | Anyone have alternative methods that they've used? | | Thanks, | Andy | | I wouldn't expect it to be particularly difficult... | | If the given machines are on your local network ( intranet | application ) | and | your network uses static IP addresses internally, you can | associate the | static IP address of any given machine on your network | with a desired | feature using the #cgi.remote_addr# variable. | | hth | | | s. isaac dealey954-776-0046 | | new epoch http://www.turnkey.to | | lead architect, tapestry cms http://products.turnkey.to | | certified advanced coldfusion 5 developer | http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 | | | s. isaac dealey954-776-0046 | | new epoch http://www.turnkey.to | | lead architect, tapestry cms http://products.turnkey.to | | certified advanced coldfusion 5 developer | http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 | | | ~| 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: temp variable storage?
I think I know what I want to do now...
1. - Store the Form.Variables into a Structure.
-cfscript
tmpStruct = StructNew();
SomeArrayformNames = ListToArray(form.fieldnames);
for(i=1; i LT ListLen(form.fieldnames)+1; i=i+1){
StructInsert(tmpStruct,Attributes.#ListGetAt(form.fieldnames,i)#,evaluate(form.
ListGetAt(form.fieldnames,i)));
}
-/cfscript
2. - Store the Structure as a Client.Variable (using a datastore)
cfset Client.tmpStructure = tmpStruct ???
3. - A few pages later I want to dump the Structure back out into
Attributes.Variables.
??? how... been finding this quite hard to accomplish
At 10:02 AM 11/23/02, you wrote:
I have a large form (around 100 text boxes and check boxes etc...). Once the user
submits it they still need to navigate about 6 more forms before the data can be
written to a database.
How do I go about storing the form data temporarily until I can write it to disk? I
suspect there are more than one ways that you all are doing this.
Thanks for a few clues.
Brian
~|
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: Anyone have experience in writing Postscript files from CF?
but after acquiring a more CF-friendly Java class it was easy to use What was the more CF-friendly Java class that you acquired? Ken ~| 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: Anyone have experience in writing Postscript files from CF?
This is from Neil Giarratana's presentation at CF-North (IniNet, Inc).
import java.io.*;
import org.apache.fop.apps.Driver;
import org.xml.sax.InputSource;
public class PDFGenerator
{
public void createPDF(String foFile) throws
FileNotFoundException, java.io.IOException,
org.apache.fop.apps.FOPException
{
StringReader s = new StringReader(foFile);
FileOutputStream out = new
FileOutputStream(c:\\mypdf.pdf);
Driver driver = new Driver(new InputSource(s),out);
driver.setRenderer(Driver.RENDER_PDF);
driver.run();
out.close();
}
}
You'll want to replace the hard coded output file with a parameter so
it's more reusable.
Good luck!
Sam
-Original Message-
From: Ken Wilson [mailto:[EMAIL PROTECTED]]
Sent: Saturday, November 23, 2002 3:59 PM
To: CF-Talk
Subject: RE: Anyone have experience in writing Postscript
files from CF?
but after acquiring a more CF-friendly Java
class it was easy to use
What was the more CF-friendly Java class that you acquired?
Ken
~|
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: temp variable storage?
Just use wddx to serialize the form scope to a variable. Then, use a hidden field to store the value of the wddx packet. -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 23, 2002 11:58 AM To: CF-Talk Subject: Re: temp variable storage? No, no and no. MUST STORE form.variable data while user navigates 6 other forms... Then the form.variable data has value and can be written to the database tables in the way described by the user when they navigate the next six pages. Until they navigate it is IMPOSSIBLE to write the data. thanks, Brian At 01:52 PM 11/23/02, you wrote: I would simply have the record created on the first form - then run a sql update query on the other forms. if you store temporarily - someone may give up and you loose all information is someone kills browser - or you have to take extra steps to write cookies or secure your temp info- by writing to db each step you;ll probably save alot of time for yourself jay Ken Wilson wrote: What dictates that the first form can't be written to the DB as soon as they submit it? Ken -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 23, 2002 1:02 PM To: CF-Talk Subject: temp variable storage? I have a large form (around 100 text boxes and check boxes etc...). Once the user submits it they still need to navigate about 6 more forms before the data can be written to a database. How do I go about storing the form data temporarily until I can write it to disk? I suspect there are more than one ways that you all are doing this. Thanks for a few clues. Brian ~| 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: Anyone have experience in writing Postscript files from CF?
Thanks will look into it !
-Original Message-
From: Samuel Neff [mailto:[EMAIL PROTECTED]]
Sent: Saturday, November 23, 2002 4:17 PM
To: CF-Talk
Subject: RE: Anyone have experience in writing Postscript files from CF?
This is from Neil Giarratana's presentation at CF-North (IniNet, Inc).
import java.io.*;
import org.apache.fop.apps.Driver;
import org.xml.sax.InputSource;
public class PDFGenerator
{
public void createPDF(String foFile) throws
FileNotFoundException, java.io.IOException,
org.apache.fop.apps.FOPException
{
StringReader s = new StringReader(foFile);
FileOutputStream out = new
FileOutputStream(c:\\mypdf.pdf);
Driver driver = new Driver(new InputSource(s),out);
driver.setRenderer(Driver.RENDER_PDF);
driver.run();
out.close();
}
}
You'll want to replace the hard coded output file with a parameter so
it's more reusable.
Good luck!
Sam
-Original Message-
From: Ken Wilson [mailto:[EMAIL PROTECTED]]
Sent: Saturday, November 23, 2002 3:59 PM
To: CF-Talk
Subject: RE: Anyone have experience in writing Postscript
files from CF?
but after acquiring a more CF-friendly Java
class it was easy to use
What was the more CF-friendly Java class that you acquired?
Ken
~|
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
ColdFusion MX JDBC MS SQL Server 2000 named instance
Okay, I found this article: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q313225 Which says that to connect to a named instance of SQL Server 2000 using JDBC you have to use the syntax server_name:port_number instead of server_name\sqlserver_instance However, when I attempt to use this syntax, the page takes an exceptionally long time ( and locks up the administrator ) until finally producing the same error message it produced with the original syntax Connection verification failed for data source: testtap []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. Anybody have any ideas? s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: ColdFusion MX JDBC MS SQL Server 2000 named instance
Well -- I'm able to connect to the named instance using the ODBC socket, but damn... that shouldn't be the _only_ way to accomplish this. Okay, I found this article: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q3 13225 Which says that to connect to a named instance of SQL Server 2000 using JDBC you have to use the syntax server_name:port_number instead of server_name\sqlserver_instance However, when I attempt to use this syntax, the page takes an exceptionally long time ( and locks up the administrator ) until finally producing the same error message it produced with the original syntax Connection verification failed for data source: testtap []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. Anybody have any ideas? s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: ColdFusion MX JDBC MS SQL Server 2000 named instance
Oh duh! Nevermind... cfmx uses the proper connection string syntax if you just use the machine name and the port number in the port number field ... In my defense, it was different in CF 5. ;P Well -- I'm able to connect to the named instance using the ODBC socket, but damn... that shouldn't be the _only_ way to accomplish this. Okay, I found this article: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q 3 13225 Which says that to connect to a named instance of SQL Server 2000 using JDBC you have to use the syntax server_name:port_number instead of server_name\sqlserver_instance However, when I attempt to use this syntax, the page takes an exceptionally long time ( and locks up the administrator ) until finally producing the same error message it produced with the original syntax Connection verification failed for data source: testtap []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. Anybody have any ideas? s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: _date bug in CF5.0, possibly CFMX as well
Considering that this behavior has existed since CF 1.5, I think, I suspect it's unlikely to change any time soon. Your observation is true, however, you and other folks will be on my side to push Macromedia to do this little thing for the good of this community. I'd prefer that they fix existing bugs, personally. This isn't something that I care about all that much, since I'm used to it. But, as Jochem said, feel free to submit this to the wishform. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: _date feature in CF5.0, possibly CFMX as well
Considering that this behavior has existed since CF 1.5, I think, I suspect it's unlikely to change any time soon. Your observation is true, however, you and other folks will be on my side to push Macromedia to do this little thing for the good of this community. I'd prefer that they fix existing bugs, personally. This isn't something that I care about all that much, since I'm used to it. But, as Jochem said, feel free to submit this to the wishform. There are also still a number of applications which depend on this feature -- it is a feature -- for server-side form validation, and while it may be mildly annoying on occasion for those of us who don't use the feature, personally I would rather deal with that minor, occasional annoyance than to be told that I must change large amounts of my code because a particular feature has been arbitrarily removed from further versions of the server. As I say, I don't use it -- but I'd rather put up with the minor inconvenience for the sake of the community at large than for MM to remove it just because I don't use it. s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: temp variable storage?
Just finished testing that exact routine... except storing as a Client.Variable until later when needed... Thanks! At 01:29 PM 11/23/02, you wrote: Just use wddx to serialize the form scope to a variable. Then, use a hidden field to store the value of the wddx packet. -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 23, 2002 11:58 AM To: CF-Talk Subject: Re: temp variable storage? No, no and no. MUST STORE form.variable data while user navigates 6 other forms... Then the form.variable data has value and can be written to the database tables in the way described by the user when they navigate the next six pages. Until they navigate it is IMPOSSIBLE to write the data. thanks, Brian At 01:52 PM 11/23/02, you wrote: I would simply have the record created on the first form - then run a sql update query on the other forms. if you store temporarily - someone may give up and you loose all information is someone kills browser - or you have to take extra steps to write cookies or secure your temp info- by writing to db each step you;ll probably save alot of time for yourself jay Ken Wilson wrote: What dictates that the first form can't be written to the DB as soon as they submit it? Ken -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 23, 2002 1:02 PM To: CF-Talk Subject: temp variable storage? I have a large form (around 100 text boxes and check boxes etc...). Once the user submits it they still need to navigate about 6 more forms before the data can be written to a database. How do I go about storing the form data temporarily until I can write it to disk? I suspect there are more than one ways that you all are doing this. Thanks for a few clues. Brian ~| 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
customizing debug output --
For anyone who might be interrested: I wanted to improve control over variable display at the bottom of the debug output, so I got into the cfmx setup and I discovered a couple of things: You can create custom debugging templates in cfusionmx/wwwroot/web_inf/debug and they do get added to the drop-down list in the coldfusion administrator... It might be nice to add as a feature later a cfsetting attribute which allows you to set the filename programmatically... Asside from some minor CSS modifications ( I prefer Verdana over Times New Roman and a smaller header size ) I was also able to change variable output from a simple loop which outputs object for any complex variable such as a structure or query to a cfdump which outputs the entire contents... Admittedly, this could seriously inflate the debug execution time and be somewhat dangerous in some situations where the scopes being dumped contain lots of nested complex variables. I also changed the factor which determines whether a given scope is to be output for debugging so that I don't have to go to the CF Administrator and change it for all pages on my cfmx webserver and instead I can turn them on or off for a given individual page programmatically, similar to the way debug output can be turned on of off all together using cfsetting. For any who might be interrested, I replaced lines 531 to 628 in cfusionmx/wwwroot/web_inf/debug/classic.cfm with this in my custom.cfm template: cfparam name=request.debugvars type=string default=Application,CGI,Client,Cookie,Form,Request,Server,Session,URL cfloop index=scope_name list=#request.debugvars# cftry cfif IsDefined(scope_name) AND IsStruct(evaluate(scope_name)) AND StructCount(evaluate(scope_name)) GT 0 AND (cfdebugger.check(#scope_name#Var) OR ListFindNoCase(request.debugvars,scope_name)) pbcfoutput#scope_name# Variables:/cfoutput/b !--- cfloop collection=#APPLICATION# item=param#param#=cftry#CFDe bugSerializable(APPLICATION[param])#cfcatch type=Any#undefined#/cfcatch/cftry /cfloop ---cfdump var=#evaluate(scope_name)# //p/cfif cfcatch type=Any/cfcatch /cftry /cfloop I hope this is useful to anyone other than myself. :) Feedback is always welcome. :) s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| 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: _date feature in CF5.0, possibly CFMX as well
s. isaac dealey, I believe you misread my msg, I propose that MM to Add enable/disable 6 server-side validation rules via CFadmin, for backward compatibility, default to enabled, not to remove them. Thanks. Don Li --- S. Isaac Dealey [EMAIL PROTECTED] wrote: Considering that this behavior has existed since CF 1.5, I think, I suspect it's unlikely to change any time soon. Your observation is true, however, you and other folks will be on my side to push Macromedia to do this little thing for the good of this community. I'd prefer that they fix existing bugs, personally. This isn't something that I care about all that much, since I'm used to it. But, as Jochem said, feel free to submit this to the wishform. There are also still a number of applications which depend on this feature -- it is a feature -- for server-side form validation, and while it may be mildly annoying on occasion for those of us who don't use the feature, personally I would rather deal with that minor, occasional annoyance than to be told that I must change large amounts of my code because a particular feature has been arbitrarily removed from further versions of the server. As I say, I don't use it -- but I'd rather put up with the minor inconvenience for the sake of the community at large than for MM to remove it just because I don't use it. s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| 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: _date feature in CF5.0, possibly CFMX as well
Ahh... I suppose that could be done in the CF Administrator... although I doubt it's liable to be a high enough priority for enough people to make it worth the time to implement it. s. isaac dealey, I believe you misread my msg, I propose that MM to Add enable/disable 6 server-side validation rules via CFadmin, for backward compatibility, default to enabled, not to remove them. Thanks. Don Li --- S. Isaac Dealey [EMAIL PROTECTED] wrote: Considering that this behavior has existed since CF 1.5, I think, I suspect it's unlikely to change any time soon. Your observation is true, however, you and other folks will be on my side to push Macromedia to do this little thing for the good of this community. I'd prefer that they fix existing bugs, personally. This isn't something that I care about all that much, since I'm used to it. But, as Jochem said, feel free to submit this to the wishform. There are also still a number of applications which depend on this feature -- it is a feature -- for server-side form validation, and while it may be mildly annoying on occasion for those of us who don't use the feature, personally I would rather deal with that minor, occasional annoyance than to be told that I must change large amounts of my code because a particular feature has been arbitrarily removed from further versions of the server. As I say, I don't use it -- but I'd rather put up with the minor inconvenience for the sake of the community at large than for MM to remove it just because I don't use it. s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~~ ~~~| 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 s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
CFMX JDBC ERROR: No ResultSet set was produced.
Does anybody know why this happens? Is it really no longer valid to pass a valid sql statement that doesn't produce a recordset? So ... How do I use a query to create a table, etc? Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]No ResultSet set was produced. The Error Occurred in C:\CFusionMX\wwwroot\tapestry43e\netap\components\addr emove\tapestry\dbserver\mssql2000\.0020.drop.triggers.cfm: line 14 Called from C:\CFusionMX\wwwroot\jdbc.cfm: line 8 Called from C:\CFusionMX\wwwroot\tapestry43e\netap\components\addremove\tape stry\dbserver\mssql2000\.0020.drop.triggers.cfm: line 14 Called from C:\CFusionMX\wwwroot\jdbc.cfm: line 8 12 : if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[trLibraryUpdate]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) 13 : drop trigger [dbo].[trLibraryUpdate] 14 : /cfquery 15 : 16 : cfquery datasource=#attributes.dsn# username=#attributes.dsnusr# password=#attributes.dsnpwd# s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: CFMX JDBC ERROR: No ResultSet set was produced.
Known issue... http://www.macromedia.com/v1/Handlers/index.cfm?ID=23464Method=Full SELECT and DROP keywords contained in SQL could produce a No ResultSet set was produced error message. 45938 argh... that's frustrating... all the more so because entering that issue id into the knowledge base produces no results. I'm going here: http://www.macromedia.com/v1/support/knowledgebase/searchform.cfm and typing 45938 into the Article (Server TechNote) ID field at the bottom and pressing the Get Article ID button and getting no results: Macromedia Servers TechNotes Knowledge Base Not finding your answer below? Use our Servers TechNotes Power Search to get answers by refining your search. ©1995-2002 Macromedia, Inc. All rights reserved. Use of this website signifies your agreement to the Terms of Use. Privacy | Site Map | Contact us | Accessibility s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: OT: Limiting functionality to individual PC's
Can NT provide security differentiated by what PC the User is signed into when the User is coming through a DHCP server and you can't base it off of a static IP address? Specifically, I am looking to provide access to a Time Clock application, but can only let Users Punch In and Out when they are actually on the premises. Unfortunately, I can't be guaranteed that purchasing companies will have a Static IP. So that looks like it leaves me with a cookie. What other information can I get from the local PC to confirm that this a an approved machine? Andy -Original Message- From: samcfug [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 23, 2002 2:47 PM To: CF-Talk Subject: Re: OT: Limiting functionality to individual PC's Like the man says, Use NT user and group permissions. = Douglas White group Manager mailto:[EMAIL PROTECTED] http://www.samcfug.org = - Original Message - From: S. Isaac Dealey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, November 23, 2002 2:06 PM Subject: RE: OT: Limiting functionality to individual PC's | Then I have no idea... | | What if they're not static and you're using DHCP? | | -Original Message- | From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] | Sent: Saturday, November 23, 2002 2:25 PM | To: CF-Talk | Subject: Re: OT: Limiting functionality to individual PC's | | I am looking to lock down certain types of access to | particular machines. I | was thinking about using cookies to tag the approved | PC's. | How easy is it | for a User to copy a cookie from 1 PC to another? | | Anyone have alternative methods that they've used? | | Thanks, | Andy | | I wouldn't expect it to be particularly difficult... | | If the given machines are on your local network ( intranet | application ) | and | your network uses static IP addresses internally, you can | associate the | static IP address of any given machine on your network | with a desired | feature using the #cgi.remote_addr# variable. | | hth | | | s. isaac dealey954-776-0046 | | new epoch http://www.turnkey.to | | lead architect, tapestry cms http://products.turnkey.to | | certified advanced coldfusion 5 developer | http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 | | | s. isaac dealey954-776-0046 | | new epoch http://www.turnkey.to | | lead architect, tapestry cms http://products.turnkey.to | | certified advanced coldfusion 5 developer | http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 | | | ~| 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: OT: Limiting functionality to individual PC's
If you're talking about a commercial product, then you're probably talking about an optional feature, correct? In any case, I would look into including multiple restriction options and leave it up to the system administrator to choose. 1. Static IP list 2. IP subnet mask or range (i.e., all IP's in range 192.168.1.x) 3. Cookies 4. Flash Local Shared objects 5. None Sam -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 23, 2002 10:22 PM To: CF-Talk Subject: RE: OT: Limiting functionality to individual PC's Can NT provide security differentiated by what PC the User is signed into when the User is coming through a DHCP server and you can't base it off of a static IP address? Specifically, I am looking to provide access to a Time Clock application, but can only let Users Punch In and Out when they are actually on the premises. Unfortunately, I can't be guaranteed that purchasing companies will have a Static IP. So that looks like it leaves me with a cookie. What other information can I get from the local PC to confirm that this a an approved machine? Andy ~| 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: temp variable storage?
In most cases you would use hidden form fields on each page of the form to pass the data along to the next page. If you search the tag gallery, I recall a CF tag that will generate all of the hidden form field code on each page. Try searching for hidden,formfield and the llke. Othertimes, usually when the user will be submitting HTML content, you can store the data in a temp table, or the same table with a temp flag. Reason being, that when there is HTMl submitted, it can not be stored very well in a hidden form field due to all of the tags a quotation marks. If you need to use the second method, let me know and I can give you more details... Brook At 01:21 PM 11/23/02 -0500, Ken Wilson wrote: What dictates that the first form can't be written to the DB as soon as they submit it? Ken -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 23, 2002 1:02 PM To: CF-Talk Subject: temp variable storage? I have a large form (around 100 text boxes and check boxes etc...). Once the user submits it they still need to navigate about 6 more forms before the data can be written to a database. How do I go about storing the form data temporarily until I can write it to disk? I suspect there are more than one ways that you all are doing this. Thanks for a few clues. Brian ~| 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: OT: Limiting functionality to individual PC's
Why require them to be local? Although for a timecard application, I suspect a cookie is likely good enough -- yea, it's hackable, but the chances of it actually being hacked are slim and it's not like the data is key-codes for nuclear missile silos or anything. Can NT provide security differentiated by what PC the User is signed into when the User is coming through a DHCP server and you can't base it off of a static IP address? Specifically, I am looking to provide access to a Time Clock application, but can only let Users Punch In and Out when they are actually on the premises. Unfortunately, I can't be guaranteed that purchasing companies will have a Static IP. So that looks like it leaves me with a cookie. What other information can I get from the local PC to confirm that this a an approved machine? Andy s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: OT: Limiting functionality to individual PC's
Good idea... Though organizing / managing several different methods and making it transparent to the application administrator(s) could be tricky... but I think well worth the effort. Customers like options. :) If you're talking about a commercial product, then you're probably talking about an optional feature, correct? In any case, I would look into including multiple restriction options and leave it up to the system administrator to choose. 1. Static IP list 2. IP subnet mask or range (i.e., all IP's in range 192.168.1.x) 3. Cookies 4. Flash Local Shared objects 5. None Sam -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 23, 2002 10:22 PM To: CF-Talk Subject: RE: OT: Limiting functionality to individual PC's Can NT provide security differentiated by what PC the User is signed into when the User is coming through a DHCP server and you can't base it off of a static IP address? Specifically, I am looking to provide access to a Time Clock application, but can only let Users Punch In and Out when they are actually on the premises. Unfortunately, I can't be guaranteed that purchasing companies will have a Static IP. So that looks like it leaves me with a cookie. What other information can I get from the local PC to confirm that this a an approved machine? Andy ~~ ~~~| 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 s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| 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: OT: Limiting functionality to individual PC's
You can use the bios machines name - or even MAC address or all of the above. = Douglas White group Manager mailto:[EMAIL PROTECTED] http://www.samcfug.org = - Original Message - From: Andy Ousterhout [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, November 23, 2002 9:21 PM Subject: RE: OT: Limiting functionality to individual PC's | Can NT provide security differentiated by what PC the User is signed into | when the User is coming through a DHCP server and you can't base it off of a | static IP address? | | Specifically, I am looking to provide access to a Time Clock application, | but can only let Users Punch In and Out when they are actually on the | premises. Unfortunately, I can't be guaranteed that purchasing companies | will have a Static IP. | | So that looks like it leaves me with a cookie. What other information can I | get from the local PC to confirm that this a an approved machine? | | Andy | | -Original Message- | From: samcfug [mailto:[EMAIL PROTECTED]] | Sent: Saturday, November 23, 2002 2:47 PM | To: CF-Talk | Subject: Re: OT: Limiting functionality to individual PC's | | | Like the man says, | Use NT user and group permissions. | | = | Douglas White | group Manager | mailto:[EMAIL PROTECTED] | http://www.samcfug.org | = | - Original Message - | From: S. Isaac Dealey [EMAIL PROTECTED] | To: CF-Talk [EMAIL PROTECTED] | Sent: Saturday, November 23, 2002 2:06 PM | Subject: RE: OT: Limiting functionality to individual PC's | | | | Then I have no idea... | | | | What if they're not static and you're using DHCP? | | | | -Original Message- | | From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] | | Sent: Saturday, November 23, 2002 2:25 PM | | To: CF-Talk | | Subject: Re: OT: Limiting functionality to individual PC's | | | | I am looking to lock down certain types of access to | | particular machines. I | | was thinking about using cookies to tag the approved | | PC's. | | How easy is it | | for a User to copy a cookie from 1 PC to another? | | | | Anyone have alternative methods that they've used? | | | | Thanks, | | Andy | | | | I wouldn't expect it to be particularly difficult... | | | | If the given machines are on your local network ( intranet | | application ) | | and | | your network uses static IP addresses internally, you can | | associate the | | static IP address of any given machine on your network | | with a desired | | feature using the #cgi.remote_addr# variable. | | | | hth | | | | | | s. isaac dealey954-776-0046 | | | | new epoch http://www.turnkey.to | | | | lead architect, tapestry cms http://products.turnkey.to | | | | certified advanced coldfusion 5 developer | | http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 | | | | | | s. isaac dealey954-776-0046 | | | | new epoch http://www.turnkey.to | | | | lead architect, tapestry cms http://products.turnkey.to | | | | certified advanced coldfusion 5 developer | | http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 | | | | | | | | ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: temp variable storage?
There has been lots of suggestions on here - but one more - I just built a complex set of forms - there are 8 major forms - half of them dynamically created form queries. User files in information and continues through additional forms and css and js hide and show the form layers. There is no limit to design here. As any form information is selected - it is updated through js to a main summary area. But since everything is contained on one page through dynamic layers - there is no need to save it as temp. I realize that all the suggestions may not hit your exact needs because there is no specifics on the issue. I still can't understand of any condition that you can't write quickly to a temp db file - even if the forms on the future pages are conditional. Also - there is the option of passing the form vars to a small 1 or 2 pixel frame through cf- where they can hang out, be written to a temp cookie or inserted into a temp db file or any number of options. Also - you can use session vars. Actually - We jsut implemented a wholesale secure area where session vars about 6 different pieces of info follow the user through. I bet that many of the advanced cf'rs on the list could give a more specific solution if there was more information too. jay brook wrote: In most cases you would use hidden form fields on each page of the form to pass the data along to the next page. If you search the tag gallery, I recall a CF tag that will generate all of the hidden form field code on each page. Try searching for hidden,formfield and the llke. Othertimes, usually when the user will be submitting HTML content, you can store the data in a temp table, or the same table with a temp flag. Reason being, that when there is HTMl submitted, it can not be stored very well in a hidden form field due to all of the tags a quotation marks. If you need to use the second method, let me know and I can give you more details... Brook At 01:21 PM 11/23/02 -0500, Ken Wilson wrote: What dictates that the first form can't be written to the DB as soon as they submit it? Ken -Original Message- From: Brian Scandale [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] Sent: Saturday, November 23, 2002 1:02 PM To: CF-Talk Subject: temp variable storage? I have a large form (around 100 text boxes and check boxes etc...). Once the user submits it they still need to navigate about 6 more forms before the data can be written to a database. How do I go about storing the form data temporarily until I can write it to disk? I suspect there are more than one ways that you all are doing this. Thanks for a few clues. Brian ~| 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: Java in CF (CFMX)
I am really late to this thread -- been doin' other interesting stuff. There are one (or two, or forty) reasons that have not been mentioned, that make inline Java code a benefit. 1) Where needed in an app, you can get strong typing and nulls -- say you want to communicate with a JDBC driver and retrieve Table/Column attributes from a db -- most JDBC drivers provide this info, but you can't get at it directly form CMFX. 2) Where CFMX can act as a gentle introduction to Java -- certainly this hybrid code would not be the best, but it would allow Java neophytes, like myself, to learn Java gracefully, without having to learn all the rules first. -- There is something about the fact that we can learn our native language, better, by the age of 5, than a person with 4 years of college courses on that language -- simple introduction, constant use, familiarity-- a lot of us Learn by Doing! 3) This would put /keep CF at the head of the pack -- one more significant reason to choose CF over the competition -- EasyJava -- choose the language/implementation that makes the most sense for an application and/or a tier. Dick P.S. while I am asking for things, I'd like to see a cfo.../cfo tag -- does the same thing (and does not deprecate the cfoutput tag-- just a lot easier to type (and pretty self-documenting, and makes a lot more sense than that %= crap!) On Friday, November 22, 2002, at 08:56 AM, Rob Rohan wrote: I understand your decision but I have a couple more things to add, then I'll shut up. 1) To me CFSCRIPT is to Cold Fusion 5 what CFJAVA would've been to CFMX. 2) I also don't think people would just use a cfjava block to just use it. There would have to be a need. (I.E. a custom java tag that doesn't need to be installed) 3) I would like to play with inner classes / threads on a page and casting to thing (like a CF list to a hashtable - don't even know if that would work, but you get the idea). 4) There could be performance gains beyond code execution. For example, when you make a cfm page into a class it adds a bunch of \r\t which is necessary in almost all cases (but certain blocks could be controlled) Thanks for listening Phil and all you wacky MM guys Rob Certified Organic When you put things in quotes, people think someone actually said it. http://treebeard.sourceforge.net http://ruinworld.sourceforge.net Scientia Est Potentia -Original Message- From: Phil Costa [mailto:[EMAIL PROTECTED]] Sent: Friday, November 22, 2002 6:09 AM To: CF-Talk Subject: RE: Java in CF (CFMX) The decision to disallow inline java code was definitely not a cut and dry one. One reason was definitely to enforce a cleaner separation of syntax; the other, which I hadn't mentioned, was to remove some additional complexity from the parsing/compiling process. Because of the differences between typing and syntax, parsing a page that had both Java and CFML/CFScript would have been a bear. Phil -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Friday, November 22, 2002 2:37 AM To: CF-Talk Subject: Re: Java in CF (CFMX) Thursday, November 21, 2002, 11:54:58 PM, you wrote: MT Jon Hall wrote: The case for allowing inline Java is simple, CF developers can use Java without having to know everything about Java. Methods and classes are easy to get. Compiling, classpath's, and understanding the lengths Java goes to, to abstract everything, etc. is not. MT Knowing just a little about a language as deep/complex as Java can MT be dangerous in a number of ways... MT It's very easy to run into errors in java if you don't understand MT how it all works (ex. trying to instantiate an interface). One of MT the overriding strengths of CF is that it offers a great deal of MT power in an easy to use/learn style. This sort of thing, IMO, goes MT against that strength. MT Mixing CFML and Java can very quickly lead to code that is horribly MT organized and difficult to follow/maintain. Obviously, anal coders MT will keep things nice and neat, but others will be mashing CFML, MT CFScript, Java, and SQL together haphazardly. MT Then there's the compatibility thing... Java lists != CF lists. MT Java arrays != CF arrays. Etc. Again, this can lead to confusion MT and cause all kinds of errors. I say let the coders (and the pm's who have a clue g) who write the applications make the decision on what works in their application. I'm not trying to be facetious, but be brutally honest, I couldn't care less that anyone else thinks my hypothetical hybrid Java/CF code is unorganized or difficult to maintain, as long as those that it matters to, like my boss and clients don't care either. So I don't see how the fear of some overwhelming horde of organized code existing somewhere out there, just over the horizon, really is a valid argument against allowing inline
Re: temp variable storage?
On Saturday, Nov 23, 2002, at 23:49 US/Pacific, Jason Miller wrote: There has been lots of suggestions on here - but one more - I just built a complex set of forms - there are 8 major forms - half of them dynamically created form queries. And another option I've not seen mentioned is to create the multi-page forms in Flash. The Flash movie can save all the values locally (either in memory or on disk) and can allow users to go back and forth between pages, updating information as they want until it is time to save the entire form's data. It's also a nicer user experience. Sean A Corfield -- Director, Architecture Web Technology Group -- Macromedia, Inc. tel: (415) 252-2287 -- cell: (415) 717-8473 aim: seancorfield -- http://www.macromedia.com An Architect's View -- http://www.corfield.org/blog/ Introducing Macromedia Contribute. Web publishing for everyone. Learn more at http://www.macromedia.com/contribute ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: OT: Limiting functionality to individual PC's
How can you grab that off the users machine via a web page? Wouldn't you at least need activex control, which still may not be able to (but probably can). -Original Message- From: samcfug [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 23, 2002 11:13 PM To: CF-Talk Subject: Re: OT: Limiting functionality to individual PC's You can use the bios machines name - or even MAC address or all of the above. = Douglas White ~| 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: how to add a MS Access Database as a datasource in SuSE Linux 8.0 ColdFusion 5.0
Have a look at OpenLink Software: www.openlinksw,com they have a solution that allows you to connect to a MS-Access db (as if it were a server) on a win box (real or emulated). I and others have done this on Linux, Mac OS X, etc. There solution has a free trial, and costs $500 to buy. You can easily wast that much $, just looking for a solution. I know it works on CFMX with JDBC -- it shoukd work on CF 5 with ODBX. HTH Dick On Friday, November 22, 2002, at 08:35 AM, samcfug wrote: Linux will not ordinarily support an Access Database which is a Windows only product. That said, there are some (pretty expensive) bridging modules that will connect to a remote windows box where the Access database is. = Douglas White group Manager mailto:[EMAIL PROTECTED] http://www.samcfug.org = - Original Message - From: Abdusselam Karatas [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 22, 2002 9:45 AM Subject: how to add a MS Access Database as a datasource in SuSE Linux 8.0 ColdFusion 5.0 | Can anyone tell me how to add a MS Access Database as a datasource in SuSE Linux 8.0 ColdFusion 5.0? | | Thanks. | | Abd¸sselam KARATAfi | [EMAIL PROTECTED] | Truva ›leti˛im Hizmetleri Ltd. fiti. | Salih Omurtak Cd. No:79 | 81020, Ko˛uyolu / ›stanbul | TURKEY | Tel: +90 216 339 06 10 | Faks: +90 216 339 02 42 | | ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Other Mailing lists
Try http://www.aspfriends.com... HTH, Steve -Original Message- From: Fregas [mailto:[EMAIL PROTECTED]] Sent: Friday, November 22, 2002 1:56 PM To: CF-Talk Subject: OT: Other Mailing lists This is way off topic, but does anyone know of some mailing lists similar to CFTALK but for Java, C# and/or ASP.NET? CFTalk has served me so well over the years because of the high level of activity and the high level of intellect of everyone on here. However, I'm trying to learn both .NET and Java and would like to know if anyone has found similarily good mailing lists for those. I've looked on topica but they are kind of lame--not much activity in most cases. Any recommendations? Thanks, Fregas ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: temp variable storage?
I would have suggested that on the Flash lists I belong to - but occassionally forget about it here - even though I ironically am working on a multi tiered flash form right now. Flash would be a great solution - although it does have the extra step - so if budget is tight it may push it. But as Sean mentioned - it is quite easy for flash to store it in memory or to have it saved somewhere. jay miller P.S. ...entire form's data. It's also a nicer user experience. Sean A Corfield -- Director, Architecture So Sean - are you saying my complex layers solutions isn't a nice user experience? ;) Sean A Corfield wrote: On Saturday, Nov 23, 2002, at 23:49 US/Pacific, Jason Miller wrote: There has been lots of suggestions on here - but one more - I just built a complex set of forms - there are 8 major forms - half of them dynamically created form queries. And another option I've not seen mentioned is to create the multi-page forms in Flash. The Flash movie can save all the values locally (either in memory or on disk) and can allow users to go back and forth between pages, updating information as they want until it is time to save the entire form's data. It's also a nicer user experience. Sean A Corfield -- Director, Architecture Web Technology Group -- Macromedia, Inc. tel: (415) 252-2287 -- cell: (415) 717-8473 aim: seancorfield -- http://www.macromedia.com http://www.macromedia.com An Architect's View -- http://www.corfield.org/blog/ http://www.corfield.org/blog/ Introducing Macromedia Contribute. Web publishing for everyone. Learn more at http://www.macromedia.com/contribute http://www.macromedia.com/contribute ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: OT: Limiting functionality to individual PC's
Sort of related - about system information - Do a search on google about SuperCookie's - here's an article. You can grab unique registry info from a webpage in 4 lines of code - http://www.computerbytesman.com/privacy/supercookie.htm http://www.computerbytesman.com/privacy/supercookie.htm jay miller Samuel Neff wrote: How can you grab that off the users machine via a web page? Wouldn't you at least need activex control, which still may not be able to (but probably can). -Original Message- From: samcfug [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] Sent: Saturday, November 23, 2002 11:13 PM To: CF-Talk Subject: Re: OT: Limiting functionality to individual PC's You can use the bios machines name - or even MAC address or all of the above. = Douglas White ~| 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.
