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
