Re: CFFM + FCKEditor (good stuff?)

[Jon Austin]

If it's not working, raise a bug on SourceForge for FCKEditor. He
usually fixes them pretty quickly.


On Mon, 10 Jan 2005 22:12:38 -0500, Tony Weeg <[EMAIL PROTECTED]> wrote:
> hi there.
> 
> im using fckEditor, and the file upload piece is trippin'

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189885
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

CFFM + FCKEditor (good stuff?)

[Tony Weeg]

hi there.

im using fckEditor, and the file upload piece is trippin'

any idea if CFFM from Rick Root, works well as a replacement
for the non-working file uploader that exists with the app?

i know if its not working, ANYTHING is better, just wondering
if you have any experience with it, ket me know...

thanks

-- 
tony

Tony Weeg

macromedia certified coldfusion mx developer
email: tonyweeg [at] gmail [dot] com
blog: http://www.revolutionwebdesign.com/blog/
cool tool: http://www.antiwrap.com

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189884
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: John Dowdell Wants to Know What's Wrong with Macromedia

[James Holmes]

Agreed. We don't let anyone touch the production boxes at all. They get
synced by an admin from test.

One thing RDS does that WebDav doesn't (afaik) is expose every datasource on
the box to every user, regardless of sandboxing. That's why RDS is disabled
on all of our shared boxes (dev, test and prod).

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 11 January 2005 4:24 
To: CF-Talk
Subject: RE: John Dowdell Wants to Know What's Wrong with Macromedia

> I didn't think that RDS was for production systems?

It isn't. Neither is WebDAV, in my opinion. I'm reluctant to allow people to
edit files via HTTP on production systems in general.


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189883
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: How to add images to my db the *right* way?

[Will Tomlinson]

>Personally, I'd completely nix the "prodMainImage1", "prodMainImage2"
>approach in the tblproductimages table, and let one row in that table
>represent one image.  Then, I'd add a prodImageID column to the
>tblAvailableColors table that indicated what images were pictures of a
>product in a given color.


Joe,

One other thing is she wants up to 3 different images per model. Some shorts 
have front, side, and rear shots. How would you arrange those in the schema?

Thanka,
Will

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189882
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: Revised Thread - Uploading CSV and Validation

[Aaron Rouse]

And if using Oracle you could use SQLLDR.  I have the need to do this
just with CF and been using a CFC I got off this list for uploading it
but still have not found the time to really progress with it.


On Mon, 10 Jan 2005 16:53:15 -0700, Paul Malan <[EMAIL PROTECTED]> wrote:
> If you're using SQL Server, you can create a DTS package then call it
> from CF.  I couldn't believe the difference in speed when I switched
> to DTS.  (If you need to use CF to validate the incoming data, use DTS
> to populate a temp table, CF to pull it out and insert the validated
> data into its permanent home.  I'd wager still much quicker than using
> a loop over cffile contents, though I'd be curious to know if you wind
> up trying both...)
> 
> 
> On Mon, 10 Jan 2005 17:36:09 -0500, Ken <[EMAIL PROTECTED]> wrote:
> > Hi. I want to enable the user to upload a csv file, then the data
> > should be validated against pre-defined criteria for different columns
> > in the csv file. Once that is done, I want to write the validated
> > rows from the csv file to the DB.
> >
> > Please help.
> >
> > Thanks,
> > Ken
> >
> >
> 
> 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189881
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: How to add images to my db the *right* way?

[Will Tomlinson]

>Hey Will,
>
>You may want to think about rearranging some of your schema: anytime
>you hit a situation where you wind up with column names like
>"prodMainImage1", "prodMainImage2", etc., you've found a place where
>you may want to examine what you're doing more closely.
>
>Personally, I'd completely nix the "prodMainImage1", "prodMainImage2"
>approach in the tblproductimages table, and let one row in that table
>represent one image.  Then, I'd add a prodImageID column to the
>tblAvailableColors table that indicated what images were pictures of a
>product in a given color.


I agree! What I've done here is insane! Let me rework this. 

Thanks!

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189880
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: wysisyg editor for forms

[Joe Rinehart]

None right now - I've got to write my own for fckEditor sometime in
the next few weeks, I'll make it lesser GPL when I do and let everyone
know. :)

-joe


On Mon, 10 Jan 2005 20:16:23 -0500, Tony Weeg <[EMAIL PROTECTED]> wrote:
> on this note, im having issues with the image uploader, its like
> putting only a 1kb file on the server with the right name/file ext.
> but the file isnt really an image... just
> some weird collection of 1kb of something ...
> 
> any ideas?
> 
> thanks.
> tony
> 
> 
> On Mon, 10 Jan 2005 20:06:37 -0500, Joe Rinehart <[EMAIL PROTECTED]> wrote:
> > I'm a big fan of fckeditor - I think the open source CFFM works with
> > it now, as well, for uploading of images and such.
> >
> > -joe
> >
> >
> > On Mon, 10 Jan 2005 18:28:50 -0500, Wurst, Keith D. <[EMAIL PROTECTED]> 
> > wrote:
> > > what does everyone think is the best free cf custom tag that can be 
> > > implemented to allow for users to format (bold, etc.) text in a form. 
> > > thank.
> > >
> > >
> >
> >
> 
> 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189879
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: How to add images to my db the *right* way?

[Joe Rinehart]

Hey Will,

You may want to think about rearranging some of your schema: anytime
you hit a situation where you wind up with column names like
"prodMainImage1", "prodMainImage2", etc., you've found a place where
you may want to examine what you're doing more closely.

Personally, I'd completely nix the "prodMainImage1", "prodMainImage2"
approach in the tblproductimages table, and let one row in that table
represent one image.  Then, I'd add a prodImageID column to the
tblAvailableColors table that indicated what images were pictures of a
product in a given color.

>From there, the queries to get all images for a product or get the
appropriate images for a product in a given color become fairly simple
and straightforward.

-Joe

-- 
For Tabs, Trees, and more, use the jComponents:
http://clearsoftware.net/client/jComponents.cfm

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189878
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

OT: OCP - MCDBA

[Leonardo CRESPO - Gmail]

Hi all! Sorry for the OT. This is the best list i know and since it
will affect many aspects of my life, i would sincerely appreciate your
opinions before committing to my next certification.

I can't make a clear choice between studying to become an Oracle OCP
or MCDBA. I'm 23yrs, Adv. Certified CFMX Developer, Certified Flash MX
2004 Developer and Designer. I learn very easily and exam difficulty
is not an issue i'm taking into consideration.

I've read a comparison about exam's cost and other info
http://www.dbazine.com/fosdick2.shtml

and Oracle's history as well (very interesting)
http://www.informit.com/articles/article.asp?p=27317&seqNum=3

But i couldn't make a decision. In the long run, which one would you
go for? In your opinion, which one has the best ROI?

Thank you very much.

Leonardo Crespo

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189877
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: wysisyg editor for forms

[Tony Weeg]

on this note, im having issues with the image uploader, its like
putting only a 1kb file on the server with the right name/file ext.
but the file isnt really an image... just
some weird collection of 1kb of something ... 

any ideas?

thanks.
tony


On Mon, 10 Jan 2005 20:06:37 -0500, Joe Rinehart <[EMAIL PROTECTED]> wrote:
> I'm a big fan of fckeditor - I think the open source CFFM works with
> it now, as well, for uploading of images and such.
> 
> -joe
> 
> 
> On Mon, 10 Jan 2005 18:28:50 -0500, Wurst, Keith D. <[EMAIL PROTECTED]> wrote:
> > what does everyone think is the best free cf custom tag that can be 
> > implemented to allow for users to format (bold, etc.) text in a form. thank.
> >
> >
> 
> 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189876
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: Suggestion for looping over months within a time period

[Joe Rinehart]

Jim,

Why not take care of this in one query?

Something to the affect of:


SELECT cast(datepart(mm, somedate), nvarchar(2)) + '/' +
cast(datepart(, somedate), nvarchar(4)) AS MonthAndYear
FROM sometable
ORDER BY somedate ASC



  #monthAndYear#
  

  


-Joe


On Mon, 10 Jan 2005 15:02:36 -0700, Jim McAtee <[EMAIL PROTECTED]> wrote:
> What is a good way to loop over the months within a time period?  For
> example, given a starting date of 11/17/2003 and an end date of 2/19/2003,
> I'd need to loop through Nov03, Dec03, Jan04, Feb04.  Within the loop I'll
> be doing queries with a where clause like:
> 
> WHERE somedate BETWEEN #month#/1/#year#
>   AND #month#/#DaysInMonth("#month#/1/#year#")#/#year#
> 
> 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189875
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: wysisyg editor for forms

[Joe Rinehart]

I'm a big fan of fckeditor - I think the open source CFFM works with
it now, as well, for uploading of images and such.

-joe


On Mon, 10 Jan 2005 18:28:50 -0500, Wurst, Keith D. <[EMAIL PROTECTED]> wrote:
> what does everyone think is the best free cf custom tag that can be 
> implemented to allow for users to format (bold, etc.) text in a form. thank.
> 
> 

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189874
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: SQL Triggers

[Larry White]

The @@identity returns the last identity insert for a particular user
according to the documentation I read, not the last identity insert
in the database. Of course if other triggers fire after your insert
the @@identity value may be the result of another trigger insert,
and not what you expect.

>I took the liberty of rewriting your trigger for you. Just a hint, when
>posting a question like this, include the table create statements if you
>can. It makes writing the answer code easier (and in most cases correct).
>
>Remember that in triggers you have the inserted and the deleted tables. You
>can join them with any other tables in the database, so you don't have to do
>select statements to get the values. This also makes the trigger handle
>multiple inserts / updates. Remember that trigger in SQL Server one get
>executed once for the transaction. So in order to update multiple rows you
>have to use a LOOP, CURSOR, or know how to write some AWESOME SQL ;).
>
>I also remember that UPDATE can use the FROM operator to update multiple
>rows. Thus your trigger can be rewritten into just one little UPDATE
>statemenet. How cute and compact. :P
>
>
>CREATE TRIGGER dbo.MyTest ON dbo.UserTime
>FOR INSERT
>AS
>
>UPDATE ProjectCosts
>SET
>   InternalCost = ProjectCosts.InternalCost + (UR.UserRate *
>i.ActualHours),
>   ActualHours = ProjectCosts.ActualHours + i.ActualHours
>FROM
>   Orders
>   INNER JOIN inserted i
>   ON Orders.OrderID = i.OrderID
>   INNER JOIN UserRates UR
>   ON i.UserID = UR.UserID
>
>
>
>
>
>
>-Original Message-
>From: Robert Bailey [mailto:[EMAIL PROTECTED] 
>Sent: Monday, January 10, 2005 7:14 PM
>To: CF-Talk
>Subject: SQL Triggers
>
>A little rusty at the triggers I see, but here is what I got:
>
>CREATE TRIGGER dbo.MyTest ON dbo.UserTime AFTER INSERT  AS
>
>DECLARE @UserTimeProjID Int , @OrderProjID Int, @InternalCostAdd
>Int,@ActualHours Int
>
>Select @UserTimeProjID, @OrderProjID, @InternalCostAdd,@ActualHours 
>
>(
>
>SELECTUT.ProjectID, Orders.ProjectID, UR.UserRate * UT.ActualHours ,
>UT.ActualHours
>FROM Orders INNER JOIN
>  UserTime UT ON Orders.OrderID = UT.OrderID INNER
>JOIN
>  UserRates UR ON UT.UserID = UR.UserID AND
>UT.UserTimeID = @@IDENTITY
>
>)
>
>UPDATE ProjectCosts
>SET InternalCost = ProjectCosts.InternalCost + @InternalCostAdd,
>ActualHours = ProjectCosts.ActualHours + @ActualHours 
>WHERE ProjectID = @UserTimeProjID
>OR ProjectID = @OrderProjID
>go
>
>
>I am not sure if the @@identity works for the inserted row and if my
>select statement is correct. Any pointers?
>
>Robert Bailey
>Software Engineer
>813-230-9967 \\ mobile
>[EMAIL PROTECTED]
>www.recruitmax.com

~|
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:189873
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: SQL Triggers

[tonyp]

I took the liberty of rewriting your trigger for you. Just a hint, when
posting a question like this, include the table create statements if you
can. It makes writing the answer code easier (and in most cases correct).

Remember that in triggers you have the inserted and the deleted tables. You
can join them with any other tables in the database, so you don't have to do
select statements to get the values. This also makes the trigger handle
multiple inserts / updates. Remember that trigger in SQL Server one get
executed once for the transaction. So in order to update multiple rows you
have to use a LOOP, CURSOR, or know how to write some AWESOME SQL ;).

