Re: Error converting data type varchar to numeric
I've had problems in the past passing to numeric fields. EX: cfprocparam type=In cfsqltype=CF_SQL_NUMERIC dbVarName=FIELD_GOAL value= null=YES try putting a value in as a test to see if this is where your error is. EX: cfprocparam type=In cfsqltype=CF_SQL_NUMERIC dbVarName=FIELD_GOAL value=0 null=YES -- Sam On Fri, Sep 26, 2008 at 2:29 PM, Larry Juncker [EMAIL PROTECTED] wrote: Anybody This is something that I really need help on... Thanks Again in advance -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED] Sent: Friday, September 26, 2008 2:50 PM To: cf-talk Subject: Error converting data type varchar to numeric Can anyone help me with this? I have no VARCHAR values going into any numeric fields.The error seems to be coming form my cfprocresult tag All values in the table can be null except the automatic column which is not even mentioned in this SP Any help would be gretly appreciated. Thanks in advance Larry PS: I only outputed my cfproc statements to show what is being submitted to the SP cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbVarName=Student_UID value=2 null=No cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbVarName=Coach_UID value=0 null=No cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbVarName=GRADE value=SR null=NO cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbVarName=PRIMARY_POSITION value=Forward 3 null=NO cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbVarName=GAMES_PLAYED value=50 null=NO cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbVarName=GAMES_STARTED value=45 null=NO cfprocparam type=In cfsqltype=CF_SQL_NUMERIC dbVarName=FIELD_GOAL value= null=YES cfprocparam type=In cfsqltype=CF_SQL_NUMERIC dbVarName=THREE_POINT_PERCENT value= null=YES cfprocparam type=In cfsqltype=CF_SQL_NUMERIC dbVarName=FREE_THROW_PERCENT value= null=YES cfprocparam type=In cfsqltype=CF_SQL_NUMERIC dbVarName=REBOUNDS_GAME value= null=YES cfprocparam type=In cfsqltype=CF_SQL_NUMERIC dbVarName=ASSISTS_GAME value= null=YES cfprocparam type=In cfsqltype=CF_SQL_NUMERIC dbVarName=TURNOVERS_GAME value= null=YES cfprocparam type=In cfsqltype=CF_SQL_NUMERIC dbVarName=BLOCKS_GAME value= null=YES cfprocparam type=In cfsqltype=CF_SQL_NUMERIC dbVarName=STEALS_GAME value= null=YES cfprocparam type=In cfsqltype=CF_SQL_NUMERIC dbVarName=TOTAL_POINTS value= null=YES cfprocparam type=In cfsqltype=CF_SQL_NUMERIC dbVarName=POINTS_GAME value= null=YES cfprocparam type=In cfsqltype=CF_SQL_NUMERIC dbVarName=VERTICAL_JUMP value= null=YES cfprocparam type=In cfsqltype=CF_SQL_NUMERIC dbVarName=STANDING_REACH value= null=YES FONT face=Times New Roman size=3/FONT The web site you are accessing has experienced an unexpected error. Please contact the website administrator. The following information is meant for the website developer for debugging purposes. Error Occurred While Processing Request Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Error converting data type varchar to numeric. The error occurred in C:\Inetpub\wwwroot\statsandgo\members\Student\Sports\form2action.cfm: line 43 41 :/cfloop 42 : 43 :cfprocresult name=InsertSport resultset=1 44 : 45 :/cfstoredproc _ SQLSTATE HY000 SQL{call sp_Basketball_ins( (param 1) , (param 2) , (param 3) , (param 4) , (param 5) , (param 6) , (param 7) , (param 8) , (param 9) , (param 10) , (param 11) , (param 12) , (param 13) , (param 14) , (param 15) , (param 16) , (param 17) , (param 18) )} VENDORERRORCODE8114 DATASOURCE profilesandgo Resources: * Check the ColdFusion documentation http://www.macromedia.com/go/proddoc_getdoc to verify that you are using the correct syntax. * Search the Knowledge Base http://www.macromedia.com/support/coldfusion/ to find a solution to your problem. Browser Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; InfoPath.1; .NET CLR 2.0.50727) Remote Address 74.43.153.40 Referrer http://www.statsandgo.com/members/student/sports/form2.cfm Date/Time26-Sep-08 02:44 PM Stack Trace javascript:; (click to expand) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313169 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfloop using to much memory
Yes I am using CF8. On Wed, Jun 25, 2008 at 6:26 PM, Dan Vega [EMAIL PROTECTED] wrote: Are you using CF8 because they made many improvements to this very problem in 8. Dan On Wed, Jun 25, 2008 at 9:17 PM, Sam Roach [EMAIL PROTECTED] wrote: We are trying to create a CSV file with about 250,000 rows with about 40 dynamic columns which we need to loop over so we can get the correct order. We see an issue coming from the nested loops on the large dataset and the server is running out of memory. We took a step back on even doing a simple loop over over a large set of rows seems to have the same issues. Anyone have any ideas how to deal with this? If you run this code on watch the memory on the CF Server it will just keep climbing until garbage collection runs. cfset outsideloop = 2000 cfloop from=1 to=#outsideloop# index=x /cfloop thanks, -- Sam ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308169 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfloop using to much memory
I'm using a java stringbuffer which works great for the portion of the code, but the main issue is with the cfloop tag. On Wed, Jun 25, 2008 at 6:51 PM, Brian Kotek [EMAIL PROTECTED] wrote: If you aren't, use a Java StringBuffer or StringBuilder to build up the CSV. If you do the concatenation using CF you'll use large amounts of memory because every concatenation creates a new String object. On Wed, Jun 25, 2008 at 9:26 PM, Dan Vega [EMAIL PROTECTED] wrote: Are you using CF8 because they made many improvements to this very problem in 8. Dan On Wed, Jun 25, 2008 at 9:17 PM, Sam Roach [EMAIL PROTECTED] wrote: We are trying to create a CSV file with about 250,000 rows with about 40 dynamic columns which we need to loop over so we can get the correct order. We see an issue coming from the nested loops on the large dataset and the server is running out of memory. We took a step back on even doing a simple loop over over a large set of rows seems to have the same issues. Anyone have any ideas how to deal with this? If you run this code on watch the memory on the CF Server it will just keep climbing until garbage collection runs. cfset outsideloop = 2000 cfloop from=1 to=#outsideloop# index=x /cfloop thanks, -- Sam ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308170 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Replace comma in replace list
I don't know if you can do it with the ReplaceList function at all... But you can wrap your var with a replace first.. Example: cfset new_var=#ReplaceList(trim(replace(my_var,,,_,all)), ##,,%,,/,\,*,?,,,|,:,$,.,',,@,#chr(44)#,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_)# hope this helps. -- Sam On Wed, Jun 25, 2008 at 1:49 PM, Robert Harrison [EMAIL PROTECTED] wrote: How do I indicate a comma in a replace list so I can replace the comma? Example: cfset new_var=#ReplaceList(trim(my_var), ##,,%, ,/,\,*,?,,,|,:,$,.,',,@,#chr(44)#, _,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_,_)# chr(44) is the comma, but that doesn't work and neither does ,,. Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308171 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfloop using to much memory
This empty loop as posted here will cause the same memory spikes. You can create just a simple .cfm page and run this and watch the memory go out of control. Maybe it is a Coldfusion bug? cfset outsideloop = 2000 cfloop from=1 to=#outsideloop# index=x /cfloop thanks, -- Sam On Thu, Jun 26, 2008 at 5:50 AM, Brian Kotek [EMAIL PROTECTED] wrote: Can you post the code? Because a loop tag itself woudn't be causing memory to spike. It has to be something inside the loop tag. On Thu, Jun 26, 2008 at 2:35 AM, Sam Roach [EMAIL PROTECTED] wrote: I'm using a java stringbuffer which works great for the portion of the code, but the main issue is with the cfloop tag. On Wed, Jun 25, 2008 at 6:51 PM, Brian Kotek [EMAIL PROTECTED] wrote: If you aren't, use a Java StringBuffer or StringBuilder to build up the CSV. If you do the concatenation using CF you'll use large amounts of memory because every concatenation creates a new String object. On Wed, Jun 25, 2008 at 9:26 PM, Dan Vega [EMAIL PROTECTED] wrote: Are you using CF8 because they made many improvements to this very problem in 8. Dan On Wed, Jun 25, 2008 at 9:17 PM, Sam Roach [EMAIL PROTECTED] wrote: We are trying to create a CSV file with about 250,000 rows with about 40 dynamic columns which we need to loop over so we can get the correct order. We see an issue coming from the nested loops on the large dataset and the server is running out of memory. We took a step back on even doing a simple loop over over a large set of rows seems to have the same issues. Anyone have any ideas how to deal with this? If you run this code on watch the memory on the CF Server it will just keep climbing until garbage collection runs. cfset outsideloop = 2000 cfloop from=1 to=#outsideloop# index=x /cfloop thanks, -- Sam ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308206 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfloop using to much memory
Thanks, the cfsilent did the trick.. -- Sam On Thu, Jun 26, 2008 at 10:04 AM, Brian Kotek [EMAIL PROTECTED] wrote: By the way, this runs in about 5 seconds and uses no memory on my machine. cfsilent cfset outsideloop = 2000 cfloop from=1 to=#outsideloop# index=x /cfloop /cfsilent On Thu, Jun 26, 2008 at 1:02 PM, Brian Kotek [EMAIL PROTECTED] wrote: Well I'm not sure it is a bug, you're talking about 20 MILLION loop iterations. If nothing else you're going to get 20 million carriage returns in the output buffer. You could try wrapping it in cfsetting enablecfoutputonly=true and, assuming you aren't in a cfoutput block, see if that makes any difference. Essentially, unless you're positive that no content is actually being generated in these loop calls, that alone will probably cause a lot of memory usage. What, by the way, is too much memory? And what exactly is the issue with the memory climbing until the GC runs...that's exactly what its supposed to do. On Thu, Jun 26, 2008 at 12:48 PM, Sam Roach [EMAIL PROTECTED] wrote: This empty loop as posted here will cause the same memory spikes. You can create just a simple .cfm page and run this and watch the memory go out of control. Maybe it is a Coldfusion bug? cfset outsideloop = 2000 cfloop from=1 to=#outsideloop# index=x /cfloop thanks, -- Sam On Thu, Jun 26, 2008 at 5:50 AM, Brian Kotek [EMAIL PROTECTED] wrote: Can you post the code? Because a loop tag itself woudn't be causing memory to spike. It has to be something inside the loop tag. On Thu, Jun 26, 2008 at 2:35 AM, Sam Roach [EMAIL PROTECTED] wrote: I'm using a java stringbuffer which works great for the portion of the code, but the main issue is with the cfloop tag. On Wed, Jun 25, 2008 at 6:51 PM, Brian Kotek [EMAIL PROTECTED] wrote: If you aren't, use a Java StringBuffer or StringBuilder to build up the CSV. If you do the concatenation using CF you'll use large amounts of memory because every concatenation creates a new String object. On Wed, Jun 25, 2008 at 9:26 PM, Dan Vega [EMAIL PROTECTED] wrote: Are you using CF8 because they made many improvements to this very problem in 8. Dan On Wed, Jun 25, 2008 at 9:17 PM, Sam Roach [EMAIL PROTECTED] wrote: We are trying to create a CSV file with about 250,000 rows with about 40 dynamic columns which we need to loop over so we can get the correct order. We see an issue coming from the nested loops on the large dataset and the server is running out of memory. We took a step back on even doing a simple loop over over a large set of rows seems to have the same issues. Anyone have any ideas how to deal with this? If you run this code on watch the memory on the CF Server it will just keep climbing until garbage collection runs. cfset outsideloop = 2000 cfloop from=1 to=#outsideloop# index=x /cfloop thanks, -- Sam ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308209 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfloop using to much memory
We are trying to create a CSV file with about 250,000 rows with about 40 dynamic columns which we need to loop over so we can get the correct order. We see an issue coming from the nested loops on the large dataset and the server is running out of memory. We took a step back on even doing a simple loop over over a large set of rows seems to have the same issues. Anyone have any ideas how to deal with this? If you run this code on watch the memory on the CF Server it will just keep climbing until garbage collection runs. cfset outsideloop = 2000 cfloop from=1 to=#outsideloop# index=x /cfloop thanks, -- Sam ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308158 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ScottishCFUG : Connect Meeting with Rob Gonda on AJAX
Has anyone setup a Coldfusion EDI VAN system? I'm Looking for some information on translations for 850 POs, or any other docs. It would be nice not to have to start from scratch. Any code samples can be zipped and emailed to me directly. Also does anyone have an infomation about becoming a VAN. Thanks, -- Sam ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263198 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
EDI X12 COLDFUSION
Has anyone setup a Coldfusion EDI VAN system? I'm Looking for some information on translations for 850 POs, or any other docs. It would be nice not to have to start from scratch. Any code samples can be zipped and emailed to me directly. Thanks, -- Sam ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263049 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Table Rename
Anyone know how to rename a table from within ColdFusion MX6.1 running MSSQL Server 2005. Here is what I am trying. CFQUERY NAME=ALTER_TABLE DATASOURCE=#database# sp_rename '#old_tablename#', '#new_tablename#' /CFQUERY I am receiving this error. Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect Thanks, -- Sam ~| 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:253639 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Table Rename
You were correct; I recreated the datasource and all works fine now. Guess I've spent to much time looking at this computer screen. Thanks. -- Sam -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 20, 2006 10:42 AM To: CF-Talk Subject: RE: Table Rename That sounds like a connectivity issue rather than syntax. -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 20, 2006 1:36 PM To: CF-Talk Subject: Table Rename Anyone know how to rename a table from within ColdFusion MX6.1 running MSSQL Server 2005. Here is what I am trying. CFQUERY NAME=ALTER_TABLE DATASOURCE=#database# sp_rename '#old_tablename#', '#new_tablename#' /CFQUERY I am receiving this error. Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect Thanks, -- Sam ~| 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:253645 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
website merging error
IIS / Coldfusion MX Has anyone ever come across an error with IIS or ColdFusion where multiple sites on the same server, seem to merge together... Each site has it's own IP address but when browsing certain pages, sometimes graphics will get pulled from the other website.You can hit the refresh button and everything will come up fine 2 out of 3 times... Other sites on this same server run correctly... here is an example...Hit refresh a few times... http://www.litewheels.com/menu_page.cfm?page=lw_news_search.cfm http://www.litewheels.com/menu_page.cfm?page=lw_news_search.cfmmenu=2 menu=2 Any advice would be helpful... -- Sam [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: website merging error
that did it... thanks to all -- Sam -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, December 18, 2003 9:43 AM To: CF-Talk Subject: RE: website merging error IIS / Coldfusion MX Has anyone ever come across an error with IIS or ColdFusion where multiple sites on the same server, seem to merge together... Each site has it's own IP address but when browsing certain pages, sometimes graphics will get pulled from the other website. You can hit the refresh button and everything will come up fine 2 out of 3 times... Have you disabled the Cache Web Server Paths option? http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/websea10.htm http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/websea10.htm Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Table help
You are trying to make 120% width fit inside 100% wide table... Try putting 20% in each.. table width=100% tr td width=20%/td td width=20%Text1/td td width=20%Test2/td td width=20%Test234/td td width=20%/td /tr /table table width=100% tr td width=20%/td tdText1/td tdTest2/td tdTest234/td td width=100%/td /tr /table -Original Message- From: Tony Walker [mailto:[EMAIL PROTECTED] Sent: Thursday, July 10, 2003 4:41 PM To: CF-Talk Subject: RE: Table help This might work... table cellspacing=0 cellpadding=0 border=0 tr td width=20%/td td width=80% table cellspacing=0 cellpadding=0 border=0 tr td/td td/td td/td td/td /tr tr td/td td/td td/td td/td /tr /table /td /tr /table ô¿ô Tony -Original Message- From: David Delbridge [mailto:[EMAIL PROTECTED] Sent: Thursday, July 10, 2003 3:18 PM To: CF-Talk Subject: Re: Table help Add width=1 to columns #2 and #3. Remove the width= parameter from column #4. Mind you, a column width of 1 will force line wrapping at every single word, so you might adjust from 1 to something greater as needed by your application. Dave -- David M. Delbridge Circa 3000 ColdFusion Hosting http://www.circa3k.com Cedric Villat wrote: I'm messing around the width of a table and can't see to get it right. Let me explain what I am trying to do. I have 5 cells in 1 row. The first cell I would like to be 20% of the screen space. The middle 3 cells are filled with text and will be whatever width the text is (so no width specified). Then I want the last cell to just fill in the rest of the screen. What I have now is: table width=100% tr td width=20%/td tdText1/td tdTest2/td tdTest234/td td width=100%/td /tr /table The problem with the above code is that the first cell is MUCH less than 20% of the screen. If I take off the 100% width from the last cell, the first cell is in fact 20%, but then the middle 3 cells are stretched to fit the screen width. Also, I guess you cannot specify % in a td since it is not reliable. How can I pad the remaining screen space in the last cell? Thanks. Cedric ~| 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
OT: MS Access random records
I need to grab a random 25000 records from a database, no dups.. I found some code online and modified it, but it is to slow... Works great for just a few records.. The query.. SELECT DISTINCTROW old_table.Name INTO new_table FROM old_table WHERE (((InStr(1,rndSet(25500,'old_table'),(, [id] ,)))0)); Here is The function.. Function rndSet(maxNumber, tablename) As String Dim dbs As Database, rst As Recordset Dim strSQL As String Dim str Dim cnt As Long Dim cnt1 As Long Dim rndMax As Long Dim RndNumber As Long Dim str2 Dim cnt3 Set dbs = CurrentDb strSQL = SELECT * FROM tablename Set rst = dbs.OpenRecordset(strSQL) rst.MoveLast cnt = CLng(rst.RecordCount) cnt3 = CLng(maxNumber) If cnt3 cnt Then cnt1 = CLng(rst.RecordCount) Else cnt1 = cnt3 End If rndMax = cnt str = , str2 = ' Do Until cnt1 = 0 Randomize RndNumber = Int(Rnd * rndMax) If (InStr(str2, CStr(RndNumber)) = 0) And RndNumber 0 Then str2 = str2 RndNumber ',' cnt1 = cnt1 - 1 rst.MoveFirst rst.Move RndNumber If cnt1 = 0 Then str = str rst(id) , Exit Do Else str = str rst(id) , End If End If Loop rndSet = str rst.Close Set dbs = Nothing End Function ~| 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: MS Access random records
nevermind, I got it... -- Sam -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 1:22 PM To: CF-Talk Subject: OT: MS Access random records I need to grab a random 25000 records from a database, no dups.. I found some code online and modified it, but it is to slow... Works great for just a few records.. The query.. SELECT DISTINCTROW old_table.Name INTO new_table FROM old_table WHERE (((InStr(1,rndSet(25500,'old_table'),(, [id] ,)))0)); Here is The function.. Function rndSet(maxNumber, tablename) As String Dim dbs As Database, rst As Recordset Dim strSQL As String Dim str Dim cnt As Long Dim cnt1 As Long Dim rndMax As Long Dim RndNumber As Long Dim str2 Dim cnt3 Set dbs = CurrentDb strSQL = SELECT * FROM tablename Set rst = dbs.OpenRecordset(strSQL) rst.MoveLast cnt = CLng(rst.RecordCount) cnt3 = CLng(maxNumber) If cnt3 cnt Then cnt1 = CLng(rst.RecordCount) Else cnt1 = cnt3 End If rndMax = cnt str = , str2 = ' Do Until cnt1 = 0 Randomize RndNumber = Int(Rnd * rndMax) If (InStr(str2, CStr(RndNumber)) = 0) And RndNumber 0 Then str2 = str2 RndNumber ',' cnt1 = cnt1 - 1 rst.MoveFirst rst.Move RndNumber If cnt1 = 0 Then str = str rst(id) , Exit Do Else str = str rst(id) , End If End If Loop rndSet = str rst.Close Set dbs = Nothing End Function ~| 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
IIS hiding .cfm
Has anyone had any luck with processing .html files to cold fusion? I've set up IIS to pass .HTML extensions to my jrun.dll, but when I try to view the page I get a Page cannot be displayed error. As an experiment I tried passing the page to the asp.dll which seemed to work fine. Looking online this is the only reference to this that I have found: http://www.maxfusion.co.uk/faq/viewfaq.cfm?QID=63 Is there another step I'm missing with Cold Fusion? -- Sam ~| 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: IIS hiding .cfm
Coldfusion MX... Version 6 -- Sam -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 8:51 AM To: CF-Talk Subject: Re: IIS hiding .cfm Which version of CF? Jerry Johnson [EMAIL PROTECTED] 03/26/03 11:45AM Has anyone had any luck with processing .html files to cold fusion? I've set up IIS to pass .HTML extensions to my jrun.dll, but when I try to view the page I get a Page cannot be displayed error. As an experiment I tried passing the page to the asp.dll which seemed to work fine. Looking online this is the only reference to this that I have found: http://www.maxfusion.co.uk/faq/viewfaq.cfm?QID=63 Is there another step I'm missing with Cold Fusion? -- Sam ~| 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: IIS hiding .cfm
thanks, that did it.. -- Sam -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 8:54 AM To: CF-Talk Subject: RE: IIS hiding .cfm Which version of ColdFusion are you running? The instructions on that page are for CF5 and below, for CFMX you have to add an entry to the C:\CFusionMX\wwwroot\WEB-INF\web.xml file such as servlet-mapping servlet-nameCfmServlet/servlet-name url-pattern*.htm/url-pattern /servlet-mapping HTH -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 16:45 To: CF-Talk Subject: IIS hiding .cfm Has anyone had any luck with processing .html files to cold fusion? I've set up IIS to pass .HTML extensions to my jrun.dll, but when I try to view the page I get a Page cannot be displayed error. As an experiment I tried passing the page to the asp.dll which seemed to work fine. Looking online this is the only reference to this that I have found: http://www.maxfusion.co.uk/faq/viewfaq.cfm?QID=63 Is there another step I'm missing with Cold Fusion? -- Sam ~| 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: Submitting form from img
input type=image src=file.gif -- Sam -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 12:01 PM To: CF-Talk Subject: Submitting form from img Hi, I have a form that I want to submit using an image rather than a input type=submit button. How can I do this? form action=action.cfm method=post img src=file.gif /form --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| 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
RE: Access date issue
you may need to put a # around the date if it is a date field in access.. ex.. #dateformat(bdate, m)# = ###Dateformat(searchdate, m)### -- Sam -Original Message- From: Rebecca Joy Sherman [mailto:[EMAIL PROTECTED] Sent: Thursday, February 27, 2003 11:54 AM To: CF-Talk Subject: Access date issue Trying to query a database to get all the records where the bdate is in the same month and year. This example is only the month. But it is not working what am I missing. I am using CF5 and Access CFQUERY datasource=#application.db# name=howmany select id,title,sdescrip, bdate from courses where bdate NULL and #dateformat(bdate, m)# = #Dateformat(searchdate, m)# order by bdate,title /CFQUERY Joy ;-* ~| 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: link checking tool
this tool may help. http://home.snafu.de/tilman/xenulink.html -- Sam -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Monday, February 24, 2003 1:12 PM To: CF-Talk Subject: link checking tool I just had the great fortune of inheriting a gargantuan app that is completely devoid of documentation (not even code-level docs). The plan is to partially gut it and modularize the functionality so that it can work better in a multi-developer environment. That's obviously going to mean a lot of 'move this file here', 'delete this file', 'rename this file' and such. I'm looking for a tool that'll parse the code base and create two lists of files: missing, and extra, so that I can easily find what I can delete, and what I need to create/migrate/convert. I wrote a very simplistic tool, but it doesn't handle circular dependancies for finding extra files, among other things, and I was wondering if there were any such tool available (preferably free) that might save me a lot of trouble. I've be perfectly happy with just handling A HREF=, FORM ACTION=, CFINCLUDE TEMPLATE= and CFMODULE TEMPLATE= calls (no IMG, LINK, STYLE, etc), without any support for dynamic references (A HREF=#self#...), as long as it took care of circular dependancies. By circular dependancies I mean two files that link to eachother (like an view/action pair), but don't link to any other files. They are clearly extra because they don't relate to the rest of the app, but because they have a dependancy (on eachother) my little app won't mark them as extra. Doesn't have to be CF specific; I've got no problems investing some time to retool a program that's designed for another arena, since it's going to be faster than writing something from scratch. TIA, barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral (formerly PIER System, Inc.) [EMAIL PROTECTED] voice : 360.671.8708 x12 fax : 360.647.5351 www.audiencecentral.com --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.456 / Virus Database: 256 - Release Date: 2/18/2003 ~| 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: (OT, kinda) Does anyone know a source for downloading IE wit hout auto-install?
I saw this posted in on thetechguide.com. Another method that works is at this link: http://www.broomeman.com/support/wsiedown.html Summary: Download ie6setup.exe and save it to, for example, C:\Download and then go to start | run and type this: C:\download\ie6setup.exe /c:ie6wzd.exe /d /s:#E The IEAK is nice too, but you may not want to install it on your machine, so this option works but without the customization benefit. -- Sam -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 11, 2003 10:02 AM To: CF-Talk Subject: RE: (OT, kinda) Does anyone know a source for downloading IE wit hout auto-install? Thanks, for the tip, Robert. I was wondering if that was the only option...looks like it is. Rick -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 11, 2003 12:47 PM To: CF-Talk Subject: RE: (OT, kinda) Does anyone know a source for downloading IE wit hout auto-install? You can download the IEAK. You can auto install without any user intervention whatsoever, even on rebooting. Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com -Original Message- From: Chris Phillips [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 11, 2003 12:26 PM To: CF-Talk Subject: RE: (OT, kinda) Does anyone know a source for downloading IE without auto-install? From memory, you can't do it from a Win2K workstation, or therefore presumably an XP machine - MS spot you and only give you the auto install option A windows 98 (or even 95 :-))) machine will give you the option to download the network version ... Somewhere on MS download centre Sorry not to be more specific Chris -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Tuesday 11 February 2003 17:04 To: CF-Talk Subject: (OT, kinda) Does anyone know a source for downloading IE without auto-install? Hi, all. Glad to see everyone after a quiet weekend and few new messages in my CF-Talk inbox! I've got a client that's having trouble using the site management functions I've built into their website that uses for session variables for verification. They're using IE 6.0, and that appears to be the problem. Even with the update to the latest version of 6.0, they're still having problems. I want to back them down to IE 5.5, which is working fine. They've got a sl connection, and I'm trying to download IE 5.5 as a file so I can burn it to a CD and install it for them. Can locate a file download of the complete IE 5.5. Anyone know where on the 'Net I can find a downloadable copy? Thanks, Rick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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: Convert format
val() command cfset SESSION.ecom.ordernumber = val(qLastOrderNo.newOrderNumber) + 1 -- Sam -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 05, 2003 12:49 PM To: CF-Talk Subject: Convert format Hi All, I've got a query which retrieves the max order number from the db. I want to increment it by one and write the new number to a session var. However, CF5 throws a message that it can't convert format. I checked the db (SQL 2000)- the field ordernumber is an integer. What am I doing wrong? (here's the snip) !--- Create an order number --- !--- Query the orders database for the last order number --- cfquery name=qLastOrderNo dbtype=dynamic connectstring=#REQUEST.dsnStore# SELECT MAX(ordernumber) AS newOrderNumber FROM #REQUEST.tablePrefix#_O_OrderInfo /cfquery cflock name=VASPCart#SESSION.SessionID# timeout=10 type=exclusive cfif qLastOrderNo.recordcount IS 0 cfset SESSION.ecom.ordernumber=7500 cfelse cfset SESSION.ecom.ordernumber= #qLastOrderNo.newOrderNumber# + 1 /cfif /cflock Thanks, Mark ~| 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
RE: stop/restart
net stop IIS Admin Service net start IIS Admin Service -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 8:51 AM To: CF-Talk Subject: stop/restart I know this may be a bit OT but does anyone know the command line in a DOS prompt to stop and restart IIS? Thanks. Robert Orlini HW Wilson 718-588-8400 x2656 ~| 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: stop/restart
net stop IIS Admin Service net start IIS Admin Service you also must restart: net start World Wide Web Publishing Service net start FTP Publishing Service -- Sam -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 8:51 AM To: CF-Talk Subject: stop/restart I know this may be a bit OT but does anyone know the command line in a DOS prompt to stop and restart IIS? Thanks. Robert Orlini HW Wilson 718-588-8400 x2656 ~| 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: DateTimeFormat
Not in one shot but you can do something like: CFSET MYDATETIME = #DateFormat(#Now()#, -mm-dd)# #TimeFormat(#Now()#, hh:mm:ss)# -- Sam -Original Message- From: Frank Mamone [mailto:[EMAIL PROTECTED]] Sent: Monday, January 27, 2003 1:10 PM To: CF-Talk Subject: DateTimeFormat Hi, I looked at all the functions but can't seem to find a CF function that formats date and time in one shot. Can I change the output of Now() directly into this format : 2003-01-27 14:54:29 Or do I have to parse out the date and time and do it separately? Looking for a shortcut:) Thanks ~| 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
session variables
Is there a way to pass session variables across a domain? Ex. from www.mywebsite.com to www1.mywebsite.com? -- Sam ~| 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: session variables
Both domains are on the same server. But when I go between the domains it starts a new session. What do I have to add to the application.cfm file to make this work? -- Sam CFAPPLICATION NAME=MYCART SESSIONMANAGEMENT=Yes SETCLIENTCOOKIES=Yes SESSIONTIMEOUT=#CreateTimeSpan(1, 0, 0, 0)# APPLICATIONTIMEOUT=#CreateTimeSpan(1, 0, 0, 0)# CLIENTMANAGEMENT=Yes CLIENTSTORAGE=Cookie CFLOCK TIMEOUT=30 THROWONTIMEOUT=Yes NAME=#Application.ApplicationName# TYPE=Exclusive CFIF NOT #ISDEFINED(Application.Started)# CFLOCK TIMEOUT=10 THROWONTIMEOUT=Yes NAME=#Session.SessionID# TYPE=Exclusive CFSET APPLICATION.STARTED = TRUE /CFLOCK /CFIF /CFLOCK CFLOCK TIMEOUT=10 THROWONTIMEOUT=Yes NAME=#Session.SessionID# TYPE=ReadOnly CFIF NOT ISDEFINED(Session.Started) CFSET SESSION.STARTED = TRUE CFSET SESSION.ITEM = CFSET SESSION.QUANTITY = CFSET SESSION.KEYCODE = /CFIF /CFLOCK -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 15, 2003 11:00 AM To: CF-Talk Subject: RE: session variables You could either cheat and turn the SESSION variable into a URL variable or you could have both domains serviced by the same CF App Server, both using the same Application name (specified in the Application.cfm file). -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 15, 2003 12:20 PM To: CF-Talk Subject: session variables Is there a way to pass session variables across a domain? Ex. from www.mywebsite.com to www1.mywebsite.com? -- Sam ~| 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
Spell Checker update.
If anyone is interested I just posted an updated version of my free spell checker utility. http://www.samroach.com/downloads.html Also I'm looking for a free place to host a demo of this utility, please let me know if you have some space available. You can email me at [EMAIL PROTECTED] Thanks and enjoy, -- Sam ~| 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: Spell Checker update.
Sorry if it is slow. the site is hosted locally on a DSL connection and is being hit fairly hard at the moment. I assure you the URL is correct. Try again in a few minutes. -- Sam -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 10:26 AM To: CF-Talk Subject: RE: Spell Checker update. Sam, Your page doesn't display. Times out. Andy -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 12:04 PM To: CF-Talk Subject: Spell Checker update. If anyone is interested I just posted an updated version of my free spell checker utility. http://www.samroach.com/downloads.html Also I'm looking for a free place to host a demo of this utility, please let me know if you have some space available. You can email me at [EMAIL PROTECTED] Thanks and enjoy, -- Sam ~| 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: Access Memo Field
This may help: ReplaceNoCase(#accessfield#, p, #CHR(10)#, ALL) -- Sam -Original Message- From: David Green [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 10:32 AM To: CF-Talk Subject: Access Memo Field I know this question has been answered many times before but I can't find it in the archives and I don't use CF all the time. Heck new layout on houseoffusion I had hard time finding way to search the archives. Ended up finding link to old archive search. The link to archives at the bottom of posts does not seem to take to a archive search. But am sure am missing something. How do I convert line feeds and carriage return formats in a access field to HTML. I have tried paragraphformat but the does not do it. Client inputted in table $69/dbl $79/sgl On output am getting $69/dbl $79/sgl Need upper. Thanks for the help and postings David ~| 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: Spell Checker update.
Found a couple of errors with some help. A new version now online. Sorry about the inconvenience to anyone who has already downloaded it. http://www.samroach.com/downloads.html -- Sam -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 10:33 AM To: CF-Talk Subject: RE: Spell Checker update. Sorry if it is slow. the site is hosted locally on a DSL connection and is being hit fairly hard at the moment. I assure you the URL is correct. Try again in a few minutes. -- Sam -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 10:26 AM To: CF-Talk Subject: RE: Spell Checker update. Sam, Your page doesn't display. Times out. Andy -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 12:04 PM To: CF-Talk Subject: Spell Checker update. If anyone is interested I just posted an updated version of my free spell checker utility. http://www.samroach.com/downloads.html Also I'm looking for a free place to host a demo of this utility, please let me know if you have some space available. You can email me at [EMAIL PROTECTED] Thanks and enjoy, -- Sam ~| 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: CFDIRECTORY FILTER MX
Posting this again I still can't figure it out. thanks, -- Sam -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 26, 2002 9:50 AM To: CF-Talk Subject: CFDIRECTORY FILTER MX I need a little help with the CFDIRECTORY tag... This used to work fine in cold fusion 5. But in MX it returns to many files. CFDIRECTORY DIRECTORY=d:\inetpub\wwwroot\tempdir\ NAME=myDirectory FILTER=*0?.html SORT=datelastmodified, name ASC This returns the same results as *0*.html ... But What I need it only one character between the '0' and the '.html'. EX: myreport01.html -- I want this file listed myreport01_data.html -- But not this one.. myreport02.html -- I want this file listed myreport02_data.html -- not this one.. -- Sam ~| 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
CFDIRECTORY FILTER MX
I need a little help with the CFDIRECTORY tag... This used to work fine in cold fusion 5. But in MX it returns to many files. CFDIRECTORY DIRECTORY=d:\inetpub\wwwroot\tempdir\ NAME=myDirectory FILTER=*0?.html SORT=datelastmodified, name ASC This returns the same results as *0*.html ... But What I need it only one character between the '0' and the '.html'. EX: myreport01.html -- I want this file listed myreport01_data.html -- But not this one.. myreport02.html -- I want this file listed myreport02_data.html -- not this one.. -- Sam ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: isDefined() finesse
Because the isdefined function doesn't care what the value of the variable you are passing you don't need to use the evaluate function. However if you wanted to output that value you would have to use something like: cfoutput#Evaluate(form.serNum#i#)#/cfoutput -Original Message- From: j cc [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 26, 2002 9:12 AM To: CF-Talk Subject: isDefined() finesse cfif isDefined(Form.SerNum#i#) at first I thought it would be isDefined(evaluate(form.serNum#i#)) BUT what you had worked fine when i put it in CF 5. for a test I did this... form name=foo action=test.cfm method=post input type=hidden name=serNum1 value=foo input type=submit value=go /form cfset i =1 cfif isDefined(form.serNum#i#) foo! /cfif and after submitting the form, I received foo! as my output. -jc ~| 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
OT: Microsoft SQL, web, and mail server recommendations
A friend of mine is getting a T1 line installed and is looking to build three new computer and was after recommendations, also trying to keep the price reasonable. He needs a SQL server (stores a lot of important information) for a custom web app which was built (mostly ASP files) for his company. Also a web server and a mail server. The app is very SQL intense but is only going to be used by his company (about 65 people in about 15 locations) Here is what I recommended to him, but would like input. Asus main boards with dual CPU capacity (ASUS P2B BX) Put 2 1.6 Intel processors in SQL server and one processor in the other two server (that way you can upgrade later) 2 Raided 30 gig SCSI drives in SQL. Single 30 gigs in other two computers. Dual Intel nics 512 RAM in SQL, and Exchange server, 256 in web server. APC power backups plus all obvious things, like case, power supply What do you guys think about dual power supplies? overkill? I told him to get an extra power supply and main board to have them on hand in case of emergency ... Thanks for any input. also recommendations on routers and switches (only about 8 people in main office) -- Sam ~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Nice
Set your Language preference to CFML in IE you can do this by going to Internet Properties - Languages - Add - User Defined CFML Then browse to Version Information link in ColdFusion MX Administrator. -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 10, 2002 8:40 AM To: CF-Talk Subject: Re: Nice Its not even Easter!! Be patient... ;o) - Original Message - From: Dick Applebaum [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 10, 2002 4:17 PM Subject: Re: Nice I'll bite -- where? On Tuesday, September 10, 2002, at 08:10 AM, Bryan F. Hogan wrote: I like the CF Easter Egg __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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: Looping depending on CFIF Statement
Maybe: CFIF LoopYes EQ True cfloop index=count from=1 to=10 cfloop index=theindex from=1 to=2 The index Is CFOUTPUT#theindex# /CFOUTPUT /cfloop cfloop cfelse cfloop index=theindex from=1 to=2 The index Is CFOUTPUT#theindex# /CFOUTPUT /cfloop /CFIF -- Sam -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 10:38 AM To: CF-Talk Subject: Looping depending on CFIF Statement Hi all, Any idea why I can't seem to wrap CFLOOP tags in CFIF statements? I keep getting errors as though CF is totally ignoring the CFIF statement and still parsing the /CFLOOP tag. Here is some simple sample code: CFIF LoopYes EQ True cfloop index=count from=1 to=10 /CFIF cfloop index=theindex from=1 to=2 The index Is CFOUTPUT#theindex# /CFOUTPUT /cfloop CFIF LoopYes EQ True /cfloop /cfif Of course LoopYes is NOT equal to True. __ 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: Looping depending on CFIF Statement
correction: CFIF LoopYes EQ True cfloop index=count from=1 to=10 cfloop index=theindex from=1 to=2 The index Is CFOUTPUT#theindex# /CFOUTPUT /cfloop /cfloop cfelse cfloop index=theindex from=1 to=2 The index Is CFOUTPUT#theindex# /CFOUTPUT /cfloop /CFIF -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 8:59 AM To: CF-Talk Subject: RE: Looping depending on CFIF Statement Maybe: CFIF LoopYes EQ True cfloop index=count from=1 to=10 cfloop index=theindex from=1 to=2 The index Is CFOUTPUT#theindex# /CFOUTPUT /cfloop cfloop cfelse cfloop index=theindex from=1 to=2 The index Is CFOUTPUT#theindex# /CFOUTPUT /cfloop /CFIF -- Sam -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 10:38 AM To: CF-Talk Subject: Looping depending on CFIF Statement Hi all, Any idea why I can't seem to wrap CFLOOP tags in CFIF statements? I keep getting errors as though CF is totally ignoring the CFIF statement and still parsing the /CFLOOP tag. Here is some simple sample code: CFIF LoopYes EQ True cfloop index=count from=1 to=10 /CFIF cfloop index=theindex from=1 to=2 The index Is CFOUTPUT#theindex# /CFOUTPUT /cfloop CFIF LoopYes EQ True /cfloop /cfif Of course LoopYes is NOT equal to True. __ 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 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: access db
With ldbview.exe you can see who is locking the database. http://www.samroach.com/ldbview.exe This may or may not help. -- Sam -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 7:40 AM To: CF-Talk Subject: RE: access db Yes, can open tables but changes will not be reflected because I don't have exclusive access to it because of the ldb. -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 10:14 AM To: CF-Talk Subject: RE: access db Did you run a repair and compact on the database. Is it the whole database or maybe one corrupt table? can you open the tables individually? I've seen lots of access databases where one table corrupts but it looks like the whole thing is whacked out. -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:56 AM To: CF-Talk Subject: RE: access db Full access to the machine, I have. -Original Message- From: cftalk [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:50 AM To: CF-Talk Subject: RE: access db You have probably tried this, but have you rebooted (do you have access to the machine)? Chuck Rodgers At 09:37 AM 8/15/02 -0400, you wrote: P.S. Left site stopped all last night. (this is not a live site, but dev) But still is locked. Lifes a Bitch :| -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:30 AM To: CF-Talk Subject: RE: access db ah :-) blush/ That said, if none of these things unlock your file then there is something seriously wrong...try this : 1. Uncheck Maintain Database Connections within CF Admin 2. Stop CF 3. Start CF 4. Try and get file If that doesnt work 1. Stop CF 2. Stop IIS 3. Check Security Permissions on that file/directory 4. Reset them as necessary (log in as Administrator) 5. Delete .ldb file Let us know. Neil -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 14:26 To: CF-Talk Subject: RE: access db Read my post. -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:20 AM To: CF-Talk Subject: RE: access db unlock it then! -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 14:22 To: CF-Talk Subject: RE: access db Yes, and make the changes needed. But unless it gets unlocked a can't replace it with the correct db. -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 6:33 PM To: CF-Talk Subject: RE: access db can't you just take a copy of the database? -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, 15 August 2002 7:14 a.m. To: CF-Talk Subject: access db I have a client today that is switching their CF site built with an access db to our servers, along with that they needed for me to build an upload function for a spreadsheet, the xls name is going to be stored in the db. I need to add that column. BUT, the darn thing is locked. Simple enough run a select query on non-existent table calling the data source. NO GO, will not unlock. Ok, try the db connection flush tag, NO GO. Ok, unclick maintain db connections in admin, NO GO. Ok, restart services, NO GO. I checked all office computers nobody has it open. I have stopped the website in IIS so no users could connect, NO GO. Is there any other way to unlock the database? This is one of the reasons I tried to talk the client out of access, but again NO GO. If you have any suggestions it would be greatly appreciated. Thanks Bryan __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: access db
Their is a compact / repair utility that comes with NT, that usually fixes a lot of problems. If you need a copy email off list. [EMAIL PROTECTED] -- Sam -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 8:04 AM To: CF-Talk Subject: RE: access db Yes everyone is out, I don't see anything in the article that explains why it would still be locked. It also stated at top that it was an article for access 95/97. I have 2000, thanks for the article link does explain a little more than what I didn't know. -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 10:47 AM To: CF-Talk Subject: RE: access db With everyone out of the database is there still a ldb hanging around in the file?? If so here's a microsoft article... http://support.microsoft.com/default.aspx?scid=kb;en-us;Q136128 -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 10:40 AM To: CF-Talk Subject: RE: access db Yes, can open tables but changes will not be reflected because I don't have exclusive access to it because of the ldb. -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 10:14 AM To: CF-Talk Subject: RE: access db Did you run a repair and compact on the database. Is it the whole database or maybe one corrupt table? can you open the tables individually? I've seen lots of access databases where one table corrupts but it looks like the whole thing is whacked out. -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:56 AM To: CF-Talk Subject: RE: access db Full access to the machine, I have. -Original Message- From: cftalk [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:50 AM To: CF-Talk Subject: RE: access db You have probably tried this, but have you rebooted (do you have access to the machine)? Chuck Rodgers At 09:37 AM 8/15/02 -0400, you wrote: P.S. Left site stopped all last night. (this is not a live site, but dev) But still is locked. Lifes a Bitch :| -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:30 AM To: CF-Talk Subject: RE: access db ah :-) blush/ That said, if none of these things unlock your file then there is something seriously wrong...try this : 1. Uncheck Maintain Database Connections within CF Admin 2. Stop CF 3. Start CF 4. Try and get file If that doesnt work 1. Stop CF 2. Stop IIS 3. Check Security Permissions on that file/directory 4. Reset them as necessary (log in as Administrator) 5. Delete .ldb file Let us know. Neil -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 14:26 To: CF-Talk Subject: RE: access db Read my post. -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:20 AM To: CF-Talk Subject: RE: access db unlock it then! -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 14:22 To: CF-Talk Subject: RE: access db Yes, and make the changes needed. But unless it gets unlocked a can't replace it with the correct db. -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 6:33 PM To: CF-Talk Subject: RE: access db can't you just take a copy of the database? -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, 15 August 2002 7:14 a.m. To: CF-Talk Subject: access db I have a client today that is switching their CF site built with an access db to our servers, along with that they needed for me to build an upload function for a spreadsheet, the xls name is going to be stored in the db. I need to add that column. BUT, the darn thing is locked. Simple enough run a select query on non-existent table calling the data source. NO GO, will not unlock. Ok, try the db connection flush tag, NO GO. Ok, unclick maintain db connections in admin, NO GO. Ok, restart services, NO GO. I checked all office computers nobody has it open. I have stopped the website in IIS so no users could connect, NO GO. Is there any other way to unlock the database? This is one of the reasons I tried to talk the client out of access, but again NO GO. If you have any suggestions it would be greatly appreciated. Thanks Bryan __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: access db
Have you tried making a copy of the database, booting with a boot disk and deleting the old version? -- Sam -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 8:04 AM To: CF-Talk Subject: RE: access db Yes everyone is out, I don't see anything in the article that explains why it would still be locked. It also stated at top that it was an article for access 95/97. I have 2000, thanks for the article link does explain a little more than what I didn't know. -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 10:47 AM To: CF-Talk Subject: RE: access db With everyone out of the database is there still a ldb hanging around in the file?? If so here's a microsoft article... http://support.microsoft.com/default.aspx?scid=kb;en-us;Q136128 -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 10:40 AM To: CF-Talk Subject: RE: access db Yes, can open tables but changes will not be reflected because I don't have exclusive access to it because of the ldb. -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 10:14 AM To: CF-Talk Subject: RE: access db Did you run a repair and compact on the database. Is it the whole database or maybe one corrupt table? can you open the tables individually? I've seen lots of access databases where one table corrupts but it looks like the whole thing is whacked out. -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:56 AM To: CF-Talk Subject: RE: access db Full access to the machine, I have. -Original Message- From: cftalk [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:50 AM To: CF-Talk Subject: RE: access db You have probably tried this, but have you rebooted (do you have access to the machine)? Chuck Rodgers At 09:37 AM 8/15/02 -0400, you wrote: P.S. Left site stopped all last night. (this is not a live site, but dev) But still is locked. Lifes a Bitch :| -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:30 AM To: CF-Talk Subject: RE: access db ah :-) blush/ That said, if none of these things unlock your file then there is something seriously wrong...try this : 1. Uncheck Maintain Database Connections within CF Admin 2. Stop CF 3. Start CF 4. Try and get file If that doesnt work 1. Stop CF 2. Stop IIS 3. Check Security Permissions on that file/directory 4. Reset them as necessary (log in as Administrator) 5. Delete .ldb file Let us know. Neil -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 14:26 To: CF-Talk Subject: RE: access db Read my post. -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:20 AM To: CF-Talk Subject: RE: access db unlock it then! -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 14:22 To: CF-Talk Subject: RE: access db Yes, and make the changes needed. But unless it gets unlocked a can't replace it with the correct db. -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 6:33 PM To: CF-Talk Subject: RE: access db can't you just take a copy of the database? -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Thursday, 15 August 2002 7:14 a.m. To: CF-Talk Subject: access db I have a client today that is switching their CF site built with an access db to our servers, along with that they needed for me to build an upload function for a spreadsheet, the xls name is going to be stored in the db. I need to add that column. BUT, the darn thing is locked. Simple enough run a select query on non-existent table calling the data source. NO GO, will not unlock. Ok, try the db connection flush tag, NO GO. Ok, unclick maintain db connections in admin, NO GO. Ok, restart services, NO GO. I checked all office computers nobody has it open. I have stopped the website in IIS so no users could connect, NO GO. Is there any other way to unlock the database? This is one of the reasons I tried to talk the client out of access, but again NO GO. If you have any suggestions it would be greatly appreciated. Thanks Bryan __ 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 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: access db
Can you edit that table using only access? or is it locked their as well? -- Sam -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 12:14 PM To: CF-Talk Subject: access db I have a client today that is switching their CF site built with an access db to our servers, along with that they needed for me to build an upload function for a spreadsheet, the xls name is going to be stored in the db. I need to add that column. BUT, the darn thing is locked. Simple enough run a select query on non-existent table calling the data source. NO GO, will not unlock. Ok, try the db connection flush tag, NO GO. Ok, unclick maintain db connections in admin, NO GO. Ok, restart services, NO GO. I checked all office computers nobody has it open. I have stopped the website in IIS so no users could connect, NO GO. Is there any other way to unlock the database? This is one of the reasons I tried to talk the client out of access, but again NO GO. If you have any suggestions it would be greatly appreciated. Thanks Bryan __ 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
Spell Checker
Ok I have a project for you Cold Fusion / JavaScript guru's. My spelling sucks and I'm cheep so I don't want to pay for a spell checker and couldn't find a good one for free on the net. So I created one, it seems works fine but it is kind of slow, and it doesn't do suggested words. It can be downloaded here: http://www.samroach.com/downloads.html So if anyone wants to have a crack at fixing it up please get in contact with me at [EMAIL PROTECTED] or if anyone knows of a good free one please let me know. thanks, -- Sam __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
Error message (ODBC)
ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. I'm getting this error when trying to insert into a table that is linked from Access to a DBF file. From within Access I can insert data fine, but from cold fusion I get the error. Has anyone ran in to this before? It works as is on my local computer, I only get the error when I move the files to another server. I'm think it might have something to do with the way CF sets up the ODBC, but I can seem to find anything deferent between my local computer and the server. Any advice or guesses welcome. thanks, -- Sam __ 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: A Tip (maybe new, maybe not)
What usually I do is upload the database to a new name and change the ODBC connection to point to the new file. -- Sam -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 10:25 AM To: CF-Talk Subject: Re: A Tip (maybe new, maybe not) Even slicker thanks! Paul Giesenhagen QuillDesign There is an undocumented CF Function that will do the same thing. CFUSION_DBCONNECTIONS_FLUSH() I used to use the bogus query to do this as well until I found out about this function. Cheers! -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel 213.244.5205 Email [EMAIL PROTECTED] Hello Stupid, and welcome to your crappy computer. - Strong Bad, HomestarRunner.com -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 9:32 AM To: CF-Talk Subject: A Tip (maybe new, maybe not) I don't know if any of you work with Access much as a database here and there, but I have been developing using an access database and had to upload it to our servers after looking at the data or correcting the data as I was writing scripts ..well as you all know it locks so you cannot FTP over it once it has been accessed. I would stop/start the cf service to get this to run, well it became a pain when my terminal window would timeout and I would have to logg back into my server yadda yadda. If you send a bogus query (one with an error), CF or Access will 'unlock' the file for you... and you are back in FTP business. Many of you might already know this .. but we just figured it out and I thought it was pretty slick! Paul Giesenhagen QuillDesign __ 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 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
Computer Professionals / Cold Fusion Programmer
Does anyone know how the law works for salaried employees, regarding Computer Professionals? Is there a minimum salary? Computer Professionals - A new law provides for increased hourly minimum pay for exempt computer professionals. The minimum salary requirement for exempt computer professionals rose from $41 per hour in 2001 to $42.64 in 2002. __ 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 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: output cf to html
Try something with temp variable and see if they change, you should only have to loop though the query once: ex: query SELECT state, city, firstName, lastName FROM myTable ORDER BY state, city, firstName, lastName /query Cfset statetemp = cfset citytemp = cfset firstnametemp = cfoutput query=myQuery cfif state neq statetemp #state#br cfset statetest = state cfif cfif city neq citytemp ---#citybr cfset citytemp=city /cfif cfif firstName neq firstNametemp --#firstName#br cfset firstNametemp = firstName /cfif -#lastName#br /cfoutput -- Sam -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 5:16 PM To: CF-Talk Subject: RE: output cf to html example query... SELECT state, city, firstName, lastName FROM myTable ORDER BY state, city, firstName, lastName -- cfoutput query=myQuery group=state #state#br cfoutput group=city ---#city#br cfoutput group=firstName --#firstName#br cfoutput -#lastName#br /cfoutput /cfoutput /cfoutput /cfoutput this will yield the following results: State1 ---City1 --Adam -whatever1 -whatever2 -whatever3 --Bob -whatever1 -whatever2 -whatever3 ---City2 --Adam -whatever1 -whatever2 -whatever3 --Bob -whatever1 -whatever2 -whatever3 State2 ---City1 --Adam -whatever1 -whatever2 -whatever3 --Bob -whatever1 -whatever2 -whatever3 ---City2 --Adam -whatever1 -whatever2 -whatever3 --Bob -whatever1 -whatever2 -whatever3 -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 4:34 PM To: CF-Talk Subject: RE: output cf to html yeh... i think i understand that Bryan but when i am doing a count on the records then dividing them into say 3 generating separate columns of data say 3 that's where i get all messed up i can easily out put in to 3 columns from the top down then right down but if i want that out put to be grouped possibly sub grouped say on studio name then say title that's when it gets so funky that i just resort to dumb 3 column looped queries that i include 20+ times in a master page! argh! should be easy to figure out, but i cant thx -paul -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 6:40 PM To: CF-Talk Subject: RE: output cf to html simple lesson in query grouping... When you specify a group attribute like so... cfoutput query=myQuery group=firstName do whatever cfoutput do inner stuff /cfoutput /cfoutput it will loop over the results and will do whatever every time it finds a firstName that is different than the previous result. do inner stuff will process all the rows that have the same firstName as the previous row. Example: row firstName lastName 1. Adam Ant 2. Adam Apple 3. Anna Conda for the code above, do whatever will happen for rows 1 and 3. do inner stuff will happen for row 2. It is crucial that you ORDER BY whatever column you want to group by in your SELECT query. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 3:18 PM To: CF-Talk Subject: RE: output cf to html thanks guys... i will try it a few differnt way that you suggested. Now if i could only learn how to loop over my quries with a group with QaQ?? then i think i wouldnt even need to do this right now i have like 20 incldes a hiting the same data source many, many times just to get the output i want very convoluted amature... i know.. wish i knew more. __ 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 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: states - counties - zip codes database?
For just city and state: http://www.usps.com/ncsc/lookups/lookup_ctystzip.html -- sam -Original Message- From: Craig Thomas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 8:11 AM To: CF-Talk Subject: RE: states - counties - zip codes database? Bump, can anyone help me out with this? This has to be a common question. Anyone know of an updated database as mentioned in the subject line - preferably one that stores the relationships between counties - zip codes? http://www.usps.com/search97cgi/s97_cgi?action=ViewVdkVgwKey=http%3A%2F%2Fw ww%2Eusps%2Ecom%2Ffoia%2Freadroom%2Fzipcodedir%2EhtmDocOffset=4DocsFound=4 23QueryZip=zip+codesCollection=externalHLNavigate=off The USPS can help you out, for a fee of course. I do not know of any FREE versions of the same thing. -Craig Thomas __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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: states - counties - zip codes database?
http://www.speedkeys.com/download.htm There is a text file on this site with zip, city, and area code. This may be helpful. -- Sam -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 8:15 AM To: CF-Talk Subject: RE: states - counties - zip codes database? For just city and state: http://www.usps.com/ncsc/lookups/lookup_ctystzip.html -- sam -Original Message- From: Craig Thomas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 8:11 AM To: CF-Talk Subject: RE: states - counties - zip codes database? Bump, can anyone help me out with this? This has to be a common question. Anyone know of an updated database as mentioned in the subject line - preferably one that stores the relationships between counties - zip codes? http://www.usps.com/search97cgi/s97_cgi?action=ViewVdkVgwKey=http%3A%2F%2Fw ww%2Eusps%2Ecom%2Ffoia%2Freadroom%2Fzipcodedir%2EhtmDocOffset=4DocsFound=4 23QueryZip=zip+codesCollection=externalHLNavigate=off The USPS can help you out, for a fee of course. I do not know of any FREE versions of the same thing. -Craig Thomas __ 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: output cf to html
As another option you could cache the queries for 24hours. cfquery name=my_query datasource=my_datasource CachedWithin=#CreateTimeSpan(1,0,0,0)# -- Sam -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 2:35 PM To: CF-Talk Subject: output cf to html I have this Huge Honking report written in cf it shows exactly what i want. but i don't want a user to run this report every time they hit the page. i would like to know how to have cf-server run the page... but just save it to html every night. so that it gets updated basically once a day. instead of hitting the db every time some one views the cfm page.. any ideas? -paul __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MX demo
works fine for me (IE 5.5 , nt2000 pro) -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 4:05 PM To: CF-Talk Subject: MX demo Does this work for anyone? http://examples.macromedia.com/flash/homemortgage/app_index2.html __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: masking URLs and cflocation
Try cf_download http://devex.macromedia.com/developer/gallery/info.cfm?ID=CA347854-2830-11D4 -AA9700508B94F380method=Full -- Sam -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 4:00 PM To: CF-Talk Subject: RE: masking URLs and cflocation I've hidden the URL to a specific file through the use of a special page and the CFContent tag. For instance, if I asked for a file that was named MyFile.gif, the URL of the link to the file would be something like getfile.cfm?FileID=44. The end result is that the user would download MyFile.gif (with the same filename in the save as window), without ever knowing where MyFile.gif actually resided. Tying this in with the use of the status bar (onmouseover, blank the status bar value), then you would effectively hide the URL to the specific file. Not sure if that's quite what you want, but hope it helps. Shawn Gover -Original Message- From: Margaret Fisk [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 4:46 PM To: CF-Talk Subject: RE: masking URLs and cflocation Hi everyone, I know there is a way to do this (at least the URL masking), but I can't find any answers. I may be asking the wrong questions but... Currently: I have a page that displays the files available for download with hrefs to download them. The user clicks the href and the files either launches in another browser or downloads. The URL is listed both on the href and in the browser address. Here is what I want to do: I want the page to list the files available for download (preferably not as buttons but that's livable) User clicks the link to download (this is not an href so the URL is not displayed) The document/file download launches (cflocation?) in another browser window but the address line displays a default address rather than the true URL. I'd prefer to do this with Cold Fusion rather than JavaScript because not everyone can run JavaScript, but I am willing to be flexible on that if it will work. Thanks in advance, Margaret __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: masking URLs and cflocation
oops http://devex.macromedia.com/developer/gallery/SearchResults.cfm?keywords=cf_ download -- Sam -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 4:07 PM To: CF-Talk Subject: RE: masking URLs and cflocation Try cf_download http://devex.macromedia.com/developer/gallery/info.cfm?ID=CA347854-2830-11D4 -AA9700508B94F380method=Full -- Sam -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 4:00 PM To: CF-Talk Subject: RE: masking URLs and cflocation I've hidden the URL to a specific file through the use of a special page and the CFContent tag. For instance, if I asked for a file that was named MyFile.gif, the URL of the link to the file would be something like getfile.cfm?FileID=44. The end result is that the user would download MyFile.gif (with the same filename in the save as window), without ever knowing where MyFile.gif actually resided. Tying this in with the use of the status bar (onmouseover, blank the status bar value), then you would effectively hide the URL to the specific file. Not sure if that's quite what you want, but hope it helps. Shawn Gover -Original Message- From: Margaret Fisk [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 4:46 PM To: CF-Talk Subject: RE: masking URLs and cflocation Hi everyone, I know there is a way to do this (at least the URL masking), but I can't find any answers. I may be asking the wrong questions but... Currently: I have a page that displays the files available for download with hrefs to download them. The user clicks the href and the files either launches in another browser or downloads. The URL is listed both on the href and in the browser address. Here is what I want to do: I want the page to list the files available for download (preferably not as buttons but that's livable) User clicks the link to download (this is not an href so the URL is not displayed) The document/file download launches (cflocation?) in another browser window but the address line displays a default address rather than the true URL. I'd prefer to do this with Cold Fusion rather than JavaScript because not everyone can run JavaScript, but I am willing to be flexible on that if it will work. Thanks in advance, Margaret __ 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: SQL Question
Not sure if this is exactly what you are looking for, but it will display your table in the format you requested. Hope this helps. This should be pretty fast. -- Sam cfquery name=test datasource=#mydatsource# select * from my_table order by foreign_id, value /cfquery cfset fid_holder=0 table border=0tr cfoutput query=test cfif fid_holder neq foreign_id /trtrtd#foreign_id#/td /cfif td#value#/td cfset fid_holder=#foreign_id# /cfoutput /tr/table -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 6:49 AM To: CF-Talk Subject: SQL Question Hey folks, I have a table like this: id foreign id value 1 1 1 2 1 2 3 1 3 4 2 1 5 2 2 6 2 3 Regular old normalized table right? Well I need to get it into columns like this: foreignID value1 value2 value3 1 1 2 3 2 1 2 3 Now I know it is possible, but difficult. I would do it with CF but no matter how high I set the time out in my administrator, and my web server it times out, or says page cannot be displayed. It is pulling huge amounts of data, then outputting it it an Excel spread sheet. We tried to do it with a DTS package and the use SQL Mail to send it, but couldn't get that to work reliably. TIA. Tim Heald ACP/CCFD :) Application Development www.schoollink.net __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Oh, that damn Numberformat!!
maybe: .00 #numberformat(#number#,00)# -- Sam -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 1:55 PM To: CF-Talk Subject: Oh, that damn Numberformat!! I hate NumberFormat(). Can someone please help? I want my numbers to output like this: 123 = 123.00 123.1 = 123.10 123.00 = 123.00 0 = 0.00 What would be the proper mask for this? I've tried 999.00, but then 0 becomes .00. I've tried 990.00, but then 12 becomes 012.00. Arrggg!! BTW, CFMX is cool. __ 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 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: IE 6.0 Bug
It seems you can running anything you want.. ex. c:\winnt\xcopy /y c:\*.* c:\winnt\system32\commdlg.dll works in ie 5.0, 5.5, and 6.0 -- Sam -Original Message- From: Craig Thomas [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 6:24 AM To: CF-Talk Subject: RE: IE 6.0 Bug works with IE 5.5 too. -craig -Original Message- From: Trusz, Andrew [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 6:56 AM To: CF-Talk Subject: RE: IE 6.0 Bug Its the long way to get to Minesweeper, but it works. andy -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 6:16 PM To: CF-Talk Subject: IE 6.0 Bug http://online.securityfocus.com/archive/1/267561 has anyone tried this? -- Sam __ 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 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: using != in a filed with a null value
You can also use neq ContactCnt neq 'Do Not Contact' -- Sam - -Original Message- From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:13 AM To: CF-Talk Subject: RE: using != in a filed with a null value I have always used for NOT EQUAL. Give it a try ^_^ +--+---+ | SCOTT VAN VLIET | SBC SERVICES, INC.| | Senior Analyst | ITO Enterprise Tools | | Tel: 858.886.3878| 7337 Trade St. Room 4000 | | Pgr: 858.536.0070| San Diego, CA 92121 | | Email: [EMAIL PROTECTED]| http://www.sbc.com| +--+---+ -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:13 AM To: CF-Talk Subject: RE: using != in a filed with a null value The weird thing is if I use that with my whole query which is Select * From customerLeads Where TodaysDate = '#DateFormat(TodaysDate, mm/dd/yy)#' And Email Like '%@%' And Email Like '%.%' And ContactCnt != 'Do Not Contact' Or ContactCnt is Null It totally ignores the date part and grabs everything. This is very strange that it is doing this. That might be because you have that OR in there, I guess. Try replacing your last filter with this: AND (ContactCnt != 'Do Not Contact' OR ContactCnt IS NULL) Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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 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: SQL DISTINCT Question
try: SELECT email, first(firstname), first(lastname) FROM people GROUP BY email; -- Sam -Original Message- From: Jeff Green [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 4:15 PM To: CF-Talk Subject: SQL DISTINCT Question SELECT DISTINCT Email FROM LinkedEmails returns a record set with no dupe emails, but I want first and last names as well so i try SELECT DISTINCT Email, FirstName, LastName FROM LinkedEmails returns a record set that has dupe email fields How would I query for unique emails and get the first and last names without getting dupe emails TIA, jeff __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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: SQL DISTINCT Question
creative :) -- Sam -Original Message- From: Jeff Green [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 4:55 PM To: CF-Talk Subject: RE: SQL DISTINCT Question Thanks Sam, got the following to work but I like yours better ;) SELECT Email, FirstName, LastName FROM Users WHERE ID IN (SELECT Min(ID) FROM Users GROUP BY email) -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 4:33 PM To: CF-Talk Subject: RE: SQL DISTINCT Question try: SELECT email, first(firstname), first(lastname) FROM people GROUP BY email; -- Sam -Original Message- From: Jeff Green [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 4:15 PM To: CF-Talk Subject: SQL DISTINCT Question SELECT DISTINCT Email FROM LinkedEmails returns a record set with no dupe emails, but I want first and last names as well so i try SELECT DISTINCT Email, FirstName, LastName FROM LinkedEmails returns a record set that has dupe email fields How would I query for unique emails and get the first and last names without getting dupe emails TIA, jeff __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
IE 6.0 Bug
http://online.securityfocus.com/archive/1/267561 has anyone tried this? -- Sam __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Make last line of query available
Will something with startrow and recordcount work? ex.. cfoutput query=revquery MAXROWS=1 STARTROW=#revquery.recordcount# cfset last_value=#triptrav_seq# /cfoutput -- Sam -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 2:32 PM To: CF-Talk Subject: Re: Make last line of query available Help, I know this is probably a silly question but I can not find how to point at the last record in this query. I would like to make the last value for triptrav_seq,value is currently 41456 for this query, available for use. Is there a method to point to the last record of an ordered query and make the variable triptrav_seq available I would appreciate any input you can give. CFQUERY NAME=revquery datasource=#application.issrtd# SELECT rev, triptrav_seq, rownum FROM rtd_triptrav WHERE rtd_trip_id = '#trip_id#' Order by rtd_triptrav.rev /CFQUERY A 1 40777 A 2 40778 A 3 40779 A 4 41456 Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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: Make last line of query available
it may be recordcount - 1 -- Sam -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 2:38 PM To: CF-Talk Subject: RE: Make last line of query available Will something with startrow and recordcount work? ex.. cfoutput query=revquery MAXROWS=1 STARTROW=#revquery.recordcount# cfset last_value=#triptrav_seq# /cfoutput -- Sam -Original Message- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 2:32 PM To: CF-Talk Subject: Re: Make last line of query available Help, I know this is probably a silly question but I can not find how to point at the last record in this query. I would like to make the last value for triptrav_seq,value is currently 41456 for this query, available for use. Is there a method to point to the last record of an ordered query and make the variable triptrav_seq available I would appreciate any input you can give. CFQUERY NAME=revquery datasource=#application.issrtd# SELECT rev, triptrav_seq, rownum FROM rtd_triptrav WHERE rtd_trip_id = '#trip_id#' Order by rtd_triptrav.rev /CFQUERY A 1 40777 A 2 40778 A 3 40779 A 4 41456 Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] __ 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: CF VS ASP
http://www.houseoffusion.com/hof/body/asp.cfm http://www.swynk.com/friends/murphy/ironic_isnt_it.asp -Original Message- From: Robert Bailey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 11:03 AM To: CF-Talk Subject: CF VS ASP OK, I have been looking for some things on the net that shows the pros and cons of CF as opposed to ASP. Knowing very little ASP myself, I do not know the many differences. Anyone know where I can find this? Pretty much looking for development time differences, execution speed, security and scalability at a bare minimum. Anyone know where I can find this? Rob __ 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
Mac help needed.
This is a site just launched. I've gotten a couple of complaints from Mac users that JavaScript errors coming up using IE. http://www.litewheels.com/index.cfm I would appreciate it if someone could take a look and let me know if they see the error. -- Sam __ 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 help needed.
aa.. I just removed that function to. Guess I've been sitting in front of this computer too long. Thanks, -- Sam -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 11:48 AM To: CF-Talk Subject: RE: Mac help needed. you have a reference to a the function openCookie() in the onUnload event of the body tag. I searched your page and there is not opencookie function being defined. Anthony Petruzzi Webmaster 954-321-4703 http://www.sheriff.org -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 2:43 PM To: CF-Talk Subject: Mac help needed. This is a site just launched. I've gotten a couple of complaints from Mac users that JavaScript errors coming up using IE. http://www.litewheels.com/index.cfm I would appreciate it if someone could take a look and let me know if they see the error. -- Sam __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF/Database Help
In this example is there any reason not to make RC_NAME and IG_NAME primary keys. I guess I just don't like auto numbers. So table 3 would look more like: RC_NAME IG_NAME -- Chocolate Cookies Flour Chocolate Cookies Sugar Chocolate Cookies Egg Chocolate Cookies Salt Chocolate Cookies Chocolate Chips Chocolate Brownies Flour Chocolate Brownies Sugar Chocolate Brownies Egg Chocolate Brownies Salt Chocolate Brownies Chocolate -Original Message- From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 1:49 PM To: CF-Talk Subject: RE: CF/Database Help Depending on the depth of you database, the best thing to do would to be create a master RECIPE table, and a master INGREDIENT table. The, you could create an linkage table that would like n number of ingredients to a recipe. EXAMPLE: RECIPE == RC_ID RC_NAME RC_DESCRIPTION -- 10 Chocolate Cookies Yummy! 20 Chocolate Brownies More Yummy! INGREDIENT == IN_ID IG_NAME IN_DESCRIPTION -- 1 Flour White Stuff 2 Sugar Sweet Stuff 3 Egg Yolks Stuff 4 SaltNaCl2 5 Chocolate Good Stuff 6 Chocolate Chips Little Stuff RECIPE_INGREDIENT = RI_ID RC_ID IN_ID - 1 10 1 2 10 2 3 10 3 4 10 4 6 10 6 7 20 1 8 20 2 9 20 3 10 20 4 11 20 5 The table, RECIPE_INGREDIENT, would contain an identity for the relationship (RI_ID), a reference to the recipe (RC_ID) and a reference to the related ingredient (IN_ID). So, to find out what ingredients are used in Chocolate Brownies, you could: SELECT RI.IN_ID, IN.IN_NAME, IN.IN_DESCRIPTION FROMRECIPE_INGREDIENT RI JOIN INGREDIENT IN ON RI.IN_ID = IN.IN_ID WHERE RI.RC_ID = 20 You can go even farther and attach the recipe details to this query. But I hope this leads you in the right direction! -- Scott Van Vliet Senior Analyst SBC Services, Inc. ITO Enterprise Tools Office: 858.886.3878 Pager: 858.536.0070 Email: [EMAIL PROTECTED] -Original Message- From: Deborah Curley [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 1:31 PM To: CF-Talk Subject: CF/Database Help Hi, I have a friend whose a chef and has asked me build him a database of recipes and a web app he can use to search, enter new recipes, etc. What I'm trying to figure out is the best way to store the ingredients since a recipe can have anywhere from 5 to 20 ingredients? Any ideas on the best way to handle that? TIA, Deb _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com __ 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: dynamic select boxes with dynamic names
Try the Evaluate command: cfloop INDEX=loopcount FROM=1 TO=#FORM.NUMOFQUESTIONS# STEP=1 #Evaluate(Answer#loopcount#)# /cfloop -- Sam -Original Message- From: Metzy Martinez [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 9:22 AM To: CF-Talk Subject: dynamic select boxes with dynamic names Hi everyone i've come accross a problem I'm creating dynamic select boxes. i can have none to infinity and so i need for them to have dynamic names. Because i'm not allowed to have select boxes with the same name. but when i post my results i'm having a problem resolving the the name of the select box. i thought i had fixed it by sending the recordcount number and looping through the name. but by doing this it only gives me the name of the select box not the value. Does any one know the answer please. Thank you, Metzy Here is some code below !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN html head titleListing Fact/title /head body cfif call is save cfquery name=factOutput datasource=#dsn.listings_v2# dbtype=ODBC SELECT distinct factType FROM fact WHERE Type_id = #Type_id# /cfquery cfquery name=listingFact datasource=#dsn.listings_v2# dbtype=ODBC DELETE FROM listingFact WHERE listing_id = #txtListing_id# /cfquery !--- #factRecord# CFOUTPUT /cfoutput #CUISINE#--- cfoutput query=factoutput CFLOOP INDEX=thislistingFact LIST=#factOutput.facttype# #txtListing_id#BR #thislistingFact#BRBR CFSTOREDPROC DATASOURCE=#dsn.listings_v2# PROCEDURE=usplistingFact_Insert CFPROCRESULT NAME=getlistingFact RESULTSET=1 CFPROCPARAM CFSQLTYPE=CF_SQL_VARCHAR TYPE=IN VALUE=#txtListing_id# CFPROCPARAM CFSQLTYPE=CF_SQL_VARCHAR TYPE=IN VALUE=#thislistingFact# /cfstoredproc /cfloop /cfoutput !--- cfoutput cflocation url=listingForm.cfm?call=edittxtlisting_id=#txtlisting_id# /cfoutput --- cfelseif call is add cfform name=frmlistingFact method=post action=listingFact.cfm cfoutput input type=Hidden name=txtListing_Id value=#txtListing_id# input type=hidden name=type_id value=#type_id# /cfoutput input type=hidden name=call value=save table border=0 cellspacing=0 cellpadding=0 tr tdbPlease Select A Fact/b/td /tr tr td valign=topFact/td /tr tr td cfquery name=factOutput datasource=#dsn.listings_v2# dbtype=ODBC SELECT distinct factType FROM fact WHERE Type_id = #Type_id# /cfquery cfoutput input type=hidden name=factRecord value=#factOutput.recordcount# table tr cfloop index=i from=1 to=#factOutput.recordcount# cfquery name=qrfactType datasource=#dsn.listings_v2# dbtype=ODBC SELECT * FROM fact WHERE factType = '#factOutput.factType[i]#' /cfquery td valign=topb#factOutput.factType[i]#/b/td td cfselect name=#factOutput.factType[i]# size=5 multiple=Yes required=Yes message=Please Select a Fact cfloop query=qrfactType option value=#fact_id##fact#/option /cfloop /cfselect /td /cfloop /tr /table /cfoutput br /td /tr tr td input type=submit name=btnSubmit value= Submit /td /tr /table /cfform cfelseif call is delete /cfif /body /html __ 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: Screen width, Height, Color Depth
can you use: #screen_height# #screen_width# #screen_colors# -Original Message- From: BEN MORRIS [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 12:49 PM To: CF-Talk Subject: Re: Screen width, Height, Color Depth You will have to have one form page that they come to and have JS write the values in a hidden form field, then have that submit to an action page, after which you will have the values to use in CF. Of course, you can't capture this in all browsers. More JS help: http://www.webreference.com/js/column17/dimensions.html Jason Larson [EMAIL PROTECTED] 03/25/02 03:35PM I have very little javascript experience and what I am trying to accomplish is to use javascript to give me the height, width and color depth of a user's browser and turn those javascript variables into a CF variable so I can use them in a cf template. I was wondering if anybody had any code snippets for something like this, and if so would you mine sharing. Thanks in advance, Jason Larson __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Screen width, Height, Color Depth
opps forget the first half: can you use: script document.write('input Type=Hidden Name=screen_height Value='+ screen.height +''); document.write('input Type=Hidden Name=screen_width Value='+ screen.width +''); document.write('input Type=Hidden Name=screen_colors Value='+ screen.colorDepth +' Bit'); /script #screen_height# #screen_width# #screen_colors# -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 12:58 PM To: CF-Talk Subject: RE: Screen width, Height, Color Depth can you use: #screen_height# #screen_width# #screen_colors# -Original Message- From: BEN MORRIS [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 12:49 PM To: CF-Talk Subject: Re: Screen width, Height, Color Depth You will have to have one form page that they come to and have JS write the values in a hidden form field, then have that submit to an action page, after which you will have the values to use in CF. Of course, you can't capture this in all browsers. More JS help: http://www.webreference.com/js/column17/dimensions.html Jason Larson [EMAIL PROTECTED] 03/25/02 03:35PM I have very little javascript experience and what I am trying to accomplish is to use javascript to give me the height, width and color depth of a user's browser and turn those javascript variables into a CF variable so I can use them in a cf template. I was wondering if anybody had any code snippets for something like this, and if so would you mine sharing. Thanks in advance, Jason Larson __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Time Issue
Also make sure you have the correct time zone selected. -- Sam -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 1:52 PM To: CF-Talk Subject: Re: Time Issue checked smtp server time and it is right as well. - Original Message - From: VAN VLIET, SCOTT E (SBCSI) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 25, 2002 2:48 PM Subject: RE: Time Issue Are your web server smtp server on the same box? If not, then this time may be coming from the smtp server. HTH -- SCOTT VAN VLIET SENIOR ANALYST SBC SERVICES, INC Tel: 858.886.3878 Fax: 858.653.6763 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 1:46 PM To: CF-Talk Subject: Time Issue I am using cfmail to send some emails - when I receive the email it says it was sent at 1:30 this morning instead of the appropriate time this afternoon (that I sent it). The system time is correct. Any ideas? Thanks __ 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: asc() to identify line break characters
TRY #replace(string,chr(13),p,all)# -- Sam -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: Friday, March 22, 2002 11:46 AM To: CF-Talk Subject: asc() to identify line break characters I have a bunch of articles stored in a DB that need to be presented on the web. I'm trying to replace line breaks with and html line break. I've tried #replace(string,chr(10),'br')# and #replace(string,chr(13),'br')# . The strings appear with hard breaks instead of br. Are there any other characters that can be used for a line break? I cut and paste them into Studio, do a #asc()# on them, and they read as 10. Yet when I try to replace 10, nothing happens. HELP :) Eric Carlisle Web Site Developer Progress Energy IT Systems Delivery E-mail: [EMAIL PROTECTED] Phone: (919) 546-4739 __ 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: Tall Table
you can use a transparent gif. tabletrtd img src=trans.gif align=right width=1 height=250 /td/tr/table -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 8:20 AM To: CF-Talk Subject: Tall Table I would like to have a specified height in a table but if that table is longer it would have a scroll bar, however I do not want to use frames. I hope that make sense, the next question is: Is that possible? Thanks, Neil __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Tall Table
I guess I didn't understand the initial request completely. -- Sam -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 8:42 AM To: CF-Talk Subject: Re: Tall Table What is that going to do? Neil - Original Message - From: Sam Roach [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 11:27 AM Subject: RE: Tall Table you can use a transparent gif. tabletrtd img src=trans.gif align=right width=1 height=250 /td/tr/table -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 8:20 AM To: CF-Talk Subject: Tall Table I would like to have a specified height in a table but if that table is longer it would have a scroll bar, however I do not want to use frames. I hope that make sense, the next question is: Is that possible? Thanks, Neil __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Tall Table
Here is an example: http://www.siteexperts.com/tips/html/ts04/page1.asp -- Sam -Original Message- From: Kirk Boecker [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 9:09 AM To: CF-Talk Subject: Re: Tall Table you can do this with style sheets - using the overflow attribute embed your table into the cell of an outside table and use overflow: auto; in the style that is in the main cell - don't think it works on older NS browsers (what does though) kirk boecker - Original Message - From: Neil H. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 8:51 AM Subject: Re: Tall Table I think the Iframe is going to mess up my flow since it is just like a frame and required a htm page included. Thanks, Neil - Original Message - From: Matthew R. Small [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 11:32 AM Subject: RE: Tall Table I think that's what iframes are for... but I've never used one so I'm not sure. And it only works in IE (I think) :-) Matt Small -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 11:20 AM To: CF-Talk Subject: Tall Table I would like to have a specified height in a table but if that table is longer it would have a scroll bar, however I do not want to use frames. I hope that make sense, the next question is: Is that possible? Thanks, Neil __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Inserting CFIF into CFINPUT
cfif #GEC.Sex# eq Male cfinput type=Radio name=sex value=Male CHECKED = TRUE cfelse cfinput type=Radio name=sex value=Male /cfif -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 11:07 AM To: CF-Talk Subject: Inserting CFIF into CFINPUT Hey all, I want to make a CFINPUT Radio button checked or unchecked depending on the value of a variable from the database. Simple right? Yup..I thought so too. So why doesn't it work? cfinput type=Radio name=sex value=Male cfif #GEC.Sex# eq Male CHECKED = TRUE /CFIF I get this error: --- Just in time compilation error Invalid token found on line 52 at position 67. ColdFusion was looking at the following text: Invalid expression element. The usual cause of this error is a misspelling in the expression text. The last successfully parsed CFML construct was a CFINPUT tag occupying document position (52:21) to (52:28). --- Any ideas on what I'm doing wrong? I expect it to be some simple syntax error. -Gel __ 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: HTML Email
You can use the standard CFMAIL just set type=html ex: CFMAIL To=#mailaddress# From=#fromaddress# Subject=#subj# server=#server# port=25 type=html HTMLhead/head body bgcolor=##FF link=##FF vlink=##FF alink=##FF Table border=0 width=600trtd This is the message /td/tr/table /body /html -Original Message- From: Joe Tartaglia [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 20, 2002 4:19 PM To: CF-Talk Subject: HTML Email Can anyone point me at a custom tag that will allow me to do HTML email? CF_AdvancedEmail looks great but it only works with CF 4.5 (we are running CF 4.0). I don't need attachments or even graphics. Just HTML-formatted (tables, etc.) text. Thanks in advance, Joe Tartaglia 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 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: two SUBMIT buttons on a form?
you could set a name for you submit buttons. On you process page do a include based on which button was clicked. EX: form action=go.cfm input type=submit value=x1 name=click_x1 input type=submit value=x2 name=click_x2 /form -- go.cfm cfif isdefined(click_x1) cfinclude template=x1_process.cfm cfelseif isdefined(click_x2) cfinclude template=x2_process.cfm /cfif - -- Sam -Original Message- From: Ed Gordon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 20, 2002 4:54 PM To: CF-Talk Subject: two SUBMIT buttons on a form? Is there a simple way to have two buttons on the bottom of a form, one which goes to one .cfm and one to another, and yet have both process the entered form data on the way? I would of course label them differently, such as NEW and COPY, or for similar functions. TIA Ed Gordon FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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: two SUBMIT buttons on a form?
Yes -- Sam -Original Message- From: Scott Van Vliet [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 20, 2002 5:04 PM To: CF-Talk Subject: RE: two SUBMIT buttons on a form? Does that work in Netscape? -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 20, 2002 5:00 PM To: CF-Talk Subject: RE: two SUBMIT buttons on a form? you could set a name for you submit buttons. On you process page do a include based on which button was clicked. EX: form action=go.cfm input type=submit value=x1 name=click_x1 input type=submit value=x2 name=click_x2 /form -- go.cfm cfif isdefined(click_x1) cfinclude template=x1_process.cfm cfelseif isdefined(click_x2) cfinclude template=x2_process.cfm /cfif - -- Sam -Original Message- From: Ed Gordon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 20, 2002 4:54 PM To: CF-Talk Subject: two SUBMIT buttons on a form? Is there a simple way to have two buttons on the bottom of a form, one which goes to one .cfm and one to another, and yet have both process the entered form data on the way? I would of course label them differently, such as NEW and COPY, or for similar functions. TIA Ed Gordon FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists