Cold Fusion MX and Websphere

[Dobris, Eric]

If anyone is using this combination, Cold Fusion MX and Websphere, what
operating system do you recommend for best performance, windows 2000 or
windows 2003?

Thanks,

Eric 

~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187735
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: Redirect to page based on URL...

[Dobris, Eric]

You can do it simply:













Eric 

  _  

From: Les Mizzell [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 02, 2004 11:08 AM
To: CF-Talk
Subject: Redirect to page based on URL...

I have a client the currently has two domain names pointing to the same 
site.  They've now asked me to redirect one of the names to a specific 
file down inside the site.

I'm pretty sure this is something that I can do with cfhttp or one of 
the related tags, but I'm not exactly sure how to pull this off..

www.name1.com would go to "www.mysite.com/index.cfm" page as normal
www.name2.com would redirect to "www.mysite.com/somefolder/somefile.cfm"

Pointers?

Thanks in advance.

-- 
Les Mizzell
---
Do geeks die when exposed to sunlight?
---

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Trying to group dates in dropdown list

[Dobris, Eric]

Can't you just use the datepart?

Select Distinct datepart(datecolumn,) as year from table

  _  

From: Barney Boisvert [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 26, 2004 4:28 PM
To: CF-Talk
Subject: RE: Trying to group dates in dropdown list

The MySQL JDBC driver will return a byte array in certain situations where
you might expect to get a string.  Most of CFMX knows how to transparently
convert it to a string for use, but there are certain places it doesn't work
(such as QofQs).  The solution is to use the CF built-in function
toString(), which will force the conversion.

Cheers,
barneyb

> -Original Message-
> From: Ron Eis [mailto:[EMAIL PROTECTED] 
> Sent: Thursday, February 26, 2004 1:15 PM
> To: CF-Talk
> Subject: RE: Trying to group dates in dropdown list
> 
> Still having problems.  I can get the YEAR-MONTH to return and display
> properly in the dropdown list in the proper format using LEFT 
> or MID but
> the query returns all entries in the database.
> 
> I need the display to be group by YEAR then MONTH in the 
> dropdown list. 
> 
> Whenever I add DISTINCT or a GROUP by to the query, I get the error
> "ByteArray objects cannot be converted to strings." 
> 
> I've checked the documentation and came up with nothing.  Has DISTINCT
> gone extinct in MX?
> 
> -Original Message-
> From: Donnie Bachan [mailto:[EMAIL PROTECTED] 
> Sent: Monday, February 16, 2004 11:05 PM
> To: CF-Talk
> Subject: RE: Trying to group dates in dropdown list
> 
> 
> I ran across this problem using MySQL and CFMX 6.1 and dates, I have
> been 
> too lazy to figure out the root of the problem but I used the 
> MySQL date
> 
> format functions to format the date before returning it to ColdFusion
> and 
> that solved the problem. If the Month and Year are stored as 
> part of a 
> date/time type use the date format function and return the 
> part that you
> 
> want.
> 
> HTH
> 
> ==
> 
> Similar to a recent post but still can't get it to work. 
> 
> Using CF MX 6.1, MySQL 3.23.44-nt, phpMyAdmin 2.4.0.  
> 
> I'm trying to group entries by month, to display MONTH YEAR in a drop
> down list.  
> 
> Current month/year is the default display. 
> 
> User has the option to select a previous month/year which will display
> the entries submitted during that time period.  
> 
> When using CF 5, used [[SELECT DISTINCT LEFT(dataDateReported,7) AS
> dropDownMenu]] AND [[
> query="buildDropDown" value="dropDownMenu"
> display="dropDownMenu">]] but get the following 
> error message
> using 6.1: "ByteArray objects cannot be converted to strings."  
> 
> Can anyone help?  Please let me know if additional information is
> needed.  Thanks in advance!
> 
> 
>  
> 
>

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Crud...I thought I had it down...[cflogin]

[Dobris, Eric]

Set it as session.loggedIN  Once you change the page you are no longer
executing the query, which means you are not setting the variables again.
That's why they never exist.

Eric 


-Original Message-
From: Jeff [mailto:[EMAIL PROTECTED] 
Sent: Friday, March 21, 2003 11:01 AM
To: CF-Talk
Subject: Crud...I thought I had it down...[cflogin]
Importance: Low


In my application.cfm file, I have the following: 







SELECT *
FROM ClientLogin
WHERE (Username = '#FORM.ClientLoginUsername#') AND (Password =
'#FORM.ClientLoginPassword#')






I'm sorry, the username and/or password you entered were
incorrect, please try again.







Then, on the login process page, I check for "Variables.LoggedIn" and I get
an error every time that it's not defined. But I'd THINK it'd be defined by
that logic, which is included in the application.cfm file...*sigh*...


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Another Challenging question

[Dobris, Eric]

 
SELECT * FROM Login 
WHERE Usr_Name = '#form.Usr_Name#' 
AND Usr_Password = '#form.Usr_Password#' 
 

 
 
 
 
 
 
 
 

If you get a greater then 1 recordcount, there is something wrong.  You need
to make sure you do not have duplicates, especially in the password table.


Eric


-Original Message-
From: Sangeeta Karmokar [mailto:[EMAIL PROTECTED] 
Sent: Friday, March 21, 2003 2:12 AM
To: CF-Talk
Subject: Another Challenging question
Importance: Low


I am not sure how to add a new thread. So I am posting this message here.. 
I am a new user of CFMX and I am creating Login and Password page with
Access as Database. CAn anyone check as this CF script is ok: 

 
SELECT * FROM Login 
WHERE Usr_Name = #form.Usr_Name# 
AND Usr_Password = #form.Usr_Password# 
 

 
 
 
 
 
 
 

Where Users is my datasource and Urs_Name and Urs_Password is my field
names. 

Please can anyone help me. 

Sangeeta
 
 


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Clearing Cached Pages

[Dobris, Eric]

Hi Dave,

Try This:





Eric

 


-Original Message-
From: Dave Sueltenfuss [mailto:[EMAIL PROTECTED] 
Sent: Monday, March 17, 2003 11:15 AM
To: CF-Talk
Subject: Clearing Cached Pages
Importance: Low


Good Morning,

I encountered a problem on Friday where a user continued to see an old page,
even after I had updated it. I realize this has to due with the users cache,
but am wondering if anyone knows of a way/command to clear the cache or
prevent a site from caching. 
Any help is appreciated

Thanks
 
Dave Sueltenfuss
Application Developer
Arch Wireless
Phone: 508-870-6711
Fax: 508-870-8011
Email: [EMAIL PROTECTED]  



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: New Macromedia.com launched!

[Dobris, Eric]

Tried to use opera 7 and it just keeps reloading the main page.



-Original Message-
From: jon hall [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, March 05, 2003 11:17 AM
To: CF-Talk
Subject: Re: New Macromedia.com launched!


Wednesday, March 5, 2003, 11:02:27 AM, you wrote:
CC> We know there are still some rough edges, and we will get them 
CC> worked out.  Just keep in mind that this project was a massive 
CC> effort, so it will take a little time to get all the kinks worked 
CC> out.

This would be the crux of the matter to me.
While I have issues with the site, I'd like anyone who has ever had an
absolutely perfect web site rollout the scale of the new macromedia.com, to
please raise their hand...

Didn't think so :)

-- 
 jon
 mailto:[EMAIL PROTECTED]


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: string parsing or list traversal

[Dobris, Eric]

I think this is exactly what you are looking for:

http://www.sqlteam.com/item.asp?ItemID=256


Eric Dobris


-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, January 22, 2003 2:52 PM
To: CF-Talk
Subject: string parsing or list traversal


Does anyone know how to traverse a list of prse a string in T-SQL inside a
stored procedure? What I need to do i send a comma delimited list into a
stored proc then loop over the list inserting each entry into a table.
 
Any help would be appreciated.
 
Thanks,
 
Michael T. Tangorre
 

MillenniuM Information Systems
1101 Wilson Blvd. Suite 1200
Arlington, Virginia 22209
 
O: 703-341-1438
C: 607-426-9277

Golden Rule: 
"He who has the gold, makes the rules!"
 


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: building date list

[Dobris, Eric]

Give this a shot,


Select DATEPART(,MAX(DateTimeIn)) AS MAXYEAR,
DATEPART(mm,MAX(DateTimeIn)) AS MAXMONTH,
DATEPART(d,MAX(DateTimeIn)) AS MAXDAY,
DATEPART(,MIN(DateTimeIn)) AS MINYEAR,
DATEPART(mm,MIN(DateTimeIn)) AS MAXMONTH,
DATEPART(d,MIN(DateTimeIn)) AS MAXDAY
 FROM dbo.table



-Original Message-
From: Owens, Howard [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, January 15, 2003 12:14 PM
To: CF-Talk
Subject: building date list


I have a query that returns all of the publication dates of stories in a
database.  Currently, it returns 18,000 rows.  Eventually, there will be
100,000 stories in the database.  Returning a query with that many records
and manipulating the dates (what I was thinking of doing) seems incrediblly
inefficient.

I would like to extract in a query the following information ...

first year of published stories
first month of that first year
first day of that first month of that first year

last year of published stories
last month of that last year
last day of that last month of that last year

I tried doing something like

SELECT Max(year(pub_date) as last_year
FROM table

That didn't give me the results I expected.

This is in MS SQL and I'm running the query as a stored procedure.

Suggestions?

Also, any good Web sites for programming transact-SQL?  Especially something
that, given my present need, will cover date manipulation.  I've searched
and haven't been able to find.

H.



~~
Howard Owens
Internet Operations Coordinator
InsideVC.com/Ventura County Star
[EMAIL PROTECTED]
AIM: GoCatGo1956 ~~


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Random Iterations -

[Dobris, Eric]

Yes, 
I just need to be able to generate them and choose 40 random combinations.
I don't need to actually buld a table with 
1,307,674,368,000 rows.

Eric
-Original Message-
From: webguy [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 18, 2002 12:37 PM
To: CF-Talk
Subject: RE: Random Iterations -


BTW you know there are

1,307,674,368,000

different non-ordered sets

WG

> -Original Message-
> From: webguy [mailto:[EMAIL PROTECTED]]
> Sent: 18 December 2002 17:15
> To: CF-Talk
> Subject: RE: Random Iterations
>
>
> That requires a pretty intense algorithm, you going to be doing this 
> often? I'd recommend doing this in C or Java... What platform?
>
> If it's the same 15 numbers just do it once !
>
> WG
>
> > -Original Message-
> > From: Dobris, Eric [mailto:[EMAIL PROTECTED]]
> > Sent: 18 December 2002 16:45
> > To: CF-Talk
> > Subject: Random Iterations
> >
> >
> > Hi Everyone,
> >
> > I have a problem I can't figure out and I am hoping someone on the 
> > list can help me figure out how to do it.
> >
> > I need to generate iteration tables.
> >
> > For Example:
> >
> > For a 3 digit iteration:
> >
> > All The possible combinations for these 3 digits; 1 2 3
> >
> > I would end up with:
> >
> > 1   1,2,3
> > 2   1,3,2
> > 3   2,1,3
> > 4   3,2,1
> > 5   2,3,1
> > 6   3,1,2
> >
> >
> >
> > I need to auto generate tables with up to 15 digits.
> >
> > Can anyone figure out the code to do this?
> >
> > Any help would be appreciated.
> >
> > Thanks,
> >
> > Eric Dobris
> >
> 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Random Iterations

[Dobris, Eric]

Hi Everyone,

I have a problem I can't figure out and I am hoping someone on the list can
help me figure out how to do it.

I need to generate iteration tables.

For Example:

For a 3 digit iteration:

All The possible combinations for these 3 digits; 1 2 3

I would end up with:

1   1,2,3
2   1,3,2
3   2,1,3
4   3,2,1
5   2,3,1
6   3,1,2



I need to auto generate tables with up to 15 digits.

Can anyone figure out the code to do this?

Any help would be appreciated. 

Thanks,

Eric Dobris
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

RE: Counting Matching Records

[Dobris, Eric]

You can try:

SELECT COUNT(employees) AS TotalEmployees
FROM   Employeestable
WHERE (employees IN(SELECT branchemployees FROM branches))


-=Swooosh

-Original Message-
From: charlie griefer [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, December 17, 2002 4:10 PM
To: CF-Talk
Subject: Re: Counting Matching Records


Les Mizzell writes: 

> I've got two tables
> 
> A. Branches
> B. Employees
> 
> I need to loop through the "Branches" table, and count the number of 
> matching employees from the employees table..
> 
> Branch A
>13 employees
> Branch B
>14 employees
> 
> RecordCount won't work here, will it?  What's the best way to do this?
>

Assuming there's a relationship between the two tables (employeeID (?)), you

can just do an inner join: 

SELECT *
FROM BranchA INNER JOIN BranchB ON BranchA.employeeID = BranchB.employeeID; 

then you can do a recordCount :) 

hth,
charlie

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

RE: update form

[Dobris, Eric]

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, December 17, 2002 8:33 AM
To: CF-Talk
Subject: Re: update form



You have 35 columns and only 32 values to insert.  They need to contain the
same amount of values.  Also it's 
cfquery not cfguery.

-=Swooosh

Quoting Dave Lyons <[EMAIL PROTECTED]>:
> 
> the MM update behavior was throwing a ton of errors so i wrote one out 
> but its not working.

Define "not working".


> 
> UPDATE user (firstName, lastName, username, password, email, city, 
> state, country, zip, sex, sexPref, BDmonth, BDDay, BDYear, height, 
> weight, bodyType, eyes, skinTone,hair, race, kids, wantkids, job, 
> hobbies, headline, maritualStatus, smoking, drinking, religion, 
> education, seeking, aboutME , aboutYOU , activated) VALUES
> ('#FORM.firstName#', '#FORM.lastName#', '#FORM.username#',
> '#FORM.password#', '#FORM.email#', '#FORM.city#', '#FORM.state#',
> '#FORM.country#', '#FORM.zip#', '#FORM.sex#', '#FORM.sexpref#',
> '#FORM.BDmonth#', '#FORM.BDDay#', '#FORM.BDYear#', '#FORM.height#',
> '#FORM.weight#', '#FORM.bodyType#', '#FORM.eyes#',
> '#FORM.skinTone#',
> '#FORM.hair#', '#FORM.race#', '#FORM.kids#', '#FORM.wantKids#',
> '#FORM.job#', '#FORM.hobbies#', '#FORM.headline#',
> '#FORM.maritualStatus#', '#FORM.smoking#', '#FORM.drinking#',
> '#FORM.religion#','#FORM.education#','#FORM.seeking#') 
> 

user is a reserved word in SQL, escape it or change it. For the rest, we
need to know the schema.

Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com