I also remember that UPDATE can use the FROM operator to update multiple
rows. Thus your trigger can be rewritten into just one little UPDATE
statemenet. How cute and compact. :P


CREATE TRIGGER dbo.MyTest ON dbo.UserTime
FOR INSERT
AS

UPDATE ProjectCosts
SET
InternalCost = ProjectCosts.InternalCost + (UR.UserRate *
i.ActualHours),
ActualHours = ProjectCosts.ActualHours + i.ActualHours
FROM
Orders
INNER JOIN inserted i
ON Orders.OrderID = i.OrderID
INNER JOIN UserRates UR
ON i.UserID = UR.UserID






-Original Message-
From: Robert Bailey [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 10, 2005 7:14 PM
To: CF-Talk
Subject: SQL Triggers

A little rusty at the triggers I see, but here is what I got:

CREATE TRIGGER dbo.MyTest ON dbo.UserTime AFTER INSERT  AS

DECLARE @UserTimeProjID Int , @OrderProjID Int, @InternalCostAdd
Int,@ActualHours Int

Select @UserTimeProjID, @OrderProjID, @InternalCostAdd,@ActualHours 

(

SELECTUT.ProjectID, Orders.ProjectID, UR.UserRate * UT.ActualHours ,
UT.ActualHours
FROM Orders INNER JOIN
  UserTime UT ON Orders.OrderID = UT.OrderID INNER
JOIN
  UserRates UR ON UT.UserID = UR.UserID AND
UT.UserTimeID = @@IDENTITY

)

UPDATE ProjectCosts
SET InternalCost = ProjectCosts.InternalCost + @InternalCostAdd,
ActualHours = ProjectCosts.ActualHours + @ActualHours 
WHERE ProjectID = @UserTimeProjID
OR ProjectID = @OrderProjID
go


I am not sure if the @@identity works for the inserted row and if my
select statement is correct. Any pointers?

Robert Bailey
Software Engineer
813-230-9967 \\ mobile
[EMAIL PROTECTED]
www.recruitmax.com




~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189872
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

Sand Box Issue, please help!!

[Joel Nath]

Hi,

I have created a sandbox security on a shared web hosting server, everything
was working last night but today when i view the same page, it gives me this
error..

"Security: The requested template has been denied access to
C:\CFusionMX\CustomTags.
The following is the internal exception message: access denied
(java.io.FilePermission C:\CFusionMX\CustomTags read)  "

not sure why it would need access to the "C:\CFusionMX\CustomTags" dir.

any sandbox gurus out there that can help???

I have all the tags enabled that I am using. and I have set the following
paths in the File/Dirs TAB.

C:\Domains\x.com\
C:\Domains\x.com\ -


also the following tags are enabled.

createObject()



the code on the page is..





 TestObj = CreateObject("component","test");












cheers
Joel


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189871
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: SQL Triggers

[tonyp]

WHOA THERE!

The biggest misconception that people have with the @@identity global
variable is that it will give you that last identity inserted for a
particular table. It actually gives you the last identity inserted for ANY
identity column in the database. In a high impact environment this could
give you the wrong value, especially if you are using it in a trigger.

I STRONGLY recommend using the SCOPE_IDENTITY(), especially in triggers.
This will give you the last value inserted into the table when using it in a
trigger since it gives you the last identity value in the scope.

Please check out the BOL for SQL Server and you will see a comparison
between SCOPE_IDENTITY() and @@IDENTITY.




-Original Message-
From: Robert Bailey [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 10, 2005 7:14 PM
To: CF-Talk
Subject: SQL Triggers

A little rusty at the triggers I see, but here is what I got:

CREATE TRIGGER dbo.MyTest ON dbo.UserTime AFTER INSERT  AS

DECLARE @UserTimeProjID Int , @OrderProjID Int, @InternalCostAdd
Int,@ActualHours Int

Select @UserTimeProjID, @OrderProjID, @InternalCostAdd,@ActualHours 

(

SELECTUT.ProjectID, Orders.ProjectID, UR.UserRate * UT.ActualHours ,
UT.ActualHours
FROM Orders INNER JOIN
  UserTime UT ON Orders.OrderID = UT.OrderID INNER
JOIN
  UserRates UR ON UT.UserID = UR.UserID AND
UT.UserTimeID = @@IDENTITY

)

UPDATE ProjectCosts
SET InternalCost = ProjectCosts.InternalCost + @InternalCostAdd,
ActualHours = ProjectCosts.ActualHours + @ActualHours 
WHERE ProjectID = @UserTimeProjID
OR ProjectID = @OrderProjID
go


I am not sure if the @@identity works for the inserted row and if my
select statement is correct. Any pointers?

Robert Bailey
Software Engineer
813-230-9967 \\ mobile
[EMAIL PROTECTED]
www.recruitmax.com




~|
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:189870
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

SQL Triggers

[Robert Bailey]

A little rusty at the triggers I see, but here is what I got:

CREATE TRIGGER dbo.MyTest ON dbo.UserTime AFTER INSERT  AS

DECLARE @UserTimeProjID Int , @OrderProjID Int, @InternalCostAdd
Int,@ActualHours Int

Select @UserTimeProjID, @OrderProjID, @InternalCostAdd,@ActualHours 

(

SELECTUT.ProjectID, Orders.ProjectID, UR.UserRate * UT.ActualHours ,
UT.ActualHours
FROM Orders INNER JOIN
  UserTime UT ON Orders.OrderID = UT.OrderID INNER
JOIN
  UserRates UR ON UT.UserID = UR.UserID AND
UT.UserTimeID = @@IDENTITY

)

UPDATE ProjectCosts
SET InternalCost = ProjectCosts.InternalCost + @InternalCostAdd,
ActualHours = ProjectCosts.ActualHours + @ActualHours 
WHERE ProjectID = @UserTimeProjID
OR ProjectID = @OrderProjID
go


I am not sure if the @@identity works for the inserted row and if my
select statement is correct. Any pointers?

Robert Bailey
Software Engineer
813-230-9967 \\ mobile
[EMAIL PROTECTED]
www.recruitmax.com


~|
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:189869
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: wysisyg editor for forms

[Matthew Walker]

This is one of the nicest:
http://tinymce.moxiecode.com/ 


-Original Message-
From: Wurst, Keith D. [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 11 January 2005 12:29 p.m.
To: CF-Talk
Subject: wysisyg editor for forms

what does everyone think is the best free cf custom tag that can be
implemented to allow for users to format (bold, etc.) text in a form. thank.




~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189868
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: Strange: Can't login to cfadmin

[Will Tomlinson]

Been looking around. Do I need to manually add port 8500? 


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189867
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: Revised Thread - Uploading CSV and Validation

[Paul Malan]

If you're using SQL Server, you can create a DTS package then call it
from CF.  I couldn't believe the difference in speed when I switched
to DTS.  (If you need to use CF to validate the incoming data, use DTS
to populate a temp table, CF to pull it out and insert the validated
data into its permanent home.  I'd wager still much quicker than using
a loop over cffile contents, though I'd be curious to know if you wind
up trying both...)


On Mon, 10 Jan 2005 17:36:09 -0500, Ken <[EMAIL PROTECTED]> wrote:
> Hi. I want to enable the user to upload a csv file, then the data
> should be validated against pre-defined criteria for different columns
> in the csv file. Once that is done, I want to write the validated
> rows from the csv file to the DB.
> 
> Please help.
> 
> Thanks,
> Ken
> 
> 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189866
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: Suggestion for looping over months within a time period

[Jeff Garza]

you are right... if  day(startDate) is greater than day(endDate) it will be 
one month shy...

So... do a little conditional logic to pad the number of loops...



   

   


Cheers,

Jeff Garza

- Original Message - 
From: "Jim McAtee" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Monday, January 10, 2005 4:18 PM
Subject: Re: Suggestion for looping over months within a time period


> Doesn't work, since DateDiff() only seems to count the number of full
> months between dates.  DateDiff("11/17/2003", "2/12/2005"), for instance,
> returns 2.




~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189865
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

Strange: Can't login to cfadmin

[Will Tomlinson]

I have a weird problem. Just loaded CF on my new computer, updater and stuff.  
It won't let me login to CFadmin. Everything is running, and I was logged in 
after the install, but now programs>Macromedia>CFMXADMIN gives you this error. 

coldfusion.tagext.lang.SettingTag.setRequestTimeout(J)V 

Here's my cfadmin page, looks right. 

http://127.0.0.1:8500/CFIDE/administrator/index.cfm

My .cfm pages are working fine. Anyone seen this?

Thanks,
Will

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189864
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

wysisyg editor for forms

[Wurst, Keith D.]

what does everyone think is the best free cf custom tag that can be implemented 
to allow for users to format (bold, etc.) text in a form. thank.


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189863
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: Suggestion for looping over months within a time period

[Larry White]

Why don't you do it all at once? Something like:



 



Select field1,field2, month(somedate) as themonth  
from sometable where somedate between
#StartDAte# and #toDate#
Order by Month(somedate)
 

Now you can just group it by month in the cfoutput using the
group attribute

>What is a good way to loop over the months within a time period?  For 
>example, given a starting date of 11/17/2003 and an end date of 2/19/2003, 
>I'd need to loop through Nov03, Dec03, Jan04, Feb04.  Within the loop I'll 
>be doing queries with a where clause like:
>
>WHERE somedate BETWEEN #month#/1/#year#
>  AND #month#/#DaysInMonth("#month#/1/#year#")#/#year#

~|
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:189862
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: Suggestion for looping over months within a time period

[Jim McAtee]

Doesn't work, since DateDiff() only seems to count the number of full 
months between dates.  DateDiff("11/17/2003", "2/12/2005"), for instance, 
returns 2.


- Original Message - 
From: "Jeff Garza" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Monday, January 10, 2005 3:25 PM
Subject: Re: Suggestion for looping over months within a time period


> This works for me...
>
> 
> 
> 
> 
> Difference in Months: #numMonths#
>
> 
> 
>Year(DateAdd("m", i, startDate))>
>"/"
> & Year(baseDate)>
>   StartDate = #baseDAte# ||| EndDate =
> #baseEndDate#
> 
>
> Hope this helps...
>
> Jeff Garza
>
> - Original Message - 
> From: "Jim McAtee" <[EMAIL PROTECTED]>
> To: "CF-Talk" 
> Sent: Monday, January 10, 2005 3:02 PM
> Subject: Suggestion for looping over months within a time period
>
>
>> What is a good way to loop over the months within a time period?  For
>> example, given a starting date of 11/17/2003 and an end date of 
>> 2/19/2003,
>> I'd need to loop through Nov03, Dec03, Jan04, Feb04.  Within the loop 
>> I'll
>> be doing queries with a where clause like:
>>
>> WHERE somedate BETWEEN #month#/1/#year#
>>  AND #month#/#DaysInMonth("#month#/1/#year#")#/#year# 


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189861
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: How to add images to my db the *right* way?

[Will Tomlinson]

Just have a look at my schema whenever you get the time. It has most of what 
you're talking about. 

I appreciate it. 

Will

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189860
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: Revised Thread - Uploading CSV and Validation

[Larry White]

Treat it as two lists. The first using Chr(13) or Chr(10) as 
a delimiter, the second using ",":





 Continue for all columns and validate
Insert into DB here


each loop of idx will provide the next row of data to be inserted.


>Hi. I want to enable the user to upload a csv file, then the data
>should be validated against pre-defined criteria for different columns
>in the csv file. Once that is done, I want to write the validated
>rows from the csv file to the DB.
>
>Please help.
>
>Thanks,
>Ken

~|
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:189859
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: How to add images to my db the *right* way?

[dave]

lol, did i really say that?? sorry bout that, get carried away sometimes!
but once u excape the horrid grasp of ms u will be amazed how easy it is to 
validate!! (no joke and in all seriousness)

ok, i dont have a ton of time to look over the stuff yet, i have a cf usergroup 
meeting in a bit but heres my first thoughts

on ypour seperate tables, i guess i wasnt thinking last email, i would your 
seperate tables for some things, such as colors, sizes, styles, lines.
then fill those with the standards (can be updatable as well), then make one 
table and each record will contain all the info on each piece but it will pull 
a lot of the info from the cfc to fill the table when each piece is entered.
stuff like sizes can be input as a csv

does that make any sense?

-- Original Message --
From: Will Tomlinson <[EMAIL PROTECTED]>
Reply-To: cf-talk@houseoffusion.com
Date:  Mon, 10 Jan 2005 17:42:27 -0400

>> lol
>> im trying to be good remember? but u set yourself up 4 it! badly!!
>
>I know! I know!
>> 
>> ok, i didnt read some of the posts but what i did read didnt make 
>> sense.
>> u had a seperate table for colors? and r u putting the images into the 
>> db or just the paths?
>
>When it comes to colors, I have three tables linking up right now. 
>Hang on. I'm gonna just put the schema up on my site. You know, the one that 
>doesn't validate.  :) heehee. 
>
>Ok, got it up there: http://www.wtomlinson.com/schema.htm
>
>It's all working great, except my image db design. It sucks! Lemme know what 
>you think. 
>
>Thanks,
>Will
>
>
>

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189858
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: How to add images to my db the *right* way?

[Will Tomlinson]

> lol
> im trying to be good remember? but u set yourself up 4 it! badly!!

I know! I know!
> 
> ok, i didnt read some of the posts but what i did read didnt make 
> sense.
> u had a seperate table for colors? and r u putting the images into the 
> db or just the paths?

When it comes to colors, I have three tables linking up right now. 
Hang on. I'm gonna just put the schema up on my site. You know, the one that 
doesn't validate.  :) heehee. 

Ok, got it up there: http://www.wtomlinson.com/schema.htm

It's all working great, except my image db design. It sucks! Lemme know what 
you think. 

Thanks,
Will


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189857
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

Revised Thread - Uploading CSV and Validation

[Ken]

Hi. I want to enable the user to upload a csv file, then the data
should be validated against pre-defined criteria for different columns
in the csv file. Once that is done, I want to write the validated
rows from the csv file to the DB.

Please help.

Thanks,
Ken

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189856
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: Suggestion for looping over months within a time period

[Jeff Garza]

This works for me...





Difference in Months: #numMonths#



   
   
   StartDate = #baseDAte# ||| EndDate = 
#baseEndDate#


Hope this helps...

Jeff Garza

- Original Message - 
From: "Jim McAtee" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Monday, January 10, 2005 3:02 PM
Subject: Suggestion for looping over months within a time period


> What is a good way to loop over the months within a time period?  For
> example, given a starting date of 11/17/2003 and an end date of 2/19/2003,
> I'd need to loop through Nov03, Dec03, Jan04, Feb04.  Within the loop I'll
> be doing queries with a where clause like:
>
> WHERE somedate BETWEEN #month#/1/#year#
>  AND #month#/#DaysInMonth("#month#/1/#year#")#/#year#
>
>
> 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189855
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: How to add images to my db the *right* way?

[dave]

lol
im trying to be good remember? but u set yourself up 4 it! badly!!

ok, i didnt read some of the posts but what i did read didnt make sense.
u had a seperate table for colors? and r u putting the images into the db or 
just the paths?

im making a ecomm clothes site as well, even though it will be flash driven the 
basics will be the same.

why loop it to get the info?
are u having troubles uploading more than 1 file field at a time? cause thats a 
bit tricky but is easily done

not sure how u'd do it with your glorified frontpage program though ;)

u remember the glorified windows ME dont ya? was also known as windows 95 ;)

 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189854
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

Suggestion for looping over months within a time period

[Jim McAtee]

What is a good way to loop over the months within a time period?  For 
example, given a starting date of 11/17/2003 and an end date of 2/19/2003, 
I'd need to loop through Nov03, Dec03, Jan04, Feb04.  Within the loop I'll 
be doing queries with a where clause like:

WHERE somedate BETWEEN #month#/1/#year#
  AND #month#/#DaysInMonth("#month#/1/#year#")#/#year# 


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189853
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

Uploading Excel and Validating

[Ken]

Hi. I want to enable the user to upload a excel sheet, then the data
should be validated against pre-defined criteria for different columns
in the excel sheet. Once that is done, I want to write the validated
rows from the excel sheet to the DB.

Please help.

Thanks,
Ken

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189852
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: Regex Help.

[Ben Doom]

But if you use a lowercase d.

[\d] is not digits, it's a lowercase d or a backslash.  :-)

--Ben

Greg Morphis wrote:
> 
> 
> 
> 
> #rval#
> 
> yields 0 (did not validate).
> 
> 
> On Mon, 10 Jan 2005 15:57:11 -0500, DURETTE, STEVEN J (AIT)
> <[EMAIL PROTECTED]> wrote:
> 
>>Opps,
>>
>>That didn't work after all.  User puts in D and it evaluates to true
>>with that reg ex.
>>
>>Steve


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189851
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: How to get file information?

[Kazmierczak, Kevin]

Yeah, I went with cfdirectory with the filter and it responded in about
10 ms to my surprise.  The folder should stay small, so hopefully it
won't slow down too much.

Thanks.

Kevin.

-Original Message-
From: Al Everett [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 10, 2005 3:56 PM
To: CF-Talk
Subject: Re: How to get file information?

I just tested it with CF5 on a desktop-class machine on a directory of
~ 47,000 GIF and JPEG images each between 15k and 30k in size.

CFDIRECTORY with a filename in the "Filter" attribute came back in 120
ms. 20 of that for CFDUMP and 100 for STARTUP, PARSING, & SHUTDOWN.

Seems pretty quick to me.


On Mon, 10 Jan 2005 15:45:15 -0500, Katz, Dov B (IT)
<[EMAIL PROTECTED]> wrote:
> Are you positive that CFDIRECTORY doesn't list files and apply the
> filter?  One easy way to tell is to do this file check in a directory
> with 10,000 files.  Id' hypothesize that cfdirectory takes significant
> longer than a java.io.File construction
> 
> I could be wrong, as this is all speculation.
> 
> dov
> 
> -Original Message-
> From: Calvin Ward [mailto:[EMAIL PROTECTED]
> Sent: Monday, January 10, 2005 2:54 PM
> To: CF-Talk
> Subject: RE: How to get file information?
> 
> Actually, it wouldn't have to iterate
> 
>  filter="myfile.ext">
> 
> Should just return the single file.
> 
> - Calvin
> 
> -Original Message-
> From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED]
> Sent: Monday, January 10, 2005 2:32 PM
> To: CF-Talk
> Subject: RE: How to get file information?
> 
> CFDirectory is probably not that performant, as it has to iterate
> through the file list to find the file you want.
> 
> I suggest
> 
>   myFile.init("#expandpath(yourfile...etc)#")>
> 
> Then you have access to all java.io.File's rich method library, such
as
> length(), canRead(), exists(), delete(), isDirectory() etc
> 
> Not sure about performance tradeoff, but definitely more features
doing
> it this way...
> 
> -Dov
> 
> -Original Message-
> From: Al Everett [mailto:[EMAIL PROTECTED]
> Sent: Monday, January 10, 2005 2:18 PM
> To: CF-Talk
> Subject: Re: How to get file information?
> 
> Use CFDIRECTORY with the "Filter" attribute. Then you'll only get
> information about your specific file.
> 
> On Mon, 10 Jan 2005 14:16:56 -0500, Kazmierczak, Kevin
> <[EMAIL PROTECTED]> wrote:
> > How would one get information on a file from CF?  I want to know
when
> > the file was last modified.  I know I could use cfdirectory and loop
> > over the directory contents and get it that way but that seems like
> > WAY too much work just to get the date on one file.
> >
> > How come you can't use cffile variables on anything but an upload?
> > Wouldn't it be helpful on all cffile actions?  They should have a
> > cffile action="readattribs" or something.
> >
> > Is this too much to ask for? Or am I missing something. This is on
> cf5.
> > I could probably use a java to pull the information on MX, but that
> > isn't an option.
> >
> > Thanks.
> >
> > Kevin.
> >
> >
> 
> 



~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189850
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: search engine friendly urls

[Duncan I Loxton]

I was just wondering if Fusebox 3 and 4 had this natively, Bert - how
do I approach this and use it? All our apps use FB3 4.5 and we are
moving them slowly but surely to MX and FB4.

Duncan


On Mon, 10 Jan 2005 06:55:50 -0500, Doug Hughes <[EMAIL PROTECTED]> wrote:
> Here's a tutorial I wrote:
> 
> http://www.doughughes.net/index.cfm/page-blogLink/entryId-45
> 
> And here's a gotcha if you use jrun:
> 
> http://www.doughughes.net/index.cfm/page-blogLink/entryId-37
> 
> 
> On Mon, 10 Jan 2005 06:28:36 -0400, Jack Dalaa <[EMAIL PROTECTED]> wrote:
> > If you're on IIS, I highly recommend downloading ISAPI Rewrite 
> > (www.isapirewrite.com), then use the following rules in httpd.ini:
> >
> > [ISAPI_Rewrite]
> > RepeatLimit 20
> >
> > # Defend your computer from some worm attacks
> > RewriteRule (/dyn/.*?)(\?[^/]*)?/([^/]*)/([^/]*)(.+?)? 
> > $1(?2$2&:\?)$3=$4?5$5: [N,I]
> > RewriteRule /dyn(.+?)/?(\?.*)? $1.cfm$2 [I]
> >
> > .. You can change the 'dyn' to whatever you want, but that would enable 
> > URL's like:
> >
> > http://www.abc.com/dyn/info/articleid/34
> >
> > http://www.abc.com/info.cfm?articleid=34
> >
> > All URL's without the /dyn/ (or whatever you decide) will be processed 
> > normally.
> >
> > With a bit of foresight in naming your pages and variables, you can 
> > accomplish fancy URL's like:
> >
> > http://www.abc.com/dyn/view/product/shoes
> >
> > Have fun!
> >
> > Jack
> >
> > >Can anyone point me in the direction of a tag or tutorial on how to
> > >convert a url and all its bits into a Search engine firendly one? i.e.
> > >uses all \ rather than the standard ? and = and &
> > >
> > >Specifically for CF 4.5 right now, but also for MX later.
> > >
> > >And is it really worth doing? Will it make it easier to get our sites
> > >into engines other than google?
> > >
> > >What are the arguments against doing it?
> > >
> > >Thanks
> > >
> > >Duncan
> >
> >
> 
> 

~|
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:189849
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: Ok, here's a brute

[Bryan Stevenson]

I'd start putting breaks in your code just before and then after suspect 
code blocks (using cfabort).  Keep moving the cfabort further along through 
your code until the error happens againthen you know the error is after 
that last spot the cfabort was and before where it is when it errors.

This is all of course assuming that it's your code and not something 
specific to your installed version of IE and or something on your computer.

HTH

Cheers

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com 


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189848
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: Regex Help.

[Greg Morphis]

#rval#

yields 0 (did not validate).


On Mon, 10 Jan 2005 15:57:11 -0500, DURETTE, STEVEN J (AIT)
<[EMAIL PROTECTED]> wrote:
> Opps,
> 
> That didn't work after all.  User puts in D and it evaluates to true
> with that reg ex.
> 
> Steve
> 
> 
> -Original Message-
> From: Greg Morphis [mailto:[EMAIL PROTECTED]
> Sent: Monday, January 10, 2005 2:57 PM
> To: CF-Talk
> Subject: Re: Regex Help.
> 
> ^[\d]*([.]?[\d]{1,2})?$
> 
> there that will catch 9, 9.9, 9.99, will not catch 9. 9.9.9, etc
> 
> On Mon, 10 Jan 2005 13:51:23 -0600, Greg Morphis <[EMAIL PROTECTED]>
> wrote:
> > I think this will work..
> > ^\d{1,2}.\d{1,2}$
> >
> > (not tested)
> >
> >
> > On Mon, 10 Jan 2005 14:43:27 -0500, DURETTE, STEVEN J (AIT)
> > <[EMAIL PROTECTED]> wrote:
> > > Hi All,
> > >
> > > Need some help with a regex.  What I'm trying to do is validate and
> > > input in javascript.
> > >
> > > The users are allowed to input a number.
> > >
> > > It can be in the following formats:
> > > 9
> > > 9.9
> > > 9.99
> > > .99
> > > .9
> > >
> > > (9 used inplace of any digit.)
> > >
> > > I tried using \b[0-9.]+  and I've tried \b[\d]*([.]?[\d]{0,2})? and
> I've
> > > tried  ([\d]*([.][\d]{1,2})?){1} but I can't seem to get the
> response
> > > that I want.
> > >
> > > The user can still input numbers such as 1.25.25 and it will pass
> the
> > > regex test.
> > >
> > > To be more specific in what I'm looking for, the users are putting
> in
> > > hours and partial hours.
> > > There can be any amount of hours, but partial hours are limited to
> .0,
> > > .00,.25, .5, .50, .75 or no decimal part whatsoever. (I've been
> trying
> > > to do the .25, .5, etc in another part of the javascript, but if I
> can
> > > do it in the regex even better.)
> > >
> > > Anybody got any ideas.
> > >
> > > Thanks
> > > Steve
> > >
> > >
> 
> 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189847
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

Ok, here's a brute

[Ian Skinner]

Any hints on where I can start debugging why a form I have now complete crashes 
the IE browser when I submit it?  No error displayed until a dialog appears 
with this header "Microsoft Internet Explorer has encountered a problem and 
needs to close.  We are sorry for the inconvenience." The dialog then allows 
one to "Send Error Report" or "Don't Send."  After that IE closes and then 
restarts.
 
I haven't a clue on where to start with this.
 
The Major Players
IE 5.5
Win 2000 Server
CF 6.1 

--
Ian Skinner
Web Programmer
BloodSource

 www.BloodSource.org  
Sacramento, CA

"C code. C code run. Run code run. Please!"
- Cynthia Dunning
 

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 




~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189846
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: How to add images to my db the *right* way?

[Will Tomlinson]

>I love ya, but I had to do it. Shoot me, sue me, whatever, it's Monday
>from hell here and I could NOT pass it up!


BANG BANG!!!

:)  

Waiting for dave to roll in and finish me off now. 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189845
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: Regex Help.

[DURETTE, STEVEN J \(AIT\)]

Opps,

That didn't work after all.  User puts in D and it evaluates to true
with that reg ex.

Steve


-Original Message-
From: Greg Morphis [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 10, 2005 2:57 PM
To: CF-Talk
Subject: Re: Regex Help.


^[\d]*([.]?[\d]{1,2})?$


there that will catch 9, 9.9, 9.99, will not catch 9. 9.9.9, etc



On Mon, 10 Jan 2005 13:51:23 -0600, Greg Morphis <[EMAIL PROTECTED]>
wrote:
> I think this will work..
> ^\d{1,2}.\d{1,2}$
> 
> (not tested)
> 
> 
> On Mon, 10 Jan 2005 14:43:27 -0500, DURETTE, STEVEN J (AIT)
> <[EMAIL PROTECTED]> wrote:
> > Hi All,
> >
> > Need some help with a regex.  What I'm trying to do is validate and
> > input in javascript.
> >
> > The users are allowed to input a number.
> >
> > It can be in the following formats:
> > 9
> > 9.9
> > 9.99
> > .99
> > .9
> >
> > (9 used inplace of any digit.)
> >
> > I tried using \b[0-9.]+  and I've tried \b[\d]*([.]?[\d]{0,2})? and
I've
> > tried  ([\d]*([.][\d]{1,2})?){1} but I can't seem to get the
response
> > that I want.
> >
> > The user can still input numbers such as 1.25.25 and it will pass
the
> > regex test.
> >
> > To be more specific in what I'm looking for, the users are putting
in
> > hours and partial hours.
> > There can be any amount of hours, but partial hours are limited to
.0,
> > .00,.25, .5, .50, .75 or no decimal part whatsoever. (I've been
trying
> > to do the .25, .5, etc in another part of the javascript, but if I
can
> > do it in the regex even better.)
> >
> > Anybody got any ideas.
> >
> > Thanks
> > Steve
> >
> > 



~|
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:189844
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: How to add images to my db the *right* way?

[Donna French]

Hey Will -

I'm going to give you a little H$LL here on the list - all in good
humor of course - and only because you and I have chatted off list.

But that code you posted sure looks a lot like CF and not .NET.

LMAO

I love ya, but I had to do it. Shoot me, sue me, whatever, it's Monday
from hell here and I could NOT pass it up!

;-)


Donna




On Mon, 10 Jan 2005 15:50:38 -0400, Will Tomlinson <[EMAIL PROTECTED]> wrote:
> I'm almost finished with the coding on my clothing e-commerce site, but I'm 
> running into a few minor snags.
> 
> When dealing with images, I usually just add a few image fields in the main 
> table, image1,2,3,etc. It usually works fine and I built this stupidly 
> elaborate process for updating and deleting them. But this clothing db is a 
> little different and the image setup needs to be done right for it all to 
> work as I need.
> 
> Everything revolves around a model of clothing. The tblprodmodels table has: 
> prodmodelcode-PK varchar
> prodsellprice
> title
> category
> etc.
> 
> I also have a tblavailablecolors with
> availablecolorID - PK (int-autnum)
> prodmodelcode  - FK from tblprodmodels
> colorname  FK  from tblallcolors
> 
> tblallcolors is just a lookup or validation table.
> 
> Everything works great with me looping available colors into tblavailable 
> colors with a multiple select menu like so:
> 
>  
>  INSERT INTO tblavailablecolors (colorname, prodmodelcode)
>VALUES ('#FORM.prodcolor#', #FORM.model#)
>  
> 
> The problem arises with having, say 10 filefields to upload to my db.
> I'm uploading and saving each filename with no problem, but how do I loop the 
> filenames into the table?
> 
> Actually, I need a new linking table. tblavailableimages? Hell, I'm having a 
> brainfart here! How should I tie in the images for a model? And tie it with a 
> color at the same time?
> 
> GR!!!
> 
> Will
> 
> 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189843
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: How to get file information?

[Al Everett]

I just tested it with CF5 on a desktop-class machine on a directory of
~ 47,000 GIF and JPEG images each between 15k and 30k in size.

CFDIRECTORY with a filename in the "Filter" attribute came back in 120
ms. 20 of that for CFDUMP and 100 for STARTUP, PARSING, & SHUTDOWN.

Seems pretty quick to me.


On Mon, 10 Jan 2005 15:45:15 -0500, Katz, Dov B (IT)
<[EMAIL PROTECTED]> wrote:
> Are you positive that CFDIRECTORY doesn't list files and apply the
> filter?  One easy way to tell is to do this file check in a directory
> with 10,000 files.  Id' hypothesize that cfdirectory takes significant
> longer than a java.io.File construction
> 
> I could be wrong, as this is all speculation.
> 
> dov
> 
> -Original Message-
> From: Calvin Ward [mailto:[EMAIL PROTECTED]
> Sent: Monday, January 10, 2005 2:54 PM
> To: CF-Talk
> Subject: RE: How to get file information?
> 
> Actually, it wouldn't have to iterate
> 
>  filter="myfile.ext">
> 
> Should just return the single file.
> 
> - Calvin
> 
> -Original Message-
> From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED]
> Sent: Monday, January 10, 2005 2:32 PM
> To: CF-Talk
> Subject: RE: How to get file information?
> 
> CFDirectory is probably not that performant, as it has to iterate
> through the file list to find the file you want.
> 
> I suggest
> 
>   myFile.init("#expandpath(yourfile...etc)#")>
> 
> Then you have access to all java.io.File's rich method library, such as
> length(), canRead(), exists(), delete(), isDirectory() etc
> 
> Not sure about performance tradeoff, but definitely more features doing
> it this way...
> 
> -Dov
> 
> -Original Message-
> From: Al Everett [mailto:[EMAIL PROTECTED]
> Sent: Monday, January 10, 2005 2:18 PM
> To: CF-Talk
> Subject: Re: How to get file information?
> 
> Use CFDIRECTORY with the "Filter" attribute. Then you'll only get
> information about your specific file.
> 
> On Mon, 10 Jan 2005 14:16:56 -0500, Kazmierczak, Kevin
> <[EMAIL PROTECTED]> wrote:
> > How would one get information on a file from CF?  I want to know when
> > the file was last modified.  I know I could use cfdirectory and loop
> > over the directory contents and get it that way but that seems like
> > WAY too much work just to get the date on one file.
> >
> > How come you can't use cffile variables on anything but an upload?
> > Wouldn't it be helpful on all cffile actions?  They should have a
> > cffile action="readattribs" or something.
> >
> > Is this too much to ask for? Or am I missing something. This is on
> cf5.
> > I could probably use a java to pull the information on MX, but that
> > isn't an option.
> >
> > Thanks.
> >
> > Kevin.
> >
> >
> 
> 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189842
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

How to add images to my db the *right* way?

[Will Tomlinson]

I'm almost finished with the coding on my clothing e-commerce site, but I'm 
running into a few minor snags. 

When dealing with images, I usually just add a few image fields in the main 
table, image1,2,3,etc. It usually works fine and I built this stupidly 
elaborate process for updating and deleting them. But this clothing db is a 
little different and the image setup needs to be done right for it all to work 
as I need. 

Everything revolves around a model of clothing. The tblprodmodels table has: 
prodmodelcode-PK varchar
prodsellprice
title
category
etc. 

I also have a tblavailablecolors with
availablecolorID - PK (int-autnum)
prodmodelcode  - FK from tblprodmodels
colorname  FK  from tblallcolors

tblallcolors is just a lookup or validation table. 

Everything works great with me looping available colors into tblavailable 
colors with a multiple select menu like so:
 
  
  INSERT INTO tblavailablecolors (colorname, prodmodelcode)
VALUES ('#FORM.prodcolor#', #FORM.model#) 
  

The problem arises with having, say 10 filefields to upload to my db. 
I'm uploading and saving each filename with no problem, but how do I loop the 
filenames into the table? 

Actually, I need a new linking table. tblavailableimages? Hell, I'm having a 
brainfart here! How should I tie in the images for a model? And tie it with a 
color at the same time?

GR!!!

Will



 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189841
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: How to get file information?

[Katz, Dov B (IT)]

Are you positive that CFDIRECTORY doesn't list files and apply the
filter?  One easy way to tell is to do this file check in a directory
with 10,000 files.  Id' hypothesize that cfdirectory takes significant
longer than a java.io.File construction

I could be wrong, as this is all speculation. 

dov

-Original Message-
From: Calvin Ward [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 10, 2005 2:54 PM
To: CF-Talk
Subject: RE: How to get file information?

Actually, it wouldn't have to iterate



Should just return the single file.

- Calvin

-Original Message-
From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED]
Sent: Monday, January 10, 2005 2:32 PM
To: CF-Talk
Subject: RE: How to get file information?

 
CFDirectory is probably not that performant, as it has to iterate
through the file list to find the file you want.

I suggest 

 

Then you have access to all java.io.File's rich method library, such as
length(), canRead(), exists(), delete(), isDirectory() etc

Not sure about performance tradeoff, but definitely more features doing
it this way...

-Dov

-Original Message-
From: Al Everett [mailto:[EMAIL PROTECTED]
Sent: Monday, January 10, 2005 2:18 PM
To: CF-Talk
Subject: Re: How to get file information?

Use CFDIRECTORY with the "Filter" attribute. Then you'll only get
information about your specific file.


On Mon, 10 Jan 2005 14:16:56 -0500, Kazmierczak, Kevin
<[EMAIL PROTECTED]> wrote:
> How would one get information on a file from CF?  I want to know when 
> the file was last modified.  I know I could use cfdirectory and loop 
> over the directory contents and get it that way but that seems like 
> WAY too much work just to get the date on one file.
> 
> How come you can't use cffile variables on anything but an upload?
> Wouldn't it be helpful on all cffile actions?  They should have a 
> cffile action="readattribs" or something.
> 
> Is this too much to ask for? Or am I missing something. This is on
cf5.
> I could probably use a java to pull the information on MX, but that 
> isn't an option.
> 
> Thanks.
> 
> Kevin.
> 
> 







~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189840
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: John Dowdell Wants to Know What's Wrong with Macromedia

[Dave Watts]

> Speaking of SSL and RDS, is there anyway to present a 
> certificate with RDS? We have found no way tell studio to 
> present a cert to https server.

The last time I used CF Studio with RDS, I seem to recall that Studio used
Internet Explorer's settings and functionality. I've never used RDS with
client certificates, though.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized 
instruction at our training centers in Washington DC, Atlanta, 
Chicago, Baltimore, Northern Virginia, or on-site at your location. 
Visit http://training.figleaf.com/ for more information!


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189839
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: Regex Help.

[DURETTE, STEVEN J \(AIT\)]

Thanks, That did it.

-Original Message-
From: Greg Morphis [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 10, 2005 2:57 PM
To: CF-Talk
Subject: Re: Regex Help.


^[\d]*([.]?[\d]{1,2})?$


there that will catch 9, 9.9, 9.99, will not catch 9. 9.9.9, etc



On Mon, 10 Jan 2005 13:51:23 -0600, Greg Morphis <[EMAIL PROTECTED]>
wrote:
> I think this will work..
> ^\d{1,2}.\d{1,2}$
> 
> (not tested)
> 
> 
> On Mon, 10 Jan 2005 14:43:27 -0500, DURETTE, STEVEN J (AIT)
> <[EMAIL PROTECTED]> wrote:
> > Hi All,
> >
> > Need some help with a regex.  What I'm trying to do is validate and
> > input in javascript.
> >
> > The users are allowed to input a number.
> >
> > It can be in the following formats:
> > 9
> > 9.9
> > 9.99
> > .99
> > .9
> >
> > (9 used inplace of any digit.)
> >
> > I tried using \b[0-9.]+  and I've tried \b[\d]*([.]?[\d]{0,2})? and
I've
> > tried  ([\d]*([.][\d]{1,2})?){1} but I can't seem to get the
response
> > that I want.
> >
> > The user can still input numbers such as 1.25.25 and it will pass
the
> > regex test.
> >
> > To be more specific in what I'm looking for, the users are putting
in
> > hours and partial hours.
> > There can be any amount of hours, but partial hours are limited to
.0,
> > .00,.25, .5, .50, .75 or no decimal part whatsoever. (I've been
trying
> > to do the .25, .5, etc in another part of the javascript, but if I
can
> > do it in the regex even better.)
> >
> > Anybody got any ideas.
> >
> > Thanks
> > Steve
> >
> > 



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189838
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: John Dowdell Wants to Know What's Wrong with Macromedia

[Dave Watts]

> I didn't think that RDS was for production systems?

It isn't. Neither is WebDAV, in my opinion. I'm reluctant to allow people to
edit files via HTTP on production systems in general.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized 
instruction at our training centers in Washington DC, Atlanta, 
Chicago, Baltimore, Northern Virginia, or on-site at your location. 
Visit http://training.figleaf.com/ for more information!

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189837
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: Regex Help.

[Greg Morphis]

^[\d]*([.]?[\d]{1,2})?$


there that will catch 9, 9.9, 9.99, will not catch 9. 9.9.9, etc



On Mon, 10 Jan 2005 13:51:23 -0600, Greg Morphis <[EMAIL PROTECTED]> wrote:
> I think this will work..
> ^\d{1,2}.\d{1,2}$
> 
> (not tested)
> 
> 
> On Mon, 10 Jan 2005 14:43:27 -0500, DURETTE, STEVEN J (AIT)
> <[EMAIL PROTECTED]> wrote:
> > Hi All,
> >
> > Need some help with a regex.  What I'm trying to do is validate and
> > input in javascript.
> >
> > The users are allowed to input a number.
> >
> > It can be in the following formats:
> > 9
> > 9.9
> > 9.99
> > .99
> > .9
> >
> > (9 used inplace of any digit.)
> >
> > I tried using \b[0-9.]+  and I've tried \b[\d]*([.]?[\d]{0,2})? and I've
> > tried  ([\d]*([.][\d]{1,2})?){1} but I can't seem to get the response
> > that I want.
> >
> > The user can still input numbers such as 1.25.25 and it will pass the
> > regex test.
> >
> > To be more specific in what I'm looking for, the users are putting in
> > hours and partial hours.
> > There can be any amount of hours, but partial hours are limited to .0,
> > .00,.25, .5, .50, .75 or no decimal part whatsoever. (I've been trying
> > to do the .25, .5, etc in another part of the javascript, but if I can
> > do it in the regex even better.)
> >
> > Anybody got any ideas.
> >
> > Thanks
> > Steve
> >
> > 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189836
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: How to get file information?

[Calvin Ward]

Actually, it wouldn't have to iterate



Should just return the single file.

- Calvin

-Original Message-
From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 10, 2005 2:32 PM
To: CF-Talk
Subject: RE: How to get file information?

 
CFDirectory is probably not that performant, as it has to iterate
through the file list to find the file you want.

I suggest 




Then you have access to all java.io.File's rich method library, such as
length(), canRead(), exists(), delete(), isDirectory() etc

Not sure about performance tradeoff, but definitely more features doing
it this way...

-Dov

-Original Message-
From: Al Everett [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 10, 2005 2:18 PM
To: CF-Talk
Subject: Re: How to get file information?

Use CFDIRECTORY with the "Filter" attribute. Then you'll only get
information about your specific file.


On Mon, 10 Jan 2005 14:16:56 -0500, Kazmierczak, Kevin
<[EMAIL PROTECTED]> wrote:
> How would one get information on a file from CF?  I want to know when 
> the file was last modified.  I know I could use cfdirectory and loop 
> over the directory contents and get it that way but that seems like 
> WAY too much work just to get the date on one file.
> 
> How come you can't use cffile variables on anything but an upload?
> Wouldn't it be helpful on all cffile actions?  They should have a 
> cffile action="readattribs" or something.
> 
> Is this too much to ask for? Or am I missing something. This is on
cf5.
> I could probably use a java to pull the information on MX, but that 
> isn't an option.
> 
> Thanks.
> 
> Kevin.
> 
> 





~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189835
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: Regex Help.

[Greg Morphis]

I think this will work..
^\d{1,2}.\d{1,2}$


(not tested)



On Mon, 10 Jan 2005 14:43:27 -0500, DURETTE, STEVEN J (AIT)
<[EMAIL PROTECTED]> wrote:
> Hi All,
> 
> Need some help with a regex.  What I'm trying to do is validate and
> input in javascript.
> 
> The users are allowed to input a number.
> 
> It can be in the following formats:
> 9
> 9.9
> 9.99
> .99
> .9
> 
> (9 used inplace of any digit.)
> 
> I tried using \b[0-9.]+  and I've tried \b[\d]*([.]?[\d]{0,2})? and I've
> tried  ([\d]*([.][\d]{1,2})?){1} but I can't seem to get the response
> that I want.
> 
> The user can still input numbers such as 1.25.25 and it will pass the
> regex test.
> 
> To be more specific in what I'm looking for, the users are putting in
> hours and partial hours.
> There can be any amount of hours, but partial hours are limited to .0,
> .00,.25, .5, .50, .75 or no decimal part whatsoever. (I've been trying
> to do the .25, .5, etc in another part of the javascript, but if I can
> do it in the regex even better.)
> 
> Anybody got any ideas.
> 
> Thanks
> Steve
> 
> 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189834
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: Regex Help.

[Tony Hicks]

Can you use isNaN here?

Just use it on your number to verify that it is or is not a number...
what's your code look like?


On Mon, 10 Jan 2005 14:43:27 -0500, DURETTE, STEVEN J (AIT)
<[EMAIL PROTECTED]> wrote:
> Hi All,
> 
> Need some help with a regex.  What I'm trying to do is validate and
> input in javascript.
> 
> The users are allowed to input a number.
> 
> It can be in the following formats:
> 9
> 9.9
> 9.99
> .99
> .9
> 
> (9 used inplace of any digit.)
> 
> I tried using \b[0-9.]+  and I've tried \b[\d]*([.]?[\d]{0,2})? and I've
> tried  ([\d]*([.][\d]{1,2})?){1} but I can't seem to get the response
> that I want.
> 
> The user can still input numbers such as 1.25.25 and it will pass the
> regex test.
> 
> To be more specific in what I'm looking for, the users are putting in
> hours and partial hours.
> There can be any amount of hours, but partial hours are limited to .0,
> .00,.25, .5, .50, .75 or no decimal part whatsoever. (I've been trying
> to do the .25, .5, etc in another part of the javascript, but if I can
> do it in the regex even better.)
> 
> Anybody got any ideas.
> 
> Thanks
> Steve
> 
> 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189833
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

Regex Help.

[DURETTE, STEVEN J \(AIT\)]

Hi All,
 
Need some help with a regex.  What I'm trying to do is validate and
input in javascript.
 
The users are allowed to input a number.
 
It can be in the following formats:
9
9.9
9.99
.99
.9
 
(9 used inplace of any digit.)
 
I tried using \b[0-9.]+  and I've tried \b[\d]*([.]?[\d]{0,2})? and I've
tried  ([\d]*([.][\d]{1,2})?){1} but I can't seem to get the response
that I want.
 
The user can still input numbers such as 1.25.25 and it will pass the
regex test.
 
To be more specific in what I'm looking for, the users are putting in
hours and partial hours.
There can be any amount of hours, but partial hours are limited to .0,
.00,.25, .5, .50, .75 or no decimal part whatsoever. (I've been trying
to do the .25, .5, etc in another part of the javascript, but if I can
do it in the regex even better.)
 
Anybody got any ideas.
 
Thanks
Steve
 


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189832
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: How to get file information?

[Katz, Dov B (IT)]

 
CFDirectory is probably not that performant, as it has to iterate
through the file list to find the file you want.

I suggest 




Then you have access to all java.io.File's rich method library, such as
length(), canRead(), exists(), delete(), isDirectory() etc

Not sure about performance tradeoff, but definitely more features doing
it this way...

-Dov

-Original Message-
From: Al Everett [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 10, 2005 2:18 PM
To: CF-Talk
Subject: Re: How to get file information?

Use CFDIRECTORY with the "Filter" attribute. Then you'll only get
information about your specific file.


On Mon, 10 Jan 2005 14:16:56 -0500, Kazmierczak, Kevin
<[EMAIL PROTECTED]> wrote:
> How would one get information on a file from CF?  I want to know when 
> the file was last modified.  I know I could use cfdirectory and loop 
> over the directory contents and get it that way but that seems like 
> WAY too much work just to get the date on one file.
> 
> How come you can't use cffile variables on anything but an upload?
> Wouldn't it be helpful on all cffile actions?  They should have a 
> cffile action="readattribs" or something.
> 
> Is this too much to ask for? Or am I missing something. This is on
cf5.
> I could probably use a java to pull the information on MX, but that 
> isn't an option.
> 
> Thanks.
> 
> Kevin.
> 
> 



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189831
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: How to get file information?

[Al Everett]

Use CFDIRECTORY with the "Filter" attribute. Then you'll only get
information about your specific file.


On Mon, 10 Jan 2005 14:16:56 -0500, Kazmierczak, Kevin
<[EMAIL PROTECTED]> wrote:
> How would one get information on a file from CF?  I want to know when
> the file was last modified.  I know I could use cfdirectory and loop
> over the directory contents and get it that way but that seems like WAY
> too much work just to get the date on one file.
> 
> How come you can't use cffile variables on anything but an upload?
> Wouldn't it be helpful on all cffile actions?  They should have a cffile
> action="readattribs" or something.
> 
> Is this too much to ask for? Or am I missing something. This is on cf5.
> I could probably use a java to pull the information on MX, but that
> isn't an option.
> 
> Thanks.
> 
> Kevin.
> 
> 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189830
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: How to get file information?

[Kazmierczak, Kevin]

I guess I could use cfdirectory with a filter, that would probably do
it.


-Original Message-
From: Kazmierczak, Kevin [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 10, 2005 2:17 PM
To: CF-Talk
Subject: How to get file information?

How would one get information on a file from CF?  I want to know when
the file was last modified.  I know I could use cfdirectory and loop
over the directory contents and get it that way but that seems like WAY
too much work just to get the date on one file.

 

How come you can't use cffile variables on anything but an upload?
Wouldn't it be helpful on all cffile actions?  They should have a cffile
action="readattribs" or something.

 

Is this too much to ask for? Or am I missing something. This is on cf5.
I could probably use a java to pull the information on MX, but that
isn't an option.

 

Thanks.

 

Kevin.





~|
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:189829
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

How to get file information?

[Kazmierczak, Kevin]

How would one get information on a file from CF?  I want to know when
the file was last modified.  I know I could use cfdirectory and loop
over the directory contents and get it that way but that seems like WAY
too much work just to get the date on one file.

 

How come you can't use cffile variables on anything but an upload?
Wouldn't it be helpful on all cffile actions?  They should have a cffile
action="readattribs" or something.

 

Is this too much to ask for? Or am I missing something. This is on cf5.
I could probably use a java to pull the information on MX, but that
isn't an option.

 

Thanks.

 

Kevin.



~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189828
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: Building a SQL WHERE clause

[daniel kessler]

>Have you tried something like this
>
>SELECT service_population,agency,city,state,salary_status
>  FROM internships
>  #preservesinglequotes( find_text )#
>  ORDER BY agency ASC

y!  That worked very well thank you Qasim.
And Al, that's a  pretty good idea.  I would've tried that next, but no need 
now.

Thanks everyone for the help.

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189827
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: Building a SQL WHERE clause

[Robert Bailey]

The '' does not help in your query, that are wrapped around your where
clause:

SELECT service_population,agency,city,state,salary_status FROM
internships WHERE service_population=''Children'' ORDER BY agency ASC


Not sure how you are passing them in the form, but you want it to read:

SELECT service_population,agency,city,state,salary_status FROM
internships WHERE service_population='Children' ORDER BY agency ASC




Robert Bailey
Software Engineer
813-230-9967 \\ mobile
[EMAIL PROTECTED]
www.recruitmax.com
 

-Original Message-
From: Daniel Kessler [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 10, 2005 1:10 PM
To: CF-Talk
Subject: Building a SQL WHERE clause

I'm doing my first Search utility:
http://hhp.umd.edu/studentservices/internships.cfm

I'm trying to build a WHERE clause in CF where it check to see if a 
form field is part of a search and if it is, then it builds into the 
WHERE string.  Unfortunatley when I do, I get the error, "SQL command 
doesn't end properly" after clicking Search.

Here's some of the code:




  <--- setup a search --->


   
   



   SELECT service_population,agency,city,state,salary_status
   FROM internships
   #find_text#
   ORDER BY agency ASC




  <--- setup some presets --->









Also, if someone can just point me to a tutorial on this, then that'd be
fine.
Really, any help would be appreciated.

-- 
Daniel Kessler

Department of Public and Community Health
University of Maryland
Suite 2387 Valley Drive
College Park, MD  20742-2611
301-405-2545 Phone
www.phi.umd.edu



~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189826
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: Building a SQL WHERE clause

[Qasim Rasheed]

Have you tried something like this

SELECT service_population,agency,city,state,salary_status
  FROM internships
  #preservesinglequotes( find_text )#
  ORDER BY agency ASC


On Mon, 10 Jan 2005 13:10:06 -0500, Daniel Kessler <[EMAIL PROTECTED]> wrote:
> I'm doing my first Search utility:
> http://hhp.umd.edu/studentservices/internships.cfm
> 
> I'm trying to build a WHERE clause in CF where it check to see if a
> form field is part of a search and if it is, then it builds into the
> WHERE string.  Unfortunatley when I do, I get the error, "SQL command
> doesn't end properly" after clicking Search.
> 
> Here's some of the code:
> 
>  structKeyExists(Form,"agency") OR structKeyExists(Form,"city") OR
> structKeyExists(Form,"state") OR
> structKeyExists(Form,"salary_status")>
> 
>
>  <--- setup a search --->
>
>
>   
>="#find_text#service_population='#Form.service_population#'">
>
> 
>
>   SELECT service_population,agency,city,state,salary_status
>   FROM internships
>   #find_text#
>   ORDER BY agency ASC
>
> 
>
> 
>  <--- setup some presets --->
>
>
>
>
>
> 
> 
> 
> Also, if someone can just point me to a tutorial on this, then that'd be fine.
> Really, any help would be appreciated.
> 
> --
> Daniel Kessler
> 
> Department of Public and Community Health
> University of Maryland
> Suite 2387 Valley Drive
> College Park, MD  20742-2611
> 301-405-2545 Phone
> www.phi.umd.edu
> 
> 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189825
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: Building a SQL WHERE clause

[Al Everett]

If form.service_population isn't defined, you have an empty WHERE
clause. That's probably the root of the issue. I suggest having
something in your WHERE clause that's always true but has no bearing
on the returned results, like "WHERE 0=0" then add the rest of your
dynamic clause.


On Mon, 10 Jan 2005 13:10:06 -0500, Daniel Kessler <[EMAIL PROTECTED]> wrote:
> I'm doing my first Search utility:
> http://hhp.umd.edu/studentservices/internships.cfm
> 
> I'm trying to build a WHERE clause in CF where it check to see if a
> form field is part of a search and if it is, then it builds into the
> WHERE string.  Unfortunatley when I do, I get the error, "SQL command
> doesn't end properly" after clicking Search.
> 
> Here's some of the code:
> 
>  structKeyExists(Form,"agency") OR structKeyExists(Form,"city") OR
> structKeyExists(Form,"state") OR
> structKeyExists(Form,"salary_status")>
> 
> 
>   <--- setup a search --->
> 
> 
>
> ="#find_text#service_population='#Form.service_population#'">
> 
> 
> 
>SELECT service_population,agency,city,state,salary_status
>FROM internships
>#find_text#
>ORDER BY agency ASC
> 
> 
> 
> 
>   <--- setup some presets --->
> 
> 
> 
> 
> 
> 
> 
> 
> Also, if someone can just point me to a tutorial on this, then that'd be fine.
> Really, any help would be appreciated.
> 
> --
> Daniel Kessler
> 
> Department of Public and Community Health
> University of Maryland
> Suite 2387 Valley Drive
> College Park, MD  20742-2611
> 301-405-2545 Phone
> www.phi.umd.edu
> 
> 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189824
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

Building a SQL WHERE clause

[Daniel Kessler]

I'm doing my first Search utility:
http://hhp.umd.edu/studentservices/internships.cfm

I'm trying to build a WHERE clause in CF where it check to see if a 
form field is part of a search and if it is, then it builds into the 
WHERE string.  Unfortunatley when I do, I get the error, "SQL command 
doesn't end properly" after clicking Search.

Here's some of the code:




  <--- setup a search --->


   
   



   SELECT service_population,agency,city,state,salary_status
   FROM internships
   #find_text#
   ORDER BY agency ASC




  <--- setup some presets --->









Also, if someone can just point me to a tutorial on this, then that'd be fine.
Really, any help would be appreciated.

-- 
Daniel Kessler

Department of Public and Community Health
University of Maryland
Suite 2387 Valley Drive
College Park, MD  20742-2611
301-405-2545 Phone
www.phi.umd.edu

~|
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:189823
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: John Dowdell Wants to Know What's Wrong with Macromedia

[Patrick McGeehan]

Speaking of SSL and RDS, is there anyway to present a certificate with RDS?
We have found no way tell studio to present a cert to https server.



Patrick McGeehan 
CFMX Advanced Certified
Applications Developer
DIT
#mcg#

 



-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 10, 2005 12:47 PM
To: CF-Talk
Subject: RE: John Dowdell Wants to Know What's Wrong with Macromedia


> RDS would be a lot more useful if it was thrown away and
> replaced with something that used open standards (WebDAV for 
> instance). RDS is far to insecure to leave running on anything 
> like a production system.

How exactly is WebDAV any more or less secure than RDS? Both can be
protected with SSL. Both let you manipulate the filesystem through HTTP
requests.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized 
instruction at our training centers in Washington DC, Atlanta, 
Chicago, Baltimore, Northern Virginia, or on-site at your location. 
Visit http://training.figleaf.com/ for more information!




~|
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:189822
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: uninstalling FP server extensions

[Calvin Ward]

If you aren't using FP there shouldn't be any issue.

- Calvin

-Original Message-
From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 10, 2005 12:56 PM
To: CF-Talk
Subject: uninstalling FP server extensions

If I use CFMX over IIS, is there any harm in uninstalling FrontPage 2002
server extensions? 

 
NOTICE: If received in error, please destroy and notify sender.  Sender does
not waive confidentiality or privilege, and use is prohibited. 
 




~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189821
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

uninstalling FP server extensions

[Katz, Dov B (IT)]

If I use CFMX over IIS, is there any harm in uninstalling FrontPage 2002
server extensions? 

 
NOTICE: If received in error, please destroy and notify sender.  Sender does 
not waive confidentiality or privilege, and use is prohibited. 
 


~|
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:189820
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: John Dowdell Wants to Know What's Wrong with Macromedia

[Calvin Ward]

I didn't think that RDS was for production systems?

-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 10, 2005 12:12 PM
To: CF-Talk
Subject: Re: John Dowdell Wants to Know What's Wrong with Macromedia

On Friday 07 Jan 2005 21:49 pm, Dave Watts wrote:
> RDS would be a lot more useful if it were something that could be used by
> other tools.

RDS would be a lot more useful if it was thrown away and replaced with 
something that used open standards (WebDAV for instance).
RDS is far to insecure to leave running on anything like a production
system.

-- 
Tom Chiverton 
Advanced ColdFusion Programmer
Tel: +44 (0)1749 834900
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834XXX
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, 
BRISTOL. BS1 6EG
*** This E-mail contains confidential information for the addressee only. If

you are not the intended recipient,
please notify us immediately. You should not use, disclose, distribute or
copy 
this communication if received
in error. No binding contract will result from this e-mail until such time
as 
a written document is signed on
behalf of the company. BlueFinger Limited cannot accept responsibility for
the 
completeness or accuracy of
this message as it has been transmitted over public networks.***



~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189819
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: John Dowdell Wants to Know What's Wrong with Macromedia

[Dave Watts]

> RDS would be a lot more useful if it was thrown away and 
> replaced with something that used open standards (WebDAV for 
> instance). RDS is far to insecure to leave running on anything 
> like a production system.

How exactly is WebDAV any more or less secure than RDS? Both can be
protected with SSL. Both let you manipulate the filesystem through HTTP
requests.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized 
instruction at our training centers in Washington DC, Atlanta, 
Chicago, Baltimore, Northern Virginia, or on-site at your location. 
Visit http://training.figleaf.com/ for more information!


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189818
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: Simple Content Management

[Adam Churvis]

If your application is built on the Plum Framework, you'd have the Plum CMS
available to you, and everything is free of charge:

http://www.productivityenhancement.com/plum/WhatPlumCanDo.cfm

This won't be an option if you're trying to integrate it into an existing
site that uses another framework, though.

If your team can all access the same LAN then you can use Macromedia's
RoboHelp, which is a *phenomenal* tool.  You can build and maintain an
entire library using RoboHelp, and some companies use it to build all the
information they make available on their intranet.

We use RoboHelp to create both the compiled .CHM help file in Plum and the
online version using the same source files.  Really slick.

A third suggestion would be Macromedia's Contribute, which is another
phenomenal tool.

Take a good look at all three.

Hope this helps.

Respectfully,

Adam Phillip Churvis
Member of Team Macromedia
http://www.ProductivityEnhancement.com

Download Plum and other cool development tools,
and get advanced intensive Master-level training:

* C# & ASP.NET for ColdFusion Developers
* ColdFusion MX Master Class
* Advanced Development with CFMX and SQL Server 2000

- Original Message - 
From: "Ben Rogers" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Friday, January 07, 2005 11:47 AM
Subject: SOT: Simple Content Management


> We need a tool to collect and organize information in order to build
> documentation for a project in a collaborative fashion.
>
> We've actually used blogs in the past to document the installation of
> software and such. A blog won't work in this case, however, as we need to
be
> able organize information in a hierarchical fashion, not chronological.
>
> Wiki's are interesting and would probably work technically speaking.
> However, I think it will be too difficult to teach everyone how to use a
> Wiki. Also, a Wiki is a little too free form. We need to define the
> structure and let people provide the content.
>
> Does such a tool exist? We don't really care whether or not it's written
in
> ColdFusion. It needs to run on Windows, however. I think we're looking for
> something Web based, but that's not a requirement (we have admin access to
> desktops and can install software).
>
> Ben Rogers
> http://www.c4.net
> v.508.240.0051
> f.508.240.0057
>
>
> 

~|
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:189817
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: Blocking Comment Spammers

[Jim McAtee]

http://www.w3.org/TR/turingtest/


- Original Message - 
From: "Stan Winchester" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Sunday, January 09, 2005 12:14 PM
Subject: Re: Blocking Comment Spammers


> That is a good point, but in most of our situations security is more 
> important than being 508 compliant. It would be nice if there was a way 
> to be both secure and compliant. Any suggestions would be appreciated.
>
>>Just a thought. But how would someone who is blind be able to get the 
>>code
>>from an image? Being a webmaster for a government webpage, we have to 
>>make
>>sure that we are section 508 complaint. I just don't see how you can 
>>include
>>something like this that a text reader would be able to read and still 
>>have
>>the security?
>
> 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189816
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: John Dowdell Wants to Know What's Wrong with Macromedia

[Thomas Chiverton]

On Friday 07 Jan 2005 21:49 pm, Dave Watts wrote:
> RDS would be a lot more useful if it were something that could be used by
> other tools.

RDS would be a lot more useful if it was thrown away and replaced with 
something that used open standards (WebDAV for instance).
RDS is far to insecure to leave running on anything like a production system.

-- 
Tom Chiverton 
Advanced ColdFusion Programmer
Tel: +44 (0)1749 834900
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834XXX
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, 
BRISTOL. BS1 6EG
*** This E-mail contains confidential information for the addressee only. If 
you are not the intended recipient,
please notify us immediately. You should not use, disclose, distribute or copy 
this communication if received
in error. No binding contract will result from this e-mail until such time as 
a written document is signed on
behalf of the company. BlueFinger Limited cannot accept responsibility for the 
completeness or accuracy of
this message as it has been transmitted over public networks.***

~|
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:189815
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

Running CFMX service with a login

[Howie Hamlin]

I have several cfmx servers running under Windows 2003 and IIS6.  These servers 
all access templates and files on the network.  Everything works (file reads, 
writes, etc) except for file deletions.  Currently, the web site in IIS is 
configured to access the share as a specific user.  I'm thinking that the CFMX 
services need to also be configured to log on as a user with access to the 
network shares so I configured this using the same login that IIS is using for 
the network access.  When I do this, however, the web pages come up blank.

Any ideas would be appreciated.

Thanks,

-- 
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc. - www.CoolFusion.com
inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server
PrismAV - Virus scanning for ColdFusion applications
>>> Find out how iMS Stacks up to the competition: 
>>> http://www.coolfusion.com/imssecomparison.cfm


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189814
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

OT: Problems w/printing in IE

[Robert Orlini]

Anyone out there having problems with printing in IE (6.0) or Outlook 2000? 
When I try to re-install IE from Microsoft it crashes. A Windows File 
Protection pop-up appears later. Also Norton has some Office files in 
Quarantine it can fix with the latest definitions.

Thanks.

Robert O.
HWW


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189813
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: General Security Discussion.

[Rebecca Wells]

>Why not just tell the browser not to cache the pages and alwasy
>checked that they are logged in... or am I missing something?

Well, duh! That's why I said that it works assuming you have set the rest of 
your security up right... like having a login-check function in the 
application.cfm page so they can hit the back button all they want to, but if 
they are logged out, they will only get to see the login page. :-p

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189812
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: Determining the location of a CFC

[Neil Middleton]

In fact, ignore me, it's not a webservice calling, it's another remote
CFC call from the same server.


On Mon, 10 Jan 2005 16:15:41 +, Neil Middleton
<[EMAIL PROTECTED]> wrote:
> I'm trying to write an application that is consumable by webservices,
> and for re-use, it doesn't know where on the server it might exist,
> only that the first folder inside the webroot is called "projects".
> 
> I am trying desperately to write some code that can tell me the
> component path for all the components within the application
> 
> e.g  projects.folder.folder.myApplication
> 
> Trouble is when I use code such as:
> 
> 
>  "", "ALL")>
>  FindNoCase("projects\", directory)),"\",".","ALL") & "." />
> 
> 
> I always end up with the path to calling application, which happens to
> also be a CFC.  Is there a way to do this?
> --
> Neil
> http://www.theservicefactory.com
> 
> Get Firefox - http://www.getfirefox.com
> 


-- 
Neil
http://www.joandneil.co.uk

Get Firefox - http://www.getfirefox.com

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189811
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

Determining the location of a CFC

[Neil Middleton]

I'm trying to write an application that is consumable by webservices,
and for re-use, it doesn't know where on the server it might exist,
only that the first folder inside the webroot is called "projects".

I am trying desperately to write some code that can tell me the
component path for all the components within the application

e.g  projects.folder.folder.myApplication

Trouble is when I use code such as:






I always end up with the path to calling application, which happens to
also be a CFC.  Is there a way to do this?
-- 
Neil
http://www.theservicefactory.com

Get Firefox - http://www.getfirefox.com

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189810
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: Possible to tell where a file went?

[Les Mizzell]

Micha Schopman wrote:
> Except Application.cfm, which needs to start with an uppercase A for
> Unix systems.


..and there's where 93% of my missing hair went!

-- 
Les Mizzell


~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189809
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: File Where DSNs are stored?

[Dave Watts]

> I am moving a CF instance from our old server to our new one. 
> Both are 6.1.
> 
> Is there a file that I can copy over that contains my DSNs, 
> or do I need to set them up separately through administrator?

If the servers are configured identically, you can copy neo-query.xml from
one to the other. In a default CFMX 6.1 installation, that'll be somewhere
within \cfusionmx\lib, I think.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized 
instruction at our training centers in Washington DC, Atlanta, 
Chicago, Baltimore, Northern Virginia, or on-site at your location. 
Visit http://training.figleaf.com/ for more information!


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189807
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: SQL Server on Windows XP

[Dave Watts]

> I remember some discussions of SQL Server (Server instance) 
> being installed on Windows XP for development purposes.  Is 
> this only available using SQL Server Developers Edition?

Yes, I believe so.

> If so, is that something that's included with an MSDN 
> subscription or anything like that or can you only get it by 
> purchasing at microsoft.com for $49.95?

If you have MSDN, it's in there along with Enterprise and Standard (on the
same CD, I think). Otherwise, you can purchase it separately.

> We have a site we need to demo on a military base and the 
> portion we're going to is locked down and we can't get internet 
> access to demo it from our server here so we're planning to 
> install everything we need on a laptop so we can show it from 
> there. Any advice that anyone can give would be greatly appreciated.

You might consider installing a server operating system on a laptop, if you
plan to do a lot of these sorts of demos. I've run Windows 2000 Server and
Windows Server 2003 for quite some time on laptops.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized 
instruction at our training centers in Washington DC, Atlanta, 
Chicago, Baltimore, Northern Virginia, or on-site at your location. 
Visit http://training.figleaf.com/ for more information!


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189808
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: SQL Server on Windows XP

[Stephen Moretti]

Burns, John D wrote:

>I remember some discussions of SQL Server (Server instance) being
>installed on Windows XP for development purposes.  Is this only
>available using SQL Server Developers Edition?  If so, is that something
>that's included with an MSDN subscription or anything like that or can
>you only get it by purchasing at microsoft.com for $49.95?  We have a
>site we need to demo on a military base and the portion we're going to
>is locked down and we can't get internet access to demo it from our
>server here so we're planning to install everything we need on a laptop
>so we can show it from there.  Any advice that anyone can give would be
>greatly appreciated
>  
>

Never looked at it myself, but this came past me the other day :

MS SQL Server 2005 Express Edition : 
http://lab.msdn.microsoft.com/express/sql/

Might be what you're after.

Stephen


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189806
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: File Where DSNs are stored?

[Andrew Dixon]

They are stored in the neo-query.xml file in the lib directory in the
CF root. You can copy it over if none of the settings need changing.

Andrew.


On Mon, 10 Jan 2005 10:14:03 -0500, Claremont, Timothy
<[EMAIL PROTECTED]> wrote:
> I am moving a CF instance from our old server to our new one. Both are
> 6.1.
> 
> Is there a file that I can copy over that contains my DSNs, or do I need
> to set them up separately through administrator?
> 
> TIA,
> Tim
> **
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please delete it from 
> your system.
> 
> This footnote also confirms that this email message has been swept for
> the presence of computer viruses.
> 
> Thank You,
> Viahealth
> **
> 
> 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189805
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

File Where DSNs are stored?

[Claremont, Timothy]

I am moving a CF instance from our old server to our new one. Both are
6.1.

Is there a file that I can copy over that contains my DSNs, or do I need
to set them up separately through administrator?

TIA,
Tim
**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please delete it from 
your system.

This footnote also confirms that this email message has been swept for
the presence of computer viruses.

Thank You,
Viahealth
**


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189804
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: SQL Server on Windows XP

[Burns, John D]

Great! That's just what I was looking for.  Thanks! 


John Burns
Certified Advanced ColdFusion MX Developer
AI-ES Aeronautics, Web Developer

-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED] 
Sent: Monday, January 10, 2005 10:00 AM
To: CF-Talk
Subject: RE: SQL Server on Windows XP

Just go download
http://www.microsoft.com/sql/msde/downloads/download.asp

All you need for dev etc



-Original Message-
From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent: 10 January 2005 14:54
To: CF-Talk
Subject: SQL Server on Windows XP

I remember some discussions of SQL Server (Server instance) being
installed on Windows XP for development purposes.  Is this only
available using SQL Server Developers Edition?  If so, is that something
that's included with an MSDN subscription or anything like that or can
you only get it by purchasing at microsoft.com for $49.95?  We have a
site we need to demo on a military base and the portion we're going to
is locked down and we can't get internet access to demo it from our
server here so we're planning to install everything we need on a laptop
so we can show it from there.  Any advice that anyone can give would be
greatly appreciated.
 
John Burns
Certified Advanced ColdFusion MX Developer AI-ES Aeronautics, Web
Developer
 






~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189803
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: SQL Server on Windows XP

[Robertson-Ravo, Neil (RX)]

Just go download http://www.microsoft.com/sql/msde/downloads/download.asp

All you need for dev etc



-Original Message-
From: Burns, John D [mailto:[EMAIL PROTECTED] 
Sent: 10 January 2005 14:54
To: CF-Talk
Subject: SQL Server on Windows XP

I remember some discussions of SQL Server (Server instance) being
installed on Windows XP for development purposes.  Is this only
available using SQL Server Developers Edition?  If so, is that something
that's included with an MSDN subscription or anything like that or can
you only get it by purchasing at microsoft.com for $49.95?  We have a
site we need to demo on a military base and the portion we're going to
is locked down and we can't get internet access to demo it from our
server here so we're planning to install everything we need on a laptop
so we can show it from there.  Any advice that anyone can give would be
greatly appreciated.
 
John Burns
Certified Advanced ColdFusion MX Developer
AI-ES Aeronautics, Web Developer
 




~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189802
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

SQL Server on Windows XP

[Burns, John D]

I remember some discussions of SQL Server (Server instance) being
installed on Windows XP for development purposes.  Is this only
available using SQL Server Developers Edition?  If so, is that something
that's included with an MSDN subscription or anything like that or can
you only get it by purchasing at microsoft.com for $49.95?  We have a
site we need to demo on a military base and the portion we're going to
is locked down and we can't get internet access to demo it from our
server here so we're planning to install everything we need on a laptop
so we can show it from there.  Any advice that anyone can give would be
greatly appreciated.
 
John Burns
Certified Advanced ColdFusion MX Developer
AI-ES Aeronautics, Web Developer
 


~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189801
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: Submitting a Form through email

[Micha Schopman]

This is prohibited due to security. Email clients block this. What you
can do is provide the client a link, which needs to be clicked to renew
their account.

Keep in mind to hash/encrypt the id of the client. I wouldn't like it if
someone could change the id in the address bar to renew my account.

Micha Schopman
Software Engineer

Modern Media, Databankweg 12 M, 3821 AL  Amersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380



~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189800
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: Simple Content Management

[RADEMAKERS Tanguy]

www.opensourcecms.com maintains a bunch of default installs of various
solutions you can play with - mostly php/mysql.

/t

>-Original Message-
>From: Ben Rogers [mailto:[EMAIL PROTECTED] 
>Sent: Friday, January 07, 2005 5:47 PM
>To: CF-Talk
>Subject: SOT: Simple Content Management
>
>We need a tool to collect and organize information in order to build
>documentation for a project in a collaborative fashion.
>
>We've actually used blogs in the past to document the installation of
>software and such. A blog won't work in this case, however, as 
>we need to be
>able organize information in a hierarchical fashion, not chronological.
>
>Wiki's are interesting and would probably work technically speaking.
>However, I think it will be too difficult to teach everyone 
>how to use a
>Wiki. Also, a Wiki is a little too free form. We need to define the
>structure and let people provide the content.
>
>Does such a tool exist? We don't really care whether or not 
>it's written in
>ColdFusion. It needs to run on Windows, however. I think we're 
>looking for
>something Web based, but that's not a requirement (we have 
>admin access to
>desktops and can install software).
>
>Ben Rogers
>http://www.c4.net
>v.508.240.0051
>f.508.240.0057
>
>
>

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189799
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: Submitting a Form through email

[Robert Bailey]

Try using the method get and see if that works. My understanding is that
most, if not all, email clients will block form posts from an email. 


 Robert Bailey
Software Engineer
813-230-9967 \\ mobile
[EMAIL PROTECTED]
www.recruitmax.com
 
-Original Message-
From: Chad McCue [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 10, 2005 8:41 AM
To: CF-Talk
Subject: Re: Submitting a Form through email


  
  
   

 
  This email is to let you know that your account on has been
inactive
for 90 days.
  
  Please take a few seconds to answer the following questions.
 

   
    
   

 
  
   

 1. Would you like to re-register for another 90-days?

   
   
   
Yes
  
No
   
  
 

   
    
   

 

   
  
  
- Original Message - 
From: "Mark Drew" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Monday, January 10, 2005 8:37 AM
Subject: Re: Submitting a Form through email


> What is the code in the html?
>
> MD
>
>
> On Mon, 10 Jan 2005 08:14:17 -0500, Chad McCue
> <[EMAIL PROTECTED]> wrote:
> > I have an email being sent out to expired accounts that is a small
form
to see if they would like to renew their account. The form that is in
the
email contains two questions and a hidden field carrying their acctID. I
am
having a problem submitting these fields, when the account receives the
email and answers the question and clicks the "Submit" button they land
on
the correct page but my form variables are undefined. Any ideas?
> >
> >
>
> 



~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189798
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: Submitting a Form through email

[Michael Traher]

Can not see an obvious problem. I would change the target page to new
one called test.cfm that only contains the code 
and see if that works.  If it does then you need to start delving into
the code that runs between index.cfm and your 'reply90day' fuse code.

Since this is fusebox the variables should also be in the attributes scope.

HTH


On Mon, 10 Jan 2005 08:14:17 -0500, Chad McCue
<[EMAIL PROTECTED]> wrote:
> I have an email being sent out to expired accounts that is a small form to 
> see if they would like to renew their account. The form that is in the email 
> contains two questions and a hidden field carrying their acctID. I am having 
> a problem submitting these fields, when the account receives the email and 
> answers the question and clicks the "Submit" button they land on the correct 
> page but my form variables are undefined. Any ideas?
> 
> 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189797
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: Submitting a Form through email

[Chad McCue]

  
  
   

 
  This email is to let you know that your account on has been inactive
for 90 days.
  
  Please take a few seconds to answer the following questions.
 

   
    
   

 
  
   

 1. Would you like to re-register for another 90-days?

   
   
   
Yes
  
No
   
  
 

   
    
   

 

   
  
  
- Original Message - 
From: "Mark Drew" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Monday, January 10, 2005 8:37 AM
Subject: Re: Submitting a Form through email


> What is the code in the html?
>
> MD
>
>
> On Mon, 10 Jan 2005 08:14:17 -0500, Chad McCue
> <[EMAIL PROTECTED]> wrote:
> > I have an email being sent out to expired accounts that is a small form
to see if they would like to renew their account. The form that is in the
email contains two questions and a hidden field carrying their acctID. I am
having a problem submitting these fields, when the account receives the
email and answers the question and clicks the "Submit" button they land on
the correct page but my form variables are undefined. Any ideas?
> >
> >
>
> 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189796
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: Submitting a Form through email

[Mark Drew]

What is the code in the html?

MD


On Mon, 10 Jan 2005 08:14:17 -0500, Chad McCue
<[EMAIL PROTECTED]> wrote:
> I have an email being sent out to expired accounts that is a small form to 
> see if they would like to renew their account. The form that is in the email 
> contains two questions and a hidden field carrying their acctID. I am having 
> a problem submitting these fields, when the account receives the email and 
> answers the question and clicks the "Submit" button they land on the correct 
> page but my form variables are undefined. Any ideas?
> 
> 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189795
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

Submitting a Form through email

[Chad McCue]

I have an email being sent out to expired accounts that is a small form to see 
if they would like to renew their account. The form that is in the email 
contains two questions and a hidden field carrying their acctID. I am having a 
problem submitting these fields, when the account receives the email and 
answers the question and clicks the "Submit" button they land on the correct 
page but my form variables are undefined. Any ideas?



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189794
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: search engine friendly urls

[Doug Hughes]

Here's a tutorial I wrote:

http://www.doughughes.net/index.cfm/page-blogLink/entryId-45

And here's a gotcha if you use jrun:

http://www.doughughes.net/index.cfm/page-blogLink/entryId-37


On Mon, 10 Jan 2005 06:28:36 -0400, Jack Dalaa <[EMAIL PROTECTED]> wrote:
> If you're on IIS, I highly recommend downloading ISAPI Rewrite 
> (www.isapirewrite.com), then use the following rules in httpd.ini:
> 
> [ISAPI_Rewrite]
> RepeatLimit 20
> 
> # Defend your computer from some worm attacks
> RewriteRule (/dyn/.*?)(\?[^/]*)?/([^/]*)/([^/]*)(.+?)? $1(?2$2&:\?)$3=$4?5$5: 
> [N,I]
> RewriteRule /dyn(.+?)/?(\?.*)? $1.cfm$2 [I]
> 
> .. You can change the 'dyn' to whatever you want, but that would enable URL's 
> like:
> 
> http://www.abc.com/dyn/info/articleid/34
> 
> http://www.abc.com/info.cfm?articleid=34
> 
> All URL's without the /dyn/ (or whatever you decide) will be processed 
> normally.
> 
> With a bit of foresight in naming your pages and variables, you can 
> accomplish fancy URL's like:
> 
> http://www.abc.com/dyn/view/product/shoes
> 
> Have fun!
> 
> Jack
> 
> >Can anyone point me in the direction of a tag or tutorial on how to
> >convert a url and all its bits into a Search engine firendly one? i.e.
> >uses all \ rather than the standard ? and = and &
> >
> >Specifically for CF 4.5 right now, but also for MX later.
> >
> >And is it really worth doing? Will it make it easier to get our sites
> >into engines other than google?
> >
> >What are the arguments against doing it?
> >
> >Thanks
> >
> >Duncan
> 
> 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189793
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: search engine friendly urls

[Jack Dalaa]

If you're on IIS, I highly recommend downloading ISAPI Rewrite 
(www.isapirewrite.com), then use the following rules in httpd.ini:


[ISAPI_Rewrite]
RepeatLimit 20

# Defend your computer from some worm attacks
RewriteRule (/dyn/.*?)(\?[^/]*)?/([^/]*)/([^/]*)(.+?)? $1(?2$2&:\?)$3=$4?5$5: 
[N,I]
RewriteRule /dyn(.+?)/?(\?.*)? $1.cfm$2 [I]


.. You can change the 'dyn' to whatever you want, but that would enable URL's 
like:

http://www.abc.com/dyn/info/articleid/34

http://www.abc.com/info.cfm?articleid=34

All URL's without the /dyn/ (or whatever you decide) will be processed normally.

With a bit of foresight in naming your pages and variables, you can accomplish 
fancy URL's like:

http://www.abc.com/dyn/view/product/shoes

Have fun!


Jack 

>Can anyone point me in the direction of a tag or tutorial on how to
>convert a url and all its bits into a Search engine firendly one? i.e.
>uses all \ rather than the standard ? and = and &
>
>Specifically for CF 4.5 right now, but also for MX later.
>
>And is it really worth doing? Will it make it easier to get our sites
>into engines other than google?
>
>What are the arguments against doing it?
>
>Thanks
>
>Duncan

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189792
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: search engine friendly urls

[Bert Dawson]

SESconverter from http://www.fusium.com/index.cfm?fuseaction=ses.intro
should do the trick.

Cheers
Bert

(ps FYI, when fusebox 3 was released the SES stuff from
formURL2attributes.cfm was tweaked and repackaged as SESconverter.cfm)


On Mon, 10 Jan 2005 17:07:41 +1100, Duncan I Loxton
<[EMAIL PROTECTED]> wrote:
> Can anyone point me in the direction of a tag or tutorial on how to
> convert a url and all its bits into a Search engine firendly one? i.e.
> uses all \ rather than the standard ? and = and &
> 
> Specifically for CF 4.5 right now, but also for MX later.
> 
> And is it really worth doing? Will it make it easier to get our sites
> into engines other than google?
> 
> What are the arguments against doing it?
> 
> Thanks
> 
> Duncan
> 
> 

~|
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:189791
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Possible to tell where a file went?

[Martin Parry]

As far as I'm concerned OnRequestEnd.cfm also needs to be correctly
cased - Thanks Micha, I forgot to mention that.

Martin Parry
Macromedia Certified Developer
http://www.BeetrootStreet.co.uk


-Original Message-
From: Micha Schopman [mailto:[EMAIL PROTECTED] 
Sent: 10 January 2005 10:49
To: CF-Talk
Subject: RE: Possible to tell where a file went?

Except Application.cfm, which needs to start with an uppercase A for
Unix systems.


~|
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:189790
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: search engine friendly urls

[Duncan I Loxton]

Thanks everyone - thats fantastic.


On Sun, 09 Jan 2005 22:23:12 -0800, Tim Davis <[EMAIL PROTECTED]> wrote:
> Duncan,
> http://tutorial90.easycfm.com/
> 
> Duncan I Loxton wrote:
> 
> >Can anyone point me in the direction of a tag or tutorial on how to
> >convert a url and all its bits into a Search engine firendly one? i.e.
> >uses all \ rather than the standard ? and = and &
> >
> >Specifically for CF 4.5 right now, but also for MX later.
> >
> >And is it really worth doing? Will it make it easier to get our sites
> >into engines other than google?
> >
> >What are the arguments against doing it?
> >
> >Thanks
> >
> >Duncan
> >
> >
> 
> 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189789
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: Possible to tell where a file went?

[Micha Schopman]

Except Application.cfm, which needs to start with an uppercase A for
Unix systems.

Micha Schopman
Software Engineer

Modern Media, Databankweg 12 M, 3821 AL  Amersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189788
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: General Security Discussion.

[RADEMAKERS Tanguy]

I usually add a snippet like this:



to all the pages in an application which should not be accessible from
the back button - like form screens in a wizard process. It's very much
a quick and dirty solution, but it does work.

/t 

>-Original Message-
>From: Chris Jensen [mailto:[EMAIL PROTECTED] 
>Sent: Sunday, January 09, 2005 11:15 PM
>To: CF-Talk
>Subject: Re: General Security Discussion.
>
>> Plus:
>> After you log a user out of an site, in the application.cfm 
>file clear their CFID, CFTOKEN, JSESSIONID, and session, then 
>do a cflocate to the index page of the site and that *should* 
>prevent the back-button from letting anyone view secure pages 
>(if you have everything else setup right).
>
>I don't think this won't completely eliminate the back 
>problem. In most 
>browsers, the user can click on an arrow or something on the 
>back button 
>to get a history and jump back to any page in the history.
>You can also sometimes get around this by just hitting back twice 
>quickly in succession.
>
>The best way around this is to close the browser window, if it's 
>intranet you could try just making it policy that uisers close after 
>logging out, or if that doesn't take off, use java script to forcibly 
>close the window. (This seems to be how most internet banking 
>sites deal 
>with the issue)
>
>Though even this won't completely solve problems, as some 
>browsers will 
>get the user to confirm the close command, or even ignore it 
>completely.
>
>-- 
>
>
>

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189787
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: General Security Discussion.

[James Smith]

> The best way around this is to close the browser window, if 
> it's intranet you could try just making it policy that uisers 
> close after logging out, or if that doesn't take off, use 
> java script to forcibly close the window. (This seems to be 
> how most internet banking sites deal with the issue)
> 
> Though even this won't completely solve problems, as some 
> browsers will get the user to confirm the close command, or 
> even ignore it completely.

You can solve one of the problems *fairly* easily.  The JS confirmation that
pops up asking if you want to allow the window to be closed is not displayed
if the window was opened with JS in the first place.  If after login you
open a new window with some JS (and redirect the origional window to a
thanks for coming type page) then when they log out the new window can be
closed with JS with no prompts and no danger of the back button being used
leaving the original window now displaying its thanks for being here
message.

You will also need to use a pragma:no-cache type header element so that they
can't be smart and look it up in the web browsers cache files. (see
http://support.microsoft.com/kb/165150/EN-US/ or
http://lab.artlung.com/other/anti-cache/)

--
Jay



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189786
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