RE: multi page (wizard like) forms
Hello, There is a form to session custom tag out there somewhere that I have used, it pretty much turns every form var to a session var with the same name at post time. You could use that and then run some large queries at the end to do all the inserts from those session vars. JLB -Original Message- From: Ali Majdzadeh [mailto:[EMAIL PROTECTED] Sent: Monday, August 28, 2006 8:54 AM To: CF-Talk Subject: multi page (wizard like) forms Hi everybody: I need to make a multipage form(wizard like form) that insert data into several tables(4-5 tables). I searched for a solution a lot but couldn't find an easy way that can let me make the pages with DW/CFM. I heard many people recommended useing SESSION VARRIABLES. I am a novice in coldfusion. Please help me find a tutorial/method making my form.(with or without sessions) I repeat it again that data should be inserted into different Related Database tables.(I use MS Access) Thanks Benign ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251229 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: HTML Emails
We supply bulk email services. www.webdecisions.com -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Thursday, August 24, 2006 9:23 AM To: CF-Talk Subject: RE: HTML Emails Would anyone care to recommend any of these email services? Just wondering who is out there and who is *good*? Thanks, Che -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Thursday, August 24, 2006 9:13 AM To: CF-Talk Subject: RE: HTML Emails As do we. We used to send thousands of messages to prospective studnents a few years ago. Then, we started getting notices that we were pending to be blacklisted on some major providers. So, we switched to a service that sends our messages. They provide for HTML and text-only parts within the same message. We are very pleased. M!ke -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Thursday, August 24, 2006 2:59 AM To: CF-Talk Subject: Re: HTML Emails You should note though that large email marketing services work closely with ISP and Spam services to stop good emails being blocked. An email should not be simply blocked just because it is HTML. if you want to be sure emails are being taken care off, use one these agencies. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250851 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: List of states, cities, zips
We have that here, I can't remember where we bought it, but we get new files every 3 months. Zip codes are added and changed a lot more often than most people think. I don't think the subscription was all that much, I'll see what I can find out. -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Friday, August 11, 2006 9:27 AM To: CF-Talk Subject: Re: List of states, cities, zips that sounds fairly exhaustive :) if it's free for distribution, i'd be interested in a copy :) On 8/11/06, Andy Matthews [EMAIL PROTECTED] wrote: How exhaustive are you looking for this list to be? I've got a DB containing cities, states for almost every country in the world. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Doug [mailto:[EMAIL PROTECTED] Sent: Friday, August 11, 2006 6:51 AM To: CF-Talk Subject: List of states, cities, zips I was wondering if anyone had a list of such that they could email me. It would be appreciated. Thanks Doug [EMAIL PROTECTED] ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249560 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Possible in SQL?
Hello, I have a table that looks something like this. Com1 genderfname lname 001 M Matt Smith 001 M Bill Wright 005 FKara Brown 005 M Mike White What I need to do is pull a record from each com1 group that meets my where criteria. Say from above I want all the males. I would want the answer to be 001 M Matt Smith 005 M Mike White Or 001 M Bill Wright 005 M Mike White I don't care which record I just want ONE per com1 id meeting the criteria. I tried using distinct but that will not work as you have to list all the field names out and then group but the none distinct ones which gives me all the com1's meeting the where criteria. Any idea's? Jeremy ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241120 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Possible in SQL?
I tried that. That will give you records with com1 showing up more than once since the names ect are not distinct sql returns all the combinations. If it would only give me one per change in com1 I would be done. Jeremy -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: Monday, May 22, 2006 8:52 AM To: CF-Talk Subject: RE: Possible in SQL? I would have thought distinct would do what you want, are you sure you use dit correctly. Select distinct com1, gender, fname, lname FROM mytable WHERE gender = 'M' Group by com1, gender, fname, lname - Snake -Original Message- From: Jeremy Bunton [mailto:[EMAIL PROTECTED] Sent: 22 May 2006 13:34 To: CF-Talk Subject: Possible in SQL? Hello, I have a table that looks something like this. Com1 genderfname lname 001 M Matt Smith 001 M Bill Wright 005 FKara Brown 005 M Mike White What I need to do is pull a record from each com1 group that meets my where criteria. Say from above I want all the males. I would want the answer to be 001 M Matt Smith 005 M Mike White Or 001 M Bill Wright 005 M Mike White I don't care which record I just want ONE per com1 id meeting the criteria. I tried using distinct but that will not work as you have to list all the field names out and then group but the none distinct ones which gives me all the com1's meeting the where criteria. Any idea's? Jeremy ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241141 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
vb.net's version of the evaluate() in cf and eval() in javascript
Any help would be great. I am having a hard time finding it. I need to set the value of a var to the name of a new var. Dim temp as string = sr a Dim eval(temp) as stringreader or something like that. Jeremy ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238048 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cfhttp?
Hello, I want to use cfhttp to post a form var back to the same page (index.cfm posting to index.cfm) Like below. I get form.project undefined with this. Should this not work? What I need to do is set a form var without a from being on the page. I thought this would be an elegant way of doing so. cfhttp method=Post url=index.cfm cfhttpparam type=Formfield value=777 name=project /cfhttp cfoutput#form.project#/cfoutput Jeremy ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237510 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfhttp?
You know I didn't think about that until after I posted this, and I tried that and it almost worked. It just came down to how the include files I am using (which I can't change) need that var. I ended up doing a cflocation back the same page if that form.project is not defined then seting the form.project = to the url.project that got passed in the url var. -Original Message- From: Everett, Al (NIH/NIGMS) [C] [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 12, 2006 10:14 AM To: CF-Talk Subject: RE: cfhttp? What I need to do is set a form var without a from being on the page. I thought this would be an elegant way of doing so. Why not just cfset form.project=777 ? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237518 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL 2005 and getiing data out
Yeah both BCP and sqlcmd are reall fast and work well EXCEPT they both have a limit on the length of the arguments you can use at the command prompt. If not for that I would be done. I guess I am going to have to look at SSIS. All I need to do is pass a query and export the data from that query to a csv file in my user specific directory. Seems easy, hopefully it is in SSIS. Jeremy -Original Message- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Friday, April 07, 2006 7:36 AM To: CF-Talk Subject: Re: SQL 2005 and getiing data out On 4/6/06, Jeremy Bunton [EMAIL PROTECTED] wrote: I need something I can run in a .bat file as it loads in a batch server. These databases have about 20 million records and the files can be quite large. CFFILE might time out, trying to write out a file with 80 fields and 50,000 records. BCP would seem the way to go to me, as it is very fast. I haven't used it in 2005 to know if there are any differences. Maybe you could create a temporary view for the current user that you could pass to your bcp command. -- Jim Wright Wright Business Solutions [EMAIL PROTECTED] 919-417-2257 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237168 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
SQL 2005 and getiing data out
I have an application that needs to run a query against a 2005 database and then export that data to a .csv file. I tried BCP first and it didn't do what I needed really so then I moved to sqlcmd, which had the options I needed. The problem is sometimes the queries the users build in the interface to pull the records get quite large. Some have IN clauses with several thousand items in the list. Both bcp and sqlcmd die on these because the command arguments are too long. The quires run fine in coldfusion and in the query analyzer, I just can't find a method to pull out the records. Any ideas?? Thanks Jeremy ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237087 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL 2005 and getiing data out
I need something I can run in a .bat file as it loads in a batch server. These databases have about 20 million records and the files can be quite large. CFFILE might time out, trying to write out a file with 80 fields and 50,000 records. Jeremy -Original Message- From: Munson, Jacob [mailto:[EMAIL PROTECTED] Sent: Thursday, April 06, 2006 10:45 AM To: CF-Talk Subject: RE: SQL 2005 and getiing data out What about using CF to do it? Query the DB and use cffile to dump out a csv. -Original Message- From: Jeremy Bunton [mailto:[EMAIL PROTECTED] Sent: Thursday, April 06, 2006 8:12 AM I have an application that needs to run a query against a 2005 database and then export that data to a .csv file. I tried BCP first and it didn't do what I needed really so then I moved to sqlcmd, which had the options I needed. The problem is sometimes the queries the users build in the interface to pull the records get quite large. Some have IN clauses with several thousand items in the list. Both bcp and sqlcmd die on these because the command arguments are too long. The quires run fine in coldfusion and in the query analyzer, I just can't find a method to pull out the records. Any ideas?? [INFO] -- Access Manager: This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A2 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237112 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Save sessions to repopulate at a later date
Hello, I'm trying to take a more all inclusive approach and save all my sessions (as the from variables are all sessions) to wddx then just reset the session structure equal to the output of my wddx. Below is my test code. It works except for the cfset session = session2 doesn't reset all my sessions, any help there? cfwddx action=cfml2wddx input=#session# output=mysavedsessions !--- clear currnet session to test to see if it works --- cfset StructClear(Session) !--- user logs in, get the data, recreate the structs --- !--- dewddx back to session --- cfwddx action=wddx2cfml input=#mysavedsessions# output=session2 cfset session = session2 cfdump var=#session# Jeremy -Original Message- From: Jim [mailto:[EMAIL PROTECTED] Sent: Thursday, March 30, 2006 12:05 PM To: CF-Talk Subject: RE: Save sessions to repopulate at a later date WDDX would make this easy, no need to modify any DB fields or anything if you change your forms. (Also no need for a complex DB) Example: !--- set your forms --- cfset session.forms = structnew() cfloop from=1 to=10 index=i cfset session.forms[i] = structnew() cfloop from=1 to=10 index=n cfset session.forms[i][n] = createuuid() /cfloop /cfloop cfdump var=#session# !--- wddx them --- cfwddx action=cfml2wddx input=#session.forms# output=mysavedforms !--- store the wddx whereever you want (file, db) --- !--- mimic session ending, losing all data --- cfset session.forms = structnew() cfdump var=#session# !--- user logs in, get the data, recreate the structs --- !--- dewddx back to session --- cfwddx action=wddx2cfml input=#mysavedforms# output=session.forms cfdump var=#session# Job done. -Original Message- From: Jeremy Bunton [mailto:[EMAIL PROTECTED] Sent: 30 March 2006 17:40 To: CF-Talk Subject: Save sessions to repopulate at a later date I have an application that has many forms that are saved in sessions as the user jumps from page to page, allowing them to see what they had entered on any page at any given time. Now the users want to be able to hit a button, save the entry and come back weeks later and see what they had entered. Now I need a way to save all sessions to a file, perhaps text or something. So that the user can login say 3 weeks later select the saved criteria (which there may be 50 different ones of by now) and then have all the forms repopulated with the same data as before. Any ideas how I might get that done. Jeremy ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236809 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Save sessions to repopulate at a later date
Yep that seems to do the trick. Thanks Jeremy -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Monday, April 03, 2006 11:28 AM To: CF-Talk Subject: RE: Save sessions to repopulate at a later date I haven't been reading this thread, but to repopulate the session scope you will have to loop over session2 putting each variable in the session one at a time: cfwddx... cfloop collection=#session2# item=i cfset SESSION[i] = session2[i] /cfloop Not tested, but something like that. Adrian -Original Message- From: Jeremy Bunton [mailto:[EMAIL PROTECTED] Sent: 03 April 2006 16:23 To: CF-Talk Subject: RE: Save sessions to repopulate at a later date Hello, I'm trying to take a more all inclusive approach and save all my sessions (as the from variables are all sessions) to wddx then just reset the session structure equal to the output of my wddx. Below is my test code. It works except for the cfset session = session2 doesn't reset all my sessions, any help there? cfwddx action=cfml2wddx input=#session# output=mysavedsessions !--- clear currnet session to test to see if it works --- cfset StructClear(Session) !--- user logs in, get the data, recreate the structs --- !--- dewddx back to session --- cfwddx action=wddx2cfml input=#mysavedsessions# output=session2 cfset session = session2 cfdump var=#session# Jeremy -Original Message- From: Jim [mailto:[EMAIL PROTECTED] Sent: Thursday, March 30, 2006 12:05 PM To: CF-Talk Subject: RE: Save sessions to repopulate at a later date WDDX would make this easy, no need to modify any DB fields or anything if you change your forms. (Also no need for a complex DB) Example: !--- set your forms --- cfset session.forms = structnew() cfloop from=1 to=10 index=i cfset session.forms[i] = structnew() cfloop from=1 to=10 index=n cfset session.forms[i][n] = createuuid() /cfloop /cfloop cfdump var=#session# !--- wddx them --- cfwddx action=cfml2wddx input=#session.forms# output=mysavedforms !--- store the wddx whereever you want (file, db) --- !--- mimic session ending, losing all data --- cfset session.forms = structnew() cfdump var=#session# !--- user logs in, get the data, recreate the structs --- !--- dewddx back to session --- cfwddx action=wddx2cfml input=#mysavedforms# output=session.forms cfdump var=#session# Job done. -Original Message- From: Jeremy Bunton [mailto:[EMAIL PROTECTED] Sent: 30 March 2006 17:40 To: CF-Talk Subject: Save sessions to repopulate at a later date I have an application that has many forms that are saved in sessions as the user jumps from page to page, allowing them to see what they had entered on any page at any given time. Now the users want to be able to hit a button, save the entry and come back weeks later and see what they had entered. Now I need a way to save all sessions to a file, perhaps text or something. So that the user can login say 3 weeks later select the saved criteria (which there may be 50 different ones of by now) and then have all the forms repopulated with the same data as before. Any ideas how I might get that done. Jeremy ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236816 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Save sessions to repopulate at a later date
I have an application that has many forms that are saved in sessions as the user jumps from page to page, allowing them to see what they had entered on any page at any given time. Now the users want to be able to hit a button, save the entry and come back weeks later and see what they had entered. Now I need a way to save all sessions to a file, perhaps text or something. So that the user can login say 3 weeks later select the saved criteria (which there may be 50 different ones of by now) and then have all the forms repopulated with the same data as before. Any ideas how I might get that done. Jeremy ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236562 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
result.columnList order
Hello, I am using the result. columnList attribute of cfquery to print out the columns of my table. I then want to insert them in a file. Problem is the columns are in alpha order, I want them in the same order as they appear in my table. Is there a way to do that? Jeremy ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236089 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: result.columnList order
Great, that works just like I need it to. jeremy -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Thursday, March 23, 2006 3:18 PM To: CF-Talk Subject: RE: result.columnList order From: Jeremy Bunton [mailto:[EMAIL PROTECTED] I am using the result. columnList attribute of cfquery to print out the columns of my table. I then want to insert them in a file. Problem is the columns are in alpha order, I want them in the same order as they appear in my table. Is there a way to do that? http://www.cflib.org/udf.cfm?ID=1410 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236093 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cfexecute
I am trying to use a cfexecute to execute a sql bcp command to write a file out. It appears to work fine from the command line but when I try to use cfexecute I don't get an error but I don't get a file. All my double quotes are escaped with double quotes. Is there a way that I can see what happens when that is executed, like when I run it from the command line? Jeremy ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235754 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
How do you all handle saving checkboxes that have been checked?
I have several forms that have check boxes. I set the vales of the checkboxes to sessions after the form is submitted so that a user can surf around the site and come back and change their selections. The code I use is below and it sort of works - but not really. Its checks to see if the value is in the session and checks the box if it is. The problem is if someone unchecks all the boxes and hits submit. Though the box was unchecked by the user the code below says it was and hence one value always gets posted back to the session and it resets itself and checks a box. cfif #trim(session.fstate)# contains #trim(stateabbr)# input type=Checkbox name=fstate value='#trim(stateabbr)#' checked#state#br cfelse input type=Checkbox name=fstate value='#trim(stateabbr)#'#state#br /cfif /cfoutput ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235770 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: How do you all handle saving checkboxes that have been checked?
Yep, thanks that fixed it right up. That was all it took. cfif isdefined(form.fstate) cfelse cfset session.fstate = /cfif -Original Message- From: Coldfusion [mailto:[EMAIL PROTECTED] Sent: Monday, March 20, 2006 11:57 AM To: CF-Talk Subject: RE: How do you all handle saving checkboxes that have been checked? You would need to validate the form items against the session variables. Thus if the form variable does not exists or set to false, kill the Session variable. All should be done on the Save (submit) event. -Original Message- From: Jeremy Bunton [mailto:[EMAIL PROTECTED] Sent: Monday, March 20, 2006 11:45 AM To: CF-Talk Subject: How do you all handle saving checkboxes that have been checked? I have several forms that have check boxes. I set the vales of the checkboxes to sessions after the form is submitted so that a user can surf around the site and come back and change their selections. The code I use is below and it sort of works - but not really. Its checks to see if the value is in the session and checks the box if it is. The problem is if someone unchecks all the boxes and hits submit. Though the box was unchecked by the user the code below says it was and hence one value always gets posted back to the session and it resets itself and checks a box. cfif #trim(session.fstate)# contains #trim(stateabbr)# input type=Checkbox name=fstate value='#trim(stateabbr)#' checked#state#br cfelse input type=Checkbox name=fstate value='#trim(stateabbr)#'#state#br /cfif /cfoutput ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235773 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Large count query caching
I have a query counting records in a 25 million plus database. Even with indexing and what not it takes about 25 seconds to run this query. (count * from table where date 19000101) Is there a way I could cache the query so that if it is ran in that same way it very quickly returns the full count. I.E. this is a dynamically build query so sometimes it will have a long where clause that I may be different than the straight just count everything thing like above. It seems to me that if that query has been ran one time in the same way that query should not have to recount the next time, and should just output the count. Jeremy ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235618 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Large count query caching
Yeah I thought about that also, but since all my queries, regardless of the ever changing where clause only return a count, never a full record set, I would think that the memory usage would be small or am I wrong? This machine sql 2005 has 4 gig of ram, but the data as a .csv was over 8 gig so I know I can't fit the whole record set in ram. Jeremy -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Friday, March 17, 2006 9:44 AM To: CF-Talk Subject: Re: Large count query caching The only problem with this is the query can change due to the dynamic building of the where clause. Could do a cached query that selects everything that could be in the where clause then do QoQ on that for dynamic where clause needs. I'd just be a little fearful of how much would need to be selected for that cached query, seems like it could get rather big if accessing 25 million records. On 3/17/06, Mingo Hagen [EMAIL PROTECTED] wrote: Hi Jeremy, Yes, you can very easily cache queries using the cachedwithin= attribute of cfquery Like so: cfquery datasource=mydata name=myquery cachedwithin=#createTimeSpan( 1, 0, 0, 0 )# SELECT COUNT( * ) FROM myTable WHERE myDate '1900-01-01' /cfquery This will cache your query for one day. You could also put the result of the query into an application variable or something like that, but this way the query will only be cached if the query text is the same. M. Jeremy Bunton wrote: I have a query counting records in a 25 million plus database. Even with indexing and what not it takes about 25 seconds to run this query. (count * from table where date 19000101) Is there a way I could cache the query so that if it is ran in that same way it very quickly returns the full count. I.E. this is a dynamically build query so sometimes it will have a long where clause that I may be different than the straight just count everything thing like above. It seems to me that if that query has been ran one time in the same way that query should not have to recount the next time, and should just output the count. Jeremy ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235622 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Large count query caching
There is a pretty large number of options. Considering zip codes(43,000 of in the US), area code, state and about 16 other fields are available. I think what it does now will work, the main problem was with nothing selected, oddly enough the more ands in the where clause the faster the clustered index seems to go. I need oracle's bitmap indexes I think to do it right. I'm pretty sure my indexes are ok. Jeremy -Original Message- From: mark [mailto:[EMAIL PROTECTED] Sent: Friday, March 17, 2006 10:43 AM To: CF-Talk Subject: RE: Large count query caching Is there a finite number of options for a count? Even if the number is 50, you could run the queries late at night and cache the results for 24 hours? It wouldn't take any shorter time, but to the user it would be much better. Mark -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Friday, March 17, 2006 10:08 AM To: CF-Talk Subject: Re: Large count query caching If you were taking the route of a cached query then yes/no that you are wrong. If the count() is going to change based upon the where clause then you would have to have a single master cached query that pulled out everything possibly needed so that you could then do QoQ on that for the dynamic where clauses. That means that your master cached query is not pulling a count() and would probably be massive in space. I think it would be best to pursue solutions through the DB to speed things up. On 3/17/06, Jeremy Bunton [EMAIL PROTECTED] wrote: Yeah I thought about that also, but since all my queries, regardless of the ever changing where clause only return a count, never a full record set, I would think that the memory usage would be small or am I wrong? This machine sql 2005 has 4 gig of ram, but the data as a .csv was over 8 gig so I know I can't fit the whole record set in ram. Jeremy ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235628 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Large count query caching
I'll check that out, I am not using them now. Jeremy -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Friday, March 17, 2006 11:09 AM To: CF-Talk Subject: RE: Large count query caching If you cannot cache on the web server - make sure and bind the data using CFQUERYPARAM. This will enable the RDMBS to use a cached execution plan on it's end. I have a blog on why this is important. http://mkruger.cfwebtools.com/index.cfm?mode=aliasalias=cfqueryparam Secondly, change the * to the PK field of the table. This is largely for the same reason. Why make the DB server look up all your columns? It's an unecessary step and it will cost you in execution time - maybe not a lot, but when you are dealing with 25 million rows ever millisecond counts :) -Mark -Original Message- From: Jeremy Bunton [mailto:[EMAIL PROTECTED] Sent: Friday, March 17, 2006 8:28 AM To: CF-Talk Subject: Large count query caching I have a query counting records in a 25 million plus database. Even with indexing and what not it takes about 25 seconds to run this query. (count * from table where date 19000101) Is there a way I could cache the query so that if it is ran in that same way it very quickly returns the full count. I.E. this is a dynamically build query so sometimes it will have a long where clause that I may be different than the straight just count everything thing like above. It seems to me that if that query has been ran one time in the same way that query should not have to recount the next time, and should just output the count. Jeremy ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235634 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
save cfquery select statement to var
Hello, I have a pretty large cfquery with 30 or so cfif's building the where clause. What I want do is save the actual select statement generated by that cfquery so that I can then plug it in to bcp in sql server to extract the data. I have tried to wrap cfsave content both inside and outside the cfquery - inside I get an error, outside I get an empty var. Any ideas on how I can do this, I know someone else has to of needed to do this before. Thanks a lot Jeremy ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235430 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: save cfquery select statement to var
Great, yes I am using cf 7. I'll take a look at that. Thanks Jeremy -Original Message- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 15, 2006 9:27 AM To: CF-Talk Subject: Re: save cfquery select statement to var What version of cf are you using? If it is cf 7+, you can use the results attribute of cfquery to get the sql statement that ran. If not cf 7+, you are going to have to use the (undocumented) service factory to do it. On 3/15/06, Jeremy Bunton [EMAIL PROTECTED] wrote: Hello, I have a pretty large cfquery with 30 or so cfif's building the where clause. What I want do is save the actual select statement generated by that cfquery so that I can then plug it in to bcp in sql server to extract the data. I have tried to wrap cfsave content both inside and outside the cfquery - inside I get an error, outside I get an empty var. Any ideas on how I can do this, I know someone else has to of needed to do this before. Thanks a lot Jeremy ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235434 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: save cfquery select statement to var
That's a good idea also. I think the result attribute will be the ticket though. Thanks Jeremy -Original Message- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 15, 2006 9:28 AM To: CF-Talk Subject: Re: save cfquery select statement to var Also, a follow up, what you *can* do is create the query in a cfsave content outside of the query, saving it to a variable, and then just put that variable in the cfquery tags. Then you will be able to access that variable later on as well. If you aren't using cf 7, this may be your best option. On 3/15/06, Ryan Guill [EMAIL PROTECTED] wrote: What version of cf are you using? If it is cf 7+, you can use the results attribute of cfquery to get the sql statement that ran. If not cf 7+, you are going to have to use the (undocumented) service factory to do it. On 3/15/06, Jeremy Bunton [EMAIL PROTECTED] wrote: Hello, I have a pretty large cfquery with 30 or so cfif's building the where clause. What I want do is save the actual select statement generated by that cfquery so that I can then plug it in to bcp in sql server to extract the data. I have tried to wrap cfsave content both inside and outside the cfquery - inside I get an error, outside I get an empty var. Any ideas on how I can do this, I know someone else has to of needed to do this before. Thanks a lot Jeremy ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235435 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: maintaining state in multipage form
You could call a javascript function to submit the form, then boot off to the page in the href -Original Message- From: Christophe Maso [mailto:[EMAIL PROTECTED] Sent: Monday, March 13, 2006 8:33 AM To: CF-Talk Subject: Re: maintaining state in multipage form It sounds like a session variable containing an array of checkboxes and their selected values might be in order. Assuming the user has cookies enabled (or if you pass the session tokens on the URLs) this should be fairly simple to implement. -Justin I'd considered using a session var, but then it occurred to me that there's no way to save the checked values to a session list or array until the submit button has been clicked. I could start on page 1, check a few boxes, and then click on the link for page 2 (or 3 or 4). At that point, page 1's checked boxes have been forgotten. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235193 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
can one Submit button submit multiple forms in a specific order?
I need to be able to hit a submit button have it submit one form (that it is not in) then after that submit has been processed submit a second form (form the submit button is in). They have to be in order because processing in the first form is needed for the second one. I'm thinking I need a CF solution. I tried js, but it submits both more or less at the same time. Jeremy ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234451 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
javascript submit form and then location in same function
I have hrefs that call this function script type=text/javascript function submitandgo (url) { window.document.theform.submit(); window.document.location=url; } /script If I don't use the location portion it works fine, but it seems to boot off to the new page before the form submit. An suggestions? Is there a way in cf to submit a form and then do a cflocation. Perhaps I need some more js code in there. Jeremy -Original Message- From: Joe Ferraro [mailto:[EMAIL PROTECTED] Sent: Monday, February 20, 2006 12:39 PM To: CF-Talk Subject: onSessionEnd locking When accessing the application scope in the onSessionEnd function in Application.cfc should you lock in the scope of application or with a named lock? The reason I ask is because the documentation uses a named lock and the onSessionEnd function cannot reference the application and session scopes directly. Thanks, Joe ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232932 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: javascript submit form and then location in same function
That function gets called in the nav as you go from page to page. I have about 20 form pages each with a form called theform. I want to be able to have the user select the checkboxs and fill in the form fields ect they want then just click to another page and have that info saved without them having to hit a submit button then going to the nav. They have the option to hit the submit button, but a lot of users just want to select what they want on that page and go off to the next with just one click. Jeremy -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, February 20, 2006 1:30 PM To: CF-Talk Subject: RE: javascript submit form and then location in same function I have hrefs that call this function script type=text/javascript function submitandgo (url) { window.document.theform.submit(); window.document.location=url; } /script If I don't use the location portion it works fine, but it seems to boot off to the new page before the form submit. An suggestions? Is there a way in cf to submit a form and then do a cflocation. Perhaps I need some more js code in there. Submitting a form typically causes the location to change anyway. Also, I think that the location object is a child of the window object, not the document object. What exactly are you trying to accomplish? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232936 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: javascript submit form and then location in same function
I got it to work. It isn't as modular was I would like, but what I do is add a hidden form field to each form, set that value onclick using js to the value of the page I want it to go to, then submit the form and use a cflocation to boot off to that page based on the form value. Its pretty slick just more code to add to each page. Jeremy -Original Message- From: Josh Nathanson [mailto:[EMAIL PROTECTED] Sent: Monday, February 20, 2006 2:03 PM To: CF-Talk Subject: Re: javascript submit form and then location in same function Hi Jeremy, When you do window.document.theform.submit(), it will submit the form to whatever file you have in your form action attribute form action=foo.cfm, before it hits the window.document.location=url line in your js code. So, you'll probably need to do a little more work to send the user to the right place after the user clicks the nav. Or, try to make them submit the form, I think people are pretty used to that, rather then having them click a nav element. -- Josh - Original Message - From: Jeremy Bunton [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, February 20, 2006 10:20 AM Subject: javascript submit form and then location in same function I have hrefs that call this function script type=text/javascript function submitandgo (url) { window.document.theform.submit(); window.document.location=url; } /script If I don't use the location portion it works fine, but it seems to boot off to the new page before the form submit. An suggestions? Is there a way in cf to submit a form and then do a cflocation. Perhaps I need some more js code in there. Jeremy -Original Message- From: Joe Ferraro [mailto:[EMAIL PROTECTED] Sent: Monday, February 20, 2006 12:39 PM To: CF-Talk Subject: onSessionEnd locking When accessing the application scope in the onSessionEnd function in Application.cfc should you lock in the scope of application or with a named lock? The reason I ask is because the documentation uses a named lock and the onSessionEnd function cannot reference the application and session scopes directly. Thanks, Joe ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232944 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
tag to allow access to foxpro .dbf
Hello, I have a foxpro table that I can't open because its locked up by CF and its on a live server so I can't just stop the CF ODBC service. I was sure I heard of a tag that would break that connection so I can open that table and change what I need to. Its seems like I have used it in the past for an access file. Jeremy ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232434 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
ArrayAppend oddity
I have the code below doing this where 01011 is a zip code. So I would like the output to be 01018 as the appended value in the array but right now I am getting 1018 (leading 0 getting cut off) I tried listappend and it does the same thing. Val() and tostring() didn't seem to do much either. Any ideas? ArrayAppend(myArrayList2,01011+7); Jeremy ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232526 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: tag to allow access to foxpro .dbf
I ended up just restarting the odbc server service, it was the only way I could free it up. Jeremy -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Thursday, February 16, 2006 12:22 PM To: CF-Talk Subject: Re: tag to allow access to foxpro .dbf this function was never officially supported and has been removed from CFML with CF MX. I can beleive it, doesn't it flush ALL connections in ALL CF applications running? Something your provider will certainly not appreciate if you do it too aften ;-/ -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232528 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ArrayAppend oddity
Yeah I like that one best, I did the length check, but that seems alittle much. Jeremy -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Thursday, February 16, 2006 2:50 PM To: CF-Talk Subject: Re: ArrayAppend oddity Or just use numberFormat(01011+7, 0) in your expression to repad the athimetic result with zeros. cheers, barneyb On 2/16/06, Dave Watts [EMAIL PROTECTED] wrote: I have the code below doing this where 01011 is a zip code. So I would like the output to be 01018 as the appended value in the array but right now I am getting 1018 (leading 0 getting cut off) I tried listappend and it does the same thing. Val() and tostring() didn't seem to do much either. Any ideas? ArrayAppend(myArrayList2,01011+7); CF doesn't keep leading zeros for numeric values. You're treating the zip code as a numeric value, by using it as an operand in numeric addition. So, naturally, you're losing the leading zero. Offhand, I'm not sure how I'd go about doing this - you don't typically use zip codes in numeric operations - but you could write a function that performs the numeric addition, then checks the length of the value to see if it's four or five digits. If it's four, you can reasonably assume that the first character was a zero before the addition. You could then plop it back on the front of the value. Dave Watts, CTO, Fig Leaf Software -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232561 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Saving form vars from page to page
Hello, Its been a while since I have done any cfing and I have to build an app with quite a few forms. Some forms will have a lot of check boxes, some regular text fields and some will be drop downs. I need to be able to save the selected items or field values on any given form page (session I am guessing) and have them be there later to be altered should the user need to change their mind. I need values to be there instead of clear as a person jumps between 20-30 different pages with different forms. How could this be done, I don't think there was a straight forward way in MX6 but maybe 7 has something I can use. Jeremy ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232098 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Saving form vars from page to page
Very cool I will look at it. I knew tthere had to be something since a lot of people do it, but I didn't know how. What I am building is an app that lets people select a given mailing list then build a query to get the names based on 51 state check boxes, zips, radius, gender and so on and people will for sure want to change the criteria around and that may have been 3 pages back and therefore must still be checked when they go back. Jeremy -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Monday, February 13, 2006 11:12 AM To: CF-Talk Subject: RE: Saving form vars from page to page Jeremy... Read over this thread on Sitepoint: http://www.sitepoint.com/forums/showthread.php?t=344244highlight=forta I post at the bottom with a link to a custom tag coded by Ben Forta which makes this VERY easy. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Jeremy Bunton [mailto:[EMAIL PROTECTED] Sent: Monday, February 13, 2006 7:29 AM To: CF-Talk Subject: Saving form vars from page to page Hello, Its been a while since I have done any cfing and I have to build an app with quite a few forms. Some forms will have a lot of check boxes, some regular text fields and some will be drop downs. I need to be able to save the selected items or field values on any given form page (session I am guessing) and have them be there later to be altered should the user need to change their mind. I need values to be there instead of clear as a person jumps between 20-30 different pages with different forms. How could this be done, I don't think there was a straight forward way in MX6 but maybe 7 has something I can use. Jeremy ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232111 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
VB.net equivalent of coldfusion's Evaluate
Any idea's. I can't seem to find anything in the MSDE. I know there has to be something similar, but I just can't find it. I'm trying to dim an array value as a stringreader object. Ex. Dim ARprmfile(T, 0) As StreamReader = New StreamReader(Args(0)) Thanks Jeremy ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214004 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Gene 6 FTP Server vs Serv-U Secure?
I've used serv-U in the past and really liked it, now I am using Titan and WS_FTP Server, WS is good but I seem to recall serv U had more options. JLB -Original Message- From: Damien McKenna [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 29, 2005 10:35 AM To: CF-Talk Subject: OT: Gene 6 FTP Server vs Serv-U Secure? I'm looking for a secure FTP server and was wondering if anyone had experience with either Gene 6 FTP Server (Standard) or Serv-U Secure? I've noticed that some things are easier in one over another, e.g. G6FTP does virtual directories easily. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210889 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
time conversion
I have a form that collects 3 pieces of time data each as separate form vars. Hour, min and AM/PM in the format of 03 04 PM. I need to convert that to military time so here 15:04. I have looked at createtime() but it seems to not have a way to handle the AM/PM data. How do you all handle this? Jeremy ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209153 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Javascript to coldfusion
I want to set a javascript var to a coldfusion variable, what I am doing looks like below. The value being a true false Boolean. I keep getting an error that doit is undefined in CF. I've gone from coldfusion to JS before, but not the other way around. Thanks Jeremy script var doit = confirm(Are you sure you want to delete?); cfset didit = doit /script ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206057 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Get column names with query
Hello, I know there is a way to do this and I looked around and can't find it. How would I go about getting the column/fieldnames from a query. I'm just doing a select * from table and I want to label the fields as they are in the SQL server db. Thanks Jeremy ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205843 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Get column names with query
Yes that works, Thanks JLB -Original Message- From: JediHomer [mailto:[EMAIL PROTECTED] Sent: Friday, May 06, 2005 10:07 AM To: CF-Talk Subject: Re: Get column names with query They should be returned in myQuery.ColumnList HTH On 5/6/05, Jeremy Bunton [EMAIL PROTECTED] wrote: Hello, I know there is a way to do this and I looked around and can't find it. How would I go about getting the column/fieldnames from a query. I'm just doing a select * from table and I want to label the fields as they are in the SQL server db. Thanks Jeremy ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205847 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Wrap custom tag
I'm currently stuck using MX 6.0 and was wondering if there is a custom tag out there that will function like the wrap() function in 6.1. After searching the Maco site I turned up nothing, but I hear there is such a thing. Jeremy ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190906 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Wrap custom tag
I want to and we do have it on a few other boxes, but the one this app is running on has yet to updated and might not be for a few months yet. I can't recall where I heard or saw it, but I'm sure I have heard of a custom tag that simulates the wrap() in 6.1. Jer -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 18, 2005 9:08 AM To: CF-Talk Subject: RE: Wrap custom tag If at all possible, you want to move to 6.1, there's a number of issues that were resolved with that update. - Calvin -Original Message- From: Jeremy Bunton [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 18, 2005 8:50 AM To: CF-Talk Subject: Wrap custom tag I'm currently stuck using MX 6.0 and was wondering if there is a custom tag out there that will function like the wrap() function in 6.1. After searching the Maco site I turned up nothing, but I hear there is such a thing. Jeremy ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190909 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Where to place .vtm tag insight files
Hello, I use Dreamweaver 2004 for all my Cf'in and have some .vtm tag insight files I need to add. What folder do I need to place those in? It seems pretty straight forward in homesite, but I can't find the equivalent in DW. JB ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189631 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Printing to label Printer in CF
Hello, I have never tried to do this before so here goes. I need to print a label from a cf app that will contain various information Client name, job number, due date, client code, ect. This is part of our project management app and the labels will be used for folders. Any pointers on how to format for a label? Jeremy ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189529 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Printing to label Printer in CF
Cool thanks all, I'll take a peek at it. -Original Message- From: Scott Stroz [mailto:[EMAIL PROTECTED] Sent: Thursday, January 06, 2005 11:53 AM To: CF-Talk Subject: Re: Printing to label Printer in CF On Thu, 6 Jan 2005 08:34:35 -0800, Bryan Stevenson [EMAIL PROTECTED] wrote: I'm pretty sure I saw someone mention a few weeks back that there is an Avery label specific CF tag in the Developers Exchange at MMs site. http://www.macromedia.com/cfusion/exchange/index.cfm#view=sn106viewName=Exc hange%20Search%20Detailsloc=en_usauthorid=29645457page=0scrollPos=0subc atid=0snid=sn106itemnumber=0extid=1002428catid=0 -- Scott Stroz Boyzoid.com ___ Some days you are the dog, Some days you are the tree. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189542 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Printing to label Printer in CF
Has anyone used that tag under mX6 or 6.1? Jeremy -Original Message- From: Scott Stroz [mailto:[EMAIL PROTECTED] Sent: Thursday, January 06, 2005 11:53 AM To: CF-Talk Subject: Re: Printing to label Printer in CF On Thu, 6 Jan 2005 08:34:35 -0800, Bryan Stevenson [EMAIL PROTECTED] wrote: I'm pretty sure I saw someone mention a few weeks back that there is an Avery label specific CF tag in the Developers Exchange at MMs site. http://www.macromedia.com/cfusion/exchange/index.cfm#view=sn106viewName=Exc hange%20Search%20Detailsloc=en_usauthorid=29645457page=0scrollPos=0subc atid=0snid=sn106itemnumber=0extid=1002428catid=0 -- Scott Stroz Boyzoid.com ___ Some days you are the dog, Some days you are the tree. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189543 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Printing to label Printer in CF / Selecting the printer?
How about this one. We have 3 printers here with one being our main printer and one with nicer color one and then we will soon have a little label printer. Everyone pretty much has their default printer set to the laser. So the question is - is there a method I could use to have a label printer on the label printer when the user hits the print this label button? With out them having to change or select a printer. Jeremy -Original Message- From: Scott Stroz [mailto:[EMAIL PROTECTED] Sent: Thursday, January 06, 2005 11:53 AM To: CF-Talk Subject: Re: Printing to label Printer in CF On Thu, 6 Jan 2005 08:34:35 -0800, Bryan Stevenson [EMAIL PROTECTED] wrote: I'm pretty sure I saw someone mention a few weeks back that there is an Avery label specific CF tag in the Developers Exchange at MMs site. http://www.macromedia.com/cfusion/exchange/index.cfm#view=sn106viewName=Exc hange%20Search%20Detailsloc=en_usauthorid=29645457page=0scrollPos=0subc atid=0snid=sn106itemnumber=0extid=1002428catid=0 -- Scott Stroz Boyzoid.com ___ Some days you are the dog, Some days you are the tree. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189552 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Printing to label Printer in CF / Selecting the printer?
We keep our servers at a co-location facility and the printer will be here in corporate headquarters. I guess I will just have to expect people to select the proper printer when they are printing a new label. -Original Message- From: Matthew Small [mailto:[EMAIL PROTECTED] Sent: Thursday, January 06, 2005 2:15 PM To: CF-Talk Subject: RE: Printing to label Printer in CF / Selecting the printer? You can do it if the printer is networked with the cf server. I've done it. Matthew Small Web Developer American City Business Journals 704-973-1045 [EMAIL PROTECTED] -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Thursday, January 06, 2005 2:12 PM To: CF-Talk Subject: Re: Printing to label Printer in CF / Selecting the printer? You CAN print to a specific printer IF: -printer is connected to the CF server I've never done it...but I've seen lots of folks do it Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com - Original Message - From: Damien McKenna [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, January 06, 2005 11:09 AM Subject: RE: Printing to label Printer in CF / Selecting the printer? You cannot control the user's computer in this regard. Think about it, would you really want some random website running commands that takes over your computer like that? -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h -Original Message- From: Jeremy Bunton [mailto:[EMAIL PROTECTED] Sent: Thursday, January 06, 2005 1:33 PM To: CF-Talk Subject: Printing to label Printer in CF / Selecting the printer? How about this one. We have 3 printers here with one being our main printer and one with nicer color one and then we will soon have a little label printer. Everyone pretty much has their default printer set to the laser. So the question is - is there a method I could use to have a label printer on the label printer when the user hits the print this label button? With out them having to change or select a printer. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189563 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cffile read to read JUST the top line of the txt file.
Hello, I want to use cffile to read just the top line (header line with field names) of a very large .csv file, say 5 million records. Is there a way to just read the top record into the variable in the cffile tag, with out having to read the whole file. Jeremy ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186077 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cffile read to read JUST the top line of the txt file.
Ahh I see that looks fairly straight forward. I thought about writing a vb.net app but it seems overkill to cfexecute a .exe to read just the top line of a file. Jeremy -Original Message- From: Joe Rinehart [mailto:[EMAIL PROTECTED] Sent: Friday, December 03, 2004 10:38 AM To: CF-Talk Subject: Re: cffile read to read JUST the top line of the txt file. Yep - this should get you started: cfscript filename = /path/to/file.csv; fileReader = createObject(java, java.io.FileReader); fileReader = fileReader.init(filename); lineReader = createObject(java,java.io.LineNumberReader); lineReader = lineReader.init(fileReader); line = lineReader.readLine(); /* this'd keep reading in lines while (isDefined(line)) { lineCount = lineCount + 1; // do something here with the data in variable line line = lineReader.readLine(); } */ /cfscript cfoutput#line#/cfoutput -joe On Fri, 3 Dec 2004 15:55:01 +0100, Pascal Peters [EMAIL PROTECTED] wrote: No, but I think you can do it with java. -Original Message- From: Jeremy Bunton [mailto:[EMAIL PROTECTED] Sent: 03 December 2004 15:52 To: CF-Talk Subject: cffile read to read JUST the top line of the txt file. Hello, I want to use cffile to read just the top line (header line with field names) of a very large .csv file, say 5 million records. Is there a way to just read the top record into the variable in the cffile tag, with out having to read the whole file. Jeremy ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186088 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFFile or CFDirectory?
That would be cffile. -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Thursday, December 02, 2004 9:36 AM To: CF-Talk Subject: CFFile or CFDirectory? I'm using cfdirectory successfully to list the directory names and then list them in a drop-down menu. Now after a user selects the directory name I would like it to load a specific file in that directory. Is that done with cffile or again using cfdirectory in some other way? Thanks as always. Robert O. ô¿ô Here is my code so far: cfdirectory directory=#GetDirectoryFromPath(GetTemplatePath())# name=myDirectory form action=select_directory.cfm method=post name=dropdown select name=name style=font-family: Verdana; font-size: 8pt; color: #80; font-weight:bold; background-color:#EBEBEB onchange=this.form.submit(); option value=Select Trial/option cfoutput query=myDirectory CFIF name NEQ '_vti_cnf' and name NEQ 'application.cfm' and name NEQ '..' and name NEQ '.' and name NEQ 'MTManager' and name NEQ 'err_req.cfm' and name NEQ 'err_valid.cfm' and name NEQ 'scheduled_trial_email' and name NEQ 'template' option value=#name# #name#/option /cfif /cfoutput /select /form ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185927 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cfexecute and vb.net return
Hello, I have a vb.net console/commandline app that prompts for various inputs after hitting the return key. Somewhat like this Input file (csv): C:/test/my.csv then return key is pressed Outputfile (csv): C:/test/new.csv return again First header name: addressone return You get the idea. I want to call this from CF using cfexecute by can't get the returns figured out. I have tried the below and using /n. Anyone have any example of a cfexecute with arguments like I need. cfexecute name = C:\test\fixed2csv.exe arguments = C:\test\fixedfile.txt C:\test\mynewcsv22.csv 3 fname 1 10 lname 11 20 zip 21 26 /cfexecute And cfexecute name = C:\test\fixed2csv.exe arguments = C:\test\fixedfile.txt C:\test\mynewcsv22.csv 3 Fname /cfexecute Jeremy ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183974 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfexecute and vb.net return
So I'm guessing this isn't possible with cfexecute and I should go the route of altering my commandline app. -Original Message- From: Jeremy Bunton [mailto:[EMAIL PROTECTED] Sent: Thursday, November 11, 2004 1:25 PM To: CF-Talk Subject: cfexecute and vb.net return Hello, I have a vb.net console/commandline app that prompts for various inputs after hitting the return key. Somewhat like this Input file (csv): C:/test/my.csv then return key is pressed Outputfile (csv): C:/test/new.csv return again First header name: addressone return You get the idea. I want to call this from CF using cfexecute by can't get the returns figured out. I have tried the below and using /n. Anyone have any example of a cfexecute with arguments like I need. cfexecute name = C:\test\fixed2csv.exe arguments = C:\test\fixedfile.txt C:\test\mynewcsv22.csv 3 fname 1 10 lname 11 20 zip 21 26 /cfexecute And cfexecute name = C:\test\fixed2csv.exe arguments = C:\test\fixedfile.txt C:\test\mynewcsv22.csv 3 Fname /cfexecute Jeremy ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184039 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
6.1 and 2003 server standard - iis 6
Hello, I am building a dev/test box with 2003 server and iis 6 running 6.1. The install seemed to go fine. I am moving some sites over to the new machine and one has the .htm extension mapped to be processed by CF. I did this on 2000 server but ccan't recall what i did and am sure it is deifferent now. I think I had to add an isapi mapping and change an xml file. What is that procedure on 2003 and i recall someone mentioning a nasty cache problem on 2003 that also requires a change in an xml file to fix. ANy help would be appreciated. THanks a lot Jeremy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: 6.1 and 2003 server standard - iis 6
I did that and i get this error Either the Macromedia application server is unreachable or it does not have a mapping to process this request. Is there not an xml file that needs to be unpdated also? Jeremy On Wed, 14 Jul 2004 13:54:22 -0400 Howie Hamlin [EMAIL PROTECTED] wrote: Open the MMC and right-click on a single web site or the global web sites item. Click on the Home Directory tab and then the Configuration button. You will see all of the mappings for the web site. Copy the mapping for .CFM to a .HTM entry. HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server PrismAV - Virus scanning for ColdFusion applications Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Jeremy Bunton To: CF-Talk Sent: Wednesday, July 14, 2004 1:41 PM Subject: 6.1 and 2003 server standard - iis 6 Hello, I am building a dev/test box with 2003 server and iis 6 running 6.1. The install seemed to go fine. I am moving some sites over to the new machine and one has the .htm extension mapped to be processed by CF. I did this on 2000 server but ccan't recall what i did and am sure it is deifferent now. I think I had to add an isapi mapping and change an xml file. What is that procedure on 2003 and i recall someone mentioning a nasty cache problem on 2003 that also requires a change in an xml file to fix. ANy help would be appreciated. THanks a lot Jeremy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: 6.1 and 2003 server standard - iis 6
Ahh that's what it was...It was driving me crazy. I did this.. notice the order, apparently it makes a difference bc that did not work. Jeremy servlet-mapping servlet-nameCfmServlet/servlet-name url-pattern*.htm/*/url-pattern /servlet-mapping servlet-mapping servlet-nameCfmServlet/servlet-name url-pattern*.htm*/url-pattern /servlet-mapping On Wed, 14 Jul 2004 15:28:59 -0400 Tony Weeg [EMAIL PROTECTED] wrote: shite... dont forget a closing one for this too... it requires another one...so...just like this for each type of extension... servlet-mapping servlet-nameCfmServlet/servlet-name url-pattern*.html/url-pattern /servlet-mapping servlet-mapping servlet-nameCfmServlet/servlet-name url-pattern*.html/*/url-pattern /servlet-mapping sorry, i forgot the closing one. tw On Wed, 14 Jul 2004 15:17:36 -0400, Tony Weeg [EMAIL PROTECTED] wrote: .html files in CFMX Open the C:\CFusionMX\wwwroot\WEB-INF\web.xml . You can modify the extension mappings by adding these lines: servlet-mapping servlet-nameCfmServlet/servlet-name url-pattern*.html/url-pattern /servlet-mapping and why...doug, you askbecause some people like to have .html/.htm and other extensions for cold fusion applications. no other reason. i have .revolution, .tony, .whatever mapped to it. just because i can. and it makes my site unique! tw On Wed, 14 Jul 2004 14:11:21 -0500, Doug White [EMAIL PROTECTED] wrote: Why on earth would you place the extra load on the server by making CF handle htm files?I have seen this once before when a client wanted that set up on a shared server.IIS 6.0 handles htm files so much easier and with a lot less CPU load. Doug - Original Message - From: Jeremy Bunton To: CF-Talk Sent: Wednesday, July 14, 2004 12:41 PM Subject: 6.1 and 2003 server standard - iis 6 Hello, I am building a dev/test box with 2003 server and iis 6 running 6.1. The install seemed to go fine. I am moving some sites over to the new machine and one has the .htm extension mapped to be processed by CF. I did this on 2000 server but ccan't recall what i did and am sure it is deifferent now. I think I had to add an isapi mapping and change an xml file. What is that procedure on 2003 and i recall someone mentioning a nasty cache problem on 2003 that also requires a change in an xml file to fix. ANy help would be appreciated. THanks a lot Jeremy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: 6.1 and 2003 server standard - iis 6
Ok I mapped the extension and changed teh xml file and coldfusion seems to be seeing the htm as a cfm file but when it as the .htm extension i get this error / by zero when i change it back to .cfm no error and it works fine. What could I be missing? Thanks a lot Jeremy Ken Ferguson [EMAIL PROTECTED] wrote: It's not that big a deal Doug. I've done the same thing because I don't WANT people seeing blah.cfm. As a matter of fact I usually create a new extension every time. If my client is BMW, I'll make all the files into index.bmw or home.bmw or whatever. They're actually cfm files, but I just want the extensions to appear differently. _ From: Doug White [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 14, 2004 2:11 PM To: CF-Talk Subject: Re: 6.1 and 2003 server standard - iis 6 Why on earth would you place the extra load on the server by making CF handle htm files?I have seen this once before when a client wanted that set up on a shared server.IIS 6.0 handles htm files so much easier and with a lot less CPU load. Doug - Original Message - From: Jeremy Bunton To: CF-Talk Sent: Wednesday, July 14, 2004 12:41 PM Subject: 6.1 and 2003 server standard - iis 6 Hello, I am building a dev/test box with 2003 server and iis 6 running 6.1. The install seemed to go fine. I am moving some sites over to the new machine and one has the .htm extension mapped to be processed by CF. I did this on 2000 server but ccan't recall what i did and am sure it is deifferent now. I think I had to add an isapi mapping and change an xml file. What is that procedure on 2003 and i recall someone mentioning a nasty cache problem on 2003 that also requires a change in an xml file to fix. ANy help would be appreciated. THanks a lot Jeremy _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
query troubles
I have a table that looks like this contactno, orddate, amount 0013352004012299.23 0013352004120212.23 11233320031201100.23 The query I am useing now looks like this, in foxpro by the way. SELECT contactno, orddate, amount as ldol FROM ordertemp4b; where contactno in (select contactno, MAX(orddate) from ordertemp4b); GROUP BY contactno,orddate,amount HAVING orddate=MAX(orddate) I need to pull the one record for each unique contactno with the most recent date. From the table above it would be (ie just one record for each contactno. 0013352004120212.23 11233320031201100.23 I'm having alot of trouble any help would be great. Thanks alot Jeremy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: query troubles
There isn't one yet, it's a temp table _ From: G [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 13, 2004 4:24 PM To: CF-Talk Subject: Re: query troubles Jeremy, what is the primary key for the ordertemp4b table? - Original Message - From: Jeremy Bunton To: CF-Talk Sent: Tuesday, July 13, 2004 2:31 PM Subject: query troubles I have a table that looks like this contactno, orddate, amount 0013352004012299.23 0013352004120212.23 11233320031201100.23 The query I am useing now looks like this, in foxpro by the way. SELECT contactno, orddate, amount as ldol FROM ordertemp4b; where contactno in (select contactno, MAX(orddate) from ordertemp4b); GROUP BY contactno,orddate,amount HAVING orddate=MAX(orddate) I need to pull the one record for each unique contactno with the most recent date. From the table above it would be (ie just one record for each contactno. 0013352004120212.23 11233320031201100.23 I'm having alot of trouble any help would be great. Thanks alot Jeremy _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
cfinclude meta info?
Is it a bad idea to cfinclude meta tags, does it hurt search engine performance. ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
MX and Page caching
I had a directory set up called new and in that folder I had a page called test.cfm. I deleted that page and the entire directory new and if I browse to that directory and page - it still shows up minus the images. I just don't get it. I mean I deleted the entire folder. I went and look in the administrator to make sure trusted cache was not checked and I don't see anything else in there that would help me. Is this just a bug, I let a few people see that folder and now I don't want them to, yet the pages still show up. I have yet to install any of the updaters, will today, but I don't think that is going to help me out. Any suggestions. I don't recall cf5 ever doing this. JLB ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Search and count occurrences of a word in a template
I have a .cfm page that I would like to find and display the number of times a certain word appears. I have looked at some of the functions like find() and the like but they don't seem to be what I am looking for, or maybe I just am not seeing how I would use them to search a page and count the occurrences of a specific word. JLB ~| 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. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MDAC 2.7
Well I installed 2.7 sp2 Or which ever is the newest. This is the first MDAC I have installed since putting 2kpro on my machine. This morning I uninstalled my office 2000 and installed it again hoping it would fixe my problem and get me back to where I was before 2.7,but no still not working. I still can't verify any of my access DNS's. I installed the jet 4 also and still no go. I checked at home on my 98 machine which works fine and is using a different odbcjt32.dll, older one. I copied it and replaced the one here and still nothing. I have pretty much exhausted all my ideas is there anything else I should do or anywhere else I should look. I don't want to have to spend a whole day plus starting over on my machine but that is what it is looking like. jeremy -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 4:31 AM To: CF-Talk Subject: RE: MDAC 2.7 Yep, Component Checker annoyingly does that if you have access to the registry, you can tell exactly which MDAC you are running by viewing this key : HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataAccess Look for FullIntallVer. N -Original Message- From: Jeremy Bunton [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 22:04 To: CF-Talk Subject: RE: MDAC 2.7 Actually when I run the Component Checker it says I have more than one MDAC configured for my system. So I think select the newest one 2.7 SP1(WinXP) and run the analyze and it says 10 file versions mismatched, one looks like so. odbccp32.cpl,File,Field 'FileVersion' mismatch: Expect '3.520.7713.0' Got '3.520.9001.0',Error So how was I supposed to fix this. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 4:57 PM To: CF-Talk Subject: RE: MDAC 2.7 I tried that and still no luck. What do you think about me reinstalling office 2000. I would think that would reinstate the old drivers. Can you connect to your Access databases via the ODBC Control Panel? Have you run the Component Checker to see if there are any problems with MDAC? 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 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
MDAC 2.7
Hello, I just installed MDAC 2.7 on my win 2k pro machine with CF4.5. Everythign seemed fine during the install, but now I can't connect to any of my data sources. None of them will verify in the administrator. Currenly they are all access DB's. Any ideas. Any way to uninstall MDAC 2.7. Every thing was fine before, I just thought I would keep up with the times. I guess I should of left well enought alone. Jeremy -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 11:40 AM To: CF-Talk Subject: Re: Clearing Cached Pages Dave, I encountered a problem on Friday where a user continued to see an old page, even after I had updated it. I realize this has to due with the users cache, but am wondering if anyone knows of a way/command to clear the cache or prevent a site from caching. Any help is appreciated To stop a page from being cached by a users browser you need to use the following HTML meta tags in your pages : META http-equiv='expire' content='0' META http-equiv='pragma' content='no-cache' I suspect that if the user has set their internet options to never check for page changes then you will be a bit stuck, but any of the other settings should pick up the addition of these tags and clear their cache or at least force their browser to load a new copy of the page. Regards Stephen == CF-Europe http://www.cf-europe.org/ Olymia Conference Centre, London 29-30 May 2003 Keynote by Ben Forta and Tim Buntel ~| 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: MDAC 2.7
I tried that and still no luck. What do you think about me reinstalling office 2000. I would think that would reinstate the old drivers. jeremy -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 3:20 PM To: CF-Talk Subject: RE: MDAC 2.7 I just installed MDAC 2.7 on my win 2k pro machine with CF4.5. Everythign seemed fine during the install, but now I can't connect to any of my data sources. None of them will verify in the administrator. Currenly they are all access DB's. Any ideas. Any way to uninstall MDAC 2.7. You may need to download and install the latest Jet service pack: http://www.microsoft.com/downloads/details.aspx?FamilyID=af693865-2bab-4ae5- b001-42840473ef39DisplayLang=en MDAC 2.6 and higher don't come with Jet drivers, or other desktop database drivers. If you need to diagnost MDAC problems, or need to uninstall MDAC, you'll need the MDAC Component Checker: http://www.microsoft.com/downloads/details.aspx?FamilyId=8F0A8DF6-4A21-4B43- BF53-14332EF092C9displaylang=en 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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MDAC 2.7
Actually when I run the Component Checker it says I have more than one MDAC configured for my system. So I think select the newest one 2.7 SP1(WinXP) and run the analyze and it says 10 file versions mismatched, one looks like so. odbccp32.cpl,File,Field 'FileVersion' mismatch: Expect '3.520.7713.0' Got '3.520.9001.0',Error So how was I supposed to fix this. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 4:57 PM To: CF-Talk Subject: RE: MDAC 2.7 I tried that and still no luck. What do you think about me reinstalling office 2000. I would think that would reinstate the old drivers. Can you connect to your Access databases via the ODBC Control Panel? Have you run the Component Checker to see if there are any problems with MDAC? 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 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
ASP.NET
Hello, Odd spot to ask this question but here goes. I am CF user have been for a few years now, but I wishing to branch out a little and widen my knowledge to the use of asp.net. Not that I am leaving CF. I have been looking on amazon for books and don't really see anything that stands out to me. I have done just a little bit of .asp a few years back but none since so I am looking for something that fits my lack of asp knowledge. Right now ASP.NET Unleashed seems to be a good choice. I'll definitely be heading the vb direction. Any recommendations from people that use to be in my shoes. Jeremy -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 1:29 PM To: CF-Talk Subject: Dreamweaver changing code on me I've been gradually moving to DreamweaverMX as my web IDE... just because. Today I was writing (hand coding) a form in code-view. I saved it to my web server and tried running it - didn't work correctly. Looked at the HTML source... WTF - what's all this garbage in here? I opened the file up in CFstudio and it appears that dreamweaver took the liberty of putting it's own tags in there. This is really bad for me... how do I set dreamweaver to save ONLY the code I've written in code view. I need to turn off its proprietary mark-up. Here's what it converted a simple xfa variable into: MM:BeginLock translatorClass=MM_COLDFUSION type=DynData depFiles= orig=%23xfa.pageDescription%23 MM_DYNAMIC_CONTENT SOURCE=xfa.pageDescription DYNAMICDATA=1MM:DECORATION HILITECOLOR=Dyn Untranslated Color{xfa.pageDescription}/MM:DECORATION/MM_DYNAMIC_CONTENTMM:EndLock Help!! Adam. ps... the buttons in my toolbars are all greyed out... CFMLBasic, CFMLflow, CFMLAdvanced, etc. Is there a reason for this? ~| 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: ASP.NET
Any site in particular I should look at. -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 2:50 PM To: CF-Talk Subject: RE: ASP.NET Jeremy: I'm an ASP developer who's dabbling w/ CF, and I can safely recommend any of the Wrox books. I got started on that, and it was a great tool. Granted, since then, there are so many resources on the web for learning ASP ASP.net, that you almost don't need to buy a book. HTH! Scott -Original Message- From: Jeremy Bunton [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 2:38 PM To: CF-Talk Subject: ASP.NET Hello, Odd spot to ask this question but here goes. I am CF user have been for a few years now, but I wishing to branch out a little and widen my knowledge to the use of asp.net. Not that I am leaving CF. I have been looking on amazon for books and don't really see anything that stands out to me. I have done just a little bit of .asp a few years back but none since so I am looking for something that fits my lack of asp knowledge. Right now ASP.NET Unleashed seems to be a good choice. I'll definitely be heading the vb direction. Any recommendations from people that use to be in my shoes. Jeremy -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 1:29 PM To: CF-Talk Subject: Dreamweaver changing code on me I've been gradually moving to DreamweaverMX as my web IDE... just because. Today I was writing (hand coding) a form in code-view. I saved it to my web server and tried running it - didn't work correctly. Looked at the HTML source... WTF - what's all this garbage in here? I opened the file up in CFstudio and it appears that dreamweaver took the liberty of putting it's own tags in there. This is really bad for me... how do I set dreamweaver to save ONLY the code I've written in code view. I need to turn off its proprietary mark-up. Here's what it converted a simple xfa variable into: MM:BeginLock translatorClass=MM_COLDFUSION type=DynData depFiles= orig=%23xfa.pageDescription%23 MM_DYNAMIC_CONTENT SOURCE=xfa.pageDescription DYNAMICDATA=1MM:DECORATION HILITECOLOR=Dyn Untranslated Color{xfa.pageDescription}/MM:DECORATION/MM_DYNAMIC_CONTE NTMM:EndLock Help!! Adam. ps... the buttons in my toolbars are all greyed out... CFMLBasic, CFMLflow, CFMLAdvanced, etc. Is there a reason for this? ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Correct CFFILE Syntax for uploading PDF: Accept = document/pdf ???
May be helpful. http://www.asahi-net.or.jp/en/guide/cgi/mimetype.html jeremy www.jeremybunton.com ~| 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
RE: [offtopic] Javascript to open a url in another frame
Can you not just use the target attribute of the link. a href=what.htm target=framenamesomelink/a -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 1:40 PM To: CF-Talk Subject: [offtopic] Javascript to open a url in another frame Hello All, Being a little dense today can anyone refresh my memory as to how you open up a link in another frame ? Is it Parent.framename.location.href = url; Or Parent.frames[1].location.href = url; Basically I just want a link from one frame to open in another. Any ideas ? -Cheers, Daz ~| 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
RE: cfif does not contain for file input
I'll give the cftry method a go this morning and see how it works. thanks -Original Message- From: Ewok [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 19, 2003 9:16 PM To: CF-Talk Subject: Re: cfif does not contain for file input This should work just fine. cftry cffile action=UPLOAD destination=C:\Inetpub\wwwroot\GLABNEW\projectsnew nameconflict=overwrite filefield=filea accept=image/gif,image/pjpeg,image/jpg,image/jpeg cfcatch cflocation url=gaddproject.cfm?error=yes /cfcatch /cftry but if you instist on your cfif method try. cfif NOT findnocase(.gif, Form.filea) AND NOT findnocase(.jpg, Form.filea) or cfif right(Form.filea, 3) NEQ gif AND right(Form.filea, 3) NEQ jpg or cfif listlast(form.filea, .) NEQ gif AND listlast(form.filea, .) NEQ jpg ...sorry, got carried away heh - Original Message - From: Jeremy Bunton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 16, 2003 9:45 AM Subject: cfif does not contain for file input Hello, I am trying to do something like bleow before I do a file upload to check for an extension and it always hits the cflocation. Makes me think maybe the file feild is not being read properly. If I take the cfif out it uploads fine. cfif Form.filea does not contain .gif and Form.filea does not contain .jpg and Form.filea does not contain .jpeg cflocation url=gaddproject.cfm?error=yes cfelse cffile action=UPLOAD destination=C:\Inetpub\wwwroot\GLABNEW\projectsnew nameconflict=overwrite filefield=filea /cfif I also tried the accept=image/gif,image/jpg, image/jpeg in the cffile but for some reason it would throw an error on jpeg uploads, so i fugured the above would work. Jeremy ~| 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
cfif does not contain for file input
Hello, I am trying to do something like bleow before I do a file upload to check for an extension and it always hits the cflocation. Makes me think maybe the file feild is not being read properly. If I take the cfif out it uploads fine. cfif Form.filea does not contain .gif and Form.filea does not contain .jpg and Form.filea does not contain .jpeg cflocation url=gaddproject.cfm?error=yes cfelse cffile action=UPLOAD destination=C:\Inetpub\wwwroot\GLABNEW\projectsnew nameconflict=overwrite filefield=filea /cfif I also tried the accept=image/gif,image/jpg, image/jpeg in the cffile but for some reason it would throw an error on jpeg uploads, so i fugured the above would work. Jeremy ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfoutput formatting
I have an output block that looks like so, tr tdimg src=images/spacer.gif width=71 height=1 alt= border=0/td cfoutput query=getclients td valign=top width=26 class=copyinput class=copy name=theid type=checkbox value=#id#/td td valign=top width=200 class=copy#UCase(cusername)#br(#cpassword#)/td /cfoutput tdimg src=images/spacer.gif width=85 height=1 alt= border=0/td /tr After the cfoutput kicks out 4 records I need a new tr/tr to be created and then show the next 4 records in 4 more td's and so forth instead of getting one row with 120 cells in it. Maybe something with the cfoutputs on the out side of the tr and a loop inside or something. JLB ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfoutput formatting
Ahh yes many thanks that seems to work well. JLB -Original Message- From: Scott Brady [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 1:06 PM To: CF-Talk Subject: Re: cfoutput formatting I use mod to do this... table tr cfoutput query=getReviews td #UCase(cusername)#br(#cpassword#) cfif (currentRow mod 4) eq 0 /tr tr /cfif /cfoutput /tr /table (I think you're missing the closing /td tag) One suggestion I'd add to the above is after you get out of the loop, you might need to pad the last row if the query doesn't return a multiple of 4 rows: cfif (currentRow mod 4) eq 0 /tr tr /cfif /cfoutput !--- This should get you the number of cells you need to add -- cfset padCells = 4 - getReview.RecordCount MOD 4 cfif padCells LT 4 cfloop from=1 to=#padCells# td nbsp; /td /cfloop /cfif /tr /table Scott Brady http://www.scottbrady.net/ ~| 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
submit cfform without submit button
Hello all, I know this isn't strictly a CF issue but I am using CF at the momeny so here we go. I have a simple form with two text fields one for username and one for password. Here is the code. cfform action=checkin.cfm method=post enctype=multipart/form-data cfinput class=copy required=yes style=width:140px; name=userjay type=text size=14 maxlength=50 message=Username is Required cfinput class=copy required=yes style=width:140px; name=passwordjay type=password size=14 maxlength=50 message=Username is Required input type=submit value=nbsp;Enternbsp; class=copy /cfform My boss wants there to NOT be a submit button showing on the screen, i.e. he just wants people to type in their username and password and then hit enter to login. How would I go about this. I thought of just hiding the submit in a div but that didn't do it. It needs to work in NN4.7 up and IE 5 up. Any help would be good. Jeremy ~| 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: submit cfform without submit button
I strongly agree, I have made that point, and he didn't think it was a big deal, but we'll see what he says now that I have it working. I am sure he will change his mind. Jeremy -Original Message- From: Adrocknaphobia Jones [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 3:33 PM To: CF-Talk Subject: RE: submit cfform without submit button Tell your boss I think he's an idiot. That such a usability no-no. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Jeremy Bunton [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 3:07 PM To: CF-Talk Subject: submit cfform without submit button Hello all, I know this isn't strictly a CF issue but I am using CF at the momeny so here we go. I have a simple form with two text fields one for username and one for password. Here is the code. cfform action=checkin.cfm method=post enctype=multipart/form-data cfinput class=copy required=yes style=width:140px; name=userjay type=text size=14 maxlength=50 message=Username is Required cfinput class=copy required=yes style=width:140px; name=passwordjay type=password size=14 maxlength=50 message=Username is Required input type=submit value=nbsp;Enternbsp; class=copy /cfform My boss wants there to NOT be a submit button showing on the screen, i.e. he just wants people to type in their username and password and then hit enter to login. How would I go about this. I thought of just hiding the submit in a div but that didn't do it. It needs to work in NN4.7 up and IE 5 up. Any help would be good. Jeremy ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: submit cfform without submit button
I showed it to him without a submit button and he loved it. Just what I wanted *shrugs* what can ya do. Jeremy -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 4:14 PM To: CF-Talk Subject: RE: submit cfform without submit button So many times ... clients or bosses have asked me for things that I knew was wrong, but I've given it to them ... and then ... they don't like it. Sometimes battles are won by not fighting them. H. -Original Message- From: Jeremy Bunton [SMTP:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 12:43 PM To: CF-Talk Subject: RE: submit cfform without submit button I strongly agree, I have made that point, and he didn't think it was a big deal, but we'll see what he says now that I have it working. I am sure he will change his mind. Jeremy -Original Message- From: Adrocknaphobia Jones [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 3:33 PM To: CF-Talk Subject: RE: submit cfform without submit button Tell your boss I think he's an idiot. That such a usability no-no. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Jeremy Bunton [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 3:07 PM To: CF-Talk Subject: submit cfform without submit button Hello all, I know this isn't strictly a CF issue but I am using CF at the momeny so here we go. I have a simple form with two text fields one for username and one for password. Here is the code. cfform action=checkin.cfm method=post enctype=multipart/form-data cfinput class=copy required=yes style=width:140px; name=userjay type=text size=14 maxlength=50 message=Username is Required cfinput class=copy required=yes style=width:140px; name=passwordjay type=password size=14 maxlength=50 message=Username is Required input type=submit value=nbsp;Enternbsp; class=copy /cfform My boss wants there to NOT be a submit button showing on the screen, i.e. he just wants people to type in their username and password and then hit enter to login. How would I go about this. I thought of just hiding the submit in a div but that didn't do it. It needs to work in NN4.7 up and IE 5 up. Any help would be good. Jeremy ~| 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
supposedly simple query
I have this VERY simple query like cfquery name=getmessages datasource=mydns select * from message where thread = #threadnumber# /cfquery where #threadnumber# is set by cfset threadnumber=#trim(URL.thread)# coming from a cflocation url=messages.cfm?thread=cfoutput#formthread#/cfoutput If I hard code in a number no problem it works but for some odd reason using the above I get [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'thread = 45'. Both fields are intergers. What ya think. Jeremy ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: supposedly simple query
That is exactly what it was, first I took the cfoutput/cfoutput out of the cflocation and wrapped them around the cflocation instead and it worked. Then after reading Craig's post I took them out all together and it is working fine now. Thanks. Jeremy -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 4:33 PM To: CF-Talk Subject: RE: supposedly simple query The cfoutput in your cflocation is causing unwanted spacing in your URL. Try: cfoutput cflocation url=messages.cfm?thread=#formthread# /cfoutput instead of: cflocation url=messages.cfm?thread=cfoutput#formthread#/cfoutput Adam. -Original Message- From: Jeremy Bunton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 3:23 PM To: CF-Talk Subject: supposedly simple query I have this VERY simple query like cfquery name=getmessages datasource=mydns select * from message where thread = #threadnumber# /cfquery where #threadnumber# is set by cfset threadnumber=#trim(URL.thread)# coming from a cflocation url=messages.cfm?thread=cfoutput#formthread#/cfoutput If I hard code in a number no problem it works but for some odd reason using the above I get [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'thread = 45'. Both fields are intergers. What ya think. Jeremy ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
XML CF5 parser
Can anyone point me in the right direction for XML parsing in CF5. I have a XML file like rss version=0.91 channel item titleGood, Microsoft form handheld alliance/title linkhttp://rss.com.com/2100-1040-960886.html?type=ptamp;part=rssamp;tag= feedamp;subj=news/link descriptionStart-up Good Technology is working with Microsoft to make its e-mail software for handhelds compatible with Microsoftapos;s Pocket PC 2002 operating system./description /item that i bring in with cfhttp, now I need to format it for use. Is that an easy to use well documented tag out there somewhere. JLB ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
download PWS
Anyone know where I can download personal web server. I looked for 10 mins on the microsoft site. Can't find it anywhere. __ Get the mailserver that powers this list at http://www.coolfusion.com 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: Pez convention moves after teen is cited
Not alot, but it is interesting. -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 1:02 PM To: CF-Talk Subject: RE: Pez convention moves after teen is cited What exactly does this have to do with Cold Fusion Development? -Original Message- From: Lon Lentz [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 1:03 PM To: CF-Talk Subject: Pez convention moves after teen is cited By Heather Ratcliffe Of The Post-Dispatch * A Frontenac officer issued a summons to the youth for not having a merchant's license. That led the convention's organizer to move the candy dispenser collectors' convention to Town and Country. Pez candy dispenser collectors moved their annual convention this weekend from Frontenac to Town and Country after an undercover police officer busted a teen who sold a $3 item without a merchant's license. A Frontenac police detective wandered into a room at the Frontenac Hilton on Thursday and bought a Star Wars Pez candy dispenser from 18-year-old Seth Weinberg of Columbia, Mo. About an hour later, the officer returned to issue Weinberg a court summons. Dozens of other dealers were not cited. I didn't invite this guy into my room to buy Pez. He just came in, Weinberg said. City officials said anyone selling merchandise in Frontenac must apply for a itinerant merchant license 30 days before the sale. The process gives police an opportunity to check the background of a vendor before the public buys wares. It doesn't matter what they are selling - diamond rings or Pez dispensers, said City Attorney Chet Pleban. We want to make sure everyone follows the law, and we know who comes into our town. John Devlin, who founded the convention 10 years ago, said he never needed a license when he hosted the event in the St. Louis area in the past. Devlin, of south St. Louis County, said the hotel event coordinator never mentioned it. He said he heard about the ordinance about three weeks before the convention. By then, he said, he didn't have time to apply. Instead, Devlin decided to move the event to the St. Louis Marriott West hotel in Town and Country after the incident Thursday. Town and Country does not put the same restrictions on vendors. The Pez show, open to the public from 10:30 to 2 p.m. today, will be squeezed into the Marriott West ballroom, which is one-third the size of the planned space. More than 200 people from across the country registered for the event. Organizers expected several hundred more to stop in. Weinberg must return to Frontenac July 17 to appear in court on his violation. I know the police are doing their job, he said. But I'm sure there has got to be something better they can be doing than busting people selling Pez. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MAC File Upload Issues
I agree with James, I have tried almost everything mentioned here and in the archives at some point and none of them have worked for me. Everyone here knows of the problem and uses netscape whenever they need to upload a file. JLB -Original Message- From: James Sleeman [mailto:[EMAIL PROTECTED]] Sent: Monday, December 03, 2001 2:53 PM To: CF-Talk Subject: Re: MAC File Upload Issues As I remember IE on the Mac messes up when uploading files, I had the same problem a couple of years ago and found no solution. Use Netscape to upload files and your problems will disappear :-) I'm uploading a file via CFFILE and the code works flawlessly - until you get onto a MAC (IE5) -- James Sleeman Innovative Media Ltd Phone: (03) 377 6262 http://www.websolutions.co.nz/ CAUTION: The information contained in this email message is confidential and may be legally privileged. If the reader of this message is not the intended recipient you are notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify the sender immediately and destroy the original message and any attachments. Views expressed in this communication may not be those of Innovative Media Ltd. ~~ Get the mailserver that powers this list at http://www.coolfusion.com 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: stop reposting of form data
Now that is an interesting little trick. I think I will try that one. The only way I could figure out how to do it was to query the bd first to see if there was a record matching the info from the form and then do the cflocation if a match was found, which would cause a performance decrease. Thanks I'll use your method. -Original Message- From: Phoeun Pha [mailto:[EMAIL PROTECTED]] Sent: Sunday, November 19, 2000 3:17 AM To: CF-Talk Subject: Re: stop reposting of form data this is how i handle my stuff. let's say we have 2 templates. First template has the form fields and stuff. template 2 sends the information to a database and also displays a "Thank You!" message. if the user were to click "Refresh",the information could be entered twice, thats bad! The solution is to have 3 templates. First template has the form fields. The second template does the dirty work, ya know, inserting stuff into database. At the end of that template, do a CFLOCATION to template 3, which says 'Thanx man, you've made me richer!". Now, if the user refreshes, they get the same message, but no form data is reposted. cool eh? Considerations: if u need to display some data from the form variables on that last page, like "Thank you, [Name], yo've made me richer!" , i say do a CFlocation (ex. url="thanxpage.cfm?name="Form.name") in the middle template with URL variables and display them on the third page. hope this helps! - Original Message - From: Mike Grey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 18, 2001 12:41 PM Subject: stop reposting of form data What method is used to stop data from being reposted when a user attemps to reload an action page. Thanks Mike Grey ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: random record
Your method is actually the one that I ended up using, not because I saw that there may be a problem with the other method, but because it seemed a little more straight forward to implement. It seems to be working just fine. JLB -Original Message- From: BORKMAN Lee [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 17, 2001 5:50 PM To: CF-Talk Subject: RE: random record Hi Mark, howzit going? ;-) Actually, I think your method (choosing a random number between 1 and MaxID, then going for the first record = MaxID) could lead to some very non-random behaviour when you have large gaps in your IDs. The first ID after a large gap will be heavily over-used. I still like my method, sent before. Should actually be random (within limits of RandRange() function). Watcha reckon? Lee (Bjork) Borkman http://bjork.net ColdFusion Tags by Bjork -Original Message- From: Warrick, Mark [mailto:[EMAIL PROTECTED]] . !--- get the max record id from the table --- cfquery name="max" datasource="#session.dsn#" SELECT max (CONTACT_ID) as maxid FROM CONTACTS /cfquery !--- set a random number --- cfset randnum = RandRange(1,max.maxid) !--- Then select the a record where the recordid equal to or greater than the random number. --- cfquery name="random_record" datasource="#session.dsn#" SELECT MIN (CONTACT_ID) as random_record FROM contacts where CONTACT_ID = #randnum# /cfquery cfoutput query="random_record" #random_record# /cfoutput IMPORTANT NOTICE: This e-mail and any attachment to it is intended only to be read or used by the named addressee. It is confidential and may contain legally privileged information. No confidentiality or privilege is waived or lost by any mistaken transmission to you. If you receive this e-mail in error, please immediately delete it from your system and notify the sender. You must not disclose, copy or use any part of this e-mail if you are not the intended recipient. The RTA is not responsible for any unauthorised alterations to this e-mail or attachment to it. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: random record
Thanks Mark that seems to have done the trick. JLB -Original Message- From: Warrick, Mark [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 16, 2001 6:36 PM To: CF-Talk Subject: RE: random record There are many ways to do this. Here's one: !-- begin index_pick_a_partner_at_random.cfm -- !--- get the max record id from the table --- cfquery name="max" datasource="#session.dsn#" SELECT max (CONTACT_ID) as maxid FROM CONTACTS /cfquery !--- set a random number --- cfset randnum = RandRange(1,max.maxid) !--- Then select the a record where the recordid equal to or greater than the random number. --- cfquery name="random_record" datasource="#session.dsn#" SELECT MIN (CONTACT_ID) as random_record FROM contacts where CONTACT_ID = #randnum# /cfquery cfoutput query="random_record" #random_record# /cfoutput !-- end index_pick_a_partner_at_random.cfm -- ---mark -- Mark Warrick Phone: (714) 547-5386 Fax: (714) 972-2181 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 ------ -Original Message- From: Jeremy Bunton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 16, 2001 1:32 PM To: CF-Talk Subject: random record Can anyone point me in the right direction regarding how I would go about pulling a random record from a table every time a user visits the page. JLB ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
random record
Can anyone point me in the right direction regarding how I would go about pulling a random record from a table every time a user visits the page. JLB ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
time in CF
Hello, I was wondering how to display the time and date in CF. In asp it is %date%. I know there must be an equally easy way of doing it in CF. Jeremy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
time in CF
Thanks to everyone for the help. I really appreciate it. Is there a way to make the time keep counting, show the seconds as they are changing. Jeremy -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Monday, November 27, 2000 5:02 PM To: CF-Talk Subject: Fw: time in CF My brain is working my hands aren't typing right. Should be #DateFormat(Now(), "mm/dd/yy:)#,#TimeFormat(Now() "hh:mm:ss tt")# - Original Message - From: "Kevin Schmidt" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, November 27, 2000 3:17 PM Subject: Re: time in CF #DateFormat(Now(), "mm/dd/yy, hh:mm:ss tt")# That will give you: "11/27/00, 3:17:00 PM" - Original Message - From: "Jeremy Bunton" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, November 27, 2000 2:01 PM Subject: time in CF Hello, I was wondering how to display the time and date in CF. In asp it is %date%. I know there must be an equally easy way of doing it in CF. Jeremy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists