RE: Suggestion for Windows HTML editor
Try HTMLKIT from www.chami.com Its free and you can get plugins for pretty much whatever you want. Jay Reichenbach _ From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 07, 2004 7:02 PM To: CF-Talk Subject: RE: Suggestion for Windows HTML editor > I can't see where Dreamweaver wont do everything you want. > Just change to code view and you're home and hosed. Damian said his new laptop will only have 64 MB of RAM! In that case, I suspect he'd see sub-optimal performance with Dreamweaver. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: RegEx Problem Trying to Use Matched Text
Heres a regex I use for email address finding. Maybe this can get you moving in the right direction ReFindNoCase("[EMAIL PROTECTED]")> _ From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 08, 2004 3:58 PM To: CF-Talk Subject: Re: RegEx Problem Trying to Use Matched Text CF5 doesn't support Perlish character classes (ie "\w"). IIRC, you can use [[:alnum:]] to replace them. BTW -- are you sure this is a direct copy from the book (aside from the \1 vs $1 change)? It looks odd in several ways to me. --Ben Josen Ruiseco wrote: > I am using the following and I get the email address twice. The second string is not a link. > > > #newString# > "([EMAIL PROTECTED])", " > #newString# > > Am I not doing something right? I'm on CF5. > > Josen _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: sql question
Turn it into a Stored Procedure and just call the stored procedure. Either using cfquery or cfstoredproc. _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 10:34 AM To: CF-Talk Subject: Re: sql question it cant be ommitted when creating a view and you do that from a single dsn in cfmx and you have to reference the database. CREATE VIEW must be first in the sql statement, unless its preceded by a "GO" heres what im doing... we are using a distributed partitioned view, and when we make table column changes we have to drop the view and create it again we want to make a cfmx routine that will destruct the views on all databases, add the new column to all the tables, then recreate the view all from 1 dsn. here is what works in sql: use dpvEven_2 if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[view_dpvReports]') and OBJECTPROPERTY(id, N'IsView') = 1) drop view [dbo].[view_dpvReports] go USE dpvEven_2 go CREATE VIEW view_dpvReports AS SELECT * FROM dpv1.dpvOdd_1.dbo.reports1 UNION ALL SELECT * FROM dpv1.dpvOdd_3.dbo.reports3 UNION ALL SELECT * FROM dpv1.dpvOdd_5.dbo.reports5 UNION ALL SELECT * FROM dpv1.dpvOdd_7.dbo.reports7 UNION ALL SELECT * FROM dpv1.dpvOdd_9.dbo.reports9 UNION ALL SELECT * FROM dpv1.dpvOdd_11.dbo.reports11 UNION ALL SELECT * FROM dpv2.dpvEven_2.dbo.reports2 UNION ALL SELECT * FROM dpv2.dpvEven_4.dbo.reports4 UNION ALL SELECT * FROM dpv2.dpvEven_6.dbo.reports6 UNION ALL SELECT * FROM dpv2.dpvEven_8.dbo.reports8 UNION ALL SELECT * FROM dpv2.dpvEven_10.dbo.reports10 UNION ALL SELECT * FROM dpv2.dpvEven_12.dbo.reports12 go but that doesnt work from cfmx in a cfquery tag. im thinking i just might use some stored procedures for this... unless anyone can think of another way. thanks! Tony Weeg macromedia certified cold fusion developer email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ cool tool: http://www.antiwrap.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
debug question
Is there a function out there that mimics CF's Debug? I'm looking for something along these lines to provide in an email. The function would have to act almost exactly as CF's dbug? TIA Jay Reichenbach [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: SQL: Passing vars to a LIKE statement
Pass the percent signs as part of your var... Don't know why it works but it does. There is a way to do it in a stored proc but I don't remember off the top of my head. _ From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 4:15 PM To: CF-Talk Subject: RE: SQL: Passing vars to a LIKE statement thanks but it is not helping, here is my stored proc and the error msg I receive CREATE PROCEDURE GetMonthlyJoins AS DECLARE @MONTH varchar(3), @MONTHNBR int, @YEAR int, @did datetime, @count int, @likevar varchar(25) IF object_id('#MonthlyJoins') is not null BEGIN TRUNCATE TABLE #MonthyJoins; END ELSE BEGIN CREATE TABLE #MonthyJoins ( rptmonth varchar(3), rptmonthnbr int, rptyear int, total int ); END DECLARE didCursor cursor local static FOR SELECT DISTINCT rptdate FROM ALL_DAILY_TOTALS WHERE convert(varchar(10),rptdate,101) like '%/01/%' ORDER BY rptdate open didCursor fetch didCursor into @did WHILE @@fetch_status=0 BEGIN SET @year = (SELECT DATEPART(year, @did)) SET @month =(SELECT UPPER(LEFT(DATENAME(month, @did),3))) SET @monthnbr =(SELECT MONTH(@did)) SELECT @count=COUNT(*) FROM avectraprod.dbo.persondemographic(nolock) WHERE demographicgroupid =4 AND demographicitemid =7 AND demographicvaluedesc LIKE @month+'%'[EMAIL PROTECTED]'%' INSERT INTO #MonthyJoins ( rptmonth,rptmonthnbr,rptyear, total ) VALUES (@month,@monthnbr,@year,@count) fetch next FROM didCursor into @did END close didCursor deallocate didCursor SELECT * FROM #MonthyJoins GO Error Message: Server: Msg 245, Level 16, State 1, Procedure GetMonthlyJoins, Line 51 Syntax error converting the varchar value 'FEB%' to a column of data type int. -Original Message- From: Ali Awan [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 1:21 PM To: CF-Talk Subject: Re: SQL: Passing vars to a LIKE statement > I need to pass some varibles into a LIKE clause in a SELECT statement. > I am having trouble with the format. > > AND valuedesc LIKE '[EMAIL PROTECTED]@year%' is what I was doing and know this > is wrong cause it see that garb as a literal string. How do I pass > this so the vars show? Eric, I recently ran into this same problem recently. The correct way to do this is: AND valuedesc LIKE '%'[EMAIL PROTECTED]'%'[EMAIL PROTECTED]'%' You need to put the "+" signs in and remember to put the single quotes properly. Whenever you use variables, you have to build the statement as a string. Hope this helps, Ali _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: debug question
It needs to dump all the info the debug dump ie pages that are executed, time it took to execute, sessionvars, urlvars,formvars. Everything you can think of. _ From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 5:15 PM To: CF-Talk Subject: RE: debug question Jay: Does it have to be a function? Why not just do something like: Here's the SESSION debug data: -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ Jason Reichenbach wrote: > Is there a function out there that mimics CF's Debug? I'm looking for > something along these lines to provide in an email. The function would > have to act almost exactly as CF's dbug? TIA _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: SQL: Passing vars to a LIKE statement
I'm assuming you are posting from a form or the like and calling this SP. Pass this from your cf page when you call the Sp @yourspvar = formvar&"%" That way the @yourspvar is a string when it comes into the sp and no need to do any of the % or single quotes in your SP just simply use whatever LIKE @yourspvar [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: debug question
I'm on CF 5 still =( any idea where I can find it on that? _ From: Qasim Rasheed [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 5:41 PM To: CF-Talk Subject: Re: debug question Jason, If you didn't find a custom made function, I think you can take a look at debug.cfm under C:\CFusionMX\wwwroot\WEB-INF\debug and get a head start. - Original Message ----- From: Jason Reichenbach <[EMAIL PROTECTED]> Date: Wed, 22 Sep 2004 17:27:38 -0400 Subject: RE: debug question To: CF-Talk <[EMAIL PROTECTED]> It needs to dump all the info the debug dump ie pages that are executed, time it took to execute, sessionvars, urlvars,formvars. Everything you can think of. _ From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 5:15 PM To: CF-Talk Subject: RE: debug question Jay: Does it have to be a function? Why not just do something like: Here's the SESSION debug data: -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ Jason Reichenbach wrote: > Is there a function out there that mimics CF's Debug? I'm looking for > something along these lines to provide in an email. The function would > have to act almost exactly as CF's dbug? TIA _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Word 2003 and CF 5
Has anyone used CF5 to access MS Word 2003 objects? All was fine with 2000, but now none of the properties seem to work. The following example results in the Range, Close and Count properties/methods not being found: /* This returns the 'Documents' collection of the Word object */ objDoc = objWord.Documents; /* Specify a document to open */ newDoc = objDoc.open("c:\jellystone\tempdir\bs7.txt"); actDoc = newDoc.application; objActDoc = actDoc.ActiveDocument; objWords = objActDoc.Paragraphs; docRange = objWords.Range(); docRangeText = docRange.Text; /* Close Object actDoc.Close();*/ /* Quit Word */ objWord.Quit(); writeoutput("Here we are:"&objWords.count); Any Help would be greatly appreciated. Thanks, Jay Reichenbach Senior Product Developer OpenHire, Inc. ~| This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.houseoffusion.com/banners/view.cfm?bannerid=11 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183057 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Word 2003 and CF 5
Has anyone used CF5 to access MS Word 2003 objects? All was fine with 2000, but now none of the properties seem to work. The following example results in the Range, Close and Count properties/methods not being found: /* This returns the 'Documents' collection of the Word object */ objDoc = objWord.Documents; /* Specify a document to open */ newDoc = objDoc.open("c:\jellystone\tempdir\bs7.txt"); actDoc = newDoc.application; objActDoc = actDoc.ActiveDocument; objWords = objActDoc.Paragraphs; docRange = objWords.Range(); docRangeText = docRange.Text; /* Close Object actDoc.Close();*/ /* Quit Word */ objWord.Quit(); writeoutput("Here we are:"&objWords.count); Any Help would be greatly appreciated. Thanks, Jay Reichenbach Senior Product Developer OpenHire, Inc. ~| Protect your mail server with built in anti-virus protection. It's not only good for you, it's good for everybody. http://www.houseoffusion.com/banners/view.cfm?bannerid=39 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183123 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SPAM-BULK: RE:Forcing text to wrap in table cell
Set a table width then set a fixed width in the first row ie: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 02, 2004 10:12 AM To: CF-Talk Subject: SPAM-BULK: RE:Forcing text to wrap in table cell this is cool but it doesnt wrap the text -Original Message- From: Marius Milosav [mailto:[EMAIL PROTECTED] Sent: Monday, November 01, 2004 11:35 PM To: CF-Talk Subject: SPAM-BULK: Re: SPAM-BULK: Forcing text to wrap in table cell Importance: Low Add the following to your table definition: Marius Milosav www.scorpiosoft.com It's not about Technology, it's about people Virtual Company (VICO) Application demo www.scorpiosoft.com/vicodemo/login.cfm - Original Message - From: "Will Tomlinson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, November 01, 2004 6:31 PM Subject: Re: SPAM-BULK: Forcing text to wrap in table cell > >This is going to sound like rookie question but... > > > >Does anyone know of a good way to make sure that long text doesn't stretch a > >table cell? > > > >Example > > > > > > > > > >fff f > >ff > > > > > > > >since there are no spaces in this text it will stretch the table to > >accommodate. I don't want to count chars and do this with code because > >in the browser i's are smaller than H's and the number of allowable chars > >would never work right. > > > >Anyone have a simple solution? > > > >David > > > Everytime I've loaded text with no spaces into a cell it's stretched the table. > > ~| Get the mailserver that powers this list at http://www.houseoffusion.com/banners/view.cfm?bannerid=17 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183130 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
CF and Word 2003
Has anyone used CF5 to access MS Word 2003 objects? All was fine with 2000, but now none of the properties seem to work. The following example results in the Range, Close and Count properties/methods not being found: /* This returns the 'Documents' collection of the Word object */ objDoc = objWord.Documents; /* Specify a document to open */ newDoc = objDoc.open("c:\jellystone\tempdir\bs7.txt"); actDoc = newDoc.application; objActDoc = actDoc.ActiveDocument; objWords = objActDoc.Paragraphs; docRange = objWords.Range(); docRangeText = docRange.Text; /* Close Object actDoc.Close();*/ /* Quit Word */ objWord.Quit(); writeoutput("Here we are:"&objWords.count); Any Help would be greatly appreciated. Thanks, Jay Reichenbach Senior Product Developer OpenHire, Inc. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183406 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
word 2003 and CF
Has anyone used CF5 to access MS Word 2003 objects? All was fine with 2000, but now none of the properties seem to work. The following example results in the Range, Close and Count properties/methods not being found: /* This returns the 'Documents' collection of the Word object */ objDoc = objWord.Documents; /* Specify a document to open */ newDoc = objDoc.open("c:\jellystone\tempdir\bs7.txt"); actDoc = newDoc.application; objActDoc = actDoc.ActiveDocument; objWords = objActDoc.Paragraphs; docRange = objWords.Range(); docRangeText = docRange.Text; /* Close Object actDoc.Close();*/ /* Quit Word */ objWord.Quit(); writeoutput("Here we are:"&objWords.count); Any Help would be greatly appreciated. Thanks, Jay Reichenbach Senior Product Developer OpenHire, Inc. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186623 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: word 2003 and CF
I figured out the issue. So no need to worry yourselves =). If anyone is interested here is what I had to do. Instead of using the .Range() method I used the content method to return all the content to a variable. Then I found it would not kill the winword.exe process so what I had to do there was initiate the .application and .activedocument once those were initiated I was able to kill the process. Jay -Original Message- From: Jason Reichenbach Sent: Wednesday, December 08, 2004 8:23 AM To: CF-Talk Subject: word 2003 and CF Has anyone used CF5 to access MS Word 2003 objects? All was fine with 2000, but now none of the properties seem to work. The following example results in the Range, Close and Count properties/methods not being found: /* This returns the 'Documents' collection of the Word object */ objDoc = objWord.Documents; /* Specify a document to open */ newDoc = objDoc.open("c:\jellystone\tempdir\bs7.txt"); actDoc = newDoc.application; objActDoc = actDoc.ActiveDocument; objWords = objActDoc.Paragraphs; docRange = objWords.Range(); docRangeText = docRange.Text; /* Close Object actDoc.Close();*/ /* Quit Word */ objWord.Quit(); writeoutput("Here we are:"&objWords.count); Any Help would be greatly appreciated. Thanks, Jay Reichenbach Senior Product Developer OpenHire, Inc. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186651 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54